APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_SESSION_GT

Line 357: FROM po_session_gt

353: c_po_line_num IN varchar2,
354: c_current_req_line_id IN NUMBER
355: ) IS
356: SELECT index_num1 -- requisition line ID
357: FROM po_session_gt
358: WHERE key = c_key
359: AND index_num2 = c_po_line_num
360: AND index_num1 <> c_current_req_line_id;
361: BEGIN

Line 393: INSERT INTO po_session_gt(

389: l_key := PO_CORE_S.get_session_gt_nextval;
390:
391: -- Insert req line ID and PO line num of all lines into temp table.
392: FORALL i IN 1..l_num_lines
393: INSERT INTO po_session_gt(
394: key, -- unique key
395: index_num1, -- req line ID
396: index_num2 -- PO line num
397: )

Line 427: FROM po_session_gt POSGT2

423: WHERE EXISTS(
424: -- Select all doc builder requisition lines that have the same PO line
425: -- number as the current line in the loop.
426: SELECT 'doc builder lines with same PO line number'
427: FROM po_session_gt POSGT2
428: WHERE POSGT2.index_num1 <> POSGT.index_num1 -- Not the current line
429: AND POSGT2.index_num2 = POSGT.index_num2 -- Same PO line number
430: )
431: OR EXISTS(

Line 442: FROM po_session_gt POSGT

438: )),
439: 'N' -- NVL to 'N' if no other req/PO lines with same PO line number
440: )
441: BULK COLLECT INTO l_line_combined_flag_tbl
442: FROM po_session_gt POSGT
443: WHERE key = l_key;
444: END IF;
445:
446: FOR i IN 1..l_num_lines -- Loop through all doc builder req lines

Line 547: DELETE FROM po_session_gt

543: END IF; -- If there is a mismatch, set error message
544: END LOOP; -- Loop through all doc builder req lines
545:
546: -- Clean up temp table
547: DELETE FROM po_session_gt
548: WHERE key = l_key;
549:
550: IF (PO_LOG.d_proc) THEN
551: PO_LOG.proc_end(d_mod, 'x_message_code_tbl', x_message_code_tbl);

Line 559: DELETE FROM po_session_gt

555:
556: EXCEPTION
557: WHEN OTHERS THEN
558: -- Clean up temp table
559: DELETE FROM po_session_gt
560: WHERE key = l_key;
561:
562: -- Close cursor if open
563: IF (req_line_ids_csr%ISOPEN)

Line 2339: INSERT INTO po_session_gt

2335: -- Bulk insert matching lines into GT table.
2336: --
2337: FORALL i IN p_start_index..p_end_index
2338:
2339: INSERT INTO po_session_gt
2340: ( key
2341: , num1
2342: , num2
2343: )

Line 2397: DELETE FROM po_session_gt

2393: d_position := 30;
2394:
2395: -- Clean up GT table and return the results into the output tables.
2396: --
2397: DELETE FROM po_session_gt
2398: WHERE key = l_key
2399: RETURNING num1, num2
2400: BULK COLLECT INTO x_req_line_id_tbl, x_po_line_num_tbl;
2401: