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.

[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADERS

Line 515: Update oe_blanket_headers

511:
512:
513: --11i10 Pricing Changes Start
514: if oe_code_control.get_code_release_level >= '110510' then
515: Update oe_blanket_headers
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 ;

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

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
528: THEN
529: Update oe_blanket_headers
530: set price_list_id = ppr_price_list_rec.list_header_id
531: where header_id = lheader_id;
532: g_header_rec.price_list_id := ppr_price_list_rec.list_header_id;
533: END IF;

Line 536: Update oe_blanket_headers

532: g_header_rec.price_list_id := ppr_price_list_rec.list_header_id;
533: END IF;
534: --End bug 3285562
535: else
536: Update oe_blanket_headers
537: set --qp_list_header_id = ppr_price_list_rec.list_header_id,
538: price_list_id = ppr_price_list_rec.list_header_id ,
539: lock_control = lock_control + 1
540: where header_id = lheader_id ;

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

4065: l_org_id := OE_GLOBALS.G_ORG_ID;
4066:
4067: --l_org_id := to_number(FND_PROFILE.VALUE('ORG_ID'));
4068: -- for bug 3342548. Added column CONTEXT
4069: INSERT INTO OE_BLANKET_HEADERS
4070: ( ACCOUNTING_RULE_ID
4071: , AGREEMENT_ID
4072: , CONTEXT
4073: , ATTRIBUTE1

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

4320: END IF;
4321: g_old_version_captured := TRUE;
4322: END IF;
4323: -- for bug 3342548. Added column CONTEXT
4324: UPDATE OE_BLANKET_HEADERS
4325: SET ACCOUNTING_RULE_ID = p_header_rec.accounting_rule_id
4326: , AGREEMENT_ID = p_header_rec.agreement_id
4327: , CONTEXT = p_header_rec.context
4328: , ATTRIBUTE1 = p_header_rec.attribute1

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

4552: End Loop;
4553:
4554: --End bug
4555:
4556: DELETE FROM OE_BLANKET_HEADERS
4557: WHERE header_id = p_header_id;
4558:
4559: DELETE FROM OE_BLANKET_HEADERS_HIST
4560: WHERE header_id = p_header_id;

Line 4559: DELETE FROM OE_BLANKET_HEADERS_HIST

4555:
4556: DELETE FROM OE_BLANKET_HEADERS
4557: WHERE header_id = p_header_id;
4558:
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

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

5304: , new_price_list_id
5305: , new_modifier_list_id
5306: , default_discount_percent
5307: , default_discount_amount
5308: FROM OE_BLANKET_HEADERS_HIST bh
5309: WHERE bh.header_id = p_header_id
5310: AND bh.sales_document_type_code = 'B'
5311: AND bh.version_number = p_version_number
5312: AND (PHASE_CHANGE_FLAG = p_phase_change_flag

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

Line 7918: INSERT INTO OE_BLANKET_HEADERS_HIST

7914: if l_debug_level > 0 then
7915: oe_debug_pub.ADD('Before inserting blanket history header_id ' || p_header_rec.header_id, 5);
7916: end if;
7917:
7918: INSERT INTO OE_BLANKET_HEADERS_HIST
7919: ( ACCOUNTING_RULE_ID
7920: , AGREEMENT_ID
7921: , ATTRIBUTE1
7922: , ATTRIBUTE10