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 763: l_datetrack_mode := hr_api.g_update_override;

759: p_update_change_insert => l_update_change_insert);
760: --
761: if l_update_override then
762: --
763: l_datetrack_mode := hr_api.g_update_override;
764: --
765: elsif l_update then
766: --
767: l_datetrack_mode := hr_api.g_update;

Line 767: l_datetrack_mode := hr_api.g_update;

763: l_datetrack_mode := hr_api.g_update_override;
764: --
765: elsif l_update then
766: --
767: l_datetrack_mode := hr_api.g_update;
768: --
769: else
770: --
771: l_datetrack_mode := hr_api.g_correction;

Line 771: l_datetrack_mode := hr_api.g_correction;

767: l_datetrack_mode := hr_api.g_update;
768: --
769: else
770: --
771: l_datetrack_mode := hr_api.g_correction;
772: --
773: end if;
774: --
775: ben_Eligible_Person_perf_api.update_perf_Eligible_Person

Line 910: l_datetrack_mode := hr_api.g_update_override;

906: p_update_change_insert => l_update_change_insert);
907: --
908: if l_update_override then
909: --
910: l_datetrack_mode := hr_api.g_update_override;
911: --
912: elsif l_update then
913: --
914: l_datetrack_mode := hr_api.g_update;

Line 914: l_datetrack_mode := hr_api.g_update;

910: l_datetrack_mode := hr_api.g_update_override;
911: --
912: elsif l_update then
913: --
914: l_datetrack_mode := hr_api.g_update;
915: --
916: else
917: --
918: l_datetrack_mode := hr_api.g_correction;

Line 918: l_datetrack_mode := hr_api.g_correction;

914: l_datetrack_mode := hr_api.g_update;
915: --
916: else
917: --
918: l_datetrack_mode := hr_api.g_correction;
919: --
920: end if;
921: --
922: BEN_prtt_enrt_ctfn_prvdd_API.update_prtt_enrt_ctfn_prvdd

Line 1047: l_datetrack_mode := hr_api.g_update_override;

1043: p_update_change_insert => l_update_change_insert);
1044: --
1045: if l_update_override then
1046: --
1047: l_datetrack_mode := hr_api.g_update_override;
1048: --
1049: elsif l_update then
1050: --
1051: l_datetrack_mode := hr_api.g_update;

Line 1051: l_datetrack_mode := hr_api.g_update;

1047: l_datetrack_mode := hr_api.g_update_override;
1048: --
1049: elsif l_update then
1050: --
1051: l_datetrack_mode := hr_api.g_update;
1052: --
1053: else
1054: --
1055: l_datetrack_mode := hr_api.g_correction;

Line 1055: l_datetrack_mode := hr_api.g_correction;

1051: l_datetrack_mode := hr_api.g_update;
1052: --
1053: else
1054: --
1055: l_datetrack_mode := hr_api.g_correction;
1056: --
1057: end if;
1058: --
1059: ben_Eligible_Person_perf_api.update_perf_Elig_Person_Option

Line 1214: AND pen.effective_end_date = hr_api.g_eot

1210: from ben_le_clsn_n_rstr pen
1211: where per_in_ler_id = p_pil_id
1212: AND pen.business_group_id = p_business_group_id
1213: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1214: AND pen.effective_end_date = hr_api.g_eot
1215: AND pen.enrt_cvg_strt_dt > p_lf_evt_ocrd_dt
1216: AND pen.enrt_cvg_strt_dt < pen.effective_end_date;
1217:
1218:

Line 1229: AND leclr.effective_end_date = hr_api.g_eot

1225: ben_prtt_enrt_rslt_f pen
1226: where leclr.per_in_ler_id <> p_pil_id
1227: AND leclr.business_group_id = p_business_group_id
1228: AND leclr.prtt_enrt_rslt_stat_cd IS NULL
1229: AND leclr.effective_end_date = hr_api.g_eot
1230: AND leclr.enrt_cvg_strt_dt > p_lf_evt_ocrd_dt
1231: AND leclr.enrt_cvg_strt_dt < leclr.effective_end_date
1232: AND leclr.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
1233: AND leclr.bkup_tbl_id = pen.prtt_enrt_rslt_id

