DBA Data[Home] [Help]

APPS.HR_API_HOOK_INTERNAL dependencies on HR_API_HOOKS

Line 30: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;

26: l_effective_date date;
27: --
28: -- Out variables
29: --
30: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;
31: l_proc varchar2(72) := g_package||'create_api_hook';
32: --
33: --
34: -- Declare a cursor that will check whether the passed

Line 37: select api_hook_id from hr_api_hooks hah

33: --
34: -- Declare a cursor that will check whether the passed
35: -- in hook package and hook procedure form a unique combination
36: cursor csr_valid_combo is
37: select api_hook_id from hr_api_hooks hah
38: where hah.hook_package = p_hook_package
39: and hah.hook_procedure = p_hook_procedure;
40:
41: begin

Line 193: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;

189: l_effective_date date;
190: --
191: -- Out variables
192: --
193: l_api_hook_id hr_api_hooks.api_hook_id%TYPE;
194: --
195: l_proc varchar2(72) := g_package||'update_api_hook';
196: --
197: begin