APPS.PO_ARCHIVE_DOCUMENT_SV dependencies on PO_HEADERS_ARCHIVE

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 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 ,