Line 1236: AND pen.effective_end_date = hr_api.g_eot

1232: AND leclr.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
1233: AND leclr.bkup_tbl_id = pen.prtt_enrt_rslt_id
1234: AND pen.per_in_ler_id = p_per_in_ler_id
1235: AND pen.prtt_enrt_rslt_stat_cd = 'BCKDT'
1236: AND pen.effective_end_date = hr_api.g_eot
1237: AND pen.enrt_cvg_strt_dt > p_lf_evt_ocrd_dt
1238: AND pen.enrt_cvg_strt_dt < pen.effective_end_date;
1239:
1240: --

Line 1991: AND effective_end_date = hr_api.g_eot

1987: AND bkup_tbl_id = l_prior_to_prv_rslt_lvl_bckdt.bkup_tbl_id
1988: AND bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_RSLT_F'
1989: AND business_group_id = p_business_group_id
1990: AND prtt_enrt_rslt_stat_cd IS NULL
1991: AND effective_end_date = hr_api.g_eot
1992: AND enrt_cvg_strt_dt > l_prv_lf_evt_ocrd_dt
1993: AND enrt_cvg_strt_dt < effective_end_date;
1994: --
1995: hr_utility.set_location ('updated bkup table table with prev per_in_ler', 44333);

Line 2069: AND effective_end_date < hr_api.g_eot

2065: object_version_number
2066: FROM ben_prtt_enrt_actn_f
2067: WHERE per_in_ler_id = p_per_in_ler_id
2068: AND prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2069: AND effective_end_date < hr_api.g_eot
2070: AND business_group_id = p_business_group_id
2071: AND prtt_enrt_actn_id not in
2072: (SELECT prtt_enrt_actn_id
2073: FROM ben_prtt_enrt_actn_f

Line 2085: and effective_end_date < hr_api.g_eot

2081: select prtt_enrt_ctfn_prvdd_id, effective_start_date, object_version_number
2082: from ben_prtt_enrt_ctfn_prvdd_f
2083: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2084: and prtt_enrt_actn_id = p_prtt_enrt_actn_id
2085: and effective_end_date < hr_api.g_eot
2086: and business_group_id = p_business_group_id;
2087: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
2088: --
2089: cursor c_check_prem_active is

Line 2093: and effective_end_date = hr_api.g_eot;

2089: cursor c_check_prem_active is
2090: select 1
2091: from ben_prtt_prem_f
2092: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2093: and effective_end_date = hr_api.g_eot;
2094: l_check_prem_active c_check_prem_active%rowtype;
2095: --
2096: cursor c_ended_prem_details is
2097: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number

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

2096: cursor c_ended_prem_details is
2097: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
2098: from ben_prtt_prem_f ppm
2099: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2100: and ppm.effective_end_date <> hr_api.g_eot
2101: and not exists (select 1
2102: from ben_prtt_prem_f ppm2
2103: where ppm2.prtt_prem_id = ppm.prtt_prem_id
2104: and ppm2.effective_end_date > ppm.effective_end_date)

Line 2152: p_datetrack_mode => hr_api.g_future_change);

2148: p_effective_start_date => l_effective_start_date,
2149: p_effective_end_date => l_effective_end_date,
2150: p_object_version_number => l_object_version_number,
2151: p_effective_date => l_actn_item.effective_start_date,
2152: p_datetrack_mode => hr_api.g_future_change);
2153: --
2154: end if;
2155: --
2156: hr_utility.set_location('ACE l_actn_item.prtt_enrt_actn_id = ' || l_actn_item.prtt_enrt_actn_id, 8888);

Line 2179: p_datetrack_mode => hr_api.g_future_change);

2175: p_effective_start_date => l_effective_start_date,
2176: p_effective_end_date => l_effective_end_date,
2177: p_object_version_number => l_object_version_number,
2178: p_effective_date => l_enrt_ctfn.effective_start_date,
2179: p_datetrack_mode => hr_api.g_future_change);
2180: --
2181: end if;
2182: --
2183: --

