APPS.PO_ARCHIVE_DOCUMENT_SV dependencies on PO_HEADERS

Line 65: from po_headers

61: savepoint archiving_po_document;
62:
63: begin
64: select revision_num into l_revision_num
65: from po_headers
66: where po_header_id = X_po_header_id;
67:
68: exception
69: when others then

Line 113: UPDATE PO_HEADERS_ARCHIVE

109: begin
110:
111: -- Set the latest_external_flag of the archived header to 'N'.
112:
113: UPDATE PO_HEADERS_ARCHIVE
114: SET latest_external_flag = 'N'
115: WHERE po_header_id = X_po_header_id
116: AND latest_external_flag = 'Y';
117:

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

115: WHERE po_header_id = X_po_header_id
116: AND latest_external_flag = 'Y';
117:
118: /* Archive the header.
119: This will be an exact copy of po_headers except for
120: the latest_external_flag. Keep the columns in
121: alphabetical order for easy verification.
122: */
123: INSERT INTO PO_HEADERS_ARCHIVE

Line 123: INSERT INTO PO_HEADERS_ARCHIVE

119: This will be an exact copy of po_headers except for
120: the latest_external_flag. Keep the columns in
121: alphabetical order for easy verification.
122: */
123: INSERT INTO PO_HEADERS_ARCHIVE
124: (
125: acceptance_due_date ,
126: acceptance_required_flag ,
127: agent_id ,

Line 310: FROM PO_HEADERS

306: vendor_id ,
307: vendor_order_num ,
308: vendor_site_id ,
309: consigned_consumption_flag -- FPI Consigned Inventory
310: FROM PO_HEADERS
311: WHERE PO_HEADER_ID = x_po_header_id;
312:
313: exception
314: when others then