DBA Data[Home] [Help]

APPS.BEN_ON_LINE_LF_EVT dependencies on FND_DATE

Line 1488: l_effective_date := fnd_date.date_to_canonical(p_effective_date);

1484: l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1485: l_lf_evt_ocrd_dt := to_char(nvl(p_lf_evt_ocrd_dt,p_effective_date),'YYYY/MM/DD HH24:MI:SS');
1486: */
1487: --
1488: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
1489: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(NVL(p_lf_evt_ocrd_dt,p_effective_date));
1490: --
1491: -- Bug 3486966
1492: --

Line 1489: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(NVL(p_lf_evt_ocrd_dt,p_effective_date));

1485: l_lf_evt_ocrd_dt := to_char(nvl(p_lf_evt_ocrd_dt,p_effective_date),'YYYY/MM/DD HH24:MI:SS');
1486: */
1487: --
1488: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
1489: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(NVL(p_lf_evt_ocrd_dt,p_effective_date));
1490: --
1491: -- Bug 3486966
1492: --
1493: if p_mode in ('L', 'C','U') then

Line 1907: l_effective_date := fnd_date.date_to_canonical(p_effective_date);

1903: hr_utility.set_location(l_package || ' Before Process',5);
1904: --
1905: if p_effective_date is not null then
1906: --l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1907: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
1908: end if;
1909: if p_lf_evt_ocrd_dt is not null then
1910: --l_lf_evt_ocrd_dt := to_char(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
1911: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);

Line 1911: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);

1907: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
1908: end if;
1909: if p_lf_evt_ocrd_dt is not null then
1910: --l_lf_evt_ocrd_dt := to_char(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
1911: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);
1912: end if;
1913: --
1914: -- Initialise the globals.
1915: --

Line 2228: l_effective_date := fnd_date.date_to_canonical(p_effective_date);

2224: --
2225: g_benefit_action_id := null;
2226: --
2227: --l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
2228: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
2229: --
2230: l_bft_id := null;
2231: --
2232: ben_manage_life_events.process

Line 3045: l_effective_date := fnd_date.date_to_canonical(p_effective_date);

3041: --
3042: hr_utility.set_location ('Calling p_manage_irec_life_events_w in iRecruitment (I) mode', 20);
3043: --
3044: -- l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
3045: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
3046: --
3047: ben_comp_object_list1.refresh_eff_date_caches;
3048: --
3049: ben_manage_life_events.irec_process