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.PQH_RMN_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: pqh_rmn_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: pqh_rmn_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: pqh_rmn_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: --
93: pqh_rmn_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: pqh_rmn_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: pqh_rmn_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqh_rmn_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: --
98: pqh_rmn_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqh_rmn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqh_rmn_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;
108: End update_dml;

Line 243: when hr_api.cannot_find_prog_unit then

239: );
240: --
241: exception
242: --
243: when hr_api.cannot_find_prog_unit then
244: --
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'PQH_RATE_MATRIX_NODES'
247: ,p_hook_type => 'AU');

Line 245: hr_api.cannot_find_prog_unit_error

241: exception
242: --
243: when hr_api.cannot_find_prog_unit then
244: --
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'PQH_RATE_MATRIX_NODES'
247: ,p_hook_type => 'AU');
248: --
249: end;

Line 308: If (p_rec.short_code = hr_api.g_varchar2) then

304: -- p_rec plsql record structure
305: -- to see if a system default is being used. If a system default
306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.short_code = hr_api.g_varchar2) then
309: p_rec.short_code :=
310: pqh_rmn_shd.g_old_rec.short_code;
311: End If;
312: If (p_rec.pl_id = hr_api.g_number) then

Line 312: If (p_rec.pl_id = hr_api.g_number) then

308: If (p_rec.short_code = hr_api.g_varchar2) then
309: p_rec.short_code :=
310: pqh_rmn_shd.g_old_rec.short_code;
311: End If;
312: If (p_rec.pl_id = hr_api.g_number) then
313: p_rec.pl_id :=
314: pqh_rmn_shd.g_old_rec.pl_id;
315: End If;
316: If (p_rec.level_number = hr_api.g_number) then

Line 316: If (p_rec.level_number = hr_api.g_number) then

312: If (p_rec.pl_id = hr_api.g_number) then
313: p_rec.pl_id :=
314: pqh_rmn_shd.g_old_rec.pl_id;
315: End If;
316: If (p_rec.level_number = hr_api.g_number) then
317: p_rec.level_number :=
318: pqh_rmn_shd.g_old_rec.level_number;
319: End If;
320: If (p_rec.criteria_short_code = hr_api.g_varchar2) then

Line 320: If (p_rec.criteria_short_code = hr_api.g_varchar2) then

316: If (p_rec.level_number = hr_api.g_number) then
317: p_rec.level_number :=
318: pqh_rmn_shd.g_old_rec.level_number;
319: End If;
320: If (p_rec.criteria_short_code = hr_api.g_varchar2) then
321: p_rec.criteria_short_code :=
322: pqh_rmn_shd.g_old_rec.criteria_short_code;
323: End If;
324: If (p_rec.node_name = hr_api.g_varchar2) then

Line 324: If (p_rec.node_name = hr_api.g_varchar2) then

320: If (p_rec.criteria_short_code = hr_api.g_varchar2) then
321: p_rec.criteria_short_code :=
322: pqh_rmn_shd.g_old_rec.criteria_short_code;
323: End If;
324: If (p_rec.node_name = hr_api.g_varchar2) then
325: p_rec.node_name :=
326: pqh_rmn_shd.g_old_rec.node_name;
327: End If;
328: If (p_rec.parent_node_id = hr_api.g_number) then

Line 328: If (p_rec.parent_node_id = hr_api.g_number) then

324: If (p_rec.node_name = hr_api.g_varchar2) then
325: p_rec.node_name :=
326: pqh_rmn_shd.g_old_rec.node_name;
327: End If;
328: If (p_rec.parent_node_id = hr_api.g_number) then
329: p_rec.parent_node_id :=
330: pqh_rmn_shd.g_old_rec.parent_node_id;
331: End If;
332: If (p_rec.eligy_prfl_id = hr_api.g_number) then

Line 332: If (p_rec.eligy_prfl_id = hr_api.g_number) then

