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.ECE_PO_ARCHIVE_PKG dependencies on PO_LINE_LOCATIONS

Line 151: -- when modified archive PO_LINES, PO_LINE_LOCATIONS and

147: -- When PO
148: -- Case entity.document_subtype is
149: -- When STANDARD or PLANNED
150: -- archive PO_HEADERS
151: -- when modified archive PO_LINES, PO_LINE_LOCATIONS and
152: -- PO_DISTRIBUTIONS.
153: -- End Case
154: -- When PA
155: -- Case entity.document_subtype is

Line 163: -- when modified archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS.

159: -- When CONTRACT
160: -- archive PO_HEADERS
161: -- When RELEASE
162: -- archive PO_RELEASES
163: -- when modified archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS.
164: -- End Case
165: -- Note: Private Procedure
166: -- ============================================================================
167:

Line 937: -- Desc: Archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

933: END PORARLINES;
934:
935: -- ============================================================================
936: -- Name: porarshipdist
937: -- Desc: Archive PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
938: -- Args: IN: p_document_id - The unique identifier of the Purchase Order
939: -- p_revision_num - The revision number of the header
940: -- Err : Error message context returned in global_stack.
941: -- Algr: Set the LATEST_EXTERNAL_FLAG of the currently archived line locations

Line 957: -- This will be an exact copy of po_line_locations except for the

953: IS
954:
955: BEGIN
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: (

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 1149: FROM PO_LINE_LOCATIONS POL,

1145: POL.UNENCUMBERED_QUANTITY ,
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'

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 1437: -- Desc: Archive PO_RELEASES, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS

1433: END PORARSHIPDIST;
1434:
1435: -- ============================================================================
1436: -- Name: porarrelease
1437: -- Desc: Archive PO_RELEASES, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1438: -- Args: IN: p_document_id - The unique identifier of the Release
1439: -- p_revision_num - The revision number of the header
1440: -- Err : Error message context returned in global_stack.
1441: -- Algr: Set the LATEST_EXTERNAL_FLAG of the currently archived release

Line 1444: -- Archive PO_LINE_LOCATIONS

1440: -- Err : Error message context returned in global_stack.
1441: -- Algr: Set the LATEST_EXTERNAL_FLAG of the currently archived release
1442: -- to "N"
1443: -- Archive PO_RELEASES
1444: -- Archive PO_LINE_LOCATIONS
1445: -- Archive PO_DISTRIBUTIONS
1446: -- Note: Private Procedure
1447: -- ============================================================================
1448:

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 1769: FROM PO_LINE_LOCATIONS POL,

1765: POL.UNENCUMBERED_QUANTITY ,
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'

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: