DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_HEADERS_ALL_EXT_TL_ARCHIVE

Line 5496: -- PO_HEADERS_ALL_EXT_B_ARCHIVE / PO_HEADERS_ALL_EXT_TL_ARCHIVE

5492: --Name: archive_uda_attribs
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.

Line 5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE

5818: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5819: END IF;
5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE
5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE
5823: l_progress := '050';
5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;

Line 5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE

5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;
5827:
5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE
5829: (EXTENSION_ID
5830: ,ATTR_GROUP_ID
5831: ,PO_HEADER_ID
5832: ,DATA_LEVEL_ID

Line 5959: -- End PO_HEADERS_ALL_EXT_TL_ARCHIVE

5955: l_progress := '060';
5956: IF PO_LOG.d_stmt THEN
5957: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5958: END IF;
5959: -- End PO_HEADERS_ALL_EXT_TL_ARCHIVE
5960:
5961: -- Archive UDA Line and Line Locations data only for PO or PA BLANKETS
5962: IF (p_document_type = 'PO') OR
5963: (p_document_type = 'PA' AND p_document_subtype='BLANKET') THEN