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 PO_SESSION_GT_S

Line 320: SELECT PO_SESSION_GT_S.nextval

316: END IF;
317:
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';

Line 446: SELECT PO_SESSION_GT_S.nextval

442: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
443:
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';

Line 575: SELECT PO_SESSION_GT_S.nextval

571: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
572:
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

Line 583: SELECT PO_SESSION_GT_S.nextval

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
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

Line 1276: SELECT PO_SESSION_GT_S.nextval

1272: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;
1273:
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

Line 1281: 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
1283: FROM DUAL;
1284:
1285: -- Insert ALL the doc_id's that came in as the input parameter list

Line 1516: SELECT PO_SESSION_GT_S.nextval

1512:
1513: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION, TYPE_BLANKET_BULK)) THEN
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

Line 1694: SELECT PO_SESSION_GT_S.nextval

1690:
1691: IF (p_type IN (TYPE_BLANKET, TYPE_QUOTATION, TYPE_BLANKET_BULK)) THEN
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