Line 2204: p_datetrack_mode => hr_api.g_future_change);

2200: p_effective_start_date => l_effective_start_date,
2201: p_effective_end_date => l_effective_end_date,
2202: p_object_version_number => l_ppe_object_version_number,
2203: p_effective_date => l_ended_prem_details.effective_start_date,
2204: p_datetrack_mode => hr_api.g_future_change);
2205: end loop;
2206: --
2207: end if;
2208: close c_check_prem_active;

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

2265: and prv2.rt_strt_dt between abr2.effective_start_date
2266: and abr2.effective_end_date)
2267: and prv.rt_strt_dt between abr.effective_start_date
2268: and abr.effective_end_date
2269: and pen.effective_end_Date = hr_api.g_eot;
2270: --
2271: l_prv c_future_prv%rowtype;
2272: --
2273: cursor c_element (p_element_entry_value_id number) is

Line 2308: ,p_datetrack_delete_mode => hr_api.g_zap

2304: hr_utility.set_location('effective date'||l_element.effective_start_date,10);
2305: l_element_start_date := l_element.effective_start_date;
2306: py_element_entry_api.delete_element_entry
2307: (p_validate => false
2308: ,p_datetrack_delete_mode => hr_api.g_zap
2309: ,p_effective_date => l_element_start_date
2310: ,p_element_entry_id => l_element.element_entry_id
2311: ,p_object_version_number => l_element.object_version_number
2312: ,p_effective_start_date => l_element.effective_start_date

Line 2390: p_datetrack_mode => hr_api.g_correction,

2386: p_effective_end_date => l_effective_end_date,
2387: p_business_group_id => p_business_group_id,
2388: p_object_version_number => l_object_version_number,
2389: p_effective_date => p_effective_date,
2390: p_datetrack_mode => hr_api.g_correction,
2391: p_multi_row_validate => FALSE,
2392: p_enrt_cvg_thru_dt => p_cvg_end_dt
2393: );
2394: --

Line 2958: and effective_end_date = hr_api.g_eot

2954: cursor c_pen_ovn (p_prtt_enrt_rslt_id in number) is
2955: select object_version_number
2956: from ben_prtt_enrt_rslt_f
2957: where prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
2958: and effective_end_date = hr_api.g_eot
2959: and prtt_enrt_rslt_stat_cd is null;
2960: -- End bug 7206471
2961: --
2962: -- Bug : 4661 Cursor to select the prtt_enrt_rslt record associated

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

3092: ,BEN_PRTT_ENRT_RSLT_F pen -- Bug 6632568
3093: where lcnr.bkup_tbl_id = pen.prtt_enrt_rslt_id -- Bug 6632568
3094: and pen.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id -- Bug 6632568
3095: and lcnr.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_CORR'
3096: and lcnr.enrt_cvg_thru_dt = hr_api.g_eot --bug#5032364
3097: and lcnr.per_in_ler_ended_id = pen.per_in_ler_id -- Bug 6632568
3098: and pen.per_in_ler_id = l_per_in_ler_id -- Bug 6632568
3099: and lcnr.effective_start_date between pen.effective_start_date -- Bug 6632568
3100: and pen.effective_end_date;

Line 3322: AND effective_end_date = hr_api.g_eot;

3318: SELECT bpl.*
3319: FROM ben_le_clsn_n_rstr bpl
3320: WHERE bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'
3321: AND per_in_ler_id = p_per_in_ler_id
3322: AND effective_end_date = hr_api.g_eot;
3323: --
3324: l_bpl_from_backup c_bpl_from_backup%ROWTYPE;
3325: --
3326: -- Bug 5500864

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

3416: select pdp.elig_cvrd_dpnt_id,
3417: pdp.object_version_number,
3418: pdp.effective_end_date
3419: from ben_elig_cvrd_dpnt_f pdp
3420: where pdp.effective_end_date <> hr_api.g_eot
3421: and pdp.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
3422: and pdp.business_group_id = p_business_group_id
3423: order by 1;
3424:

