eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CITY_TAX_RULE_API dependencies on HR_API

Line 197: when hr_api.cannot_find_prog_unit then

193: ,p_wage_exempt => p_wage_exempt
194: ,p_school_district_code => p_school_district_code
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (
200: p_module_name => 'CREATE_CITY_TAX_RULE'
201: ,p_hook_type => 'BP'

Line 198: hr_api.cannot_find_prog_unit_error

194: ,p_school_district_code => p_school_district_code
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (
200: p_module_name => 'CREATE_CITY_TAX_RULE'
201: ,p_hook_type => 'BP'
202: );

Line 378: when hr_api.cannot_find_prog_unit then

374: ,p_school_district_code => p_school_district_code
375: ,p_object_version_number => l_object_version_number
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'CREATE_CITY_TAX_RULE'
381: ,p_hook_type => 'AP'
382: );

Line 379: hr_api.cannot_find_prog_unit_error

375: ,p_object_version_number => l_object_version_number
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'CREATE_CITY_TAX_RULE'
381: ,p_hook_type => 'AP'
382: );
383: --

Line 394: raise hr_api.validate_enabled;

390: --
391: -- When in validation only mode raise the Validate_Enabled exception
392: --
393: if p_validate then
394: raise hr_api.validate_enabled;
395: end if;
396: --
397: -- Set all output arguments
398: --

Line 408: when hr_api.validate_enabled then

404: hr_utility.set_location(' Leaving:'||l_proc, 40);
405: --
406: exception
407: --
408: when hr_api.validate_enabled then
409: --
410: -- As the Validate_Enabled exception has been raised
411: -- we must rollback to the savepoint
412: --

Line 448: ,p_additional_wa_rate in number default hr_api.g_number

