APPS.BEN_CLOSE_ENROLLMENT dependencies on FND_DATE

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

1535: l_effective_date := to_date(p_effective_date,'YYYY/MM/DD HH24:MI:SS');
1536: l_effective_date := to_date(to_char(trunc(l_effective_date),'DD/MM/RRRR')
1537: ,'DD/MM/RRRR');
1538: */
1539: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
1540: --
1541: -- Put row in fnd_sessions
1542: --
1543: dt_fndate.change_ses_date

Line 1796: fnd_date.date_to_canonical(process_date) process_date

1792: --
1793: cursor c_parameters
1794: is
1795: select -- to_char(process_date, 'YYYY/MM/DD HH24:MI:SS') process_date
1796: fnd_date.date_to_canonical(process_date) process_date
1797: ,business_group_id
1798: ,pgm_id
1799: ,pl_id
1800: ,location_id

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

1856: ,p_location_id => l_parameters.location_id
1857: ,p_ler_id => l_parameters.ler_id
1858: -- PB : 5422 :
1859: -- ,p_popl_enrt_typ_cycl_id => l_parameters.popl_enrt_typ_cycl_id
1860: ,p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parameters.lf_evt_ocrd_dt)
1861: ,p_person_id => l_parameters.person_id
1862: ,p_debug_messages => l_parameters.debug_messages_flag
1863: ,p_audit_log => l_parameters.audit_log_flag
1864: ,p_close_uneai_flag => l_parameters.close_uneai_flag

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

2032: --
2033: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt)
2034: ,'DD/MM/RRRR'),'DD/MM/RRRR');
2035: */
2036: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
2037: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
2038: --
2039: -- Put row in fnd_sessions
2040: --

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

2033: l_lf_evt_ocrd_dt := to_date(to_char(trunc(l_lf_evt_ocrd_dt)
2034: ,'DD/MM/RRRR'),'DD/MM/RRRR');
2035: */
2036: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
2037: l_lf_evt_ocrd_dt := trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));
2038: --
2039: -- Put row in fnd_sessions
2040: --
2041: dt_fndate.change_ses_date

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

2053: --
2054: l_uneai_effective_date := to_date(to_char(trunc(l_uneai_effective_date)
2055: ,'DD/MM/RRRR'),'DD/MM/RRRR');
2056: */
2057: l_uneai_effective_date := trunc(fnd_date.canonical_to_date(p_uneai_effective_date));
2058: end if;
2059: --
2060: -- Check business rules and mandatory parameters
2061: --