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

Line 2768: FROM oe_price_adjustments

2764:
2765: -- increment lock_control by 1 whenever the record is updated
2766: SELECT lock_control
2767: INTO l_lock_control
2768: FROM oe_price_adjustments
2769: WHERE price_adjustment_id = p_Header_Adj_rec.price_adjustment_id;
2770:
2771: l_lock_control := l_lock_control + 1;
2772:

Line 2812: UPDATE OE_PRICE_ADJUSTMENTS

2808: END IF; /*code_release_level*/
2809: -- notification framework end
2810:
2811:
2812: UPDATE OE_PRICE_ADJUSTMENTS
2813: SET PRICE_ADJUSTMENT_ID = p_Header_Adj_rec.price_adjustment_id
2814: , CREATION_DATE = p_Header_Adj_rec.creation_date
2815: , CREATED_BY = p_Header_Adj_rec.created_by
2816: , LAST_UPDATE_DATE = p_Header_Adj_rec.last_update_date

Line 2960: INSERT INTO OE_PRICE_ADJUSTMENTS

2956: IF l_debug_level > 0 THEN
2957: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
2958: END IF;
2959:
2960: INSERT INTO OE_PRICE_ADJUSTMENTS
2961: ( PRICE_ADJUSTMENT_ID
2962: , CREATION_DATE
2963: , CREATED_BY
2964: , LAST_UPDATE_DATE

Line 3244: DELETE FROM OE_PRICE_ADJUSTMENTS

3240:
3241: begin
3242:
3243:
3244: DELETE FROM OE_PRICE_ADJUSTMENTS
3245: WHERE HEADER_ID = p_header_id
3246: AND LINE_ID IS NULL
3247: AND LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE';
3248:

Line 3276: FROM OE_PRICE_ADJUSTMENTS

3272: IS
3273: l_return_status VARCHAR2(30);
3274: CURSOR price_adj IS
3275: SELECT price_adjustment_id
3276: FROM OE_PRICE_ADJUSTMENTS
3277: WHERE HEADER_ID = p_header_id;
3278:
3279: -- added for notification framework
3280: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 3355: DELETE FROM OE_PRICE_ADJUSTMENTS

3351: DELETE FROM OE_PRICE_ADJS_HISTORY
3352: WHERE HEADER_ID = p_header_id;
3353: /* End Audit Trail */
3354:
3355: DELETE FROM OE_PRICE_ADJUSTMENTS
3356: WHERE HEADER_ID = p_header_id;
3357: ELSE
3358:
3359: --added for notification framework

Line 3425: DELETE FROM OE_PRICE_ADJUSTMENTS

3421: AND (NVL(VERSION_FLAG, 'N') = 'Y'
3422: OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
3423: /* End Audit Trail */
3424:
3425: DELETE FROM OE_PRICE_ADJUSTMENTS
3426: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3427: ;
3428: END IF;
3429:

Line 3595: FROM OE_PRICE_ADJUSTMENTS

3591: , ADJUSTED_AMOUNT_PER_PQTY
3592: , INVOICED_AMOUNT
3593: --uom end
3594: , LOCK_CONTROL
3595: FROM OE_PRICE_ADJUSTMENTS
3596: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3597:
3598: CURSOR l_Header_Adj_csr_h IS
3599: SELECT ATTRIBUTE1

Line 3702: FROM OE_PRICE_ADJUSTMENTS

3698: , ADJUSTED_AMOUNT_PER_PQTY
3699: , INVOICED_AMOUNT
3700: --uom end
3701: , LOCK_CONTROL
3702: FROM OE_PRICE_ADJUSTMENTS
3703: WHERE HEADER_ID = p_header_id AND LINE_ID IS NULL;
3704:
3705: l_implicit_rec l_header_adj_csr_p%ROWTYPE;
3706: l_entity NUMBER;

Line 3956: FROM oe_price_adjustments

3952:
3953: -- added for performance change
3954: SELECT price_adjustment_id
3955: INTO l_price_adjustment_id
3956: FROM oe_price_adjustments
3957: WHERE price_adjustment_id = l_price_adjustment_id
3958: FOR UPDATE NOWAIT;
3959:
3960: IF l_debug_level > 0 THEN

Line 4092: FROM oe_price_adjustments

4088: IS
4089:
4090: CURSOR lock_adj_hdr(p_header_id IN NUMBER) IS
4091: SELECT price_adjustment_id
4092: FROM oe_price_adjustments
4093: WHERE header_id = p_header_id
4094: FOR UPDATE NOWAIT;
4095:
4096: l_price_adjustment_id NUMBER;

Line 4129: FROM oe_price_adjustments

4125: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
4126:
4127: SELECT price_adjustment_id
4128: INTO l_price_adjustment_id
4129: FROM oe_price_adjustments
4130: WHERE price_adjustment_id = p_price_adjustment_id
4131: FOR UPDATE NOWAIT;
4132: END IF;
4133:

Line 4461: FROM oe_price_adjustments_v opa

4457: 'AMT',opa.operand,
4458: 'NEWPRICE',ool.unit_list_price-opa.operand))
4459: unit_discount_amount
4460: --Bug 3340636 Ends
4461: FROM oe_price_adjustments_v opa
4462: , oe_order_lines_all ool
4463: WHERE opa.HEADER_ID = p_header_id
4464: and opa.line_id is null
4465: and ool.line_id = p_line_id

Line 4480: FROM oe_price_adjustments_v opa

4476: ,opa.adjustment_type_code
4477: ,opa.operand
4478: ,opa.arithmetic_operator
4479: ,Nvl(opa.adjusted_amount,0)*(-1) unit_discount_amount --added nvl for bug 13605684
4480: FROM oe_price_adjustments_v opa
4481: , oe_order_lines_all ool
4482: WHERE opa.line_id =p_line_id
4483: and ool.line_id = p_line_id
4484: and ool.header_id = p_header_id

Line 5255: FROM oe_price_adjustments

5251: ELSE
5252: IF p_header_id IS NULL THEN
5253: BEGIN
5254: SELECT header_id INTO l_header_id
5255: FROM oe_price_adjustments
5256: WHERE price_adjustment_id = p_price_adjustment_id;
5257:
5258: IF l_header_id IS NULL THEN
5259: RETURN NULL;

Line 5293: FROM oe_price_adjustments

5289: END IF;
5290:
5291: SELECT nvl(operand,0) * decode(list_line_type_code, 'DIS', -1, 'SUR', 1)
5292: INTO l_operand
5293: FROM oe_price_adjustments
5294: WHERE price_adjustment_id = p_price_adjustment_id
5295: AND line_id IS NULL
5296: AND arithmetic_operator = '%';
5297: