APPS.ECE_PO_ARCHIVE_PKG dependencies on PO_HEADERS

Line 150: -- archive PO_HEADERS

146: -- Case entity.document_type is
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

Line 157: -- archive PO_HEADERS

153: -- End Case
154: -- When PA
155: -- Case entity.document_subtype is
156: -- When BLANKET
157: -- archive PO_HEADERS
158: -- when modified archive PO_LINES.
159: -- When CONTRACT
160: -- archive PO_HEADERS
161: -- When RELEASE

Line 160: -- archive PO_HEADERS

156: -- When BLANKET
157: -- archive PO_HEADERS
158: -- when modified archive PO_LINES.
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

Line 312: FROM PO_HEADERS

308: -- If revision number does not exist (which should never be the
309: -- case), we default to 0.
310: SELECT NVL(REVISION_NUM, 0)
311: INTO l_revision_num
312: FROM PO_HEADERS
313: WHERE PO_HEADER_ID = p_document_id;
314: -- Assert: Purchase Order exists.
315: -- Check if Purchase Order is already archived.
316: -- If revision_num does not exist (which should never be the

Line 323: FROM PO_HEADERS_ARCHIVE

319: BEGIN
320:
321: SELECT NVL(REVISION_NUM, -1)
322: INTO l_archived_revision_num
323: FROM PO_HEADERS_ARCHIVE
324: WHERE PO_HEADER_ID = p_document_id
325: AND LATEST_EXTERNAL_FLAG = 'Y';
326:
327: EXCEPTION

Line 427: -- Desc: Archive PO_HEADERS

423:
424:
425: -- ============================================================================
426: -- Name: porarheader
427: -- Desc: Archive PO_HEADERS
428: -- Args: IN: p_document_id - The unique identifier of the Purchase Order
429: -- Err : Error message context returned in global_stack.
430: -- Algr: Set the LATEST_EXTERNAL_FLAG of the current archived header to "N"
431: -- Archive the Header.

Line 441: UPDATE PO_HEADERS_ARCHIVE

437: IS
438:
439: BEGIN
440:
441: UPDATE PO_HEADERS_ARCHIVE
442: SET LATEST_EXTERNAL_FLAG = 'N'
443: WHERE PO_HEADER_ID = p_document_id
444: AND LATEST_EXTERNAL_FLAG = 'Y';
445:

Line 447: -- This will be an exact copy of po_headers except for

443: WHERE PO_HEADER_ID = p_document_id
444: AND LATEST_EXTERNAL_FLAG = 'Y';
445:
446: -- Archive the header.
447: -- This will be an exact copy of po_headers except for
448: -- the latest_external_flag. Keep the columns in
449: -- alphabetical order for easy verification.
450: INSERT INTO PO_HEADERS_ARCHIVE
451: (

Line 450: INSERT INTO PO_HEADERS_ARCHIVE

446: -- Archive the header.
447: -- This will be an exact copy of po_headers except for
448: -- the latest_external_flag. Keep the columns in
449: -- alphabetical order for easy verification.
450: INSERT INTO PO_HEADERS_ARCHIVE
451: (
452: ACCEPTANCE_DUE_DATE ,
453: ACCEPTANCE_REQUIRED_FLAG ,
454: AGENT_ID ,

Line 633: FROM PO_HEADERS

629: VENDOR_CONTACT_ID ,
630: VENDOR_ID ,
631: VENDOR_ORDER_NUM ,
632: VENDOR_SITE_ID
633: FROM PO_HEADERS
634: WHERE PO_HEADER_ID = p_document_id;
635:
636:
637: EXCEPTION