328: If (p_rec.parent_node_id = hr_api.g_number) then
329: p_rec.parent_node_id :=
330: pqh_rmn_shd.g_old_rec.parent_node_id;
331: End If;
332: If (p_rec.eligy_prfl_id = hr_api.g_number) then
333: p_rec.eligy_prfl_id :=
334: pqh_rmn_shd.g_old_rec.eligy_prfl_id;
335: End If;
336: If (p_rec.business_group_id = hr_api.g_number) then

Line 336: If (p_rec.business_group_id = hr_api.g_number) then

332: If (p_rec.eligy_prfl_id = hr_api.g_number) then
333: p_rec.eligy_prfl_id :=
334: pqh_rmn_shd.g_old_rec.eligy_prfl_id;
335: End If;
336: If (p_rec.business_group_id = hr_api.g_number) then
337: p_rec.business_group_id :=
338: pqh_rmn_shd.g_old_rec.business_group_id;
339: End If;
340: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

336: If (p_rec.business_group_id = hr_api.g_number) then
337: p_rec.business_group_id :=
338: pqh_rmn_shd.g_old_rec.business_group_id;
339: End If;
340: If (p_rec.legislation_code = hr_api.g_varchar2) then
341: p_rec.legislation_code :=
342: pqh_rmn_shd.g_old_rec.legislation_code;
343: End If;
344: --

Line 404: ,p_short_code in varchar2 default hr_api.g_varchar2

400: -- ----------------------------------------------------------------------------
401: Procedure upd
402: (p_rate_matrix_node_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_short_code in varchar2 default hr_api.g_varchar2
405: ,p_level_number in number default hr_api.g_number
406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number

Line 405: ,p_level_number in number default hr_api.g_number

401: Procedure upd
402: (p_rate_matrix_node_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_short_code in varchar2 default hr_api.g_varchar2
405: ,p_level_number in number default hr_api.g_number
406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number

Line 406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2

402: (p_rate_matrix_node_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_short_code in varchar2 default hr_api.g_varchar2
405: ,p_level_number in number default hr_api.g_number
406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number

Line 407: ,p_node_name in varchar2 default hr_api.g_varchar2

403: ,p_object_version_number in out nocopy number
404: ,p_short_code in varchar2 default hr_api.g_varchar2
405: ,p_level_number in number default hr_api.g_number
406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number
411: ,p_business_group_id in number default hr_api.g_number

Line 408: ,p_pl_id in number default hr_api.g_number

404: ,p_short_code in varchar2 default hr_api.g_varchar2
405: ,p_level_number in number default hr_api.g_number
406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number
411: ,p_business_group_id in number default hr_api.g_number
412: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 409: ,p_parent_node_id in number default hr_api.g_number

405: ,p_level_number in number default hr_api.g_number
406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number
411: ,p_business_group_id in number default hr_api.g_number
412: ,p_legislation_code in varchar2 default hr_api.g_varchar2
413: ) is

Line 410: ,p_eligy_prfl_id in number default hr_api.g_number

406: ,p_criteria_short_code in varchar2 default hr_api.g_varchar2
407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number
411: ,p_business_group_id in number default hr_api.g_number
412: ,p_legislation_code in varchar2 default hr_api.g_varchar2
413: ) is
414: --

Line 411: ,p_business_group_id in number default hr_api.g_number

407: ,p_node_name in varchar2 default hr_api.g_varchar2
408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number
411: ,p_business_group_id in number default hr_api.g_number
412: ,p_legislation_code in varchar2 default hr_api.g_varchar2
413: ) is
414: --
415: l_rec pqh_rmn_shd.g_rec_type;

Line 412: ,p_legislation_code in varchar2 default hr_api.g_varchar2

408: ,p_pl_id in number default hr_api.g_number
409: ,p_parent_node_id in number default hr_api.g_number
410: ,p_eligy_prfl_id in number default hr_api.g_number
411: ,p_business_group_id in number default hr_api.g_number
412: ,p_legislation_code in varchar2 default hr_api.g_varchar2
413: ) is
414: --
415: l_rec pqh_rmn_shd.g_rec_type;
416: l_proc varchar2(72) := g_package||'upd';