DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_GA_ORG_ASSIGN_DRAFT

Line 166: --Deleting from po_ga_org_assign_draft

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

Line 167: DELETE FROM po_ga_org_assign_draft

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

Line 2017: INSERT INTO po_ga_org_assign_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,