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 2939: FROM OE_PRICE_ADJUSTMENTS

2935:
2936: -- increment lock_control by 1 whenever the record is updated
2937: SELECT lock_control
2938: INTO l_lock_control
2939: FROM OE_PRICE_ADJUSTMENTS
2940: WHERE price_adjustment_id = p_Line_Adj_rec.price_adjustment_id;
2941:
2942: l_lock_control := l_lock_control + 1;
2943:

Line 2974: UPDATE OE_PRICE_ADJUSTMENTS

2970: END IF;
2971: END IF; /* code_release_level*/
2972: -- notification framework end
2973:
2974: UPDATE OE_PRICE_ADJUSTMENTS
2975: SET PRICE_ADJUSTMENT_ID = p_Line_Adj_rec.price_adjustment_id
2976: , CREATION_DATE = p_Line_Adj_rec.creation_date
2977: , CREATED_BY = p_Line_Adj_rec.created_by
2978: , LAST_UPDATE_DATE = p_Line_Adj_rec.last_update_date

Line 3117: from oe_price_adjustments;

3113: l number;
3114: begin
3115: select max(price_adjustment_id)
3116: into j
3117: from oe_price_adjustments;
3118:
3119: Select oe_price_adjustments_s.nextval
3120: Into h
3121: From dual;

Line 3119: Select oe_price_adjustments_s.nextval

3115: select max(price_adjustment_id)
3116: into j
3117: from oe_price_adjustments;
3118:
3119: Select oe_price_adjustments_s.nextval
3120: Into h
3121: From dual;
3122:
3123: If j > h and j <> fnd_api.g_miss_num Then

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

3122:
3123: If j > h and j <> fnd_api.g_miss_num Then
3124: l:=j-h+10;
3125: for i in 1..l loop
3126: select oe_price_adjustments_s.nextval into k from dual;
3127: end loop;
3128: End If;
3129:
3130: end;

Line 3155: INSERT INTO OE_PRICE_ADJUSTMENTS

3151: ' ,list_line_type_code:'||p_line_adj_rec.list_line_type_code||
3152: ' ,operator:'||p_line_adj_rec.arithmetic_operator);
3153: END IF;
3154:
3155: INSERT INTO OE_PRICE_ADJUSTMENTS
3156: ( PRICE_ADJUSTMENT_ID
3157: , CREATION_DATE
3158: , CREATED_BY
3159: , LAST_UPDATE_DATE

Line 3461: FROM OE_PRICE_ADJUSTMENTS

3457: IS
3458: l_return_status VARCHAR2(30);
3459: CURSOR price_adj IS
3460: SELECT price_adjustment_id
3461: FROM OE_PRICE_ADJUSTMENTS
3462: WHERE LINE_ID = p_line_id;
3463:
3464: -- added for notification framework
3465: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 3531: DELETE FROM OE_PRICE_ADJUSTMENTS

3527: p_price_adjustment_id=>l_adj.price_adjustment_id);
3528: ***/
3529:
3530: END LOOP;
3531: DELETE FROM OE_PRICE_ADJUSTMENTS
3532: WHERE LINE_ID = p_line_id;
3533: ELSE
3534: IF l_debug_level > 0 THEN
3535: oe_debug_pub.add( ' P_LINE_ID = G_MISS_NUM' ) ;

Line 3588: DELETE FROM OE_PRICE_ADJUSTMENTS

3584: ***/
3585:
3586: --bug3528335 moving the following DELETE statement before deletion of the parent and checking for PBH.
3587: --bug3405372 deleting the child lines of PBH modifiers as well
3588: DELETE FROM OE_PRICE_ADJUSTMENTS
3589: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
3590: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
3591: OE_PRICE_ADJUSTMENTS PARENT
3592: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID

Line 3591: OE_PRICE_ADJUSTMENTS PARENT

3587: --bug3405372 deleting the child lines of PBH modifiers as well
3588: DELETE FROM OE_PRICE_ADJUSTMENTS
3589: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
3590: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
3591: OE_PRICE_ADJUSTMENTS PARENT
3592: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
3593: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
3594: AND PARENT.LIST_LINE_TYPE_CODE='PBH');
3595: IF l_debug_level > 0 THEN

Line 3602: DELETE FROM OE_PRICE_ADJUSTMENTS

3598: --bug3528335 end
3599:
3600:
3601:
3602: DELETE FROM OE_PRICE_ADJUSTMENTS
3603: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3604:
3605: END IF;
3606: IF l_debug_level > 0 THEN

Line 3770: FROM OE_PRICE_ADJUSTMENTS

3766: --RETRO}
3767: , LOCK_CONTROL
3768: -- eBTax changes
3769: , TAX_RATE_ID
3770: FROM OE_PRICE_ADJUSTMENTS
3771: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3772:
3773: CURSOR l_Line_Adj_csr2 IS
3774: SELECT ATTRIBUTE1

Line 3882: FROM OE_PRICE_ADJUSTMENTS

3878: --RETRO}
3879: , LOCK_CONTROL
3880: -- eBTax changes
3881: , TAX_RATE_ID
3882: FROM OE_PRICE_ADJUSTMENTS
3883: WHERE line_id = p_line_id;
3884:
3885: CURSOR l_Line_Adj_csr3 IS
3886: SELECT ATTRIBUTE1

Line 3994: FROM OE_PRICE_ADJUSTMENTS

3990: --RETRO}
3991: , LOCK_CONTROL
3992: -- eBTax changes
3993: , TAX_RATE_ID
3994: FROM OE_PRICE_ADJUSTMENTS
3995: WHERE header_id = p_header_id
3996: and line_id is null;
3997:
3998: --Line-level adjustments based on header_id

Line 4108: FROM OE_PRICE_ADJUSTMENTS

4104: --RETRO}
4105: , LOCK_CONTROL
4106: -- eBTax changes
4107: , TAX_RATE_ID
4108: FROM OE_PRICE_ADJUSTMENTS
4109: WHERE header_id = p_line_level_header_id
4110: and line_id is not null;
4111:
4112: l_implicit_rec l_line_adj_csr%ROWTYPE;

Line 4392: FROM oe_price_adjustments

4388:
4389: -- added for performance change
4390: SELECT price_adjustment_id
4391: INTO l_price_adjustment_id
4392: FROM oe_price_adjustments
4393: WHERE price_adjustment_id = l_price_adjustment_id
4394: FOR UPDATE NOWAIT;
4395:
4396: IF l_debug_level > 0 THEN

Line 4521: FROM oe_price_adjustments

4517: IS
4518:
4519: CURSOR lock_adj_lines(p_line_id IN NUMBER) IS
4520: SELECT price_adjustment_id
4521: FROM oe_price_adjustments
4522: WHERE line_id = p_line_id
4523: FOR UPDATE NOWAIT;
4524:
4525: l_price_adjustment_id NUMBER;

Line 4558: FROM oe_price_adjustments

4554: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
4555:
4556: SELECT price_adjustment_id
4557: INTO l_price_adjustment_id
4558: FROM oe_price_adjustments
4559: WHERE price_adjustment_id = p_price_adjustment_id
4560: FOR UPDATE NOWAIT;
4561: END IF;
4562:

Line 5159: FROM oe_price_adjustments prg, oe_order_lines_all l,

5155: oe_debug_pub.ADD('p_line_id :'||p_line_id,1);
5156:
5157: SELECT 'Y'
5158: INTO l_prg_exist
5159: FROM oe_price_adjustments prg, oe_order_lines_all l,
5160: oe_price_adj_assocs a,oe_price_adjustments p
5161: WHERE prg.line_id = p_line_id
5162: AND prg.list_line_type_code = 'PRG'
5163: AND prg.price_adjustment_id = a.price_adjustment_id

Line 5160: oe_price_adj_assocs a,oe_price_adjustments p

5156:
5157: SELECT 'Y'
5158: INTO l_prg_exist
5159: FROM oe_price_adjustments prg, oe_order_lines_all l,
5160: oe_price_adj_assocs a,oe_price_adjustments p
5161: WHERE prg.line_id = p_line_id
5162: AND prg.list_line_type_code = 'PRG'
5163: AND prg.price_adjustment_id = a.price_adjustment_id
5164: AND p.price_adjustment_id = a.rltd_price_adj_id

Line 5902: from oe_price_adjustments adj1,

5898:
5899: -- Get all PRG lines
5900: Cursor prg_lines is
5901: select adj1.line_id, assoc.rltd_price_adj_id
5902: from oe_price_adjustments adj1,
5903: oe_price_adj_assocs assoc,
5904: oe_price_adjustments adj2,
5905: oe_order_lines_all line
5906: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND

Line 5904: oe_price_adjustments adj2,

5900: Cursor prg_lines is
5901: select adj1.line_id, assoc.rltd_price_adj_id
5902: from oe_price_adjustments adj1,
5903: oe_price_adj_assocs assoc,
5904: oe_price_adjustments adj2,
5905: oe_order_lines_all line
5906: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
5907: assoc.price_adjustment_id = adj2.price_adjustment_id AND
5908: adj2.list_line_type_code = 'PRG' AND

Line 5916: from oe_price_adjustments

5912:
5913:
5914: Cursor prg_adjs is
5915: select price_adjustment_id
5916: from oe_price_adjustments
5917: where line_id = p_line_id AND list_line_type_code = 'PRG';
5918:
5919: /* Variables to call process order */
5920: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 6830: update oe_price_adjustments

6826: p_x_line_rec.Pricing_quantity := l_new_pricing_qty;
6827: Oe_Debug_Pub.add(' p_x_line_rec.Pricing_quantity = ' || p_x_line_rec.Pricing_quantity);
6828: -- End of code changes for bug 9014929
6829:
6830: update oe_price_adjustments
6831: set adjusted_amount = adjusted_amount * l_new_pricing_qty / l_old_pricing_qty
6832: where line_id = p_x_Line_rec.line_id
6833: and list_line_type_code in ('DIS','SUR')
6834: and applied_flag = 'Y'

Line 6838: update oe_price_adjustments

6834: and applied_flag = 'Y'
6835: and updated_flag = 'Y'
6836: and arithmetic_operator in ('AMT' , '%' , 'NEWPRICE');
6837:
6838: update oe_price_adjustments
6839: set operand = operand * l_new_pricing_qty / l_old_pricing_qty
6840: where line_id = p_x_Line_rec.line_id
6841: and list_line_type_code in ('DIS','SUR')
6842: and applied_flag = 'Y'

Line 6872: from oe_price_adjustments adj1,

6868:
6869: Procedure Set_PRG_Cache(p_header_id IN NUMBER) AS
6870: Cursor prg_cur is
6871: select adj1.line_id line_id
6872: from oe_price_adjustments adj1,
6873: oe_price_adj_assocs assoc,
6874: oe_price_adjustments adj2
6875: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
6876: assoc.price_adjustment_id = adj2.price_adjustment_id AND

Line 6874: oe_price_adjustments adj2

6870: Cursor prg_cur is
6871: select adj1.line_id line_id
6872: from oe_price_adjustments adj1,
6873: oe_price_adj_assocs assoc,
6874: oe_price_adjustments adj2
6875: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
6876: assoc.price_adjustment_id = adj2.price_adjustment_id AND
6877: adj2.list_line_type_code = 'PRG' AND
6878: adj2.header_id = p_header_id;