[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_into_icd (
l_icd_chc_rates_tab icd_chc_rates_tab,
p_effective_date DATE,
p_person_id NUMBER,
p_business_group_id NUMBER,
p_rt_strt_dt DATE,
p_rt_strt_dt_cd VARCHAR2,
p_rt_strt_dt_rl NUMBER,
p_rt_end_dt DATE,
p_rt_end_dt_cd VARCHAR2,
p_rt_end_dt_rl NUMBER,
j_count NUMBER
)
IS
--
CURSOR c_pl_info (p_pl_id NUMBER)
IS
SELECT pln.rt_strt_dt_cd, pln.rt_strt_dt_rl, pln.rt_end_dt_cd,
pln.rt_end_dt_rl, pln.bnf_dsgn_cd
FROM ben_pl_f pln
WHERE pln.pl_id = p_pl_id
AND p_effective_date BETWEEN pln.effective_start_date
AND pln.effective_end_date;
SELECT nnmntry_uom, cost_allocation_keyflex_id
FROM ben_acty_base_rt_f
WHERE acty_base_rt_id = p_acty_base_rt_id
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT ben_icd_chc_rates_s.NEXTVAL
FROM DUAL;
hr_utility.set_location ('Entering insert_into_icd ', 213);
INSERT INTO ben_icd_chc_rates
(icd_chc_rate_id, person_id, business_group_id,
assignment_id,
effective_date,
acty_base_rt_id,
pl_id,
pl_typ_id,
oipl_id,
opt_id,
pl_ordr_num,
oipl_ordr_num,
nnmntry_uom, rt_strt_dt_cd,
rt_strt_dt, rt_strt_dt_rl, rt_end_dt_cd,
rt_end_dt, rt_end_dt_rl, bnf_rqd_flag,
input_value_id1,
input_value1,
input_value_id2,
input_value2,
input_value_id3,
input_value3,
input_value_id4,
input_value4,
input_value_id5,
input_value5,
input_value_id6,
input_value6,
input_value_id7,
input_value7,
input_value_id8,
input_value8,
input_value_id9,
input_value9,
input_value_id10,
input_value10,
input_value_id11,
input_value11,
input_value_id12,
input_value12,
input_value_id13,
input_value13,
input_value_id14,
input_value14,
input_value_id15,
input_value15,
element_type_id,
element_link_id, object_version_number, last_update_date,
last_updated_by, creation_date, created_by,
cost_allocation_keyflex_id, elig_flag
)
VALUES (l_next_val, p_person_id, p_business_group_id,
l_icd_chc_rates_tab (j_count).l_assignment_id,
p_effective_date,
l_icd_chc_rates_tab (j_count).acty_base_rt_id,
l_icd_chc_rates_tab (j_count).pl_id,
l_icd_chc_rates_tab (j_count).pl_typ_id,
l_icd_chc_rates_tab (j_count).oipl_id,
l_icd_chc_rates_tab (j_count).opt_id,
l_icd_chc_rates_tab (j_count).pl_ordr_num,
l_icd_chc_rates_tab (j_count).oipl_ordr_num,
l_abr_info.nnmntry_uom, l_pl_info.rt_strt_dt_cd,
p_rt_strt_dt, p_rt_strt_dt_rl, l_pl_info.rt_end_dt_cd,
hr_api.g_eot, p_rt_end_dt_rl, l_bnf_rqd_flag,
l_icd_chc_rates_tab (j_count).input_value_id1,
l_icd_chc_rates_tab (j_count).input_value1,
l_icd_chc_rates_tab (j_count).input_value_id2,
l_icd_chc_rates_tab (j_count).input_value2,
l_icd_chc_rates_tab (j_count).input_value_id3,
l_icd_chc_rates_tab (j_count).input_value3,
l_icd_chc_rates_tab (j_count).input_value_id4,
l_icd_chc_rates_tab (j_count).input_value4,
l_icd_chc_rates_tab (j_count).input_value_id5,
l_icd_chc_rates_tab (j_count).input_value5,
l_icd_chc_rates_tab (j_count).input_value_id6,
l_icd_chc_rates_tab (j_count).input_value6,
l_icd_chc_rates_tab (j_count).input_value_id7,
l_icd_chc_rates_tab (j_count).input_value7,
l_icd_chc_rates_tab (j_count).input_value_id8,
l_icd_chc_rates_tab (j_count).input_value8,
l_icd_chc_rates_tab (j_count).input_value_id9,
l_icd_chc_rates_tab (j_count).input_value9,
l_icd_chc_rates_tab (j_count).input_value_id10,
l_icd_chc_rates_tab (j_count).input_value10,
l_icd_chc_rates_tab (j_count).input_value_id11,
l_icd_chc_rates_tab (j_count).input_value11,
l_icd_chc_rates_tab (j_count).input_value_id12,
l_icd_chc_rates_tab (j_count).input_value12,
l_icd_chc_rates_tab (j_count).input_value_id13,
l_icd_chc_rates_tab (j_count).input_value13,
l_icd_chc_rates_tab (j_count).input_value_id14,
l_icd_chc_rates_tab (j_count).input_value14,
l_icd_chc_rates_tab (j_count).input_value_id15,
l_icd_chc_rates_tab (j_count).input_value15,
l_icd_chc_rates_tab (j_count).element_type_id,
l_icd_chc_rates_tab (j_count).element_link_id, 1, SYSDATE,
fnd_global.user_id, SYSDATE, fnd_global.user_id,
l_abr_info.cost_allocation_keyflex_id, 'Y'
);
hr_utility.set_location ('Leaving Insert_Into_Icd ', 213);
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
END insert_into_icd;
SELECT opt_id, pl_id
FROM ben_oipl_f
WHERE oipl_id = p_oipl_id;
insert_into_icd
(l_icd_chc_rates_tab => ben_determine_activity_base_rt.l_icd_chc_rates_tab,
p_effective_date => p_effective_date,
p_person_id => p_person_id,
p_business_group_id => p_business_group_id,
p_rt_strt_dt => l_rt_strt_dt,
p_rt_strt_dt_cd => l_rt_strt_dt_cd,
p_rt_strt_dt_rl => l_rt_strt_dt_rl,
p_rt_end_dt => l_dummy_date,
p_rt_end_dt_cd => l_dummy_char,
p_rt_end_dt_rl => l_dummy_num,
j_count => l_icd_count
);
DELETE FROM ben_icd_chc_rates
WHERE person_id = p_person_id
AND pl_id =
ben_icm_life_events.g_cache_pep_object
(cache11).pl_id;
insert_into_icd
(l_icd_chc_rates_tab => ben_determine_activity_base_rt.l_icd_chc_rates_tab,
p_effective_date => p_effective_date,
p_person_id => p_person_id,
p_business_group_id => p_business_group_id,
p_rt_strt_dt => l_rt_strt_dt,
p_rt_strt_dt_cd => l_rt_strt_dt_cd,
p_rt_strt_dt_rl => l_rt_strt_dt_rl,
p_rt_end_dt => l_dummy_date,
p_rt_end_dt_cd => l_dummy_char,
p_rt_end_dt_rl => l_dummy_num,
j_count => l_icd_count
);
DELETE FROM ben_icd_chc_rates
WHERE person_id = p_person_id
AND opt_id =
ben_icm_life_events.g_cache_epo_object
(cache11).opt_id;
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
SELECT trk_inelig_per_flag
FROM ben_oipl_f
WHERE opt_id = p_opt_id;
SELECT object_version_number
FROM ben_elig_per_f pep
WHERE pep.elig_per_id = p_elig_per_id;
SELECT object_version_number
FROM ben_elig_per_opt_f epo
WHERE epo.elig_per_opt_id = p_elig_per_opt_id;
ben_eligible_person_perf_api.update_perf_eligible_person
(p_validate => FALSE,
p_elig_per_id => ben_icm_life_events.g_cache_pep_object
(l_count).elig_per_id,
p_per_in_ler_id => NULL,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_elig_flag => ben_icm_life_events.g_cache_pep_object
(l_count).elig_flag,
p_prtn_strt_dt => ben_icm_life_events.g_cache_pep_object
(l_count).prtn_strt_dt,
p_rt_comp_ref_amt => ben_icm_life_events.g_cache_pep_object
(l_count).rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_comp_ref_uom,
p_rt_age_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_age_val,
p_rt_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_los_val,
p_rt_hrs_wkd_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_pep_object
(l_count).rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_age_uom,
p_rt_los_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_los_uom,
p_rt_pct_fl_tm_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_pct_fl_tm_val,
p_rt_frz_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_los_flag,
p_rt_frz_age_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_comb_age_and_los_flag,
p_once_r_cntug_cd => ben_icm_life_events.g_cache_pep_object
(l_count).once_r_cntug_cd,
p_comp_ref_amt => ben_icm_life_events.g_cache_pep_object
(l_count).comp_ref_amt,
p_cmbn_age_n_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).cmbn_age_n_los_val,
p_comp_ref_uom => ben_icm_life_events.g_cache_pep_object
(l_count).comp_ref_uom,
p_age_val => ben_icm_life_events.g_cache_pep_object
(l_count).age_val,
p_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).los_val,
p_hrs_wkd_val => ben_icm_life_events.g_cache_pep_object
(l_count).hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_pep_object
(l_count).hrs_wkd_bndry_perd_cd,
p_age_uom => ben_icm_life_events.g_cache_pep_object
(l_count).age_uom,
p_los_uom => ben_icm_life_events.g_cache_pep_object
(l_count).los_uom,
p_pct_fl_tm_val => ben_icm_life_events.g_cache_pep_object
(l_count).pct_fl_tm_val,
p_frz_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_los_flag,
p_frz_age_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_age_flag,
p_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_comb_age_and_los_flag,
p_wait_perd_cmpltn_dt => ben_icm_life_events.g_cache_pep_object
(l_count).wait_perd_cmpltn_dt,
p_wait_perd_strt_dt => ben_icm_life_events.g_cache_pep_object
(l_count).wait_perd_strt_dt,
p_object_version_number => ben_icm_life_events.g_cache_pep_object(l_count).object_version_number,
p_effective_date => ben_icm_life_events.g_cache_pep_object
(l_count).p_effective_date,
p_datetrack_mode => ben_icm_life_events.g_cache_pep_object(l_count).p_datetrack_mode,
p_program_application_id => fnd_global.prog_appl_id,
p_program_id => fnd_global.conc_program_id,
p_request_id => fnd_global.conc_request_id,
p_program_update_date => SYSDATE
);
hr_utility.set_location ('Insert Mode for PEP' ||ben_icm_life_events.g_cache_pep_object (l_count).object_version_number, 1234);
INSERT INTO ben_elig_per_f
(elig_per_id,
effective_start_date,
effective_end_date,
business_group_id,
pl_id,
plip_id,
ptip_id,
pgm_id,
ler_id,
person_id, per_in_ler_id,
dpnt_othr_pl_cvrd_rl_flag,
pl_key_ee_flag,
pl_hghly_compd_flag,
prtn_ovridn_flag,
prtn_ovridn_thru_dt,
no_mx_prtn_ovrid_thru_flag,
prtn_strt_dt,
dstr_rstcn_flag,
pl_wvd_flag,
wait_perd_cmpltn_dt,
wait_perd_strt_dt,
elig_flag,
comp_ref_amt,
cmbn_age_n_los_val,
comp_ref_uom,
age_val,
age_uom,
los_val,
los_uom,
hrs_wkd_val,
hrs_wkd_bndry_perd_cd,
pct_fl_tm_val,
frz_los_flag,
frz_age_flag,
frz_cmp_lvl_flag,
frz_pct_fl_tm_flag,
frz_hrs_wkd_flag,
frz_comb_age_and_los_flag,
rt_comp_ref_amt,
rt_cmbn_age_n_los_val,
rt_comp_ref_uom,
rt_age_val,
rt_age_uom,
rt_los_val,
rt_los_uom,
rt_hrs_wkd_val,
rt_hrs_wkd_bndry_perd_cd,
rt_pct_fl_tm_val,
rt_frz_los_flag,
rt_frz_age_flag,
rt_frz_cmp_lvl_flag,
rt_frz_pct_fl_tm_flag,
rt_frz_hrs_wkd_flag,
rt_frz_comb_age_and_los_flag,
once_r_cntug_cd,
pl_ordr_num,
plip_ordr_num,
ptip_ordr_num,
object_version_number,
program_application_id,
program_id,
request_id,
program_update_date
)
VALUES (ben_icm_life_events.g_cache_pep_object (l_count).elig_per_id,
ben_icm_life_events.g_cache_pep_object (l_count).effective_start_date,
ben_icm_life_events.g_cache_pep_object (l_count).effective_end_date,
ben_icm_life_events.g_cache_pep_object (l_count).business_group_id,
ben_icm_life_events.g_cache_pep_object (l_count).pl_id,
ben_icm_life_events.g_cache_pep_object (l_count).plip_id,
ben_icm_life_events.g_cache_pep_object (l_count).ptip_id,
ben_icm_life_events.g_cache_pep_object (l_count).pgm_id,
ben_icm_life_events.g_cache_pep_object (l_count).ler_id,
p_person_id, NULL,
ben_icm_life_events.g_cache_pep_object (l_count).dpnt_othr_pl_cvrd_rl_flag,
ben_icm_life_events.g_cache_pep_object (l_count).pl_key_ee_flag,
ben_icm_life_events.g_cache_pep_object (l_count).pl_hghly_compd_flag,
ben_icm_life_events.g_cache_pep_object (l_count).prtn_ovridn_flag,
ben_icm_life_events.g_cache_pep_object (l_count).prtn_ovridn_thru_dt,
ben_icm_life_events.g_cache_pep_object (l_count).no_mx_prtn_ovrid_thru_flag,
ben_icm_life_events.g_cache_pep_object (l_count).prtn_strt_dt,
ben_icm_life_events.g_cache_pep_object (l_count).dstr_rstcn_flag,
ben_icm_life_events.g_cache_pep_object (l_count).pl_wvd_flag,
ben_icm_life_events.g_cache_pep_object (l_count).wait_perd_cmpltn_dt,
ben_icm_life_events.g_cache_pep_object (l_count).wait_perd_strt_dt,
ben_icm_life_events.g_cache_pep_object (l_count).elig_flag,
ben_icm_life_events.g_cache_pep_object (l_count).comp_ref_amt,
ben_icm_life_events.g_cache_pep_object (l_count).cmbn_age_n_los_val,
ben_icm_life_events.g_cache_pep_object (l_count).comp_ref_uom,
ben_icm_life_events.g_cache_pep_object (l_count).age_val,
ben_icm_life_events.g_cache_pep_object (l_count).age_uom,
ben_icm_life_events.g_cache_pep_object (l_count).los_val,
ben_icm_life_events.g_cache_pep_object (l_count).los_uom,
ben_icm_life_events.g_cache_pep_object (l_count).hrs_wkd_val,
ben_icm_life_events.g_cache_pep_object (l_count).hrs_wkd_bndry_perd_cd,
ben_icm_life_events.g_cache_pep_object (l_count).pct_fl_tm_val,
ben_icm_life_events.g_cache_pep_object (l_count).frz_los_flag,
ben_icm_life_events.g_cache_pep_object (l_count).frz_age_flag,
ben_icm_life_events.g_cache_pep_object (l_count).frz_cmp_lvl_flag,
ben_icm_life_events.g_cache_pep_object (l_count).frz_pct_fl_tm_flag,
ben_icm_life_events.g_cache_pep_object (l_count).frz_hrs_wkd_flag,
ben_icm_life_events.g_cache_pep_object (l_count).frz_comb_age_and_los_flag,
ben_icm_life_events.g_cache_pep_object (l_count).rt_comp_ref_amt,
ben_icm_life_events.g_cache_pep_object (l_count).rt_cmbn_age_n_los_val,
ben_icm_life_events.g_cache_pep_object (l_count).rt_comp_ref_uom,
ben_icm_life_events.g_cache_pep_object (l_count).rt_age_val,
ben_icm_life_events.g_cache_pep_object (l_count).rt_age_uom,
ben_icm_life_events.g_cache_pep_object (l_count).rt_los_val,
ben_icm_life_events.g_cache_pep_object (l_count).rt_los_uom,
ben_icm_life_events.g_cache_pep_object (l_count).rt_hrs_wkd_val,
ben_icm_life_events.g_cache_pep_object (l_count).rt_hrs_wkd_bndry_perd_cd,
ben_icm_life_events.g_cache_pep_object (l_count).rt_pct_fl_tm_val,
ben_icm_life_events.g_cache_pep_object (l_count).rt_frz_los_flag,
ben_icm_life_events.g_cache_pep_object (l_count).rt_frz_age_flag,
ben_icm_life_events.g_cache_pep_object (l_count).rt_frz_cmp_lvl_flag,
ben_icm_life_events.g_cache_pep_object (l_count).rt_frz_pct_fl_tm_flag,
ben_icm_life_events.g_cache_pep_object (l_count).rt_frz_hrs_wkd_flag,
ben_icm_life_events.g_cache_pep_object (l_count).rt_frz_comb_age_and_los_flag,
ben_icm_life_events.g_cache_pep_object (l_count).once_r_cntug_cd,
ben_icm_life_events.g_cache_pep_object (l_count).pl_ordr_num,
ben_icm_life_events.g_cache_pep_object (l_count).plip_ordr_num,
ben_icm_life_events.g_cache_pep_object (l_count).ptip_ordr_num,
ben_icm_life_events.g_cache_pep_object (l_count).object_version_number,
ben_icm_life_events.g_cache_pep_object (l_count).program_application_id,
ben_icm_life_events.g_cache_pep_object (l_count).program_id,
ben_icm_life_events.g_cache_pep_object (l_count).request_id,
ben_icm_life_events.g_cache_pep_object (l_count).program_update_date
);
ben_eligible_person_perf_api.update_perf_eligible_person
(p_validate => FALSE,
p_elig_per_id => ben_icm_life_events.g_cache_pep_object
(l_count).elig_per_id,
p_per_in_ler_id => NULL,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_elig_flag => ben_icm_life_events.g_cache_pep_object
(l_count).elig_flag,
p_prtn_strt_dt => ben_icm_life_events.g_cache_pep_object
(l_count).prtn_strt_dt,
p_rt_comp_ref_amt => ben_icm_life_events.g_cache_pep_object
(l_count).rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_comp_ref_uom,
p_rt_age_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_age_val,
p_rt_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_los_val,
p_rt_hrs_wkd_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_pep_object
(l_count).rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_age_uom,
p_rt_los_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_los_uom,
p_rt_pct_fl_tm_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_pct_fl_tm_val,
p_rt_frz_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_los_flag,
p_rt_frz_age_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_comb_age_and_los_flag,
p_once_r_cntug_cd => ben_icm_life_events.g_cache_pep_object
(l_count).once_r_cntug_cd,
p_comp_ref_amt => ben_icm_life_events.g_cache_pep_object
(l_count).comp_ref_amt,
p_cmbn_age_n_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).cmbn_age_n_los_val,
p_comp_ref_uom => ben_icm_life_events.g_cache_pep_object
(l_count).comp_ref_uom,
p_age_val => ben_icm_life_events.g_cache_pep_object
(l_count).age_val,
p_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).los_val,
p_hrs_wkd_val => ben_icm_life_events.g_cache_pep_object
(l_count).hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_pep_object
(l_count).hrs_wkd_bndry_perd_cd,
p_age_uom => ben_icm_life_events.g_cache_pep_object
(l_count).age_uom,
p_los_uom => ben_icm_life_events.g_cache_pep_object
(l_count).los_uom,
p_pct_fl_tm_val => ben_icm_life_events.g_cache_pep_object
(l_count).pct_fl_tm_val,
p_frz_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_los_flag,
p_frz_age_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_age_flag,
p_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_comb_age_and_los_flag,
p_wait_perd_cmpltn_dt => ben_icm_life_events.g_cache_pep_object
(l_count).wait_perd_cmpltn_dt,
p_wait_perd_strt_dt => ben_icm_life_events.g_cache_pep_object
(l_count).wait_perd_strt_dt,
p_object_version_number => ben_icm_life_events.g_cache_pep_object(l_count).object_version_number,
p_effective_date => ben_icm_life_events.g_cache_pep_object
(l_count).p_effective_date,
p_datetrack_mode => ben_icm_life_events.g_cache_pep_object
(l_count).p_datetrack_mode,
p_program_application_id => fnd_global.prog_appl_id,
p_program_id => fnd_global.conc_program_id,
p_request_id => fnd_global.conc_request_id,
p_program_update_date => SYSDATE
);
ben_eligible_person_perf_api.update_perf_eligible_person
(p_validate => FALSE,
p_elig_per_id => ben_icm_life_events.g_cache_pep_object
(l_count).elig_per_id,
p_per_in_ler_id => NULL,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_elig_flag => ben_icm_life_events.g_cache_pep_object
(l_count).elig_flag,
p_prtn_strt_dt => ben_icm_life_events.g_cache_pep_object
(l_count).prtn_strt_dt,
p_rt_comp_ref_amt => ben_icm_life_events.g_cache_pep_object
(l_count).rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_comp_ref_uom,
p_rt_age_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_age_val,
p_rt_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_los_val,
p_rt_hrs_wkd_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_pep_object
(l_count).rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_age_uom,
p_rt_los_uom => ben_icm_life_events.g_cache_pep_object
(l_count).rt_los_uom,
p_rt_pct_fl_tm_val => ben_icm_life_events.g_cache_pep_object
(l_count).rt_pct_fl_tm_val,
p_rt_frz_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_los_flag,
p_rt_frz_age_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).rt_frz_comb_age_and_los_flag,
p_once_r_cntug_cd => ben_icm_life_events.g_cache_pep_object
(l_count).once_r_cntug_cd,
p_comp_ref_amt => ben_icm_life_events.g_cache_pep_object
(l_count).comp_ref_amt,
p_cmbn_age_n_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).cmbn_age_n_los_val,
p_comp_ref_uom => ben_icm_life_events.g_cache_pep_object
(l_count).comp_ref_uom,
p_age_val => ben_icm_life_events.g_cache_pep_object
(l_count).age_val,
p_los_val => ben_icm_life_events.g_cache_pep_object
(l_count).los_val,
p_hrs_wkd_val => ben_icm_life_events.g_cache_pep_object
(l_count).hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_pep_object
(l_count).hrs_wkd_bndry_perd_cd,
p_age_uom => ben_icm_life_events.g_cache_pep_object
(l_count).age_uom,
p_los_uom => ben_icm_life_events.g_cache_pep_object
(l_count).los_uom,
p_pct_fl_tm_val => ben_icm_life_events.g_cache_pep_object
(l_count).pct_fl_tm_val,
p_frz_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_los_flag,
p_frz_age_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_age_flag,
p_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_pep_object
(l_count).frz_comb_age_and_los_flag,
p_wait_perd_cmpltn_dt => ben_icm_life_events.g_cache_pep_object
(l_count).wait_perd_cmpltn_dt,
p_wait_perd_strt_dt => ben_icm_life_events.g_cache_pep_object
(l_count).wait_perd_strt_dt,
p_object_version_number => ben_icm_life_events.g_cache_pep_object(l_count).object_version_number,
p_effective_date => ben_icm_life_events.g_cache_pep_object
(l_count).p_effective_date,
p_datetrack_mode => ben_icm_life_events.g_cache_pep_object
(l_count).p_datetrack_mode,
p_program_application_id => fnd_global.prog_appl_id,
p_program_id => fnd_global.conc_program_id,
p_request_id => fnd_global.conc_request_id,
p_program_update_date => SYSDATE
);
ben_eligible_person_perf_api.update_perf_elig_person_option
(p_validate => FALSE,
p_elig_per_opt_id => ben_icm_life_events.g_cache_epo_object
(v_count).elig_per_opt_id,
p_elig_per_id => ben_icm_life_events.g_cache_epo_object
(v_count).elig_per_id,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_prtn_ovridn_flag => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_ovridn_flag,
p_prtn_ovridn_thru_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_ovridn_thru_dt,
p_no_mx_prtn_ovrid_thru_flag => ben_icm_life_events.g_cache_epo_object
(v_count).no_mx_prtn_ovrid_thru_flag,
p_elig_flag => ben_icm_life_events.g_cache_epo_object
(v_count).elig_flag,
p_prtn_strt_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_strt_dt,
p_prtn_end_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_end_dt,
p_wait_perd_cmpltn_date => ben_icm_life_events.g_cache_epo_object
(v_count).wait_perd_cmpltn_date,
p_wait_perd_strt_dt => ben_icm_life_events.g_cache_epo_object
(v_count).wait_perd_strt_dt
-- ,p_prtn_ovridn_rsn_cd =>ben_icm_life_events.g_cache_epo_object(v_count).prtn_ovridn_rsn_cd
,
p_pct_fl_tm_val => ben_icm_life_events.g_cache_epo_object
(v_count).pct_fl_tm_val,
p_opt_id => ben_icm_life_events.g_cache_epo_object
(v_count).opt_id,
p_per_in_ler_id => NULL,
p_rt_comp_ref_amt => ben_icm_life_events.g_cache_epo_object
(v_count).rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_comp_ref_uom,
p_rt_age_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_age_val,
p_rt_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_los_val,
p_rt_hrs_wkd_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_epo_object
(v_count).rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_age_uom,
p_rt_los_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_los_uom,
p_rt_pct_fl_tm_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_pct_fl_tm_val,
p_rt_frz_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_los_flag,
p_rt_frz_age_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_comb_age_and_los_flag,
p_comp_ref_amt => ben_icm_life_events.g_cache_epo_object
(v_count).comp_ref_amt,
p_cmbn_age_n_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).cmbn_age_n_los_val,
p_comp_ref_uom => ben_icm_life_events.g_cache_epo_object
(v_count).comp_ref_uom,
p_age_val => ben_icm_life_events.g_cache_epo_object
(v_count).age_val,
p_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).los_val,
p_hrs_wkd_val => ben_icm_life_events.g_cache_epo_object
(v_count).hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_epo_object
(v_count).hrs_wkd_bndry_perd_cd,
p_age_uom => ben_icm_life_events.g_cache_epo_object
(v_count).age_uom,
p_los_uom => ben_icm_life_events.g_cache_epo_object
(v_count).los_uom,
p_frz_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_los_flag,
p_frz_age_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_age_flag,
p_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_comb_age_and_los_flag
-- ,p_ovrid_svc_dt =>ben_icm_life_events.g_cache_epo_object(v_count).ovrid_svc_dt
,
p_inelg_rsn_cd => ben_icm_life_events.g_cache_epo_object
(v_count).inelg_rsn_cd,
p_once_r_cntug_cd => ben_icm_life_events.g_cache_epo_object
(v_count).once_r_cntug_cd,
p_oipl_ordr_num => ben_icm_life_events.g_cache_epo_object
(v_count).oipl_ordr_num,
p_business_group_id => ben_icm_life_events.g_cache_epo_object
(v_count).business_group_id,
p_request_id => ben_icm_life_events.g_cache_epo_object
(v_count).request_id,
p_program_application_id => ben_icm_life_events.g_cache_epo_object
(v_count).program_application_id,
p_program_id => ben_icm_life_events.g_cache_epo_object
(v_count).program_id,
p_program_update_date => ben_icm_life_events.g_cache_epo_object
(v_count).program_update_date,
p_object_version_number => ben_icm_life_events.g_cache_epo_object(v_count).object_version_number,
p_effective_date => ben_icm_life_events.g_cache_epo_object
(v_count).p_effective_date,
p_datetrack_mode => ben_icm_life_events.g_cache_epo_object
(v_count).p_datetrack_mode
);
hr_utility.set_location ('Insert Mode for EPO' || ben_icm_life_events.g_cache_epo_object (v_count).elig_per_opt_id, 1234);
INSERT INTO ben_elig_per_opt_f
(elig_per_opt_id,
elig_per_id,
effective_start_date,
effective_end_date,
prtn_ovridn_flag,
prtn_ovridn_thru_dt,
no_mx_prtn_ovrid_thru_flag,
elig_flag,
prtn_strt_dt,
pct_fl_tm_val,
opt_id,
business_group_id,
request_id,
program_application_id,
program_id,
program_update_date,
age_uom,
age_val,
cmbn_age_n_los_val,
comp_ref_amt,
comp_ref_uom,
frz_age_flag,
frz_cmp_lvl_flag,
frz_comb_age_and_los_flag,
frz_hrs_wkd_flag,
frz_los_flag,
frz_pct_fl_tm_flag,
hrs_wkd_bndry_perd_cd,
hrs_wkd_val,
los_uom,
los_val,
rt_comp_ref_amt,
rt_cmbn_age_n_los_val,
rt_comp_ref_uom,
rt_age_val,
rt_los_val,
rt_hrs_wkd_val,
rt_hrs_wkd_bndry_perd_cd,
rt_age_uom,
rt_los_uom,
rt_pct_fl_tm_val,
rt_frz_los_flag,
rt_frz_age_flag,
rt_frz_cmp_lvl_flag,
rt_frz_pct_fl_tm_flag,
rt_frz_hrs_wkd_flag,
rt_frz_comb_age_and_los_flag,
once_r_cntug_cd,
wait_perd_cmpltn_dt,
per_in_ler_id,
wait_perd_strt_dt,
wait_perd_cmpltn_date,
object_version_number
)
VALUES (ben_icm_life_events.g_cache_epo_object (v_count).elig_per_opt_id,
ben_icm_life_events.g_cache_epo_object (v_count).elig_per_id,
ben_icm_life_events.g_cache_epo_object (v_count).effective_start_date,
ben_icm_life_events.g_cache_epo_object (v_count).effective_end_date,
ben_icm_life_events.g_cache_epo_object (v_count).prtn_ovridn_flag,
ben_icm_life_events.g_cache_epo_object (v_count).prtn_ovridn_thru_dt,
ben_icm_life_events.g_cache_epo_object (v_count).no_mx_prtn_ovrid_thru_flag,
ben_icm_life_events.g_cache_epo_object (v_count).elig_flag,
ben_icm_life_events.g_cache_epo_object (v_count).prtn_strt_dt,
ben_icm_life_events.g_cache_epo_object (v_count).pct_fl_tm_val,
ben_icm_life_events.g_cache_epo_object (v_count).opt_id,
ben_icm_life_events.g_cache_epo_object (v_count).business_group_id,
ben_icm_life_events.g_cache_epo_object (v_count).request_id,
ben_icm_life_events.g_cache_epo_object (v_count).program_application_id,
ben_icm_life_events.g_cache_epo_object (v_count).program_id,
ben_icm_life_events.g_cache_epo_object (v_count).program_update_date,
ben_icm_life_events.g_cache_epo_object (v_count).age_uom,
ben_icm_life_events.g_cache_epo_object (v_count).age_val,
ben_icm_life_events.g_cache_epo_object (v_count).cmbn_age_n_los_val,
ben_icm_life_events.g_cache_epo_object (v_count).comp_ref_amt,
ben_icm_life_events.g_cache_epo_object (v_count).comp_ref_uom,
ben_icm_life_events.g_cache_epo_object (v_count).frz_age_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_cmp_lvl_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_comb_age_and_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_hrs_wkd_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_pct_fl_tm_flag,
ben_icm_life_events.g_cache_epo_object (v_count).hrs_wkd_bndry_perd_cd,
ben_icm_life_events.g_cache_epo_object (v_count).hrs_wkd_val,
ben_icm_life_events.g_cache_epo_object (v_count).los_uom,
ben_icm_life_events.g_cache_epo_object (v_count).los_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_comp_ref_amt,
ben_icm_life_events.g_cache_epo_object (v_count).rt_cmbn_age_n_los_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_comp_ref_uom,
ben_icm_life_events.g_cache_epo_object (v_count).rt_age_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_los_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_hrs_wkd_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_hrs_wkd_bndry_perd_cd,
ben_icm_life_events.g_cache_epo_object (v_count).rt_age_uom,
ben_icm_life_events.g_cache_epo_object (v_count).rt_los_uom,
ben_icm_life_events.g_cache_epo_object (v_count).rt_pct_fl_tm_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_age_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_cmp_lvl_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_pct_fl_tm_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_hrs_wkd_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_comb_age_and_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).once_r_cntug_cd,
ben_icm_life_events.g_cache_epo_object (v_count).wait_perd_cmpltn_dt,
NULL,
ben_icm_life_events.g_cache_epo_object (v_count).wait_perd_strt_dt,
ben_icm_life_events.g_cache_epo_object (v_count).wait_perd_cmpltn_date,
ben_icm_life_events.g_cache_epo_object (v_count).object_version_number
);
ben_eligible_person_perf_api.update_perf_elig_person_option
(p_validate => FALSE,
p_elig_per_opt_id => ben_icm_life_events.g_cache_epo_object
(v_count).elig_per_opt_id,
p_elig_per_id => ben_icm_life_events.g_cache_epo_object
(v_count).elig_per_id,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_prtn_ovridn_flag => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_ovridn_flag,
p_prtn_ovridn_thru_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_ovridn_thru_dt,
p_no_mx_prtn_ovrid_thru_flag => ben_icm_life_events.g_cache_epo_object
(v_count).no_mx_prtn_ovrid_thru_flag,
p_elig_flag => ben_icm_life_events.g_cache_epo_object
(v_count).elig_flag,
p_prtn_strt_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_strt_dt,
p_prtn_end_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_end_dt,
p_wait_perd_cmpltn_date => ben_icm_life_events.g_cache_epo_object
(v_count).wait_perd_cmpltn_date,
p_wait_perd_strt_dt => ben_icm_life_events.g_cache_epo_object
(v_count).wait_perd_strt_dt
-- ,p_prtn_ovridn_rsn_cd =>ben_icm_life_events.g_cache_epo_object(v_count).prtn_ovridn_rsn_cd
,
p_pct_fl_tm_val => ben_icm_life_events.g_cache_epo_object
(v_count).pct_fl_tm_val,
p_opt_id => ben_icm_life_events.g_cache_epo_object
(v_count).opt_id,
p_per_in_ler_id => NULL,
p_rt_comp_ref_amt => ben_icm_life_events.g_cache_epo_object
(v_count).rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_comp_ref_uom,
p_rt_age_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_age_val,
p_rt_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_los_val,
p_rt_hrs_wkd_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_epo_object
(v_count).rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_age_uom,
p_rt_los_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_los_uom,
p_rt_pct_fl_tm_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_pct_fl_tm_val,
p_rt_frz_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_los_flag,
p_rt_frz_age_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_comb_age_and_los_flag,
p_comp_ref_amt => ben_icm_life_events.g_cache_epo_object
(v_count).comp_ref_amt,
p_cmbn_age_n_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).cmbn_age_n_los_val,
p_comp_ref_uom => ben_icm_life_events.g_cache_epo_object
(v_count).comp_ref_uom,
p_age_val => ben_icm_life_events.g_cache_epo_object
(v_count).age_val,
p_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).los_val,
p_hrs_wkd_val => ben_icm_life_events.g_cache_epo_object
(v_count).hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_epo_object
(v_count).hrs_wkd_bndry_perd_cd,
p_age_uom => ben_icm_life_events.g_cache_epo_object
(v_count).age_uom,
p_los_uom => ben_icm_life_events.g_cache_epo_object
(v_count).los_uom,
p_frz_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_los_flag,
p_frz_age_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_age_flag,
p_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_comb_age_and_los_flag
-- ,p_ovrid_svc_dt =>ben_icm_life_events.g_cache_epo_object(v_count).ovrid_svc_dt
,
p_inelg_rsn_cd => ben_icm_life_events.g_cache_epo_object
(v_count).inelg_rsn_cd,
p_once_r_cntug_cd => ben_icm_life_events.g_cache_epo_object
(v_count).once_r_cntug_cd,
p_oipl_ordr_num => ben_icm_life_events.g_cache_epo_object
(v_count).oipl_ordr_num,
p_business_group_id => ben_icm_life_events.g_cache_epo_object
(v_count).business_group_id,
p_request_id => ben_icm_life_events.g_cache_epo_object
(v_count).request_id,
p_program_application_id => ben_icm_life_events.g_cache_epo_object
(v_count).program_application_id,
p_program_id => ben_icm_life_events.g_cache_epo_object
(v_count).program_id,
p_program_update_date => ben_icm_life_events.g_cache_epo_object
(v_count).program_update_date,
p_object_version_number => ben_icm_life_events.g_cache_epo_object(v_count).object_version_number,
p_effective_date => ben_icm_life_events.g_cache_epo_object
(v_count).p_effective_date,
p_datetrack_mode => ben_icm_life_events.g_cache_epo_object
(v_count).p_datetrack_mode
);
INSERT INTO ben_elig_per_opt_f
(elig_per_opt_id,
elig_per_id,
effective_start_date,
effective_end_date,
prtn_ovridn_flag,
prtn_ovridn_thru_dt,
no_mx_prtn_ovrid_thru_flag,
elig_flag,
prtn_strt_dt,
pct_fl_tm_val,
opt_id,
business_group_id,
request_id,
program_application_id,
program_id,
program_update_date,
age_uom,
age_val,
cmbn_age_n_los_val,
comp_ref_amt,
comp_ref_uom,
frz_age_flag,
frz_cmp_lvl_flag,
frz_comb_age_and_los_flag,
frz_hrs_wkd_flag,
frz_los_flag,
frz_pct_fl_tm_flag,
hrs_wkd_bndry_perd_cd,
hrs_wkd_val,
los_uom,
los_val,
rt_comp_ref_amt,
rt_cmbn_age_n_los_val,
rt_comp_ref_uom,
rt_age_val,
rt_los_val,
rt_hrs_wkd_val,
rt_hrs_wkd_bndry_perd_cd,
rt_age_uom,
rt_los_uom,
rt_pct_fl_tm_val,
rt_frz_los_flag,
rt_frz_age_flag,
rt_frz_cmp_lvl_flag,
rt_frz_pct_fl_tm_flag,
rt_frz_hrs_wkd_flag,
rt_frz_comb_age_and_los_flag,
once_r_cntug_cd,
wait_perd_cmpltn_dt,
per_in_ler_id,
wait_perd_strt_dt,
wait_perd_cmpltn_date,
object_version_number
)
VALUES (ben_icm_life_events.g_cache_epo_object (v_count).elig_per_opt_id,
ben_icm_life_events.g_cache_epo_object (v_count).elig_per_id,
ben_icm_life_events.g_cache_epo_object (v_count).effective_start_date,
ben_icm_life_events.g_cache_epo_object (v_count).effective_end_date,
ben_icm_life_events.g_cache_epo_object (v_count).prtn_ovridn_flag,
ben_icm_life_events.g_cache_epo_object (v_count).prtn_ovridn_thru_dt,
ben_icm_life_events.g_cache_epo_object (v_count).no_mx_prtn_ovrid_thru_flag,
ben_icm_life_events.g_cache_epo_object (v_count).elig_flag,
ben_icm_life_events.g_cache_epo_object (v_count).prtn_strt_dt,
ben_icm_life_events.g_cache_epo_object (v_count).pct_fl_tm_val,
ben_icm_life_events.g_cache_epo_object (v_count).opt_id,
ben_icm_life_events.g_cache_epo_object (v_count).business_group_id,
ben_icm_life_events.g_cache_epo_object (v_count).request_id,
ben_icm_life_events.g_cache_epo_object (v_count).program_application_id,
ben_icm_life_events.g_cache_epo_object (v_count).program_id,
ben_icm_life_events.g_cache_epo_object (v_count).program_update_date,
ben_icm_life_events.g_cache_epo_object (v_count).age_uom,
ben_icm_life_events.g_cache_epo_object (v_count).age_val,
ben_icm_life_events.g_cache_epo_object (v_count).cmbn_age_n_los_val,
ben_icm_life_events.g_cache_epo_object (v_count).comp_ref_amt,
ben_icm_life_events.g_cache_epo_object (v_count).comp_ref_uom,
ben_icm_life_events.g_cache_epo_object (v_count).frz_age_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_cmp_lvl_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_comb_age_and_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_hrs_wkd_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).frz_pct_fl_tm_flag,
ben_icm_life_events.g_cache_epo_object (v_count).hrs_wkd_bndry_perd_cd,
ben_icm_life_events.g_cache_epo_object (v_count).hrs_wkd_val,
ben_icm_life_events.g_cache_epo_object (v_count).los_uom,
ben_icm_life_events.g_cache_epo_object (v_count).los_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_comp_ref_amt,
ben_icm_life_events.g_cache_epo_object (v_count).rt_cmbn_age_n_los_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_comp_ref_uom,
ben_icm_life_events.g_cache_epo_object (v_count).rt_age_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_los_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_hrs_wkd_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_hrs_wkd_bndry_perd_cd,
ben_icm_life_events.g_cache_epo_object (v_count).rt_age_uom,
ben_icm_life_events.g_cache_epo_object (v_count).rt_los_uom,
ben_icm_life_events.g_cache_epo_object (v_count).rt_pct_fl_tm_val,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_age_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_cmp_lvl_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_pct_fl_tm_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_hrs_wkd_flag,
ben_icm_life_events.g_cache_epo_object (v_count).rt_frz_comb_age_and_los_flag,
ben_icm_life_events.g_cache_epo_object (v_count).once_r_cntug_cd,
ben_icm_life_events.g_cache_epo_object (v_count).wait_perd_cmpltn_dt,
NULL,
ben_icm_life_events.g_cache_epo_object (v_count).wait_perd_strt_dt,
ben_icm_life_events.g_cache_epo_object (v_count).wait_perd_cmpltn_date,
ben_icm_life_events.g_cache_epo_object (v_count).object_version_number
);
ben_eligible_person_perf_api.update_perf_elig_person_option
(p_validate => FALSE,
p_elig_per_opt_id => ben_icm_life_events.g_cache_epo_object
(v_count).elig_per_opt_id,
p_elig_per_id => ben_icm_life_events.g_cache_epo_object
(v_count).elig_per_id,
p_effective_start_date => l_effective_start_date,
p_effective_end_date => l_effective_end_date,
p_prtn_ovridn_flag => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_ovridn_flag,
p_prtn_ovridn_thru_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_ovridn_thru_dt,
p_no_mx_prtn_ovrid_thru_flag => ben_icm_life_events.g_cache_epo_object
(v_count).no_mx_prtn_ovrid_thru_flag,
p_elig_flag => ben_icm_life_events.g_cache_epo_object
(v_count).elig_flag,
p_prtn_strt_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_strt_dt,
p_prtn_end_dt => ben_icm_life_events.g_cache_epo_object
(v_count).prtn_end_dt,
p_wait_perd_cmpltn_date => ben_icm_life_events.g_cache_epo_object
(v_count).wait_perd_cmpltn_date,
p_wait_perd_strt_dt => ben_icm_life_events.g_cache_epo_object
(v_count).wait_perd_strt_dt
-- ,p_prtn_ovridn_rsn_cd =>ben_icm_life_events.g_cache_epo_object(v_count).prtn_ovridn_rsn_cd
,
p_pct_fl_tm_val => ben_icm_life_events.g_cache_epo_object
(v_count).pct_fl_tm_val,
p_opt_id => ben_icm_life_events.g_cache_epo_object
(v_count).opt_id,
p_per_in_ler_id => NULL,
p_rt_comp_ref_amt => ben_icm_life_events.g_cache_epo_object
(v_count).rt_comp_ref_amt,
p_rt_cmbn_age_n_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_cmbn_age_n_los_val,
p_rt_comp_ref_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_comp_ref_uom,
p_rt_age_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_age_val,
p_rt_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_los_val,
p_rt_hrs_wkd_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_hrs_wkd_val,
p_rt_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_epo_object
(v_count).rt_hrs_wkd_bndry_perd_cd,
p_rt_age_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_age_uom,
p_rt_los_uom => ben_icm_life_events.g_cache_epo_object
(v_count).rt_los_uom,
p_rt_pct_fl_tm_val => ben_icm_life_events.g_cache_epo_object
(v_count).rt_pct_fl_tm_val,
p_rt_frz_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_los_flag,
p_rt_frz_age_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_age_flag,
p_rt_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_cmp_lvl_flag,
p_rt_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_pct_fl_tm_flag,
p_rt_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_hrs_wkd_flag,
p_rt_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).rt_frz_comb_age_and_los_flag,
p_comp_ref_amt => ben_icm_life_events.g_cache_epo_object
(v_count).comp_ref_amt,
p_cmbn_age_n_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).cmbn_age_n_los_val,
p_comp_ref_uom => ben_icm_life_events.g_cache_epo_object
(v_count).comp_ref_uom,
p_age_val => ben_icm_life_events.g_cache_epo_object
(v_count).age_val,
p_los_val => ben_icm_life_events.g_cache_epo_object
(v_count).los_val,
p_hrs_wkd_val => ben_icm_life_events.g_cache_epo_object
(v_count).hrs_wkd_val,
p_hrs_wkd_bndry_perd_cd => ben_icm_life_events.g_cache_epo_object
(v_count).hrs_wkd_bndry_perd_cd,
p_age_uom => ben_icm_life_events.g_cache_epo_object
(v_count).age_uom,
p_los_uom => ben_icm_life_events.g_cache_epo_object
(v_count).los_uom,
p_frz_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_los_flag,
p_frz_age_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_age_flag,
p_frz_cmp_lvl_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_cmp_lvl_flag,
p_frz_pct_fl_tm_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_pct_fl_tm_flag,
p_frz_hrs_wkd_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_hrs_wkd_flag,
p_frz_comb_age_and_los_flag => ben_icm_life_events.g_cache_epo_object
(v_count).frz_comb_age_and_los_flag,
p_inelg_rsn_cd => ben_icm_life_events.g_cache_epo_object
(v_count).inelg_rsn_cd,
p_once_r_cntug_cd => ben_icm_life_events.g_cache_epo_object
(v_count).once_r_cntug_cd,
p_oipl_ordr_num => ben_icm_life_events.g_cache_epo_object
(v_count).oipl_ordr_num,
p_business_group_id => ben_icm_life_events.g_cache_epo_object
(v_count).business_group_id,
p_request_id => ben_icm_life_events.g_cache_epo_object
(v_count).request_id,
p_program_application_id => ben_icm_life_events.g_cache_epo_object
(v_count).program_application_id,
p_program_id => ben_icm_life_events.g_cache_epo_object
(v_count).program_id,
p_program_update_date => ben_icm_life_events.g_cache_epo_object
(v_count).program_update_date,
p_object_version_number => ben_icm_life_events.g_cache_epo_object(v_count).object_version_number,
p_effective_date => ben_icm_life_events.g_cache_epo_object
(v_count).p_effective_date,
p_datetrack_mode => ben_icm_life_events.g_cache_epo_object
(v_count).p_datetrack_mode
);
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
DELETE FROM ben_icd_chc_rates
WHERE person_id = p_person_id;
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
p_comp_selection_rule_id => NULL,
p_person_selection_rule_id => NULL,
p_ler_id => NULL,
p_organization_id => NULL,
p_benfts_grp_id => NULL,
p_location_id => NULL,
p_pstl_zip_rng_id => NULL,
p_rptg_grp_id => NULL,
p_pl_typ_id => NULL,
p_opt_id => NULL,
p_eligy_prfl_id => NULL,
p_vrbl_rt_prfl_id => NULL,
p_legal_entity_id => NULL,
p_payroll_id => NULL,
p_commit_data => 'N',
p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
);
p_comp_selection_rule_id => NULL,
p_effective_date => p_effective_date,
p_pgm_id => NULL,
p_business_group_id => p_business_group_id,
p_pl_id => NULL,
p_oipl_id => NULL,
p_asnd_lf_evt_dt => NULL,
p_no_programs => 'N',
p_no_plans => 'N',
p_rptg_grp_id => NULL,
p_pl_typ_id => NULL,
p_opt_id => NULL,
p_eligy_prfl_id => NULL,
p_vrbl_rt_prfl_id => NULL,
p_thread_id => 1,
p_mode => 'D'
);
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;
ben_icm_life_events.g_cache_pep_object.DELETE;
ben_icm_life_events.g_cache_epo_object.DELETE;
ben_determine_activity_base_rt.l_icd_chc_rates_tab.DELETE;