APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINE_LOC_ALL_EXT_B_ARCHIVE

Line 5498: -- PO_LINE_LOC_ALL_EXT_B_ARCHIVE / PO_LINE_LOC_ALL_EXT_TL_ARCHIVE

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:
5502: -- Archive UDA Data associated with the Document

Line 6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE

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
6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');
6377: END IF;

Line 6379: INSERT INTO PO_LINE_LOC_ALL_EXT_B_ARCHIVE

6375: IF PO_LOG.d_stmt THEN
6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');
6377: END IF;
6378:
6379: INSERT INTO PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6380: (EXTENSION_ID
6381: ,ATTR_GROUP_ID
6382: ,LINE_LOCATION_ID
6383: ,DATA_LEVEL_ID

Line 6618: UPDATE PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL1

6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6615: END IF;
6616:
6617: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6618: UPDATE PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL1
6619: SET latest_external_flag = 'N'
6620: WHERE latest_external_flag = 'Y'
6621: AND revision_num < p_revision_num
6622: AND EXISTS

Line 6624: FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL2, PO_LINE_LOCATIONS_ARCHIVE_ALL PLA

6620: WHERE latest_external_flag = 'Y'
6621: AND revision_num < p_revision_num
6622: AND EXISTS
6623: (SELECT 'A new archived row'
6624: FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL2, PO_LINE_LOCATIONS_ARCHIVE_ALL PLA
6625: WHERE PLA.po_header_id = p_po_header_id
6626: AND PLA.line_location_id = POL1.line_location_id
6627: AND POL2.line_location_id = POL1.line_location_id
6628: AND POL2.latest_external_flag = 'Y'

Line 6637: -- End PO_LINE_LOC_ALL_EXT_B_ARCHIVE

6633: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6634: END IF;
6635: END IF;
6636: --
6637: -- End PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6638:
6639: -- Start PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6640: l_progress := '130';
6641: IF PO_LOG.d_stmt THEN