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