APIs With User Hooks
In Release 11, Oracle HRMS has supplemented the core product API functionality by the addition of API user hooks. These are locations in the HRMS APIs where additional customer specific logic can be executed.
When the API processing reaches a user hook, core product processing stops and any customer specific logic for that event is executed. Then, if no errors occur, the main API processing resumes.
You can use such extra logic to add functionality not supplied directly by Oracle Applications. This could include business events such as the following:
- validating particular customer data: For example, you could limit grade step promotions to a maximum of one step.
- maintaining additional data in your own user defined tables: This could include specialised information about employees not held in database tables supplied by Oracle HRMS.
- detecting that a particular business event has occurred: If the event was an employee termination process, for example, this could be made to send a message to your security database disabling the employee's security pass.
Attention: You should not manually edit the API source code files supplied by Oracle If you do modify these codes, Oracle Applications will be unable to support the product, and upgrades may not be possible. Oracle Applications only supports direct calls to the published APIs. Direct calls to any other server-side package procedures or functions that are written as part of the Oracle HRMS Applications suite are not supported.
List of APIs
The following APIs support all the API event points (before process; after process) :
create_contact_relationship
delete_contact_relationship
actual_termination_emp_asg
employee assignment criteria
create_personal_payment_method
update_personal_payment_method
create_position_requirement
secondary applicant assignment
secondary employee assignment
Row Handlers
The Row Handlers on the following tables support all the Row Handler event points (after insert; after update; after delete) :
PAY_PERSONAL_PAYMENT_METHODS_F
PER_CONTACT_RELATIONSHIPS