APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINES_ALL_EXT_B

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 5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE

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
5964:
5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE
5966: l_progress := '070';
5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;

Line 5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');

5964:
5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE
5966: l_progress := '070';
5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;
5970:
5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE
5972: (EXTENSION_ID

Line 5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE

5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;
5970:
5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE
5972: (EXTENSION_ID
5973: ,ATTR_GROUP_ID
5974: ,PO_LINE_ID
5975: ,DATA_LEVEL_ID

Line 6190: FROM PO_LINES_ALL_EXT_B POLE,

6186: ,POLE.UDA_TEMPLATE_ID
6187: ,POLE.DRAFT_ID
6188: ,p_revision_num
6189: ,'Y'
6190: FROM PO_LINES_ALL_EXT_B POLE,
6191: PO_LINES_ALL POL, PO_LINES_ARCHIVE_ALL POLA
6192: WHERE POL.po_header_id = p_po_header_id
6193: AND POL.po_line_id = POLE.po_line_id
6194: AND POL.po_line_id = POLA.po_line_id (+)

Line 6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');

6203:
6204: l_progress := '080';
6205: IF PO_LOG.d_stmt THEN
6206: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:
6210: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1

Line 6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1

6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:
6210: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1
6212: SET latest_external_flag = 'N'
6213: WHERE latest_external_flag = 'Y'
6214: AND revision_num < p_revision_num
6215: AND EXISTS

Line 6217: FROM PO_LINES_ALL_EXT_B_ARCHIVE POL2, PO_LINES_ARCHIVE_ALL PLA

6213: WHERE latest_external_flag = 'Y'
6214: AND revision_num < p_revision_num
6215: AND EXISTS
6216: (SELECT 'A new archived row'
6217: FROM PO_LINES_ALL_EXT_B_ARCHIVE POL2, PO_LINES_ARCHIVE_ALL PLA
6218: WHERE PLA.po_header_id = p_po_header_id
6219: AND PLA.po_line_id = POL1.po_line_id
6220: AND POL2.po_line_id = POL1.po_line_id
6221: AND POL2.latest_external_flag = 'Y'

Line 6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE

6226: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6227: END IF;
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

Line 6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');

6610:
6611: l_progress := '120';
6612: IF PO_LOG.d_stmt THEN
6613: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
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