eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_HEADERS_ALL_EXT_B

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 5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE

5577: -- End Check if Document is UDA Enabled
5578:
5579: -- Archive UDA data only for UDA_enabled Docs, and only for DocTypes PO and PA
5580: IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA') THEN
5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE
5582: l_progress := '030';
5583: IF PO_LOG.d_stmt THEN
5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;

Line 5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');

5580: IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA') THEN
5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE
5582: l_progress := '030';
5583: IF PO_LOG.d_stmt THEN
5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;
5586:
5587: -- : Setting the latest_external_flag to N for all old records.
5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE

Line 5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE

5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;
5586:
5587: -- : Setting the latest_external_flag to N for all old records.
5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE
5589: SET latest_external_flag = 'N'
5590: WHERE po_header_id = p_po_header_id
5591: AND latest_external_flag = 'Y';
5592:

Line 5593: INSERT INTO PO_HEADERS_ALL_EXT_B_ARCHIVE

5589: SET latest_external_flag = 'N'
5590: WHERE po_header_id = p_po_header_id
5591: AND latest_external_flag = 'Y';
5592:
5593: INSERT INTO PO_HEADERS_ALL_EXT_B_ARCHIVE
5594: (EXTENSION_ID
5595: ,ATTR_GROUP_ID
5596: ,PO_HEADER_ID
5597: ,DATA_LEVEL_ID

Line 5812: FROM PO_HEADERS_ALL_EXT_B

5808: ,UDA_TEMPLATE_ID
5809: ,DRAFT_ID
5810: ,p_revision_num
5811: ,'Y' --
5812: FROM PO_HEADERS_ALL_EXT_B
5813: WHERE po_header_id = p_po_header_id
5814: AND draft_id = -1;
5815:
5816: l_progress := '040';

Line 5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE

5816: l_progress := '040';
5817: IF PO_LOG.d_stmt THEN
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