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

Line 510: and pen.effective_end_date = hr_api.g_eot

506: ben_prtt_enrt_rslt_f pen,
507: ben_per_in_ler pil,
508: ben_elig_per_elctbl_chc epe
509: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
510: and pen.effective_end_date = hr_api.g_eot
511: and pen.enrt_cvg_thru_dt = hr_api.g_eot
512: and pen.prtt_enrt_rslt_stat_cd is null
513: and pen.per_in_ler_id = pil.per_in_ler_id
514: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 511: and pen.enrt_cvg_thru_dt = hr_api.g_eot

507: ben_per_in_ler pil,
508: ben_elig_per_elctbl_chc epe
509: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
510: and pen.effective_end_date = hr_api.g_eot
511: and pen.enrt_cvg_thru_dt = hr_api.g_eot
512: and pen.prtt_enrt_rslt_stat_cd is null
513: and pen.per_in_ler_id = pil.per_in_ler_id
514: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
515: and epe.per_in_ler_id = pil.per_in_ler_id

Line 924: l_datetrack_mode := hr_api.g_update_override;

920: p_update_change_insert => l_update_change_insert);
921: --
922: if l_update_override then
923: --
924: l_datetrack_mode := hr_api.g_update_override;
925: --
926: elsif l_update then
927: --
928: l_datetrack_mode := hr_api.g_update;

Line 928: l_datetrack_mode := hr_api.g_update;

924: l_datetrack_mode := hr_api.g_update_override;
925: --
926: elsif l_update then
927: --
928: l_datetrack_mode := hr_api.g_update;
929: --
930: else
931: --
932: l_datetrack_mode := hr_api.g_correction;

Line 932: l_datetrack_mode := hr_api.g_correction;

928: l_datetrack_mode := hr_api.g_update;
929: --
930: else
931: --
932: l_datetrack_mode := hr_api.g_correction;
933: --
934: end if;
935: --
936: ben_Eligible_Person_perf_api.update_perf_Eligible_Person

Line 1152: l_datetrack_mode := hr_api.g_update_override;

1148: p_update_change_insert => l_update_change_insert);
1149: --
1150: if l_update_override then
1151: --
1152: l_datetrack_mode := hr_api.g_update_override;
1153: --
1154: elsif l_update then
1155: --
1156: l_datetrack_mode := hr_api.g_update;

Line 1156: l_datetrack_mode := hr_api.g_update;

1152: l_datetrack_mode := hr_api.g_update_override;
1153: --
1154: elsif l_update then
1155: --
1156: l_datetrack_mode := hr_api.g_update;
1157: --
1158: else
1159: --
1160: l_datetrack_mode := hr_api.g_correction;

Line 1160: l_datetrack_mode := hr_api.g_correction;

1156: l_datetrack_mode := hr_api.g_update;
1157: --
1158: else
1159: --
1160: l_datetrack_mode := hr_api.g_correction;
1161: --
1162: end if;
1163: --
1164: BEN_prtt_enrt_ctfn_prvdd_API.update_prtt_enrt_ctfn_prvdd

Line 1296: l_datetrack_mode := hr_api.g_update_override;

1292: p_update_change_insert => l_update_change_insert);
1293: --
1294: if l_update_override then
1295: --
1296: l_datetrack_mode := hr_api.g_update_override;
1297: --
1298: elsif l_update then
1299: --
1300: l_datetrack_mode := hr_api.g_update;

Line 1300: l_datetrack_mode := hr_api.g_update;

1296: l_datetrack_mode := hr_api.g_update_override;
1297: --
1298: elsif l_update then
1299: --
1300: l_datetrack_mode := hr_api.g_update;
1301: --
1302: else
1303: --
1304: l_datetrack_mode := hr_api.g_correction;

Line 1304: l_datetrack_mode := hr_api.g_correction;

1300: l_datetrack_mode := hr_api.g_update;
1301: --
1302: else
1303: --
1304: l_datetrack_mode := hr_api.g_correction;
1305: --
1306: end if;
1307: --
1308: ben_Eligible_Person_perf_api.update_perf_Elig_Person_Option

Line 1528: AND pen.effective_end_date = hr_api.g_eot

1524: from ben_le_clsn_n_rstr pen
1525: where per_in_ler_id = p_pil_id
1526: AND pen.business_group_id = p_business_group_id
1527: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1528: AND pen.effective_end_date = hr_api.g_eot
1529: AND pen.enrt_cvg_strt_dt > p_lf_evt_ocrd_dt
1530: AND pen.enrt_cvg_strt_dt < pen.effective_end_date;
1531:
1532: /* Added for Bug 8604243 */

Line 1577: AND leclr.effective_end_date = hr_api.g_eot

1573: ben_prtt_enrt_rslt_f pen
1574: where leclr.per_in_ler_id <> p_pil_id
1575: AND leclr.business_group_id = p_business_group_id
1576: AND leclr.prtt_enrt_rslt_stat_cd IS NULL
1577: AND leclr.effective_end_date = hr_api.g_eot
1578: AND leclr.enrt_cvg_strt_dt > p_lf_evt_ocrd_dt
1579: AND leclr.enrt_cvg_strt_dt < leclr.effective_end_date
1580: AND leclr.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
1581: AND leclr.bkup_tbl_id = pen.prtt_enrt_rslt_id

Line 1584: AND pen.effective_end_date = hr_api.g_eot

1580: AND leclr.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
1581: AND leclr.bkup_tbl_id = pen.prtt_enrt_rslt_id
1582: AND pen.per_in_ler_id = p_per_in_ler_id
1583: AND pen.prtt_enrt_rslt_stat_cd = 'BCKDT'
1584: AND pen.effective_end_date = hr_api.g_eot
1585: AND pen.enrt_cvg_strt_dt > p_lf_evt_ocrd_dt
1586: AND pen.enrt_cvg_strt_dt < pen.effective_end_date;
1587:
1588: --

Line 2376: AND effective_end_date = hr_api.g_eot

2372: AND bkup_tbl_id = l_prior_to_prv_rslt_lvl_bckdt.bkup_tbl_id
2373: AND bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
2374: AND business_group_id = p_business_group_id
2375: AND prtt_enrt_rslt_stat_cd IS NULL
2376: AND effective_end_date = hr_api.g_eot
2377: AND enrt_cvg_strt_dt > l_prv_lf_evt_ocrd_dt
2378: AND enrt_cvg_strt_dt < effective_end_date;
2379: --
2380: hr_utility.set_location ('updated bkup table table with prev per_in_ler', 44333);

Line 2454: AND effective_end_date < hr_api.g_eot

2450: object_version_number
2451: FROM ben_prtt_enrt_actn_f
2452: WHERE per_in_ler_id = p_per_in_ler_id
2453: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2454: AND effective_end_date < hr_api.g_eot
2455: AND business_group_id = p_business_group_id
2456: AND prtt_enrt_actn_id not in
2457: (SELECT prtt_enrt_actn_id
2458: FROM ben_prtt_enrt_actn_f

Line 2470: and effective_end_date < hr_api.g_eot

2466: select prtt_enrt_ctfn_prvdd_id, effective_start_date, object_version_number
2467: from ben_prtt_enrt_ctfn_prvdd_f
2468: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2469: and prtt_enrt_actn_id = p_prtt_enrt_actn_id
2470: and effective_end_date < hr_api.g_eot
2471: and business_group_id = p_business_group_id;
2472: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
2473: --
2474: cursor c_check_prem_active is

Line 2478: and effective_end_date = hr_api.g_eot;

2474: cursor c_check_prem_active is
2475: select 1
2476: from ben_prtt_prem_f
2477: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2478: and effective_end_date = hr_api.g_eot;
2479: l_check_prem_active c_check_prem_active%rowtype;
2480: --
2481: cursor c_ended_prem_details is
2482: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number

Line 2485: and ppm.effective_end_date <> hr_api.g_eot

2481: cursor c_ended_prem_details is
2482: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
2483: from ben_prtt_prem_f ppm
2484: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2485: and ppm.effective_end_date <> hr_api.g_eot
2486: and not exists (select 1
2487: from ben_prtt_prem_f ppm2
2488: where ppm2.prtt_prem_id = ppm.prtt_prem_id
2489: and ppm2.effective_end_date > ppm.effective_end_date)

Line 2537: p_datetrack_mode => hr_api.g_future_change);

