APPS.HR_API_USER_HOOKS_UTILITY dependencies on HR_API_HOOK_CALLS

Line 517: from hr_api_hook_calls ahc

513: from hr_api_hooks ahk
514: where ahk.api_module_id = p_api_module_id
515: and ( (ahk.encoded_error is not null)
516: or exists (select null
517: from hr_api_hook_calls ahc
518: where ahc.api_hook_id = ahk.api_hook_id
519: and ahc.enabled_flag = 'Y'
520: and ahc.status = 'I')
521: or exists (select null

Line 546: from hr_api_hook_calls ahc

542: and ahk.api_module_id = p_api_module_id
543: and ahk.hook_package = p_hook_package
544: and ( (ahk.encoded_error is not null)
545: or exists (select null
546: from hr_api_hook_calls ahc
547: where ahc.api_hook_id = ahk.api_hook_id
548: and ahc.enabled_flag = 'Y'
549: and ahc.status = 'I'
550: ) )

Line 579: from hr_api_hook_calls

575: cursor cur_ahc_err (p_api_hook_id number) is
576: select encoded_error
577: , call_package
578: , call_procedure
579: from hr_api_hook_calls
580: where api_hook_id = p_api_hook_id
581: and enabled_flag = 'Y'
582: and status = 'I'
583: order by sequence;

Line 591: -- HR_API_HOOK_CALLS.

587: l_mod_name_output boolean default false; -- Indicates if the module name and
588: -- type has already been output.
589: l_encoded_error varchar2(2000); -- Encoded error message from
590: -- HR_API_HOOKS or
591: -- HR_API_HOOK_CALLS.
592: l_read_error varchar2(2000); -- A de-encrypted version of
593: -- l_encoded_error.
594: l_line varchar2(2000); -- Line of text for report.
595: l_err_cur_module boolean default false; -- Indicates if at least one error

Line 917: -- information written to the HR_API_HOOKS and HR_API_HOOK_CALLS tables

913: hr_utility.set_location('Entering:'|| l_proc, 10);
914: --
915: -- Create each hook package which is defined in the HR_API_HOOKS table
916: -- Commit after each package has been created to ensure any error
917: -- information written to the HR_API_HOOKS and HR_API_HOOK_CALLS tables
918: -- is kept.
919: --
920: for l_hook in cur_hooks loop
921: hr_api_user_hooks.create_package_body(l_hook.hook_package);

Line 968: -- HR_API_HOOK_CALLS tables is kept.

964: --
965: -- For this API module, create each hook package defined in the
966: -- HR_API_HOOKS table. Commit after each package has been created to
967: -- ensure any error information written to the HR_API_HOOKS and
968: -- HR_API_HOOK_CALLS tables is kept.
969: --
970: for l_hook in cur_hooks loop
971: hr_api_user_hooks.create_package_body(l_hook.hook_package);
972: dbms_session.free_unused_user_memory;