1974: p_wait_perd_cmpltn_date => l_wait_perd_cmpltn_dt,
1975: p_effective_date => l_effective_dt,
1976: p_object_version_number => l_object_version_number_opt,
1977: p_datetrack_mode => l_datetrack_mode,
1978: p_program_application_id => fnd_global.prog_appl_id,
1979: p_program_id => fnd_global.conc_program_id,
1980: p_request_id => fnd_global.conc_request_id,
1981: p_program_update_date => sysdate);
1982: --
1975: p_effective_date => l_effective_dt,
1976: p_object_version_number => l_object_version_number_opt,
1977: p_datetrack_mode => l_datetrack_mode,
1978: p_program_application_id => fnd_global.prog_appl_id,
1979: p_program_id => fnd_global.conc_program_id,
1980: p_request_id => fnd_global.conc_request_id,
1981: p_program_update_date => sysdate);
1982: --
1983:
1976: p_object_version_number => l_object_version_number_opt,
1977: p_datetrack_mode => l_datetrack_mode,
1978: p_program_application_id => fnd_global.prog_appl_id,
1979: p_program_id => fnd_global.conc_program_id,
1980: p_request_id => fnd_global.conc_request_id,
1981: p_program_update_date => sysdate);
1982: --
1983:
1984: if p_score_tab.count > 0 then
2054: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
2055: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2056: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2057: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2058: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2059: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2060: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2061: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2062: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= 'UPDATE';
2055: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2056: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2057: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2058: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2059: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2060: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2061: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2062: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= 'UPDATE';
2063: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_t_effective_dt;
2056: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2057: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2058: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2059: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2060: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2061: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2062: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= 'UPDATE';
2063: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_t_effective_dt;
2064: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2313: p_effective_end_date => l_effective_end_date,
2314: p_object_version_number => l_object_version_number_opt,
2315: p_oipl_ordr_num => l_oipl_rec.ordr_num,
2316: p_business_group_id => p_business_group_id,
2317: p_program_application_id => fnd_global.prog_appl_id,
2318: p_program_id => fnd_global.conc_program_id,
2319: p_request_id => fnd_global.conc_request_id,
2320: p_program_update_date => sysdate,
2321: --
2314: p_object_version_number => l_object_version_number_opt,
2315: p_oipl_ordr_num => l_oipl_rec.ordr_num,
2316: p_business_group_id => p_business_group_id,
2317: p_program_application_id => fnd_global.prog_appl_id,
2318: p_program_id => fnd_global.conc_program_id,
2319: p_request_id => fnd_global.conc_request_id,
2320: p_program_update_date => sysdate,
2321: --
2322: -- Bugs : 1412882, part of bug 1412951
2315: p_oipl_ordr_num => l_oipl_rec.ordr_num,
2316: p_business_group_id => p_business_group_id,
2317: p_program_application_id => fnd_global.prog_appl_id,
2318: p_program_id => fnd_global.conc_program_id,
2319: p_request_id => fnd_global.conc_request_id,
2320: p_program_update_date => sysdate,
2321: --
2322: -- Bugs : 1412882, part of bug 1412951
2323: --
2391: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2392: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
2393: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2394: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
2395: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2396: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2397: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2398: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2399: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2392: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
2393: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2394: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
2395: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2396: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2397: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2398: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2399: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2400: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2393: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2394: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
2395: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2396: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2397: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2398: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2399: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2400: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2401: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_inelig:= l_newly_inelig;
2568: p_effective_date => l_effective_dt,
2569: -- p_effective_date => p_effective_date,
2570: p_object_version_number => l_object_version_number_opt,
2571: p_datetrack_mode => l_datetrack_mode,
2572: p_program_application_id => fnd_global.prog_appl_id,
2573: p_program_id => fnd_global.conc_program_id,
2574: p_request_id => fnd_global.conc_request_id,
2575: p_program_update_date => sysdate);
2576: --
2569: -- p_effective_date => p_effective_date,
2570: p_object_version_number => l_object_version_number_opt,
2571: p_datetrack_mode => l_datetrack_mode,
2572: p_program_application_id => fnd_global.prog_appl_id,
2573: p_program_id => fnd_global.conc_program_id,
2574: p_request_id => fnd_global.conc_request_id,
2575: p_program_update_date => sysdate);
2576: --
2577: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
2570: p_object_version_number => l_object_version_number_opt,
2571: p_datetrack_mode => l_datetrack_mode,
2572: p_program_application_id => fnd_global.prog_appl_id,
2573: p_program_id => fnd_global.conc_program_id,
2574: p_request_id => fnd_global.conc_request_id,
2575: p_program_update_date => sysdate);
2576: --
2577: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
2578: --
2632: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
2633: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2634: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2635: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2636: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2637: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2638: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2639: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2640: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2633: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2634: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2635: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2636: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2637: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2638: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2639: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2640: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2641: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2634: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2635: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2636: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2637: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2638: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2639: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2640: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2641: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2642: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2729: -- p_effective_date => p_effective_date,
2730: p_effective_date => l_effective_dt,
2731: p_object_version_number => l_object_version_number_opt,
2732: p_datetrack_mode => hr_api.g_correction,
2733: p_program_application_id => fnd_global.prog_appl_id,
2734: p_program_id => fnd_global.conc_program_id,
2735: p_request_id => fnd_global.conc_request_id,
2736: p_program_update_date => sysdate);
2737: --
2730: p_effective_date => l_effective_dt,
2731: p_object_version_number => l_object_version_number_opt,
2732: p_datetrack_mode => hr_api.g_correction,
2733: p_program_application_id => fnd_global.prog_appl_id,
2734: p_program_id => fnd_global.conc_program_id,
2735: p_request_id => fnd_global.conc_request_id,
2736: p_program_update_date => sysdate);
2737: --
2738: --
2731: p_object_version_number => l_object_version_number_opt,
2732: p_datetrack_mode => hr_api.g_correction,
2733: p_program_application_id => fnd_global.prog_appl_id,
2734: p_program_id => fnd_global.conc_program_id,
2735: p_request_id => fnd_global.conc_request_id,
2736: p_program_update_date => sysdate);
2737: --
2738: --
2739: end if;
2871: p_effective_date => l_effective_dt,
2872: -- p_effective_date => p_effective_date,
2873: p_object_version_number => l_object_version_number_opt,
2874: p_datetrack_mode => l_datetrack_mode,
2875: p_program_application_id => fnd_global.prog_appl_id,
2876: p_program_id => fnd_global.conc_program_id,
2877: p_request_id => fnd_global.conc_request_id,
2878: p_program_update_date => sysdate);
2879: --
2872: -- p_effective_date => p_effective_date,
2873: p_object_version_number => l_object_version_number_opt,
2874: p_datetrack_mode => l_datetrack_mode,
2875: p_program_application_id => fnd_global.prog_appl_id,
2876: p_program_id => fnd_global.conc_program_id,
2877: p_request_id => fnd_global.conc_request_id,
2878: p_program_update_date => sysdate);
2879: --
2880: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
2873: p_object_version_number => l_object_version_number_opt,
2874: p_datetrack_mode => l_datetrack_mode,
2875: p_program_application_id => fnd_global.prog_appl_id,
2876: p_program_id => fnd_global.conc_program_id,
2877: p_request_id => fnd_global.conc_request_id,
2878: p_program_update_date => sysdate);
2879: --
2880: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
2881: --
2936: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
2937: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2938: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2939: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2940: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2941: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2942: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2943: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2944: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2937: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2938: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2939: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2940: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2941: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2942: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2943: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2944: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2945: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2938: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2939: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2940: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2941: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2942: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2943: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2944: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2945: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2946: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
3017: -- p_effective_date => p_effective_date,
3018: p_effective_date => l_effective_dt,
3019: p_object_version_number => l_object_version_number_opt,
3020: p_datetrack_mode => hr_api.g_correction,
3021: p_program_application_id => fnd_global.prog_appl_id,
3022: p_program_id => fnd_global.conc_program_id,
3023: p_request_id => fnd_global.conc_request_id,
3024: p_program_update_date => sysdate);
3025: --
3018: p_effective_date => l_effective_dt,
3019: p_object_version_number => l_object_version_number_opt,
3020: p_datetrack_mode => hr_api.g_correction,
3021: p_program_application_id => fnd_global.prog_appl_id,
3022: p_program_id => fnd_global.conc_program_id,
3023: p_request_id => fnd_global.conc_request_id,
3024: p_program_update_date => sysdate);
3025: --
3026: end if; --p
3019: p_object_version_number => l_object_version_number_opt,
3020: p_datetrack_mode => hr_api.g_correction,
3021: p_program_application_id => fnd_global.prog_appl_id,
3022: p_program_id => fnd_global.conc_program_id,
3023: p_request_id => fnd_global.conc_request_id,
3024: p_program_update_date => sysdate);
3025: --
3026: end if; --p
3027: --
3120: p_effective_date => l_effective_dt,
3121: -- p_effective_date => p_effective_date,
3122: p_object_version_number => l_object_version_number_opt,
3123: p_datetrack_mode => l_datetrack_mode,
3124: p_program_application_id => fnd_global.prog_appl_id,
3125: p_program_id => fnd_global.conc_program_id,
3126: p_request_id => fnd_global.conc_request_id,
3127: p_program_update_date => sysdate,
3128: p_inelg_rsn_cd => p_inelg_rsn_cd);
3121: -- p_effective_date => p_effective_date,
3122: p_object_version_number => l_object_version_number_opt,
3123: p_datetrack_mode => l_datetrack_mode,
3124: p_program_application_id => fnd_global.prog_appl_id,
3125: p_program_id => fnd_global.conc_program_id,
3126: p_request_id => fnd_global.conc_request_id,
3127: p_program_update_date => sysdate,
3128: p_inelg_rsn_cd => p_inelg_rsn_cd);
3129: --
3122: p_object_version_number => l_object_version_number_opt,
3123: p_datetrack_mode => l_datetrack_mode,
3124: p_program_application_id => fnd_global.prog_appl_id,
3125: p_program_id => fnd_global.conc_program_id,
3126: p_request_id => fnd_global.conc_request_id,
3127: p_program_update_date => sysdate,
3128: p_inelg_rsn_cd => p_inelg_rsn_cd);
3129: --
3130:
3185: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3186: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3187: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3188: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3189: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3190: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3191: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3192: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3193: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3186: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3187: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3188: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3189: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3190: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3191: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3192: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3193: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3194: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3187: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3188: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3189: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3190: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3191: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3192: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3193: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3194: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3195: ben_icm_life_events.g_cache_epo_object(l_count_icm1).inelg_rsn_cd := p_inelg_rsn_cd;
3376: --
3377: p_effective_date => l_effective_dt,
3378: -- p_effective_date => p_effective_date,
3379: p_object_version_number => l_object_version_number_opt,
3380: p_program_application_id => fnd_global.prog_appl_id,
3381: p_program_id => fnd_global.conc_program_id,
3382: p_request_id => fnd_global.conc_request_id,
3383: p_program_update_date => sysdate,
3384: p_inelg_rsn_cd => p_inelg_rsn_cd
3377: p_effective_date => l_effective_dt,
3378: -- p_effective_date => p_effective_date,
3379: p_object_version_number => l_object_version_number_opt,
3380: p_program_application_id => fnd_global.prog_appl_id,
3381: p_program_id => fnd_global.conc_program_id,
3382: p_request_id => fnd_global.conc_request_id,
3383: p_program_update_date => sysdate,
3384: p_inelg_rsn_cd => p_inelg_rsn_cd
3385: --
3378: -- p_effective_date => p_effective_date,
3379: p_object_version_number => l_object_version_number_opt,
3380: p_program_application_id => fnd_global.prog_appl_id,
3381: p_program_id => fnd_global.conc_program_id,
3382: p_request_id => fnd_global.conc_request_id,
3383: p_program_update_date => sysdate,
3384: p_inelg_rsn_cd => p_inelg_rsn_cd
3385: --
3386: -- Bypass insert validate validation for performance
3449: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3450: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3451: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
3452: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
3453: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3454: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3455: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3456: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3457: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3450: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3451: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
3452: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
3453: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3454: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3455: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3456: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3457: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3458: ben_icm_life_events.g_cache_epo_object(l_count_icm1).inelg_rsn_cd := p_inelg_rsn_cd;
3451: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
3452: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
3453: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3454: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3455: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3456: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3457: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3458: ben_icm_life_events.g_cache_epo_object(l_count_icm1).inelg_rsn_cd := p_inelg_rsn_cd;
3459: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
3611: p_effective_end_date => l_effective_end_date,
3612: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3613: p_oipl_ordr_num => null,
3614: p_business_group_id => p_business_group_id,
3615: p_program_application_id => fnd_global.prog_appl_id,
3616: p_program_id => fnd_global.conc_program_id,
3617: p_request_id => fnd_global.conc_request_id,
3618: p_program_update_date => sysdate,
3619: --
3612: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3613: p_oipl_ordr_num => null,
3614: p_business_group_id => p_business_group_id,
3615: p_program_application_id => fnd_global.prog_appl_id,
3616: p_program_id => fnd_global.conc_program_id,
3617: p_request_id => fnd_global.conc_request_id,
3618: p_program_update_date => sysdate,
3619: --
3620: -- Bugs : 1412882, part of bug 1412951
3613: p_oipl_ordr_num => null,
3614: p_business_group_id => p_business_group_id,
3615: p_program_application_id => fnd_global.prog_appl_id,
3616: p_program_id => fnd_global.conc_program_id,
3617: p_request_id => fnd_global.conc_request_id,
3618: p_program_update_date => sysdate,
3619: --
3620: -- Bugs : 1412882, part of bug 1412951
3621: --
3684: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
3685: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3686: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3687: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3688: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3689: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3690: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3691: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_prev_oiplip_elig_check.object_version_number;
3692: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3685: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3686: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3687: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3688: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3689: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3690: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3691: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_prev_oiplip_elig_check.object_version_number;
3692: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3693: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3686: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3687: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3688: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3689: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3690: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3691: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_prev_oiplip_elig_check.object_version_number;
3692: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3693: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3694: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_pl_id := l_envpl_id;
3798: p_effective_date => l_effective_dt,
3799: -- p_effective_date => p_effective_date,
3800: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3801: p_datetrack_mode => l_datetrack_mode,
3802: p_program_application_id => fnd_global.prog_appl_id,
3803: p_program_id => fnd_global.conc_program_id,
3804: p_request_id => fnd_global.conc_request_id,
3805: p_program_update_date => sysdate);
3806: --
3799: -- p_effective_date => p_effective_date,
3800: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3801: p_datetrack_mode => l_datetrack_mode,
3802: p_program_application_id => fnd_global.prog_appl_id,
3803: p_program_id => fnd_global.conc_program_id,
3804: p_request_id => fnd_global.conc_request_id,
3805: p_program_update_date => sysdate);
3806: --
3807: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
3800: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3801: p_datetrack_mode => l_datetrack_mode,
3802: p_program_application_id => fnd_global.prog_appl_id,
3803: p_program_id => fnd_global.conc_program_id,
3804: p_request_id => fnd_global.conc_request_id,
3805: p_program_update_date => sysdate);
3806: --
3807: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
3808: IF NOT ben_icm_life_events.g_cache_epo_object.EXISTS(1) THEN
3863: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
3864: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3865: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3866: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number; --l_prev_oiplip_elig_check.object_version_number-1;
3867: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3868: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3869: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3870: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3871: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3864: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3865: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3866: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number; --l_prev_oiplip_elig_check.object_version_number-1;
3867: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3868: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3869: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3870: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3871: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3872: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:=l_datetrack_mode;
3865: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3866: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number; --l_prev_oiplip_elig_check.object_version_number-1;
3867: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3868: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3869: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3870: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3871: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3872: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:=l_datetrack_mode;
3873: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_pl_id := l_envpl_id;
4297: p_wait_perd_strt_dt => l_wait_perd_strt_dt,
4298: p_object_version_number => l_object_version_number,
4299: p_effective_date => l_effective_dt,
4300: p_datetrack_mode => l_datetrack_mode,
4301: p_program_application_id => fnd_global.prog_appl_id,
4302: p_program_id => fnd_global.conc_program_id,
4303: p_request_id => fnd_global.conc_request_id,
4304: p_program_update_date => sysdate);
4305: --
4298: p_object_version_number => l_object_version_number,
4299: p_effective_date => l_effective_dt,
4300: p_datetrack_mode => l_datetrack_mode,
4301: p_program_application_id => fnd_global.prog_appl_id,
4302: p_program_id => fnd_global.conc_program_id,
4303: p_request_id => fnd_global.conc_request_id,
4304: p_program_update_date => sysdate);
4305: --
4306:
4299: p_effective_date => l_effective_dt,
4300: p_datetrack_mode => l_datetrack_mode,
4301: p_program_application_id => fnd_global.prog_appl_id,
4302: p_program_id => fnd_global.conc_program_id,
4303: p_request_id => fnd_global.conc_request_id,
4304: p_program_update_date => sysdate);
4305: --
4306:
4307: if g_debug then
4382: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag :='N';
4383: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
4384: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
4385: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4386: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4387: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
4388: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
4389: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4390: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4383: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
4384: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
4385: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4386: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4387: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
4388: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
4389: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4390: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4391: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4384: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
4385: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4386: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4387: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
4388: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
4389: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4390: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4391: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4392: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
4657: -- Bugs : 1412882, part of bug 1412951
4658: --
4659: p_effective_date => l_effective_dt,
4660: -- p_effective_date => p_effective_date,
4661: p_program_application_id => fnd_global.prog_appl_id,
4662: p_program_id => fnd_global.conc_program_id,
4663: p_request_id => fnd_global.conc_request_id,
4664: p_program_update_date => sysdate
4665: --
4658: --
4659: p_effective_date => l_effective_dt,
4660: -- p_effective_date => p_effective_date,
4661: p_program_application_id => fnd_global.prog_appl_id,
4662: p_program_id => fnd_global.conc_program_id,
4663: p_request_id => fnd_global.conc_request_id,
4664: p_program_update_date => sysdate
4665: --
4666: -- Bypass insert validate validation for performance
4659: p_effective_date => l_effective_dt,
4660: -- p_effective_date => p_effective_date,
4661: p_program_application_id => fnd_global.prog_appl_id,
4662: p_program_id => fnd_global.conc_program_id,
4663: p_request_id => fnd_global.conc_request_id,
4664: p_program_update_date => sysdate
4665: --
4666: -- Bypass insert validate validation for performance
4667: --
4738: ben_icm_life_events.g_cache_pep_object(l_count_icm).pl_ordr_num :=l_plan_ordr_num;
4739: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num := l_plip_rec.ordr_num;
4740: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num := l_ptip_rec.ordr_num;
4741: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_object_version_number;
4742: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4743: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id := fnd_global.conc_program_id;
4744: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id := fnd_global.conc_request_id;
4745: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4746: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4739: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num := l_plip_rec.ordr_num;
4740: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num := l_ptip_rec.ordr_num;
4741: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_object_version_number;
4742: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4743: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id := fnd_global.conc_program_id;
4744: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id := fnd_global.conc_request_id;
4745: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4746: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4747: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4740: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num := l_ptip_rec.ordr_num;
4741: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_object_version_number;
4742: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4743: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id := fnd_global.conc_program_id;
4744: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id := fnd_global.conc_request_id;
4745: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4746: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4747: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4748: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
4930: --
4931: p_effective_date => l_effective_dt,
4932: -- p_effective_date => p_effective_date,
4933: p_datetrack_mode => l_datetrack_mode,
4934: p_program_application_id => fnd_global.prog_appl_id,
4935: p_program_id => fnd_global.conc_program_id,
4936: p_request_id => fnd_global.conc_request_id,
4937: p_program_update_date => sysdate);
4938: --ICM
4931: p_effective_date => l_effective_dt,
4932: -- p_effective_date => p_effective_date,
4933: p_datetrack_mode => l_datetrack_mode,
4934: p_program_application_id => fnd_global.prog_appl_id,
4935: p_program_id => fnd_global.conc_program_id,
4936: p_request_id => fnd_global.conc_request_id,
4937: p_program_update_date => sysdate);
4938: --ICM
4939: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
4932: -- p_effective_date => p_effective_date,
4933: p_datetrack_mode => l_datetrack_mode,
4934: p_program_application_id => fnd_global.prog_appl_id,
4935: p_program_id => fnd_global.conc_program_id,
4936: p_request_id => fnd_global.conc_request_id,
4937: p_program_update_date => sysdate);
4938: --ICM
4939: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
4940: --
4995: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag := 'N';
4996: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag := 'N';
4997: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
4998: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4999: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5000: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5001: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5002: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5003: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4996: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag := 'N';
4997: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
4998: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4999: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5000: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5001: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5002: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5003: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5004: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4997: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
4998: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4999: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5000: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5001: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5002: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5003: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5004: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5005: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5090: p_prtn_end_dt => (l_prtn_eff_strt_dt -1),
5091: p_object_version_number => l_object_version_number,
5092: p_effective_date => l_effective_dt, -- 4947426
5093: p_datetrack_mode => hr_api.g_correction,
5094: p_program_application_id => fnd_global.prog_appl_id,
5095: p_program_id => fnd_global.conc_program_id,
5096: p_request_id => fnd_global.conc_request_id,
5097: p_program_update_date => sysdate);
5098: --
5091: p_object_version_number => l_object_version_number,
5092: p_effective_date => l_effective_dt, -- 4947426
5093: p_datetrack_mode => hr_api.g_correction,
5094: p_program_application_id => fnd_global.prog_appl_id,
5095: p_program_id => fnd_global.conc_program_id,
5096: p_request_id => fnd_global.conc_request_id,
5097: p_program_update_date => sysdate);
5098: --
5099: end if; --p
5092: p_effective_date => l_effective_dt, -- 4947426
5093: p_datetrack_mode => hr_api.g_correction,
5094: p_program_application_id => fnd_global.prog_appl_id,
5095: p_program_id => fnd_global.conc_program_id,
5096: p_request_id => fnd_global.conc_request_id,
5097: p_program_update_date => sysdate);
5098: --
5099: end if; --p
5100: --
5236: --
5237: p_effective_date => l_effective_dt,
5238: -- p_effective_date => p_effective_date,
5239: p_datetrack_mode => l_datetrack_mode,
5240: p_program_application_id => fnd_global.prog_appl_id,
5241: p_program_id => fnd_global.conc_program_id,
5242: p_request_id => fnd_global.conc_request_id,
5243: p_program_update_date => sysdate);
5244: --ICM
5237: p_effective_date => l_effective_dt,
5238: -- p_effective_date => p_effective_date,
5239: p_datetrack_mode => l_datetrack_mode,
5240: p_program_application_id => fnd_global.prog_appl_id,
5241: p_program_id => fnd_global.conc_program_id,
5242: p_request_id => fnd_global.conc_request_id,
5243: p_program_update_date => sysdate);
5244: --ICM
5245: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5238: -- p_effective_date => p_effective_date,
5239: p_datetrack_mode => l_datetrack_mode,
5240: p_program_application_id => fnd_global.prog_appl_id,
5241: p_program_id => fnd_global.conc_program_id,
5242: p_request_id => fnd_global.conc_request_id,
5243: p_program_update_date => sysdate);
5244: --ICM
5245: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5246: hr_utility.set_location('Building PEP5',214);
5304: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag :='N';
5305: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
5306: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5307: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5308: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5309: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5310: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5311: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5312: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5305: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
5306: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5307: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5308: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5309: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5310: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5311: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5312: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5313: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5306: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5307: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5308: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5309: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5310: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5311: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5312: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5313: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5314: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5395: p_object_version_number => l_object_version_number,
5396: -- p_effective_date => p_effective_date,
5397: p_effective_date => l_effective_dt,
5398: p_datetrack_mode => hr_api.g_correction,
5399: p_program_application_id => fnd_global.prog_appl_id,
5400: p_program_id => fnd_global.conc_program_id,
5401: p_request_id => fnd_global.conc_request_id,
5402: p_program_update_date => sysdate);
5403: --
5396: -- p_effective_date => p_effective_date,
5397: p_effective_date => l_effective_dt,
5398: p_datetrack_mode => hr_api.g_correction,
5399: p_program_application_id => fnd_global.prog_appl_id,
5400: p_program_id => fnd_global.conc_program_id,
5401: p_request_id => fnd_global.conc_request_id,
5402: p_program_update_date => sysdate);
5403: --
5404: hr_utility.set_location('Building epo cache1 10 : count ' || l_count_icm1,123);
5397: p_effective_date => l_effective_dt,
5398: p_datetrack_mode => hr_api.g_correction,
5399: p_program_application_id => fnd_global.prog_appl_id,
5400: p_program_id => fnd_global.conc_program_id,
5401: p_request_id => fnd_global.conc_request_id,
5402: p_program_update_date => sysdate);
5403: --
5404: hr_utility.set_location('Building epo cache1 10 : count ' || l_count_icm1,123);
5405: hr_utility.set_location('Building epo cache1 1'|| l_count_icm1,123);
5506: --
5507: p_effective_date => l_effective_dt,
5508: -- p_effective_date => p_effective_date,
5509: p_datetrack_mode => l_datetrack_mode,
5510: p_program_application_id => fnd_global.prog_appl_id,
5511: p_program_id => fnd_global.conc_program_id,
5512: p_request_id => fnd_global.conc_request_id,
5513: p_program_update_date => sysdate,
5514: p_inelg_rsn_cd => p_inelg_rsn_cd);
5507: p_effective_date => l_effective_dt,
5508: -- p_effective_date => p_effective_date,
5509: p_datetrack_mode => l_datetrack_mode,
5510: p_program_application_id => fnd_global.prog_appl_id,
5511: p_program_id => fnd_global.conc_program_id,
5512: p_request_id => fnd_global.conc_request_id,
5513: p_program_update_date => sysdate,
5514: p_inelg_rsn_cd => p_inelg_rsn_cd);
5515: --ICM
5508: -- p_effective_date => p_effective_date,
5509: p_datetrack_mode => l_datetrack_mode,
5510: p_program_application_id => fnd_global.prog_appl_id,
5511: p_program_id => fnd_global.conc_program_id,
5512: p_request_id => fnd_global.conc_request_id,
5513: p_program_update_date => sysdate,
5514: p_inelg_rsn_cd => p_inelg_rsn_cd);
5515: --ICM
5516: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5574: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag :='N';
5575: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
5576: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5577: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5578: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5579: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5580: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5581: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5582: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5575: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
5576: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5577: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5578: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5579: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5580: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5581: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5582: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5583: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5576: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5577: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5578: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5579: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5580: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5581: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5582: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5583: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5584: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5748: -- Bugs : 1412882, part of bug 1412951
5749: --
5750: p_effective_date => l_effective_dt,
5751: -- p_effective_date => p_effective_date,
5752: p_program_application_id => fnd_global.prog_appl_id,
5753: p_program_id => fnd_global.conc_program_id,
5754: p_request_id => fnd_global.conc_request_id,
5755: p_program_update_date => sysdate,
5756: p_inelg_rsn_cd => p_inelg_rsn_cd
5749: --
5750: p_effective_date => l_effective_dt,
5751: -- p_effective_date => p_effective_date,
5752: p_program_application_id => fnd_global.prog_appl_id,
5753: p_program_id => fnd_global.conc_program_id,
5754: p_request_id => fnd_global.conc_request_id,
5755: p_program_update_date => sysdate,
5756: p_inelg_rsn_cd => p_inelg_rsn_cd
5757: --
5750: p_effective_date => l_effective_dt,
5751: -- p_effective_date => p_effective_date,
5752: p_program_application_id => fnd_global.prog_appl_id,
5753: p_program_id => fnd_global.conc_program_id,
5754: p_request_id => fnd_global.conc_request_id,
5755: p_program_update_date => sysdate,
5756: p_inelg_rsn_cd => p_inelg_rsn_cd
5757: --
5758: -- Bypass insert validate validation for performance
5830: ben_icm_life_events.g_cache_pep_object(l_count_icm).pl_ordr_num :=l_plan_ordr_num;
5831: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num :=l_plip_rec.ordr_num;
5832: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num :=l_ptip_rec.ordr_num;
5833: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number :=l_object_version_number;
5834: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5835: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5836: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5837: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5838: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5831: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num :=l_plip_rec.ordr_num;
5832: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num :=l_ptip_rec.ordr_num;
5833: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number :=l_object_version_number;
5834: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5835: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5836: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5837: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5838: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5839: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5832: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num :=l_ptip_rec.ordr_num;
5833: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number :=l_object_version_number;
5834: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5835: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5836: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5837: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5838: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5839: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5840: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;