444: (p_validate in boolean default false
445: ,p_emp_city_tax_rule_id in number
446: ,p_effective_start_date out nocopy date
447: ,p_effective_end_date out nocopy date
448: ,p_additional_wa_rate in number default hr_api.g_number
449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number

Line 449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2

445: ,p_emp_city_tax_rule_id in number
446: ,p_effective_start_date out nocopy date
447: ,p_effective_end_date out nocopy date
448: ,p_additional_wa_rate in number default hr_api.g_number
449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number

Line 450: ,p_lit_additional_tax in number default hr_api.g_number

446: ,p_effective_start_date out nocopy date
447: ,p_effective_end_date out nocopy date
448: ,p_additional_wa_rate in number default hr_api.g_number
449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2

Line 451: ,p_lit_override_amount in number default hr_api.g_number

447: ,p_effective_end_date out nocopy date
448: ,p_additional_wa_rate in number default hr_api.g_number
449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2

Line 452: ,p_lit_override_rate in number default hr_api.g_number

448: ,p_additional_wa_rate in number default hr_api.g_number
449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2

Line 453: ,p_withholding_allowances in number default hr_api.g_number

449: ,p_filing_status_code in varchar2 default hr_api.g_varchar2
450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2

Line 454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2

450: ,p_lit_additional_tax in number default hr_api.g_number
451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
458: ,p_school_district_code in varchar2 default hr_api.g_varchar2

Line 455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2

451: ,p_lit_override_amount in number default hr_api.g_number
452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
458: ,p_school_district_code in varchar2 default hr_api.g_varchar2
459: ,p_object_version_number in out nocopy number

Line 456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2

452: ,p_lit_override_rate in number default hr_api.g_number
453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
458: ,p_school_district_code in varchar2 default hr_api.g_varchar2
459: ,p_object_version_number in out nocopy number
460: ,p_effective_date in date

Line 457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2

453: ,p_withholding_allowances in number default hr_api.g_number
454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
458: ,p_school_district_code in varchar2 default hr_api.g_varchar2
459: ,p_object_version_number in out nocopy number
460: ,p_effective_date in date
461: ,p_datetrack_mode in varchar2

Line 458: ,p_school_district_code in varchar2 default hr_api.g_varchar2

454: ,p_lit_exempt in varchar2 default hr_api.g_varchar2
455: ,p_sd_exempt in varchar2 default hr_api.g_varchar2
456: ,p_ht_exempt in varchar2 default hr_api.g_varchar2
457: ,p_wage_exempt in varchar2 default hr_api.g_varchar2
458: ,p_school_district_code in varchar2 default hr_api.g_varchar2
459: ,p_object_version_number in out nocopy number
460: ,p_effective_date in date
461: ,p_datetrack_mode in varchar2
462: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 462: ,p_attribute_category in varchar2 default hr_api.g_varchar2

458: ,p_school_district_code in varchar2 default hr_api.g_varchar2
459: ,p_object_version_number in out nocopy number
460: ,p_effective_date in date
461: ,p_datetrack_mode in varchar2
462: ,p_attribute_category in varchar2 default hr_api.g_varchar2
463: ,p_attribute1 in varchar2 default hr_api.g_varchar2
464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 463: ,p_attribute1 in varchar2 default hr_api.g_varchar2

459: ,p_object_version_number in out nocopy number
460: ,p_effective_date in date
461: ,p_datetrack_mode in varchar2
462: ,p_attribute_category in varchar2 default hr_api.g_varchar2
463: ,p_attribute1 in varchar2 default hr_api.g_varchar2
464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 464: ,p_attribute2 in varchar2 default hr_api.g_varchar2

460: ,p_effective_date in date
461: ,p_datetrack_mode in varchar2
462: ,p_attribute_category in varchar2 default hr_api.g_varchar2
463: ,p_attribute1 in varchar2 default hr_api.g_varchar2
464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 465: ,p_attribute3 in varchar2 default hr_api.g_varchar2

461: ,p_datetrack_mode in varchar2
462: ,p_attribute_category in varchar2 default hr_api.g_varchar2
463: ,p_attribute1 in varchar2 default hr_api.g_varchar2
464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 466: ,p_attribute4 in varchar2 default hr_api.g_varchar2

462: ,p_attribute_category in varchar2 default hr_api.g_varchar2
463: ,p_attribute1 in varchar2 default hr_api.g_varchar2
464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 467: ,p_attribute5 in varchar2 default hr_api.g_varchar2

463: ,p_attribute1 in varchar2 default hr_api.g_varchar2
464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 468: ,p_attribute6 in varchar2 default hr_api.g_varchar2

464: ,p_attribute2 in varchar2 default hr_api.g_varchar2
465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 469: ,p_attribute7 in varchar2 default hr_api.g_varchar2

465: ,p_attribute3 in varchar2 default hr_api.g_varchar2
466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 470: ,p_attribute8 in varchar2 default hr_api.g_varchar2

466: ,p_attribute4 in varchar2 default hr_api.g_varchar2
467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 471: ,p_attribute9 in varchar2 default hr_api.g_varchar2

467: ,p_attribute5 in varchar2 default hr_api.g_varchar2
468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 472: ,p_attribute10 in varchar2 default hr_api.g_varchar2

468: ,p_attribute6 in varchar2 default hr_api.g_varchar2
469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 473: ,p_attribute11 in varchar2 default hr_api.g_varchar2

469: ,p_attribute7 in varchar2 default hr_api.g_varchar2
470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 474: ,p_attribute12 in varchar2 default hr_api.g_varchar2

470: ,p_attribute8 in varchar2 default hr_api.g_varchar2
471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 475: ,p_attribute13 in varchar2 default hr_api.g_varchar2

471: ,p_attribute9 in varchar2 default hr_api.g_varchar2
472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 476: ,p_attribute14 in varchar2 default hr_api.g_varchar2

472: ,p_attribute10 in varchar2 default hr_api.g_varchar2
473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 477: ,p_attribute15 in varchar2 default hr_api.g_varchar2

473: ,p_attribute11 in varchar2 default hr_api.g_varchar2
474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 478: ,p_attribute16 in varchar2 default hr_api.g_varchar2

474: ,p_attribute12 in varchar2 default hr_api.g_varchar2
475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 479: ,p_attribute17 in varchar2 default hr_api.g_varchar2

475: ,p_attribute13 in varchar2 default hr_api.g_varchar2
476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 480: ,p_attribute18 in varchar2 default hr_api.g_varchar2

476: ,p_attribute14 in varchar2 default hr_api.g_varchar2
477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 481: ,p_attribute19 in varchar2 default hr_api.g_varchar2

477: ,p_attribute15 in varchar2 default hr_api.g_varchar2
478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 482: ,p_attribute20 in varchar2 default hr_api.g_varchar2

478: ,p_attribute16 in varchar2 default hr_api.g_varchar2
479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 483: ,p_attribute21 in varchar2 default hr_api.g_varchar2

479: ,p_attribute17 in varchar2 default hr_api.g_varchar2
480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 484: ,p_attribute22 in varchar2 default hr_api.g_varchar2

480: ,p_attribute18 in varchar2 default hr_api.g_varchar2
481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 485: ,p_attribute23 in varchar2 default hr_api.g_varchar2

481: ,p_attribute19 in varchar2 default hr_api.g_varchar2
482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 486: ,p_attribute24 in varchar2 default hr_api.g_varchar2

482: ,p_attribute20 in varchar2 default hr_api.g_varchar2
483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 487: ,p_attribute25 in varchar2 default hr_api.g_varchar2

483: ,p_attribute21 in varchar2 default hr_api.g_varchar2
484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 488: ,p_attribute26 in varchar2 default hr_api.g_varchar2

484: ,p_attribute22 in varchar2 default hr_api.g_varchar2
485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 489: ,p_attribute27 in varchar2 default hr_api.g_varchar2

485: ,p_attribute23 in varchar2 default hr_api.g_varchar2
486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2

Line 490: ,p_attribute28 in varchar2 default hr_api.g_varchar2

486: ,p_attribute24 in varchar2 default hr_api.g_varchar2
487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2

Line 491: ,p_attribute29 in varchar2 default hr_api.g_varchar2

487: ,p_attribute25 in varchar2 default hr_api.g_varchar2
488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2

Line 492: ,p_attribute30 in varchar2 default hr_api.g_varchar2

488: ,p_attribute26 in varchar2 default hr_api.g_varchar2
489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2

Line 493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2

489: ,p_attribute27 in varchar2 default hr_api.g_varchar2
490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2

Line 494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2

490: ,p_attribute28 in varchar2 default hr_api.g_varchar2
491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2

Line 495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2

491: ,p_attribute29 in varchar2 default hr_api.g_varchar2
492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2

Line 496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2

492: ,p_attribute30 in varchar2 default hr_api.g_varchar2
493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2

Line 497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2

493: ,p_cty_information_category in varchar2 default hr_api.g_varchar2
494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2

Line 498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2

494: ,p_cty_information1 in varchar2 default hr_api.g_varchar2
495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2

Line 499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2

495: ,p_cty_information2 in varchar2 default hr_api.g_varchar2
496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2

Line 500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2

496: ,p_cty_information3 in varchar2 default hr_api.g_varchar2
497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2

Line 501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2

497: ,p_cty_information4 in varchar2 default hr_api.g_varchar2
498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2

Line 502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2

498: ,p_cty_information5 in varchar2 default hr_api.g_varchar2
499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2

Line 503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2

499: ,p_cty_information6 in varchar2 default hr_api.g_varchar2
500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2

Line 504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2

500: ,p_cty_information7 in varchar2 default hr_api.g_varchar2
501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2

Line 505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2

501: ,p_cty_information8 in varchar2 default hr_api.g_varchar2
502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2

Line 506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2

502: ,p_cty_information9 in varchar2 default hr_api.g_varchar2
503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2

Line 507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2

503: ,p_cty_information10 in varchar2 default hr_api.g_varchar2
504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2

Line 508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2

504: ,p_cty_information11 in varchar2 default hr_api.g_varchar2
505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2

Line 509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2

505: ,p_cty_information12 in varchar2 default hr_api.g_varchar2
506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2

Line 510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2

506: ,p_cty_information13 in varchar2 default hr_api.g_varchar2
507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2

Line 511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2

507: ,p_cty_information14 in varchar2 default hr_api.g_varchar2
508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2

Line 512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2

508: ,p_cty_information15 in varchar2 default hr_api.g_varchar2
509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2

Line 513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2

509: ,p_cty_information16 in varchar2 default hr_api.g_varchar2
510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2

Line 514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2

510: ,p_cty_information17 in varchar2 default hr_api.g_varchar2
511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2

Line 515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2

511: ,p_cty_information18 in varchar2 default hr_api.g_varchar2
512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2

Line 516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2

512: ,p_cty_information19 in varchar2 default hr_api.g_varchar2
513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2

Line 517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2

513: ,p_cty_information20 in varchar2 default hr_api.g_varchar2
514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2

Line 518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2

514: ,p_cty_information21 in varchar2 default hr_api.g_varchar2
515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2
522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2

Line 519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2

515: ,p_cty_information22 in varchar2 default hr_api.g_varchar2
516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2
522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2
523: ,p_cty_information30 in varchar2 default hr_api.g_varchar2

Line 520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2

516: ,p_cty_information23 in varchar2 default hr_api.g_varchar2
517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2
522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2
523: ,p_cty_information30 in varchar2 default hr_api.g_varchar2
524: ) is

Line 521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2

517: ,p_cty_information24 in varchar2 default hr_api.g_varchar2
518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2
522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2
523: ,p_cty_information30 in varchar2 default hr_api.g_varchar2
524: ) is
525: --

Line 522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2

518: ,p_cty_information25 in varchar2 default hr_api.g_varchar2
519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2
522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2
523: ,p_cty_information30 in varchar2 default hr_api.g_varchar2
524: ) is
525: --
526: -- Declare cursors and local variables

Line 523: ,p_cty_information30 in varchar2 default hr_api.g_varchar2

519: ,p_cty_information26 in varchar2 default hr_api.g_varchar2
520: ,p_cty_information27 in varchar2 default hr_api.g_varchar2
521: ,p_cty_information28 in varchar2 default hr_api.g_varchar2
522: ,p_cty_information29 in varchar2 default hr_api.g_varchar2
523: ,p_cty_information30 in varchar2 default hr_api.g_varchar2
524: ) is
525: --
526: -- Declare cursors and local variables
527: --

Line 593: when hr_api.cannot_find_prog_unit then

589: ,p_school_district_code => p_school_district_code
590: ,p_object_version_number => p_object_version_number
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'UPDATE_CITY_TAX_RULE'
596: ,p_hook_type => 'BP'
597: );

