APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_LINES

Line 223: FROM OE_BLANKET_LINES L,OE_BLANKET_LINES_EXT BL

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

Line 255: FROM OE_BLANKET_LINES_EXT BL

251: end if;
252:
253: SELECT line_id
254: INTO x_blanket_line_id
255: FROM OE_BLANKET_LINES_EXT BL
256: WHERE BL.ORDER_NUMBER = p_blanket_number
257: AND BL.LINE_NUMBER = p_blanket_line_number;
258:
259: if l_debug_level > 0 then

Line 313: FROM oe_blanket_lines_all

309: oe_debug_pub.add('lock blanket line');
310: end if;
311: SELECT 'Y'
312: INTO g_blkt_line_tbl(x_blanket_line_id).locked_flag
313: FROM oe_blanket_lines_all
314: WHERE line_id = x_blanket_line_id
315: FOR UPDATE NOWAIT;
316: END IF;
317:

Line 944: UPDATE OE_BLANKET_LINES_EXT

940:
941: l_index := g_blkt_line_tbl.FIRST;
942: WHILE l_index IS NOT NULL LOOP
943:
944: UPDATE OE_BLANKET_LINES_EXT
945: SET RELEASED_AMOUNT = g_blkt_line_tbl(l_index).released_amount
946: ,RELEASED_QUANTITY = g_blkt_line_tbl(l_index).released_quantity
947: ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
948: ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity

Line 951: UPDATE OE_BLANKET_LINES

947: ,FULFILLED_AMOUNT = g_blkt_line_tbl(l_index).fulfilled_amount
948: ,FULFILLED_QUANTITY = g_blkt_line_tbl(l_index).fulfilled_quantity
949: WHERE LINE_ID = l_index;
950:
951: UPDATE OE_BLANKET_LINES
952: SET LOCK_CONTROL = LOCK_CONTROL + 1
953: WHERE LINE_ID = l_index;
954:
955: l_index := g_blkt_line_tbl.NEXT(l_index);