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_ELIGY_PROFILE_API dependencies on HR_API

Line 252: when hr_api.cannot_find_prog_unit then

248: ,p_effective_date => trunc(p_effective_date));
249: --
250: exception
251: --
252: when hr_api.cannot_find_prog_unit then
253: --
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'CREATE_ELIGY_PROFILE'
256: ,p_hook_type => 'BP');

Line 254: hr_api.cannot_find_prog_unit_error

250: exception
251: --
252: when hr_api.cannot_find_prog_unit then
253: --
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'CREATE_ELIGY_PROFILE'
256: ,p_hook_type => 'BP');
257: --
258: -- End of API User Hook for the before hook of create_ELIGY_PROFILE

Line 484: when hr_api.cannot_find_prog_unit then

480: ,p_effective_date => trunc(p_effective_date));
481: --
482: exception
483: --
484: when hr_api.cannot_find_prog_unit then
485: --
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'CREATE_ELIGY_PROFILE'
488: ,p_hook_type => 'AP');

Line 486: hr_api.cannot_find_prog_unit_error

482: exception
483: --
484: when hr_api.cannot_find_prog_unit then
485: --
486: hr_api.cannot_find_prog_unit_error
487: (p_module_name => 'CREATE_ELIGY_PROFILE'
488: ,p_hook_type => 'AP');
489: --
490: -- End of API User Hook for the after hook of create_ELIGY_PROFILE

Line 499: raise hr_api.validate_enabled;

495: --
496: -- When in validation only mode raise the Validate_Enabled exception
497: --
498: if p_validate then
499: raise hr_api.validate_enabled;
500: end if;
501: --
502: -- Set all output arguments
503: --

Line 513: when hr_api.validate_enabled then

509: hr_utility.set_location(' Leaving:'||l_proc, 70);
510: --
511: exception
512: --
513: when hr_api.validate_enabled then
514: --
515: -- As the Validate_Enabled exception has been raised
516: -- we must rollback to the savepoint
517: --

Line 553: ,p_name in varchar2 default hr_api.g_varchar2

549: (p_validate in boolean default false
550: ,p_eligy_prfl_id in number
551: ,p_effective_start_date out nocopy date
552: ,p_effective_end_date out nocopy date
553: ,p_name in varchar2 default hr_api.g_varchar2
554: ,p_description in varchar2 default hr_api.g_varchar2
555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2

Line 554: ,p_description in varchar2 default hr_api.g_varchar2

550: ,p_eligy_prfl_id in number
551: ,p_effective_start_date out nocopy date
552: ,p_effective_end_date out nocopy date
553: ,p_name in varchar2 default hr_api.g_varchar2
554: ,p_description in varchar2 default hr_api.g_varchar2
555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2

Line 555: ,p_stat_cd in varchar2 default hr_api.g_varchar2

551: ,p_effective_start_date out nocopy date
552: ,p_effective_end_date out nocopy date
553: ,p_name in varchar2 default hr_api.g_varchar2
554: ,p_description in varchar2 default hr_api.g_varchar2
555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2

Line 556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2

552: ,p_effective_end_date out nocopy date
553: ,p_name in varchar2 default hr_api.g_varchar2
554: ,p_description in varchar2 default hr_api.g_varchar2
555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2

Line 557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2

553: ,p_name in varchar2 default hr_api.g_varchar2
554: ,p_description in varchar2 default hr_api.g_varchar2
555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2

Line 558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2

554: ,p_description in varchar2 default hr_api.g_varchar2
555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2

Line 559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2

555: ,p_stat_cd in varchar2 default hr_api.g_varchar2
556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2

Line 560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2

556: ,p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2
557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2

Line 561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2

557: ,p_elig_enrld_plip_flag in varchar2 default hr_api.g_varchar2
558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2

Line 562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2

558: ,p_elig_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2
559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2

Line 563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2

559: ,p_elig_enrld_ptip_flag in varchar2 default hr_api.g_varchar2
560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2

Line 564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2

560: ,p_elig_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2
561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2

Line 565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2

561: ,p_elig_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2
562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2

Line 566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2

562: ,p_elig_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2
563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2

Line 567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2

563: ,p_elig_job_flag in varchar2 default hr_api.g_varchar2
564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2

Line 568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2

564: ,p_elig_hrly_slrd_flag in varchar2 default hr_api.g_varchar2
565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2

Line 569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2

565: ,p_elig_pstl_cd_flag in varchar2 default hr_api.g_varchar2
566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2

Line 570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2

566: ,p_elig_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2
567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2

Line 571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2

567: ,p_elig_lgl_enty_flag in varchar2 default hr_api.g_varchar2
568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2

Line 572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2

568: ,p_elig_benfts_grp_flag in varchar2 default hr_api.g_varchar2
569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2

Line 573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2

569: ,p_elig_wk_loc_flag in varchar2 default hr_api.g_varchar2
570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2

Line 574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2

570: ,p_elig_brgng_unit_flag in varchar2 default hr_api.g_varchar2
571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2

Line 575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2

571: ,p_elig_age_flag in varchar2 default hr_api.g_varchar2
572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2

Line 576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2

572: ,p_elig_los_flag in varchar2 default hr_api.g_varchar2
573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2

Line 577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2

573: ,p_elig_per_typ_flag in varchar2 default hr_api.g_varchar2
574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2

Line 578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2

574: ,p_elig_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2
575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2

Line 579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2

575: ,p_elig_ee_stat_flag in varchar2 default hr_api.g_varchar2
576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2

Line 580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2

576: ,p_elig_grd_flag in varchar2 default hr_api.g_varchar2
577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2

Line 581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2

577: ,p_elig_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2
578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2

Line 582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2

578: ,p_elig_asnt_set_flag in varchar2 default hr_api.g_varchar2
579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2

Line 583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2

579: ,p_elig_hrs_wkd_flag in varchar2 default hr_api.g_varchar2
580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2

Line 584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2

580: ,p_elig_comp_lvl_flag in varchar2 default hr_api.g_varchar2
581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2

Line 585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2

581: ,p_elig_org_unit_flag in varchar2 default hr_api.g_varchar2
582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2

Line 586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2

582: ,p_elig_loa_rsn_flag in varchar2 default hr_api.g_varchar2
583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2

Line 587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2

583: ,p_elig_pyrl_flag in varchar2 default hr_api.g_varchar2
584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2

Line 588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2

584: ,p_elig_schedd_hrs_flag in varchar2 default hr_api.g_varchar2
585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2

Line 589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2

585: ,p_elig_py_bss_flag in varchar2 default hr_api.g_varchar2
586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2

Line 590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2

586: ,p_eligy_prfl_rl_flag in varchar2 default hr_api.g_varchar2
587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2

Line 591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2

587: ,p_elig_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2
588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2

Line 592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2

588: ,p_cntng_prtn_elig_prfl_flag in varchar2 default hr_api.g_varchar2
589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2

Line 593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2

589: ,p_elig_prtt_pl_flag in varchar2 default hr_api.g_varchar2
590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2

Line 594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2

590: ,p_elig_ppl_grp_flag in varchar2 default hr_api.g_varchar2
591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2

Line 595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2

591: ,p_elig_svc_area_flag in varchar2 default hr_api.g_varchar2
592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2

Line 596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2

592: ,p_elig_ptip_prte_flag in varchar2 default hr_api.g_varchar2
593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2

Line 597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2

593: ,p_elig_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2
594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2

Line 598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2

594: ,p_elig_enrld_pl_flag in varchar2 default hr_api.g_varchar2
595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number

Line 599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2

595: ,p_elig_enrld_oipl_flag in varchar2 default hr_api.g_varchar2
596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2

Line 600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2

596: ,p_elig_enrld_pgm_flag in varchar2 default hr_api.g_varchar2
597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2

Line 601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2

597: ,p_elig_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2
598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2

Line 602: ,p_business_group_id in number default hr_api.g_number

598: ,p_elig_lvg_rsn_flag in varchar2 default hr_api.g_varchar2
599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2

Line 603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2

599: ,p_elig_optd_mdcr_flag in varchar2 default hr_api.g_varchar2
600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2

Line 604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2

600: ,p_elig_tbco_use_flag in varchar2 default hr_api.g_varchar2
601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2

Line 605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2

601: ,p_elig_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2
602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2

Line 606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2

602: ,p_business_group_id in number default hr_api.g_number
603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2

Line 607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2

603: ,p_elp_attribute_category in varchar2 default hr_api.g_varchar2
604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2

Line 608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2

604: ,p_elp_attribute1 in varchar2 default hr_api.g_varchar2
605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2

Line 609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2

605: ,p_elp_attribute2 in varchar2 default hr_api.g_varchar2
606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2

Line 610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2

606: ,p_elp_attribute3 in varchar2 default hr_api.g_varchar2
607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2

Line 611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2

607: ,p_elp_attribute4 in varchar2 default hr_api.g_varchar2
608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2

Line 612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2

608: ,p_elp_attribute5 in varchar2 default hr_api.g_varchar2
609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2

Line 613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2

609: ,p_elp_attribute6 in varchar2 default hr_api.g_varchar2
610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2

Line 614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2

610: ,p_elp_attribute7 in varchar2 default hr_api.g_varchar2
611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2

Line 615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2

611: ,p_elp_attribute8 in varchar2 default hr_api.g_varchar2
612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2

Line 616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2

612: ,p_elp_attribute9 in varchar2 default hr_api.g_varchar2
613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2

Line 617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2

613: ,p_elp_attribute10 in varchar2 default hr_api.g_varchar2
614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2

Line 618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2

614: ,p_elp_attribute11 in varchar2 default hr_api.g_varchar2
615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2

Line 619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2

615: ,p_elp_attribute12 in varchar2 default hr_api.g_varchar2
616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2

Line 620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2

616: ,p_elp_attribute13 in varchar2 default hr_api.g_varchar2
617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2

Line 621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2

617: ,p_elp_attribute14 in varchar2 default hr_api.g_varchar2
618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2

Line 622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2

618: ,p_elp_attribute15 in varchar2 default hr_api.g_varchar2
619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2

Line 623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2

619: ,p_elp_attribute16 in varchar2 default hr_api.g_varchar2
620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2

Line 624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2

620: ,p_elp_attribute17 in varchar2 default hr_api.g_varchar2
621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2

Line 625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2

621: ,p_elp_attribute18 in varchar2 default hr_api.g_varchar2
622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2

Line 626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2

622: ,p_elp_attribute19 in varchar2 default hr_api.g_varchar2
623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2

Line 627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2

623: ,p_elp_attribute20 in varchar2 default hr_api.g_varchar2
624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2

Line 628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2

624: ,p_elp_attribute21 in varchar2 default hr_api.g_varchar2
625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2

Line 629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2

625: ,p_elp_attribute22 in varchar2 default hr_api.g_varchar2
626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2

Line 630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2

626: ,p_elp_attribute23 in varchar2 default hr_api.g_varchar2
627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2

Line 631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2

627: ,p_elp_attribute24 in varchar2 default hr_api.g_varchar2
628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2

Line 632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2

628: ,p_elp_attribute25 in varchar2 default hr_api.g_varchar2
629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2

Line 633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2

629: ,p_elp_attribute26 in varchar2 default hr_api.g_varchar2
630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2

Line 634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2

630: ,p_elp_attribute27 in varchar2 default hr_api.g_varchar2
631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2

Line 635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2

631: ,p_elp_attribute28 in varchar2 default hr_api.g_varchar2
632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2

Line 636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2

632: ,p_elp_attribute29 in varchar2 default hr_api.g_varchar2
633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2

Line 637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2

633: ,p_elp_attribute30 in varchar2 default hr_api.g_varchar2
634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2

Line 638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2

634: ,p_elig_mrtl_sts_flag in varchar2 default hr_api.g_varchar2
635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2

Line 639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2

635: ,p_elig_gndr_flag in varchar2 default hr_api.g_varchar2
636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2

Line 640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2

636: ,p_elig_dsblty_ctg_flag in varchar2 default hr_api.g_varchar2
637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2

Line 641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2

637: ,p_elig_dsblty_rsn_flag in varchar2 default hr_api.g_varchar2
638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2

Line 642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2

638: ,p_elig_dsblty_dgr_flag in varchar2 default hr_api.g_varchar2
639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2

Line 643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2

639: ,p_elig_suppl_role_flag in varchar2 default hr_api.g_varchar2
640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2

Line 644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2

640: ,p_elig_qual_titl_flag in varchar2 default hr_api.g_varchar2
641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2

Line 645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2

641: ,p_elig_pstn_flag in varchar2 default hr_api.g_varchar2
642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2

Line 646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2

642: ,p_elig_prbtn_perd_flag in varchar2 default hr_api.g_varchar2
643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2

Line 647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2

643: ,p_elig_sp_clng_prg_pt_flag in varchar2 default hr_api.g_varchar2
644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2

Line 648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2

644: ,p_bnft_cagr_prtn_cd in varchar2 default hr_api.g_varchar2
645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2

Line 649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2

645: ,p_elig_dsbld_flag in varchar2 default hr_api.g_varchar2
646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2
653: ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */

Line 650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2

646: ,p_elig_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2
647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2
653: ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */
654: ,p_object_version_number in out nocopy number

Line 651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2

647: ,p_elig_ttl_prtt_flag in varchar2 default hr_api.g_varchar2
648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2
653: ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */
654: ,p_object_version_number in out nocopy number
655: ,p_effective_date in date

Line 652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2

648: ,p_elig_comptncy_flag in varchar2 default hr_api.g_varchar2
649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2
653: ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */
654: ,p_object_version_number in out nocopy number
655: ,p_effective_date in date
656: ,p_datetrack_mode in varchar2) is

