APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1276: --raise ben_manage_life_events.g_record_error;

1272: --
1273: --if p_per_comp_val is null then
1274: --
1275: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1276: --raise ben_manage_life_events.g_record_error;
1277: --
1278: --end if;
1279: --
1280: -- as the derived factor may have periodicity, we need to compute the compensation

Line 1442: --raise ben_manage_life_events.g_record_error;

1438: --
1439: --if p_per_hrs_wkd is null then
1440: --
1441: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1442: --raise ben_manage_life_events.g_record_error;
1443: --
1444: --end if;
1445: --
1446: if not p_comp_obj_mode then

Line 1598: --raise ben_manage_life_events.g_record_error;

1594: --
1595: --if p_per_hrs_wkd is null then
1596: --
1597: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1598: --raise ben_manage_life_events.g_record_error;
1599: --
1600: --end if;
1601: --
1602: if not p_comp_obj_mode then

Line 1753: --raise ben_manage_life_events.g_record_error;

1749: --
1750: --if p_per_hrs_wkd is null then
1751: --
1752: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
1753: --raise ben_manage_life_events.g_record_error;
1754: --
1755: --end if;
1756: --
1757: if not p_comp_obj_mode then

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

2326: p_effective_date => p_effective_date,
2327: p_param1 => 'BEN_ELP_I_ELIGY_PRFL_ID',
2328: p_param1_value => to_char(nvl(p_eligy_prfl_id, -1)),
2329: p_param2 => 'BEN_IV_RT_STRT_DT',
2330: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2331: p_param3 => 'BEN_IV_CVG_STRT_DT',
2332: p_param3_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt),
2333: p_param4 => 'BEN_IV_PERSON_ID', -- Bug 5331889 : Added person_id param as well
2334: p_param4_value => to_char(p_person_id)

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

4209: ,p_pl_typ_id => p_pl_typ_id
4210: ,p_opt_id => p_opt_id
4211: ,p_ler_id => p_ler_id
4212: ,p_param1 => 'BEN_IV_RT_STRT_DT'
4213: ,p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
4214: ,p_param2 => 'BEN_IV_CVG_STRT_DT'
4215: ,p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
4216:
4217: ,p_jurisdiction_code => p_jurisdiction_code);

Line 4315: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

4311: p_comp_obj_mode => p_comp_obj_mode,
4312: p_business_group_id => p_business_group_id,
4313: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4314: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4315: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4316: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4317: p_returned_date => l_sched_effective_date);
4318: --
4319: end if;

Line 4316: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

4312: p_business_group_id => p_business_group_id,
4313: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
4314: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4315: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
4316: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
4317: p_returned_date => l_sched_effective_date);
4318: --
4319: end if;
4320: --

Line 5416: --raise ben_manage_life_events.g_record_error;

5412: --
5413: --if p_per_comp_val is null then
5414: --
5415: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5416: --raise ben_manage_life_events.g_record_error;
5417: --
5418: --end if;
5419: --
5420: if not p_comp_obj_mode or

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

5578: (p_formula_id => l_inst_dets(l_count).formula_id,
5579: p_assignment_id => l_ass_rec.assignment_id,
5580: p_effective_date => p_effective_date,
5581: p_param1 => 'BEN_IV_RT_STRT_DT',
5582: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5583: p_param2 => 'BEN_IV_CVG_STRT_DT',
5584: p_param2_value => fnd_date.date_to_canonical(l_fonm_cvg_strt_dt)
5585: );
5586: --

Line 5746: --raise ben_manage_life_events.g_record_error;

5742: --
5743: --if p_per_comp_val is null then
5744: --
5745: --fnd_message.set_name('BEN','BEN_91767_DERIVABLE_NO_EXIST');
5746: --raise ben_manage_life_events.g_record_error;
5747: --
5748: --end if;
5749: --
5750: if not p_comp_obj_mode or

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

6157: --
6158: l_rows_found := true;
6159: --
6160: <>
6161: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6162: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6163: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
6164: l_inst_dets(l_insttorrw_num).pl_id then
6165: --

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

6158: l_rows_found := true;
6159: --
6160: <>
6161: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6162: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6163: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
6164: l_inst_dets(l_insttorrw_num).pl_id then
6165: --
6166: -- Apply the date logic to the life event occurred date.

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

6159: --
6160: <>
6161: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6162: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6163: if ben_manage_life_events.g_cache_person_prtn(l_count).pl_id =
6164: l_inst_dets(l_insttorrw_num).pl_id then
6165: --
6166: -- Apply the date logic to the life event occurred date.
6167: --

