eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINES_ALL_EXT_TL

Line 159: DELETE FROM po_lines_all_ext_tl

155:
156: DELETE FROM po_headers_all_ext_tl
157: WHERE draft_id = p_draft_id;
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;

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 4622: -- Start PO_LINES_ALL_EXT_TL

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
4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;

Line 4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');

4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN
4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;
4627:
4628: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4629: INSERT INTO PO_LINES_ALL_EXT_TL

Line 4629: INSERT INTO PO_LINES_ALL_EXT_TL

4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;
4627:
4628: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4629: INSERT INTO PO_LINES_ALL_EXT_TL
4630: (EXTENSION_ID
4631: ,ATTR_GROUP_ID
4632: ,PO_LINE_ID
4633: ,DATA_LEVEL_ID

Line 4748: FROM PO_LINES_ALL_EXT_TL_ARCHIVE

4744: ,TL_EXT_ATTR39
4745: ,TL_EXT_ATTR40
4746: ,UDA_TEMPLATE_ID
4747: ,p_draft_id
4748: FROM PO_LINES_ALL_EXT_TL_ARCHIVE
4749: WHERE extension_id = l_old_line_ext_id_tbl(i)
4750: AND language = userenv('LANG')
4751: AND revision_num = p_revision_num;
4752:

Line 4757: -- End PO_LINES_ALL_EXT_TL

4753: d_position := 110;
4754: IF PO_LOG.d_stmt THEN
4755: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4756: END IF;
4757: -- End PO_LINES_ALL_EXT_TL
4758:
4759: OPEN po_line_loc_ext_cursor;
4760: FETCH po_line_loc_ext_cursor BULK COLLECT INTO l_old_line_loc_ext_id_tbl, l_new_line_loc_ext_id_tbl;
4761: CLOSE po_line_loc_ext_cursor;