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_LINES

Line 549: Update oe_blanket_lines

545: K := ppr_price_list_line_tbl.first;
546: WHILE K is not null
547: LOOP
548:
549: Update oe_blanket_lines
550: set
551: price_list_id = ppr_price_list_rec.list_header_id,
552: lock_control = lock_control + 1
553: WHERE

Line 556: UPDATE oe_blanket_lines_ext

552: lock_control = lock_control + 1
553: WHERE
554: line_id = g_line_id_tbl(K).line_id ;
555:
556: UPDATE oe_blanket_lines_ext
557: SET
558: qp_list_line_id = ppr_price_list_line_tbl(K).list_line_id
559: WHERE
560: line_id = g_line_id_tbl(K).line_id ;

Line 772: Update oe_blanket_lines

768: END IF;
769:
770: END IF; -- end if code release level check to create pricing attributes
771:
772: Update oe_blanket_lines
773: set
774: price_list_id = ppr_price_list_line_tbl(1).list_header_id,
775: lock_control = lock_control + 1
776: WHERE

Line 780: Update oe_blanket_lines_ext

776: WHERE
777: line_id =
778: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
779:
780: Update oe_blanket_lines_ext
781: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
782: WHERE
783: line_id =
784: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

Line 875: Update oe_blanket_lines_ext

871: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874:
875: Update oe_blanket_lines_ext
876: set qp_list_line_id = Null
877: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;
878: END IF;
879:

Line 3755: FROM OE_BLANKET_LINES_EXT

3751: BEGIN
3752:
3753: SELECT 'ERROR'
3754: INTO l_dummy
3755: FROM OE_BLANKET_LINES_EXT
3756: WHERE ORDER_NUMBER = p_header_rec.order_number
3757: AND END_DATE_ACTIVE > p_header_rec.end_date_active
3758: AND ROWNUM = 1;
3759:

Line 3801: FROM OE_BLANKET_LINES_EXT

3797: THEN
3798: BEGIN
3799: SELECT 'CASCADE'
3800: INTO l_dummy
3801: FROM OE_BLANKET_LINES_EXT
3802: WHERE ORDER_NUMBER = p_header_rec.order_number
3803: AND END_DATE_ACTIVE IS NULL
3804: AND ROWNUM = 1;
3805:

Line 3813: FROM OE_BLANKET_LINES_EXT OLX, OE_BLANKET_LINES OL

3809: --if cascading, check to see if minimum values are satisfied
3810: IF (p_header_rec.end_date_active <= trunc(sysdate)) THEN
3811: SELECT 'WARNING'
3812: INTO l_dummy
3813: FROM OE_BLANKET_LINES_EXT OLX, OE_BLANKET_LINES OL
3814: WHERE OLX.LINE_ID = OL.LINE_ID
3815: AND OLX.ORDER_NUMBER = p_header_rec.order_number
3816: AND END_DATE_ACTIVE IS NULL
3817: AND OVERRIDE_BLANKET_CONTROLS_FLAG = 'N'

Line 4426: UPDATE OE_BLANKET_LINES_EXT

4422: , default_discount_percent = p_header_rec.default_discount_percent
4423: , default_discount_amount = p_header_rec.default_discount_amount
4424: WHERE order_number = p_header_rec.order_number;
4425:
4426: UPDATE OE_BLANKET_LINES_EXT
4427: SET
4428: END_DATE_ACTIVE = p_header_rec.end_date_active
4429: WHERE order_number = p_header_rec.order_number
4430: AND END_DATE_ACTIVE IS NULL;

Line 4472: FROM OE_BLANKET_LINES

4468: l_order_number Number;
4469: l_line_id Number;
4470: Cursor c_line_id is
4471: SELECT line_id
4472: FROM OE_BLANKET_LINES
4473: WHERE header_id=p_header_id;
4474: --
4475:
4476: BEGIN

Line 4638: INSERT INTO OE_BLANKET_LINES