Line 6172: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6168: ben_determine_date.main
6169: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6170: p_effective_date => p_effective_date,
6171: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6172: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6173: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6174: p_returned_date => l_date_to_use);
6175: --
6176: if (l_date_to_use

Line 6173: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6169: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6170: p_effective_date => p_effective_date,
6171: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6172: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6173: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6174: p_returned_date => l_date_to_use);
6175: --
6176: if (l_date_to_use
6177: between ben_manage_life_events.

Line 6177: between ben_manage_life_events.

6173: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6174: p_returned_date => l_date_to_use);
6175: --
6176: if (l_date_to_use
6177: between ben_manage_life_events.
6178: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6179: and ben_manage_life_events.
6180: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6181: l_found_plan := true;

Line 6179: and ben_manage_life_events.

6175: --
6176: if (l_date_to_use
6177: between ben_manage_life_events.
6178: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6179: and ben_manage_life_events.
6180: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6181: l_found_plan := true;
6182: --
6183: if l_inst_dets(l_insttorrw_num).excld_flag = 'N'then

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

6285: --
6286: l_rows_found := true;
6287: --
6288: <>
6289: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6290: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6291: if ben_manage_life_events.
6292: g_cache_person_prtn(l_count).oipl_id =
6293: l_inst_dets(l_insttorrw_num).oipl_id then

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

6286: l_rows_found := true;
6287: --
6288: <>
6289: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6290: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6291: if ben_manage_life_events.
6292: g_cache_person_prtn(l_count).oipl_id =
6293: l_inst_dets(l_insttorrw_num).oipl_id then
6294: --

Line 6291: if ben_manage_life_events.

6287: --
6288: <>
6289: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6290: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6291: if ben_manage_life_events.
6292: g_cache_person_prtn(l_count).oipl_id =
6293: l_inst_dets(l_insttorrw_num).oipl_id then
6294: --
6295: -- Apply the date logic to the life event occurred date.

Line 6301: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6297: ben_determine_date.main
6298: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6299: p_effective_date => p_effective_date,
6300: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6301: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6302: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6303: p_returned_date => l_date_to_use);
6304: --
6305: if (l_date_to_use

Line 6302: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6298: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6299: p_effective_date => p_effective_date,
6300: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6301: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6302: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6303: p_returned_date => l_date_to_use);
6304: --
6305: if (l_date_to_use
6306: between ben_manage_life_events.

Line 6306: between ben_manage_life_events.

6302: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6303: p_returned_date => l_date_to_use);
6304: --
6305: if (l_date_to_use
6306: between ben_manage_life_events.
6307: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6308: and ben_manage_life_events.
6309: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6310: --

Line 6308: and ben_manage_life_events.

6304: --
6305: if (l_date_to_use
6306: between ben_manage_life_events.
6307: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6308: and ben_manage_life_events.
6309: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6310: --
6311: l_found_oipl := true;
6312: --

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

6407: --
6408: l_rows_found := true;
6409: --
6410: <>
6411: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6412: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6413: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
6414: l_inst_dets(l_insttorrw_num).pgm_id then
6415: l_found_pgm := true;

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

6408: l_rows_found := true;
6409: --
6410: <>
6411: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6412: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6413: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
6414: l_inst_dets(l_insttorrw_num).pgm_id then
6415: l_found_pgm := true;
6416: --

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

6409: --
6410: <>
6411: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6412: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6413: if ben_manage_life_events.g_cache_person_prtn(l_count).pgm_id =
6414: l_inst_dets(l_insttorrw_num).pgm_id then
6415: l_found_pgm := true;
6416: --
6417: -- Apply the date logic to the life event occurred date.

Line 6423: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6419: ben_determine_date.main
6420: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6421: p_effective_date => p_effective_date,
6422: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6423: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6424: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6425: p_returned_date => l_date_to_use);
6426: --
6427: if (l_date_to_use

Line 6424: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6420: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6421: p_effective_date => p_effective_date,
6422: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6423: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6424: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6425: p_returned_date => l_date_to_use);
6426: --
6427: if (l_date_to_use
6428: between ben_manage_life_events.

Line 6428: between ben_manage_life_events.

6424: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6425: p_returned_date => l_date_to_use);
6426: --
6427: if (l_date_to_use
6428: between ben_manage_life_events.
6429: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6430: and ben_manage_life_events.
6431: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6432: --

Line 6430: and ben_manage_life_events.

6426: --
6427: if (l_date_to_use
6428: between ben_manage_life_events.
6429: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6430: and ben_manage_life_events.
6431: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6432: --
6433: if l_inst_dets(l_insttorrw_num).excld_flag = 'N'then
6434: --

Line 6554: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6550: ben_determine_date.main
6551: (p_date_cd => l_inst_dets(l_insttorrw_num).cvg_det_dt_cd,
6552: p_effective_date => p_effective_date,
6553: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6554: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6555: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6556: p_returned_date => l_date_to_use);
6557: --
6558: open c1(l_inst_dets(l_insttorrw_num).pl_id);

Line 6555: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6551: (p_date_cd => l_inst_dets(l_insttorrw_num).cvg_det_dt_cd,
6552: p_effective_date => p_effective_date,
6553: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6554: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6555: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6556: p_returned_date => l_date_to_use);
6557: --
6558: open c1(l_inst_dets(l_insttorrw_num).pl_id);
6559: fetch c1 into l_dummy;

Line 6672: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6668: ben_determine_date.main
6669: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6670: p_effective_date => p_effective_date,
6671: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6672: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6673: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6674: p_returned_date => l_date_to_use);
6675: --
6676: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);

Line 6673: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6669: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6670: p_effective_date => p_effective_date,
6671: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6672: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6673: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6674: p_returned_date => l_date_to_use);
6675: --
6676: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);
6677: --

