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
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
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;
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