DBA Data[Home] [Help]

APPS.BEN_ON_LINE_LF_EVT dependencies on FND_DATE

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

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

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

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

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

1891: hr_utility.set_location(l_package || ' Before Process',5);
1892: --
1893: if p_effective_date is not null then
1894: --l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1895: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
1896: end if;
1897: if p_lf_evt_ocrd_dt is not null then
1898: --l_lf_evt_ocrd_dt := to_char(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
1899: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);

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

1895: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
1896: end if;
1897: if p_lf_evt_ocrd_dt is not null then
1898: --l_lf_evt_ocrd_dt := to_char(p_lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
1899: l_lf_evt_ocrd_dt := fnd_date.date_to_canonical(p_lf_evt_ocrd_dt);
1900: end if;
1901: --
1902: -- Initialise the globals.
1903: --

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

2212: --
2213: g_benefit_action_id := null;
2214: --
2215: --l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
2216: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
2217: --
2218: l_bft_id := null;
2219: --
2220: ben_manage_life_events.process

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

2991: --
2992: hr_utility.set_location ('Calling p_manage_irec_life_events_w in iRecruitment (I) mode', 20);
2993: --
2994: -- l_effective_date := to_char(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
2995: l_effective_date := fnd_date.date_to_canonical(p_effective_date);
2996: --
2997: ben_comp_object_list1.refresh_eff_date_caches;
2998: --
2999: ben_manage_life_events.irec_process