Line 3441: and pen.effective_end_date = hr_api.g_eot

3437: and pen.per_in_ler_id <> pil.per_in_ler_id
3438: and pil.per_in_ler_id = p_per_in_ler_id
3439: and pen.person_id = pil.person_id
3440: and pen.prtt_enrt_rslt_stat_cd is null
3441: and pen.effective_end_date = hr_api.g_eot
3442: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
3443: l_pen_sus c_pen_sus%rowtype;
3444:
3445:

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

3438: and pil.per_in_ler_id = p_per_in_ler_id
3439: and pen.person_id = pil.person_id
3440: and pen.prtt_enrt_rslt_stat_cd is null
3441: and pen.effective_end_date = hr_api.g_eot
3442: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
3443: l_pen_sus c_pen_sus%rowtype;
3444:
3445:
3446: l_salary_warning boolean;

Line 3736: l_datetrack_mode := hr_api.g_future_change;

3732: end loop;
3733: --
3734: -- Past records exist. So datetrack mode FUTURE_CHANGE.
3735: --
3736: l_datetrack_mode := hr_api.g_future_change;
3737: l_object_version_number := l_max_object_version_number;
3738: --
3739: -- pass the real effective_date also
3740: --

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

3741: g_bolfe_effective_date:=p_effective_date;
3742: --
3743: -- Delete from the appropriate API.
3744: --
3745: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
3746: ben_elig_cvrd_dpnt_api.delete_elig_cvrd_dpnt
3747: (p_validate => false,
3748: p_elig_cvrd_dpnt_id => l_pk_id,
3749: p_effective_start_date => l_effective_start_date,

Line 3775: ,p_datetrack_mode => hr_api.g_zap

3771: p_validate => FALSE
3772: ,p_elig_cvrd_dpnt_id => l_pk_id
3773: ,p_cvg_thru_dt => NULL
3774: ,p_effective_date => l_dpnt_eff_start_date
3775: ,p_datetrack_mode => hr_api.g_zap
3776: );
3777:
3778: end if;
3779: --

Line 3801: l_datetrack_mode := hr_api.g_future_change;

3797: fetch c_futur_del_dpnt into l_pk_id,l_object_version_number,l_effective_date ;
3798: exit when c_futur_del_dpnt%notfound;
3799:
3800:
3801: l_datetrack_mode := hr_api.g_future_change;
3802: ben_elig_cvrd_dpnt_api.delete_elig_cvrd_dpnt
3803: (p_validate => false,
3804: p_elig_cvrd_dpnt_id => l_pk_id,
3805: p_effective_start_date => l_effective_start_date,

Line 3839: ,p_datetrack_mode => hr_api.g_correction

3835: ,p_cvg_thru_dt => i.enrt_cvg_thru_dt
3836: ,p_per_in_ler_id => i.per_in_ler_id
3837: ,p_object_version_number => l_object_version_number
3838: ,p_effective_date => i.effective_start_date
3839: ,p_datetrack_mode => hr_api.g_correction
3840: ,p_multi_row_actn => FALSE);
3841: l_prev_elig_cvrd_dpnt_id := i.elig_cvrd_dpnt_id;
3842: --
3843: -- Correct the effective end date. 7197868

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

3841: l_prev_elig_cvrd_dpnt_id := i.elig_cvrd_dpnt_id;
3842: --
3843: -- Correct the effective end date. 7197868
3844: --
3845: if (i.bkp_effective_end_date = hr_api.g_eot
3846: and i.effective_end_date <> i.bkp_effective_end_date) then
3847: --
3848: -- Delete future dated rows.
3849: --

Line 3858: p_datetrack_mode => hr_api.g_future_change,

3854: p_effective_end_date => l_effective_end_date,
3855: p_object_version_number => l_object_version_number,
3856: p_business_group_id => p_business_group_id,
3857: p_effective_date => i.bkp_effective_start_date,
3858: p_datetrack_mode => hr_api.g_future_change,
3859: p_called_from => 'benbolfe');
3860: end if;
3861: --
3862: -- End 7197868

Line 4152: l_datetrack_mode := hr_api.g_delete_next_change;

