APPS.BEN_ELIGY_PROFILE_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 548

procedure update_ELIGY_PROFILE
  (p_validate                       in  boolean   default false
  ,p_eligy_prfl_id                  in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_name                           in  varchar2  default hr_api.g_varchar2
  ,p_description                    in  varchar2  default hr_api.g_varchar2
  ,p_stat_cd                        in  varchar2  default hr_api.g_varchar2
  ,p_asmt_to_use_cd                 in  varchar2  default hr_api.g_varchar2
  ,p_elig_enrld_plip_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_cbr_quald_bnf_flag        in  varchar2  default hr_api.g_varchar2
  ,p_elig_enrld_ptip_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_dpnt_cvrd_plip_flag       in  varchar2  default hr_api.g_varchar2
  ,p_elig_dpnt_cvrd_ptip_flag       in  varchar2  default hr_api.g_varchar2
  ,p_elig_dpnt_cvrd_pgm_flag        in  varchar2  default hr_api.g_varchar2
  ,p_elig_job_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_elig_hrly_slrd_flag            in  varchar2  default hr_api.g_varchar2
  ,p_elig_pstl_cd_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_lbr_mmbr_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_lgl_enty_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_benfts_grp_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_wk_loc_flag               in  varchar2  default hr_api.g_varchar2
  ,p_elig_brgng_unit_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_age_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_elig_los_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_elig_per_typ_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_fl_tm_pt_tm_flag          in  varchar2  default hr_api.g_varchar2
  ,p_elig_ee_stat_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_grd_flag                  in  varchar2  default hr_api.g_varchar2
  ,p_elig_pct_fl_tm_flag            in  varchar2  default hr_api.g_varchar2
  ,p_elig_asnt_set_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_hrs_wkd_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_comp_lvl_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_org_unit_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_loa_rsn_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_pyrl_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_elig_schedd_hrs_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_py_bss_flag               in  varchar2  default hr_api.g_varchar2
  ,p_eligy_prfl_rl_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_cmbn_age_los_flag         in  varchar2  default hr_api.g_varchar2
  ,p_cntng_prtn_elig_prfl_flag      in  varchar2  default hr_api.g_varchar2
  ,p_elig_prtt_pl_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_ppl_grp_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_svc_area_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_ptip_prte_flag            in  varchar2  default hr_api.g_varchar2
  ,p_elig_no_othr_cvg_flag          in  varchar2  default hr_api.g_varchar2
  ,p_elig_enrld_pl_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_enrld_oipl_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_enrld_pgm_flag            in  varchar2  default hr_api.g_varchar2
  ,p_elig_dpnt_cvrd_pl_flag         in  varchar2  default hr_api.g_varchar2
  ,p_elig_lvg_rsn_flag              in  varchar2  default hr_api.g_varchar2
  ,p_elig_optd_mdcr_flag            in  varchar2  default hr_api.g_varchar2
  ,p_elig_tbco_use_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_dpnt_othr_ptip_flag       in  varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_elp_attribute_category         in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute1                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute2                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute3                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute4                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute5                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute6                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute7                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute8                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute9                 in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute10                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute11                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute12                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute13                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute14                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute15                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute16                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute17                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute18                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute19                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute20                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute21                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute22                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute23                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute24                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute25                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute26                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute27                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute28                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute29                in  varchar2  default hr_api.g_varchar2
  ,p_elp_attribute30                in  varchar2  default hr_api.g_varchar2
  ,p_elig_mrtl_sts_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_gndr_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_elig_dsblty_ctg_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_dsblty_rsn_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_dsblty_dgr_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_suppl_role_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_qual_titl_flag            in  varchar2  default hr_api.g_varchar2
  ,p_elig_pstn_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_elig_prbtn_perd_flag           in  varchar2  default hr_api.g_varchar2
  ,p_elig_sp_clng_prg_pt_flag       in  varchar2  default hr_api.g_varchar2
  ,p_bnft_cagr_prtn_cd              in  varchar2  default hr_api.g_varchar2
  ,p_elig_dsbld_flag                in  varchar2  default hr_api.g_varchar2
  ,p_elig_ttl_cvg_vol_flag          in  varchar2  default hr_api.g_varchar2
  ,p_elig_ttl_prtt_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_comptncy_flag             in  varchar2  default hr_api.g_varchar2
  ,p_elig_hlth_cvg_flag		    in  varchar2  default hr_api.g_varchar2
  ,p_elig_anthr_pl_flag		    in  varchar2  default hr_api.g_varchar2
  ,p_elig_qua_in_gr_flag	    in  varchar2  default hr_api.g_varchar2
  ,p_elig_perf_rtng_flag	    in  varchar2  default hr_api.g_varchar2
  ,p_elig_crit_values_flag          in  varchar2  default hr_api.g_varchar2  /* RBC */
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';

Line: 671

  savepoint update_ELIGY_PROFILE;

Line: 683

    ben_ELIGY_PROFILE_bk2.update_ELIGY_PROFILE_b
      (p_eligy_prfl_id                  =>  p_eligy_prfl_id
      ,p_name                           =>  p_name
      ,p_description                    =>  p_description
      ,p_stat_cd                        =>  p_stat_cd
      ,p_asmt_to_use_cd                 =>  p_asmt_to_use_cd
      ,p_elig_enrld_plip_flag           =>  p_elig_enrld_plip_flag
      ,p_elig_cbr_quald_bnf_flag        =>  p_elig_cbr_quald_bnf_flag
      ,p_elig_enrld_ptip_flag           =>  p_elig_enrld_ptip_flag
      ,p_elig_dpnt_cvrd_plip_flag       =>  p_elig_dpnt_cvrd_plip_flag
      ,p_elig_dpnt_cvrd_ptip_flag       =>  p_elig_dpnt_cvrd_ptip_flag
      ,p_elig_dpnt_cvrd_pgm_flag        =>  p_elig_dpnt_cvrd_pgm_flag
      ,p_elig_job_flag                  =>  p_elig_job_flag
      ,p_elig_hrly_slrd_flag            =>  p_elig_hrly_slrd_flag
      ,p_elig_pstl_cd_flag              =>  p_elig_pstl_cd_flag
      ,p_elig_lbr_mmbr_flag             =>  p_elig_lbr_mmbr_flag
      ,p_elig_lgl_enty_flag             =>  p_elig_lgl_enty_flag
      ,p_elig_benfts_grp_flag           =>  p_elig_benfts_grp_flag
      ,p_elig_wk_loc_flag               =>  p_elig_wk_loc_flag
      ,p_elig_brgng_unit_flag           =>  p_elig_brgng_unit_flag
      ,p_elig_age_flag                  =>  p_elig_age_flag
      ,p_elig_los_flag                  =>  p_elig_los_flag
      ,p_elig_per_typ_flag              =>  p_elig_per_typ_flag
      ,p_elig_fl_tm_pt_tm_flag          =>  p_elig_fl_tm_pt_tm_flag
      ,p_elig_ee_stat_flag              =>  p_elig_ee_stat_flag
      ,p_elig_grd_flag                  =>  p_elig_grd_flag
      ,p_elig_pct_fl_tm_flag            =>  p_elig_pct_fl_tm_flag
      ,p_elig_asnt_set_flag             =>  p_elig_asnt_set_flag
      ,p_elig_hrs_wkd_flag              =>  p_elig_hrs_wkd_flag
      ,p_elig_comp_lvl_flag             =>  p_elig_comp_lvl_flag
      ,p_elig_org_unit_flag             =>  p_elig_org_unit_flag
      ,p_elig_loa_rsn_flag              =>  p_elig_loa_rsn_flag
      ,p_elig_pyrl_flag                 =>  p_elig_pyrl_flag
      ,p_elig_schedd_hrs_flag           =>  p_elig_schedd_hrs_flag
      ,p_elig_py_bss_flag               =>  p_elig_py_bss_flag
      ,p_eligy_prfl_rl_flag             =>  p_eligy_prfl_rl_flag
      ,p_elig_cmbn_age_los_flag         =>  p_elig_cmbn_age_los_flag
      ,p_cntng_prtn_elig_prfl_flag      =>  p_cntng_prtn_elig_prfl_flag
      ,p_elig_prtt_pl_flag              =>  p_elig_prtt_pl_flag
      ,p_elig_ppl_grp_flag              =>  p_elig_ppl_grp_flag
      ,p_elig_svc_area_flag             =>  p_elig_svc_area_flag
      ,p_elig_ptip_prte_flag            =>  p_elig_ptip_prte_flag
      ,p_elig_no_othr_cvg_flag          =>  p_elig_no_othr_cvg_flag
      ,p_elig_enrld_pl_flag             =>  p_elig_enrld_pl_flag
      ,p_elig_enrld_oipl_flag           =>  p_elig_enrld_oipl_flag
      ,p_elig_enrld_pgm_flag            =>  p_elig_enrld_pgm_flag
      ,p_elig_dpnt_cvrd_pl_flag         =>  p_elig_dpnt_cvrd_pl_flag
      ,p_elig_lvg_rsn_flag              =>  p_elig_lvg_rsn_flag
      ,p_elig_optd_mdcr_flag            =>  p_elig_optd_mdcr_flag
      ,p_elig_tbco_use_flag             =>  p_elig_tbco_use_flag
      ,p_elig_dpnt_othr_ptip_flag       =>  p_elig_dpnt_othr_ptip_flag
      ,p_business_group_id              =>  p_business_group_id
      ,p_elp_attribute_category         =>  p_elp_attribute_category
      ,p_elp_attribute1                 =>  p_elp_attribute1
      ,p_elp_attribute2                 =>  p_elp_attribute2
      ,p_elp_attribute3                 =>  p_elp_attribute3
      ,p_elp_attribute4                 =>  p_elp_attribute4
      ,p_elp_attribute5                 =>  p_elp_attribute5
      ,p_elp_attribute6                 =>  p_elp_attribute6
      ,p_elp_attribute7                 =>  p_elp_attribute7
      ,p_elp_attribute8                 =>  p_elp_attribute8
      ,p_elp_attribute9                 =>  p_elp_attribute9
      ,p_elp_attribute10                =>  p_elp_attribute10
      ,p_elp_attribute11                =>  p_elp_attribute11
      ,p_elp_attribute12                =>  p_elp_attribute12
      ,p_elp_attribute13                =>  p_elp_attribute13
      ,p_elp_attribute14                =>  p_elp_attribute14
      ,p_elp_attribute15                =>  p_elp_attribute15
      ,p_elp_attribute16                =>  p_elp_attribute16
      ,p_elp_attribute17                =>  p_elp_attribute17
      ,p_elp_attribute18                =>  p_elp_attribute18
      ,p_elp_attribute19                =>  p_elp_attribute19
      ,p_elp_attribute20                =>  p_elp_attribute20
      ,p_elp_attribute21                =>  p_elp_attribute21
      ,p_elp_attribute22                =>  p_elp_attribute22
      ,p_elp_attribute23                =>  p_elp_attribute23
      ,p_elp_attribute24                =>  p_elp_attribute24
      ,p_elp_attribute25                =>  p_elp_attribute25
      ,p_elp_attribute26                =>  p_elp_attribute26
      ,p_elp_attribute27                =>  p_elp_attribute27
      ,p_elp_attribute28                =>  p_elp_attribute28
      ,p_elp_attribute29                =>  p_elp_attribute29
      ,p_elp_attribute30                =>  p_elp_attribute30
      ,p_elig_mrtl_sts_flag             =>  p_elig_mrtl_sts_flag
      ,p_elig_gndr_flag                 =>  p_elig_gndr_flag
      ,p_elig_dsblty_ctg_flag           =>  p_elig_dsblty_ctg_flag
      ,p_elig_dsblty_rsn_flag           =>  p_elig_dsblty_rsn_flag
      ,p_elig_dsblty_dgr_flag           =>  p_elig_dsblty_dgr_flag
      ,p_elig_suppl_role_flag           =>  p_elig_suppl_role_flag
      ,p_elig_qual_titl_flag            =>  p_elig_qual_titl_flag
      ,p_elig_pstn_flag                 =>  p_elig_pstn_flag
      ,p_elig_prbtn_perd_flag           =>  p_elig_prbtn_perd_flag
      ,p_elig_sp_clng_prg_pt_flag       =>  p_elig_sp_clng_prg_pt_flag
      ,p_bnft_cagr_prtn_cd              =>  p_bnft_cagr_prtn_cd
      ,p_elig_dsbld_flag                =>  p_elig_dsbld_flag
      ,p_elig_ttl_cvg_vol_flag          =>  p_elig_ttl_cvg_vol_flag
      ,p_elig_ttl_prtt_flag             =>  p_elig_ttl_prtt_flag
      ,p_elig_comptncy_flag             =>  p_elig_comptncy_flag
      ,p_elig_hlth_cvg_flag		=>  p_elig_hlth_cvg_flag
      ,p_elig_anthr_pl_flag		=>  p_elig_anthr_pl_flag
      ,p_elig_qua_in_gr_flag		=>  p_elig_qua_in_gr_flag
      ,p_elig_perf_rtng_flag		=>  p_elig_perf_rtng_flag
      ,p_elig_crit_values_flag          =>  p_elig_crit_values_flag   /* RBC */
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 795

        (p_module_name => 'UPDATE_ELIGY_PROFILE'
        ,p_hook_type   => 'BP');

Line: 915

    ben_ELIGY_PROFILE_bk2.update_ELIGY_PROFILE_a
      (p_eligy_prfl_id                  =>  p_eligy_prfl_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_name                           =>  p_name
      ,p_description                    =>  p_description
      ,p_stat_cd                        =>  p_stat_cd
      ,p_asmt_to_use_cd                 =>  p_asmt_to_use_cd
      ,p_elig_enrld_plip_flag           =>  p_elig_enrld_plip_flag
      ,p_elig_cbr_quald_bnf_flag        =>  p_elig_cbr_quald_bnf_flag
      ,p_elig_enrld_ptip_flag           =>  p_elig_enrld_ptip_flag
      ,p_elig_dpnt_cvrd_plip_flag       =>  p_elig_dpnt_cvrd_plip_flag
      ,p_elig_dpnt_cvrd_ptip_flag       =>  p_elig_dpnt_cvrd_ptip_flag
      ,p_elig_dpnt_cvrd_pgm_flag        =>  p_elig_dpnt_cvrd_pgm_flag
      ,p_elig_job_flag                  =>  p_elig_job_flag
      ,p_elig_hrly_slrd_flag            =>  p_elig_hrly_slrd_flag
      ,p_elig_pstl_cd_flag              =>  p_elig_pstl_cd_flag
      ,p_elig_lbr_mmbr_flag             =>  p_elig_lbr_mmbr_flag
      ,p_elig_lgl_enty_flag             =>  p_elig_lgl_enty_flag
      ,p_elig_benfts_grp_flag           =>  p_elig_benfts_grp_flag
      ,p_elig_wk_loc_flag               =>  p_elig_wk_loc_flag
      ,p_elig_brgng_unit_flag           =>  p_elig_brgng_unit_flag
      ,p_elig_age_flag                  =>  p_elig_age_flag
      ,p_elig_los_flag                  =>  p_elig_los_flag
      ,p_elig_per_typ_flag              =>  p_elig_per_typ_flag
      ,p_elig_fl_tm_pt_tm_flag          =>  p_elig_fl_tm_pt_tm_flag
      ,p_elig_ee_stat_flag              =>  p_elig_ee_stat_flag
      ,p_elig_grd_flag                  =>  p_elig_grd_flag
      ,p_elig_pct_fl_tm_flag            =>  p_elig_pct_fl_tm_flag
      ,p_elig_asnt_set_flag             =>  p_elig_asnt_set_flag
      ,p_elig_hrs_wkd_flag              =>  p_elig_hrs_wkd_flag
      ,p_elig_comp_lvl_flag             =>  p_elig_comp_lvl_flag
      ,p_elig_org_unit_flag             =>  p_elig_org_unit_flag
      ,p_elig_loa_rsn_flag              =>  p_elig_loa_rsn_flag
      ,p_elig_pyrl_flag                 =>  p_elig_pyrl_flag
      ,p_elig_schedd_hrs_flag           =>  p_elig_schedd_hrs_flag
      ,p_elig_py_bss_flag               =>  p_elig_py_bss_flag
      ,p_eligy_prfl_rl_flag             =>  p_eligy_prfl_rl_flag
      ,p_elig_cmbn_age_los_flag         =>  p_elig_cmbn_age_los_flag
      ,p_cntng_prtn_elig_prfl_flag      =>  p_cntng_prtn_elig_prfl_flag
      ,p_elig_prtt_pl_flag              =>  p_elig_prtt_pl_flag
      ,p_elig_ppl_grp_flag              =>  p_elig_ppl_grp_flag
      ,p_elig_svc_area_flag             =>  p_elig_svc_area_flag
      ,p_elig_ptip_prte_flag            =>  p_elig_ptip_prte_flag
      ,p_elig_no_othr_cvg_flag          =>  p_elig_no_othr_cvg_flag
      ,p_elig_enrld_pl_flag             =>  p_elig_enrld_pl_flag
      ,p_elig_enrld_oipl_flag           =>  p_elig_enrld_oipl_flag
      ,p_elig_enrld_pgm_flag            =>  p_elig_enrld_pgm_flag
      ,p_elig_dpnt_cvrd_pl_flag         =>  p_elig_dpnt_cvrd_pl_flag
      ,p_elig_lvg_rsn_flag              =>  p_elig_lvg_rsn_flag
      ,p_elig_optd_mdcr_flag            =>  p_elig_optd_mdcr_flag
      ,p_elig_tbco_use_flag             =>  p_elig_tbco_use_flag
      ,p_elig_dpnt_othr_ptip_flag       =>  p_elig_dpnt_othr_ptip_flag
      ,p_business_group_id              =>  p_business_group_id
      ,p_elp_attribute_category         =>  p_elp_attribute_category
      ,p_elp_attribute1                 =>  p_elp_attribute1
      ,p_elp_attribute2                 =>  p_elp_attribute2
      ,p_elp_attribute3                 =>  p_elp_attribute3
      ,p_elp_attribute4                 =>  p_elp_attribute4
      ,p_elp_attribute5                 =>  p_elp_attribute5
      ,p_elp_attribute6                 =>  p_elp_attribute6
      ,p_elp_attribute7                 =>  p_elp_attribute7
      ,p_elp_attribute8                 =>  p_elp_attribute8
      ,p_elp_attribute9                 =>  p_elp_attribute9
      ,p_elp_attribute10                =>  p_elp_attribute10
      ,p_elp_attribute11                =>  p_elp_attribute11
      ,p_elp_attribute12                =>  p_elp_attribute12
      ,p_elp_attribute13                =>  p_elp_attribute13
      ,p_elp_attribute14                =>  p_elp_attribute14
      ,p_elp_attribute15                =>  p_elp_attribute15
      ,p_elp_attribute16                =>  p_elp_attribute16
      ,p_elp_attribute17                =>  p_elp_attribute17
      ,p_elp_attribute18                =>  p_elp_attribute18
      ,p_elp_attribute19                =>  p_elp_attribute19
      ,p_elp_attribute20                =>  p_elp_attribute20
      ,p_elp_attribute21                =>  p_elp_attribute21
      ,p_elp_attribute22                =>  p_elp_attribute22
      ,p_elp_attribute23                =>  p_elp_attribute23
      ,p_elp_attribute24                =>  p_elp_attribute24
      ,p_elp_attribute25                =>  p_elp_attribute25
      ,p_elp_attribute26                =>  p_elp_attribute26
      ,p_elp_attribute27                =>  p_elp_attribute27
      ,p_elp_attribute28                =>  p_elp_attribute28
      ,p_elp_attribute29                =>  p_elp_attribute29
      ,p_elp_attribute30                =>  p_elp_attribute30
      ,p_elig_mrtl_sts_flag             =>  p_elig_mrtl_sts_flag
      ,p_elig_gndr_flag                 =>  p_elig_gndr_flag
      ,p_elig_dsblty_ctg_flag           =>  p_elig_dsblty_ctg_flag
      ,p_elig_dsblty_rsn_flag           =>  p_elig_dsblty_rsn_flag
      ,p_elig_dsblty_dgr_flag           =>  p_elig_dsblty_dgr_flag
      ,p_elig_suppl_role_flag           =>  p_elig_suppl_role_flag
      ,p_elig_qual_titl_flag            =>  p_elig_qual_titl_flag
      ,p_elig_pstn_flag                 =>  p_elig_pstn_flag
      ,p_elig_prbtn_perd_flag           =>  p_elig_prbtn_perd_flag
      ,p_elig_sp_clng_prg_pt_flag       =>  p_elig_sp_clng_prg_pt_flag
      ,p_bnft_cagr_prtn_cd              =>  p_bnft_cagr_prtn_cd
      ,p_elig_dsbld_flag                =>  p_elig_dsbld_flag
      ,p_elig_ttl_cvg_vol_flag          =>  p_elig_ttl_cvg_vol_flag
      ,p_elig_ttl_prtt_flag             =>  p_elig_ttl_prtt_flag
      ,p_elig_comptncy_flag             =>  p_elig_comptncy_flag
      ,p_elig_hlth_cvg_flag		=>  p_elig_hlth_cvg_flag
      ,p_elig_anthr_pl_flag		=>  p_elig_anthr_pl_flag
      ,p_elig_qua_in_gr_flag		=>  p_elig_qua_in_gr_flag
      ,p_elig_perf_rtng_flag		=>  p_elig_perf_rtng_flag
      ,p_elig_crit_values_flag          =>  p_elig_crit_values_flag   /* RBC */
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 1029

        (p_module_name => 'UPDATE_ELIGY_PROFILE'
        ,p_hook_type   => 'AP');

Line: 1059

    ROLLBACK TO update_ELIGY_PROFILE;

Line: 1075

    ROLLBACK TO update_ELIGY_PROFILE;

Line: 1078

end update_ELIGY_PROFILE;

Line: 1083

procedure delete_children
  (p_eligy_prfl_id                  in  number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2) is

cursor BEN_ELIGY_PRFL_RL_F is
  select a.eligy_prfl_rl_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIGY_PRFL_RL_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIGY_PRFL_RL_F b
        where a.eligy_prfl_rl_id = b.eligy_prfl_rl_id);

Line: 1097

  select a.elig_age_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_AGE_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_AGE_PRTE_F b
        where a.elig_age_prte_id = b.elig_age_prte_id);

Line: 1105

  select a.elig_asnt_set_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ASNT_SET_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ASNT_SET_PRTE_F b
        where a.elig_asnt_set_prte_id = b.elig_asnt_set_prte_id);

Line: 1113

  select a.elig_benfts_grp_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_BENFTS_GRP_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_BENFTS_GRP_PRTE_F b
        where a.elig_benfts_grp_prte_id = b.elig_benfts_grp_prte_id);

Line: 1121

  select a.elig_brgng_unit_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_BRGNG_UNIT_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_BRGNG_UNIT_PRTE_F b
        where a.elig_brgng_unit_prte_id = b.elig_brgng_unit_prte_id);

Line: 1129

  select a.elig_cbr_quald_bnf_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_CBR_QUALD_BNF_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_CBR_QUALD_BNF_F b
        where a.elig_cbr_quald_bnf_id = b.elig_cbr_quald_bnf_id);

Line: 1137

  select a.elig_cmbn_age_los_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_CMBN_AGE_LOS_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_CMBN_AGE_LOS_PRTE_F b
        where a.elig_cmbn_age_los_prte_id = b.elig_cmbn_age_los_prte_id);

Line: 1145

  select a.elig_comp_lvl_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_COMP_LVL_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_COMP_LVL_PRTE_F b
        where a.elig_comp_lvl_prte_id = b.elig_comp_lvl_prte_id);

Line: 1153

  select a.elig_dpnt_cvrd_othr_pgm_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F b
        where a.elig_dpnt_cvrd_othr_pgm_id = b.elig_dpnt_cvrd_othr_pgm_id);

Line: 1161

  select a.elig_dpnt_cvrd_othr_pl_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DPNT_CVRD_OTHR_PL_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_DPNT_CVRD_OTHR_PL_F b
        where a.elig_dpnt_cvrd_othr_pl_id = b.elig_dpnt_cvrd_othr_pl_id);

Line: 1169

  select a.elig_dpnt_cvrd_othr_ptip_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F b
        where a.elig_dpnt_cvrd_othr_ptip_id = b.elig_dpnt_cvrd_othr_ptip_id);

Line: 1177

  select a.elig_dpnt_cvrd_plip_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DPNT_CVRD_PLIP_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_DPNT_CVRD_PLIP_F b
        where a.elig_dpnt_cvrd_plip_id = b.elig_dpnt_cvrd_plip_id);

Line: 1185

  select a.elig_ee_stat_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_EE_STAT_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_EE_STAT_PRTE_F b
        where a.elig_ee_stat_prte_id = b.elig_ee_stat_prte_id);

Line: 1193

  select a.elig_enrld_anthr_oipl_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ENRLD_ANTHR_OIPL_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ENRLD_ANTHR_OIPL_F b
        where a.elig_enrld_anthr_oipl_id = b.elig_enrld_anthr_oipl_id);

Line: 1201

  select a.elig_enrld_anthr_pgm_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ENRLD_ANTHR_PGM_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ENRLD_ANTHR_PGM_F b
        where a.elig_enrld_anthr_pgm_id = b.elig_enrld_anthr_pgm_id);

Line: 1209

  select a.elig_enrld_anthr_plip_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ENRLD_ANTHR_PLIP_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ENRLD_ANTHR_PLIP_F b
        where a.elig_enrld_anthr_plip_id = b.elig_enrld_anthr_plip_id);

Line: 1217

  select a.elig_enrld_anthr_pl_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ENRLD_ANTHR_PL_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ENRLD_ANTHR_PL_F b
        where a.elig_enrld_anthr_pl_id = b.elig_enrld_anthr_pl_id);

Line: 1225

  select a.elig_enrld_anthr_ptip_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ENRLD_ANTHR_PTIP_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ENRLD_ANTHR_PTIP_F b
        where a.elig_enrld_anthr_ptip_id = b.elig_enrld_anthr_ptip_id);

Line: 1233

  select a.elig_fl_tm_pt_tm_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_FL_TM_PT_TM_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_FL_TM_PT_TM_PRTE_F b
        where a.elig_fl_tm_pt_tm_prte_id = b.elig_fl_tm_pt_tm_prte_id);

Line: 1241

  select a.elig_grd_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_GRD_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_GRD_PRTE_F b
        where a.elig_grd_prte_id = b.elig_grd_prte_id);

Line: 1249

  select a.elig_hrly_slrd_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_HRLY_SLRD_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_HRLY_SLRD_PRTE_F b
        where a.elig_hrly_slrd_prte_id = b.elig_hrly_slrd_prte_id);

Line: 1257

  select a.elig_hrs_wkd_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_HRS_WKD_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_HRS_WKD_PRTE_F b
        where a.elig_hrs_wkd_prte_id = b.elig_hrs_wkd_prte_id);

Line: 1265

  select a.elig_job_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_JOB_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_JOB_PRTE_F b
        where a.elig_job_prte_id = b.elig_job_prte_id);

Line: 1273

  select a.elig_lbr_mmbr_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_LBR_MMBR_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_LBR_MMBR_PRTE_F b
        where a.elig_lbr_mmbr_prte_id = b.elig_lbr_mmbr_prte_id);

Line: 1281

  select a.elig_lgl_enty_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_LGL_ENTY_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_LGL_ENTY_PRTE_F b
        where a.elig_lgl_enty_prte_id = b.elig_lgl_enty_prte_id);

Line: 1289

  select a.elig_loa_rsn_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_LOA_RSN_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_LOA_RSN_PRTE_F b
        where a.elig_loa_rsn_prte_id = b.elig_loa_rsn_prte_id);

Line: 1297

  select a.elig_los_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_LOS_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_LOS_PRTE_F b
        where a.elig_los_prte_id = b.elig_los_prte_id);

Line: 1305

  select a.elig_lvg_rsn_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_LVG_RSN_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_LVG_RSN_PRTE_F b
        where a.elig_lvg_rsn_prte_id = b.elig_lvg_rsn_prte_id);

Line: 1313

  select a.elig_no_othr_cvg_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_NO_OTHR_CVG_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_NO_OTHR_CVG_PRTE_F b
        where a.elig_no_othr_cvg_prte_id = b.elig_no_othr_cvg_prte_id);

Line: 1321

  select a.elig_optd_mdcr_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_OPTD_MDCR_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_OPTD_MDCR_PRTE_F b
        where a.elig_optd_mdcr_prte_id = b.elig_optd_mdcr_prte_id);

Line: 1329

  select a.elig_org_unit_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ORG_UNIT_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_ORG_UNIT_PRTE_F b
        where a.elig_org_unit_prte_id = b.elig_org_unit_prte_id);

Line: 1337

  select a.elig_othr_ptip_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_OTHR_PTIP_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_OTHR_PTIP_PRTE_F b
        where a.elig_othr_ptip_prte_id = b.elig_othr_ptip_prte_id);

Line: 1345

  select a.elig_dpnt_othr_ptip_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DPNT_OTHR_PTIP_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_DPNT_OTHR_PTIP_F b
        where a.elig_dpnt_othr_ptip_id = b.elig_dpnt_othr_ptip_id);

Line: 1353

  select a.elig_pct_fl_tm_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PCT_FL_TM_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PCT_FL_TM_PRTE_F b
        where a.elig_pct_fl_tm_prte_id = b.elig_pct_fl_tm_prte_id);

Line: 1361

  select a.elig_per_typ_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PER_TYP_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PER_TYP_PRTE_F b
        where a.elig_per_typ_prte_id = b.elig_per_typ_prte_id);

Line: 1369

  select a.elig_ppl_grp_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PPL_GRP_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PPL_GRP_PRTE_F b
        where a.elig_ppl_grp_prte_id = b.elig_ppl_grp_prte_id);

Line: 1377

  select a.elig_prtt_anthr_pl_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F b
        where a.elig_prtt_anthr_pl_prte_id = b.elig_prtt_anthr_pl_prte_id);

Line: 1385

  select a.elig_pstl_cd_r_rng_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PSTL_CD_R_RNG_PRTE_F b
        where a.elig_pstl_cd_r_rng_prte_id = b.elig_pstl_cd_r_rng_prte_id);

Line: 1393

  select a.elig_pyrl_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PYRL_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PYRL_PRTE_F b
        where a.elig_pyrl_prte_id = b.elig_pyrl_prte_id);

Line: 1401

  select a.elig_py_bss_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PY_BSS_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_PY_BSS_PRTE_F b
        where a.elig_py_bss_prte_id = b.elig_py_bss_prte_id);

Line: 1409

  select a.elig_schedd_hrs_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_SCHEDD_HRS_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_SCHEDD_HRS_PRTE_F b
        where a.elig_schedd_hrs_prte_id = b.elig_schedd_hrs_prte_id);

Line: 1417

  select a.elig_svc_area_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_SVC_AREA_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_SVC_AREA_PRTE_F b
        where a.elig_svc_area_prte_id = b.elig_svc_area_prte_id);

Line: 1425

  select a.elig_wk_loc_prte_id, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_WK_LOC_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_ELIG_WK_LOC_PRTE_F b
        where a.elig_wk_loc_prte_id = b.elig_wk_loc_prte_id);

Line: 1433

  select a.prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
  from BEN_PRTN_ELIG_PRFL_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_PRTN_ELIG_PRFL_F b
        where a.prtn_elig_prfl_id = b.prtn_elig_prfl_id);

Line: 1442

  select a.cntng_prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
  from BEN_CNTNG_PRTN_ELIG_PRFL_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and a.effective_end_date = (select max(b.effective_end_date)
        from BEN_CNTNG_PRTN_ELIG_PRFL_F b
        where a.cntng_prtn_elig_prfl_id = b.cntng_prtn_elig_prfl_id);

