[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure update_dml(p_rec in out nocopy ben_epe_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'update_dml';
update ben_elig_per_elctbl_chc
set
elig_per_elctbl_chc_id = p_rec.elig_per_elctbl_chc_id,
-- enrt_typ_cycl_cd = p_rec.enrt_typ_cycl_cd,
enrt_cvg_strt_dt_cd = p_rec.enrt_cvg_strt_dt_cd,
-- enrt_perd_end_dt = p_rec.enrt_perd_end_dt,
-- enrt_perd_strt_dt = p_rec.enrt_perd_strt_dt,
enrt_cvg_strt_dt_rl = p_rec.enrt_cvg_strt_dt_rl,
-- rt_strt_dt = p_rec.rt_strt_dt,
-- rt_strt_dt_rl = p_rec.rt_strt_dt_rl,
-- rt_strt_dt_cd = p_rec.rt_strt_dt_cd,
ctfn_rqd_flag = p_rec.ctfn_rqd_flag,
pil_elctbl_chc_popl_id = p_rec.pil_elctbl_chc_popl_id,
roll_crs_flag = p_rec.roll_crs_flag,
crntly_enrd_flag = p_rec.crntly_enrd_flag,
dflt_flag = p_rec.dflt_flag,
elctbl_flag = p_rec.elctbl_flag,
mndtry_flag = p_rec.mndtry_flag,
in_pndg_wkflow_flag = p_rec.in_pndg_wkflow_flag,
-- dflt_enrt_dt = p_rec.dflt_enrt_dt,
dpnt_cvg_strt_dt_cd = p_rec.dpnt_cvg_strt_dt_cd,
dpnt_cvg_strt_dt_rl = p_rec.dpnt_cvg_strt_dt_rl,
enrt_cvg_strt_dt = p_rec.enrt_cvg_strt_dt,
alws_dpnt_dsgn_flag = p_rec.alws_dpnt_dsgn_flag,
dpnt_dsgn_cd = p_rec.dpnt_dsgn_cd,
ler_chg_dpnt_cvg_cd = p_rec.ler_chg_dpnt_cvg_cd,
erlst_deenrt_dt = p_rec.erlst_deenrt_dt,
procg_end_dt = p_rec.procg_end_dt,
comp_lvl_cd = p_rec.comp_lvl_cd,
pl_id = p_rec.pl_id,
oipl_id = p_rec.oipl_id,
pgm_id = p_rec.pgm_id,
plip_id = p_rec.plip_id,
ptip_id = p_rec.ptip_id,
pl_typ_id = p_rec.pl_typ_id,
oiplip_id = p_rec.oiplip_id,
cmbn_plip_id = p_rec.cmbn_plip_id,
cmbn_ptip_id = p_rec.cmbn_ptip_id,
cmbn_ptip_opt_id = p_rec.cmbn_ptip_opt_id,
assignment_id = p_rec.assignment_id,
spcl_rt_pl_id = p_rec.spcl_rt_pl_id,
spcl_rt_oipl_id = p_rec.spcl_rt_oipl_id,
must_enrl_anthr_pl_id = p_rec.must_enrl_anthr_pl_id,
interim_elig_per_elctbl_chc_id = p_rec.int_elig_per_elctbl_chc_id,
prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id,
bnft_prvdr_pool_id = p_rec.bnft_prvdr_pool_id,
per_in_ler_id = p_rec.per_in_ler_id,
yr_perd_id = p_rec.yr_perd_id,
auto_enrt_flag = p_rec.auto_enrt_flag,
business_group_id = p_rec.business_group_id,
pl_ordr_num = p_rec.pl_ordr_num,
plip_ordr_num = p_rec.plip_ordr_num,
ptip_ordr_num = p_rec.ptip_ordr_num,
oipl_ordr_num = p_rec.oipl_ordr_num,
-- cwb
comments = p_rec.comments,
elig_flag = p_rec.elig_flag,
elig_ovrid_dt = p_rec.elig_ovrid_dt,
elig_ovrid_person_id = p_rec.elig_ovrid_person_id,
inelig_rsn_cd = p_rec.inelig_rsn_cd,
mgr_ovrid_dt = p_rec.mgr_ovrid_dt,
mgr_ovrid_person_id = p_rec.mgr_ovrid_person_id,
ws_mgr_id = p_rec.ws_mgr_id,
-- cwb
epe_attribute_category = p_rec.epe_attribute_category,
epe_attribute1 = p_rec.epe_attribute1,
epe_attribute2 = p_rec.epe_attribute2,
epe_attribute3 = p_rec.epe_attribute3,
epe_attribute4 = p_rec.epe_attribute4,
epe_attribute5 = p_rec.epe_attribute5,
epe_attribute6 = p_rec.epe_attribute6,
epe_attribute7 = p_rec.epe_attribute7,
epe_attribute8 = p_rec.epe_attribute8,
epe_attribute9 = p_rec.epe_attribute9,
epe_attribute10 = p_rec.epe_attribute10,
epe_attribute11 = p_rec.epe_attribute11,
epe_attribute12 = p_rec.epe_attribute12,
epe_attribute13 = p_rec.epe_attribute13,
epe_attribute14 = p_rec.epe_attribute14,
epe_attribute15 = p_rec.epe_attribute15,
epe_attribute16 = p_rec.epe_attribute16,
epe_attribute17 = p_rec.epe_attribute17,
epe_attribute18 = p_rec.epe_attribute18,
epe_attribute19 = p_rec.epe_attribute19,
epe_attribute20 = p_rec.epe_attribute20,
epe_attribute21 = p_rec.epe_attribute21,
epe_attribute22 = p_rec.epe_attribute22,
epe_attribute23 = p_rec.epe_attribute23,
epe_attribute24 = p_rec.epe_attribute24,
epe_attribute25 = p_rec.epe_attribute25,
epe_attribute26 = p_rec.epe_attribute26,
epe_attribute27 = p_rec.epe_attribute27,
epe_attribute28 = p_rec.epe_attribute28,
epe_attribute29 = p_rec.epe_attribute29,
epe_attribute30 = p_rec.epe_attribute30,
approval_status_cd = p_rec.approval_status_cd,
fonm_cvg_strt_dt = p_rec.fonm_cvg_strt_dt,
cryfwd_elig_dpnt_cd = p_rec.cryfwd_elig_dpnt_cd,
request_id = p_rec.request_id,
program_application_id = p_rec.program_application_id,
program_id = p_rec.program_id,
program_update_date = p_rec.program_update_date,
object_version_number = p_rec.object_version_number
where elig_per_elctbl_chc_id = p_rec.elig_per_elctbl_chc_id;
End update_dml;
Procedure pre_update(p_rec in ben_epe_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_update';
End pre_update;
Procedure post_update(p_rec in ben_epe_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_update';
End post_update;
If (p_rec.program_update_date = hr_api.g_date) then
p_rec.program_update_date :=
ben_epe_shd.g_old_rec.program_update_date;
ben_epe_bus.update_validate(p_rec,p_effective_date);
pre_update(p_rec);
update_dml(p_rec);
post_update(p_rec);
p_program_update_date in date default hr_api.g_date,
p_object_version_number in out nocopy number
) is
--
l_rec ben_epe_shd.g_rec_type;
p_program_update_date,
p_object_version_number
);