162: DELETE FROM po_line_locations_all_ext_tl
163: WHERE draft_id = p_draft_id;
164: --End Deleting UDA Atribs
165:
166: --Deleting from po_ga_org_assign_draft
167: DELETE FROM po_ga_org_assign_draft
168: WHERE draft_id = p_draft_id;
169:
170: --Deleting from po_attribute_values
163: WHERE draft_id = p_draft_id;
164: --End Deleting UDA Atribs
165:
166: --Deleting from po_ga_org_assign_draft
167: DELETE FROM po_ga_org_assign_draft
168: WHERE draft_id = p_draft_id;
169:
170: --Deleting from po_attribute_values
171: DELETE FROM po_attribute_values_draft
2013: IF (PO_LOG.d_stmt) THEN
2014: PO_LOG.stmt(d_module, d_position, 'transfer records from archive to dft');
2015: END IF;
2016:
2017: INSERT INTO po_ga_org_assign_draft
2018: (
2019: draft_id,
2020: delete_flag,
2021: change_accepted_flag,