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 676: Update oe_blanket_lines

672: K := ppr_price_list_line_tbl.first;
673: WHILE K is not null
674: LOOP
675:
676: Update oe_blanket_lines
677: set
678: price_list_id = ppr_price_list_rec.list_header_id,
679: lock_control = lock_control + 1
680: WHERE

Line 683: UPDATE oe_blanket_lines_ext

679: lock_control = lock_control + 1
680: WHERE
681: line_id = g_line_id_tbl(K).line_id ;
682:
683: UPDATE oe_blanket_lines_ext
684: SET
685: qp_list_line_id = ppr_price_list_line_tbl(K).list_line_id
686: WHERE
687: line_id = g_line_id_tbl(K).line_id ;

Line 914: Update oe_blanket_lines

910:
911: END IF; -- end if code release level check to create pricing attributes
912: */
913:
914: Update oe_blanket_lines
915: set
916: price_list_id = ppr_price_list_line_tbl(1).list_header_id,
917: lock_control = lock_control + 1
918: WHERE

Line 922: Update oe_blanket_lines_ext

918: WHERE
919: line_id =
920: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
921:
922: Update oe_blanket_lines_ext
923: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
924: WHERE
925: line_id =
926: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

Line 1017: Update oe_blanket_lines_ext

1013: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016:
1017: Update oe_blanket_lines_ext
1018: set qp_list_line_id = Null
1019: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;
1020: END IF;
1021:

Line 3946: FROM OE_BLANKET_LINES_EXT

3942: BEGIN
3943:
3944: SELECT 'ERROR'
3945: INTO l_dummy
3946: FROM OE_BLANKET_LINES_EXT
3947: WHERE ORDER_NUMBER = p_header_rec.order_number
3948: AND END_DATE_ACTIVE > p_header_rec.end_date_active
3949: AND ROWNUM = 1;
3950:

Line 3995: FROM OE_BLANKET_LINES_EXT

3991: THEN
3992: BEGIN
3993: SELECT 'CASCADE'
3994: INTO l_dummy
3995: FROM OE_BLANKET_LINES_EXT
3996: WHERE ORDER_NUMBER = p_header_rec.order_number
3997: AND END_DATE_ACTIVE IS NULL
3998: AND ROWNUM = 1;
3999:

Line 4007: FROM OE_BLANKET_LINES_EXT OLX, OE_BLANKET_LINES OL

4003: --if cascading, check to see if minimum values are satisfied
4004: IF (p_header_rec.end_date_active <= trunc(sysdate)) THEN
4005: SELECT 'WARNING'
4006: INTO l_dummy
4007: FROM OE_BLANKET_LINES_EXT OLX, OE_BLANKET_LINES OL
4008: WHERE OLX.LINE_ID = OL.LINE_ID
4009: AND OLX.ORDER_NUMBER = p_header_rec.order_number
4010: AND END_DATE_ACTIVE IS NULL
4011: AND OVERRIDE_BLANKET_CONTROLS_FLAG = 'N'

Line 4620: UPDATE OE_BLANKET_LINES_EXT

4616: , default_discount_percent = p_header_rec.default_discount_percent
4617: , default_discount_amount = p_header_rec.default_discount_amount
4618: WHERE order_number = p_header_rec.order_number;
4619:
4620: UPDATE OE_BLANKET_LINES_EXT
4621: SET
4622: END_DATE_ACTIVE = p_header_rec.end_date_active
4623: WHERE order_number = p_header_rec.order_number
4624: AND END_DATE_ACTIVE IS NULL;

Line 4666: FROM OE_BLANKET_LINES

4662: l_order_number Number;
4663: l_line_id Number;
4664: Cursor c_line_id is
4665: SELECT line_id
4666: FROM OE_BLANKET_LINES
4667: WHERE header_id=p_header_id;
4668: --
4669:
4670: BEGIN

Line 4832: INSERT INTO OE_BLANKET_LINES

4828: END IF;
4829: g_old_version_captured := TRUE;
4830: END IF;
4831:
4832: INSERT INTO OE_BLANKET_LINES
4833: ( ACCOUNTING_RULE_ID
4834: , AGREEMENT_ID
4835: , ATTRIBUTE1
4836: , ATTRIBUTE10

Line 4975: INSERT INTO OE_BLANKET_LINES_EXT

4971: , p_line_rec.transaction_phase_code -- hashraf pack J
4972: , p_line_rec.source_document_version_number
4973: );
4974:
4975: INSERT INTO OE_BLANKET_LINES_EXT
4976: ( START_DATE_ACTIVE
4977: , END_DATE_ACTIVE
4978: , MAX_RELEASE_AMOUNT
4979: , MIN_RELEASE_AMOUNT

Line 5087: UPDATE OE_BLANKET_LINES

5083: END IF;
5084: g_old_version_captured := TRUE;
5085: END IF;
5086:
5087: UPDATE OE_BLANKET_LINES
5088: SET ACCOUNTING_RULE_ID = p_line_rec.accounting_rule_id
5089: , AGREEMENT_ID = p_line_rec.agreement_id
5090: , ATTRIBUTE1 = p_line_rec.attribute1
5091: , ATTRIBUTE10 = p_line_rec.attribute10

Line 5155: UPDATE OE_BLANKET_LINES_EXT

5151: IF SQL%NOTFOUND THEN
5152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5153: END IF;
5154:
5155: UPDATE OE_BLANKET_LINES_EXT
5156: SET
5157: min_release_quantity = p_line_rec.min_release_quantity
5158: , max_release_quantity = p_line_rec.max_release_quantity
5159: , START_DATE_ACTIVE = p_line_rec.START_DATE_ACTIVE

Line 5231: FROM OE_BLANKET_LINES_all

5227:
5228: IF l_header_id IS NULL or
5229: l_header_id = FND_API.G_MISS_NUM THEN
5230: SELECT /* MOAC_SQL_CHANGE */ header_id into l_header_id
5231: FROM OE_BLANKET_LINES_all
5232: WHERE line_id = p_line_id;
5233: END IF;
5234:
5235: --Versioning changes

Line 5271: DELETE FROM OE_BLANKET_LINES

5267: RAISE FND_API.G_EXC_ERROR;
5268: END IF;
5269: -- End bug
5270:
5271: DELETE FROM OE_BLANKET_LINES
5272: WHERE line_id = p_line_id;
5273:
5274: --for bug 3348870
5275:

Line 5276: DELETE FROM OE_BLANKET_LINES_EXT

5272: WHERE line_id = p_line_id;
5273:
5274: --for bug 3348870
5275:
5276: DELETE FROM OE_BLANKET_LINES_EXT
5277: WHERE line_id = p_line_id;
5278:
5279: DELETE FROM OE_BLANKET_LINES_HIST
5280: WHERE line_id = p_line_id;

Line 5279: DELETE FROM OE_BLANKET_LINES_HIST

5275:
5276: DELETE FROM OE_BLANKET_LINES_EXT
5277: WHERE line_id = p_line_id;
5278:
5279: DELETE FROM OE_BLANKET_LINES_HIST
5280: WHERE line_id = p_line_id;
5281:
5282: if l_debug_level > 0 then
5283: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.DELETE_ROW', 1);

Line 5876: FROM OE_BLANKET_LINES bl, OE_BLANKET_LINES_EXT blx

5872: , source_document_version_number
5873: -- 11i10 Pricing Changes
5874: , modifier_list_line_id
5875: , blx.qp_list_line_id
5876: FROM OE_BLANKET_LINES bl, OE_BLANKET_LINES_EXT blx
5877: WHERE bl.line_id = blx.line_id
5878: AND bl.sales_document_type_code = 'B'
5879: AND ( bl.line_id = p_line_id OR
5880: header_id = p_header_id) ;

Line 5971: FROM OE_BLANKET_LINES_HIST bl

5967: , source_document_version_number
5968: -- 11i10 Pricing Changes
5969: , modifier_list_line_id
5970: , qp_list_line_id
5971: FROM OE_BLANKET_LINES_HIST bl
5972: WHERE bl.sales_document_type_code = 'B'
5973: AND ( bl.line_id = p_line_id OR
5974: header_id = p_header_id)
5975: AND version_number = p_version_number

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

6534: FOR UPDATE NOWAIT;
6535:
6536: CURSOR c_blanket_lines IS
6537: SELECT /* MOAC_SQL_CHANGE */ bl.line_id, bl.lock_control
6538: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX
6539: WHERE BL.LINE_ID = BLX.LINE_ID
6540: AND BLX.ORDER_NUMBER = l_blanket_id
6541: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
6542: AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'

Line 6566: FROM OE_BLANKET_LINES_EXT

6562: l_is_line_lock_control := FALSE;
6563: ELSE
6564: SELECT ORDER_NUMBER
6565: INTO l_blanket_id
6566: FROM OE_BLANKET_LINES_EXT
6567: WHERE LINE_ID = p_blanket_line_id;
6568:
6569: l_is_line_lock_control := TRUE;
6570: END IF;

Line 6926: FROM OE_BLANKET_LINES

6922: -- Get Blanket Line Number
6923: IF p_x_line_rec.line_number IS NULL THEN
6924: SELECT NVL(MAX(line_number)+1,1)
6925: INTO p_x_line_rec.line_number
6926: FROM OE_BLANKET_LINES
6927: WHERE header_id = p_x_line_rec.header_id;
6928: END IF;
6929:
6930: -- Constant Defaults

Line 7505: FROM oe_blanket_lines L

7501: ELSE
7502: BEGIN
7503: SELECT 'N'
7504: INTO l_valid
7505: FROM oe_blanket_lines L
7506: WHERE L.line_number =
7507: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7508: AND L.header_id =
7509: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1

Line 7616: from OE_BLANKET_LINES L, OE_BLANKET_LINES_EXT LX

7612: --modified the following sql to check for uiqueness of
7613: -- (inventory_item_id,item_idenitfier_type,ordered_item_id) for bug6826787
7614:
7615: select count(1) into lcount
7616: from OE_BLANKET_LINES L, OE_BLANKET_LINES_EXT LX
7617: where L.line_id = LX.line_id
7618: AND L.header_id = l_header_id
7619: AND L.line_id <> l_line_id
7620: AND ( ( l_item_identifier_type NOT IN ('ALL','CAT')

Line 8325: INSERT INTO OE_BLANKET_LINES_HIST

8321: if l_debug_level > 0 then
8322: oe_debug_pub.ADD('Before inserting blanket line history line_id ' || p_line_tbl(I).line_id, 5);
8323: end if;
8324:
8325: INSERT INTO OE_BLANKET_LINES_HIST
8326: ( ACCOUNTING_RULE_ID
8327: , AGREEMENT_ID
8328: , ATTRIBUTE1
8329: , ATTRIBUTE10

Line 9498: oe_blanket_lines_all where header_id = p_header_id;

9494: ship_to_org_id,
9495: deliver_to_org_id,
9496: invoice_to_org_id
9497: from
9498: oe_blanket_lines_all where header_id = p_header_id;
9499: mc1x c1%ROWTYPE;
9500:
9501: BEGIN
9502: OE_MSG_PUB.initialize;

Line 9624: update oe_blanket_lines_all set sold_to_org_id = p_sold_to_org_id

9620:
9621: if x_return_status = FND_API.G_RET_STS_ERROR then
9622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9623: elsif l_dummy = 'VALID' then
9624: update oe_blanket_lines_all set sold_to_org_id = p_sold_to_org_id
9625: where header_id = p_header_id;
9626: end if;
9627: IF l_debug_level > 0 THEN
9628: oe_debug_pub.add('EXISTING OE_Blanket_util.validate_sold_to: '|| TO_CHAR (p_header_id) ,1);