DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINES_DRAFT_ALL

Line 136: DELETE FROM po_lines_draft_all

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;
138:
139: DELETE FROM po_line_locations_draft_all
140: WHERE draft_id = p_draft_id;

Line 773: -- PO_LINES_DRAFT_ALL

769: --Name: SYNC_LINES
770: --Pre-reqs:
771: -- None.
772: --Modifies:
773: -- PO_LINES_DRAFT_ALL
774: --Locks:
775: -- None.
776: --Function:
777: -- Arcives the po document lines.

Line 811: INSERT INTO po_lines_draft_all

807: IF (PO_LOG.d_stmt) THEN
808: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
809: END IF;
810:
811: INSERT INTO po_lines_draft_all
812: (
813: draft_id,
814: delete_flag,
815: change_accepted_flag,