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_UDA_DATA_UTIL dependencies on PO_REQ_HEADERS_EXT_TL

Line 2133: amd_tl_address_row PO_REQ_HEADERS_EXT_TL%ROWTYPE ;

2129: amd_address_row PO_REQ_HEADERS_EXT_B%ROWTYPE ;
2130: TYPE amd_address_row_table IS TABLE OF PO_REQ_HEADERS_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;
2131: amd_address_rows amd_address_row_table;
2132:
2133: amd_tl_address_row PO_REQ_HEADERS_EXT_TL%ROWTYPE ;
2134: TYPE amd_tl_address_row_table IS TABLE OF PO_REQ_HEADERS_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;
2135: amd_tl_address_rows amd_tl_address_row_table;
2136: l_attr_group_id NUMBER;
2137:

Line 2134: TYPE amd_tl_address_row_table IS TABLE OF PO_REQ_HEADERS_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;

2130: TYPE amd_address_row_table IS TABLE OF PO_REQ_HEADERS_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;
2131: amd_address_rows amd_address_row_table;
2132:
2133: amd_tl_address_row PO_REQ_HEADERS_EXT_TL%ROWTYPE ;
2134: TYPE amd_tl_address_row_table IS TABLE OF PO_REQ_HEADERS_EXT_TL%ROWTYPE INDEX BY BINARY_INTEGER;
2135: amd_tl_address_rows amd_tl_address_row_table;
2136: l_attr_group_id NUMBER;
2137:
2138: --Bug9441838: Added variable to hold the sequence value

Line 2162: SELECT * BULK COLLECT INTO amd_tl_address_rows FROM po_req_headers_ext_tl

2158: AND ATTR_GROUP_ID = l_attr_group_id;
2159:
2160: FOR row_b IN 1 .. amd_address_rows.Count LOOP
2161: -- First Fetch the TL records for the current Extension ID
2162: SELECT * BULK COLLECT INTO amd_tl_address_rows FROM po_req_headers_ext_tl
2163: WHERE requisition_header_id = x_amd_requisition_header_id
2164: AND ATTR_GROUP_ID = l_attr_group_id
2165: AND extension_id = amd_address_rows(row_b).extension_id;
2166:

Line 2181: UPDATE po_req_headers_ext_tl SET ROW = amd_tl_address_rows(row_tl)

2177:
2178: amd_tl_address_rows(row_tl).extension_id := amd_address_rows(row_b).extension_id;
2179: amd_tl_address_rows(row_tl).requisition_header_id := x_requisition_header_id;
2180:
2181: UPDATE po_req_headers_ext_tl SET ROW = amd_tl_address_rows(row_tl)
2182: WHERE extension_id IN ( SELECT extension_id FROM po_req_headers_ext_b
2183: WHERE C_EXT_ATTR39 = amd_address_rows(row_b).C_EXT_ATTR39
2184: AND attr_group_id = l_attr_group_id
2185: AND requisition_header_id = x_requisition_header_id)

Line 2186: AND po_req_headers_ext_tl.LANGUAGE = amd_tl_address_rows(row_tl).LANGUAGE;

2182: WHERE extension_id IN ( SELECT extension_id FROM po_req_headers_ext_b
2183: WHERE C_EXT_ATTR39 = amd_address_rows(row_b).C_EXT_ATTR39
2184: AND attr_group_id = l_attr_group_id
2185: AND requisition_header_id = x_requisition_header_id)
2186: AND po_req_headers_ext_tl.LANGUAGE = amd_tl_address_rows(row_tl).LANGUAGE;
2187:
2188: END LOOP;
2189:
2190: UPDATE po_req_headers_ext_b SET ROW = amd_address_rows(row_b)

Line 4781: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_object_ext_tl_table := 'PO_REQ_HEADERS_EXT_TL';

4777:
4778: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_object_name := 'PO_REQUISITION_HEADERS_ALL' ;
4779: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_dff_name := 'PO_REQ_HEADER_EXT_ATTRS';
4780: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_object_ext_b_table := 'PO_REQ_HEADERS_EXT_B';
4781: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_object_ext_tl_table := 'PO_REQ_HEADERS_EXT_TL';
4782: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_ag_mapping_column := 'REQ_HEADER_GROUP_ID';
4783:
4784: g_object_dff_tl('PO_REQ_LINE_EXT_ATTRS').l_object_name := 'PO_REQUISITION_LINES_ALL' ;
4785: g_object_dff_tl('PO_REQ_LINE_EXT_ATTRS').l_dff_name := 'PO_REQ_LINE_EXT_ATTRS';