174: ,p_wage_exempt => p_wage_exempt
175: ,p_school_district_code => p_school_district_code
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'CREATE_COUNTY_TAX_RULE'
182: ,p_hook_type => 'BP'
175: ,p_school_district_code => p_school_district_code
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'CREATE_COUNTY_TAX_RULE'
182: ,p_hook_type => 'BP'
183: );
368: ,p_school_district_code => p_school_district_code
369: ,p_object_version_number => l_object_version_number
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'CREATE_COUNTY_TAX_RULE'
375: ,p_hook_type => 'AP'
376: );
369: ,p_object_version_number => l_object_version_number
370: );
371: exception
372: when hr_api.cannot_find_prog_unit then
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'CREATE_COUNTY_TAX_RULE'
375: ,p_hook_type => 'AP'
376: );
377: --
384: --
385: -- When in validation only mode raise the Validate_Enabled exception
386: --
387: if p_validate then
388: raise hr_api.validate_enabled;
389: end if;
390: --
391: -- Set all output arguments
392: --
398: hr_utility.set_location(' Leaving:'||l_proc, 50);
399: --
400: exception
401: --
402: when hr_api.validate_enabled then
403: --
404: -- As the Validate_Enabled exception has been raised
405: -- we must rollback to the savepoint
406: --
441: (p_validate in boolean default false
442: ,p_emp_county_tax_rule_id in number
443: ,p_effective_start_date out nocopy date
444: ,p_effective_end_date out nocopy date
445: ,p_additional_wa_rate in number default hr_api.g_number
446: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
442: ,p_emp_county_tax_rule_id in number
443: ,p_effective_start_date out nocopy date
444: ,p_effective_end_date out nocopy date
445: ,p_additional_wa_rate in number default hr_api.g_number
446: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
443: ,p_effective_start_date out nocopy date
444: ,p_effective_end_date out nocopy date
445: ,p_additional_wa_rate in number default hr_api.g_number
446: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
444: ,p_effective_end_date out nocopy date
445: ,p_additional_wa_rate in number default hr_api.g_number
446: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
445: ,p_additional_wa_rate in number default hr_api.g_number
446: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
446: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
454: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
447: ,p_lit_additional_tax in number default hr_api.g_number
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
454: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
455: ,p_school_district_code in varchar2 default hr_api.g_varchar2
448: ,p_lit_override_amount in number default hr_api.g_number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
454: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
455: ,p_school_district_code in varchar2 default hr_api.g_varchar2
456: ,p_object_version_number in out nocopy number
449: ,p_lit_override_rate in number default hr_api.g_number
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
454: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
455: ,p_school_district_code in varchar2 default hr_api.g_varchar2
456: ,p_object_version_number in out nocopy number
457: ,p_effective_date in date
450: ,p_withholding_allowances in number default hr_api.g_number
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
454: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
455: ,p_school_district_code in varchar2 default hr_api.g_varchar2
456: ,p_object_version_number in out nocopy number
457: ,p_effective_date in date
458: ,p_datetrack_mode in varchar2
451: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
452: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
453: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
454: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
455: ,p_school_district_code in varchar2 default hr_api.g_varchar2
456: ,p_object_version_number in out nocopy number
457: ,p_effective_date in date
458: ,p_datetrack_mode in varchar2
459: ,p_attribute_category in varchar2 default hr_api.g_varchar2
455: ,p_school_district_code in varchar2 default hr_api.g_varchar2
456: ,p_object_version_number in out nocopy number
457: ,p_effective_date in date
458: ,p_datetrack_mode in varchar2
459: ,p_attribute_category in varchar2 default hr_api.g_varchar2
460: ,p_attribute1 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
456: ,p_object_version_number in out nocopy number
457: ,p_effective_date in date
458: ,p_datetrack_mode in varchar2
459: ,p_attribute_category in varchar2 default hr_api.g_varchar2
460: ,p_attribute1 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
457: ,p_effective_date in date
458: ,p_datetrack_mode in varchar2
459: ,p_attribute_category in varchar2 default hr_api.g_varchar2
460: ,p_attribute1 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
458: ,p_datetrack_mode in varchar2
459: ,p_attribute_category in varchar2 default hr_api.g_varchar2
460: ,p_attribute1 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
459: ,p_attribute_category in varchar2 default hr_api.g_varchar2
460: ,p_attribute1 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
460: ,p_attribute1 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
461: ,p_attribute2 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
462: ,p_attribute3 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
463: ,p_attribute4 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
464: ,p_attribute5 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
465: ,p_attribute6 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
466: ,p_attribute7 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
467: ,p_attribute8 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
468: ,p_attribute9 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
469: ,p_attribute10 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
470: ,p_attribute11 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
471: ,p_attribute12 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
472: ,p_attribute13 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
473: ,p_attribute14 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
474: ,p_attribute15 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
475: ,p_attribute16 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
476: ,p_attribute17 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
477: ,p_attribute18 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
478: ,p_attribute19 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
479: ,p_attribute20 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
480: ,p_attribute21 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
481: ,p_attribute22 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
482: ,p_attribute23 in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
483: ,p_attribute24 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
484: ,p_attribute25 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
485: ,p_attribute26 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
486: ,p_attribute27 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
487: ,p_attribute28 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
488: ,p_attribute29 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
489: ,p_attribute30 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
490: ,p_cnt_information_category in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
491: ,p_cnt_information1 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
492: ,p_cnt_information2 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
493: ,p_cnt_information3 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
494: ,p_cnt_information4 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
495: ,p_cnt_information5 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
496: ,p_cnt_information6 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
497: ,p_cnt_information7 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
498: ,p_cnt_information8 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
499: ,p_cnt_information9 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
500: ,p_cnt_information10 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
501: ,p_cnt_information11 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
502: ,p_cnt_information12 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
503: ,p_cnt_information13 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
504: ,p_cnt_information14 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
505: ,p_cnt_information15 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
506: ,p_cnt_information16 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
507: ,p_cnt_information17 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
508: ,p_cnt_information18 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
509: ,p_cnt_information19 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
510: ,p_cnt_information20 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
511: ,p_cnt_information21 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
519: ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
512: ,p_cnt_information22 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
519: ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
520: ,p_cnt_information30 in varchar2 default hr_api.g_varchar2
513: ,p_cnt_information23 in varchar2 default hr_api.g_varchar2
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
519: ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
520: ,p_cnt_information30 in varchar2 default hr_api.g_varchar2
521: ) is
514: ,p_cnt_information24 in varchar2 default hr_api.g_varchar2
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
519: ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
520: ,p_cnt_information30 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
515: ,p_cnt_information25 in varchar2 default hr_api.g_varchar2
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
519: ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
520: ,p_cnt_information30 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: -- Declare cursors and local variables
516: ,p_cnt_information26 in varchar2 default hr_api.g_varchar2
517: ,p_cnt_information27 in varchar2 default hr_api.g_varchar2
518: ,p_cnt_information28 in varchar2 default hr_api.g_varchar2
519: ,p_cnt_information29 in varchar2 default hr_api.g_varchar2
520: ,p_cnt_information30 in varchar2 default hr_api.g_varchar2
521: ) is
522: --
523: -- Declare cursors and local variables
524: --
586: ,p_school_district_code => p_school_district_code
587: ,p_object_version_number => p_object_version_number
588: );
589: exception
590: when hr_api.cannot_find_prog_unit then
591: hr_api.cannot_find_prog_unit_error
592: (p_module_name => 'UPDATE_COUNTY_TAX_RULE'
593: ,p_hook_type => 'BP'
594: );
587: ,p_object_version_number => p_object_version_number
588: );
589: exception
590: when hr_api.cannot_find_prog_unit then
591: hr_api.cannot_find_prog_unit_error
592: (p_module_name => 'UPDATE_COUNTY_TAX_RULE'
593: ,p_hook_type => 'BP'
594: );
595: --
687: -- Call create_asg_geo_row to create rows in the pay_us_asg_reporting
688: -- table if the county school district has changed
689: --
690: if p_school_district_code IS NOT NULL AND
691: p_school_district_code <> hr_api.g_varchar2 THEN
692: hr_utility.set_location(l_proc, 22);
693: OPEN csr_assignment_id(p_emp_county_tax_rule_id,
694: p_effective_date);
695: FETCH csr_assignment_id
729: ,p_school_district_code => p_school_district_code
730: ,p_object_version_number => l_object_version_number
731: );
732: exception
733: when hr_api.cannot_find_prog_unit then
734: hr_api.cannot_find_prog_unit_error
735: (p_module_name => 'UPDATE_COUNTY_TAX_RULE'
736: ,p_hook_type => 'AP'
737: );
730: ,p_object_version_number => l_object_version_number
731: );
732: exception
733: when hr_api.cannot_find_prog_unit then
734: hr_api.cannot_find_prog_unit_error
735: (p_module_name => 'UPDATE_COUNTY_TAX_RULE'
736: ,p_hook_type => 'AP'
737: );
738: --
745: --
746: -- When in validation only mode raise the Validate_Enabled exception
747: --
748: if p_validate then
749: raise hr_api.validate_enabled;
750: end if;
751: --
752: -- Set all output arguments
753: --
758: hr_utility.set_location(' Leaving:'||l_proc, 30);
759: --
760: exception
761: --
762: when hr_api.validate_enabled then
763: --
764: -- As the Validate_Enabled exception has been raised
765: -- we must rollback to the savepoint
766: --