54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_etp_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
79: ,p_base_key_column => 'element_type_id'
80: ,p_base_key_value => p_rec.element_type_id
81: );
82: --
83: pay_etp_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_element_types_f Row
86: --
87: update pay_element_types_f
179: where element_type_id = p_rec.element_type_id
180: and effective_start_date = p_validation_start_date
181: and effective_end_date = p_validation_end_date;
182: --
183: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
184: --
185: -- Set the effective start and end dates
186: --
187: p_rec.effective_start_date := p_validation_start_date;
191: hr_utility.set_location(' Leaving:'||l_proc, 15);
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
196: pay_etp_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
196: pay_etp_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
196: pay_etp_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
201: pay_etp_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
201: pay_etp_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
205: Raise;
200: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
201: pay_etp_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: pay_etp_shd.g_api_dml := false; -- Unset the api dml status
205: Raise;
206: End dt_update_dml;
207: --
208: -- ----------------------------------------------------------------------------
236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure update_dml
240: (p_rec in out nocopy pay_etp_shd.g_rec_type
241: ,p_effective_date in date
242: ,p_datetrack_mode in varchar2
243: ,p_validation_start_date in date
244: ,p_validation_end_date in date
303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure dt_pre_update
307: (p_rec in out nocopy pay_etp_shd.g_rec_type
308: ,p_effective_date in date
309: ,p_datetrack_mode in varchar2
310: ,p_validation_start_date in date
311: ,p_validation_end_date in date
319: If (p_datetrack_mode <> hr_api.g_correction) then
320: --
321: -- Update the current effective end date
322: --
323: pay_etp_shd.upd_effective_end_date
324: (p_effective_date => p_effective_date
325: ,p_base_key_value => p_rec.element_type_id
326: ,p_new_effective_end_date => (p_validation_start_date - 1)
327: ,p_validation_start_date => p_validation_start_date
388: --
389: -- {End Of Comments}
390: -- ----------------------------------------------------------------------------
391: Procedure pre_update
392: (p_rec in out nocopy pay_etp_shd.g_rec_type
393: ,p_effective_date in date
394: ,p_datetrack_mode in varchar2
395: ,p_validation_start_date in date
396: ,p_validation_end_date in date
410: ,p_comment_text => p_rec.comments
411: );
412: -- Update the comments if they have changed
413: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
414: pay_etp_shd.g_old_rec.comments) then
415: hr_comm_api.upd(p_comment_id => p_rec.comment_id
416: ,p_source_table_name => 'PAY_ELEMENT_TYPES_F'
417: ,p_comment_text => p_rec.comments
418: );
461: --
462: -- {End Of Comments}
463: -- ----------------------------------------------------------------------------
464: Procedure post_update
465: (p_rec in pay_etp_shd.g_rec_type
466: ,p_effective_date in date
467: ,p_datetrack_mode in varchar2
468: ,p_validation_start_date in date
469: ,p_validation_end_date in date
670: => p_rec.advance_element_type_id
671: ,p_deduction_element_type_id
672: => p_rec.deduction_element_type_id
673: ,p_effective_start_date_o
674: => pay_etp_shd.g_old_rec.effective_start_date
675: ,p_effective_end_date_o
676: => pay_etp_shd.g_old_rec.effective_end_date
677: ,p_business_group_id_o
678: => pay_etp_shd.g_old_rec.business_group_id
672: => p_rec.deduction_element_type_id
673: ,p_effective_start_date_o
674: => pay_etp_shd.g_old_rec.effective_start_date
675: ,p_effective_end_date_o
676: => pay_etp_shd.g_old_rec.effective_end_date
677: ,p_business_group_id_o
678: => pay_etp_shd.g_old_rec.business_group_id
679: ,p_legislation_code_o
680: => pay_etp_shd.g_old_rec.legislation_code
674: => pay_etp_shd.g_old_rec.effective_start_date
675: ,p_effective_end_date_o
676: => pay_etp_shd.g_old_rec.effective_end_date
677: ,p_business_group_id_o
678: => pay_etp_shd.g_old_rec.business_group_id
679: ,p_legislation_code_o
680: => pay_etp_shd.g_old_rec.legislation_code
681: ,p_formula_id_o
682: => pay_etp_shd.g_old_rec.formula_id
676: => pay_etp_shd.g_old_rec.effective_end_date
677: ,p_business_group_id_o
678: => pay_etp_shd.g_old_rec.business_group_id
679: ,p_legislation_code_o
680: => pay_etp_shd.g_old_rec.legislation_code
681: ,p_formula_id_o
682: => pay_etp_shd.g_old_rec.formula_id
683: ,p_input_currency_code_o
684: => pay_etp_shd.g_old_rec.input_currency_code
678: => pay_etp_shd.g_old_rec.business_group_id
679: ,p_legislation_code_o
680: => pay_etp_shd.g_old_rec.legislation_code
681: ,p_formula_id_o
682: => pay_etp_shd.g_old_rec.formula_id
683: ,p_input_currency_code_o
684: => pay_etp_shd.g_old_rec.input_currency_code
685: ,p_output_currency_code_o
686: => pay_etp_shd.g_old_rec.output_currency_code
680: => pay_etp_shd.g_old_rec.legislation_code
681: ,p_formula_id_o
682: => pay_etp_shd.g_old_rec.formula_id
683: ,p_input_currency_code_o
684: => pay_etp_shd.g_old_rec.input_currency_code
685: ,p_output_currency_code_o
686: => pay_etp_shd.g_old_rec.output_currency_code
687: ,p_classification_id_o
688: => pay_etp_shd.g_old_rec.classification_id
682: => pay_etp_shd.g_old_rec.formula_id
683: ,p_input_currency_code_o
684: => pay_etp_shd.g_old_rec.input_currency_code
685: ,p_output_currency_code_o
686: => pay_etp_shd.g_old_rec.output_currency_code
687: ,p_classification_id_o
688: => pay_etp_shd.g_old_rec.classification_id
689: ,p_benefit_classification_id_o
690: => pay_etp_shd.g_old_rec.benefit_classification_id
684: => pay_etp_shd.g_old_rec.input_currency_code
685: ,p_output_currency_code_o
686: => pay_etp_shd.g_old_rec.output_currency_code
687: ,p_classification_id_o
688: => pay_etp_shd.g_old_rec.classification_id
689: ,p_benefit_classification_id_o
690: => pay_etp_shd.g_old_rec.benefit_classification_id
691: ,p_additional_entry_allowed_f_o
692: => pay_etp_shd.g_old_rec.additional_entry_allowed_flag
686: => pay_etp_shd.g_old_rec.output_currency_code
687: ,p_classification_id_o
688: => pay_etp_shd.g_old_rec.classification_id
689: ,p_benefit_classification_id_o
690: => pay_etp_shd.g_old_rec.benefit_classification_id
691: ,p_additional_entry_allowed_f_o
692: => pay_etp_shd.g_old_rec.additional_entry_allowed_flag
693: ,p_adjustment_only_flag_o
694: => pay_etp_shd.g_old_rec.adjustment_only_flag
688: => pay_etp_shd.g_old_rec.classification_id
689: ,p_benefit_classification_id_o
690: => pay_etp_shd.g_old_rec.benefit_classification_id
691: ,p_additional_entry_allowed_f_o
692: => pay_etp_shd.g_old_rec.additional_entry_allowed_flag
693: ,p_adjustment_only_flag_o
694: => pay_etp_shd.g_old_rec.adjustment_only_flag
695: ,p_closed_for_entry_flag_o
696: => pay_etp_shd.g_old_rec.closed_for_entry_flag
690: => pay_etp_shd.g_old_rec.benefit_classification_id
691: ,p_additional_entry_allowed_f_o
692: => pay_etp_shd.g_old_rec.additional_entry_allowed_flag
693: ,p_adjustment_only_flag_o
694: => pay_etp_shd.g_old_rec.adjustment_only_flag
695: ,p_closed_for_entry_flag_o
696: => pay_etp_shd.g_old_rec.closed_for_entry_flag
697: ,p_element_name_o
698: => pay_etp_shd.g_old_rec.element_name
692: => pay_etp_shd.g_old_rec.additional_entry_allowed_flag
693: ,p_adjustment_only_flag_o
694: => pay_etp_shd.g_old_rec.adjustment_only_flag
695: ,p_closed_for_entry_flag_o
696: => pay_etp_shd.g_old_rec.closed_for_entry_flag
697: ,p_element_name_o
698: => pay_etp_shd.g_old_rec.element_name
699: ,p_indirect_only_flag_o
700: => pay_etp_shd.g_old_rec.indirect_only_flag
694: => pay_etp_shd.g_old_rec.adjustment_only_flag
695: ,p_closed_for_entry_flag_o
696: => pay_etp_shd.g_old_rec.closed_for_entry_flag
697: ,p_element_name_o
698: => pay_etp_shd.g_old_rec.element_name
699: ,p_indirect_only_flag_o
700: => pay_etp_shd.g_old_rec.indirect_only_flag
701: ,p_multiple_entries_allowed_f_o
702: => pay_etp_shd.g_old_rec.multiple_entries_allowed_flag
696: => pay_etp_shd.g_old_rec.closed_for_entry_flag
697: ,p_element_name_o
698: => pay_etp_shd.g_old_rec.element_name
699: ,p_indirect_only_flag_o
700: => pay_etp_shd.g_old_rec.indirect_only_flag
701: ,p_multiple_entries_allowed_f_o
702: => pay_etp_shd.g_old_rec.multiple_entries_allowed_flag
703: ,p_multiply_value_flag_o
704: => pay_etp_shd.g_old_rec.multiply_value_flag
698: => pay_etp_shd.g_old_rec.element_name
699: ,p_indirect_only_flag_o
700: => pay_etp_shd.g_old_rec.indirect_only_flag
701: ,p_multiple_entries_allowed_f_o
702: => pay_etp_shd.g_old_rec.multiple_entries_allowed_flag
703: ,p_multiply_value_flag_o
704: => pay_etp_shd.g_old_rec.multiply_value_flag
705: ,p_post_termination_rule_o
706: => pay_etp_shd.g_old_rec.post_termination_rule
700: => pay_etp_shd.g_old_rec.indirect_only_flag
701: ,p_multiple_entries_allowed_f_o
702: => pay_etp_shd.g_old_rec.multiple_entries_allowed_flag
703: ,p_multiply_value_flag_o
704: => pay_etp_shd.g_old_rec.multiply_value_flag
705: ,p_post_termination_rule_o
706: => pay_etp_shd.g_old_rec.post_termination_rule
707: ,p_process_in_run_flag_o
708: => pay_etp_shd.g_old_rec.process_in_run_flag
702: => pay_etp_shd.g_old_rec.multiple_entries_allowed_flag
703: ,p_multiply_value_flag_o
704: => pay_etp_shd.g_old_rec.multiply_value_flag
705: ,p_post_termination_rule_o
706: => pay_etp_shd.g_old_rec.post_termination_rule
707: ,p_process_in_run_flag_o
708: => pay_etp_shd.g_old_rec.process_in_run_flag
709: ,p_processing_priority_o
710: => pay_etp_shd.g_old_rec.processing_priority
704: => pay_etp_shd.g_old_rec.multiply_value_flag
705: ,p_post_termination_rule_o
706: => pay_etp_shd.g_old_rec.post_termination_rule
707: ,p_process_in_run_flag_o
708: => pay_etp_shd.g_old_rec.process_in_run_flag
709: ,p_processing_priority_o
710: => pay_etp_shd.g_old_rec.processing_priority
711: ,p_processing_type_o
712: => pay_etp_shd.g_old_rec.processing_type
706: => pay_etp_shd.g_old_rec.post_termination_rule
707: ,p_process_in_run_flag_o
708: => pay_etp_shd.g_old_rec.process_in_run_flag
709: ,p_processing_priority_o
710: => pay_etp_shd.g_old_rec.processing_priority
711: ,p_processing_type_o
712: => pay_etp_shd.g_old_rec.processing_type
713: ,p_standard_link_flag_o
714: => pay_etp_shd.g_old_rec.standard_link_flag
708: => pay_etp_shd.g_old_rec.process_in_run_flag
709: ,p_processing_priority_o
710: => pay_etp_shd.g_old_rec.processing_priority
711: ,p_processing_type_o
712: => pay_etp_shd.g_old_rec.processing_type
713: ,p_standard_link_flag_o
714: => pay_etp_shd.g_old_rec.standard_link_flag
715: ,p_comment_id_o
716: => pay_etp_shd.g_old_rec.comment_id
710: => pay_etp_shd.g_old_rec.processing_priority
711: ,p_processing_type_o
712: => pay_etp_shd.g_old_rec.processing_type
713: ,p_standard_link_flag_o
714: => pay_etp_shd.g_old_rec.standard_link_flag
715: ,p_comment_id_o
716: => pay_etp_shd.g_old_rec.comment_id
717: ,p_comments_o
718: => pay_etp_shd.g_old_rec.comments
712: => pay_etp_shd.g_old_rec.processing_type
713: ,p_standard_link_flag_o
714: => pay_etp_shd.g_old_rec.standard_link_flag
715: ,p_comment_id_o
716: => pay_etp_shd.g_old_rec.comment_id
717: ,p_comments_o
718: => pay_etp_shd.g_old_rec.comments
719: ,p_description_o
720: => pay_etp_shd.g_old_rec.description
714: => pay_etp_shd.g_old_rec.standard_link_flag
715: ,p_comment_id_o
716: => pay_etp_shd.g_old_rec.comment_id
717: ,p_comments_o
718: => pay_etp_shd.g_old_rec.comments
719: ,p_description_o
720: => pay_etp_shd.g_old_rec.description
721: ,p_legislation_subgroup_o
722: => pay_etp_shd.g_old_rec.legislation_subgroup
716: => pay_etp_shd.g_old_rec.comment_id
717: ,p_comments_o
718: => pay_etp_shd.g_old_rec.comments
719: ,p_description_o
720: => pay_etp_shd.g_old_rec.description
721: ,p_legislation_subgroup_o
722: => pay_etp_shd.g_old_rec.legislation_subgroup
723: ,p_qualifying_age_o
724: => pay_etp_shd.g_old_rec.qualifying_age
718: => pay_etp_shd.g_old_rec.comments
719: ,p_description_o
720: => pay_etp_shd.g_old_rec.description
721: ,p_legislation_subgroup_o
722: => pay_etp_shd.g_old_rec.legislation_subgroup
723: ,p_qualifying_age_o
724: => pay_etp_shd.g_old_rec.qualifying_age
725: ,p_qualifying_length_of_servi_o
726: => pay_etp_shd.g_old_rec.qualifying_length_of_service
720: => pay_etp_shd.g_old_rec.description
721: ,p_legislation_subgroup_o
722: => pay_etp_shd.g_old_rec.legislation_subgroup
723: ,p_qualifying_age_o
724: => pay_etp_shd.g_old_rec.qualifying_age
725: ,p_qualifying_length_of_servi_o
726: => pay_etp_shd.g_old_rec.qualifying_length_of_service
727: ,p_qualifying_units_o
728: => pay_etp_shd.g_old_rec.qualifying_units
722: => pay_etp_shd.g_old_rec.legislation_subgroup
723: ,p_qualifying_age_o
724: => pay_etp_shd.g_old_rec.qualifying_age
725: ,p_qualifying_length_of_servi_o
726: => pay_etp_shd.g_old_rec.qualifying_length_of_service
727: ,p_qualifying_units_o
728: => pay_etp_shd.g_old_rec.qualifying_units
729: ,p_reporting_name_o
730: => pay_etp_shd.g_old_rec.reporting_name
724: => pay_etp_shd.g_old_rec.qualifying_age
725: ,p_qualifying_length_of_servi_o
726: => pay_etp_shd.g_old_rec.qualifying_length_of_service
727: ,p_qualifying_units_o
728: => pay_etp_shd.g_old_rec.qualifying_units
729: ,p_reporting_name_o
730: => pay_etp_shd.g_old_rec.reporting_name
731: ,p_attribute_category_o
732: => pay_etp_shd.g_old_rec.attribute_category
726: => pay_etp_shd.g_old_rec.qualifying_length_of_service
727: ,p_qualifying_units_o
728: => pay_etp_shd.g_old_rec.qualifying_units
729: ,p_reporting_name_o
730: => pay_etp_shd.g_old_rec.reporting_name
731: ,p_attribute_category_o
732: => pay_etp_shd.g_old_rec.attribute_category
733: ,p_attribute1_o
734: => pay_etp_shd.g_old_rec.attribute1
728: => pay_etp_shd.g_old_rec.qualifying_units
729: ,p_reporting_name_o
730: => pay_etp_shd.g_old_rec.reporting_name
731: ,p_attribute_category_o
732: => pay_etp_shd.g_old_rec.attribute_category
733: ,p_attribute1_o
734: => pay_etp_shd.g_old_rec.attribute1
735: ,p_attribute2_o
736: => pay_etp_shd.g_old_rec.attribute2
730: => pay_etp_shd.g_old_rec.reporting_name
731: ,p_attribute_category_o
732: => pay_etp_shd.g_old_rec.attribute_category
733: ,p_attribute1_o
734: => pay_etp_shd.g_old_rec.attribute1
735: ,p_attribute2_o
736: => pay_etp_shd.g_old_rec.attribute2
737: ,p_attribute3_o
738: => pay_etp_shd.g_old_rec.attribute3
732: => pay_etp_shd.g_old_rec.attribute_category
733: ,p_attribute1_o
734: => pay_etp_shd.g_old_rec.attribute1
735: ,p_attribute2_o
736: => pay_etp_shd.g_old_rec.attribute2
737: ,p_attribute3_o
738: => pay_etp_shd.g_old_rec.attribute3
739: ,p_attribute4_o
740: => pay_etp_shd.g_old_rec.attribute4
734: => pay_etp_shd.g_old_rec.attribute1
735: ,p_attribute2_o
736: => pay_etp_shd.g_old_rec.attribute2
737: ,p_attribute3_o
738: => pay_etp_shd.g_old_rec.attribute3
739: ,p_attribute4_o
740: => pay_etp_shd.g_old_rec.attribute4
741: ,p_attribute5_o
742: => pay_etp_shd.g_old_rec.attribute5
736: => pay_etp_shd.g_old_rec.attribute2
737: ,p_attribute3_o
738: => pay_etp_shd.g_old_rec.attribute3
739: ,p_attribute4_o
740: => pay_etp_shd.g_old_rec.attribute4
741: ,p_attribute5_o
742: => pay_etp_shd.g_old_rec.attribute5
743: ,p_attribute6_o
744: => pay_etp_shd.g_old_rec.attribute6
738: => pay_etp_shd.g_old_rec.attribute3
739: ,p_attribute4_o
740: => pay_etp_shd.g_old_rec.attribute4
741: ,p_attribute5_o
742: => pay_etp_shd.g_old_rec.attribute5
743: ,p_attribute6_o
744: => pay_etp_shd.g_old_rec.attribute6
745: ,p_attribute7_o
746: => pay_etp_shd.g_old_rec.attribute7
740: => pay_etp_shd.g_old_rec.attribute4
741: ,p_attribute5_o
742: => pay_etp_shd.g_old_rec.attribute5
743: ,p_attribute6_o
744: => pay_etp_shd.g_old_rec.attribute6
745: ,p_attribute7_o
746: => pay_etp_shd.g_old_rec.attribute7
747: ,p_attribute8_o
748: => pay_etp_shd.g_old_rec.attribute8
742: => pay_etp_shd.g_old_rec.attribute5
743: ,p_attribute6_o
744: => pay_etp_shd.g_old_rec.attribute6
745: ,p_attribute7_o
746: => pay_etp_shd.g_old_rec.attribute7
747: ,p_attribute8_o
748: => pay_etp_shd.g_old_rec.attribute8
749: ,p_attribute9_o
750: => pay_etp_shd.g_old_rec.attribute9
744: => pay_etp_shd.g_old_rec.attribute6
745: ,p_attribute7_o
746: => pay_etp_shd.g_old_rec.attribute7
747: ,p_attribute8_o
748: => pay_etp_shd.g_old_rec.attribute8
749: ,p_attribute9_o
750: => pay_etp_shd.g_old_rec.attribute9
751: ,p_attribute10_o
752: => pay_etp_shd.g_old_rec.attribute10
746: => pay_etp_shd.g_old_rec.attribute7
747: ,p_attribute8_o
748: => pay_etp_shd.g_old_rec.attribute8
749: ,p_attribute9_o
750: => pay_etp_shd.g_old_rec.attribute9
751: ,p_attribute10_o
752: => pay_etp_shd.g_old_rec.attribute10
753: ,p_attribute11_o
754: => pay_etp_shd.g_old_rec.attribute11
748: => pay_etp_shd.g_old_rec.attribute8
749: ,p_attribute9_o
750: => pay_etp_shd.g_old_rec.attribute9
751: ,p_attribute10_o
752: => pay_etp_shd.g_old_rec.attribute10
753: ,p_attribute11_o
754: => pay_etp_shd.g_old_rec.attribute11
755: ,p_attribute12_o
756: => pay_etp_shd.g_old_rec.attribute12
750: => pay_etp_shd.g_old_rec.attribute9
751: ,p_attribute10_o
752: => pay_etp_shd.g_old_rec.attribute10
753: ,p_attribute11_o
754: => pay_etp_shd.g_old_rec.attribute11
755: ,p_attribute12_o
756: => pay_etp_shd.g_old_rec.attribute12
757: ,p_attribute13_o
758: => pay_etp_shd.g_old_rec.attribute13
752: => pay_etp_shd.g_old_rec.attribute10
753: ,p_attribute11_o
754: => pay_etp_shd.g_old_rec.attribute11
755: ,p_attribute12_o
756: => pay_etp_shd.g_old_rec.attribute12
757: ,p_attribute13_o
758: => pay_etp_shd.g_old_rec.attribute13
759: ,p_attribute14_o
760: => pay_etp_shd.g_old_rec.attribute14
754: => pay_etp_shd.g_old_rec.attribute11
755: ,p_attribute12_o
756: => pay_etp_shd.g_old_rec.attribute12
757: ,p_attribute13_o
758: => pay_etp_shd.g_old_rec.attribute13
759: ,p_attribute14_o
760: => pay_etp_shd.g_old_rec.attribute14
761: ,p_attribute15_o
762: => pay_etp_shd.g_old_rec.attribute15
756: => pay_etp_shd.g_old_rec.attribute12
757: ,p_attribute13_o
758: => pay_etp_shd.g_old_rec.attribute13
759: ,p_attribute14_o
760: => pay_etp_shd.g_old_rec.attribute14
761: ,p_attribute15_o
762: => pay_etp_shd.g_old_rec.attribute15
763: ,p_attribute16_o
764: => pay_etp_shd.g_old_rec.attribute16
758: => pay_etp_shd.g_old_rec.attribute13
759: ,p_attribute14_o
760: => pay_etp_shd.g_old_rec.attribute14
761: ,p_attribute15_o
762: => pay_etp_shd.g_old_rec.attribute15
763: ,p_attribute16_o
764: => pay_etp_shd.g_old_rec.attribute16
765: ,p_attribute17_o
766: => pay_etp_shd.g_old_rec.attribute17
760: => pay_etp_shd.g_old_rec.attribute14
761: ,p_attribute15_o
762: => pay_etp_shd.g_old_rec.attribute15
763: ,p_attribute16_o
764: => pay_etp_shd.g_old_rec.attribute16
765: ,p_attribute17_o
766: => pay_etp_shd.g_old_rec.attribute17
767: ,p_attribute18_o
768: => pay_etp_shd.g_old_rec.attribute18
762: => pay_etp_shd.g_old_rec.attribute15
763: ,p_attribute16_o
764: => pay_etp_shd.g_old_rec.attribute16
765: ,p_attribute17_o
766: => pay_etp_shd.g_old_rec.attribute17
767: ,p_attribute18_o
768: => pay_etp_shd.g_old_rec.attribute18
769: ,p_attribute19_o
770: => pay_etp_shd.g_old_rec.attribute19
764: => pay_etp_shd.g_old_rec.attribute16
765: ,p_attribute17_o
766: => pay_etp_shd.g_old_rec.attribute17
767: ,p_attribute18_o
768: => pay_etp_shd.g_old_rec.attribute18
769: ,p_attribute19_o
770: => pay_etp_shd.g_old_rec.attribute19
771: ,p_attribute20_o
772: => pay_etp_shd.g_old_rec.attribute20
766: => pay_etp_shd.g_old_rec.attribute17
767: ,p_attribute18_o
768: => pay_etp_shd.g_old_rec.attribute18
769: ,p_attribute19_o
770: => pay_etp_shd.g_old_rec.attribute19
771: ,p_attribute20_o
772: => pay_etp_shd.g_old_rec.attribute20
773: ,p_element_information_catego_o
774: => pay_etp_shd.g_old_rec.element_information_category
768: => pay_etp_shd.g_old_rec.attribute18
769: ,p_attribute19_o
770: => pay_etp_shd.g_old_rec.attribute19
771: ,p_attribute20_o
772: => pay_etp_shd.g_old_rec.attribute20
773: ,p_element_information_catego_o
774: => pay_etp_shd.g_old_rec.element_information_category
775: ,p_element_information1_o
776: => pay_etp_shd.g_old_rec.element_information1
770: => pay_etp_shd.g_old_rec.attribute19
771: ,p_attribute20_o
772: => pay_etp_shd.g_old_rec.attribute20
773: ,p_element_information_catego_o
774: => pay_etp_shd.g_old_rec.element_information_category
775: ,p_element_information1_o
776: => pay_etp_shd.g_old_rec.element_information1
777: ,p_element_information2_o
778: => pay_etp_shd.g_old_rec.element_information2
772: => pay_etp_shd.g_old_rec.attribute20
773: ,p_element_information_catego_o
774: => pay_etp_shd.g_old_rec.element_information_category
775: ,p_element_information1_o
776: => pay_etp_shd.g_old_rec.element_information1
777: ,p_element_information2_o
778: => pay_etp_shd.g_old_rec.element_information2
779: ,p_element_information3_o
780: => pay_etp_shd.g_old_rec.element_information3
774: => pay_etp_shd.g_old_rec.element_information_category
775: ,p_element_information1_o
776: => pay_etp_shd.g_old_rec.element_information1
777: ,p_element_information2_o
778: => pay_etp_shd.g_old_rec.element_information2
779: ,p_element_information3_o
780: => pay_etp_shd.g_old_rec.element_information3
781: ,p_element_information4_o
782: => pay_etp_shd.g_old_rec.element_information4
776: => pay_etp_shd.g_old_rec.element_information1
777: ,p_element_information2_o
778: => pay_etp_shd.g_old_rec.element_information2
779: ,p_element_information3_o
780: => pay_etp_shd.g_old_rec.element_information3
781: ,p_element_information4_o
782: => pay_etp_shd.g_old_rec.element_information4
783: ,p_element_information5_o
784: => pay_etp_shd.g_old_rec.element_information5
778: => pay_etp_shd.g_old_rec.element_information2
779: ,p_element_information3_o
780: => pay_etp_shd.g_old_rec.element_information3
781: ,p_element_information4_o
782: => pay_etp_shd.g_old_rec.element_information4
783: ,p_element_information5_o
784: => pay_etp_shd.g_old_rec.element_information5
785: ,p_element_information6_o
786: => pay_etp_shd.g_old_rec.element_information6
780: => pay_etp_shd.g_old_rec.element_information3
781: ,p_element_information4_o
782: => pay_etp_shd.g_old_rec.element_information4
783: ,p_element_information5_o
784: => pay_etp_shd.g_old_rec.element_information5
785: ,p_element_information6_o
786: => pay_etp_shd.g_old_rec.element_information6
787: ,p_element_information7_o
788: => pay_etp_shd.g_old_rec.element_information7
782: => pay_etp_shd.g_old_rec.element_information4
783: ,p_element_information5_o
784: => pay_etp_shd.g_old_rec.element_information5
785: ,p_element_information6_o
786: => pay_etp_shd.g_old_rec.element_information6
787: ,p_element_information7_o
788: => pay_etp_shd.g_old_rec.element_information7
789: ,p_element_information8_o
790: => pay_etp_shd.g_old_rec.element_information8
784: => pay_etp_shd.g_old_rec.element_information5
785: ,p_element_information6_o
786: => pay_etp_shd.g_old_rec.element_information6
787: ,p_element_information7_o
788: => pay_etp_shd.g_old_rec.element_information7
789: ,p_element_information8_o
790: => pay_etp_shd.g_old_rec.element_information8
791: ,p_element_information9_o
792: => pay_etp_shd.g_old_rec.element_information9
786: => pay_etp_shd.g_old_rec.element_information6
787: ,p_element_information7_o
788: => pay_etp_shd.g_old_rec.element_information7
789: ,p_element_information8_o
790: => pay_etp_shd.g_old_rec.element_information8
791: ,p_element_information9_o
792: => pay_etp_shd.g_old_rec.element_information9
793: ,p_element_information10_o
794: => pay_etp_shd.g_old_rec.element_information10
788: => pay_etp_shd.g_old_rec.element_information7
789: ,p_element_information8_o
790: => pay_etp_shd.g_old_rec.element_information8
791: ,p_element_information9_o
792: => pay_etp_shd.g_old_rec.element_information9
793: ,p_element_information10_o
794: => pay_etp_shd.g_old_rec.element_information10
795: ,p_element_information11_o
796: => pay_etp_shd.g_old_rec.element_information11
790: => pay_etp_shd.g_old_rec.element_information8
791: ,p_element_information9_o
792: => pay_etp_shd.g_old_rec.element_information9
793: ,p_element_information10_o
794: => pay_etp_shd.g_old_rec.element_information10
795: ,p_element_information11_o
796: => pay_etp_shd.g_old_rec.element_information11
797: ,p_element_information12_o
798: => pay_etp_shd.g_old_rec.element_information12
792: => pay_etp_shd.g_old_rec.element_information9
793: ,p_element_information10_o
794: => pay_etp_shd.g_old_rec.element_information10
795: ,p_element_information11_o
796: => pay_etp_shd.g_old_rec.element_information11
797: ,p_element_information12_o
798: => pay_etp_shd.g_old_rec.element_information12
799: ,p_element_information13_o
800: => pay_etp_shd.g_old_rec.element_information13
794: => pay_etp_shd.g_old_rec.element_information10
795: ,p_element_information11_o
796: => pay_etp_shd.g_old_rec.element_information11
797: ,p_element_information12_o
798: => pay_etp_shd.g_old_rec.element_information12
799: ,p_element_information13_o
800: => pay_etp_shd.g_old_rec.element_information13
801: ,p_element_information14_o
802: => pay_etp_shd.g_old_rec.element_information14
796: => pay_etp_shd.g_old_rec.element_information11
797: ,p_element_information12_o
798: => pay_etp_shd.g_old_rec.element_information12
799: ,p_element_information13_o
800: => pay_etp_shd.g_old_rec.element_information13
801: ,p_element_information14_o
802: => pay_etp_shd.g_old_rec.element_information14
803: ,p_element_information15_o
804: => pay_etp_shd.g_old_rec.element_information15
798: => pay_etp_shd.g_old_rec.element_information12
799: ,p_element_information13_o
800: => pay_etp_shd.g_old_rec.element_information13
801: ,p_element_information14_o
802: => pay_etp_shd.g_old_rec.element_information14
803: ,p_element_information15_o
804: => pay_etp_shd.g_old_rec.element_information15
805: ,p_element_information16_o
806: => pay_etp_shd.g_old_rec.element_information16
800: => pay_etp_shd.g_old_rec.element_information13
801: ,p_element_information14_o
802: => pay_etp_shd.g_old_rec.element_information14
803: ,p_element_information15_o
804: => pay_etp_shd.g_old_rec.element_information15
805: ,p_element_information16_o
806: => pay_etp_shd.g_old_rec.element_information16
807: ,p_element_information17_o
808: => pay_etp_shd.g_old_rec.element_information17
802: => pay_etp_shd.g_old_rec.element_information14
803: ,p_element_information15_o
804: => pay_etp_shd.g_old_rec.element_information15
805: ,p_element_information16_o
806: => pay_etp_shd.g_old_rec.element_information16
807: ,p_element_information17_o
808: => pay_etp_shd.g_old_rec.element_information17
809: ,p_element_information18_o
810: => pay_etp_shd.g_old_rec.element_information18
804: => pay_etp_shd.g_old_rec.element_information15
805: ,p_element_information16_o
806: => pay_etp_shd.g_old_rec.element_information16
807: ,p_element_information17_o
808: => pay_etp_shd.g_old_rec.element_information17
809: ,p_element_information18_o
810: => pay_etp_shd.g_old_rec.element_information18
811: ,p_element_information19_o
812: => pay_etp_shd.g_old_rec.element_information19
806: => pay_etp_shd.g_old_rec.element_information16
807: ,p_element_information17_o
808: => pay_etp_shd.g_old_rec.element_information17
809: ,p_element_information18_o
810: => pay_etp_shd.g_old_rec.element_information18
811: ,p_element_information19_o
812: => pay_etp_shd.g_old_rec.element_information19
813: ,p_element_information20_o
814: => pay_etp_shd.g_old_rec.element_information20
808: => pay_etp_shd.g_old_rec.element_information17
809: ,p_element_information18_o
810: => pay_etp_shd.g_old_rec.element_information18
811: ,p_element_information19_o
812: => pay_etp_shd.g_old_rec.element_information19
813: ,p_element_information20_o
814: => pay_etp_shd.g_old_rec.element_information20
815: ,p_third_party_pay_only_flag_o
816: => pay_etp_shd.g_old_rec.third_party_pay_only_flag
810: => pay_etp_shd.g_old_rec.element_information18
811: ,p_element_information19_o
812: => pay_etp_shd.g_old_rec.element_information19
813: ,p_element_information20_o
814: => pay_etp_shd.g_old_rec.element_information20
815: ,p_third_party_pay_only_flag_o
816: => pay_etp_shd.g_old_rec.third_party_pay_only_flag
817: ,p_object_version_number_o
818: => pay_etp_shd.g_old_rec.object_version_number
812: => pay_etp_shd.g_old_rec.element_information19
813: ,p_element_information20_o
814: => pay_etp_shd.g_old_rec.element_information20
815: ,p_third_party_pay_only_flag_o
816: => pay_etp_shd.g_old_rec.third_party_pay_only_flag
817: ,p_object_version_number_o
818: => pay_etp_shd.g_old_rec.object_version_number
819: ,p_iterative_flag_o
820: => pay_etp_shd.g_old_rec.iterative_flag
814: => pay_etp_shd.g_old_rec.element_information20
815: ,p_third_party_pay_only_flag_o
816: => pay_etp_shd.g_old_rec.third_party_pay_only_flag
817: ,p_object_version_number_o
818: => pay_etp_shd.g_old_rec.object_version_number
819: ,p_iterative_flag_o
820: => pay_etp_shd.g_old_rec.iterative_flag
821: ,p_iterative_formula_id_o
822: => pay_etp_shd.g_old_rec.iterative_formula_id
816: => pay_etp_shd.g_old_rec.third_party_pay_only_flag
817: ,p_object_version_number_o
818: => pay_etp_shd.g_old_rec.object_version_number
819: ,p_iterative_flag_o
820: => pay_etp_shd.g_old_rec.iterative_flag
821: ,p_iterative_formula_id_o
822: => pay_etp_shd.g_old_rec.iterative_formula_id
823: ,p_iterative_priority_o
824: => pay_etp_shd.g_old_rec.iterative_priority
818: => pay_etp_shd.g_old_rec.object_version_number
819: ,p_iterative_flag_o
820: => pay_etp_shd.g_old_rec.iterative_flag
821: ,p_iterative_formula_id_o
822: => pay_etp_shd.g_old_rec.iterative_formula_id
823: ,p_iterative_priority_o
824: => pay_etp_shd.g_old_rec.iterative_priority
825: ,p_creator_type_o
826: => pay_etp_shd.g_old_rec.creator_type
820: => pay_etp_shd.g_old_rec.iterative_flag
821: ,p_iterative_formula_id_o
822: => pay_etp_shd.g_old_rec.iterative_formula_id
823: ,p_iterative_priority_o
824: => pay_etp_shd.g_old_rec.iterative_priority
825: ,p_creator_type_o
826: => pay_etp_shd.g_old_rec.creator_type
827: ,p_retro_summ_ele_id_o
828: => pay_etp_shd.g_old_rec.retro_summ_ele_id
822: => pay_etp_shd.g_old_rec.iterative_formula_id
823: ,p_iterative_priority_o
824: => pay_etp_shd.g_old_rec.iterative_priority
825: ,p_creator_type_o
826: => pay_etp_shd.g_old_rec.creator_type
827: ,p_retro_summ_ele_id_o
828: => pay_etp_shd.g_old_rec.retro_summ_ele_id
829: ,p_grossup_flag_o
830: => pay_etp_shd.g_old_rec.grossup_flag
824: => pay_etp_shd.g_old_rec.iterative_priority
825: ,p_creator_type_o
826: => pay_etp_shd.g_old_rec.creator_type
827: ,p_retro_summ_ele_id_o
828: => pay_etp_shd.g_old_rec.retro_summ_ele_id
829: ,p_grossup_flag_o
830: => pay_etp_shd.g_old_rec.grossup_flag
831: ,p_process_mode_o
832: => pay_etp_shd.g_old_rec.process_mode
826: => pay_etp_shd.g_old_rec.creator_type
827: ,p_retro_summ_ele_id_o
828: => pay_etp_shd.g_old_rec.retro_summ_ele_id
829: ,p_grossup_flag_o
830: => pay_etp_shd.g_old_rec.grossup_flag
831: ,p_process_mode_o
832: => pay_etp_shd.g_old_rec.process_mode
833: ,p_advance_indicator_o
834: => pay_etp_shd.g_old_rec.advance_indicator
828: => pay_etp_shd.g_old_rec.retro_summ_ele_id
829: ,p_grossup_flag_o
830: => pay_etp_shd.g_old_rec.grossup_flag
831: ,p_process_mode_o
832: => pay_etp_shd.g_old_rec.process_mode
833: ,p_advance_indicator_o
834: => pay_etp_shd.g_old_rec.advance_indicator
835: ,p_advance_payable_o
836: => pay_etp_shd.g_old_rec.advance_payable
830: => pay_etp_shd.g_old_rec.grossup_flag
831: ,p_process_mode_o
832: => pay_etp_shd.g_old_rec.process_mode
833: ,p_advance_indicator_o
834: => pay_etp_shd.g_old_rec.advance_indicator
835: ,p_advance_payable_o
836: => pay_etp_shd.g_old_rec.advance_payable
837: ,p_advance_deduction_o
838: => pay_etp_shd.g_old_rec.advance_deduction
832: => pay_etp_shd.g_old_rec.process_mode
833: ,p_advance_indicator_o
834: => pay_etp_shd.g_old_rec.advance_indicator
835: ,p_advance_payable_o
836: => pay_etp_shd.g_old_rec.advance_payable
837: ,p_advance_deduction_o
838: => pay_etp_shd.g_old_rec.advance_deduction
839: ,p_process_advance_entry_o
840: => pay_etp_shd.g_old_rec.process_advance_entry
834: => pay_etp_shd.g_old_rec.advance_indicator
835: ,p_advance_payable_o
836: => pay_etp_shd.g_old_rec.advance_payable
837: ,p_advance_deduction_o
838: => pay_etp_shd.g_old_rec.advance_deduction
839: ,p_process_advance_entry_o
840: => pay_etp_shd.g_old_rec.process_advance_entry
841: ,p_proration_group_id_o
842: => pay_etp_shd.g_old_rec.proration_group_id
836: => pay_etp_shd.g_old_rec.advance_payable
837: ,p_advance_deduction_o
838: => pay_etp_shd.g_old_rec.advance_deduction
839: ,p_process_advance_entry_o
840: => pay_etp_shd.g_old_rec.process_advance_entry
841: ,p_proration_group_id_o
842: => pay_etp_shd.g_old_rec.proration_group_id
843: ,p_proration_formula_id_o
844: => pay_etp_shd.g_old_rec.proration_formula_id
838: => pay_etp_shd.g_old_rec.advance_deduction
839: ,p_process_advance_entry_o
840: => pay_etp_shd.g_old_rec.process_advance_entry
841: ,p_proration_group_id_o
842: => pay_etp_shd.g_old_rec.proration_group_id
843: ,p_proration_formula_id_o
844: => pay_etp_shd.g_old_rec.proration_formula_id
845: ,p_recalc_event_group_id_o
846: => pay_etp_shd.g_old_rec.recalc_event_group_id
840: => pay_etp_shd.g_old_rec.process_advance_entry
841: ,p_proration_group_id_o
842: => pay_etp_shd.g_old_rec.proration_group_id
843: ,p_proration_formula_id_o
844: => pay_etp_shd.g_old_rec.proration_formula_id
845: ,p_recalc_event_group_id_o
846: => pay_etp_shd.g_old_rec.recalc_event_group_id
847: ,p_once_each_period_flag_o
848: => pay_etp_shd.g_old_rec.once_each_period_flag
842: => pay_etp_shd.g_old_rec.proration_group_id
843: ,p_proration_formula_id_o
844: => pay_etp_shd.g_old_rec.proration_formula_id
845: ,p_recalc_event_group_id_o
846: => pay_etp_shd.g_old_rec.recalc_event_group_id
847: ,p_once_each_period_flag_o
848: => pay_etp_shd.g_old_rec.once_each_period_flag
849: ,p_time_definition_type_o
850: => pay_etp_shd.g_old_rec.time_definition_type
844: => pay_etp_shd.g_old_rec.proration_formula_id
845: ,p_recalc_event_group_id_o
846: => pay_etp_shd.g_old_rec.recalc_event_group_id
847: ,p_once_each_period_flag_o
848: => pay_etp_shd.g_old_rec.once_each_period_flag
849: ,p_time_definition_type_o
850: => pay_etp_shd.g_old_rec.time_definition_type
851: ,p_time_definition_id_o
852: => pay_etp_shd.g_old_rec.time_definition_id
846: => pay_etp_shd.g_old_rec.recalc_event_group_id
847: ,p_once_each_period_flag_o
848: => pay_etp_shd.g_old_rec.once_each_period_flag
849: ,p_time_definition_type_o
850: => pay_etp_shd.g_old_rec.time_definition_type
851: ,p_time_definition_id_o
852: => pay_etp_shd.g_old_rec.time_definition_id
853: ,p_advance_element_type_id_o
854: => pay_etp_shd.g_old_rec.advance_element_type_id
848: => pay_etp_shd.g_old_rec.once_each_period_flag
849: ,p_time_definition_type_o
850: => pay_etp_shd.g_old_rec.time_definition_type
851: ,p_time_definition_id_o
852: => pay_etp_shd.g_old_rec.time_definition_id
853: ,p_advance_element_type_id_o
854: => pay_etp_shd.g_old_rec.advance_element_type_id
855: ,p_deduction_element_type_id_o
856: => pay_etp_shd.g_old_rec.deduction_element_type_id
850: => pay_etp_shd.g_old_rec.time_definition_type
851: ,p_time_definition_id_o
852: => pay_etp_shd.g_old_rec.time_definition_id
853: ,p_advance_element_type_id_o
854: => pay_etp_shd.g_old_rec.advance_element_type_id
855: ,p_deduction_element_type_id_o
856: => pay_etp_shd.g_old_rec.deduction_element_type_id
857: );
858: --
852: => pay_etp_shd.g_old_rec.time_definition_id
853: ,p_advance_element_type_id_o
854: => pay_etp_shd.g_old_rec.advance_element_type_id
855: ,p_deduction_element_type_id_o
856: => pay_etp_shd.g_old_rec.deduction_element_type_id
857: );
858: --
859: exception
860: --
912: --
913: -- {End Of Comments}
914: -- ----------------------------------------------------------------------------
915: Procedure convert_defs
916: (p_rec in out nocopy pay_etp_shd.g_rec_type
917: ) is
918: --
919: Begin
920: --
924: -- is being used then we must set to the 'current' argument value.
925: --
926: If (p_rec.business_group_id = hr_api.g_number) then
927: p_rec.business_group_id :=
928: pay_etp_shd.g_old_rec.business_group_id;
929: End If;
930: If (p_rec.legislation_code = hr_api.g_varchar2) then
931: p_rec.legislation_code :=
932: pay_etp_shd.g_old_rec.legislation_code;
928: pay_etp_shd.g_old_rec.business_group_id;
929: End If;
930: If (p_rec.legislation_code = hr_api.g_varchar2) then
931: p_rec.legislation_code :=
932: pay_etp_shd.g_old_rec.legislation_code;
933: End If;
934: If (p_rec.formula_id = hr_api.g_number) then
935: p_rec.formula_id :=
936: pay_etp_shd.g_old_rec.formula_id;
932: pay_etp_shd.g_old_rec.legislation_code;
933: End If;
934: If (p_rec.formula_id = hr_api.g_number) then
935: p_rec.formula_id :=
936: pay_etp_shd.g_old_rec.formula_id;
937: End If;
938: If (p_rec.input_currency_code = hr_api.g_varchar2) then
939: p_rec.input_currency_code :=
940: pay_etp_shd.g_old_rec.input_currency_code;
936: pay_etp_shd.g_old_rec.formula_id;
937: End If;
938: If (p_rec.input_currency_code = hr_api.g_varchar2) then
939: p_rec.input_currency_code :=
940: pay_etp_shd.g_old_rec.input_currency_code;
941: End If;
942: If (p_rec.output_currency_code = hr_api.g_varchar2) then
943: p_rec.output_currency_code :=
944: pay_etp_shd.g_old_rec.output_currency_code;
940: pay_etp_shd.g_old_rec.input_currency_code;
941: End If;
942: If (p_rec.output_currency_code = hr_api.g_varchar2) then
943: p_rec.output_currency_code :=
944: pay_etp_shd.g_old_rec.output_currency_code;
945: End If;
946: If (p_rec.classification_id = hr_api.g_number) then
947: p_rec.classification_id :=
948: pay_etp_shd.g_old_rec.classification_id;
944: pay_etp_shd.g_old_rec.output_currency_code;
945: End If;
946: If (p_rec.classification_id = hr_api.g_number) then
947: p_rec.classification_id :=
948: pay_etp_shd.g_old_rec.classification_id;
949: End If;
950: If (p_rec.benefit_classification_id = hr_api.g_number) then
951: p_rec.benefit_classification_id :=
952: pay_etp_shd.g_old_rec.benefit_classification_id;
948: pay_etp_shd.g_old_rec.classification_id;
949: End If;
950: If (p_rec.benefit_classification_id = hr_api.g_number) then
951: p_rec.benefit_classification_id :=
952: pay_etp_shd.g_old_rec.benefit_classification_id;
953: End If;
954: If (p_rec.additional_entry_allowed_flag = hr_api.g_varchar2) then
955: p_rec.additional_entry_allowed_flag :=
956: pay_etp_shd.g_old_rec.additional_entry_allowed_flag;
952: pay_etp_shd.g_old_rec.benefit_classification_id;
953: End If;
954: If (p_rec.additional_entry_allowed_flag = hr_api.g_varchar2) then
955: p_rec.additional_entry_allowed_flag :=
956: pay_etp_shd.g_old_rec.additional_entry_allowed_flag;
957: End If;
958: If (p_rec.adjustment_only_flag = hr_api.g_varchar2) then
959: p_rec.adjustment_only_flag :=
960: pay_etp_shd.g_old_rec.adjustment_only_flag;
956: pay_etp_shd.g_old_rec.additional_entry_allowed_flag;
957: End If;
958: If (p_rec.adjustment_only_flag = hr_api.g_varchar2) then
959: p_rec.adjustment_only_flag :=
960: pay_etp_shd.g_old_rec.adjustment_only_flag;
961: End If;
962: If (p_rec.closed_for_entry_flag = hr_api.g_varchar2) then
963: p_rec.closed_for_entry_flag :=
964: pay_etp_shd.g_old_rec.closed_for_entry_flag;
960: pay_etp_shd.g_old_rec.adjustment_only_flag;
961: End If;
962: If (p_rec.closed_for_entry_flag = hr_api.g_varchar2) then
963: p_rec.closed_for_entry_flag :=
964: pay_etp_shd.g_old_rec.closed_for_entry_flag;
965: End If;
966: If (p_rec.element_name = hr_api.g_varchar2) then
967: p_rec.element_name :=
968: pay_etp_shd.g_old_rec.element_name;
964: pay_etp_shd.g_old_rec.closed_for_entry_flag;
965: End If;
966: If (p_rec.element_name = hr_api.g_varchar2) then
967: p_rec.element_name :=
968: pay_etp_shd.g_old_rec.element_name;
969: End If;
970: If (p_rec.indirect_only_flag = hr_api.g_varchar2) then
971: p_rec.indirect_only_flag :=
972: pay_etp_shd.g_old_rec.indirect_only_flag;
968: pay_etp_shd.g_old_rec.element_name;
969: End If;
970: If (p_rec.indirect_only_flag = hr_api.g_varchar2) then
971: p_rec.indirect_only_flag :=
972: pay_etp_shd.g_old_rec.indirect_only_flag;
973: End If;
974: If (p_rec.multiple_entries_allowed_flag = hr_api.g_varchar2) then
975: p_rec.multiple_entries_allowed_flag :=
976: pay_etp_shd.g_old_rec.multiple_entries_allowed_flag;
972: pay_etp_shd.g_old_rec.indirect_only_flag;
973: End If;
974: If (p_rec.multiple_entries_allowed_flag = hr_api.g_varchar2) then
975: p_rec.multiple_entries_allowed_flag :=
976: pay_etp_shd.g_old_rec.multiple_entries_allowed_flag;
977: End If;
978: If (p_rec.multiply_value_flag = hr_api.g_varchar2) then
979: p_rec.multiply_value_flag :=
980: pay_etp_shd.g_old_rec.multiply_value_flag;
976: pay_etp_shd.g_old_rec.multiple_entries_allowed_flag;
977: End If;
978: If (p_rec.multiply_value_flag = hr_api.g_varchar2) then
979: p_rec.multiply_value_flag :=
980: pay_etp_shd.g_old_rec.multiply_value_flag;
981: End If;
982: If (p_rec.post_termination_rule = hr_api.g_varchar2) then
983: p_rec.post_termination_rule :=
984: pay_etp_shd.g_old_rec.post_termination_rule;
980: pay_etp_shd.g_old_rec.multiply_value_flag;
981: End If;
982: If (p_rec.post_termination_rule = hr_api.g_varchar2) then
983: p_rec.post_termination_rule :=
984: pay_etp_shd.g_old_rec.post_termination_rule;
985: End If;
986: If (p_rec.process_in_run_flag = hr_api.g_varchar2) then
987: p_rec.process_in_run_flag :=
988: pay_etp_shd.g_old_rec.process_in_run_flag;
984: pay_etp_shd.g_old_rec.post_termination_rule;
985: End If;
986: If (p_rec.process_in_run_flag = hr_api.g_varchar2) then
987: p_rec.process_in_run_flag :=
988: pay_etp_shd.g_old_rec.process_in_run_flag;
989: End If;
990: If (p_rec.processing_priority = hr_api.g_number) then
991: p_rec.processing_priority :=
992: pay_etp_shd.g_old_rec.processing_priority;
988: pay_etp_shd.g_old_rec.process_in_run_flag;
989: End If;
990: If (p_rec.processing_priority = hr_api.g_number) then
991: p_rec.processing_priority :=
992: pay_etp_shd.g_old_rec.processing_priority;
993: End If;
994: If (p_rec.processing_type = hr_api.g_varchar2) then
995: p_rec.processing_type :=
996: pay_etp_shd.g_old_rec.processing_type;
992: pay_etp_shd.g_old_rec.processing_priority;
993: End If;
994: If (p_rec.processing_type = hr_api.g_varchar2) then
995: p_rec.processing_type :=
996: pay_etp_shd.g_old_rec.processing_type;
997: End If;
998: If (p_rec.standard_link_flag = hr_api.g_varchar2) then
999: p_rec.standard_link_flag :=
1000: pay_etp_shd.g_old_rec.standard_link_flag;
996: pay_etp_shd.g_old_rec.processing_type;
997: End If;
998: If (p_rec.standard_link_flag = hr_api.g_varchar2) then
999: p_rec.standard_link_flag :=
1000: pay_etp_shd.g_old_rec.standard_link_flag;
1001: End If;
1002: If (p_rec.comment_id = hr_api.g_number) then
1003: p_rec.comment_id :=
1004: pay_etp_shd.g_old_rec.comment_id;
1000: pay_etp_shd.g_old_rec.standard_link_flag;
1001: End If;
1002: If (p_rec.comment_id = hr_api.g_number) then
1003: p_rec.comment_id :=
1004: pay_etp_shd.g_old_rec.comment_id;
1005: End If;
1006: If (p_rec.comments = hr_api.g_varchar2) then
1007: p_rec.comments :=
1008: pay_etp_shd.g_old_rec.comments;
1004: pay_etp_shd.g_old_rec.comment_id;
1005: End If;
1006: If (p_rec.comments = hr_api.g_varchar2) then
1007: p_rec.comments :=
1008: pay_etp_shd.g_old_rec.comments;
1009: End If;
1010: If (p_rec.description = hr_api.g_varchar2) then
1011: p_rec.description :=
1012: pay_etp_shd.g_old_rec.description;
1008: pay_etp_shd.g_old_rec.comments;
1009: End If;
1010: If (p_rec.description = hr_api.g_varchar2) then
1011: p_rec.description :=
1012: pay_etp_shd.g_old_rec.description;
1013: End If;
1014: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
1015: p_rec.legislation_subgroup :=
1016: pay_etp_shd.g_old_rec.legislation_subgroup;
1012: pay_etp_shd.g_old_rec.description;
1013: End If;
1014: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
1015: p_rec.legislation_subgroup :=
1016: pay_etp_shd.g_old_rec.legislation_subgroup;
1017: End If;
1018: If (p_rec.qualifying_age = hr_api.g_number) then
1019: p_rec.qualifying_age :=
1020: pay_etp_shd.g_old_rec.qualifying_age;
1016: pay_etp_shd.g_old_rec.legislation_subgroup;
1017: End If;
1018: If (p_rec.qualifying_age = hr_api.g_number) then
1019: p_rec.qualifying_age :=
1020: pay_etp_shd.g_old_rec.qualifying_age;
1021: End If;
1022: If (p_rec.qualifying_length_of_service = hr_api.g_number) then
1023: p_rec.qualifying_length_of_service :=
1024: pay_etp_shd.g_old_rec.qualifying_length_of_service;
1020: pay_etp_shd.g_old_rec.qualifying_age;
1021: End If;
1022: If (p_rec.qualifying_length_of_service = hr_api.g_number) then
1023: p_rec.qualifying_length_of_service :=
1024: pay_etp_shd.g_old_rec.qualifying_length_of_service;
1025: End If;
1026: If (p_rec.qualifying_units = hr_api.g_varchar2) then
1027: p_rec.qualifying_units :=
1028: pay_etp_shd.g_old_rec.qualifying_units;
1024: pay_etp_shd.g_old_rec.qualifying_length_of_service;
1025: End If;
1026: If (p_rec.qualifying_units = hr_api.g_varchar2) then
1027: p_rec.qualifying_units :=
1028: pay_etp_shd.g_old_rec.qualifying_units;
1029: End If;
1030: If (p_rec.reporting_name = hr_api.g_varchar2) then
1031: p_rec.reporting_name :=
1032: pay_etp_shd.g_old_rec.reporting_name;
1028: pay_etp_shd.g_old_rec.qualifying_units;
1029: End If;
1030: If (p_rec.reporting_name = hr_api.g_varchar2) then
1031: p_rec.reporting_name :=
1032: pay_etp_shd.g_old_rec.reporting_name;
1033: End If;
1034: If (p_rec.attribute_category = hr_api.g_varchar2) then
1035: p_rec.attribute_category :=
1036: pay_etp_shd.g_old_rec.attribute_category;
1032: pay_etp_shd.g_old_rec.reporting_name;
1033: End If;
1034: If (p_rec.attribute_category = hr_api.g_varchar2) then
1035: p_rec.attribute_category :=
1036: pay_etp_shd.g_old_rec.attribute_category;
1037: End If;
1038: If (p_rec.attribute1 = hr_api.g_varchar2) then
1039: p_rec.attribute1 :=
1040: pay_etp_shd.g_old_rec.attribute1;
1036: pay_etp_shd.g_old_rec.attribute_category;
1037: End If;
1038: If (p_rec.attribute1 = hr_api.g_varchar2) then
1039: p_rec.attribute1 :=
1040: pay_etp_shd.g_old_rec.attribute1;
1041: End If;
1042: If (p_rec.attribute2 = hr_api.g_varchar2) then
1043: p_rec.attribute2 :=
1044: pay_etp_shd.g_old_rec.attribute2;
1040: pay_etp_shd.g_old_rec.attribute1;
1041: End If;
1042: If (p_rec.attribute2 = hr_api.g_varchar2) then
1043: p_rec.attribute2 :=
1044: pay_etp_shd.g_old_rec.attribute2;
1045: End If;
1046: If (p_rec.attribute3 = hr_api.g_varchar2) then
1047: p_rec.attribute3 :=
1048: pay_etp_shd.g_old_rec.attribute3;
1044: pay_etp_shd.g_old_rec.attribute2;
1045: End If;
1046: If (p_rec.attribute3 = hr_api.g_varchar2) then
1047: p_rec.attribute3 :=
1048: pay_etp_shd.g_old_rec.attribute3;
1049: End If;
1050: If (p_rec.attribute4 = hr_api.g_varchar2) then
1051: p_rec.attribute4 :=
1052: pay_etp_shd.g_old_rec.attribute4;
1048: pay_etp_shd.g_old_rec.attribute3;
1049: End If;
1050: If (p_rec.attribute4 = hr_api.g_varchar2) then
1051: p_rec.attribute4 :=
1052: pay_etp_shd.g_old_rec.attribute4;
1053: End If;
1054: If (p_rec.attribute5 = hr_api.g_varchar2) then
1055: p_rec.attribute5 :=
1056: pay_etp_shd.g_old_rec.attribute5;
1052: pay_etp_shd.g_old_rec.attribute4;
1053: End If;
1054: If (p_rec.attribute5 = hr_api.g_varchar2) then
1055: p_rec.attribute5 :=
1056: pay_etp_shd.g_old_rec.attribute5;
1057: End If;
1058: If (p_rec.attribute6 = hr_api.g_varchar2) then
1059: p_rec.attribute6 :=
1060: pay_etp_shd.g_old_rec.attribute6;
1056: pay_etp_shd.g_old_rec.attribute5;
1057: End If;
1058: If (p_rec.attribute6 = hr_api.g_varchar2) then
1059: p_rec.attribute6 :=
1060: pay_etp_shd.g_old_rec.attribute6;
1061: End If;
1062: If (p_rec.attribute7 = hr_api.g_varchar2) then
1063: p_rec.attribute7 :=
1064: pay_etp_shd.g_old_rec.attribute7;
1060: pay_etp_shd.g_old_rec.attribute6;
1061: End If;
1062: If (p_rec.attribute7 = hr_api.g_varchar2) then
1063: p_rec.attribute7 :=
1064: pay_etp_shd.g_old_rec.attribute7;
1065: End If;
1066: If (p_rec.attribute8 = hr_api.g_varchar2) then
1067: p_rec.attribute8 :=
1068: pay_etp_shd.g_old_rec.attribute8;
1064: pay_etp_shd.g_old_rec.attribute7;
1065: End If;
1066: If (p_rec.attribute8 = hr_api.g_varchar2) then
1067: p_rec.attribute8 :=
1068: pay_etp_shd.g_old_rec.attribute8;
1069: End If;
1070: If (p_rec.attribute9 = hr_api.g_varchar2) then
1071: p_rec.attribute9 :=
1072: pay_etp_shd.g_old_rec.attribute9;
1068: pay_etp_shd.g_old_rec.attribute8;
1069: End If;
1070: If (p_rec.attribute9 = hr_api.g_varchar2) then
1071: p_rec.attribute9 :=
1072: pay_etp_shd.g_old_rec.attribute9;
1073: End If;
1074: If (p_rec.attribute10 = hr_api.g_varchar2) then
1075: p_rec.attribute10 :=
1076: pay_etp_shd.g_old_rec.attribute10;
1072: pay_etp_shd.g_old_rec.attribute9;
1073: End If;
1074: If (p_rec.attribute10 = hr_api.g_varchar2) then
1075: p_rec.attribute10 :=
1076: pay_etp_shd.g_old_rec.attribute10;
1077: End If;
1078: If (p_rec.attribute11 = hr_api.g_varchar2) then
1079: p_rec.attribute11 :=
1080: pay_etp_shd.g_old_rec.attribute11;
1076: pay_etp_shd.g_old_rec.attribute10;
1077: End If;
1078: If (p_rec.attribute11 = hr_api.g_varchar2) then
1079: p_rec.attribute11 :=
1080: pay_etp_shd.g_old_rec.attribute11;
1081: End If;
1082: If (p_rec.attribute12 = hr_api.g_varchar2) then
1083: p_rec.attribute12 :=
1084: pay_etp_shd.g_old_rec.attribute12;
1080: pay_etp_shd.g_old_rec.attribute11;
1081: End If;
1082: If (p_rec.attribute12 = hr_api.g_varchar2) then
1083: p_rec.attribute12 :=
1084: pay_etp_shd.g_old_rec.attribute12;
1085: End If;
1086: If (p_rec.attribute13 = hr_api.g_varchar2) then
1087: p_rec.attribute13 :=
1088: pay_etp_shd.g_old_rec.attribute13;
1084: pay_etp_shd.g_old_rec.attribute12;
1085: End If;
1086: If (p_rec.attribute13 = hr_api.g_varchar2) then
1087: p_rec.attribute13 :=
1088: pay_etp_shd.g_old_rec.attribute13;
1089: End If;
1090: If (p_rec.attribute14 = hr_api.g_varchar2) then
1091: p_rec.attribute14 :=
1092: pay_etp_shd.g_old_rec.attribute14;
1088: pay_etp_shd.g_old_rec.attribute13;
1089: End If;
1090: If (p_rec.attribute14 = hr_api.g_varchar2) then
1091: p_rec.attribute14 :=
1092: pay_etp_shd.g_old_rec.attribute14;
1093: End If;
1094: If (p_rec.attribute15 = hr_api.g_varchar2) then
1095: p_rec.attribute15 :=
1096: pay_etp_shd.g_old_rec.attribute15;
1092: pay_etp_shd.g_old_rec.attribute14;
1093: End If;
1094: If (p_rec.attribute15 = hr_api.g_varchar2) then
1095: p_rec.attribute15 :=
1096: pay_etp_shd.g_old_rec.attribute15;
1097: End If;
1098: If (p_rec.attribute16 = hr_api.g_varchar2) then
1099: p_rec.attribute16 :=
1100: pay_etp_shd.g_old_rec.attribute16;
1096: pay_etp_shd.g_old_rec.attribute15;
1097: End If;
1098: If (p_rec.attribute16 = hr_api.g_varchar2) then
1099: p_rec.attribute16 :=
1100: pay_etp_shd.g_old_rec.attribute16;
1101: End If;
1102: If (p_rec.attribute17 = hr_api.g_varchar2) then
1103: p_rec.attribute17 :=
1104: pay_etp_shd.g_old_rec.attribute17;
1100: pay_etp_shd.g_old_rec.attribute16;
1101: End If;
1102: If (p_rec.attribute17 = hr_api.g_varchar2) then
1103: p_rec.attribute17 :=
1104: pay_etp_shd.g_old_rec.attribute17;
1105: End If;
1106: If (p_rec.attribute18 = hr_api.g_varchar2) then
1107: p_rec.attribute18 :=
1108: pay_etp_shd.g_old_rec.attribute18;
1104: pay_etp_shd.g_old_rec.attribute17;
1105: End If;
1106: If (p_rec.attribute18 = hr_api.g_varchar2) then
1107: p_rec.attribute18 :=
1108: pay_etp_shd.g_old_rec.attribute18;
1109: End If;
1110: If (p_rec.attribute19 = hr_api.g_varchar2) then
1111: p_rec.attribute19 :=
1112: pay_etp_shd.g_old_rec.attribute19;
1108: pay_etp_shd.g_old_rec.attribute18;
1109: End If;
1110: If (p_rec.attribute19 = hr_api.g_varchar2) then
1111: p_rec.attribute19 :=
1112: pay_etp_shd.g_old_rec.attribute19;
1113: End If;
1114: If (p_rec.attribute20 = hr_api.g_varchar2) then
1115: p_rec.attribute20 :=
1116: pay_etp_shd.g_old_rec.attribute20;
1112: pay_etp_shd.g_old_rec.attribute19;
1113: End If;
1114: If (p_rec.attribute20 = hr_api.g_varchar2) then
1115: p_rec.attribute20 :=
1116: pay_etp_shd.g_old_rec.attribute20;
1117: End If;
1118: If (p_rec.element_information_category = hr_api.g_varchar2) then
1119: p_rec.element_information_category :=
1120: pay_etp_shd.g_old_rec.element_information_category;
1116: pay_etp_shd.g_old_rec.attribute20;
1117: End If;
1118: If (p_rec.element_information_category = hr_api.g_varchar2) then
1119: p_rec.element_information_category :=
1120: pay_etp_shd.g_old_rec.element_information_category;
1121: End If;
1122: If (p_rec.element_information1 = hr_api.g_varchar2) then
1123: p_rec.element_information1 :=
1124: pay_etp_shd.g_old_rec.element_information1;
1120: pay_etp_shd.g_old_rec.element_information_category;
1121: End If;
1122: If (p_rec.element_information1 = hr_api.g_varchar2) then
1123: p_rec.element_information1 :=
1124: pay_etp_shd.g_old_rec.element_information1;
1125: End If;
1126: If (p_rec.element_information2 = hr_api.g_varchar2) then
1127: p_rec.element_information2 :=
1128: pay_etp_shd.g_old_rec.element_information2;
1124: pay_etp_shd.g_old_rec.element_information1;
1125: End If;
1126: If (p_rec.element_information2 = hr_api.g_varchar2) then
1127: p_rec.element_information2 :=
1128: pay_etp_shd.g_old_rec.element_information2;
1129: End If;
1130: If (p_rec.element_information3 = hr_api.g_varchar2) then
1131: p_rec.element_information3 :=
1132: pay_etp_shd.g_old_rec.element_information3;
1128: pay_etp_shd.g_old_rec.element_information2;
1129: End If;
1130: If (p_rec.element_information3 = hr_api.g_varchar2) then
1131: p_rec.element_information3 :=
1132: pay_etp_shd.g_old_rec.element_information3;
1133: End If;
1134: If (p_rec.element_information4 = hr_api.g_varchar2) then
1135: p_rec.element_information4 :=
1136: pay_etp_shd.g_old_rec.element_information4;
1132: pay_etp_shd.g_old_rec.element_information3;
1133: End If;
1134: If (p_rec.element_information4 = hr_api.g_varchar2) then
1135: p_rec.element_information4 :=
1136: pay_etp_shd.g_old_rec.element_information4;
1137: End If;
1138: If (p_rec.element_information5 = hr_api.g_varchar2) then
1139: p_rec.element_information5 :=
1140: pay_etp_shd.g_old_rec.element_information5;
1136: pay_etp_shd.g_old_rec.element_information4;
1137: End If;
1138: If (p_rec.element_information5 = hr_api.g_varchar2) then
1139: p_rec.element_information5 :=
1140: pay_etp_shd.g_old_rec.element_information5;
1141: End If;
1142: If (p_rec.element_information6 = hr_api.g_varchar2) then
1143: p_rec.element_information6 :=
1144: pay_etp_shd.g_old_rec.element_information6;
1140: pay_etp_shd.g_old_rec.element_information5;
1141: End If;
1142: If (p_rec.element_information6 = hr_api.g_varchar2) then
1143: p_rec.element_information6 :=
1144: pay_etp_shd.g_old_rec.element_information6;
1145: End If;
1146: If (p_rec.element_information7 = hr_api.g_varchar2) then
1147: p_rec.element_information7 :=
1148: pay_etp_shd.g_old_rec.element_information7;
1144: pay_etp_shd.g_old_rec.element_information6;
1145: End If;
1146: If (p_rec.element_information7 = hr_api.g_varchar2) then
1147: p_rec.element_information7 :=
1148: pay_etp_shd.g_old_rec.element_information7;
1149: End If;
1150: If (p_rec.element_information8 = hr_api.g_varchar2) then
1151: p_rec.element_information8 :=
1152: pay_etp_shd.g_old_rec.element_information8;
1148: pay_etp_shd.g_old_rec.element_information7;
1149: End If;
1150: If (p_rec.element_information8 = hr_api.g_varchar2) then
1151: p_rec.element_information8 :=
1152: pay_etp_shd.g_old_rec.element_information8;
1153: End If;
1154: If (p_rec.element_information9 = hr_api.g_varchar2) then
1155: p_rec.element_information9 :=
1156: pay_etp_shd.g_old_rec.element_information9;
1152: pay_etp_shd.g_old_rec.element_information8;
1153: End If;
1154: If (p_rec.element_information9 = hr_api.g_varchar2) then
1155: p_rec.element_information9 :=
1156: pay_etp_shd.g_old_rec.element_information9;
1157: End If;
1158: If (p_rec.element_information10 = hr_api.g_varchar2) then
1159: p_rec.element_information10 :=
1160: pay_etp_shd.g_old_rec.element_information10;
1156: pay_etp_shd.g_old_rec.element_information9;
1157: End If;
1158: If (p_rec.element_information10 = hr_api.g_varchar2) then
1159: p_rec.element_information10 :=
1160: pay_etp_shd.g_old_rec.element_information10;
1161: End If;
1162: If (p_rec.element_information11 = hr_api.g_varchar2) then
1163: p_rec.element_information11 :=
1164: pay_etp_shd.g_old_rec.element_information11;
1160: pay_etp_shd.g_old_rec.element_information10;
1161: End If;
1162: If (p_rec.element_information11 = hr_api.g_varchar2) then
1163: p_rec.element_information11 :=
1164: pay_etp_shd.g_old_rec.element_information11;
1165: End If;
1166: If (p_rec.element_information12 = hr_api.g_varchar2) then
1167: p_rec.element_information12 :=
1168: pay_etp_shd.g_old_rec.element_information12;
1164: pay_etp_shd.g_old_rec.element_information11;
1165: End If;
1166: If (p_rec.element_information12 = hr_api.g_varchar2) then
1167: p_rec.element_information12 :=
1168: pay_etp_shd.g_old_rec.element_information12;
1169: End If;
1170: If (p_rec.element_information13 = hr_api.g_varchar2) then
1171: p_rec.element_information13 :=
1172: pay_etp_shd.g_old_rec.element_information13;
1168: pay_etp_shd.g_old_rec.element_information12;
1169: End If;
1170: If (p_rec.element_information13 = hr_api.g_varchar2) then
1171: p_rec.element_information13 :=
1172: pay_etp_shd.g_old_rec.element_information13;
1173: End If;
1174: If (p_rec.element_information14 = hr_api.g_varchar2) then
1175: p_rec.element_information14 :=
1176: pay_etp_shd.g_old_rec.element_information14;
1172: pay_etp_shd.g_old_rec.element_information13;
1173: End If;
1174: If (p_rec.element_information14 = hr_api.g_varchar2) then
1175: p_rec.element_information14 :=
1176: pay_etp_shd.g_old_rec.element_information14;
1177: End If;
1178: If (p_rec.element_information15 = hr_api.g_varchar2) then
1179: p_rec.element_information15 :=
1180: pay_etp_shd.g_old_rec.element_information15;
1176: pay_etp_shd.g_old_rec.element_information14;
1177: End If;
1178: If (p_rec.element_information15 = hr_api.g_varchar2) then
1179: p_rec.element_information15 :=
1180: pay_etp_shd.g_old_rec.element_information15;
1181: End If;
1182: If (p_rec.element_information16 = hr_api.g_varchar2) then
1183: p_rec.element_information16 :=
1184: pay_etp_shd.g_old_rec.element_information16;
1180: pay_etp_shd.g_old_rec.element_information15;
1181: End If;
1182: If (p_rec.element_information16 = hr_api.g_varchar2) then
1183: p_rec.element_information16 :=
1184: pay_etp_shd.g_old_rec.element_information16;
1185: End If;
1186: If (p_rec.element_information17 = hr_api.g_varchar2) then
1187: p_rec.element_information17 :=
1188: pay_etp_shd.g_old_rec.element_information17;
1184: pay_etp_shd.g_old_rec.element_information16;
1185: End If;
1186: If (p_rec.element_information17 = hr_api.g_varchar2) then
1187: p_rec.element_information17 :=
1188: pay_etp_shd.g_old_rec.element_information17;
1189: End If;
1190: If (p_rec.element_information18 = hr_api.g_varchar2) then
1191: p_rec.element_information18 :=
1192: pay_etp_shd.g_old_rec.element_information18;
1188: pay_etp_shd.g_old_rec.element_information17;
1189: End If;
1190: If (p_rec.element_information18 = hr_api.g_varchar2) then
1191: p_rec.element_information18 :=
1192: pay_etp_shd.g_old_rec.element_information18;
1193: End If;
1194: If (p_rec.element_information19 = hr_api.g_varchar2) then
1195: p_rec.element_information19 :=
1196: pay_etp_shd.g_old_rec.element_information19;
1192: pay_etp_shd.g_old_rec.element_information18;
1193: End If;
1194: If (p_rec.element_information19 = hr_api.g_varchar2) then
1195: p_rec.element_information19 :=
1196: pay_etp_shd.g_old_rec.element_information19;
1197: End If;
1198: If (p_rec.element_information20 = hr_api.g_varchar2) then
1199: p_rec.element_information20 :=
1200: pay_etp_shd.g_old_rec.element_information20;
1196: pay_etp_shd.g_old_rec.element_information19;
1197: End If;
1198: If (p_rec.element_information20 = hr_api.g_varchar2) then
1199: p_rec.element_information20 :=
1200: pay_etp_shd.g_old_rec.element_information20;
1201: End If;
1202: If (p_rec.third_party_pay_only_flag = hr_api.g_varchar2) then
1203: p_rec.third_party_pay_only_flag :=
1204: pay_etp_shd.g_old_rec.third_party_pay_only_flag;
1200: pay_etp_shd.g_old_rec.element_information20;
1201: End If;
1202: If (p_rec.third_party_pay_only_flag = hr_api.g_varchar2) then
1203: p_rec.third_party_pay_only_flag :=
1204: pay_etp_shd.g_old_rec.third_party_pay_only_flag;
1205: End If;
1206: If (p_rec.iterative_flag = hr_api.g_varchar2) then
1207: p_rec.iterative_flag :=
1208: pay_etp_shd.g_old_rec.iterative_flag;
1204: pay_etp_shd.g_old_rec.third_party_pay_only_flag;
1205: End If;
1206: If (p_rec.iterative_flag = hr_api.g_varchar2) then
1207: p_rec.iterative_flag :=
1208: pay_etp_shd.g_old_rec.iterative_flag;
1209: End If;
1210: If (p_rec.iterative_formula_id = hr_api.g_number) then
1211: p_rec.iterative_formula_id :=
1212: pay_etp_shd.g_old_rec.iterative_formula_id;
1208: pay_etp_shd.g_old_rec.iterative_flag;
1209: End If;
1210: If (p_rec.iterative_formula_id = hr_api.g_number) then
1211: p_rec.iterative_formula_id :=
1212: pay_etp_shd.g_old_rec.iterative_formula_id;
1213: End If;
1214: If (p_rec.iterative_priority = hr_api.g_number) then
1215: p_rec.iterative_priority :=
1216: pay_etp_shd.g_old_rec.iterative_priority;
1212: pay_etp_shd.g_old_rec.iterative_formula_id;
1213: End If;
1214: If (p_rec.iterative_priority = hr_api.g_number) then
1215: p_rec.iterative_priority :=
1216: pay_etp_shd.g_old_rec.iterative_priority;
1217: End If;
1218: If (p_rec.creator_type = hr_api.g_varchar2) then
1219: p_rec.creator_type :=
1220: pay_etp_shd.g_old_rec.creator_type;
1216: pay_etp_shd.g_old_rec.iterative_priority;
1217: End If;
1218: If (p_rec.creator_type = hr_api.g_varchar2) then
1219: p_rec.creator_type :=
1220: pay_etp_shd.g_old_rec.creator_type;
1221: End If;
1222: If (p_rec.retro_summ_ele_id = hr_api.g_number) then
1223: p_rec.retro_summ_ele_id :=
1224: pay_etp_shd.g_old_rec.retro_summ_ele_id;
1220: pay_etp_shd.g_old_rec.creator_type;
1221: End If;
1222: If (p_rec.retro_summ_ele_id = hr_api.g_number) then
1223: p_rec.retro_summ_ele_id :=
1224: pay_etp_shd.g_old_rec.retro_summ_ele_id;
1225: End If;
1226: If (p_rec.grossup_flag = hr_api.g_varchar2) then
1227: p_rec.grossup_flag :=
1228: pay_etp_shd.g_old_rec.grossup_flag;
1224: pay_etp_shd.g_old_rec.retro_summ_ele_id;
1225: End If;
1226: If (p_rec.grossup_flag = hr_api.g_varchar2) then
1227: p_rec.grossup_flag :=
1228: pay_etp_shd.g_old_rec.grossup_flag;
1229: End If;
1230: If (p_rec.process_mode = hr_api.g_varchar2) then
1231: p_rec.process_mode :=
1232: pay_etp_shd.g_old_rec.process_mode;
1228: pay_etp_shd.g_old_rec.grossup_flag;
1229: End If;
1230: If (p_rec.process_mode = hr_api.g_varchar2) then
1231: p_rec.process_mode :=
1232: pay_etp_shd.g_old_rec.process_mode;
1233: End If;
1234: If (p_rec.advance_indicator = hr_api.g_varchar2) then
1235: p_rec.advance_indicator :=
1236: pay_etp_shd.g_old_rec.advance_indicator;
1232: pay_etp_shd.g_old_rec.process_mode;
1233: End If;
1234: If (p_rec.advance_indicator = hr_api.g_varchar2) then
1235: p_rec.advance_indicator :=
1236: pay_etp_shd.g_old_rec.advance_indicator;
1237: End If;
1238: If (p_rec.advance_payable = hr_api.g_varchar2) then
1239: p_rec.advance_payable :=
1240: pay_etp_shd.g_old_rec.advance_payable;
1236: pay_etp_shd.g_old_rec.advance_indicator;
1237: End If;
1238: If (p_rec.advance_payable = hr_api.g_varchar2) then
1239: p_rec.advance_payable :=
1240: pay_etp_shd.g_old_rec.advance_payable;
1241: End If;
1242: If (p_rec.advance_deduction = hr_api.g_varchar2) then
1243: p_rec.advance_deduction :=
1244: pay_etp_shd.g_old_rec.advance_deduction;
1240: pay_etp_shd.g_old_rec.advance_payable;
1241: End If;
1242: If (p_rec.advance_deduction = hr_api.g_varchar2) then
1243: p_rec.advance_deduction :=
1244: pay_etp_shd.g_old_rec.advance_deduction;
1245: End If;
1246: If (p_rec.process_advance_entry = hr_api.g_varchar2) then
1247: p_rec.process_advance_entry :=
1248: pay_etp_shd.g_old_rec.process_advance_entry;
1244: pay_etp_shd.g_old_rec.advance_deduction;
1245: End If;
1246: If (p_rec.process_advance_entry = hr_api.g_varchar2) then
1247: p_rec.process_advance_entry :=
1248: pay_etp_shd.g_old_rec.process_advance_entry;
1249: End If;
1250: If (p_rec.proration_group_id = hr_api.g_number) then
1251: p_rec.proration_group_id :=
1252: pay_etp_shd.g_old_rec.proration_group_id;
1248: pay_etp_shd.g_old_rec.process_advance_entry;
1249: End If;
1250: If (p_rec.proration_group_id = hr_api.g_number) then
1251: p_rec.proration_group_id :=
1252: pay_etp_shd.g_old_rec.proration_group_id;
1253: End If;
1254: If (p_rec.proration_formula_id = hr_api.g_number) then
1255: p_rec.proration_formula_id :=
1256: pay_etp_shd.g_old_rec.proration_formula_id;
1252: pay_etp_shd.g_old_rec.proration_group_id;
1253: End If;
1254: If (p_rec.proration_formula_id = hr_api.g_number) then
1255: p_rec.proration_formula_id :=
1256: pay_etp_shd.g_old_rec.proration_formula_id;
1257: End If;
1258: If (p_rec.recalc_event_group_id = hr_api.g_number) then
1259: p_rec.recalc_event_group_id :=
1260: pay_etp_shd.g_old_rec.recalc_event_group_id;
1256: pay_etp_shd.g_old_rec.proration_formula_id;
1257: End If;
1258: If (p_rec.recalc_event_group_id = hr_api.g_number) then
1259: p_rec.recalc_event_group_id :=
1260: pay_etp_shd.g_old_rec.recalc_event_group_id;
1261: End If;
1262: If (p_rec.once_each_period_flag = hr_api.g_varchar2) then
1263: p_rec.once_each_period_flag :=
1264: pay_etp_shd.g_old_rec.once_each_period_flag;
1260: pay_etp_shd.g_old_rec.recalc_event_group_id;
1261: End If;
1262: If (p_rec.once_each_period_flag = hr_api.g_varchar2) then
1263: p_rec.once_each_period_flag :=
1264: pay_etp_shd.g_old_rec.once_each_period_flag;
1265: End If;
1266: If (p_rec.time_definition_type = hr_api.g_varchar2) then
1267: p_rec.time_definition_type :=
1268: pay_etp_shd.g_old_rec.time_definition_type;
1264: pay_etp_shd.g_old_rec.once_each_period_flag;
1265: End If;
1266: If (p_rec.time_definition_type = hr_api.g_varchar2) then
1267: p_rec.time_definition_type :=
1268: pay_etp_shd.g_old_rec.time_definition_type;
1269: End If;
1270: If (p_rec.time_definition_id = hr_api.g_number) then
1271: p_rec.time_definition_id :=
1272: pay_etp_shd.g_old_rec.time_definition_id;
1268: pay_etp_shd.g_old_rec.time_definition_type;
1269: End If;
1270: If (p_rec.time_definition_id = hr_api.g_number) then
1271: p_rec.time_definition_id :=
1272: pay_etp_shd.g_old_rec.time_definition_id;
1273: End If;
1274: If (p_rec.advance_element_type_id = hr_api.g_number) then
1275: p_rec.advance_element_type_id :=
1276: pay_etp_shd.g_old_rec.advance_element_type_id;
1272: pay_etp_shd.g_old_rec.time_definition_id;
1273: End If;
1274: If (p_rec.advance_element_type_id = hr_api.g_number) then
1275: p_rec.advance_element_type_id :=
1276: pay_etp_shd.g_old_rec.advance_element_type_id;
1277: End If;
1278: If (p_rec.deduction_element_type_id = hr_api.g_number) then
1279: p_rec.deduction_element_type_id :=
1280: pay_etp_shd.g_old_rec.deduction_element_type_id;
1276: pay_etp_shd.g_old_rec.advance_element_type_id;
1277: End If;
1278: If (p_rec.deduction_element_type_id = hr_api.g_number) then
1279: p_rec.deduction_element_type_id :=
1280: pay_etp_shd.g_old_rec.deduction_element_type_id;
1281: End If;
1282: --
1283: End convert_defs;
1284: --
1287: -- ----------------------------------------------------------------------------
1288: Procedure upd
1289: (p_effective_date in date
1290: ,p_datetrack_mode in varchar2
1291: ,p_rec in out nocopy pay_etp_shd.g_rec_type
1292: ,p_processing_priority_warning out nocopy boolean
1293: ) is
1294: --
1295: l_proc varchar2(72) := g_package||'upd';
1306: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1307: --
1308: -- We must lock the row which we need to update.
1309: --
1310: pay_etp_shd.lck
1311: (p_effective_date => p_effective_date
1312: ,p_datetrack_mode => p_datetrack_mode
1313: ,p_element_type_id => p_rec.element_type_id
1314: ,p_object_version_number => p_rec.object_version_number
1474: ,p_comment_id out nocopy number
1475: ,p_processing_priority_warning out nocopy boolean
1476: ) is
1477: --
1478: l_rec pay_etp_shd.g_rec_type;
1479: l_proc varchar2(72) := g_package||'upd';
1480: l_processing_priority_warning boolean;
1481: --
1482: Begin
1485: -- Call conversion function to turn arguments into the
1486: -- l_rec structure.
1487: --
1488: l_rec :=
1489: pay_etp_shd.convert_args
1490: (p_element_type_id
1491: ,null
1492: ,null
1493: ,p_business_group_id