Line 594: hr_api.cannot_find_prog_unit_error

590: ,p_object_version_number => p_object_version_number
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'UPDATE_CITY_TAX_RULE'
596: ,p_hook_type => 'BP'
597: );
598: --

Line 691: p_school_district_code <> hr_api.g_varchar2 THEN

687: -- Call create_asg_geo_row to create rows in the pay_us_asg_reporting
688: -- table if this city 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_city_tax_rule_id,
694: p_effective_date);
695: FETCH csr_assignment_id

Line 735: when hr_api.cannot_find_prog_unit then

731: ,p_school_district_code => p_school_district_code
732: ,p_object_version_number => p_object_version_number
733: );
734: exception
735: when hr_api.cannot_find_prog_unit then
736: hr_api.cannot_find_prog_unit_error
737: (p_module_name => 'UPDATE_CITY_TAX_RULE'
738: ,p_hook_type => 'AP'
739: );

Line 736: hr_api.cannot_find_prog_unit_error

732: ,p_object_version_number => p_object_version_number
733: );
734: exception
735: when hr_api.cannot_find_prog_unit then
736: hr_api.cannot_find_prog_unit_error
737: (p_module_name => 'UPDATE_CITY_TAX_RULE'
738: ,p_hook_type => 'AP'
739: );
740: --

Line 751: raise hr_api.validate_enabled;

747: --
748: -- When in validation only mode raise the Validate_Enabled exception
749: --
750: if p_validate then
751: raise hr_api.validate_enabled;
752: end if;
753: --
754: -- Set all output arguments
755: --

Line 764: when hr_api.validate_enabled then

760: hr_utility.set_location(' Leaving:'||l_proc, 30);
761: --
762: exception
763: --
764: when hr_api.validate_enabled then
765: --
766: -- As the Validate_Enabled exception has been raised
767: -- we must rollback to the savepoint
768: --