DBA Data[Home] [Help]

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ALL_EXT_B

Line 153: DELETE FROM po_line_locations_all_ext_b

149:
150: DELETE FROM po_lines_all_ext_b
151: WHERE draft_id = p_draft_id;
152:
153: DELETE FROM po_line_locations_all_ext_b
154: WHERE draft_id = p_draft_id;
155:
156: DELETE FROM po_headers_all_ext_tl
157: WHERE draft_id = p_draft_id;

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 4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');

4762:
4763: -- Start PO_LINE_LOC_ALL_EXT_B
4764: d_position := 120;
4765: IF PO_LOG.d_stmt THEN
4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');
4767: END IF;
4768:
4769: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B

Line 4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B

4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');
4767: END IF;
4768:
4769: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B
4771: (EXTENSION_ID
4772: ,ATTR_GROUP_ID
4773: ,LINE_LOCATION_ID
4774: ,DATA_LEVEL_ID