Line 6801: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6797: ben_determine_date.main
6798: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6799: p_effective_date => p_effective_date,
6800: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6801: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6802: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6803: p_returned_date => l_date_to_use);
6804: --
6805: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);

Line 6802: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6798: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6799: p_effective_date => p_effective_date,
6800: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6801: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6802: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6803: p_returned_date => l_date_to_use);
6804: --
6805: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);
6806: --

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

6926: for l_insttorrw_num in l_inst_dets.first .. l_inst_dets.last loop
6927: --
6928: l_rows_found := true;
6929: --
6930: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);
6931:
6932: <>
6933: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6934: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop

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

6929: --
6930: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);
6931:
6932: <>
6933: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6934: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6935: if ben_manage_life_events.
6936: g_cache_person_prtn(l_count).ptip_id =
6937: l_inst_dets(l_insttorrw_num).ptip_id then

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

6930: hr_utility.set_location('Getting results' || ben_manage_life_events.g_cache_person_prtn.last ,10);
6931:
6932: <>
6933: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6934: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6935: if ben_manage_life_events.
6936: g_cache_person_prtn(l_count).ptip_id =
6937: l_inst_dets(l_insttorrw_num).ptip_id then
6938: --

Line 6935: if ben_manage_life_events.

6931:
6932: <>
6933: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
6934: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
6935: if ben_manage_life_events.
6936: g_cache_person_prtn(l_count).ptip_id =
6937: l_inst_dets(l_insttorrw_num).ptip_id then
6938: --
6939: -- Apply the date logic to the life event occurred date.

Line 6945: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

6941: ben_determine_date.main
6942: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6943: p_effective_date => p_effective_date,
6944: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6945: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6946: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6947: p_returned_date => l_date_to_use);
6948: --
6949: hr_utility.set_location( 'l_date_to_use ' || l_date_to_use , 99 ) ;

Line 6946: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

6942: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
6943: p_effective_date => p_effective_date,
6944: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
6945: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
6946: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
6947: p_returned_date => l_date_to_use);
6948: --
6949: hr_utility.set_location( 'l_date_to_use ' || l_date_to_use , 99 ) ;
6950:

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

6958: hr_utility.set_location('Getting cobra plans',10);
6959: --
6960: if l_inst_dets(l_insttorrw_num).only_pls_subj_cobra_flag = 'Y' then
6961: --
6962: open c1(ben_manage_life_events.g_cache_person_prtn(l_count).pl_id,
6963: l_date_to_use );
6964: --
6965: fetch c1 into l_dummy;
6966: --

Line 6983: between ben_manage_life_events.

6979: --
6980: hr_utility.set_location('Cobra plans found',10);
6981: --
6982: if (l_date_to_use
6983: between ben_manage_life_events.
6984: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6985: and ben_manage_life_events.
6986: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6987: --

Line 6985: and ben_manage_life_events.

6981: --
6982: if (l_date_to_use
6983: between ben_manage_life_events.
6984: g_cache_person_prtn(l_count).enrt_cvg_strt_dt
6985: and ben_manage_life_events.
6986: g_cache_person_prtn(l_count).enrt_cvg_thru_dt) then
6987: --
6988: l_found_ptip := true;
6989: hr_utility.set_location('cobra plans found',10);

Line 7134: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

7130: ben_determine_date.main
7131: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7132: p_effective_date => p_effective_date,
7133: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7134: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7135: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7136: p_returned_date => l_date_to_use);
7137: --
7138: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);

Line 7135: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

7131: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7132: p_effective_date => p_effective_date,
7133: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7134: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7135: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7136: p_returned_date => l_date_to_use);
7137: --
7138: -- 4204020 l_date_to_use := nvl(l_fonm_cvg_strt_dt,l_date_to_use);
7139: --

Line 7268: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,

7264: ben_determine_date.main
7265: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7266: p_effective_date => p_effective_date,
7267: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7268: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7269: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7270: p_returned_date => l_date_to_use);
7271: --
7272: open c1(l_inst_dets(l_insttorrw_num).pgm_id);

