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.
118: End If;
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 15);
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
125: pay_ivl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
125: pay_ivl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
130: pay_ivl_shd.constraint_error
123: -- A check constraint has been violated
124: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
125: pay_ivl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
130: pay_ivl_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
130: pay_ivl_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;
135: End dt_update_dml;
244: l_dummy_version_number number;
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: If (p_datetrack_mode <> hr_api.g_correction) then
249: --
250: -- Update the current effective end date
251: --
252: pay_ivl_shd.upd_effective_end_date
257: ,p_validation_end_date => p_validation_end_date
258: ,p_object_version_number => l_dummy_version_number
259: );
260: --
261: If (p_datetrack_mode = hr_api.g_update_override) then
262: --
263: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
264: -- delete any future rows
265: --
483: );
484: --
485: exception
486: --
487: when hr_api.cannot_find_prog_unit then
488: --
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'PAY_INPUT_VALUES_F'
491: ,p_hook_type => 'AU');
485: exception
486: --
487: when hr_api.cannot_find_prog_unit then
488: --
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'PAY_INPUT_VALUES_F'
491: ,p_hook_type => 'AU');
492: --
493: end;
548: -- p_rec plsql record structure
549: -- to see if a system default is being used. If a system default
550: -- is being used then we must set to the 'current' argument value.
551: --
552: If (p_rec.element_type_id = hr_api.g_number) then
553: p_rec.element_type_id :=
554: pay_ivl_shd.g_old_rec.element_type_id;
555: End If;
556: If (p_rec.lookup_type = hr_api.g_varchar2) then
552: If (p_rec.element_type_id = hr_api.g_number) then
553: p_rec.element_type_id :=
554: pay_ivl_shd.g_old_rec.element_type_id;
555: End If;
556: If (p_rec.lookup_type = hr_api.g_varchar2) then
557: p_rec.lookup_type :=
558: pay_ivl_shd.g_old_rec.lookup_type;
559: End If;
560: If (p_rec.business_group_id = hr_api.g_number) then
556: If (p_rec.lookup_type = hr_api.g_varchar2) then
557: p_rec.lookup_type :=
558: pay_ivl_shd.g_old_rec.lookup_type;
559: End If;
560: If (p_rec.business_group_id = hr_api.g_number) then
561: p_rec.business_group_id :=
562: pay_ivl_shd.g_old_rec.business_group_id;
563: End If;
564: If (p_rec.legislation_code = hr_api.g_varchar2) then
560: If (p_rec.business_group_id = hr_api.g_number) then
561: p_rec.business_group_id :=
562: pay_ivl_shd.g_old_rec.business_group_id;
563: End If;
564: If (p_rec.legislation_code = hr_api.g_varchar2) then
565: p_rec.legislation_code :=
566: pay_ivl_shd.g_old_rec.legislation_code;
567: End If;
568: If (p_rec.formula_id = hr_api.g_number) then
564: If (p_rec.legislation_code = hr_api.g_varchar2) then
565: p_rec.legislation_code :=
566: pay_ivl_shd.g_old_rec.legislation_code;
567: End If;
568: If (p_rec.formula_id = hr_api.g_number) then
569: p_rec.formula_id :=
570: pay_ivl_shd.g_old_rec.formula_id;
571: End If;
572: If (p_rec.value_set_id = hr_api.g_number) then
568: If (p_rec.formula_id = hr_api.g_number) then
569: p_rec.formula_id :=
570: pay_ivl_shd.g_old_rec.formula_id;
571: End If;
572: If (p_rec.value_set_id = hr_api.g_number) then
573: p_rec.value_set_id :=
574: pay_ivl_shd.g_old_rec.value_set_id;
575: End If;
576: If (p_rec.display_sequence = hr_api.g_number) then
572: If (p_rec.value_set_id = hr_api.g_number) then
573: p_rec.value_set_id :=
574: pay_ivl_shd.g_old_rec.value_set_id;
575: End If;
576: If (p_rec.display_sequence = hr_api.g_number) then
577: p_rec.display_sequence :=
578: pay_ivl_shd.g_old_rec.display_sequence;
579: End If;
580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
576: If (p_rec.display_sequence = hr_api.g_number) then
577: p_rec.display_sequence :=
578: pay_ivl_shd.g_old_rec.display_sequence;
579: End If;
580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
581: p_rec.generate_db_items_flag :=
582: pay_ivl_shd.g_old_rec.generate_db_items_flag;
583: End If;
584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
580: If (p_rec.generate_db_items_flag = hr_api.g_varchar2) then
581: p_rec.generate_db_items_flag :=
582: pay_ivl_shd.g_old_rec.generate_db_items_flag;
583: End If;
584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
585: p_rec.hot_default_flag :=
586: pay_ivl_shd.g_old_rec.hot_default_flag;
587: End If;
588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
584: If (p_rec.hot_default_flag = hr_api.g_varchar2) then
585: p_rec.hot_default_flag :=
586: pay_ivl_shd.g_old_rec.hot_default_flag;
587: End If;
588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
589: p_rec.mandatory_flag :=
590: pay_ivl_shd.g_old_rec.mandatory_flag;
591: End If;
592: If (p_rec.name = hr_api.g_varchar2) then
588: If (p_rec.mandatory_flag = hr_api.g_varchar2) then
589: p_rec.mandatory_flag :=
590: pay_ivl_shd.g_old_rec.mandatory_flag;
591: End If;
592: If (p_rec.name = hr_api.g_varchar2) then
593: p_rec.name :=
594: pay_ivl_shd.g_old_rec.name;
595: End If;
596: If (p_rec.uom = hr_api.g_varchar2) then
592: If (p_rec.name = hr_api.g_varchar2) then
593: p_rec.name :=
594: pay_ivl_shd.g_old_rec.name;
595: End If;
596: If (p_rec.uom = hr_api.g_varchar2) then
597: p_rec.uom :=
598: pay_ivl_shd.g_old_rec.uom;
599: End If;
600: If (p_rec.default_value = hr_api.g_varchar2) then
596: If (p_rec.uom = hr_api.g_varchar2) then
597: p_rec.uom :=
598: pay_ivl_shd.g_old_rec.uom;
599: End If;
600: If (p_rec.default_value = hr_api.g_varchar2) then
601: p_rec.default_value :=
602: pay_ivl_shd.g_old_rec.default_value;
603: End If;
604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
600: If (p_rec.default_value = hr_api.g_varchar2) then
601: p_rec.default_value :=
602: pay_ivl_shd.g_old_rec.default_value;
603: End If;
604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
605: p_rec.legislation_subgroup :=
606: pay_ivl_shd.g_old_rec.legislation_subgroup;
607: End If;
608: If (p_rec.max_value = hr_api.g_varchar2) then
604: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
605: p_rec.legislation_subgroup :=
606: pay_ivl_shd.g_old_rec.legislation_subgroup;
607: End If;
608: If (p_rec.max_value = hr_api.g_varchar2) then
609: p_rec.max_value :=
610: pay_ivl_shd.g_old_rec.max_value;
611: End If;
612: If (p_rec.min_value = hr_api.g_varchar2) then
608: If (p_rec.max_value = hr_api.g_varchar2) then
609: p_rec.max_value :=
610: pay_ivl_shd.g_old_rec.max_value;
611: End If;
612: If (p_rec.min_value = hr_api.g_varchar2) then
613: p_rec.min_value :=
614: pay_ivl_shd.g_old_rec.min_value;
615: End If;
616: If (p_rec.warning_or_error = hr_api.g_varchar2) then
612: If (p_rec.min_value = hr_api.g_varchar2) then
613: p_rec.min_value :=
614: pay_ivl_shd.g_old_rec.min_value;
615: End If;
616: If (p_rec.warning_or_error = hr_api.g_varchar2) then
617: p_rec.warning_or_error :=
618: pay_ivl_shd.g_old_rec.warning_or_error;
619: End If;
620: --
732: (p_effective_date in date
733: ,p_datetrack_mode in varchar2
734: ,p_input_value_id in number
735: ,p_object_version_number in out nocopy number
736: ,p_element_type_id in number default hr_api.g_number
737: ,p_display_sequence in number default hr_api.g_number
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
733: ,p_datetrack_mode in varchar2
734: ,p_input_value_id in number
735: ,p_object_version_number in out nocopy number
736: ,p_element_type_id in number default hr_api.g_number
737: ,p_display_sequence in number default hr_api.g_number
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
734: ,p_input_value_id in number
735: ,p_object_version_number in out nocopy number
736: ,p_element_type_id in number default hr_api.g_number
737: ,p_display_sequence in number default hr_api.g_number
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
735: ,p_object_version_number in out nocopy number
736: ,p_element_type_id in number default hr_api.g_number
737: ,p_display_sequence in number default hr_api.g_number
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
736: ,p_element_type_id in number default hr_api.g_number
737: ,p_display_sequence in number default hr_api.g_number
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
737: ,p_display_sequence in number default hr_api.g_number
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
738: ,p_generate_db_items_flag in varchar2 default hr_api.g_varchar2
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
739: ,p_hot_default_flag in varchar2 default hr_api.g_varchar2
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
740: ,p_mandatory_flag in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
741: ,p_name in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
742: ,p_uom in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
743: ,p_lookup_type in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
751: ,p_min_value in varchar2 default hr_api.g_varchar2
744: ,p_business_group_id in number default hr_api.g_number
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
751: ,p_min_value in varchar2 default hr_api.g_varchar2
752: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
745: ,p_legislation_code in varchar2 default hr_api.g_varchar2
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
751: ,p_min_value in varchar2 default hr_api.g_varchar2
752: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
753: ,p_effective_start_date out nocopy date
746: ,p_formula_id in number default hr_api.g_number
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
751: ,p_min_value in varchar2 default hr_api.g_varchar2
752: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
753: ,p_effective_start_date out nocopy date
754: ,p_effective_end_date out nocopy date
747: ,p_value_set_id in number default hr_api.g_number
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
751: ,p_min_value in varchar2 default hr_api.g_varchar2
752: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
753: ,p_effective_start_date out nocopy date
754: ,p_effective_end_date out nocopy date
755: ,p_default_val_warning out nocopy boolean
748: ,p_default_value in varchar2 default hr_api.g_varchar2
749: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
750: ,p_max_value in varchar2 default hr_api.g_varchar2
751: ,p_min_value in varchar2 default hr_api.g_varchar2
752: ,p_warning_or_error in varchar2 default hr_api.g_varchar2
753: ,p_effective_start_date out nocopy date
754: ,p_effective_end_date out nocopy date
755: ,p_default_val_warning out nocopy boolean
756: ,p_min_max_warning out nocopy boolean