APPS.PO_UDA_DATA_UTIL dependencies on PO_HEADERS_ALL_EXT_B

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