APPS.GMI_OM_UTILITIES_PKG dependencies on IC_TXN_REQUEST_LINES

Line 102: l_organization_id IC_TXN_REQUEST_LINES.organization_id%TYPE ;

98: l_mode VARCHAR2(2);
99: l_api_return_status VARCHAR2(10);
100: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
101: l_mo_line GMI_Move_Order_Global.mo_line_rec;
102: l_organization_id IC_TXN_REQUEST_LINES.organization_id%TYPE ;
103: l_quantity NUMBER := 0;
104: l_transaction_quantity NUMBER := 0;
105: l_secondary_quantity NUMBER := 0;
106: l_transaction_quantity2 NUMBER := 0;

Line 164: FROM IC_TXN_REQUEST_LINES

160:
161: IF l_mode = 'BO' THEN
162: SELECT organization_id
163: INTO l_organization_id
164: FROM IC_TXN_REQUEST_LINES
165: WHERE LINE_ID = l_line_id;
166:
167: l_shipping_attr(1).source_header_id := wdd_row.source_header_id;
168: l_shipping_attr(1).source_line_id := wdd_row.source_line_id;

Line 191: UPDATE IC_TXN_REQUEST_LINES

187:
188: CLOSE wdd_cur;
189:
190: IF (l_mode = 'BO') THEN
191: UPDATE IC_TXN_REQUEST_LINES
192: SET LINE_STATUS = 5,
193: quantity_detailed = quantity_detailed - nvl(l_trans_qty,0),
194: secondary_quantity_detailed = secondary_quantity_detailed - nvl(l_trans_qty2,0)
195: WHERE LINE_ID = l_line_id;--:TOLINES_BLK.LINE_ID;

Line 197: UPDATE IC_TXN_REQUEST_LINES

193: quantity_detailed = quantity_detailed - nvl(l_trans_qty,0),
194: secondary_quantity_detailed = secondary_quantity_detailed - nvl(l_trans_qty2,0)
195: WHERE LINE_ID = l_line_id;--:TOLINES_BLK.LINE_ID;
196: ELSE
197: UPDATE IC_TXN_REQUEST_LINES
198: SET quantity_detailed = quantity_detailed - nvl(l_trans_qty,0),
199: secondary_quantity_detailed = secondary_quantity_detailed - nvl(l_trans_qty2,0)
200: WHERE LINE_ID = l_line_id;--:TOLINES_BLK.LINE_ID;
201: END IF;