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_LF_EVT_CLPS_RESTORE dependencies on HR_API

Line 164: and (pen.effective_end_date = hr_api.g_eot or

160: and ((pen.pgm_id is null and c_pgm_id is null) or
161: pen.pgm_id = c_pgm_id )
162: and ( c_pl_id is null or
163: pen.pl_id = c_pl_id )
164: and (pen.effective_end_date = hr_api.g_eot or
165: pen.effective_end_date = (select max(effective_end_date)
166: from ben_prtt_enrt_rslt_f
167: where prtt_enrt_rslt_id =
168: pen.prtt_enrt_rslt_id))

Line 170: pen.enrt_cvg_thru_dt = hr_api.g_eot

166: from ben_prtt_enrt_rslt_f
167: where prtt_enrt_rslt_id =
168: pen.prtt_enrt_rslt_id))
169: and (pen.enrt_cvg_thru_dt is null or
170: pen.enrt_cvg_thru_dt = hr_api.g_eot
171: )
172: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
173: and pen.prtt_enrt_rslt_id not in (
174: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 181: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

177: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
178: and pil_inner.person_id = c_person_id
179: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
180: and (pen_inner.enrt_cvg_thru_dt is null or
181: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
182: )
183: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
184: union
185: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 193: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

189: and pil_inner.person_id = c_person_id
190: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
191: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
192: and (pen_inner.enrt_cvg_thru_dt is null or
193: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
194: )
195: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
196: )
197: union

Line 297: pen.enrt_cvg_thru_dt = hr_api.g_eot) and

293: pen.pgm_id = c_pgm_id )
294: and ( c_pl_id is null or
295: pen.pl_id = c_pl_id )
296: and ((pen.enrt_cvg_thru_dt is null or
297: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
298: pen.effective_end_date = hr_api.g_eot
299: )
300: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
301: and pen.bkup_tbl_id not in (

Line 298: pen.effective_end_date = hr_api.g_eot

294: and ( c_pl_id is null or
295: pen.pl_id = c_pl_id )
296: and ((pen.enrt_cvg_thru_dt is null or
297: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
298: pen.effective_end_date = hr_api.g_eot
299: )
300: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
301: and pen.bkup_tbl_id not in (
302: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 309: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

305: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
306: and pil_inner.person_id = c_person_id
307: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
308: and (pen_inner.enrt_cvg_thru_dt is null or
309: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
310: )
311: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
312: union
313: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 321: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

317: and pil_inner.person_id = c_person_id
318: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
319: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
320: and (pen_inner.enrt_cvg_thru_dt is null or
321: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
322: )
323: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
324: )
325: order by 1;

Line 370: epen.enrt_cvg_thru_dt = hr_api.g_eot)

366: (select '1' from ben_prtt_enrt_rslt_f epen where
367: epen.per_in_ler_id = c_bckdt_per_in_ler_id
368: and epen.person_id = c_person_id
369: and (epen.enrt_cvg_thru_dt is null or
370: epen.enrt_cvg_thru_dt = hr_api.g_eot)
371: and epen.effective_end_date = hr_api.g_eot)
372: --To Handle Programs and Plans not in Program
373: and (pen.effective_end_date = hr_api.g_eot or
374: pen.effective_end_date = (select max(effective_end_date)

Line 371: and epen.effective_end_date = hr_api.g_eot)

367: epen.per_in_ler_id = c_bckdt_per_in_ler_id
368: and epen.person_id = c_person_id
369: and (epen.enrt_cvg_thru_dt is null or
370: epen.enrt_cvg_thru_dt = hr_api.g_eot)
371: and epen.effective_end_date = hr_api.g_eot)
372: --To Handle Programs and Plans not in Program
373: and (pen.effective_end_date = hr_api.g_eot or
374: pen.effective_end_date = (select max(effective_end_date)
375: from ben_prtt_enrt_rslt_f

Line 373: and (pen.effective_end_date = hr_api.g_eot or

369: and (epen.enrt_cvg_thru_dt is null or
370: epen.enrt_cvg_thru_dt = hr_api.g_eot)
371: and epen.effective_end_date = hr_api.g_eot)
372: --To Handle Programs and Plans not in Program
373: and (pen.effective_end_date = hr_api.g_eot or
374: pen.effective_end_date = (select max(effective_end_date)
375: from ben_prtt_enrt_rslt_f
376: where prtt_enrt_rslt_id =
377: pen.prtt_enrt_rslt_id))

Line 379: pen.enrt_cvg_thru_dt = hr_api.g_eot

375: from ben_prtt_enrt_rslt_f
376: where prtt_enrt_rslt_id =
377: pen.prtt_enrt_rslt_id))
378: and (pen.enrt_cvg_thru_dt is null or
379: pen.enrt_cvg_thru_dt = hr_api.g_eot
380: )
381: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
382: and pen.prtt_enrt_rslt_id not in (
383: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 390: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

386: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
387: and pil_inner.person_id = c_person_id
388: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
389: and (pen_inner.enrt_cvg_thru_dt is null or
390: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
391: )
392: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
393: union
394: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 402: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

398: and pil_inner.person_id = c_person_id
399: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
400: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
401: and (pen_inner.enrt_cvg_thru_dt is null or
402: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
403: )
404: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
405: )
406: union

Line 439: epen.enrt_cvg_thru_dt = hr_api.g_eot)

435: (select '1' from ben_prtt_enrt_rslt_f epen where
436: epen.per_in_ler_id = c_bckdt_per_in_ler_id
437: and epen.person_id = c_person_id
438: and (epen.enrt_cvg_thru_dt is null or
439: epen.enrt_cvg_thru_dt = hr_api.g_eot)
440: and epen.effective_end_date = hr_api.g_eot)
441: AND pil.per_in_ler_id = pen.per_in_ler_id
442: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
443: and ((pen.enrt_cvg_thru_dt is null or

Line 440: and epen.effective_end_date = hr_api.g_eot)

436: epen.per_in_ler_id = c_bckdt_per_in_ler_id
437: and epen.person_id = c_person_id
438: and (epen.enrt_cvg_thru_dt is null or
439: epen.enrt_cvg_thru_dt = hr_api.g_eot)
440: and epen.effective_end_date = hr_api.g_eot)
441: AND pil.per_in_ler_id = pen.per_in_ler_id
442: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
443: and ((pen.enrt_cvg_thru_dt is null or
444: pen.enrt_cvg_thru_dt = hr_api.g_eot) and

Line 444: pen.enrt_cvg_thru_dt = hr_api.g_eot) and

440: and epen.effective_end_date = hr_api.g_eot)
441: AND pil.per_in_ler_id = pen.per_in_ler_id
442: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
443: and ((pen.enrt_cvg_thru_dt is null or
444: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
445: pen.effective_end_date = hr_api.g_eot
446: )
447: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
448: and pen.bkup_tbl_id not in (

Line 445: pen.effective_end_date = hr_api.g_eot

441: AND pil.per_in_ler_id = pen.per_in_ler_id
442: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
443: and ((pen.enrt_cvg_thru_dt is null or
444: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
445: pen.effective_end_date = hr_api.g_eot
446: )
447: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
448: and pen.bkup_tbl_id not in (
449: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 456: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

452: where pil_inner.per_in_ler_id = c_bckdt_per_in_ler_id
453: and pil_inner.person_id = c_person_id
454: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
455: and (pen_inner.enrt_cvg_thru_dt is null or
456: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
457: )
458: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
459: union
460: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 468: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

464: and pil_inner.person_id = c_person_id
465: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
466: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
467: and (pen_inner.enrt_cvg_thru_dt is null or
468: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
469: )
470: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
471: )
472: order by 1;

Line 797: and pen.enrt_cvg_thru_dt = hr_api.g_eot

793: and pil.person_id = p_person_id
794: and pil.business_group_id = p_business_group_id
795: AND pil.per_in_ler_id = pen.per_in_ler_id
796: and pen.prtt_enrt_rslt_stat_cd is null
797: and pen.enrt_cvg_thru_dt = hr_api.g_eot
798: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP') ;
799: --
800: TYPE l_prev_pen_rec is TABLE OF c_pen_dat%rowtype INDEX BY BINARY_INTEGER;
801: --

Line 1016: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot BUG 4642657

1012: /* Bug 8305552: Added 'not in (p_per_in_ler_id)'. Do not check elections for the current LifeEvent,because for Automatic enrollments
1013: record will be present during validation of the cursor*/
1014: and pen.person_id = p_person_id
1015: and pen.prtt_enrt_rslt_stat_cd is null
1016: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot BUG 4642657
1017: and pen.effective_end_date = hr_api.g_eot
1018: and pen.ler_id = ler.ler_id
1019: and p_effective_date between ler.effective_start_date and
1020: ler.effective_end_date

Line 1017: and pen.effective_end_date = hr_api.g_eot

1013: record will be present during validation of the cursor*/
1014: and pen.person_id = p_person_id
1015: and pen.prtt_enrt_rslt_stat_cd is null
1016: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot BUG 4642657
1017: and pen.effective_end_date = hr_api.g_eot
1018: and pen.ler_id = ler.ler_id
1019: and p_effective_date between ler.effective_start_date and
1020: ler.effective_end_date
1021: and ler.typ_cd not in ('IREC','SCHEDDU', 'COMP', 'GSP', 'ABS')

Line 1358: nvl(bckdt_epe_egd_rec.ELIG_STRT_DT, hr_api.g_eot) =

1354: if nvl(bckdt_epe_egd_rec.DPNT_INELIG_FLAG, '$') =
1355: nvl(l_curr_epe_egd_table(l_curr_count).DPNT_INELIG_FLAG, '$') and
1356: nvl(bckdt_epe_egd_rec.INELG_RSN_CD, '$') =
1357: nvl(l_curr_epe_egd_table(l_curr_count).INELG_RSN_CD, '$') and
1358: nvl(bckdt_epe_egd_rec.ELIG_STRT_DT, hr_api.g_eot) =
1359: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_STRT_DT, hr_api.g_eot) and
1360: nvl(bckdt_epe_egd_rec.ELIG_THRU_DT, hr_api.g_eot) =
1361: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_THRU_DT, hr_api.g_eot) and
1362: nvl(bckdt_epe_egd_rec.DPNT_PERSON_ID, -1) =

Line 1359: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_STRT_DT, hr_api.g_eot) and

1355: nvl(l_curr_epe_egd_table(l_curr_count).DPNT_INELIG_FLAG, '$') and
1356: nvl(bckdt_epe_egd_rec.INELG_RSN_CD, '$') =
1357: nvl(l_curr_epe_egd_table(l_curr_count).INELG_RSN_CD, '$') and
1358: nvl(bckdt_epe_egd_rec.ELIG_STRT_DT, hr_api.g_eot) =
1359: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_STRT_DT, hr_api.g_eot) and
1360: nvl(bckdt_epe_egd_rec.ELIG_THRU_DT, hr_api.g_eot) =
1361: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_THRU_DT, hr_api.g_eot) and
1362: nvl(bckdt_epe_egd_rec.DPNT_PERSON_ID, -1) =
1363: nvl(l_curr_epe_egd_table(l_curr_count).DPNT_PERSON_ID, -1)