4148: */
4149: --
4150: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4151: --
4152: l_datetrack_mode := hr_api.g_delete_next_change;
4153: l_object_version_number := l_max_object_version_number;
4154: --
4155: -- Delete from the appropriate API.
4156: --

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

4153: l_object_version_number := l_max_object_version_number;
4154: --
4155: -- Delete from the appropriate API.
4156: --
4157: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4158: ben_eligible_person_api.delete_eligible_person
4159: (p_validate => false,
4160: p_elig_per_id => l_pk_id,
4161: p_effective_start_date => l_effective_start_date,

Line 4427: l_datetrack_mode := hr_api.g_future_change;

4423: */
4424: --
4425: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4426: --
4427: l_datetrack_mode := hr_api.g_future_change;
4428: l_object_version_number := l_max_object_version_number;
4429: --
4430: -- Delete from the appropriate API.
4431: --

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

4428: l_object_version_number := l_max_object_version_number;
4429: --
4430: -- Delete from the appropriate API.
4431: --
4432: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4433: ben_elig_person_option_api.delete_elig_person_option
4434: (p_validate => false,
4435: p_elig_per_opt_id => l_pk_id,
4436: p_effective_start_date => l_effective_start_date,

Line 4713: l_datetrack_mode := hr_api.g_future_change;

4709: end loop;
4710: --
4711: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4712: --
4713: l_datetrack_mode := hr_api.g_future_change;
4714: l_object_version_number := l_max_object_version_number;
4715: --
4716: -- Delete from the appropriate API.
4717: --

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

4714: l_object_version_number := l_max_object_version_number;
4715: --
4716: -- Delete from the appropriate API.
4717: --
4718: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4719: ben_prtt_prem_api.delete_prtt_prem
4720: (p_validate => false,
4721: p_prtt_prem_id => l_pk_id,
4722: p_effective_start_date => l_effective_start_date,

Line 4988: l_datetrack_mode := hr_api.g_future_change;

4984: end loop;
4985: --
4986: -- Past records exist. So datetrack mode FUTURE_CHANGE.
4987: --
4988: l_datetrack_mode := hr_api.g_future_change;
4989: l_object_version_number := l_max_object_version_number;
4990: --
4991: -- Delete from the appropriate API.
4992: --

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

4989: l_object_version_number := l_max_object_version_number;
4990: --
4991: -- Delete from the appropriate API.
4992: --
4993: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
4994: ben_plan_beneficiary_api.delete_plan_beneficiary
4995: (p_validate => false,
4996: p_pl_bnf_id => l_pk_id,
4997: p_effective_start_date => l_effective_start_date,

Line 5016: ,p_datetrack_mode => hr_api.g_zap

5012: BEN_PLAN_BENEFICIARY_API.remove_usage (
5013: p_validate => FALSE
5014: ,p_pl_bnf_id => l_pk_id
5015: ,p_effective_date => l_bnf_effective_start_date
5016: ,p_datetrack_mode => hr_api.g_zap
5017: ,p_business_group_id => p_business_group_id
5018: ,p_dsgn_thru_dt => NULL);
5019:
5020:

Line 5042: ,p_datetrack_mode => hr_api.g_correction

5038: ,p_dsgn_thru_dt => i.enrt_cvg_thru_dt
5039: ,p_per_in_ler_id => i.per_in_ler_id
5040: ,p_object_version_number => l_object_version_number
5041: ,p_effective_date => i.effective_start_date
5042: ,p_datetrack_mode => hr_api.g_correction
5043: ,p_multi_row_actn => FALSE);
5044:
5045: end loop ;
5046:

Line 5373: l_rt_end_dt := hr_api.g_eot;

5369: if l_prev_prv_bckdt.acty_base_rt_id = l_prv_bckdt.acty_base_rt_id then
5370: l_rt_end_dt := l_prev_prv_bckdt.rt_strt_dt -1;
5371: l_ended_per_in_ler_id := l_prev_prv_bckdt.per_in_ler_id;
5372: else
5373: l_rt_end_dt := hr_api.g_eot;
5374: l_ended_per_in_ler_id := null;
5375: end if;
5376: */
5377:

Line 5382: l_rt_end_dt := hr_api.g_eot;

5378: if l_next_prv.prtt_rt_val_id is not null then
5379: l_rt_end_dt := l_next_prv.rt_strt_dt -1;
5380: l_ended_per_in_ler_id := l_next_prv.per_in_ler_id;
5381: else
5382: l_rt_end_dt := hr_api.g_eot;
5383: l_ended_per_in_ler_id := null;
5384: end if;
5385:
5386: ben_prtt_rt_val_api.update_prtt_rt_val

Line 5787: l_datetrack_mode := hr_api.g_future_change;

5783: end loop;
5784:
5785: -- Past records exist. So datetrack mode FUTURE_CHANGE.
5786: --
5787: l_datetrack_mode := hr_api.g_future_change;
5788: l_object_version_number := l_max_object_version_number;
5789: --
5790:
5791: -- Delete from the appropriate API.

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

5800: fetch c_corr_result_exist into l_dummy ;
5801: close c_corr_result_exist ;
5802: hr_utility.set_location( 'corrected result exist ' || l_dummy , 99 );
5803:
5804: if l_effective_date <> hr_api.g_eot and l_dummy is null and nvl(p_copy_only,'N') <> 'Y' then
5805: ben_prtt_enrt_result_api.delete_prtt_enrt_result
5806: (p_validate => false,
5807: p_prtt_enrt_rslt_id => l_pk_id,
5808: p_effective_start_date => l_effective_start_date,

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

5816: l_prev_pk_id := l_pk_id;
5817: --
5818: -- check if the cvg was ended or the row was just dt ended
5819: --
5820: if nvl(l_enrt_cvg_thru_dt,hr_api.g_eot)<>hr_api.g_eot or
5821: l_pen_eed<>hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
5822: --
5823: -- The ended row is being removed, effectively creating it.
5824: -- else it's just and update.

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

5817: --
5818: -- check if the cvg was ended or the row was just dt ended
5819: --
5820: if nvl(l_enrt_cvg_thru_dt,hr_api.g_eot)<>hr_api.g_eot or
5821: l_pen_eed<>hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
5822: --
5823: -- The ended row is being removed, effectively creating it.
5824: -- else it's just and update.
5825: --

Line 5857: ,P_desired_datetrack_mode => hr_api.g_update

5853: --
5854: ben_prtt_enrt_result_api.get_ben_pen_upd_dt_mode
5855: (p_effective_date => p_effective_date
5856: ,p_base_key_value => l_pk_id
5857: ,P_desired_datetrack_mode => hr_api.g_update
5858: ,P_datetrack_allow => l_datetrack_mode
5859: );
5860: */
5861:

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

6151: ,p_business_group_id => p_business_group_id
6152: ,p_object_version_number => l_object_version_number
6153: ,p_prtt_enrt_rslt_stat_cd => 'BCKDT'
6154: ,p_effective_date => l_pen_esd -- p_effective_date
6155: ,p_datetrack_mode => hr_api.g_correction -- l_datetrack_mode
6156: ,p_multi_row_validate => FALSE);
6157: --
6158: ben_ext_chlg.log_benefit_chg(
6159: p_action => 'DELETE'

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

6202: if l_prev_bkup_tbl_id <> i.bkup_tbl_id and nvl(p_copy_only,'N') <> 'Y' then
6203:
6204: l_object_version_number := i.object_version_number ;
6205: --bug#5032364
6206: if i.enrt_cvg_thru_dt <> hr_api.g_eot then
6207: --
6208: ben_prtt_enrt_result_api.delete_enrollment
6209: (p_validate => false ,
6210: p_prtt_enrt_rslt_id => i.bkup_tbl_id,

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

6223: --
6224: -- When updating the corrected row, also correct the effective end date.
6225: -- Bug 7197868
6226: --
6227: if (i.effective_end_date = hr_api.g_eot
6228: and i.pen_effective_end_date <> i.effective_end_date) then
6229: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6230: --
6231: -- Bug 7197868

Line 6242: p_datetrack_mode => hr_api.g_future_change,

6238: p_effective_start_date => l_effective_start_date,
6239: p_effective_end_date => l_effective_end_date,
6240: p_object_version_number => l_object_version_number,
6241: p_effective_date => i.effective_start_date,
6242: p_datetrack_mode => hr_api.g_future_change,
6243: p_multi_row_validate => false);
6244: end if;
6245: --
6246: ben_prtt_enrt_result_api.update_prtt_enrt_result

Line 6258: ,p_datetrack_mode => hr_api.g_correction

6254: ,p_object_version_number => l_object_version_number
6255: ,p_effective_date => i.effective_start_date
6256: ,p_prtt_enrt_rslt_stat_cd => i.prtt_enrt_rslt_stat_cd
6257: ,p_enrt_mthd_cd => i.enrt_mthd_cd -- Bug 7137371
6258: ,p_datetrack_mode => hr_api.g_correction
6259: ,p_sspndd_flag => i.sspndd_flag
6260: ,p_multi_row_validate => FALSE
6261: ,p_business_group_id => p_business_group_id
6262: );

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

6266: -- only when p_copy_only = 'N' and l_prev_bkup_tbl_id <> i.bkup_tbl_id
6267: --changed 7176884 begin
6268: -- delete the row from the backup table -- 7197868
6269: --
6270: if (i.effective_end_date = hr_api.g_eot
6271: and i.pen_effective_end_date <> i.effective_end_date) then
6272: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6273: hr_utility.set_location(' i.per_in_ler_id ' || i.per_in_ler_id, 999 );
6274: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );

Line 6387: p_datetrack_mode => hr_api.g_FUTURE_CHANGE,

6383: p_effective_start_date => l_effective_start_date,
6384: p_effective_end_date => l_effective_end_date,
6385: p_object_version_number => l_bpl_from_backup.object_version_number,
6386: p_effective_date => l_bpl_from_backup.effective_start_date,
6387: p_datetrack_mode => hr_api.g_FUTURE_CHANGE,
6388: p_business_group_id => p_business_group_id
6389: );
6390: hr_utility.set_location('ACE Reopened = ' || l_bpl_from_backup.BKUP_TBL_ID, 9999);
6391: --

Line 6399: and effective_end_date = hr_api.g_eot;

6395: where cls.per_in_ler_id = l_bpl_from_backup.per_in_ler_id
6396: and cls.bkup_tbl_id = l_bpl_from_backup.bkup_tbl_id
6397: and cls.bkup_tbl_typ_cd = 'BEN_BNFT_PRVDD_LDGR_F'
6398: and effective_start_date = l_bpl_from_backup.effective_start_date
6399: and effective_end_date = hr_api.g_eot;
6400: --
6401: -- End Bug 6376239
6402: --
6403: end loop;

Line 6433: l_datetrack_mode := hr_api.g_future_change;

6429: if l_effective_date is not null then
6430: if l_prev_pk_id <> l_pk_id then
6431: -- Past records exist. So datetrack mode FUTURE_CHANGE.
6432: --
6433: l_datetrack_mode := hr_api.g_future_change;
6434: l_object_version_number := l_max_object_version_number;
6435: --
6436: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
6437: --

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

6432: --
6433: l_datetrack_mode := hr_api.g_future_change;
6434: l_object_version_number := l_max_object_version_number;
6435: --
6436: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
6437: --
6438: hr_utility.set_location('Deleting ledger='||to_char(l_bpl.bnft_prvdd_ldgr_id), 50);
6439: --
6440: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

Line 6469: p_datetrack_mode => hr_api.g_zap,

6465: p_effective_start_date => l_bpl.effective_start_date,
6466: p_effective_end_date => l_bpl.effective_end_date,
6467: p_object_version_number => l_bpl.object_version_number,
6468: p_effective_date => l_bpl_effective_date,
6469: p_datetrack_mode => hr_api.g_zap,
6470: p_business_group_id => p_business_group_id
6471: );
6472: l_prev_pk_id := l_pk_id;
6473: end if;