APPS.OE_BLKT_RELEASE_UTIL dependencies on OE_BLANKET_HEADERS

Line 237: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH

233: ,BH.BLANKET_MAX_AMOUNT
234: ,H.TRANSACTIONAL_CURR_CODE
235: ,H.CONVERSION_TYPE_CODE
236: ,'N' -- locked_flag
237: FROM OE_BLANKET_HEADERS H,OE_BLANKET_HEADERS_EXT BH
238: WHERE H.HEADER_ID = x_blanket_header_id
239: AND H.ORDER_NUMBER = BH.ORDER_NUMBER
240: AND H.SALES_DOCUMENT_TYPE_CODE = 'B';
241: --

Line 358: FROM oe_blanket_headers_all

354: oe_debug_pub.add('lock blanket header');
355: end if;
356: SELECT 'Y'
357: INTO g_blkt_hdr_tbl(x_blanket_header_id).locked_flag
358: FROM oe_blanket_headers_all
359: WHERE header_id = x_blanket_header_id
360: FOR UPDATE NOWAIT;
361: END IF;
362:

Line 926: UPDATE OE_BLANKET_HEADERS_EXT

922:
923: l_index := g_blkt_hdr_tbl.FIRST;
924: WHILE l_index IS NOT NULL LOOP
925:
926: UPDATE OE_BLANKET_HEADERS_EXT
927: SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
928: ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
929: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
930: FROM OE_BLANKET_HEADERS H

Line 930: FROM OE_BLANKET_HEADERS H

926: UPDATE OE_BLANKET_HEADERS_EXT
927: SET RELEASED_AMOUNT = g_blkt_hdr_tbl(l_index).released_amount
928: ,FULFILLED_AMOUNT = g_blkt_hdr_tbl(l_index).fulfilled_amount
929: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
930: FROM OE_BLANKET_HEADERS H
931: WHERE H.HEADER_ID = l_index);
932:
933: UPDATE OE_BLANKET_HEADERS
934: SET LOCK_CONTROL = LOCK_CONTROL + 1

Line 933: UPDATE OE_BLANKET_HEADERS

929: WHERE ORDER_NUMBER IN (SELECT H.ORDER_NUMBER
930: FROM OE_BLANKET_HEADERS H
931: WHERE H.HEADER_ID = l_index);
932:
933: UPDATE OE_BLANKET_HEADERS
934: SET LOCK_CONTROL = LOCK_CONTROL + 1
935: WHERE HEADER_ID = l_index;
936:
937: l_index := g_blkt_hdr_tbl.NEXT(l_index);