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_HEADERS_ALL

Line 2223: po_address_row PO_HEADERS_ALL_EXT_B%ROWTYPE ;

2219: d_api_name CONSTANT VARCHAR2(30) := 'Merge_Mod_Address_AG';
2220: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2221: d_progress NUMBER;
2222:
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 ;

Line 2224: TYPE po_address_row_table IS TABLE OF PO_HEADERS_ALL_EXT_B%ROWTYPE INDEX BY BINARY_INTEGER;

2220: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name;
2221: d_progress NUMBER;
2222:
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;

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 2246: SELECT * BULK COLLECT INTO po_address_rows FROM po_headers_all_ext_b

2242: FROM EGO_ATTR_GROUPS_V
2243: WHERE ATTR_GROUP_TYPE = 'PO_HEADER_EXT_ATTRS'
2244: AND ATTR_GROUP_NAME = 'addresses';
2245:
2246: SELECT * BULK COLLECT INTO po_address_rows FROM po_headers_all_ext_b
2247: WHERE po_header_id = p_po_header_id
2248: AND ATTR_GROUP_ID = l_attr_group_id
2249: AND draft_id = p_draft_id;
2250:

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 2276: WHERE extension_id IN ( SELECT extension_id FROM po_headers_all_ext_b

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
2280: AND draft_id = -1)

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 2285: UPDATE po_headers_all_ext_b SET ROW = po_address_rows(row_b)

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)
2286: WHERE C_EXT_ATTR39 = po_address_rows(row_b).C_EXT_ATTR39
2287: AND attr_group_id = l_attr_group_id
2288: AND po_header_id = p_po_header_id
2289: AND draft_id = -1 ;

Line 2326: l_attr_grp_id PO_HEADERS_ALL_EXT_B.ATTR_GRouP_ID%TYPE;

2322: l_count NUMBER;
2323: j NUMBER ;
2324: i NUMBER := 1;
2325:
2326: l_attr_grp_id PO_HEADERS_ALL_EXT_B.ATTR_GRouP_ID%TYPE;
2327: BEGIN
2328:
2329: query := 'SELECT attr_group_id FROM '|| g_object_dff_tl(p_attr_grp_type).l_object_ext_b_table || ' WHERE ' || p_where_clause || ' AND pk1_value IS NULL';
2330: count_query := 'SELECT count(*) FROM '|| g_object_dff_tl(p_attr_grp_type).l_object_ext_b_table || ' WHERE ' || p_where_clause || ' AND pk1_value IS NULL';

Line 2778: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;

2774: d_progress NUMBER := 0;
2775: l_po_uda_usage_object po_uda_usage_object ;
2776: l_attr_grp_ids_list PO_TBL_NUMBER;
2777: l_x_attr_ids_count NUMBER;
2778: l_clm_standard_form PO_HEADERS_ALL.CLM_STANDARD_FORM%TYPE;
2779: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY ;
2780: l_attr_grp_ids PO_TBL_NUMBER;
2781: t_count NUMBER;
2782:

Line 2799: SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all

2795: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
2796: l_context := NULL;
2797:
2798: /* IF (c_get_usages_rec.attribute_category = 'FORMS') then
2799: SELECT clm_standard_form into l_clm_standard_form FROM po_headers_all
2800: WHERE po_header_id = p_po_header_id;
2801: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_NAME', l_clm_standard_form));
2802: END IF; */
2803:

Line 4750: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_name := 'PO_HEADERS_ALL' ;

4746: END get_attr_group_id;
4747:
4748: BEGIN
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';

Line 4752: g_object_dff_tl('PO_HEADER_EXT_ATTRS').l_object_ext_b_table := 'PO_HEADERS_ALL_EXT_B';

4748: BEGIN
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:

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' ;