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 316: FROM DUAL;

312: l_progress := '010';
313: -- pick a new key for temp table
314: SELECT PO_SESSION_GT_S.nextval
315: INTO l_key
316: FROM DUAL;
317:
318: l_progress := '020';
319: -- Insert all lines in the given Quotation into the GT table
320: INSERT INTO PO_SESSION_GT

Line 441: FROM DUAL;

437: l_progress := '010';
438: -- pick a new key for temp table
439: SELECT PO_SESSION_GT_S.nextval
440: INTO l_key
441: FROM DUAL;
442:
443: l_progress := '020';
444: -- Insert all lines in the given ReqTemplate into the GT table
445: INSERT INTO PO_SESSION_GT

Line 569: FROM DUAL;

565: l_progress := '010';
566: -- pick a new key for temp table, to store records to be passed to iProc
567: SELECT PO_SESSION_GT_S.nextval
568: INTO l_key
569: FROM DUAL;
570:
571: -- Pick another key for temp table, used for remaining headers to be processed
572: -- This will be the key to those PO_HEADER_ID's in PO_SESSSION_GT table that
573: -- have not been completely checked to see if they contain any changes to the

Line 577: FROM DUAL;

573: -- have not been completely checked to see if they contain any changes to the
574: -- searchable attributes at Heade/Line/Attr/TLP levels.
575: SELECT PO_SESSION_GT_S.nextval
576: INTO l_key_remaining_headers
577: FROM DUAL;
578:
579: -- Insert ALL the doc_id's that came in in the input parameter list into the
580: -- 'remaining_headers' list
581: FORALL i in 1..p_po_header_ids.COUNT

Line 1242: FROM DUAL;

1238: l_progress := '010';
1239: -- Pick a key for temp table, used for org_assignemnts
1240: SELECT PO_SESSION_GT_S.nextval
1241: INTO l_key_org_assignments
1242: FROM DUAL;
1243:
1244: -- Pick another key for temp table, used for input headers
1245: SELECT PO_SESSION_GT_S.nextval
1246: INTO l_key_input_headers

Line 1247: FROM DUAL;

1243:
1244: -- Pick another key for temp table, used for input headers
1245: SELECT PO_SESSION_GT_S.nextval
1246: INTO l_key_input_headers
1247: FROM DUAL;
1248:
1249: -- Insert ALL the doc_id's that came in as the input parameter list
1250: FORALL i in 1..p_po_header_ids.COUNT
1251: INSERT INTO PO_SESSION_GT

Line 1480: FROM DUAL;

1476: l_progress := '010';
1477: -- pick a new key for temp table
1478: SELECT PO_SESSION_GT_S.nextval
1479: INTO l_key
1480: FROM DUAL;
1481:
1482: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION)) THEN
1483: l_progress := '020';
1484:

Line 1658: FROM DUAL;

1654: l_progress := '010';
1655: -- pick a new key for temp table
1656: SELECT PO_SESSION_GT_S.nextval
1657: INTO l_key
1658: FROM DUAL;
1659:
1660: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION)) THEN
1661: l_progress := '020';
1662: