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_PCL_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 118: When hr_api.check_integrity_violated Then

114: End If;
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 15);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: per_pcl_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: per_pcl_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: per_pcl_shd.constraint_error

Line 123: When hr_api.unique_integrity_violated Then

119: -- A check constraint has been violated
120: --
121: per_pcl_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: per_pcl_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: per_pcl_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;
131: End dt_update_dml;

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

240: l_dummy_version_number number;
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: If (p_datetrack_mode <> hr_api.g_correction) then
245: --
246: -- Update the current effective end date
247: --
248: per_pcl_shd.upd_effective_end_date

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

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

Line 467: when hr_api.cannot_find_prog_unit then

463: );
464: --
465: exception
466: --
467: when hr_api.cannot_find_prog_unit then
468: --
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'PER_CAGR_ENTITLEMENT_LINES_F'
471: ,p_hook_type => 'AU');

Line 469: hr_api.cannot_find_prog_unit_error

465: exception
466: --
467: when hr_api.cannot_find_prog_unit then
468: --
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'PER_CAGR_ENTITLEMENT_LINES_F'
471: ,p_hook_type => 'AU');
472: --
473: end;

Line 532: If (p_rec.cagr_entitlement_id = hr_api.g_number) then

528: -- p_rec plsql record structure
529: -- to see if a system default is being used. If a system default
530: -- is being used then we must set to the 'current' argument value.
531: --
532: If (p_rec.cagr_entitlement_id = hr_api.g_number) then
533: p_rec.cagr_entitlement_id :=
534: per_pcl_shd.g_old_rec.cagr_entitlement_id;
535: End If;
536: If (p_rec.mandatory = hr_api.g_varchar2) then

Line 536: If (p_rec.mandatory = hr_api.g_varchar2) then

532: If (p_rec.cagr_entitlement_id = hr_api.g_number) then
533: p_rec.cagr_entitlement_id :=
534: per_pcl_shd.g_old_rec.cagr_entitlement_id;
535: End If;
536: If (p_rec.mandatory = hr_api.g_varchar2) then
537: p_rec.mandatory :=
538: per_pcl_shd.g_old_rec.mandatory;
539: End If;
540: If (p_rec.value = hr_api.g_varchar2) then

Line 540: If (p_rec.value = hr_api.g_varchar2) then

536: If (p_rec.mandatory = hr_api.g_varchar2) then
537: p_rec.mandatory :=
538: per_pcl_shd.g_old_rec.mandatory;
539: End If;
540: If (p_rec.value = hr_api.g_varchar2) then
541: p_rec.value :=
542: per_pcl_shd.g_old_rec.value;
543: End If;
544: If (p_rec.range_from = hr_api.g_varchar2) then

Line 544: If (p_rec.range_from = hr_api.g_varchar2) then

540: If (p_rec.value = hr_api.g_varchar2) then
541: p_rec.value :=
542: per_pcl_shd.g_old_rec.value;
543: End If;
544: If (p_rec.range_from = hr_api.g_varchar2) then
545: p_rec.range_from :=
546: per_pcl_shd.g_old_rec.range_from;
547: End If;
548: If (p_rec.range_to = hr_api.g_varchar2) then

Line 548: If (p_rec.range_to = hr_api.g_varchar2) then

544: If (p_rec.range_from = hr_api.g_varchar2) then
545: p_rec.range_from :=
546: per_pcl_shd.g_old_rec.range_from;
547: End If;
548: If (p_rec.range_to = hr_api.g_varchar2) then
549: p_rec.range_to :=
550: per_pcl_shd.g_old_rec.range_to;
551: End If;
552: If (p_rec.parent_spine_id = hr_api.g_number) then

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

548: If (p_rec.range_to = hr_api.g_varchar2) then
549: p_rec.range_to :=
550: per_pcl_shd.g_old_rec.range_to;
551: End If;
552: If (p_rec.parent_spine_id = hr_api.g_number) then
553: p_rec.parent_spine_id :=
554: per_pcl_shd.g_old_rec.parent_spine_id;
555: End If;
556: If (p_rec.step_id = hr_api.g_number) then

Line 556: If (p_rec.step_id = hr_api.g_number) then

552: If (p_rec.parent_spine_id = hr_api.g_number) then
553: p_rec.parent_spine_id :=
554: per_pcl_shd.g_old_rec.parent_spine_id;
555: End If;
556: If (p_rec.step_id = hr_api.g_number) then
557: p_rec.step_id :=
558: per_pcl_shd.g_old_rec.step_id;
559: End If;
560: If (p_rec.from_step_id = hr_api.g_number) then

Line 560: If (p_rec.from_step_id = hr_api.g_number) then

556: If (p_rec.step_id = hr_api.g_number) then
557: p_rec.step_id :=
558: per_pcl_shd.g_old_rec.step_id;
559: End If;
560: If (p_rec.from_step_id = hr_api.g_number) then
561: p_rec.from_step_id :=
562: per_pcl_shd.g_old_rec.from_step_id;
563: End If;
564: If (p_rec.to_step_id = hr_api.g_number) then

Line 564: If (p_rec.to_step_id = hr_api.g_number) then

560: If (p_rec.from_step_id = hr_api.g_number) then
561: p_rec.from_step_id :=
562: per_pcl_shd.g_old_rec.from_step_id;
563: End If;
564: If (p_rec.to_step_id = hr_api.g_number) then
565: p_rec.to_step_id :=
566: per_pcl_shd.g_old_rec.to_step_id;
567: End If;
568: If (p_rec.status = hr_api.g_varchar2) then

Line 568: If (p_rec.status = hr_api.g_varchar2) then