2533: p_effective_start_date => l_effective_start_date,
2534: p_effective_end_date => l_effective_end_date,
2535: p_object_version_number => l_object_version_number,
2536: p_effective_date => l_actn_item.effective_start_date,
2537: p_datetrack_mode => hr_api.g_future_change);
2538: --
2539: end if;
2540: --
2541: hr_utility.set_location('ACE l_actn_item.prtt_enrt_actn_id = ' || l_actn_item.prtt_enrt_actn_id, 8888);

Line 2564: p_datetrack_mode => hr_api.g_future_change);

2560: p_effective_start_date => l_effective_start_date,
2561: p_effective_end_date => l_effective_end_date,
2562: p_object_version_number => l_object_version_number,
2563: p_effective_date => l_enrt_ctfn.effective_start_date,
2564: p_datetrack_mode => hr_api.g_future_change);
2565: --
2566: end if;
2567: --
2568: --

Line 2589: p_datetrack_mode => hr_api.g_future_change);

2585: p_effective_start_date => l_effective_start_date,
2586: p_effective_end_date => l_effective_end_date,
2587: p_object_version_number => l_ppe_object_version_number,
2588: p_effective_date => l_ended_prem_details.effective_start_date,
2589: p_datetrack_mode => hr_api.g_future_change);
2590: end loop;
2591: --
2592: end if;
2593: close c_check_prem_active;

Line 2654: and pen.effective_end_Date = hr_api.g_eot;

2650: and prv2.rt_strt_dt between abr2.effective_start_date
2651: and abr2.effective_end_date)
2652: and prv.rt_strt_dt between abr.effective_start_date
2653: and abr.effective_end_date
2654: and pen.effective_end_Date = hr_api.g_eot;
2655: --
2656: l_prv c_future_prv%rowtype;
2657: --
2658: cursor c_element (p_element_entry_value_id number) is

Line 2693: ,p_datetrack_delete_mode => hr_api.g_zap

2689: hr_utility.set_location('effective date'||l_element.effective_start_date,10);
2690: l_element_start_date := l_element.effective_start_date;
2691: py_element_entry_api.delete_element_entry
2692: (p_validate => false
2693: ,p_datetrack_delete_mode => hr_api.g_zap
2694: ,p_effective_date => l_element_start_date
2695: ,p_element_entry_id => l_element.element_entry_id
2696: ,p_object_version_number => l_element.object_version_number
2697: ,p_effective_start_date => l_element.effective_start_date

Line 2775: p_datetrack_mode => hr_api.g_correction,

2771: p_effective_end_date => l_effective_end_date,
2772: p_business_group_id => p_business_group_id,
2773: p_object_version_number => l_object_version_number,
2774: p_effective_date => p_effective_date,
2775: p_datetrack_mode => hr_api.g_correction,
2776: p_multi_row_validate => FALSE,
2777: p_enrt_cvg_thru_dt => p_cvg_end_dt
2778: );
2779: --

Line 2974: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

2970: ,prtt_enrt_rslt_stat_cd
2971: from ben_prtt_enrt_rslt_f pen
2972: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2973: and pen.business_group_id = p_business_group_id
2974: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
2975: -- and pen.prtt_enrt_rslt_stat_cd is null
2976: and p_effective_date
2977: between pen.effective_start_date
2978: and pen.effective_end_date;

Line 3408: and effective_end_date = hr_api.g_eot

3404: --APP-PAY-07155 error on backing out the life event which has created coverage adjustment records if
3405: --there are date track records for the enrollment after SYSDATE
3406: from ben_prtt_enrt_rslt_f
3407: where prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
3408: and effective_end_date = hr_api.g_eot
3409: and prtt_enrt_rslt_stat_cd is null;
3410: -- End bug 7206471
3411: --
3412: -- Bug : 4661 Cursor to select the prtt_enrt_rslt record associated

Line 3548: and lcnr.enrt_cvg_thru_dt = hr_api.g_eot --bug#5032364

3544: ,BEN_PRTT_ENRT_RSLT_F pen -- Bug 6632568
3545: where lcnr.bkup_tbl_id = pen.prtt_enrt_rslt_id -- Bug 6632568
3546: and pen.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id -- Bug 6632568
3547: and lcnr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
3548: and lcnr.enrt_cvg_thru_dt = hr_api.g_eot --bug#5032364
3549: and lcnr.per_in_ler_ended_id = pen.per_in_ler_id -- Bug 6632568
3550: and pen.per_in_ler_id = l_per_in_ler_id -- Bug 6632568
3551: and lcnr.effective_start_date between pen.effective_start_date -- Bug 6632568
3552: and pen.effective_end_date;

Line 3774: AND effective_end_date = hr_api.g_eot;

3770: SELECT bpl.*
3771: FROM ben_le_clsn_n_rstr bpl
3772: WHERE bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'
3773: AND per_in_ler_id = p_per_in_ler_id
3774: AND effective_end_date = hr_api.g_eot;
3775: --
3776: l_bpl_from_backup c_bpl_from_backup%ROWTYPE;
3777: --
3778: -- Bug 5500864

Line 3896: where pdp.effective_end_date <> hr_api.g_eot

3892: select pdp.elig_cvrd_dpnt_id,
3893: pdp.object_version_number,
3894: pdp.effective_end_date
3895: from ben_elig_cvrd_dpnt_f pdp
3896: where pdp.effective_end_date <> hr_api.g_eot
3897: and pdp.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
3898: and pdp.business_group_id = p_business_group_id
3899: order by 1;
3900:

Line 3917: and pen.effective_end_date = hr_api.g_eot

3913: and pen.per_in_ler_id <> pil.per_in_ler_id
3914: and pil.per_in_ler_id = p_per_in_ler_id
3915: and pen.person_id = pil.person_id
3916: and pen.prtt_enrt_rslt_stat_cd is null
3917: and pen.effective_end_date = hr_api.g_eot
3918: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
3919: l_pen_sus c_pen_sus%rowtype;
3920:
3921:

Line 3918: and pen.enrt_cvg_thru_dt = hr_api.g_eot;

3914: and pil.per_in_ler_id = p_per_in_ler_id
3915: and pen.person_id = pil.person_id
3916: and pen.prtt_enrt_rslt_stat_cd is null
3917: and pen.effective_end_date = hr_api.g_eot
3918: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
3919: l_pen_sus c_pen_sus%rowtype;
3920:
3921:
3922: l_salary_warning boolean;

Line 4214: l_datetrack_mode := hr_api.g_future_change;

4210: end loop;
4211: --
4212: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4213: --
4214: l_datetrack_mode := hr_api.g_future_change;
4215: l_object_version_number := l_max_object_version_number;
4216: --
4217: -- pass the real effective_date also
4218: --

Line 4223: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

4219: g_bolfe_effective_date:=p_effective_date;
4220: --
4221: -- Delete from the appropriate API.
4222: --
4223: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4224: ben_elig_cvrd_dpnt_api.delete_elig_cvrd_dpnt
4225: (p_validate => false,
4226: p_elig_cvrd_dpnt_id => l_pk_id,
4227: p_effective_start_date => l_effective_start_date,

Line 4253: ,p_datetrack_mode => hr_api.g_zap

4249: p_validate => FALSE
4250: ,p_elig_cvrd_dpnt_id => l_pk_id
4251: ,p_cvg_thru_dt => NULL
4252: ,p_effective_date => l_dpnt_eff_start_date
4253: ,p_datetrack_mode => hr_api.g_zap
4254: );
4255:
4256: end if;
4257: --

