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_RNK_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_rnk_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_rnk_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_rnk_shd.constraint_error

Line 98: When hr_api.parent_integrity_violated Then

94: -- A check constraint has been violated
95: --
96: pqh_rnk_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_rnk_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_rnk_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_rnk_shd.constraint_error

Line 103: When hr_api.unique_integrity_violated Then

99: -- Parent integrity has been violated
100: --
101: pqh_rnk_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_rnk_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_rnk_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 261: when hr_api.cannot_find_prog_unit then

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

Line 263: hr_api.cannot_find_prog_unit_error

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

Line 326: If (p_rec.pgm_id = hr_api.g_number) then

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

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

326: If (p_rec.pgm_id = hr_api.g_number) then
327: p_rec.pgm_id :=
328: pqh_rnk_shd.g_old_rec.pgm_id;
329: End If;
330: If (p_rec.pl_id = hr_api.g_number) then
331: p_rec.pl_id :=
332: pqh_rnk_shd.g_old_rec.pl_id;
333: End If;
334: If (p_rec.oipl_id = hr_api.g_number) then

Line 334: If (p_rec.oipl_id = hr_api.g_number) then

330: If (p_rec.pl_id = hr_api.g_number) then
331: p_rec.pl_id :=
332: pqh_rnk_shd.g_old_rec.pl_id;
333: End If;
334: If (p_rec.oipl_id = hr_api.g_number) then
335: p_rec.oipl_id :=
336: pqh_rnk_shd.g_old_rec.oipl_id;
337: End If;
338: If (p_rec.process_cd = hr_api.g_varchar2) then

Line 338: If (p_rec.process_cd = hr_api.g_varchar2) then

334: If (p_rec.oipl_id = hr_api.g_number) then
335: p_rec.oipl_id :=
336: pqh_rnk_shd.g_old_rec.oipl_id;
337: End If;
338: If (p_rec.process_cd = hr_api.g_varchar2) then
339: p_rec.process_cd :=
340: pqh_rnk_shd.g_old_rec.process_cd;
341: End If;
342: If (p_rec.process_date = hr_api.g_date) then

Line 342: If (p_rec.process_date = hr_api.g_date) then

338: If (p_rec.process_cd = hr_api.g_varchar2) then
339: p_rec.process_cd :=
340: pqh_rnk_shd.g_old_rec.process_cd;
341: End If;
342: If (p_rec.process_date = hr_api.g_date) then
343: p_rec.process_date :=
344: pqh_rnk_shd.g_old_rec.process_date;
345: End If;
346: If (p_rec.benefit_action_id = hr_api.g_number) then

Line 346: If (p_rec.benefit_action_id = hr_api.g_number) then

342: If (p_rec.process_date = hr_api.g_date) then
343: p_rec.process_date :=
344: pqh_rnk_shd.g_old_rec.process_date;
345: End If;
346: If (p_rec.benefit_action_id = hr_api.g_number) then
347: p_rec.benefit_action_id :=
348: pqh_rnk_shd.g_old_rec.benefit_action_id;
349: End If;
350: If (p_rec.person_id = hr_api.g_number) then

Line 350: If (p_rec.person_id = hr_api.g_number) then

346: If (p_rec.benefit_action_id = hr_api.g_number) then
347: p_rec.benefit_action_id :=
348: pqh_rnk_shd.g_old_rec.benefit_action_id;
349: End If;
350: If (p_rec.person_id = hr_api.g_number) then
351: p_rec.person_id :=
352: pqh_rnk_shd.g_old_rec.person_id;
353: End If;
354: If (p_rec.assignment_id = hr_api.g_number) then

Line 354: If (p_rec.assignment_id = hr_api.g_number) then

350: If (p_rec.person_id = hr_api.g_number) then
351: p_rec.person_id :=
352: pqh_rnk_shd.g_old_rec.person_id;
353: End If;
354: If (p_rec.assignment_id = hr_api.g_number) then
355: p_rec.assignment_id :=
356: pqh_rnk_shd.g_old_rec.assignment_id;
357: End If;
358: If (p_rec.total_score = hr_api.g_number) then

Line 358: If (p_rec.total_score = hr_api.g_number) then

354: If (p_rec.assignment_id = hr_api.g_number) then
355: p_rec.assignment_id :=
356: pqh_rnk_shd.g_old_rec.assignment_id;
357: End If;
358: If (p_rec.total_score = hr_api.g_number) then
359: p_rec.total_score :=
360: pqh_rnk_shd.g_old_rec.total_score;
361: End If;
362: If (p_rec.request_id = hr_api.g_number) then

Line 362: If (p_rec.request_id = hr_api.g_number) then

358: If (p_rec.total_score = hr_api.g_number) then
359: p_rec.total_score :=
360: pqh_rnk_shd.g_old_rec.total_score;
361: End If;
362: If (p_rec.request_id = hr_api.g_number) then
363: p_rec.request_id :=
364: pqh_rnk_shd.g_old_rec.request_id;
365: End If;
366: If (p_rec.business_group_id = hr_api.g_number) then

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

362: If (p_rec.request_id = hr_api.g_number) then
363: p_rec.request_id :=
364: pqh_rnk_shd.g_old_rec.request_id;
365: End If;
366: If (p_rec.business_group_id = hr_api.g_number) then
367: p_rec.business_group_id :=
368: pqh_rnk_shd.g_old_rec.business_group_id;
369: End If;
370: If (p_rec.per_in_ler_id = hr_api.g_number) then

Line 370: If (p_rec.per_in_ler_id = hr_api.g_number) then

366: If (p_rec.business_group_id = hr_api.g_number) then
367: p_rec.business_group_id :=
368: pqh_rnk_shd.g_old_rec.business_group_id;
369: End If;
370: If (p_rec.per_in_ler_id = hr_api.g_number) then
371: p_rec.per_in_ler_id :=
372: pqh_rnk_shd.g_old_rec.per_in_ler_id;
373: End If;
374: --

Line 438: ,p_process_date in date default hr_api.g_date

434: Procedure upd
435: (p_effective_date in date
436: ,p_rank_process_id in number
437: ,p_object_version_number in out nocopy number
438: ,p_process_date in date default hr_api.g_date
439: ,p_pgm_id in number default hr_api.g_number
440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2

Line 439: ,p_pgm_id in number default hr_api.g_number

435: (p_effective_date in date
436: ,p_rank_process_id in number
437: ,p_object_version_number in out nocopy number
438: ,p_process_date in date default hr_api.g_date
439: ,p_pgm_id in number default hr_api.g_number
440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number

Line 440: ,p_pl_id in number default hr_api.g_number

436: ,p_rank_process_id in number
437: ,p_object_version_number in out nocopy number
438: ,p_process_date in date default hr_api.g_date
439: ,p_pgm_id in number default hr_api.g_number
440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number

Line 441: ,p_oipl_id in number default hr_api.g_number

437: ,p_object_version_number in out nocopy number
438: ,p_process_date in date default hr_api.g_date
439: ,p_pgm_id in number default hr_api.g_number
440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number

Line 442: ,p_process_cd in varchar2 default hr_api.g_varchar2

438: ,p_process_date in date default hr_api.g_date
439: ,p_pgm_id in number default hr_api.g_number
440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number

Line 443: ,p_benefit_action_id in number default hr_api.g_number

439: ,p_pgm_id in number default hr_api.g_number
440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number

Line 444: ,p_person_id in number default hr_api.g_number

440: ,p_pl_id in number default hr_api.g_number
441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number
448: ,p_business_group_id in number default hr_api.g_number

Line 445: ,p_assignment_id in number default hr_api.g_number

441: ,p_oipl_id in number default hr_api.g_number
442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number
448: ,p_business_group_id in number default hr_api.g_number
449: ,p_per_in_ler_id in number default hr_api.g_number

Line 446: ,p_total_score in number default hr_api.g_number

442: ,p_process_cd in varchar2 default hr_api.g_varchar2
443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number
448: ,p_business_group_id in number default hr_api.g_number
449: ,p_per_in_ler_id in number default hr_api.g_number
450: ) is

Line 447: ,p_request_id in number default hr_api.g_number

443: ,p_benefit_action_id in number default hr_api.g_number
444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number
448: ,p_business_group_id in number default hr_api.g_number
449: ,p_per_in_ler_id in number default hr_api.g_number
450: ) is
451: --

Line 448: ,p_business_group_id in number default hr_api.g_number

444: ,p_person_id in number default hr_api.g_number
445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number
448: ,p_business_group_id in number default hr_api.g_number
449: ,p_per_in_ler_id in number default hr_api.g_number
450: ) is
451: --
452: l_rec pqh_rnk_shd.g_rec_type;

Line 449: ,p_per_in_ler_id in number default hr_api.g_number

445: ,p_assignment_id in number default hr_api.g_number
446: ,p_total_score in number default hr_api.g_number
447: ,p_request_id in number default hr_api.g_number
448: ,p_business_group_id in number default hr_api.g_number
449: ,p_per_in_ler_id in number default hr_api.g_number
450: ) is
451: --
452: l_rec pqh_rnk_shd.g_rec_type;
453: l_proc constant varchar2(72) := g_package||'upd';