Line 1360: nvl(bckdt_epe_egd_rec.ELIG_THRU_DT, hr_api.g_eot) =

1356: nvl(bckdt_epe_egd_rec.INELG_RSN_CD, '$') =
1357: nvl(l_curr_epe_egd_table(l_curr_count).INELG_RSN_CD, '$') and
1358: nvl(bckdt_epe_egd_rec.ELIG_STRT_DT, hr_api.g_eot) =
1359: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_STRT_DT, hr_api.g_eot) and
1360: nvl(bckdt_epe_egd_rec.ELIG_THRU_DT, hr_api.g_eot) =
1361: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_THRU_DT, hr_api.g_eot) and
1362: nvl(bckdt_epe_egd_rec.DPNT_PERSON_ID, -1) =
1363: nvl(l_curr_epe_egd_table(l_curr_count).DPNT_PERSON_ID, -1)
1364: then

Line 1361: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_THRU_DT, hr_api.g_eot) and

1357: nvl(l_curr_epe_egd_table(l_curr_count).INELG_RSN_CD, '$') and
1358: nvl(bckdt_epe_egd_rec.ELIG_STRT_DT, hr_api.g_eot) =
1359: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_STRT_DT, hr_api.g_eot) and
1360: nvl(bckdt_epe_egd_rec.ELIG_THRU_DT, hr_api.g_eot) =
1361: nvl(l_curr_epe_egd_table(l_curr_count).ELIG_THRU_DT, hr_api.g_eot) and
1362: nvl(bckdt_epe_egd_rec.DPNT_PERSON_ID, -1) =
1363: nvl(l_curr_epe_egd_table(l_curr_count).DPNT_PERSON_ID, -1)
1364: then
1365: l_found := TRUE;

Line 1506: nvl(bckdt_enb_ecr_rec.RT_STRT_DT, hr_api.g_eot) =

1502: nvl(bckdt_enb_ecr_rec.MN_ELCN_VAL, -1) =
1503: nvl(l_curr_enb_ecr_table(l_curr_count).MN_ELCN_VAL, -1) and
1504: nvl(bckdt_enb_ecr_rec.INCRMT_ELCN_VAL, -1) =
1505: nvl(l_curr_enb_ecr_table(l_curr_count).INCRMT_ELCN_VAL, -1) and
1506: nvl(bckdt_enb_ecr_rec.RT_STRT_DT, hr_api.g_eot) =
1507: nvl(l_curr_enb_ecr_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
1508: nvl(bckdt_enb_ecr_rec.RT_STRT_DT_CD, '$') =
1509: nvl(l_curr_enb_ecr_table(l_curr_count).RT_STRT_DT_CD, '$') and
1510: nvl(bckdt_enb_ecr_rec.RT_STRT_DT_RL, -1) =

Line 1507: nvl(l_curr_enb_ecr_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and

1503: nvl(l_curr_enb_ecr_table(l_curr_count).MN_ELCN_VAL, -1) and
1504: nvl(bckdt_enb_ecr_rec.INCRMT_ELCN_VAL, -1) =
1505: nvl(l_curr_enb_ecr_table(l_curr_count).INCRMT_ELCN_VAL, -1) and
1506: nvl(bckdt_enb_ecr_rec.RT_STRT_DT, hr_api.g_eot) =
1507: nvl(l_curr_enb_ecr_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
1508: nvl(bckdt_enb_ecr_rec.RT_STRT_DT_CD, '$') =
1509: nvl(l_curr_enb_ecr_table(l_curr_count).RT_STRT_DT_CD, '$') and
1510: nvl(bckdt_enb_ecr_rec.RT_STRT_DT_RL, -1) =
1511: nvl(l_curr_enb_ecr_table(l_curr_count).RT_STRT_DT_RL, -1) and

Line 1675: nvl(bckdt_epe_ecr_rec.RT_STRT_DT, hr_api.g_eot) =

1671: nvl(bckdt_epe_ecr_rec.MN_ELCN_VAL, -1) =
1672: nvl(l_curr_epe_ecr_table(l_curr_count).MN_ELCN_VAL, -1) and
1673: nvl(bckdt_epe_ecr_rec.INCRMT_ELCN_VAL, -1) =
1674: nvl(l_curr_epe_ecr_table(l_curr_count).INCRMT_ELCN_VAL, -1) and
1675: nvl(bckdt_epe_ecr_rec.RT_STRT_DT, hr_api.g_eot) =
1676: nvl(l_curr_epe_ecr_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
1677: nvl(bckdt_epe_ecr_rec.RT_STRT_DT_CD, '$') =
1678: nvl(l_curr_epe_ecr_table(l_curr_count).RT_STRT_DT_CD, '$') and
1679: nvl(bckdt_epe_ecr_rec.RT_STRT_DT_RL, -1) =

Line 1676: nvl(l_curr_epe_ecr_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and

1672: nvl(l_curr_epe_ecr_table(l_curr_count).MN_ELCN_VAL, -1) and
1673: nvl(bckdt_epe_ecr_rec.INCRMT_ELCN_VAL, -1) =
1674: nvl(l_curr_epe_ecr_table(l_curr_count).INCRMT_ELCN_VAL, -1) and
1675: nvl(bckdt_epe_ecr_rec.RT_STRT_DT, hr_api.g_eot) =
1676: nvl(l_curr_epe_ecr_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
1677: nvl(bckdt_epe_ecr_rec.RT_STRT_DT_CD, '$') =
1678: nvl(l_curr_epe_ecr_table(l_curr_count).RT_STRT_DT_CD, '$') and
1679: nvl(bckdt_epe_ecr_rec.RT_STRT_DT_RL, -1) =
1680: nvl(l_curr_epe_ecr_table(l_curr_count).RT_STRT_DT_RL, -1) and

Line 2051: nvl(bckdt_ecd_rec.effective_end_date, hr_api.g_eot) =

2047: for l_curr_count in l_curr_ecd_table.first..l_curr_ecd_table.last loop
2048: --
2049: if nvl(bckdt_ecd_rec.dpnt_person_id, -1) =
2050: nvl(l_curr_ecd_table(l_curr_count).dpnt_person_id, -1) and
2051: nvl(bckdt_ecd_rec.effective_end_date, hr_api.g_eot) =
2052: nvl(l_curr_ecd_table(l_curr_count).effective_end_date, hr_api.g_eot) and
2053: nvl(bckdt_ecd_rec.cvg_thru_dt, hr_api.g_eot) =
2054: nvl(l_curr_ecd_table(l_curr_count).cvg_thru_dt, hr_api.g_eot)
2055: then

Line 2052: nvl(l_curr_ecd_table(l_curr_count).effective_end_date, hr_api.g_eot) and

2048: --
2049: if nvl(bckdt_ecd_rec.dpnt_person_id, -1) =
2050: nvl(l_curr_ecd_table(l_curr_count).dpnt_person_id, -1) and
2051: nvl(bckdt_ecd_rec.effective_end_date, hr_api.g_eot) =
2052: nvl(l_curr_ecd_table(l_curr_count).effective_end_date, hr_api.g_eot) and
2053: nvl(bckdt_ecd_rec.cvg_thru_dt, hr_api.g_eot) =
2054: nvl(l_curr_ecd_table(l_curr_count).cvg_thru_dt, hr_api.g_eot)
2055: then
2056: l_found := TRUE;

Line 2053: nvl(bckdt_ecd_rec.cvg_thru_dt, hr_api.g_eot) =

2049: if nvl(bckdt_ecd_rec.dpnt_person_id, -1) =
2050: nvl(l_curr_ecd_table(l_curr_count).dpnt_person_id, -1) and
2051: nvl(bckdt_ecd_rec.effective_end_date, hr_api.g_eot) =
2052: nvl(l_curr_ecd_table(l_curr_count).effective_end_date, hr_api.g_eot) and
2053: nvl(bckdt_ecd_rec.cvg_thru_dt, hr_api.g_eot) =
2054: nvl(l_curr_ecd_table(l_curr_count).cvg_thru_dt, hr_api.g_eot)
2055: then
2056: l_found := TRUE;
2057: exit;

Line 2054: nvl(l_curr_ecd_table(l_curr_count).cvg_thru_dt, hr_api.g_eot)

2050: nvl(l_curr_ecd_table(l_curr_count).dpnt_person_id, -1) and
2051: nvl(bckdt_ecd_rec.effective_end_date, hr_api.g_eot) =
2052: nvl(l_curr_ecd_table(l_curr_count).effective_end_date, hr_api.g_eot) and
2053: nvl(bckdt_ecd_rec.cvg_thru_dt, hr_api.g_eot) =
2054: nvl(l_curr_ecd_table(l_curr_count).cvg_thru_dt, hr_api.g_eot)
2055: then
2056: l_found := TRUE;
2057: exit;
2058: end if;

Line 2245: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);

2241: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2242: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2243: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2244: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2245: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2246: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2247: */
2248: l_found := FALSE;
2249: l_diff_auto_flag := TRUE ;

Line 2246: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);

2242: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2243: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2244: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2245: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2246: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2247: */
2248: l_found := FALSE;
2249: l_diff_auto_flag := TRUE ;
2250: --

Line 2279: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);

2275: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2276: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2277: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2278: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2279: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2280: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2281:
2282:
2283: if l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG = 'Y' and

Line 2280: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);

2276: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2277: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2278: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2279: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2280: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2281:
2282:
2283: if l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG = 'Y' and
2284: l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG = 'Y' and

Line 2344: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =

2340: nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$') =
2341: nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$') and
2342: nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1) =
2343: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2344: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2345: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2346: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2347: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2348: then

Line 2345: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and

2341: nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$') and
2342: nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1) =
2343: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2344: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2345: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2346: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2347: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2348: then
2349: --

Line 2346: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =

2342: nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1) =
2343: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2344: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2345: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2346: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2347: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2348: then
2349: --
2350: -- Now check elig_dpnt rows for any differences.

Line 2347: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)

2343: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2344: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2345: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2346: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2347: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2348: then
2349: --
2350: -- Now check elig_dpnt rows for any differences.
2351: --

Line 2676: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =

2672: nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$') =
2673: nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$') and
2674: nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1) =
2675: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2676: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2677: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2678: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2679: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2680: then

Line 2677: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and

2673: nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$') and
2674: nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1) =
2675: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2676: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2677: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2678: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2679: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2680: then
2681: --

Line 2678: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =

2674: nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1) =
2675: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2676: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2677: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2678: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2679: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2680: then
2681: --
2682: -- Now check elig_dpnt rows for any differences.

Line 2679: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)

2675: nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1) and
2676: nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot) =
2677: nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
2678: nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot) =
2679: nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot)
2680: then
2681: --
2682: -- Now check elig_dpnt rows for any differences.
2683: --

