DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 133: DELETE FROM po_headers_draft_all

129: DELETE FROM po_drafts
130: WHERE draft_id = p_draft_id;
131:
132: --Start Deleting Headers/Lines/Shipments/Distributions
133: DELETE FROM po_headers_draft_all
134: WHERE draft_id = p_draft_id;
135:
136: DELETE FROM po_lines_draft_all
137: WHERE draft_id = p_draft_id;

Line 313: -- PO_HEADERS_DRAFT_ALL

309: --Name: SYNC_HEADER
310: --Pre-reqs:
311: -- None.
312: --Modifies:
313: -- PO_HEADERS_DRAFT_ALL
314: --Locks:
315: -- None.
316: --Function:
317: -- Sync PO Header

Line 351: INSERT INTO po_headers_draft_all

347: IF (PO_LOG.d_stmt) THEN
348: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
349: END IF;
350:
351: INSERT INTO po_headers_draft_all
352: ( draft_id,
353: delete_flag,
354: change_accepted_flag,
355: change_status,