eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1287: --raise ben_manage_life_events.g_record_error;

1283: --
1284: --if p_per_comp_val is null then
1285: --
1286: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1287: --raise ben_manage_life_events.g_record_error;
1288: --
1289: --end if;
1290: --
1291: -- as the derived factor may have periodicity, we need to compute the compensation

Line 1453: --raise ben_manage_life_events.g_record_error;

1449: --
1450: --if p_per_hrs_wkd is null then
1451: --
1452: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1453: --raise ben_manage_life_events.g_record_error;
1454: --
1455: --end if;
1456: --
1457: if not p_comp_obj_mode then

Line 1609: --raise ben_manage_life_events.g_record_error;

1605: --
1606: --if p_per_hrs_wkd is null then
1607: --
1608: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1609: --raise ben_manage_life_events.g_record_error;
1610: --
1611: --end if;
1612: --
1613: if not p_comp_obj_mode then

Line 1764: --raise ben_manage_life_events.g_record_error;

1760: --
1761: --if p_per_hrs_wkd is null then
1762: --
1763: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1764: --raise ben_manage_life_events.g_record_error;
1765: --
1766: --end if;
1767: --
1768: if not p_comp_obj_mode then

Line 2341: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

2337: p_effective_date => p_effective_date,
2338: p_param1 => 'BEN_ELP_I_ELIGY_PRFL_ID',
2339: p_param1_value => to_char(nvl(p_eligy_prfl_id, -1)),
2340: p_param2 => 'BEN_IV_RT_STRT_DT',
2341: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2342: p_param3 => 'BEN_IV_CVG_STRT_DT',
2343: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),
2344: p_param4 => 'BEN_IV_PERSON_ID', -- Bug 5331889 : Added person_id param as well
2345: p_param4_value => to_char(p_person_id)

Line 4224: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

4220: ,p_pl_typ_id => p_pl_typ_id
4221: ,p_opt_id => p_opt_id
4222: ,p_ler_id => p_ler_id
4223: ,p_param1 => 'BEN_IV_RT_STRT_DT'
4224: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
4225: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
4226: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
4227:
4228: ,p_jurisdiction_code => p_jurisdiction_code);

Line 4326: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

4322: p_comp_obj_mode => p_comp_obj_mode,
4323: p_business_group_id => p_business_group_id,
4324: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4325: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4326: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4327: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4328: p_returned_date => l_sched_effective_date);
4329: --
4330: end if;

Line 4327: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

4323: p_business_group_id => p_business_group_id,
4324: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4325: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4326: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4327: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4328: p_returned_date => l_sched_effective_date);
4329: --
4330: end if;
4331: --

Line 5428: --raise ben_manage_life_events.g_record_error;

5424: --
5425: --if p_per_comp_val is null then
5426: --
5427: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5428: --raise ben_manage_life_events.g_record_error;
5429: --
5430: --end if;
5431: --
5432: if not p_comp_obj_mode or

Line 5594: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

5590: (p_formula_id => l_inst_dets(l_count).formula_id,
5591: p_assignment_id => l_ass_rec.assignment_id,
5592: p_effective_date => p_effective_date,
5593: p_param1 => 'BEN_IV_RT_STRT_DT',
5594: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5595: p_param2 => 'BEN_IV_CVG_STRT_DT',
5596: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
5597: );
5598: --

Line 5758: --raise ben_manage_life_events.g_record_error;

5754: --
5755: --if p_per_comp_val is null then
5756: --
5757: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5758: --raise ben_manage_life_events.g_record_error;
5759: --
5760: --end if;
5761: --
5762: if not p_comp_obj_mode or

Line 6173: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

6169: --
6170: l_rows_found := true;
6171: --
6172: <>
6173: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6174: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6175: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
6176: l_inst_dets(l_insttorrw_num).pl_id then
6177: --

Line 6174: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

6170: l_rows_found := true;
6171: --
6172: <>
6173: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6174: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6175: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
6176: l_inst_dets(l_insttorrw_num).pl_id then
6177: --
6178: -- Apply the date logic to the life event occurred date.

Line 6175: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =

6171: --
6172: <>
6173: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6174: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6175: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
6176: l_inst_dets(l_insttorrw_num).pl_id then
6177: --
6178: -- Apply the date logic to the life event occurred date.
6179: --

Line 6184: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6180: ben_determine_date.main
6181: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6182: p_effective_date => p_effective_date,
6183: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6184: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6185: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6186: p_returned_date => l_date_to_use);
6187: --
6188: if (l_date_to_use

Line 6185: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6181: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6182: p_effective_date => p_effective_date,
6183: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6184: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6185: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6186: p_returned_date => l_date_to_use);
6187: --
6188: if (l_date_to_use
6189: between ben_manage_life_events.

Line 6189: between ben_manage_life_events.

6185: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6186: p_returned_date => l_date_to_use);
6187: --
6188: if (l_date_to_use
6189: between ben_manage_life_events.
6190: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6191: and ben_manage_life_events.
6192: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6193: l_found_plan := true;

Line 6191: and ben_manage_life_events.

6187: --
6188: if (l_date_to_use
6189: between ben_manage_life_events.
6190: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6191: and ben_manage_life_events.
6192: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6193: l_found_plan := true;
6194: --
6195: if l_inst_dets(l_insttorrw_num).excld_flag = 'N'then

Line 6301: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

6297: --
6298: l_rows_found := true;
6299: --
6300: <>
6301: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6302: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6303: if ben_manage_life_events.
6304: g_cache_person_prtn(l_count).oipl_id =
6305: l_inst_dets(l_insttorrw_num).oipl_id then

Line 6302: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

6298: l_rows_found := true;
6299: --
6300: <>
6301: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6302: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6303: if ben_manage_life_events.
6304: g_cache_person_prtn(l_count).oipl_id =
6305: l_inst_dets(l_insttorrw_num).oipl_id then
6306: --

Line 6303: if ben_manage_life_events.

6299: --
6300: <>
6301: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6302: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6303: if ben_manage_life_events.
6304: g_cache_person_prtn(l_count).oipl_id =
6305: l_inst_dets(l_insttorrw_num).oipl_id then
6306: --
6307: -- Apply the date logic to the life event occurred date.

Line 6313: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6309: ben_determine_date.main
6310: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6311: p_effective_date => p_effective_date,
6312: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6313: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6314: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6315: p_returned_date => l_date_to_use);
6316: --
6317: if (l_date_to_use

Line 6314: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6310: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6311: p_effective_date => p_effective_date,
6312: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6313: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6314: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6315: p_returned_date => l_date_to_use);
6316: --
6317: if (l_date_to_use
6318: between ben_manage_life_events.

Line 6318: between ben_manage_life_events.

6314: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6315: p_returned_date => l_date_to_use);
6316: --
6317: if (l_date_to_use
6318: between ben_manage_life_events.
6319: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6320: and ben_manage_life_events.
6321: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6322: --

Line 6320: and ben_manage_life_events.

6316: --
6317: if (l_date_to_use
6318: between ben_manage_life_events.
6319: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6320: and ben_manage_life_events.
6321: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6322: --
6323: l_found_oipl := true;
6324: --

Line 6423: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

6419: --
6420: l_rows_found := true;
6421: --
6422: <>
6423: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6424: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6425: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
6426: l_inst_dets(l_insttorrw_num).pgm_id then
6427: l_found_pgm := true;

Line 6424: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

6420: l_rows_found := true;
6421: --
6422: <>
6423: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6424: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6425: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
6426: l_inst_dets(l_insttorrw_num).pgm_id then
6427: l_found_pgm := true;
6428: --

Line 6425: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =

6421: --
6422: <>
6423: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6424: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6425: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
6426: l_inst_dets(l_insttorrw_num).pgm_id then
6427: l_found_pgm := true;
6428: --
6429: -- Apply the date logic to the life event occurred date.

Line 6435: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6431: ben_determine_date.main
6432: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6433: p_effective_date => p_effective_date,
6434: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6435: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6436: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6437: p_returned_date => l_date_to_use);
6438: --
6439: if (l_date_to_use

Line 6436: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6432: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6433: p_effective_date => p_effective_date,
6434: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6435: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6436: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6437: p_returned_date => l_date_to_use);
6438: --
6439: if (l_date_to_use
6440: between ben_manage_life_events.

Line 6440: between ben_manage_life_events.

6436: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6437: p_returned_date => l_date_to_use);
6438: --
6439: if (l_date_to_use
6440: between ben_manage_life_events.
6441: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6442: and ben_manage_life_events.
6443: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6444: --

Line 6442: and ben_manage_life_events.

6438: --
6439: if (l_date_to_use
6440: between ben_manage_life_events.
6441: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6442: and ben_manage_life_events.
6443: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6444: --
6445: if l_inst_dets(l_insttorrw_num).excld_flag = 'N'then
6446: --

Line 6566: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6562: ben_determine_date.main
6563: (p_date_cd => l_inst_dets(l_insttorrw_num).cvg_det_dt_cd,
6564: p_effective_date => p_effective_date,
6565: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6566: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6567: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6568: p_returned_date => l_date_to_use);
6569: --
6570: open c1(l_inst_dets(l_insttorrw_num).pl_id);

Line 6567: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6563: (p_date_cd => l_inst_dets(l_insttorrw_num).cvg_det_dt_cd,
6564: p_effective_date => p_effective_date,
6565: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6566: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6567: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6568: p_returned_date => l_date_to_use);
6569: --
6570: open c1(l_inst_dets(l_insttorrw_num).pl_id);
6571: fetch c1 into l_dummy;

Line 6684: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6680: ben_determine_date.main
6681: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6682: p_effective_date => p_effective_date,
6683: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6684: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6685: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6686: p_returned_date => l_date_to_use);
6687: --
6688: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);

Line 6685: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6681: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6682: p_effective_date => p_effective_date,
6683: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6684: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6685: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6686: p_returned_date => l_date_to_use);
6687: --
6688: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);
6689: --

Line 6813: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6809: ben_determine_date.main
6810: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6811: p_effective_date => p_effective_date,
6812: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6813: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6814: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6815: p_returned_date => l_date_to_use);
6816: --
6817: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);

Line 6814: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6810: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6811: p_effective_date => p_effective_date,
6812: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6813: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6814: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6815: p_returned_date => l_date_to_use);
6816: --
6817: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);
6818: --

Line 6942: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);

6938: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
6939: --
6940: l_rows_found := true;
6941: --
6942: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);
6943:
6944: <>
6945: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6946: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

Line 6945: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..

6941: --
6942: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);
6943:
6944: <>
6945: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6946: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6947: if ben_manage_life_events.
6948: g_cache_person_prtn(l_count).ptip_id =
6949: l_inst_dets(l_insttorrw_num).ptip_id then

Line 6946: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

6942: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);
6943:
6944: <>
6945: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6946: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6947: if ben_manage_life_events.
6948: g_cache_person_prtn(l_count).ptip_id =
6949: l_inst_dets(l_insttorrw_num).ptip_id then
6950: --

Line 6947: if ben_manage_life_events.

6943:
6944: <>
6945: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6946: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6947: if ben_manage_life_events.
6948: g_cache_person_prtn(l_count).ptip_id =
6949: l_inst_dets(l_insttorrw_num).ptip_id then
6950: --
6951: -- Apply the date logic to the life event occurred date.

Line 6957: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6953: ben_determine_date.main
6954: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6955: p_effective_date => p_effective_date,
6956: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6957: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6958: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6959: p_returned_date => l_date_to_use);
6960: --
6961: hr_utility.set_location( 'l_date_to_use ' || l_date_to_use , 99 ) ;

Line 6958: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6954: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6955: p_effective_date => p_effective_date,
6956: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6957: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6958: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6959: p_returned_date => l_date_to_use);
6960: --
6961: hr_utility.set_location( 'l_date_to_use ' || l_date_to_use , 99 ) ;
6962:

Line 6974: open c1(ben_manage_life_events.g_cache_person_prtn(l_count).pl_id,

6970: hr_utility.set_location('Getting cobra plans',10);
6971: --
6972: if l_inst_dets(l_insttorrw_num).only_pls_subj_cobra_flag = 'Y' then
6973: --
6974: open c1(ben_manage_life_events.g_cache_person_prtn(l_count).pl_id,
6975: l_date_to_use );
6976: --
6977: fetch c1 into l_dummy;
6978: --

Line 6995: between ben_manage_life_events.

6991: --
6992: hr_utility.set_location('Cobra plans found',10);
6993: --
6994: if (l_date_to_use
6995: between ben_manage_life_events.
6996: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6997: and ben_manage_life_events.
6998: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6999: --

Line 6997: and ben_manage_life_events.

6993: --
6994: if (l_date_to_use
6995: between ben_manage_life_events.
6996: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6997: and ben_manage_life_events.
6998: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6999: --
7000: l_found_ptip := true;
7001: hr_utility.set_location('cobra plans found',10);

Line 7146: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

7142: ben_determine_date.main
7143: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7144: p_effective_date => p_effective_date,
7145: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7146: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7147: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7148: p_returned_date => l_date_to_use);
7149: --
7150: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);

Line 7147: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

7143: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7144: p_effective_date => p_effective_date,
7145: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7146: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7147: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7148: p_returned_date => l_date_to_use);
7149: --
7150: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);
7151: --

Line 7280: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

7276: ben_determine_date.main
7277: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7278: p_effective_date => p_effective_date,
7279: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7280: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7281: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7282: p_returned_date => l_date_to_use);
7283: --
7284: open c1(l_inst_dets(l_insttorrw_num).pgm_id);

