APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 1038: INSERT INTO PO_LINES_ARCHIVE_ALL

1034: END IF;
1035:
1036: /*Bug7286203 - Added some fields to archival check so that cancellation and archival are in sync*/
1037:
1038: INSERT INTO PO_LINES_ARCHIVE_ALL
1039: (allow_price_override_flag,
1040: amount,
1041: attribute1,
1042: attribute10,

Line 1425: PO_LINES_ARCHIVE_ALL POLA

1421: POL.CLM_PAYMENT_INSTR_CODE, --
1422: POL.CLM_EXHIBIT_NAME -- Elins project
1423:
1424: FROM PO_LINES_ALL POL,
1425: PO_LINES_ARCHIVE_ALL POLA
1426: WHERE POL.po_header_id = p_document_id
1427: AND POL.po_line_id = POLA.po_line_id (+)
1428: AND POLA.latest_external_flag (+) = 'Y'
1429: AND (--:Copy all lines in case of CLM where revision num in base

Line 1557: UPDATE PO_LINES_ARCHIVE_ALL POL1

1553: 'Update PO_LINES_ARCHIVE to reset latest_external_flag');
1554: END IF;
1555:
1556: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
1557: UPDATE PO_LINES_ARCHIVE_ALL POL1
1558: SET latest_external_flag = 'N'
1559: WHERE po_header_id = p_document_id
1560: AND latest_external_flag = 'Y'
1561: AND revision_num < p_revision_num

Line 1564: FROM PO_LINES_ARCHIVE_ALL POL2

1560: AND latest_external_flag = 'Y'
1561: AND revision_num < p_revision_num
1562: AND EXISTS
1563: (SELECT 'A new archived row'
1564: FROM PO_LINES_ARCHIVE_ALL POL2
1565: WHERE POL2.po_line_id = POL1.po_line_id
1566: AND POL2.latest_external_flag = 'Y'
1567: AND POL2.revision_num = p_revision_num);
1568: ELSE

Line 3753: FROM po_lines_archive_all

3749: RETURN BOOLEAN
3750: IS
3751: CURSOR archived_line_csr IS
3752: SELECT 'Line archive records'
3753: FROM po_lines_archive_all
3754: WHERE po_line_id = p_po_line_id;
3755:
3756: l_archived_line_csr_type archived_line_csr%ROWTYPE;
3757: l_line_is_archived BOOLEAN;

Line 3967: cursor c is select po_line_id from po_lines_archive_all

3963: d_mod CONSTANT VARCHAR2(100) := D_archive_attribute_values;
3964: l_progress VARCHAR2(4) := '000';
3965:
3966: --bug 10349444
3967: cursor c is select po_line_id from po_lines_archive_all
3968: where po_header_id = p_po_header_id
3969: and revision_num = p_revision_num;
3970:
3971: l_po_line_id po_lines_all.po_line_id%type;

Line 4716: cursor c is select po_line_id from po_lines_archive_all

4712: d_mod CONSTANT VARCHAR2(100) := D_archive_attr_values_tlp;
4713: l_progress VARCHAR2(4) := '000';
4714:
4715: -- bug 10349444
4716: cursor c is select po_line_id from po_lines_archive_all
4717: where po_header_id = p_po_header_id
4718: and revision_num = p_revision_num;
4719:
4720: l_po_line_id po_lines_all.po_line_id%type;

Line 6191: PO_LINES_ALL POL, PO_LINES_ARCHIVE_ALL POLA

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 (+)
6195: AND Nvl(POL.revision_num,0) = p_revision_num

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'