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

Line 82: When hr_api.check_integrity_violated Then

78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_rct_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then

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

81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_rct_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_rct_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 86: When hr_api.parent_integrity_violated Then

82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
84: pqh_rct_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_rct_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then

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

85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_rct_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_rct_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 90: When hr_api.unique_integrity_violated Then

86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: pqh_rct_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_rct_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When Others Then

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

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.unique_integrity_violated Then
91: -- Unique integrity has been violated
92: pqh_rct_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When Others Then
95: Raise;
96: End update_dml;
97: --

Line 214: when hr_api.cannot_find_prog_unit then

210: );
211: --
212: exception
213: --
214: when hr_api.cannot_find_prog_unit then
215: --
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'pqh_routing_categories'
218: ,p_hook_type => 'AU');

Line 216: hr_api.cannot_find_prog_unit_error

212: exception
213: --
214: when hr_api.cannot_find_prog_unit then
215: --
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'pqh_routing_categories'
218: ,p_hook_type => 'AU');
219: --
220: end;

Line 284: If (p_rec.transaction_category_id = hr_api.g_number) then

280: -- p_rec plsql record structure
281: -- to see if a system default is being used. If a system default
282: -- is being used then we must set to the 'current' argument value.
283: --
284: If (p_rec.transaction_category_id = hr_api.g_number) then
285: p_rec.transaction_category_id :=
286: pqh_rct_shd.g_old_rec.transaction_category_id;
287: End If;
288: If (p_rec.enable_flag = hr_api.g_varchar2) then

Line 288: If (p_rec.enable_flag = hr_api.g_varchar2) then

284: If (p_rec.transaction_category_id = hr_api.g_number) then
285: p_rec.transaction_category_id :=
286: pqh_rct_shd.g_old_rec.transaction_category_id;
287: End If;
288: If (p_rec.enable_flag = hr_api.g_varchar2) then
289: p_rec.enable_flag :=
290: pqh_rct_shd.g_old_rec.enable_flag;
291: End If;
292: If (p_rec.default_flag = hr_api.g_varchar2) then

Line 292: If (p_rec.default_flag = hr_api.g_varchar2) then

288: If (p_rec.enable_flag = hr_api.g_varchar2) then
289: p_rec.enable_flag :=
290: pqh_rct_shd.g_old_rec.enable_flag;
291: End If;
292: If (p_rec.default_flag = hr_api.g_varchar2) then
293: p_rec.default_flag :=
294: pqh_rct_shd.g_old_rec.default_flag;
295: End If;
296: If (p_rec.delete_flag = hr_api.g_varchar2) then

Line 296: If (p_rec.delete_flag = hr_api.g_varchar2) then

292: If (p_rec.default_flag = hr_api.g_varchar2) then
293: p_rec.default_flag :=
294: pqh_rct_shd.g_old_rec.default_flag;
295: End If;
296: If (p_rec.delete_flag = hr_api.g_varchar2) then
297: p_rec.delete_flag :=
298: pqh_rct_shd.g_old_rec.delete_flag;
299: End If;
300: If (p_rec.routing_list_id = hr_api.g_number) then

Line 300: If (p_rec.routing_list_id = hr_api.g_number) then

296: If (p_rec.delete_flag = hr_api.g_varchar2) then
297: p_rec.delete_flag :=
298: pqh_rct_shd.g_old_rec.delete_flag;
299: End If;
300: If (p_rec.routing_list_id = hr_api.g_number) then
301: p_rec.routing_list_id :=
302: pqh_rct_shd.g_old_rec.routing_list_id;
303: End If;
304: If (p_rec.position_structure_id = hr_api.g_number) then

Line 304: If (p_rec.position_structure_id = hr_api.g_number) then

300: If (p_rec.routing_list_id = hr_api.g_number) then
301: p_rec.routing_list_id :=
302: pqh_rct_shd.g_old_rec.routing_list_id;
303: End If;
304: If (p_rec.position_structure_id = hr_api.g_number) then
305: p_rec.position_structure_id :=
306: pqh_rct_shd.g_old_rec.position_structure_id;
307: End If;
308: If (p_rec.override_position_id = hr_api.g_number) then

Line 308: If (p_rec.override_position_id = hr_api.g_number) then

304: If (p_rec.position_structure_id = hr_api.g_number) then
305: p_rec.position_structure_id :=
306: pqh_rct_shd.g_old_rec.position_structure_id;
307: End If;
308: If (p_rec.override_position_id = hr_api.g_number) then
309: p_rec.override_position_id :=
310: pqh_rct_shd.g_old_rec.override_position_id;
311: End If;
312: If (p_rec.override_assignment_id = hr_api.g_number) then

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

