187: ,p_cpp_revocation_date => p_cpp_revocation_date --For Bug Number 13258136
188: ,p_effective_date => trunc(p_effective_date)
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (
194: p_module_name => 'CREATE_ca_emp_fedtax_inf'
195: ,p_hook_type => 'BP'
188: ,p_effective_date => trunc(p_effective_date)
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (
194: p_module_name => 'CREATE_ca_emp_fedtax_inf'
195: ,p_hook_type => 'BP'
196: );
330: ,p_cpp_revocation_date => p_cpp_revocation_date --For Bug Number 13258136
331: ,p_effective_date => trunc(p_effective_date)
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'CREATE_ca_emp_fedtax_inf'
337: ,p_hook_type => 'AP'
338: );
331: ,p_effective_date => trunc(p_effective_date)
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'CREATE_ca_emp_fedtax_inf'
337: ,p_hook_type => 'AP'
338: );
339: --
346: --
347: -- When in validation only mode raise the Validate_Enabled exception
348: --
349: if p_validate then
350: raise hr_api.validate_enabled;
351: end if;
352: --
353: -- Set all output arguments
354: --
361: --
362: end if;
363: exception
364: --
365: when hr_api.validate_enabled then
366: --
367: -- As the Validate_Enabled exception has been raised
368: -- we must rollback to the savepoint
369: --
396: (p_validate in boolean default false
397: ,p_emp_fed_tax_inf_id in number
398: ,p_effective_start_date out nocopy date
399: ,p_effective_end_date out nocopy date
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_assignment_id in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
397: ,p_emp_fed_tax_inf_id in number
398: ,p_effective_start_date out nocopy date
399: ,p_effective_end_date out nocopy date
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_assignment_id in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
398: ,p_effective_start_date out nocopy date
399: ,p_effective_end_date out nocopy date
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_assignment_id in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
399: ,p_effective_end_date out nocopy date
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_assignment_id in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
400: ,p_legislation_code in varchar2 default hr_api.g_varchar2
401: ,p_assignment_id in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
401: ,p_assignment_id in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
402: ,p_business_group_id in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
403: ,p_employment_province in varchar2 default hr_api.g_varchar2
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
404: ,p_tax_credit_amount in number default hr_api.g_number
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
405: ,p_claim_code in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
406: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
407: ,p_additional_tax in number default hr_api.g_number
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
408: ,p_annual_dedn in number default hr_api.g_number
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
409: ,p_total_expense_by_commission in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
410: ,p_total_remnrtn_by_commission in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
411: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
412: ,p_other_fedtax_credits in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
413: ,p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
414: ,p_fed_exempt_flag in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
415: ,p_ei_exempt_flag in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
416: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
417: ,p_fed_override_amount in number default hr_api.g_number
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
418: ,p_fed_override_rate in number default hr_api.g_number
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
419: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
420: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
421: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
422: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
423: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
424: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
425: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
426: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
427: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
428: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
429: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
430: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
431: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
432: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
433: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
434: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
435: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
436: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
437: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
438: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
439: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
440: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
441: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
449: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
442: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
449: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
450: ,p_object_version_number in out nocopy number
443: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
449: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
450: ,p_object_version_number in out nocopy number
451: ,p_fed_lsf_amount in number default hr_api.g_number
444: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
449: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
450: ,p_object_version_number in out nocopy number
451: ,p_fed_lsf_amount in number default hr_api.g_number
452: ,p_cpp_election_date in date default null --For Bug Number 13258136, defaulted for Bug 13690645
445: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
446: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
449: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
450: ,p_object_version_number in out nocopy number
451: ,p_fed_lsf_amount in number default hr_api.g_number
452: ,p_cpp_election_date in date default null --For Bug Number 13258136, defaulted for Bug 13690645
453: ,p_cpp_revocation_date in date default null --For Bug Number 13258136, defaulted for Bug 13690645
447: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
448: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
449: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
450: ,p_object_version_number in out nocopy number
451: ,p_fed_lsf_amount in number default hr_api.g_number
452: ,p_cpp_election_date in date default null --For Bug Number 13258136, defaulted for Bug 13690645
453: ,p_cpp_revocation_date in date default null --For Bug Number 13258136, defaulted for Bug 13690645
454: ,p_effective_date in date
455: ,p_datetrack_mode in varchar2
541: ,p_effective_date => trunc(p_effective_date)
542: ,p_datetrack_mode => p_datetrack_mode
543: );
544: exception
545: when hr_api.cannot_find_prog_unit then
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'UPDATE_ca_emp_fedtax_inf'
548: ,p_hook_type => 'BP'
549: );
542: ,p_datetrack_mode => p_datetrack_mode
543: );
544: exception
545: when hr_api.cannot_find_prog_unit then
546: hr_api.cannot_find_prog_unit_error
547: (p_module_name => 'UPDATE_ca_emp_fedtax_inf'
548: ,p_hook_type => 'BP'
549: );
550: --
683: ,p_effective_date => trunc(p_effective_date)
684: ,p_datetrack_mode => p_datetrack_mode
685: );
686: exception
687: when hr_api.cannot_find_prog_unit then
688: hr_api.cannot_find_prog_unit_error
689: (p_module_name => 'UPDATE_ca_emp_fedtax_inf'
690: ,p_hook_type => 'AP'
691: );
684: ,p_datetrack_mode => p_datetrack_mode
685: );
686: exception
687: when hr_api.cannot_find_prog_unit then
688: hr_api.cannot_find_prog_unit_error
689: (p_module_name => 'UPDATE_ca_emp_fedtax_inf'
690: ,p_hook_type => 'AP'
691: );
692: --
699: --
700: -- When in validation only mode raise the Validate_Enabled exception
701: --
702: if p_validate then
703: raise hr_api.validate_enabled;
704: end if;
705: --
706: -- Set all output arguments
707: --
712: hr_utility.set_location(' Leaving:'||l_proc, 70);
713: --
714: exception
715: --
716: when hr_api.validate_enabled then
717: --
718: -- As the Validate_Enabled exception has been raised
719: -- we must rollback to the savepoint
720: --
782: ,p_effective_date => trunc(p_effective_date)
783: ,p_datetrack_mode => p_datetrack_mode
784: );
785: exception
786: when hr_api.cannot_find_prog_unit then
787: hr_api.cannot_find_prog_unit_error
788: (p_module_name => 'DELETE_ca_emp_fedtax_inf'
789: ,p_hook_type => 'BP'
790: );
783: ,p_datetrack_mode => p_datetrack_mode
784: );
785: exception
786: when hr_api.cannot_find_prog_unit then
787: hr_api.cannot_find_prog_unit_error
788: (p_module_name => 'DELETE_ca_emp_fedtax_inf'
789: ,p_hook_type => 'BP'
790: );
791: --
818: ,p_effective_date => trunc(p_effective_date)
819: ,p_datetrack_mode => p_datetrack_mode
820: );
821: exception
822: when hr_api.cannot_find_prog_unit then
823: hr_api.cannot_find_prog_unit_error
824: (p_module_name => 'DELETE_ca_emp_fedtax_inf'
825: ,p_hook_type => 'AP'
826: );
819: ,p_datetrack_mode => p_datetrack_mode
820: );
821: exception
822: when hr_api.cannot_find_prog_unit then
823: hr_api.cannot_find_prog_unit_error
824: (p_module_name => 'DELETE_ca_emp_fedtax_inf'
825: ,p_hook_type => 'AP'
826: );
827: --
834: --
835: -- When in validation only mode raise the Validate_Enabled exception
836: --
837: if p_validate then
838: raise hr_api.validate_enabled;
839: end if;
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 70);
842: --
841: hr_utility.set_location(' Leaving:'||l_proc, 70);
842: --
843: exception
844: --
845: when hr_api.validate_enabled then
846: --
847: -- As the Validate_Enabled exception has been raised
848: -- we must rollback to the savepoint
849: --