Line 653: ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */

649: ,p_elig_hlth_cvg_flag in varchar2 default hr_api.g_varchar2
650: ,p_elig_anthr_pl_flag in varchar2 default hr_api.g_varchar2
651: ,p_elig_qua_in_gr_flag in varchar2 default hr_api.g_varchar2
652: ,p_elig_perf_rtng_flag in varchar2 default hr_api.g_varchar2
653: ,p_elig_crit_values_flag in varchar2 default hr_api.g_varchar2 /* RBC */
654: ,p_object_version_number in out nocopy number
655: ,p_effective_date in date
656: ,p_datetrack_mode in varchar2) is
657: --

Line 792: when hr_api.cannot_find_prog_unit then

788: ,p_datetrack_mode => p_datetrack_mode);
789: --
790: exception
791: --
792: when hr_api.cannot_find_prog_unit then
793: --
794: hr_api.cannot_find_prog_unit_error
795: (p_module_name => 'UPDATE_ELIGY_PROFILE'
796: ,p_hook_type => 'BP');

Line 794: hr_api.cannot_find_prog_unit_error

790: exception
791: --
792: when hr_api.cannot_find_prog_unit then
793: --
794: hr_api.cannot_find_prog_unit_error
795: (p_module_name => 'UPDATE_ELIGY_PROFILE'
796: ,p_hook_type => 'BP');
797: --
798: -- End of API User Hook for the before hook of update_ELIGY_PROFILE

Line 1026: when hr_api.cannot_find_prog_unit then

1022: ,p_datetrack_mode => p_datetrack_mode);
1023: --
1024: exception
1025: --
1026: when hr_api.cannot_find_prog_unit then
1027: --
1028: hr_api.cannot_find_prog_unit_error
1029: (p_module_name => 'UPDATE_ELIGY_PROFILE'
1030: ,p_hook_type => 'AP');

Line 1028: hr_api.cannot_find_prog_unit_error

1024: exception
1025: --
1026: when hr_api.cannot_find_prog_unit then
1027: --
1028: hr_api.cannot_find_prog_unit_error
1029: (p_module_name => 'UPDATE_ELIGY_PROFILE'
1030: ,p_hook_type => 'AP');
1031: --
1032: -- End of API User Hook for the after hook of update_ELIGY_PROFILE

Line 1041: raise hr_api.validate_enabled;

1037: --
1038: -- When in validation only mode raise the Validate_Enabled exception
1039: --
1040: if p_validate then
1041: raise hr_api.validate_enabled;
1042: end if;
1043: --
1044: -- Set all output arguments
1045: --

Line 1054: when hr_api.validate_enabled then

1050: hr_utility.set_location(' Leaving:'||l_proc, 70);
1051: --
1052: exception
1053: --
1054: when hr_api.validate_enabled then
1055: --
1056: -- As the Validate_Enabled exception has been raised
1057: -- we must rollback to the savepoint
1058: --

Line 1586: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1582: -- BEN_ELIG_DSBLD_STAT_PRTE_F
1583: -- BEN_ELIG_MLTRY_STAT_PRTE_F
1584: -- BEN_ELIG_PRTT_ANTHR_PGM_F
1585: for l_row in BEN_ELIGY_PRFL_RL_F loop
1586: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1587: or p_datetrack_mode <> hr_api.g_delete then
1588: if p_datetrack_mode = hr_api.g_zap then
1589: l_effective_date := l_row.eed;
1590: else l_effective_date := p_effective_date;

Line 1587: or p_datetrack_mode <> hr_api.g_delete then

1583: -- BEN_ELIG_MLTRY_STAT_PRTE_F
1584: -- BEN_ELIG_PRTT_ANTHR_PGM_F
1585: for l_row in BEN_ELIGY_PRFL_RL_F loop
1586: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1587: or p_datetrack_mode <> hr_api.g_delete then
1588: if p_datetrack_mode = hr_api.g_zap then
1589: l_effective_date := l_row.eed;
1590: else l_effective_date := p_effective_date;
1591: end if;

Line 1588: if p_datetrack_mode = hr_api.g_zap then

1584: -- BEN_ELIG_PRTT_ANTHR_PGM_F
1585: for l_row in BEN_ELIGY_PRFL_RL_F loop
1586: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1587: or p_datetrack_mode <> hr_api.g_delete then
1588: if p_datetrack_mode = hr_api.g_zap then
1589: l_effective_date := l_row.eed;
1590: else l_effective_date := p_effective_date;
1591: end if;
1592: ben_ELIGY_PROFILE_RULE_api.delete_ELIGY_PROFILE_RULE

Line 1603: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1599: ,p_datetrack_mode => p_datetrack_mode);
1600: end if;
1601: end loop;
1602: for l_row in BEN_ELIG_AGE_PRTE_F loop
1603: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1604: or p_datetrack_mode <> hr_api.g_delete then
1605: if p_datetrack_mode = hr_api.g_zap then
1606: l_effective_date := l_row.eed;
1607: else l_effective_date := p_effective_date;

Line 1604: or p_datetrack_mode <> hr_api.g_delete then

1600: end if;
1601: end loop;
1602: for l_row in BEN_ELIG_AGE_PRTE_F loop
1603: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1604: or p_datetrack_mode <> hr_api.g_delete then
1605: if p_datetrack_mode = hr_api.g_zap then
1606: l_effective_date := l_row.eed;
1607: else l_effective_date := p_effective_date;
1608: end if;

Line 1605: if p_datetrack_mode = hr_api.g_zap then

1601: end loop;
1602: for l_row in BEN_ELIG_AGE_PRTE_F loop
1603: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1604: or p_datetrack_mode <> hr_api.g_delete then
1605: if p_datetrack_mode = hr_api.g_zap then
1606: l_effective_date := l_row.eed;
1607: else l_effective_date := p_effective_date;
1608: end if;
1609: ben_ELIG_AGE_PRTE_api.delete_ELIG_AGE_PRTE

Line 1620: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1616: ,p_datetrack_mode => p_datetrack_mode);
1617: end if;
1618: end loop;
1619: for l_row in BEN_ELIG_ASNT_SET_PRTE_F loop
1620: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1621: or p_datetrack_mode <> hr_api.g_delete then
1622: if p_datetrack_mode = hr_api.g_zap then
1623: l_effective_date := l_row.eed;
1624: else l_effective_date := p_effective_date;

Line 1621: or p_datetrack_mode <> hr_api.g_delete then

1617: end if;
1618: end loop;
1619: for l_row in BEN_ELIG_ASNT_SET_PRTE_F loop
1620: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1621: or p_datetrack_mode <> hr_api.g_delete then
1622: if p_datetrack_mode = hr_api.g_zap then
1623: l_effective_date := l_row.eed;
1624: else l_effective_date := p_effective_date;
1625: end if;

Line 1622: if p_datetrack_mode = hr_api.g_zap then

1618: end loop;
1619: for l_row in BEN_ELIG_ASNT_SET_PRTE_F loop
1620: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1621: or p_datetrack_mode <> hr_api.g_delete then
1622: if p_datetrack_mode = hr_api.g_zap then
1623: l_effective_date := l_row.eed;
1624: else l_effective_date := p_effective_date;
1625: end if;
1626: BEN_ELIG_ASNT_SET_PRTE_api.delete_ELIG_ASNT_SET_PRTE

Line 1637: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1633: ,p_datetrack_mode => p_datetrack_mode);
1634: end if;
1635: end loop;
1636: for l_row in BEN_ELIG_BENFTS_GRP_PRTE_F loop
1637: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1638: or p_datetrack_mode <> hr_api.g_delete then
1639: if p_datetrack_mode = hr_api.g_zap then
1640: l_effective_date := l_row.eed;
1641: else l_effective_date := p_effective_date;

Line 1638: or p_datetrack_mode <> hr_api.g_delete then

1634: end if;
1635: end loop;
1636: for l_row in BEN_ELIG_BENFTS_GRP_PRTE_F loop
1637: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1638: or p_datetrack_mode <> hr_api.g_delete then
1639: if p_datetrack_mode = hr_api.g_zap then
1640: l_effective_date := l_row.eed;
1641: else l_effective_date := p_effective_date;
1642: end if;

Line 1639: if p_datetrack_mode = hr_api.g_zap then

1635: end loop;
1636: for l_row in BEN_ELIG_BENFTS_GRP_PRTE_F loop
1637: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1638: or p_datetrack_mode <> hr_api.g_delete then
1639: if p_datetrack_mode = hr_api.g_zap then
1640: l_effective_date := l_row.eed;
1641: else l_effective_date := p_effective_date;
1642: end if;
1643: BEN_ELIG_BENFTS_GRP_PRTE_api.delete_ELIG_BENFTS_GRP_PRTE

Line 1654: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1650: ,p_datetrack_mode => p_datetrack_mode);
1651: end if;
1652: end loop;
1653: for l_row in BEN_ELIG_BRGNG_UNIT_PRTE_F loop
1654: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1655: or p_datetrack_mode <> hr_api.g_delete then
1656: if p_datetrack_mode = hr_api.g_zap then
1657: l_effective_date := l_row.eed;
1658: else l_effective_date := p_effective_date;

Line 1655: or p_datetrack_mode <> hr_api.g_delete then

1651: end if;
1652: end loop;
1653: for l_row in BEN_ELIG_BRGNG_UNIT_PRTE_F loop
1654: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1655: or p_datetrack_mode <> hr_api.g_delete then
1656: if p_datetrack_mode = hr_api.g_zap then
1657: l_effective_date := l_row.eed;
1658: else l_effective_date := p_effective_date;
1659: end if;

Line 1656: if p_datetrack_mode = hr_api.g_zap then

1652: end loop;
1653: for l_row in BEN_ELIG_BRGNG_UNIT_PRTE_F loop
1654: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1655: or p_datetrack_mode <> hr_api.g_delete then
1656: if p_datetrack_mode = hr_api.g_zap then
1657: l_effective_date := l_row.eed;
1658: else l_effective_date := p_effective_date;
1659: end if;
1660: BEN_ELIG_BRGNG_UNIT_PRTE_api.delete_ELIG_BRGNG_UNIT_PRTE

Line 1671: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1667: ,p_datetrack_mode => p_datetrack_mode);
1668: end if;
1669: end loop;
1670: for l_row in BEN_ELIG_CBR_QUALD_BNF_F loop
1671: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1672: or p_datetrack_mode <> hr_api.g_delete then
1673: if p_datetrack_mode = hr_api.g_zap then
1674: l_effective_date := l_row.eed;
1675: else l_effective_date := p_effective_date;

Line 1672: or p_datetrack_mode <> hr_api.g_delete then

1668: end if;
1669: end loop;
1670: for l_row in BEN_ELIG_CBR_QUALD_BNF_F loop
1671: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1672: or p_datetrack_mode <> hr_api.g_delete then
1673: if p_datetrack_mode = hr_api.g_zap then
1674: l_effective_date := l_row.eed;
1675: else l_effective_date := p_effective_date;
1676: end if;

Line 1673: if p_datetrack_mode = hr_api.g_zap then

1669: end loop;
1670: for l_row in BEN_ELIG_CBR_QUALD_BNF_F loop
1671: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1672: or p_datetrack_mode <> hr_api.g_delete then
1673: if p_datetrack_mode = hr_api.g_zap then
1674: l_effective_date := l_row.eed;
1675: else l_effective_date := p_effective_date;
1676: end if;
1677: BEN_ELIG_CBR_QUALD_BNF_api.delete_ELIG_CBR_QUALD_BNF

Line 1688: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1684: ,p_datetrack_mode => p_datetrack_mode);
1685: end if;
1686: end loop;
1687: for l_row in BEN_ELIG_CMBN_AGE_LOS_PRTE_F loop
1688: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1689: or p_datetrack_mode <> hr_api.g_delete then
1690: if p_datetrack_mode = hr_api.g_zap then
1691: l_effective_date := l_row.eed;
1692: else l_effective_date := p_effective_date;

Line 1689: or p_datetrack_mode <> hr_api.g_delete then

1685: end if;
1686: end loop;
1687: for l_row in BEN_ELIG_CMBN_AGE_LOS_PRTE_F loop
1688: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1689: or p_datetrack_mode <> hr_api.g_delete then
1690: if p_datetrack_mode = hr_api.g_zap then
1691: l_effective_date := l_row.eed;
1692: else l_effective_date := p_effective_date;
1693: end if;

Line 1690: if p_datetrack_mode = hr_api.g_zap then

1686: end loop;
1687: for l_row in BEN_ELIG_CMBN_AGE_LOS_PRTE_F loop
1688: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1689: or p_datetrack_mode <> hr_api.g_delete then
1690: if p_datetrack_mode = hr_api.g_zap then
1691: l_effective_date := l_row.eed;
1692: else l_effective_date := p_effective_date;
1693: end if;
1694: ben_ELIG_CMBN_AGE_LOS_api.delete_ELIG_CMBN_AGE_LOS

Line 1705: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1701: ,p_datetrack_mode => p_datetrack_mode);
1702: end if;
1703: end loop;
1704: for l_row in BEN_ELIG_COMP_LVL_PRTE_F loop
1705: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1706: or p_datetrack_mode <> hr_api.g_delete then
1707: if p_datetrack_mode = hr_api.g_zap then
1708: l_effective_date := l_row.eed;
1709: else l_effective_date := p_effective_date;

Line 1706: or p_datetrack_mode <> hr_api.g_delete then

1702: end if;
1703: end loop;
1704: for l_row in BEN_ELIG_COMP_LVL_PRTE_F loop
1705: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1706: or p_datetrack_mode <> hr_api.g_delete then
1707: if p_datetrack_mode = hr_api.g_zap then
1708: l_effective_date := l_row.eed;
1709: else l_effective_date := p_effective_date;
1710: end if;

Line 1707: if p_datetrack_mode = hr_api.g_zap then

1703: end loop;
1704: for l_row in BEN_ELIG_COMP_LVL_PRTE_F loop
1705: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1706: or p_datetrack_mode <> hr_api.g_delete then
1707: if p_datetrack_mode = hr_api.g_zap then
1708: l_effective_date := l_row.eed;
1709: else l_effective_date := p_effective_date;
1710: end if;
1711: BEN_ELIG_COMP_LVL_PRTE_api.delete_ELIG_COMP_LVL_PRTE

Line 1722: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1718: ,p_datetrack_mode => p_datetrack_mode);
1719: end if;
1720: end loop;
1721: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PGM_F loop
1722: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1723: or p_datetrack_mode <> hr_api.g_delete then
1724: if p_datetrack_mode = hr_api.g_zap then
1725: l_effective_date := l_row.eed;
1726: else l_effective_date := p_effective_date;

Line 1723: or p_datetrack_mode <> hr_api.g_delete then

1719: end if;
1720: end loop;
1721: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PGM_F loop
1722: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1723: or p_datetrack_mode <> hr_api.g_delete then
1724: if p_datetrack_mode = hr_api.g_zap then
1725: l_effective_date := l_row.eed;
1726: else l_effective_date := p_effective_date;
1727: end if;

Line 1724: if p_datetrack_mode = hr_api.g_zap then

1720: end loop;
1721: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PGM_F loop
1722: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1723: or p_datetrack_mode <> hr_api.g_delete then
1724: if p_datetrack_mode = hr_api.g_zap then
1725: l_effective_date := l_row.eed;
1726: else l_effective_date := p_effective_date;
1727: end if;
1728: ben_ELIG_DPNT_CVRD_O_PGM_api.delete_ELIG_DPNT_CVRD_O_PGM

Line 1739: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1735: ,p_datetrack_mode => p_datetrack_mode);
1736: end if;
1737: end loop;
1738: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PL_F loop
1739: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1740: or p_datetrack_mode <> hr_api.g_delete then
1741: if p_datetrack_mode = hr_api.g_zap then
1742: l_effective_date := l_row.eed;
1743: else l_effective_date := p_effective_date;

Line 1740: or p_datetrack_mode <> hr_api.g_delete then

1736: end if;
1737: end loop;
1738: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PL_F loop
1739: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1740: or p_datetrack_mode <> hr_api.g_delete then
1741: if p_datetrack_mode = hr_api.g_zap then
1742: l_effective_date := l_row.eed;
1743: else l_effective_date := p_effective_date;
1744: end if;

Line 1741: if p_datetrack_mode = hr_api.g_zap then

1737: end loop;
1738: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PL_F loop
1739: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1740: or p_datetrack_mode <> hr_api.g_delete then
1741: if p_datetrack_mode = hr_api.g_zap then
1742: l_effective_date := l_row.eed;
1743: else l_effective_date := p_effective_date;
1744: end if;
1745: ben_ELIG_DPNT_CVD_OTHR_PL_api.delete_ELIG_DPNT_CVD_OTHR_PL

Line 1756: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1752: ,p_datetrack_mode => p_datetrack_mode);
1753: end if;
1754: end loop;
1755: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F loop
1756: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1757: or p_datetrack_mode <> hr_api.g_delete then
1758: if p_datetrack_mode = hr_api.g_zap then
1759: l_effective_date := l_row.eed;
1760: else l_effective_date := p_effective_date;

Line 1757: or p_datetrack_mode <> hr_api.g_delete then

1753: end if;
1754: end loop;
1755: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F loop
1756: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1757: or p_datetrack_mode <> hr_api.g_delete then
1758: if p_datetrack_mode = hr_api.g_zap then
1759: l_effective_date := l_row.eed;
1760: else l_effective_date := p_effective_date;
1761: end if;

Line 1758: if p_datetrack_mode = hr_api.g_zap then

1754: end loop;
1755: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F loop
1756: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1757: or p_datetrack_mode <> hr_api.g_delete then
1758: if p_datetrack_mode = hr_api.g_zap then
1759: l_effective_date := l_row.eed;
1760: else l_effective_date := p_effective_date;
1761: end if;
1762: ben_ELIG_DPNT_CVRD_O_PTIP_api.delete_ELIG_DPNT_CVRD_O_PTIP

Line 1773: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1769: ,p_datetrack_mode => p_datetrack_mode);
1770: end if;
1771: end loop;
1772: for l_row in BEN_ELIG_DPNT_CVRD_PLIP_F loop
1773: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1774: or p_datetrack_mode <> hr_api.g_delete then
1775: if p_datetrack_mode = hr_api.g_zap then
1776: l_effective_date := l_row.eed;
1777: else l_effective_date := p_effective_date;

Line 1774: or p_datetrack_mode <> hr_api.g_delete then

1770: end if;
1771: end loop;
1772: for l_row in BEN_ELIG_DPNT_CVRD_PLIP_F loop
1773: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1774: or p_datetrack_mode <> hr_api.g_delete then
1775: if p_datetrack_mode = hr_api.g_zap then
1776: l_effective_date := l_row.eed;
1777: else l_effective_date := p_effective_date;
1778: end if;

Line 1775: if p_datetrack_mode = hr_api.g_zap then

1771: end loop;
1772: for l_row in BEN_ELIG_DPNT_CVRD_PLIP_F loop
1773: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1774: or p_datetrack_mode <> hr_api.g_delete then
1775: if p_datetrack_mode = hr_api.g_zap then
1776: l_effective_date := l_row.eed;
1777: else l_effective_date := p_effective_date;
1778: end if;
1779: ben_ELIG_DPNT_CVRD_PLIP_api.delete_ELIG_DPNT_CVRD_PLIP

Line 1790: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1786: ,p_datetrack_mode => p_datetrack_mode);
1787: end if;
1788: end loop;
1789: for l_row in BEN_ELIG_EE_STAT_PRTE_F loop
1790: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1791: or p_datetrack_mode <> hr_api.g_delete then
1792: if p_datetrack_mode = hr_api.g_zap then
1793: l_effective_date := l_row.eed;
1794: else l_effective_date := p_effective_date;

Line 1791: or p_datetrack_mode <> hr_api.g_delete then

1787: end if;
1788: end loop;
1789: for l_row in BEN_ELIG_EE_STAT_PRTE_F loop
1790: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1791: or p_datetrack_mode <> hr_api.g_delete then
1792: if p_datetrack_mode = hr_api.g_zap then
1793: l_effective_date := l_row.eed;
1794: else l_effective_date := p_effective_date;
1795: end if;

Line 1792: if p_datetrack_mode = hr_api.g_zap then

1788: end loop;
1789: for l_row in BEN_ELIG_EE_STAT_PRTE_F loop
1790: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1791: or p_datetrack_mode <> hr_api.g_delete then
1792: if p_datetrack_mode = hr_api.g_zap then
1793: l_effective_date := l_row.eed;
1794: else l_effective_date := p_effective_date;
1795: end if;
1796: BEN_ELIG_EE_STAT_PRTE_api.delete_ELIG_EE_STAT_PRTE

Line 1807: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1803: ,p_datetrack_mode => p_datetrack_mode);
1804: end if;
1805: end loop;
1806: for l_row in BEN_ELIG_ENRLD_ANTHR_OIPL_F loop
1807: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1808: or p_datetrack_mode <> hr_api.g_delete then
1809: if p_datetrack_mode = hr_api.g_zap then
1810: l_effective_date := l_row.eed;
1811: else l_effective_date := p_effective_date;

Line 1808: or p_datetrack_mode <> hr_api.g_delete then

1804: end if;
1805: end loop;
1806: for l_row in BEN_ELIG_ENRLD_ANTHR_OIPL_F loop
1807: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1808: or p_datetrack_mode <> hr_api.g_delete then
1809: if p_datetrack_mode = hr_api.g_zap then
1810: l_effective_date := l_row.eed;
1811: else l_effective_date := p_effective_date;
1812: end if;

Line 1809: if p_datetrack_mode = hr_api.g_zap then

1805: end loop;
1806: for l_row in BEN_ELIG_ENRLD_ANTHR_OIPL_F loop
1807: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1808: or p_datetrack_mode <> hr_api.g_delete then
1809: if p_datetrack_mode = hr_api.g_zap then
1810: l_effective_date := l_row.eed;
1811: else l_effective_date := p_effective_date;
1812: end if;
1813: BEN_ELIG_ENRLD_ANTHR_OIPL_api.delete_ELIG_ENRLD_ANTHR_OIPL

Line 1824: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1820: ,p_datetrack_mode => p_datetrack_mode);
1821: end if;
1822: end loop;
1823: for l_row in BEN_ELIG_ENRLD_ANTHR_PGM_F loop
1824: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1825: or p_datetrack_mode <> hr_api.g_delete then
1826: if p_datetrack_mode = hr_api.g_zap then
1827: l_effective_date := l_row.eed;
1828: else l_effective_date := p_effective_date;

Line 1825: or p_datetrack_mode <> hr_api.g_delete then

1821: end if;
1822: end loop;
1823: for l_row in BEN_ELIG_ENRLD_ANTHR_PGM_F loop
1824: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1825: or p_datetrack_mode <> hr_api.g_delete then
1826: if p_datetrack_mode = hr_api.g_zap then
1827: l_effective_date := l_row.eed;
1828: else l_effective_date := p_effective_date;
1829: end if;

Line 1826: if p_datetrack_mode = hr_api.g_zap then

1822: end loop;
1823: for l_row in BEN_ELIG_ENRLD_ANTHR_PGM_F loop
1824: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1825: or p_datetrack_mode <> hr_api.g_delete then
1826: if p_datetrack_mode = hr_api.g_zap then
1827: l_effective_date := l_row.eed;
1828: else l_effective_date := p_effective_date;
1829: end if;
1830: BEN_ELIG_ENRLD_ANTHR_PGM_api.delete_ELIG_ENRLD_ANTHR_PGM

Line 1841: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1837: ,p_datetrack_mode => p_datetrack_mode);
1838: end if;
1839: end loop;
1840: for l_row in BEN_ELIG_ENRLD_ANTHR_PLIP_F loop
1841: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1842: or p_datetrack_mode <> hr_api.g_delete then
1843: if p_datetrack_mode = hr_api.g_zap then
1844: l_effective_date := l_row.eed;
1845: else l_effective_date := p_effective_date;

Line 1842: or p_datetrack_mode <> hr_api.g_delete then

1838: end if;
1839: end loop;
1840: for l_row in BEN_ELIG_ENRLD_ANTHR_PLIP_F loop
1841: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1842: or p_datetrack_mode <> hr_api.g_delete then
1843: if p_datetrack_mode = hr_api.g_zap then
1844: l_effective_date := l_row.eed;
1845: else l_effective_date := p_effective_date;
1846: end if;

Line 1843: if p_datetrack_mode = hr_api.g_zap then

1839: end loop;
1840: for l_row in BEN_ELIG_ENRLD_ANTHR_PLIP_F loop
1841: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1842: or p_datetrack_mode <> hr_api.g_delete then
1843: if p_datetrack_mode = hr_api.g_zap then
1844: l_effective_date := l_row.eed;
1845: else l_effective_date := p_effective_date;
1846: end if;
1847: BEN_ELIG_ENRLD_ANTHR_PLIP_api.delete_ELIG_ENRLD_ANTHR_PLIP

Line 1858: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1854: ,p_datetrack_mode => p_datetrack_mode);
1855: end if;
1856: end loop;
1857: for l_row in BEN_ELIG_ENRLD_ANTHR_PL_F loop
1858: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1859: or p_datetrack_mode <> hr_api.g_delete then
1860: if p_datetrack_mode = hr_api.g_zap then
1861: l_effective_date := l_row.eed;
1862: else l_effective_date := p_effective_date;

Line 1859: or p_datetrack_mode <> hr_api.g_delete then

1855: end if;
1856: end loop;
1857: for l_row in BEN_ELIG_ENRLD_ANTHR_PL_F loop
1858: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1859: or p_datetrack_mode <> hr_api.g_delete then
1860: if p_datetrack_mode = hr_api.g_zap then
1861: l_effective_date := l_row.eed;
1862: else l_effective_date := p_effective_date;
1863: end if;

Line 1860: if p_datetrack_mode = hr_api.g_zap then

1856: end loop;
1857: for l_row in BEN_ELIG_ENRLD_ANTHR_PL_F loop
1858: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1859: or p_datetrack_mode <> hr_api.g_delete then
1860: if p_datetrack_mode = hr_api.g_zap then
1861: l_effective_date := l_row.eed;
1862: else l_effective_date := p_effective_date;
1863: end if;
1864: BEN_ELIG_ENRLD_ANTHR_PL_api.delete_ELIG_ENRLD_ANTHR_PL

Line 1875: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1871: ,p_datetrack_mode => p_datetrack_mode);
1872: end if;
1873: end loop;
1874: for l_row in BEN_ELIG_ENRLD_ANTHR_PTIP_F loop
1875: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1876: or p_datetrack_mode <> hr_api.g_delete then
1877: if p_datetrack_mode = hr_api.g_zap then
1878: l_effective_date := l_row.eed;
1879: else l_effective_date := p_effective_date;

Line 1876: or p_datetrack_mode <> hr_api.g_delete then

1872: end if;
1873: end loop;
1874: for l_row in BEN_ELIG_ENRLD_ANTHR_PTIP_F loop
1875: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1876: or p_datetrack_mode <> hr_api.g_delete then
1877: if p_datetrack_mode = hr_api.g_zap then
1878: l_effective_date := l_row.eed;
1879: else l_effective_date := p_effective_date;
1880: end if;

Line 1877: if p_datetrack_mode = hr_api.g_zap then

1873: end loop;
1874: for l_row in BEN_ELIG_ENRLD_ANTHR_PTIP_F loop
1875: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1876: or p_datetrack_mode <> hr_api.g_delete then
1877: if p_datetrack_mode = hr_api.g_zap then
1878: l_effective_date := l_row.eed;
1879: else l_effective_date := p_effective_date;
1880: end if;
1881: BEN_ELIG_ENRLD_ANTHR_PTIP_api.delete_ELIG_ENRLD_ANTHR_PTIP

Line 1892: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1888: ,p_datetrack_mode => p_datetrack_mode);
1889: end if;
1890: end loop;
1891: for l_row in BEN_ELIG_FL_TM_PT_TM_PRTE_F loop
1892: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1893: or p_datetrack_mode <> hr_api.g_delete then
1894: if p_datetrack_mode = hr_api.g_zap then
1895: l_effective_date := l_row.eed;
1896: else l_effective_date := p_effective_date;

Line 1893: or p_datetrack_mode <> hr_api.g_delete then

1889: end if;
1890: end loop;
1891: for l_row in BEN_ELIG_FL_TM_PT_TM_PRTE_F loop
1892: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1893: or p_datetrack_mode <> hr_api.g_delete then
1894: if p_datetrack_mode = hr_api.g_zap then
1895: l_effective_date := l_row.eed;
1896: else l_effective_date := p_effective_date;
1897: end if;

Line 1894: if p_datetrack_mode = hr_api.g_zap then

1890: end loop;
1891: for l_row in BEN_ELIG_FL_TM_PT_TM_PRTE_F loop
1892: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1893: or p_datetrack_mode <> hr_api.g_delete then
1894: if p_datetrack_mode = hr_api.g_zap then
1895: l_effective_date := l_row.eed;
1896: else l_effective_date := p_effective_date;
1897: end if;
1898: BEN_ELIG_FL_TM_PT_TM_PRTE_api.delete_ELIG_FL_TM_PT_TM_PRTE

Line 1909: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1905: ,p_datetrack_mode => p_datetrack_mode);
1906: end if;
1907: end loop;
1908: for l_row in BEN_ELIG_GRD_PRTE_F loop
1909: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1910: or p_datetrack_mode <> hr_api.g_delete then
1911: if p_datetrack_mode = hr_api.g_zap then
1912: l_effective_date := l_row.eed;
1913: else l_effective_date := p_effective_date;

Line 1910: or p_datetrack_mode <> hr_api.g_delete then

1906: end if;
1907: end loop;
1908: for l_row in BEN_ELIG_GRD_PRTE_F loop
1909: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1910: or p_datetrack_mode <> hr_api.g_delete then
1911: if p_datetrack_mode = hr_api.g_zap then
1912: l_effective_date := l_row.eed;
1913: else l_effective_date := p_effective_date;
1914: end if;

Line 1911: if p_datetrack_mode = hr_api.g_zap then

1907: end loop;
1908: for l_row in BEN_ELIG_GRD_PRTE_F loop
1909: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1910: or p_datetrack_mode <> hr_api.g_delete then
1911: if p_datetrack_mode = hr_api.g_zap then
1912: l_effective_date := l_row.eed;
1913: else l_effective_date := p_effective_date;
1914: end if;
1915: BEN_ELIG_GRD_PRTE_api.delete_ELIG_GRD_PRTE

Line 1926: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1922: ,p_datetrack_mode => p_datetrack_mode);
1923: end if;
1924: end loop;
1925: for l_row in BEN_ELIG_HRLY_SLRD_PRTE_F loop
1926: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1927: or p_datetrack_mode <> hr_api.g_delete then
1928: if p_datetrack_mode = hr_api.g_zap then
1929: l_effective_date := l_row.eed;
1930: else l_effective_date := p_effective_date;

Line 1927: or p_datetrack_mode <> hr_api.g_delete then

1923: end if;
1924: end loop;
1925: for l_row in BEN_ELIG_HRLY_SLRD_PRTE_F loop
1926: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1927: or p_datetrack_mode <> hr_api.g_delete then
1928: if p_datetrack_mode = hr_api.g_zap then
1929: l_effective_date := l_row.eed;
1930: else l_effective_date := p_effective_date;
1931: end if;

Line 1928: if p_datetrack_mode = hr_api.g_zap then

1924: end loop;
1925: for l_row in BEN_ELIG_HRLY_SLRD_PRTE_F loop
1926: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1927: or p_datetrack_mode <> hr_api.g_delete then
1928: if p_datetrack_mode = hr_api.g_zap then
1929: l_effective_date := l_row.eed;
1930: else l_effective_date := p_effective_date;
1931: end if;
1932: BEN_ELIG_HRLY_SLRD_PRTE_api.delete_ELIG_HRLY_SLRD_PRTE

Line 1943: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1939: ,p_datetrack_mode => p_datetrack_mode);
1940: end if;
1941: end loop;
1942: for l_row in BEN_ELIG_HRS_WKD_PRTE_F loop
1943: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1944: or p_datetrack_mode <> hr_api.g_delete then
1945: if p_datetrack_mode = hr_api.g_zap then
1946: l_effective_date := l_row.eed;
1947: else l_effective_date := p_effective_date;

Line 1944: or p_datetrack_mode <> hr_api.g_delete then

1940: end if;
1941: end loop;
1942: for l_row in BEN_ELIG_HRS_WKD_PRTE_F loop
1943: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1944: or p_datetrack_mode <> hr_api.g_delete then
1945: if p_datetrack_mode = hr_api.g_zap then
1946: l_effective_date := l_row.eed;
1947: else l_effective_date := p_effective_date;
1948: end if;

Line 1945: if p_datetrack_mode = hr_api.g_zap then

1941: end loop;
1942: for l_row in BEN_ELIG_HRS_WKD_PRTE_F loop
1943: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1944: or p_datetrack_mode <> hr_api.g_delete then
1945: if p_datetrack_mode = hr_api.g_zap then
1946: l_effective_date := l_row.eed;
1947: else l_effective_date := p_effective_date;
1948: end if;
1949: BEN_ELIG_HRS_WKD_PRTE_api.delete_ELIG_HRS_WKD_PRTE

Line 1960: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1956: ,p_datetrack_mode => p_datetrack_mode);
1957: end if;
1958: end loop;
1959: for l_row in BEN_ELIG_JOB_PRTE_F loop
1960: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1961: or p_datetrack_mode <> hr_api.g_delete then
1962: if p_datetrack_mode = hr_api.g_zap then
1963: l_effective_date := l_row.eed;
1964: else l_effective_date := p_effective_date;

Line 1961: or p_datetrack_mode <> hr_api.g_delete then

1957: end if;
1958: end loop;
1959: for l_row in BEN_ELIG_JOB_PRTE_F loop
1960: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1961: or p_datetrack_mode <> hr_api.g_delete then
1962: if p_datetrack_mode = hr_api.g_zap then
1963: l_effective_date := l_row.eed;
1964: else l_effective_date := p_effective_date;
1965: end if;

Line 1962: if p_datetrack_mode = hr_api.g_zap then

1958: end loop;
1959: for l_row in BEN_ELIG_JOB_PRTE_F loop
1960: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1961: or p_datetrack_mode <> hr_api.g_delete then
1962: if p_datetrack_mode = hr_api.g_zap then
1963: l_effective_date := l_row.eed;
1964: else l_effective_date := p_effective_date;
1965: end if;
1966: ben_ELIGY_JOB_PRTE_api.delete_ELIGY_JOB_PRTE

Line 1977: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1973: ,p_datetrack_mode => p_datetrack_mode);
1974: end if;
1975: end loop;
1976: for l_row in BEN_ELIG_LBR_MMBR_PRTE_F loop
1977: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1978: or p_datetrack_mode <> hr_api.g_delete then
1979: if p_datetrack_mode = hr_api.g_zap then
1980: l_effective_date := l_row.eed;
1981: else l_effective_date := p_effective_date;

Line 1978: or p_datetrack_mode <> hr_api.g_delete then

1974: end if;
1975: end loop;
1976: for l_row in BEN_ELIG_LBR_MMBR_PRTE_F loop
1977: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1978: or p_datetrack_mode <> hr_api.g_delete then
1979: if p_datetrack_mode = hr_api.g_zap then
1980: l_effective_date := l_row.eed;
1981: else l_effective_date := p_effective_date;
1982: end if;

Line 1979: if p_datetrack_mode = hr_api.g_zap then

1975: end loop;
1976: for l_row in BEN_ELIG_LBR_MMBR_PRTE_F loop
1977: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1978: or p_datetrack_mode <> hr_api.g_delete then
1979: if p_datetrack_mode = hr_api.g_zap then
1980: l_effective_date := l_row.eed;
1981: else l_effective_date := p_effective_date;
1982: end if;
1983: BEN_ELIG_LBR_MMBR_PRTE_api.delete_ELIG_LBR_MMBR_PRTE

Line 1994: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

1990: ,p_datetrack_mode => p_datetrack_mode);
1991: end if;
1992: end loop;
1993: for l_row in BEN_ELIG_LGL_ENTY_PRTE_F loop
1994: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1995: or p_datetrack_mode <> hr_api.g_delete then
1996: if p_datetrack_mode = hr_api.g_zap then
1997: l_effective_date := l_row.eed;
1998: else l_effective_date := p_effective_date;

Line 1995: or p_datetrack_mode <> hr_api.g_delete then

1991: end if;
1992: end loop;
1993: for l_row in BEN_ELIG_LGL_ENTY_PRTE_F loop
1994: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1995: or p_datetrack_mode <> hr_api.g_delete then
1996: if p_datetrack_mode = hr_api.g_zap then
1997: l_effective_date := l_row.eed;
1998: else l_effective_date := p_effective_date;
1999: end if;

Line 1996: if p_datetrack_mode = hr_api.g_zap then

1992: end loop;
1993: for l_row in BEN_ELIG_LGL_ENTY_PRTE_F loop
1994: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1995: or p_datetrack_mode <> hr_api.g_delete then
1996: if p_datetrack_mode = hr_api.g_zap then
1997: l_effective_date := l_row.eed;
1998: else l_effective_date := p_effective_date;
1999: end if;
2000: BEN_ELIG_LGL_ENTY_PRTE_api.delete_ELIG_LGL_ENTY_PRTE

Line 2011: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2007: ,p_datetrack_mode => p_datetrack_mode);
2008: end if;
2009: end loop;
2010: for l_row in BEN_ELIG_LOA_RSN_PRTE_F loop
2011: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2012: or p_datetrack_mode <> hr_api.g_delete then
2013: if p_datetrack_mode = hr_api.g_zap then
2014: l_effective_date := l_row.eed;
2015: else l_effective_date := p_effective_date;

Line 2012: or p_datetrack_mode <> hr_api.g_delete then

2008: end if;
2009: end loop;
2010: for l_row in BEN_ELIG_LOA_RSN_PRTE_F loop
2011: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2012: or p_datetrack_mode <> hr_api.g_delete then
2013: if p_datetrack_mode = hr_api.g_zap then
2014: l_effective_date := l_row.eed;
2015: else l_effective_date := p_effective_date;
2016: end if;

Line 2013: if p_datetrack_mode = hr_api.g_zap then

2009: end loop;
2010: for l_row in BEN_ELIG_LOA_RSN_PRTE_F loop
2011: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2012: or p_datetrack_mode <> hr_api.g_delete then
2013: if p_datetrack_mode = hr_api.g_zap then
2014: l_effective_date := l_row.eed;
2015: else l_effective_date := p_effective_date;
2016: end if;
2017: BEN_ELIG_LOA_RSN_PRTE_api.delete_ELIG_LOA_RSN_PRTE

Line 2028: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2024: ,p_datetrack_mode => p_datetrack_mode);
2025: end if;
2026: end loop;
2027: for l_row in BEN_ELIG_LOS_PRTE_F loop
2028: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2029: or p_datetrack_mode <> hr_api.g_delete then
2030: if p_datetrack_mode = hr_api.g_zap then
2031: l_effective_date := l_row.eed;
2032: else l_effective_date := p_effective_date;

Line 2029: or p_datetrack_mode <> hr_api.g_delete then

2025: end if;
2026: end loop;
2027: for l_row in BEN_ELIG_LOS_PRTE_F loop
2028: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2029: or p_datetrack_mode <> hr_api.g_delete then
2030: if p_datetrack_mode = hr_api.g_zap then
2031: l_effective_date := l_row.eed;
2032: else l_effective_date := p_effective_date;
2033: end if;

Line 2030: if p_datetrack_mode = hr_api.g_zap then

2026: end loop;
2027: for l_row in BEN_ELIG_LOS_PRTE_F loop
2028: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2029: or p_datetrack_mode <> hr_api.g_delete then
2030: if p_datetrack_mode = hr_api.g_zap then
2031: l_effective_date := l_row.eed;
2032: else l_effective_date := p_effective_date;
2033: end if;
2034: BEN_ELIG_LOS_PRTE_api.delete_ELIG_LOS_PRTE

Line 2045: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2041: ,p_datetrack_mode => p_datetrack_mode);
2042: end if;
2043: end loop;
2044: for l_row in BEN_ELIG_LVG_RSN_PRTE_F loop
2045: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2046: or p_datetrack_mode <> hr_api.g_delete then
2047: if p_datetrack_mode = hr_api.g_zap then
2048: l_effective_date := l_row.eed;
2049: else l_effective_date := p_effective_date;

Line 2046: or p_datetrack_mode <> hr_api.g_delete then

2042: end if;
2043: end loop;
2044: for l_row in BEN_ELIG_LVG_RSN_PRTE_F loop
2045: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2046: or p_datetrack_mode <> hr_api.g_delete then
2047: if p_datetrack_mode = hr_api.g_zap then
2048: l_effective_date := l_row.eed;
2049: else l_effective_date := p_effective_date;
2050: end if;

Line 2047: if p_datetrack_mode = hr_api.g_zap then

2043: end loop;
2044: for l_row in BEN_ELIG_LVG_RSN_PRTE_F loop
2045: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2046: or p_datetrack_mode <> hr_api.g_delete then
2047: if p_datetrack_mode = hr_api.g_zap then
2048: l_effective_date := l_row.eed;
2049: else l_effective_date := p_effective_date;
2050: end if;
2051: BEN_ELIG_LVG_RSN_PRTE_api.delete_ELIG_LVG_RSN_PRTE

Line 2062: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2058: ,p_datetrack_mode => p_datetrack_mode);
2059: end if;
2060: end loop;
2061: for l_row in BEN_ELIG_NO_OTHR_CVG_PRTE_F loop
2062: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2063: or p_datetrack_mode <> hr_api.g_delete then
2064: if p_datetrack_mode = hr_api.g_zap then
2065: l_effective_date := l_row.eed;
2066: else l_effective_date := p_effective_date;

Line 2063: or p_datetrack_mode <> hr_api.g_delete then

2059: end if;
2060: end loop;
2061: for l_row in BEN_ELIG_NO_OTHR_CVG_PRTE_F loop
2062: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2063: or p_datetrack_mode <> hr_api.g_delete then
2064: if p_datetrack_mode = hr_api.g_zap then
2065: l_effective_date := l_row.eed;
2066: else l_effective_date := p_effective_date;
2067: end if;

Line 2064: if p_datetrack_mode = hr_api.g_zap then

2060: end loop;
2061: for l_row in BEN_ELIG_NO_OTHR_CVG_PRTE_F loop
2062: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2063: or p_datetrack_mode <> hr_api.g_delete then
2064: if p_datetrack_mode = hr_api.g_zap then
2065: l_effective_date := l_row.eed;
2066: else l_effective_date := p_effective_date;
2067: end if;
2068: BEN_ELIG_NO_OTHR_CVG_PRTE_api.delete_ELIG_NO_OTHR_CVG_PRTE

Line 2079: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2075: ,p_datetrack_mode => p_datetrack_mode);
2076: end if;
2077: end loop;
2078: for l_row in BEN_ELIG_OPTD_MDCR_PRTE_F loop
2079: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2080: or p_datetrack_mode <> hr_api.g_delete then
2081: if p_datetrack_mode = hr_api.g_zap then
2082: l_effective_date := l_row.eed;
2083: else l_effective_date := p_effective_date;

Line 2080: or p_datetrack_mode <> hr_api.g_delete then

2076: end if;
2077: end loop;
2078: for l_row in BEN_ELIG_OPTD_MDCR_PRTE_F loop
2079: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2080: or p_datetrack_mode <> hr_api.g_delete then
2081: if p_datetrack_mode = hr_api.g_zap then
2082: l_effective_date := l_row.eed;
2083: else l_effective_date := p_effective_date;
2084: end if;

Line 2081: if p_datetrack_mode = hr_api.g_zap then

2077: end loop;
2078: for l_row in BEN_ELIG_OPTD_MDCR_PRTE_F loop
2079: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2080: or p_datetrack_mode <> hr_api.g_delete then
2081: if p_datetrack_mode = hr_api.g_zap then
2082: l_effective_date := l_row.eed;
2083: else l_effective_date := p_effective_date;
2084: end if;
2085: BEN_ELIG_OPTD_MDCR_PRTE_api.delete_ELIG_OPTD_MDCR_PRTE

Line 2096: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2092: ,p_datetrack_mode => p_datetrack_mode);
2093: end if;
2094: end loop;
2095: for l_row in BEN_ELIG_ORG_UNIT_PRTE_F loop
2096: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2097: or p_datetrack_mode <> hr_api.g_delete then
2098: if p_datetrack_mode = hr_api.g_zap then
2099: l_effective_date := l_row.eed;
2100: else l_effective_date := p_effective_date;

Line 2097: or p_datetrack_mode <> hr_api.g_delete then

2093: end if;
2094: end loop;
2095: for l_row in BEN_ELIG_ORG_UNIT_PRTE_F loop
2096: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2097: or p_datetrack_mode <> hr_api.g_delete then
2098: if p_datetrack_mode = hr_api.g_zap then
2099: l_effective_date := l_row.eed;
2100: else l_effective_date := p_effective_date;
2101: end if;

Line 2098: if p_datetrack_mode = hr_api.g_zap then

2094: end loop;
2095: for l_row in BEN_ELIG_ORG_UNIT_PRTE_F loop
2096: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2097: or p_datetrack_mode <> hr_api.g_delete then
2098: if p_datetrack_mode = hr_api.g_zap then
2099: l_effective_date := l_row.eed;
2100: else l_effective_date := p_effective_date;
2101: end if;
2102: BEN_ELIG_ORG_UNIT_PRTE_api.delete_ELIG_ORG_UNIT_PRTE

