Steps For Creating User Hook

Steps For Creating User Hook :Oracle HRMS

Step 1: Find the API for which HOOK has to write.

            There are mainly two tables:

             1)HR_API_HOOKS

             2)HR_API_MODULES

Note:For understanding types of hook search in oracle metalink.

Step 2: Create A PL/SQL  Procedure which fits requirements.

Step 3: Now Register created procedure into Required Hook:

             API for Registering User Hook:

                   . HR_API_HOOK_CALL_API.CREATE_API_HOOK_CALL
                   . HR_API_HOOK_CALL_API.UPDATE_API_HOOK_CALL
                   . HR_API_HOOK_CALL_API.DELETE_API_HOOK_CALL

Step 4: Once Hook registered. We need to run the Pre Processors which will taken care by DBA.

Step 5: Once done with all above steps verify the status of user hook in the table called:

             HR_API_HOOK_CALLS

"Team Work" More We Less Me.

       Sameer Patil