Line: 1452

  select a.ELIG_GNDR_PRTE_ID, a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_GNDR_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1459

  select a.ELIG_MRTL_STS_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_MRTL_STS_PRTE_F a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1465

  select a.ELIG_DSBLTY_CTG_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DSBLTY_CTG_PRTE_f a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1471

  select a.ELIG_DSBLTY_RSN_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DSBLTY_RSN_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1477

  select a.ELIG_DSBLTY_DGR_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DSBLTY_DGR_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1483

  select a.ELIG_Suppl_role_prte_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_Suppl_role_prte_f  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1489

  select a.ELIG_qual_titl_prte_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_qual_titl_prte_f  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1496

  select a.ELIG_pstn_prte_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_pstn_prte_f  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1502

  select a.ELIG_prbtn_perd_prte_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_prbtn_perd_prte_f  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1508

  select a.ELIG_sp_clng_prg_prte_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_sp_clng_prg_prte_f  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1514

  select a.ELIG_DSBLD_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_DSBLD_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1520

  select a.ELIG_TTL_CVG_VOL_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_TTL_CVG_VOL_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1526

  select a.ELIG_TTL_PRTT_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_TTL_PRTT_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1532

  select a.ELIG_ANTHR_PL_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_ANTHR_PL_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1538

  select a.ELIG_HLTH_CVG_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_HLTH_CVG_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1544

  select a.ELIG_COMPTNCY_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_COMPTNCY_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1550

  select a.ELIG_QUA_IN_GR_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_QUA_IN_GR_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1556

  select a.ELIG_PERF_RTNG_PRTE_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIG_PERF_RTNG_PRTE_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1564

  select a.ELIGY_CRIT_VALUES_ID , a.object_version_number, a.effective_end_date eed
  from BEN_ELIGY_CRIT_VALUES_F  a
  where a.eligy_prfl_id = p_eligy_prfl_id
    and p_effective_date between   a.effective_start_date and a.effective_end_date ;

