APPS.ITG_SYNCPOINBOUND_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 617: FROM po_requisition_lines_all

613: CURSOR po_req_lines_csr IS
614: SELECT requisition_line_id,
615: quantity,
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)

Line 625: requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE,

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 (
625: requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE,
626: quantity po_requisition_lines_all.quantity%TYPE,
627: quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
628: );
629:

Line 626: quantity po_requisition_lines_all.quantity%TYPE,

622: ORDER BY need_by_date;
623:
624: TYPE po_req_lines_rec IS RECORD (
625: requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE,
626: quantity po_requisition_lines_all.quantity%TYPE,
627: quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
628: );
629:
630: TYPE po_req_lines_tab IS TABLE OF po_req_lines_rec

Line 627: quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE

623:
624: TYPE po_req_lines_rec IS RECORD (
625: requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE,
626: quantity po_requisition_lines_all.quantity%TYPE,
627: quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
628: );
629:
630: TYPE po_req_lines_tab IS TABLE OF po_req_lines_rec
631: INDEX BY BINARY_INTEGER;

Line 722: ITG_Debug.msg('ARL', 'Updating po_requisition_lines_all ...');

718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: /* Time to update the table */
722: ITG_Debug.msg('ARL', 'Updating po_requisition_lines_all ...');
723: ITG_Debug.msg('ARL', 'l_reqlltab.COUNT', l_reqlltab.COUNT);
724: FOR i IN 1 .. l_reqlltab.COUNT LOOP
725: UPDATE po_requisition_lines_all
726: SET quantity_delivered = l_reqlltab(i).quantity_delivered,

Line 725: UPDATE po_requisition_lines_all

721: /* Time to update the table */
722: ITG_Debug.msg('ARL', 'Updating po_requisition_lines_all ...');
723: ITG_Debug.msg('ARL', 'l_reqlltab.COUNT', l_reqlltab.COUNT);
724: FOR i IN 1 .. l_reqlltab.COUNT LOOP
725: UPDATE po_requisition_lines_all
726: SET quantity_delivered = l_reqlltab(i).quantity_delivered,
727: last_update_date = SYSDATE,
728: last_updated_by = FND_GLOBAL.user_id
729: WHERE requisition_line_id = l_reqlltab(i).requisition_line_id;