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

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 114: When hr_api.check_integrity_violated Then

110: End If;
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 15);
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
117: per_pgs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
117: per_pgs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
122: per_pgs_shd.constraint_error

Line 119: When hr_api.unique_integrity_violated Then

115: -- A check constraint has been violated
116: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
117: per_pgs_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
122: per_pgs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
122: per_pgs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: per_pgs_shd.g_api_dml := false; -- Unset the api dml status
126: Raise;
127: End dt_update_dml;

Line 240: If (p_datetrack_mode <> hr_api.g_correction) then

236: l_dummy_version_number number;
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: per_pgs_shd.upd_effective_end_date

Line 253: If (p_datetrack_mode = hr_api.g_update_override) then

249: ,p_validation_end_date => p_validation_end_date
250: ,p_object_version_number => l_dummy_version_number
251: );
252: --
253: If (p_datetrack_mode = hr_api.g_update_override) then
254: --
255: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
256: -- delete any future rows
257: --

Line 445: when hr_api.cannot_find_prog_unit then

441: );
442: --
443: exception
444: --
445: when hr_api.cannot_find_prog_unit then
446: --
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'PER_GRADE_SPINES_F'
449: ,p_hook_type => 'AU');

Line 447: hr_api.cannot_find_prog_unit_error

443: exception
444: --
445: when hr_api.cannot_find_prog_unit then
446: --
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'PER_GRADE_SPINES_F'
449: ,p_hook_type => 'AU');
450: --
451: end;

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

506: -- p_rec plsql record structure
507: -- to see if a system default is being used. If a system default
508: -- is being used then we must set to the 'current' argument value.
509: --
510: If (p_rec.business_group_id = hr_api.g_number) then
511: p_rec.business_group_id :=
512: per_pgs_shd.g_old_rec.business_group_id;
513: End If;
514: If (p_rec.parent_spine_id = hr_api.g_number) then

Line 514: If (p_rec.parent_spine_id = hr_api.g_number) then

510: If (p_rec.business_group_id = hr_api.g_number) then
511: p_rec.business_group_id :=
512: per_pgs_shd.g_old_rec.business_group_id;
513: End If;
514: If (p_rec.parent_spine_id = hr_api.g_number) then
515: p_rec.parent_spine_id :=
516: per_pgs_shd.g_old_rec.parent_spine_id;
517: End If;
518: If (p_rec.grade_id = hr_api.g_number) then

Line 518: If (p_rec.grade_id = hr_api.g_number) then

514: If (p_rec.parent_spine_id = hr_api.g_number) then
515: p_rec.parent_spine_id :=
516: per_pgs_shd.g_old_rec.parent_spine_id;
517: End If;
518: If (p_rec.grade_id = hr_api.g_number) then
519: p_rec.grade_id :=
520: per_pgs_shd.g_old_rec.grade_id;
521: End If;
522: If (p_rec.ceiling_step_id = hr_api.g_number) then

Line 522: If (p_rec.ceiling_step_id = hr_api.g_number) then

518: If (p_rec.grade_id = hr_api.g_number) then
519: p_rec.grade_id :=
520: per_pgs_shd.g_old_rec.grade_id;
521: End If;
522: If (p_rec.ceiling_step_id = hr_api.g_number) then
523: p_rec.ceiling_step_id :=
524: per_pgs_shd.g_old_rec.ceiling_step_id;
525: End If;
526: If (p_rec.starting_step = hr_api.g_number) then

Line 526: If (p_rec.starting_step = hr_api.g_number) then

522: If (p_rec.ceiling_step_id = hr_api.g_number) then
523: p_rec.ceiling_step_id :=
524: per_pgs_shd.g_old_rec.ceiling_step_id;
525: End If;
526: If (p_rec.starting_step = hr_api.g_number) then
527: p_rec.starting_step :=
528: per_pgs_shd.g_old_rec.starting_step;
529: End If;
530: If (p_rec.request_id = hr_api.g_number) then

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

526: If (p_rec.starting_step = hr_api.g_number) then
527: p_rec.starting_step :=
528: per_pgs_shd.g_old_rec.starting_step;
529: End If;
530: If (p_rec.request_id = hr_api.g_number) then
531: p_rec.request_id :=
532: per_pgs_shd.g_old_rec.request_id;
533: End If;
534: If (p_rec.program_application_id = hr_api.g_number) then

Line 534: If (p_rec.program_application_id = hr_api.g_number) then

530: If (p_rec.request_id = hr_api.g_number) then
531: p_rec.request_id :=
532: per_pgs_shd.g_old_rec.request_id;
533: End If;
534: If (p_rec.program_application_id = hr_api.g_number) then
535: p_rec.program_application_id :=
536: per_pgs_shd.g_old_rec.program_application_id;
537: End If;
538: If (p_rec.program_id = hr_api.g_number) then

Line 538: If (p_rec.program_id = hr_api.g_number) then

534: If (p_rec.program_application_id = hr_api.g_number) then
535: p_rec.program_application_id :=
536: per_pgs_shd.g_old_rec.program_application_id;
537: End If;
538: If (p_rec.program_id = hr_api.g_number) then
539: p_rec.program_id :=
540: per_pgs_shd.g_old_rec.program_id;
541: End If;
542: If (p_rec.program_update_date = hr_api.g_date) then

Line 542: If (p_rec.program_update_date = hr_api.g_date) then

538: If (p_rec.program_id = hr_api.g_number) then
539: p_rec.program_id :=
540: per_pgs_shd.g_old_rec.program_id;
541: End If;
542: If (p_rec.program_update_date = hr_api.g_date) then
543: p_rec.program_update_date :=
544: per_pgs_shd.g_old_rec.program_update_date;
545: End If;
546: --

Line 641: ,p_business_group_id in number default hr_api.g_number

637: (p_effective_date in date
638: ,p_datetrack_mode in varchar2
639: ,p_grade_spine_id in number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number

Line 642: ,p_parent_spine_id in number default hr_api.g_number

638: ,p_datetrack_mode in varchar2
639: ,p_grade_spine_id in number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number

Line 643: ,p_grade_id in number default hr_api.g_number

639: ,p_grade_spine_id in number
640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number

Line 644: ,p_ceiling_step_id in number default hr_api.g_number

640: ,p_object_version_number in out nocopy number
641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number

Line 645: ,p_starting_step in number default hr_api.g_number

641: ,p_business_group_id in number default hr_api.g_number
642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date

Line 646: ,p_request_id in number default hr_api.g_number

642: ,p_parent_spine_id in number default hr_api.g_number
643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date

Line 647: ,p_program_application_id in number default hr_api.g_number

643: ,p_grade_id in number default hr_api.g_number
644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
651: ,p_effective_end_date out nocopy date

Line 648: ,p_program_id in number default hr_api.g_number

644: ,p_ceiling_step_id in number default hr_api.g_number
645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
651: ,p_effective_end_date out nocopy date
652: ) is

Line 649: ,p_program_update_date in date default hr_api.g_date

645: ,p_starting_step in number default hr_api.g_number
646: ,p_request_id in number default hr_api.g_number
647: ,p_program_application_id in number default hr_api.g_number
648: ,p_program_id in number default hr_api.g_number
649: ,p_program_update_date in date default hr_api.g_date
650: ,p_effective_start_date out nocopy date
651: ,p_effective_end_date out nocopy date
652: ) is
653: --