2068: p_wait_perd_cmpltn_date => l_wait_perd_cmpltn_dt,
2069: p_effective_date => l_effective_dt,
2070: p_object_version_number => l_object_version_number_opt,
2071: p_datetrack_mode => l_datetrack_mode,
2072: p_program_application_id => fnd_global.prog_appl_id,
2073: p_program_id => fnd_global.conc_program_id,
2074: p_request_id => fnd_global.conc_request_id,
2075: p_program_update_date => sysdate);
2076: --
2069: p_effective_date => l_effective_dt,
2070: p_object_version_number => l_object_version_number_opt,
2071: p_datetrack_mode => l_datetrack_mode,
2072: p_program_application_id => fnd_global.prog_appl_id,
2073: p_program_id => fnd_global.conc_program_id,
2074: p_request_id => fnd_global.conc_request_id,
2075: p_program_update_date => sysdate);
2076: --
2077:
2070: p_object_version_number => l_object_version_number_opt,
2071: p_datetrack_mode => l_datetrack_mode,
2072: p_program_application_id => fnd_global.prog_appl_id,
2073: p_program_id => fnd_global.conc_program_id,
2074: p_request_id => fnd_global.conc_request_id,
2075: p_program_update_date => sysdate);
2076: --
2077:
2078: if p_score_tab.count > 0 then
2148: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
2149: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2150: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2151: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2152: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2153: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2154: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2155: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2156: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= 'UPDATE';
2149: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2150: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2151: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2152: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2153: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2154: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2155: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2156: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= 'UPDATE';
2157: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_t_effective_dt;
2150: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2151: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2152: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2153: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2154: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2155: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2156: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= 'UPDATE';
2157: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_t_effective_dt;
2158: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2423: p_effective_end_date => l_effective_end_date,
2424: p_object_version_number => l_object_version_number_opt,
2425: p_oipl_ordr_num => l_oipl_rec.ordr_num,
2426: p_business_group_id => p_business_group_id,
2427: p_program_application_id => fnd_global.prog_appl_id,
2428: p_program_id => fnd_global.conc_program_id,
2429: p_request_id => fnd_global.conc_request_id,
2430: p_program_update_date => sysdate,
2431: --
2424: p_object_version_number => l_object_version_number_opt,
2425: p_oipl_ordr_num => l_oipl_rec.ordr_num,
2426: p_business_group_id => p_business_group_id,
2427: p_program_application_id => fnd_global.prog_appl_id,
2428: p_program_id => fnd_global.conc_program_id,
2429: p_request_id => fnd_global.conc_request_id,
2430: p_program_update_date => sysdate,
2431: --
2432: -- Bugs : 1412882, part of bug 1412951
2425: p_oipl_ordr_num => l_oipl_rec.ordr_num,
2426: p_business_group_id => p_business_group_id,
2427: p_program_application_id => fnd_global.prog_appl_id,
2428: p_program_id => fnd_global.conc_program_id,
2429: p_request_id => fnd_global.conc_request_id,
2430: p_program_update_date => sysdate,
2431: --
2432: -- Bugs : 1412882, part of bug 1412951
2433: --
2501: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2502: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
2503: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2504: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
2505: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2506: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2507: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2508: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2509: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2502: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
2503: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2504: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
2505: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2506: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2507: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2508: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2509: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2510: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2503: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2504: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
2505: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2506: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2507: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2508: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2509: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2510: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2511: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_inelig:= l_newly_inelig;
2734: p_effective_date => l_effective_dt,
2735: -- p_effective_date => p_effective_date,
2736: p_object_version_number => l_object_version_number_opt,
2737: p_datetrack_mode => l_datetrack_mode,
2738: p_program_application_id => fnd_global.prog_appl_id,
2739: p_program_id => fnd_global.conc_program_id,
2740: p_request_id => fnd_global.conc_request_id,
2741: p_program_update_date => sysdate);
2742: --
2735: -- p_effective_date => p_effective_date,
2736: p_object_version_number => l_object_version_number_opt,
2737: p_datetrack_mode => l_datetrack_mode,
2738: p_program_application_id => fnd_global.prog_appl_id,
2739: p_program_id => fnd_global.conc_program_id,
2740: p_request_id => fnd_global.conc_request_id,
2741: p_program_update_date => sysdate);
2742: --
2743: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
2736: p_object_version_number => l_object_version_number_opt,
2737: p_datetrack_mode => l_datetrack_mode,
2738: p_program_application_id => fnd_global.prog_appl_id,
2739: p_program_id => fnd_global.conc_program_id,
2740: p_request_id => fnd_global.conc_request_id,
2741: p_program_update_date => sysdate);
2742: --
2743: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
2744: --
2798: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
2799: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2800: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2801: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2802: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2803: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2804: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2805: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2806: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2799: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
2800: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2801: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2802: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2803: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2804: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2805: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2806: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2807: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2800: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
2801: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
2802: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
2803: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
2804: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
2805: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
2806: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
2807: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
2808: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
2895: -- p_effective_date => p_effective_date,
2896: p_effective_date => l_effective_dt,
2897: p_object_version_number => l_object_version_number_opt,
2898: p_datetrack_mode => hr_api.g_correction,
2899: p_program_application_id => fnd_global.prog_appl_id,
2900: p_program_id => fnd_global.conc_program_id,
2901: p_request_id => fnd_global.conc_request_id,
2902: p_program_update_date => sysdate);
2903: --
2896: p_effective_date => l_effective_dt,
2897: p_object_version_number => l_object_version_number_opt,
2898: p_datetrack_mode => hr_api.g_correction,
2899: p_program_application_id => fnd_global.prog_appl_id,
2900: p_program_id => fnd_global.conc_program_id,
2901: p_request_id => fnd_global.conc_request_id,
2902: p_program_update_date => sysdate);
2903: --
2904: --
2897: p_object_version_number => l_object_version_number_opt,
2898: p_datetrack_mode => hr_api.g_correction,
2899: p_program_application_id => fnd_global.prog_appl_id,
2900: p_program_id => fnd_global.conc_program_id,
2901: p_request_id => fnd_global.conc_request_id,
2902: p_program_update_date => sysdate);
2903: --
2904: --
2905: end if;
3092: p_effective_date => l_effective_dt,
3093: -- p_effective_date => p_effective_date,
3094: p_object_version_number => l_object_version_number_opt,
3095: p_datetrack_mode => l_datetrack_mode,
3096: p_program_application_id => fnd_global.prog_appl_id,
3097: p_program_id => fnd_global.conc_program_id,
3098: p_request_id => fnd_global.conc_request_id,
3099: p_program_update_date => sysdate);
3100: --
3093: -- p_effective_date => p_effective_date,
3094: p_object_version_number => l_object_version_number_opt,
3095: p_datetrack_mode => l_datetrack_mode,
3096: p_program_application_id => fnd_global.prog_appl_id,
3097: p_program_id => fnd_global.conc_program_id,
3098: p_request_id => fnd_global.conc_request_id,
3099: p_program_update_date => sysdate);
3100: --
3101: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
3094: p_object_version_number => l_object_version_number_opt,
3095: p_datetrack_mode => l_datetrack_mode,
3096: p_program_application_id => fnd_global.prog_appl_id,
3097: p_program_id => fnd_global.conc_program_id,
3098: p_request_id => fnd_global.conc_request_id,
3099: p_program_update_date => sysdate);
3100: --
3101: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
3102: --
3157: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
3158: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3159: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3160: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3161: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3162: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3163: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3164: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3165: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3158: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3159: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3160: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3161: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3162: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3163: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3164: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3165: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3166: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3159: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3160: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3161: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3162: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3163: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3164: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3165: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3166: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3167: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
3238: -- p_effective_date => p_effective_date,
3239: p_effective_date => l_effective_dt,
3240: p_object_version_number => l_object_version_number_opt,
3241: p_datetrack_mode => hr_api.g_correction,
3242: p_program_application_id => fnd_global.prog_appl_id,
3243: p_program_id => fnd_global.conc_program_id,
3244: p_request_id => fnd_global.conc_request_id,
3245: p_program_update_date => sysdate);
3246: --
3239: p_effective_date => l_effective_dt,
3240: p_object_version_number => l_object_version_number_opt,
3241: p_datetrack_mode => hr_api.g_correction,
3242: p_program_application_id => fnd_global.prog_appl_id,
3243: p_program_id => fnd_global.conc_program_id,
3244: p_request_id => fnd_global.conc_request_id,
3245: p_program_update_date => sysdate);
3246: --
3247: end if; --p
3240: p_object_version_number => l_object_version_number_opt,
3241: p_datetrack_mode => hr_api.g_correction,
3242: p_program_application_id => fnd_global.prog_appl_id,
3243: p_program_id => fnd_global.conc_program_id,
3244: p_request_id => fnd_global.conc_request_id,
3245: p_program_update_date => sysdate);
3246: --
3247: end if; --p
3248: --
3396: p_effective_date => l_effective_dt,
3397: -- p_effective_date => p_effective_date,
3398: p_object_version_number => l_object_version_number_opt,
3399: p_datetrack_mode => l_datetrack_mode,
3400: p_program_application_id => fnd_global.prog_appl_id,
3401: p_program_id => fnd_global.conc_program_id,
3402: p_request_id => fnd_global.conc_request_id,
3403: p_program_update_date => sysdate,
3404: p_inelg_rsn_cd => p_inelg_rsn_cd);
3397: -- p_effective_date => p_effective_date,
3398: p_object_version_number => l_object_version_number_opt,
3399: p_datetrack_mode => l_datetrack_mode,
3400: p_program_application_id => fnd_global.prog_appl_id,
3401: p_program_id => fnd_global.conc_program_id,
3402: p_request_id => fnd_global.conc_request_id,
3403: p_program_update_date => sysdate,
3404: p_inelg_rsn_cd => p_inelg_rsn_cd);
3405: --
3398: p_object_version_number => l_object_version_number_opt,
3399: p_datetrack_mode => l_datetrack_mode,
3400: p_program_application_id => fnd_global.prog_appl_id,
3401: p_program_id => fnd_global.conc_program_id,
3402: p_request_id => fnd_global.conc_request_id,
3403: p_program_update_date => sysdate,
3404: p_inelg_rsn_cd => p_inelg_rsn_cd);
3405: --
3406:
3461: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3462: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3463: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3464: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3465: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3466: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3467: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3468: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3469: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3462: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3463: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3464: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3465: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3466: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3467: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3468: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3469: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3470: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3463: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_t_object_version_number;
3464: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3465: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3466: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3467: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3468: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3469: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:= l_datetrack_mode;
3470: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3471: ben_icm_life_events.g_cache_epo_object(l_count_icm1).inelg_rsn_cd := p_inelg_rsn_cd;
3652: --
3653: p_effective_date => l_effective_dt,
3654: -- p_effective_date => p_effective_date,
3655: p_object_version_number => l_object_version_number_opt,
3656: p_program_application_id => fnd_global.prog_appl_id,
3657: p_program_id => fnd_global.conc_program_id,
3658: p_request_id => fnd_global.conc_request_id,
3659: p_program_update_date => sysdate,
3660: p_inelg_rsn_cd => p_inelg_rsn_cd
3653: p_effective_date => l_effective_dt,
3654: -- p_effective_date => p_effective_date,
3655: p_object_version_number => l_object_version_number_opt,
3656: p_program_application_id => fnd_global.prog_appl_id,
3657: p_program_id => fnd_global.conc_program_id,
3658: p_request_id => fnd_global.conc_request_id,
3659: p_program_update_date => sysdate,
3660: p_inelg_rsn_cd => p_inelg_rsn_cd
3661: --
3654: -- p_effective_date => p_effective_date,
3655: p_object_version_number => l_object_version_number_opt,
3656: p_program_application_id => fnd_global.prog_appl_id,
3657: p_program_id => fnd_global.conc_program_id,
3658: p_request_id => fnd_global.conc_request_id,
3659: p_program_update_date => sysdate,
3660: p_inelg_rsn_cd => p_inelg_rsn_cd
3661: --
3662: -- Bypass insert validate validation for performance
3725: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3726: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3727: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
3728: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
3729: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3730: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3731: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3732: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3733: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3726: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
3727: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
3728: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
3729: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3730: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3731: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3732: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3733: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3734: ben_icm_life_events.g_cache_epo_object(l_count_icm1).inelg_rsn_cd := p_inelg_rsn_cd;
3727: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := l_oipl_rec.ordr_num;
3728: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_object_version_number_opt;
3729: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3730: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3731: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3732: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3733: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3734: ben_icm_life_events.g_cache_epo_object(l_count_icm1).inelg_rsn_cd := p_inelg_rsn_cd;
3735: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_newly_elig := l_newly_elig;
3887: p_effective_end_date => l_effective_end_date,
3888: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3889: p_oipl_ordr_num => null,
3890: p_business_group_id => p_business_group_id,
3891: p_program_application_id => fnd_global.prog_appl_id,
3892: p_program_id => fnd_global.conc_program_id,
3893: p_request_id => fnd_global.conc_request_id,
3894: p_program_update_date => sysdate,
3895: --
3888: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
3889: p_oipl_ordr_num => null,
3890: p_business_group_id => p_business_group_id,
3891: p_program_application_id => fnd_global.prog_appl_id,
3892: p_program_id => fnd_global.conc_program_id,
3893: p_request_id => fnd_global.conc_request_id,
3894: p_program_update_date => sysdate,
3895: --
3896: -- Bugs : 1412882, part of bug 1412951
3889: p_oipl_ordr_num => null,
3890: p_business_group_id => p_business_group_id,
3891: p_program_application_id => fnd_global.prog_appl_id,
3892: p_program_id => fnd_global.conc_program_id,
3893: p_request_id => fnd_global.conc_request_id,
3894: p_program_update_date => sysdate,
3895: --
3896: -- Bugs : 1412882, part of bug 1412951
3897: --
3960: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
3961: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3962: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3963: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3964: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3965: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3966: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3967: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_prev_oiplip_elig_check.object_version_number;
3968: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3961: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
3962: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3963: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3964: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3965: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3966: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3967: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_prev_oiplip_elig_check.object_version_number;
3968: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3969: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3962: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
3963: ben_icm_life_events.g_cache_epo_object(l_count_icm1).oipl_ordr_num := null;
3964: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
3965: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
3966: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
3967: ben_icm_life_events.g_cache_epo_object(l_count_icm1).object_version_number := l_prev_oiplip_elig_check.object_version_number;
3968: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
3969: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
3970: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_pl_id := l_envpl_id;
4130: p_effective_date => l_effective_dt,
4131: -- p_effective_date => p_effective_date,
4132: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
4133: p_datetrack_mode => l_datetrack_mode,
4134: p_program_application_id => fnd_global.prog_appl_id,
4135: p_program_id => fnd_global.conc_program_id,
4136: p_request_id => fnd_global.conc_request_id,
4137: p_program_update_date => sysdate);
4138: --
4131: -- p_effective_date => p_effective_date,
4132: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
4133: p_datetrack_mode => l_datetrack_mode,
4134: p_program_application_id => fnd_global.prog_appl_id,
4135: p_program_id => fnd_global.conc_program_id,
4136: p_request_id => fnd_global.conc_request_id,
4137: p_program_update_date => sysdate);
4138: --
4139: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
4132: p_object_version_number => l_prev_oiplip_elig_check.object_version_number,
4133: p_datetrack_mode => l_datetrack_mode,
4134: p_program_application_id => fnd_global.prog_appl_id,
4135: p_program_id => fnd_global.conc_program_id,
4136: p_request_id => fnd_global.conc_request_id,
4137: p_program_update_date => sysdate);
4138: --
4139: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
4140: IF NOT ben_icm_life_events.g_cache_epo_object.EXISTS(1) THEN
4195: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_hrs_wkd_flag :='N';
4196: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
4197: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
4198: 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;
4199: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
4200: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
4201: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
4202: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
4203: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
4196: ben_icm_life_events.g_cache_epo_object(l_count_icm1).rt_frz_comb_age_and_los_flag :='N';
4197: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
4198: 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;
4199: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
4200: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
4201: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
4202: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
4203: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
4204: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:=l_datetrack_mode;
4197: ben_icm_life_events.g_cache_epo_object(l_count_icm1).once_r_cntug_cd := p_oiplip_rec.once_r_cntug_cd;
4198: 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;
4199: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_application_id :=fnd_global.prog_appl_id;
4200: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_id :=fnd_global.conc_program_id;
4201: ben_icm_life_events.g_cache_epo_object(l_count_icm1).request_id :=fnd_global.conc_request_id;
4202: ben_icm_life_events.g_cache_epo_object(l_count_icm1).program_update_date :=sysdate;
4203: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_effective_date:= l_effective_dt;
4204: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_datetrack_mode:=l_datetrack_mode;
4205: ben_icm_life_events.g_cache_epo_object(l_count_icm1).p_pl_id := l_envpl_id;
4673: p_wait_perd_strt_dt => l_wait_perd_strt_dt,
4674: p_object_version_number => l_object_version_number,
4675: p_effective_date => l_effective_dt,
4676: p_datetrack_mode => l_datetrack_mode,
4677: p_program_application_id => fnd_global.prog_appl_id,
4678: p_program_id => fnd_global.conc_program_id,
4679: p_request_id => fnd_global.conc_request_id,
4680: p_program_update_date => sysdate);
4681: --
4674: p_object_version_number => l_object_version_number,
4675: p_effective_date => l_effective_dt,
4676: p_datetrack_mode => l_datetrack_mode,
4677: p_program_application_id => fnd_global.prog_appl_id,
4678: p_program_id => fnd_global.conc_program_id,
4679: p_request_id => fnd_global.conc_request_id,
4680: p_program_update_date => sysdate);
4681: --
4682:
4675: p_effective_date => l_effective_dt,
4676: p_datetrack_mode => l_datetrack_mode,
4677: p_program_application_id => fnd_global.prog_appl_id,
4678: p_program_id => fnd_global.conc_program_id,
4679: p_request_id => fnd_global.conc_request_id,
4680: p_program_update_date => sysdate);
4681: --
4682:
4683: if g_debug then
4758: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag :='N';
4759: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
4760: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
4761: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4762: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4763: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
4764: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
4765: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4766: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4759: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
4760: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
4761: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4762: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4763: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
4764: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
4765: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4766: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4767: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4760: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
4761: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
4762: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
4763: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
4764: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
4765: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
4766: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
4767: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
4768: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5048: -- Bugs : 1412882, part of bug 1412951
5049: --
5050: p_effective_date => l_effective_dt,
5051: -- p_effective_date => p_effective_date,
5052: p_program_application_id => fnd_global.prog_appl_id,
5053: p_program_id => fnd_global.conc_program_id,
5054: p_request_id => fnd_global.conc_request_id,
5055: p_program_update_date => sysdate
5056: --
5049: --
5050: p_effective_date => l_effective_dt,
5051: -- p_effective_date => p_effective_date,
5052: p_program_application_id => fnd_global.prog_appl_id,
5053: p_program_id => fnd_global.conc_program_id,
5054: p_request_id => fnd_global.conc_request_id,
5055: p_program_update_date => sysdate
5056: --
5057: -- Bypass insert validate validation for performance
5050: p_effective_date => l_effective_dt,
5051: -- p_effective_date => p_effective_date,
5052: p_program_application_id => fnd_global.prog_appl_id,
5053: p_program_id => fnd_global.conc_program_id,
5054: p_request_id => fnd_global.conc_request_id,
5055: p_program_update_date => sysdate
5056: --
5057: -- Bypass insert validate validation for performance
5058: --
5129: ben_icm_life_events.g_cache_pep_object(l_count_icm).pl_ordr_num :=l_plan_ordr_num;
5130: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num := l_plip_rec.ordr_num;
5131: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num := l_ptip_rec.ordr_num;
5132: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_object_version_number;
5133: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5134: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id := fnd_global.conc_program_id;
5135: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id := fnd_global.conc_request_id;
5136: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5137: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5130: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num := l_plip_rec.ordr_num;
5131: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num := l_ptip_rec.ordr_num;
5132: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_object_version_number;
5133: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5134: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id := fnd_global.conc_program_id;
5135: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id := fnd_global.conc_request_id;
5136: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5137: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5138: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5131: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num := l_ptip_rec.ordr_num;
5132: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_object_version_number;
5133: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5134: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id := fnd_global.conc_program_id;
5135: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id := fnd_global.conc_request_id;
5136: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5137: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5138: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5139: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5363: --
5364: p_effective_date => l_effective_dt,
5365: -- p_effective_date => p_effective_date,
5366: p_datetrack_mode => l_datetrack_mode,
5367: p_program_application_id => fnd_global.prog_appl_id,
5368: p_program_id => fnd_global.conc_program_id,
5369: p_request_id => fnd_global.conc_request_id,
5370: p_program_update_date => sysdate);
5371: --ICM
5364: p_effective_date => l_effective_dt,
5365: -- p_effective_date => p_effective_date,
5366: p_datetrack_mode => l_datetrack_mode,
5367: p_program_application_id => fnd_global.prog_appl_id,
5368: p_program_id => fnd_global.conc_program_id,
5369: p_request_id => fnd_global.conc_request_id,
5370: p_program_update_date => sysdate);
5371: --ICM
5372: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5365: -- p_effective_date => p_effective_date,
5366: p_datetrack_mode => l_datetrack_mode,
5367: p_program_application_id => fnd_global.prog_appl_id,
5368: p_program_id => fnd_global.conc_program_id,
5369: p_request_id => fnd_global.conc_request_id,
5370: p_program_update_date => sysdate);
5371: --ICM
5372: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5373: --
5428: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag := 'N';
5429: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag := 'N';
5430: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
5431: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5432: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5433: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5434: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5435: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5436: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5429: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag := 'N';
5430: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
5431: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5432: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5433: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5434: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5435: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5436: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5437: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5430: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd := p_comp_rec.once_r_cntug_cd;
5431: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5432: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5433: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5434: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5435: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5436: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5437: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5438: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5523: p_prtn_end_dt => (l_prtn_eff_strt_dt -1),
5524: p_object_version_number => l_object_version_number,
5525: p_effective_date => l_effective_dt, -- 4947426
5526: p_datetrack_mode => hr_api.g_correction,
5527: p_program_application_id => fnd_global.prog_appl_id,
5528: p_program_id => fnd_global.conc_program_id,
5529: p_request_id => fnd_global.conc_request_id,
5530: p_program_update_date => sysdate);
5531: --
5524: p_object_version_number => l_object_version_number,
5525: p_effective_date => l_effective_dt, -- 4947426
5526: p_datetrack_mode => hr_api.g_correction,
5527: p_program_application_id => fnd_global.prog_appl_id,
5528: p_program_id => fnd_global.conc_program_id,
5529: p_request_id => fnd_global.conc_request_id,
5530: p_program_update_date => sysdate);
5531: --
5532: end if; --p
5525: p_effective_date => l_effective_dt, -- 4947426
5526: p_datetrack_mode => hr_api.g_correction,
5527: p_program_application_id => fnd_global.prog_appl_id,
5528: p_program_id => fnd_global.conc_program_id,
5529: p_request_id => fnd_global.conc_request_id,
5530: p_program_update_date => sysdate);
5531: --
5532: end if; --p
5533: --
5710: --
5711: p_effective_date => l_effective_dt,
5712: -- p_effective_date => p_effective_date,
5713: p_datetrack_mode => l_datetrack_mode,
5714: p_program_application_id => fnd_global.prog_appl_id,
5715: p_program_id => fnd_global.conc_program_id,
5716: p_request_id => fnd_global.conc_request_id,
5717: p_program_update_date => sysdate);
5718: --ICM
5711: p_effective_date => l_effective_dt,
5712: -- p_effective_date => p_effective_date,
5713: p_datetrack_mode => l_datetrack_mode,
5714: p_program_application_id => fnd_global.prog_appl_id,
5715: p_program_id => fnd_global.conc_program_id,
5716: p_request_id => fnd_global.conc_request_id,
5717: p_program_update_date => sysdate);
5718: --ICM
5719: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5712: -- p_effective_date => p_effective_date,
5713: p_datetrack_mode => l_datetrack_mode,
5714: p_program_application_id => fnd_global.prog_appl_id,
5715: p_program_id => fnd_global.conc_program_id,
5716: p_request_id => fnd_global.conc_request_id,
5717: p_program_update_date => sysdate);
5718: --ICM
5719: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
5720: hr_utility.set_location('Building PEP5',214);
5778: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag :='N';
5779: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
5780: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5781: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5782: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5783: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5784: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5785: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5786: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5779: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
5780: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5781: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5782: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5783: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5784: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5785: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5786: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5787: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5780: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
5781: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
5782: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
5783: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
5784: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
5785: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
5786: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
5787: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
5788: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
5869: p_object_version_number => l_object_version_number,
5870: -- p_effective_date => p_effective_date,
5871: p_effective_date => l_effective_dt,
5872: p_datetrack_mode => hr_api.g_correction,
5873: p_program_application_id => fnd_global.prog_appl_id,
5874: p_program_id => fnd_global.conc_program_id,
5875: p_request_id => fnd_global.conc_request_id,
5876: p_program_update_date => sysdate);
5877: --
5870: -- p_effective_date => p_effective_date,
5871: p_effective_date => l_effective_dt,
5872: p_datetrack_mode => hr_api.g_correction,
5873: p_program_application_id => fnd_global.prog_appl_id,
5874: p_program_id => fnd_global.conc_program_id,
5875: p_request_id => fnd_global.conc_request_id,
5876: p_program_update_date => sysdate);
5877: --
5878: hr_utility.set_location('Building epo cache1 10 : count ' || l_count_icm1,123);
5871: p_effective_date => l_effective_dt,
5872: p_datetrack_mode => hr_api.g_correction,
5873: p_program_application_id => fnd_global.prog_appl_id,
5874: p_program_id => fnd_global.conc_program_id,
5875: p_request_id => fnd_global.conc_request_id,
5876: p_program_update_date => sysdate);
5877: --
5878: hr_utility.set_location('Building epo cache1 10 : count ' || l_count_icm1,123);
5879: hr_utility.set_location('Building epo cache1 1'|| l_count_icm1,123);
6023: --
6024: p_effective_date => l_effective_dt,
6025: -- p_effective_date => p_effective_date,
6026: p_datetrack_mode => l_datetrack_mode,
6027: p_program_application_id => fnd_global.prog_appl_id,
6028: p_program_id => fnd_global.conc_program_id,
6029: p_request_id => fnd_global.conc_request_id,
6030: p_program_update_date => sysdate,
6031: p_inelg_rsn_cd => p_inelg_rsn_cd);
6024: p_effective_date => l_effective_dt,
6025: -- p_effective_date => p_effective_date,
6026: p_datetrack_mode => l_datetrack_mode,
6027: p_program_application_id => fnd_global.prog_appl_id,
6028: p_program_id => fnd_global.conc_program_id,
6029: p_request_id => fnd_global.conc_request_id,
6030: p_program_update_date => sysdate,
6031: p_inelg_rsn_cd => p_inelg_rsn_cd);
6032: --ICM
6025: -- p_effective_date => p_effective_date,
6026: p_datetrack_mode => l_datetrack_mode,
6027: p_program_application_id => fnd_global.prog_appl_id,
6028: p_program_id => fnd_global.conc_program_id,
6029: p_request_id => fnd_global.conc_request_id,
6030: p_program_update_date => sysdate,
6031: p_inelg_rsn_cd => p_inelg_rsn_cd);
6032: --ICM
6033: IF nvl(l_env_rec.mode_cd,'~') = 'D' THEN
6091: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_hrs_wkd_flag :='N';
6092: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
6093: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
6094: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
6095: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
6096: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
6097: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
6098: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
6099: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
6092: ben_icm_life_events.g_cache_pep_object(l_count_icm).rt_frz_comb_age_and_los_flag :='N';
6093: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
6094: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
6095: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
6096: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
6097: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
6098: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
6099: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
6100: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
6093: ben_icm_life_events.g_cache_pep_object(l_count_icm).once_r_cntug_cd :=p_comp_rec.once_r_cntug_cd;
6094: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number := l_p_object_version_number;
6095: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
6096: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
6097: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
6098: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
6099: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
6100: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
6101: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;
6265: -- Bugs : 1412882, part of bug 1412951
6266: --
6267: p_effective_date => l_effective_dt,
6268: -- p_effective_date => p_effective_date,
6269: p_program_application_id => fnd_global.prog_appl_id,
6270: p_program_id => fnd_global.conc_program_id,
6271: p_request_id => fnd_global.conc_request_id,
6272: p_program_update_date => sysdate,
6273: p_inelg_rsn_cd => p_inelg_rsn_cd
6266: --
6267: p_effective_date => l_effective_dt,
6268: -- p_effective_date => p_effective_date,
6269: p_program_application_id => fnd_global.prog_appl_id,
6270: p_program_id => fnd_global.conc_program_id,
6271: p_request_id => fnd_global.conc_request_id,
6272: p_program_update_date => sysdate,
6273: p_inelg_rsn_cd => p_inelg_rsn_cd
6274: --
6267: p_effective_date => l_effective_dt,
6268: -- p_effective_date => p_effective_date,
6269: p_program_application_id => fnd_global.prog_appl_id,
6270: p_program_id => fnd_global.conc_program_id,
6271: p_request_id => fnd_global.conc_request_id,
6272: p_program_update_date => sysdate,
6273: p_inelg_rsn_cd => p_inelg_rsn_cd
6274: --
6275: -- Bypass insert validate validation for performance
6347: ben_icm_life_events.g_cache_pep_object(l_count_icm).pl_ordr_num :=l_plan_ordr_num;
6348: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num :=l_plip_rec.ordr_num;
6349: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num :=l_ptip_rec.ordr_num;
6350: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number :=l_object_version_number;
6351: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
6352: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
6353: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
6354: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
6355: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
6348: ben_icm_life_events.g_cache_pep_object(l_count_icm).plip_ordr_num :=l_plip_rec.ordr_num;
6349: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num :=l_ptip_rec.ordr_num;
6350: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number :=l_object_version_number;
6351: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
6352: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
6353: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
6354: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
6355: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
6356: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
6349: ben_icm_life_events.g_cache_pep_object(l_count_icm).ptip_ordr_num :=l_ptip_rec.ordr_num;
6350: ben_icm_life_events.g_cache_pep_object(l_count_icm).object_version_number :=l_object_version_number;
6351: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_application_id :=fnd_global.prog_appl_id;
6352: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_id :=fnd_global.conc_program_id;
6353: ben_icm_life_events.g_cache_pep_object(l_count_icm).request_id :=fnd_global.conc_request_id;
6354: ben_icm_life_events.g_cache_pep_object(l_count_icm).program_update_date :=sysdate;
6355: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_elig := l_newly_elig;
6356: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_newly_inelig:= l_newly_inelig;
6357: ben_icm_life_events.g_cache_pep_object(l_count_icm).p_first_elig := l_first_elig;