Line 4279: l_datetrack_mode := hr_api.g_future_change;

4275: fetch c_futur_del_dpnt into l_pk_id,l_object_version_number,l_effective_date ;
4276: exit when c_futur_del_dpnt%notfound;
4277:
4278:
4279: l_datetrack_mode := hr_api.g_future_change;
4280: ben_elig_cvrd_dpnt_api.delete_elig_cvrd_dpnt
4281: (p_validate => false,
4282: p_elig_cvrd_dpnt_id => l_pk_id,
4283: p_effective_start_date => l_effective_start_date,

Line 4317: ,p_datetrack_mode => hr_api.g_correction

4313: ,p_cvg_thru_dt => i.enrt_cvg_thru_dt
4314: ,p_per_in_ler_id => i.per_in_ler_id
4315: ,p_object_version_number => l_object_version_number
4316: ,p_effective_date => i.effective_start_date
4317: ,p_datetrack_mode => hr_api.g_correction
4318: ,p_multi_row_actn => FALSE);
4319: l_prev_elig_cvrd_dpnt_id := i.elig_cvrd_dpnt_id;
4320: --
4321: -- Correct the effective end date. 7197868

Line 4323: if (i.bkp_effective_end_date = hr_api.g_eot

4319: l_prev_elig_cvrd_dpnt_id := i.elig_cvrd_dpnt_id;
4320: --
4321: -- Correct the effective end date. 7197868
4322: --
4323: if (i.bkp_effective_end_date = hr_api.g_eot
4324: and i.effective_end_date <> i.bkp_effective_end_date) then
4325: --
4326: -- Delete future dated rows.
4327: --

Line 4336: p_datetrack_mode => hr_api.g_future_change,

4332: p_effective_end_date => l_effective_end_date,
4333: p_object_version_number => l_object_version_number,
4334: p_business_group_id => p_business_group_id,
4335: p_effective_date => i.bkp_effective_start_date,
4336: p_datetrack_mode => hr_api.g_future_change,
4337: p_called_from => 'benbolfe');
4338: end if;
4339: --
4340: -- End 7197868

Line 4633: l_datetrack_mode := hr_api.g_delete_next_change;

4629: */
4630: --
4631: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4632: --
4633: l_datetrack_mode := hr_api.g_delete_next_change;
4634: l_object_version_number := l_max_object_version_number;
4635: --
4636: -- Delete from the appropriate API.
4637: --

Line 4638: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

