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

Line 93: When hr_api.check_integrity_violated Then

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

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

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

Line 98: When hr_api.parent_integrity_violated Then

94: -- A check constraint has been violated
95: --
96: pqh_rha_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: pqh_rha_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 103: When hr_api.unique_integrity_violated Then

99: -- Parent integrity has been violated
100: --
101: pqh_rha_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: pqh_rha_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: pqh_rha_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: --
110: Raise;
111: End update_dml;

Line 260: when hr_api.cannot_find_prog_unit then

256: );
257: --
258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'PQH_ROUTING_HIST_ATTRIBS'
264: ,p_hook_type => 'AU');

Line 262: hr_api.cannot_find_prog_unit_error

258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'PQH_ROUTING_HIST_ATTRIBS'
264: ,p_hook_type => 'AU');
265: --
266: end;

Line 325: If (p_rec.routing_history_id = hr_api.g_number) then

321: -- p_rec plsql record structure
322: -- to see if a system default is being used. If a system default
323: -- is being used then we must set to the 'current' argument value.
324: --
325: If (p_rec.routing_history_id = hr_api.g_number) then
326: p_rec.routing_history_id :=
327: pqh_rha_shd.g_old_rec.routing_history_id;
328: End If;
329: If (p_rec.attribute_id = hr_api.g_number) then

Line 329: If (p_rec.attribute_id = hr_api.g_number) then

325: If (p_rec.routing_history_id = hr_api.g_number) then
326: p_rec.routing_history_id :=
327: pqh_rha_shd.g_old_rec.routing_history_id;
328: End If;
329: If (p_rec.attribute_id = hr_api.g_number) then
330: p_rec.attribute_id :=
331: pqh_rha_shd.g_old_rec.attribute_id;
332: End If;
333: If (p_rec.from_char = hr_api.g_varchar2) then

Line 333: If (p_rec.from_char = hr_api.g_varchar2) then

329: If (p_rec.attribute_id = hr_api.g_number) then
330: p_rec.attribute_id :=
331: pqh_rha_shd.g_old_rec.attribute_id;
332: End If;
333: If (p_rec.from_char = hr_api.g_varchar2) then
334: p_rec.from_char :=
335: pqh_rha_shd.g_old_rec.from_char;
336: End If;
337: If (p_rec.from_date = hr_api.g_date) then

Line 337: If (p_rec.from_date = hr_api.g_date) then

333: If (p_rec.from_char = hr_api.g_varchar2) then
334: p_rec.from_char :=
335: pqh_rha_shd.g_old_rec.from_char;
336: End If;
337: If (p_rec.from_date = hr_api.g_date) then
338: p_rec.from_date :=
339: pqh_rha_shd.g_old_rec.from_date;
340: End If;
341: If (p_rec.from_number = hr_api.g_number) then

Line 341: If (p_rec.from_number = hr_api.g_number) then

337: If (p_rec.from_date = hr_api.g_date) then
338: p_rec.from_date :=
339: pqh_rha_shd.g_old_rec.from_date;
340: End If;
341: If (p_rec.from_number = hr_api.g_number) then
342: p_rec.from_number :=
343: pqh_rha_shd.g_old_rec.from_number;
344: End If;
345: If (p_rec.to_char = hr_api.g_varchar2) then

Line 345: If (p_rec.to_char = hr_api.g_varchar2) then

341: If (p_rec.from_number = hr_api.g_number) then
342: p_rec.from_number :=
343: pqh_rha_shd.g_old_rec.from_number;
344: End If;
345: If (p_rec.to_char = hr_api.g_varchar2) then
346: p_rec.to_char :=
347: pqh_rha_shd.g_old_rec.to_char;
348: End If;
349: If (p_rec.to_date = hr_api.g_date) then

Line 349: If (p_rec.to_date = hr_api.g_date) then

345: If (p_rec.to_char = hr_api.g_varchar2) then
346: p_rec.to_char :=
347: pqh_rha_shd.g_old_rec.to_char;
348: End If;
349: If (p_rec.to_date = hr_api.g_date) then
350: p_rec.to_date :=
351: pqh_rha_shd.g_old_rec.to_date;
352: End If;
353: If (p_rec.to_number = hr_api.g_number) then

Line 353: If (p_rec.to_number = hr_api.g_number) then

349: If (p_rec.to_date = hr_api.g_date) then
350: p_rec.to_date :=
351: pqh_rha_shd.g_old_rec.to_date;
352: End If;
353: If (p_rec.to_number = hr_api.g_number) then
354: p_rec.to_number :=
355: pqh_rha_shd.g_old_rec.to_number;
356: End If;
357: If (p_rec.range_type_cd = hr_api.g_varchar2) then

Line 357: If (p_rec.range_type_cd = hr_api.g_varchar2) then

