[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ---------------------------------------------------------------------------+
57: Procedure dt_update_dml
58: (p_rec in out nocopy pqp_aat_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 => 'assignment_attribute_id'
80: ,p_base_key_value => p_rec.assignment_attribute_id
81: );
82: --
83: pqp_aat_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pqp_assignment_attributes_f Row
86: --
87: update pqp_assignment_attributes_f
169: where assignment_attribute_id = p_rec.assignment_attribute_id
170: and effective_start_date = p_validation_start_date
171: and effective_end_date = p_validation_end_date;
172: --
173: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
174: --
175: -- Set the effective start and end dates
176: --
177: p_rec.effective_start_date := p_validation_start_date;
181: hr_utility.set_location(' Leaving:'||l_proc, 15);
182: Exception
183: When hr_api.check_integrity_violated Then
184: -- A check constraint has been violated
185: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
186: pqp_aat_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
182: Exception
183: When hr_api.check_integrity_violated Then
184: -- A check constraint has been violated
185: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
186: pqp_aat_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
186: pqp_aat_shd.constraint_error
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
191: pqp_aat_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
187: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
188: When hr_api.unique_integrity_violated Then
189: -- Unique integrity has been violated
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
191: pqp_aat_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
195: Raise;
190: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
191: pqp_aat_shd.constraint_error
192: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
193: When Others Then
194: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
195: Raise;
196: End dt_update_dml;
197: --
198: -- ---------------------------------------------------------------------------+
226: --
227: -- {End Of Comments}
228: -- ---------------------------------------------------------------------------+
229: Procedure update_dml
230: (p_rec in out nocopy pqp_aat_shd.g_rec_type
231: ,p_effective_date in date
232: ,p_datetrack_mode in varchar2
233: ,p_validation_start_date in date
234: ,p_validation_end_date in date
293: --
294: -- {End Of Comments}
295: -- ---------------------------------------------------------------------------+
296: Procedure dt_pre_update
297: (p_rec in out nocopy pqp_aat_shd.g_rec_type
298: ,p_effective_date in date
299: ,p_datetrack_mode in varchar2
300: ,p_validation_start_date in date
301: ,p_validation_end_date in date
309: If (p_datetrack_mode <> hr_api.g_correction) then
310: --
311: -- Update the current effective end date
312: --
313: pqp_aat_shd.upd_effective_end_date
314: (p_effective_date => p_effective_date
315: ,p_base_key_value => p_rec.assignment_attribute_id
316: ,p_new_effective_end_date => (p_validation_start_date - 1)
317: ,p_validation_start_date => p_validation_start_date
379: --
380: -- {End Of Comments}
381: -- ---------------------------------------------------------------------------+
382: Procedure pre_update
383: (p_rec in out nocopy pqp_aat_shd.g_rec_type
384: ,p_effective_date in date
385: ,p_datetrack_mode in varchar2
386: ,p_validation_start_date in date
387: ,p_validation_end_date in date
437: --
438: -- {End Of Comments}
439: -- ---------------------------------------------------------------------------+
440: Procedure post_update
441: (p_rec in pqp_aat_shd.g_rec_type
442: ,p_effective_date in date
443: ,p_datetrack_mode in varchar2
444: ,p_validation_start_date in date
445: ,p_validation_end_date in date
624: => p_rec.lgps_trans_arrang_flag
625: ,p_lgps_membership_number
626: => p_rec.lgps_membership_number
627: ,p_effective_start_date_o
628: => pqp_aat_shd.g_old_rec.effective_start_date
629: ,p_effective_end_date_o
630: => pqp_aat_shd.g_old_rec.effective_end_date
631: ,p_business_group_id_o
632: => pqp_aat_shd.g_old_rec.business_group_id
626: => p_rec.lgps_membership_number
627: ,p_effective_start_date_o
628: => pqp_aat_shd.g_old_rec.effective_start_date
629: ,p_effective_end_date_o
630: => pqp_aat_shd.g_old_rec.effective_end_date
631: ,p_business_group_id_o
632: => pqp_aat_shd.g_old_rec.business_group_id
633: ,p_assignment_id_o
634: => pqp_aat_shd.g_old_rec.assignment_id
628: => pqp_aat_shd.g_old_rec.effective_start_date
629: ,p_effective_end_date_o
630: => pqp_aat_shd.g_old_rec.effective_end_date
631: ,p_business_group_id_o
632: => pqp_aat_shd.g_old_rec.business_group_id
633: ,p_assignment_id_o
634: => pqp_aat_shd.g_old_rec.assignment_id
635: ,p_contract_type_o
636: => pqp_aat_shd.g_old_rec.contract_type
630: => pqp_aat_shd.g_old_rec.effective_end_date
631: ,p_business_group_id_o
632: => pqp_aat_shd.g_old_rec.business_group_id
633: ,p_assignment_id_o
634: => pqp_aat_shd.g_old_rec.assignment_id
635: ,p_contract_type_o
636: => pqp_aat_shd.g_old_rec.contract_type
637: ,p_work_pattern_o
638: => pqp_aat_shd.g_old_rec.work_pattern
632: => pqp_aat_shd.g_old_rec.business_group_id
633: ,p_assignment_id_o
634: => pqp_aat_shd.g_old_rec.assignment_id
635: ,p_contract_type_o
636: => pqp_aat_shd.g_old_rec.contract_type
637: ,p_work_pattern_o
638: => pqp_aat_shd.g_old_rec.work_pattern
639: ,p_start_day_o
640: => pqp_aat_shd.g_old_rec.start_day
634: => pqp_aat_shd.g_old_rec.assignment_id
635: ,p_contract_type_o
636: => pqp_aat_shd.g_old_rec.contract_type
637: ,p_work_pattern_o
638: => pqp_aat_shd.g_old_rec.work_pattern
639: ,p_start_day_o
640: => pqp_aat_shd.g_old_rec.start_day
641: ,p_object_version_number_o
642: => pqp_aat_shd.g_old_rec.object_version_number
636: => pqp_aat_shd.g_old_rec.contract_type
637: ,p_work_pattern_o
638: => pqp_aat_shd.g_old_rec.work_pattern
639: ,p_start_day_o
640: => pqp_aat_shd.g_old_rec.start_day
641: ,p_object_version_number_o
642: => pqp_aat_shd.g_old_rec.object_version_number
643: ,p_primary_company_car_o
644: => pqp_aat_shd.g_old_rec.primary_company_car
638: => pqp_aat_shd.g_old_rec.work_pattern
639: ,p_start_day_o
640: => pqp_aat_shd.g_old_rec.start_day
641: ,p_object_version_number_o
642: => pqp_aat_shd.g_old_rec.object_version_number
643: ,p_primary_company_car_o
644: => pqp_aat_shd.g_old_rec.primary_company_car
645: ,p_primary_car_fuel_benefit_o
646: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
640: => pqp_aat_shd.g_old_rec.start_day
641: ,p_object_version_number_o
642: => pqp_aat_shd.g_old_rec.object_version_number
643: ,p_primary_company_car_o
644: => pqp_aat_shd.g_old_rec.primary_company_car
645: ,p_primary_car_fuel_benefit_o
646: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
647: ,p_primary_class_1a_o
648: => pqp_aat_shd.g_old_rec.primary_class_1a
642: => pqp_aat_shd.g_old_rec.object_version_number
643: ,p_primary_company_car_o
644: => pqp_aat_shd.g_old_rec.primary_company_car
645: ,p_primary_car_fuel_benefit_o
646: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
647: ,p_primary_class_1a_o
648: => pqp_aat_shd.g_old_rec.primary_class_1a
649: ,p_primary_capital_contributi_o
650: => pqp_aat_shd.g_old_rec.primary_capital_contribution
644: => pqp_aat_shd.g_old_rec.primary_company_car
645: ,p_primary_car_fuel_benefit_o
646: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
647: ,p_primary_class_1a_o
648: => pqp_aat_shd.g_old_rec.primary_class_1a
649: ,p_primary_capital_contributi_o
650: => pqp_aat_shd.g_old_rec.primary_capital_contribution
651: ,p_primary_private_contributi_o
652: => pqp_aat_shd.g_old_rec.primary_private_contribution
646: => pqp_aat_shd.g_old_rec.primary_car_fuel_benefit
647: ,p_primary_class_1a_o
648: => pqp_aat_shd.g_old_rec.primary_class_1a
649: ,p_primary_capital_contributi_o
650: => pqp_aat_shd.g_old_rec.primary_capital_contribution
651: ,p_primary_private_contributi_o
652: => pqp_aat_shd.g_old_rec.primary_private_contribution
653: ,p_secondary_company_car_o
654: => pqp_aat_shd.g_old_rec.secondary_company_car
648: => pqp_aat_shd.g_old_rec.primary_class_1a
649: ,p_primary_capital_contributi_o
650: => pqp_aat_shd.g_old_rec.primary_capital_contribution
651: ,p_primary_private_contributi_o
652: => pqp_aat_shd.g_old_rec.primary_private_contribution
653: ,p_secondary_company_car_o
654: => pqp_aat_shd.g_old_rec.secondary_company_car
655: ,p_secondary_car_fuel_benefit_o
656: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
650: => pqp_aat_shd.g_old_rec.primary_capital_contribution
651: ,p_primary_private_contributi_o
652: => pqp_aat_shd.g_old_rec.primary_private_contribution
653: ,p_secondary_company_car_o
654: => pqp_aat_shd.g_old_rec.secondary_company_car
655: ,p_secondary_car_fuel_benefit_o
656: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
657: ,p_secondary_class_1a_o
658: => pqp_aat_shd.g_old_rec.secondary_class_1a
652: => pqp_aat_shd.g_old_rec.primary_private_contribution
653: ,p_secondary_company_car_o
654: => pqp_aat_shd.g_old_rec.secondary_company_car
655: ,p_secondary_car_fuel_benefit_o
656: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
657: ,p_secondary_class_1a_o
658: => pqp_aat_shd.g_old_rec.secondary_class_1a
659: ,p_secondary_capital_contribu_o
660: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
654: => pqp_aat_shd.g_old_rec.secondary_company_car
655: ,p_secondary_car_fuel_benefit_o
656: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
657: ,p_secondary_class_1a_o
658: => pqp_aat_shd.g_old_rec.secondary_class_1a
659: ,p_secondary_capital_contribu_o
660: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
661: ,p_secondary_private_contribu_o
662: => pqp_aat_shd.g_old_rec.secondary_private_contribution
656: => pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit
657: ,p_secondary_class_1a_o
658: => pqp_aat_shd.g_old_rec.secondary_class_1a
659: ,p_secondary_capital_contribu_o
660: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
661: ,p_secondary_private_contribu_o
662: => pqp_aat_shd.g_old_rec.secondary_private_contribution
663: ,p_company_car_calc_method_o
664: => pqp_aat_shd.g_old_rec.company_car_calc_method
658: => pqp_aat_shd.g_old_rec.secondary_class_1a
659: ,p_secondary_capital_contribu_o
660: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
661: ,p_secondary_private_contribu_o
662: => pqp_aat_shd.g_old_rec.secondary_private_contribution
663: ,p_company_car_calc_method_o
664: => pqp_aat_shd.g_old_rec.company_car_calc_method
665: ,p_company_car_rates_table_id_o
666: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
660: => pqp_aat_shd.g_old_rec.secondary_capital_contribution
661: ,p_secondary_private_contribu_o
662: => pqp_aat_shd.g_old_rec.secondary_private_contribution
663: ,p_company_car_calc_method_o
664: => pqp_aat_shd.g_old_rec.company_car_calc_method
665: ,p_company_car_rates_table_id_o
666: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
667: ,p_company_car_secondary_tabl_o
668: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
662: => pqp_aat_shd.g_old_rec.secondary_private_contribution
663: ,p_company_car_calc_method_o
664: => pqp_aat_shd.g_old_rec.company_car_calc_method
665: ,p_company_car_rates_table_id_o
666: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
667: ,p_company_car_secondary_tabl_o
668: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
669: ,p_private_car_o
670: => pqp_aat_shd.g_old_rec.private_car
664: => pqp_aat_shd.g_old_rec.company_car_calc_method
665: ,p_company_car_rates_table_id_o
666: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
667: ,p_company_car_secondary_tabl_o
668: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
669: ,p_private_car_o
670: => pqp_aat_shd.g_old_rec.private_car
671: ,p_private_car_calc_method_o
672: => pqp_aat_shd.g_old_rec.private_car_calc_method
666: => pqp_aat_shd.g_old_rec.company_car_rates_table_id
667: ,p_company_car_secondary_tabl_o
668: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
669: ,p_private_car_o
670: => pqp_aat_shd.g_old_rec.private_car
671: ,p_private_car_calc_method_o
672: => pqp_aat_shd.g_old_rec.private_car_calc_method
673: ,p_private_car_rates_table_id_o
674: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
668: => pqp_aat_shd.g_old_rec.company_car_secondary_table_id
669: ,p_private_car_o
670: => pqp_aat_shd.g_old_rec.private_car
671: ,p_private_car_calc_method_o
672: => pqp_aat_shd.g_old_rec.private_car_calc_method
673: ,p_private_car_rates_table_id_o
674: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
675: ,p_private_car_essential_tabl_o
676: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
670: => pqp_aat_shd.g_old_rec.private_car
671: ,p_private_car_calc_method_o
672: => pqp_aat_shd.g_old_rec.private_car_calc_method
673: ,p_private_car_rates_table_id_o
674: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
675: ,p_private_car_essential_tabl_o
676: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
677: ,p_tp_is_teacher_o
678: => pqp_aat_shd.g_old_rec.tp_is_teacher
672: => pqp_aat_shd.g_old_rec.private_car_calc_method
673: ,p_private_car_rates_table_id_o
674: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
675: ,p_private_car_essential_tabl_o
676: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
677: ,p_tp_is_teacher_o
678: => pqp_aat_shd.g_old_rec.tp_is_teacher
679: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
680: =>pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
674: => pqp_aat_shd.g_old_rec.private_car_rates_table_id
675: ,p_private_car_essential_tabl_o
676: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
677: ,p_tp_is_teacher_o
678: => pqp_aat_shd.g_old_rec.tp_is_teacher
679: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
680: =>pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
681: ,p_tp_safeguarded_grade_o
682: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
676: => pqp_aat_shd.g_old_rec.private_car_essential_table_id
677: ,p_tp_is_teacher_o
678: => pqp_aat_shd.g_old_rec.tp_is_teacher
679: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
680: =>pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
681: ,p_tp_safeguarded_grade_o
682: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
683: ,p_tp_safeguarded_grade_id_o
684: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
678: => pqp_aat_shd.g_old_rec.tp_is_teacher
679: ,p_tp_headteacher_grp_code_o --added for head Teacher seconded location for salary scale calculation
680: =>pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
681: ,p_tp_safeguarded_grade_o
682: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
683: ,p_tp_safeguarded_grade_id_o
684: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
685: ,p_tp_safeguarded_rate_type_o
686: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
680: =>pqp_aat_shd.g_old_rec.tp_headteacher_grp_code
681: ,p_tp_safeguarded_grade_o
682: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
683: ,p_tp_safeguarded_grade_id_o
684: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
685: ,p_tp_safeguarded_rate_type_o
686: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
687: ,p_tp_safeguarded_rate_id_o
688: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
682: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade
683: ,p_tp_safeguarded_grade_id_o
684: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
685: ,p_tp_safeguarded_rate_type_o
686: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
687: ,p_tp_safeguarded_rate_id_o
688: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
689: ,p_tp_spinal_point_id_o
690: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
684: => pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id
685: ,p_tp_safeguarded_rate_type_o
686: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
687: ,p_tp_safeguarded_rate_id_o
688: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
689: ,p_tp_spinal_point_id_o
690: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
691: ,p_tp_elected_pension_o
692: => pqp_aat_shd.g_old_rec.tp_elected_pension
686: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type
687: ,p_tp_safeguarded_rate_id_o
688: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
689: ,p_tp_spinal_point_id_o
690: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
691: ,p_tp_elected_pension_o
692: => pqp_aat_shd.g_old_rec.tp_elected_pension
693: ,p_tp_fast_track_o
694: => pqp_aat_shd.g_old_rec.tp_fast_track
688: => pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id
689: ,p_tp_spinal_point_id_o
690: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
691: ,p_tp_elected_pension_o
692: => pqp_aat_shd.g_old_rec.tp_elected_pension
693: ,p_tp_fast_track_o
694: => pqp_aat_shd.g_old_rec.tp_fast_track
695: ,p_aat_attribute_category_o
696: => pqp_aat_shd.g_old_rec.aat_attribute_category
690: => pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id
691: ,p_tp_elected_pension_o
692: => pqp_aat_shd.g_old_rec.tp_elected_pension
693: ,p_tp_fast_track_o
694: => pqp_aat_shd.g_old_rec.tp_fast_track
695: ,p_aat_attribute_category_o
696: => pqp_aat_shd.g_old_rec.aat_attribute_category
697: ,p_aat_attribute1_o
698: => pqp_aat_shd.g_old_rec.aat_attribute1
692: => pqp_aat_shd.g_old_rec.tp_elected_pension
693: ,p_tp_fast_track_o
694: => pqp_aat_shd.g_old_rec.tp_fast_track
695: ,p_aat_attribute_category_o
696: => pqp_aat_shd.g_old_rec.aat_attribute_category
697: ,p_aat_attribute1_o
698: => pqp_aat_shd.g_old_rec.aat_attribute1
699: ,p_aat_attribute2_o
700: => pqp_aat_shd.g_old_rec.aat_attribute2
694: => pqp_aat_shd.g_old_rec.tp_fast_track
695: ,p_aat_attribute_category_o
696: => pqp_aat_shd.g_old_rec.aat_attribute_category
697: ,p_aat_attribute1_o
698: => pqp_aat_shd.g_old_rec.aat_attribute1
699: ,p_aat_attribute2_o
700: => pqp_aat_shd.g_old_rec.aat_attribute2
701: ,p_aat_attribute3_o
702: => pqp_aat_shd.g_old_rec.aat_attribute3
696: => pqp_aat_shd.g_old_rec.aat_attribute_category
697: ,p_aat_attribute1_o
698: => pqp_aat_shd.g_old_rec.aat_attribute1
699: ,p_aat_attribute2_o
700: => pqp_aat_shd.g_old_rec.aat_attribute2
701: ,p_aat_attribute3_o
702: => pqp_aat_shd.g_old_rec.aat_attribute3
703: ,p_aat_attribute4_o
704: => pqp_aat_shd.g_old_rec.aat_attribute4
698: => pqp_aat_shd.g_old_rec.aat_attribute1
699: ,p_aat_attribute2_o
700: => pqp_aat_shd.g_old_rec.aat_attribute2
701: ,p_aat_attribute3_o
702: => pqp_aat_shd.g_old_rec.aat_attribute3
703: ,p_aat_attribute4_o
704: => pqp_aat_shd.g_old_rec.aat_attribute4
705: ,p_aat_attribute5_o
706: => pqp_aat_shd.g_old_rec.aat_attribute5
700: => pqp_aat_shd.g_old_rec.aat_attribute2
701: ,p_aat_attribute3_o
702: => pqp_aat_shd.g_old_rec.aat_attribute3
703: ,p_aat_attribute4_o
704: => pqp_aat_shd.g_old_rec.aat_attribute4
705: ,p_aat_attribute5_o
706: => pqp_aat_shd.g_old_rec.aat_attribute5
707: ,p_aat_attribute6_o
708: => pqp_aat_shd.g_old_rec.aat_attribute6
702: => pqp_aat_shd.g_old_rec.aat_attribute3
703: ,p_aat_attribute4_o
704: => pqp_aat_shd.g_old_rec.aat_attribute4
705: ,p_aat_attribute5_o
706: => pqp_aat_shd.g_old_rec.aat_attribute5
707: ,p_aat_attribute6_o
708: => pqp_aat_shd.g_old_rec.aat_attribute6
709: ,p_aat_attribute7_o
710: => pqp_aat_shd.g_old_rec.aat_attribute7
704: => pqp_aat_shd.g_old_rec.aat_attribute4
705: ,p_aat_attribute5_o
706: => pqp_aat_shd.g_old_rec.aat_attribute5
707: ,p_aat_attribute6_o
708: => pqp_aat_shd.g_old_rec.aat_attribute6
709: ,p_aat_attribute7_o
710: => pqp_aat_shd.g_old_rec.aat_attribute7
711: ,p_aat_attribute8_o
712: => pqp_aat_shd.g_old_rec.aat_attribute8
706: => pqp_aat_shd.g_old_rec.aat_attribute5
707: ,p_aat_attribute6_o
708: => pqp_aat_shd.g_old_rec.aat_attribute6
709: ,p_aat_attribute7_o
710: => pqp_aat_shd.g_old_rec.aat_attribute7
711: ,p_aat_attribute8_o
712: => pqp_aat_shd.g_old_rec.aat_attribute8
713: ,p_aat_attribute9_o
714: => pqp_aat_shd.g_old_rec.aat_attribute9
708: => pqp_aat_shd.g_old_rec.aat_attribute6
709: ,p_aat_attribute7_o
710: => pqp_aat_shd.g_old_rec.aat_attribute7
711: ,p_aat_attribute8_o
712: => pqp_aat_shd.g_old_rec.aat_attribute8
713: ,p_aat_attribute9_o
714: => pqp_aat_shd.g_old_rec.aat_attribute9
715: ,p_aat_attribute10_o
716: => pqp_aat_shd.g_old_rec.aat_attribute10
710: => pqp_aat_shd.g_old_rec.aat_attribute7
711: ,p_aat_attribute8_o
712: => pqp_aat_shd.g_old_rec.aat_attribute8
713: ,p_aat_attribute9_o
714: => pqp_aat_shd.g_old_rec.aat_attribute9
715: ,p_aat_attribute10_o
716: => pqp_aat_shd.g_old_rec.aat_attribute10
717: ,p_aat_attribute11_o
718: => pqp_aat_shd.g_old_rec.aat_attribute11
712: => pqp_aat_shd.g_old_rec.aat_attribute8
713: ,p_aat_attribute9_o
714: => pqp_aat_shd.g_old_rec.aat_attribute9
715: ,p_aat_attribute10_o
716: => pqp_aat_shd.g_old_rec.aat_attribute10
717: ,p_aat_attribute11_o
718: => pqp_aat_shd.g_old_rec.aat_attribute11
719: ,p_aat_attribute12_o
720: => pqp_aat_shd.g_old_rec.aat_attribute12
714: => pqp_aat_shd.g_old_rec.aat_attribute9
715: ,p_aat_attribute10_o
716: => pqp_aat_shd.g_old_rec.aat_attribute10
717: ,p_aat_attribute11_o
718: => pqp_aat_shd.g_old_rec.aat_attribute11
719: ,p_aat_attribute12_o
720: => pqp_aat_shd.g_old_rec.aat_attribute12
721: ,p_aat_attribute13_o
722: => pqp_aat_shd.g_old_rec.aat_attribute13
716: => pqp_aat_shd.g_old_rec.aat_attribute10
717: ,p_aat_attribute11_o
718: => pqp_aat_shd.g_old_rec.aat_attribute11
719: ,p_aat_attribute12_o
720: => pqp_aat_shd.g_old_rec.aat_attribute12
721: ,p_aat_attribute13_o
722: => pqp_aat_shd.g_old_rec.aat_attribute13
723: ,p_aat_attribute14_o
724: => pqp_aat_shd.g_old_rec.aat_attribute14
718: => pqp_aat_shd.g_old_rec.aat_attribute11
719: ,p_aat_attribute12_o
720: => pqp_aat_shd.g_old_rec.aat_attribute12
721: ,p_aat_attribute13_o
722: => pqp_aat_shd.g_old_rec.aat_attribute13
723: ,p_aat_attribute14_o
724: => pqp_aat_shd.g_old_rec.aat_attribute14
725: ,p_aat_attribute15_o
726: => pqp_aat_shd.g_old_rec.aat_attribute15
720: => pqp_aat_shd.g_old_rec.aat_attribute12
721: ,p_aat_attribute13_o
722: => pqp_aat_shd.g_old_rec.aat_attribute13
723: ,p_aat_attribute14_o
724: => pqp_aat_shd.g_old_rec.aat_attribute14
725: ,p_aat_attribute15_o
726: => pqp_aat_shd.g_old_rec.aat_attribute15
727: ,p_aat_attribute16_o
728: => pqp_aat_shd.g_old_rec.aat_attribute16
722: => pqp_aat_shd.g_old_rec.aat_attribute13
723: ,p_aat_attribute14_o
724: => pqp_aat_shd.g_old_rec.aat_attribute14
725: ,p_aat_attribute15_o
726: => pqp_aat_shd.g_old_rec.aat_attribute15
727: ,p_aat_attribute16_o
728: => pqp_aat_shd.g_old_rec.aat_attribute16
729: ,p_aat_attribute17_o
730: => pqp_aat_shd.g_old_rec.aat_attribute17
724: => pqp_aat_shd.g_old_rec.aat_attribute14
725: ,p_aat_attribute15_o
726: => pqp_aat_shd.g_old_rec.aat_attribute15
727: ,p_aat_attribute16_o
728: => pqp_aat_shd.g_old_rec.aat_attribute16
729: ,p_aat_attribute17_o
730: => pqp_aat_shd.g_old_rec.aat_attribute17
731: ,p_aat_attribute18_o
732: => pqp_aat_shd.g_old_rec.aat_attribute18
726: => pqp_aat_shd.g_old_rec.aat_attribute15
727: ,p_aat_attribute16_o
728: => pqp_aat_shd.g_old_rec.aat_attribute16
729: ,p_aat_attribute17_o
730: => pqp_aat_shd.g_old_rec.aat_attribute17
731: ,p_aat_attribute18_o
732: => pqp_aat_shd.g_old_rec.aat_attribute18
733: ,p_aat_attribute19_o
734: => pqp_aat_shd.g_old_rec.aat_attribute19
728: => pqp_aat_shd.g_old_rec.aat_attribute16
729: ,p_aat_attribute17_o
730: => pqp_aat_shd.g_old_rec.aat_attribute17
731: ,p_aat_attribute18_o
732: => pqp_aat_shd.g_old_rec.aat_attribute18
733: ,p_aat_attribute19_o
734: => pqp_aat_shd.g_old_rec.aat_attribute19
735: ,p_aat_attribute20_o
736: => pqp_aat_shd.g_old_rec.aat_attribute20
730: => pqp_aat_shd.g_old_rec.aat_attribute17
731: ,p_aat_attribute18_o
732: => pqp_aat_shd.g_old_rec.aat_attribute18
733: ,p_aat_attribute19_o
734: => pqp_aat_shd.g_old_rec.aat_attribute19
735: ,p_aat_attribute20_o
736: => pqp_aat_shd.g_old_rec.aat_attribute20
737: ,p_aat_information_category_o
738: => pqp_aat_shd.g_old_rec.aat_information_category
732: => pqp_aat_shd.g_old_rec.aat_attribute18
733: ,p_aat_attribute19_o
734: => pqp_aat_shd.g_old_rec.aat_attribute19
735: ,p_aat_attribute20_o
736: => pqp_aat_shd.g_old_rec.aat_attribute20
737: ,p_aat_information_category_o
738: => pqp_aat_shd.g_old_rec.aat_information_category
739: ,p_aat_information1_o
740: => pqp_aat_shd.g_old_rec.aat_information1
734: => pqp_aat_shd.g_old_rec.aat_attribute19
735: ,p_aat_attribute20_o
736: => pqp_aat_shd.g_old_rec.aat_attribute20
737: ,p_aat_information_category_o
738: => pqp_aat_shd.g_old_rec.aat_information_category
739: ,p_aat_information1_o
740: => pqp_aat_shd.g_old_rec.aat_information1
741: ,p_aat_information2_o
742: => pqp_aat_shd.g_old_rec.aat_information2
736: => pqp_aat_shd.g_old_rec.aat_attribute20
737: ,p_aat_information_category_o
738: => pqp_aat_shd.g_old_rec.aat_information_category
739: ,p_aat_information1_o
740: => pqp_aat_shd.g_old_rec.aat_information1
741: ,p_aat_information2_o
742: => pqp_aat_shd.g_old_rec.aat_information2
743: ,p_aat_information3_o
744: => pqp_aat_shd.g_old_rec.aat_information3
738: => pqp_aat_shd.g_old_rec.aat_information_category
739: ,p_aat_information1_o
740: => pqp_aat_shd.g_old_rec.aat_information1
741: ,p_aat_information2_o
742: => pqp_aat_shd.g_old_rec.aat_information2
743: ,p_aat_information3_o
744: => pqp_aat_shd.g_old_rec.aat_information3
745: ,p_aat_information4_o
746: => pqp_aat_shd.g_old_rec.aat_information4
740: => pqp_aat_shd.g_old_rec.aat_information1
741: ,p_aat_information2_o
742: => pqp_aat_shd.g_old_rec.aat_information2
743: ,p_aat_information3_o
744: => pqp_aat_shd.g_old_rec.aat_information3
745: ,p_aat_information4_o
746: => pqp_aat_shd.g_old_rec.aat_information4
747: ,p_aat_information5_o
748: => pqp_aat_shd.g_old_rec.aat_information5
742: => pqp_aat_shd.g_old_rec.aat_information2
743: ,p_aat_information3_o
744: => pqp_aat_shd.g_old_rec.aat_information3
745: ,p_aat_information4_o
746: => pqp_aat_shd.g_old_rec.aat_information4
747: ,p_aat_information5_o
748: => pqp_aat_shd.g_old_rec.aat_information5
749: ,p_aat_information6_o
750: => pqp_aat_shd.g_old_rec.aat_information6
744: => pqp_aat_shd.g_old_rec.aat_information3
745: ,p_aat_information4_o
746: => pqp_aat_shd.g_old_rec.aat_information4
747: ,p_aat_information5_o
748: => pqp_aat_shd.g_old_rec.aat_information5
749: ,p_aat_information6_o
750: => pqp_aat_shd.g_old_rec.aat_information6
751: ,p_aat_information7_o
752: => pqp_aat_shd.g_old_rec.aat_information7
746: => pqp_aat_shd.g_old_rec.aat_information4
747: ,p_aat_information5_o
748: => pqp_aat_shd.g_old_rec.aat_information5
749: ,p_aat_information6_o
750: => pqp_aat_shd.g_old_rec.aat_information6
751: ,p_aat_information7_o
752: => pqp_aat_shd.g_old_rec.aat_information7
753: ,p_aat_information8_o
754: => pqp_aat_shd.g_old_rec.aat_information8
748: => pqp_aat_shd.g_old_rec.aat_information5
749: ,p_aat_information6_o
750: => pqp_aat_shd.g_old_rec.aat_information6
751: ,p_aat_information7_o
752: => pqp_aat_shd.g_old_rec.aat_information7
753: ,p_aat_information8_o
754: => pqp_aat_shd.g_old_rec.aat_information8
755: ,p_aat_information9_o
756: => pqp_aat_shd.g_old_rec.aat_information9
750: => pqp_aat_shd.g_old_rec.aat_information6
751: ,p_aat_information7_o
752: => pqp_aat_shd.g_old_rec.aat_information7
753: ,p_aat_information8_o
754: => pqp_aat_shd.g_old_rec.aat_information8
755: ,p_aat_information9_o
756: => pqp_aat_shd.g_old_rec.aat_information9
757: ,p_aat_information10_o
758: => pqp_aat_shd.g_old_rec.aat_information10
752: => pqp_aat_shd.g_old_rec.aat_information7
753: ,p_aat_information8_o
754: => pqp_aat_shd.g_old_rec.aat_information8
755: ,p_aat_information9_o
756: => pqp_aat_shd.g_old_rec.aat_information9
757: ,p_aat_information10_o
758: => pqp_aat_shd.g_old_rec.aat_information10
759: ,p_aat_information11_o
760: => pqp_aat_shd.g_old_rec.aat_information11
754: => pqp_aat_shd.g_old_rec.aat_information8
755: ,p_aat_information9_o
756: => pqp_aat_shd.g_old_rec.aat_information9
757: ,p_aat_information10_o
758: => pqp_aat_shd.g_old_rec.aat_information10
759: ,p_aat_information11_o
760: => pqp_aat_shd.g_old_rec.aat_information11
761: ,p_aat_information12_o
762: => pqp_aat_shd.g_old_rec.aat_information12
756: => pqp_aat_shd.g_old_rec.aat_information9
757: ,p_aat_information10_o
758: => pqp_aat_shd.g_old_rec.aat_information10
759: ,p_aat_information11_o
760: => pqp_aat_shd.g_old_rec.aat_information11
761: ,p_aat_information12_o
762: => pqp_aat_shd.g_old_rec.aat_information12
763: ,p_aat_information13_o
764: => pqp_aat_shd.g_old_rec.aat_information13
758: => pqp_aat_shd.g_old_rec.aat_information10
759: ,p_aat_information11_o
760: => pqp_aat_shd.g_old_rec.aat_information11
761: ,p_aat_information12_o
762: => pqp_aat_shd.g_old_rec.aat_information12
763: ,p_aat_information13_o
764: => pqp_aat_shd.g_old_rec.aat_information13
765: ,p_aat_information14_o
766: => pqp_aat_shd.g_old_rec.aat_information14
760: => pqp_aat_shd.g_old_rec.aat_information11
761: ,p_aat_information12_o
762: => pqp_aat_shd.g_old_rec.aat_information12
763: ,p_aat_information13_o
764: => pqp_aat_shd.g_old_rec.aat_information13
765: ,p_aat_information14_o
766: => pqp_aat_shd.g_old_rec.aat_information14
767: ,p_aat_information15_o
768: => pqp_aat_shd.g_old_rec.aat_information15
762: => pqp_aat_shd.g_old_rec.aat_information12
763: ,p_aat_information13_o
764: => pqp_aat_shd.g_old_rec.aat_information13
765: ,p_aat_information14_o
766: => pqp_aat_shd.g_old_rec.aat_information14
767: ,p_aat_information15_o
768: => pqp_aat_shd.g_old_rec.aat_information15
769: ,p_aat_information16_o
770: => pqp_aat_shd.g_old_rec.aat_information16
764: => pqp_aat_shd.g_old_rec.aat_information13
765: ,p_aat_information14_o
766: => pqp_aat_shd.g_old_rec.aat_information14
767: ,p_aat_information15_o
768: => pqp_aat_shd.g_old_rec.aat_information15
769: ,p_aat_information16_o
770: => pqp_aat_shd.g_old_rec.aat_information16
771: ,p_aat_information17_o
772: => pqp_aat_shd.g_old_rec.aat_information17
766: => pqp_aat_shd.g_old_rec.aat_information14
767: ,p_aat_information15_o
768: => pqp_aat_shd.g_old_rec.aat_information15
769: ,p_aat_information16_o
770: => pqp_aat_shd.g_old_rec.aat_information16
771: ,p_aat_information17_o
772: => pqp_aat_shd.g_old_rec.aat_information17
773: ,p_aat_information18_o
774: => pqp_aat_shd.g_old_rec.aat_information18
768: => pqp_aat_shd.g_old_rec.aat_information15
769: ,p_aat_information16_o
770: => pqp_aat_shd.g_old_rec.aat_information16
771: ,p_aat_information17_o
772: => pqp_aat_shd.g_old_rec.aat_information17
773: ,p_aat_information18_o
774: => pqp_aat_shd.g_old_rec.aat_information18
775: ,p_aat_information19_o
776: => pqp_aat_shd.g_old_rec.aat_information19
770: => pqp_aat_shd.g_old_rec.aat_information16
771: ,p_aat_information17_o
772: => pqp_aat_shd.g_old_rec.aat_information17
773: ,p_aat_information18_o
774: => pqp_aat_shd.g_old_rec.aat_information18
775: ,p_aat_information19_o
776: => pqp_aat_shd.g_old_rec.aat_information19
777: ,p_aat_information20_o
778: => pqp_aat_shd.g_old_rec.aat_information20
772: => pqp_aat_shd.g_old_rec.aat_information17
773: ,p_aat_information18_o
774: => pqp_aat_shd.g_old_rec.aat_information18
775: ,p_aat_information19_o
776: => pqp_aat_shd.g_old_rec.aat_information19
777: ,p_aat_information20_o
778: => pqp_aat_shd.g_old_rec.aat_information20
779: ,p_lgps_process_flag_o
780: => pqp_aat_shd.g_old_rec.lgps_process_flag
774: => pqp_aat_shd.g_old_rec.aat_information18
775: ,p_aat_information19_o
776: => pqp_aat_shd.g_old_rec.aat_information19
777: ,p_aat_information20_o
778: => pqp_aat_shd.g_old_rec.aat_information20
779: ,p_lgps_process_flag_o
780: => pqp_aat_shd.g_old_rec.lgps_process_flag
781: ,p_lgps_exclusion_type_o
782: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
776: => pqp_aat_shd.g_old_rec.aat_information19
777: ,p_aat_information20_o
778: => pqp_aat_shd.g_old_rec.aat_information20
779: ,p_lgps_process_flag_o
780: => pqp_aat_shd.g_old_rec.lgps_process_flag
781: ,p_lgps_exclusion_type_o
782: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
783: ,p_lgps_pensionable_pay_o
784: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
778: => pqp_aat_shd.g_old_rec.aat_information20
779: ,p_lgps_process_flag_o
780: => pqp_aat_shd.g_old_rec.lgps_process_flag
781: ,p_lgps_exclusion_type_o
782: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
783: ,p_lgps_pensionable_pay_o
784: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
785: ,p_lgps_trans_arrang_flag_o
786: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
780: => pqp_aat_shd.g_old_rec.lgps_process_flag
781: ,p_lgps_exclusion_type_o
782: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
783: ,p_lgps_pensionable_pay_o
784: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
785: ,p_lgps_trans_arrang_flag_o
786: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
787: ,p_lgps_membership_number_o
788: => pqp_aat_shd.g_old_rec.lgps_membership_number
782: => pqp_aat_shd.g_old_rec.lgps_exclusion_type
783: ,p_lgps_pensionable_pay_o
784: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
785: ,p_lgps_trans_arrang_flag_o
786: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
787: ,p_lgps_membership_number_o
788: => pqp_aat_shd.g_old_rec.lgps_membership_number
789: );
790: --
784: => pqp_aat_shd.g_old_rec.lgps_pensionable_pay
785: ,p_lgps_trans_arrang_flag_o
786: => pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag
787: ,p_lgps_membership_number_o
788: => pqp_aat_shd.g_old_rec.lgps_membership_number
789: );
790: --
791: exception
792: --
844: --
845: -- {End Of Comments}
846: -- ---------------------------------------------------------------------------+
847: Procedure convert_defs
848: (p_rec in out nocopy pqp_aat_shd.g_rec_type
849: ) is
850: --
851: Begin
852: --
856: -- is being used then we must set to the 'current' argument value.
857: --
858: If (p_rec.business_group_id = hr_api.g_number) then
859: p_rec.business_group_id :=
860: pqp_aat_shd.g_old_rec.business_group_id;
861: End If;
862: If (p_rec.assignment_id = hr_api.g_number) then
863: p_rec.assignment_id :=
864: pqp_aat_shd.g_old_rec.assignment_id;
860: pqp_aat_shd.g_old_rec.business_group_id;
861: End If;
862: If (p_rec.assignment_id = hr_api.g_number) then
863: p_rec.assignment_id :=
864: pqp_aat_shd.g_old_rec.assignment_id;
865: End If;
866: If (p_rec.contract_type = hr_api.g_varchar2) then
867: p_rec.contract_type :=
868: pqp_aat_shd.g_old_rec.contract_type;
864: pqp_aat_shd.g_old_rec.assignment_id;
865: End If;
866: If (p_rec.contract_type = hr_api.g_varchar2) then
867: p_rec.contract_type :=
868: pqp_aat_shd.g_old_rec.contract_type;
869: End If;
870: If (p_rec.work_pattern = hr_api.g_varchar2) then
871: p_rec.work_pattern :=
872: pqp_aat_shd.g_old_rec.work_pattern;
868: pqp_aat_shd.g_old_rec.contract_type;
869: End If;
870: If (p_rec.work_pattern = hr_api.g_varchar2) then
871: p_rec.work_pattern :=
872: pqp_aat_shd.g_old_rec.work_pattern;
873: End If;
874: If (p_rec.start_day = hr_api.g_varchar2) then
875: p_rec.start_day :=
876: pqp_aat_shd.g_old_rec.start_day;
872: pqp_aat_shd.g_old_rec.work_pattern;
873: End If;
874: If (p_rec.start_day = hr_api.g_varchar2) then
875: p_rec.start_day :=
876: pqp_aat_shd.g_old_rec.start_day;
877: End If;
878: If (p_rec.primary_company_car = hr_api.g_number) then
879: p_rec.primary_company_car :=
880: pqp_aat_shd.g_old_rec.primary_company_car;
876: pqp_aat_shd.g_old_rec.start_day;
877: End If;
878: If (p_rec.primary_company_car = hr_api.g_number) then
879: p_rec.primary_company_car :=
880: pqp_aat_shd.g_old_rec.primary_company_car;
881: End If;
882: If (p_rec.primary_car_fuel_benefit = hr_api.g_varchar2) then
883: p_rec.primary_car_fuel_benefit :=
884: pqp_aat_shd.g_old_rec.primary_car_fuel_benefit;
880: pqp_aat_shd.g_old_rec.primary_company_car;
881: End If;
882: If (p_rec.primary_car_fuel_benefit = hr_api.g_varchar2) then
883: p_rec.primary_car_fuel_benefit :=
884: pqp_aat_shd.g_old_rec.primary_car_fuel_benefit;
885: End If;
886: If (p_rec.primary_class_1a = hr_api.g_varchar2) then
887: p_rec.primary_class_1a :=
888: pqp_aat_shd.g_old_rec.primary_class_1a;
884: pqp_aat_shd.g_old_rec.primary_car_fuel_benefit;
885: End If;
886: If (p_rec.primary_class_1a = hr_api.g_varchar2) then
887: p_rec.primary_class_1a :=
888: pqp_aat_shd.g_old_rec.primary_class_1a;
889: End If;
890: If (p_rec.primary_capital_contribution = hr_api.g_number) then
891: p_rec.primary_capital_contribution :=
892: pqp_aat_shd.g_old_rec.primary_capital_contribution;
888: pqp_aat_shd.g_old_rec.primary_class_1a;
889: End If;
890: If (p_rec.primary_capital_contribution = hr_api.g_number) then
891: p_rec.primary_capital_contribution :=
892: pqp_aat_shd.g_old_rec.primary_capital_contribution;
893: End If;
894: If (p_rec.primary_private_contribution = hr_api.g_number) then
895: p_rec.primary_private_contribution :=
896: pqp_aat_shd.g_old_rec.primary_private_contribution;
892: pqp_aat_shd.g_old_rec.primary_capital_contribution;
893: End If;
894: If (p_rec.primary_private_contribution = hr_api.g_number) then
895: p_rec.primary_private_contribution :=
896: pqp_aat_shd.g_old_rec.primary_private_contribution;
897: End If;
898: If (p_rec.secondary_company_car = hr_api.g_number) then
899: p_rec.secondary_company_car :=
900: pqp_aat_shd.g_old_rec.secondary_company_car;
896: pqp_aat_shd.g_old_rec.primary_private_contribution;
897: End If;
898: If (p_rec.secondary_company_car = hr_api.g_number) then
899: p_rec.secondary_company_car :=
900: pqp_aat_shd.g_old_rec.secondary_company_car;
901: End If;
902: If (p_rec.secondary_car_fuel_benefit = hr_api.g_varchar2) then
903: p_rec.secondary_car_fuel_benefit :=
904: pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit;
900: pqp_aat_shd.g_old_rec.secondary_company_car;
901: End If;
902: If (p_rec.secondary_car_fuel_benefit = hr_api.g_varchar2) then
903: p_rec.secondary_car_fuel_benefit :=
904: pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit;
905: End If;
906: If (p_rec.secondary_class_1a = hr_api.g_varchar2) then
907: p_rec.secondary_class_1a :=
908: pqp_aat_shd.g_old_rec.secondary_class_1a;
904: pqp_aat_shd.g_old_rec.secondary_car_fuel_benefit;
905: End If;
906: If (p_rec.secondary_class_1a = hr_api.g_varchar2) then
907: p_rec.secondary_class_1a :=
908: pqp_aat_shd.g_old_rec.secondary_class_1a;
909: End If;
910: If (p_rec.secondary_capital_contribution = hr_api.g_number) then
911: p_rec.secondary_capital_contribution :=
912: pqp_aat_shd.g_old_rec.secondary_capital_contribution;
908: pqp_aat_shd.g_old_rec.secondary_class_1a;
909: End If;
910: If (p_rec.secondary_capital_contribution = hr_api.g_number) then
911: p_rec.secondary_capital_contribution :=
912: pqp_aat_shd.g_old_rec.secondary_capital_contribution;
913: End If;
914: If (p_rec.secondary_private_contribution = hr_api.g_number) then
915: p_rec.secondary_private_contribution :=
916: pqp_aat_shd.g_old_rec.secondary_private_contribution;
912: pqp_aat_shd.g_old_rec.secondary_capital_contribution;
913: End If;
914: If (p_rec.secondary_private_contribution = hr_api.g_number) then
915: p_rec.secondary_private_contribution :=
916: pqp_aat_shd.g_old_rec.secondary_private_contribution;
917: End If;
918: If (p_rec.company_car_calc_method = hr_api.g_varchar2) then
919: p_rec.company_car_calc_method :=
920: pqp_aat_shd.g_old_rec.company_car_calc_method;
916: pqp_aat_shd.g_old_rec.secondary_private_contribution;
917: End If;
918: If (p_rec.company_car_calc_method = hr_api.g_varchar2) then
919: p_rec.company_car_calc_method :=
920: pqp_aat_shd.g_old_rec.company_car_calc_method;
921: End If;
922: If (p_rec.company_car_rates_table_id = hr_api.g_number) then
923: p_rec.company_car_rates_table_id :=
924: pqp_aat_shd.g_old_rec.company_car_rates_table_id;
920: pqp_aat_shd.g_old_rec.company_car_calc_method;
921: End If;
922: If (p_rec.company_car_rates_table_id = hr_api.g_number) then
923: p_rec.company_car_rates_table_id :=
924: pqp_aat_shd.g_old_rec.company_car_rates_table_id;
925: End If;
926: If (p_rec.company_car_secondary_table_id = hr_api.g_number) then
927: p_rec.company_car_secondary_table_id :=
928: pqp_aat_shd.g_old_rec.company_car_secondary_table_id;
924: pqp_aat_shd.g_old_rec.company_car_rates_table_id;
925: End If;
926: If (p_rec.company_car_secondary_table_id = hr_api.g_number) then
927: p_rec.company_car_secondary_table_id :=
928: pqp_aat_shd.g_old_rec.company_car_secondary_table_id;
929: End If;
930: If (p_rec.private_car = hr_api.g_number) then
931: p_rec.private_car :=
932: pqp_aat_shd.g_old_rec.private_car;
928: pqp_aat_shd.g_old_rec.company_car_secondary_table_id;
929: End If;
930: If (p_rec.private_car = hr_api.g_number) then
931: p_rec.private_car :=
932: pqp_aat_shd.g_old_rec.private_car;
933: End If;
934: If (p_rec.private_car_calc_method = hr_api.g_varchar2) then
935: p_rec.private_car_calc_method :=
936: pqp_aat_shd.g_old_rec.private_car_calc_method;
932: pqp_aat_shd.g_old_rec.private_car;
933: End If;
934: If (p_rec.private_car_calc_method = hr_api.g_varchar2) then
935: p_rec.private_car_calc_method :=
936: pqp_aat_shd.g_old_rec.private_car_calc_method;
937: End If;
938: If (p_rec.private_car_rates_table_id = hr_api.g_number) then
939: p_rec.private_car_rates_table_id :=
940: pqp_aat_shd.g_old_rec.private_car_rates_table_id;
936: pqp_aat_shd.g_old_rec.private_car_calc_method;
937: End If;
938: If (p_rec.private_car_rates_table_id = hr_api.g_number) then
939: p_rec.private_car_rates_table_id :=
940: pqp_aat_shd.g_old_rec.private_car_rates_table_id;
941: End If;
942: If (p_rec.private_car_essential_table_id = hr_api.g_number) then
943: p_rec.private_car_essential_table_id :=
944: pqp_aat_shd.g_old_rec.private_car_essential_table_id;
940: pqp_aat_shd.g_old_rec.private_car_rates_table_id;
941: End If;
942: If (p_rec.private_car_essential_table_id = hr_api.g_number) then
943: p_rec.private_car_essential_table_id :=
944: pqp_aat_shd.g_old_rec.private_car_essential_table_id;
945: End If;
946: If (p_rec.tp_is_teacher = hr_api.g_varchar2) then
947: p_rec.tp_is_teacher :=
948: pqp_aat_shd.g_old_rec.tp_is_teacher;
944: pqp_aat_shd.g_old_rec.private_car_essential_table_id;
945: End If;
946: If (p_rec.tp_is_teacher = hr_api.g_varchar2) then
947: p_rec.tp_is_teacher :=
948: pqp_aat_shd.g_old_rec.tp_is_teacher;
949: End If;
950: --added for head Teacher seconded location for salary scale calculation
951: If (p_rec.tp_headteacher_grp_code = hr_api.g_number) then
952: p_rec.tp_headteacher_grp_code :=
949: End If;
950: --added for head Teacher seconded location for salary scale calculation
951: If (p_rec.tp_headteacher_grp_code = hr_api.g_number) then
952: p_rec.tp_headteacher_grp_code :=
953: pqp_aat_shd.g_old_rec.tp_headteacher_grp_code;
954: End If;
955: If (p_rec.tp_safeguarded_grade = hr_api.g_varchar2) then
956: p_rec.tp_safeguarded_grade :=
957: pqp_aat_shd.g_old_rec.tp_safeguarded_grade;
953: pqp_aat_shd.g_old_rec.tp_headteacher_grp_code;
954: End If;
955: If (p_rec.tp_safeguarded_grade = hr_api.g_varchar2) then
956: p_rec.tp_safeguarded_grade :=
957: pqp_aat_shd.g_old_rec.tp_safeguarded_grade;
958: End If;
959: If (p_rec.tp_safeguarded_grade_id = hr_api.g_number) then
960: p_rec.tp_safeguarded_grade_id :=
961: pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id;
957: pqp_aat_shd.g_old_rec.tp_safeguarded_grade;
958: End If;
959: If (p_rec.tp_safeguarded_grade_id = hr_api.g_number) then
960: p_rec.tp_safeguarded_grade_id :=
961: pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id;
962: End If;
963: If (p_rec.tp_safeguarded_rate_type = hr_api.g_varchar2) then
964: p_rec.tp_safeguarded_rate_type :=
965: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type;
961: pqp_aat_shd.g_old_rec.tp_safeguarded_grade_id;
962: End If;
963: If (p_rec.tp_safeguarded_rate_type = hr_api.g_varchar2) then
964: p_rec.tp_safeguarded_rate_type :=
965: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type;
966: End If;
967: If (p_rec.tp_safeguarded_rate_id = hr_api.g_number) then
968: p_rec.tp_safeguarded_rate_id :=
969: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id;
965: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type;
966: End If;
967: If (p_rec.tp_safeguarded_rate_id = hr_api.g_number) then
968: p_rec.tp_safeguarded_rate_id :=
969: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id;
970: End If;
971: If (p_rec.tp_safeguarded_spinal_point_id = hr_api.g_number) then
972: p_rec.tp_safeguarded_spinal_point_id :=
973: pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id;
969: pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id;
970: End If;
971: If (p_rec.tp_safeguarded_spinal_point_id = hr_api.g_number) then
972: p_rec.tp_safeguarded_spinal_point_id :=
973: pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id;
974: End If;
975: If (p_rec.tp_elected_pension = hr_api.g_varchar2) then
976: p_rec.tp_elected_pension :=
977: pqp_aat_shd.g_old_rec.tp_elected_pension;
973: pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id;
974: End If;
975: If (p_rec.tp_elected_pension = hr_api.g_varchar2) then
976: p_rec.tp_elected_pension :=
977: pqp_aat_shd.g_old_rec.tp_elected_pension;
978: End If;
979: If (p_rec.tp_fast_track = hr_api.g_varchar2) then
980: p_rec.tp_fast_track :=
981: pqp_aat_shd.g_old_rec.tp_fast_track;
977: pqp_aat_shd.g_old_rec.tp_elected_pension;
978: End If;
979: If (p_rec.tp_fast_track = hr_api.g_varchar2) then
980: p_rec.tp_fast_track :=
981: pqp_aat_shd.g_old_rec.tp_fast_track;
982: End If;
983: If (p_rec.aat_attribute_category = hr_api.g_varchar2) then
984: p_rec.aat_attribute_category :=
985: pqp_aat_shd.g_old_rec.aat_attribute_category;
981: pqp_aat_shd.g_old_rec.tp_fast_track;
982: End If;
983: If (p_rec.aat_attribute_category = hr_api.g_varchar2) then
984: p_rec.aat_attribute_category :=
985: pqp_aat_shd.g_old_rec.aat_attribute_category;
986: End If;
987: If (p_rec.aat_attribute1 = hr_api.g_varchar2) then
988: p_rec.aat_attribute1 :=
989: pqp_aat_shd.g_old_rec.aat_attribute1;
985: pqp_aat_shd.g_old_rec.aat_attribute_category;
986: End If;
987: If (p_rec.aat_attribute1 = hr_api.g_varchar2) then
988: p_rec.aat_attribute1 :=
989: pqp_aat_shd.g_old_rec.aat_attribute1;
990: End If;
991: If (p_rec.aat_attribute2 = hr_api.g_varchar2) then
992: p_rec.aat_attribute2 :=
993: pqp_aat_shd.g_old_rec.aat_attribute2;
989: pqp_aat_shd.g_old_rec.aat_attribute1;
990: End If;
991: If (p_rec.aat_attribute2 = hr_api.g_varchar2) then
992: p_rec.aat_attribute2 :=
993: pqp_aat_shd.g_old_rec.aat_attribute2;
994: End If;
995: If (p_rec.aat_attribute3 = hr_api.g_varchar2) then
996: p_rec.aat_attribute3 :=
997: pqp_aat_shd.g_old_rec.aat_attribute3;
993: pqp_aat_shd.g_old_rec.aat_attribute2;
994: End If;
995: If (p_rec.aat_attribute3 = hr_api.g_varchar2) then
996: p_rec.aat_attribute3 :=
997: pqp_aat_shd.g_old_rec.aat_attribute3;
998: End If;
999: If (p_rec.aat_attribute4 = hr_api.g_varchar2) then
1000: p_rec.aat_attribute4 :=
1001: pqp_aat_shd.g_old_rec.aat_attribute4;
997: pqp_aat_shd.g_old_rec.aat_attribute3;
998: End If;
999: If (p_rec.aat_attribute4 = hr_api.g_varchar2) then
1000: p_rec.aat_attribute4 :=
1001: pqp_aat_shd.g_old_rec.aat_attribute4;
1002: End If;
1003: If (p_rec.aat_attribute5 = hr_api.g_varchar2) then
1004: p_rec.aat_attribute5 :=
1005: pqp_aat_shd.g_old_rec.aat_attribute5;
1001: pqp_aat_shd.g_old_rec.aat_attribute4;
1002: End If;
1003: If (p_rec.aat_attribute5 = hr_api.g_varchar2) then
1004: p_rec.aat_attribute5 :=
1005: pqp_aat_shd.g_old_rec.aat_attribute5;
1006: End If;
1007: If (p_rec.aat_attribute6 = hr_api.g_varchar2) then
1008: p_rec.aat_attribute6 :=
1009: pqp_aat_shd.g_old_rec.aat_attribute6;
1005: pqp_aat_shd.g_old_rec.aat_attribute5;
1006: End If;
1007: If (p_rec.aat_attribute6 = hr_api.g_varchar2) then
1008: p_rec.aat_attribute6 :=
1009: pqp_aat_shd.g_old_rec.aat_attribute6;
1010: End If;
1011: If (p_rec.aat_attribute7 = hr_api.g_varchar2) then
1012: p_rec.aat_attribute7 :=
1013: pqp_aat_shd.g_old_rec.aat_attribute7;
1009: pqp_aat_shd.g_old_rec.aat_attribute6;
1010: End If;
1011: If (p_rec.aat_attribute7 = hr_api.g_varchar2) then
1012: p_rec.aat_attribute7 :=
1013: pqp_aat_shd.g_old_rec.aat_attribute7;
1014: End If;
1015: If (p_rec.aat_attribute8 = hr_api.g_varchar2) then
1016: p_rec.aat_attribute8 :=
1017: pqp_aat_shd.g_old_rec.aat_attribute8;
1013: pqp_aat_shd.g_old_rec.aat_attribute7;
1014: End If;
1015: If (p_rec.aat_attribute8 = hr_api.g_varchar2) then
1016: p_rec.aat_attribute8 :=
1017: pqp_aat_shd.g_old_rec.aat_attribute8;
1018: End If;
1019: If (p_rec.aat_attribute9 = hr_api.g_varchar2) then
1020: p_rec.aat_attribute9 :=
1021: pqp_aat_shd.g_old_rec.aat_attribute9;
1017: pqp_aat_shd.g_old_rec.aat_attribute8;
1018: End If;
1019: If (p_rec.aat_attribute9 = hr_api.g_varchar2) then
1020: p_rec.aat_attribute9 :=
1021: pqp_aat_shd.g_old_rec.aat_attribute9;
1022: End If;
1023: If (p_rec.aat_attribute10 = hr_api.g_varchar2) then
1024: p_rec.aat_attribute10 :=
1025: pqp_aat_shd.g_old_rec.aat_attribute10;
1021: pqp_aat_shd.g_old_rec.aat_attribute9;
1022: End If;
1023: If (p_rec.aat_attribute10 = hr_api.g_varchar2) then
1024: p_rec.aat_attribute10 :=
1025: pqp_aat_shd.g_old_rec.aat_attribute10;
1026: End If;
1027: If (p_rec.aat_attribute11 = hr_api.g_varchar2) then
1028: p_rec.aat_attribute11 :=
1029: pqp_aat_shd.g_old_rec.aat_attribute11;
1025: pqp_aat_shd.g_old_rec.aat_attribute10;
1026: End If;
1027: If (p_rec.aat_attribute11 = hr_api.g_varchar2) then
1028: p_rec.aat_attribute11 :=
1029: pqp_aat_shd.g_old_rec.aat_attribute11;
1030: End If;
1031: If (p_rec.aat_attribute12 = hr_api.g_varchar2) then
1032: p_rec.aat_attribute12 :=
1033: pqp_aat_shd.g_old_rec.aat_attribute12;
1029: pqp_aat_shd.g_old_rec.aat_attribute11;
1030: End If;
1031: If (p_rec.aat_attribute12 = hr_api.g_varchar2) then
1032: p_rec.aat_attribute12 :=
1033: pqp_aat_shd.g_old_rec.aat_attribute12;
1034: End If;
1035: If (p_rec.aat_attribute13 = hr_api.g_varchar2) then
1036: p_rec.aat_attribute13 :=
1037: pqp_aat_shd.g_old_rec.aat_attribute13;
1033: pqp_aat_shd.g_old_rec.aat_attribute12;
1034: End If;
1035: If (p_rec.aat_attribute13 = hr_api.g_varchar2) then
1036: p_rec.aat_attribute13 :=
1037: pqp_aat_shd.g_old_rec.aat_attribute13;
1038: End If;
1039: If (p_rec.aat_attribute14 = hr_api.g_varchar2) then
1040: p_rec.aat_attribute14 :=
1041: pqp_aat_shd.g_old_rec.aat_attribute14;
1037: pqp_aat_shd.g_old_rec.aat_attribute13;
1038: End If;
1039: If (p_rec.aat_attribute14 = hr_api.g_varchar2) then
1040: p_rec.aat_attribute14 :=
1041: pqp_aat_shd.g_old_rec.aat_attribute14;
1042: End If;
1043: If (p_rec.aat_attribute15 = hr_api.g_varchar2) then
1044: p_rec.aat_attribute15 :=
1045: pqp_aat_shd.g_old_rec.aat_attribute15;
1041: pqp_aat_shd.g_old_rec.aat_attribute14;
1042: End If;
1043: If (p_rec.aat_attribute15 = hr_api.g_varchar2) then
1044: p_rec.aat_attribute15 :=
1045: pqp_aat_shd.g_old_rec.aat_attribute15;
1046: End If;
1047: If (p_rec.aat_attribute16 = hr_api.g_varchar2) then
1048: p_rec.aat_attribute16 :=
1049: pqp_aat_shd.g_old_rec.aat_attribute16;
1045: pqp_aat_shd.g_old_rec.aat_attribute15;
1046: End If;
1047: If (p_rec.aat_attribute16 = hr_api.g_varchar2) then
1048: p_rec.aat_attribute16 :=
1049: pqp_aat_shd.g_old_rec.aat_attribute16;
1050: End If;
1051: If (p_rec.aat_attribute17 = hr_api.g_varchar2) then
1052: p_rec.aat_attribute17 :=
1053: pqp_aat_shd.g_old_rec.aat_attribute17;
1049: pqp_aat_shd.g_old_rec.aat_attribute16;
1050: End If;
1051: If (p_rec.aat_attribute17 = hr_api.g_varchar2) then
1052: p_rec.aat_attribute17 :=
1053: pqp_aat_shd.g_old_rec.aat_attribute17;
1054: End If;
1055: If (p_rec.aat_attribute18 = hr_api.g_varchar2) then
1056: p_rec.aat_attribute18 :=
1057: pqp_aat_shd.g_old_rec.aat_attribute18;
1053: pqp_aat_shd.g_old_rec.aat_attribute17;
1054: End If;
1055: If (p_rec.aat_attribute18 = hr_api.g_varchar2) then
1056: p_rec.aat_attribute18 :=
1057: pqp_aat_shd.g_old_rec.aat_attribute18;
1058: End If;
1059: If (p_rec.aat_attribute19 = hr_api.g_varchar2) then
1060: p_rec.aat_attribute19 :=
1061: pqp_aat_shd.g_old_rec.aat_attribute19;
1057: pqp_aat_shd.g_old_rec.aat_attribute18;
1058: End If;
1059: If (p_rec.aat_attribute19 = hr_api.g_varchar2) then
1060: p_rec.aat_attribute19 :=
1061: pqp_aat_shd.g_old_rec.aat_attribute19;
1062: End If;
1063: If (p_rec.aat_attribute20 = hr_api.g_varchar2) then
1064: p_rec.aat_attribute20 :=
1065: pqp_aat_shd.g_old_rec.aat_attribute20;
1061: pqp_aat_shd.g_old_rec.aat_attribute19;
1062: End If;
1063: If (p_rec.aat_attribute20 = hr_api.g_varchar2) then
1064: p_rec.aat_attribute20 :=
1065: pqp_aat_shd.g_old_rec.aat_attribute20;
1066: End If;
1067: If (p_rec.aat_information_category = hr_api.g_varchar2) then
1068: p_rec.aat_information_category :=
1069: pqp_aat_shd.g_old_rec.aat_information_category;
1065: pqp_aat_shd.g_old_rec.aat_attribute20;
1066: End If;
1067: If (p_rec.aat_information_category = hr_api.g_varchar2) then
1068: p_rec.aat_information_category :=
1069: pqp_aat_shd.g_old_rec.aat_information_category;
1070: End If;
1071: If (p_rec.aat_information1 = hr_api.g_varchar2) then
1072: p_rec.aat_information1 :=
1073: pqp_aat_shd.g_old_rec.aat_information1;
1069: pqp_aat_shd.g_old_rec.aat_information_category;
1070: End If;
1071: If (p_rec.aat_information1 = hr_api.g_varchar2) then
1072: p_rec.aat_information1 :=
1073: pqp_aat_shd.g_old_rec.aat_information1;
1074: End If;
1075: If (p_rec.aat_information2 = hr_api.g_varchar2) then
1076: p_rec.aat_information2 :=
1077: pqp_aat_shd.g_old_rec.aat_information2;
1073: pqp_aat_shd.g_old_rec.aat_information1;
1074: End If;
1075: If (p_rec.aat_information2 = hr_api.g_varchar2) then
1076: p_rec.aat_information2 :=
1077: pqp_aat_shd.g_old_rec.aat_information2;
1078: End If;
1079: If (p_rec.aat_information3 = hr_api.g_varchar2) then
1080: p_rec.aat_information3 :=
1081: pqp_aat_shd.g_old_rec.aat_information3;
1077: pqp_aat_shd.g_old_rec.aat_information2;
1078: End If;
1079: If (p_rec.aat_information3 = hr_api.g_varchar2) then
1080: p_rec.aat_information3 :=
1081: pqp_aat_shd.g_old_rec.aat_information3;
1082: End If;
1083: If (p_rec.aat_information4 = hr_api.g_varchar2) then
1084: p_rec.aat_information4 :=
1085: pqp_aat_shd.g_old_rec.aat_information4;
1081: pqp_aat_shd.g_old_rec.aat_information3;
1082: End If;
1083: If (p_rec.aat_information4 = hr_api.g_varchar2) then
1084: p_rec.aat_information4 :=
1085: pqp_aat_shd.g_old_rec.aat_information4;
1086: End If;
1087: If (p_rec.aat_information5 = hr_api.g_varchar2) then
1088: p_rec.aat_information5 :=
1089: pqp_aat_shd.g_old_rec.aat_information5;
1085: pqp_aat_shd.g_old_rec.aat_information4;
1086: End If;
1087: If (p_rec.aat_information5 = hr_api.g_varchar2) then
1088: p_rec.aat_information5 :=
1089: pqp_aat_shd.g_old_rec.aat_information5;
1090: End If;
1091: If (p_rec.aat_information6 = hr_api.g_varchar2) then
1092: p_rec.aat_information6 :=
1093: pqp_aat_shd.g_old_rec.aat_information6;
1089: pqp_aat_shd.g_old_rec.aat_information5;
1090: End If;
1091: If (p_rec.aat_information6 = hr_api.g_varchar2) then
1092: p_rec.aat_information6 :=
1093: pqp_aat_shd.g_old_rec.aat_information6;
1094: End If;
1095: If (p_rec.aat_information7 = hr_api.g_varchar2) then
1096: p_rec.aat_information7 :=
1097: pqp_aat_shd.g_old_rec.aat_information7;
1093: pqp_aat_shd.g_old_rec.aat_information6;
1094: End If;
1095: If (p_rec.aat_information7 = hr_api.g_varchar2) then
1096: p_rec.aat_information7 :=
1097: pqp_aat_shd.g_old_rec.aat_information7;
1098: End If;
1099: If (p_rec.aat_information8 = hr_api.g_varchar2) then
1100: p_rec.aat_information8 :=
1101: pqp_aat_shd.g_old_rec.aat_information8;
1097: pqp_aat_shd.g_old_rec.aat_information7;
1098: End If;
1099: If (p_rec.aat_information8 = hr_api.g_varchar2) then
1100: p_rec.aat_information8 :=
1101: pqp_aat_shd.g_old_rec.aat_information8;
1102: End If;
1103: If (p_rec.aat_information9 = hr_api.g_varchar2) then
1104: p_rec.aat_information9 :=
1105: pqp_aat_shd.g_old_rec.aat_information9;
1101: pqp_aat_shd.g_old_rec.aat_information8;
1102: End If;
1103: If (p_rec.aat_information9 = hr_api.g_varchar2) then
1104: p_rec.aat_information9 :=
1105: pqp_aat_shd.g_old_rec.aat_information9;
1106: End If;
1107: If (p_rec.aat_information10 = hr_api.g_varchar2) then
1108: p_rec.aat_information10 :=
1109: pqp_aat_shd.g_old_rec.aat_information10;
1105: pqp_aat_shd.g_old_rec.aat_information9;
1106: End If;
1107: If (p_rec.aat_information10 = hr_api.g_varchar2) then
1108: p_rec.aat_information10 :=
1109: pqp_aat_shd.g_old_rec.aat_information10;
1110: End If;
1111: If (p_rec.aat_information11 = hr_api.g_varchar2) then
1112: p_rec.aat_information11 :=
1113: pqp_aat_shd.g_old_rec.aat_information11;
1109: pqp_aat_shd.g_old_rec.aat_information10;
1110: End If;
1111: If (p_rec.aat_information11 = hr_api.g_varchar2) then
1112: p_rec.aat_information11 :=
1113: pqp_aat_shd.g_old_rec.aat_information11;
1114: End If;
1115: If (p_rec.aat_information12 = hr_api.g_varchar2) then
1116: p_rec.aat_information12 :=
1117: pqp_aat_shd.g_old_rec.aat_information12;
1113: pqp_aat_shd.g_old_rec.aat_information11;
1114: End If;
1115: If (p_rec.aat_information12 = hr_api.g_varchar2) then
1116: p_rec.aat_information12 :=
1117: pqp_aat_shd.g_old_rec.aat_information12;
1118: End If;
1119: If (p_rec.aat_information13 = hr_api.g_varchar2) then
1120: p_rec.aat_information13 :=
1121: pqp_aat_shd.g_old_rec.aat_information13;
1117: pqp_aat_shd.g_old_rec.aat_information12;
1118: End If;
1119: If (p_rec.aat_information13 = hr_api.g_varchar2) then
1120: p_rec.aat_information13 :=
1121: pqp_aat_shd.g_old_rec.aat_information13;
1122: End If;
1123: If (p_rec.aat_information14 = hr_api.g_varchar2) then
1124: p_rec.aat_information14 :=
1125: pqp_aat_shd.g_old_rec.aat_information14;
1121: pqp_aat_shd.g_old_rec.aat_information13;
1122: End If;
1123: If (p_rec.aat_information14 = hr_api.g_varchar2) then
1124: p_rec.aat_information14 :=
1125: pqp_aat_shd.g_old_rec.aat_information14;
1126: End If;
1127: If (p_rec.aat_information15 = hr_api.g_varchar2) then
1128: p_rec.aat_information15 :=
1129: pqp_aat_shd.g_old_rec.aat_information15;
1125: pqp_aat_shd.g_old_rec.aat_information14;
1126: End If;
1127: If (p_rec.aat_information15 = hr_api.g_varchar2) then
1128: p_rec.aat_information15 :=
1129: pqp_aat_shd.g_old_rec.aat_information15;
1130: End If;
1131: If (p_rec.aat_information16 = hr_api.g_varchar2) then
1132: p_rec.aat_information16 :=
1133: pqp_aat_shd.g_old_rec.aat_information16;
1129: pqp_aat_shd.g_old_rec.aat_information15;
1130: End If;
1131: If (p_rec.aat_information16 = hr_api.g_varchar2) then
1132: p_rec.aat_information16 :=
1133: pqp_aat_shd.g_old_rec.aat_information16;
1134: End If;
1135: If (p_rec.aat_information17 = hr_api.g_varchar2) then
1136: p_rec.aat_information17 :=
1137: pqp_aat_shd.g_old_rec.aat_information17;
1133: pqp_aat_shd.g_old_rec.aat_information16;
1134: End If;
1135: If (p_rec.aat_information17 = hr_api.g_varchar2) then
1136: p_rec.aat_information17 :=
1137: pqp_aat_shd.g_old_rec.aat_information17;
1138: End If;
1139: If (p_rec.aat_information18 = hr_api.g_varchar2) then
1140: p_rec.aat_information18 :=
1141: pqp_aat_shd.g_old_rec.aat_information18;
1137: pqp_aat_shd.g_old_rec.aat_information17;
1138: End If;
1139: If (p_rec.aat_information18 = hr_api.g_varchar2) then
1140: p_rec.aat_information18 :=
1141: pqp_aat_shd.g_old_rec.aat_information18;
1142: End If;
1143: If (p_rec.aat_information19 = hr_api.g_varchar2) then
1144: p_rec.aat_information19 :=
1145: pqp_aat_shd.g_old_rec.aat_information19;
1141: pqp_aat_shd.g_old_rec.aat_information18;
1142: End If;
1143: If (p_rec.aat_information19 = hr_api.g_varchar2) then
1144: p_rec.aat_information19 :=
1145: pqp_aat_shd.g_old_rec.aat_information19;
1146: End If;
1147: If (p_rec.aat_information20 = hr_api.g_varchar2) then
1148: p_rec.aat_information20 :=
1149: pqp_aat_shd.g_old_rec.aat_information20;
1145: pqp_aat_shd.g_old_rec.aat_information19;
1146: End If;
1147: If (p_rec.aat_information20 = hr_api.g_varchar2) then
1148: p_rec.aat_information20 :=
1149: pqp_aat_shd.g_old_rec.aat_information20;
1150: End If;
1151: If (p_rec.lgps_process_flag = hr_api.g_varchar2) then
1152: p_rec.lgps_process_flag :=
1153: pqp_aat_shd.g_old_rec.lgps_process_flag;
1149: pqp_aat_shd.g_old_rec.aat_information20;
1150: End If;
1151: If (p_rec.lgps_process_flag = hr_api.g_varchar2) then
1152: p_rec.lgps_process_flag :=
1153: pqp_aat_shd.g_old_rec.lgps_process_flag;
1154: End If;
1155: If (p_rec.lgps_exclusion_type = hr_api.g_varchar2) then
1156: p_rec.lgps_exclusion_type :=
1157: pqp_aat_shd.g_old_rec.lgps_exclusion_type;
1153: pqp_aat_shd.g_old_rec.lgps_process_flag;
1154: End If;
1155: If (p_rec.lgps_exclusion_type = hr_api.g_varchar2) then
1156: p_rec.lgps_exclusion_type :=
1157: pqp_aat_shd.g_old_rec.lgps_exclusion_type;
1158: End If;
1159: If (p_rec.lgps_pensionable_pay = hr_api.g_varchar2) then
1160: p_rec.lgps_pensionable_pay :=
1161: pqp_aat_shd.g_old_rec.lgps_pensionable_pay;
1157: pqp_aat_shd.g_old_rec.lgps_exclusion_type;
1158: End If;
1159: If (p_rec.lgps_pensionable_pay = hr_api.g_varchar2) then
1160: p_rec.lgps_pensionable_pay :=
1161: pqp_aat_shd.g_old_rec.lgps_pensionable_pay;
1162: End If;
1163: If (p_rec.lgps_trans_arrang_flag = hr_api.g_varchar2) then
1164: p_rec.lgps_trans_arrang_flag :=
1165: pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag;
1161: pqp_aat_shd.g_old_rec.lgps_pensionable_pay;
1162: End If;
1163: If (p_rec.lgps_trans_arrang_flag = hr_api.g_varchar2) then
1164: p_rec.lgps_trans_arrang_flag :=
1165: pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag;
1166: End If;
1167: If (p_rec.lgps_membership_number = hr_api.g_varchar2) then
1168: p_rec.lgps_membership_number :=
1169: pqp_aat_shd.g_old_rec.lgps_membership_number;
1165: pqp_aat_shd.g_old_rec.lgps_trans_arrang_flag;
1166: End If;
1167: If (p_rec.lgps_membership_number = hr_api.g_varchar2) then
1168: p_rec.lgps_membership_number :=
1169: pqp_aat_shd.g_old_rec.lgps_membership_number;
1170: End If;
1171:
1172: --
1173: End convert_defs;
1177: -- ---------------------------------------------------------------------------+
1178: Procedure upd
1179: (p_effective_date in date
1180: ,p_datetrack_mode in varchar2
1181: ,p_rec in out nocopy pqp_aat_shd.g_rec_type
1182: ) is
1183: --
1184: l_proc varchar2(72) := g_package||'upd';
1185: l_validation_start_date date;
1193: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1194: --
1195: -- We must lock the row which we need to update.
1196: --
1197: pqp_aat_shd.lck
1198: (p_effective_date => p_effective_date
1199: ,p_datetrack_mode => p_datetrack_mode
1200: ,p_assignment_attribute_id => p_rec.assignment_attribute_id
1201: ,p_object_version_number => p_rec.object_version_number
1339: ,p_effective_start_date out nocopy date
1340: ,p_effective_end_date out nocopy date
1341: ) is
1342: --
1343: l_rec pqp_aat_shd.g_rec_type;
1344: l_proc varchar2(72) := g_package||'upd';
1345: --
1346: Begin
1347: hr_utility.set_location('Entering:'||l_proc, 5);
1349: -- Call conversion function to turn arguments into the
1350: -- l_rec structure.
1351: --
1352: l_rec :=
1353: pqp_aat_shd.convert_args
1354: (p_assignment_attribute_id
1355: ,null
1356: ,null
1357: ,p_business_group_id