eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPEXPL dependencies on FND_DATE

Line 1652: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date

1648: into expl_date
1649: from dual;
1650: ELSE
1651: -- we will make sure that the canonical and the nls_date formats are supported.
1652: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date
1653: -- Named and Mixed notation calls in SQL statements do not support in 10g database.
1654: BEGIN
1655: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date, FND_DATE.calendar_aware_alt)) --changed for calendar internationalization project
1656: into expl_date

Line 1655: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date, FND_DATE.calendar_aware_alt)) --changed for calendar internationalization project

1651: -- we will make sure that the canonical and the nls_date formats are supported.
1652: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date
1653: -- Named and Mixed notation calls in SQL statements do not support in 10g database.
1654: BEGIN
1655: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date(rev_date, FND_DATE.calendar_aware_alt)) --changed for calendar internationalization project
1656: into expl_date
1657: from dual;
1658: EXCEPTION WHEN OTHERS THEN
1659: BEGIN

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

1814: into expl_date
1815: from dual;
1816: ELSE
1817: -- we will make sure that the canonical and the nls_date formats are supported.
1818: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date
1819: -- and fnd_date.displayDT_to_date do the same operation.
1820: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date
1821: -- Named and Mixed notation calls in SQL statements do not support in 10g database.
1822: BEGIN

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

1815: from dual;
1816: ELSE
1817: -- we will make sure that the canonical and the nls_date formats are supported.
1818: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date
1819: -- and fnd_date.displayDT_to_date do the same operation.
1820: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date
1821: -- Named and Mixed notation calls in SQL statements do not support in 10g database.
1822: BEGIN
1823: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date( rev_date, FND_DATE.calendar_aware_alt)) --calendar internationalization project

Line 1820: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date

1816: ELSE
1817: -- we will make sure that the canonical and the nls_date formats are supported.
1818: -- Bug 4740913. Removed fnd_date.charDT_to_date as both fnd_date.charDT_to_date
1819: -- and fnd_date.displayDT_to_date do the same operation.
1820: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date
1821: -- Named and Mixed notation calls in SQL statements do not support in 10g database.
1822: BEGIN
1823: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date( rev_date, FND_DATE.calendar_aware_alt)) --calendar internationalization project
1824: into expl_date

Line 1823: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date( rev_date, FND_DATE.calendar_aware_alt)) --calendar internationalization project

1819: -- and fnd_date.displayDT_to_date do the same operation.
1820: -- Bug 16173516 - Modified to positional notation call of fnd_date.displayDT_to_date
1821: -- Named and Mixed notation calls in SQL statements do not support in 10g database.
1822: BEGIN
1823: select fnd_date.date_to_canonical(fnd_date.displayDT_to_date( rev_date, FND_DATE.calendar_aware_alt)) --calendar internationalization project
1824: into expl_date
1825: from dual;
1826: EXCEPTION WHEN OTHERS THEN
1827: BEGIN