APPS.PO_CHANGE_RESPONSE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 233: from po_line_locations_all

229:
230: if (p_po_release_id is null) then
231:
232: select count(*) into l_total_shipment_count
233: from po_line_locations_all
234: where po_header_id = p_po_header_id
235: and po_release_id is null
236: and nvl(cancel_flag, 'N') <> 'Y'
237: and nvl(closed_code, 'OPEN') = 'OPEN'

Line 243: from po_line_locations_all

239:
240: else
241:
242: select count(*) into l_total_shipment_count
243: from po_line_locations_all
244: where po_header_id = p_po_header_id
245: and po_release_id = p_po_release_id
246: and nvl(cancel_flag, 'N') <> 'Y'
247: and nvl(closed_code, 'OPEN') = 'OPEN'

Line 851: update po_line_locations_all

847: -- also update approved_flag of corresponding shipment if change request is rejected
848:
849: if (p_request_status = 'REJECTED') then
850:
851: update po_line_locations_all
852: set approved_flag = 'Y'
853: where line_location_id = p_line_location_id;
854:
855: end if;