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

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

600: from ben_prtt_enrt_rslt_f pen
601: where pen.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
602: and pen.per_in_ler_id = v_per_in_ler_id
603: and pen.prtt_enrt_rslt_stat_cd IS NULL
604: and pen.effective_end_date = hr_api.g_eot ;
605: --
606: l_pen c_pen%ROWTYPE;
607: l_susp_epe c_epe%ROWTYPE;
608: l_interim_epe c_epe%ROWTYPE;

Line 1179: per.effective_end_date = hr_api.g_eot and

1175: per.person_id = pil.person_id and
1176: per.business_group_id = p_business_group_id and
1177: per.sspndd_flag = 'N' and
1178: per.prtt_enrt_rslt_stat_cd is null and
1179: per.effective_end_date = hr_api.g_eot and
1180: per.enrt_cvg_strt_dt < per.effective_end_date and
1181: (
1182: ( p_per_in_ler_id = per.per_in_ler_id and
1183: ( /* Case 4 */

Line 1184: per.enrt_cvg_thru_dt <> hr_api.g_eot or

1180: per.enrt_cvg_strt_dt < per.effective_end_date and
1181: (
1182: ( p_per_in_ler_id = per.per_in_ler_id and
1183: ( /* Case 4 */
1184: per.enrt_cvg_thru_dt <> hr_api.g_eot or
1185: ( /* Case 1,2*/
1186: ( exists (select 'x' from ben_prtt_enrt_rslt_f pen3
1187: where pen3.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id and
1188: pen3.prtt_enrt_rslt_stat_cd is null and

Line 1191: pen3.enrt_cvg_thru_dt = hr_api.g_eot and

1187: where pen3.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id and
1188: pen3.prtt_enrt_rslt_stat_cd is null and
1189: pen3.sspndd_flag = 'N' and
1190: pen3.effective_end_date < per.effective_start_date and
1191: pen3.enrt_cvg_thru_dt = hr_api.g_eot and
1192: pen3.per_in_ler_id <> per.per_in_ler_id
1193: )
1194: ) and
1195: per.enrt_cvg_thru_dt = hr_api.g_eot

Line 1195: per.enrt_cvg_thru_dt = hr_api.g_eot

1191: pen3.enrt_cvg_thru_dt = hr_api.g_eot and
1192: pen3.per_in_ler_id <> per.per_in_ler_id
1193: )
1194: ) and
1195: per.enrt_cvg_thru_dt = hr_api.g_eot
1196: )
1197: )
1198: )
1199: or

Line 1768: and susp.effective_end_date = hr_api.g_eot

1764: ben_prtt_enrt_rslt_f currently_susp
1765: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1766: and susp.per_in_ler_id = c_per_in_ler_id
1767: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1768: and susp.effective_end_date = hr_api.g_eot
1769: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1770: and susp.prtt_enrt_rslt_id = currently_susp.prtt_enrt_rslt_id
1771: and currently_susp.effective_end_date+1 = susp.effective_start_date
1772: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot

Line 1769: and susp.enrt_cvg_thru_dt = hr_api.g_eot

1765: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1766: and susp.per_in_ler_id = c_per_in_ler_id
1767: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1768: and susp.effective_end_date = hr_api.g_eot
1769: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1770: and susp.prtt_enrt_rslt_id = currently_susp.prtt_enrt_rslt_id
1771: and currently_susp.effective_end_date+1 = susp.effective_start_date
1772: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1773: and currently_susp.per_in_ler_id <> c_per_in_ler_id

Line 1772: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot

1768: and susp.effective_end_date = hr_api.g_eot
1769: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1770: and susp.prtt_enrt_rslt_id = currently_susp.prtt_enrt_rslt_id
1771: and currently_susp.effective_end_date+1 = susp.effective_start_date
1772: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1773: and currently_susp.per_in_ler_id <> c_per_in_ler_id
1774: and currently_susp.sspndd_flag = 'Y' ;
1775: */
1776: cursor c_cf_suspended(c_prtt_enrt_rslt_id number,

Line 1786: and susp.effective_end_date = hr_api.g_eot

1782: ben_prtt_enrt_rslt_f currently_susp
1783: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1784: and susp.per_in_ler_id = c_per_in_ler_id
1785: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1786: and susp.effective_end_date = hr_api.g_eot
1787: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1788: and currently_susp.prtt_enrt_rslt_stat_cd IS NULL
1789: and susp.person_id = currently_susp.person_id
1790: and (currently_susp.pl_id = susp.pl_id AND

Line 1787: and susp.enrt_cvg_thru_dt = hr_api.g_eot

1783: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1784: and susp.per_in_ler_id = c_per_in_ler_id
1785: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1786: and susp.effective_end_date = hr_api.g_eot
1787: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1788: and currently_susp.prtt_enrt_rslt_stat_cd IS NULL
1789: and susp.person_id = currently_susp.person_id
1790: and (currently_susp.pl_id = susp.pl_id AND
1791: (p_pgm_id IS NULL or currently_susp.pgm_id = susp.pgm_id) AND

Line 1793: and currently_susp.effective_end_date = hr_api.g_eot

1789: and susp.person_id = currently_susp.person_id
1790: and (currently_susp.pl_id = susp.pl_id AND
1791: (p_pgm_id IS NULL or currently_susp.pgm_id = susp.pgm_id) AND
1792: (p_oipl_id IS NULL or currently_susp.oipl_id = susp.oipl_id))
1793: and currently_susp.effective_end_date = hr_api.g_eot
1794: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1795: and currently_susp.per_in_ler_id <> c_per_in_ler_id
1796: and currently_susp.sspndd_flag = 'Y' ;
1797: --

Line 1794: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot

1790: and (currently_susp.pl_id = susp.pl_id AND
1791: (p_pgm_id IS NULL or currently_susp.pgm_id = susp.pgm_id) AND
1792: (p_oipl_id IS NULL or currently_susp.oipl_id = susp.oipl_id))
1793: and currently_susp.effective_end_date = hr_api.g_eot
1794: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1795: and currently_susp.per_in_ler_id <> c_per_in_ler_id
1796: and currently_susp.sspndd_flag = 'Y' ;
1797: --
1798: l_cf_suspended c_cf_suspended%ROWTYPE;

Line 1811: and interim.effective_end_date = hr_api.g_eot

1807: from ben_prtt_enrt_rslt_f interim,
1808: ben_elig_per_elctbl_chc new_epe
1809: where interim.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1810: and interim.per_in_ler_id <> c_per_in_ler_id
1811: and interim.effective_end_date = hr_api.g_eot
1812: and interim.enrt_cvg_thru_dt = hr_api.g_eot
1813: and new_epe.per_in_ler_id = c_per_in_ler_id
1814: and new_epe.pl_id = interim.pl_id
1815: and nvl(new_epe.pgm_id,-1) = nvl(interim.pgm_id,-1)

Line 1812: and interim.enrt_cvg_thru_dt = hr_api.g_eot

1808: ben_elig_per_elctbl_chc new_epe
1809: where interim.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1810: and interim.per_in_ler_id <> c_per_in_ler_id
1811: and interim.effective_end_date = hr_api.g_eot
1812: and interim.enrt_cvg_thru_dt = hr_api.g_eot
1813: and new_epe.per_in_ler_id = c_per_in_ler_id
1814: and new_epe.pl_id = interim.pl_id
1815: and nvl(new_epe.pgm_id,-1) = nvl(interim.pgm_id,-1)
1816: and nvl(new_epe.oipl_id,-1)= nvl(interim.oipl_id,-1)

Line 2629: l_epe.enrt_cvg_thru_dt = hr_api.g_eot then

2625: /*
2626: if nvl(l_epe.pgm_id,-1) = nvl(l_epe.pen_pgm_id,-1) and
2627: nvl(l_epe.pl_id,-1) = nvl(l_epe.pen_pl_id,-1) and
2628: nvl(l_epe.oipl_id,-1) = nvl(l_epe.pen_oipl_id,-1) and
2629: l_epe.enrt_cvg_thru_dt = hr_api.g_eot then
2630: g_use_new_result:=false;
2631: --
2632: hr_utility.set_location('g_use_new_result false',333);
2633: --

Line 2676: ,p_datetrack_mode => hr_api.g_update

2672: ,p_Ann_rt_val7 => l_rt(7).ann_dflt_val
2673: ,p_Ann_rt_val8 => l_rt(8).ann_dflt_val
2674: ,p_Ann_rt_val9 => l_rt(9).ann_dflt_val
2675: ,p_Ann_rt_val10 => l_rt(10).ann_dflt_val
2676: ,p_datetrack_mode => hr_api.g_update
2677: ,p_suspend_flag => l_suspend_flag
2678: ,p_prtt_enrt_interim_id => l_prtt_enrt_interim_id
2679: ,P_PRTT_RT_VAL_ID1 => l_dump_num
2680: ,P_PRTT_RT_VAL_ID2 => l_dump_num

Line 2721: p_enrt_cvg_strt_dt in date default hr_api.g_date,

2717: p_RPLCS_SSPNDD_RSLT_ID in number,
2718: p_object_version_number in out nocopy number,
2719: p_datetrack_mode in varchar2,
2720: p_ENRT_PL_OPT_FLAG in varchar2 default 'N',
2721: p_enrt_cvg_strt_dt in date default hr_api.g_date,
2722: p_enrt_cvg_thru_dt in date default hr_api.g_date,
2723: p_pgm_id in number default NULL,
2724: p_pl_id in number default NULL,
2725: p_person_id in number

Line 2722: p_enrt_cvg_thru_dt in date default hr_api.g_date,

2718: p_object_version_number in out nocopy number,
2719: p_datetrack_mode in varchar2,
2720: p_ENRT_PL_OPT_FLAG in varchar2 default 'N',
2721: p_enrt_cvg_strt_dt in date default hr_api.g_date,
2722: p_enrt_cvg_thru_dt in date default hr_api.g_date,
2723: p_pgm_id in number default NULL,
2724: p_pl_id in number default NULL,
2725: p_person_id in number
2726: ) is

Line 2741: pen.effective_start_date and nvl(pen.effective_end_date,hr_api.g_eot)

2737: And pen.person_id = p_person_id
2738: And nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
2739: And pen.pl_id = p_pl_id
2740: And p_effective_date between
2741: pen.effective_start_date and nvl(pen.effective_end_date,hr_api.g_eot)
2742: And pen.sspndd_flag = 'Y'
2743: and pen.prtt_enrt_rslt_stat_cd is null
2744: And pen.oipl_id is not NULL
2745: ;

Line 2956: and prv.rt_end_dt=hr_api.g_eot

2952: ben_acty_base_rt_f abr,
2953: pay_element_entry_values_f pev,
2954: pay_element_entries_f pee
2955: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
2956: and prv.rt_end_dt=hr_api.g_eot
2957: and prv.business_group_id = p_business_group_id
2958: and prv.prtt_rt_val_stat_cd is null
2959: and abr.acty_base_rt_id=prv.acty_base_rt_id
2960: and abr.business_group_id = p_business_group_id

Line 3020: and pen2.enrt_cvg_thru_dt <> hr_api.g_eot

3016: and exists (select null from ben_prtt_enrt_rslt_f pen2
3017: where pen2.prtt_enrt_rslt_id = pen.RPLCS_SSPNDD_RSLT_ID
3018: and pen2.prtt_enrt_rslt_stat_cd is null
3019: and pen2.per_in_ler_id = p_per_in_ler_id
3020: and pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3021: and pen2.effective_end_date = hr_api.g_eot);
3022: --
3023: cursor c_enrt_rslt (p_prtt_enrt_rslt_id number) is
3024: select pen.effective_start_date,

Line 3021: and pen2.effective_end_date = hr_api.g_eot);

3017: where pen2.prtt_enrt_rslt_id = pen.RPLCS_SSPNDD_RSLT_ID
3018: and pen2.prtt_enrt_rslt_stat_cd is null
3019: and pen2.per_in_ler_id = p_per_in_ler_id
3020: and pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3021: and pen2.effective_end_date = hr_api.g_eot);
3022: --
3023: cursor c_enrt_rslt (p_prtt_enrt_rslt_id number) is
3024: select pen.effective_start_date,
3025: pen.effective_end_date,

Line 3032: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot

3028: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3029: and pen.prtt_enrt_rslt_stat_cd is null
3030: and pen.effective_end_date = (select pen2.effective_start_date - 1
3031: from ben_prtt_enrt_rslt_f pen2
3032: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3033: and pen2.effective_end_date = hr_api.g_eot
3034: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3035: and pen2.prtt_enrt_rslt_stat_cd is null);
3036: --

Line 3033: and pen2.effective_end_date = hr_api.g_eot

3029: and pen.prtt_enrt_rslt_stat_cd is null
3030: and pen.effective_end_date = (select pen2.effective_start_date - 1
3031: from ben_prtt_enrt_rslt_f pen2
3032: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3033: and pen2.effective_end_date = hr_api.g_eot
3034: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3035: and pen2.prtt_enrt_rslt_stat_cd is null);
3036: --
3037: cursor c_prv_sspndd(p_pen_id number

Line 3081: and prv.rt_end_dt <> hr_api.g_eot

3077: where prv.per_in_ler_id = p_per_in_ler_id
3078: and prv.per_in_ler_id = pil.per_in_ler_id
3079: and prv.prtt_rt_val_stat_cd is null
3080: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3081: and prv.rt_end_dt <> hr_api.g_eot
3082: and prv.rt_strt_dt = (select max(rt_strt_dt)
3083: from ben_prtt_rt_val
3084: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3085: and rt_end_dt <> hr_api.g_eot

Line 3085: and rt_end_dt <> hr_api.g_eot

3081: and prv.rt_end_dt <> hr_api.g_eot
3082: and prv.rt_strt_dt = (select max(rt_strt_dt)
3083: from ben_prtt_rt_val
3084: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3085: and rt_end_dt <> hr_api.g_eot
3086: and prtt_rt_val_stat_cd is null)
3087: ;
3088: --
3089: l_pea c_pea%rowtype ;

Line 3118: hr_api.mandatory_arg_error

3114: hr_utility.set_location ('Entering '|| l_proc, 10);
3115: --
3116: -- Check all the input parameters are not null
3117: --
3118: hr_api.mandatory_arg_error
3119: (p_api_name => l_proc
3120: ,p_argument => 'p_prtt_enrt_rslt_id'
3121: ,p_argument_value => p_prtt_enrt_rslt_id);
3122: hr_api.mandatory_arg_error

Line 3122: hr_api.mandatory_arg_error

3118: hr_api.mandatory_arg_error
3119: (p_api_name => l_proc
3120: ,p_argument => 'p_prtt_enrt_rslt_id'
3121: ,p_argument_value => p_prtt_enrt_rslt_id);
3122: hr_api.mandatory_arg_error
3123: (p_api_name => l_proc
3124: ,p_argument => 'p_effective_date'
3125: ,p_argument_value => p_effective_date);
3126: hr_api.mandatory_arg_error

Line 3126: hr_api.mandatory_arg_error

3122: hr_api.mandatory_arg_error
3123: (p_api_name => l_proc
3124: ,p_argument => 'p_effective_date'
3125: ,p_argument_value => p_effective_date);
3126: hr_api.mandatory_arg_error
3127: (p_api_name => l_proc
3128: ,p_argument => 'p_business_group_id'
3129: ,p_argument_value => p_business_group_id);
3130: hr_api.mandatory_arg_error

Line 3130: hr_api.mandatory_arg_error

3126: hr_api.mandatory_arg_error
3127: (p_api_name => l_proc
3128: ,p_argument => 'p_business_group_id'
3129: ,p_argument_value => p_business_group_id);
3130: hr_api.mandatory_arg_error
3131: (p_api_name => l_proc
3132: ,p_argument => 'p_object_version_number'
3133: ,p_argument_value => p_object_version_number);
3134: hr_api.mandatory_arg_error

Line 3134: hr_api.mandatory_arg_error

3130: hr_api.mandatory_arg_error
3131: (p_api_name => l_proc
3132: ,p_argument => 'p_object_version_number'
3133: ,p_argument_value => p_object_version_number);
3134: hr_api.mandatory_arg_error
3135: (p_api_name => l_proc
3136: ,p_argument => 'p_datetrack_mode'
3137: ,p_argument_value => p_datetrack_mode);
3138: --

Line 3421: p_datetrack_mode => hr_api.g_future_change,

3417: p_effective_start_date => l_effective_start_date,
3418: p_effective_end_date => l_effective_end_date,
3419: p_object_version_number => l_enrt_rslt.object_version_number,
3420: p_effective_date => l_enrt_rslt.effective_end_date,
3421: p_datetrack_mode => hr_api.g_future_change,
3422: p_multi_row_validate => FALSE);
3423: --
3424: open c_prv(l_rplcs_sspndd_rslt_id, l_pen.per_in_ler_id);
3425: loop

Line 3434: ,p_rt_end_dt => hr_api.g_eot

3430: ben_prtt_rt_val_api.update_prtt_rt_val
3431: (p_validate => FALSE
3432: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
3433: ,p_object_version_number => l_prv.object_version_number
3434: ,p_rt_end_dt => hr_api.g_eot
3435: ,p_prtt_rt_val_stat_cd => null
3436: ,p_ended_per_in_ler_id => null
3437: ,p_person_id => l_prv.person_id
3438: ,p_business_group_id => p_business_group_id

Line 3471: ,p_datetrack_mode => hr_api.g_correction

3467: ,p_business_group_id => p_business_group_id
3468: ,p_effective_start_date => l_pea_effective_start_date
3469: ,p_effective_end_date => l_pea_effective_end_date
3470: ,p_object_version_number => l_pea.pea_object_version_number
3471: ,p_datetrack_mode => hr_api.g_correction
3472: );
3473: hr_utility.set_location('After ben_prtt_enrt_actn_api.update_prtt_enrt_actn ',20);
3474: --
3475: end loop ;

Line 3661: -- and prv.rt_end_dt=hr_api.g_eot

3657: ben_acty_base_rt_f abr
3658: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3659: and prv.per_in_ler_id = l_per_in_ler_id
3660: and prv.rt_strt_dt <= prv.rt_end_dt
3661: -- and prv.rt_end_dt=hr_api.g_eot
3662: and prv.business_group_id = p_business_group_id
3663: and prv.prtt_rt_val_stat_cd is null
3664: and abr.acty_base_rt_id=prv.acty_base_rt_id
3665: and abr.business_group_id = p_business_group_id

Line 3724: and ecd.cvg_thru_dt = hr_api.g_eot

3720: From ben_elig_cvrd_dpnt_f ecd,
3721: ben_per_in_ler pil
3722: Where ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3723: and ecd.cvg_strt_dt is not null
3724: and ecd.cvg_thru_dt = hr_api.g_eot
3725: and ecd.business_group_id = p_business_group_id
3726: and p_effective_date between
3727: ecd.effective_start_date and ecd.effective_end_date
3728: and pil.per_in_ler_id=ecd.per_in_ler_id

Line 3842: hr_api.mandatory_arg_error(p_api_name => l_proc,

3838:
3839: --
3840: -- Check all the input parameters are not null
3841: --
3842: hr_api.mandatory_arg_error(p_api_name => l_proc,
3843: p_argument => 'p_prtt_enrt_rslt_id',
3844: p_argument_value => p_prtt_enrt_rslt_id);
3845: --
3846: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 3846: hr_api.mandatory_arg_error(p_api_name => l_proc,

3842: hr_api.mandatory_arg_error(p_api_name => l_proc,
3843: p_argument => 'p_prtt_enrt_rslt_id',
3844: p_argument_value => p_prtt_enrt_rslt_id);
3845: --
3846: hr_api.mandatory_arg_error(p_api_name => l_proc,
3847: p_argument => 'p_effective_date',
3848: p_argument_value => p_effective_date);
3849: --
3850: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 3850: hr_api.mandatory_arg_error(p_api_name => l_proc,

3846: hr_api.mandatory_arg_error(p_api_name => l_proc,
3847: p_argument => 'p_effective_date',
3848: p_argument_value => p_effective_date);
3849: --
3850: hr_api.mandatory_arg_error(p_api_name => l_proc,
3851: p_argument => 'p_business_group_id',
3852: p_argument_value => p_business_group_id);
3853: --
3854: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 3854: hr_api.mandatory_arg_error(p_api_name => l_proc,

3850: hr_api.mandatory_arg_error(p_api_name => l_proc,
3851: p_argument => 'p_business_group_id',
3852: p_argument_value => p_business_group_id);
3853: --
3854: hr_api.mandatory_arg_error(p_api_name => l_proc,
3855: p_argument => 'p_object_version_number',
3856: p_argument_value => p_object_version_number);
3857: --
3858: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 3858: hr_api.mandatory_arg_error(p_api_name => l_proc,

3854: hr_api.mandatory_arg_error(p_api_name => l_proc,
3855: p_argument => 'p_object_version_number',
3856: p_argument_value => p_object_version_number);
3857: --
3858: hr_api.mandatory_arg_error(p_api_name => l_proc,
3859: p_argument => 'p_datetrack_mode',
3860: p_argument_value => p_datetrack_mode);
3861: --
3862: l_last_place := 'Fetching record from ben_prtt_enrt_rslt_f';

Line 3969: ,P_DATETRACK_MODE => hr_api.g_delete

3965: ,P_EFFECTIVE_START_DATE => l_interim.effective_start_date
3966: ,P_EFFECTIVE_END_DATE => l_interim.effective_end_date
3967: ,P_OBJECT_VERSION_NUMBER => l_interim.object_version_number
3968: ,P_EFFECTIVE_DATE => p_effective_date
3969: ,P_DATETRACK_MODE => hr_api.g_delete
3970: ,P_MULTI_ROW_VALIDATE => FALSE
3971: ,p_source => 'bensuenr'
3972: );
3973: End if;

Line 4101: l_datetrack_mode := hr_api.g_correction;

4097: --
4098: For l_dpnt in c_dpnt(l_interim.prtt_enrt_rslt_id) loop
4099: --
4100: If (p_effective_date = l_dpnt.effective_start_date) then
4101: l_datetrack_mode := hr_api.g_correction;
4102: Else
4103: l_datetrack_mode := hr_api.g_update;
4104: End if;
4105: --

Line 4103: l_datetrack_mode := hr_api.g_update;

4099: --
4100: If (p_effective_date = l_dpnt.effective_start_date) then
4101: l_datetrack_mode := hr_api.g_correction;
4102: Else
4103: l_datetrack_mode := hr_api.g_update;
4104: End if;
4105: --
4106: l_last_place := 'Calling update_elig_cvrd_dpnt';
4107: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt

Line 4123: l_datetrack_mode := hr_api.g_correction;

4119: --
4120: -- Update interim result row.
4121: --
4122: if l_unsusp_cvg_start_date = l_interim.enrt_cvg_strt_dt then
4123: l_datetrack_mode := hr_api.g_correction;
4124: Else
4125: l_datetrack_mode := hr_api.g_update;
4126: End if;
4127: hr_utility.set_location('l_cvg_thru_dt'||l_cvg_thru_dt,777);

Line 4125: l_datetrack_mode := hr_api.g_update;

4121: --
4122: if l_unsusp_cvg_start_date = l_interim.enrt_cvg_strt_dt then
4123: l_datetrack_mode := hr_api.g_correction;
4124: Else
4125: l_datetrack_mode := hr_api.g_update;
4126: End if;
4127: hr_utility.set_location('l_cvg_thru_dt'||l_cvg_thru_dt,777);
4128: --
4129: Update_sspndd_flag

Line 4149: ,p_datetrack_mode => hr_api.g_delete

4145: (p_prtt_enrt_rslt_id => l_interim.prtt_enrt_rslt_id
4146: ,p_effective_date => p_effective_date
4147: ,p_business_group_id => p_business_group_id
4148: ,p_validate => FALSE
4149: ,p_datetrack_mode => hr_api.g_delete
4150: );
4151: --
4152: End if;
4153: --

Line 4351: if l_ee_end_date <> hr_api.g_eot and

4347: else
4348: open c_ee(l_prv.element_entry_value_id,l_rec_rt_strt_dt);
4349: fetch c_ee into l_ee_end_date;
4350: close c_ee;
4351: if l_ee_end_date <> hr_api.g_eot and
4352: l_prv.rt_end_dt = hr_api.g_eot then
4353: ben_element_entry.reopen_closed_enrollment(
4354: p_business_group_id => p_business_group_id
4355: ,p_person_id => l_pen.person_id

Line 4352: l_prv.rt_end_dt = hr_api.g_eot then

4348: open c_ee(l_prv.element_entry_value_id,l_rec_rt_strt_dt);
4349: fetch c_ee into l_ee_end_date;
4350: close c_ee;
4351: if l_ee_end_date <> hr_api.g_eot and
4352: l_prv.rt_end_dt = hr_api.g_eot then
4353: ben_element_entry.reopen_closed_enrollment(
4354: p_business_group_id => p_business_group_id
4355: ,p_person_id => l_pen.person_id
4356: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id

Line 4429: l_datetrack_mode := hr_api.g_correction;

4425: -- certifications, we need to derive it here.
4426: --
4427: IF (p_effective_date = l_pen.effective_start_date) Then
4428: --
4429: l_datetrack_mode := hr_api.g_correction;
4430: --
4431: ELSIF p_effective_date > l_pen.effective_start_date then
4432: --
4433: l_datetrack_mode := hr_api.g_update;

Line 4433: l_datetrack_mode := hr_api.g_update;

4429: l_datetrack_mode := hr_api.g_correction;
4430: --
4431: ELSIF p_effective_date > l_pen.effective_start_date then
4432: --
4433: l_datetrack_mode := hr_api.g_update;
4434: --
4435: ELSE
4436: --
4437: l_datetrack_mode := p_datetrack_mode;

Line 4598: l_datetrack_mode := hr_api.g_correction;

4594: --
4595: if l_dpnt.cvg_strt_dt <> l_pen.enrt_cvg_strt_dt and l_update_dates then
4596: --
4597: If (p_effective_date = l_dpnt.effective_start_date) then
4598: l_datetrack_mode := hr_api.g_correction;
4599: Else
4600: l_datetrack_mode := hr_api.g_update;
4601: End if;
4602: --

Line 4600: l_datetrack_mode := hr_api.g_update;

4596: --
4597: If (p_effective_date = l_dpnt.effective_start_date) then
4598: l_datetrack_mode := hr_api.g_correction;
4599: Else
4600: l_datetrack_mode := hr_api.g_update;
4601: End if;
4602: --
4603: l_last_place := 'Calling update_elig_cvrd_dpnt';
4604: --