The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_dml
(p_rec in out nocopy ben_pgm_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_pgm_f
set
pgm_id = p_rec.pgm_id,
name = p_rec.name,
dpnt_adrs_rqd_flag = p_rec.dpnt_adrs_rqd_flag,
pgm_prvds_no_auto_enrt_flag = p_rec.pgm_prvds_no_auto_enrt_flag,
dpnt_dob_rqd_flag = p_rec.dpnt_dob_rqd_flag,
pgm_prvds_no_dflt_enrt_flag = p_rec.pgm_prvds_no_dflt_enrt_flag,
dpnt_legv_id_rqd_flag = p_rec.dpnt_legv_id_rqd_flag,
dpnt_dsgn_lvl_cd = p_rec.dpnt_dsgn_lvl_cd,
pgm_stat_cd = p_rec.pgm_stat_cd,
ivr_ident = p_rec.ivr_ident,
pgm_typ_cd = p_rec.pgm_typ_cd,
elig_apls_flag = p_rec.elig_apls_flag,
uses_all_asmts_for_rts_flag = p_rec.uses_all_asmts_for_rts_flag,
url_ref_name = p_rec.url_ref_name,
pgm_desc = p_rec.pgm_desc,
prtn_elig_ovrid_alwd_flag = p_rec.prtn_elig_ovrid_alwd_flag,
pgm_use_all_asnts_elig_flag = p_rec.pgm_use_all_asnts_elig_flag,
dpnt_dsgn_cd = p_rec.dpnt_dsgn_cd,
mx_dpnt_pct_prtt_lf_amt = p_rec.mx_dpnt_pct_prtt_lf_amt,
mx_sps_pct_prtt_lf_amt = p_rec.mx_sps_pct_prtt_lf_amt,
acty_ref_perd_cd = p_rec.acty_ref_perd_cd,
coord_cvg_for_all_pls_flg = p_rec.coord_cvg_for_all_pls_flg,
enrt_cvg_end_dt_cd = p_rec.enrt_cvg_end_dt_cd,
enrt_cvg_end_dt_rl = p_rec.enrt_cvg_end_dt_rl,
dpnt_cvg_end_dt_cd = p_rec.dpnt_cvg_end_dt_cd,
dpnt_cvg_end_dt_rl = p_rec.dpnt_cvg_end_dt_rl,
dpnt_cvg_strt_dt_cd = p_rec.dpnt_cvg_strt_dt_cd,
dpnt_cvg_strt_dt_rl = p_rec.dpnt_cvg_strt_dt_rl,
dpnt_dsgn_no_ctfn_rqd_flag = p_rec.dpnt_dsgn_no_ctfn_rqd_flag,
drvbl_fctr_dpnt_elig_flag = p_rec.drvbl_fctr_dpnt_elig_flag,
drvbl_fctr_prtn_elig_flag = p_rec.drvbl_fctr_prtn_elig_flag,
enrt_cvg_strt_dt_cd = p_rec.enrt_cvg_strt_dt_cd,
enrt_cvg_strt_dt_rl = p_rec.enrt_cvg_strt_dt_rl,
enrt_info_rt_freq_cd = p_rec.enrt_info_rt_freq_cd,
rt_strt_dt_cd = p_rec.rt_strt_dt_cd,
rt_strt_dt_rl = p_rec.rt_strt_dt_rl,
rt_end_dt_cd = p_rec.rt_end_dt_cd,
rt_end_dt_rl = p_rec.rt_end_dt_rl,
pgm_grp_cd = p_rec.pgm_grp_cd,
pgm_uom = p_rec.pgm_uom,
drvbl_fctr_apls_rts_flag = p_rec.drvbl_fctr_apls_rts_flag,
alws_unrstrctd_enrt_flag = p_rec.alws_unrstrctd_enrt_flag,
enrt_cd = p_rec.enrt_cd,
enrt_mthd_cd = p_rec.enrt_mthd_cd,
poe_lvl_cd = p_rec.poe_lvl_cd,
enrt_rl = p_rec.enrt_rl,
auto_enrt_mthd_rl = p_rec.auto_enrt_mthd_rl,
trk_inelig_per_flag = p_rec.trk_inelig_per_flag,
business_group_id = p_rec.business_group_id,
per_cvrd_cd = p_rec.per_cvrd_cd ,
vrfy_fmly_mmbr_rl = p_rec.vrfy_fmly_mmbr_rl ,
vrfy_fmly_mmbr_cd = p_rec.vrfy_fmly_mmbr_cd,
short_name = p_rec.short_name, /*FHR*/
short_code = p_rec.short_code, /*FHR*/
legislation_code = p_rec.legislation_code, /*FHR*/
legislation_subgroup = p_rec.legislation_subgroup, /*FHR*/
Dflt_pgm_flag = p_rec.Dflt_pgm_flag,
Use_prog_points_flag = p_rec.Use_prog_points_flag,
Dflt_step_cd = p_rec.Dflt_step_cd,
Dflt_step_rl = p_rec.Dflt_step_rl,
Update_salary_cd = p_rec.Update_salary_cd,
Use_multi_pay_rates_flag = p_rec.Use_multi_pay_rates_flag,
dflt_element_type_id = p_rec.dflt_element_type_id,
Dflt_input_value_id = p_rec.Dflt_input_value_id,
Use_scores_cd = p_rec.Use_scores_cd,
Scores_calc_mthd_cd = p_rec.Scores_calc_mthd_cd,
Scores_calc_rl = p_rec.Scores_calc_rl,
gsp_allow_override_flag = p_rec.gsp_allow_override_flag,
use_variable_rates_flag = p_rec.use_variable_rates_flag,
salary_calc_mthd_cd = p_rec.salary_calc_mthd_cd,
salary_calc_mthd_rl = p_rec.salary_calc_mthd_rl,
susp_if_dpnt_ssn_nt_prv_cd = p_rec.susp_if_dpnt_ssn_nt_prv_cd,
susp_if_dpnt_dob_nt_prv_cd = p_rec.susp_if_dpnt_dob_nt_prv_cd,
susp_if_dpnt_adr_nt_prv_cd = p_rec.susp_if_dpnt_adr_nt_prv_cd,
susp_if_ctfn_not_dpnt_flag = p_rec.susp_if_ctfn_not_dpnt_flag,
dpnt_ctfn_determine_cd = p_rec.dpnt_ctfn_determine_cd,
pgm_attribute_category = p_rec.pgm_attribute_category,
pgm_attribute1 = p_rec.pgm_attribute1,
pgm_attribute2 = p_rec.pgm_attribute2,
pgm_attribute3 = p_rec.pgm_attribute3,
pgm_attribute4 = p_rec.pgm_attribute4,
pgm_attribute5 = p_rec.pgm_attribute5,
pgm_attribute6 = p_rec.pgm_attribute6,
pgm_attribute7 = p_rec.pgm_attribute7,
pgm_attribute8 = p_rec.pgm_attribute8,
pgm_attribute9 = p_rec.pgm_attribute9,
pgm_attribute10 = p_rec.pgm_attribute10,
pgm_attribute11 = p_rec.pgm_attribute11,
pgm_attribute12 = p_rec.pgm_attribute12,
pgm_attribute13 = p_rec.pgm_attribute13,
pgm_attribute14 = p_rec.pgm_attribute14,
pgm_attribute15 = p_rec.pgm_attribute15,
pgm_attribute16 = p_rec.pgm_attribute16,
pgm_attribute17 = p_rec.pgm_attribute17,
pgm_attribute18 = p_rec.pgm_attribute18,
pgm_attribute19 = p_rec.pgm_attribute19,
pgm_attribute20 = p_rec.pgm_attribute20,
pgm_attribute21 = p_rec.pgm_attribute21,
pgm_attribute22 = p_rec.pgm_attribute22,
pgm_attribute23 = p_rec.pgm_attribute23,
pgm_attribute24 = p_rec.pgm_attribute24,
pgm_attribute25 = p_rec.pgm_attribute25,
pgm_attribute26 = p_rec.pgm_attribute26,
pgm_attribute27 = p_rec.pgm_attribute27,
pgm_attribute28 = p_rec.pgm_attribute28,
pgm_attribute29 = p_rec.pgm_attribute29,
pgm_attribute30 = p_rec.pgm_attribute30,
object_version_number = p_rec.object_version_number
where pgm_id = p_rec.pgm_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_pgm_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_pgm_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_pgm_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_pgm_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_pgm_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_pgm_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';
End post_update;
If (p_rec.Update_salary_cd = hr_api.g_varchar2) then
p_rec.Update_salary_cd :=
ben_pgm_shd.g_old_rec.Update_salary_cd;
ben_pgm_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_Update_salary_cd in Varchar2 default hr_api.g_varchar2,
p_Use_multi_pay_rates_flag in Varchar2 default hr_api.g_varchar2,
p_dflt_element_type_id in number default hr_api.g_number,
p_Dflt_input_value_id in number default hr_api.g_number,
p_Use_scores_cd in Varchar2 default hr_api.g_varchar2,
p_Scores_calc_mthd_cd in Varchar2 default hr_api.g_varchar2,
p_Scores_calc_rl in number default hr_api.g_number,
p_gsp_allow_override_flag in varchar2 default hr_api.g_varchar2,
p_use_variable_rates_flag in varchar2 default hr_api.g_varchar2,
p_salary_calc_mthd_cd in varchar2 default hr_api.g_varchar2,
p_salary_calc_mthd_rl in number default hr_api.g_number,
p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2,
p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2,
p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2,
p_susp_if_ctfn_not_dpnt_flag in varchar2 default hr_api.g_varchar2,
p_dpnt_ctfn_determine_cd in varchar2 default hr_api.g_varchar2,
p_pgm_attribute_category in varchar2 default hr_api.g_varchar2,
p_pgm_attribute1 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute2 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute3 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute4 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute5 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute6 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute7 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute8 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute9 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute10 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute11 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute12 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute13 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute14 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute15 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute16 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute17 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute18 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute19 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute20 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute21 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute22 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute23 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute24 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute25 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute26 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute27 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute28 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute29 in varchar2 default hr_api.g_varchar2,
p_pgm_attribute30 in varchar2 default hr_api.g_varchar2,
p_object_version_number in out nocopy number,
p_effective_date in date,
p_datetrack_mode in varchar2
) is
--
l_rec ben_pgm_shd.g_rec_type;
p_Update_salary_cd,
p_Use_multi_pay_rates_flag,
p_dflt_element_type_id,
p_Dflt_input_value_id,
p_Use_scores_cd,
p_Scores_calc_mthd_cd,
p_Scores_calc_rl,
P_gsp_allow_override_flag,
P_use_variable_rates_flag,
P_salary_calc_mthd_cd,
P_salary_calc_mthd_rl,
p_susp_if_dpnt_ssn_nt_prv_cd,
p_susp_if_dpnt_dob_nt_prv_cd,
p_susp_if_dpnt_adr_nt_prv_cd,
p_susp_if_ctfn_not_dpnt_flag,
p_dpnt_ctfn_determine_cd,
P_pgm_attribute_category,
p_pgm_attribute1,
p_pgm_attribute2,
p_pgm_attribute3,
p_pgm_attribute4,
p_pgm_attribute5,
p_pgm_attribute6,
p_pgm_attribute7,
p_pgm_attribute8,
p_pgm_attribute9,
p_pgm_attribute10,
p_pgm_attribute11,
p_pgm_attribute12,
p_pgm_attribute13,
p_pgm_attribute14,
p_pgm_attribute15,
p_pgm_attribute16,
p_pgm_attribute17,
p_pgm_attribute18,
p_pgm_attribute19,
p_pgm_attribute20,
p_pgm_attribute21,
p_pgm_attribute22,
p_pgm_attribute23,
p_pgm_attribute24,
p_pgm_attribute25,
p_pgm_attribute26,
p_pgm_attribute27,
p_pgm_attribute28,
p_pgm_attribute29,
p_pgm_attribute30,
p_object_version_number
);