APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS_EXT

Line 520: Update oe_blanket_headers_ext

516: set lock_control = lock_control + 1
517: ,last_updated_by = fnd_global.user_id
518: ,last_update_date = sysdate
519: where header_id = lheader_id ;
520: Update oe_blanket_headers_ext
521: set new_price_list_id = ppr_price_list_rec.list_header_id
522: where order_number = (select /* MOAC_SQL_CHANGE */ order_number
523: from oe_blanket_headers_all
524: where header_id = lheader_id);

Line 4220: INSERT INTO OE_BLANKET_HEADERS_EXT

4216: , p_header_rec.source_document_version_number
4217: );
4218: -- hashraf ... end of pack J
4219:
4220: INSERT INTO OE_BLANKET_HEADERS_EXT
4221: ( ORDER_NUMBER
4222: , START_DATE_ACTIVE
4223: , END_DATE_ACTIVE
4224: , on_hold_flag

Line 4397: UPDATE OE_BLANKET_HEADERS_EXT

4393: -- hashraf ... end of pack J
4394:
4395: WHERE header_id = p_header_rec.header_id;
4396:
4397: UPDATE OE_BLANKET_HEADERS_EXT
4398: SET
4399: START_DATE_ACTIVE = p_header_rec.START_DATE_ACTIVE
4400: , END_DATE_ACTIVE = p_header_rec.END_DATE_ACTIVE
4401: , on_hold_flag = p_header_rec.on_hold_flag

Line 4563: DELETE FROM OE_BLANKET_HEADERS_EXT

4559: DELETE FROM OE_BLANKET_HEADERS_HIST
4560: WHERE header_id = p_header_id;
4561:
4562: --for bug 3348870
4563: DELETE FROM OE_BLANKET_HEADERS_EXT
4564: WHERE order_number=l_order_number;
4565:
4566: if l_debug_level > 0 then
4567: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.DELETE_ROW', 1);

Line 5212: FROM OE_BLANKET_HEADERS bh, OE_BLANKET_HEADERS_EXT bhx

5208: , new_price_list_id
5209: , new_modifier_list_id
5210: , default_discount_percent
5211: , default_discount_amount
5212: FROM OE_BLANKET_HEADERS bh, OE_BLANKET_HEADERS_EXT bhx
5213: WHERE bh.order_number = bhx.order_number
5214: AND bh.header_id = p_header_id
5215: AND bh.sales_document_type_code = 'B';
5216:

Line 6335: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_HEADERS_EXT BHX

6331: l_temp_lock_control NUMBER;
6332:
6333: CURSOR c_blanket_header IS
6334: SELECT /* MOAC_SQL_CHANGE */ bh.lock_control
6335: FROM OE_BLANKET_HEADERS_ALL BH, OE_BLANKET_HEADERS_EXT BHX
6336: WHERE BH.ORDER_NUMBER = BHX.ORDER_NUMBER
6337: AND BH.ORDER_NUMBER = p_blanket_id
6338: AND ORG_ID = MO_GLOBAL.get_current_org_id
6339: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'