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 641: and pen.effective_end_date = hr_api.g_eot ;

637: from ben_prtt_enrt_rslt_f pen
638: where pen.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
639: and pen.per_in_ler_id = v_per_in_ler_id
640: and pen.prtt_enrt_rslt_stat_cd IS NULL
641: and pen.effective_end_date = hr_api.g_eot ;
642: --
643: l_pen c_pen%ROWTYPE;
644: l_susp_epe c_epe%ROWTYPE;
645: l_interim_epe c_epe%ROWTYPE;

Line 1235: per.effective_end_date = hr_api.g_eot and

1231: per.person_id = pil.person_id and
1232: per.business_group_id = p_business_group_id and
1233: per.sspndd_flag = 'N' and
1234: per.prtt_enrt_rslt_stat_cd is null and
1235: per.effective_end_date = hr_api.g_eot and
1236: per.enrt_cvg_strt_dt < per.effective_end_date and
1237: (
1238: ( p_per_in_ler_id = per.per_in_ler_id and
1239: ( /* Case 4 */

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

1236: per.enrt_cvg_strt_dt < per.effective_end_date and
1237: (
1238: ( p_per_in_ler_id = per.per_in_ler_id and
1239: ( /* Case 4 */
1240: per.enrt_cvg_thru_dt <> hr_api.g_eot or
1241: ( /* Case 1,2*/
1242: ( exists (select 'x' from ben_prtt_enrt_rslt_f pen3
1243: where pen3.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id and
1244: pen3.prtt_enrt_rslt_stat_cd is null and

Line 1247: pen3.enrt_cvg_thru_dt = hr_api.g_eot and

1243: where pen3.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id and
1244: pen3.prtt_enrt_rslt_stat_cd is null and
1245: pen3.sspndd_flag = 'N' and
1246: pen3.effective_end_date < per.effective_start_date and
1247: pen3.enrt_cvg_thru_dt = hr_api.g_eot and
1248: pen3.per_in_ler_id <> per.per_in_ler_id
1249: )
1250: ) and
1251: per.enrt_cvg_thru_dt = hr_api.g_eot

Line 1251: per.enrt_cvg_thru_dt = hr_api.g_eot

1247: pen3.enrt_cvg_thru_dt = hr_api.g_eot and
1248: pen3.per_in_ler_id <> per.per_in_ler_id
1249: )
1250: ) and
1251: per.enrt_cvg_thru_dt = hr_api.g_eot
1252: )
1253: )
1254: )
1255: or

Line 1844: and susp.effective_end_date = hr_api.g_eot

1840: ben_prtt_enrt_rslt_f currently_susp
1841: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1842: and susp.per_in_ler_id = c_per_in_ler_id
1843: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1844: and susp.effective_end_date = hr_api.g_eot
1845: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1846: and susp.prtt_enrt_rslt_id = currently_susp.prtt_enrt_rslt_id
1847: and currently_susp.effective_end_date+1 = susp.effective_start_date
1848: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot

Line 1845: and susp.enrt_cvg_thru_dt = hr_api.g_eot

1841: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1842: and susp.per_in_ler_id = c_per_in_ler_id
1843: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1844: and susp.effective_end_date = hr_api.g_eot
1845: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1846: and susp.prtt_enrt_rslt_id = currently_susp.prtt_enrt_rslt_id
1847: and currently_susp.effective_end_date+1 = susp.effective_start_date
1848: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1849: and currently_susp.per_in_ler_id <> c_per_in_ler_id

Line 1848: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot

1844: and susp.effective_end_date = hr_api.g_eot
1845: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1846: and susp.prtt_enrt_rslt_id = currently_susp.prtt_enrt_rslt_id
1847: and currently_susp.effective_end_date+1 = susp.effective_start_date
1848: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1849: and currently_susp.per_in_ler_id <> c_per_in_ler_id
1850: and currently_susp.sspndd_flag = 'Y' ;
1851: */
1852: cursor c_cf_suspended(c_prtt_enrt_rslt_id number,

Line 1862: and susp.effective_end_date = hr_api.g_eot

1858: ben_prtt_enrt_rslt_f currently_susp
1859: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1860: and susp.per_in_ler_id = c_per_in_ler_id
1861: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1862: and susp.effective_end_date = hr_api.g_eot
1863: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1864: and currently_susp.prtt_enrt_rslt_stat_cd IS NULL
1865: and susp.person_id = currently_susp.person_id
1866: and (currently_susp.pl_id = susp.pl_id AND

Line 1863: and susp.enrt_cvg_thru_dt = hr_api.g_eot

1859: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1860: and susp.per_in_ler_id = c_per_in_ler_id
1861: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1862: and susp.effective_end_date = hr_api.g_eot
1863: and susp.enrt_cvg_thru_dt = hr_api.g_eot
1864: and currently_susp.prtt_enrt_rslt_stat_cd IS NULL
1865: and susp.person_id = currently_susp.person_id
1866: and (currently_susp.pl_id = susp.pl_id AND
1867: (p_pgm_id IS NULL or currently_susp.pgm_id = susp.pgm_id) AND

Line 1869: and currently_susp.effective_end_date = hr_api.g_eot

1865: and susp.person_id = currently_susp.person_id
1866: and (currently_susp.pl_id = susp.pl_id AND
1867: (p_pgm_id IS NULL or currently_susp.pgm_id = susp.pgm_id) AND
1868: (p_oipl_id IS NULL or currently_susp.oipl_id = susp.oipl_id))
1869: and currently_susp.effective_end_date = hr_api.g_eot
1870: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1871: and currently_susp.per_in_ler_id <> c_per_in_ler_id
1872: and currently_susp.sspndd_flag = 'Y' ;
1873: --

Line 1870: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot

1866: and (currently_susp.pl_id = susp.pl_id AND
1867: (p_pgm_id IS NULL or currently_susp.pgm_id = susp.pgm_id) AND
1868: (p_oipl_id IS NULL or currently_susp.oipl_id = susp.oipl_id))
1869: and currently_susp.effective_end_date = hr_api.g_eot
1870: and currently_susp.enrt_cvg_thru_dt = hr_api.g_eot
1871: and currently_susp.per_in_ler_id <> c_per_in_ler_id
1872: and currently_susp.sspndd_flag = 'Y' ;
1873: --
1874: l_cf_suspended c_cf_suspended%ROWTYPE;

Line 1887: and interim.effective_end_date = hr_api.g_eot

1883: from ben_prtt_enrt_rslt_f interim,
1884: ben_elig_per_elctbl_chc new_epe
1885: where interim.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1886: and interim.per_in_ler_id <> c_per_in_ler_id
1887: and interim.effective_end_date = hr_api.g_eot
1888: and interim.enrt_cvg_thru_dt = hr_api.g_eot
1889: and new_epe.per_in_ler_id = c_per_in_ler_id
1890: and new_epe.pl_id = interim.pl_id
1891: and nvl(new_epe.pgm_id,-1) = nvl(interim.pgm_id,-1)

Line 1888: and interim.enrt_cvg_thru_dt = hr_api.g_eot

1884: ben_elig_per_elctbl_chc new_epe
1885: where interim.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1886: and interim.per_in_ler_id <> c_per_in_ler_id
1887: and interim.effective_end_date = hr_api.g_eot
1888: and interim.enrt_cvg_thru_dt = hr_api.g_eot
1889: and new_epe.per_in_ler_id = c_per_in_ler_id
1890: and new_epe.pl_id = interim.pl_id
1891: and nvl(new_epe.pgm_id,-1) = nvl(interim.pgm_id,-1)
1892: and nvl(new_epe.oipl_id,-1)= nvl(interim.oipl_id,-1)

Line 2775: l_epe.enrt_cvg_thru_dt = hr_api.g_eot then

2771: /*
2772: if nvl(l_epe.pgm_id,-1) = nvl(l_epe.pen_pgm_id,-1) and
2773: nvl(l_epe.pl_id,-1) = nvl(l_epe.pen_pl_id,-1) and
2774: nvl(l_epe.oipl_id,-1) = nvl(l_epe.pen_oipl_id,-1) and
2775: l_epe.enrt_cvg_thru_dt = hr_api.g_eot then
2776: g_use_new_result:=false;
2777: --
2778: hr_utility.set_location('g_use_new_result false',333);
2779: --

Line 2822: ,p_datetrack_mode => hr_api.g_update

2818: ,p_Ann_rt_val7 => l_rt(7).ann_dflt_val
2819: ,p_Ann_rt_val8 => l_rt(8).ann_dflt_val
2820: ,p_Ann_rt_val9 => l_rt(9).ann_dflt_val
2821: ,p_Ann_rt_val10 => l_rt(10).ann_dflt_val
2822: ,p_datetrack_mode => hr_api.g_update
2823: ,p_suspend_flag => l_suspend_flag
2824: ,p_prtt_enrt_interim_id => l_prtt_enrt_interim_id
2825: ,P_PRTT_RT_VAL_ID1 => l_dump_num
2826: ,P_PRTT_RT_VAL_ID2 => l_dump_num

Line 2867: p_enrt_cvg_strt_dt in date default hr_api.g_date,

2863: p_RPLCS_SSPNDD_RSLT_ID in number,
2864: p_object_version_number in out nocopy number,
2865: p_datetrack_mode in varchar2,
2866: p_ENRT_PL_OPT_FLAG in varchar2 default 'N',
2867: p_enrt_cvg_strt_dt in date default hr_api.g_date,
2868: p_enrt_cvg_thru_dt in date default hr_api.g_date,
2869: p_pgm_id in number default NULL,
2870: p_pl_id in number default NULL,
2871: p_person_id in number

Line 2868: p_enrt_cvg_thru_dt in date default hr_api.g_date,

2864: p_object_version_number in out nocopy number,
2865: p_datetrack_mode in varchar2,
2866: p_ENRT_PL_OPT_FLAG in varchar2 default 'N',
2867: p_enrt_cvg_strt_dt in date default hr_api.g_date,
2868: p_enrt_cvg_thru_dt in date default hr_api.g_date,
2869: p_pgm_id in number default NULL,
2870: p_pl_id in number default NULL,
2871: p_person_id in number
2872: ) is

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

2883: And pen.person_id = p_person_id
2884: And nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
2885: And pen.pl_id = p_pl_id
2886: And p_effective_date between
2887: pen.effective_start_date and nvl(pen.effective_end_date,hr_api.g_eot)
2888: And pen.sspndd_flag = 'Y'
2889: and pen.prtt_enrt_rslt_stat_cd is null
2890: And pen.oipl_id is not NULL
2891: ;

Line 3102: and prv.rt_end_dt=hr_api.g_eot

3098: ben_acty_base_rt_f abr,
3099: pay_element_entry_values_f pev,
3100: pay_element_entries_f pee
3101: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3102: and prv.rt_end_dt=hr_api.g_eot
3103: and prv.business_group_id = p_business_group_id
3104: and prv.prtt_rt_val_stat_cd is null
3105: and abr.acty_base_rt_id=prv.acty_base_rt_id
3106: and abr.business_group_id = p_business_group_id

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

3162: and exists (select null from ben_prtt_enrt_rslt_f pen2
3163: where pen2.prtt_enrt_rslt_id = pen.RPLCS_SSPNDD_RSLT_ID
3164: and pen2.prtt_enrt_rslt_stat_cd is null
3165: and pen2.per_in_ler_id = p_per_in_ler_id
3166: and pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3167: and pen2.effective_end_date = hr_api.g_eot);
3168: --
3169: cursor c_enrt_rslt (p_prtt_enrt_rslt_id number) is
3170: select pen.effective_start_date,

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

3163: where pen2.prtt_enrt_rslt_id = pen.RPLCS_SSPNDD_RSLT_ID
3164: and pen2.prtt_enrt_rslt_stat_cd is null
3165: and pen2.per_in_ler_id = p_per_in_ler_id
3166: and pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3167: and pen2.effective_end_date = hr_api.g_eot);
3168: --
3169: cursor c_enrt_rslt (p_prtt_enrt_rslt_id number) is
3170: select pen.effective_start_date,
3171: pen.effective_end_date,

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

3174: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3175: and pen.prtt_enrt_rslt_stat_cd is null
3176: and pen.effective_end_date = (select pen2.effective_start_date - 1
3177: from ben_prtt_enrt_rslt_f pen2
3178: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3179: and pen2.effective_end_date = hr_api.g_eot
3180: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3181: and pen2.prtt_enrt_rslt_stat_cd is null);
3182: --

Line 3179: and pen2.effective_end_date = hr_api.g_eot

3175: and pen.prtt_enrt_rslt_stat_cd is null
3176: and pen.effective_end_date = (select pen2.effective_start_date - 1
3177: from ben_prtt_enrt_rslt_f pen2
3178: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3179: and pen2.effective_end_date = hr_api.g_eot
3180: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3181: and pen2.prtt_enrt_rslt_stat_cd is null);
3182: --
3183: cursor c_prv_sspndd(p_pen_id number

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

3223: where prv.per_in_ler_id = p_per_in_ler_id
3224: and prv.per_in_ler_id = pil.per_in_ler_id
3225: and prv.prtt_rt_val_stat_cd is null
3226: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3227: and prv.rt_end_dt <> hr_api.g_eot
3228: and prv.rt_strt_dt = (select max(rt_strt_dt)
3229: from ben_prtt_rt_val
3230: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3231: and rt_end_dt <> hr_api.g_eot

Line 3231: and rt_end_dt <> hr_api.g_eot

3227: and prv.rt_end_dt <> hr_api.g_eot
3228: and prv.rt_strt_dt = (select max(rt_strt_dt)
3229: from ben_prtt_rt_val
3230: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3231: and rt_end_dt <> hr_api.g_eot
3232: and prtt_rt_val_stat_cd is null)
3233: ;
3234: --
3235: l_pea c_pea%rowtype ;

Line 3264: hr_api.mandatory_arg_error

3260: hr_utility.set_location ('Entering '|| l_proc, 10);
3261: --
3262: -- Check all the input parameters are not null
3263: --
3264: hr_api.mandatory_arg_error
3265: (p_api_name => l_proc
3266: ,p_argument => 'p_prtt_enrt_rslt_id'
3267: ,p_argument_value => p_prtt_enrt_rslt_id);
3268: hr_api.mandatory_arg_error

Line 3268: hr_api.mandatory_arg_error

3264: hr_api.mandatory_arg_error
3265: (p_api_name => l_proc
3266: ,p_argument => 'p_prtt_enrt_rslt_id'
3267: ,p_argument_value => p_prtt_enrt_rslt_id);
3268: hr_api.mandatory_arg_error
3269: (p_api_name => l_proc
3270: ,p_argument => 'p_effective_date'
3271: ,p_argument_value => p_effective_date);
3272: hr_api.mandatory_arg_error

Line 3272: hr_api.mandatory_arg_error

3268: hr_api.mandatory_arg_error
3269: (p_api_name => l_proc
3270: ,p_argument => 'p_effective_date'
3271: ,p_argument_value => p_effective_date);
3272: hr_api.mandatory_arg_error
3273: (p_api_name => l_proc
3274: ,p_argument => 'p_business_group_id'
3275: ,p_argument_value => p_business_group_id);
3276: hr_api.mandatory_arg_error

Line 3276: hr_api.mandatory_arg_error

3272: hr_api.mandatory_arg_error
3273: (p_api_name => l_proc
3274: ,p_argument => 'p_business_group_id'
3275: ,p_argument_value => p_business_group_id);
3276: hr_api.mandatory_arg_error
3277: (p_api_name => l_proc
3278: ,p_argument => 'p_object_version_number'
3279: ,p_argument_value => p_object_version_number);
3280: hr_api.mandatory_arg_error

Line 3280: hr_api.mandatory_arg_error

3276: hr_api.mandatory_arg_error
3277: (p_api_name => l_proc
3278: ,p_argument => 'p_object_version_number'
3279: ,p_argument_value => p_object_version_number);
3280: hr_api.mandatory_arg_error
3281: (p_api_name => l_proc
3282: ,p_argument => 'p_datetrack_mode'
3283: ,p_argument_value => p_datetrack_mode);
3284: --

Line 3567: p_datetrack_mode => hr_api.g_future_change,

3563: p_effective_start_date => l_effective_start_date,
3564: p_effective_end_date => l_effective_end_date,
3565: p_object_version_number => l_enrt_rslt.object_version_number,
3566: p_effective_date => l_enrt_rslt.effective_end_date,
3567: p_datetrack_mode => hr_api.g_future_change,
3568: p_multi_row_validate => FALSE);
3569: --
3570: open c_prv(l_rplcs_sspndd_rslt_id, l_pen.per_in_ler_id);
3571: loop

Line 3580: ,p_rt_end_dt => hr_api.g_eot

3576: ben_prtt_rt_val_api.update_prtt_rt_val
3577: (p_validate => FALSE
3578: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
3579: ,p_object_version_number => l_prv.object_version_number
3580: ,p_rt_end_dt => hr_api.g_eot
3581: ,p_prtt_rt_val_stat_cd => null
3582: ,p_ended_per_in_ler_id => null
3583: ,p_person_id => l_prv.person_id
3584: ,p_business_group_id => p_business_group_id

Line 3617: ,p_datetrack_mode => hr_api.g_correction

3613: ,p_business_group_id => p_business_group_id
3614: ,p_effective_start_date => l_pea_effective_start_date
3615: ,p_effective_end_date => l_pea_effective_end_date
3616: ,p_object_version_number => l_pea.pea_object_version_number
3617: ,p_datetrack_mode => hr_api.g_correction
3618: );
3619: hr_utility.set_location('After ben_prtt_enrt_actn_api.update_prtt_enrt_actn ',20);
3620: --
3621: end loop ;

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

3826: ben_acty_base_rt_f abr
3827: where prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3828: and prv.per_in_ler_id = l_per_in_ler_id
3829: and prv.rt_strt_dt <= prv.rt_end_dt
3830: -- and prv.rt_end_dt=hr_api.g_eot
3831: and prv.business_group_id = p_business_group_id
3832: and prv.prtt_rt_val_stat_cd is null
3833: and abr.acty_base_rt_id=prv.acty_base_rt_id
3834: and abr.business_group_id = p_business_group_id

Line 3893: and ecd.cvg_thru_dt = hr_api.g_eot

3889: From ben_elig_cvrd_dpnt_f ecd,
3890: ben_per_in_ler pil
3891: Where ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3892: and ecd.cvg_strt_dt is not null
3893: and ecd.cvg_thru_dt = hr_api.g_eot
3894: and ecd.business_group_id = p_business_group_id
3895: and p_effective_date between
3896: ecd.effective_start_date and ecd.effective_end_date
3897: and pil.per_in_ler_id=ecd.per_in_ler_id

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

4007:
4008: --
4009: -- Check all the input parameters are not null
4010: --
4011: hr_api.mandatory_arg_error(p_api_name => l_proc,
4012: p_argument => 'p_prtt_enrt_rslt_id',
4013: p_argument_value => p_prtt_enrt_rslt_id);
4014: --
4015: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

4011: hr_api.mandatory_arg_error(p_api_name => l_proc,
4012: p_argument => 'p_prtt_enrt_rslt_id',
4013: p_argument_value => p_prtt_enrt_rslt_id);
4014: --
4015: hr_api.mandatory_arg_error(p_api_name => l_proc,
4016: p_argument => 'p_effective_date',
4017: p_argument_value => p_effective_date);
4018: --
4019: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

4015: hr_api.mandatory_arg_error(p_api_name => l_proc,
4016: p_argument => 'p_effective_date',
4017: p_argument_value => p_effective_date);
4018: --
4019: hr_api.mandatory_arg_error(p_api_name => l_proc,
4020: p_argument => 'p_business_group_id',
4021: p_argument_value => p_business_group_id);
4022: --
4023: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

4019: hr_api.mandatory_arg_error(p_api_name => l_proc,
4020: p_argument => 'p_business_group_id',
4021: p_argument_value => p_business_group_id);
4022: --
4023: hr_api.mandatory_arg_error(p_api_name => l_proc,
4024: p_argument => 'p_object_version_number',
4025: p_argument_value => p_object_version_number);
4026: --
4027: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

4023: hr_api.mandatory_arg_error(p_api_name => l_proc,
4024: p_argument => 'p_object_version_number',
4025: p_argument_value => p_object_version_number);
4026: --
4027: hr_api.mandatory_arg_error(p_api_name => l_proc,
4028: p_argument => 'p_datetrack_mode',
4029: p_argument_value => p_datetrack_mode);
4030: --
4031: l_last_place := 'Fetching record from ben_prtt_enrt_rslt_f';

Line 4140: ,P_DATETRACK_MODE => hr_api.g_delete

4136: ,P_EFFECTIVE_START_DATE => l_interim.effective_start_date
4137: ,P_EFFECTIVE_END_DATE => l_interim.effective_end_date
4138: ,P_OBJECT_VERSION_NUMBER => l_interim.object_version_number
4139: ,P_EFFECTIVE_DATE => p_effective_date
4140: ,P_DATETRACK_MODE => hr_api.g_delete
4141: ,P_MULTI_ROW_VALIDATE => FALSE
4142: ,p_source => 'bensuenr'
4143: );
4144: End if;

Line 4305: l_datetrack_mode := hr_api.g_correction;

4301: --
4302: For l_dpnt in c_dpnt(l_interim.prtt_enrt_rslt_id) loop
4303: --
4304: If (p_effective_date = l_dpnt.effective_start_date) then
4305: l_datetrack_mode := hr_api.g_correction;
4306: Else
4307: l_datetrack_mode := hr_api.g_update;
4308: End if;
4309: --

Line 4307: l_datetrack_mode := hr_api.g_update;

4303: --
4304: If (p_effective_date = l_dpnt.effective_start_date) then
4305: l_datetrack_mode := hr_api.g_correction;
4306: Else
4307: l_datetrack_mode := hr_api.g_update;
4308: End if;
4309: --
4310: l_last_place := 'Calling update_elig_cvrd_dpnt';
4311: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt

Line 4328: l_datetrack_mode := hr_api.g_correction;

4324: --
4325: -- Update interim result row.
4326: --
4327: if l_unsusp_cvg_start_date = l_interim.enrt_cvg_strt_dt then
4328: l_datetrack_mode := hr_api.g_correction;
4329: Else
4330: l_datetrack_mode := hr_api.g_update;
4331: End if;
4332: hr_utility.set_location('l_cvg_thru_dt'||l_cvg_thru_dt,777);

Line 4330: l_datetrack_mode := hr_api.g_update;

4326: --
4327: if l_unsusp_cvg_start_date = l_interim.enrt_cvg_strt_dt then
4328: l_datetrack_mode := hr_api.g_correction;
4329: Else
4330: l_datetrack_mode := hr_api.g_update;
4331: End if;
4332: hr_utility.set_location('l_cvg_thru_dt'||l_cvg_thru_dt,777);
4333: --
4334: Update_sspndd_flag

Line 4354: ,p_datetrack_mode => hr_api.g_delete

4350: (p_prtt_enrt_rslt_id => l_interim.prtt_enrt_rslt_id
4351: ,p_effective_date => p_effective_date
4352: ,p_business_group_id => p_business_group_id
4353: ,p_validate => FALSE
4354: ,p_datetrack_mode => hr_api.g_delete
4355: );
4356: --
4357: End if;
4358: --

Line 4557: if l_ee_end_date <> hr_api.g_eot and

4553: else
4554: open c_ee(l_prv.element_entry_value_id,l_rec_rt_strt_dt);
4555: fetch c_ee into l_ee_end_date;
4556: close c_ee;
4557: if l_ee_end_date <> hr_api.g_eot and
4558: l_prv.rt_end_dt = hr_api.g_eot then
4559: ben_element_entry.reopen_closed_enrollment(
4560: p_business_group_id => p_business_group_id
4561: ,p_person_id => l_pen.person_id

Line 4558: l_prv.rt_end_dt = hr_api.g_eot then

4554: open c_ee(l_prv.element_entry_value_id,l_rec_rt_strt_dt);
4555: fetch c_ee into l_ee_end_date;
4556: close c_ee;
4557: if l_ee_end_date <> hr_api.g_eot and
4558: l_prv.rt_end_dt = hr_api.g_eot then
4559: ben_element_entry.reopen_closed_enrollment(
4560: p_business_group_id => p_business_group_id
4561: ,p_person_id => l_pen.person_id
4562: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id

Line 4635: l_datetrack_mode := hr_api.g_correction;

4631: -- certifications, we need to derive it here.
4632: --
4633: IF (p_effective_date = l_pen.effective_start_date) Then
4634: --
4635: l_datetrack_mode := hr_api.g_correction;
4636: --
4637: ELSIF p_effective_date > l_pen.effective_start_date then
4638: --
4639: l_datetrack_mode := hr_api.g_update;

Line 4639: l_datetrack_mode := hr_api.g_update;

4635: l_datetrack_mode := hr_api.g_correction;
4636: --
4637: ELSIF p_effective_date > l_pen.effective_start_date then
4638: --
4639: l_datetrack_mode := hr_api.g_update;
4640: --
4641: ELSE
4642: --
4643: l_datetrack_mode := p_datetrack_mode;

Line 4807: l_datetrack_mode := hr_api.g_correction;

4803: --
4804: if l_dpnt.cvg_strt_dt <> l_pen.enrt_cvg_strt_dt and l_update_dates then
4805: --
4806: If (p_effective_date = l_dpnt.effective_start_date) then
4807: l_datetrack_mode := hr_api.g_correction;
4808: Else
4809: l_datetrack_mode := hr_api.g_update;
4810: End if;
4811: --

Line 4809: l_datetrack_mode := hr_api.g_update;

4805: --
4806: If (p_effective_date = l_dpnt.effective_start_date) then
4807: l_datetrack_mode := hr_api.g_correction;
4808: Else
4809: l_datetrack_mode := hr_api.g_update;
4810: End if;
4811: --
4812: l_last_place := 'Calling update_elig_cvrd_dpnt';
4813: --