APPS.GMI_RESERVATION_UTIL dependencies on IC_TXN_REQUEST_LINES

Line 2328: l_ic_txn_request_lines ic_txn_request_lines%ROWTYPE;

2324:
2325: /* added by fabdi 20/08/2001 Bug 2023369 */
2326: locked_by_other_user EXCEPTION;
2327: PRAGMA EXCEPTION_INIT (locked_by_other_user,-54);
2328: l_ic_txn_request_lines ic_txn_request_lines%ROWTYPE;
2329: l_NEW_ALLOCATED_QTY NUMBER;
2330: l_NEW_ALLOCATED_QTY2 NUMBER;
2331: l_whse_ctl NUMBER;
2332: l_lock_status BOOLEAN;

Line 2998: into l_ic_txn_request_lines

2994: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, p_mo_line_id = '||p_mo_line_id, 'pick_lots.log');
2995: if p_mo_line_id IS NOT NULL
2996: THEN
2997: select *
2998: into l_ic_txn_request_lines
2999: from ic_txn_request_lines
3000: where LINE_ID = p_mo_line_id
3001: for update OF quantity_detailed, secondary_quantity_detailed NOWAIT;
3002:

Line 2999: from ic_txn_request_lines

2995: if p_mo_line_id IS NOT NULL
2996: THEN
2997: select *
2998: into l_ic_txn_request_lines
2999: from ic_txn_request_lines
3000: where LINE_ID = p_mo_line_id
3001: for update OF quantity_detailed, secondary_quantity_detailed NOWAIT;
3002:
3003: OPEN get_whse_ctl(l_organization_id);

Line 3055: update ic_txn_request_lines

3051: IF SQL%FOUND THEN
3052: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, l_NEW_ALLOCATED_QTY= '||l_NEW_ALLOCATED_QTY, 'pick_lots.log');
3053: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, l_NEW_ALLOCATED_QTY2= '||l_NEW_ALLOCATED_QTY2, 'pick_lots.log');
3054:
3055: update ic_txn_request_lines
3056: set quantity_detailed = nvl(quantity_delivered,0) + NVL(l_NEW_ALLOCATED_QTY,0)
3057: , secondary_quantity_detailed = nvl(secondary_quantity_delivered,0) + NVL(l_NEW_ALLOCATED_QTY2,0)
3058: where line_id = p_mo_line_id;
3059: ELSE