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 1649: from dual;

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

Line 1657: from dual;

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

Line 1662: from dual;

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

Line 1815: from dual;

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

Line 1825: from dual;

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

Line 1830: from dual;

1826: EXCEPTION WHEN OTHERS THEN
1827: BEGIN
1828: select to_char(to_date(rev_date, 'YYYY/MM/DD HH24:MI:SS'), 'YYYY/MM/DD HH24:MI:SS')
1829: into expl_date
1830: from dual;
1831: END;
1832: END;
1833: END IF;
1834: