APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS_ALL

Line 523: from oe_blanket_headers_all

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

Line 3858: FROM OE_BLANKET_HEADERS_ALL

3854: THEN
3855:
3856: SELECT /* MOAC_SQL_CHANGE */ version_number
3857: INTO l_db_version_number
3858: FROM OE_BLANKET_HEADERS_ALL
3859: WHERE HEADER_ID = p_header_rec.header_id;
3860:
3861: if l_debug_level > 0 then
3862: oe_debug_pub.add('new version :'||p_header_rec.version_number);

Line 4489: FROM oe_blanket_headers_all

4485: BEGIN
4486:
4487: SELECT /* MOAC_SQL_CHANGE */ transaction_phase_code
4488: INTO l_transaction_phase_code
4489: FROM oe_blanket_headers_all
4490: WHERE header_id = p_header_id;
4491:
4492: --for bug 3348870
4493: SELECT order_number

Line 4495: FROM OE_BLANKET_HEADERS_ALL

4491:
4492: --for bug 3348870
4493: SELECT order_number
4494: INTO l_order_number
4495: FROM OE_BLANKET_HEADERS_ALL
4496: WHERE header_id=p_header_id;
4497:
4498: EXCEPTION
4499: WHEN OTHERS THEN

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

5326: oe_debug_pub.add('Entering OE_BLANKET_UTIL.QUERY_ROW', 1);
5327: end if;
5328:
5329: IF p_version_number IS NOT NULL THEN
5330: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE header_id = p_header_id;
5331: END IF;
5332:
5333: IF p_version_number IS NULL OR
5334: p_version_number = l_current_version_number THEN

Line 5812: 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));

5808:
5809: END IF;
5810:
5811: IF p_version_number IS NOT NULL THEN
5812: 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));
5813: END IF;
5814:
5815:
5816: IF p_version_number IS NULL OR

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

6152:
6153: x_return_status := FND_API.G_RET_STS_SUCCESS;
6154:
6155: IF p_version_number IS NOT NULL THEN
6156: SELECT /* MOAC_SQL_CHANGE */ version_number INTO l_current_version_number FROM OE_BLANKET_HEADERS_ALL WHERE header_id = p_header_id;
6157:
6158: IF l_version_number >= l_current_version_number THEN
6159: l_version_number := NULL;
6160: END IF;

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'

Line 7070: OE_BLANKET_HEADERS_ALL

7066: END IF;
7067:
7068: Select Count(header_id) into
7069: lcount From
7070: OE_BLANKET_HEADERS_ALL
7071: WHERE order_number = X_doc_sequence_value;
7072:
7073: IF lcount > 0 THEN
7074: fnd_message.set_name('ONT','OE_BLKT_NUM_EXISTS');

Line 7563: FROM oe_blanket_headers_all

7559: x_return_status := FND_API.G_RET_STS_SUCCESS;
7560:
7561: SELECT /* MOAC_SQL_CHANGE */ version_number
7562: INTO l_new_version_number
7563: FROM oe_blanket_headers_all
7564: WHERE header_id = g_old_header_hist_rec.header_id;
7565:
7566: if l_debug_level > 0 then
7567: oe_debug_pub.ADD('old versn :'||g_old_header_hist_rec.version_number);