4634: END IF;
4635: g_old_version_captured := TRUE;
4636: END IF;
4637:
4638: INSERT INTO OE_BLANKET_LINES
4639: ( ACCOUNTING_RULE_ID
4640: , AGREEMENT_ID
4641: , ATTRIBUTE1
4642: , ATTRIBUTE10

Line 4781: INSERT INTO OE_BLANKET_LINES_EXT

4777: , p_line_rec.transaction_phase_code -- hashraf pack J
4778: , p_line_rec.source_document_version_number
4779: );
4780:
4781: INSERT INTO OE_BLANKET_LINES_EXT
4782: ( START_DATE_ACTIVE
4783: , END_DATE_ACTIVE
4784: , MAX_RELEASE_AMOUNT
4785: , MIN_RELEASE_AMOUNT

Line 4893: UPDATE OE_BLANKET_LINES

4889: END IF;
4890: g_old_version_captured := TRUE;
4891: END IF;
4892:
4893: UPDATE OE_BLANKET_LINES
4894: SET ACCOUNTING_RULE_ID = p_line_rec.accounting_rule_id
4895: , AGREEMENT_ID = p_line_rec.agreement_id
4896: , ATTRIBUTE1 = p_line_rec.attribute1
4897: , ATTRIBUTE10 = p_line_rec.attribute10

Line 4961: UPDATE OE_BLANKET_LINES_EXT

4957: IF SQL%NOTFOUND THEN
4958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4959: END IF;
4960:
4961: UPDATE OE_BLANKET_LINES_EXT
4962: SET
4963: min_release_quantity = p_line_rec.min_release_quantity
4964: , max_release_quantity = p_line_rec.max_release_quantity
4965: , START_DATE_ACTIVE = p_line_rec.START_DATE_ACTIVE

Line 5037: FROM OE_BLANKET_LINES_all

5033:
5034: IF l_header_id IS NULL or
5035: l_header_id = FND_API.G_MISS_NUM THEN
5036: SELECT /* MOAC_SQL_CHANGE */ header_id into l_header_id
5037: FROM OE_BLANKET_LINES_all
5038: WHERE line_id = p_line_id;
5039: END IF;
5040:
5041: --Versioning changes

Line 5077: DELETE FROM OE_BLANKET_LINES

5073: RAISE FND_API.G_EXC_ERROR;
5074: END IF;
5075: -- End bug
5076:
5077: DELETE FROM OE_BLANKET_LINES
5078: WHERE line_id = p_line_id;
5079:
5080: --for bug 3348870
5081:

Line 5082: DELETE FROM OE_BLANKET_LINES_EXT

5078: WHERE line_id = p_line_id;
5079:
5080: --for bug 3348870
5081:
5082: DELETE FROM OE_BLANKET_LINES_EXT
5083: WHERE line_id = p_line_id;
5084:
5085: DELETE FROM OE_BLANKET_LINES_HIST
5086: WHERE line_id = p_line_id;

Line 5085: DELETE FROM OE_BLANKET_LINES_HIST

5081:
5082: DELETE FROM OE_BLANKET_LINES_EXT
5083: WHERE line_id = p_line_id;
5084:
5085: DELETE FROM OE_BLANKET_LINES_HIST
5086: WHERE line_id = p_line_id;
5087:
5088: if l_debug_level > 0 then
5089: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.DELETE_ROW', 1);

Line 5682: FROM OE_BLANKET_LINES bl, OE_BLANKET_LINES_EXT blx

5678: , source_document_version_number
5679: -- 11i10 Pricing Changes
5680: , modifier_list_line_id
5681: , blx.qp_list_line_id
5682: FROM OE_BLANKET_LINES bl, OE_BLANKET_LINES_EXT blx
5683: WHERE bl.line_id = blx.line_id
5684: AND bl.sales_document_type_code = 'B'
5685: AND ( bl.line_id = p_line_id OR
5686: header_id = p_header_id) ;

Line 5777: FROM OE_BLANKET_LINES_HIST bl

5773: , source_document_version_number
5774: -- 11i10 Pricing Changes
5775: , modifier_list_line_id
5776: , qp_list_line_id
5777: FROM OE_BLANKET_LINES_HIST bl
5778: WHERE bl.sales_document_type_code = 'B'
5779: AND ( bl.line_id = p_line_id OR
5780: header_id = p_header_id)
5781: AND version_number = p_version_number

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 6344: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX

6340: FOR UPDATE NOWAIT;
6341:
6342: CURSOR c_blanket_lines IS
6343: SELECT /* MOAC_SQL_CHANGE */ bl.line_id, bl.lock_control
6344: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX
6345: WHERE BL.LINE_ID = BLX.LINE_ID
6346: AND BLX.ORDER_NUMBER = l_blanket_id
6347: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
6348: AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'

Line 6372: FROM OE_BLANKET_LINES_EXT

6368: l_is_line_lock_control := FALSE;
6369: ELSE
6370: SELECT ORDER_NUMBER
6371: INTO l_blanket_id
6372: FROM OE_BLANKET_LINES_EXT
6373: WHERE LINE_ID = p_blanket_line_id;
6374:
6375: l_is_line_lock_control := TRUE;
6376: END IF;

Line 6732: FROM OE_BLANKET_LINES

6728: -- Get Blanket Line Number
6729: IF p_x_line_rec.line_number IS NULL THEN
6730: SELECT NVL(MAX(line_number)+1,1)
6731: INTO p_x_line_rec.line_number
6732: FROM OE_BLANKET_LINES
6733: WHERE header_id = p_x_line_rec.header_id;
6734: END IF;
6735:
6736: -- Constant Defaults

Line 7308: FROM oe_blanket_lines L

7304: ELSE
7305: BEGIN
7306: SELECT 'N'
7307: INTO l_valid
7308: FROM oe_blanket_lines L
7309: WHERE L.line_number =
7310: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7311: AND L.header_id =
7312: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1

Line 7419: from OE_BLANKET_LINES L, OE_BLANKET_LINES_EXT LX

7415: --modified the following sql to check for uiqueness of
7416: -- (inventory_item_id,item_idenitfier_type,ordered_item_id) for bug6826787
7417:
7418: select count(1) into lcount
7419: from OE_BLANKET_LINES L, OE_BLANKET_LINES_EXT LX
7420: where L.line_id = LX.line_id
7421: AND L.header_id = l_header_id
7422: AND L.line_id <> l_line_id
7423: AND ( ( l_item_identifier_type NOT IN ('ALL','CAT')

Line 8128: INSERT INTO OE_BLANKET_LINES_HIST

8124: if l_debug_level > 0 then
8125: oe_debug_pub.ADD('Before inserting blanket line history line_id ' || p_line_tbl(I).line_id, 5);
8126: end if;
8127:
8128: INSERT INTO OE_BLANKET_LINES_HIST
8129: ( ACCOUNTING_RULE_ID
8130: , AGREEMENT_ID
8131: , ATTRIBUTE1
8132: , ATTRIBUTE10

Line 9301: oe_blanket_lines_all where header_id = p_header_id;

9297: ship_to_org_id,
9298: deliver_to_org_id,
9299: invoice_to_org_id
9300: from
9301: oe_blanket_lines_all where header_id = p_header_id;
9302: mc1x c1%ROWTYPE;
9303:
9304: BEGIN
9305: OE_MSG_PUB.initialize;

Line 9427: update oe_blanket_lines_all set sold_to_org_id = p_sold_to_org_id

9423:
9424: if x_return_status = FND_API.G_RET_STS_ERROR then
9425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9426: elsif l_dummy = 'VALID' then
9427: update oe_blanket_lines_all set sold_to_org_id = p_sold_to_org_id
9428: where header_id = p_header_id;
9429: end if;
9430: IF l_debug_level > 0 THEN
9431: oe_debug_pub.add('EXISTING OE_Blanket_util.validate_sold_to: '|| TO_CHAR (p_header_id) ,1);