DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ALL_EXT_TL

Line 162: DELETE FROM po_line_locations_all_ext_tl

158:
159: DELETE FROM po_lines_all_ext_tl
160: WHERE draft_id = p_draft_id;
161:
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

Line 3886: -- PO_LINE_LOCATIONS_ALL_EXT_B / PO_LINE_LOCATIONS_ALL_EXT_TL

3882: --Pre-reqs: None
3883: --Modifies:
3884: -- PO_HEADERS_ALL_EXT_B / PO_HEADERS_ALL_EXT_TL
3885: -- PO_LINES_ALL_EXT_B / PO_LINES_ALL_EXT_TL
3886: -- PO_LINE_LOCATIONS_ALL_EXT_B / PO_LINE_LOCATIONS_ALL_EXT_TL
3887: --Locks:
3888: -- None.
3889: --Function:
3890: -- Sync UDA Data from Archive to Transaction Table

Line 4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');

4994:
4995: -- Start PO_LINE_LOC_ALL_EXT_TL
4996: d_position := 140;
4997: IF PO_LOG.d_stmt THEN
4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');
4999: END IF;
5000:
5001: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL

Line 5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL

4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');
4999: END IF;
5000:
5001: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL
5003: (EXTENSION_ID
5004: ,ATTR_GROUP_ID
5005: ,LINE_LOCATION_ID
5006: ,DATA_LEVEL_ID