APPS.ITG_SYNCPOINBOUND_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 222: FROM po_line_locations_all

218: receive_close_tolerance,
219: NVL(need_by_date, promised_date) process_date,
220: 0 new_quantity,
221: 0 changed
222: FROM po_line_locations_all
223: WHERE po_line_id = l_rec.po_line_id
224: ORDER BY process_date;
225: ELSE
226: /* Negative quantity, this is a RETURN against standard POs.

Line 242: FROM po_line_locations_all

238: receive_close_tolerance,
239: NVL(promised_date, need_by_date) process_date,
240: 0 new_quantity,
241: 0 changed
242: FROM po_line_locations_all
243: WHERE po_line_id = l_rec.po_line_id
244: ORDER BY process_date DESC;
245: END IF;
246: ELSE

Line 266: FROM po_line_locations_all

262: receive_close_tolerance,
263: NVL(need_by_date, promised_date) process_date,
264: 0 new_quantity,
265: 0 changed
266: FROM po_line_locations_all
267: WHERE po_release_id = l_release_id
268: AND po_header_id = g_po_id
269: ORDER BY process_date;
270: ELSE

Line 287: FROM po_line_locations_all

283: receive_close_tolerance,
284: NVL(promised_date, need_by_date) process_date,
285: 0 new_quantity,
286: 0 changed
287: FROM po_line_locations_all
288: WHERE po_release_id = l_release_id
289: AND po_header_id = g_po_id
290: ORDER BY process_date DESC;
291: END IF;

Line 620: FROM po_line_locations_all

616: quantity_delivered
617: FROM po_requisition_lines_all
618: WHERE line_location_id IN (
619: SELECT line_location_id
620: FROM po_line_locations_all
621: WHERE po_line_id = l_rec.po_line_id)
622: ORDER BY need_by_date;
623:
624: TYPE po_req_lines_rec IS RECORD (

Line 787: ITG_Debug.msg('PRD', 'update po_line_locations_all');

783: l_lltab(i).new_quantity, 0);
784: aa_rllocs(l_lltab(i).new_quantity);
785: END IF;
786:
787: ITG_Debug.msg('PRD', 'update po_line_locations_all');
788: UPDATE po_line_locations_all
789: SET quantity_received = l_lltab(i).quantity_received,
790: last_update_date = SYSDATE,
791: last_updated_by = FND_GLOBAL.user_id

Line 788: UPDATE po_line_locations_all

784: aa_rllocs(l_lltab(i).new_quantity);
785: END IF;
786:
787: ITG_Debug.msg('PRD', 'update po_line_locations_all');
788: UPDATE po_line_locations_all
789: SET quantity_received = l_lltab(i).quantity_received,
790: last_update_date = SYSDATE,
791: last_updated_by = FND_GLOBAL.user_id
792: WHERE line_location_id = l_lltab(i).line_location_id;

Line 869: UPDATE po_line_locations_all

865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868: FOR i IN 1 .. l_lltab.count LOOP
869: UPDATE po_line_locations_all
870: SET quantity_accepted = l_lltab(i).quantity_accepted,
871: last_update_date = SYSDATE,
872: last_updated_by = FND_GLOBAL.user_id
873: WHERE line_location_id = l_lltab(i).line_location_id;

Line 874: ITG_Debug.msg('PID', 'Update po_line_locations_all');

870: SET quantity_accepted = l_lltab(i).quantity_accepted,
871: last_update_date = SYSDATE,
872: last_updated_by = FND_GLOBAL.user_id
873: WHERE line_location_id = l_lltab(i).line_location_id;
874: ITG_Debug.msg('PID', 'Update po_line_locations_all');
875: ITG_Debug.msg('PID', 'quantity_accepted',
876: l_lltab(i).quantity_accepted);
877: ITG_Debug.msg('PID', 'line_location_id',
878: l_lltab(i).line_location_id);

Line 934: ITG_Debug.msg('PI', 'Update po_line_locations_all ...');

930: l_closed_code := get_closed_code(
931: l_lltab(i), l_lltab(i).quantity_billed);
932:
933: /* Update the table for the quantity billed */
934: ITG_Debug.msg('PI', 'Update po_line_locations_all ...');
935: ITG_Debug.msg('PI', 'quantity_billed', l_lltab(i).quantity_billed);
936: ITG_Debug.msg('PI', 'line_location_id', l_lltab(i).line_location_id);
937: UPDATE po_line_locations_all
938: SET quantity_billed = l_lltab(i).quantity_billed,

Line 937: UPDATE po_line_locations_all

933: /* Update the table for the quantity billed */
934: ITG_Debug.msg('PI', 'Update po_line_locations_all ...');
935: ITG_Debug.msg('PI', 'quantity_billed', l_lltab(i).quantity_billed);
936: ITG_Debug.msg('PI', 'line_location_id', l_lltab(i).line_location_id);
937: UPDATE po_line_locations_all
938: SET quantity_billed = l_lltab(i).quantity_billed,
939: last_update_date = SYSDATE,
940: last_updated_by = FND_GLOBAL.user_id
941: WHERE line_location_id = l_lltab(i).line_location_id;