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 314: SELECT PO_SESSION_GT_S.nextval

310: END IF;
311:
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';

Line 439: SELECT PO_SESSION_GT_S.nextval

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

Line 567: SELECT PO_SESSION_GT_S.nextval

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

Line 575: SELECT PO_SESSION_GT_S.nextval

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

Line 1240: SELECT PO_SESSION_GT_S.nextval

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

Line 1245: 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
1247: FROM DUAL;
1248:
1249: -- Insert ALL the doc_id's that came in as the input parameter list

Line 1478: SELECT PO_SESSION_GT_S.nextval

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

Line 1656: SELECT PO_SESSION_GT_S.nextval

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