DBA Data[Home] [Help]

APPS.BEN_PL_BNF_CTFN_PRVDD_API dependencies on HR_API

Line 268: when hr_api.cannot_find_prog_unit then

264: ,p_program_update_date => p_program_update_date
265: ,p_effective_date => trunc(p_effective_date)
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (
271: p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
272: ,p_hook_type => 'BP'

Line 269: hr_api.cannot_find_prog_unit_error

265: ,p_effective_date => trunc(p_effective_date)
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (
271: p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
272: ,p_hook_type => 'BP'
273: );

Line 383: when hr_api.cannot_find_prog_unit then

379: ,p_object_version_number => l_object_version_number
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
386: ,p_hook_type => 'AP'
387: );

Line 384: hr_api.cannot_find_prog_unit_error

380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
386: ,p_hook_type => 'AP'
387: );
388: --

Line 398: raise hr_api.validate_enabled;

394: --
395: -- When in validation only mode raise the Validate_Enabled exception
396: --
397: if p_validate then
398: raise hr_api.validate_enabled;
399: end if;
400: --
401: -- Set all output arguments
402: --

Line 412: when hr_api.validate_enabled then

408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
410: exception
411: --
412: when hr_api.validate_enabled then
413: --
414: -- As the Validate_Enabled exception has been raised
415: -- we must rollback to the savepoint
416: --

Line 450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2

446: (p_validate in boolean default false
447: ,p_pl_bnf_ctfn_prvdd_id in number
448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number

Line 451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date

447: ,p_pl_bnf_ctfn_prvdd_id in number
448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number

Line 452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2

Line 453: ,p_pl_bnf_id in number default hr_api.g_number

449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2

Line 454: ,p_prtt_enrt_actn_id in number default hr_api.g_number

450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2

Line 455: ,p_business_group_id in number default hr_api.g_number

451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2

Line 456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2

452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2

Line 457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2

453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2

Line 458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2

454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2

Line 459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2

455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2

Line 460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2

456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2

Line 461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2

457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2

Line 462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2

458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2

Line 463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2

459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2

Line 464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2

460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2

Line 465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2

461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2

Line 466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2

462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2

Line 467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2

463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2

Line 468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2

464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2

Line 469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2

465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2

Line 470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2

466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2

Line 471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2

467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2

Line 472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2

468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2

Line 473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2

469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2

Line 474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2

470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2

Line 475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2

471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2

Line 476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2

472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2

Line 477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2

473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2

Line 478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2

474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2

Line 479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2

475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2

Line 480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2

476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2

Line 481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2

477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2

Line 482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2

478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2

Line 483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2

479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number

Line 484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2

480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number

Line 485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2

481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number

Line 486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2

482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date

Line 487: ,p_request_id in number default hr_api.g_number

483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number

Line 488: ,p_program_application_id in number default hr_api.g_number

484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
492: ,p_effective_date in date

Line 489: ,p_program_id in number default hr_api.g_number

485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
492: ,p_effective_date in date
493: ,p_datetrack_mode in varchar2

Line 490: ,p_program_update_date in date default hr_api.g_date

486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
492: ,p_effective_date in date
493: ,p_datetrack_mode in varchar2
494: ) is

Line 585: when hr_api.cannot_find_prog_unit then

581: ,p_effective_date => trunc(p_effective_date)
582: ,p_datetrack_mode => p_datetrack_mode
583: );
584: exception
585: when hr_api.cannot_find_prog_unit then
586: hr_api.cannot_find_prog_unit_error
587: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
588: ,p_hook_type => 'BP'
589: );

Line 586: hr_api.cannot_find_prog_unit_error

582: ,p_datetrack_mode => p_datetrack_mode
583: );
584: exception
585: when hr_api.cannot_find_prog_unit then
586: hr_api.cannot_find_prog_unit_error
587: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
588: ,p_hook_type => 'BP'
589: );
590: --

Line 710: when hr_api.cannot_find_prog_unit then

706: ,p_effective_date => trunc(p_effective_date)
707: ,p_datetrack_mode => p_datetrack_mode
708: );
709: exception
710: when hr_api.cannot_find_prog_unit then
711: hr_api.cannot_find_prog_unit_error
712: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
713: ,p_hook_type => 'AP'
714: );

Line 711: hr_api.cannot_find_prog_unit_error

707: ,p_datetrack_mode => p_datetrack_mode
708: );
709: exception
710: when hr_api.cannot_find_prog_unit then
711: hr_api.cannot_find_prog_unit_error
712: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
713: ,p_hook_type => 'AP'
714: );
715: --

Line 725: raise hr_api.validate_enabled;

721: --
722: -- When in validation only mode raise the Validate_Enabled exception
723: --
724: if p_validate then
725: raise hr_api.validate_enabled;
726: end if;
727: --
728: -- Set all output arguments
729: --

Line 738: when hr_api.validate_enabled then

734: hr_utility.set_location(' Leaving:'||l_proc, 70);
735: --
736: exception
737: --
738: when hr_api.validate_enabled then
739: --
740: -- As the Validate_Enabled exception has been raised
741: -- we must rollback to the savepoint
742: --

Line 868: when hr_api.cannot_find_prog_unit then

864: ,p_effective_date => trunc(p_effective_date)
865: ,p_datetrack_mode => p_datetrack_mode
866: );
867: exception
868: when hr_api.cannot_find_prog_unit then
869: hr_api.cannot_find_prog_unit_error
870: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
871: ,p_hook_type => 'BP'
872: );

Line 869: hr_api.cannot_find_prog_unit_error

865: ,p_datetrack_mode => p_datetrack_mode
866: );
867: exception
868: when hr_api.cannot_find_prog_unit then
869: hr_api.cannot_find_prog_unit_error
870: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
871: ,p_hook_type => 'BP'
872: );
873: --

Line 957: when hr_api.cannot_find_prog_unit then

953: ,p_effective_date => trunc(p_effective_date)
954: ,p_datetrack_mode => p_datetrack_mode
955: );
956: exception
957: when hr_api.cannot_find_prog_unit then
958: hr_api.cannot_find_prog_unit_error
959: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
960: ,p_hook_type => 'AP'
961: );

Line 958: hr_api.cannot_find_prog_unit_error

954: ,p_datetrack_mode => p_datetrack_mode
955: );
956: exception
957: when hr_api.cannot_find_prog_unit then
958: hr_api.cannot_find_prog_unit_error
959: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
960: ,p_hook_type => 'AP'
961: );
962: --

Line 972: raise hr_api.validate_enabled;

968: --
969: -- When in validation only mode raise the Validate_Enabled exception
970: --
971: if p_validate then
972: raise hr_api.validate_enabled;
973: end if;
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 70);
976: --

Line 979: when hr_api.validate_enabled then

975: hr_utility.set_location(' Leaving:'||l_proc, 70);
976: --
977: exception
978: --
979: when hr_api.validate_enabled then
980: --
981: -- As the Validate_Enabled exception has been raised
982: -- we must rollback to the savepoint
983: --