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 DUAL

Line 604: to use individual pl/sql table for each column in the cursor select list */

600: l_batch_size NUMBER := 20000;
601:
602: /* Declare pl/sql tables for all coulmns in the select list. BULK BIND and INSERT with
603: pl/sql table of records work fine in 9i releases but not in 8i. So, the only option is
604: to use individual pl/sql table for each column in the cursor select list */
605:
606:
607: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER
608: INDEX BY BINARY_INTEGER;

Line 1648: from dual;

1644:
1645: IF (expl_date is null) THEN
1646: select to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
1647: into expl_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))

Line 1654: from dual;

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
1657: select to_char(to_date(rev_date, 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')
1658: into expl_date

Line 1659: from dual;

1655: EXCEPTION WHEN OTHERS THEN
1656: BEGIN
1657: select to_char(to_date(rev_date, 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')
1658: into expl_date
1659: from dual;
1660: END;
1661: END;
1662: END IF;
1663:

Line 1807: from dual;

1803:
1804: IF (expl_date is null) THEN
1805: select to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
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.

Line 1815: from dual;

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
1818: select to_char(to_date(rev_date, 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')
1819: into expl_date

Line 1820: from dual;

1816: EXCEPTION WHEN OTHERS THEN
1817: BEGIN
1818: select to_char(to_date(rev_date, 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')
1819: into expl_date
1820: from dual;
1821: END;
1822: END;
1823: END IF;
1824: