DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 142: DELETE FROM po_distributions_draft_all

138:
139: DELETE FROM po_line_locations_draft_all
140: WHERE draft_id = p_draft_id;
141:
142: DELETE FROM po_distributions_draft_all
143: WHERE draft_id = p_draft_id;
144: --End Deleting Headers/Lines/Shipments/Distributions
145:
146: --Start Deleting UDA Atribs

Line 1655: -- PO_DISTRIBUTIONS_DRAFT_ALL

1651: --Name: SYNC_DISTRIBUTIONS
1652: --Pre-reqs:
1653: -- None.
1654: --Modifies:
1655: -- PO_DISTRIBUTIONS_DRAFT_ALL
1656: --Locks:
1657: -- None.
1658: --Function:
1659: -- Arcives the po document distributions.

Line 1692: INSERT INTO po_distributions_draft_all

1688: IF (PO_LOG.d_stmt) THEN
1689: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
1690: END IF;
1691:
1692: INSERT INTO po_distributions_draft_all
1693: (
1694: draft_id,
1695: delete_flag,
1696: change_accepted_flag,