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_LINE_ADJ_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 156: from oe_price_adj_Assocs a, oe_price_adjustments b

152: ,a.PRICE_ADJ_ASSOC_ID
153: ,a.LINE_ID
154: ,a.RLTD_PRICE_ADJ_ID
155: ,a.LOCK_CONTROL
156: from oe_price_adj_Assocs a, oe_price_adjustments b
157: where a.price_adjustment_id = p_price_adjustment_id
158: and a.rltd_price_adj_id = b.price_adjustment_id
159: and b.list_line_type_code in ('SUR','DIS');
160: I PLS_INTEGER;

Line 2861: FROM OE_PRICE_ADJUSTMENTS

2857:
2858: -- increment lock_control by 1 whenever the record is updated
2859: SELECT lock_control
2860: INTO l_lock_control
2861: FROM OE_PRICE_ADJUSTMENTS
2862: WHERE price_adjustment_id = p_Line_Adj_rec.price_adjustment_id;
2863:
2864: l_lock_control := l_lock_control + 1;
2865:

Line 2896: UPDATE OE_PRICE_ADJUSTMENTS

2892: END IF;
2893: END IF; /* code_release_level*/
2894: -- notification framework end
2895:
2896: UPDATE OE_PRICE_ADJUSTMENTS
2897: SET PRICE_ADJUSTMENT_ID = p_Line_Adj_rec.price_adjustment_id
2898: , CREATION_DATE = p_Line_Adj_rec.creation_date
2899: , CREATED_BY = p_Line_Adj_rec.created_by
2900: , LAST_UPDATE_DATE = p_Line_Adj_rec.last_update_date

Line 3039: from oe_price_adjustments;

3035: l number;
3036: begin
3037: select max(price_adjustment_id)
3038: into j
3039: from oe_price_adjustments;
3040:
3041: Select oe_price_adjustments_s.nextval
3042: Into h
3043: From dual;

Line 3041: Select oe_price_adjustments_s.nextval

3037: select max(price_adjustment_id)
3038: into j
3039: from oe_price_adjustments;
3040:
3041: Select oe_price_adjustments_s.nextval
3042: Into h
3043: From dual;
3044:
3045: If j > h and j <> fnd_api.g_miss_num Then

Line 3048: select oe_price_adjustments_s.nextval into k from dual;

3044:
3045: If j > h and j <> fnd_api.g_miss_num Then
3046: l:=j-h+10;
3047: for i in 1..l loop
3048: select oe_price_adjustments_s.nextval into k from dual;
3049: end loop;
3050: End If;
3051:
3052: end;

Line 3077: INSERT INTO OE_PRICE_ADJUSTMENTS

3073: ' ,list_line_type_code:'||p_line_adj_rec.list_line_type_code||
3074: ' ,operator:'||p_line_adj_rec.arithmetic_operator);
3075: END IF;
3076:
3077: INSERT INTO OE_PRICE_ADJUSTMENTS
3078: ( PRICE_ADJUSTMENT_ID
3079: , CREATION_DATE
3080: , CREATED_BY
3081: , LAST_UPDATE_DATE

Line 3383: FROM OE_PRICE_ADJUSTMENTS

3379: IS
3380: l_return_status VARCHAR2(30);
3381: CURSOR price_adj IS
3382: SELECT price_adjustment_id
3383: FROM OE_PRICE_ADJUSTMENTS
3384: WHERE LINE_ID = p_line_id;
3385:
3386: -- added for notification framework
3387: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 3453: DELETE FROM OE_PRICE_ADJUSTMENTS

3449: p_price_adjustment_id=>l_adj.price_adjustment_id);
3450: ***/
3451:
3452: END LOOP;
3453: DELETE FROM OE_PRICE_ADJUSTMENTS
3454: WHERE LINE_ID = p_line_id;
3455: ELSE
3456: IF l_debug_level > 0 THEN
3457: oe_debug_pub.add( ' P_LINE_ID = G_MISS_NUM' ) ;

Line 3510: DELETE FROM OE_PRICE_ADJUSTMENTS

3506: ***/
3507:
3508: --bug3528335 moving the following DELETE statement before deletion of the parent and checking for PBH.
3509: --bug3405372 deleting the child lines of PBH modifiers as well
3510: DELETE FROM OE_PRICE_ADJUSTMENTS
3511: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
3512: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
3513: OE_PRICE_ADJUSTMENTS PARENT
3514: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID

Line 3513: OE_PRICE_ADJUSTMENTS PARENT

3509: --bug3405372 deleting the child lines of PBH modifiers as well
3510: DELETE FROM OE_PRICE_ADJUSTMENTS
3511: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
3512: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
3513: OE_PRICE_ADJUSTMENTS PARENT
3514: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
3515: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
3516: AND PARENT.LIST_LINE_TYPE_CODE='PBH');
3517: IF l_debug_level > 0 THEN

Line 3524: DELETE FROM OE_PRICE_ADJUSTMENTS

3520: --bug3528335 end
3521:
3522:
3523:
3524: DELETE FROM OE_PRICE_ADJUSTMENTS
3525: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3526:
3527: END IF;
3528: IF l_debug_level > 0 THEN

Line 3692: FROM OE_PRICE_ADJUSTMENTS

3688: --RETRO}
3689: , LOCK_CONTROL
3690: -- eBTax changes
3691: , TAX_RATE_ID
3692: FROM OE_PRICE_ADJUSTMENTS
3693: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3694:
3695: CURSOR l_Line_Adj_csr2 IS
3696: SELECT ATTRIBUTE1

Line 3804: FROM OE_PRICE_ADJUSTMENTS

3800: --RETRO}
3801: , LOCK_CONTROL
3802: -- eBTax changes
3803: , TAX_RATE_ID
3804: FROM OE_PRICE_ADJUSTMENTS
3805: WHERE line_id = p_line_id;
3806:
3807: CURSOR l_Line_Adj_csr3 IS
3808: SELECT ATTRIBUTE1

Line 3916: FROM OE_PRICE_ADJUSTMENTS

3912: --RETRO}
3913: , LOCK_CONTROL
3914: -- eBTax changes
3915: , TAX_RATE_ID
3916: FROM OE_PRICE_ADJUSTMENTS
3917: WHERE header_id = p_header_id
3918: and line_id is null;
3919:
3920: --Line-level adjustments based on header_id

Line 4030: FROM OE_PRICE_ADJUSTMENTS

4026: --RETRO}
4027: , LOCK_CONTROL
4028: -- eBTax changes
4029: , TAX_RATE_ID
4030: FROM OE_PRICE_ADJUSTMENTS
4031: WHERE header_id = p_line_level_header_id
4032: and line_id is not null;
4033:
4034: l_implicit_rec l_line_adj_csr%ROWTYPE;

Line 4314: FROM oe_price_adjustments

4310:
4311: -- added for performance change
4312: SELECT price_adjustment_id
4313: INTO l_price_adjustment_id
4314: FROM oe_price_adjustments
4315: WHERE price_adjustment_id = l_price_adjustment_id
4316: FOR UPDATE NOWAIT;
4317:
4318: IF l_debug_level > 0 THEN

Line 4443: FROM oe_price_adjustments

4439: IS
4440:
4441: CURSOR lock_adj_lines(p_line_id IN NUMBER) IS
4442: SELECT price_adjustment_id
4443: FROM oe_price_adjustments
4444: WHERE line_id = p_line_id
4445: FOR UPDATE NOWAIT;
4446:
4447: l_price_adjustment_id NUMBER;

Line 4480: FROM oe_price_adjustments

4476: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
4477:
4478: SELECT price_adjustment_id
4479: INTO l_price_adjustment_id
4480: FROM oe_price_adjustments
4481: WHERE price_adjustment_id = p_price_adjustment_id
4482: FOR UPDATE NOWAIT;
4483: END IF;
4484:

Line 5694: from oe_price_adjustments adj1,

5690:
5691: -- Get all PRG lines
5692: Cursor prg_lines is
5693: select adj1.line_id, assoc.rltd_price_adj_id
5694: from oe_price_adjustments adj1,
5695: oe_price_adj_assocs assoc,
5696: oe_price_adjustments adj2,
5697: oe_order_lines_all line
5698: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND

Line 5696: oe_price_adjustments adj2,

5692: Cursor prg_lines is
5693: select adj1.line_id, assoc.rltd_price_adj_id
5694: from oe_price_adjustments adj1,
5695: oe_price_adj_assocs assoc,
5696: oe_price_adjustments adj2,
5697: oe_order_lines_all line
5698: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
5699: assoc.price_adjustment_id = adj2.price_adjustment_id AND
5700: adj2.list_line_type_code = 'PRG' AND

Line 5708: from oe_price_adjustments

5704:
5705:
5706: Cursor prg_adjs is
5707: select price_adjustment_id
5708: from oe_price_adjustments
5709: where line_id = p_line_id AND list_line_type_code = 'PRG';
5710:
5711: /* Variables to call process order */
5712: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 6559: update oe_price_adjustments

6555: p_x_line_rec.order_quantity_uom,
6556: p_x_line_rec.pricing_quantity_uom,
6557: p_x_line_rec.ordered_quantity
6558: );
6559: update oe_price_adjustments
6560: set adjusted_amount = adjusted_amount * l_new_pricing_qty / l_old_pricing_qty
6561: where line_id = p_x_Line_rec.line_id
6562: and list_line_type_code in ('DIS','SUR')
6563: and applied_flag = 'Y'

Line 6567: update oe_price_adjustments

6563: and applied_flag = 'Y'
6564: and updated_flag = 'Y'
6565: and arithmetic_operator in ('AMT' , '%' , 'NEWPRICE');
6566:
6567: update oe_price_adjustments
6568: set operand = operand * l_new_pricing_qty / l_old_pricing_qty
6569: where line_id = p_x_Line_rec.line_id
6570: and list_line_type_code in ('DIS','SUR')
6571: and applied_flag = 'Y'

Line 6601: from oe_price_adjustments adj1,

6597:
6598: Procedure Set_PRG_Cache(p_header_id IN NUMBER) AS
6599: Cursor prg_cur is
6600: select adj1.line_id line_id
6601: from oe_price_adjustments adj1,
6602: oe_price_adj_assocs assoc,
6603: oe_price_adjustments adj2
6604: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
6605: assoc.price_adjustment_id = adj2.price_adjustment_id AND

Line 6603: oe_price_adjustments adj2

6599: Cursor prg_cur is
6600: select adj1.line_id line_id
6601: from oe_price_adjustments adj1,
6602: oe_price_adj_assocs assoc,
6603: oe_price_adjustments adj2
6604: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
6605: assoc.price_adjustment_id = adj2.price_adjustment_id AND
6606: adj2.list_line_type_code = 'PRG' AND
6607: adj2.header_id = p_header_id;