54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_cft_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) is
77: (p_base_table_name => 'pay_ca_emp_fed_tax_info_f',
78: p_base_key_column => 'emp_fed_tax_inf_id',
79: p_base_key_value => p_rec.emp_fed_tax_inf_id);
80: --
81: pay_cft_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the pay_ca_emp_fed_tax_info_f Row
84: --
85: update pay_ca_emp_fed_tax_info_f
140: where emp_fed_tax_inf_id = p_rec.emp_fed_tax_inf_id
141: and effective_start_date = p_validation_start_date
142: and effective_end_date = p_validation_end_date;
143: --
144: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
145: --
146: -- Set the effective start and end dates
147: --
148: p_rec.effective_start_date := p_validation_start_date;
152: hr_utility.set_location(' Leaving:'||l_proc, 15);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
157: pay_cft_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
157: pay_cft_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
157: pay_cft_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
162: pay_cft_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.unique_integrity_violated Then
160: -- Unique integrity has been violated
161: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
162: pay_cft_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
161: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
162: pay_cft_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When Others Then
165: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
166: Raise;
167: End dt_update_dml;
168: --
169: -- ----------------------------------------------------------------------------
197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure update_dml
201: (p_rec in out nocopy pay_cft_shd.g_rec_type,
202: p_effective_date in date,
203: p_datetrack_mode in varchar2,
204: p_validation_start_date in date,
205: p_validation_end_date in date) is
261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure dt_pre_update
265: (p_rec in out nocopy pay_cft_shd.g_rec_type,
266: p_effective_date in date,
267: p_datetrack_mode in varchar2,
268: p_validation_start_date in date,
269: p_validation_end_date in date) is
277: hr_utility.set_location(l_proc, 10);
278: --
279: -- Update the current effective end date
280: --
281: pay_cft_shd.upd_effective_end_date
282: (p_effective_date => p_effective_date,
283: p_base_key_value => p_rec.emp_fed_tax_inf_id,
284: p_new_effective_end_date => (p_validation_start_date - 1),
285: p_validation_start_date => p_validation_start_date,
346: --
347: -- {End Of Comments}
348: -- ----------------------------------------------------------------------------
349: Procedure pre_update
350: (p_rec in out nocopy pay_cft_shd.g_rec_type,
351: p_effective_date in date,
352: p_datetrack_mode in varchar2,
353: p_validation_start_date in date,
354: p_validation_end_date in date) is
402: --
403: -- {End Of Comments}
404: -- ----------------------------------------------------------------------------
405: Procedure post_update
406: (p_rec in pay_cft_shd.g_rec_type,
407: p_effective_date in date,
408: p_datetrack_mode in varchar2,
409: p_validation_start_date in date,
410: p_validation_end_date in date) is
480: ,p_effective_date =>p_effective_date
481: ,p_datetrack_mode =>p_datetrack_mode
482: ,p_validation_start_date =>p_validation_start_date
483: ,p_validation_end_date =>p_validation_end_date
484: ,p_effective_start_date_o =>pay_cft_shd.g_old_rec.effective_start_date
485: ,p_effective_end_date_o =>pay_cft_shd.g_old_rec.effective_end_date
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
481: ,p_datetrack_mode =>p_datetrack_mode
482: ,p_validation_start_date =>p_validation_start_date
483: ,p_validation_end_date =>p_validation_end_date
484: ,p_effective_start_date_o =>pay_cft_shd.g_old_rec.effective_start_date
485: ,p_effective_end_date_o =>pay_cft_shd.g_old_rec.effective_end_date
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
482: ,p_validation_start_date =>p_validation_start_date
483: ,p_validation_end_date =>p_validation_end_date
484: ,p_effective_start_date_o =>pay_cft_shd.g_old_rec.effective_start_date
485: ,p_effective_end_date_o =>pay_cft_shd.g_old_rec.effective_end_date
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
483: ,p_validation_end_date =>p_validation_end_date
484: ,p_effective_start_date_o =>pay_cft_shd.g_old_rec.effective_start_date
485: ,p_effective_end_date_o =>pay_cft_shd.g_old_rec.effective_end_date
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
484: ,p_effective_start_date_o =>pay_cft_shd.g_old_rec.effective_start_date
485: ,p_effective_end_date_o =>pay_cft_shd.g_old_rec.effective_end_date
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
485: ,p_effective_end_date_o =>pay_cft_shd.g_old_rec.effective_end_date
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
486: ,p_legislation_code_o =>pay_cft_shd.g_old_rec.legislation_code
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
487: ,p_assignment_id_o =>pay_cft_shd.g_old_rec.assignment_id
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
488: ,p_business_group_id_o =>pay_cft_shd.g_old_rec.business_group_id
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
489: ,p_employment_province_o =>pay_cft_shd.g_old_rec.employment_province
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
490: ,p_tax_credit_amount_o =>pay_cft_shd.g_old_rec.tax_credit_amount
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
491: ,p_claim_code_o =>pay_cft_shd.g_old_rec.claim_code
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
492: ,p_basic_exemption_flag_o =>pay_cft_shd.g_old_rec.basic_exemption_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
493: ,p_additional_tax_o =>pay_cft_shd.g_old_rec.additional_tax
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
494: ,p_annual_dedn_o =>pay_cft_shd.g_old_rec.annual_dedn
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
495: ,p_total_expense_by_commissio_o =>pay_cft_shd.g_old_rec.total_expense_by_commission
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
496: ,p_total_remnrtn_by_commissio_o =>pay_cft_shd.g_old_rec.total_remnrtn_by_commission
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
497: ,p_prescribed_zone_dedn_amt_o =>pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
498: ,p_other_fedtax_credits_o =>pay_cft_shd.g_old_rec.other_fedtax_credits
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
499: ,p_cpp_qpp_exempt_flag_o =>pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
500: ,p_fed_exempt_flag_o =>pay_cft_shd.g_old_rec.fed_exempt_flag
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
501: ,p_ei_exempt_flag_o =>pay_cft_shd.g_old_rec.ei_exempt_flag
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
502: ,p_tax_calc_method_o =>pay_cft_shd.g_old_rec.tax_calc_method
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
503: ,p_fed_override_amount_o =>pay_cft_shd.g_old_rec.fed_override_amount
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
504: ,p_fed_override_rate_o =>pay_cft_shd.g_old_rec.fed_override_rate
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
505: ,p_ca_tax_information_categor_o =>pay_cft_shd.g_old_rec.ca_tax_information_category
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
506: ,p_ca_tax_information1_o =>pay_cft_shd.g_old_rec.ca_tax_information1
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
507: ,p_ca_tax_information2_o =>pay_cft_shd.g_old_rec.ca_tax_information2
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
508: ,p_ca_tax_information3_o =>pay_cft_shd.g_old_rec.ca_tax_information3
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
509: ,p_ca_tax_information4_o =>pay_cft_shd.g_old_rec.ca_tax_information4
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
510: ,p_ca_tax_information5_o =>pay_cft_shd.g_old_rec.ca_tax_information5
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
511: ,p_ca_tax_information6_o =>pay_cft_shd.g_old_rec.ca_tax_information6
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
512: ,p_ca_tax_information7_o =>pay_cft_shd.g_old_rec.ca_tax_information7
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
513: ,p_ca_tax_information8_o =>pay_cft_shd.g_old_rec.ca_tax_information8
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
514: ,p_ca_tax_information9_o =>pay_cft_shd.g_old_rec.ca_tax_information9
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
515: ,p_ca_tax_information10_o =>pay_cft_shd.g_old_rec.ca_tax_information10
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
516: ,p_ca_tax_information11_o =>pay_cft_shd.g_old_rec.ca_tax_information11
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
517: ,p_ca_tax_information12_o =>pay_cft_shd.g_old_rec.ca_tax_information12
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
518: ,p_ca_tax_information13_o =>pay_cft_shd.g_old_rec.ca_tax_information13
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
519: ,p_ca_tax_information14_o =>pay_cft_shd.g_old_rec.ca_tax_information14
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
520: ,p_ca_tax_information15_o =>pay_cft_shd.g_old_rec.ca_tax_information15
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
521: ,p_ca_tax_information16_o =>pay_cft_shd.g_old_rec.ca_tax_information16
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
522: ,p_ca_tax_information17_o =>pay_cft_shd.g_old_rec.ca_tax_information17
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
523: ,p_ca_tax_information18_o =>pay_cft_shd.g_old_rec.ca_tax_information18
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
524: ,p_ca_tax_information19_o =>pay_cft_shd.g_old_rec.ca_tax_information19
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
525: ,p_ca_tax_information20_o =>pay_cft_shd.g_old_rec.ca_tax_information20
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
526: ,p_ca_tax_information21_o =>pay_cft_shd.g_old_rec.ca_tax_information21
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
527: ,p_ca_tax_information22_o =>pay_cft_shd.g_old_rec.ca_tax_information22
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
528: ,p_ca_tax_information23_o =>pay_cft_shd.g_old_rec.ca_tax_information23
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
536: ,p_object_version_number_o =>pay_cft_shd.g_old_rec.object_version_number
529: ,p_ca_tax_information24_o =>pay_cft_shd.g_old_rec.ca_tax_information24
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
536: ,p_object_version_number_o =>pay_cft_shd.g_old_rec.object_version_number
537: ,p_fed_lsf_amount_o =>pay_cft_shd.g_old_rec.fed_lsf_amount
530: ,p_ca_tax_information25_o =>pay_cft_shd.g_old_rec.ca_tax_information25
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
536: ,p_object_version_number_o =>pay_cft_shd.g_old_rec.object_version_number
537: ,p_fed_lsf_amount_o =>pay_cft_shd.g_old_rec.fed_lsf_amount
538: );
531: ,p_ca_tax_information26_o =>pay_cft_shd.g_old_rec.ca_tax_information26
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
536: ,p_object_version_number_o =>pay_cft_shd.g_old_rec.object_version_number
537: ,p_fed_lsf_amount_o =>pay_cft_shd.g_old_rec.fed_lsf_amount
538: );
539: --
532: ,p_ca_tax_information27_o =>pay_cft_shd.g_old_rec.ca_tax_information27
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
536: ,p_object_version_number_o =>pay_cft_shd.g_old_rec.object_version_number
537: ,p_fed_lsf_amount_o =>pay_cft_shd.g_old_rec.fed_lsf_amount
538: );
539: --
540: exception
533: ,p_ca_tax_information28_o =>pay_cft_shd.g_old_rec.ca_tax_information28
534: ,p_ca_tax_information29_o =>pay_cft_shd.g_old_rec.ca_tax_information29
535: ,p_ca_tax_information30_o =>pay_cft_shd.g_old_rec.ca_tax_information30
536: ,p_object_version_number_o =>pay_cft_shd.g_old_rec.object_version_number
537: ,p_fed_lsf_amount_o =>pay_cft_shd.g_old_rec.fed_lsf_amount
538: );
539: --
540: exception
541: --
596: -- Internal Row Handler Use Only.
597: --
598: -- {End Of Comments}
599: -- ----------------------------------------------------------------------------
600: Procedure convert_defs(p_rec in out nocopy pay_cft_shd.g_rec_type) is
601: --
602: l_proc varchar2(72) := g_package||'convert_defs';
603: --
604: Begin
611: -- is being used then we must set to the 'current' argument value.
612: --
613: If (p_rec.legislation_code = hr_api.g_varchar2) then
614: p_rec.legislation_code :=
615: pay_cft_shd.g_old_rec.legislation_code;
616: End If;
617: If (p_rec.assignment_id = hr_api.g_number) then
618: p_rec.assignment_id :=
619: pay_cft_shd.g_old_rec.assignment_id;
615: pay_cft_shd.g_old_rec.legislation_code;
616: End If;
617: If (p_rec.assignment_id = hr_api.g_number) then
618: p_rec.assignment_id :=
619: pay_cft_shd.g_old_rec.assignment_id;
620: End If;
621: If (p_rec.business_group_id = hr_api.g_number) then
622: p_rec.business_group_id :=
623: pay_cft_shd.g_old_rec.business_group_id;
619: pay_cft_shd.g_old_rec.assignment_id;
620: End If;
621: If (p_rec.business_group_id = hr_api.g_number) then
622: p_rec.business_group_id :=
623: pay_cft_shd.g_old_rec.business_group_id;
624: End If;
625: If (p_rec.employment_province = hr_api.g_varchar2) then
626: p_rec.employment_province :=
627: pay_cft_shd.g_old_rec.employment_province;
623: pay_cft_shd.g_old_rec.business_group_id;
624: End If;
625: If (p_rec.employment_province = hr_api.g_varchar2) then
626: p_rec.employment_province :=
627: pay_cft_shd.g_old_rec.employment_province;
628: End If;
629: If (p_rec.tax_credit_amount = hr_api.g_number) then
630: p_rec.tax_credit_amount :=
631: pay_cft_shd.g_old_rec.tax_credit_amount;
627: pay_cft_shd.g_old_rec.employment_province;
628: End If;
629: If (p_rec.tax_credit_amount = hr_api.g_number) then
630: p_rec.tax_credit_amount :=
631: pay_cft_shd.g_old_rec.tax_credit_amount;
632: End If;
633: If (p_rec.claim_code = hr_api.g_varchar2) then
634: p_rec.claim_code :=
635: pay_cft_shd.g_old_rec.claim_code;
631: pay_cft_shd.g_old_rec.tax_credit_amount;
632: End If;
633: If (p_rec.claim_code = hr_api.g_varchar2) then
634: p_rec.claim_code :=
635: pay_cft_shd.g_old_rec.claim_code;
636: End If;
637: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
638: p_rec.basic_exemption_flag :=
639: pay_cft_shd.g_old_rec.basic_exemption_flag;
635: pay_cft_shd.g_old_rec.claim_code;
636: End If;
637: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
638: p_rec.basic_exemption_flag :=
639: pay_cft_shd.g_old_rec.basic_exemption_flag;
640: End If;
641: If (p_rec.additional_tax = hr_api.g_number) then
642: p_rec.additional_tax :=
643: pay_cft_shd.g_old_rec.additional_tax;
639: pay_cft_shd.g_old_rec.basic_exemption_flag;
640: End If;
641: If (p_rec.additional_tax = hr_api.g_number) then
642: p_rec.additional_tax :=
643: pay_cft_shd.g_old_rec.additional_tax;
644: End If;
645: If (p_rec.annual_dedn = hr_api.g_number) then
646: p_rec.annual_dedn :=
647: pay_cft_shd.g_old_rec.annual_dedn;
643: pay_cft_shd.g_old_rec.additional_tax;
644: End If;
645: If (p_rec.annual_dedn = hr_api.g_number) then
646: p_rec.annual_dedn :=
647: pay_cft_shd.g_old_rec.annual_dedn;
648: End If;
649: If (p_rec.total_expense_by_commission = hr_api.g_number) then
650: p_rec.total_expense_by_commission :=
651: pay_cft_shd.g_old_rec.total_expense_by_commission;
647: pay_cft_shd.g_old_rec.annual_dedn;
648: End If;
649: If (p_rec.total_expense_by_commission = hr_api.g_number) then
650: p_rec.total_expense_by_commission :=
651: pay_cft_shd.g_old_rec.total_expense_by_commission;
652: End If;
653: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
654: p_rec.total_remnrtn_by_commission :=
655: pay_cft_shd.g_old_rec.total_remnrtn_by_commission;
651: pay_cft_shd.g_old_rec.total_expense_by_commission;
652: End If;
653: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
654: p_rec.total_remnrtn_by_commission :=
655: pay_cft_shd.g_old_rec.total_remnrtn_by_commission;
656: End If;
657: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
658: p_rec.prescribed_zone_dedn_amt :=
659: pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt;
655: pay_cft_shd.g_old_rec.total_remnrtn_by_commission;
656: End If;
657: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
658: p_rec.prescribed_zone_dedn_amt :=
659: pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt;
660: End If;
661: If (p_rec.other_fedtax_credits = hr_api.g_varchar2) then
662: p_rec.other_fedtax_credits :=
663: pay_cft_shd.g_old_rec.other_fedtax_credits;
659: pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt;
660: End If;
661: If (p_rec.other_fedtax_credits = hr_api.g_varchar2) then
662: p_rec.other_fedtax_credits :=
663: pay_cft_shd.g_old_rec.other_fedtax_credits;
664: End If;
665: If (p_rec.cpp_qpp_exempt_flag = hr_api.g_varchar2) then
666: p_rec.cpp_qpp_exempt_flag :=
667: pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag;
663: pay_cft_shd.g_old_rec.other_fedtax_credits;
664: End If;
665: If (p_rec.cpp_qpp_exempt_flag = hr_api.g_varchar2) then
666: p_rec.cpp_qpp_exempt_flag :=
667: pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag;
668: End If;
669: If (p_rec.fed_exempt_flag = hr_api.g_varchar2) then
670: p_rec.fed_exempt_flag :=
671: pay_cft_shd.g_old_rec.fed_exempt_flag;
667: pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag;
668: End If;
669: If (p_rec.fed_exempt_flag = hr_api.g_varchar2) then
670: p_rec.fed_exempt_flag :=
671: pay_cft_shd.g_old_rec.fed_exempt_flag;
672: End If;
673: If (p_rec.ei_exempt_flag = hr_api.g_varchar2) then
674: p_rec.ei_exempt_flag :=
675: pay_cft_shd.g_old_rec.ei_exempt_flag;
671: pay_cft_shd.g_old_rec.fed_exempt_flag;
672: End If;
673: If (p_rec.ei_exempt_flag = hr_api.g_varchar2) then
674: p_rec.ei_exempt_flag :=
675: pay_cft_shd.g_old_rec.ei_exempt_flag;
676: End If;
677: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
678: p_rec.tax_calc_method :=
679: pay_cft_shd.g_old_rec.tax_calc_method;
675: pay_cft_shd.g_old_rec.ei_exempt_flag;
676: End If;
677: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
678: p_rec.tax_calc_method :=
679: pay_cft_shd.g_old_rec.tax_calc_method;
680: End If;
681: If (p_rec.fed_override_amount = hr_api.g_number) then
682: p_rec.fed_override_amount :=
683: pay_cft_shd.g_old_rec.fed_override_amount;
679: pay_cft_shd.g_old_rec.tax_calc_method;
680: End If;
681: If (p_rec.fed_override_amount = hr_api.g_number) then
682: p_rec.fed_override_amount :=
683: pay_cft_shd.g_old_rec.fed_override_amount;
684: End If;
685: If (p_rec.fed_override_rate = hr_api.g_number) then
686: p_rec.fed_override_rate :=
687: pay_cft_shd.g_old_rec.fed_override_rate;
683: pay_cft_shd.g_old_rec.fed_override_amount;
684: End If;
685: If (p_rec.fed_override_rate = hr_api.g_number) then
686: p_rec.fed_override_rate :=
687: pay_cft_shd.g_old_rec.fed_override_rate;
688: End If;
689: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
690: p_rec.ca_tax_information_category :=
691: pay_cft_shd.g_old_rec.ca_tax_information_category;
687: pay_cft_shd.g_old_rec.fed_override_rate;
688: End If;
689: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
690: p_rec.ca_tax_information_category :=
691: pay_cft_shd.g_old_rec.ca_tax_information_category;
692: End If;
693: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
694: p_rec.ca_tax_information1 :=
695: pay_cft_shd.g_old_rec.ca_tax_information1;
691: pay_cft_shd.g_old_rec.ca_tax_information_category;
692: End If;
693: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
694: p_rec.ca_tax_information1 :=
695: pay_cft_shd.g_old_rec.ca_tax_information1;
696: End If;
697: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
698: p_rec.ca_tax_information2 :=
699: pay_cft_shd.g_old_rec.ca_tax_information2;
695: pay_cft_shd.g_old_rec.ca_tax_information1;
696: End If;
697: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
698: p_rec.ca_tax_information2 :=
699: pay_cft_shd.g_old_rec.ca_tax_information2;
700: End If;
701: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
702: p_rec.ca_tax_information3 :=
703: pay_cft_shd.g_old_rec.ca_tax_information3;
699: pay_cft_shd.g_old_rec.ca_tax_information2;
700: End If;
701: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
702: p_rec.ca_tax_information3 :=
703: pay_cft_shd.g_old_rec.ca_tax_information3;
704: End If;
705: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
706: p_rec.ca_tax_information4 :=
707: pay_cft_shd.g_old_rec.ca_tax_information4;
703: pay_cft_shd.g_old_rec.ca_tax_information3;
704: End If;
705: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
706: p_rec.ca_tax_information4 :=
707: pay_cft_shd.g_old_rec.ca_tax_information4;
708: End If;
709: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
710: p_rec.ca_tax_information5 :=
711: pay_cft_shd.g_old_rec.ca_tax_information5;
707: pay_cft_shd.g_old_rec.ca_tax_information4;
708: End If;
709: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
710: p_rec.ca_tax_information5 :=
711: pay_cft_shd.g_old_rec.ca_tax_information5;
712: End If;
713: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
714: p_rec.ca_tax_information6 :=
715: pay_cft_shd.g_old_rec.ca_tax_information6;
711: pay_cft_shd.g_old_rec.ca_tax_information5;
712: End If;
713: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
714: p_rec.ca_tax_information6 :=
715: pay_cft_shd.g_old_rec.ca_tax_information6;
716: End If;
717: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
718: p_rec.ca_tax_information7 :=
719: pay_cft_shd.g_old_rec.ca_tax_information7;
715: pay_cft_shd.g_old_rec.ca_tax_information6;
716: End If;
717: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
718: p_rec.ca_tax_information7 :=
719: pay_cft_shd.g_old_rec.ca_tax_information7;
720: End If;
721: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
722: p_rec.ca_tax_information8 :=
723: pay_cft_shd.g_old_rec.ca_tax_information8;
719: pay_cft_shd.g_old_rec.ca_tax_information7;
720: End If;
721: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
722: p_rec.ca_tax_information8 :=
723: pay_cft_shd.g_old_rec.ca_tax_information8;
724: End If;
725: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
726: p_rec.ca_tax_information9 :=
727: pay_cft_shd.g_old_rec.ca_tax_information9;
723: pay_cft_shd.g_old_rec.ca_tax_information8;
724: End If;
725: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
726: p_rec.ca_tax_information9 :=
727: pay_cft_shd.g_old_rec.ca_tax_information9;
728: End If;
729: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
730: p_rec.ca_tax_information10 :=
731: pay_cft_shd.g_old_rec.ca_tax_information10;
727: pay_cft_shd.g_old_rec.ca_tax_information9;
728: End If;
729: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
730: p_rec.ca_tax_information10 :=
731: pay_cft_shd.g_old_rec.ca_tax_information10;
732: End If;
733: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
734: p_rec.ca_tax_information11 :=
735: pay_cft_shd.g_old_rec.ca_tax_information11;
731: pay_cft_shd.g_old_rec.ca_tax_information10;
732: End If;
733: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
734: p_rec.ca_tax_information11 :=
735: pay_cft_shd.g_old_rec.ca_tax_information11;
736: End If;
737: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
738: p_rec.ca_tax_information12 :=
739: pay_cft_shd.g_old_rec.ca_tax_information12;
735: pay_cft_shd.g_old_rec.ca_tax_information11;
736: End If;
737: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
738: p_rec.ca_tax_information12 :=
739: pay_cft_shd.g_old_rec.ca_tax_information12;
740: End If;
741: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
742: p_rec.ca_tax_information13 :=
743: pay_cft_shd.g_old_rec.ca_tax_information13;
739: pay_cft_shd.g_old_rec.ca_tax_information12;
740: End If;
741: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
742: p_rec.ca_tax_information13 :=
743: pay_cft_shd.g_old_rec.ca_tax_information13;
744: End If;
745: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
746: p_rec.ca_tax_information14 :=
747: pay_cft_shd.g_old_rec.ca_tax_information14;
743: pay_cft_shd.g_old_rec.ca_tax_information13;
744: End If;
745: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
746: p_rec.ca_tax_information14 :=
747: pay_cft_shd.g_old_rec.ca_tax_information14;
748: End If;
749: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
750: p_rec.ca_tax_information15 :=
751: pay_cft_shd.g_old_rec.ca_tax_information15;
747: pay_cft_shd.g_old_rec.ca_tax_information14;
748: End If;
749: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
750: p_rec.ca_tax_information15 :=
751: pay_cft_shd.g_old_rec.ca_tax_information15;
752: End If;
753: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
754: p_rec.ca_tax_information16 :=
755: pay_cft_shd.g_old_rec.ca_tax_information16;
751: pay_cft_shd.g_old_rec.ca_tax_information15;
752: End If;
753: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
754: p_rec.ca_tax_information16 :=
755: pay_cft_shd.g_old_rec.ca_tax_information16;
756: End If;
757: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
758: p_rec.ca_tax_information17 :=
759: pay_cft_shd.g_old_rec.ca_tax_information17;
755: pay_cft_shd.g_old_rec.ca_tax_information16;
756: End If;
757: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
758: p_rec.ca_tax_information17 :=
759: pay_cft_shd.g_old_rec.ca_tax_information17;
760: End If;
761: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
762: p_rec.ca_tax_information18 :=
763: pay_cft_shd.g_old_rec.ca_tax_information18;
759: pay_cft_shd.g_old_rec.ca_tax_information17;
760: End If;
761: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
762: p_rec.ca_tax_information18 :=
763: pay_cft_shd.g_old_rec.ca_tax_information18;
764: End If;
765: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
766: p_rec.ca_tax_information19 :=
767: pay_cft_shd.g_old_rec.ca_tax_information19;
763: pay_cft_shd.g_old_rec.ca_tax_information18;
764: End If;
765: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
766: p_rec.ca_tax_information19 :=
767: pay_cft_shd.g_old_rec.ca_tax_information19;
768: End If;
769: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
770: p_rec.ca_tax_information20 :=
771: pay_cft_shd.g_old_rec.ca_tax_information20;
767: pay_cft_shd.g_old_rec.ca_tax_information19;
768: End If;
769: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
770: p_rec.ca_tax_information20 :=
771: pay_cft_shd.g_old_rec.ca_tax_information20;
772: End If;
773: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
774: p_rec.ca_tax_information21 :=
775: pay_cft_shd.g_old_rec.ca_tax_information21;
771: pay_cft_shd.g_old_rec.ca_tax_information20;
772: End If;
773: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
774: p_rec.ca_tax_information21 :=
775: pay_cft_shd.g_old_rec.ca_tax_information21;
776: End If;
777: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
778: p_rec.ca_tax_information22 :=
779: pay_cft_shd.g_old_rec.ca_tax_information22;
775: pay_cft_shd.g_old_rec.ca_tax_information21;
776: End If;
777: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
778: p_rec.ca_tax_information22 :=
779: pay_cft_shd.g_old_rec.ca_tax_information22;
780: End If;
781: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
782: p_rec.ca_tax_information23 :=
783: pay_cft_shd.g_old_rec.ca_tax_information23;
779: pay_cft_shd.g_old_rec.ca_tax_information22;
780: End If;
781: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
782: p_rec.ca_tax_information23 :=
783: pay_cft_shd.g_old_rec.ca_tax_information23;
784: End If;
785: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
786: p_rec.ca_tax_information24 :=
787: pay_cft_shd.g_old_rec.ca_tax_information24;
783: pay_cft_shd.g_old_rec.ca_tax_information23;
784: End If;
785: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
786: p_rec.ca_tax_information24 :=
787: pay_cft_shd.g_old_rec.ca_tax_information24;
788: End If;
789: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
790: p_rec.ca_tax_information25 :=
791: pay_cft_shd.g_old_rec.ca_tax_information25;
787: pay_cft_shd.g_old_rec.ca_tax_information24;
788: End If;
789: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
790: p_rec.ca_tax_information25 :=
791: pay_cft_shd.g_old_rec.ca_tax_information25;
792: End If;
793: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
794: p_rec.ca_tax_information26 :=
795: pay_cft_shd.g_old_rec.ca_tax_information26;
791: pay_cft_shd.g_old_rec.ca_tax_information25;
792: End If;
793: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
794: p_rec.ca_tax_information26 :=
795: pay_cft_shd.g_old_rec.ca_tax_information26;
796: End If;
797: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
798: p_rec.ca_tax_information27 :=
799: pay_cft_shd.g_old_rec.ca_tax_information27;
795: pay_cft_shd.g_old_rec.ca_tax_information26;
796: End If;
797: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
798: p_rec.ca_tax_information27 :=
799: pay_cft_shd.g_old_rec.ca_tax_information27;
800: End If;
801: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
802: p_rec.ca_tax_information28 :=
803: pay_cft_shd.g_old_rec.ca_tax_information28;
799: pay_cft_shd.g_old_rec.ca_tax_information27;
800: End If;
801: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
802: p_rec.ca_tax_information28 :=
803: pay_cft_shd.g_old_rec.ca_tax_information28;
804: End If;
805: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
806: p_rec.ca_tax_information29 :=
807: pay_cft_shd.g_old_rec.ca_tax_information29;
803: pay_cft_shd.g_old_rec.ca_tax_information28;
804: End If;
805: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
806: p_rec.ca_tax_information29 :=
807: pay_cft_shd.g_old_rec.ca_tax_information29;
808: End If;
809: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
810: p_rec.ca_tax_information30 :=
811: pay_cft_shd.g_old_rec.ca_tax_information30;
807: pay_cft_shd.g_old_rec.ca_tax_information29;
808: End If;
809: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
810: p_rec.ca_tax_information30 :=
811: pay_cft_shd.g_old_rec.ca_tax_information30;
812: End If;
813: If (p_rec.fed_lsf_amount = hr_api.g_number) then
814: p_rec.fed_lsf_amount :=
815: pay_cft_shd.g_old_rec.fed_lsf_amount;
811: pay_cft_shd.g_old_rec.ca_tax_information30;
812: End If;
813: If (p_rec.fed_lsf_amount = hr_api.g_number) then
814: p_rec.fed_lsf_amount :=
815: pay_cft_shd.g_old_rec.fed_lsf_amount;
816: End If;
817:
818: --
819: hr_utility.set_location(' Leaving:'||l_proc, 10);
824: -- |---------------------------------< upd >----------------------------------|
825: -- ----------------------------------------------------------------------------
826: Procedure upd
827: (
828: p_rec in out nocopy pay_cft_shd.g_rec_type,
829: p_effective_date in date,
830: p_datetrack_mode in varchar2
831: ) is
832: --
842: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
843: --
844: -- We must lock the row which we need to update.
845: --
846: pay_cft_shd.lck
847: (
848: p_effective_date => p_effective_date,
849: p_datetrack_mode => p_datetrack_mode,
850: p_emp_fed_tax_inf_id => p_rec.emp_fed_tax_inf_id,
959: p_effective_date in date,
960: p_datetrack_mode in varchar2
961: ) is
962: --
963: l_rec pay_cft_shd.g_rec_type;
964: l_proc varchar2(72) := g_package||'upd';
965: --
966: Begin
967: hr_utility.set_location('Entering:'||l_proc, 5);
969: -- Call conversion function to turn arguments into the
970: -- l_rec structure.
971: --
972: l_rec :=
973: pay_cft_shd.convert_args
974: (
975: p_emp_fed_tax_inf_id,
976: null,
977: null,