[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_insert_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
--
-- Cursor to select 'old' created AOL who column values
--
Cursor C_Sel1 Is
select t.created_by,
t.creation_date
from ben_pgm_f t
where t.pgm_id = p_rec.pgm_id
and t.effective_start_date =
ben_pgm_shd.g_old_rec.effective_start_date
and t.effective_end_date = (p_validation_start_date - 1);
l_proc varchar2(72) := g_package||'dt_insert_dml';
l_last_update_date ben_pgm_f.last_update_date%TYPE;
l_last_updated_by ben_pgm_f.last_updated_by%TYPE;
l_last_update_login ben_pgm_f.last_update_login%TYPE;
If (p_datetrack_mode <> 'INSERT') then
hr_utility.set_location(l_proc, 10);
l_last_update_date := sysdate;
l_last_updated_by := fnd_global.user_id;
l_last_update_login := fnd_global.login_id;
insert into ben_pgm_f
( pgm_id,
effective_start_date,
effective_end_date,
name,
dpnt_adrs_rqd_flag,
pgm_prvds_no_auto_enrt_flag,
dpnt_dob_rqd_flag,
pgm_prvds_no_dflt_enrt_flag,
dpnt_dsgn_lvl_cd,
dpnt_legv_id_rqd_flag,
pgm_stat_cd,
ivr_ident,
pgm_typ_cd,
elig_apls_flag,
uses_all_asmts_for_rts_flag,
url_ref_name,
pgm_desc,
prtn_elig_ovrid_alwd_flag,
pgm_use_all_asnts_elig_flag,
dpnt_dsgn_cd,
mx_dpnt_pct_prtt_lf_amt,
mx_sps_pct_prtt_lf_amt,
coord_cvg_for_all_pls_flg,
enrt_cvg_end_dt_cd,
enrt_cvg_end_dt_rl,
pgm_grp_cd,
acty_ref_perd_cd,
drvbl_fctr_dpnt_elig_flag,
pgm_uom,
enrt_info_rt_freq_cd,
drvbl_fctr_prtn_elig_flag,
drvbl_fctr_apls_rts_flag,
alws_unrstrctd_enrt_flag,
enrt_cd,
enrt_mthd_cd,
poe_lvl_cd,
enrt_rl,
auto_enrt_mthd_rl,
dpnt_dsgn_no_ctfn_rqd_flag,
enrt_cvg_strt_dt_cd,
enrt_cvg_strt_dt_rl,
rt_end_dt_cd,
rt_end_dt_rl,
rt_strt_dt_cd,
rt_strt_dt_rl,
dpnt_cvg_strt_dt_cd,
dpnt_cvg_strt_dt_rl,
dpnt_cvg_end_dt_rl,
dpnt_cvg_end_dt_cd,
trk_inelig_per_flag,
business_group_id,
per_cvrd_cd ,
vrfy_fmly_mmbr_rl,
vrfy_fmly_mmbr_cd,
short_name, /*FHR*/
short_code, /*FHR*/
legislation_code, /*FHR*/
legislation_subgroup, /*FHR*/
Dflt_pgm_flag,
Use_prog_points_flag,
Dflt_step_cd,
Dflt_step_rl,
Update_salary_cd,
Use_multi_pay_rates_flag,
dflt_element_type_id,
Dflt_input_value_id,
Use_scores_cd,
Scores_calc_mthd_cd,
Scores_calc_rl,
gsp_allow_override_flag,
use_variable_rates_flag,
salary_calc_mthd_cd,
salary_calc_mthd_rl,
susp_if_dpnt_ssn_nt_prv_cd,
susp_if_dpnt_dob_nt_prv_cd,
susp_if_dpnt_adr_nt_prv_cd,
susp_if_ctfn_not_dpnt_flag,
dpnt_ctfn_determine_cd,
pgm_attribute_category,
pgm_attribute1,
pgm_attribute2,
pgm_attribute3,
pgm_attribute4,
pgm_attribute5,
pgm_attribute6,
pgm_attribute7,
pgm_attribute8,
pgm_attribute9,
pgm_attribute10,
pgm_attribute11,
pgm_attribute12,
pgm_attribute13,
pgm_attribute14,
pgm_attribute15,
pgm_attribute16,
pgm_attribute17,
pgm_attribute18,
pgm_attribute19,
pgm_attribute20,
pgm_attribute21,
pgm_attribute22,
pgm_attribute23,
pgm_attribute24,
pgm_attribute25,
pgm_attribute26,
pgm_attribute27,
pgm_attribute28,
pgm_attribute29,
pgm_attribute30,
object_version_number
, created_by,
creation_date,
last_update_date,
last_updated_by,
last_update_login,
all_inelig
)
Values
( p_rec.pgm_id,
p_rec.effective_start_date,
p_rec.effective_end_date,
p_rec.name,
p_rec.dpnt_adrs_rqd_flag,
p_rec.pgm_prvds_no_auto_enrt_flag,
p_rec.dpnt_dob_rqd_flag,
p_rec.pgm_prvds_no_dflt_enrt_flag,
p_rec.dpnt_dsgn_lvl_cd,
p_rec.dpnt_legv_id_rqd_flag,
p_rec.pgm_stat_cd,
p_rec.ivr_ident,
p_rec.pgm_typ_cd,
p_rec.elig_apls_flag,
p_rec.uses_all_asmts_for_rts_flag,
p_rec.url_ref_name,
p_rec.pgm_desc,
p_rec.prtn_elig_ovrid_alwd_flag,
p_rec.pgm_use_all_asnts_elig_flag,
p_rec.dpnt_dsgn_cd,
p_rec.mx_dpnt_pct_prtt_lf_amt,
p_rec.mx_sps_pct_prtt_lf_amt,
p_rec.coord_cvg_for_all_pls_flg,
p_rec.enrt_cvg_end_dt_cd,
p_rec.enrt_cvg_end_dt_rl,
p_rec.pgm_grp_cd,
p_rec.acty_ref_perd_cd,
p_rec.drvbl_fctr_dpnt_elig_flag,
p_rec.pgm_uom,
p_rec.enrt_info_rt_freq_cd,
p_rec.drvbl_fctr_prtn_elig_flag,
p_rec.drvbl_fctr_apls_rts_flag,
p_rec.alws_unrstrctd_enrt_flag,
p_rec.enrt_cd,
p_rec.enrt_mthd_cd,
p_rec.poe_lvl_cd,
p_rec.enrt_rl,
p_rec.auto_enrt_mthd_rl,
p_rec.dpnt_dsgn_no_ctfn_rqd_flag,
p_rec.enrt_cvg_strt_dt_cd,
p_rec.enrt_cvg_strt_dt_rl,
p_rec.rt_end_dt_cd,
p_rec.rt_end_dt_rl,
p_rec.rt_strt_dt_cd,
p_rec.rt_strt_dt_rl,
p_rec.dpnt_cvg_strt_dt_cd,
p_rec.dpnt_cvg_strt_dt_rl,
p_rec.dpnt_cvg_end_dt_rl,
p_rec.dpnt_cvg_end_dt_cd,
p_rec.trk_inelig_per_flag,
p_rec.business_group_id,
P_rec.per_cvrd_cd ,
P_rec.vrfy_fmly_mmbr_rl,
P_rec.vrfy_fmly_mmbr_cd,
p_rec.short_name, /*FHR*/
p_rec.short_code, /*FHR*/
p_rec.legislation_code, /*FHR*/
p_rec.legislation_subgroup, /*FHR*/
p_rec.Dflt_pgm_flag,
p_rec.Use_prog_points_flag,
p_rec.Dflt_step_cd,
p_rec.Dflt_step_rl,
p_rec.Update_salary_cd,
p_rec.Use_multi_pay_rates_flag,
p_rec.dflt_element_type_id,
p_rec.Dflt_input_value_id,
p_rec.Use_scores_cd,
p_rec.Scores_calc_mthd_cd,
p_rec.Scores_calc_rl,
p_rec.gsp_allow_override_flag,
p_rec.use_variable_rates_flag,
p_rec.salary_calc_mthd_cd,
p_rec.salary_calc_mthd_rl,
p_rec.susp_if_dpnt_ssn_nt_prv_cd,
p_rec.susp_if_dpnt_dob_nt_prv_cd,
p_rec.susp_if_dpnt_adr_nt_prv_cd,
p_rec.susp_if_ctfn_not_dpnt_flag,
p_rec.dpnt_ctfn_determine_cd,
p_rec.pgm_attribute_category,
p_rec.pgm_attribute1,
p_rec.pgm_attribute2,
p_rec.pgm_attribute3,
p_rec.pgm_attribute4,
p_rec.pgm_attribute5,
p_rec.pgm_attribute6,
p_rec.pgm_attribute7,
p_rec.pgm_attribute8,
p_rec.pgm_attribute9,
p_rec.pgm_attribute10,
p_rec.pgm_attribute11,
p_rec.pgm_attribute12,
p_rec.pgm_attribute13,
p_rec.pgm_attribute14,
p_rec.pgm_attribute15,
p_rec.pgm_attribute16,
p_rec.pgm_attribute17,
p_rec.pgm_attribute18,
p_rec.pgm_attribute19,
p_rec.pgm_attribute20,
p_rec.pgm_attribute21,
p_rec.pgm_attribute22,
p_rec.pgm_attribute23,
p_rec.pgm_attribute24,
p_rec.pgm_attribute25,
p_rec.pgm_attribute26,
p_rec.pgm_attribute27,
p_rec.pgm_attribute28,
p_rec.pgm_attribute29,
p_rec.pgm_attribute30,
p_rec.object_version_number
, l_created_by,
l_creation_date,
l_last_update_date,
l_last_updated_by,
l_last_update_login,
p_rec.all_inelig
);
End dt_insert_dml;
Procedure insert_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||'insert_dml';
dt_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 insert_dml;
Procedure pre_insert
(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_insert';
select ben_pgm_f_s.nextval
from sys.dual;
End pre_insert;
Procedure post_insert
(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_insert';
End post_insert;
l_datetrack_mode varchar2(30) := 'INSERT';
ben_pgm_bus.insert_validate
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
pre_insert
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
insert_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
post_insert
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => l_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 null,
p_Use_multi_pay_rates_flag in Varchar2 default null,
p_dflt_element_type_id in number default null,
p_Dflt_input_value_id in number default null,
p_Use_scores_cd in Varchar2 default null,
p_Scores_calc_mthd_cd in Varchar2 default null,
p_Scores_calc_rl in number default null,
p_gsp_allow_override_flag in varchar2 default null,
p_use_variable_rates_flag in varchar2 default null,
p_salary_calc_mthd_cd in varchar2 default null,
p_salary_calc_mthd_rl in number default null,
p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default null,
p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default null,
p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default null,
p_susp_if_ctfn_not_dpnt_flag in varchar2 default 'Y',
p_dpnt_ctfn_determine_cd in varchar2 default null,
p_pgm_attribute_category in varchar2 default null,
p_pgm_attribute1 in varchar2 default null,
p_pgm_attribute2 in varchar2 default null,
p_pgm_attribute3 in varchar2 default null,
p_pgm_attribute4 in varchar2 default null,
p_pgm_attribute5 in varchar2 default null,
p_pgm_attribute6 in varchar2 default null,
p_pgm_attribute7 in varchar2 default null,
p_pgm_attribute8 in varchar2 default null,
p_pgm_attribute9 in varchar2 default null,
p_pgm_attribute10 in varchar2 default null,
p_pgm_attribute11 in varchar2 default null,
p_pgm_attribute12 in varchar2 default null,
p_pgm_attribute13 in varchar2 default null,
p_pgm_attribute14 in varchar2 default null,
p_pgm_attribute15 in varchar2 default null,
p_pgm_attribute16 in varchar2 default null,
p_pgm_attribute17 in varchar2 default null,
p_pgm_attribute18 in varchar2 default null,
p_pgm_attribute19 in varchar2 default null,
p_pgm_attribute20 in varchar2 default null,
p_pgm_attribute21 in varchar2 default null,
p_pgm_attribute22 in varchar2 default null,
p_pgm_attribute23 in varchar2 default null,
p_pgm_attribute24 in varchar2 default null,
p_pgm_attribute25 in varchar2 default null,
p_pgm_attribute26 in varchar2 default null,
p_pgm_attribute27 in varchar2 default null,
p_pgm_attribute28 in varchar2 default null,
p_pgm_attribute29 in varchar2 default null,
p_pgm_attribute30 in varchar2 default null,
p_all_inelig in varchar2 default null,
p_object_version_number out nocopy number,
p_effective_date in date
) 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_all_inelig
,null
);