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

Line 63: l_procedure_id PO_SESSION_GT.key%TYPE; -- bug3606853

59:
60: l_api_name CONSTANT VARCHAR(30) := 'CHECK_UPDATABLE';
61: l_progress VARCHAR2(3) := '000';
62:
63: l_procedure_id PO_SESSION_GT.key%TYPE; -- bug3606853
64:
65: BEGIN
66:
67: IF g_fnd_debug = 'Y' THEN

Line 89: INSERT INTO PO_SESSION_GT

85: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
86:
87: FORALL i IN 1..p_count
88: -- SQL What: Checks if current PO Header/Line/Shipment is in updateable status
89: INSERT INTO PO_SESSION_GT
90: ( key
91: )
92: SELECT l_procedure_id
93: FROM DUAL

Line 144: -- Remove everthing that has been inserted into PO_SESSION_GT by the above

140:
141: END LOOP;
142:
143: -- bug3606853 START
144: -- Remove everthing that has been inserted into PO_SESSION_GT by the above
145: -- dummy insert
146:
147: DELETE FROM po_session_gt
148: WHERE key = l_procedure_id;

Line 147: DELETE FROM po_session_gt

143: -- bug3606853 START
144: -- Remove everthing that has been inserted into PO_SESSION_GT by the above
145: -- dummy insert
146:
147: DELETE FROM po_session_gt
148: WHERE key = l_procedure_id;
149:
150: -- bug3592160 END
151:

Line 214: l_procedure_id PO_SESSION_GT.key%TYPE; -- bug3606853

210:
211: l_api_name CONSTANT VARCHAR(30) := 'CHECK_RESERVABLE';
212: l_progress VARCHAR2(3) := '000';
213:
214: l_procedure_id PO_SESSION_GT.key%TYPE; -- bug3606853
215: BEGIN
216:
217: IF g_fnd_debug = 'Y' THEN
218: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 239: INSERT INTO PO_SESSION_GT

235: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
236:
237: FORALL i IN 1..p_count
238: -- SQL What: Checks if current PO Header/Line/Shipment is in reservable status
239: INSERT INTO PO_SESSION_GT
240: ( key
241: )
242: SELECT l_procedure_id
243: FROM DUAL

Line 281: -- Remove everthing that has been inserted into PO_SESSION_GT by the above

277:
278: END LOOP;
279:
280: -- bug3606853 START
281: -- Remove everthing that has been inserted into PO_SESSION_GT by the above
282: -- dummy insert
283:
284: DELETE FROM po_session_gt
285: WHERE key = l_procedure_id;

Line 284: DELETE FROM po_session_gt

280: -- bug3606853 START
281: -- Remove everthing that has been inserted into PO_SESSION_GT by the above
282: -- dummy insert
283:
284: DELETE FROM po_session_gt
285: WHERE key = l_procedure_id;
286:
287: -- bug3592160 END
288:

Line 350: l_procedure_id PO_SESSION_GT.key%TYPE; -- bug3606853

346:
347: l_api_name CONSTANT VARCHAR(30) := 'CHECK_UNRESERVABLE';
348: l_progress VARCHAR2(3) := '000';
349:
350: l_procedure_id PO_SESSION_GT.key%TYPE; -- bug3606853
351:
352: BEGIN
353:
354: IF g_fnd_debug = 'Y' THEN

Line 376: INSERT INTO PO_SESSION_GT

372: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
373:
374: FORALL i IN 1..p_count
375: -- SQL What: Checks if current PO Header/Line/Shipment is in unreservable status
376: INSERT INTO PO_SESSION_GT
377: ( key
378: )
379: SELECT l_procedure_id
380: FROM DUAL

Line 411: -- Remove everthing that has been inserted into PO_SESSION_GT by the above

407:
408: END LOOP;
409:
410: -- bug3606853 START
411: -- Remove everthing that has been inserted into PO_SESSION_GT by the above
412: -- dummy insert
413:
414: DELETE FROM po_session_gt
415: WHERE key = l_procedure_id;

Line 414: DELETE FROM po_session_gt

410: -- bug3606853 START
411: -- Remove everthing that has been inserted into PO_SESSION_GT by the above
412: -- dummy insert
413:
414: DELETE FROM po_session_gt
415: WHERE key = l_procedure_id;
416:
417: -- bug3592160 END
418: