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.BEN_PLAN_BENEFICIARY_API dependencies on HR_API

Line 188: when hr_api.cannot_find_prog_unit then

184: ,p_per_in_ler_id => l_per_in_ler_id
185: ,p_effective_date => trunc(p_effective_date)
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (
191: p_module_name => 'CREATE_PLAN_BENEFICIARY'
192: ,p_hook_type => 'BP'

Line 189: hr_api.cannot_find_prog_unit_error

185: ,p_effective_date => trunc(p_effective_date)
186: );
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (
191: p_module_name => 'CREATE_PLAN_BENEFICIARY'
192: ,p_hook_type => 'BP'
193: );

Line 350: when hr_api.cannot_find_prog_unit then

346: ,p_per_in_ler_id => l_per_in_ler_id
347: ,p_effective_date => trunc(p_effective_date)
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'CREATE_PLAN_BENEFICIARY'
353: ,p_hook_type => 'AP'
354: );

Line 351: hr_api.cannot_find_prog_unit_error

347: ,p_effective_date => trunc(p_effective_date)
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'CREATE_PLAN_BENEFICIARY'
353: ,p_hook_type => 'AP'
354: );
355: --

Line 365: raise hr_api.validate_enabled;

361: --
362: -- When in validation only mode raise the Validate_Enabled exception
363: --
364: if p_validate then
365: raise hr_api.validate_enabled;
366: end if;
367: --
368: -- Set all output arguments
369: --

Line 379: when hr_api.validate_enabled then

375: hr_utility.set_location(' Leaving:'||l_proc, 70);
376: --
377: exception
378: --
379: when hr_api.validate_enabled then
380: --
381: -- As the Validate_Enabled exception has been raised
382: -- we must rollback to the savepoint
383: --

Line 532: ,p_business_group_id in number default hr_api.g_number