Line 2113: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2109: ,p_datetrack_mode => p_datetrack_mode);
2110: end if;
2111: end loop;
2112: for l_row in BEN_ELIG_OTHR_PTIP_PRTE_F loop
2113: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2114: or p_datetrack_mode <> hr_api.g_delete then
2115: if p_datetrack_mode = hr_api.g_zap then
2116: l_effective_date := l_row.eed;
2117: else l_effective_date := p_effective_date;

Line 2114: or p_datetrack_mode <> hr_api.g_delete then

2110: end if;
2111: end loop;
2112: for l_row in BEN_ELIG_OTHR_PTIP_PRTE_F loop
2113: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2114: or p_datetrack_mode <> hr_api.g_delete then
2115: if p_datetrack_mode = hr_api.g_zap then
2116: l_effective_date := l_row.eed;
2117: else l_effective_date := p_effective_date;
2118: end if;

Line 2115: if p_datetrack_mode = hr_api.g_zap then

2111: end loop;
2112: for l_row in BEN_ELIG_OTHR_PTIP_PRTE_F loop
2113: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2114: or p_datetrack_mode <> hr_api.g_delete then
2115: if p_datetrack_mode = hr_api.g_zap then
2116: l_effective_date := l_row.eed;
2117: else l_effective_date := p_effective_date;
2118: end if;
2119: BEN_ELIG_OTHR_PTIP_PRTE_api.delete_ELIG_OTHR_PTIP_PRTE

Line 2130: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2126: ,p_datetrack_mode => p_datetrack_mode);
2127: end if;
2128: end loop;
2129: for l_row in BEN_ELIG_DPNT_OTHR_PTIP_F loop
2130: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2131: or p_datetrack_mode <> hr_api.g_delete then
2132: if p_datetrack_mode = hr_api.g_zap then
2133: l_effective_date := l_row.eed;
2134: else l_effective_date := p_effective_date;

Line 2131: or p_datetrack_mode <> hr_api.g_delete then

2127: end if;
2128: end loop;
2129: for l_row in BEN_ELIG_DPNT_OTHR_PTIP_F loop
2130: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2131: or p_datetrack_mode <> hr_api.g_delete then
2132: if p_datetrack_mode = hr_api.g_zap then
2133: l_effective_date := l_row.eed;
2134: else l_effective_date := p_effective_date;
2135: end if;

Line 2132: if p_datetrack_mode = hr_api.g_zap then

2128: end loop;
2129: for l_row in BEN_ELIG_DPNT_OTHR_PTIP_F loop
2130: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2131: or p_datetrack_mode <> hr_api.g_delete then
2132: if p_datetrack_mode = hr_api.g_zap then
2133: l_effective_date := l_row.eed;
2134: else l_effective_date := p_effective_date;
2135: end if;
2136: BEN_ELIG_DPNT_OTHR_PTIP_api.delete_ELIG_DPNT_OTHR_PTIP

Line 2147: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2143: ,p_datetrack_mode => p_datetrack_mode);
2144: end if;
2145: end loop;
2146: for l_row in BEN_ELIG_PCT_FL_TM_PRTE_F loop
2147: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2148: or p_datetrack_mode <> hr_api.g_delete then
2149: if p_datetrack_mode = hr_api.g_zap then
2150: l_effective_date := l_row.eed;
2151: else l_effective_date := p_effective_date;

Line 2148: or p_datetrack_mode <> hr_api.g_delete then

2144: end if;
2145: end loop;
2146: for l_row in BEN_ELIG_PCT_FL_TM_PRTE_F loop
2147: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2148: or p_datetrack_mode <> hr_api.g_delete then
2149: if p_datetrack_mode = hr_api.g_zap then
2150: l_effective_date := l_row.eed;
2151: else l_effective_date := p_effective_date;
2152: end if;

Line 2149: if p_datetrack_mode = hr_api.g_zap then

2145: end loop;
2146: for l_row in BEN_ELIG_PCT_FL_TM_PRTE_F loop
2147: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2148: or p_datetrack_mode <> hr_api.g_delete then
2149: if p_datetrack_mode = hr_api.g_zap then
2150: l_effective_date := l_row.eed;
2151: else l_effective_date := p_effective_date;
2152: end if;
2153: BEN_ELIG_PCT_FL_TM_PRTE_api.delete_ELIG_PCT_FL_TM_PRTE

Line 2164: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2160: ,p_datetrack_mode => p_datetrack_mode);
2161: end if;
2162: end loop;
2163: for l_row in BEN_ELIG_PER_TYP_PRTE_F loop
2164: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2165: or p_datetrack_mode <> hr_api.g_delete then
2166: if p_datetrack_mode = hr_api.g_zap then
2167: l_effective_date := l_row.eed;
2168: else l_effective_date := p_effective_date;

Line 2165: or p_datetrack_mode <> hr_api.g_delete then

2161: end if;
2162: end loop;
2163: for l_row in BEN_ELIG_PER_TYP_PRTE_F loop
2164: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2165: or p_datetrack_mode <> hr_api.g_delete then
2166: if p_datetrack_mode = hr_api.g_zap then
2167: l_effective_date := l_row.eed;
2168: else l_effective_date := p_effective_date;
2169: end if;

Line 2166: if p_datetrack_mode = hr_api.g_zap then

2162: end loop;
2163: for l_row in BEN_ELIG_PER_TYP_PRTE_F loop
2164: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2165: or p_datetrack_mode <> hr_api.g_delete then
2166: if p_datetrack_mode = hr_api.g_zap then
2167: l_effective_date := l_row.eed;
2168: else l_effective_date := p_effective_date;
2169: end if;
2170: BEN_ELIG_PER_TYP_PRTE_api.delete_ELIG_PER_TYP_PRTE

Line 2181: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2177: ,p_datetrack_mode => p_datetrack_mode);
2178: end if;
2179: end loop;
2180: for l_row in BEN_ELIG_PPL_GRP_PRTE_F loop
2181: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2182: or p_datetrack_mode <> hr_api.g_delete then
2183: if p_datetrack_mode = hr_api.g_zap then
2184: l_effective_date := l_row.eed;
2185: else l_effective_date := p_effective_date;

Line 2182: or p_datetrack_mode <> hr_api.g_delete then

2178: end if;
2179: end loop;
2180: for l_row in BEN_ELIG_PPL_GRP_PRTE_F loop
2181: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2182: or p_datetrack_mode <> hr_api.g_delete then
2183: if p_datetrack_mode = hr_api.g_zap then
2184: l_effective_date := l_row.eed;
2185: else l_effective_date := p_effective_date;
2186: end if;

Line 2183: if p_datetrack_mode = hr_api.g_zap then

2179: end loop;
2180: for l_row in BEN_ELIG_PPL_GRP_PRTE_F loop
2181: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2182: or p_datetrack_mode <> hr_api.g_delete then
2183: if p_datetrack_mode = hr_api.g_zap then
2184: l_effective_date := l_row.eed;
2185: else l_effective_date := p_effective_date;
2186: end if;
2187: BEN_ELIG_PPL_GRP_PRTE_api.delete_ELIG_PPL_GRP_PRTE

Line 2198: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2194: ,p_datetrack_mode => p_datetrack_mode);
2195: end if;
2196: end loop;
2197: for l_row in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F loop
2198: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2199: or p_datetrack_mode <> hr_api.g_delete then
2200: if p_datetrack_mode = hr_api.g_zap then
2201: l_effective_date := l_row.eed;
2202: else l_effective_date := p_effective_date;

Line 2199: or p_datetrack_mode <> hr_api.g_delete then

2195: end if;
2196: end loop;
2197: for l_row in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F loop
2198: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2199: or p_datetrack_mode <> hr_api.g_delete then
2200: if p_datetrack_mode = hr_api.g_zap then
2201: l_effective_date := l_row.eed;
2202: else l_effective_date := p_effective_date;
2203: end if;

Line 2200: if p_datetrack_mode = hr_api.g_zap then

2196: end loop;
2197: for l_row in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F loop
2198: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2199: or p_datetrack_mode <> hr_api.g_delete then
2200: if p_datetrack_mode = hr_api.g_zap then
2201: l_effective_date := l_row.eed;
2202: else l_effective_date := p_effective_date;
2203: end if;
2204: ben_ELG_PRT_ANTHR_PL_PT_api.delete_ELG_PRT_ANTHR_PL_PT

Line 2215: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2211: ,p_datetrack_mode => p_datetrack_mode);
2212: end if;
2213: end loop;
2214: for l_row in BEN_ELIG_PSTL_CD_R_RNG_PRTE_F loop
2215: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2216: or p_datetrack_mode <> hr_api.g_delete then
2217: if p_datetrack_mode = hr_api.g_zap then
2218: l_effective_date := l_row.eed;
2219: else l_effective_date := p_effective_date;

Line 2216: or p_datetrack_mode <> hr_api.g_delete then

2212: end if;
2213: end loop;
2214: for l_row in BEN_ELIG_PSTL_CD_R_RNG_PRTE_F loop
2215: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2216: or p_datetrack_mode <> hr_api.g_delete then
2217: if p_datetrack_mode = hr_api.g_zap then
2218: l_effective_date := l_row.eed;
2219: else l_effective_date := p_effective_date;
2220: end if;

Line 2217: if p_datetrack_mode = hr_api.g_zap then

2213: end loop;
2214: for l_row in BEN_ELIG_PSTL_CD_R_RNG_PRTE_F loop
2215: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2216: or p_datetrack_mode <> hr_api.g_delete then
2217: if p_datetrack_mode = hr_api.g_zap then
2218: l_effective_date := l_row.eed;
2219: else l_effective_date := p_effective_date;
2220: end if;
2221: ben_ELIG_PSTL_CD_RNG_PRTE_api.delete_ELIG_PSTL_CD_RNG_PRTE

Line 2232: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2228: ,p_datetrack_mode => p_datetrack_mode);
2229: end if;
2230: end loop;
2231: for l_row in BEN_ELIG_PYRL_PRTE_F loop
2232: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2233: or p_datetrack_mode <> hr_api.g_delete then
2234: if p_datetrack_mode = hr_api.g_zap then
2235: l_effective_date := l_row.eed;
2236: else l_effective_date := p_effective_date;

Line 2233: or p_datetrack_mode <> hr_api.g_delete then

2229: end if;
2230: end loop;
2231: for l_row in BEN_ELIG_PYRL_PRTE_F loop
2232: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2233: or p_datetrack_mode <> hr_api.g_delete then
2234: if p_datetrack_mode = hr_api.g_zap then
2235: l_effective_date := l_row.eed;
2236: else l_effective_date := p_effective_date;
2237: end if;

Line 2234: if p_datetrack_mode = hr_api.g_zap then

2230: end loop;
2231: for l_row in BEN_ELIG_PYRL_PRTE_F loop
2232: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2233: or p_datetrack_mode <> hr_api.g_delete then
2234: if p_datetrack_mode = hr_api.g_zap then
2235: l_effective_date := l_row.eed;
2236: else l_effective_date := p_effective_date;
2237: end if;
2238: BEN_ELIG_PYRL_PRTE_api.delete_ELIG_PYRL_PRTE

Line 2249: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2245: ,p_datetrack_mode => p_datetrack_mode);
2246: end if;
2247: end loop;
2248: for l_row in BEN_ELIG_PY_BSS_PRTE_F loop
2249: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2250: or p_datetrack_mode <> hr_api.g_delete then
2251: if p_datetrack_mode = hr_api.g_zap then
2252: l_effective_date := l_row.eed;
2253: else l_effective_date := p_effective_date;

Line 2250: or p_datetrack_mode <> hr_api.g_delete then

2246: end if;
2247: end loop;
2248: for l_row in BEN_ELIG_PY_BSS_PRTE_F loop
2249: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2250: or p_datetrack_mode <> hr_api.g_delete then
2251: if p_datetrack_mode = hr_api.g_zap then
2252: l_effective_date := l_row.eed;
2253: else l_effective_date := p_effective_date;
2254: end if;

Line 2251: if p_datetrack_mode = hr_api.g_zap then

2247: end loop;
2248: for l_row in BEN_ELIG_PY_BSS_PRTE_F loop
2249: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2250: or p_datetrack_mode <> hr_api.g_delete then
2251: if p_datetrack_mode = hr_api.g_zap then
2252: l_effective_date := l_row.eed;
2253: else l_effective_date := p_effective_date;
2254: end if;
2255: BEN_ELIG_PY_BSS_PRTE_api.delete_ELIG_PY_BSS_PRTE

Line 2266: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2262: ,p_datetrack_mode => p_datetrack_mode);
2263: end if;
2264: end loop;
2265: for l_row in BEN_ELIG_SCHEDD_HRS_PRTE_F loop
2266: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2267: or p_datetrack_mode <> hr_api.g_delete then
2268: if p_datetrack_mode = hr_api.g_zap then
2269: l_effective_date := l_row.eed;
2270: else l_effective_date := p_effective_date;

Line 2267: or p_datetrack_mode <> hr_api.g_delete then

2263: end if;
2264: end loop;
2265: for l_row in BEN_ELIG_SCHEDD_HRS_PRTE_F loop
2266: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2267: or p_datetrack_mode <> hr_api.g_delete then
2268: if p_datetrack_mode = hr_api.g_zap then
2269: l_effective_date := l_row.eed;
2270: else l_effective_date := p_effective_date;
2271: end if;

Line 2268: if p_datetrack_mode = hr_api.g_zap then

2264: end loop;
2265: for l_row in BEN_ELIG_SCHEDD_HRS_PRTE_F loop
2266: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2267: or p_datetrack_mode <> hr_api.g_delete then
2268: if p_datetrack_mode = hr_api.g_zap then
2269: l_effective_date := l_row.eed;
2270: else l_effective_date := p_effective_date;
2271: end if;
2272: BEN_ELIG_SCHEDD_HRS_PRTE_api.delete_ELIG_SCHEDD_HRS_PRTE

Line 2283: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2279: ,p_datetrack_mode => p_datetrack_mode);
2280: end if;
2281: end loop;
2282: for l_row in BEN_ELIG_SVC_AREA_PRTE_F loop
2283: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2284: or p_datetrack_mode <> hr_api.g_delete then
2285: if p_datetrack_mode = hr_api.g_zap then
2286: l_effective_date := l_row.eed;
2287: else l_effective_date := p_effective_date;

Line 2284: or p_datetrack_mode <> hr_api.g_delete then

2280: end if;
2281: end loop;
2282: for l_row in BEN_ELIG_SVC_AREA_PRTE_F loop
2283: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2284: or p_datetrack_mode <> hr_api.g_delete then
2285: if p_datetrack_mode = hr_api.g_zap then
2286: l_effective_date := l_row.eed;
2287: else l_effective_date := p_effective_date;
2288: end if;

Line 2285: if p_datetrack_mode = hr_api.g_zap then

2281: end loop;
2282: for l_row in BEN_ELIG_SVC_AREA_PRTE_F loop
2283: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2284: or p_datetrack_mode <> hr_api.g_delete then
2285: if p_datetrack_mode = hr_api.g_zap then
2286: l_effective_date := l_row.eed;
2287: else l_effective_date := p_effective_date;
2288: end if;
2289: BEN_ELIG_SVC_AREA_PRTE_api.delete_ELIG_SVC_AREA_PRTE

Line 2300: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2296: ,p_datetrack_mode => p_datetrack_mode);
2297: end if;
2298: end loop;
2299: for l_row in BEN_ELIG_WK_LOC_PRTE_F loop
2300: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2301: or p_datetrack_mode <> hr_api.g_delete then
2302: if p_datetrack_mode = hr_api.g_zap then
2303: l_effective_date := l_row.eed;
2304: else l_effective_date := p_effective_date;

Line 2301: or p_datetrack_mode <> hr_api.g_delete then

2297: end if;
2298: end loop;
2299: for l_row in BEN_ELIG_WK_LOC_PRTE_F loop
2300: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2301: or p_datetrack_mode <> hr_api.g_delete then
2302: if p_datetrack_mode = hr_api.g_zap then
2303: l_effective_date := l_row.eed;
2304: else l_effective_date := p_effective_date;
2305: end if;

Line 2302: if p_datetrack_mode = hr_api.g_zap then

2298: end loop;
2299: for l_row in BEN_ELIG_WK_LOC_PRTE_F loop
2300: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2301: or p_datetrack_mode <> hr_api.g_delete then
2302: if p_datetrack_mode = hr_api.g_zap then
2303: l_effective_date := l_row.eed;
2304: else l_effective_date := p_effective_date;
2305: end if;
2306: BEN_ELIG_WK_LOC_PRTE_api.delete_ELIG_WK_LOC_PRTE

Line 2317: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2313: ,p_datetrack_mode => p_datetrack_mode);
2314: end if;
2315: end loop;
2316: for l_row in BEN_PRTN_ELIG_PRFL_F loop
2317: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2318: or p_datetrack_mode <> hr_api.g_delete then
2319: if p_datetrack_mode = hr_api.g_zap then
2320: l_effective_date := l_row.eed;
2321: else l_effective_date := p_effective_date;

Line 2318: or p_datetrack_mode <> hr_api.g_delete then

2314: end if;
2315: end loop;
2316: for l_row in BEN_PRTN_ELIG_PRFL_F loop
2317: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2318: or p_datetrack_mode <> hr_api.g_delete then
2319: if p_datetrack_mode = hr_api.g_zap then
2320: l_effective_date := l_row.eed;
2321: else l_effective_date := p_effective_date;
2322: end if;

Line 2319: if p_datetrack_mode = hr_api.g_zap then

2315: end loop;
2316: for l_row in BEN_PRTN_ELIG_PRFL_F loop
2317: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2318: or p_datetrack_mode <> hr_api.g_delete then
2319: if p_datetrack_mode = hr_api.g_zap then
2320: l_effective_date := l_row.eed;
2321: else l_effective_date := p_effective_date;
2322: end if;
2323: BEN_PRTN_ELIG_PRFL_api.delete_PRTN_ELIG_PRFL

Line 2335: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2331: end if;
2332: end loop;
2333:
2334: for l_row in BEN_CNTNG_PRTN_ELIG_PRFL_F loop
2335: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2336: or p_datetrack_mode <> hr_api.g_delete then
2337: if p_datetrack_mode = hr_api.g_zap then
2338: l_effective_date := l_row.eed;
2339: else l_effective_date := p_effective_date;

Line 2336: or p_datetrack_mode <> hr_api.g_delete then

2332: end loop;
2333:
2334: for l_row in BEN_CNTNG_PRTN_ELIG_PRFL_F loop
2335: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2336: or p_datetrack_mode <> hr_api.g_delete then
2337: if p_datetrack_mode = hr_api.g_zap then
2338: l_effective_date := l_row.eed;
2339: else l_effective_date := p_effective_date;
2340: end if;

Line 2337: if p_datetrack_mode = hr_api.g_zap then

2333:
2334: for l_row in BEN_CNTNG_PRTN_ELIG_PRFL_F loop
2335: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2336: or p_datetrack_mode <> hr_api.g_delete then
2337: if p_datetrack_mode = hr_api.g_zap then
2338: l_effective_date := l_row.eed;
2339: else l_effective_date := p_effective_date;
2340: end if;
2341: BEN_CNTNG_PRTN_ELIG_PRFL_api.delete_CNTNG_PRTN_ELIG_PRFL

Line 2354: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2350: end loop;
2351:
2352:
2353: for l_row in BEN_ELIG_GNDR_PRTE_F loop
2354: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2355: or p_datetrack_mode <> hr_api.g_delete then
2356: if p_datetrack_mode = hr_api.g_zap then
2357: l_effective_date := l_row.eed;
2358: else

Line 2355: or p_datetrack_mode <> hr_api.g_delete then

2351:
2352:
2353: for l_row in BEN_ELIG_GNDR_PRTE_F loop
2354: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2355: or p_datetrack_mode <> hr_api.g_delete then
2356: if p_datetrack_mode = hr_api.g_zap then
2357: l_effective_date := l_row.eed;
2358: else
2359: l_effective_date := p_effective_date;

Line 2356: if p_datetrack_mode = hr_api.g_zap then

2352:
2353: for l_row in BEN_ELIG_GNDR_PRTE_F loop
2354: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2355: or p_datetrack_mode <> hr_api.g_delete then
2356: if p_datetrack_mode = hr_api.g_zap then
2357: l_effective_date := l_row.eed;
2358: else
2359: l_effective_date := p_effective_date;
2360: end if;

Line 2443: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2439: end loop;
2440:
2441:
2442: for l_row in BEN_ELIG_qual_titl_prte_f loop
2443: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2444: or p_datetrack_mode <> hr_api.g_delete then
2445: if p_datetrack_mode = hr_api.g_zap then
2446: l_effective_date := l_row.eed;
2447: else

Line 2444: or p_datetrack_mode <> hr_api.g_delete then

2440:
2441:
2442: for l_row in BEN_ELIG_qual_titl_prte_f loop
2443: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2444: or p_datetrack_mode <> hr_api.g_delete then
2445: if p_datetrack_mode = hr_api.g_zap then
2446: l_effective_date := l_row.eed;
2447: else
2448: l_effective_date := p_effective_date;

Line 2445: if p_datetrack_mode = hr_api.g_zap then

2441:
2442: for l_row in BEN_ELIG_qual_titl_prte_f loop
2443: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2444: or p_datetrack_mode <> hr_api.g_delete then
2445: if p_datetrack_mode = hr_api.g_zap then
2446: l_effective_date := l_row.eed;
2447: else
2448: l_effective_date := p_effective_date;
2449: end if;

Line 2462: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2458: end if;
2459: end loop;
2460:
2461: for l_row in BEN_ELIG_pstn_prte_f loop
2462: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2463: or p_datetrack_mode <> hr_api.g_delete then
2464: if p_datetrack_mode = hr_api.g_zap then
2465: l_effective_date := l_row.eed;
2466: else

Line 2463: or p_datetrack_mode <> hr_api.g_delete then

2459: end loop;
2460:
2461: for l_row in BEN_ELIG_pstn_prte_f loop
2462: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2463: or p_datetrack_mode <> hr_api.g_delete then
2464: if p_datetrack_mode = hr_api.g_zap then
2465: l_effective_date := l_row.eed;
2466: else
2467: l_effective_date := p_effective_date;

Line 2464: if p_datetrack_mode = hr_api.g_zap then

2460:
2461: for l_row in BEN_ELIG_pstn_prte_f loop
2462: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2463: or p_datetrack_mode <> hr_api.g_delete then
2464: if p_datetrack_mode = hr_api.g_zap then
2465: l_effective_date := l_row.eed;
2466: else
2467: l_effective_date := p_effective_date;
2468: end if;

Line 2503: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2499: ,p_datetrack_mode => p_datetrack_mode);
2500: end loop;
2501:
2502: for l_row in BEN_ELIG_DSBLD_PRTE_F loop
2503: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2504: or p_datetrack_mode <> hr_api.g_delete then
2505: if p_datetrack_mode = hr_api.g_zap then
2506: l_effective_date := l_row.eed;
2507: else

Line 2504: or p_datetrack_mode <> hr_api.g_delete then

2500: end loop;
2501:
2502: for l_row in BEN_ELIG_DSBLD_PRTE_F loop
2503: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2504: or p_datetrack_mode <> hr_api.g_delete then
2505: if p_datetrack_mode = hr_api.g_zap then
2506: l_effective_date := l_row.eed;
2507: else
2508: l_effective_date := p_effective_date;

Line 2505: if p_datetrack_mode = hr_api.g_zap then

