APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_UDA_INTERFACE

Line 230: po_uda_interface pui

226: Cursor c_uda_intf(p_interface_header_id number) IS
227:
228: SELECT pui.interface_line_id
229: FROM po_headers_interface phi,
230: po_uda_interface pui
231: WHERE phi.interface_header_id = p_interface_header_id
232: AND phi.interface_header_id = pui.interface_reference_id
233: AND pui.attr_group_type = 'PO_HEADER_EXT_ATTRS'
234: UNION

Line 238: po_uda_interface pui

234: UNION
235: SELECT pui.interface_line_id
236: FROM po_headers_interface phi,
237: po_lines_interface pli,
238: po_uda_interface pui
239: WHERE phi.interface_header_id = p_interface_header_id
240: AND pli.interface_header_id = phi.interface_header_id
241: AND pli.interface_line_id = pui.interface_reference_id
242: AND pui.attr_group_type = 'PO_LINE_EXT_ATTRS'

Line 248: po_uda_interface pui

244: SELECT pui.interface_line_id
245: FROM po_headers_interface phi,
246: po_lines_interface pli,
247: po_line_locations_interface pll,
248: po_uda_interface pui
249: WHERE phi.interface_header_id = p_interface_header_id
250: AND pli.interface_header_id = phi.interface_header_id
251: AND pli.interface_line_id = pll.interface_line_id
252: AND pll.interface_line_location_id = pui.interface_reference_id

Line 337: UPDATE PO_UDA_INTERFACE

333: --po_header_id in case of header level attr
334: --po_line_id in case of line level attr
335: --LINE_LOCATION_ID in case of shipment level attr
336: forall i in 1..l_uda_lines_tbl.count
337: UPDATE PO_UDA_INTERFACE
338: SET pk1_value = Decode(attr_group_type, 'PO_HEADER_EXT_ATTRS', (SELECT po_header_id
339: FROM po_headers_interface
340: WHERE interface_header_id = interface_reference_id ),
341: 'PO_LINE_EXT_ATTRS' , (SELECT PO_LINE_ID

Line 4266: FROM po_uda_interface

4262: LOOP
4263:
4264: SELECT pk1_value, pk2_value, attr_group_type
4265: INTO l_pk1_value, l_pk2_value, l_attr_group_type
4266: FROM po_uda_interface
4267: WHERE Nvl(interface_line_id,-1) = p_uda_lines_tbl(i);
4268:
4269: --Call the api which imports uda data from intf_tabl to ext_tbl
4270: po_uda_import_pkg.IMPORT_UDA_ATTRS(l_attr_group_type, --ATTR_GROUP_TYPE

Line 4511: , p_table_name => 'PO_UDA_INTERFACE'

4507: p_interface_header_id => p_interface_header_id
4508: , p_column_name => 'N_EXT_ATTR20'
4509: , p_error_message_name => 'PO_PRICING_MISMATCH'
4510: , p_app_name => 'PO'
4511: , p_table_name => 'PO_UDA_INTERFACE'
4512: , p_column_value => null
4513: );
4514: l_error_count := l_error_count + 1;
4515: END;