Line 7281: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

7277: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7278: p_effective_date => p_effective_date,
7279: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7280: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7281: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7282: p_returned_date => l_date_to_use);
7283: --
7284: open c1(l_inst_dets(l_insttorrw_num).pgm_id);
7285: fetch c1 into l_dummy;

Line 8937: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;

8933: l_cagrelig_cnt pls_integer;
8934: l_pl_typ_id number;
8935: l_typ_rec ben_person_object.g_cache_typ_table;
8936: l_appass_rec ben_person_object.g_cache_ass_table;
8937: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
8938: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
8939: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
8940: --
8941: l_ff_use_asg_id_flag varchar2(1);

Line 9245: if ben_manage_life_events.fonm = 'Y'

9241: --
9242: -- intialize the global
9243: --
9244: l_fonm_cvg_strt_dt := null ;
9245: if ben_manage_life_events.fonm = 'Y'
9246: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
9247: --
9248: if p_eval_typ = 'E' then
9249: --

Line 9246: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

9242: -- intialize the global
9243: --
9244: l_fonm_cvg_strt_dt := null ;
9245: if ben_manage_life_events.fonm = 'Y'
9246: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
9247: --
9248: if p_eval_typ = 'E' then
9249: --
9250: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));

Line 9250: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));

9246: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
9247: --
9248: if p_eval_typ = 'E' then
9249: --
9250: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
9251: --
9252: else
9253: --
9254: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 9254: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

9250: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
9251: --
9252: else
9253: --
9254: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
9255: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
9256: nvl(p_lf_evt_ocrd_dt, p_effective_date)));
9257: --
9258: end if;

Line 9255: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

9251: --
9252: else
9253: --
9254: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
9255: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
9256: nvl(p_lf_evt_ocrd_dt, p_effective_date)));
9257: --
9258: end if;
9259: --

Line 9548: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;

9544:
9545: if l_benmngle_parm_rec.mode_cd = 'I' then
9546: --
9547: l_appass_rec.delete;
9548: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9549: else
9550: --
9551: ben_person_object.get_object(p_person_id => p_person_id,
9552: p_rec => l_appass_rec);

Line 9586: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;

9582:
9583:
9584: l_appass_rec.delete;
9585:
9586: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9587:
9588: hr_utility.set_location(' p_assignment_id :' || l_appass_rec(1).assignment_id,99);
9589: hr_utility.set_location(' location_id :' || l_appass_rec(1).location_id,99);
9590: hr_utility.set_location(' p_effective_date :' || p_effective_date,99);

Line 9671: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;

9667:
9668: if l_benmngle_parm_rec.mode_cd = 'I' then
9669: --
9670: l_appass_rec.delete;
9671: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9672: else
9673: --
9674: ben_person_object.get_object(p_person_id => p_person_id,
9675: p_rec => l_appass_rec);

Line 10054: p_fonm_cvg_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,

10050: p_oipl_id => p_oipl_id,
10051: p_ler_id => p_ler_id,
10052: p_pl_typ_id => l_pl_typ_id,
10053: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
10054: p_fonm_cvg_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10055: p_fonm_rt_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10056: p_crit_ovrrd_val_tbl => l_crit_ovrrd_val_tab) ;
10057:
10058: end if ;

Line 10055: p_fonm_rt_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,

10051: p_ler_id => p_ler_id,
10052: p_pl_typ_id => l_pl_typ_id,
10053: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
10054: p_fonm_cvg_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10055: p_fonm_rt_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10056: p_crit_ovrrd_val_tbl => l_crit_ovrrd_val_tab) ;
10057:
10058: end if ;
10059:

Line 10900: ben_manage_life_events.g_output_string :=

10896: -- there are optional profiles, mt_one flag is off
10897: -- and all optional profiles failed
10898: --
10899: -- 5173693 Truncate the String, if too long.
10900: ben_manage_life_events.g_output_string :=
10901: SUBSTR(ben_manage_life_events.g_output_string,1,900) ||
10902: 'Elg: No '||
10903: 'Rsn: Opt Prfl No Pass';
10904:

Line 10901: SUBSTR(ben_manage_life_events.g_output_string,1,900) ||

10897: -- and all optional profiles failed
10898: --
10899: -- 5173693 Truncate the String, if too long.
10900: ben_manage_life_events.g_output_string :=
10901: SUBSTR(ben_manage_life_events.g_output_string,1,900) ||
10902: 'Elg: No '||
10903: 'Rsn: Opt Prfl No Pass';
10904:
10905: --