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.
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));
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
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));
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;
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
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: --
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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: --