APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINES_ALL_EXT_TL

Line 5497: -- PO_LINES_ALL_EXT_B_ARCHIVE / PO_LINES_ALL_EXT_TL_ARCHIVE

5493: --Pre-reqs:
5494: -- None.
5495: --Modifies:
5496: -- PO_HEADERS_ALL_EXT_B_ARCHIVE / PO_HEADERS_ALL_EXT_TL_ARCHIVE
5497: -- PO_LINES_ALL_EXT_B_ARCHIVE / PO_LINES_ALL_EXT_TL_ARCHIVE
5498: -- PO_LINE_LOC_ALL_EXT_B_ARCHIVE / PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
5499: --Locks:
5500: -- None.
5501: --Function:

Line 6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE

6228: END IF;
6229: --
6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE
6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;

Line 6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');

6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;
6237:
6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE
6239: (EXTENSION_ID

Line 6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE

6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;
6237:
6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE
6239: (EXTENSION_ID
6240: ,ATTR_GROUP_ID
6241: ,PO_LINE_ID
6242: ,DATA_LEVEL_ID

Line 6361: FROM PO_LINES_ALL_EXT_TL POLE,

6357: ,POLE.UDA_TEMPLATE_ID
6358: ,POLE.DRAFT_ID
6359: ,p_revision_num
6360: ,NULL
6361: FROM PO_LINES_ALL_EXT_TL POLE,
6362: PO_LINES_ALL POL
6363: WHERE POL.po_header_id = p_po_header_id
6364: AND POL.po_line_id = POLE.po_line_id
6365: AND POLE.draft_id = -1;

Line 6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE

6367: l_progress := '100';
6368: IF PO_LOG.d_stmt THEN
6369: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6370: END IF;
6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE
6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6374: l_progress := '110';
6375: IF PO_LOG.d_stmt THEN