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

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 51: and nvl(application_id,hr_api.g_number)

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)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)

Line 52: = nvl(p_application_id,hr_api.g_number)

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)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)

Line 53: and nvl(call_package, hr_api.g_varchar2)

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)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;

Line 54: = nvl(p_call_package,hr_api.g_varchar2)

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)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:

Line 55: and nvl(call_procedure, hr_api.g_varchar2)

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)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:
59: begin

Line 56: = nvl(p_call_procedure, hr_api.g_varchar2)

52: = nvl(p_application_id,hr_api.g_number)
53: and nvl(call_package, hr_api.g_varchar2)
54: = nvl(p_call_package,hr_api.g_varchar2)
55: and nvl(call_procedure, hr_api.g_varchar2)
56: = nvl(p_call_procedure, hr_api.g_varchar2)
57: and legislation_code IS NULL;
58:
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 129: raise hr_api.validate_enabled;

125: --
126: -- When in validation only mode raise the Validate_Enabled exception
127: --
128: if p_validate then
129: raise hr_api.validate_enabled;
130: end if;
131: --
132: -- Set all output arguments
133: --

Line 139: when hr_api.validate_enabled then

135: p_object_version_number := l_object_version_number;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 100);
138: exception
139: when hr_api.validate_enabled then
140: --
141: -- As the Validate_Enabled exception has been raised
142: -- we must rollback to the savepoint
143: --

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 234: raise hr_api.validate_enabled;

230: --
231: -- When in validation only mode raise the Validate_Enabled exception
232: --
233: if p_validate then
234: raise hr_api.validate_enabled;
235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 100);
238: exception

Line 239: when hr_api.validate_enabled then

235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 100);
238: exception
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised
242: -- we must rollback to the savepoint
243: --

Line 260: p_sequence in number default hr_api.g_number,

256: (p_validate in boolean default false,
257: p_effective_date in date,
258: p_api_hook_call_id in number,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,

Line 261: p_app_install_status in varchar2 default hr_api.g_varchar2,

257: p_effective_date in date,
258: p_api_hook_call_id in number,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,

Line 262: p_enabled_flag in varchar2 default hr_api.g_varchar2,

258: p_api_hook_call_id in number,
259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,

Line 263: p_call_package in varchar2 default hr_api.g_varchar2,

259: p_object_version_number in out nocopy number,
260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2

Line 264: p_call_procedure in varchar2 default hr_api.g_varchar2,

260: p_sequence in number default hr_api.g_number,
261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is

Line 265: p_pre_processor_date in date default hr_api.g_date,

261: p_app_install_status in varchar2 default hr_api.g_varchar2,
262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
269: --

Line 266: p_encoded_error in varchar2 default hr_api.g_varchar2,

262: p_enabled_flag in varchar2 default hr_api.g_varchar2,
263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
269: --
270: -- Declare cursors and local variables

Line 267: p_status in varchar2 default hr_api.g_varchar2

263: p_call_package in varchar2 default hr_api.g_varchar2,
264: p_call_procedure in varchar2 default hr_api.g_varchar2,
265: p_pre_processor_date in date default hr_api.g_date,
266: p_encoded_error in varchar2 default hr_api.g_varchar2,
267: p_status in varchar2 default hr_api.g_varchar2
268: ) is
269: --
270: -- Declare cursors and local variables
271: --

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: --

Line 360: raise hr_api.validate_enabled;

356: --
357: -- When in validation only mode raise the Validate_Enabled exception
358: --
359: if p_validate then
360: raise hr_api.validate_enabled;
361: end if;
362: --
363: -- Set all output arguments
364: --

Line 369: when hr_api.validate_enabled then

365: p_object_version_number := l_object_version_number;
366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 100);
368: exception
369: when hr_api.validate_enabled then
370: --
371: -- Only set output warning arguments
372: -- (Any key or derived arguments must be set to null
373: -- when validation only mode is being used.)