353: If (p_rec.to_number = hr_api.g_number) then
354: p_rec.to_number :=
355: pqh_rha_shd.g_old_rec.to_number;
356: End If;
357: If (p_rec.range_type_cd = hr_api.g_varchar2) then
358: p_rec.range_type_cd :=
359: pqh_rha_shd.g_old_rec.range_type_cd;
360: End If;
361: If (p_rec.value_date = hr_api.g_date) then

Line 361: If (p_rec.value_date = hr_api.g_date) then

357: If (p_rec.range_type_cd = hr_api.g_varchar2) then
358: p_rec.range_type_cd :=
359: pqh_rha_shd.g_old_rec.range_type_cd;
360: End If;
361: If (p_rec.value_date = hr_api.g_date) then
362: p_rec.value_date :=
363: pqh_rha_shd.g_old_rec.value_date;
364: End If;
365: If (p_rec.value_number = hr_api.g_number) then

Line 365: If (p_rec.value_number = hr_api.g_number) then

361: If (p_rec.value_date = hr_api.g_date) then
362: p_rec.value_date :=
363: pqh_rha_shd.g_old_rec.value_date;
364: End If;
365: If (p_rec.value_number = hr_api.g_number) then
366: p_rec.value_number :=
367: pqh_rha_shd.g_old_rec.value_number;
368: End If;
369: If (p_rec.value_char = hr_api.g_varchar2) then

Line 369: If (p_rec.value_char = hr_api.g_varchar2) then

365: If (p_rec.value_number = hr_api.g_number) then
366: p_rec.value_number :=
367: pqh_rha_shd.g_old_rec.value_number;
368: End If;
369: If (p_rec.value_char = hr_api.g_varchar2) then
370: p_rec.value_char :=
371: pqh_rha_shd.g_old_rec.value_char;
372: End If;
373: --

Line 431: ,p_routing_history_id in number default hr_api.g_number

427: Procedure upd
428: (p_effective_date in date
429: ,p_routing_hist_attrib_id in number
430: ,p_object_version_number in out nocopy number
431: ,p_routing_history_id in number default hr_api.g_number
432: ,p_attribute_id in number default hr_api.g_number
433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number

Line 432: ,p_attribute_id in number default hr_api.g_number

428: (p_effective_date in date
429: ,p_routing_hist_attrib_id in number
430: ,p_object_version_number in out nocopy number
431: ,p_routing_history_id in number default hr_api.g_number
432: ,p_attribute_id in number default hr_api.g_number
433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2

Line 433: ,p_from_char in varchar2 default hr_api.g_varchar2

429: ,p_routing_hist_attrib_id in number
430: ,p_object_version_number in out nocopy number
431: ,p_routing_history_id in number default hr_api.g_number
432: ,p_attribute_id in number default hr_api.g_number
433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date

Line 434: ,p_from_date in date default hr_api.g_date

430: ,p_object_version_number in out nocopy number
431: ,p_routing_history_id in number default hr_api.g_number
432: ,p_attribute_id in number default hr_api.g_number
433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number

Line 435: ,p_from_number in number default hr_api.g_number

431: ,p_routing_history_id in number default hr_api.g_number
432: ,p_attribute_id in number default hr_api.g_number
433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2

Line 436: ,p_to_char in varchar2 default hr_api.g_varchar2

432: ,p_attribute_id in number default hr_api.g_number
433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date

Line 437: ,p_to_date in date default hr_api.g_date

433: ,p_from_char in varchar2 default hr_api.g_varchar2
434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date
441: ,p_value_number in number default hr_api.g_number

Line 438: ,p_to_number in number default hr_api.g_number

434: ,p_from_date in date default hr_api.g_date
435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date
441: ,p_value_number in number default hr_api.g_number
442: ,p_value_char in varchar2 default hr_api.g_varchar2

Line 439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2

435: ,p_from_number in number default hr_api.g_number
436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date
441: ,p_value_number in number default hr_api.g_number
442: ,p_value_char in varchar2 default hr_api.g_varchar2
443: ) is

Line 440: ,p_value_date in date default hr_api.g_date

436: ,p_to_char in varchar2 default hr_api.g_varchar2
437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date
441: ,p_value_number in number default hr_api.g_number
442: ,p_value_char in varchar2 default hr_api.g_varchar2
443: ) is
444: --

Line 441: ,p_value_number in number default hr_api.g_number

437: ,p_to_date in date default hr_api.g_date
438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date
441: ,p_value_number in number default hr_api.g_number
442: ,p_value_char in varchar2 default hr_api.g_varchar2
443: ) is
444: --
445: l_rec pqh_rha_shd.g_rec_type;

Line 442: ,p_value_char in varchar2 default hr_api.g_varchar2

438: ,p_to_number in number default hr_api.g_number
439: ,p_range_type_cd in varchar2 default hr_api.g_varchar2
440: ,p_value_date in date default hr_api.g_date
441: ,p_value_number in number default hr_api.g_number
442: ,p_value_char in varchar2 default hr_api.g_varchar2
443: ) is
444: --
445: l_rec pqh_rha_shd.g_rec_type;
446: l_proc varchar2(72) := g_package||'upd';