528: (p_validate in boolean default false
529: ,p_pl_bnf_id in number
530: ,p_effective_start_date out nocopy date
531: ,p_effective_end_date out nocopy date
532: ,p_business_group_id in number default hr_api.g_number
533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number

Line 533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

529: ,p_pl_bnf_id in number
530: ,p_effective_start_date out nocopy date
531: ,p_effective_end_date out nocopy date
532: ,p_business_group_id in number default hr_api.g_number
533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2

Line 534: ,p_bnf_person_id in number default hr_api.g_number

530: ,p_effective_start_date out nocopy date
531: ,p_effective_end_date out nocopy date
532: ,p_business_group_id in number default hr_api.g_number
533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number

Line 535: ,p_organization_id in number default hr_api.g_number

531: ,p_effective_end_date out nocopy date
532: ,p_business_group_id in number default hr_api.g_number
533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number

Line 536: ,p_ttee_person_id in number default hr_api.g_number

532: ,p_business_group_id in number default hr_api.g_number
533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2

Line 537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2

533: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date

Line 538: ,p_pct_dsgd_num in number default hr_api.g_number

534: ,p_bnf_person_id in number default hr_api.g_number
535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date

Line 539: ,p_amt_dsgd_val in number default hr_api.g_number

535: ,p_organization_id in number default hr_api.g_number
536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2

Line 540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2

536: ,p_ttee_person_id in number default hr_api.g_number
537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2

Line 541: ,p_dsgn_strt_dt in date default hr_api.g_date

537: ,p_prmry_cntngnt_cd in varchar2 default hr_api.g_varchar2
538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2

Line 542: ,p_dsgn_thru_dt in date default hr_api.g_date

538: ,p_pct_dsgd_num in number default hr_api.g_number
539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2

Line 543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2

539: ,p_amt_dsgd_val in number default hr_api.g_number
540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2

Line 544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2

540: ,p_amt_dsgd_uom in varchar2 default hr_api.g_varchar2
541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2

Line 545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2

541: ,p_dsgn_strt_dt in date default hr_api.g_date
542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2

Line 546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2

542: ,p_dsgn_thru_dt in date default hr_api.g_date
543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2

Line 547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2

543: ,p_addl_instrn_txt in varchar2 default hr_api.g_varchar2
544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2

Line 548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2

544: ,p_pbn_attribute_category in varchar2 default hr_api.g_varchar2
545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2

Line 549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2

545: ,p_pbn_attribute1 in varchar2 default hr_api.g_varchar2
546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2

Line 550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2

546: ,p_pbn_attribute2 in varchar2 default hr_api.g_varchar2
547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2

Line 551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2

547: ,p_pbn_attribute3 in varchar2 default hr_api.g_varchar2
548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2

Line 552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2

548: ,p_pbn_attribute4 in varchar2 default hr_api.g_varchar2
549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2

Line 553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2

549: ,p_pbn_attribute5 in varchar2 default hr_api.g_varchar2
550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2

Line 554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2

550: ,p_pbn_attribute6 in varchar2 default hr_api.g_varchar2
551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2

Line 555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2

551: ,p_pbn_attribute7 in varchar2 default hr_api.g_varchar2
552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2

Line 556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2

552: ,p_pbn_attribute8 in varchar2 default hr_api.g_varchar2
553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2

Line 557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2

553: ,p_pbn_attribute9 in varchar2 default hr_api.g_varchar2
554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2

Line 558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2

554: ,p_pbn_attribute10 in varchar2 default hr_api.g_varchar2
555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2

Line 559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2

555: ,p_pbn_attribute11 in varchar2 default hr_api.g_varchar2
556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2

Line 560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2

556: ,p_pbn_attribute12 in varchar2 default hr_api.g_varchar2
557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2

Line 561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2

557: ,p_pbn_attribute13 in varchar2 default hr_api.g_varchar2
558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2

Line 562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2

558: ,p_pbn_attribute14 in varchar2 default hr_api.g_varchar2
559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2

Line 563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2

559: ,p_pbn_attribute15 in varchar2 default hr_api.g_varchar2
560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2

Line 564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2

560: ,p_pbn_attribute16 in varchar2 default hr_api.g_varchar2
561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2

Line 565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2

561: ,p_pbn_attribute17 in varchar2 default hr_api.g_varchar2
562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2

Line 566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2

562: ,p_pbn_attribute18 in varchar2 default hr_api.g_varchar2
563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2

Line 567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2

563: ,p_pbn_attribute19 in varchar2 default hr_api.g_varchar2
564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2

Line 568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2

564: ,p_pbn_attribute20 in varchar2 default hr_api.g_varchar2
565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2

Line 569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2

565: ,p_pbn_attribute21 in varchar2 default hr_api.g_varchar2
566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2

Line 570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2

566: ,p_pbn_attribute22 in varchar2 default hr_api.g_varchar2
567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2

Line 571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2

567: ,p_pbn_attribute23 in varchar2 default hr_api.g_varchar2
568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number

Line 572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2

568: ,p_pbn_attribute24 in varchar2 default hr_api.g_varchar2
569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number

Line 573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2

569: ,p_pbn_attribute25 in varchar2 default hr_api.g_varchar2
570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number

Line 574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2

570: ,p_pbn_attribute26 in varchar2 default hr_api.g_varchar2
571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number
578: ,p_program_update_date in date default hr_api.g_date

Line 575: ,p_request_id in number default hr_api.g_number

571: ,p_pbn_attribute27 in varchar2 default hr_api.g_varchar2
572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number
578: ,p_program_update_date in date default hr_api.g_date
579: ,p_object_version_number in out nocopy number

Line 576: ,p_program_application_id in number default hr_api.g_number

572: ,p_pbn_attribute28 in varchar2 default hr_api.g_varchar2
573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number
578: ,p_program_update_date in date default hr_api.g_date
579: ,p_object_version_number in out nocopy number
580: ,p_per_in_ler_id in number default hr_api.g_number

Line 577: ,p_program_id in number default hr_api.g_number

573: ,p_pbn_attribute29 in varchar2 default hr_api.g_varchar2
574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number
578: ,p_program_update_date in date default hr_api.g_date
579: ,p_object_version_number in out nocopy number
580: ,p_per_in_ler_id in number default hr_api.g_number
581: ,p_effective_date in date

Line 578: ,p_program_update_date in date default hr_api.g_date

574: ,p_pbn_attribute30 in varchar2 default hr_api.g_varchar2
575: ,p_request_id in number default hr_api.g_number
576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number
578: ,p_program_update_date in date default hr_api.g_date
579: ,p_object_version_number in out nocopy number
580: ,p_per_in_ler_id in number default hr_api.g_number
581: ,p_effective_date in date
582: ,p_datetrack_mode in varchar2

Line 580: ,p_per_in_ler_id in number default hr_api.g_number

576: ,p_program_application_id in number default hr_api.g_number
577: ,p_program_id in number default hr_api.g_number
578: ,p_program_update_date in date default hr_api.g_date
579: ,p_object_version_number in out nocopy number
580: ,p_per_in_ler_id in number default hr_api.g_number
581: ,p_effective_date in date
582: ,p_datetrack_mode in varchar2
583: ,p_multi_row_actn in boolean default TRUE
584: ) is

Line 686: when hr_api.cannot_find_prog_unit then

682: ,p_effective_date => trunc(p_effective_date)
683: ,p_datetrack_mode => p_datetrack_mode
684: );
685: exception
686: when hr_api.cannot_find_prog_unit then
687: hr_api.cannot_find_prog_unit_error
688: (p_module_name => 'UPDATE_PLAN_BENEFICIARY'
689: ,p_hook_type => 'BP'
690: );

Line 687: hr_api.cannot_find_prog_unit_error

683: ,p_datetrack_mode => p_datetrack_mode
684: );
685: exception
686: when hr_api.cannot_find_prog_unit then
687: hr_api.cannot_find_prog_unit_error
688: (p_module_name => 'UPDATE_PLAN_BENEFICIARY'
689: ,p_hook_type => 'BP'
690: );
691: --

Line 777: p_datetrack_mode => hr_api.g_zap,

773: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
774: (p_validate => p_validate,
775: p_effective_date => p_effective_date,
776: p_business_group_id => p_business_group_id,
777: p_datetrack_mode => hr_api.g_zap,
778: p_object_version_number => l_object_version_number,
779: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
780: p_rslt_object_version_number => l_rslt_object_version_number,
781: p_unsuspend_enrt_flag => 'N',

Line 794: if not(p_dsgn_strt_dt is not null and p_dsgn_thru_dt = hr_api.g_eot) then

790: -----tilak
791:
792: -- If not covered, call delete useage
793: --
794: if not(p_dsgn_strt_dt is not null and p_dsgn_thru_dt = hr_api.g_eot) then
795: --
796: --
797: if p_datetrack_mode = 'UPDATE' then
798: l2_datetrack_mode := 'DELETE';

Line 899: when hr_api.cannot_find_prog_unit then

895: ,p_effective_date => trunc(p_effective_date)
896: ,p_datetrack_mode => p_datetrack_mode
897: );
898: exception
899: when hr_api.cannot_find_prog_unit then
900: hr_api.cannot_find_prog_unit_error
901: (p_module_name => 'UPDATE_PLAN_BENEFICIARY'
902: ,p_hook_type => 'AP'
903: );

Line 900: hr_api.cannot_find_prog_unit_error

896: ,p_datetrack_mode => p_datetrack_mode
897: );
898: exception
899: when hr_api.cannot_find_prog_unit then
900: hr_api.cannot_find_prog_unit_error
901: (p_module_name => 'UPDATE_PLAN_BENEFICIARY'
902: ,p_hook_type => 'AP'
903: );
904: --

Line 914: raise hr_api.validate_enabled;

910: --
911: -- When in validation only mode raise the Validate_Enabled exception
912: --
913: if p_validate then
914: raise hr_api.validate_enabled;
915: end if;
916: --
917: -- Set all output arguments
918: --

Line 927: when hr_api.validate_enabled then

923: hr_utility.set_location(' Leaving:'||l_proc, 70);
924: --
925: exception
926: --
927: when hr_api.validate_enabled then
928: --
929: -- As the Validate_Enabled exception has been raised
930: -- we must rollback to the savepoint
931: --

Line 965: ,p_bnf_person_id in number default hr_api.g_number

961: ,p_effective_start_date out nocopy date
962: ,p_effective_end_date out nocopy date
963: ,p_business_group_id in number
964: ,p_prtt_enrt_rslt_id in number
965: ,p_bnf_person_id in number default hr_api.g_number
966: ,p_organization_id in number default hr_api.g_number
967: ,p_prmry_cntngnt_cd in varchar2
968: ,p_pct_dsgd_num in number
969: ,p_dsgn_strt_dt in date

Line 966: ,p_organization_id in number default hr_api.g_number

962: ,p_effective_end_date out nocopy date
963: ,p_business_group_id in number
964: ,p_prtt_enrt_rslt_id in number
965: ,p_bnf_person_id in number default hr_api.g_number
966: ,p_organization_id in number default hr_api.g_number
967: ,p_prmry_cntngnt_cd in varchar2
968: ,p_pct_dsgd_num in number
969: ,p_dsgn_strt_dt in date
970: ,p_dsgn_thru_dt in date

Line 1146: l_datetrack_mode := hr_api.g_zap ;

1142: fetch c_pl_bnf into l_pl_bnf ;
1143: close c_pl_bnf ;
1144: --
1145: if l_pl_bnf.effective_start_date = p_effective_date then
1146: l_datetrack_mode := hr_api.g_zap ;
1147: l_effective_date := p_effective_date ;
1148: elsif p_datetrack_mode = hr_api.g_delete then
1149: l_effective_date := p_effective_date - 1 ;
1150: l_datetrack_mode := p_datetrack_mode ;

Line 1148: elsif p_datetrack_mode = hr_api.g_delete then

1144: --
1145: if l_pl_bnf.effective_start_date = p_effective_date then
1146: l_datetrack_mode := hr_api.g_zap ;
1147: l_effective_date := p_effective_date ;
1148: elsif p_datetrack_mode = hr_api.g_delete then
1149: l_effective_date := p_effective_date - 1 ;
1150: l_datetrack_mode := p_datetrack_mode ;
1151: else
1152: l_effective_date := p_effective_date ;

Line 1184: if p_datetrack_mode = hr_api.g_zap then

1180: --
1181: --
1182: -- Delete certifications
1183: --
1184: if p_datetrack_mode = hr_api.g_zap then
1185: --
1186: for ctfn_rec in bnf_ctfn_id_zap_c loop
1187: --
1188: open bnf_ctfn_ovn_zap_c(ctfn_rec.pl_bnf_ctfn_prvdd_id);

Line 1214: ctfn_rec.effective_end_date = hr_api.g_eot) and

1210: --
1211: --bug#2564387 - if the record is not end dated don't call delete in future-change mode
1212: --Bug 4064635 we can't delete the cert which is already deleted
1213: if not (p_datetrack_mode = 'FUTURE_CHANGE' and
1214: ctfn_rec.effective_end_date = hr_api.g_eot) and
1215: ctfn_rec.effective_end_date <> l_effective_date then
1216: --
1217: if p_datetrack_mode = 'FUTURE_CHANGE' then
1218: --if there is no future row change the mode to delete

Line 1222: l_datetrack_mode := hr_api.g_delete;

1218: --if there is no future row change the mode to delete
1219: open c_future_row (ctfn_rec.pl_bnf_ctfn_prvdd_id, ctfn_rec.effective_end_date);
1220: fetch c_future_row into l_dummy;
1221: if c_future_row%notfound then
1222: l_datetrack_mode := hr_api.g_delete;
1223: end if;
1224: close c_future_row;
1225: --
1226: end if;

Line 1257: when hr_api.cannot_find_prog_unit then

1253: ,p_effective_date => trunc(l_effective_date)
1254: ,p_datetrack_mode => l_datetrack_mode
1255: );
1256: exception
1257: when hr_api.cannot_find_prog_unit then
1258: hr_api.cannot_find_prog_unit_error
1259: (p_module_name => 'DELETE_PLAN_BENEFICIARY'
1260: ,p_hook_type => 'BP'
1261: );

Line 1258: hr_api.cannot_find_prog_unit_error

1254: ,p_datetrack_mode => l_datetrack_mode
1255: );
1256: exception
1257: when hr_api.cannot_find_prog_unit then
1258: hr_api.cannot_find_prog_unit_error
1259: (p_module_name => 'DELETE_PLAN_BENEFICIARY'
1260: ,p_hook_type => 'BP'
1261: );
1262: --

Line 1345: when hr_api.cannot_find_prog_unit then

1341: ,p_effective_date => trunc(l_effective_date)
1342: ,p_datetrack_mode => l_datetrack_mode
1343: );
1344: exception
1345: when hr_api.cannot_find_prog_unit then
1346: hr_api.cannot_find_prog_unit_error
1347: (p_module_name => 'DELETE_PLAN_BENEFICIARY'
1348: ,p_hook_type => 'AP'
1349: );

Line 1346: hr_api.cannot_find_prog_unit_error

1342: ,p_datetrack_mode => l_datetrack_mode
1343: );
1344: exception
1345: when hr_api.cannot_find_prog_unit then
1346: hr_api.cannot_find_prog_unit_error
1347: (p_module_name => 'DELETE_PLAN_BENEFICIARY'
1348: ,p_hook_type => 'AP'
1349: );
1350: --

Line 1360: raise hr_api.validate_enabled;

1356: --
1357: -- When in validation only mode raise the Validate_Enabled exception
1358: --
1359: if p_validate then
1360: raise hr_api.validate_enabled;
1361: end if;
1362: --
1363: hr_utility.set_location(' Leaving:'||l_proc, 70);
1364: --

Line 1367: when hr_api.validate_enabled then

1363: hr_utility.set_location(' Leaving:'||l_proc, 70);
1364: --
1365: exception
1366: --
1367: when hr_api.validate_enabled then
1368: --
1369: -- As the Validate_Enabled exception has been raised
1370: -- we must rollback to the savepoint
1371: --

Line 1777: -- and a.effective_start_date <= hr_api.g_date

1773: a.person_type_usage_id
1774: from per_person_type_usages_f a
1775: where a.person_id = p_bnf_person_id
1776: and a.person_type_id = l_person_type_id
1777: -- and a.effective_start_date <= hr_api.g_date
1778: and a.effective_end_date >= l_dsg_strt_dt
1779: ;
1780: --
1781: --

Line 1844: l_effective_end_date >= hr_api.g_date

1840: );
1841: --
1842: else
1843: if l_effective_start_date <= l_dsg_strt_dt and
1844: l_effective_end_date >= hr_api.g_date
1845: then
1846: null;
1847: elsif l_effective_start_date <= l_dsg_strt_dt and
1848: l_effective_end_date < hr_api.g_date

Line 1848: l_effective_end_date < hr_api.g_date

1844: l_effective_end_date >= hr_api.g_date
1845: then
1846: null;
1847: elsif l_effective_start_date <= l_dsg_strt_dt and
1848: l_effective_end_date < hr_api.g_date
1849: then
1850: update per_person_type_usages_f
1851: set effective_end_date = hr_api.g_date
1852: where person_type_usage_id = l_person_type_usage_id;

Line 1851: set effective_end_date = hr_api.g_date

1847: elsif l_effective_start_date <= l_dsg_strt_dt and
1848: l_effective_end_date < hr_api.g_date
1849: then
1850: update per_person_type_usages_f
1851: set effective_end_date = hr_api.g_date
1852: where person_type_usage_id = l_person_type_usage_id;
1853: elsif l_effective_start_date > l_dsg_strt_dt and
1854: l_effective_end_date = hr_api.g_date then
1855: --

Line 1854: l_effective_end_date = hr_api.g_date then

1850: update per_person_type_usages_f
1851: set effective_end_date = hr_api.g_date
1852: where person_type_usage_id = l_person_type_usage_id;
1853: elsif l_effective_start_date > l_dsg_strt_dt and
1854: l_effective_end_date = hr_api.g_date then
1855: --
1856: update per_person_type_usages_f
1857: set effective_start_date = l_dsg_strt_dt
1858: where person_type_usage_id = l_person_type_usage_id;

Line 1861: l_effective_end_date < hr_api.g_date then

1857: set effective_start_date = l_dsg_strt_dt
1858: where person_type_usage_id = l_person_type_usage_id;
1859: --
1860: elsif l_effective_start_date > l_dsg_strt_dt and
1861: l_effective_end_date < hr_api.g_date then
1862: --
1863: update per_person_type_usages_f
1864: set effective_start_date = l_dsg_strt_dt,
1865: effective_end_date = hr_api.g_date

Line 1865: effective_end_date = hr_api.g_date

1861: l_effective_end_date < hr_api.g_date then
1862: --
1863: update per_person_type_usages_f
1864: set effective_start_date = l_dsg_strt_dt,
1865: effective_end_date = hr_api.g_date
1866: where person_type_usage_id = l_person_type_usage_id;
1867: --
1868: end if;
1869: --

Line 1987: if l_datetrack_mode = hr_api.g_delete

1983: --
1984: -- bug 5668052
1985: if p_dsgn_thru_dt is not null
1986: then
1987: if l_datetrack_mode = hr_api.g_delete
1988: and p_dsgn_thru_dt < l_usg_effective_start_date
1989: then
1990: l_datetrack_mode := 'ZAP';
1991: end if;

Line 1993: -- if p_datetrack_mode = 'DELETE' AND l_effective_end_date = hr_api.g_eot

1989: then
1990: l_datetrack_mode := 'ZAP';
1991: end if;
1992: end if;
1993: -- if p_datetrack_mode = 'DELETE' AND l_effective_end_date = hr_api.g_eot
1994: if l_datetrack_mode = 'DELETE' AND l_effective_end_date = hr_api.g_eot
1995: then
1996:
1997:

Line 1994: if l_datetrack_mode = 'DELETE' AND l_effective_end_date = hr_api.g_eot

1990: l_datetrack_mode := 'ZAP';
1991: end if;
1992: end if;
1993: -- if p_datetrack_mode = 'DELETE' AND l_effective_end_date = hr_api.g_eot
1994: if l_datetrack_mode = 'DELETE' AND l_effective_end_date = hr_api.g_eot
1995: then
1996:
1997:
1998: hr_per_type_usage_internal.delete_person_type_usage

Line 2010: elsif l_datetrack_mode = hr_api.g_zap then

2006: ,p_effective_end_date => l_effective_end_date
2007: );
2008: --
2009: -- start bug 5668052
2010: elsif l_datetrack_mode = hr_api.g_zap then
2011: hr_utility.set_location('Checking deletion in zap mode ',121);
2012: open bnf_rec_exists(l_bnf_person_id);
2013: fetch bnf_rec_exists into l_dummy;
2014: if bnf_rec_exists%notfound then