308: If (p_rec.override_position_id = hr_api.g_number) then
309: p_rec.override_position_id :=
310: pqh_rct_shd.g_old_rec.override_position_id;
311: End If;
312: If (p_rec.override_assignment_id = hr_api.g_number) then
313: p_rec.override_assignment_id :=
314: pqh_rct_shd.g_old_rec.override_assignment_id;
315: End If;
316: If (p_rec.override_role_id = hr_api.g_number) then

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

312: If (p_rec.override_assignment_id = hr_api.g_number) then
313: p_rec.override_assignment_id :=
314: pqh_rct_shd.g_old_rec.override_assignment_id;
315: End If;
316: If (p_rec.override_role_id = hr_api.g_number) then
317: p_rec.override_role_id :=
318: pqh_rct_shd.g_old_rec.override_role_id;
319: End If;
320: If (p_rec.override_user_id = hr_api.g_number) then

Line 320: If (p_rec.override_user_id = hr_api.g_number) then

316: If (p_rec.override_role_id = hr_api.g_number) then
317: p_rec.override_role_id :=
318: pqh_rct_shd.g_old_rec.override_role_id;
319: End If;
320: If (p_rec.override_user_id = hr_api.g_number) then
321: p_rec.override_user_id :=
322: pqh_rct_shd.g_old_rec.override_user_id;
323: End If;
324:

Line 381: p_transaction_category_id in number default hr_api.g_number,

377: Procedure upd
378: (
379: p_effective_date in date,
380: p_routing_category_id in number,
381: p_transaction_category_id in number default hr_api.g_number,
382: p_enable_flag in varchar2 default hr_api.g_varchar2,
383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,

Line 382: p_enable_flag in varchar2 default hr_api.g_varchar2,

378: (
379: p_effective_date in date,
380: p_routing_category_id in number,
381: p_transaction_category_id in number default hr_api.g_number,
382: p_enable_flag in varchar2 default hr_api.g_varchar2,
383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,

Line 383: p_default_flag in varchar2 default hr_api.g_varchar2,

379: p_effective_date in date,
380: p_routing_category_id in number,
381: p_transaction_category_id in number default hr_api.g_number,
382: p_enable_flag in varchar2 default hr_api.g_varchar2,
383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,

Line 384: p_delete_flag in varchar2 default hr_api.g_varchar2,

380: p_routing_category_id in number,
381: p_transaction_category_id in number default hr_api.g_number,
382: p_enable_flag in varchar2 default hr_api.g_varchar2,
383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,

Line 385: p_routing_list_id in number default hr_api.g_number,

381: p_transaction_category_id in number default hr_api.g_number,
382: p_enable_flag in varchar2 default hr_api.g_varchar2,
383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,
389: p_override_role_id in number default hr_api.g_number,

Line 386: p_position_structure_id in number default hr_api.g_number,

382: p_enable_flag in varchar2 default hr_api.g_varchar2,
383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,
389: p_override_role_id in number default hr_api.g_number,
390: p_override_user_id in number default hr_api.g_number,

Line 387: p_override_position_id in number default hr_api.g_number,

383: p_default_flag in varchar2 default hr_api.g_varchar2,
384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,
389: p_override_role_id in number default hr_api.g_number,
390: p_override_user_id in number default hr_api.g_number,
391: p_object_version_number in out nocopy number

Line 388: p_override_assignment_id in number default hr_api.g_number,

384: p_delete_flag in varchar2 default hr_api.g_varchar2,
385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,
389: p_override_role_id in number default hr_api.g_number,
390: p_override_user_id in number default hr_api.g_number,
391: p_object_version_number in out nocopy number
392: ) is

Line 389: p_override_role_id in number default hr_api.g_number,

385: p_routing_list_id in number default hr_api.g_number,
386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,
389: p_override_role_id in number default hr_api.g_number,
390: p_override_user_id in number default hr_api.g_number,
391: p_object_version_number in out nocopy number
392: ) is
393: --

Line 390: p_override_user_id in number default hr_api.g_number,

386: p_position_structure_id in number default hr_api.g_number,
387: p_override_position_id in number default hr_api.g_number,
388: p_override_assignment_id in number default hr_api.g_number,
389: p_override_role_id in number default hr_api.g_number,
390: p_override_user_id in number default hr_api.g_number,
391: p_object_version_number in out nocopy number
392: ) is
393: --
394: l_rec pqh_rct_shd.g_rec_type;