Line: 1586

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1592

         ben_ELIGY_PROFILE_RULE_api.delete_ELIGY_PROFILE_RULE
         (p_validate                       => false
         ,p_eligy_prfl_rl_id               => l_row.eligy_prfl_rl_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1603

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1609

         ben_ELIG_AGE_PRTE_api.delete_ELIG_AGE_PRTE
         (p_validate                       => false
         ,p_elig_age_prte_id               => l_row.elig_age_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1620

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1626

         BEN_ELIG_ASNT_SET_PRTE_api.delete_ELIG_ASNT_SET_PRTE
         (p_validate                       => false
         ,p_elig_asnt_set_prte_id          => l_row.elig_asnt_set_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1637

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1643

         BEN_ELIG_BENFTS_GRP_PRTE_api.delete_ELIG_BENFTS_GRP_PRTE
         (p_validate                       => false
         ,p_elig_benfts_grp_prte_id        => l_row.elig_benfts_grp_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1654

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1660

         BEN_ELIG_BRGNG_UNIT_PRTE_api.delete_ELIG_BRGNG_UNIT_PRTE
         (p_validate                       => false
         ,p_elig_brgng_unit_prte_id        => l_row.elig_brgng_unit_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1671

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1677

         BEN_ELIG_CBR_QUALD_BNF_api.delete_ELIG_CBR_QUALD_BNF
         (p_validate                       => false
         ,p_elig_cbr_quald_bnf_id          => l_row.elig_cbr_quald_bnf_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1688

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1694

         ben_ELIG_CMBN_AGE_LOS_api.delete_ELIG_CMBN_AGE_LOS
         (p_validate                       => false
         ,p_elig_cmbn_age_los_prte_id      => l_row.elig_cmbn_age_los_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1705

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1711

         BEN_ELIG_COMP_LVL_PRTE_api.delete_ELIG_COMP_LVL_PRTE
         (p_validate                       => false
         ,p_elig_comp_lvl_prte_id          => l_row.elig_comp_lvl_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1722

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1728

         ben_ELIG_DPNT_CVRD_O_PGM_api.delete_ELIG_DPNT_CVRD_O_PGM
         (p_validate                       => false
         ,p_elig_dpnt_cvrd_othr_pgm_id     => l_row.elig_dpnt_cvrd_othr_pgm_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1739

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1745

         ben_ELIG_DPNT_CVD_OTHR_PL_api.delete_ELIG_DPNT_CVD_OTHR_PL
         (p_validate                       => false
         ,p_elig_dpnt_cvrd_othr_pl_id      => l_row.elig_dpnt_cvrd_othr_pl_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1756

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1762

         ben_ELIG_DPNT_CVRD_O_PTIP_api.delete_ELIG_DPNT_CVRD_O_PTIP
         (p_validate                       => false
         ,p_elig_dpnt_cvrd_othr_ptip_id     => l_row.elig_dpnt_cvrd_othr_ptip_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1773

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1779

         ben_ELIG_DPNT_CVRD_PLIP_api.delete_ELIG_DPNT_CVRD_PLIP
         (p_validate                       => false
         ,p_elig_dpnt_cvrd_plip_id         => l_row.elig_dpnt_cvrd_plip_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1790

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1796

         BEN_ELIG_EE_STAT_PRTE_api.delete_ELIG_EE_STAT_PRTE
         (p_validate                       => false
         ,p_elig_ee_stat_prte_id           => l_row.elig_ee_stat_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1807

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1813

         BEN_ELIG_ENRLD_ANTHR_OIPL_api.delete_ELIG_ENRLD_ANTHR_OIPL
         (p_validate                       => false
         ,p_elig_enrld_anthr_oipl_id       => l_row.elig_enrld_anthr_oipl_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1824

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1830

         BEN_ELIG_ENRLD_ANTHR_PGM_api.delete_ELIG_ENRLD_ANTHR_PGM
         (p_validate                       => false
         ,p_elig_enrld_anthr_pgm_id        => l_row.elig_enrld_anthr_pgm_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1841

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1847

         BEN_ELIG_ENRLD_ANTHR_PLIP_api.delete_ELIG_ENRLD_ANTHR_PLIP
         (p_validate                       => false
         ,p_elig_enrld_anthr_plip_id       => l_row.elig_enrld_anthr_plip_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1858

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1864

         BEN_ELIG_ENRLD_ANTHR_PL_api.delete_ELIG_ENRLD_ANTHR_PL
         (p_validate                       => false
         ,p_elig_enrld_anthr_pl_id         => l_row.elig_enrld_anthr_pl_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1875

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1881

         BEN_ELIG_ENRLD_ANTHR_PTIP_api.delete_ELIG_ENRLD_ANTHR_PTIP
         (p_validate                       => false
         ,p_elig_enrld_anthr_ptip_id       => l_row.elig_enrld_anthr_ptip_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1892

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1898

         BEN_ELIG_FL_TM_PT_TM_PRTE_api.delete_ELIG_FL_TM_PT_TM_PRTE
         (p_validate                       => false
         ,p_elig_fl_tm_pt_tm_prte_id         => l_row.elig_fl_tm_pt_tm_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1909

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1915

         BEN_ELIG_GRD_PRTE_api.delete_ELIG_GRD_PRTE
         (p_validate                       => false
         ,p_elig_grd_prte_id                 => l_row.elig_grd_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1926

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1932

         BEN_ELIG_HRLY_SLRD_PRTE_api.delete_ELIG_HRLY_SLRD_PRTE
         (p_validate                       => false
         ,p_elig_hrly_slrd_prte_id           => l_row.elig_hrly_slrd_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1943

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1949

         BEN_ELIG_HRS_WKD_PRTE_api.delete_ELIG_HRS_WKD_PRTE
         (p_validate                       => false
         ,p_elig_hrs_wkd_prte_id       => l_row.elig_hrs_wkd_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1960

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1966

         ben_ELIGY_JOB_PRTE_api.delete_ELIGY_JOB_PRTE
         (p_validate                       => false
         ,p_elig_job_prte_id               => l_row.elig_job_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1977

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 1983

         BEN_ELIG_LBR_MMBR_PRTE_api.delete_ELIG_LBR_MMBR_PRTE
         (p_validate                       => false
         ,p_elig_lbr_mmbr_prte_id          => l_row.elig_lbr_mmbr_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 1994

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2000

         BEN_ELIG_LGL_ENTY_PRTE_api.delete_ELIG_LGL_ENTY_PRTE
         (p_validate                       => false
         ,p_elig_lgl_enty_prte_id          => l_row.elig_lgl_enty_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2011

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2017

         BEN_ELIG_LOA_RSN_PRTE_api.delete_ELIG_LOA_RSN_PRTE
         (p_validate                       => false
         ,p_elig_loa_rsn_prte_id               => l_row.elig_loa_rsn_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2028

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2034

         BEN_ELIG_LOS_PRTE_api.delete_ELIG_LOS_PRTE
         (p_validate                       => false
         ,p_elig_los_prte_id               => l_row.elig_los_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2045

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2051

         BEN_ELIG_LVG_RSN_PRTE_api.delete_ELIG_LVG_RSN_PRTE
         (p_validate                       => false
         ,p_elig_lvg_rsn_prte_id           => l_row.elig_lvg_rsn_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2062

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2068

         BEN_ELIG_NO_OTHR_CVG_PRTE_api.delete_ELIG_NO_OTHR_CVG_PRTE
         (p_validate                       => false
         ,p_elig_no_othr_cvg_prte_id       => l_row.elig_no_othr_cvg_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2079

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2085

         BEN_ELIG_OPTD_MDCR_PRTE_api.delete_ELIG_OPTD_MDCR_PRTE
         (p_validate                       => false
         ,p_elig_optd_mdcr_prte_id         => l_row.elig_optd_mdcr_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2096

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2102

         BEN_ELIG_ORG_UNIT_PRTE_api.delete_ELIG_ORG_UNIT_PRTE
         (p_validate                       => false
         ,p_elig_org_unit_prte_id          => l_row.elig_org_unit_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2113

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2119

         BEN_ELIG_OTHR_PTIP_PRTE_api.delete_ELIG_OTHR_PTIP_PRTE
         (p_validate                       => false
         ,p_elig_othr_ptip_prte_id         => l_row.elig_othr_ptip_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2130

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2136

         BEN_ELIG_DPNT_OTHR_PTIP_api.delete_ELIG_DPNT_OTHR_PTIP
         (p_validate                       => false
         ,p_elig_dpnt_othr_ptip_id         => l_row.elig_dpnt_othr_ptip_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2147

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2153

         BEN_ELIG_PCT_FL_TM_PRTE_api.delete_ELIG_PCT_FL_TM_PRTE
         (p_validate                       => false
         ,p_elig_pct_fl_tm_prte_id         => l_row.elig_pct_fl_tm_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2164

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2170

         BEN_ELIG_PER_TYP_PRTE_api.delete_ELIG_PER_TYP_PRTE
         (p_validate                       => false
         ,p_elig_per_typ_prte_id           => l_row.elig_per_typ_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2181

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2187

         BEN_ELIG_PPL_GRP_PRTE_api.delete_ELIG_PPL_GRP_PRTE
         (p_validate                       => false
         ,p_elig_ppl_grp_prte_id           => l_row.elig_ppl_grp_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2198

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2204

         ben_ELG_PRT_ANTHR_PL_PT_api.delete_ELG_PRT_ANTHR_PL_PT
         (p_validate                       => false
         ,p_elig_prtt_anthr_pl_prte_id     => l_row.elig_prtt_anthr_pl_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2215

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2221

         ben_ELIG_PSTL_CD_RNG_PRTE_api.delete_ELIG_PSTL_CD_RNG_PRTE
         (p_validate                       => false
         ,p_elig_pstl_cd_r_rng_prte_id     => l_row.elig_pstl_cd_r_rng_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2232

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2238

         BEN_ELIG_PYRL_PRTE_api.delete_ELIG_PYRL_PRTE
         (p_validate                       => false
         ,p_elig_pyrl_prte_id              => l_row.elig_pyrl_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2249

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2255

         BEN_ELIG_PY_BSS_PRTE_api.delete_ELIG_PY_BSS_PRTE
         (p_validate                       => false
         ,p_elig_py_bss_prte_id            => l_row.elig_py_bss_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2266

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2272

         BEN_ELIG_SCHEDD_HRS_PRTE_api.delete_ELIG_SCHEDD_HRS_PRTE
         (p_validate                       => false
         ,p_elig_schedd_hrs_prte_id        => l_row.elig_schedd_hrs_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2283

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2289

         BEN_ELIG_SVC_AREA_PRTE_api.delete_ELIG_SVC_AREA_PRTE
         (p_validate                       => false
         ,p_elig_svc_area_prte_id          => l_row.elig_svc_area_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2300

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2306

         BEN_ELIG_WK_LOC_PRTE_api.delete_ELIG_WK_LOC_PRTE
         (p_validate                       => false
         ,p_elig_wk_loc_prte_id            => l_row.elig_wk_loc_prte_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2317

      if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2323

         BEN_PRTN_ELIG_PRFL_api.delete_PRTN_ELIG_PRFL
         (p_validate                       => false
         ,p_prtn_elig_prfl_id              => l_row.prtn_elig_prfl_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2335

         if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
         or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2341

         BEN_CNTNG_PRTN_ELIG_PRFL_api.delete_CNTNG_PRTN_ELIG_PRFL
         (p_validate                       => false
         ,p_cntng_prtn_elig_prfl_id              => l_row.cntng_prtn_elig_prfl_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => l_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2354

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2361

         BEN_ELIG_GNDR_PRTE_api.delete_ELIG_GNDR_PRTE
         (p_validate                       => false
         ,p_ELIG_GNDR_PRTE_ID         => l_row.ELIG_GNDR_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2374

         BEN_ELIG_MRTL_STS_PRTE_api.delete_ELIG_MRTL_STS_PRTE
         (p_validate                       => false
         ,p_ELIG_MRTL_STS_PRTE_ID          => l_row.ELIG_MRTL_STS_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2385

         BEN_ELIG_DSBLTY_CTG_PRTE_api.delete_ELIG_DSBLTY_CTG_PRTE
         (p_validate                       => false
         ,p_ELIG_DSBLTY_CTG_PRTE_ID        => l_row.ELIG_DSBLTY_CTG_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2397

         BEN_ELIG_DSBLTY_RSN_PRTE_api.delete_ELIG_DSBLTY_RSN_PRTE
         (p_validate                       => false
         ,p_ELIG_DSBLTY_RSN_PRTE_ID        => l_row.ELIG_DSBLTY_RSN_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2408

         BEN_ELIG_DSBLTY_DGR_PRTE_api.delete_ELIG_DSBLTY_DGR_PRTE
         (p_validate                       => false
         ,p_ELIG_DSBLTY_DGR_PRTE_ID        => l_row.ELIG_DSBLTY_DGR_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2420

         BEN_ELIG_DSBLTY_DGR_PRTE_api.delete_ELIG_DSBLTY_DGR_PRTE
         (p_validate                       => false
         ,p_ELIG_DSBLTY_DGR_PRTE_ID        => l_row.ELIG_DSBLTY_DGR_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2431

         BEN_ELIG_Suppl_role_prte_api.delete_ELIG_Suppl_role_prte
         (p_validate                       => false
         ,p_ELIG_Suppl_role_prte_ID        => l_row.ELIG_Suppl_role_prte_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2443

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2450

         BEN_ELIG_qual_titl_prte_api.delete_ELIG_qual_titl_prte
         (p_validate                       => false
         ,p_ELIG_qual_titl_prte_ID          => l_row.ELIG_qual_titl_prte_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2462

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2469

         BEN_ELIG_pstn_prte_api.delete_ELIG_pstn_prte
         (p_validate                       => false
         ,p_ELIG_pstn_prte_ID              => l_row.ELIG_pstn_prte_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2481

         BEN_ELIG_prbtn_perd_prte_api.delete_ELIG_prbtn_perd_prte
         (p_validate                       => false
         ,p_ELIG_prbtn_perd_prte_ID        => l_row.ELIG_prbtn_perd_prte_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2492

         BEN_ELIG_sp_clng_prg_prte_api.delete_ELIG_sp_clng_prg_prte
         (p_validate                       => false
         ,p_ELIG_sp_clng_prg_prte_ID       => l_row.ELIG_sp_clng_prg_prte_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2503

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2510

         BEN_ELIG_DSBLD_PRTE_api.delete_ELIG_DSBLD_PRTE
         (p_validate                       => false
         ,p_ELIG_DSBLD_PRTE_ID             => l_row.ELIG_DSBLD_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2522

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2529

         BEN_ELIG_TTL_CVG_VOL_PRTE_api.delete_ELIG_TTL_CVG_VOL_PRTE
         (p_validate                       => false
         ,p_ELIG_TTL_CVG_VOL_PRTE_ID       => l_row.ELIG_TTL_CVG_VOL_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2541

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2548

         BEN_ELIG_TTL_PRTT_PRTE_api.delete_ELIG_TTL_PRTT_PRTE
         (p_validate                       => false
         ,p_ELIG_TTL_PRTT_PRTE_ID          => l_row.ELIG_TTL_PRTT_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2560

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2567

         BEN_ELIG_ANTHR_PL_PRTE_api.delete_ELIG_ANTHR_PL_PRTE
         (p_validate                       => false
         ,p_ELIG_ANTHR_PL_PRTE_ID          => l_row.ELIG_ANTHR_PL_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2579

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2586

         BEN_ELIG_HLTH_CVG_PRTE_api.delete_ELIG_HLTH_CVG_PRTE
         (p_validate                       => false
         ,p_ELIG_HLTH_CVG_PRTE_ID          => l_row.ELIG_HLTH_CVG_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2598

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2605

         BEN_ELIG_COMPTNCY_PRTE_api.delete_ELIG_COMPTNCY_PRTE
         (p_validate                       => false
         ,p_ELIG_COMPTNCY_PRTE_ID          => l_row.ELIG_COMPTNCY_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2617

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2624

         BEN_ELIG_QUA_IN_GR_PRTE_api.delete_ELIG_QUA_IN_GR_PRTE
         (p_validate                       => false
         ,p_ELIG_QUA_IN_GR_PRTE_ID         => l_row.ELIG_QUA_IN_GR_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2636

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2643

         BEN_ELIG_PERF_RTNG_PRTE_api.delete_ELIG_PERF_RTNG_PRTE
         (p_validate                       => false
         ,p_ELIG_PERF_RTNG_PRTE_ID         => l_row.ELIG_PERF_RTNG_PRTE_ID
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2658

     if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
            or p_datetrack_mode <> hr_api.g_delete then
         if p_datetrack_mode = hr_api.g_zap then
            l_effective_date := l_row.eed;

Line: 2665

         ben_eligy_crit_values_api.delete_eligy_crit_values
         (p_validate                       => false
         ,p_eligy_crit_values_id           => l_row.eligy_crit_values_id
         ,p_effective_start_date           => l_effective_start_date
         ,p_effective_end_date             => l_effective_end_date
         ,p_object_version_number          => l_row.object_version_number
         ,p_effective_date                 => p_effective_date
         ,p_datetrack_mode                 => p_datetrack_mode);

Line: 2679

end delete_children;

Line: 2684

procedure delete_ELIGY_PROFILE
  (p_validate                       in  boolean  default false
  ,p_eligy_prfl_id                  in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ELIGY_PROFILE';

Line: 2706

  savepoint delete_ELIGY_PROFILE;

Line: 2719

    ben_ELIGY_PROFILE_bk3.delete_ELIGY_PROFILE_b
      (p_eligy_prfl_id                  =>  p_eligy_prfl_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 2730

        (p_module_name => 'DELETE_ELIGY_PROFILE'
        ,p_hook_type   => 'BP');

Line: 2737

  delete_children
    (p_eligy_prfl_id                 => p_eligy_prfl_id
    ,p_effective_date                => p_effective_date
    ,p_datetrack_mode                => p_datetrack_mode);

Line: 2754

    ben_ELIGY_PROFILE_bk3.delete_ELIGY_PROFILE_a
      (p_eligy_prfl_id                  =>  p_eligy_prfl_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode);

Line: 2767

        (p_module_name => 'DELETE_ELIGY_PROFILE'
        ,p_hook_type   => 'AP');

Line: 2791

    ROLLBACK TO delete_ELIGY_PROFILE;

Line: 2808

    ROLLBACK TO delete_ELIGY_PROFILE;

Line: 2811

end delete_ELIGY_PROFILE;