DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 76: PO_HEADERS_ARCHIVE_ALL PHA

72: SELECT NVL(ph.revision_num, 0),
73: NVL(pha.revision_num, -1)
74: INTO x_revision_num, l_arch_revision_num
75: FROM PO_HEADERS_ALL PH,
76: PO_HEADERS_ARCHIVE_ALL PHA
77: WHERE ph.po_header_id = p_document_id
78: AND ph.approved_date IS NOT NULL
79: AND ph.approved_flag = 'Y'
80: AND ph.po_header_id = pha.po_header_id (+)

Line 227: UPDATE PO_HEADERS_ARCHIVE_ALL

223: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
224: 'Update PO_HEADERS_ARCHIVE to reset latest_external_flag');
225: END IF;
226:
227: UPDATE PO_HEADERS_ARCHIVE_ALL
228: SET latest_external_flag = 'N'
229: WHERE po_header_id = p_document_id
230: AND latest_external_flag = 'Y';
231:

Line 239: INSERT INTO PO_HEADERS_ARCHIVE_ALL

235: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
236: 'Insert PO_HEADERS_ARCHIVE ');
237: END IF;
238:
239: INSERT INTO PO_HEADERS_ARCHIVE_ALL
240: (acceptance_due_date ,
241: acceptance_required_flag ,
242: agent_id ,
243: amount_limit ,