DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_LINES_EXT

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