Line 7269: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,

7265: (p_date_cd => l_inst_dets(l_insttorrw_num).enrl_det_dt_cd,
7266: p_effective_date => p_effective_date,
7267: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7268: p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt,
7269: p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt,
7270: p_returned_date => l_date_to_use);
7271: --
7272: open c1(l_inst_dets(l_insttorrw_num).pgm_id);
7273: fetch c1 into l_dummy;

Line 8918: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;

8914: l_cagrelig_cnt pls_integer;
8915: l_pl_typ_id number;
8916: l_typ_rec ben_person_object.g_cache_typ_table;
8917: l_appass_rec ben_person_object.g_cache_ass_table;
8918: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
8919: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
8920: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
8921: --
8922: l_ff_use_asg_id_flag varchar2(1);

Line 9226: if ben_manage_life_events.fonm = 'Y'

9222: --
9223: -- intialize the global
9224: --
9225: l_fonm_cvg_strt_dt := null ;
9226: if ben_manage_life_events.fonm = 'Y'
9227: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
9228: --
9229: if p_eval_typ = 'E' then
9230: --

Line 9227: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

9223: -- intialize the global
9224: --
9225: l_fonm_cvg_strt_dt := null ;
9226: if ben_manage_life_events.fonm = 'Y'
9227: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
9228: --
9229: if p_eval_typ = 'E' then
9230: --
9231: 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 9231: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));

9227: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
9228: --
9229: if p_eval_typ = 'E' then
9230: --
9231: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
9232: --
9233: else
9234: --
9235: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

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

9231: l_fonm_cvg_strt_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
9232: --
9233: else
9234: --
9235: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
9236: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
9237: nvl(p_lf_evt_ocrd_dt, p_effective_date)));
9238: --
9239: end if;

Line 9236: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,

9232: --
9233: else
9234: --
9235: l_fonm_cvg_strt_dt :=nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
9236: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
9237: nvl(p_lf_evt_ocrd_dt, p_effective_date)));
9238: --
9239: end if;
9240: --

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

9525:
9526: if l_benmngle_parm_rec.mode_cd = 'I' then
9527: --
9528: l_appass_rec.delete;
9529: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9530: else
9531: --
9532: ben_person_object.get_object(p_person_id => p_person_id,
9533: p_rec => l_appass_rec);

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

9563:
9564:
9565: l_appass_rec.delete;
9566:
9567: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9568:
9569: hr_utility.set_location(' p_assignment_id :' || l_appass_rec(1).assignment_id,99);
9570: hr_utility.set_location(' location_id :' || l_appass_rec(1).location_id,99);
9571: hr_utility.set_location(' p_effective_date :' || p_effective_date,99);

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

9648:
9649: if l_benmngle_parm_rec.mode_cd = 'I' then
9650: --
9651: l_appass_rec.delete;
9652: l_appass_rec(1) := ben_manage_life_events.g_irec_ass_rec ;
9653: else
9654: --
9655: ben_person_object.get_object(p_person_id => p_person_id,
9656: p_rec => l_appass_rec);

Line 10014: p_fonm_cvg_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,

10010: p_oipl_id => p_oipl_id,
10011: p_ler_id => p_ler_id,
10012: p_pl_typ_id => l_pl_typ_id,
10013: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
10014: p_fonm_cvg_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10015: p_fonm_rt_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10016: p_crit_ovrrd_val_tbl => l_crit_ovrrd_val_tab) ;
10017:
10018: end if ;

Line 10015: p_fonm_rt_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,

10011: p_ler_id => p_ler_id,
10012: p_pl_typ_id => l_pl_typ_id,
10013: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
10014: p_fonm_cvg_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10015: p_fonm_rt_strt_date => ben_manage_life_events.g_fonm_cvg_strt_dt,
10016: p_crit_ovrrd_val_tbl => l_crit_ovrrd_val_tab) ;
10017:
10018: end if ;
10019:

Line 10853: ben_manage_life_events.g_output_string :=

10849: -- there are optional profiles, mt_one flag is off
10850: -- and all optional profiles failed
10851: --
10852: -- 5173693 Truncate the String, if too long.
10853: ben_manage_life_events.g_output_string :=
10854: SUBSTR(ben_manage_life_events.g_output_string,1,900) ||
10855: 'Elg: No '||
10856: 'Rsn: Opt Prfl No Pass';
10857:

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

10850: -- and all optional profiles failed
10851: --
10852: -- 5173693 Truncate the String, if too long.
10853: ben_manage_life_events.g_output_string :=
10854: SUBSTR(ben_manage_life_events.g_output_string,1,900) ||
10855: 'Elg: No '||
10856: 'Rsn: Opt Prfl No Pass';
10857:
10858: --