2501:
2502: for l_row in BEN_ELIG_DSBLD_PRTE_F loop
2503: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2504: or p_datetrack_mode <> hr_api.g_delete then
2505: if p_datetrack_mode = hr_api.g_zap then
2506: l_effective_date := l_row.eed;
2507: else
2508: l_effective_date := p_effective_date;
2509: end if;

Line 2522: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2518: end if;
2519: end loop;
2520:
2521: for l_row in BEN_ELIG_TTL_CVG_VOL_PRTE_F loop
2522: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2523: or p_datetrack_mode <> hr_api.g_delete then
2524: if p_datetrack_mode = hr_api.g_zap then
2525: l_effective_date := l_row.eed;
2526: else

Line 2523: or p_datetrack_mode <> hr_api.g_delete then

2519: end loop;
2520:
2521: for l_row in BEN_ELIG_TTL_CVG_VOL_PRTE_F loop
2522: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2523: or p_datetrack_mode <> hr_api.g_delete then
2524: if p_datetrack_mode = hr_api.g_zap then
2525: l_effective_date := l_row.eed;
2526: else
2527: l_effective_date := p_effective_date;

Line 2524: if p_datetrack_mode = hr_api.g_zap then

2520:
2521: for l_row in BEN_ELIG_TTL_CVG_VOL_PRTE_F loop
2522: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2523: or p_datetrack_mode <> hr_api.g_delete then
2524: if p_datetrack_mode = hr_api.g_zap then
2525: l_effective_date := l_row.eed;
2526: else
2527: l_effective_date := p_effective_date;
2528: end if;

Line 2541: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2537: end if;
2538: end loop;
2539:
2540: for l_row in BEN_ELIG_TTL_PRTT_PRTE_F loop
2541: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2542: or p_datetrack_mode <> hr_api.g_delete then
2543: if p_datetrack_mode = hr_api.g_zap then
2544: l_effective_date := l_row.eed;
2545: else

Line 2542: or p_datetrack_mode <> hr_api.g_delete then

2538: end loop;
2539:
2540: for l_row in BEN_ELIG_TTL_PRTT_PRTE_F loop
2541: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2542: or p_datetrack_mode <> hr_api.g_delete then
2543: if p_datetrack_mode = hr_api.g_zap then
2544: l_effective_date := l_row.eed;
2545: else
2546: l_effective_date := p_effective_date;

Line 2543: if p_datetrack_mode = hr_api.g_zap then

2539:
2540: for l_row in BEN_ELIG_TTL_PRTT_PRTE_F loop
2541: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2542: or p_datetrack_mode <> hr_api.g_delete then
2543: if p_datetrack_mode = hr_api.g_zap then
2544: l_effective_date := l_row.eed;
2545: else
2546: l_effective_date := p_effective_date;
2547: end if;

Line 2560: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2556: end if;
2557: end loop;
2558:
2559: for l_row in BEN_ELIG_ANTHR_PL_PRTE_F loop
2560: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2561: or p_datetrack_mode <> hr_api.g_delete then
2562: if p_datetrack_mode = hr_api.g_zap then
2563: l_effective_date := l_row.eed;
2564: else

Line 2561: or p_datetrack_mode <> hr_api.g_delete then

2557: end loop;
2558:
2559: for l_row in BEN_ELIG_ANTHR_PL_PRTE_F loop
2560: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2561: or p_datetrack_mode <> hr_api.g_delete then
2562: if p_datetrack_mode = hr_api.g_zap then
2563: l_effective_date := l_row.eed;
2564: else
2565: l_effective_date := p_effective_date;

Line 2562: if p_datetrack_mode = hr_api.g_zap then

2558:
2559: for l_row in BEN_ELIG_ANTHR_PL_PRTE_F loop
2560: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2561: or p_datetrack_mode <> hr_api.g_delete then
2562: if p_datetrack_mode = hr_api.g_zap then
2563: l_effective_date := l_row.eed;
2564: else
2565: l_effective_date := p_effective_date;
2566: end if;

Line 2579: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2575: end if;
2576: end loop;
2577:
2578: for l_row in BEN_ELIG_HLTH_CVG_PRTE_F loop
2579: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2580: or p_datetrack_mode <> hr_api.g_delete then
2581: if p_datetrack_mode = hr_api.g_zap then
2582: l_effective_date := l_row.eed;
2583: else

Line 2580: or p_datetrack_mode <> hr_api.g_delete then

2576: end loop;
2577:
2578: for l_row in BEN_ELIG_HLTH_CVG_PRTE_F loop
2579: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2580: or p_datetrack_mode <> hr_api.g_delete then
2581: if p_datetrack_mode = hr_api.g_zap then
2582: l_effective_date := l_row.eed;
2583: else
2584: l_effective_date := p_effective_date;

Line 2581: if p_datetrack_mode = hr_api.g_zap then

2577:
2578: for l_row in BEN_ELIG_HLTH_CVG_PRTE_F loop
2579: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2580: or p_datetrack_mode <> hr_api.g_delete then
2581: if p_datetrack_mode = hr_api.g_zap then
2582: l_effective_date := l_row.eed;
2583: else
2584: l_effective_date := p_effective_date;
2585: end if;

Line 2598: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2594: end if;
2595: end loop;
2596:
2597: for l_row in BEN_ELIG_COMPTNCY_PRTE_F loop
2598: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2599: or p_datetrack_mode <> hr_api.g_delete then
2600: if p_datetrack_mode = hr_api.g_zap then
2601: l_effective_date := l_row.eed;
2602: else

Line 2599: or p_datetrack_mode <> hr_api.g_delete then

2595: end loop;
2596:
2597: for l_row in BEN_ELIG_COMPTNCY_PRTE_F loop
2598: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2599: or p_datetrack_mode <> hr_api.g_delete then
2600: if p_datetrack_mode = hr_api.g_zap then
2601: l_effective_date := l_row.eed;
2602: else
2603: l_effective_date := p_effective_date;

Line 2600: if p_datetrack_mode = hr_api.g_zap then

2596:
2597: for l_row in BEN_ELIG_COMPTNCY_PRTE_F loop
2598: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2599: or p_datetrack_mode <> hr_api.g_delete then
2600: if p_datetrack_mode = hr_api.g_zap then
2601: l_effective_date := l_row.eed;
2602: else
2603: l_effective_date := p_effective_date;
2604: end if;

Line 2617: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2613: end if;
2614: end loop;
2615:
2616: for l_row in BEN_ELIG_QUA_IN_GR_PRTE_F loop
2617: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2618: or p_datetrack_mode <> hr_api.g_delete then
2619: if p_datetrack_mode = hr_api.g_zap then
2620: l_effective_date := l_row.eed;
2621: else

Line 2618: or p_datetrack_mode <> hr_api.g_delete then

2614: end loop;
2615:
2616: for l_row in BEN_ELIG_QUA_IN_GR_PRTE_F loop
2617: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2618: or p_datetrack_mode <> hr_api.g_delete then
2619: if p_datetrack_mode = hr_api.g_zap then
2620: l_effective_date := l_row.eed;
2621: else
2622: l_effective_date := p_effective_date;

Line 2619: if p_datetrack_mode = hr_api.g_zap then

2615:
2616: for l_row in BEN_ELIG_QUA_IN_GR_PRTE_F loop
2617: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2618: or p_datetrack_mode <> hr_api.g_delete then
2619: if p_datetrack_mode = hr_api.g_zap then
2620: l_effective_date := l_row.eed;
2621: else
2622: l_effective_date := p_effective_date;
2623: end if;

Line 2636: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2632: end if;
2633: end loop;
2634:
2635: for l_row in BEN_ELIG_PERF_RTNG_PRTE_F loop
2636: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2637: or p_datetrack_mode <> hr_api.g_delete then
2638: if p_datetrack_mode = hr_api.g_zap then
2639: l_effective_date := l_row.eed;
2640: else

Line 2637: or p_datetrack_mode <> hr_api.g_delete then

2633: end loop;
2634:
2635: for l_row in BEN_ELIG_PERF_RTNG_PRTE_F loop
2636: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2637: or p_datetrack_mode <> hr_api.g_delete then
2638: if p_datetrack_mode = hr_api.g_zap then
2639: l_effective_date := l_row.eed;
2640: else
2641: l_effective_date := p_effective_date;

Line 2638: if p_datetrack_mode = hr_api.g_zap then

2634:
2635: for l_row in BEN_ELIG_PERF_RTNG_PRTE_F loop
2636: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2637: or p_datetrack_mode <> hr_api.g_delete then
2638: if p_datetrack_mode = hr_api.g_zap then
2639: l_effective_date := l_row.eed;
2640: else
2641: l_effective_date := p_effective_date;
2642: end if;

Line 2658: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)

2654: --
2655: -- Bug No 4411798
2656: --
2657: for l_row in BEN_ELIGY_CRIT_VALUES_F loop
2658: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2659: or p_datetrack_mode <> hr_api.g_delete then
2660: if p_datetrack_mode = hr_api.g_zap then
2661: l_effective_date := l_row.eed;
2662: else

Line 2659: or p_datetrack_mode <> hr_api.g_delete then

2655: -- Bug No 4411798
2656: --
2657: for l_row in BEN_ELIGY_CRIT_VALUES_F loop
2658: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2659: or p_datetrack_mode <> hr_api.g_delete then
2660: if p_datetrack_mode = hr_api.g_zap then
2661: l_effective_date := l_row.eed;
2662: else
2663: l_effective_date := p_effective_date;

Line 2660: if p_datetrack_mode = hr_api.g_zap then

2656: --
2657: for l_row in BEN_ELIGY_CRIT_VALUES_F loop
2658: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2659: or p_datetrack_mode <> hr_api.g_delete then
2660: if p_datetrack_mode = hr_api.g_zap then
2661: l_effective_date := l_row.eed;
2662: else
2663: l_effective_date := p_effective_date;
2664: end if;

Line 2727: when hr_api.cannot_find_prog_unit then

2723: ,p_datetrack_mode => p_datetrack_mode);
2724: --
2725: exception
2726: --
2727: when hr_api.cannot_find_prog_unit then
2728: --
2729: hr_api.cannot_find_prog_unit_error
2730: (p_module_name => 'DELETE_ELIGY_PROFILE'
2731: ,p_hook_type => 'BP');

Line 2729: hr_api.cannot_find_prog_unit_error

2725: exception
2726: --
2727: when hr_api.cannot_find_prog_unit then
2728: --
2729: hr_api.cannot_find_prog_unit_error
2730: (p_module_name => 'DELETE_ELIGY_PROFILE'
2731: ,p_hook_type => 'BP');
2732: --
2733: -- End of API User Hook for the before hook of delete_ELIGY_PROFILE

Line 2764: when hr_api.cannot_find_prog_unit then

2760: ,p_datetrack_mode => p_datetrack_mode);
2761: --
2762: exception
2763: --
2764: when hr_api.cannot_find_prog_unit then
2765: --
2766: hr_api.cannot_find_prog_unit_error
2767: (p_module_name => 'DELETE_ELIGY_PROFILE'
2768: ,p_hook_type => 'AP');

Line 2766: hr_api.cannot_find_prog_unit_error

2762: exception
2763: --
2764: when hr_api.cannot_find_prog_unit then
2765: --
2766: hr_api.cannot_find_prog_unit_error
2767: (p_module_name => 'DELETE_ELIGY_PROFILE'
2768: ,p_hook_type => 'AP');
2769: --
2770: -- End of API User Hook for the after hook of delete_ELIGY_PROFILE

Line 2779: raise hr_api.validate_enabled;

2775: --
2776: -- When in validation only mode raise the Validate_Enabled exception
2777: --
2778: if p_validate then
2779: raise hr_api.validate_enabled;
2780: end if;
2781: --
2782: hr_utility.set_location(' Leaving:'||l_proc, 70);
2783: --

Line 2786: when hr_api.validate_enabled then

2782: hr_utility.set_location(' Leaving:'||l_proc, 70);
2783: --
2784: exception
2785: --
2786: when hr_api.validate_enabled then
2787: --
2788: -- As the Validate_Enabled exception has been raised
2789: -- we must rollback to the savepoint
2790: --