DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 139: DELETE FROM po_line_locations_draft_all

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;
141:
142: DELETE FROM po_distributions_draft_all
143: WHERE draft_id = p_draft_id;

Line 1226: -- PO_LINE_LOCATIONS_DRAFT_ALL

1222: --Name: SYNC_LINE_LOCATIONS
1223: --Pre-reqs:
1224: -- None.
1225: --Modifies:
1226: -- PO_LINE_LOCATIONS_DRAFT_ALL
1227: --Locks:
1228: -- None.
1229: --Function:
1230: -- Syncs the po document line locations Draft.

Line 1263: INSERT INTO po_line_locations_draft_all

1259: IF (PO_LOG.d_stmt) THEN
1260: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
1261: END IF;
1262:
1263: INSERT INTO po_line_locations_draft_all
1264: ( draft_id,
1265: delete_flag,
1266: change_accepted_flag,
1267: change_status,