APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 650: from oe_blanket_headers_all

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);
652: g_header_rec.new_price_list_id := ppr_price_list_rec.list_header_id;
653: --for bug 3285562
654: IF g_header_rec.price_list_id is NULL

Line 4052: FROM OE_BLANKET_HEADERS_ALL

4048: THEN
4049:
4050: SELECT /* MOAC_SQL_CHANGE */ version_number
4051: INTO l_db_version_number
4052: FROM OE_BLANKET_HEADERS_ALL
4053: WHERE HEADER_ID = p_header_rec.header_id;
4054:
4055: if l_debug_level > 0 then
4056: oe_debug_pub.add('new version :'||p_header_rec.version_number);

Line 4683: FROM oe_blanket_headers_all

4679: BEGIN
4680:
4681: SELECT /* MOAC_SQL_CHANGE */ transaction_phase_code
4682: INTO l_transaction_phase_code
4683: FROM oe_blanket_headers_all
4684: WHERE header_id = p_header_id;
4685:
4686: --for bug 3348870
4687: SELECT order_number

Line 4689: FROM OE_BLANKET_HEADERS_ALL

4685:
4686: --for bug 3348870
4687: SELECT order_number
4688: INTO l_order_number
4689: FROM OE_BLANKET_HEADERS_ALL
4690: WHERE header_id=p_header_id;
4691:
4692: EXCEPTION
4693: WHEN OTHERS THEN

Line 5524: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE header_id = p_header_id;

5520: oe_debug_pub.add('Entering OE_BLANKET_UTIL.QUERY_ROW', 1);
5521: end if;
5522:
5523: IF p_version_number IS NOT NULL THEN
5524: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE header_id = p_header_id;
5525: END IF;
5526:
5527: IF p_version_number IS NULL OR
5528: p_version_number = l_current_version_number THEN

Line 6006: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE (header_id = p_header_id OR header_id = (select header_id from oe_blanket_lines_ALL where line_id = p_line_id));

6002:
6003: END IF;
6004:
6005: IF p_version_number IS NOT NULL THEN
6006: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE (header_id = p_header_id OR header_id = (select header_id from oe_blanket_lines_ALL where line_id = p_line_id));
6007: END IF;
6008:
6009:
6010: IF p_version_number IS NULL OR

Line 6350: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE header_id = p_header_id;

6346:
6347: x_return_status := FND_API.G_RET_STS_SUCCESS;
6348:
6349: IF p_version_number IS NOT NULL THEN
6350: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE header_id = p_header_id;
6351:
6352: IF l_version_number >= l_current_version_number THEN
6353: l_version_number := NULL;
6354: END IF;

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'

Line 7264: OE_BLANKET_HEADERS_ALL

7260: END IF;
7261:
7262: Select Count(header_id) into
7263: lcount From
7264: OE_BLANKET_HEADERS_ALL
7265: WHERE order_number = X_doc_sequence_value;
7266:
7267: IF lcount > 0 THEN
7268: fnd_message.set_name('ONT','OE_BLKT_NUM_EXISTS');

Line 7760: FROM oe_blanket_headers_all

7756: x_return_status := FND_API.G_RET_STS_SUCCESS;
7757:
7758: SELECT /* MOAC_SQL_CHANGE */ version_number
7759: INTO l_new_version_number
7760: FROM oe_blanket_headers_all
7761: WHERE header_id = g_old_header_hist_rec.header_id;
7762:
7763: if l_debug_level > 0 then
7764: oe_debug_pub.ADD('old versn :'||g_old_header_hist_rec.version_number);