eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APP_API_HOOK_CALL_INTERNAL dependencies on HR_API_HOOK_CALLS

Line 33: l_api_hook_call_id hr_api_hook_calls.api_hook_call_id%TYPE;

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

Line 34: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

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

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

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

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

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

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

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

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

35:
36: l_legislation_code hr_api_hook_calls.legislation_code%TYPE := null;
37: l_encoded_error hr_api_hook_calls.encoded_error%TYPE := null;
38: l_status hr_api_hook_calls.status%TYPE := 'N';
39: l_pre_processor_date hr_api_hook_calls.pre_processor_date%TYPE := null;
40: --
41: l_proc varchar2(72) := g_package
42: || 'create_app_api_hook_call';
43: --

Line 49: from hr_api_hook_calls

45: -- in hook package and hook procedure form a unique combination
46:
47: cursor csr_valid_combo is
48: select api_hook_call_id, object_version_number
49: from hr_api_hook_calls
50: where api_hook_id = p_api_hook_id
51: and nvl(application_id,hr_api.g_number)
52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)

Line 174: FROM hr_api_hook_calls

170: --
171: -- Cursor to check application_id
172: CURSOR csr_check_app IS
173: SELECT 'Y'
174: FROM hr_api_hook_calls
175: WHERE api_hook_call_id = p_api_hook_call_id
176: AND application_id IS NOT NULL;
177: --
178: -- Cursor to check hook call exists

Line 181: FROM hr_api_hook_calls

177: --
178: -- Cursor to check hook call exists
179: CURSOR csr_check_exists IS
180: SELECT 'Y'
181: FROM hr_api_hook_calls
182: WHERE api_hook_call_id = p_api_hook_call_id;
183: --
184: l_exists varchar2(1);
185: --

Line 276: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;

272: l_effective_date date;
273: --
274: -- Out variables
275: --
276: l_object_version_number hr_api_hook_calls.object_version_number%TYPE;
277:
278: l_proc varchar2(72) := g_package||'update_app_api_hook_call';
279: --
280: -- Cursor to check application_id

Line 283: FROM hr_api_hook_calls

279: --
280: -- Cursor to check application_id
281: CURSOR csr_check_app IS
282: SELECT 'Y'
283: FROM hr_api_hook_calls
284: WHERE api_hook_call_id = p_api_hook_call_id
285: AND application_id IS NOT NULL;
286: --
287: -- Cursor to check hook call exists

Line 290: FROM hr_api_hook_calls

286: --
287: -- Cursor to check hook call exists
288: CURSOR csr_check_exists IS
289: SELECT 'Y'
290: FROM hr_api_hook_calls
291: WHERE api_hook_call_id = p_api_hook_call_id;
292: --
293: l_exists varchar2(1);
294: --