[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_dml
(p_rec in out nocopy ben_pep_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'dt_update_dml';
update ben_elig_per_f
set
elig_per_id = p_rec.elig_per_id,
business_group_id = p_rec.business_group_id,
pl_id = p_rec.pl_id,
pgm_id = p_rec.pgm_id,
plip_id = p_rec.plip_id,
ptip_id = p_rec.ptip_id,
ler_id = p_rec.ler_id,
person_id = p_rec.person_id,
per_in_ler_id = p_rec.per_in_ler_id,
dpnt_othr_pl_cvrd_rl_flag = p_rec.dpnt_othr_pl_cvrd_rl_flag,
prtn_ovridn_thru_dt = p_rec.prtn_ovridn_thru_dt,
pl_key_ee_flag = p_rec.pl_key_ee_flag,
pl_hghly_compd_flag = p_rec.pl_hghly_compd_flag,
elig_flag = p_rec.elig_flag,
comp_ref_amt = p_rec.comp_ref_amt,
cmbn_age_n_los_val = p_rec.cmbn_age_n_los_val,
comp_ref_uom = p_rec.comp_ref_uom,
age_val = p_rec.age_val,
los_val = p_rec.los_val,
prtn_end_dt = p_rec.prtn_end_dt,
prtn_strt_dt = p_rec.prtn_strt_dt,
wait_perd_cmpltn_dt = p_rec.wait_perd_cmpltn_dt,
wait_perd_strt_dt = p_rec.wait_perd_strt_dt,
wv_ctfn_typ_cd = p_rec.wv_ctfn_typ_cd,
hrs_wkd_val = p_rec.hrs_wkd_val,
hrs_wkd_bndry_perd_cd = p_rec.hrs_wkd_bndry_perd_cd,
prtn_ovridn_flag = p_rec.prtn_ovridn_flag,
no_mx_prtn_ovrid_thru_flag = p_rec.no_mx_prtn_ovrid_thru_flag,
prtn_ovridn_rsn_cd = p_rec.prtn_ovridn_rsn_cd,
age_uom = p_rec.age_uom,
los_uom = p_rec.los_uom,
ovrid_svc_dt = p_rec.ovrid_svc_dt,
inelg_rsn_cd = p_rec.inelg_rsn_cd,
frz_los_flag = p_rec.frz_los_flag,
frz_age_flag = p_rec.frz_age_flag,
frz_cmp_lvl_flag = p_rec.frz_cmp_lvl_flag,
frz_pct_fl_tm_flag = p_rec.frz_pct_fl_tm_flag,
frz_hrs_wkd_flag = p_rec.frz_hrs_wkd_flag,
frz_comb_age_and_los_flag = p_rec.frz_comb_age_and_los_flag,
dstr_rstcn_flag = p_rec.dstr_rstcn_flag,
pct_fl_tm_val = p_rec.pct_fl_tm_val,
wv_prtn_rsn_cd = p_rec.wv_prtn_rsn_cd,
pl_wvd_flag = p_rec.pl_wvd_flag,
rt_comp_ref_amt = p_rec.rt_comp_ref_amt,
rt_cmbn_age_n_los_val = p_rec.rt_cmbn_age_n_los_val,
rt_comp_ref_uom = p_rec.rt_comp_ref_uom,
rt_age_val = p_rec.rt_age_val,
rt_los_val = p_rec.rt_los_val,
rt_hrs_wkd_val = p_rec.rt_hrs_wkd_val,
rt_hrs_wkd_bndry_perd_cd = p_rec.rt_hrs_wkd_bndry_perd_cd,
rt_age_uom = p_rec.rt_age_uom,
rt_los_uom = p_rec.rt_los_uom,
rt_pct_fl_tm_val = p_rec.rt_pct_fl_tm_val,
rt_frz_los_flag = p_rec.rt_frz_los_flag,
rt_frz_age_flag = p_rec.rt_frz_age_flag,
rt_frz_cmp_lvl_flag = p_rec.rt_frz_cmp_lvl_flag,
rt_frz_pct_fl_tm_flag = p_rec.rt_frz_pct_fl_tm_flag,
rt_frz_hrs_wkd_flag = p_rec.rt_frz_hrs_wkd_flag,
rt_frz_comb_age_and_los_flag = p_rec.rt_frz_comb_age_and_los_flag,
once_r_cntug_cd = p_rec.once_r_cntug_cd,
pl_ordr_num = p_rec.pl_ordr_num,
plip_ordr_num = p_rec.plip_ordr_num,
ptip_ordr_num = p_rec.ptip_ordr_num,
pep_attribute_category = p_rec.pep_attribute_category,
pep_attribute1 = p_rec.pep_attribute1,
pep_attribute2 = p_rec.pep_attribute2,
pep_attribute3 = p_rec.pep_attribute3,
pep_attribute4 = p_rec.pep_attribute4,
pep_attribute5 = p_rec.pep_attribute5,
pep_attribute6 = p_rec.pep_attribute6,
pep_attribute7 = p_rec.pep_attribute7,
pep_attribute8 = p_rec.pep_attribute8,
pep_attribute9 = p_rec.pep_attribute9,
pep_attribute10 = p_rec.pep_attribute10,
pep_attribute11 = p_rec.pep_attribute11,
pep_attribute12 = p_rec.pep_attribute12,
pep_attribute13 = p_rec.pep_attribute13,
pep_attribute14 = p_rec.pep_attribute14,
pep_attribute15 = p_rec.pep_attribute15,
pep_attribute16 = p_rec.pep_attribute16,
pep_attribute17 = p_rec.pep_attribute17,
pep_attribute18 = p_rec.pep_attribute18,
pep_attribute19 = p_rec.pep_attribute19,
pep_attribute20 = p_rec.pep_attribute20,
pep_attribute21 = p_rec.pep_attribute21,
pep_attribute22 = p_rec.pep_attribute22,
pep_attribute23 = p_rec.pep_attribute23,
pep_attribute24 = p_rec.pep_attribute24,
pep_attribute25 = p_rec.pep_attribute25,
pep_attribute26 = p_rec.pep_attribute26,
pep_attribute27 = p_rec.pep_attribute27,
pep_attribute28 = p_rec.pep_attribute28,
pep_attribute29 = p_rec.pep_attribute29,
pep_attribute30 = p_rec.pep_attribute30,
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_id = p_rec.elig_per_id
and effective_start_date = p_validation_start_date
and effective_end_date = p_validation_end_date;
End dt_update_dml;
Procedure update_dml
(p_rec in out nocopy ben_pep_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'update_dml';
dt_update_dml(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End update_dml;
Procedure dt_pre_update
(p_rec in out nocopy ben_pep_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'dt_pre_update';
If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
hr_utility.set_location(l_proc, 15);
ben_pep_del.delete_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
ben_pep_ins.insert_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End dt_pre_update;
Procedure pre_update
(p_rec in out nocopy ben_pep_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'pre_update';
dt_pre_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End pre_update;
Procedure post_update
(p_rec in ben_pep_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'post_update';
ben_pep_rku.after_update
(
p_elig_per_id => p_rec.elig_per_id,
p_effective_start_date => p_rec.effective_start_date,
p_effective_end_date => p_rec.effective_end_date,
p_business_group_id => p_rec.business_group_id,
p_pl_id => p_rec.pl_id,
p_pgm_id => p_rec.pgm_id,
p_plip_id => p_rec.plip_id,
p_ptip_id => p_rec.ptip_id,
p_ler_id => p_rec.ler_id,
p_person_id => p_rec.person_id,
p_per_in_ler_id => p_rec.per_in_ler_id,
p_dpnt_othr_pl_cvrd_rl_flag => p_rec.dpnt_othr_pl_cvrd_rl_flag,
p_prtn_ovridn_thru_dt => p_rec.prtn_ovridn_thru_dt,
p_pl_key_ee_flag => p_rec.pl_key_ee_flag,
p_pl_hghly_compd_flag => p_rec.pl_hghly_compd_flag,
p_elig_flag => p_rec.elig_flag,
p_comp_ref_amt => p_rec.comp_ref_amt,
p_cmbn_age_n_los_val => p_rec.cmbn_age_n_los_val,
p_comp_ref_uom => p_rec.comp_ref_uom,
p_age_val => p_rec.age_val,
p_los_val => p_rec.los_val,
p_prtn_end_dt => p_rec.prtn_end_dt,
p_prtn_strt_dt => p_rec.prtn_strt_dt,
p_wait_perd_cmpltn_dt => p_rec.wait_perd_cmpltn_dt,
p_wait_perd_strt_dt => p_rec.wait_perd_strt_dt,
p_wv_ctfn_typ_cd => p_rec.wv_ctfn_typ_cd,
p_hrs_wkd_val => p_rec.hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => p_rec.hrs_wkd_bndry_perd_cd,
p_prtn_ovridn_flag => p_rec.prtn_ovridn_flag,
p_no_mx_prtn_ovrid_thru_flag => p_rec.no_mx_prtn_ovrid_thru_flag,
p_prtn_ovridn_rsn_cd => p_rec.prtn_ovridn_rsn_cd,
p_age_uom => p_rec.age_uom,
p_los_uom => p_rec.los_uom,
p_ovrid_svc_dt => p_rec.ovrid_svc_dt,
p_inelg_rsn_cd => p_rec.inelg_rsn_cd,
p_frz_los_flag => p_rec.frz_los_flag,
p_frz_age_flag => p_rec.frz_age_flag,
p_frz_cmp_lvl_flag => p_rec.frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => p_rec.frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => p_rec.frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => p_rec.frz_comb_age_and_los_flag,
p_dstr_rstcn_flag => p_rec.dstr_rstcn_flag,
p_pct_fl_tm_val => p_rec.pct_fl_tm_val,
p_wv_prtn_rsn_cd => p_rec.wv_prtn_rsn_cd,
p_pl_wvd_flag => p_rec.pl_wvd_flag,
p_rt_comp_ref_amt => p_rec.rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => p_rec.rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => p_rec.rt_comp_ref_uom,
p_rt_age_val => p_rec.rt_age_val,
p_rt_los_val => p_rec.rt_los_val,
p_rt_hrs_wkd_val => p_rec.rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => p_rec.rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => p_rec.rt_age_uom,
p_rt_los_uom => p_rec.rt_los_uom,
p_rt_pct_fl_tm_val => p_rec.rt_pct_fl_tm_val,
p_rt_frz_los_flag => p_rec.rt_frz_los_flag,
p_rt_frz_age_flag => p_rec.rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => p_rec.rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => p_rec.rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => p_rec.rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => p_rec.rt_frz_comb_age_and_los_flag,
p_once_r_cntug_cd => p_rec.once_r_cntug_cd,
p_pl_ordr_num => p_rec.pl_ordr_num,
p_plip_ordr_num => p_rec.plip_ordr_num,
p_ptip_ordr_num => p_rec.ptip_ordr_num,
p_pep_attribute_category => p_rec.pep_attribute_category,
p_pep_attribute1 => p_rec.pep_attribute1,
p_pep_attribute2 => p_rec.pep_attribute2,
p_pep_attribute3 => p_rec.pep_attribute3,
p_pep_attribute4 => p_rec.pep_attribute4,
p_pep_attribute5 => p_rec.pep_attribute5,
p_pep_attribute6 => p_rec.pep_attribute6,
p_pep_attribute7 => p_rec.pep_attribute7,
p_pep_attribute8 => p_rec.pep_attribute8,
p_pep_attribute9 => p_rec.pep_attribute9,
p_pep_attribute10 => p_rec.pep_attribute10,
p_pep_attribute11 => p_rec.pep_attribute11,
p_pep_attribute12 => p_rec.pep_attribute12,
p_pep_attribute13 => p_rec.pep_attribute13,
p_pep_attribute14 => p_rec.pep_attribute14,
p_pep_attribute15 => p_rec.pep_attribute15,
p_pep_attribute16 => p_rec.pep_attribute16,
p_pep_attribute17 => p_rec.pep_attribute17,
p_pep_attribute18 => p_rec.pep_attribute18,
p_pep_attribute19 => p_rec.pep_attribute19,
p_pep_attribute20 => p_rec.pep_attribute20,
p_pep_attribute21 => p_rec.pep_attribute21,
p_pep_attribute22 => p_rec.pep_attribute22,
p_pep_attribute23 => p_rec.pep_attribute23,
p_pep_attribute24 => p_rec.pep_attribute24,
p_pep_attribute25 => p_rec.pep_attribute25,
p_pep_attribute26 => p_rec.pep_attribute26,
p_pep_attribute27 => p_rec.pep_attribute27,
p_pep_attribute28 => p_rec.pep_attribute28,
p_pep_attribute29 => p_rec.pep_attribute29,
p_pep_attribute30 => p_rec.pep_attribute30,
p_request_id => p_rec.request_id,
p_program_application_id => p_rec.program_application_id,
p_program_id => p_rec.program_id,
p_program_update_date => p_rec.program_update_date,
p_object_version_number => p_rec.object_version_number,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date,
p_effective_start_date_o => ben_pep_shd.g_old_rec.effective_start_date,
p_effective_end_date_o => ben_pep_shd.g_old_rec.effective_end_date,
p_business_group_id_o => ben_pep_shd.g_old_rec.business_group_id,
p_pl_id_o => ben_pep_shd.g_old_rec.pl_id,
p_pgm_id_o => ben_pep_shd.g_old_rec.pgm_id,
p_plip_id_o => ben_pep_shd.g_old_rec.plip_id,
p_ptip_id_o => ben_pep_shd.g_old_rec.ptip_id,
p_ler_id_o => ben_pep_shd.g_old_rec.ler_id,
p_person_id_o => ben_pep_shd.g_old_rec.person_id,
p_per_in_ler_id_o => ben_pep_shd.g_old_rec.per_in_ler_id,
p_dpnt_othr_pl_cvrd_rl_flag_o => ben_pep_shd.g_old_rec.dpnt_othr_pl_cvrd_rl_flag,
p_prtn_ovridn_thru_dt_o => ben_pep_shd.g_old_rec.prtn_ovridn_thru_dt,
p_pl_key_ee_flag_o => ben_pep_shd.g_old_rec. pl_key_ee_flag,
p_pl_hghly_compd_flag_o => ben_pep_shd.g_old_rec.pl_hghly_compd_flag,
p_elig_flag_o => ben_pep_shd.g_old_rec.elig_flag,
p_comp_ref_amt_o => ben_pep_shd.g_old_rec. comp_ref_amt,
p_cmbn_age_n_los_val_o => ben_pep_shd.g_old_rec. cmbn_age_n_los_val,
p_comp_ref_uom_o => ben_pep_shd.g_old_rec. comp_ref_uom,
p_age_val_o => ben_pep_shd.g_old_rec.age_val,
p_los_val_o => ben_pep_shd.g_old_rec.los_val,
p_prtn_end_dt_o => ben_pep_shd.g_old_rec.prtn_end_dt,
p_prtn_strt_dt_o => ben_pep_shd.g_old_rec.prtn_strt_dt,
p_wait_perd_cmpltn_dt_o => ben_pep_shd.g_old_rec.wait_perd_cmpltn_dt,
p_wait_perd_strt_dt_o => ben_pep_shd.g_old_rec.wait_perd_strt_dt,
p_wv_ctfn_typ_cd_o => ben_pep_shd.g_old_rec. wv_ctfn_typ_cd,
p_hrs_wkd_val_o => ben_pep_shd.g_old_rec.hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd_o => ben_pep_shd.g_old_rec.hrs_wkd_bndry_perd_cd,
p_prtn_ovridn_flag_o => ben_pep_shd.g_old_rec. prtn_ovridn_flag,
p_no_mx_prtn_ovrid_thru_flag_o => ben_pep_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,
p_prtn_ovridn_rsn_cd_o => ben_pep_shd.g_old_rec.prtn_ovridn_rsn_cd,
p_age_uom_o => ben_pep_shd.g_old_rec.age_uom,
p_los_uom_o => ben_pep_shd.g_old_rec.los_uom,
p_ovrid_svc_dt_o => ben_pep_shd.g_old_rec.ovrid_svc_dt,
p_inelg_rsn_cd_o => ben_pep_shd.g_old_rec.inelg_rsn_cd,
p_frz_los_flag_o => ben_pep_shd.g_old_rec.frz_los_flag,
p_frz_age_flag_o => ben_pep_shd.g_old_rec.frz_age_flag,
p_frz_cmp_lvl_flag_o => ben_pep_shd.g_old_rec.frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag_o => ben_pep_shd.g_old_rec.frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag_o => ben_pep_shd.g_old_rec.frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag_o => ben_pep_shd.g_old_rec.frz_comb_age_and_los_flag,
p_dstr_rstcn_flag_o => ben_pep_shd.g_old_rec.dstr_rstcn_flag,
p_pct_fl_tm_val_o => ben_pep_shd.g_old_rec.pct_fl_tm_val,
p_wv_prtn_rsn_cd_o => ben_pep_shd.g_old_rec.wv_prtn_rsn_cd,
p_pl_wvd_flag_o => ben_pep_shd.g_old_rec.pl_wvd_flag,
p_rt_comp_ref_amt_o => ben_pep_shd.g_old_rec.comp_ref_amt,
p_rt_cmbn_age_n_los_val_o => ben_pep_shd.g_old_rec.cmbn_age_n_los_val,
p_rt_comp_ref_uom_o => ben_pep_shd.g_old_rec.comp_ref_uom,
p_rt_age_val_o => ben_pep_shd.g_old_rec.rt_age_val,
p_rt_los_val_o => ben_pep_shd.g_old_rec.rt_los_val,
p_rt_hrs_wkd_val_o => ben_pep_shd.g_old_rec.rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd_o => ben_pep_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom_o => ben_pep_shd.g_old_rec.rt_age_uom,
p_rt_los_uom_o => ben_pep_shd.g_old_rec.rt_los_uom,
p_rt_pct_fl_tm_val_o => ben_pep_shd.g_old_rec.rt_pct_fl_tm_val,
p_rt_frz_los_flag_o => ben_pep_shd.g_old_rec.rt_frz_los_flag,
p_rt_frz_age_flag_o => ben_pep_shd.g_old_rec.rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag_o => ben_pep_shd.g_old_rec.rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag_o => ben_pep_shd.g_old_rec.rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag_o => ben_pep_shd.g_old_rec.rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_fl_o => ben_pep_shd.g_old_rec.rt_frz_comb_age_and_los_flag,
p_once_r_cntug_cd_o => ben_pep_shd.g_old_rec.once_r_cntug_cd,
p_pl_ordr_num_o => ben_pep_shd.g_old_rec.pl_ordr_num,
p_plip_ordr_num_o => ben_pep_shd.g_old_rec.plip_ordr_num,
p_ptip_ordr_num_o => ben_pep_shd.g_old_rec.ptip_ordr_num,
p_pep_attribute_category_o => ben_pep_shd.g_old_rec.pep_attribute_category,
p_pep_attribute1_o => ben_pep_shd.g_old_rec.pep_attribute1,
p_pep_attribute2_o => ben_pep_shd.g_old_rec.pep_attribute2,
p_pep_attribute3_o => ben_pep_shd.g_old_rec.pep_attribute3,
p_pep_attribute4_o => ben_pep_shd.g_old_rec.pep_attribute4,
p_pep_attribute5_o => ben_pep_shd.g_old_rec.pep_attribute5,
p_pep_attribute6_o => ben_pep_shd.g_old_rec.pep_attribute6,
p_pep_attribute7_o => ben_pep_shd.g_old_rec.pep_attribute7,
p_pep_attribute8_o => ben_pep_shd.g_old_rec.pep_attribute8,
p_pep_attribute9_o => ben_pep_shd.g_old_rec.pep_attribute9,
p_pep_attribute10_o => ben_pep_shd.g_old_rec.pep_attribute10,
p_pep_attribute11_o => ben_pep_shd.g_old_rec.pep_attribute11,
p_pep_attribute12_o => ben_pep_shd.g_old_rec.pep_attribute12,
p_pep_attribute13_o => ben_pep_shd.g_old_rec.pep_attribute13,
p_pep_attribute14_o => ben_pep_shd.g_old_rec.pep_attribute14,
p_pep_attribute15_o => ben_pep_shd.g_old_rec.pep_attribute15,
p_pep_attribute16_o => ben_pep_shd.g_old_rec.pep_attribute16,
p_pep_attribute17_o => ben_pep_shd.g_old_rec.pep_attribute17,
p_pep_attribute18_o => ben_pep_shd.g_old_rec.pep_attribute18,
p_pep_attribute19_o => ben_pep_shd.g_old_rec.pep_attribute19,
p_pep_attribute20_o => ben_pep_shd.g_old_rec.pep_attribute20,
p_pep_attribute21_o => ben_pep_shd.g_old_rec.pep_attribute21,
p_pep_attribute22_o => ben_pep_shd.g_old_rec.pep_attribute22,
p_pep_attribute23_o => ben_pep_shd.g_old_rec.pep_attribute23,
p_pep_attribute24_o => ben_pep_shd.g_old_rec.pep_attribute24,
p_pep_attribute25_o => ben_pep_shd.g_old_rec.pep_attribute25,
p_pep_attribute26_o => ben_pep_shd.g_old_rec.pep_attribute26,
p_pep_attribute27_o => ben_pep_shd.g_old_rec.pep_attribute27,
p_pep_attribute28_o => ben_pep_shd.g_old_rec.pep_attribute28,
p_pep_attribute29_o => ben_pep_shd.g_old_rec.pep_attribute29,
p_pep_attribute30_o => ben_pep_shd.g_old_rec.pep_attribute30,
p_request_id_o => ben_pep_shd.g_old_rec.request_id,
p_program_application_id_o => ben_pep_shd.g_old_rec.program_application_id,
p_program_id_o => ben_pep_shd.g_old_rec.program_id,
p_program_update_date_o => ben_pep_shd.g_old_rec.program_update_date,
p_object_version_number_o => ben_pep_shd.g_old_rec.object_version_number);
End post_update;
If (p_rec.program_update_date = hr_api.g_date) then
p_rec.program_update_date :=
ben_pep_shd.g_old_rec.program_update_date;
ben_pep_bus.update_validate
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
pre_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
update_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
post_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
p_program_update_date in date default hr_api.g_date,
p_object_version_number in out nocopy number,
p_effective_date in date,
p_datetrack_mode in varchar2
) is
--
l_rec ben_pep_shd.g_rec_type;
p_program_update_date,
p_object_version_number
);