DBA Data[Home] [Help]

APPS.BOMPEXPL dependencies on FND_DATE

Line 1652: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date))

1648: from dual;
1649: ELSE
1650: -- we will make sure that the canonical and the nls_date formats are supported.
1651: BEGIN
1652: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date))
1653: into expl_date
1654: from dual;
1655: EXCEPTION WHEN OTHERS THEN
1656: BEGIN

Line 1810: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date

1806: into expl_date
1807: from dual;
1808: ELSE
1809: -- we will make sure that the canonical and the nls_date formats are supported.
1810: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date
1811: -- and fnd_date.displayDT_to_date do the same operation.
1812: BEGIN
1813: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date))
1814: into expl_date

Line 1811: -- and fnd_date.displayDT_to_date do the same operation.

1807: from dual;
1808: ELSE
1809: -- we will make sure that the canonical and the nls_date formats are supported.
1810: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date
1811: -- and fnd_date.displayDT_to_date do the same operation.
1812: BEGIN
1813: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date))
1814: into expl_date
1815: from dual;

Line 1813: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date))

1809: -- we will make sure that the canonical and the nls_date formats are supported.
1810: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date
1811: -- and fnd_date.displayDT_to_date do the same operation.
1812: BEGIN
1813: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date))
1814: into expl_date
1815: from dual;
1816: EXCEPTION WHEN OTHERS THEN
1817: BEGIN