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_AHK_UPD dependencies on HR_API

Line 64: -- Update the hr_api_hooks Row

60: --
61: --
62: hr_ahk_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Update the hr_api_hooks Row
65: --
66: update hr_api_hooks
67: set
68: api_hook_id = p_rec.api_hook_id,

Line 66: update hr_api_hooks

62: hr_ahk_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Update the hr_api_hooks Row
65: --
66: update hr_api_hooks
67: set
68: api_hook_id = p_rec.api_hook_id,
69: api_module_id = p_rec.api_module_id,
70: api_hook_type = p_rec.api_hook_type,

Line 84: When hr_api.check_integrity_violated Then

80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
87: hr_ahk_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
87: hr_ahk_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
92: hr_ahk_shd.constraint_error

Line 89: When hr_api.parent_integrity_violated Then

85: -- A check constraint has been violated
86: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
87: hr_ahk_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
92: hr_ahk_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
92: hr_ahk_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
97: hr_ahk_shd.constraint_error

Line 94: When hr_api.unique_integrity_violated Then

90: -- Parent integrity has been violated
91: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
92: hr_ahk_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
97: hr_ahk_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
97: hr_ahk_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: hr_ahk_shd.g_api_dml := false; -- Unset the api dml status
101: Raise;
102: End update_dml;

Line 245: If (p_rec.api_module_id = hr_api.g_number) then

241: -- p_rec plsql record structure
242: -- to see if a system default is being used. If a system default
243: -- is being used then we must set to the 'current' argument value.
244: --
245: If (p_rec.api_module_id = hr_api.g_number) then
246: p_rec.api_module_id :=
247: hr_ahk_shd.g_old_rec.api_module_id;
248: End If;
249: If (p_rec.api_hook_type = hr_api.g_varchar2) then

Line 249: If (p_rec.api_hook_type = hr_api.g_varchar2) then

245: If (p_rec.api_module_id = hr_api.g_number) then
246: p_rec.api_module_id :=
247: hr_ahk_shd.g_old_rec.api_module_id;
248: End If;
249: If (p_rec.api_hook_type = hr_api.g_varchar2) then
250: p_rec.api_hook_type :=
251: hr_ahk_shd.g_old_rec.api_hook_type;
252: End If;
253: If (p_rec.hook_package = hr_api.g_varchar2) then

Line 253: If (p_rec.hook_package = hr_api.g_varchar2) then

249: If (p_rec.api_hook_type = hr_api.g_varchar2) then
250: p_rec.api_hook_type :=
251: hr_ahk_shd.g_old_rec.api_hook_type;
252: End If;
253: If (p_rec.hook_package = hr_api.g_varchar2) then
254: p_rec.hook_package :=
255: hr_ahk_shd.g_old_rec.hook_package;
256: End If;
257: If (p_rec.hook_procedure = hr_api.g_varchar2) then

Line 257: If (p_rec.hook_procedure = hr_api.g_varchar2) then

253: If (p_rec.hook_package = hr_api.g_varchar2) then
254: p_rec.hook_package :=
255: hr_ahk_shd.g_old_rec.hook_package;
256: End If;
257: If (p_rec.hook_procedure = hr_api.g_varchar2) then
258: p_rec.hook_procedure :=
259: hr_ahk_shd.g_old_rec.hook_procedure;
260: End If;
261: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 261: If (p_rec.legislation_code = hr_api.g_varchar2) then

257: If (p_rec.hook_procedure = hr_api.g_varchar2) then
258: p_rec.hook_procedure :=
259: hr_ahk_shd.g_old_rec.hook_procedure;
260: End If;
261: If (p_rec.legislation_code = hr_api.g_varchar2) then
262: p_rec.legislation_code :=
263: hr_ahk_shd.g_old_rec.legislation_code;
264: End If;
265: If (p_rec.legislation_package = hr_api.g_varchar2) then

Line 265: If (p_rec.legislation_package = hr_api.g_varchar2) then

261: If (p_rec.legislation_code = hr_api.g_varchar2) then
262: p_rec.legislation_code :=
263: hr_ahk_shd.g_old_rec.legislation_code;
264: End If;
265: If (p_rec.legislation_package = hr_api.g_varchar2) then
266: p_rec.legislation_package :=
267: hr_ahk_shd.g_old_rec.legislation_package;
268: End If;
269: If (p_rec.legislation_function = hr_api.g_varchar2) then

Line 269: If (p_rec.legislation_function = hr_api.g_varchar2) then

265: If (p_rec.legislation_package = hr_api.g_varchar2) then
266: p_rec.legislation_package :=
267: hr_ahk_shd.g_old_rec.legislation_package;
268: End If;
269: If (p_rec.legislation_function = hr_api.g_varchar2) then
270: p_rec.legislation_function :=
271: hr_ahk_shd.g_old_rec.legislation_function;
272: End If;
273: If (p_rec.encoded_error = hr_api.g_varchar2) then