Line 2840: ,p_datetrack_mode => hr_api.g_correction);

2836: ,p_effective_end_date => l_effective_end_date
2837: ,p_per_cm_prvdd_stat_cd => 'VOID'
2838: ,p_object_version_number => per_cm_rec.object_version_number
2839: ,p_effective_date => p_effective_date
2840: ,p_datetrack_mode => hr_api.g_correction);
2841: --
2842: end loop;
2843: --
2844: hr_utility.set_location('Leaving:'|| l_proc, 10);

Line 2900: ,p_datetrack_mode => hr_api.g_correction);

2896: ,p_resnd_rsn_cd => 'RPE' -- event reprocessed
2897: ,p_resnd_cmnt_txt => l_resnd_cmnt_txt
2898: ,p_object_version_number => per_cm_rec.object_version_number
2899: ,p_effective_date => p_effective_date
2900: ,p_datetrack_mode => hr_api.g_correction);
2901: --
2902: end loop;
2903: --
2904: hr_utility.set_location('Leaving:'|| l_proc, 10);

Line 3165: nvl(bckdt_prv_rec.RT_STRT_DT, hr_api.g_eot) =

3161: loop
3162: --
3163: if nvl(bckdt_prv_rec.RT_TYP_CD, '$') =
3164: nvl(l_curr_prv_table(l_curr_count).RT_TYP_CD, '$') and
3165: nvl(bckdt_prv_rec.RT_STRT_DT, hr_api.g_eot) =
3166: nvl(l_curr_prv_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
3167: (nvl(bckdt_prv_rec.RT_END_DT, hr_api.g_eot) =
3168: nvl(l_curr_prv_table(l_curr_count).RT_END_DT, hr_api.g_eot) or
3169: p_dont_check_cnt_flag = 'Y'

Line 3166: nvl(l_curr_prv_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and

3162: --
3163: if nvl(bckdt_prv_rec.RT_TYP_CD, '$') =
3164: nvl(l_curr_prv_table(l_curr_count).RT_TYP_CD, '$') and
3165: nvl(bckdt_prv_rec.RT_STRT_DT, hr_api.g_eot) =
3166: nvl(l_curr_prv_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
3167: (nvl(bckdt_prv_rec.RT_END_DT, hr_api.g_eot) =
3168: nvl(l_curr_prv_table(l_curr_count).RT_END_DT, hr_api.g_eot) or
3169: p_dont_check_cnt_flag = 'Y'
3170: ) and

Line 3167: (nvl(bckdt_prv_rec.RT_END_DT, hr_api.g_eot) =

3163: if nvl(bckdt_prv_rec.RT_TYP_CD, '$') =
3164: nvl(l_curr_prv_table(l_curr_count).RT_TYP_CD, '$') and
3165: nvl(bckdt_prv_rec.RT_STRT_DT, hr_api.g_eot) =
3166: nvl(l_curr_prv_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
3167: (nvl(bckdt_prv_rec.RT_END_DT, hr_api.g_eot) =
3168: nvl(l_curr_prv_table(l_curr_count).RT_END_DT, hr_api.g_eot) or
3169: p_dont_check_cnt_flag = 'Y'
3170: ) and
3171: nvl(bckdt_prv_rec.TX_TYP_CD, '$') =

Line 3168: nvl(l_curr_prv_table(l_curr_count).RT_END_DT, hr_api.g_eot) or

3164: nvl(l_curr_prv_table(l_curr_count).RT_TYP_CD, '$') and
3165: nvl(bckdt_prv_rec.RT_STRT_DT, hr_api.g_eot) =
3166: nvl(l_curr_prv_table(l_curr_count).RT_STRT_DT, hr_api.g_eot) and
3167: (nvl(bckdt_prv_rec.RT_END_DT, hr_api.g_eot) =
3168: nvl(l_curr_prv_table(l_curr_count).RT_END_DT, hr_api.g_eot) or
3169: p_dont_check_cnt_flag = 'Y'
3170: ) and
3171: nvl(bckdt_prv_rec.TX_TYP_CD, '$') =
3172: nvl(l_curr_prv_table(l_curr_count).TX_TYP_CD, '$') and

Line 3199: nvl(bckdt_prv_rec.RT_OVRIDN_THRU_DT, hr_api.g_eot) =

3195: nvl(bckdt_prv_rec.DSPLY_ON_ENRT_FLAG, '$') =
3196: nvl(l_curr_prv_table(l_curr_count).DSPLY_ON_ENRT_FLAG, '$') and
3197: nvl(bckdt_prv_rec.RT_OVRIDN_FLAG, '$') =
3198: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_FLAG, '$') and
3199: nvl(bckdt_prv_rec.RT_OVRIDN_THRU_DT, hr_api.g_eot) =
3200: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_THRU_DT, hr_api.g_eot) and
3201: nvl(bckdt_prv_rec.ELCTNS_MADE_DT, hr_api.g_eot) =
3202: nvl(l_curr_prv_table(l_curr_count).ELCTNS_MADE_DT, hr_api.g_eot) and
3203: nvl(bckdt_prv_rec.CVG_AMT_CALC_MTHD_ID, -1) =

Line 3200: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_THRU_DT, hr_api.g_eot) and

3196: nvl(l_curr_prv_table(l_curr_count).DSPLY_ON_ENRT_FLAG, '$') and
3197: nvl(bckdt_prv_rec.RT_OVRIDN_FLAG, '$') =
3198: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_FLAG, '$') and
3199: nvl(bckdt_prv_rec.RT_OVRIDN_THRU_DT, hr_api.g_eot) =
3200: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_THRU_DT, hr_api.g_eot) and
3201: nvl(bckdt_prv_rec.ELCTNS_MADE_DT, hr_api.g_eot) =
3202: nvl(l_curr_prv_table(l_curr_count).ELCTNS_MADE_DT, hr_api.g_eot) and
3203: nvl(bckdt_prv_rec.CVG_AMT_CALC_MTHD_ID, -1) =
3204: nvl(l_curr_prv_table(l_curr_count).CVG_AMT_CALC_MTHD_ID, -1) and

Line 3201: nvl(bckdt_prv_rec.ELCTNS_MADE_DT, hr_api.g_eot) =

3197: nvl(bckdt_prv_rec.RT_OVRIDN_FLAG, '$') =
3198: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_FLAG, '$') and
3199: nvl(bckdt_prv_rec.RT_OVRIDN_THRU_DT, hr_api.g_eot) =
3200: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_THRU_DT, hr_api.g_eot) and
3201: nvl(bckdt_prv_rec.ELCTNS_MADE_DT, hr_api.g_eot) =
3202: nvl(l_curr_prv_table(l_curr_count).ELCTNS_MADE_DT, hr_api.g_eot) and
3203: nvl(bckdt_prv_rec.CVG_AMT_CALC_MTHD_ID, -1) =
3204: nvl(l_curr_prv_table(l_curr_count).CVG_AMT_CALC_MTHD_ID, -1) and
3205: nvl(bckdt_prv_rec.ACTL_PREM_ID, -1) =

Line 3202: nvl(l_curr_prv_table(l_curr_count).ELCTNS_MADE_DT, hr_api.g_eot) and

3198: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_FLAG, '$') and
3199: nvl(bckdt_prv_rec.RT_OVRIDN_THRU_DT, hr_api.g_eot) =
3200: nvl(l_curr_prv_table(l_curr_count).RT_OVRIDN_THRU_DT, hr_api.g_eot) and
3201: nvl(bckdt_prv_rec.ELCTNS_MADE_DT, hr_api.g_eot) =
3202: nvl(l_curr_prv_table(l_curr_count).ELCTNS_MADE_DT, hr_api.g_eot) and
3203: nvl(bckdt_prv_rec.CVG_AMT_CALC_MTHD_ID, -1) =
3204: nvl(l_curr_prv_table(l_curr_count).CVG_AMT_CALC_MTHD_ID, -1) and
3205: nvl(bckdt_prv_rec.ACTL_PREM_ID, -1) =
3206: nvl(l_curr_prv_table(l_curr_count).ACTL_PREM_ID, -1) and

Line 3556: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||

3552: hr_utility.set_location( 'SSPNDD_FLAG ' ||
3553: nvl(bckdt_pen_rec.SSPNDD_FLAG, '$r') ||'--'||
3554: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$'),4987);
3555: hr_utility.set_location( 'ENRT_CVG_STRT_DT '
3556: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3557: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3558: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3559: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3560: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);

Line 3557: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);

3553: nvl(bckdt_pen_rec.SSPNDD_FLAG, '$r') ||'--'||
3554: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$'),4987);
3555: hr_utility.set_location( 'ENRT_CVG_STRT_DT '
3556: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3557: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3558: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3559: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3560: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);
3561: hr_utility.set_location( 'PRTT_IS_CVRD_FLA '

Line 3559: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||

3555: hr_utility.set_location( 'ENRT_CVG_STRT_DT '
3556: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3557: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3558: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3559: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3560: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);
3561: hr_utility.set_location( 'PRTT_IS_CVRD_FLA '
3562: || nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') ||'--'||
3563: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$'),4987);

Line 3560: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);

3556: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3557: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3558: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3559: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3560: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);
3561: hr_utility.set_location( 'PRTT_IS_CVRD_FLA '
3562: || nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') ||'--'||
3563: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$'),4987);
3564: hr_utility.set_location( 'PRTT_IS_CVRD_FLAG'

Line 3576: || nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) ||'--'||

3572: nvl(l_curr_pen_table(l_curr_count).BNFT_TYP_CD, '$'),4987);
3573: hr_utility.set_location( 'UOM ' || nvl(bckdt_pen_rec.UOM, '$') ||'--'||
3574: nvl(l_curr_pen_table(l_curr_count).UOM, '$'),4987);
3575: hr_utility.set_location( 'ORGNL_ENRT_DT '
3576: || nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) ||'--'||
3577: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);
3578: hr_utility.set_location( 'ENRT_MTHD_CD '
3579: || nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') ||'--'||
3580: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$'),4987);

Line 3577: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);

3573: hr_utility.set_location( 'UOM ' || nvl(bckdt_pen_rec.UOM, '$') ||'--'||
3574: nvl(l_curr_pen_table(l_curr_count).UOM, '$'),4987);
3575: hr_utility.set_location( 'ORGNL_ENRT_DT '
3576: || nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) ||'--'||
3577: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);
3578: hr_utility.set_location( 'ENRT_MTHD_CD '
3579: || nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') ||'--'||
3580: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$'),4987);
3581: hr_utility.set_location( 'ENRT_OVRIDN_FLAG '||

Line 3588: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||

3584: hr_utility.set_location( 'ENRT_OVRID_RSN_CD '
3585: || nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$')||'--'||
3586: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$'),4987);
3587: hr_utility.set_location( 'ERLST_DEENRT_DT '
3588: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||
3589: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);
3590:
3591: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3592: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||

Line 3589: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);

3585: || nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$')||'--'||
3586: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$'),4987);
3587: hr_utility.set_location( 'ERLST_DEENRT_DT '
3588: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||
3589: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);
3590:
3591: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3592: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||
3593: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);

Line 3592: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||

3588: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||
3589: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);
3590:
3591: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3592: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||
3593: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);
3594: hr_utility.set_location( 'NO_LNGR_ELIG_FLAG'
3595: || nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$')||'--'||
3596: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$'),4987);

Line 3593: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);

3589: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);
3590:
3591: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3592: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||
3593: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);
3594: hr_utility.set_location( 'NO_LNGR_ELIG_FLAG'
3595: || nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$')||'--'||
3596: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$'),4987);
3597: hr_utility.set_location( 'PRTT_ENRT_RSLT_STAT_CD'

Line 3623: nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) =

3619:
3620: */
3621: if nvl(bckdt_pen_rec.SSPNDD_FLAG, '$') =
3622: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$') and
3623: nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) =
3624: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
3625: nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot) =
3626: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot) and
3627: nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') =

Line 3624: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and

3620: */
3621: if nvl(bckdt_pen_rec.SSPNDD_FLAG, '$') =
3622: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$') and
3623: nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) =
3624: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
3625: nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot) =
3626: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot) and
3627: nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') =
3628: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$') and

Line 3625: nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot) =

3621: if nvl(bckdt_pen_rec.SSPNDD_FLAG, '$') =
3622: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$') and
3623: nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) =
3624: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
3625: nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot) =
3626: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot) and
3627: nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') =
3628: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$') and
3629: nvl(bckdt_pen_rec.BNFT_AMT, -1) =

Line 3626: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot) and

3622: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$') and
3623: nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) =
3624: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot) and
3625: nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot) =
3626: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot) and
3627: nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') =
3628: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$') and
3629: nvl(bckdt_pen_rec.BNFT_AMT, -1) =
3630: nvl(l_curr_pen_table(l_curr_count).BNFT_AMT, -1) and

Line 3637: nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) =

3633: nvl(bckdt_pen_rec.BNFT_TYP_CD, '$') =
3634: nvl(l_curr_pen_table(l_curr_count).BNFT_TYP_CD, '$') and
3635: nvl(bckdt_pen_rec.UOM, '$') =
3636: nvl(l_curr_pen_table(l_curr_count).UOM, '$') and
3637: nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) =
3638: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot) and
3639: nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') =
3640: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$') and
3641: nvl(bckdt_pen_rec.ENRT_OVRIDN_FLAG, '$') =

Line 3638: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot) and

3634: nvl(l_curr_pen_table(l_curr_count).BNFT_TYP_CD, '$') and
3635: nvl(bckdt_pen_rec.UOM, '$') =
3636: nvl(l_curr_pen_table(l_curr_count).UOM, '$') and
3637: nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) =
3638: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot) and
3639: nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') =
3640: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$') and
3641: nvl(bckdt_pen_rec.ENRT_OVRIDN_FLAG, '$') =
3642: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRIDN_FLAG, '$') and

Line 3645: nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot) =

3641: nvl(bckdt_pen_rec.ENRT_OVRIDN_FLAG, '$') =
3642: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRIDN_FLAG, '$') and
3643: nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$') =
3644: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$') and
3645: nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot) =
3646: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) and
3647: nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) =
3648: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot) and
3649: nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$') =

Line 3646: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) and

3642: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRIDN_FLAG, '$') and
3643: nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$') =
3644: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$') and
3645: nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot) =
3646: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) and
3647: nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) =
3648: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot) and
3649: nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$') =
3650: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$') and

Line 3647: nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) =

3643: nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$') =
3644: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$') and
3645: nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot) =
3646: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) and
3647: nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) =
3648: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot) and
3649: nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$') =
3650: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$') and
3651: /*

Line 3648: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot) and

3644: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$') and
3645: nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot) =
3646: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) and
3647: nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) =
3648: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot) and
3649: nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$') =
3650: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$') and
3651: /*
3652: Bug 1266433 : Do not compare the status codes.

Line 4078: l_datetrack_mode := hr_api.g_correction;

4074: --
4075: if l_curr_pen_rec.effective_start_date = l_curr_bpl_rec.effective_start_date or
4076: l_curr_pen_rec.effective_start_date = l_curr_bpl_rec.effective_end_date
4077: then
4078: l_datetrack_mode := hr_api.g_correction;
4079: else
4080: l_datetrack_mode := hr_api.g_update;
4081: end if;
4082: --

Line 4080: l_datetrack_mode := hr_api.g_update;

4076: l_curr_pen_rec.effective_start_date = l_curr_bpl_rec.effective_end_date
4077: then
4078: l_datetrack_mode := hr_api.g_correction;
4079: else
4080: l_datetrack_mode := hr_api.g_update;
4081: end if;
4082: --
4083: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
4084: p_bnft_prvdd_ldgr_id => l_curr_bpl_rec.bnft_prvdd_ldgr_id

Line 4342: l_datetrack_mode := hr_api.g_correction;

4338: ELSE
4339: IF l_curr_ppr.effective_start_date = l_old_ppr_rec.effective_start_date
4340: OR l_curr_ppr.effective_start_date = l_old_ppr_rec.effective_end_date
4341: THEN
4342: l_datetrack_mode := hr_api.g_correction;
4343: ELSE
4344: l_datetrack_mode := hr_api.g_update;
4345: END IF;
4346: hr_utility.set_location('Reinstate Provider by Updating in mode '||l_datetrack_mode,99099);

Line 4344: l_datetrack_mode := hr_api.g_update;

4340: OR l_curr_ppr.effective_start_date = l_old_ppr_rec.effective_end_date
4341: THEN
4342: l_datetrack_mode := hr_api.g_correction;
4343: ELSE
4344: l_datetrack_mode := hr_api.g_update;
4345: END IF;
4346: hr_utility.set_location('Reinstate Provider by Updating in mode '||l_datetrack_mode,99099);
4347: ben_prmry_care_prvdr_api.update_prmry_care_prvdr (p_validate => FALSE,
4348: p_prmry_care_prvdr_id => l_old_ppr_rec.prmry_care_prvdr_id,

Line 4475: l_datetrack_mode := hr_api.g_correction;

4471: ELSE
4472: IF l_curr_ppr.effective_start_date = l_old_ppr_rec.effective_start_date
4473: OR l_curr_ppr.effective_start_date = l_old_ppr_rec.effective_end_date
4474: THEN
4475: l_datetrack_mode := hr_api.g_correction;
4476: ELSE
4477: l_datetrack_mode := hr_api.g_update;
4478: END IF;
4479: hr_utility.set_location('Reinstate Provider by Updating in mode '||l_datetrack_mode,99099);

Line 4477: l_datetrack_mode := hr_api.g_update;

4473: OR l_curr_ppr.effective_start_date = l_old_ppr_rec.effective_end_date
4474: THEN
4475: l_datetrack_mode := hr_api.g_correction;
4476: ELSE
4477: l_datetrack_mode := hr_api.g_update;
4478: END IF;
4479: hr_utility.set_location('Reinstate Provider by Updating in mode '||l_datetrack_mode,99099);
4480: ben_prmry_care_prvdr_api.update_prmry_care_prvdr (p_validate => FALSE,
4481: p_prmry_care_prvdr_id => l_old_ppr_rec.prmry_care_prvdr_id,

Line 4570: and pea.effective_end_date = hr_api.g_eot --BUG 4502165 fix

4566: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4567: and pea.business_group_id = p_business_group_id
4568: and nvl(pea.pl_bnf_id, -1) = nvl(p_old_pl_bnf_id, -1)
4569: and nvl(pea.elig_cvrd_dpnt_id, -1) = nvl(p_old_elig_cvrd_dpnt_id, -1)
4570: and pea.effective_end_date = hr_api.g_eot --BUG 4502165 fix
4571: -- and pea.PL_BNF_ID is null
4572: -- and pea.ELIG_CVRD_DPNT_ID is null
4573: union
4574: select pea.OVRDN_THRU_DT, -- used as pea.CMPLTD_DT

Line 4625: if nvl(l_old_pea_rec.CMPLTD_DT, hr_api.g_eot) <> nvl(l_pea_rec.CMPLTD_DT, hr_api.g_eot)

4621: open c_pea(l_old_pea_rec.actn_typ_id);
4622: fetch c_pea into l_pea_rec;
4623: if c_pea%found then
4624: --
4625: if nvl(l_old_pea_rec.CMPLTD_DT, hr_api.g_eot) <> nvl(l_pea_rec.CMPLTD_DT, hr_api.g_eot)
4626: then
4627: --
4628: -- Use the correction mode.
4629: l_datetrack_mode := hr_api.g_correction;

Line 4629: l_datetrack_mode := hr_api.g_correction;

4625: if nvl(l_old_pea_rec.CMPLTD_DT, hr_api.g_eot) <> nvl(l_pea_rec.CMPLTD_DT, hr_api.g_eot)
4626: then
4627: --
4628: -- Use the correction mode.
4629: l_datetrack_mode := hr_api.g_correction;
4630: --
4631: -- update the action items.
4632: --
4633: -- If completion date is > p_effective_date .

Line 4741: if nvl(l_old_cpp_rec.DPNT_DSGN_CTFN_RECD_DT, hr_api.g_eot) <>

4737: open c_cpp(l_old_cpp_rec.actn_typ_id, l_old_cpp_rec.dpnt_dsgn_ctfn_typ_cd);
4738: fetch c_cpp into l_cpp_rec;
4739: if c_cpp%found then
4740: --
4741: if nvl(l_old_cpp_rec.DPNT_DSGN_CTFN_RECD_DT, hr_api.g_eot) <>
4742: nvl(l_cpp_rec.DPNT_DSGN_CTFN_RECD_DT, hr_api.g_eot)
4743: then
4744: --
4745: -- Use the correction mode.

Line 4742: nvl(l_cpp_rec.DPNT_DSGN_CTFN_RECD_DT, hr_api.g_eot)

4738: fetch c_cpp into l_cpp_rec;
4739: if c_cpp%found then
4740: --
4741: if nvl(l_old_cpp_rec.DPNT_DSGN_CTFN_RECD_DT, hr_api.g_eot) <>
4742: nvl(l_cpp_rec.DPNT_DSGN_CTFN_RECD_DT, hr_api.g_eot)
4743: then
4744: --
4745: -- Use the correction mode.
4746: -- update the dependent certification received.

Line 4748: l_datetrack_mode := hr_api.g_correction;

4744: --
4745: -- Use the correction mode.
4746: -- update the dependent certification received.
4747: --
4748: l_datetrack_mode := hr_api.g_correction;
4749: --
4750: if l_old_cpp_rec.DPNT_DSGN_CTFN_RECD_DT < p_effective_date then
4751: l_old_cpp_rec.DPNT_DSGN_CTFN_RECD_DT := p_effective_date;
4752: end if;

Line 4974: and (pdp_old.effective_end_date = hr_api.g_eot or

4970: select 'Y'
4971: from ben_elig_cvrd_dpnt_f pdp_old
4972: where pdp_old.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4973: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4974: and (pdp_old.effective_end_date = hr_api.g_eot or
4975: pdp_old.effective_end_date = (select max(effective_end_date)
4976: from ben_elig_cvrd_dpnt_f
4977: where elig_cvrd_dpnt_id = pdp_old.elig_cvrd_dpnt_id
4978: and prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id))

Line 4979: and (pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot)

4975: pdp_old.effective_end_date = (select max(effective_end_date)
4976: from ben_elig_cvrd_dpnt_f
4977: where elig_cvrd_dpnt_id = pdp_old.elig_cvrd_dpnt_id
4978: and prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id))
4979: and (pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot)
4980: /*Bug 12419118: Added below exists clause*/
4981: and exists
4982: (select '1' from ben_elig_cvrd_dpnt_f
4983: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id

Line 4985: and effective_end_date = hr_api.g_eot

4981: and exists
4982: (select '1' from ben_elig_cvrd_dpnt_f
4983: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4984: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4985: and effective_end_date = hr_api.g_eot
4986: and cvg_thru_dt = hr_api.g_eot
4987: and per_in_ler_id = p_bckdt_per_in_ler_id
4988: union
4989: select '1' from ben_le_clsn_n_rstr

Line 4986: and cvg_thru_dt = hr_api.g_eot

4982: (select '1' from ben_elig_cvrd_dpnt_f
4983: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4984: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4985: and effective_end_date = hr_api.g_eot
4986: and cvg_thru_dt = hr_api.g_eot
4987: and per_in_ler_id = p_bckdt_per_in_ler_id
4988: union
4989: select '1' from ben_le_clsn_n_rstr
4990: where BKUP_TBL_ID = p_elig_cvrd_dpnt_id

Line 4992: and effective_end_date = hr_api.g_eot

4988: union
4989: select '1' from ben_le_clsn_n_rstr
4990: where BKUP_TBL_ID = p_elig_cvrd_dpnt_id
4991: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4992: and effective_end_date = hr_api.g_eot
4993: and cvg_thru_dt = hr_api.g_eot
4994: and per_in_ler_id = p_bckdt_per_in_ler_id
4995: and bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
4996: )

Line 4993: and cvg_thru_dt = hr_api.g_eot

4989: select '1' from ben_le_clsn_n_rstr
4990: where BKUP_TBL_ID = p_elig_cvrd_dpnt_id
4991: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4992: and effective_end_date = hr_api.g_eot
4993: and cvg_thru_dt = hr_api.g_eot
4994: and per_in_ler_id = p_bckdt_per_in_ler_id
4995: and bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
4996: )
4997: union

Line 5003: and ((pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot) and

4999: from ben_le_clsn_n_rstr pdp_old
5000: where pdp_old.bkup_tbl_id = p_elig_cvrd_dpnt_id
5001: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
5002: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5003: and ((pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot) and
5004: pdp_old.effective_end_date = hr_api.g_eot
5005: )
5006: and pdp_old.per_in_ler_id = p_bckdt_per_in_ler_id; --Bug 12419118
5007: --

Line 5004: pdp_old.effective_end_date = hr_api.g_eot

5000: where pdp_old.bkup_tbl_id = p_elig_cvrd_dpnt_id
5001: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
5002: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5003: and ((pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot) and
5004: pdp_old.effective_end_date = hr_api.g_eot
5005: )
5006: and pdp_old.per_in_ler_id = p_bckdt_per_in_ler_id; --Bug 12419118
5007: --
5008: l_chk_valid_pdp char;

Line 5016: and nvl(pdp.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

5012: from ben_elig_cvrd_dpnt_f pdp ,
5013: ben_per_in_ler pil
5014: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5015: and pdp.cvg_strt_dt is not null
5016: and nvl(pdp.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
5017: and pdp.business_group_id = p_business_group_id
5018: and pdp.dpnt_person_id = cp_dpnt_person_id
5019: and p_effective_date between pdp.effective_start_date
5020: and pdp.effective_end_date

Line 5126: p_cvg_thru_dt => hr_api.g_eot,

5122: p_effective_date => p_effective_date, -- Bug : 5124 As per Jeana, data
5123: -- should be reinstated with system date
5124: -- rather than p_effective_date,
5125: p_cvg_strt_dt => l_cvg_strt_dt,
5126: p_cvg_thru_dt => hr_api.g_eot,
5127: p_datetrack_mode => hr_api.g_insert,
5128: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
5129: p_effective_start_date => l_effective_start_date,
5130: p_effective_end_date => l_effective_end_date,

Line 5127: p_datetrack_mode => hr_api.g_insert,

5123: -- should be reinstated with system date
5124: -- rather than p_effective_date,
5125: p_cvg_strt_dt => l_cvg_strt_dt,
5126: p_cvg_thru_dt => hr_api.g_eot,
5127: p_datetrack_mode => hr_api.g_insert,
5128: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
5129: p_effective_start_date => l_effective_start_date,
5130: p_effective_end_date => l_effective_end_date,
5131: p_object_version_number => l_pdp_object_version_number,

Line 5137: elsif bckdt_pen_dpnts_rec.cvg_thru_dt <> hr_api.g_eot then

5133: end if;
5134: close c_epe_dpnt;
5135: --
5136: --
5137: elsif bckdt_pen_dpnts_rec.cvg_thru_dt <> hr_api.g_eot then
5138: hr_utility.set_location('End-dated row found - vvp', 7777);
5139:
5140: --5692797 Check whether backed out PDP record exists for the dependent in same enrollment
5141: --with valid coverage. If yes, no need to reinstate this end-dated record.

Line 5161: p_datetrack_mode => hr_api.g_update,

5157: -- should be reinstated with system date
5158: -- rather than p_effective_date,
5159: p_cvg_strt_dt => bckdt_pen_dpnts_rec.cvg_strt_dt,
5160: p_cvg_thru_dt => bckdt_pen_dpnts_rec.cvg_thru_dt,
5161: p_datetrack_mode => hr_api.g_update,
5162: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
5163: p_effective_start_date => l_effective_start_date,
5164: p_effective_end_date => l_effective_end_date,
5165: p_object_version_number => l_pdp_object_version_number,

Line 5304: if nvl(l_old_pbc_rec.BNF_CTFN_RECD_DT, hr_api.g_eot) <>

5300: open c_pbc(l_old_pbc_rec.actn_typ_id, l_old_pbc_rec.BNF_CTFN_TYP_CD);
5301: fetch c_pbc into l_pbc_rec;
5302: if c_pbc%found then
5303: --
5304: if nvl(l_old_pbc_rec.BNF_CTFN_RECD_DT, hr_api.g_eot) <>
5305: nvl(l_pbc_rec.BNF_CTFN_RECD_DT, hr_api.g_eot)
5306: then
5307: --
5308: -- Use the correction mode.

Line 5305: nvl(l_pbc_rec.BNF_CTFN_RECD_DT, hr_api.g_eot)

5301: fetch c_pbc into l_pbc_rec;
5302: if c_pbc%found then
5303: --
5304: if nvl(l_old_pbc_rec.BNF_CTFN_RECD_DT, hr_api.g_eot) <>
5305: nvl(l_pbc_rec.BNF_CTFN_RECD_DT, hr_api.g_eot)
5306: then
5307: --
5308: -- Use the correction mode.
5309: -- update the dependent certification received.

Line 5311: l_datetrack_mode := hr_api.g_correction;

5307: --
5308: -- Use the correction mode.
5309: -- update the dependent certification received.
5310: --
5311: l_datetrack_mode := hr_api.g_correction;
5312: --
5313: if l_old_pbc_rec.BNF_CTFN_RECD_DT < p_effective_date then
5314: l_old_pbc_rec.BNF_CTFN_RECD_DT := p_effective_date;
5315: end if;

Line 5664: if(l_old_bnf_rec.effective_end_date <> hr_api.g_eot and l_old_bnf_rec.ftr_rec = 'N') then

5660: end if;
5661:
5662: /* Bug 12791126: While reinstating the plan beneficiary, if the beneficiary record is end dated,
5663: then after creating the beneficiary record, record should be end dated. Added 'if' condition */
5664: if(l_old_bnf_rec.effective_end_date <> hr_api.g_eot and l_old_bnf_rec.ftr_rec = 'N') then
5665: if(l_old_bnf_rec.effective_start_date = l_bnf_effective_start_date ) then
5666: l_del_date :=l_old_bnf_rec.effective_end_date;
5667: else
5668: l_del_date :=l_bnf_effective_start_date;

Line 5679: ,p_datetrack_mode => hr_api.g_delete

5675: ,p_effective_end_date => l_bnf_effective_end_date
5676: ,p_object_version_number => l_bnf_object_version_number
5677: ,p_business_group_id => p_business_group_id
5678: ,p_effective_date => l_del_date+1
5679: ,p_datetrack_mode => hr_api.g_delete
5680: ,p_multi_row_actn => FALSE
5681: );
5682: end if;
5683: --

Line 5695: l_datetrack_mode := hr_api.g_update;

5691: /*Bug 12964358: Reinstate the plan beneficiary history on reprocessing the LE.If elections are reinstated
5692: as of sysdate, then update mode will be 'update' else 'correction' . Flag l_upd_mode is set based upon the date on which
5693: plan beneficiary is reinstated. Also end dated beneficiary should be reinstated correctly on reprocessing the LE. Added below 'if' */
5694: if(l_upd_mode) then
5695: l_datetrack_mode := hr_api.g_update;
5696: l_upd_date := l_old_bnf_rec.effective_start_date;
5697: open c_bnf_rec(l_bnf_rec.pl_bnf_id,l_upd_date);
5698: fetch c_bnf_rec into l_bnf_rec_upd;
5699: if(c_bnf_rec%notfound) then

Line 5707: l_datetrack_mode := hr_api.g_correction;

5703: end if;
5704: close c_bnf_rec;
5705: /*End of Bug 12964358 */
5706: else
5707: l_datetrack_mode := hr_api.g_correction;
5708: l_upd_date := p_effective_date;
5709: l_upd_obj_version_number := l_bnf_rec.object_version_number;
5710: end if;
5711: else

Line 5714: l_datetrack_mode := hr_api.g_update;

5710: end if;
5711: else
5712: l_upd_date := p_effective_date;--Bug 16059081
5713: l_upd_obj_version_number := l_bnf_rec.object_version_number;
5714: l_datetrack_mode := hr_api.g_update;
5715: end if;
5716: --
5717: hr_utility.set_location('update call ' ,10);
5718: ben_plan_beneficiary_api.update_PLAN_BENEFICIARY

Line 5780: if(l_old_bnf_rec.effective_end_date <> hr_api.g_eot and l_old_bnf_rec.ftr_rec = 'N') then

5776: --
5777: l_pl_bnf_id := l_bnf_rec.pl_bnf_id;
5778:
5779: /*Bug 12964358: Beneficiary that are end dated should be end dated on reprocessing the LE*/
5780: if(l_old_bnf_rec.effective_end_date <> hr_api.g_eot and l_old_bnf_rec.ftr_rec = 'N') then
5781: if(l_old_bnf_rec.effective_start_date = l_bnf_effective_start_date ) then
5782: l_del_date :=l_old_bnf_rec.effective_end_date;
5783: else
5784: l_del_date :=l_bnf_effective_start_date;

Line 5796: ,p_datetrack_mode => hr_api.g_delete

5792: ,p_effective_end_date => l_bnf_effective_end_date
5793: ,p_object_version_number => l_upd_obj_version_number
5794: ,p_business_group_id => p_business_group_id
5795: ,p_effective_date => l_del_date+1
5796: ,p_datetrack_mode => hr_api.g_delete
5797: ,p_multi_row_actn => FALSE
5798: );
5799: end if;
5800: --

Line 5937: if nvl(l_old_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) <>

5933: l_old_pcs_rec.ACTN_TYP_ID);
5934: fetch c_pcs into l_pcs_rec;
5935: if c_pcs%found then
5936: --
5937: if nvl(l_old_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) <>
5938: nvl(l_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) or
5939: nvl(l_old_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot) <>
5940: nvl(l_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot)
5941: then

Line 5938: nvl(l_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) or

5934: fetch c_pcs into l_pcs_rec;
5935: if c_pcs%found then
5936: --
5937: if nvl(l_old_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) <>
5938: nvl(l_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) or
5939: nvl(l_old_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot) <>
5940: nvl(l_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot)
5941: then
5942: --

Line 5939: nvl(l_old_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot) <>

5935: if c_pcs%found then
5936: --
5937: if nvl(l_old_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) <>
5938: nvl(l_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) or
5939: nvl(l_old_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot) <>
5940: nvl(l_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot)
5941: then
5942: --
5943: -- Use the correction mode.

Line 5940: nvl(l_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot)

5936: --
5937: if nvl(l_old_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) <>
5938: nvl(l_pcs_rec.ENRT_CTFN_RECD_DT, hr_api.g_eot) or
5939: nvl(l_old_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot) <>
5940: nvl(l_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot)
5941: then
5942: --
5943: -- Use the correction mode.
5944: l_datetrack_mode := hr_api.g_correction;

Line 5944: l_datetrack_mode := hr_api.g_correction;

5940: nvl(l_pcs_rec.ENRT_CTFN_DND_DT, hr_api.g_eot)
5941: then
5942: --
5943: -- Use the correction mode.
5944: l_datetrack_mode := hr_api.g_correction;
5945: --
5946: -- update the action items.
5947: --
5948: -- If completion date is > p_effective_date .

Line 6105: and (pen.effective_end_date = hr_api.g_eot or

6101: and pil.person_id = p_person_id
6102: and pil.business_group_id = p_business_group_id
6103: and pil.per_in_ler_id = pen.per_in_ler_id
6104: /*Pick up both end-dated and non-end-dated results*/
6105: and (pen.effective_end_date = hr_api.g_eot or
6106: pen.effective_end_date = (select max(effective_end_date)
6107: from ben_prtt_enrt_rslt_f
6108: where prtt_enrt_rslt_id =
6109: pen.prtt_enrt_rslt_id))

Line 6111: pen.enrt_cvg_thru_dt = hr_api.g_eot

6107: from ben_prtt_enrt_rslt_f
6108: where prtt_enrt_rslt_id =
6109: pen.prtt_enrt_rslt_id))
6110: and (pen.enrt_cvg_thru_dt is null or
6111: pen.enrt_cvg_thru_dt = hr_api.g_eot
6112: )
6113: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6114: and pen.prtt_enrt_rslt_id not in (
6115: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 6123: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

6119: and pil_inner.person_id = p_person_id
6120: and pil_inner.business_group_id = p_business_group_id
6121: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
6122: and (pen_inner.enrt_cvg_thru_dt is null or
6123: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
6124: )
6125: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6126: union
6127: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 6136: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

6132: and pil_inner.business_group_id = p_business_group_id
6133: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
6134: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
6135: and (pen_inner.enrt_cvg_thru_dt is null or
6136: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
6137: )
6138: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6139: )
6140: union

Line 6227: pen.enrt_cvg_thru_dt = hr_api.g_eot) and

6223: and pil.business_group_id = p_business_group_id
6224: AND pil.per_in_ler_id = pen.per_in_ler_id
6225: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
6226: and ((pen.enrt_cvg_thru_dt is null or
6227: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
6228: --bug#2604375 - added to control updated result rows for the same per_in_ler
6229: pen.effective_end_date = hr_api.g_eot
6230: )
6231: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 6229: pen.effective_end_date = hr_api.g_eot

6225: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
6226: and ((pen.enrt_cvg_thru_dt is null or
6227: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
6228: --bug#2604375 - added to control updated result rows for the same per_in_ler
6229: pen.effective_end_date = hr_api.g_eot
6230: )
6231: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6232: and pen.bkup_tbl_id not in (
6233: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 6241: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

6237: and pil_inner.person_id = p_person_id
6238: and pil_inner.business_group_id = p_business_group_id
6239: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
6240: and (pen_inner.enrt_cvg_thru_dt is null or
6241: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
6242: )
6243: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6244: union
6245: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 6254: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

6250: and pil_inner.business_group_id = p_business_group_id
6251: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
6252: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
6253: and (pen_inner.enrt_cvg_thru_dt is null or
6254: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
6255: )
6256: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6257: )
6258: order by 1, 11 desc; -- pen.effective_end_date; -- Low to High

Line 6414: and pen.effective_end_date = hr_api.g_eot

6410: and pen.per_in_ler_id = pil.per_in_ler_id
6411: and pen.business_group_id = p_business_group_id
6412: and pil.business_group_id = p_business_group_id
6413: and pen.prtt_enrt_rslt_stat_cd is null
6414: and pen.effective_end_date = hr_api.g_eot
6415: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6416: and (pen.enrt_cvg_thru_dt is null or
6417: pen.enrt_cvg_thru_dt = hr_api.g_eot
6418: );

Line 6417: pen.enrt_cvg_thru_dt = hr_api.g_eot

6413: and pen.prtt_enrt_rslt_stat_cd is null
6414: and pen.effective_end_date = hr_api.g_eot
6415: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
6416: and (pen.enrt_cvg_thru_dt is null or
6417: pen.enrt_cvg_thru_dt = hr_api.g_eot
6418: );
6419: type t_bckt_csd_pen_table is table of c_bckt_csd_pen%rowtype index by binary_integer;
6420: l_bckt_csd_pil_enrt_table t_bckt_csd_pen_table;
6421: l_bckt_csd_pen_esd date;

Line 6434: and prv1.rt_end_dt <> hr_api.g_eot

6430: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
6431: and prv2.prtt_enrt_rslt_id = v_new_pen_id
6432: and prv1.acty_base_rt_id = prv2.acty_base_rt_id
6433: and prv1.rt_ovridn_flag = 'Y'
6434: and prv1.rt_end_dt <> hr_api.g_eot
6435: and prv1.rt_ovridn_thru_dt >= prv2.rt_strt_dt
6436: -- and prv1.prtt_rt_val_stat_cd is null
6437: and prv2.prtt_rt_val_stat_cd is null
6438: and prv2.per_in_ler_id = p_per_in_ler_id ;

Line 6461: and effective_end_date = hr_api.g_eot;

6457: cursor c_ovn(v_prtt_enrt_rslt_id number) is
6458: select object_version_number
6459: from ben_prtt_enrt_rslt_f
6460: where prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
6461: and effective_end_date = hr_api.g_eot;
6462: --
6463: cursor c_prv_ovn (v_prtt_rt_val_id number) is
6464: select prv.*
6465: ,abr.input_value_id

Line 6585: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),

6581: close c_epe_pen;
6582: hr_utility.set_location('After epe fetch ' || l_proc,30);
6583: --
6584: g_sys_date := greatest(trunc(l_epe_pen_rec.enrt_perd_strt_dt),
6585: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),
6586: l_bckdt_pen_rec.effective_start_date);
6587: /*
6588: g_sys_date := greatest(trunc(sysdate),
6589: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,

Line 6589: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,

6585: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),
6586: l_bckdt_pen_rec.effective_start_date);
6587: /*
6588: g_sys_date := greatest(trunc(sysdate),
6589: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,
6590: l_bckdt_pen_rec.effective_start_date);
6591: */
6592: --
6593: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));

Line 6593: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));

6589: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,
6590: l_bckdt_pen_rec.effective_start_date);
6591: */
6592: --
6593: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
6594: --
6595: --
6596: hr_utility.set_location('Date used to reinstate the enrollment = ' || g_sys_date, 333);
6597: if g_sys_date <= l_bckdt_pen_rec.effective_end_date

Line 6786: p_datetrack_mode => hr_api.g_insert, --

6782: p_ann_rt_val9 => l_rt_table(9).ann_rt_val,
6783: p_enrt_rt_id10 => l_rt_table(10).enrt_rt_id,
6784: p_rt_val10 => l_rt_table(10).dflt_val,
6785: p_ann_rt_val10 => l_rt_table(10).ann_rt_val,
6786: p_datetrack_mode => hr_api.g_insert, --
6787: p_suspend_flag => l_suspend_flag,
6788: p_called_from_sspnd => 'N',
6789: p_prtt_enrt_interim_id => l_prtt_enrt_interim_id,
6790: p_prtt_rt_val_id1 => l_prtt_rt_val_id1,

Line 7333: ,p_datetrack_mode => hr_api.g_correction

7329: ,p_enrt_cvg_thru_dt => l_enrt_table(i).bckdt_enrt_cvg_thru_dt
7330: ,p_enrt_ovridn_flag => 'Y'
7331: ,p_object_version_number => l_ovn
7332: ,p_effective_date => l_enrt_table(i).g_sys_date
7333: ,p_datetrack_mode => hr_api.g_correction
7334: ,p_multi_row_validate => FALSE);
7335: --
7336: end if;
7337: --

Line 7387: ,p_datetrack_mode => hr_api.g_correction

7383: ,p_cvg_thru_dt => l_dpnt_rec.cvg_thru_dt
7384: ,p_ovrdn_flag => l_dpnt_rec.ovrdn_flag
7385: ,p_ovrdn_thru_dt => l_dpnt_rec.ovrdn_thru_dt
7386: ,p_object_version_number => l_dpnt_rec.new_pdp_ovn
7387: ,p_datetrack_mode => hr_api.g_correction
7388: ,p_effective_date => l_enrt_table(i).g_sys_date);
7389: --
7390: end loop;
7391: --

Line 7697: nvl(p_bckdt_epe_row.ENRT_CVG_STRT_DT, hr_api.g_eot) = nvl(p_current_epe_row.ENRT_CVG_STRT_DT, hr_api.g_eot) and

7693: nvl(p_bckdt_epe_row.ENRT_CVG_STRT_DT_RL, -1) = nvl(p_current_epe_row.ENRT_CVG_STRT_DT_RL, -1) and
7694: nvl(p_bckdt_epe_row.DPNT_CVG_STRT_DT_CD, '$') = nvl(p_current_epe_row.DPNT_CVG_STRT_DT_CD, '$') and
7695: nvl(p_bckdt_epe_row.LER_CHG_DPNT_CVG_CD, '$') = nvl(p_current_epe_row.LER_CHG_DPNT_CVG_CD, '$') and
7696: nvl(p_bckdt_epe_row.DPNT_CVG_STRT_DT_RL, -1) = nvl(p_current_epe_row.DPNT_CVG_STRT_DT_RL, -1) and
7697: nvl(p_bckdt_epe_row.ENRT_CVG_STRT_DT, hr_api.g_eot) = nvl(p_current_epe_row.ENRT_CVG_STRT_DT, hr_api.g_eot) and
7698: nvl(p_bckdt_epe_row.ERLST_DEENRT_DT, hr_api.g_eot) = nvl(p_current_epe_row.ERLST_DEENRT_DT, hr_api.g_eot)
7699: then
7700: --
7701: -- Now check elig_dpnt rows for any differences.

Line 7698: nvl(p_bckdt_epe_row.ERLST_DEENRT_DT, hr_api.g_eot) = nvl(p_current_epe_row.ERLST_DEENRT_DT, hr_api.g_eot)

7694: nvl(p_bckdt_epe_row.DPNT_CVG_STRT_DT_CD, '$') = nvl(p_current_epe_row.DPNT_CVG_STRT_DT_CD, '$') and
7695: nvl(p_bckdt_epe_row.LER_CHG_DPNT_CVG_CD, '$') = nvl(p_current_epe_row.LER_CHG_DPNT_CVG_CD, '$') and
7696: nvl(p_bckdt_epe_row.DPNT_CVG_STRT_DT_RL, -1) = nvl(p_current_epe_row.DPNT_CVG_STRT_DT_RL, -1) and
7697: nvl(p_bckdt_epe_row.ENRT_CVG_STRT_DT, hr_api.g_eot) = nvl(p_current_epe_row.ENRT_CVG_STRT_DT, hr_api.g_eot) and
7698: nvl(p_bckdt_epe_row.ERLST_DEENRT_DT, hr_api.g_eot) = nvl(p_current_epe_row.ERLST_DEENRT_DT, hr_api.g_eot)
7699: then
7700: --
7701: -- Now check elig_dpnt rows for any differences.
7702: --

Line 8149: and pen.effective_end_date = hr_api.g_eot

8145: and pen.per_in_ler_id = pil.per_in_ler_id
8146: and pen.business_group_id = p_business_group_id
8147: and pil.business_group_id = p_business_group_id
8148: and pen.prtt_enrt_rslt_stat_cd is null
8149: and pen.effective_end_date = hr_api.g_eot
8150: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
8151: and (pen.enrt_cvg_thru_dt is null or
8152: pen.enrt_cvg_thru_dt = hr_api.g_eot
8153: );

Line 8152: pen.enrt_cvg_thru_dt = hr_api.g_eot

8148: and pen.prtt_enrt_rslt_stat_cd is null
8149: and pen.effective_end_date = hr_api.g_eot
8150: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
8151: and (pen.enrt_cvg_thru_dt is null or
8152: pen.enrt_cvg_thru_dt = hr_api.g_eot
8153: );
8154: type t_bckt_csd_pen_table is table of c_bckt_csd_pen%rowtype index by binary_integer;
8155: l_bckt_csd_pil_enrt_table t_bckt_csd_pen_table;
8156: l_bckt_csd_pen_esd date;

Line 8285: and prevpen.enrt_cvg_thru_dt = hr_api.g_eot

8281: and newepe.pl_id = prevepe.pl_id
8282: and nvl(prevepe.pgm_id,-1) = nvl(newepe.pgm_id,-1)
8283: and nvl(prevepe.oipl_id,-1) = nvl(newepe.oipl_id,-1)
8284: and prevpen.prtt_enrt_rslt_id = prevepe.prtt_enrt_rslt_id
8285: and prevpen.enrt_cvg_thru_dt = hr_api.g_eot
8286: --and prevpen.effective_end_date = hr_api.g_eot
8287: and prevpen.prtt_enrt_rslt_stat_cd is null;
8288:
8289: l_prev_pil_id number;

Line 8286: --and prevpen.effective_end_date = hr_api.g_eot

8282: and nvl(prevepe.pgm_id,-1) = nvl(newepe.pgm_id,-1)
8283: and nvl(prevepe.oipl_id,-1) = nvl(newepe.oipl_id,-1)
8284: and prevpen.prtt_enrt_rslt_id = prevepe.prtt_enrt_rslt_id
8285: and prevpen.enrt_cvg_thru_dt = hr_api.g_eot
8286: --and prevpen.effective_end_date = hr_api.g_eot
8287: and prevpen.prtt_enrt_rslt_stat_cd is null;
8288:
8289: l_prev_pil_id number;
8290: l_prev_pil_sus_epe_id number;

Line 8409: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),

8405: --
8406: hr_utility.set_location('After epe fetch ' || l_proc,30);
8407: --
8408: g_sys_date := greatest(trunc(p_enrt_perd_strt_dt),
8409: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),
8410: l_bckdt_pen_rec.effective_start_date);
8411: --
8412: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
8413: --

Line 8412: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));

8408: g_sys_date := greatest(trunc(p_enrt_perd_strt_dt),
8409: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),
8410: l_bckdt_pen_rec.effective_start_date);
8411: --
8412: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
8413: --
8414: --
8415: hr_utility.set_location('Date used to reinstate the enrollment = ' || g_sys_date, 333);
8416: --

Line 8735: p_datetrack_mode => hr_api.g_insert,

8731: p_ann_rt_val9 => l_rt_table(9).ann_rt_val,
8732: p_enrt_rt_id10 => l_rt_table(10).enrt_rt_id,
8733: p_rt_val10 => l_rt_table(10).dflt_val,
8734: p_ann_rt_val10 => l_rt_table(10).ann_rt_val,
8735: p_datetrack_mode => hr_api.g_insert,
8736: p_suspend_flag => l_suspend_flag,
8737: p_called_from_sspnd => 'N',
8738: p_prtt_enrt_interim_id => l_prtt_enrt_interim_id,
8739: p_prtt_rt_val_id1 => l_prtt_rt_val_id1,

Line 9105: and pen_curr.effective_end_date = hr_api.g_eot

9101: and pen_curr.RPLCS_SSPNDD_RSLT_ID is not NULL
9102: and pen_int.prtt_enrt_rslt_stat_cd is NULL
9103: and pen_int.per_in_ler_id = p_per_in_ler_id
9104: and pen_curr.RPLCS_SSPNDD_RSLT_ID = pen_int.prtt_enrt_rslt_id
9105: and pen_curr.effective_end_date = hr_api.g_eot
9106: and pen_int.effective_end_date = hr_api.g_eot
9107: and exists
9108: (select '1' from ben_prtt_enrt_rslt_f pen_bckdt,
9109: ben_prtt_enrt_rslt_f pen_int_bckdt

Line 9106: and pen_int.effective_end_date = hr_api.g_eot

9102: and pen_int.prtt_enrt_rslt_stat_cd is NULL
9103: and pen_int.per_in_ler_id = p_per_in_ler_id
9104: and pen_curr.RPLCS_SSPNDD_RSLT_ID = pen_int.prtt_enrt_rslt_id
9105: and pen_curr.effective_end_date = hr_api.g_eot
9106: and pen_int.effective_end_date = hr_api.g_eot
9107: and exists
9108: (select '1' from ben_prtt_enrt_rslt_f pen_bckdt,
9109: ben_prtt_enrt_rslt_f pen_int_bckdt
9110: where pen_bckdt.prtt_enrt_rslt_id = c_bckdt_prtt_enrt_rslt_id

Line 9453: and nvl(prv1.rt_ovridn_thru_dt,hr_api.g_eot) >= prv2.rt_strt_dt -- Bug 4384574

9449: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
9450: and prv2.prtt_enrt_rslt_id = v_new_pen_id
9451: and prv1.acty_base_rt_id = prv2.acty_base_rt_id
9452: and prv1.rt_ovridn_flag = 'Y'
9453: and nvl(prv1.rt_ovridn_thru_dt,hr_api.g_eot) >= prv2.rt_strt_dt -- Bug 4384574
9454: and prv1.prtt_rt_val_stat_cd = 'BCKDT'
9455: and prv2.prtt_rt_val_stat_cd is null
9456: and prv2.per_in_ler_id = p_per_in_ler_id
9457: and prv1.per_in_ler_id = p_bckdt_per_in_ler_id ;

Line 9480: and effective_end_date = hr_api.g_eot;

9476: cursor c_ovn(v_prtt_enrt_rslt_id number) is
9477: select object_version_number
9478: from ben_prtt_enrt_rslt_f
9479: where prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
9480: and effective_end_date = hr_api.g_eot;
9481: --
9482: cursor c_epe_enrt_rt(v_elig_per_elctbl_chc_id number,
9483: v_acty_base_rt_id number) is
9484: select ecr.elig_per_elctbl_chc_id

Line 9664: ,p_datetrack_mode => hr_api.g_correction

9660: ,p_enrt_ovrid_rsn_cd => p_enrt_table(i).enrt_ovrid_rsn_cd
9661: ,p_enrt_ovridn_flag => 'Y'
9662: ,p_object_version_number => l_ovn
9663: ,p_effective_date => p_enrt_table(i).g_sys_date
9664: ,p_datetrack_mode => hr_api.g_correction
9665: ,p_multi_row_validate => FALSE);
9666: --
9667: end if;
9668: --

Line 9826: ,p_datetrack_mode => hr_api.g_correction

9822: ,p_cvg_thru_dt => l_dpnt_rec.cvg_thru_dt
9823: ,p_ovrdn_flag => l_dpnt_rec.ovrdn_flag
9824: ,p_ovrdn_thru_dt => l_dpnt_rec.ovrdn_thru_dt
9825: ,p_object_version_number => l_dpnt_rec.new_pdp_ovn
9826: ,p_datetrack_mode => hr_api.g_correction
9827: ,p_effective_date => p_enrt_table(i).g_sys_date);
9828: --
9829: end loop;
9830: --

Line 9975: and pen.enrt_cvg_thru_dt = hr_api.g_eot

9971: and nvl(pen.pgm_id,-1) = nvl(c_pgm_id,-1)
9972: and pen.pl_typ_id = c_pl_typ_id
9973: and pen.enrt_mthd_cd = 'E'
9974: and pen.prtt_enrt_rslt_stat_cd is null
9975: and pen.enrt_cvg_thru_dt = hr_api.g_eot
9976: and pen.enrt_cvg_thru_dt >= pen.enrt_cvg_strt_dt ;
9977:
9978: cursor c_chk_exp_inter_pil is
9979: select 'Y'

Line 9985: and pen.enrt_cvg_thru_dt = hr_api.g_eot

9981: ben_ler_f ler
9982: where pen.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
9983: and pen.person_id = p_person_id
9984: and pen.prtt_enrt_rslt_stat_cd is null
9985: and pen.enrt_cvg_thru_dt = hr_api.g_eot
9986: and pen.effective_end_date = hr_api.g_eot
9987: and pen.ler_id = ler.ler_id
9988: and p_effective_date between ler.effective_start_date and
9989: ler.effective_end_date

Line 9986: and pen.effective_end_date = hr_api.g_eot

9982: where pen.per_in_ler_id not in (p_per_in_ler_id,p_bckdt_per_in_ler_id)
9983: and pen.person_id = p_person_id
9984: and pen.prtt_enrt_rslt_stat_cd is null
9985: and pen.enrt_cvg_thru_dt = hr_api.g_eot
9986: and pen.effective_end_date = hr_api.g_eot
9987: and pen.ler_id = ler.ler_id
9988: and p_effective_date between ler.effective_start_date and
9989: ler.effective_end_date
9990: and ler.typ_cd not in ('IREC','SCHEDDU', 'COMP', 'GSP', 'ABS')

Line 10134: AND ( (pen_inner.enrt_cvg_thru_dt IS NOT NULL and pen_inner.enrt_cvg_thru_dt <> hr_api.g_eot )

10130: AND pil_inner.person_id = p_person_id
10131: AND pil_inner.business_group_id = p_business_group_id
10132: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
10133: AND pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
10134: AND ( (pen_inner.enrt_cvg_thru_dt IS NOT NULL and pen_inner.enrt_cvg_thru_dt <> hr_api.g_eot )
10135: and pen_inner.effective_end_date = hr_api.g_eot
10136: )
10137: AND pen_inner.comp_lvl_cd NOT IN('PLANFC','PLANIMP');
10138: --

Line 10135: and pen_inner.effective_end_date = hr_api.g_eot

10131: AND pil_inner.business_group_id = p_business_group_id
10132: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
10133: AND pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
10134: AND ( (pen_inner.enrt_cvg_thru_dt IS NOT NULL and pen_inner.enrt_cvg_thru_dt <> hr_api.g_eot )
10135: and pen_inner.effective_end_date = hr_api.g_eot
10136: )
10137: AND pen_inner.comp_lvl_cd NOT IN('PLANFC','PLANIMP');
10138: --
10139: l_en_dtd_pen_bckdt_pil c_en_dtd_pen_bckdt_pil%ROWTYPE;

Line 11538: pen.enrt_cvg_thru_dt = hr_api.g_eot) and

11534: and pil.business_group_id = p_business_group_id
11535: AND pil.per_in_ler_id = pen.per_in_ler_id
11536: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
11537: and ((pen.enrt_cvg_thru_dt is null or
11538: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
11539: --bug#2604375 - added to control updated result rows for the same per_in_ler
11540: pen.effective_end_date = hr_api.g_eot
11541: )
11542: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')

Line 11540: pen.effective_end_date = hr_api.g_eot

11536: and pen.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
11537: and ((pen.enrt_cvg_thru_dt is null or
11538: pen.enrt_cvg_thru_dt = hr_api.g_eot) and
11539: --bug#2604375 - added to control updated result rows for the same per_in_ler
11540: pen.effective_end_date = hr_api.g_eot
11541: )
11542: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11543: and pen.bkup_tbl_id not in (
11544: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 11552: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

11548: and pil_inner.person_id = p_person_id
11549: and pil_inner.business_group_id = p_business_group_id
11550: and pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
11551: and (pen_inner.enrt_cvg_thru_dt is null or
11552: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
11553: )
11554: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11555: union
11556: select nvl(pen_inner.RPLCS_SSPNDD_RSLT_ID, -1)

Line 11565: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot

11561: and pil_inner.business_group_id = p_business_group_id
11562: AND pil_inner.per_in_ler_id = pen_inner.per_in_ler_id
11563: and pen_inner.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
11564: and (pen_inner.enrt_cvg_thru_dt is null or
11565: pen_inner.enrt_cvg_thru_dt = hr_api.g_eot
11566: )
11567: and pen_inner.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11568: )
11569: order by 1; -- pen.effective_end_date; -- Low to High

Line 11733: and pen.effective_end_date = hr_api.g_eot

11729: and pen.per_in_ler_id = pil.per_in_ler_id
11730: and pen.business_group_id = p_business_group_id
11731: and pil.business_group_id = p_business_group_id
11732: and pen.prtt_enrt_rslt_stat_cd is null
11733: and pen.effective_end_date = hr_api.g_eot
11734: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11735: and (pen.enrt_cvg_thru_dt is null or
11736: pen.enrt_cvg_thru_dt = hr_api.g_eot
11737: );

Line 11736: pen.enrt_cvg_thru_dt = hr_api.g_eot

11732: and pen.prtt_enrt_rslt_stat_cd is null
11733: and pen.effective_end_date = hr_api.g_eot
11734: and pen.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11735: and (pen.enrt_cvg_thru_dt is null or
11736: pen.enrt_cvg_thru_dt = hr_api.g_eot
11737: );
11738: type t_bckt_csd_pen_table is table of c_bckt_csd_pen%rowtype index by binary_integer;
11739: l_bckt_csd_pil_enrt_table t_bckt_csd_pen_table;
11740: l_bckt_csd_pen_esd date;

Line 11753: and prv1.rt_end_dt <> hr_api.g_eot

11749: where prv1.prtt_enrt_rslt_id = v_bckdt_pen_id
11750: and prv2.prtt_enrt_rslt_id = v_new_pen_id
11751: and prv1.acty_base_rt_id = prv2.acty_base_rt_id
11752: and prv1.rt_ovridn_flag = 'Y'
11753: and prv1.rt_end_dt <> hr_api.g_eot
11754: and prv1.rt_ovridn_thru_dt >= prv2.rt_strt_dt
11755: -- and prv1.prtt_rt_val_stat_cd is null
11756: and prv2.prtt_rt_val_stat_cd is null
11757: and prv2.per_in_ler_id = p_per_in_ler_id ;

Line 11780: and effective_end_date = hr_api.g_eot;

11776: cursor c_ovn(v_prtt_enrt_rslt_id number) is
11777: select object_version_number
11778: from ben_prtt_enrt_rslt_f
11779: where prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
11780: and effective_end_date = hr_api.g_eot;
11781: --
11782: cursor c_prv_ovn (v_prtt_rt_val_id number) is
11783: select prv.*
11784: ,abr.input_value_id

Line 11805: and pen.enrt_cvg_thru_dt = hr_api.g_eot

11801: and pen.pl_id = p_pl_id
11802: and nvl(pen.oipl_id,-9999) = nvl(p_oipl_id,-9999) --5287988
11803: and pen.per_in_ler_id = p_per_in_ler_id -- 8626297
11804: and pen.prtt_enrt_rslt_stat_cd is null
11805: and pen.enrt_cvg_thru_dt = hr_api.g_eot
11806: and pen.effective_end_date = hr_api.g_eot;
11807:
11808: /* Bug 8863079: Added cursor c_get_epe_id to determine the interim epe record */
11809: cursor c_get_epe_id(c_prtt_enrt_rslt_id number,c_per_in_ler_id number) is

Line 11806: and pen.effective_end_date = hr_api.g_eot;

11802: and nvl(pen.oipl_id,-9999) = nvl(p_oipl_id,-9999) --5287988
11803: and pen.per_in_ler_id = p_per_in_ler_id -- 8626297
11804: and pen.prtt_enrt_rslt_stat_cd is null
11805: and pen.enrt_cvg_thru_dt = hr_api.g_eot
11806: and pen.effective_end_date = hr_api.g_eot;
11807:
11808: /* Bug 8863079: Added cursor c_get_epe_id to determine the interim epe record */
11809: cursor c_get_epe_id(c_prtt_enrt_rslt_id number,c_per_in_ler_id number) is
11810: select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc epe,

Line 11954: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,

11950: --
11951: end if;
11952: --
11953: g_sys_date := greatest(trunc(sysdate),
11954: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,
11955: l_bckdt_pen_rec.effective_start_date);
11956: --
11957: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
11958: --

Line 11957: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));

11953: g_sys_date := greatest(trunc(sysdate),
11954: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot) + 1,
11955: l_bckdt_pen_rec.effective_start_date);
11956: --
11957: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
11958: --
11959: hr_utility.set_location('Date used to reinstate the enrollment = ' || g_sys_date, 333);
11960: if g_sys_date <= l_bckdt_pen_rec.effective_end_date
11961: then

Line 12216: p_datetrack_mode => hr_api.g_insert, -- 99999 l_datetrack_mode,

12212: p_ann_rt_val9 => l_rt_table(9).ann_rt_val,
12213: p_enrt_rt_id10 => l_rt_table(10).enrt_rt_id,
12214: p_rt_val10 => l_rt_table(10).dflt_val,
12215: p_ann_rt_val10 => l_rt_table(10).ann_rt_val,
12216: p_datetrack_mode => hr_api.g_insert, -- 99999 l_datetrack_mode,
12217: p_suspend_flag => l_suspend_flag,
12218: p_called_from_sspnd => 'N',
12219: p_prtt_enrt_interim_id => l_prtt_enrt_interim_id,
12220: p_prtt_rt_val_id1 => l_prtt_rt_val_id1,

Line 12748: ,p_datetrack_mode => hr_api.g_correction

12744: ,p_enrt_cvg_thru_dt => l_enrt_table(i).bckdt_enrt_cvg_thru_dt
12745: ,p_enrt_ovridn_flag => 'Y'
12746: ,p_object_version_number => l_ovn
12747: ,p_effective_date => l_enrt_table(i).g_sys_date
12748: ,p_datetrack_mode => hr_api.g_correction
12749: ,p_multi_row_validate => FALSE);
12750: --
12751: end if;
12752: --

Line 12799: ,p_datetrack_mode => hr_api.g_correction

12795: ,p_cvg_thru_dt => l_dpnt_rec.cvg_thru_dt
12796: ,p_ovrdn_flag => l_dpnt_rec.ovrdn_flag
12797: ,p_ovrdn_thru_dt => l_dpnt_rec.ovrdn_thru_dt
12798: ,p_object_version_number => l_dpnt_rec.new_pdp_ovn
12799: ,p_datetrack_mode => hr_api.g_correction
12800: ,p_effective_date => l_enrt_table(i).g_sys_date);
12801: --
12802: end loop;
12803: --