APPS.HR_LEG_API_HOOK_CALL_INTERNAL dependencies on HR_API_HOOK_CALLS

Line 32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;

28: --
29: --
30: -- Out variables
31: --
32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;

Line 33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

29: --
30: -- Out variables
31: --
32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';

Line 36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;

32: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;
33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
39: --
40: l_proc varchar2(72) := g_package||'create_leg_api_hook_call';

Line 37: l_status hr_api_hook_calls.status%TYPE := 'N';

33: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
39: --
40: l_proc varchar2(72) := g_package||'create_leg_api_hook_call';
41: --

Line 38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;

34:
35: -- Temp variables
36: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
37: l_status hr_api_hook_calls.status%TYPE := 'N';
38: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
39: --
40: l_proc varchar2(72) := g_package||'create_leg_api_hook_call';
41: --
42: -- Declare a cursor that will check whether the passed

Line 46: select api_hook_call_id from hr_api_hook_calls

42: -- Declare a cursor that will check whether the passed
43: -- in hook package and hook procedure form a unique combination
44:
45: cursor csr_valid_combo is
46: select api_hook_call_id from hr_api_hook_calls
47: where api_hook_id = p_api_hook_id
48: and nvl(legislation_code,'x') = nvl(p_legislation_code,'x')
49: and nvl(call_package, 'x') = nvl(p_call_package,'x')
50: and nvl(call_procedure, 'x') = nvl(p_call_procedure, 'x')

Line 218: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

214: l_effective_date date;
215: --
216: -- Out variables
217: --
218: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
219:
220: l_proc varchar2(72) := g_package||'update_leg_api_hook_call';
221: --
222: begin