[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pqp_pty_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
194: Exception
195: When hr_api.check_integrity_violated Then
196: -- A check constraint has been violated
197: --
198: pqp_pty_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: --
203: pqp_pty_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: --
207: Raise;
238: --
239: -- {End Of Comments}
240: -- ----------------------------------------------------------------------------
241: Procedure update_dml
242: (p_rec in out nocopy pqp_pty_shd.g_rec_type
243: ,p_effective_date in date
244: ,p_datetrack_mode in varchar2
245: ,p_validation_start_date in date
246: ,p_validation_end_date in date
305: --
306: -- {End Of Comments}
307: -- ----------------------------------------------------------------------------
308: Procedure dt_pre_update
309: (p_rec in out nocopy pqp_pty_shd.g_rec_type
310: ,p_effective_date in date
311: ,p_datetrack_mode in varchar2
312: ,p_validation_start_date in date
313: ,p_validation_end_date in date
321: If (p_datetrack_mode <> hr_api.g_correction) then
322: --
323: -- Update the current effective end date
324: --
325: pqp_pty_shd.upd_effective_end_date
326: (p_effective_date => p_effective_date
327: ,p_base_key_value => p_rec.pension_type_id
328: ,p_new_effective_end_date => (p_validation_start_date - 1)
329: ,p_validation_start_date => p_validation_start_date
390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure pre_update
394: (p_rec in out nocopy pqp_pty_shd.g_rec_type
395: ,p_effective_date in date
396: ,p_datetrack_mode in varchar2
397: ,p_validation_start_date in date
398: ,p_validation_end_date in date
448: --
449: -- {End Of Comments}
450: -- ----------------------------------------------------------------------------
451: Procedure post_update
452: (p_rec in pqp_pty_shd.g_rec_type
453: ,p_effective_date in date
454: ,p_datetrack_mode in varchar2
455: ,p_validation_start_date in date
456: ,p_validation_end_date in date
657: => p_rec.ee_age_contribution
658: ,p_er_age_contribution
659: => p_rec.er_age_contribution
660: ,p_effective_start_date_o
661: => pqp_pty_shd.g_old_rec.effective_start_date
662: ,p_effective_end_date_o
663: => pqp_pty_shd.g_old_rec.effective_end_date
664: ,p_pension_type_name_o
665: => pqp_pty_shd.g_old_rec.pension_type_name
659: => p_rec.er_age_contribution
660: ,p_effective_start_date_o
661: => pqp_pty_shd.g_old_rec.effective_start_date
662: ,p_effective_end_date_o
663: => pqp_pty_shd.g_old_rec.effective_end_date
664: ,p_pension_type_name_o
665: => pqp_pty_shd.g_old_rec.pension_type_name
666: ,p_pension_category_o
667: => pqp_pty_shd.g_old_rec.pension_category
661: => pqp_pty_shd.g_old_rec.effective_start_date
662: ,p_effective_end_date_o
663: => pqp_pty_shd.g_old_rec.effective_end_date
664: ,p_pension_type_name_o
665: => pqp_pty_shd.g_old_rec.pension_type_name
666: ,p_pension_category_o
667: => pqp_pty_shd.g_old_rec.pension_category
668: ,p_pension_provider_type_o
669: => pqp_pty_shd.g_old_rec.pension_provider_type
663: => pqp_pty_shd.g_old_rec.effective_end_date
664: ,p_pension_type_name_o
665: => pqp_pty_shd.g_old_rec.pension_type_name
666: ,p_pension_category_o
667: => pqp_pty_shd.g_old_rec.pension_category
668: ,p_pension_provider_type_o
669: => pqp_pty_shd.g_old_rec.pension_provider_type
670: ,p_salary_calculation_method_o
671: => pqp_pty_shd.g_old_rec.salary_calculation_method
665: => pqp_pty_shd.g_old_rec.pension_type_name
666: ,p_pension_category_o
667: => pqp_pty_shd.g_old_rec.pension_category
668: ,p_pension_provider_type_o
669: => pqp_pty_shd.g_old_rec.pension_provider_type
670: ,p_salary_calculation_method_o
671: => pqp_pty_shd.g_old_rec.salary_calculation_method
672: ,p_threshold_conversion_rule_o
673: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
667: => pqp_pty_shd.g_old_rec.pension_category
668: ,p_pension_provider_type_o
669: => pqp_pty_shd.g_old_rec.pension_provider_type
670: ,p_salary_calculation_method_o
671: => pqp_pty_shd.g_old_rec.salary_calculation_method
672: ,p_threshold_conversion_rule_o
673: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
674: ,p_contribution_conversion_ru_o
675: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
669: => pqp_pty_shd.g_old_rec.pension_provider_type
670: ,p_salary_calculation_method_o
671: => pqp_pty_shd.g_old_rec.salary_calculation_method
672: ,p_threshold_conversion_rule_o
673: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
674: ,p_contribution_conversion_ru_o
675: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
676: ,p_er_annual_limit_o
677: => pqp_pty_shd.g_old_rec.er_annual_limit
671: => pqp_pty_shd.g_old_rec.salary_calculation_method
672: ,p_threshold_conversion_rule_o
673: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
674: ,p_contribution_conversion_ru_o
675: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
676: ,p_er_annual_limit_o
677: => pqp_pty_shd.g_old_rec.er_annual_limit
678: ,p_ee_annual_limit_o
679: => pqp_pty_shd.g_old_rec.ee_annual_limit
673: => pqp_pty_shd.g_old_rec.threshold_conversion_rule
674: ,p_contribution_conversion_ru_o
675: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
676: ,p_er_annual_limit_o
677: => pqp_pty_shd.g_old_rec.er_annual_limit
678: ,p_ee_annual_limit_o
679: => pqp_pty_shd.g_old_rec.ee_annual_limit
680: ,p_er_annual_salary_threshold_o
681: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
675: => pqp_pty_shd.g_old_rec.contribution_conversion_rule
676: ,p_er_annual_limit_o
677: => pqp_pty_shd.g_old_rec.er_annual_limit
678: ,p_ee_annual_limit_o
679: => pqp_pty_shd.g_old_rec.ee_annual_limit
680: ,p_er_annual_salary_threshold_o
681: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
682: ,p_ee_annual_salary_threshold_o
683: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
677: => pqp_pty_shd.g_old_rec.er_annual_limit
678: ,p_ee_annual_limit_o
679: => pqp_pty_shd.g_old_rec.ee_annual_limit
680: ,p_er_annual_salary_threshold_o
681: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
682: ,p_ee_annual_salary_threshold_o
683: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
684: ,p_object_version_number_o
685: => pqp_pty_shd.g_old_rec.object_version_number
679: => pqp_pty_shd.g_old_rec.ee_annual_limit
680: ,p_er_annual_salary_threshold_o
681: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
682: ,p_ee_annual_salary_threshold_o
683: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
684: ,p_object_version_number_o
685: => pqp_pty_shd.g_old_rec.object_version_number
686: ,p_business_group_id_o
687: => pqp_pty_shd.g_old_rec.business_group_id
681: => pqp_pty_shd.g_old_rec.er_annual_salary_threshold
682: ,p_ee_annual_salary_threshold_o
683: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
684: ,p_object_version_number_o
685: => pqp_pty_shd.g_old_rec.object_version_number
686: ,p_business_group_id_o
687: => pqp_pty_shd.g_old_rec.business_group_id
688: ,p_legislation_code_o
689: => pqp_pty_shd.g_old_rec.legislation_code
683: => pqp_pty_shd.g_old_rec.ee_annual_salary_threshold
684: ,p_object_version_number_o
685: => pqp_pty_shd.g_old_rec.object_version_number
686: ,p_business_group_id_o
687: => pqp_pty_shd.g_old_rec.business_group_id
688: ,p_legislation_code_o
689: => pqp_pty_shd.g_old_rec.legislation_code
690: ,p_description_o
691: => pqp_pty_shd.g_old_rec.description
685: => pqp_pty_shd.g_old_rec.object_version_number
686: ,p_business_group_id_o
687: => pqp_pty_shd.g_old_rec.business_group_id
688: ,p_legislation_code_o
689: => pqp_pty_shd.g_old_rec.legislation_code
690: ,p_description_o
691: => pqp_pty_shd.g_old_rec.description
692: ,p_minimum_age_o
693: => pqp_pty_shd.g_old_rec.minimum_age
687: => pqp_pty_shd.g_old_rec.business_group_id
688: ,p_legislation_code_o
689: => pqp_pty_shd.g_old_rec.legislation_code
690: ,p_description_o
691: => pqp_pty_shd.g_old_rec.description
692: ,p_minimum_age_o
693: => pqp_pty_shd.g_old_rec.minimum_age
694: ,p_ee_contribution_percent_o
695: => pqp_pty_shd.g_old_rec.ee_contribution_percent
689: => pqp_pty_shd.g_old_rec.legislation_code
690: ,p_description_o
691: => pqp_pty_shd.g_old_rec.description
692: ,p_minimum_age_o
693: => pqp_pty_shd.g_old_rec.minimum_age
694: ,p_ee_contribution_percent_o
695: => pqp_pty_shd.g_old_rec.ee_contribution_percent
696: ,p_maximum_age_o
697: => pqp_pty_shd.g_old_rec.maximum_age
691: => pqp_pty_shd.g_old_rec.description
692: ,p_minimum_age_o
693: => pqp_pty_shd.g_old_rec.minimum_age
694: ,p_ee_contribution_percent_o
695: => pqp_pty_shd.g_old_rec.ee_contribution_percent
696: ,p_maximum_age_o
697: => pqp_pty_shd.g_old_rec.maximum_age
698: ,p_er_contribution_percent_o
699: => pqp_pty_shd.g_old_rec.er_contribution_percent
693: => pqp_pty_shd.g_old_rec.minimum_age
694: ,p_ee_contribution_percent_o
695: => pqp_pty_shd.g_old_rec.ee_contribution_percent
696: ,p_maximum_age_o
697: => pqp_pty_shd.g_old_rec.maximum_age
698: ,p_er_contribution_percent_o
699: => pqp_pty_shd.g_old_rec.er_contribution_percent
700: ,p_ee_annual_contribution_o
701: => pqp_pty_shd.g_old_rec.ee_annual_contribution
695: => pqp_pty_shd.g_old_rec.ee_contribution_percent
696: ,p_maximum_age_o
697: => pqp_pty_shd.g_old_rec.maximum_age
698: ,p_er_contribution_percent_o
699: => pqp_pty_shd.g_old_rec.er_contribution_percent
700: ,p_ee_annual_contribution_o
701: => pqp_pty_shd.g_old_rec.ee_annual_contribution
702: ,p_er_annual_contribution_o
703: => pqp_pty_shd.g_old_rec.er_annual_contribution
697: => pqp_pty_shd.g_old_rec.maximum_age
698: ,p_er_contribution_percent_o
699: => pqp_pty_shd.g_old_rec.er_contribution_percent
700: ,p_ee_annual_contribution_o
701: => pqp_pty_shd.g_old_rec.ee_annual_contribution
702: ,p_er_annual_contribution_o
703: => pqp_pty_shd.g_old_rec.er_annual_contribution
704: ,p_annual_premium_amount_o
705: => pqp_pty_shd.g_old_rec.annual_premium_amount
699: => pqp_pty_shd.g_old_rec.er_contribution_percent
700: ,p_ee_annual_contribution_o
701: => pqp_pty_shd.g_old_rec.ee_annual_contribution
702: ,p_er_annual_contribution_o
703: => pqp_pty_shd.g_old_rec.er_annual_contribution
704: ,p_annual_premium_amount_o
705: => pqp_pty_shd.g_old_rec.annual_premium_amount
706: ,p_ee_contribution_bal_type_i_o
707: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
701: => pqp_pty_shd.g_old_rec.ee_annual_contribution
702: ,p_er_annual_contribution_o
703: => pqp_pty_shd.g_old_rec.er_annual_contribution
704: ,p_annual_premium_amount_o
705: => pqp_pty_shd.g_old_rec.annual_premium_amount
706: ,p_ee_contribution_bal_type_i_o
707: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
708: ,p_er_contribution_bal_type_i_o
709: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
703: => pqp_pty_shd.g_old_rec.er_annual_contribution
704: ,p_annual_premium_amount_o
705: => pqp_pty_shd.g_old_rec.annual_premium_amount
706: ,p_ee_contribution_bal_type_i_o
707: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
708: ,p_er_contribution_bal_type_i_o
709: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
710: ,p_balance_init_element_type__o
711: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
705: => pqp_pty_shd.g_old_rec.annual_premium_amount
706: ,p_ee_contribution_bal_type_i_o
707: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
708: ,p_er_contribution_bal_type_i_o
709: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
710: ,p_balance_init_element_type__o
711: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
712: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
713: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
707: => pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id
708: ,p_er_contribution_bal_type_i_o
709: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
710: ,p_balance_init_element_type__o
711: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
712: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
713: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
714: ,p_pty_attribute_category_o
715: => pqp_pty_shd.g_old_rec.pty_attribute_category
708: ,p_er_contribution_bal_type_i_o
709: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
710: ,p_balance_init_element_type__o
711: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
712: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
713: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
714: ,p_pty_attribute_category_o
715: => pqp_pty_shd.g_old_rec.pty_attribute_category
716: ,p_pty_attribute1_o
709: => pqp_pty_shd.g_old_rec.er_contribution_bal_type_id
710: ,p_balance_init_element_type__o
711: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
712: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
713: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
714: ,p_pty_attribute_category_o
715: => pqp_pty_shd.g_old_rec.pty_attribute_category
716: ,p_pty_attribute1_o
717: => pqp_pty_shd.g_old_rec.pty_attribute1
711: => pqp_pty_shd.g_old_rec.balance_init_element_type_id
712: ,p_ee_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
713: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
714: ,p_pty_attribute_category_o
715: => pqp_pty_shd.g_old_rec.pty_attribute_category
716: ,p_pty_attribute1_o
717: => pqp_pty_shd.g_old_rec.pty_attribute1
718: ,p_pty_attribute2_o
719: => pqp_pty_shd.g_old_rec.pty_attribute2
713: ,p_er_contribution_fixed_rate_o => pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate --added for UK
714: ,p_pty_attribute_category_o
715: => pqp_pty_shd.g_old_rec.pty_attribute_category
716: ,p_pty_attribute1_o
717: => pqp_pty_shd.g_old_rec.pty_attribute1
718: ,p_pty_attribute2_o
719: => pqp_pty_shd.g_old_rec.pty_attribute2
720: ,p_pty_attribute3_o
721: => pqp_pty_shd.g_old_rec.pty_attribute3
715: => pqp_pty_shd.g_old_rec.pty_attribute_category
716: ,p_pty_attribute1_o
717: => pqp_pty_shd.g_old_rec.pty_attribute1
718: ,p_pty_attribute2_o
719: => pqp_pty_shd.g_old_rec.pty_attribute2
720: ,p_pty_attribute3_o
721: => pqp_pty_shd.g_old_rec.pty_attribute3
722: ,p_pty_attribute4_o
723: => pqp_pty_shd.g_old_rec.pty_attribute4
717: => pqp_pty_shd.g_old_rec.pty_attribute1
718: ,p_pty_attribute2_o
719: => pqp_pty_shd.g_old_rec.pty_attribute2
720: ,p_pty_attribute3_o
721: => pqp_pty_shd.g_old_rec.pty_attribute3
722: ,p_pty_attribute4_o
723: => pqp_pty_shd.g_old_rec.pty_attribute4
724: ,p_pty_attribute5_o
725: => pqp_pty_shd.g_old_rec.pty_attribute5
719: => pqp_pty_shd.g_old_rec.pty_attribute2
720: ,p_pty_attribute3_o
721: => pqp_pty_shd.g_old_rec.pty_attribute3
722: ,p_pty_attribute4_o
723: => pqp_pty_shd.g_old_rec.pty_attribute4
724: ,p_pty_attribute5_o
725: => pqp_pty_shd.g_old_rec.pty_attribute5
726: ,p_pty_attribute6_o
727: => pqp_pty_shd.g_old_rec.pty_attribute6
721: => pqp_pty_shd.g_old_rec.pty_attribute3
722: ,p_pty_attribute4_o
723: => pqp_pty_shd.g_old_rec.pty_attribute4
724: ,p_pty_attribute5_o
725: => pqp_pty_shd.g_old_rec.pty_attribute5
726: ,p_pty_attribute6_o
727: => pqp_pty_shd.g_old_rec.pty_attribute6
728: ,p_pty_attribute7_o
729: => pqp_pty_shd.g_old_rec.pty_attribute7
723: => pqp_pty_shd.g_old_rec.pty_attribute4
724: ,p_pty_attribute5_o
725: => pqp_pty_shd.g_old_rec.pty_attribute5
726: ,p_pty_attribute6_o
727: => pqp_pty_shd.g_old_rec.pty_attribute6
728: ,p_pty_attribute7_o
729: => pqp_pty_shd.g_old_rec.pty_attribute7
730: ,p_pty_attribute8_o
731: => pqp_pty_shd.g_old_rec.pty_attribute8
725: => pqp_pty_shd.g_old_rec.pty_attribute5
726: ,p_pty_attribute6_o
727: => pqp_pty_shd.g_old_rec.pty_attribute6
728: ,p_pty_attribute7_o
729: => pqp_pty_shd.g_old_rec.pty_attribute7
730: ,p_pty_attribute8_o
731: => pqp_pty_shd.g_old_rec.pty_attribute8
732: ,p_pty_attribute9_o
733: => pqp_pty_shd.g_old_rec.pty_attribute9
727: => pqp_pty_shd.g_old_rec.pty_attribute6
728: ,p_pty_attribute7_o
729: => pqp_pty_shd.g_old_rec.pty_attribute7
730: ,p_pty_attribute8_o
731: => pqp_pty_shd.g_old_rec.pty_attribute8
732: ,p_pty_attribute9_o
733: => pqp_pty_shd.g_old_rec.pty_attribute9
734: ,p_pty_attribute10_o
735: => pqp_pty_shd.g_old_rec.pty_attribute10
729: => pqp_pty_shd.g_old_rec.pty_attribute7
730: ,p_pty_attribute8_o
731: => pqp_pty_shd.g_old_rec.pty_attribute8
732: ,p_pty_attribute9_o
733: => pqp_pty_shd.g_old_rec.pty_attribute9
734: ,p_pty_attribute10_o
735: => pqp_pty_shd.g_old_rec.pty_attribute10
736: ,p_pty_attribute11_o
737: => pqp_pty_shd.g_old_rec.pty_attribute11
731: => pqp_pty_shd.g_old_rec.pty_attribute8
732: ,p_pty_attribute9_o
733: => pqp_pty_shd.g_old_rec.pty_attribute9
734: ,p_pty_attribute10_o
735: => pqp_pty_shd.g_old_rec.pty_attribute10
736: ,p_pty_attribute11_o
737: => pqp_pty_shd.g_old_rec.pty_attribute11
738: ,p_pty_attribute12_o
739: => pqp_pty_shd.g_old_rec.pty_attribute12
733: => pqp_pty_shd.g_old_rec.pty_attribute9
734: ,p_pty_attribute10_o
735: => pqp_pty_shd.g_old_rec.pty_attribute10
736: ,p_pty_attribute11_o
737: => pqp_pty_shd.g_old_rec.pty_attribute11
738: ,p_pty_attribute12_o
739: => pqp_pty_shd.g_old_rec.pty_attribute12
740: ,p_pty_attribute13_o
741: => pqp_pty_shd.g_old_rec.pty_attribute13
735: => pqp_pty_shd.g_old_rec.pty_attribute10
736: ,p_pty_attribute11_o
737: => pqp_pty_shd.g_old_rec.pty_attribute11
738: ,p_pty_attribute12_o
739: => pqp_pty_shd.g_old_rec.pty_attribute12
740: ,p_pty_attribute13_o
741: => pqp_pty_shd.g_old_rec.pty_attribute13
742: ,p_pty_attribute14_o
743: => pqp_pty_shd.g_old_rec.pty_attribute14
737: => pqp_pty_shd.g_old_rec.pty_attribute11
738: ,p_pty_attribute12_o
739: => pqp_pty_shd.g_old_rec.pty_attribute12
740: ,p_pty_attribute13_o
741: => pqp_pty_shd.g_old_rec.pty_attribute13
742: ,p_pty_attribute14_o
743: => pqp_pty_shd.g_old_rec.pty_attribute14
744: ,p_pty_attribute15_o
745: => pqp_pty_shd.g_old_rec.pty_attribute15
739: => pqp_pty_shd.g_old_rec.pty_attribute12
740: ,p_pty_attribute13_o
741: => pqp_pty_shd.g_old_rec.pty_attribute13
742: ,p_pty_attribute14_o
743: => pqp_pty_shd.g_old_rec.pty_attribute14
744: ,p_pty_attribute15_o
745: => pqp_pty_shd.g_old_rec.pty_attribute15
746: ,p_pty_attribute16_o
747: => pqp_pty_shd.g_old_rec.pty_attribute16
741: => pqp_pty_shd.g_old_rec.pty_attribute13
742: ,p_pty_attribute14_o
743: => pqp_pty_shd.g_old_rec.pty_attribute14
744: ,p_pty_attribute15_o
745: => pqp_pty_shd.g_old_rec.pty_attribute15
746: ,p_pty_attribute16_o
747: => pqp_pty_shd.g_old_rec.pty_attribute16
748: ,p_pty_attribute17_o
749: => pqp_pty_shd.g_old_rec.pty_attribute17
743: => pqp_pty_shd.g_old_rec.pty_attribute14
744: ,p_pty_attribute15_o
745: => pqp_pty_shd.g_old_rec.pty_attribute15
746: ,p_pty_attribute16_o
747: => pqp_pty_shd.g_old_rec.pty_attribute16
748: ,p_pty_attribute17_o
749: => pqp_pty_shd.g_old_rec.pty_attribute17
750: ,p_pty_attribute18_o
751: => pqp_pty_shd.g_old_rec.pty_attribute18
745: => pqp_pty_shd.g_old_rec.pty_attribute15
746: ,p_pty_attribute16_o
747: => pqp_pty_shd.g_old_rec.pty_attribute16
748: ,p_pty_attribute17_o
749: => pqp_pty_shd.g_old_rec.pty_attribute17
750: ,p_pty_attribute18_o
751: => pqp_pty_shd.g_old_rec.pty_attribute18
752: ,p_pty_attribute19_o
753: => pqp_pty_shd.g_old_rec.pty_attribute19
747: => pqp_pty_shd.g_old_rec.pty_attribute16
748: ,p_pty_attribute17_o
749: => pqp_pty_shd.g_old_rec.pty_attribute17
750: ,p_pty_attribute18_o
751: => pqp_pty_shd.g_old_rec.pty_attribute18
752: ,p_pty_attribute19_o
753: => pqp_pty_shd.g_old_rec.pty_attribute19
754: ,p_pty_attribute20_o
755: => pqp_pty_shd.g_old_rec.pty_attribute20
749: => pqp_pty_shd.g_old_rec.pty_attribute17
750: ,p_pty_attribute18_o
751: => pqp_pty_shd.g_old_rec.pty_attribute18
752: ,p_pty_attribute19_o
753: => pqp_pty_shd.g_old_rec.pty_attribute19
754: ,p_pty_attribute20_o
755: => pqp_pty_shd.g_old_rec.pty_attribute20
756: ,p_pty_information_category_o
757: => pqp_pty_shd.g_old_rec.pty_information_category
751: => pqp_pty_shd.g_old_rec.pty_attribute18
752: ,p_pty_attribute19_o
753: => pqp_pty_shd.g_old_rec.pty_attribute19
754: ,p_pty_attribute20_o
755: => pqp_pty_shd.g_old_rec.pty_attribute20
756: ,p_pty_information_category_o
757: => pqp_pty_shd.g_old_rec.pty_information_category
758: ,p_pty_information1_o
759: => pqp_pty_shd.g_old_rec.pty_information1
753: => pqp_pty_shd.g_old_rec.pty_attribute19
754: ,p_pty_attribute20_o
755: => pqp_pty_shd.g_old_rec.pty_attribute20
756: ,p_pty_information_category_o
757: => pqp_pty_shd.g_old_rec.pty_information_category
758: ,p_pty_information1_o
759: => pqp_pty_shd.g_old_rec.pty_information1
760: ,p_pty_information2_o
761: => pqp_pty_shd.g_old_rec.pty_information2
755: => pqp_pty_shd.g_old_rec.pty_attribute20
756: ,p_pty_information_category_o
757: => pqp_pty_shd.g_old_rec.pty_information_category
758: ,p_pty_information1_o
759: => pqp_pty_shd.g_old_rec.pty_information1
760: ,p_pty_information2_o
761: => pqp_pty_shd.g_old_rec.pty_information2
762: ,p_pty_information3_o
763: => pqp_pty_shd.g_old_rec.pty_information3
757: => pqp_pty_shd.g_old_rec.pty_information_category
758: ,p_pty_information1_o
759: => pqp_pty_shd.g_old_rec.pty_information1
760: ,p_pty_information2_o
761: => pqp_pty_shd.g_old_rec.pty_information2
762: ,p_pty_information3_o
763: => pqp_pty_shd.g_old_rec.pty_information3
764: ,p_pty_information4_o
765: => pqp_pty_shd.g_old_rec.pty_information4
759: => pqp_pty_shd.g_old_rec.pty_information1
760: ,p_pty_information2_o
761: => pqp_pty_shd.g_old_rec.pty_information2
762: ,p_pty_information3_o
763: => pqp_pty_shd.g_old_rec.pty_information3
764: ,p_pty_information4_o
765: => pqp_pty_shd.g_old_rec.pty_information4
766: ,p_pty_information5_o
767: => pqp_pty_shd.g_old_rec.pty_information5
761: => pqp_pty_shd.g_old_rec.pty_information2
762: ,p_pty_information3_o
763: => pqp_pty_shd.g_old_rec.pty_information3
764: ,p_pty_information4_o
765: => pqp_pty_shd.g_old_rec.pty_information4
766: ,p_pty_information5_o
767: => pqp_pty_shd.g_old_rec.pty_information5
768: ,p_pty_information6_o
769: => pqp_pty_shd.g_old_rec.pty_information6
763: => pqp_pty_shd.g_old_rec.pty_information3
764: ,p_pty_information4_o
765: => pqp_pty_shd.g_old_rec.pty_information4
766: ,p_pty_information5_o
767: => pqp_pty_shd.g_old_rec.pty_information5
768: ,p_pty_information6_o
769: => pqp_pty_shd.g_old_rec.pty_information6
770: ,p_pty_information7_o
771: => pqp_pty_shd.g_old_rec.pty_information7
765: => pqp_pty_shd.g_old_rec.pty_information4
766: ,p_pty_information5_o
767: => pqp_pty_shd.g_old_rec.pty_information5
768: ,p_pty_information6_o
769: => pqp_pty_shd.g_old_rec.pty_information6
770: ,p_pty_information7_o
771: => pqp_pty_shd.g_old_rec.pty_information7
772: ,p_pty_information8_o
773: => pqp_pty_shd.g_old_rec.pty_information8
767: => pqp_pty_shd.g_old_rec.pty_information5
768: ,p_pty_information6_o
769: => pqp_pty_shd.g_old_rec.pty_information6
770: ,p_pty_information7_o
771: => pqp_pty_shd.g_old_rec.pty_information7
772: ,p_pty_information8_o
773: => pqp_pty_shd.g_old_rec.pty_information8
774: ,p_pty_information9_o
775: => pqp_pty_shd.g_old_rec.pty_information9
769: => pqp_pty_shd.g_old_rec.pty_information6
770: ,p_pty_information7_o
771: => pqp_pty_shd.g_old_rec.pty_information7
772: ,p_pty_information8_o
773: => pqp_pty_shd.g_old_rec.pty_information8
774: ,p_pty_information9_o
775: => pqp_pty_shd.g_old_rec.pty_information9
776: ,p_pty_information10_o
777: => pqp_pty_shd.g_old_rec.pty_information10
771: => pqp_pty_shd.g_old_rec.pty_information7
772: ,p_pty_information8_o
773: => pqp_pty_shd.g_old_rec.pty_information8
774: ,p_pty_information9_o
775: => pqp_pty_shd.g_old_rec.pty_information9
776: ,p_pty_information10_o
777: => pqp_pty_shd.g_old_rec.pty_information10
778: ,p_pty_information11_o
779: => pqp_pty_shd.g_old_rec.pty_information11
773: => pqp_pty_shd.g_old_rec.pty_information8
774: ,p_pty_information9_o
775: => pqp_pty_shd.g_old_rec.pty_information9
776: ,p_pty_information10_o
777: => pqp_pty_shd.g_old_rec.pty_information10
778: ,p_pty_information11_o
779: => pqp_pty_shd.g_old_rec.pty_information11
780: ,p_pty_information12_o
781: => pqp_pty_shd.g_old_rec.pty_information12
775: => pqp_pty_shd.g_old_rec.pty_information9
776: ,p_pty_information10_o
777: => pqp_pty_shd.g_old_rec.pty_information10
778: ,p_pty_information11_o
779: => pqp_pty_shd.g_old_rec.pty_information11
780: ,p_pty_information12_o
781: => pqp_pty_shd.g_old_rec.pty_information12
782: ,p_pty_information13_o
783: => pqp_pty_shd.g_old_rec.pty_information13
777: => pqp_pty_shd.g_old_rec.pty_information10
778: ,p_pty_information11_o
779: => pqp_pty_shd.g_old_rec.pty_information11
780: ,p_pty_information12_o
781: => pqp_pty_shd.g_old_rec.pty_information12
782: ,p_pty_information13_o
783: => pqp_pty_shd.g_old_rec.pty_information13
784: ,p_pty_information14_o
785: => pqp_pty_shd.g_old_rec.pty_information14
779: => pqp_pty_shd.g_old_rec.pty_information11
780: ,p_pty_information12_o
781: => pqp_pty_shd.g_old_rec.pty_information12
782: ,p_pty_information13_o
783: => pqp_pty_shd.g_old_rec.pty_information13
784: ,p_pty_information14_o
785: => pqp_pty_shd.g_old_rec.pty_information14
786: ,p_pty_information15_o
787: => pqp_pty_shd.g_old_rec.pty_information15
781: => pqp_pty_shd.g_old_rec.pty_information12
782: ,p_pty_information13_o
783: => pqp_pty_shd.g_old_rec.pty_information13
784: ,p_pty_information14_o
785: => pqp_pty_shd.g_old_rec.pty_information14
786: ,p_pty_information15_o
787: => pqp_pty_shd.g_old_rec.pty_information15
788: ,p_pty_information16_o
789: => pqp_pty_shd.g_old_rec.pty_information16
783: => pqp_pty_shd.g_old_rec.pty_information13
784: ,p_pty_information14_o
785: => pqp_pty_shd.g_old_rec.pty_information14
786: ,p_pty_information15_o
787: => pqp_pty_shd.g_old_rec.pty_information15
788: ,p_pty_information16_o
789: => pqp_pty_shd.g_old_rec.pty_information16
790: ,p_pty_information17_o
791: => pqp_pty_shd.g_old_rec.pty_information17
785: => pqp_pty_shd.g_old_rec.pty_information14
786: ,p_pty_information15_o
787: => pqp_pty_shd.g_old_rec.pty_information15
788: ,p_pty_information16_o
789: => pqp_pty_shd.g_old_rec.pty_information16
790: ,p_pty_information17_o
791: => pqp_pty_shd.g_old_rec.pty_information17
792: ,p_pty_information18_o
793: => pqp_pty_shd.g_old_rec.pty_information18
787: => pqp_pty_shd.g_old_rec.pty_information15
788: ,p_pty_information16_o
789: => pqp_pty_shd.g_old_rec.pty_information16
790: ,p_pty_information17_o
791: => pqp_pty_shd.g_old_rec.pty_information17
792: ,p_pty_information18_o
793: => pqp_pty_shd.g_old_rec.pty_information18
794: ,p_pty_information19_o
795: => pqp_pty_shd.g_old_rec.pty_information19
789: => pqp_pty_shd.g_old_rec.pty_information16
790: ,p_pty_information17_o
791: => pqp_pty_shd.g_old_rec.pty_information17
792: ,p_pty_information18_o
793: => pqp_pty_shd.g_old_rec.pty_information18
794: ,p_pty_information19_o
795: => pqp_pty_shd.g_old_rec.pty_information19
796: ,p_pty_information20_o
797: => pqp_pty_shd.g_old_rec.pty_information20
791: => pqp_pty_shd.g_old_rec.pty_information17
792: ,p_pty_information18_o
793: => pqp_pty_shd.g_old_rec.pty_information18
794: ,p_pty_information19_o
795: => pqp_pty_shd.g_old_rec.pty_information19
796: ,p_pty_information20_o
797: => pqp_pty_shd.g_old_rec.pty_information20
798: ,p_special_pension_type_code_o
799: => pqp_pty_shd.g_old_rec.special_pension_type_code
793: => pqp_pty_shd.g_old_rec.pty_information18
794: ,p_pty_information19_o
795: => pqp_pty_shd.g_old_rec.pty_information19
796: ,p_pty_information20_o
797: => pqp_pty_shd.g_old_rec.pty_information20
798: ,p_special_pension_type_code_o
799: => pqp_pty_shd.g_old_rec.special_pension_type_code
800: ,p_pension_sub_category_o
801: => pqp_pty_shd.g_old_rec.pension_sub_category
795: => pqp_pty_shd.g_old_rec.pty_information19
796: ,p_pty_information20_o
797: => pqp_pty_shd.g_old_rec.pty_information20
798: ,p_special_pension_type_code_o
799: => pqp_pty_shd.g_old_rec.special_pension_type_code
800: ,p_pension_sub_category_o
801: => pqp_pty_shd.g_old_rec.pension_sub_category
802: ,p_pension_basis_calc_method_o
803: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
797: => pqp_pty_shd.g_old_rec.pty_information20
798: ,p_special_pension_type_code_o
799: => pqp_pty_shd.g_old_rec.special_pension_type_code
800: ,p_pension_sub_category_o
801: => pqp_pty_shd.g_old_rec.pension_sub_category
802: ,p_pension_basis_calc_method_o
803: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
804: ,p_pension_salary_balance_o
805: => pqp_pty_shd.g_old_rec.pension_salary_balance
799: => pqp_pty_shd.g_old_rec.special_pension_type_code
800: ,p_pension_sub_category_o
801: => pqp_pty_shd.g_old_rec.pension_sub_category
802: ,p_pension_basis_calc_method_o
803: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
804: ,p_pension_salary_balance_o
805: => pqp_pty_shd.g_old_rec.pension_salary_balance
806: ,p_recurring_bonus_percent_o
807: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
801: => pqp_pty_shd.g_old_rec.pension_sub_category
802: ,p_pension_basis_calc_method_o
803: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
804: ,p_pension_salary_balance_o
805: => pqp_pty_shd.g_old_rec.pension_salary_balance
806: ,p_recurring_bonus_percent_o
807: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
808: ,p_non_recur_bonus_percent_o
809: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
803: => pqp_pty_shd.g_old_rec.pension_basis_calc_method
804: ,p_pension_salary_balance_o
805: => pqp_pty_shd.g_old_rec.pension_salary_balance
806: ,p_recurring_bonus_percent_o
807: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
808: ,p_non_recur_bonus_percent_o
809: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
810: ,p_recurring_bonus_balance_o
811: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
805: => pqp_pty_shd.g_old_rec.pension_salary_balance
806: ,p_recurring_bonus_percent_o
807: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
808: ,p_non_recur_bonus_percent_o
809: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
810: ,p_recurring_bonus_balance_o
811: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
812: ,p_non_recur_bonus_balance_o
813: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
807: => pqp_pty_shd.g_old_rec.recurring_bonus_percent
808: ,p_non_recur_bonus_percent_o
809: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
810: ,p_recurring_bonus_balance_o
811: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
812: ,p_non_recur_bonus_balance_o
813: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
814: ,p_std_tax_reduction_o
815: => pqp_pty_shd.g_old_rec.std_tax_reduction
809: => pqp_pty_shd.g_old_rec.non_recurring_bonus_percent
810: ,p_recurring_bonus_balance_o
811: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
812: ,p_non_recur_bonus_balance_o
813: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
814: ,p_std_tax_reduction_o
815: => pqp_pty_shd.g_old_rec.std_tax_reduction
816: ,p_spl_tax_reduction_o
817: => pqp_pty_shd.g_old_rec.spl_tax_reduction
811: => pqp_pty_shd.g_old_rec.recurring_bonus_balance
812: ,p_non_recur_bonus_balance_o
813: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
814: ,p_std_tax_reduction_o
815: => pqp_pty_shd.g_old_rec.std_tax_reduction
816: ,p_spl_tax_reduction_o
817: => pqp_pty_shd.g_old_rec.spl_tax_reduction
818: ,p_sig_sal_spl_tax_reduction_o
819: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
813: => pqp_pty_shd.g_old_rec.non_recurring_bonus_balance
814: ,p_std_tax_reduction_o
815: => pqp_pty_shd.g_old_rec.std_tax_reduction
816: ,p_spl_tax_reduction_o
817: => pqp_pty_shd.g_old_rec.spl_tax_reduction
818: ,p_sig_sal_spl_tax_reduction_o
819: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
820: ,p_sig_sal_non_tax_reduction_o
821: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
815: => pqp_pty_shd.g_old_rec.std_tax_reduction
816: ,p_spl_tax_reduction_o
817: => pqp_pty_shd.g_old_rec.spl_tax_reduction
818: ,p_sig_sal_spl_tax_reduction_o
819: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
820: ,p_sig_sal_non_tax_reduction_o
821: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
822: ,p_sig_sal_std_tax_reduction_o
823: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
817: => pqp_pty_shd.g_old_rec.spl_tax_reduction
818: ,p_sig_sal_spl_tax_reduction_o
819: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
820: ,p_sig_sal_non_tax_reduction_o
821: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
822: ,p_sig_sal_std_tax_reduction_o
823: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
824: ,p_sii_std_tax_reduction_o
825: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
819: => pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction
820: ,p_sig_sal_non_tax_reduction_o
821: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
822: ,p_sig_sal_std_tax_reduction_o
823: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
824: ,p_sii_std_tax_reduction_o
825: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
826: ,p_sii_spl_tax_reduction_o
827: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
821: => pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction
822: ,p_sig_sal_std_tax_reduction_o
823: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
824: ,p_sii_std_tax_reduction_o
825: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
826: ,p_sii_spl_tax_reduction_o
827: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
828: ,p_sii_non_tax_reduction_o
829: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
823: => pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction
824: ,p_sii_std_tax_reduction_o
825: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
826: ,p_sii_spl_tax_reduction_o
827: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
828: ,p_sii_non_tax_reduction_o
829: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
830: ,p_prev_year_bonus_include_o
831: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
825: => pqp_pty_shd.g_old_rec.sii_std_tax_reduction
826: ,p_sii_spl_tax_reduction_o
827: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
828: ,p_sii_non_tax_reduction_o
829: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
830: ,p_prev_year_bonus_include_o
831: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
832: ,p_recurring_bonus_period_o
833: => pqp_pty_shd.g_old_rec.recurring_bonus_period
827: => pqp_pty_shd.g_old_rec.sii_spl_tax_reduction
828: ,p_sii_non_tax_reduction_o
829: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
830: ,p_prev_year_bonus_include_o
831: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
832: ,p_recurring_bonus_period_o
833: => pqp_pty_shd.g_old_rec.recurring_bonus_period
834: ,p_non_recurring_bonus_period_o
835: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
829: => pqp_pty_shd.g_old_rec.sii_non_tax_reduction
830: ,p_prev_year_bonus_include_o
831: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
832: ,p_recurring_bonus_period_o
833: => pqp_pty_shd.g_old_rec.recurring_bonus_period
834: ,p_non_recurring_bonus_period_o
835: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
836: ,p_ee_age_threshold_o
837: => pqp_pty_shd.g_old_rec.ee_age_threshold
831: => pqp_pty_shd.g_old_rec.previous_year_bonus_included
832: ,p_recurring_bonus_period_o
833: => pqp_pty_shd.g_old_rec.recurring_bonus_period
834: ,p_non_recurring_bonus_period_o
835: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
836: ,p_ee_age_threshold_o
837: => pqp_pty_shd.g_old_rec.ee_age_threshold
838: ,p_er_age_threshold_o
839: => pqp_pty_shd.g_old_rec.er_age_threshold
833: => pqp_pty_shd.g_old_rec.recurring_bonus_period
834: ,p_non_recurring_bonus_period_o
835: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
836: ,p_ee_age_threshold_o
837: => pqp_pty_shd.g_old_rec.ee_age_threshold
838: ,p_er_age_threshold_o
839: => pqp_pty_shd.g_old_rec.er_age_threshold
840: ,p_ee_age_contribution_o
841: => pqp_pty_shd.g_old_rec.ee_age_contribution
835: => pqp_pty_shd.g_old_rec.non_recurring_bonus_period
836: ,p_ee_age_threshold_o
837: => pqp_pty_shd.g_old_rec.ee_age_threshold
838: ,p_er_age_threshold_o
839: => pqp_pty_shd.g_old_rec.er_age_threshold
840: ,p_ee_age_contribution_o
841: => pqp_pty_shd.g_old_rec.ee_age_contribution
842: ,p_er_age_contribution_o
843: => pqp_pty_shd.g_old_rec.er_age_contribution
837: => pqp_pty_shd.g_old_rec.ee_age_threshold
838: ,p_er_age_threshold_o
839: => pqp_pty_shd.g_old_rec.er_age_threshold
840: ,p_ee_age_contribution_o
841: => pqp_pty_shd.g_old_rec.ee_age_contribution
842: ,p_er_age_contribution_o
843: => pqp_pty_shd.g_old_rec.er_age_contribution
844: );
845: --
839: => pqp_pty_shd.g_old_rec.er_age_threshold
840: ,p_ee_age_contribution_o
841: => pqp_pty_shd.g_old_rec.ee_age_contribution
842: ,p_er_age_contribution_o
843: => pqp_pty_shd.g_old_rec.er_age_contribution
844: );
845: --
846: exception
847: --
899: --
900: -- {End Of Comments}
901: -- ----------------------------------------------------------------------------
902: Procedure convert_defs
903: (p_rec in out nocopy pqp_pty_shd.g_rec_type
904: ) is
905: --
906: Begin
907: --
911: -- is being used then we must set to the 'current' argument value.
912: --
913: If (p_rec.pension_type_name = hr_api.g_varchar2) then
914: p_rec.pension_type_name :=
915: pqp_pty_shd.g_old_rec.pension_type_name;
916: End If;
917: If (p_rec.pension_category = hr_api.g_varchar2) then
918: p_rec.pension_category :=
919: pqp_pty_shd.g_old_rec.pension_category;
915: pqp_pty_shd.g_old_rec.pension_type_name;
916: End If;
917: If (p_rec.pension_category = hr_api.g_varchar2) then
918: p_rec.pension_category :=
919: pqp_pty_shd.g_old_rec.pension_category;
920: End If;
921: If (p_rec.pension_provider_type = hr_api.g_varchar2) then
922: p_rec.pension_provider_type :=
923: pqp_pty_shd.g_old_rec.pension_provider_type;
919: pqp_pty_shd.g_old_rec.pension_category;
920: End If;
921: If (p_rec.pension_provider_type = hr_api.g_varchar2) then
922: p_rec.pension_provider_type :=
923: pqp_pty_shd.g_old_rec.pension_provider_type;
924: End If;
925: If (p_rec.salary_calculation_method = hr_api.g_varchar2) then
926: p_rec.salary_calculation_method :=
927: pqp_pty_shd.g_old_rec.salary_calculation_method;
923: pqp_pty_shd.g_old_rec.pension_provider_type;
924: End If;
925: If (p_rec.salary_calculation_method = hr_api.g_varchar2) then
926: p_rec.salary_calculation_method :=
927: pqp_pty_shd.g_old_rec.salary_calculation_method;
928: End If;
929: If (p_rec.threshold_conversion_rule = hr_api.g_varchar2) then
930: p_rec.threshold_conversion_rule :=
931: pqp_pty_shd.g_old_rec.threshold_conversion_rule;
927: pqp_pty_shd.g_old_rec.salary_calculation_method;
928: End If;
929: If (p_rec.threshold_conversion_rule = hr_api.g_varchar2) then
930: p_rec.threshold_conversion_rule :=
931: pqp_pty_shd.g_old_rec.threshold_conversion_rule;
932: End If;
933: If (p_rec.contribution_conversion_rule = hr_api.g_varchar2) then
934: p_rec.contribution_conversion_rule :=
935: pqp_pty_shd.g_old_rec.contribution_conversion_rule;
931: pqp_pty_shd.g_old_rec.threshold_conversion_rule;
932: End If;
933: If (p_rec.contribution_conversion_rule = hr_api.g_varchar2) then
934: p_rec.contribution_conversion_rule :=
935: pqp_pty_shd.g_old_rec.contribution_conversion_rule;
936: End If;
937: If (p_rec.er_annual_limit = hr_api.g_number) then
938: p_rec.er_annual_limit :=
939: pqp_pty_shd.g_old_rec.er_annual_limit;
935: pqp_pty_shd.g_old_rec.contribution_conversion_rule;
936: End If;
937: If (p_rec.er_annual_limit = hr_api.g_number) then
938: p_rec.er_annual_limit :=
939: pqp_pty_shd.g_old_rec.er_annual_limit;
940: End If;
941: If (p_rec.ee_annual_limit = hr_api.g_number) then
942: p_rec.ee_annual_limit :=
943: pqp_pty_shd.g_old_rec.ee_annual_limit;
939: pqp_pty_shd.g_old_rec.er_annual_limit;
940: End If;
941: If (p_rec.ee_annual_limit = hr_api.g_number) then
942: p_rec.ee_annual_limit :=
943: pqp_pty_shd.g_old_rec.ee_annual_limit;
944: End If;
945: If (p_rec.er_annual_salary_threshold = hr_api.g_number) then
946: p_rec.er_annual_salary_threshold :=
947: pqp_pty_shd.g_old_rec.er_annual_salary_threshold;
943: pqp_pty_shd.g_old_rec.ee_annual_limit;
944: End If;
945: If (p_rec.er_annual_salary_threshold = hr_api.g_number) then
946: p_rec.er_annual_salary_threshold :=
947: pqp_pty_shd.g_old_rec.er_annual_salary_threshold;
948: End If;
949: If (p_rec.ee_annual_salary_threshold = hr_api.g_number) then
950: p_rec.ee_annual_salary_threshold :=
951: pqp_pty_shd.g_old_rec.ee_annual_salary_threshold;
947: pqp_pty_shd.g_old_rec.er_annual_salary_threshold;
948: End If;
949: If (p_rec.ee_annual_salary_threshold = hr_api.g_number) then
950: p_rec.ee_annual_salary_threshold :=
951: pqp_pty_shd.g_old_rec.ee_annual_salary_threshold;
952: End If;
953: If (p_rec.business_group_id = hr_api.g_number) then
954: p_rec.business_group_id :=
955: pqp_pty_shd.g_old_rec.business_group_id;
951: pqp_pty_shd.g_old_rec.ee_annual_salary_threshold;
952: End If;
953: If (p_rec.business_group_id = hr_api.g_number) then
954: p_rec.business_group_id :=
955: pqp_pty_shd.g_old_rec.business_group_id;
956: End If;
957: If (p_rec.legislation_code = hr_api.g_varchar2) then
958: p_rec.legislation_code :=
959: pqp_pty_shd.g_old_rec.legislation_code;
955: pqp_pty_shd.g_old_rec.business_group_id;
956: End If;
957: If (p_rec.legislation_code = hr_api.g_varchar2) then
958: p_rec.legislation_code :=
959: pqp_pty_shd.g_old_rec.legislation_code;
960: End If;
961: If (p_rec.description = hr_api.g_varchar2) then
962: p_rec.description :=
963: pqp_pty_shd.g_old_rec.description;
959: pqp_pty_shd.g_old_rec.legislation_code;
960: End If;
961: If (p_rec.description = hr_api.g_varchar2) then
962: p_rec.description :=
963: pqp_pty_shd.g_old_rec.description;
964: End If;
965: If (p_rec.minimum_age = hr_api.g_number) then
966: p_rec.minimum_age :=
967: pqp_pty_shd.g_old_rec.minimum_age;
963: pqp_pty_shd.g_old_rec.description;
964: End If;
965: If (p_rec.minimum_age = hr_api.g_number) then
966: p_rec.minimum_age :=
967: pqp_pty_shd.g_old_rec.minimum_age;
968: End If;
969: If (p_rec.ee_contribution_percent = hr_api.g_number) then
970: p_rec.ee_contribution_percent :=
971: pqp_pty_shd.g_old_rec.ee_contribution_percent;
967: pqp_pty_shd.g_old_rec.minimum_age;
968: End If;
969: If (p_rec.ee_contribution_percent = hr_api.g_number) then
970: p_rec.ee_contribution_percent :=
971: pqp_pty_shd.g_old_rec.ee_contribution_percent;
972: End If;
973: If (p_rec.maximum_age = hr_api.g_number) then
974: p_rec.maximum_age :=
975: pqp_pty_shd.g_old_rec.maximum_age;
971: pqp_pty_shd.g_old_rec.ee_contribution_percent;
972: End If;
973: If (p_rec.maximum_age = hr_api.g_number) then
974: p_rec.maximum_age :=
975: pqp_pty_shd.g_old_rec.maximum_age;
976: End If;
977: If (p_rec.er_contribution_percent = hr_api.g_number) then
978: p_rec.er_contribution_percent :=
979: pqp_pty_shd.g_old_rec.er_contribution_percent;
975: pqp_pty_shd.g_old_rec.maximum_age;
976: End If;
977: If (p_rec.er_contribution_percent = hr_api.g_number) then
978: p_rec.er_contribution_percent :=
979: pqp_pty_shd.g_old_rec.er_contribution_percent;
980: End If;
981: If (p_rec.ee_annual_contribution = hr_api.g_number) then
982: p_rec.ee_annual_contribution :=
983: pqp_pty_shd.g_old_rec.ee_annual_contribution;
979: pqp_pty_shd.g_old_rec.er_contribution_percent;
980: End If;
981: If (p_rec.ee_annual_contribution = hr_api.g_number) then
982: p_rec.ee_annual_contribution :=
983: pqp_pty_shd.g_old_rec.ee_annual_contribution;
984: End If;
985: If (p_rec.er_annual_contribution = hr_api.g_number) then
986: p_rec.er_annual_contribution :=
987: pqp_pty_shd.g_old_rec.er_annual_contribution;
983: pqp_pty_shd.g_old_rec.ee_annual_contribution;
984: End If;
985: If (p_rec.er_annual_contribution = hr_api.g_number) then
986: p_rec.er_annual_contribution :=
987: pqp_pty_shd.g_old_rec.er_annual_contribution;
988: End If;
989: If (p_rec.annual_premium_amount = hr_api.g_number) then
990: p_rec.annual_premium_amount :=
991: pqp_pty_shd.g_old_rec.annual_premium_amount;
987: pqp_pty_shd.g_old_rec.er_annual_contribution;
988: End If;
989: If (p_rec.annual_premium_amount = hr_api.g_number) then
990: p_rec.annual_premium_amount :=
991: pqp_pty_shd.g_old_rec.annual_premium_amount;
992: End If;
993: If (p_rec.ee_contribution_bal_type_id = hr_api.g_number) then
994: p_rec.ee_contribution_bal_type_id :=
995: pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id;
991: pqp_pty_shd.g_old_rec.annual_premium_amount;
992: End If;
993: If (p_rec.ee_contribution_bal_type_id = hr_api.g_number) then
994: p_rec.ee_contribution_bal_type_id :=
995: pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id;
996: End If;
997: If (p_rec.er_contribution_bal_type_id = hr_api.g_number) then
998: p_rec.er_contribution_bal_type_id :=
999: pqp_pty_shd.g_old_rec.er_contribution_bal_type_id;
995: pqp_pty_shd.g_old_rec.ee_contribution_bal_type_id;
996: End If;
997: If (p_rec.er_contribution_bal_type_id = hr_api.g_number) then
998: p_rec.er_contribution_bal_type_id :=
999: pqp_pty_shd.g_old_rec.er_contribution_bal_type_id;
1000: End If;
1001: If (p_rec.balance_init_element_type_id = hr_api.g_number) then
1002: p_rec.balance_init_element_type_id :=
1003: pqp_pty_shd.g_old_rec.balance_init_element_type_id;
999: pqp_pty_shd.g_old_rec.er_contribution_bal_type_id;
1000: End If;
1001: If (p_rec.balance_init_element_type_id = hr_api.g_number) then
1002: p_rec.balance_init_element_type_id :=
1003: pqp_pty_shd.g_old_rec.balance_init_element_type_id;
1004: End If;
1005:
1006:
1007:
1006:
1007:
1008: If (p_rec.ee_contribution_fixed_rate = hr_api.g_number) then --added for UK
1009: p_rec.ee_contribution_fixed_rate:=
1010: pqp_pty_shd.g_old_rec.ee_contribution_fixed_rate;
1011: End If;
1012:
1013: If (p_rec.er_contribution_fixed_rate = hr_api.g_number) then --added for UK
1014: p_rec.er_contribution_fixed_rate:=
1011: End If;
1012:
1013: If (p_rec.er_contribution_fixed_rate = hr_api.g_number) then --added for UK
1014: p_rec.er_contribution_fixed_rate:=
1015: pqp_pty_shd.g_old_rec.er_contribution_fixed_rate;
1016: End If;
1017:
1018: If (p_rec.pty_attribute_category = hr_api.g_varchar2) then
1019: p_rec.pty_attribute_category :=
1016: End If;
1017:
1018: If (p_rec.pty_attribute_category = hr_api.g_varchar2) then
1019: p_rec.pty_attribute_category :=
1020: pqp_pty_shd.g_old_rec.pty_attribute_category;
1021: End If;
1022: If (p_rec.pty_attribute1 = hr_api.g_varchar2) then
1023: p_rec.pty_attribute1 :=
1024: pqp_pty_shd.g_old_rec.pty_attribute1;
1020: pqp_pty_shd.g_old_rec.pty_attribute_category;
1021: End If;
1022: If (p_rec.pty_attribute1 = hr_api.g_varchar2) then
1023: p_rec.pty_attribute1 :=
1024: pqp_pty_shd.g_old_rec.pty_attribute1;
1025: End If;
1026: If (p_rec.pty_attribute2 = hr_api.g_varchar2) then
1027: p_rec.pty_attribute2 :=
1028: pqp_pty_shd.g_old_rec.pty_attribute2;
1024: pqp_pty_shd.g_old_rec.pty_attribute1;
1025: End If;
1026: If (p_rec.pty_attribute2 = hr_api.g_varchar2) then
1027: p_rec.pty_attribute2 :=
1028: pqp_pty_shd.g_old_rec.pty_attribute2;
1029: End If;
1030: If (p_rec.pty_attribute3 = hr_api.g_varchar2) then
1031: p_rec.pty_attribute3 :=
1032: pqp_pty_shd.g_old_rec.pty_attribute3;
1028: pqp_pty_shd.g_old_rec.pty_attribute2;
1029: End If;
1030: If (p_rec.pty_attribute3 = hr_api.g_varchar2) then
1031: p_rec.pty_attribute3 :=
1032: pqp_pty_shd.g_old_rec.pty_attribute3;
1033: End If;
1034: If (p_rec.pty_attribute4 = hr_api.g_varchar2) then
1035: p_rec.pty_attribute4 :=
1036: pqp_pty_shd.g_old_rec.pty_attribute4;
1032: pqp_pty_shd.g_old_rec.pty_attribute3;
1033: End If;
1034: If (p_rec.pty_attribute4 = hr_api.g_varchar2) then
1035: p_rec.pty_attribute4 :=
1036: pqp_pty_shd.g_old_rec.pty_attribute4;
1037: End If;
1038: If (p_rec.pty_attribute5 = hr_api.g_varchar2) then
1039: p_rec.pty_attribute5 :=
1040: pqp_pty_shd.g_old_rec.pty_attribute5;
1036: pqp_pty_shd.g_old_rec.pty_attribute4;
1037: End If;
1038: If (p_rec.pty_attribute5 = hr_api.g_varchar2) then
1039: p_rec.pty_attribute5 :=
1040: pqp_pty_shd.g_old_rec.pty_attribute5;
1041: End If;
1042: If (p_rec.pty_attribute6 = hr_api.g_varchar2) then
1043: p_rec.pty_attribute6 :=
1044: pqp_pty_shd.g_old_rec.pty_attribute6;
1040: pqp_pty_shd.g_old_rec.pty_attribute5;
1041: End If;
1042: If (p_rec.pty_attribute6 = hr_api.g_varchar2) then
1043: p_rec.pty_attribute6 :=
1044: pqp_pty_shd.g_old_rec.pty_attribute6;
1045: End If;
1046: If (p_rec.pty_attribute7 = hr_api.g_varchar2) then
1047: p_rec.pty_attribute7 :=
1048: pqp_pty_shd.g_old_rec.pty_attribute7;
1044: pqp_pty_shd.g_old_rec.pty_attribute6;
1045: End If;
1046: If (p_rec.pty_attribute7 = hr_api.g_varchar2) then
1047: p_rec.pty_attribute7 :=
1048: pqp_pty_shd.g_old_rec.pty_attribute7;
1049: End If;
1050: If (p_rec.pty_attribute8 = hr_api.g_varchar2) then
1051: p_rec.pty_attribute8 :=
1052: pqp_pty_shd.g_old_rec.pty_attribute8;
1048: pqp_pty_shd.g_old_rec.pty_attribute7;
1049: End If;
1050: If (p_rec.pty_attribute8 = hr_api.g_varchar2) then
1051: p_rec.pty_attribute8 :=
1052: pqp_pty_shd.g_old_rec.pty_attribute8;
1053: End If;
1054: If (p_rec.pty_attribute9 = hr_api.g_varchar2) then
1055: p_rec.pty_attribute9 :=
1056: pqp_pty_shd.g_old_rec.pty_attribute9;
1052: pqp_pty_shd.g_old_rec.pty_attribute8;
1053: End If;
1054: If (p_rec.pty_attribute9 = hr_api.g_varchar2) then
1055: p_rec.pty_attribute9 :=
1056: pqp_pty_shd.g_old_rec.pty_attribute9;
1057: End If;
1058: If (p_rec.pty_attribute10 = hr_api.g_varchar2) then
1059: p_rec.pty_attribute10 :=
1060: pqp_pty_shd.g_old_rec.pty_attribute10;
1056: pqp_pty_shd.g_old_rec.pty_attribute9;
1057: End If;
1058: If (p_rec.pty_attribute10 = hr_api.g_varchar2) then
1059: p_rec.pty_attribute10 :=
1060: pqp_pty_shd.g_old_rec.pty_attribute10;
1061: End If;
1062: If (p_rec.pty_attribute11 = hr_api.g_varchar2) then
1063: p_rec.pty_attribute11 :=
1064: pqp_pty_shd.g_old_rec.pty_attribute11;
1060: pqp_pty_shd.g_old_rec.pty_attribute10;
1061: End If;
1062: If (p_rec.pty_attribute11 = hr_api.g_varchar2) then
1063: p_rec.pty_attribute11 :=
1064: pqp_pty_shd.g_old_rec.pty_attribute11;
1065: End If;
1066: If (p_rec.pty_attribute12 = hr_api.g_varchar2) then
1067: p_rec.pty_attribute12 :=
1068: pqp_pty_shd.g_old_rec.pty_attribute12;
1064: pqp_pty_shd.g_old_rec.pty_attribute11;
1065: End If;
1066: If (p_rec.pty_attribute12 = hr_api.g_varchar2) then
1067: p_rec.pty_attribute12 :=
1068: pqp_pty_shd.g_old_rec.pty_attribute12;
1069: End If;
1070: If (p_rec.pty_attribute13 = hr_api.g_varchar2) then
1071: p_rec.pty_attribute13 :=
1072: pqp_pty_shd.g_old_rec.pty_attribute13;
1068: pqp_pty_shd.g_old_rec.pty_attribute12;
1069: End If;
1070: If (p_rec.pty_attribute13 = hr_api.g_varchar2) then
1071: p_rec.pty_attribute13 :=
1072: pqp_pty_shd.g_old_rec.pty_attribute13;
1073: End If;
1074: If (p_rec.pty_attribute14 = hr_api.g_varchar2) then
1075: p_rec.pty_attribute14 :=
1076: pqp_pty_shd.g_old_rec.pty_attribute14;
1072: pqp_pty_shd.g_old_rec.pty_attribute13;
1073: End If;
1074: If (p_rec.pty_attribute14 = hr_api.g_varchar2) then
1075: p_rec.pty_attribute14 :=
1076: pqp_pty_shd.g_old_rec.pty_attribute14;
1077: End If;
1078: If (p_rec.pty_attribute15 = hr_api.g_varchar2) then
1079: p_rec.pty_attribute15 :=
1080: pqp_pty_shd.g_old_rec.pty_attribute15;
1076: pqp_pty_shd.g_old_rec.pty_attribute14;
1077: End If;
1078: If (p_rec.pty_attribute15 = hr_api.g_varchar2) then
1079: p_rec.pty_attribute15 :=
1080: pqp_pty_shd.g_old_rec.pty_attribute15;
1081: End If;
1082: If (p_rec.pty_attribute16 = hr_api.g_varchar2) then
1083: p_rec.pty_attribute16 :=
1084: pqp_pty_shd.g_old_rec.pty_attribute16;
1080: pqp_pty_shd.g_old_rec.pty_attribute15;
1081: End If;
1082: If (p_rec.pty_attribute16 = hr_api.g_varchar2) then
1083: p_rec.pty_attribute16 :=
1084: pqp_pty_shd.g_old_rec.pty_attribute16;
1085: End If;
1086: If (p_rec.pty_attribute17 = hr_api.g_varchar2) then
1087: p_rec.pty_attribute17 :=
1088: pqp_pty_shd.g_old_rec.pty_attribute17;
1084: pqp_pty_shd.g_old_rec.pty_attribute16;
1085: End If;
1086: If (p_rec.pty_attribute17 = hr_api.g_varchar2) then
1087: p_rec.pty_attribute17 :=
1088: pqp_pty_shd.g_old_rec.pty_attribute17;
1089: End If;
1090: If (p_rec.pty_attribute18 = hr_api.g_varchar2) then
1091: p_rec.pty_attribute18 :=
1092: pqp_pty_shd.g_old_rec.pty_attribute18;
1088: pqp_pty_shd.g_old_rec.pty_attribute17;
1089: End If;
1090: If (p_rec.pty_attribute18 = hr_api.g_varchar2) then
1091: p_rec.pty_attribute18 :=
1092: pqp_pty_shd.g_old_rec.pty_attribute18;
1093: End If;
1094: If (p_rec.pty_attribute19 = hr_api.g_varchar2) then
1095: p_rec.pty_attribute19 :=
1096: pqp_pty_shd.g_old_rec.pty_attribute19;
1092: pqp_pty_shd.g_old_rec.pty_attribute18;
1093: End If;
1094: If (p_rec.pty_attribute19 = hr_api.g_varchar2) then
1095: p_rec.pty_attribute19 :=
1096: pqp_pty_shd.g_old_rec.pty_attribute19;
1097: End If;
1098: If (p_rec.pty_attribute20 = hr_api.g_varchar2) then
1099: p_rec.pty_attribute20 :=
1100: pqp_pty_shd.g_old_rec.pty_attribute20;
1096: pqp_pty_shd.g_old_rec.pty_attribute19;
1097: End If;
1098: If (p_rec.pty_attribute20 = hr_api.g_varchar2) then
1099: p_rec.pty_attribute20 :=
1100: pqp_pty_shd.g_old_rec.pty_attribute20;
1101: End If;
1102: If (p_rec.pty_information_category = hr_api.g_varchar2) then
1103: p_rec.pty_information_category :=
1104: pqp_pty_shd.g_old_rec.pty_information_category;
1100: pqp_pty_shd.g_old_rec.pty_attribute20;
1101: End If;
1102: If (p_rec.pty_information_category = hr_api.g_varchar2) then
1103: p_rec.pty_information_category :=
1104: pqp_pty_shd.g_old_rec.pty_information_category;
1105: End If;
1106: If (p_rec.pty_information1 = hr_api.g_varchar2) then
1107: p_rec.pty_information1 :=
1108: pqp_pty_shd.g_old_rec.pty_information1;
1104: pqp_pty_shd.g_old_rec.pty_information_category;
1105: End If;
1106: If (p_rec.pty_information1 = hr_api.g_varchar2) then
1107: p_rec.pty_information1 :=
1108: pqp_pty_shd.g_old_rec.pty_information1;
1109: End If;
1110: If (p_rec.pty_information2 = hr_api.g_varchar2) then
1111: p_rec.pty_information2 :=
1112: pqp_pty_shd.g_old_rec.pty_information2;
1108: pqp_pty_shd.g_old_rec.pty_information1;
1109: End If;
1110: If (p_rec.pty_information2 = hr_api.g_varchar2) then
1111: p_rec.pty_information2 :=
1112: pqp_pty_shd.g_old_rec.pty_information2;
1113: End If;
1114: If (p_rec.pty_information3 = hr_api.g_varchar2) then
1115: p_rec.pty_information3 :=
1116: pqp_pty_shd.g_old_rec.pty_information3;
1112: pqp_pty_shd.g_old_rec.pty_information2;
1113: End If;
1114: If (p_rec.pty_information3 = hr_api.g_varchar2) then
1115: p_rec.pty_information3 :=
1116: pqp_pty_shd.g_old_rec.pty_information3;
1117: End If;
1118: If (p_rec.pty_information4 = hr_api.g_varchar2) then
1119: p_rec.pty_information4 :=
1120: pqp_pty_shd.g_old_rec.pty_information4;
1116: pqp_pty_shd.g_old_rec.pty_information3;
1117: End If;
1118: If (p_rec.pty_information4 = hr_api.g_varchar2) then
1119: p_rec.pty_information4 :=
1120: pqp_pty_shd.g_old_rec.pty_information4;
1121: End If;
1122: If (p_rec.pty_information5 = hr_api.g_varchar2) then
1123: p_rec.pty_information5 :=
1124: pqp_pty_shd.g_old_rec.pty_information5;
1120: pqp_pty_shd.g_old_rec.pty_information4;
1121: End If;
1122: If (p_rec.pty_information5 = hr_api.g_varchar2) then
1123: p_rec.pty_information5 :=
1124: pqp_pty_shd.g_old_rec.pty_information5;
1125: End If;
1126: If (p_rec.pty_information6 = hr_api.g_varchar2) then
1127: p_rec.pty_information6 :=
1128: pqp_pty_shd.g_old_rec.pty_information6;
1124: pqp_pty_shd.g_old_rec.pty_information5;
1125: End If;
1126: If (p_rec.pty_information6 = hr_api.g_varchar2) then
1127: p_rec.pty_information6 :=
1128: pqp_pty_shd.g_old_rec.pty_information6;
1129: End If;
1130: If (p_rec.pty_information7 = hr_api.g_varchar2) then
1131: p_rec.pty_information7 :=
1132: pqp_pty_shd.g_old_rec.pty_information7;
1128: pqp_pty_shd.g_old_rec.pty_information6;
1129: End If;
1130: If (p_rec.pty_information7 = hr_api.g_varchar2) then
1131: p_rec.pty_information7 :=
1132: pqp_pty_shd.g_old_rec.pty_information7;
1133: End If;
1134: If (p_rec.pty_information8 = hr_api.g_varchar2) then
1135: p_rec.pty_information8 :=
1136: pqp_pty_shd.g_old_rec.pty_information8;
1132: pqp_pty_shd.g_old_rec.pty_information7;
1133: End If;
1134: If (p_rec.pty_information8 = hr_api.g_varchar2) then
1135: p_rec.pty_information8 :=
1136: pqp_pty_shd.g_old_rec.pty_information8;
1137: End If;
1138: If (p_rec.pty_information9 = hr_api.g_varchar2) then
1139: p_rec.pty_information9 :=
1140: pqp_pty_shd.g_old_rec.pty_information9;
1136: pqp_pty_shd.g_old_rec.pty_information8;
1137: End If;
1138: If (p_rec.pty_information9 = hr_api.g_varchar2) then
1139: p_rec.pty_information9 :=
1140: pqp_pty_shd.g_old_rec.pty_information9;
1141: End If;
1142: If (p_rec.pty_information10 = hr_api.g_varchar2) then
1143: p_rec.pty_information10 :=
1144: pqp_pty_shd.g_old_rec.pty_information10;
1140: pqp_pty_shd.g_old_rec.pty_information9;
1141: End If;
1142: If (p_rec.pty_information10 = hr_api.g_varchar2) then
1143: p_rec.pty_information10 :=
1144: pqp_pty_shd.g_old_rec.pty_information10;
1145: End If;
1146: If (p_rec.pty_information11 = hr_api.g_varchar2) then
1147: p_rec.pty_information11 :=
1148: pqp_pty_shd.g_old_rec.pty_information11;
1144: pqp_pty_shd.g_old_rec.pty_information10;
1145: End If;
1146: If (p_rec.pty_information11 = hr_api.g_varchar2) then
1147: p_rec.pty_information11 :=
1148: pqp_pty_shd.g_old_rec.pty_information11;
1149: End If;
1150: If (p_rec.pty_information12 = hr_api.g_varchar2) then
1151: p_rec.pty_information12 :=
1152: pqp_pty_shd.g_old_rec.pty_information12;
1148: pqp_pty_shd.g_old_rec.pty_information11;
1149: End If;
1150: If (p_rec.pty_information12 = hr_api.g_varchar2) then
1151: p_rec.pty_information12 :=
1152: pqp_pty_shd.g_old_rec.pty_information12;
1153: End If;
1154: If (p_rec.pty_information13 = hr_api.g_varchar2) then
1155: p_rec.pty_information13 :=
1156: pqp_pty_shd.g_old_rec.pty_information13;
1152: pqp_pty_shd.g_old_rec.pty_information12;
1153: End If;
1154: If (p_rec.pty_information13 = hr_api.g_varchar2) then
1155: p_rec.pty_information13 :=
1156: pqp_pty_shd.g_old_rec.pty_information13;
1157: End If;
1158: If (p_rec.pty_information14 = hr_api.g_varchar2) then
1159: p_rec.pty_information14 :=
1160: pqp_pty_shd.g_old_rec.pty_information14;
1156: pqp_pty_shd.g_old_rec.pty_information13;
1157: End If;
1158: If (p_rec.pty_information14 = hr_api.g_varchar2) then
1159: p_rec.pty_information14 :=
1160: pqp_pty_shd.g_old_rec.pty_information14;
1161: End If;
1162: If (p_rec.pty_information15 = hr_api.g_varchar2) then
1163: p_rec.pty_information15 :=
1164: pqp_pty_shd.g_old_rec.pty_information15;
1160: pqp_pty_shd.g_old_rec.pty_information14;
1161: End If;
1162: If (p_rec.pty_information15 = hr_api.g_varchar2) then
1163: p_rec.pty_information15 :=
1164: pqp_pty_shd.g_old_rec.pty_information15;
1165: End If;
1166: If (p_rec.pty_information16 = hr_api.g_varchar2) then
1167: p_rec.pty_information16 :=
1168: pqp_pty_shd.g_old_rec.pty_information16;
1164: pqp_pty_shd.g_old_rec.pty_information15;
1165: End If;
1166: If (p_rec.pty_information16 = hr_api.g_varchar2) then
1167: p_rec.pty_information16 :=
1168: pqp_pty_shd.g_old_rec.pty_information16;
1169: End If;
1170: If (p_rec.pty_information17 = hr_api.g_varchar2) then
1171: p_rec.pty_information17 :=
1172: pqp_pty_shd.g_old_rec.pty_information17;
1168: pqp_pty_shd.g_old_rec.pty_information16;
1169: End If;
1170: If (p_rec.pty_information17 = hr_api.g_varchar2) then
1171: p_rec.pty_information17 :=
1172: pqp_pty_shd.g_old_rec.pty_information17;
1173: End If;
1174: If (p_rec.pty_information18 = hr_api.g_varchar2) then
1175: p_rec.pty_information18 :=
1176: pqp_pty_shd.g_old_rec.pty_information18;
1172: pqp_pty_shd.g_old_rec.pty_information17;
1173: End If;
1174: If (p_rec.pty_information18 = hr_api.g_varchar2) then
1175: p_rec.pty_information18 :=
1176: pqp_pty_shd.g_old_rec.pty_information18;
1177: End If;
1178: If (p_rec.pty_information19 = hr_api.g_varchar2) then
1179: p_rec.pty_information19 :=
1180: pqp_pty_shd.g_old_rec.pty_information19;
1176: pqp_pty_shd.g_old_rec.pty_information18;
1177: End If;
1178: If (p_rec.pty_information19 = hr_api.g_varchar2) then
1179: p_rec.pty_information19 :=
1180: pqp_pty_shd.g_old_rec.pty_information19;
1181: End If;
1182: If (p_rec.pty_information20 = hr_api.g_varchar2) then
1183: p_rec.pty_information20 :=
1184: pqp_pty_shd.g_old_rec.pty_information20;
1180: pqp_pty_shd.g_old_rec.pty_information19;
1181: End If;
1182: If (p_rec.pty_information20 = hr_api.g_varchar2) then
1183: p_rec.pty_information20 :=
1184: pqp_pty_shd.g_old_rec.pty_information20;
1185: End If;
1186: If (p_rec.special_pension_type_code = hr_api.g_varchar2) then
1187: p_rec.special_pension_type_code :=
1188: pqp_pty_shd.g_old_rec.special_pension_type_code;
1184: pqp_pty_shd.g_old_rec.pty_information20;
1185: End If;
1186: If (p_rec.special_pension_type_code = hr_api.g_varchar2) then
1187: p_rec.special_pension_type_code :=
1188: pqp_pty_shd.g_old_rec.special_pension_type_code;
1189: End If;
1190: If (p_rec.pension_sub_category = hr_api.g_varchar2) then
1191: p_rec.pension_sub_category :=
1192: pqp_pty_shd.g_old_rec.pension_sub_category;
1188: pqp_pty_shd.g_old_rec.special_pension_type_code;
1189: End If;
1190: If (p_rec.pension_sub_category = hr_api.g_varchar2) then
1191: p_rec.pension_sub_category :=
1192: pqp_pty_shd.g_old_rec.pension_sub_category;
1193: End If;
1194: If (p_rec.pension_basis_calc_method = hr_api.g_varchar2) then
1195: p_rec.pension_basis_calc_method :=
1196: pqp_pty_shd.g_old_rec.pension_basis_calc_method;
1192: pqp_pty_shd.g_old_rec.pension_sub_category;
1193: End If;
1194: If (p_rec.pension_basis_calc_method = hr_api.g_varchar2) then
1195: p_rec.pension_basis_calc_method :=
1196: pqp_pty_shd.g_old_rec.pension_basis_calc_method;
1197: End If;
1198: If (p_rec.pension_salary_balance = hr_api.g_number) then
1199: p_rec.pension_salary_balance :=
1200: pqp_pty_shd.g_old_rec.pension_salary_balance;
1196: pqp_pty_shd.g_old_rec.pension_basis_calc_method;
1197: End If;
1198: If (p_rec.pension_salary_balance = hr_api.g_number) then
1199: p_rec.pension_salary_balance :=
1200: pqp_pty_shd.g_old_rec.pension_salary_balance;
1201: End If;
1202: If (p_rec.recurring_bonus_percent = hr_api.g_number) then
1203: p_rec.recurring_bonus_percent :=
1204: pqp_pty_shd.g_old_rec.recurring_bonus_percent;
1200: pqp_pty_shd.g_old_rec.pension_salary_balance;
1201: End If;
1202: If (p_rec.recurring_bonus_percent = hr_api.g_number) then
1203: p_rec.recurring_bonus_percent :=
1204: pqp_pty_shd.g_old_rec.recurring_bonus_percent;
1205: End If;
1206: If (p_rec.non_recurring_bonus_percent = hr_api.g_number) then
1207: p_rec.non_recurring_bonus_percent :=
1208: pqp_pty_shd.g_old_rec.non_recurring_bonus_percent;
1204: pqp_pty_shd.g_old_rec.recurring_bonus_percent;
1205: End If;
1206: If (p_rec.non_recurring_bonus_percent = hr_api.g_number) then
1207: p_rec.non_recurring_bonus_percent :=
1208: pqp_pty_shd.g_old_rec.non_recurring_bonus_percent;
1209: End If;
1210: If (p_rec.recurring_bonus_balance = hr_api.g_number) then
1211: p_rec.recurring_bonus_balance :=
1212: pqp_pty_shd.g_old_rec.recurring_bonus_balance;
1208: pqp_pty_shd.g_old_rec.non_recurring_bonus_percent;
1209: End If;
1210: If (p_rec.recurring_bonus_balance = hr_api.g_number) then
1211: p_rec.recurring_bonus_balance :=
1212: pqp_pty_shd.g_old_rec.recurring_bonus_balance;
1213: End If;
1214: If (p_rec.non_recurring_bonus_balance = hr_api.g_number) then
1215: p_rec.non_recurring_bonus_balance :=
1216: pqp_pty_shd.g_old_rec.non_recurring_bonus_balance;
1212: pqp_pty_shd.g_old_rec.recurring_bonus_balance;
1213: End If;
1214: If (p_rec.non_recurring_bonus_balance = hr_api.g_number) then
1215: p_rec.non_recurring_bonus_balance :=
1216: pqp_pty_shd.g_old_rec.non_recurring_bonus_balance;
1217: End If;
1218: If (p_rec.std_tax_reduction = hr_api.g_varchar2) then
1219: p_rec.std_tax_reduction :=
1220: pqp_pty_shd.g_old_rec.std_tax_reduction;
1216: pqp_pty_shd.g_old_rec.non_recurring_bonus_balance;
1217: End If;
1218: If (p_rec.std_tax_reduction = hr_api.g_varchar2) then
1219: p_rec.std_tax_reduction :=
1220: pqp_pty_shd.g_old_rec.std_tax_reduction;
1221: End If;
1222: If (p_rec.spl_tax_reduction = hr_api.g_varchar2) then
1223: p_rec.spl_tax_reduction :=
1224: pqp_pty_shd.g_old_rec.spl_tax_reduction;
1220: pqp_pty_shd.g_old_rec.std_tax_reduction;
1221: End If;
1222: If (p_rec.spl_tax_reduction = hr_api.g_varchar2) then
1223: p_rec.spl_tax_reduction :=
1224: pqp_pty_shd.g_old_rec.spl_tax_reduction;
1225: End If;
1226: If (p_rec.sig_sal_spl_tax_reduction = hr_api.g_varchar2) then
1227: p_rec.sig_sal_spl_tax_reduction :=
1228: pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction;
1224: pqp_pty_shd.g_old_rec.spl_tax_reduction;
1225: End If;
1226: If (p_rec.sig_sal_spl_tax_reduction = hr_api.g_varchar2) then
1227: p_rec.sig_sal_spl_tax_reduction :=
1228: pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction;
1229: End If;
1230: If (p_rec.sig_sal_non_tax_reduction = hr_api.g_varchar2) then
1231: p_rec.sig_sal_non_tax_reduction :=
1232: pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction;
1228: pqp_pty_shd.g_old_rec.sig_sal_spl_tax_reduction;
1229: End If;
1230: If (p_rec.sig_sal_non_tax_reduction = hr_api.g_varchar2) then
1231: p_rec.sig_sal_non_tax_reduction :=
1232: pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction;
1233: End If;
1234: If (p_rec.sig_sal_std_tax_reduction = hr_api.g_varchar2) then
1235: p_rec.sig_sal_std_tax_reduction :=
1236: pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction;
1232: pqp_pty_shd.g_old_rec.sig_sal_non_tax_reduction;
1233: End If;
1234: If (p_rec.sig_sal_std_tax_reduction = hr_api.g_varchar2) then
1235: p_rec.sig_sal_std_tax_reduction :=
1236: pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction;
1237: End If;
1238: If (p_rec.sii_std_tax_reduction = hr_api.g_varchar2) then
1239: p_rec.sii_std_tax_reduction :=
1240: pqp_pty_shd.g_old_rec.sii_std_tax_reduction;
1236: pqp_pty_shd.g_old_rec.sig_sal_std_tax_reduction;
1237: End If;
1238: If (p_rec.sii_std_tax_reduction = hr_api.g_varchar2) then
1239: p_rec.sii_std_tax_reduction :=
1240: pqp_pty_shd.g_old_rec.sii_std_tax_reduction;
1241: End If;
1242: If (p_rec.sii_spl_tax_reduction = hr_api.g_varchar2) then
1243: p_rec.sii_spl_tax_reduction :=
1244: pqp_pty_shd.g_old_rec.sii_spl_tax_reduction;
1240: pqp_pty_shd.g_old_rec.sii_std_tax_reduction;
1241: End If;
1242: If (p_rec.sii_spl_tax_reduction = hr_api.g_varchar2) then
1243: p_rec.sii_spl_tax_reduction :=
1244: pqp_pty_shd.g_old_rec.sii_spl_tax_reduction;
1245: End If;
1246: If (p_rec.sii_non_tax_reduction = hr_api.g_varchar2) then
1247: p_rec.sii_non_tax_reduction :=
1248: pqp_pty_shd.g_old_rec.sii_non_tax_reduction;
1244: pqp_pty_shd.g_old_rec.sii_spl_tax_reduction;
1245: End If;
1246: If (p_rec.sii_non_tax_reduction = hr_api.g_varchar2) then
1247: p_rec.sii_non_tax_reduction :=
1248: pqp_pty_shd.g_old_rec.sii_non_tax_reduction;
1249: End If;
1250: If (p_rec.previous_year_bonus_included = hr_api.g_varchar2) then
1251: p_rec.previous_year_bonus_included :=
1252: pqp_pty_shd.g_old_rec.previous_year_bonus_included;
1248: pqp_pty_shd.g_old_rec.sii_non_tax_reduction;
1249: End If;
1250: If (p_rec.previous_year_bonus_included = hr_api.g_varchar2) then
1251: p_rec.previous_year_bonus_included :=
1252: pqp_pty_shd.g_old_rec.previous_year_bonus_included;
1253: End If;
1254: If (p_rec.recurring_bonus_period = hr_api.g_varchar2) then
1255: p_rec.recurring_bonus_period :=
1256: pqp_pty_shd.g_old_rec.recurring_bonus_period;
1252: pqp_pty_shd.g_old_rec.previous_year_bonus_included;
1253: End If;
1254: If (p_rec.recurring_bonus_period = hr_api.g_varchar2) then
1255: p_rec.recurring_bonus_period :=
1256: pqp_pty_shd.g_old_rec.recurring_bonus_period;
1257: End If;
1258: If (p_rec.non_recurring_bonus_period = hr_api.g_varchar2) then
1259: p_rec.non_recurring_bonus_period :=
1260: pqp_pty_shd.g_old_rec.non_recurring_bonus_period;
1256: pqp_pty_shd.g_old_rec.recurring_bonus_period;
1257: End If;
1258: If (p_rec.non_recurring_bonus_period = hr_api.g_varchar2) then
1259: p_rec.non_recurring_bonus_period :=
1260: pqp_pty_shd.g_old_rec.non_recurring_bonus_period;
1261: End If;
1262: If (p_rec.ee_age_threshold = hr_api.g_varchar2) then
1263: p_rec.ee_age_threshold :=
1264: pqp_pty_shd.g_old_rec.ee_age_threshold;
1260: pqp_pty_shd.g_old_rec.non_recurring_bonus_period;
1261: End If;
1262: If (p_rec.ee_age_threshold = hr_api.g_varchar2) then
1263: p_rec.ee_age_threshold :=
1264: pqp_pty_shd.g_old_rec.ee_age_threshold;
1265: End If;
1266: If (p_rec.er_age_threshold = hr_api.g_varchar2) then
1267: p_rec.er_age_threshold :=
1268: pqp_pty_shd.g_old_rec.er_age_threshold;
1264: pqp_pty_shd.g_old_rec.ee_age_threshold;
1265: End If;
1266: If (p_rec.er_age_threshold = hr_api.g_varchar2) then
1267: p_rec.er_age_threshold :=
1268: pqp_pty_shd.g_old_rec.er_age_threshold;
1269: End If;
1270: If (p_rec.ee_age_contribution = hr_api.g_varchar2) then
1271: p_rec.ee_age_contribution :=
1272: pqp_pty_shd.g_old_rec.ee_age_contribution;
1268: pqp_pty_shd.g_old_rec.er_age_threshold;
1269: End If;
1270: If (p_rec.ee_age_contribution = hr_api.g_varchar2) then
1271: p_rec.ee_age_contribution :=
1272: pqp_pty_shd.g_old_rec.ee_age_contribution;
1273: End If;
1274: If (p_rec.er_age_contribution = hr_api.g_varchar2) then
1275: p_rec.er_age_contribution :=
1276: pqp_pty_shd.g_old_rec.er_age_contribution;
1272: pqp_pty_shd.g_old_rec.ee_age_contribution;
1273: End If;
1274: If (p_rec.er_age_contribution = hr_api.g_varchar2) then
1275: p_rec.er_age_contribution :=
1276: pqp_pty_shd.g_old_rec.er_age_contribution;
1277: End If;
1278: --
1279: End convert_defs;
1280: --
1283: -- ----------------------------------------------------------------------------
1284: Procedure upd
1285: (p_effective_date in date
1286: ,p_datetrack_mode in varchar2
1287: ,p_rec in out nocopy pqp_pty_shd.g_rec_type
1288: ) is
1289: --
1290: l_proc varchar2(72) := g_package||'upd';
1291: l_validation_start_date date;
1299: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1300: --
1301: -- We must lock the row which we need to update.
1302: --
1303: pqp_pty_shd.lck
1304: (p_effective_date => p_effective_date
1305: ,p_datetrack_mode => p_datetrack_mode
1306: ,p_pension_type_id => p_rec.pension_type_id
1307: ,p_object_version_number => p_rec.object_version_number
1463: ,p_effective_start_date out nocopy date
1464: ,p_effective_end_date out nocopy date
1465: ) is
1466: --
1467: l_rec pqp_pty_shd.g_rec_type;
1468: l_proc varchar2(72) := g_package||'upd';
1469: --
1470: Begin
1471: hr_utility.set_location('Entering:'||l_proc, 5);
1473: -- Call conversion function to turn arguments into the
1474: -- l_rec structure.
1475: --
1476: l_rec :=
1477: pqp_pty_shd.convert_args
1478: (p_pension_type_id
1479: ,null
1480: ,null
1481: ,p_pension_type_name