APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on PO_SESSION_GT

Line 117: l_key PO_SESSION_GT.key%TYPE;

113:
114: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
115: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
116: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
117: l_key PO_SESSION_GT.key%TYPE;
118: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script
119: BEGIN
120: l_progress := '010';
121:

Line 476: l_key PO_SESSION_GT.key%TYPE;

472: l_end_index NUMBER;
473: l_end_index_tmp NUMBER;
474: l_last_batch_flag VARCHAR2(1);
475:
476: l_key PO_SESSION_GT.key%TYPE;
477: BEGIN
478: l_progress := '010';
479: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
480:

Line 820: SELECT PO_SESSION_GT_S.nextval

816:
817: -- SQL What: Pick a new key from session GT sequence .
818: -- SQL Why : To get po_line_id's
819: -- SQL Join: none
820: SELECT PO_SESSION_GT_S.nextval
821: INTO l_key
822: FROM DUAL;
823:
824: l_progress := '030';

Line 829: INSERT INTO PO_SESSION_GT(key, num1)

825: -- SQL What: Get all the line id's for the given set of header id's
826: -- SQL Why : To archive the GBPA lines.
827: -- SQL Join: po_header_id
828: FORALL i IN 1 .. p_po_header_ids.COUNT
829: INSERT INTO PO_SESSION_GT(key, num1)
830: SELECT l_key,
831: po_line_id
832: FROM PO_LINES_ALL
833: WHERE po_header_id = p_po_header_ids(i);

Line 839: DELETE FROM PO_SESSION_GT

835: l_progress := '040';
836: -- SQL What: Transfer from session GT table to local array
837: -- SQL Why : The po_lie_id's are requied for archival of lines
838: -- SQL Join: key
839: DELETE FROM PO_SESSION_GT
840: WHERE key = l_key
841: RETURNING num1
842: BULK COLLECT INTO l_po_line_ids;
843: