APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINES_ALL_EXT_B

Line 150: DELETE FROM po_lines_all_ext_b

146: --Start Deleting UDA Atribs
147: DELETE FROM po_headers_all_ext_b
148: WHERE draft_id = p_draft_id;
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;

Line 3885: -- PO_LINES_ALL_EXT_B / PO_LINES_ALL_EXT_TL

3881: --Name: SYNC_UDA_ATTRIBS
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:

Line 3945: FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,

3941: AND revision_num = p_revision_num;
3942:
3943: CURSOR po_lines_ext_cursor IS
3944: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
3945: FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,
3946: PO_LINES_ALL POL
3947: WHERE POL.po_header_id = p_document_id
3948: AND POL.po_line_id = POLE.po_line_id
3949: AND POLE.draft_id = -1

Line 4390: -- Start PO_LINES_ALL_EXT_B

4386: OPEN po_lines_ext_cursor;
4387: FETCH po_lines_ext_cursor BULK COLLECT INTO l_old_line_ext_id_tbl, l_new_line_ext_id_tbl;
4388: CLOSE po_lines_ext_cursor;
4389:
4390: -- Start PO_LINES_ALL_EXT_B
4391: d_position := 80;
4392: IF PO_LOG.d_stmt THEN
4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;

Line 4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');

4389:
4390: -- Start PO_LINES_ALL_EXT_B
4391: d_position := 80;
4392: IF PO_LOG.d_stmt THEN
4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;
4395:
4396: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4397: INSERT INTO PO_LINES_ALL_EXT_B

Line 4397: INSERT INTO PO_LINES_ALL_EXT_B

4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;
4395:
4396: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4397: INSERT INTO PO_LINES_ALL_EXT_B
4398: (EXTENSION_ID
4399: ,ATTR_GROUP_ID
4400: ,PO_LINE_ID
4401: ,DATA_LEVEL_ID

Line 4612: FROM PO_LINES_ALL_EXT_B_ARCHIVE

4608: ,D_EXT_ATTR9
4609: ,D_EXT_ATTR10
4610: ,UDA_TEMPLATE_ID
4611: ,p_draft_id
4612: FROM PO_LINES_ALL_EXT_B_ARCHIVE
4613: WHERE extension_id = l_old_line_ext_id_tbl(i)
4614: AND revision_num = p_revision_num;
4615:
4616: d_position := 90;

Line 4620: -- End PO_LINES_ALL_EXT_B

4616: d_position := 90;
4617: IF PO_LOG.d_stmt THEN
4618: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4619: END IF;
4620: -- End PO_LINES_ALL_EXT_B
4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN