APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_HEADERS

Line 240: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH

236: ,BH.BLANKET_MAX_AMOUNT
237: ,H.TRANSACTIONAL_CURR_CODE
238: ,H.CONVERSION_TYPE_CODE
239: ,'N' -- locked_flag
240: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH
241: WHERE H.HEADER_ID = p_blanket_header_id
242: AND H.ORDER_NUMBER = BH.ORDER_NUMBER
243: AND H.SALES_DOCUMENT_TYPE_CODE = 'B';
244:

Line 372: FROM oe_blanket_headers_all

368: oe_debug_pub.add('lock blanket header');
369: end if;
370: SELECT 'Y'
371: INTO g_blkt_hdr_tbl(x_blanket_header_id).locked_flag
372: FROM oe_blanket_headers_all
373: WHERE header_id = l_blanket_header_id --bug8465849
374: FOR UPDATE NOWAIT;
375: END IF;
376:

Line 945: UPDATE OE_BLANKET_HEADERS_EXT

941:
942: l_index := g_blkt_hdr_tbl.FIRST;
943: WHILE l_index IS NOT NULL LOOP
944:
945: UPDATE OE_BLANKET_HEADERS_EXT
946: SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
947: ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
948: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
949: FROM OE_BLANKET_HEADERS H

Line 949: FROM OE_BLANKET_HEADERS H

945: UPDATE OE_BLANKET_HEADERS_EXT
946: SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
947: ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
948: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
949: FROM OE_BLANKET_HEADERS H
950: WHERE H.HEADER_ID = g_blkt_hdr_tbl(l_index).header_id);
951:
952: UPDATE OE_BLANKET_HEADERS
953: SET LOCK_CONTROL = LOCK_CONTROL + 1

Line 952: UPDATE OE_BLANKET_HEADERS

948: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
949: FROM OE_BLANKET_HEADERS H
950: WHERE H.HEADER_ID = g_blkt_hdr_tbl(l_index).header_id);
951:
952: UPDATE OE_BLANKET_HEADERS
953: SET LOCK_CONTROL = LOCK_CONTROL + 1
954: WHERE HEADER_ID = g_blkt_hdr_tbl(l_index).header_id;--bug8465849
955:
956: l_index := g_blkt_hdr_tbl.NEXT(l_index);