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.

[Home] [Help]

APPS.PO_UDA_DATA_UTIL dependencies on PO_HEADERS_ALL_EXT_TL

Line 2227: po_tl_address_row PO_HEADERS_ALL_EXT_TL%ROWTYPE ;

2223: po_address_row PO_HEADERS_ALL_EXT_B%ROWTYPE ;
2224: TYPE po_address_row_table IS TABLE OF PO_HEADERS_ALL_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;
2225: po_address_rows po_address_row_table;
2226:
2227: po_tl_address_row PO_HEADERS_ALL_EXT_TL%ROWTYPE ;
2228: TYPE po_tl_address_row_table IS TABLE OF PO_HEADERS_ALL_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;
2229: po_tl_address_rows po_tl_address_row_table;
2230: l_attr_group_id NUMBER;
2231: BEGIN

Line 2228: TYPE po_tl_address_row_table IS TABLE OF PO_HEADERS_ALL_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;

2224: TYPE po_address_row_table IS TABLE OF PO_HEADERS_ALL_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;
2225: po_address_rows po_address_row_table;
2226:
2227: po_tl_address_row PO_HEADERS_ALL_EXT_TL%ROWTYPE ;
2228: TYPE po_tl_address_row_table IS TABLE OF PO_HEADERS_ALL_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;
2229: po_tl_address_rows po_tl_address_row_table;
2230: l_attr_group_id NUMBER;
2231: BEGIN
2232:

Line 2253: SELECT * BULK COLLECT INTO po_tl_address_rows FROM po_headers_all_ext_tl

2249: AND draft_id = p_draft_id;
2250:
2251: FOR row_b IN 1 .. po_address_rows.Count LOOP
2252: -- First Fetch the TL records for the current Extension ID
2253: SELECT * BULK COLLECT INTO po_tl_address_rows FROM po_headers_all_ext_tl
2254: WHERE po_header_id = p_po_header_id
2255: AND draft_id = p_draft_id
2256: AND ATTR_GROUP_ID = l_attr_group_id
2257: AND extension_id = po_address_rows(row_b).extension_id;

Line 2275: UPDATE po_headers_all_ext_tl SET ROW = po_tl_address_rows(row_tl)

2271: po_tl_address_rows(row_tl).extension_id := po_address_rows(row_b).extension_id;
2272: po_tl_address_rows(row_tl).po_header_id := p_po_header_id;
2273: po_tl_address_rows(row_tl).draft_id := -1;
2274:
2275: UPDATE po_headers_all_ext_tl SET ROW = po_tl_address_rows(row_tl)
2276: WHERE extension_id IN ( SELECT extension_id FROM po_headers_all_ext_b
2277: WHERE C_EXT_ATTR39 = po_address_rows(row_b).C_EXT_ATTR39
2278: AND attr_group_id = l_attr_group_id
2279: AND po_header_id = p_po_header_id

Line 2281: AND po_headers_all_ext_tl.LANGUAGE = po_tl_address_rows(row_tl).LANGUAGE;

2277: WHERE C_EXT_ATTR39 = po_address_rows(row_b).C_EXT_ATTR39
2278: AND attr_group_id = l_attr_group_id
2279: AND po_header_id = p_po_header_id
2280: AND draft_id = -1)
2281: AND po_headers_all_ext_tl.LANGUAGE = po_tl_address_rows(row_tl).LANGUAGE;
2282:
2283: END LOOP;
2284:
2285: UPDATE po_headers_all_ext_b SET ROW = po_address_rows(row_b)

Line 4753: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_ext_tl_table := 'PO_HEADERS_ALL_EXT_TL';

4749:
4750: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_name := 'PO_HEADERS_ALL' ;
4751: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_dff_name := 'PO_HEADER_EXT_ATTRS';
4752: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_ext_b_table := 'PO_HEADERS_ALL_EXT_B';
4753: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_ext_tl_table := 'PO_HEADERS_ALL_EXT_TL';
4754: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_ag_mapping_column := 'PO_HEADER_GROUP_ID';
4755: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_arch_object_name := 'PO_HEADERS_ARCHIVE_ALL' ;
4756:
4757: g_object_dff_tl('PO_LINE_EXT_ATTRS').l_object_name := 'PO_LINES_ALL' ;