4634: l_object_version_number := l_max_object_version_number;
4635: --
4636: -- Delete from the appropriate API.
4637: --
4638: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4639: ben_eligible_person_api.delete_eligible_person
4640: (p_validate => false,
4641: p_elig_per_id => l_pk_id,
4642: p_effective_start_date => l_effective_start_date,

Line 4909: l_datetrack_mode := hr_api.g_future_change;

4905: */
4906: --
4907: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4908: --
4909: l_datetrack_mode := hr_api.g_future_change;
4910: l_object_version_number := l_max_object_version_number;
4911: --
4912: -- Delete from the appropriate API.
4913: --

Line 4914: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

4910: l_object_version_number := l_max_object_version_number;
4911: --
4912: -- Delete from the appropriate API.
4913: --
4914: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4915: ben_elig_person_option_api.delete_elig_person_option
4916: (p_validate => false,
4917: p_elig_per_opt_id => l_pk_id,
4918: p_effective_start_date => l_effective_start_date,

Line 5195: l_datetrack_mode := hr_api.g_future_change;

5191: end loop;
5192: --
5193: -- Past records exist. So datetrack mode FUTURE_CHANGE.
5194: --
5195: l_datetrack_mode := hr_api.g_future_change;
5196: l_object_version_number := l_max_object_version_number;
5197: --
5198: -- Delete from the appropriate API.
5199: --

Line 5200: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

5196: l_object_version_number := l_max_object_version_number;
5197: --
5198: -- Delete from the appropriate API.
5199: --
5200: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
5201: ben_prtt_prem_api.delete_prtt_prem
5202: (p_validate => false,
5203: p_prtt_prem_id => l_pk_id,
5204: p_effective_start_date => l_effective_start_date,

Line 5470: l_datetrack_mode := hr_api.g_future_change;

5466: end loop;
5467: --
5468: -- Past records exist. So datetrack mode FUTURE_CHANGE.
5469: --
5470: l_datetrack_mode := hr_api.g_future_change;
5471: l_object_version_number := l_max_object_version_number;
5472: --
5473: -- Delete from the appropriate API.
5474: --

Line 5475: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

5471: l_object_version_number := l_max_object_version_number;
5472: --
5473: -- Delete from the appropriate API.
5474: --
5475: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
5476: ben_plan_beneficiary_api.delete_plan_beneficiary
5477: (p_validate => false,
5478: p_pl_bnf_id => l_pk_id,
5479: p_effective_start_date => l_effective_start_date,

Line 5498: ,p_datetrack_mode => hr_api.g_zap

5494: BEN_PLAN_BENEFICIARY_API.remove_usage (
5495: p_validate => FALSE
5496: ,p_pl_bnf_id => l_pk_id
5497: ,p_effective_date => l_bnf_effective_start_date
5498: ,p_datetrack_mode => hr_api.g_zap
5499: ,p_business_group_id => p_business_group_id
5500: ,p_dsgn_thru_dt => NULL);
5501:
5502:

Line 5524: ,p_datetrack_mode => hr_api.g_correction

5520: ,p_dsgn_thru_dt => i.enrt_cvg_thru_dt
5521: ,p_per_in_ler_id => i.per_in_ler_id
5522: ,p_object_version_number => l_object_version_number
5523: ,p_effective_date => i.effective_start_date
5524: ,p_datetrack_mode => hr_api.g_correction
5525: ,p_multi_row_actn => FALSE);
5526:
5527: end loop ;
5528:

Line 5887: l_rt_end_dt := hr_api.g_eot;

5883: if l_prev_prv_bckdt.acty_base_rt_id = l_prv_bckdt.acty_base_rt_id then
5884: l_rt_end_dt := l_prev_prv_bckdt.rt_strt_dt -1;
5885: l_ended_per_in_ler_id := l_prev_prv_bckdt.per_in_ler_id;
5886: else
5887: l_rt_end_dt := hr_api.g_eot;
5888: l_ended_per_in_ler_id := null;
5889: end if;
5890: */
5891:

Line 5896: l_rt_end_dt := hr_api.g_eot;

5892: if l_next_prv.prtt_rt_val_id is not null then
5893: l_rt_end_dt := l_next_prv.rt_strt_dt -1;
5894: l_ended_per_in_ler_id := l_next_prv.per_in_ler_id;
5895: else
5896: l_rt_end_dt := hr_api.g_eot;
5897: l_ended_per_in_ler_id := null;
5898: --
5899: -- 8896851
5900: --

Line 6347: l_datetrack_mode := hr_api.g_future_change;

6343: end loop;
6344:
6345: -- Past records exist. So datetrack mode FUTURE_CHANGE.
6346: --
6347: l_datetrack_mode := hr_api.g_future_change;
6348: l_object_version_number := l_max_object_version_number;
6349: --
6350:
6351: -- Delete from the appropriate API.

Line 6364: if l_effective_date <> hr_api.g_eot and l_dummy is null and nvl(p_copy_only,'N') <> 'Y' then

6360: fetch c_corr_result_exist into l_dummy ;
6361: close c_corr_result_exist ;
6362: hr_utility.set_location( 'corrected result exist ' || l_dummy , 99 );
6363:
6364: if l_effective_date <> hr_api.g_eot and l_dummy is null and nvl(p_copy_only,'N') <> 'Y' then
6365: ben_prtt_enrt_result_api.delete_prtt_enrt_result
6366: (p_validate => false,
6367: p_prtt_enrt_rslt_id => l_pk_id,
6368: p_effective_start_date => l_effective_start_date,

Line 6379: if(l_effective_end_date = hr_api.g_eot) then

6375:
6376: /* Added for Bug 8984394 */
6377: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 1999 );
6378: hr_utility.set_location( 'l_effective_end_date ' || l_effective_end_date , 1999 );
6379: if(l_effective_end_date = hr_api.g_eot) then
6380: /*Bug 9580432: Call update_epe procedure to update the epe record. Deleted the code and made a call
6381: to the procedure update_epe as the deleted code and procedure do the same thing ie update epe record
6382: with the prtt_enrt_rslt_id*/
6383: hr_utility.set_location(' Calling update_epe ',1999);

Line 6395: if nvl(l_enrt_cvg_thru_dt,hr_api.g_eot)<>hr_api.g_eot or

6391: l_prev_pk_id := l_pk_id;
6392: --
6393: -- check if the cvg was ended or the row was just dt ended
6394: --
6395: if nvl(l_enrt_cvg_thru_dt,hr_api.g_eot)<>hr_api.g_eot or
6396: l_pen_eed<>hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
6397: --
6398: -- The ended row is being removed, effectively creating it.
6399: -- else it's just and update.

Line 6396: l_pen_eed<>hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

6392: --
6393: -- check if the cvg was ended or the row was just dt ended
6394: --
6395: if nvl(l_enrt_cvg_thru_dt,hr_api.g_eot)<>hr_api.g_eot or
6396: l_pen_eed<>hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
6397: --
6398: -- The ended row is being removed, effectively creating it.
6399: -- else it's just and update.
6400: --

Line 6432: ,P_desired_datetrack_mode => hr_api.g_update

6428: --
6429: ben_prtt_enrt_result_api.get_ben_pen_upd_dt_mode
6430: (p_effective_date => p_effective_date
6431: ,p_base_key_value => l_pk_id
6432: ,P_desired_datetrack_mode => hr_api.g_update
6433: ,P_datetrack_allow => l_datetrack_mode
6434: );
6435: */
6436:

Line 6730: ,p_datetrack_mode => hr_api.g_correction -- l_datetrack_mode

6726: ,p_business_group_id => p_business_group_id
6727: ,p_object_version_number => l_object_version_number
6728: ,p_prtt_enrt_rslt_stat_cd => 'BCKDT'
6729: ,p_effective_date => l_pen_esd -- p_effective_date
6730: ,p_datetrack_mode => hr_api.g_correction -- l_datetrack_mode
6731: ,p_multi_row_validate => FALSE);
6732: --
6733: ben_ext_chlg.log_benefit_chg(
6734: p_action => 'DELETE'

Line 6798: if i.enrt_cvg_thru_dt <> hr_api.g_eot then

6794: if l_prev_bkup_tbl_id <> i.bkup_tbl_id and nvl(p_copy_only,'N') <> 'Y' then
6795:
6796: l_object_version_number := i.object_version_number ;
6797: --bug#5032364
6798: if i.enrt_cvg_thru_dt <> hr_api.g_eot then
6799: --
6800: ben_prtt_enrt_result_api.delete_enrollment
6801: (p_validate => false ,
6802: p_prtt_enrt_rslt_id => i.bkup_tbl_id,

Line 6819: if (i.effective_end_date = hr_api.g_eot

6815: --
6816: -- When updating the corrected row, also correct the effective end date.
6817: -- Bug 7197868
6818: --
6819: if (i.effective_end_date = hr_api.g_eot
6820: and i.pen_effective_end_date <> i.effective_end_date) then
6821: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6822: --
6823: -- Bug 7197868

Line 6834: p_datetrack_mode => hr_api.g_future_change,

6830: p_effective_start_date => l_effective_start_date,
6831: p_effective_end_date => l_effective_end_date,
6832: p_object_version_number => l_object_version_number,
6833: p_effective_date => i.effective_start_date,
6834: p_datetrack_mode => hr_api.g_future_change,
6835: p_multi_row_validate => false);
6836: end if;
6837: --
6838: ben_prtt_enrt_result_api.update_prtt_enrt_result

Line 6850: ,p_datetrack_mode => hr_api.g_correction

6846: ,p_object_version_number => l_object_version_number
6847: ,p_effective_date => i.effective_start_date
6848: ,p_prtt_enrt_rslt_stat_cd => i.prtt_enrt_rslt_stat_cd
6849: ,p_enrt_mthd_cd => i.enrt_mthd_cd -- Bug 7137371
6850: ,p_datetrack_mode => hr_api.g_correction
6851: ,p_sspndd_flag => i.sspndd_flag
6852: ,p_multi_row_validate => FALSE
6853: ,p_business_group_id => p_business_group_id
6854: );

Line 6870: if ((i.effective_end_date = hr_api.g_eot

6866: -- only when p_copy_only = 'N' and l_prev_bkup_tbl_id <> i.bkup_tbl_id
6867: --changed 7176884 begin
6868: -- delete the row from the backup table -- 7197868
6869: --
6870: if ((i.effective_end_date = hr_api.g_eot
6871: and i.pen_effective_end_date <> i.effective_end_date)
6872: or (l_prtt_enrt_rslt_stat_cd = 'VOIDD')) then -- 8199189
6873: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6874: hr_utility.set_location(' i.per_in_ler_id ' || i.per_in_ler_id, 999 );

Line 7039: p_datetrack_mode => hr_api.g_FUTURE_CHANGE,

7035: p_effective_start_date => l_effective_start_date,
7036: p_effective_end_date => l_effective_end_date,
7037: p_object_version_number => l_bpl_from_backup.object_version_number,
7038: p_effective_date => l_bpl_from_backup.effective_start_date,
7039: p_datetrack_mode => hr_api.g_FUTURE_CHANGE,
7040: p_business_group_id => p_business_group_id
7041: );
7042: hr_utility.set_location('ACE Reopened = ' || l_bpl_from_backup.BKUP_TBL_ID, 9999);
7043: --

Line 7051: and effective_end_date = hr_api.g_eot;

7047: where cls.per_in_ler_id = l_bpl_from_backup.per_in_ler_id
7048: and cls.bkup_tbl_id = l_bpl_from_backup.bkup_tbl_id
7049: and cls.bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'
7050: and effective_start_date = l_bpl_from_backup.effective_start_date
7051: and effective_end_date = hr_api.g_eot;
7052: --
7053: -- End Bug 6376239
7054: --
7055: end loop;

Line 7085: l_datetrack_mode := hr_api.g_future_change;

7081: if l_effective_date is not null then
7082: if l_prev_pk_id <> l_pk_id then
7083: -- Past records exist. So datetrack mode FUTURE_CHANGE.
7084: --
7085: l_datetrack_mode := hr_api.g_future_change;
7086: l_object_version_number := l_max_object_version_number;
7087: --
7088: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
7089: --

Line 7088: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then

7084: --
7085: l_datetrack_mode := hr_api.g_future_change;
7086: l_object_version_number := l_max_object_version_number;
7087: --
7088: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
7089: --
7090: hr_utility.set_location('Deleting ledger='||to_char(l_bpl.bnft_prvdd_ldgr_id), 50);
7091: --
7092: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

Line 7121: p_datetrack_mode => hr_api.g_zap,

7117: p_effective_start_date => l_bpl.effective_start_date,
7118: p_effective_end_date => l_bpl.effective_end_date,
7119: p_object_version_number => l_bpl.object_version_number,
7120: p_effective_date => l_bpl_effective_date,
7121: p_datetrack_mode => hr_api.g_zap,
7122: p_business_group_id => p_business_group_id
7123: );
7124: l_prev_pk_id := l_pk_id;
7125: end if;