APPS.GMI_RESERVATION_UTIL dependencies on IC_TXN_REQUEST_LINES

Line 2316: l_ic_txn_request_lines ic_txn_request_lines%ROWTYPE;

2312:
2313: /* added by fabdi 20/08/2001 Bug 2023369 */
2314: locked_by_other_user EXCEPTION;
2315: PRAGMA EXCEPTION_INIT (locked_by_other_user,-54);
2316: l_ic_txn_request_lines ic_txn_request_lines%ROWTYPE;
2317: l_NEW_ALLOCATED_QTY NUMBER;
2318: l_NEW_ALLOCATED_QTY2 NUMBER;
2319: l_whse_ctl NUMBER;
2320: l_lock_status BOOLEAN;

Line 2986: into l_ic_txn_request_lines

2982: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, p_mo_line_id = '||p_mo_line_id, 'pick_lots.log');
2983: if p_mo_line_id IS NOT NULL
2984: THEN
2985: select *
2986: into l_ic_txn_request_lines
2987: from ic_txn_request_lines
2988: where LINE_ID = p_mo_line_id
2989: for update OF quantity_detailed, secondary_quantity_detailed NOWAIT;
2990:

Line 2987: from ic_txn_request_lines

2983: if p_mo_line_id IS NOT NULL
2984: THEN
2985: select *
2986: into l_ic_txn_request_lines
2987: from ic_txn_request_lines
2988: where LINE_ID = p_mo_line_id
2989: for update OF quantity_detailed, secondary_quantity_detailed NOWAIT;
2990:
2991: OPEN get_whse_ctl(l_organization_id);

Line 3043: update ic_txn_request_lines

3039: IF SQL%FOUND THEN
3040: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, l_NEW_ALLOCATED_QTY= '||l_NEW_ALLOCATED_QTY, 'pick_lots.log');
3041: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, l_NEW_ALLOCATED_QTY2= '||l_NEW_ALLOCATED_QTY2, 'pick_lots.log');
3042:
3043: update ic_txn_request_lines
3044: set quantity_detailed = nvl(quantity_delivered,0) + NVL(l_NEW_ALLOCATED_QTY,0)
3045: , secondary_quantity_detailed = nvl(secondary_quantity_delivered,0) + NVL(l_NEW_ALLOCATED_QTY2,0)
3046: where line_id = p_mo_line_id;
3047: ELSE