APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_LINES_INTERFACE

Line 304: 'PO_LINES_INTERFACE',

300: null,
301: X_interface_header_id,
302: X_interface_line_id,
303: 'PO_PDOI_INVALID_UOM_CODE',
304: 'PO_LINES_INTERFACE',
305: 'UNIT_OF_MEASURE',
306: 'VALUE',
307: null, null, null, null, null,
308: X_unit_of_measure,

Line 420: 'PO_LINES_INTERFACE',

416: null,
417: X_interface_header_id,
418: X_interface_line_id,
419: 'PO_PDOI_DIFF_ITEM_DESC',
420: 'PO_LINES_INTERFACE',
421: 'ITEM_DESCRIPTION',
422: null, null, null, null, null, null,
423: null, null, null, null, null, null,
424: X_header_processable_flag);

Line 610: update po_lines_interface

606: else
607: -- Price tolerance check failed.
608: -- Mark the line as Notified
609:
610: update po_lines_interface
611: set process_code = 'NOTIFIED'
612: where interface_line_id = X_interface_line_id
613: and interface_header_id = X_interface_header_id;
614:

Line 684: 'PO_LINES_INTERFACE',

680: null,
681: X_interface_header_id,
682: X_interface_line_id,
683: 'PO_PDOI_INVALID_UOM_CODE',
684: 'PO_LINES_INTERFACE',
685: 'UNIT_OF_MEASURE',
686: 'VALUE',
687: null,null, null, null, null,
688: x_unit_of_measure,

Line 746: 'PO_LINES_INTERFACE',

742: null,
743: X_interface_header_id,
744: X_interface_line_id,
745: 'PO_BLANKET_UPDATE_PRICE_BREAKS',
746: 'PO_LINES_INTERFACE',
747: 'UNIT_OF_MEASURE',
748: null,null, null, null, null, null,
749: null,null, null, null, null, null,
750: l_header_processable_flag );

Line 759: 'PO_LINES_INTERFACE',

755: null,
756: X_interface_header_id,
757: X_interface_line_id,
758: 'PO_BLANKET_UPDATE_PB_NO_CONV',
759: 'PO_LINES_INTERFACE',
760: 'UNIT_OF_MEASURE',
761: null,null, null, null, null, null,
762: null,null, null, null, null, null,
763: l_header_processable_flag );

Line 1409: from po_lines_interface

1405: END IF;
1406:
1407: begin
1408: select count(*) into l_number_of_items
1409: from po_lines_interface
1410: where interface_header_id = X_interface_header_id
1411: and process_code = 'NOTIFIED'
1412: and nvl(price_break_flag,'N') = 'N';
1413:

Line 1627: from po_lines_interface

1623: from po_headers_interface
1624: where interface_header_id = p_interface_header_id;
1625:
1626: select price_chg_accept_flag into l_acceptance_flag
1627: from po_lines_interface
1628: where interface_header_id = p_interface_header_id
1629: and interface_line_id = p_interface_line_id;
1630:
1631: IF (g_po_pdoi_write_to_file = 'Y') THEN

Line 1710: update po_lines_interface

1706: END IF;
1707:
1708: -- need to save the tolerance value at the line level as we would have to display it in the PRICAT form
1709:
1710: update po_lines_interface
1711: set price_update_tolerance = l_price_update_tolerance
1712: where interface_header_id = p_interface_header_id
1713: and interface_line_id = p_interface_line_id;
1714: