APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS_EXT

Line 647: Update oe_blanket_headers_ext

643: set lock_control = lock_control + 1
644: ,last_updated_by = fnd_global.user_id
645: ,last_update_date = sysdate
646: where header_id = lheader_id ;
647: Update oe_blanket_headers_ext
648: set new_price_list_id = ppr_price_list_rec.list_header_id
649: where order_number = (select /* MOAC_SQL_CHANGE */ order_number
650: from oe_blanket_headers_all
651: where header_id = lheader_id);

Line 4414: INSERT INTO OE_BLANKET_HEADERS_EXT

4410: , p_header_rec.source_document_version_number
4411: );
4412: -- hashraf ... end of pack J
4413:
4414: INSERT INTO OE_BLANKET_HEADERS_EXT
4415: ( ORDER_NUMBER
4416: , START_DATE_ACTIVE
4417: , END_DATE_ACTIVE
4418: , on_hold_flag

Line 4591: UPDATE OE_BLANKET_HEADERS_EXT

4587: -- hashraf ... end of pack J
4588:
4589: WHERE header_id = p_header_rec.header_id;
4590:
4591: UPDATE OE_BLANKET_HEADERS_EXT
4592: SET
4593: START_DATE_ACTIVE = p_header_rec.START_DATE_ACTIVE
4594: , END_DATE_ACTIVE = p_header_rec.END_DATE_ACTIVE
4595: , on_hold_flag = p_header_rec.on_hold_flag

Line 4757: DELETE FROM OE_BLANKET_HEADERS_EXT

4753: DELETE FROM OE_BLANKET_HEADERS_HIST
4754: WHERE header_id = p_header_id;
4755:
4756: --for bug 3348870
4757: DELETE FROM OE_BLANKET_HEADERS_EXT
4758: WHERE order_number=l_order_number;
4759:
4760: if l_debug_level > 0 then
4761: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.DELETE_ROW', 1);

Line 5406: FROM OE_BLANKET_HEADERS bh, OE_BLANKET_HEADERS_EXT bhx

5402: , new_price_list_id
5403: , new_modifier_list_id
5404: , default_discount_percent
5405: , default_discount_amount
5406: FROM OE_BLANKET_HEADERS bh, OE_BLANKET_HEADERS_EXT bhx
5407: WHERE bh.order_number = bhx.order_number
5408: AND bh.header_id = p_header_id
5409: AND bh.sales_document_type_code = 'B';
5410:

Line 6529: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_HEADERS_EXT BHX

6525: l_temp_lock_control NUMBER;
6526:
6527: CURSOR c_blanket_header IS
6528: SELECT /* MOAC_SQL_CHANGE */ bh.lock_control
6529: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_HEADERS_EXT BHX
6530: WHERE BH.ORDER_NUMBER = BHX.ORDER_NUMBER
6531: AND BH.ORDER_NUMBER = p_blanket_id
6532: AND ORG_ID = MO_GLOBAL.get_current_org_id
6533: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'