DBA Data[Home] [Help]

APPS.PAY_CPT_DEL dependencies on PAY_CPT_SHD

Line 54: (p_rec in out nocopy pay_cpt_shd.g_rec_type,

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
55: p_effective_date in date,
56: p_datetrack_mode in varchar2,
57: p_validation_start_date in date,
58: p_validation_end_date in date) is

Line 66: pay_cpt_shd.g_api_dml := true; -- Set the api dml status

62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: pay_cpt_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

71: delete from pay_ca_emp_prov_tax_info_f
72: where emp_province_tax_inf_id = p_rec.emp_province_tax_inf_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: pay_cpt_shd.g_api_dml := true; -- Set the api dml status
79: --

Line 78: pay_cpt_shd.g_api_dml := true; -- Set the api dml status

74: --
75: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: pay_cpt_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --

Line 87: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

83: delete from pay_ca_emp_prov_tax_info_f
84: where emp_province_tax_inf_id = p_rec.emp_province_tax_inf_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --

Line 94: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status

90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

Line 102: (p_rec in out nocopy pay_cpt_shd.g_rec_type,

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is

Line 156: (p_rec in out nocopy pay_cpt_shd.g_rec_type,

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is

Line 169: p_rec.effective_start_date := pay_cpt_shd.g_old_rec.effective_start_date;

165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := pay_cpt_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: pay_cpt_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: pay_cpt_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.emp_province_tax_inf_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,

Line 227: (p_rec in out nocopy pay_cpt_shd.g_rec_type,

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_delete
227: (p_rec in out nocopy pay_cpt_shd.g_rec_type,
228: p_effective_date in date,
229: p_datetrack_mode in varchar2,
230: p_validation_start_date in date,
231: p_validation_end_date in date) is

Line 285: (p_rec in pay_cpt_shd.g_rec_type,

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in pay_cpt_shd.g_rec_type,
286: p_effective_date in date,
287: p_datetrack_mode in varchar2,
288: p_validation_start_date in date,
289: p_validation_end_date in date) is

Line 309: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date

305: ,p_validation_start_date =>p_validation_start_date
306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id

Line 310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date

306: ,p_validation_end_date =>p_validation_end_date
307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code

Line 311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code

307: ,p_effective_start_date =>p_rec.effective_start_date
308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code

Line 312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id

308: ,p_effective_end_date =>p_rec.effective_end_date
309: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount

Line 313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id

309: ,p_effective_start_date_o =>pay_cpt_shd.g_old_rec.effective_start_date
310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag

Line 314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code

310: ,p_effective_end_date_o =>pay_cpt_shd.g_old_rec.effective_end_date
311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code

Line 315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code

311: ,p_legislation_code_o =>pay_cpt_shd.g_old_rec.legislation_code
312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided

Line 316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount

312: ,p_assignment_id_o =>pay_cpt_shd.g_old_rec.assignment_id
313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status

Line 317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag

313: ,p_business_group_id_o =>pay_cpt_shd.g_old_rec.business_group_id
314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants

Line 318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code

314: ,p_province_code_o =>pay_cpt_shd.g_old_rec.province_code
315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status

Line 319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided

315: ,p_jurisdiction_code_o =>pay_cpt_shd.g_old_rec.jurisdiction_code
316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status

Line 320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status

316: ,p_tax_credit_amount_o =>pay_cpt_shd.g_old_rec.tax_credit_amount
317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants

Line 321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants

317: ,p_basic_exemption_flag_o =>pay_cpt_shd.g_old_rec.basic_exemption_flag
318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn

Line 322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status

318: ,p_deduction_code_o =>pay_cpt_shd.g_old_rec.deduction_code
319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission

Line 323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status

319: ,p_extra_info_not_provided_o =>pay_cpt_shd.g_old_rec.extra_info_not_provided
320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission

Line 324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants

320: ,p_marriage_status_o =>pay_cpt_shd.g_old_rec.marriage_status
321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt

Line 325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn

321: ,p_no_of_infirm_dependants_o =>pay_cpt_shd.g_old_rec.no_of_infirm_dependants
322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax

Line 326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission

322: ,p_non_resident_status_o =>pay_cpt_shd.g_old_rec.non_resident_status
323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate

Line 327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission

323: ,p_disability_status_o =>pay_cpt_shd.g_old_rec.disability_status
324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount

Line 328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt

324: ,p_no_of_dependants_o =>pay_cpt_shd.g_old_rec.no_of_dependants
325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag

Line 329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax

325: ,p_annual_dedn_o =>pay_cpt_shd.g_old_rec.annual_dedn
326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag

Line 330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate

326: ,p_total_expense_by_commissio_o =>pay_cpt_shd.g_old_rec.total_expense_by_commission
327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag

Line 331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount

327: ,p_total_remnrtn_by_commissio_o =>pay_cpt_shd.g_old_rec.total_remnrtn_by_commission
328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag

Line 332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag

328: ,p_prescribed_zone_dedn_amt_o =>pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt
329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method

Line 333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag

329: ,p_additional_tax_o =>pay_cpt_shd.g_old_rec.additional_tax
330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit

Line 334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag

330: ,p_prov_override_rate_o =>pay_cpt_shd.g_old_rec.prov_override_rate
331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category

Line 335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag

331: ,p_prov_override_amount_o =>pay_cpt_shd.g_old_rec.prov_override_amount
332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1

Line 336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method

332: ,p_prov_exempt_flag_o =>pay_cpt_shd.g_old_rec.prov_exempt_flag
333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2

Line 337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit

333: ,p_pmed_exempt_flag_o =>pay_cpt_shd.g_old_rec.pmed_exempt_flag
334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3

Line 338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category

334: ,p_wc_exempt_flag_o =>pay_cpt_shd.g_old_rec.wc_exempt_flag
335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4

Line 339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1

335: ,p_qpp_exempt_flag_o =>pay_cpt_shd.g_old_rec.qpp_exempt_flag
336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5

Line 340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2

336: ,p_tax_calc_method_o =>pay_cpt_shd.g_old_rec.tax_calc_method
337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6

Line 341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3

337: ,p_other_tax_credit_o =>pay_cpt_shd.g_old_rec.other_tax_credit
338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7

Line 342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4

338: ,p_ca_tax_information_categor_o =>pay_cpt_shd.g_old_rec.ca_tax_information_category
339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8

Line 343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5

339: ,p_ca_tax_information1_o =>pay_cpt_shd.g_old_rec.ca_tax_information1
340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9

Line 344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6

340: ,p_ca_tax_information2_o =>pay_cpt_shd.g_old_rec.ca_tax_information2
341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10

Line 345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7

341: ,p_ca_tax_information3_o =>pay_cpt_shd.g_old_rec.ca_tax_information3
342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11

Line 346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8

342: ,p_ca_tax_information4_o =>pay_cpt_shd.g_old_rec.ca_tax_information4
343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12

Line 347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9

343: ,p_ca_tax_information5_o =>pay_cpt_shd.g_old_rec.ca_tax_information5
344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13

Line 348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10

344: ,p_ca_tax_information6_o =>pay_cpt_shd.g_old_rec.ca_tax_information6
345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14

Line 349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11

345: ,p_ca_tax_information7_o =>pay_cpt_shd.g_old_rec.ca_tax_information7
346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15

Line 350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12

346: ,p_ca_tax_information8_o =>pay_cpt_shd.g_old_rec.ca_tax_information8
347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16

Line 351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13

347: ,p_ca_tax_information9_o =>pay_cpt_shd.g_old_rec.ca_tax_information9
348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17

Line 352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14

348: ,p_ca_tax_information10_o =>pay_cpt_shd.g_old_rec.ca_tax_information10
349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18

Line 353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15

349: ,p_ca_tax_information11_o =>pay_cpt_shd.g_old_rec.ca_tax_information11
350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19

Line 354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16

350: ,p_ca_tax_information12_o =>pay_cpt_shd.g_old_rec.ca_tax_information12
351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20

Line 355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17

351: ,p_ca_tax_information13_o =>pay_cpt_shd.g_old_rec.ca_tax_information13
352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21

Line 356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18

352: ,p_ca_tax_information14_o =>pay_cpt_shd.g_old_rec.ca_tax_information14
353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22

Line 357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19

353: ,p_ca_tax_information15_o =>pay_cpt_shd.g_old_rec.ca_tax_information15
354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23

Line 358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20

354: ,p_ca_tax_information16_o =>pay_cpt_shd.g_old_rec.ca_tax_information16
355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24

Line 359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21

355: ,p_ca_tax_information17_o =>pay_cpt_shd.g_old_rec.ca_tax_information17
356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25

Line 360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22

356: ,p_ca_tax_information18_o =>pay_cpt_shd.g_old_rec.ca_tax_information18
357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26

Line 361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23

357: ,p_ca_tax_information19_o =>pay_cpt_shd.g_old_rec.ca_tax_information19
358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27

Line 362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24

358: ,p_ca_tax_information20_o =>pay_cpt_shd.g_old_rec.ca_tax_information20
359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28

Line 363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25

359: ,p_ca_tax_information21_o =>pay_cpt_shd.g_old_rec.ca_tax_information21
360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29

Line 364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26

360: ,p_ca_tax_information22_o =>pay_cpt_shd.g_old_rec.ca_tax_information22
361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30

Line 365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27

361: ,p_ca_tax_information23_o =>pay_cpt_shd.g_old_rec.ca_tax_information23
362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number

Line 366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28

362: ,p_ca_tax_information24_o =>pay_cpt_shd.g_old_rec.ca_tax_information24
363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount

Line 367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29

363: ,p_ca_tax_information25_o =>pay_cpt_shd.g_old_rec.ca_tax_information25
364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
371: ,p_ppip_exempt_flag_o =>pay_cpt_shd.g_old_rec.ppip_exempt_flag

Line 368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30

364: ,p_ca_tax_information26_o =>pay_cpt_shd.g_old_rec.ca_tax_information26
365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
371: ,p_ppip_exempt_flag_o =>pay_cpt_shd.g_old_rec.ppip_exempt_flag
372: );

Line 369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number

365: ,p_ca_tax_information27_o =>pay_cpt_shd.g_old_rec.ca_tax_information27
366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
371: ,p_ppip_exempt_flag_o =>pay_cpt_shd.g_old_rec.ppip_exempt_flag
372: );
373: --

Line 370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount

366: ,p_ca_tax_information28_o =>pay_cpt_shd.g_old_rec.ca_tax_information28
367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
371: ,p_ppip_exempt_flag_o =>pay_cpt_shd.g_old_rec.ppip_exempt_flag
372: );
373: --
374: exception

Line 371: ,p_ppip_exempt_flag_o =>pay_cpt_shd.g_old_rec.ppip_exempt_flag

367: ,p_ca_tax_information29_o =>pay_cpt_shd.g_old_rec.ca_tax_information29
368: ,p_ca_tax_information30_o =>pay_cpt_shd.g_old_rec.ca_tax_information30
369: ,p_object_version_number_o =>pay_cpt_shd.g_old_rec.object_version_number
370: ,p_prov_lsp_amount_o =>pay_cpt_shd.g_old_rec.prov_lsp_amount
371: ,p_ppip_exempt_flag_o =>pay_cpt_shd.g_old_rec.ppip_exempt_flag
372: );
373: --
374: exception
375: --

Line 395: p_rec in out nocopy pay_cpt_shd.g_rec_type,

391: -- |---------------------------------< del >----------------------------------|
392: -- ----------------------------------------------------------------------------
393: Procedure del
394: (
395: p_rec in out nocopy pay_cpt_shd.g_rec_type,
396: p_effective_date in date,
397: p_datetrack_mode in varchar2
398: ) is
399: --

Line 413: pay_cpt_shd.lck

409: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
410: --
411: -- We must lock the row which we need to delete.
412: --
413: pay_cpt_shd.lck
414: (p_effective_date => p_effective_date,
415: p_datetrack_mode => p_datetrack_mode,
416: p_emp_province_tax_inf_id => p_rec.emp_province_tax_inf_id,
417: p_object_version_number => p_rec.object_version_number,

Line 473: l_rec pay_cpt_shd.g_rec_type;

469: p_effective_date in date,
470: p_datetrack_mode in varchar2
471: ) is
472: --
473: l_rec pay_cpt_shd.g_rec_type;
474: l_proc varchar2(72) := g_package||'del';
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);