eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS

Line 642: Update oe_blanket_headers

638: */
639:
640: --11i10 Pricing Changes Start
641: if oe_code_control.get_code_release_level >= '110510' then
642: Update oe_blanket_headers
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 ;

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 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 656: Update oe_blanket_headers

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
655: THEN
656: Update oe_blanket_headers
657: set price_list_id = ppr_price_list_rec.list_header_id
658: where header_id = lheader_id;
659: g_header_rec.price_list_id := ppr_price_list_rec.list_header_id;
660: END IF;

Line 663: Update oe_blanket_headers

659: g_header_rec.price_list_id := ppr_price_list_rec.list_header_id;
660: END IF;
661: --End bug 3285562
662: else
663: Update oe_blanket_headers
664: set --qp_list_header_id = ppr_price_list_rec.list_header_id,
665: price_list_id = ppr_price_list_rec.list_header_id ,
666: lock_control = lock_control + 1
667: where header_id = lheader_id ;

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 4263: INSERT INTO OE_BLANKET_HEADERS

4259: l_org_id := OE_GLOBALS.G_ORG_ID;
4260:
4261: --l_org_id := to_number(FND_PROFILE.VALUE('ORG_ID'));
4262: -- for bug 3342548. Added column CONTEXT
4263: INSERT INTO OE_BLANKET_HEADERS
4264: ( ACCOUNTING_RULE_ID
4265: , AGREEMENT_ID
4266: , CONTEXT
4267: , ATTRIBUTE1

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 4518: UPDATE OE_BLANKET_HEADERS

4514: END IF;
4515: g_old_version_captured := TRUE;
4516: END IF;
4517: -- for bug 3342548. Added column CONTEXT
4518: UPDATE OE_BLANKET_HEADERS
4519: SET ACCOUNTING_RULE_ID = p_header_rec.accounting_rule_id
4520: , AGREEMENT_ID = p_header_rec.agreement_id
4521: , CONTEXT = p_header_rec.context
4522: , ATTRIBUTE1 = p_header_rec.attribute1

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 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 4750: DELETE FROM OE_BLANKET_HEADERS

4746: End Loop;
4747:
4748: --End bug
4749:
4750: DELETE FROM OE_BLANKET_HEADERS
4751: WHERE header_id = p_header_id;
4752:
4753: DELETE FROM OE_BLANKET_HEADERS_HIST
4754: WHERE header_id = p_header_id;

Line 4753: DELETE FROM OE_BLANKET_HEADERS_HIST

4749:
4750: DELETE FROM OE_BLANKET_HEADERS
4751: WHERE header_id = p_header_id;
4752:
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

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 5502: FROM OE_BLANKET_HEADERS_HIST bh

5498: , new_price_list_id
5499: , new_modifier_list_id
5500: , default_discount_percent
5501: , default_discount_amount
5502: FROM OE_BLANKET_HEADERS_HIST bh
5503: WHERE bh.header_id = p_header_id
5504: AND bh.sales_document_type_code = 'B'
5505: AND bh.version_number = p_version_number
5506: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

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);

Line 8115: INSERT INTO OE_BLANKET_HEADERS_HIST

8111: if l_debug_level > 0 then
8112: oe_debug_pub.ADD('Before inserting blanket history header_id ' || p_header_rec.header_id, 5);
8113: end if;
8114:
8115: INSERT INTO OE_BLANKET_HEADERS_HIST
8116: ( ACCOUNTING_RULE_ID
8117: , AGREEMENT_ID
8118: , ATTRIBUTE1
8119: , ATTRIBUTE10