564: If (p_rec.to_step_id = hr_api.g_number) then
565: p_rec.to_step_id :=
566: per_pcl_shd.g_old_rec.to_step_id;
567: End If;
568: If (p_rec.status = hr_api.g_varchar2) then
569: p_rec.status :=
570: per_pcl_shd.g_old_rec.status;
571: End If;
572: If (p_rec.oipl_id = hr_api.g_number) then

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

568: If (p_rec.status = hr_api.g_varchar2) then
569: p_rec.status :=
570: per_pcl_shd.g_old_rec.status;
571: End If;
572: If (p_rec.oipl_id = hr_api.g_number) then
573: p_rec.oipl_id :=
574: per_pcl_shd.g_old_rec.oipl_id;
575: End If;
576: If (p_rec.grade_spine_id = hr_api.g_number) then

Line 576: If (p_rec.grade_spine_id = hr_api.g_number) then

572: If (p_rec.oipl_id = hr_api.g_number) then
573: p_rec.oipl_id :=
574: per_pcl_shd.g_old_rec.oipl_id;
575: End If;
576: If (p_rec.grade_spine_id = hr_api.g_number) then
577: p_rec.grade_spine_id :=
578: per_pcl_shd.g_old_rec.grade_spine_id;
579: End If;
580: If (p_rec.eligy_prfl_id = hr_api.g_number) then

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

576: If (p_rec.grade_spine_id = hr_api.g_number) then
577: p_rec.grade_spine_id :=
578: per_pcl_shd.g_old_rec.grade_spine_id;
579: End If;
580: If (p_rec.eligy_prfl_id = hr_api.g_number) then
581: p_rec.eligy_prfl_id :=
582: per_pcl_shd.g_old_rec.eligy_prfl_id;
583: End If;
584: --

Line 673: ,p_cagr_entitlement_id in number default hr_api.g_number

669: (p_effective_date in date
670: ,p_datetrack_mode in varchar2
671: ,p_cagr_entitlement_line_id in number
672: ,p_object_version_number in out nocopy number
673: ,p_cagr_entitlement_id in number default hr_api.g_number
674: ,p_mandatory in varchar2 default hr_api.g_varchar2
675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number

Line 674: ,p_mandatory in varchar2 default hr_api.g_varchar2

670: ,p_datetrack_mode in varchar2
671: ,p_cagr_entitlement_line_id in number
672: ,p_object_version_number in out nocopy number
673: ,p_cagr_entitlement_id in number default hr_api.g_number
674: ,p_mandatory in varchar2 default hr_api.g_varchar2
675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number

Line 675: ,p_parent_spine_id in number default hr_api.g_number

671: ,p_cagr_entitlement_line_id in number
672: ,p_object_version_number in out nocopy number
673: ,p_cagr_entitlement_id in number default hr_api.g_number
674: ,p_mandatory in varchar2 default hr_api.g_varchar2
675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2

Line 676: ,p_step_id in number default hr_api.g_number

672: ,p_object_version_number in out nocopy number
673: ,p_cagr_entitlement_id in number default hr_api.g_number
674: ,p_mandatory in varchar2 default hr_api.g_varchar2
675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number

Line 677: ,p_from_step_id in number default hr_api.g_number

673: ,p_cagr_entitlement_id in number default hr_api.g_number
674: ,p_mandatory in varchar2 default hr_api.g_varchar2
675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number

Line 678: ,p_to_step_id in number default hr_api.g_number

674: ,p_mandatory in varchar2 default hr_api.g_varchar2
675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2

Line 679: ,p_status in varchar2 default hr_api.g_varchar2

675: ,p_parent_spine_id in number default hr_api.g_number
676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2

Line 680: ,p_oipl_id in number default hr_api.g_number

676: ,p_step_id in number default hr_api.g_number
677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2
684: ,p_range_to in varchar2 default hr_api.g_varchar2

Line 681: ,p_grade_spine_id in number default hr_api.g_number

677: ,p_from_step_id in number default hr_api.g_number
678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2
684: ,p_range_to in varchar2 default hr_api.g_varchar2
685: ,p_eligy_prfl_id in number default hr_api.g_number

Line 682: ,p_value in varchar2 default hr_api.g_varchar2

678: ,p_to_step_id in number default hr_api.g_number
679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2
684: ,p_range_to in varchar2 default hr_api.g_varchar2
685: ,p_eligy_prfl_id in number default hr_api.g_number
686: ,p_effective_start_date out nocopy date

Line 683: ,p_range_from in varchar2 default hr_api.g_varchar2

679: ,p_status in varchar2 default hr_api.g_varchar2
680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2
684: ,p_range_to in varchar2 default hr_api.g_varchar2
685: ,p_eligy_prfl_id in number default hr_api.g_number
686: ,p_effective_start_date out nocopy date
687: ,p_effective_end_date out nocopy date

Line 684: ,p_range_to in varchar2 default hr_api.g_varchar2

680: ,p_oipl_id in number default hr_api.g_number
681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2
684: ,p_range_to in varchar2 default hr_api.g_varchar2
685: ,p_eligy_prfl_id in number default hr_api.g_number
686: ,p_effective_start_date out nocopy date
687: ,p_effective_end_date out nocopy date
688: ) is

Line 685: ,p_eligy_prfl_id in number default hr_api.g_number

681: ,p_grade_spine_id in number default hr_api.g_number
682: ,p_value in varchar2 default hr_api.g_varchar2
683: ,p_range_from in varchar2 default hr_api.g_varchar2
684: ,p_range_to in varchar2 default hr_api.g_varchar2
685: ,p_eligy_prfl_id in number default hr_api.g_number
686: ,p_effective_start_date out nocopy date
687: ,p_effective_end_date out nocopy date
688: ) is
689: --