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_B

Line 2129: amd_address_row PO_REQ_HEADERS_EXT_B%ROWTYPE ;

2125: d_api_name CONSTANT VARCHAR2(30) := 'Merge_Amendment_Address_AG';
2126: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2127: d_progress NUMBER;
2128:
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 ;

Line 2130: TYPE amd_address_row_table IS TABLE OF PO_REQ_HEADERS_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;

2126: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2127: d_progress NUMBER;
2128:
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;

Line 2156: SELECT * BULK COLLECT INTO amd_address_rows FROM po_req_headers_ext_b

2152: WHERE ATTR_GROUP_TYPE = 'PO_REQ_HEADER_EXT_ATTRS'
2153: AND ATTR_GROUP_NAME = 'addresses';
2154:
2155:
2156: SELECT * BULK COLLECT INTO amd_address_rows FROM po_req_headers_ext_b
2157: WHERE requisition_header_id = x_amd_requisition_header_id
2158: AND ATTR_GROUP_ID = l_attr_group_id;
2159:
2160: FOR row_b IN 1 .. amd_address_rows.Count LOOP

Line 2182: WHERE extension_id IN ( SELECT extension_id FROM po_req_headers_ext_b

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)
2186: AND po_req_headers_ext_tl.LANGUAGE = amd_tl_address_rows(row_tl).LANGUAGE;

Line 2190: UPDATE po_req_headers_ext_b SET ROW = amd_address_rows(row_b)

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)
2191: WHERE C_EXT_ATTR39 = amd_address_rows(row_b).C_EXT_ATTR39
2192: AND attr_group_id = l_attr_group_id
2193: AND requisition_header_id = x_requisition_header_id;
2194:

Line 4780: g_object_dff_tl('PO_REQ_HEADER_EXT_ATTRS').l_object_ext_b_table := 'PO_REQ_HEADERS_EXT_B';

4776: g_object_dff_tl('PO_DISTRIBUTIONS_EXT_ATTRS').l_arch_object_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL' ;
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' ;