APPS.HR_API_HOOK_CALL_API dependencies on HR_API_HOOK_CALLS

Line 30: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;

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

Line 31: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

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

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

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

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

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

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

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

Line 37: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;

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

Line 132: l_leg_code hr_api_hook_calls.legislation_code%TYPE;

128: p_object_version_number in number
129: ) is
130: --
131: l_proc varchar2(72) := g_package||'delete_api_hook_call';
132: l_leg_code hr_api_hook_calls.legislation_code%TYPE;
133: --
134: -- Setup a cursor to retrieve leg code for the hook call
135: --
136: Cursor csr_get_leg_code is

Line 138: from hr_api_hook_calls

134: -- Setup a cursor to retrieve leg code for the hook call
135: --
136: Cursor csr_get_leg_code is
137: Select legislation_code
138: from hr_api_hook_calls
139: where api_hook_call_id = p_api_hook_call_id;
140:
141: begin
142: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 209: l_leg_code hr_api_hook_calls.legislation_code%TYPE;

205: l_effective_date date;
206: --
207: l_object_version_number number;
208: --
209: l_leg_code hr_api_hook_calls.legislation_code%TYPE;
210: --
211: -- Setup a cursor to retrieve leg code for the hook call
212: --
213: Cursor csr_get_leg_code is

Line 215: from hr_api_hook_calls

211: -- Setup a cursor to retrieve leg code for the hook call
212: --
213: Cursor csr_get_leg_code is
214: Select legislation_code
215: from hr_api_hook_calls
216: where api_hook_call_id = p_api_hook_call_id;
217: --
218: begin
219: hr_utility.set_location('Entering:'|| l_proc, 5);