APPS.ECE_PO_ARCHIVE_PKG dependencies on PO_LINE_LOCATIONS_ARCHIVE

Line 960: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE

956: -- Archive the line locations.
957: -- This will be an exact copy of po_line_locations except for the
958: -- latest_external_flag and the revision_num. Keep the columns
959: -- in alphabetical order for easy verification.
960: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE
961: (
962: ACCRUE_ON_RECEIPT_FLAG ,
963: ALLOW_SUBSTITUTE_RECEIPTS_FLAG ,
964: APPROVED_DATE ,

Line 1150: PO_LINE_LOCATIONS_ARCHIVE POLA

1146: POL.UNIT_MEAS_LOOKUP_CODE ,
1147: POL.UNIT_OF_MEASURE_CLASS ,
1148: POL.USSGL_TRANSACTION_CODE
1149: FROM PO_LINE_LOCATIONS POL,
1150: PO_LINE_LOCATIONS_ARCHIVE POLA
1151: WHERE POL.PO_HEADER_ID = p_document_id
1152: AND POL.LINE_LOCATION_ID = POLA.LINE_LOCATION_ID (+)
1153: AND POLA.LATEST_EXTERNAL_FLAG (+) = 'Y'
1154: AND (

Line 1204: UPDATE PO_LINE_LOCATIONS_ARCHIVE POL1

1200: -- - latest_external_flag = 'Y'
1201: -- - revision_num < p_revision_num (the new revision of the
1202: -- header)
1203: -- - have no new archived row
1204: UPDATE PO_LINE_LOCATIONS_ARCHIVE POL1
1205: SET LATEST_EXTERNAL_FLAG = 'N'
1206: WHERE PO_HEADER_ID = p_document_id
1207: AND LATEST_EXTERNAL_FLAG = 'Y'
1208: AND REVISION_NUM < p_revision_num

Line 1211: FROM PO_LINE_LOCATIONS_ARCHIVE POL2

1207: AND LATEST_EXTERNAL_FLAG = 'Y'
1208: AND REVISION_NUM < p_revision_num
1209: AND EXISTS
1210: (SELECT 'A new archived row'
1211: FROM PO_LINE_LOCATIONS_ARCHIVE POL2
1212: WHERE POL2.LINE_LOCATION_ID = POL1.LINE_LOCATION_ID
1213: AND POL2.LATEST_EXTERNAL_FLAG = 'Y'
1214: AND POL2.REVISION_NUM = p_revision_num);
1215: END IF;

Line 1580: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE

1576: WHERE PO_RELEASE_ID = p_document_id;
1577:
1578:
1579: -- Archive the Shipments.
1580: INSERT INTO PO_LINE_LOCATIONS_ARCHIVE
1581: (
1582: ACCRUE_ON_RECEIPT_FLAG ,
1583: ALLOW_SUBSTITUTE_RECEIPTS_FLAG ,
1584: APPROVED_DATE ,

Line 1770: PO_LINE_LOCATIONS_ARCHIVE POLA

1766: POL.UNIT_MEAS_LOOKUP_CODE ,
1767: POL.UNIT_OF_MEASURE_CLASS ,
1768: POL.USSGL_TRANSACTION_CODE
1769: FROM PO_LINE_LOCATIONS POL,
1770: PO_LINE_LOCATIONS_ARCHIVE POLA
1771: WHERE POL.PO_RELEASE_ID = p_document_id
1772: AND POL.LINE_LOCATION_ID = POLA.LINE_LOCATION_ID (+)
1773: AND POLA.LATEST_EXTERNAL_FLAG (+) = 'Y'
1774: AND (

Line 1824: UPDATE PO_LINE_LOCATIONS_ARCHIVE POL1

1820: -- - latest_external_flag = 'Y'
1821: -- - revision_num < p_revision_num (the new revision of the
1822: -- header)
1823: -- - no new archived row
1824: UPDATE PO_LINE_LOCATIONS_ARCHIVE POL1
1825: SET LATEST_EXTERNAL_FLAG = 'N'
1826: WHERE PO_RELEASE_ID = p_document_id
1827: AND LATEST_EXTERNAL_FLAG = 'Y'
1828: AND REVISION_NUM < p_revision_num

Line 1831: FROM PO_LINE_LOCATIONS_ARCHIVE POL2

1827: AND LATEST_EXTERNAL_FLAG = 'Y'
1828: AND REVISION_NUM < p_revision_num
1829: AND EXISTS
1830: (SELECT 'A new archived row'
1831: FROM PO_LINE_LOCATIONS_ARCHIVE POL2
1832: WHERE POL2.LINE_LOCATION_ID = POL1.LINE_LOCATION_ID
1833: AND POL2.LATEST_EXTERNAL_FLAG = 'Y'
1834: AND POL2.REVISION_NUM = p_revision_num);
1835: