205: ,p_effective_date => trunc(p_effective_date)
206: ,p_ppip_exempt_flag => p_ppip_exempt_flag
207: );
208: exception
209: when hr_api.cannot_find_prog_unit then
210: hr_api.cannot_find_prog_unit_error
211: (
212: p_module_name => 'CREATE_ca_emp_prvtax_inf'
213: ,p_hook_type => 'BP'
206: ,p_ppip_exempt_flag => p_ppip_exempt_flag
207: );
208: exception
209: when hr_api.cannot_find_prog_unit then
210: hr_api.cannot_find_prog_unit_error
211: (
212: p_module_name => 'CREATE_ca_emp_prvtax_inf'
213: ,p_hook_type => 'BP'
214: );
360: ,p_prov_lsp_amount => p_prov_lsp_amount
361: ,p_effective_date => trunc(p_effective_date)
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_ca_emp_prvtax_inf'
367: ,p_hook_type => 'AP'
368: );
361: ,p_effective_date => trunc(p_effective_date)
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_ca_emp_prvtax_inf'
367: ,p_hook_type => 'AP'
368: );
369: --
376: --
377: -- When in validation only mode raise the Validate_Enabled exception
378: --
379: if p_validate then
380: raise hr_api.validate_enabled;
381: end if;
382: --
383: -- Set all output arguments
384: --
391: --
392: end if;
393: exception
394: --
395: when hr_api.validate_enabled then
396: --
397: -- As the Validate_Enabled exception has been raised
398: -- we must rollback to the savepoint
399: --
433: (p_validate in boolean default false
434: ,p_emp_province_tax_inf_id in number
435: ,p_effective_start_date out nocopy date
436: ,p_effective_end_date out nocopy date
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_assignment_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
434: ,p_emp_province_tax_inf_id in number
435: ,p_effective_start_date out nocopy date
436: ,p_effective_end_date out nocopy date
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_assignment_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
435: ,p_effective_start_date out nocopy date
436: ,p_effective_end_date out nocopy date
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_assignment_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
436: ,p_effective_end_date out nocopy date
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_assignment_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
437: ,p_legislation_code in varchar2 default hr_api.g_varchar2
438: ,p_assignment_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
438: ,p_assignment_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
440: ,p_province_code in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
441: ,p_jurisdiction_code in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
442: ,p_tax_credit_amount in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
443: ,p_basic_exemption_flag in varchar2 default hr_api.g_varchar2
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
444: ,p_deduction_code in varchar2 default hr_api.g_varchar2
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
445: ,p_extra_info_not_provided in varchar2 default hr_api.g_varchar2
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
446: ,p_marriage_status in varchar2 default hr_api.g_varchar2
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
447: ,p_no_of_infirm_dependants in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
448: ,p_non_resident_status in varchar2 default hr_api.g_varchar2
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
449: ,p_disability_status in varchar2 default hr_api.g_varchar2
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
450: ,p_no_of_dependants in number default hr_api.g_number
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
451: ,p_annual_dedn in number default hr_api.g_number
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
452: ,p_total_expense_by_commission in number default hr_api.g_number
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
453: ,p_total_remnrtn_by_commission in number default hr_api.g_number
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
454: ,p_prescribed_zone_dedn_amt in number default hr_api.g_number
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
455: ,p_additional_tax in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
456: ,p_prov_override_rate in number default hr_api.g_number
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
457: ,p_prov_override_amount in number default hr_api.g_number
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
458: ,p_prov_exempt_flag in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
459: ,p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
460: ,p_wc_exempt_flag in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
461: ,p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
462: ,p_tax_calc_method in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
463: ,p_other_tax_credit in number default hr_api.g_number
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
464: ,p_ca_tax_information_category in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
465: ,p_ca_tax_information1 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
466: ,p_ca_tax_information2 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
467: ,p_ca_tax_information3 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
468: ,p_ca_tax_information4 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
469: ,p_ca_tax_information5 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
470: ,p_ca_tax_information6 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
471: ,p_ca_tax_information7 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
472: ,p_ca_tax_information8 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
473: ,p_ca_tax_information9 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
474: ,p_ca_tax_information10 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
475: ,p_ca_tax_information11 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
476: ,p_ca_tax_information12 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
477: ,p_ca_tax_information13 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
478: ,p_ca_tax_information14 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
479: ,p_ca_tax_information15 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
480: ,p_ca_tax_information16 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
481: ,p_ca_tax_information17 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
482: ,p_ca_tax_information18 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
483: ,p_ca_tax_information19 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
484: ,p_ca_tax_information20 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
485: ,p_ca_tax_information21 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
486: ,p_ca_tax_information22 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
494: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
487: ,p_ca_tax_information23 in varchar2 default hr_api.g_varchar2
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
494: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
495: ,p_object_version_number in out nocopy number
488: ,p_ca_tax_information24 in varchar2 default hr_api.g_varchar2
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
494: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
495: ,p_object_version_number in out nocopy number
496: ,p_prov_lsp_amount in number default hr_api.g_number
489: ,p_ca_tax_information25 in varchar2 default hr_api.g_varchar2
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
494: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
495: ,p_object_version_number in out nocopy number
496: ,p_prov_lsp_amount in number default hr_api.g_number
497: ,p_effective_date in date
490: ,p_ca_tax_information26 in varchar2 default hr_api.g_varchar2
491: ,p_ca_tax_information27 in varchar2 default hr_api.g_varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
494: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
495: ,p_object_version_number in out nocopy number
496: ,p_prov_lsp_amount in number default hr_api.g_number
497: ,p_effective_date in date
498: ,p_datetrack_mode in varchar2
492: ,p_ca_tax_information28 in varchar2 default hr_api.g_varchar2
493: ,p_ca_tax_information29 in varchar2 default hr_api.g_varchar2
494: ,p_ca_tax_information30 in varchar2 default hr_api.g_varchar2
495: ,p_object_version_number in out nocopy number
496: ,p_prov_lsp_amount in number default hr_api.g_number
497: ,p_effective_date in date
498: ,p_datetrack_mode in varchar2
499: ,p_ppip_exempt_flag in varchar2 default hr_api.g_varchar2
500: ) is
495: ,p_object_version_number in out nocopy number
496: ,p_prov_lsp_amount in number default hr_api.g_number
497: ,p_effective_date in date
498: ,p_datetrack_mode in varchar2
499: ,p_ppip_exempt_flag in varchar2 default hr_api.g_varchar2
500: ) is
501: --
502: -- Declare cursors and local variables
503: --
591: ,p_effective_date => trunc(p_effective_date)
592: ,p_datetrack_mode => p_datetrack_mode
593: );
594: exception
595: when hr_api.cannot_find_prog_unit then
596: hr_api.cannot_find_prog_unit_error
597: (p_module_name => 'UPDATE_ca_emp_prvtax_inf'
598: ,p_hook_type => 'BP'
599: );
592: ,p_datetrack_mode => p_datetrack_mode
593: );
594: exception
595: when hr_api.cannot_find_prog_unit then
596: hr_api.cannot_find_prog_unit_error
597: (p_module_name => 'UPDATE_ca_emp_prvtax_inf'
598: ,p_hook_type => 'BP'
599: );
600: --
747: ,p_effective_date => trunc(p_effective_date)
748: ,p_datetrack_mode => p_datetrack_mode
749: );
750: exception
751: when hr_api.cannot_find_prog_unit then
752: hr_api.cannot_find_prog_unit_error
753: (p_module_name => 'UPDATE_ca_emp_prvtax_inf'
754: ,p_hook_type => 'AP'
755: );
748: ,p_datetrack_mode => p_datetrack_mode
749: );
750: exception
751: when hr_api.cannot_find_prog_unit then
752: hr_api.cannot_find_prog_unit_error
753: (p_module_name => 'UPDATE_ca_emp_prvtax_inf'
754: ,p_hook_type => 'AP'
755: );
756: --
763: --
764: -- When in validation only mode raise the Validate_Enabled exception
765: --
766: if p_validate then
767: raise hr_api.validate_enabled;
768: end if;
769: --
770: -- Set all output arguments
771: --
776: hr_utility.set_location(' Leaving:'||l_proc, 70);
777: --
778: exception
779: --
780: when hr_api.validate_enabled then
781: --
782: -- As the Validate_Enabled exception has been raised
783: -- we must rollback to the savepoint
784: --
853: ,p_effective_date => trunc(p_effective_date)
854: ,p_datetrack_mode => p_datetrack_mode
855: );
856: exception
857: when hr_api.cannot_find_prog_unit then
858: hr_api.cannot_find_prog_unit_error
859: (p_module_name => 'DELETE_ca_emp_prvtax_inf'
860: ,p_hook_type => 'BP'
861: );
854: ,p_datetrack_mode => p_datetrack_mode
855: );
856: exception
857: when hr_api.cannot_find_prog_unit then
858: hr_api.cannot_find_prog_unit_error
859: (p_module_name => 'DELETE_ca_emp_prvtax_inf'
860: ,p_hook_type => 'BP'
861: );
862: --
889: ,p_effective_date => trunc(p_effective_date)
890: ,p_datetrack_mode => p_datetrack_mode
891: );
892: exception
893: when hr_api.cannot_find_prog_unit then
894: hr_api.cannot_find_prog_unit_error
895: (p_module_name => 'DELETE_ca_emp_prvtax_inf'
896: ,p_hook_type => 'AP'
897: );
890: ,p_datetrack_mode => p_datetrack_mode
891: );
892: exception
893: when hr_api.cannot_find_prog_unit then
894: hr_api.cannot_find_prog_unit_error
895: (p_module_name => 'DELETE_ca_emp_prvtax_inf'
896: ,p_hook_type => 'AP'
897: );
898: --
905: --
906: -- When in validation only mode raise the Validate_Enabled exception
907: --
908: if p_validate then
909: raise hr_api.validate_enabled;
910: end if;
911: --
912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: --
912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: --
914: exception
915: --
916: when hr_api.validate_enabled then
917: --
918: -- As the Validate_Enabled exception has been raised
919: -- we must rollback to the savepoint
920: --