Line 273: If (p_rec.encoded_error = hr_api.g_varchar2) then

269: If (p_rec.legislation_function = hr_api.g_varchar2) then
270: p_rec.legislation_function :=
271: hr_ahk_shd.g_old_rec.legislation_function;
272: End If;
273: If (p_rec.encoded_error = hr_api.g_varchar2) then
274: p_rec.encoded_error :=
275: hr_ahk_shd.g_old_rec.encoded_error;
276: End If;
277: --

Line 332: p_api_hook_type in varchar2 default hr_api.g_varchar2,

328: Procedure upd
329: (
330: p_api_hook_id in number,
331: p_effective_date in date,
332: p_api_hook_type in varchar2 default hr_api.g_varchar2,
333: p_hook_package in varchar2 default hr_api.g_varchar2,
334: p_hook_procedure in varchar2 default hr_api.g_varchar2,
335: p_legislation_package in varchar2 default hr_api.g_varchar2,
336: p_legislation_function in varchar2 default hr_api.g_varchar2,

Line 333: p_hook_package in varchar2 default hr_api.g_varchar2,

329: (
330: p_api_hook_id in number,
331: p_effective_date in date,
332: p_api_hook_type in varchar2 default hr_api.g_varchar2,
333: p_hook_package in varchar2 default hr_api.g_varchar2,
334: p_hook_procedure in varchar2 default hr_api.g_varchar2,
335: p_legislation_package in varchar2 default hr_api.g_varchar2,
336: p_legislation_function in varchar2 default hr_api.g_varchar2,
337: p_encoded_error in varchar2 default hr_api.g_varchar2

Line 334: p_hook_procedure in varchar2 default hr_api.g_varchar2,

330: p_api_hook_id in number,
331: p_effective_date in date,
332: p_api_hook_type in varchar2 default hr_api.g_varchar2,
333: p_hook_package in varchar2 default hr_api.g_varchar2,
334: p_hook_procedure in varchar2 default hr_api.g_varchar2,
335: p_legislation_package in varchar2 default hr_api.g_varchar2,
336: p_legislation_function in varchar2 default hr_api.g_varchar2,
337: p_encoded_error in varchar2 default hr_api.g_varchar2
338: ) is

Line 335: p_legislation_package in varchar2 default hr_api.g_varchar2,

331: p_effective_date in date,
332: p_api_hook_type in varchar2 default hr_api.g_varchar2,
333: p_hook_package in varchar2 default hr_api.g_varchar2,
334: p_hook_procedure in varchar2 default hr_api.g_varchar2,
335: p_legislation_package in varchar2 default hr_api.g_varchar2,
336: p_legislation_function in varchar2 default hr_api.g_varchar2,
337: p_encoded_error in varchar2 default hr_api.g_varchar2
338: ) is
339: --

Line 336: p_legislation_function in varchar2 default hr_api.g_varchar2,

332: p_api_hook_type in varchar2 default hr_api.g_varchar2,
333: p_hook_package in varchar2 default hr_api.g_varchar2,
334: p_hook_procedure in varchar2 default hr_api.g_varchar2,
335: p_legislation_package in varchar2 default hr_api.g_varchar2,
336: p_legislation_function in varchar2 default hr_api.g_varchar2,
337: p_encoded_error in varchar2 default hr_api.g_varchar2
338: ) is
339: --
340: l_rec hr_ahk_shd.g_rec_type;

Line 337: p_encoded_error in varchar2 default hr_api.g_varchar2

333: p_hook_package in varchar2 default hr_api.g_varchar2,
334: p_hook_procedure in varchar2 default hr_api.g_varchar2,
335: p_legislation_package in varchar2 default hr_api.g_varchar2,
336: p_legislation_function in varchar2 default hr_api.g_varchar2,
337: p_encoded_error in varchar2 default hr_api.g_varchar2
338: ) is
339: --
340: l_rec hr_ahk_shd.g_rec_type;
341: l_proc varchar2(72) := g_package||'upd';

Line 353: hr_api.g_number,

349: l_rec :=
350: hr_ahk_shd.convert_args
351: (
352: p_api_hook_id,
353: hr_api.g_number,
354: p_api_hook_type,
355: p_hook_package,
356: p_hook_procedure,
357: hr_api.g_varchar2,

Line 357: hr_api.g_varchar2,

353: hr_api.g_number,
354: p_api_hook_type,
355: p_hook_package,
356: p_hook_procedure,
357: hr_api.g_varchar2,
358: p_legislation_package,
359: p_legislation_function,
360: p_encoded_error
361: );