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.PO_CATALOG_INDEX_PVT dependencies on DUAL

Line 322: FROM DUAL;

318: l_progress := '010';
319: -- pick a new key for temp table
320: SELECT PO_SESSION_GT_S.nextval
321: INTO l_key
322: FROM DUAL;
323:
324: l_progress := '020';
325: -- Insert all lines in the given Quotation into the GT table
326: INSERT INTO PO_SESSION_GT

Line 448: FROM DUAL;

444: l_progress := '010';
445: -- pick a new key for temp table
446: SELECT PO_SESSION_GT_S.nextval
447: INTO l_key
448: FROM DUAL;
449:
450: l_progress := '020';
451: -- Insert all lines in the given ReqTemplate into the GT table
452: INSERT INTO PO_SESSION_GT

Line 577: FROM DUAL;

573: l_progress := '010';
574: -- pick a new key for temp table, to store records to be passed to iProc
575: SELECT PO_SESSION_GT_S.nextval
576: INTO l_key
577: FROM DUAL;
578:
579: -- Pick another key for temp table, used for remaining headers to be processed
580: -- This will be the key to those PO_HEADER_ID's in PO_SESSSION_GT table that
581: -- have not been completely checked to see if they contain any changes to the

Line 585: FROM DUAL;

581: -- have not been completely checked to see if they contain any changes to the
582: -- searchable attributes at Heade/Line/Attr/TLP levels.
583: SELECT PO_SESSION_GT_S.nextval
584: INTO l_key_remaining_headers
585: FROM DUAL;
586:
587: -- Insert ALL the doc_id's that came in in the input parameter list into the
588: -- 'remaining_headers' list
589: FORALL i in 1..p_po_header_ids.COUNT

Line 1278: FROM DUAL;

1274: l_progress := '010';
1275: -- Pick a key for temp table, used for org_assignemnts
1276: SELECT PO_SESSION_GT_S.nextval
1277: INTO l_key_org_assignments
1278: FROM DUAL;
1279:
1280: -- Pick another key for temp table, used for input headers
1281: SELECT PO_SESSION_GT_S.nextval
1282: INTO l_key_input_headers

Line 1283: FROM DUAL;

1279:
1280: -- Pick another key for temp table, used for input headers
1281: SELECT PO_SESSION_GT_S.nextval
1282: INTO l_key_input_headers
1283: FROM DUAL;
1284:
1285: -- Insert ALL the doc_id's that came in as the input parameter list
1286: FORALL i in 1..p_po_header_ids.COUNT
1287: INSERT INTO PO_SESSION_GT

Line 1518: FROM DUAL;

1514: l_progress := '010';
1515: -- pick a new key for temp table
1516: SELECT PO_SESSION_GT_S.nextval
1517: INTO l_key
1518: FROM DUAL;
1519:
1520: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION)) THEN
1521: l_progress := '020';
1522:

Line 1696: FROM DUAL;

1692: l_progress := '010';
1693: -- pick a new key for temp table
1694: SELECT PO_SESSION_GT_S.nextval
1695: INTO l_key
1696: FROM DUAL;
1697:
1698: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION)) THEN
1699: l_progress := '020';
1700: