[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_cpt_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_prov_tax_info_f',
78: p_base_key_column => 'emp_province_tax_inf_id',
79: p_base_key_value => p_rec.emp_province_tax_inf_id);
80: --
81: pay_cpt_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the pay_ca_emp_prov_tax_info_f Row
84: --
85: update pay_ca_emp_prov_tax_info_f
149: where emp_province_tax_inf_id = p_rec.emp_province_tax_inf_id
150: and effective_start_date = p_validation_start_date
151: and effective_end_date = p_validation_end_date;
152: --
153: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
154: --
155: -- Set the effective start and end dates
156: --
157: p_rec.effective_start_date := p_validation_start_date;
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
166: pay_cpt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
166: pay_cpt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
166: pay_cpt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
171: pay_cpt_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
171: pay_cpt_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
171: pay_cpt_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
177: --
178: -- ----------------------------------------------------------------------------
206: --
207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure update_dml
210: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
211: p_effective_date in date,
212: p_datetrack_mode in varchar2,
213: p_validation_start_date in date,
214: p_validation_end_date in date) is
270: --
271: -- {End Of Comments}
272: -- ----------------------------------------------------------------------------
273: Procedure dt_pre_update
274: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
275: p_effective_date in date,
276: p_datetrack_mode in varchar2,
277: p_validation_start_date in date,
278: p_validation_end_date in date) is
286: hr_utility.set_location(l_proc, 10);
287: --
288: -- Update the current effective end date
289: --
290: pay_cpt_shd.upd_effective_end_date
291: (p_effective_date => p_effective_date,
292: p_base_key_value => p_rec.emp_province_tax_inf_id,
293: p_new_effective_end_date => (p_validation_start_date - 1),
294: p_validation_start_date => p_validation_start_date,
355: --
356: -- {End Of Comments}
357: -- ----------------------------------------------------------------------------
358: Procedure pre_update
359: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
360: p_effective_date in date,
361: p_datetrack_mode in varchar2,
362: p_validation_start_date in date,
363: p_validation_end_date in date) is
411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure post_update
415: (p_rec in pay_cpt_shd.g_rec_type,
416: p_effective_date in date,
417: p_datetrack_mode in varchar2,
418: p_validation_start_date in date,
419: p_validation_end_date in date) is
496: ,p_effective_date =>p_effective_date
497: ,p_datetrack_mode =>p_datetrack_mode
498: ,p_validation_start_date =>p_validation_start_date
499: ,p_validation_end_date =>p_validation_end_date
500: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
501: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
497: ,p_datetrack_mode =>p_datetrack_mode
498: ,p_validation_start_date =>p_validation_start_date
499: ,p_validation_end_date =>p_validation_end_date
500: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
501: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
498: ,p_validation_start_date =>p_validation_start_date
499: ,p_validation_end_date =>p_validation_end_date
500: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
501: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
499: ,p_validation_end_date =>p_validation_end_date
500: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
501: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
500: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
501: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
501: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
502: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
503: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
504: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
505: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
506: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
507: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
508: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
509: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
510: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
511: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
512: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
513: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
514: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
515: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
516: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
517: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
518: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
519: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
520: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
521: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
522: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
523: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
524: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
525: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
526: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
527: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
528: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
529: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
530: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
531: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
532: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
533: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
534: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
535: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
536: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
537: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
538: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
539: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
540: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
541: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
542: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
543: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
544: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
545: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
546: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
547: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
548: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
549: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
550: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
551: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
552: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
560: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
553: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
560: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
561: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
554: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
560: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
561: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
562: ,p_ppip_exempt_flag =>p_rec.ppip_exempt_flag
555: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
560: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
561: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
562: ,p_ppip_exempt_flag =>p_rec.ppip_exempt_flag
563: );
556: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
560: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
561: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
562: ,p_ppip_exempt_flag =>p_rec.ppip_exempt_flag
563: );
564: --
557: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
558: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
559: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
560: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
561: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
562: ,p_ppip_exempt_flag =>p_rec.ppip_exempt_flag
563: );
564: --
565: exception
620: -- Internal Row Handler Use Only.
621: --
622: -- {End Of Comments}
623: -- ----------------------------------------------------------------------------
624: Procedure convert_defs(p_rec in out nocopy pay_cpt_shd.g_rec_type) is
625: --
626: l_proc varchar2(72) := g_package||'convert_defs';
627: --
628: Begin
635: -- is being used then we must set to the 'current' argument value.
636: --
637: If (p_rec.legislation_code = hr_api.g_varchar2) then
638: p_rec.legislation_code :=
639: pay_cpt_shd.g_old_rec.legislation_code;
640: End If;
641: If (p_rec.assignment_id = hr_api.g_number) then
642: p_rec.assignment_id :=
643: pay_cpt_shd.g_old_rec.assignment_id;
639: pay_cpt_shd.g_old_rec.legislation_code;
640: End If;
641: If (p_rec.assignment_id = hr_api.g_number) then
642: p_rec.assignment_id :=
643: pay_cpt_shd.g_old_rec.assignment_id;
644: End If;
645: If (p_rec.business_group_id = hr_api.g_number) then
646: p_rec.business_group_id :=
647: pay_cpt_shd.g_old_rec.business_group_id;
643: pay_cpt_shd.g_old_rec.assignment_id;
644: End If;
645: If (p_rec.business_group_id = hr_api.g_number) then
646: p_rec.business_group_id :=
647: pay_cpt_shd.g_old_rec.business_group_id;
648: End If;
649: If (p_rec.province_code = hr_api.g_varchar2) then
650: p_rec.province_code :=
651: pay_cpt_shd.g_old_rec.province_code;
647: pay_cpt_shd.g_old_rec.business_group_id;
648: End If;
649: If (p_rec.province_code = hr_api.g_varchar2) then
650: p_rec.province_code :=
651: pay_cpt_shd.g_old_rec.province_code;
652: End If;
653: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
654: p_rec.jurisdiction_code :=
655: pay_cpt_shd.g_old_rec.jurisdiction_code;
651: pay_cpt_shd.g_old_rec.province_code;
652: End If;
653: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
654: p_rec.jurisdiction_code :=
655: pay_cpt_shd.g_old_rec.jurisdiction_code;
656: End If;
657: If (p_rec.tax_credit_amount = hr_api.g_number) then
658: p_rec.tax_credit_amount :=
659: pay_cpt_shd.g_old_rec.tax_credit_amount;
655: pay_cpt_shd.g_old_rec.jurisdiction_code;
656: End If;
657: If (p_rec.tax_credit_amount = hr_api.g_number) then
658: p_rec.tax_credit_amount :=
659: pay_cpt_shd.g_old_rec.tax_credit_amount;
660: End If;
661: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
662: p_rec.basic_exemption_flag :=
663: pay_cpt_shd.g_old_rec.basic_exemption_flag;
659: pay_cpt_shd.g_old_rec.tax_credit_amount;
660: End If;
661: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
662: p_rec.basic_exemption_flag :=
663: pay_cpt_shd.g_old_rec.basic_exemption_flag;
664: End If;
665: If (p_rec.deduction_code = hr_api.g_varchar2) then
666: p_rec.deduction_code :=
667: pay_cpt_shd.g_old_rec.deduction_code;
663: pay_cpt_shd.g_old_rec.basic_exemption_flag;
664: End If;
665: If (p_rec.deduction_code = hr_api.g_varchar2) then
666: p_rec.deduction_code :=
667: pay_cpt_shd.g_old_rec.deduction_code;
668: End If;
669: If (p_rec.extra_info_not_provided = hr_api.g_varchar2) then
670: p_rec.extra_info_not_provided :=
671: pay_cpt_shd.g_old_rec.extra_info_not_provided;
667: pay_cpt_shd.g_old_rec.deduction_code;
668: End If;
669: If (p_rec.extra_info_not_provided = hr_api.g_varchar2) then
670: p_rec.extra_info_not_provided :=
671: pay_cpt_shd.g_old_rec.extra_info_not_provided;
672: End If;
673: If (p_rec.marriage_status = hr_api.g_varchar2) then
674: p_rec.marriage_status :=
675: pay_cpt_shd.g_old_rec.marriage_status;
671: pay_cpt_shd.g_old_rec.extra_info_not_provided;
672: End If;
673: If (p_rec.marriage_status = hr_api.g_varchar2) then
674: p_rec.marriage_status :=
675: pay_cpt_shd.g_old_rec.marriage_status;
676: End If;
677: If (p_rec.no_of_infirm_dependants = hr_api.g_number) then
678: p_rec.no_of_infirm_dependants :=
679: pay_cpt_shd.g_old_rec.no_of_infirm_dependants;
675: pay_cpt_shd.g_old_rec.marriage_status;
676: End If;
677: If (p_rec.no_of_infirm_dependants = hr_api.g_number) then
678: p_rec.no_of_infirm_dependants :=
679: pay_cpt_shd.g_old_rec.no_of_infirm_dependants;
680: End If;
681: If (p_rec.non_resident_status = hr_api.g_varchar2) then
682: p_rec.non_resident_status :=
683: pay_cpt_shd.g_old_rec.non_resident_status;
679: pay_cpt_shd.g_old_rec.no_of_infirm_dependants;
680: End If;
681: If (p_rec.non_resident_status = hr_api.g_varchar2) then
682: p_rec.non_resident_status :=
683: pay_cpt_shd.g_old_rec.non_resident_status;
684: End If;
685: If (p_rec.disability_status = hr_api.g_varchar2) then
686: p_rec.disability_status :=
687: pay_cpt_shd.g_old_rec.disability_status;
683: pay_cpt_shd.g_old_rec.non_resident_status;
684: End If;
685: If (p_rec.disability_status = hr_api.g_varchar2) then
686: p_rec.disability_status :=
687: pay_cpt_shd.g_old_rec.disability_status;
688: End If;
689: If (p_rec.no_of_dependants = hr_api.g_number) then
690: p_rec.no_of_dependants :=
691: pay_cpt_shd.g_old_rec.no_of_dependants;
687: pay_cpt_shd.g_old_rec.disability_status;
688: End If;
689: If (p_rec.no_of_dependants = hr_api.g_number) then
690: p_rec.no_of_dependants :=
691: pay_cpt_shd.g_old_rec.no_of_dependants;
692: End If;
693: If (p_rec.annual_dedn = hr_api.g_number) then
694: p_rec.annual_dedn :=
695: pay_cpt_shd.g_old_rec.annual_dedn;
691: pay_cpt_shd.g_old_rec.no_of_dependants;
692: End If;
693: If (p_rec.annual_dedn = hr_api.g_number) then
694: p_rec.annual_dedn :=
695: pay_cpt_shd.g_old_rec.annual_dedn;
696: End If;
697: If (p_rec.total_expense_by_commission = hr_api.g_number) then
698: p_rec.total_expense_by_commission :=
699: pay_cpt_shd.g_old_rec.total_expense_by_commission;
695: pay_cpt_shd.g_old_rec.annual_dedn;
696: End If;
697: If (p_rec.total_expense_by_commission = hr_api.g_number) then
698: p_rec.total_expense_by_commission :=
699: pay_cpt_shd.g_old_rec.total_expense_by_commission;
700: End If;
701: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
702: p_rec.total_remnrtn_by_commission :=
703: pay_cpt_shd.g_old_rec.total_remnrtn_by_commission;
699: pay_cpt_shd.g_old_rec.total_expense_by_commission;
700: End If;
701: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
702: p_rec.total_remnrtn_by_commission :=
703: pay_cpt_shd.g_old_rec.total_remnrtn_by_commission;
704: End If;
705: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
706: p_rec.prescribed_zone_dedn_amt :=
707: pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt;
703: pay_cpt_shd.g_old_rec.total_remnrtn_by_commission;
704: End If;
705: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
706: p_rec.prescribed_zone_dedn_amt :=
707: pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt;
708: End If;
709: If (p_rec.additional_tax = hr_api.g_number) then
710: p_rec.additional_tax :=
711: pay_cpt_shd.g_old_rec.additional_tax;
707: pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt;
708: End If;
709: If (p_rec.additional_tax = hr_api.g_number) then
710: p_rec.additional_tax :=
711: pay_cpt_shd.g_old_rec.additional_tax;
712: End If;
713: If (p_rec.prov_override_rate = hr_api.g_number) then
714: p_rec.prov_override_rate :=
715: pay_cpt_shd.g_old_rec.prov_override_rate;
711: pay_cpt_shd.g_old_rec.additional_tax;
712: End If;
713: If (p_rec.prov_override_rate = hr_api.g_number) then
714: p_rec.prov_override_rate :=
715: pay_cpt_shd.g_old_rec.prov_override_rate;
716: End If;
717: If (p_rec.prov_override_amount = hr_api.g_number) then
718: p_rec.prov_override_amount :=
719: pay_cpt_shd.g_old_rec.prov_override_amount;
715: pay_cpt_shd.g_old_rec.prov_override_rate;
716: End If;
717: If (p_rec.prov_override_amount = hr_api.g_number) then
718: p_rec.prov_override_amount :=
719: pay_cpt_shd.g_old_rec.prov_override_amount;
720: End If;
721: If (p_rec.prov_exempt_flag = hr_api.g_varchar2) then
722: p_rec.prov_exempt_flag :=
723: pay_cpt_shd.g_old_rec.prov_exempt_flag;
719: pay_cpt_shd.g_old_rec.prov_override_amount;
720: End If;
721: If (p_rec.prov_exempt_flag = hr_api.g_varchar2) then
722: p_rec.prov_exempt_flag :=
723: pay_cpt_shd.g_old_rec.prov_exempt_flag;
724: End If;
725: If (p_rec.pmed_exempt_flag = hr_api.g_varchar2) then
726: p_rec.pmed_exempt_flag :=
727: pay_cpt_shd.g_old_rec.pmed_exempt_flag;
723: pay_cpt_shd.g_old_rec.prov_exempt_flag;
724: End If;
725: If (p_rec.pmed_exempt_flag = hr_api.g_varchar2) then
726: p_rec.pmed_exempt_flag :=
727: pay_cpt_shd.g_old_rec.pmed_exempt_flag;
728: End If;
729: If (p_rec.wc_exempt_flag = hr_api.g_varchar2) then
730: p_rec.wc_exempt_flag :=
731: pay_cpt_shd.g_old_rec.wc_exempt_flag;
727: pay_cpt_shd.g_old_rec.pmed_exempt_flag;
728: End If;
729: If (p_rec.wc_exempt_flag = hr_api.g_varchar2) then
730: p_rec.wc_exempt_flag :=
731: pay_cpt_shd.g_old_rec.wc_exempt_flag;
732: End If;
733: If (p_rec.qpp_exempt_flag = hr_api.g_varchar2) then
734: p_rec.qpp_exempt_flag :=
735: pay_cpt_shd.g_old_rec.qpp_exempt_flag;
731: pay_cpt_shd.g_old_rec.wc_exempt_flag;
732: End If;
733: If (p_rec.qpp_exempt_flag = hr_api.g_varchar2) then
734: p_rec.qpp_exempt_flag :=
735: pay_cpt_shd.g_old_rec.qpp_exempt_flag;
736: End If;
737: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
738: p_rec.tax_calc_method :=
739: pay_cpt_shd.g_old_rec.tax_calc_method;
735: pay_cpt_shd.g_old_rec.qpp_exempt_flag;
736: End If;
737: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
738: p_rec.tax_calc_method :=
739: pay_cpt_shd.g_old_rec.tax_calc_method;
740: End If;
741: If (p_rec.other_tax_credit = hr_api.g_number) then
742: p_rec.other_tax_credit :=
743: pay_cpt_shd.g_old_rec.other_tax_credit;
739: pay_cpt_shd.g_old_rec.tax_calc_method;
740: End If;
741: If (p_rec.other_tax_credit = hr_api.g_number) then
742: p_rec.other_tax_credit :=
743: pay_cpt_shd.g_old_rec.other_tax_credit;
744: End If;
745: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
746: p_rec.ca_tax_information_category :=
747: pay_cpt_shd.g_old_rec.ca_tax_information_category;
743: pay_cpt_shd.g_old_rec.other_tax_credit;
744: End If;
745: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
746: p_rec.ca_tax_information_category :=
747: pay_cpt_shd.g_old_rec.ca_tax_information_category;
748: End If;
749: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
750: p_rec.ca_tax_information1 :=
751: pay_cpt_shd.g_old_rec.ca_tax_information1;
747: pay_cpt_shd.g_old_rec.ca_tax_information_category;
748: End If;
749: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
750: p_rec.ca_tax_information1 :=
751: pay_cpt_shd.g_old_rec.ca_tax_information1;
752: End If;
753: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
754: p_rec.ca_tax_information2 :=
755: pay_cpt_shd.g_old_rec.ca_tax_information2;
751: pay_cpt_shd.g_old_rec.ca_tax_information1;
752: End If;
753: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
754: p_rec.ca_tax_information2 :=
755: pay_cpt_shd.g_old_rec.ca_tax_information2;
756: End If;
757: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
758: p_rec.ca_tax_information3 :=
759: pay_cpt_shd.g_old_rec.ca_tax_information3;
755: pay_cpt_shd.g_old_rec.ca_tax_information2;
756: End If;
757: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
758: p_rec.ca_tax_information3 :=
759: pay_cpt_shd.g_old_rec.ca_tax_information3;
760: End If;
761: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
762: p_rec.ca_tax_information4 :=
763: pay_cpt_shd.g_old_rec.ca_tax_information4;
759: pay_cpt_shd.g_old_rec.ca_tax_information3;
760: End If;
761: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
762: p_rec.ca_tax_information4 :=
763: pay_cpt_shd.g_old_rec.ca_tax_information4;
764: End If;
765: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
766: p_rec.ca_tax_information5 :=
767: pay_cpt_shd.g_old_rec.ca_tax_information5;
763: pay_cpt_shd.g_old_rec.ca_tax_information4;
764: End If;
765: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
766: p_rec.ca_tax_information5 :=
767: pay_cpt_shd.g_old_rec.ca_tax_information5;
768: End If;
769: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
770: p_rec.ca_tax_information6 :=
771: pay_cpt_shd.g_old_rec.ca_tax_information6;
767: pay_cpt_shd.g_old_rec.ca_tax_information5;
768: End If;
769: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
770: p_rec.ca_tax_information6 :=
771: pay_cpt_shd.g_old_rec.ca_tax_information6;
772: End If;
773: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
774: p_rec.ca_tax_information7 :=
775: pay_cpt_shd.g_old_rec.ca_tax_information7;
771: pay_cpt_shd.g_old_rec.ca_tax_information6;
772: End If;
773: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
774: p_rec.ca_tax_information7 :=
775: pay_cpt_shd.g_old_rec.ca_tax_information7;
776: End If;
777: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
778: p_rec.ca_tax_information8 :=
779: pay_cpt_shd.g_old_rec.ca_tax_information8;
775: pay_cpt_shd.g_old_rec.ca_tax_information7;
776: End If;
777: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
778: p_rec.ca_tax_information8 :=
779: pay_cpt_shd.g_old_rec.ca_tax_information8;
780: End If;
781: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
782: p_rec.ca_tax_information9 :=
783: pay_cpt_shd.g_old_rec.ca_tax_information9;
779: pay_cpt_shd.g_old_rec.ca_tax_information8;
780: End If;
781: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
782: p_rec.ca_tax_information9 :=
783: pay_cpt_shd.g_old_rec.ca_tax_information9;
784: End If;
785: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
786: p_rec.ca_tax_information10 :=
787: pay_cpt_shd.g_old_rec.ca_tax_information10;
783: pay_cpt_shd.g_old_rec.ca_tax_information9;
784: End If;
785: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
786: p_rec.ca_tax_information10 :=
787: pay_cpt_shd.g_old_rec.ca_tax_information10;
788: End If;
789: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
790: p_rec.ca_tax_information11 :=
791: pay_cpt_shd.g_old_rec.ca_tax_information11;
787: pay_cpt_shd.g_old_rec.ca_tax_information10;
788: End If;
789: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
790: p_rec.ca_tax_information11 :=
791: pay_cpt_shd.g_old_rec.ca_tax_information11;
792: End If;
793: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
794: p_rec.ca_tax_information12 :=
795: pay_cpt_shd.g_old_rec.ca_tax_information12;
791: pay_cpt_shd.g_old_rec.ca_tax_information11;
792: End If;
793: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
794: p_rec.ca_tax_information12 :=
795: pay_cpt_shd.g_old_rec.ca_tax_information12;
796: End If;
797: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
798: p_rec.ca_tax_information13 :=
799: pay_cpt_shd.g_old_rec.ca_tax_information13;
795: pay_cpt_shd.g_old_rec.ca_tax_information12;
796: End If;
797: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
798: p_rec.ca_tax_information13 :=
799: pay_cpt_shd.g_old_rec.ca_tax_information13;
800: End If;
801: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
802: p_rec.ca_tax_information14 :=
803: pay_cpt_shd.g_old_rec.ca_tax_information14;
799: pay_cpt_shd.g_old_rec.ca_tax_information13;
800: End If;
801: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
802: p_rec.ca_tax_information14 :=
803: pay_cpt_shd.g_old_rec.ca_tax_information14;
804: End If;
805: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
806: p_rec.ca_tax_information15 :=
807: pay_cpt_shd.g_old_rec.ca_tax_information15;
803: pay_cpt_shd.g_old_rec.ca_tax_information14;
804: End If;
805: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
806: p_rec.ca_tax_information15 :=
807: pay_cpt_shd.g_old_rec.ca_tax_information15;
808: End If;
809: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
810: p_rec.ca_tax_information16 :=
811: pay_cpt_shd.g_old_rec.ca_tax_information16;
807: pay_cpt_shd.g_old_rec.ca_tax_information15;
808: End If;
809: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
810: p_rec.ca_tax_information16 :=
811: pay_cpt_shd.g_old_rec.ca_tax_information16;
812: End If;
813: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
814: p_rec.ca_tax_information17 :=
815: pay_cpt_shd.g_old_rec.ca_tax_information17;
811: pay_cpt_shd.g_old_rec.ca_tax_information16;
812: End If;
813: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
814: p_rec.ca_tax_information17 :=
815: pay_cpt_shd.g_old_rec.ca_tax_information17;
816: End If;
817: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
818: p_rec.ca_tax_information18 :=
819: pay_cpt_shd.g_old_rec.ca_tax_information18;
815: pay_cpt_shd.g_old_rec.ca_tax_information17;
816: End If;
817: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
818: p_rec.ca_tax_information18 :=
819: pay_cpt_shd.g_old_rec.ca_tax_information18;
820: End If;
821: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
822: p_rec.ca_tax_information19 :=
823: pay_cpt_shd.g_old_rec.ca_tax_information19;
819: pay_cpt_shd.g_old_rec.ca_tax_information18;
820: End If;
821: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
822: p_rec.ca_tax_information19 :=
823: pay_cpt_shd.g_old_rec.ca_tax_information19;
824: End If;
825: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
826: p_rec.ca_tax_information20 :=
827: pay_cpt_shd.g_old_rec.ca_tax_information20;
823: pay_cpt_shd.g_old_rec.ca_tax_information19;
824: End If;
825: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
826: p_rec.ca_tax_information20 :=
827: pay_cpt_shd.g_old_rec.ca_tax_information20;
828: End If;
829: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
830: p_rec.ca_tax_information21 :=
831: pay_cpt_shd.g_old_rec.ca_tax_information21;
827: pay_cpt_shd.g_old_rec.ca_tax_information20;
828: End If;
829: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
830: p_rec.ca_tax_information21 :=
831: pay_cpt_shd.g_old_rec.ca_tax_information21;
832: End If;
833: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
834: p_rec.ca_tax_information22 :=
835: pay_cpt_shd.g_old_rec.ca_tax_information22;
831: pay_cpt_shd.g_old_rec.ca_tax_information21;
832: End If;
833: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
834: p_rec.ca_tax_information22 :=
835: pay_cpt_shd.g_old_rec.ca_tax_information22;
836: End If;
837: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
838: p_rec.ca_tax_information23 :=
839: pay_cpt_shd.g_old_rec.ca_tax_information23;
835: pay_cpt_shd.g_old_rec.ca_tax_information22;
836: End If;
837: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
838: p_rec.ca_tax_information23 :=
839: pay_cpt_shd.g_old_rec.ca_tax_information23;
840: End If;
841: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
842: p_rec.ca_tax_information24 :=
843: pay_cpt_shd.g_old_rec.ca_tax_information24;
839: pay_cpt_shd.g_old_rec.ca_tax_information23;
840: End If;
841: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
842: p_rec.ca_tax_information24 :=
843: pay_cpt_shd.g_old_rec.ca_tax_information24;
844: End If;
845: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
846: p_rec.ca_tax_information25 :=
847: pay_cpt_shd.g_old_rec.ca_tax_information25;
843: pay_cpt_shd.g_old_rec.ca_tax_information24;
844: End If;
845: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
846: p_rec.ca_tax_information25 :=
847: pay_cpt_shd.g_old_rec.ca_tax_information25;
848: End If;
849: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
850: p_rec.ca_tax_information26 :=
851: pay_cpt_shd.g_old_rec.ca_tax_information26;
847: pay_cpt_shd.g_old_rec.ca_tax_information25;
848: End If;
849: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
850: p_rec.ca_tax_information26 :=
851: pay_cpt_shd.g_old_rec.ca_tax_information26;
852: End If;
853: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
854: p_rec.ca_tax_information27 :=
855: pay_cpt_shd.g_old_rec.ca_tax_information27;
851: pay_cpt_shd.g_old_rec.ca_tax_information26;
852: End If;
853: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
854: p_rec.ca_tax_information27 :=
855: pay_cpt_shd.g_old_rec.ca_tax_information27;
856: End If;
857: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
858: p_rec.ca_tax_information28 :=
859: pay_cpt_shd.g_old_rec.ca_tax_information28;
855: pay_cpt_shd.g_old_rec.ca_tax_information27;
856: End If;
857: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
858: p_rec.ca_tax_information28 :=
859: pay_cpt_shd.g_old_rec.ca_tax_information28;
860: End If;
861: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
862: p_rec.ca_tax_information29 :=
863: pay_cpt_shd.g_old_rec.ca_tax_information29;
859: pay_cpt_shd.g_old_rec.ca_tax_information28;
860: End If;
861: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
862: p_rec.ca_tax_information29 :=
863: pay_cpt_shd.g_old_rec.ca_tax_information29;
864: End If;
865: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
866: p_rec.ca_tax_information30 :=
867: pay_cpt_shd.g_old_rec.ca_tax_information30;
863: pay_cpt_shd.g_old_rec.ca_tax_information29;
864: End If;
865: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
866: p_rec.ca_tax_information30 :=
867: pay_cpt_shd.g_old_rec.ca_tax_information30;
868: End If;
869: If (p_rec.prov_lsp_amount = hr_api.g_number) then
870: p_rec.prov_lsp_amount :=
871: pay_cpt_shd.g_old_rec.prov_lsp_amount;
867: pay_cpt_shd.g_old_rec.ca_tax_information30;
868: End If;
869: If (p_rec.prov_lsp_amount = hr_api.g_number) then
870: p_rec.prov_lsp_amount :=
871: pay_cpt_shd.g_old_rec.prov_lsp_amount;
872: End If;
873: If (p_rec.ppip_exempt_flag = hr_api.g_varchar2) then
874: p_rec.ppip_exempt_flag :=
875: pay_cpt_shd.g_old_rec.ppip_exempt_flag;
871: pay_cpt_shd.g_old_rec.prov_lsp_amount;
872: End If;
873: If (p_rec.ppip_exempt_flag = hr_api.g_varchar2) then
874: p_rec.ppip_exempt_flag :=
875: pay_cpt_shd.g_old_rec.ppip_exempt_flag;
876: End If;
877:
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 10);
884: -- |---------------------------------< upd >----------------------------------|
885: -- ----------------------------------------------------------------------------
886: Procedure upd
887: (
888: p_rec in out nocopy pay_cpt_shd.g_rec_type,
889: p_effective_date in date,
890: p_datetrack_mode in varchar2
891: ) is
892: --
902: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
903: --
904: -- We must lock the row which we need to update.
905: --
906: pay_cpt_shd.lck
907: (p_effective_date => p_effective_date,
908: p_datetrack_mode => p_datetrack_mode,
909: p_emp_province_tax_inf_id => p_rec.emp_province_tax_inf_id,
910: p_object_version_number => p_rec.object_version_number,
1027: p_datetrack_mode in varchar2,
1028: p_ppip_exempt_flag in varchar2 default hr_api.g_varchar2
1029: ) is
1030: --
1031: l_rec pay_cpt_shd.g_rec_type;
1032: l_proc varchar2(72) := g_package||'upd';
1033: --
1034: Begin
1035: hr_utility.set_location('Entering:'||l_proc, 5);
1037: -- Call conversion function to turn arguments into the
1038: -- l_rec structure.
1039: --
1040: l_rec :=
1041: pay_cpt_shd.convert_args
1042: (
1043: p_emp_province_tax_inf_id,
1044: null,
1045: null,