APPS.BEN_CLOSE_ENROLLMENT dependencies on FND_DATE

Line 1579: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

1575: l_effective_date := to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1576: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR')
1577: ,'DD/MM/RRRR');
1578: */
1579: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
1580: --
1581: -- Put row in fnd_sessions
1582: --
1583: dt_fndate.change_ses_date

Line 1836: fnd_date.date_to_canonical(process_date) process_date

1832: --
1833: cursor c_parameters
1834: is
1835: select -- to_char(process_date, 'YYYY/MM/DD HH24:MI:SS') process_date
1836: fnd_date.date_to_canonical(process_date) process_date
1837: ,business_group_id
1838: ,pgm_id
1839: ,pl_id
1840: ,location_id

Line 1900: ,p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parameters.lf_evt_ocrd_dt)

1896: ,p_location_id => l_parameters.location_id
1897: ,p_ler_id => l_parameters.ler_id
1898: -- PB : 5422 :
1899: -- ,p_popl_enrt_typ_cycl_id => l_parameters.popl_enrt_typ_cycl_id
1900: ,p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parameters.lf_evt_ocrd_dt)
1901: ,p_person_id => l_parameters.person_id
1902: ,p_debug_messages => l_parameters.debug_messages_flag
1903: ,p_audit_log => l_parameters.audit_log_flag
1904: ,p_close_uneai_flag => l_parameters.close_uneai_flag

Line 2076: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

2072: --
2073: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt)
2074: ,'DD/MM/RRRR'),'DD/MM/RRRR');
2075: */
2076: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
2077: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
2078: --
2079: -- Put row in fnd_sessions
2080: --

Line 2077: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));

2073: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt)
2074: ,'DD/MM/RRRR'),'DD/MM/RRRR');
2075: */
2076: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
2077: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
2078: --
2079: -- Put row in fnd_sessions
2080: --
2081: dt_fndate.change_ses_date

Line 2097: l_uneai_effective_date := trunc(fnd_date.canonical_to_date(p_uneai_effective_date));

2093: --
2094: l_uneai_effective_date := to_date(to_char(trunc(l_uneai_effective_date)
2095: ,'DD/MM/RRRR'),'DD/MM/RRRR');
2096: */
2097: l_uneai_effective_date := trunc(fnd_date.canonical_to_date(p_uneai_effective_date));
2098: end if;
2099: --
2100: -- Check business rules and mandatory parameters
2101: --