APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_LINES

Line 225: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL

221: ,L.ORDER_QUANTITY_UOM
222: ,nvl(BL.RETURNED_QUANTITY,0)
223: ,nvl(BL.RETURNED_AMOUNT,0)
224: ,'N' -- locked_flag
225: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL
226: WHERE L.LINE_ID = p_blanket_line_id
227: AND L.LINE_ID = BL.LINE_ID
228: AND L.SALES_DOCUMENT_TYPE_CODE = 'B';
229:

Line 262: FROM OE_BLANKET_LINES_EXT BL

258: end if;
259:
260: SELECT line_id
261: INTO x_blanket_line_id
262: FROM OE_BLANKET_LINES_EXT BL
263: WHERE BL.ORDER_NUMBER = p_blanket_number
264: AND BL.LINE_NUMBER = p_blanket_line_number;
265:
266: l_blanket_line_id := x_blanket_line_id;

Line 325: FROM oe_blanket_lines_all

321: oe_debug_pub.add('lock blanket line');
322: end if;
323: SELECT 'Y'
324: INTO g_blkt_line_tbl(x_blanket_line_id).locked_flag
325: FROM oe_blanket_lines_all
326: WHERE line_id = l_blanket_line_id --bug8465849
327: FOR UPDATE NOWAIT;
328: END IF;
329:

Line 965: UPDATE OE_BLANKET_LINES_EXT

961:
962: l_index := g_blkt_line_tbl.FIRST;
963: WHILE l_index IS NOT NULL LOOP
964:
965: UPDATE OE_BLANKET_LINES_EXT
966: SET RELEASED_AMOUNT = g_blkt_line_tbl(l_index).released_amount
967: ,RELEASED_QUANTITY = g_blkt_line_tbl(l_index).released_quantity
968: ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
969: ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity

Line 972: UPDATE OE_BLANKET_LINES

968: ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
969: ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity
970: WHERE LINE_ID = g_blkt_line_tbl(l_index).line_id;
971:
972: UPDATE OE_BLANKET_LINES
973: SET LOCK_CONTROL = LOCK_CONTROL + 1
974: WHERE LINE_ID = g_blkt_line_tbl(l_index).line_id;--bug8465849
975:
976: l_index := g_blkt_line_tbl.NEXT(l_index);