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_DOCUMENT_CHECKS_PVT dependencies on PO_SESSION_GT

Line 12695: l_procedure_id PO_SESSION_GT.key%TYPE;

12691: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
12692:
12693: -- bug3592160 START
12694: l_header_id PO_TBL_NUMBER;
12695: l_procedure_id PO_SESSION_GT.key%TYPE;
12696: -- bug3592160 END
12697:
12698: --
12699: l_role PO_DRAFTS.owner_role%TYPE := NVL(p_role, PO_GLOBAL.g_ROLE_BUYER);

Line 12745: INSERT INTO PO_SESSION_GT

12741: -- BULK UPDATE
12742: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
12743:
12744: FORALL i IN 1..p_count
12745: INSERT INTO PO_SESSION_GT
12746: ( key,
12747: num1
12748: )
12749: SELECT l_procedure_id,

Line 12830: -- Remove everything that has been inserted into PO_SESSION_GT

12826:
12827: END LOOP;
12828:
12829: -- bug3592160 START
12830: -- Remove everything that has been inserted into PO_SESSION_GT
12831: DELETE FROM po_session_gt
12832: WHERE key = l_procedure_id;
12833: -- bug3592160 END
12834:

Line 12831: DELETE FROM po_session_gt

12827: END LOOP;
12828:
12829: -- bug3592160 START
12830: -- Remove everything that has been inserted into PO_SESSION_GT
12831: DELETE FROM po_session_gt
12832: WHERE key = l_procedure_id;
12833: -- bug3592160 END
12834:
12835: --

Line 12929: l_procedure_id PO_SESSION_GT.key%TYPE;

12925: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
12926:
12927: -- bug3592160 START
12928: l_header_id PO_TBL_NUMBER;
12929: l_procedure_id PO_SESSION_GT.key%TYPE;
12930: -- bug3592160 END
12931:
12932: BEGIN
12933:

Line 12971: INSERT INTO PO_SESSION_GT

12967: -- BULK UPDATE
12968: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
12969:
12970: FORALL i IN 1..p_count
12971: INSERT INTO PO_SESSION_GT
12972: ( key,
12973: num1
12974: )
12975: SELECT l_procedure_id,

Line 13032: -- Remove everything that has been inserted into PO_SESSION_GT

13028:
13029: END LOOP;
13030:
13031: -- bug3592160 START
13032: -- Remove everything that has been inserted into PO_SESSION_GT
13033: DELETE FROM po_session_gt
13034: WHERE key = l_procedure_id;
13035: -- bug3592160 END
13036:

Line 13033: DELETE FROM po_session_gt

13029: END LOOP;
13030:
13031: -- bug3592160 START
13032: -- Remove everything that has been inserted into PO_SESSION_GT
13033: DELETE FROM po_session_gt
13034: WHERE key = l_procedure_id;
13035: -- bug3592160 END
13036:
13037: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 13102: l_procedure_id PO_SESSION_GT.key%TYPE;

13098: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
13099:
13100: -- bug3592160 START
13101: l_header_id PO_TBL_NUMBER;
13102: l_procedure_id PO_SESSION_GT.key%TYPE;
13103: -- bug3592160 END
13104:
13105: BEGIN
13106:

Line 13144: INSERT INTO PO_SESSION_GT

13140: -- BULK UPDATE
13141: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
13142:
13143: FORALL i IN 1..p_count
13144: INSERT INTO PO_SESSION_GT
13145: ( key,
13146: num1
13147: )
13148: SELECT l_procedure_id,

Line 13201: -- Remove everything that has been inserted into PO_SESSION_GT

13197:
13198: END LOOP;
13199:
13200: -- bug3592160 START
13201: -- Remove everything that has been inserted into PO_SESSION_GT
13202: DELETE FROM po_session_gt
13203: WHERE key = l_procedure_id;
13204: -- bug3592160 END
13205:

Line 13202: DELETE FROM po_session_gt

13198: END LOOP;
13199:
13200: -- bug3592160 START
13201: -- Remove everything that has been inserted into PO_SESSION_GT
13202: DELETE FROM po_session_gt
13203: WHERE key = l_procedure_id;
13204: -- bug3592160 END
13205:
13206: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 14864: -- PO_SESSION_GT column mapping

14860: -- Collect this information into the scratchpad,
14861: -- along with the info we need for error reporting.
14862:
14863: -----------------------------------------
14864: -- PO_SESSION_GT column mapping
14865: --
14866: -- num1 line_num
14867: -- num2 shipment_num
14868: -- num3 distribution_num

Line 14872: SELECT PO_SESSION_GT_S.nextval

14868: -- num3 distribution_num
14869: -- char1 period_name
14870: -----------------------------------------
14871:
14872: SELECT PO_SESSION_GT_S.nextval
14873: INTO l_dates_key
14874: FROM DUAL
14875: ;
14876:

Line 14880: INSERT INTO PO_SESSION_GT

14876:
14877: l_progress := '220';
14878:
14879: FORALL i IN 1 .. l_period_name_tbl.COUNT
14880: INSERT INTO PO_SESSION_GT
14881: ( key
14882: , num1 -- line_num
14883: , num2 -- shipment_num
14884: , num3 -- distribution_num

Line 14947: FROM PO_SESSION_GT DATES

14943: , 1
14944: , 240
14945: )
14946: , l_msg_name
14947: FROM PO_SESSION_GT DATES
14948: WHERE DATES.key = l_dates_key
14949: AND DATES.char1 IS NULL -- period_name not found
14950: ;
14951: