APPS.OE_HEADER_ADJ_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 2711: FROM oe_price_adjustments

2707:
2708: -- increment lock_control by 1 whenever the record is updated
2709: SELECT lock_control
2710: INTO l_lock_control
2711: FROM oe_price_adjustments
2712: WHERE price_adjustment_id = p_Header_Adj_rec.price_adjustment_id;
2713:
2714: l_lock_control := l_lock_control + 1;
2715:

Line 2755: UPDATE OE_PRICE_ADJUSTMENTS

2751: END IF; /*code_release_level*/
2752: -- notification framework end
2753:
2754:
2755: UPDATE OE_PRICE_ADJUSTMENTS
2756: SET PRICE_ADJUSTMENT_ID = p_Header_Adj_rec.price_adjustment_id
2757: , CREATION_DATE = p_Header_Adj_rec.creation_date
2758: , CREATED_BY = p_Header_Adj_rec.created_by
2759: , LAST_UPDATE_DATE = p_Header_Adj_rec.last_update_date

Line 2903: INSERT INTO OE_PRICE_ADJUSTMENTS

2899: IF l_debug_level > 0 THEN
2900: oe_debug_pub.add( 'ENTERING OE_HEADER_ADJ_UTIL.INSERT_ROW' , 1 ) ;
2901: END IF;
2902:
2903: INSERT INTO OE_PRICE_ADJUSTMENTS
2904: ( PRICE_ADJUSTMENT_ID
2905: , CREATION_DATE
2906: , CREATED_BY
2907: , LAST_UPDATE_DATE

Line 3185: DELETE FROM OE_PRICE_ADJUSTMENTS

3181:
3182: begin
3183:
3184:
3185: DELETE FROM OE_PRICE_ADJUSTMENTS
3186: WHERE HEADER_ID = p_header_id
3187: AND LINE_ID IS NULL
3188: AND LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE';
3189:

Line 3217: FROM OE_PRICE_ADJUSTMENTS

3213: IS
3214: l_return_status VARCHAR2(30);
3215: CURSOR price_adj IS
3216: SELECT price_adjustment_id
3217: FROM OE_PRICE_ADJUSTMENTS
3218: WHERE HEADER_ID = p_header_id;
3219:
3220: -- added for notification framework
3221: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 3296: DELETE FROM OE_PRICE_ADJUSTMENTS

3292: DELETE FROM OE_PRICE_ADJS_HISTORY
3293: WHERE HEADER_ID = p_header_id;
3294: /* End Audit Trail */
3295:
3296: DELETE FROM OE_PRICE_ADJUSTMENTS
3297: WHERE HEADER_ID = p_header_id;
3298: ELSE
3299:
3300: --added for notification framework

Line 3366: DELETE FROM OE_PRICE_ADJUSTMENTS

3362: AND (NVL(VERSION_FLAG, 'N') = 'Y'
3363: OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
3364: /* End Audit Trail */
3365:
3366: DELETE FROM OE_PRICE_ADJUSTMENTS
3367: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id
3368: ;
3369: END IF;
3370:

Line 3536: FROM OE_PRICE_ADJUSTMENTS

3532: , ADJUSTED_AMOUNT_PER_PQTY
3533: , INVOICED_AMOUNT
3534: --uom end
3535: , LOCK_CONTROL
3536: FROM OE_PRICE_ADJUSTMENTS
3537: WHERE PRICE_ADJUSTMENT_ID = p_price_adjustment_id;
3538:
3539: CURSOR l_Header_Adj_csr_h IS
3540: SELECT ATTRIBUTE1

Line 3643: FROM OE_PRICE_ADJUSTMENTS

3639: , ADJUSTED_AMOUNT_PER_PQTY
3640: , INVOICED_AMOUNT
3641: --uom end
3642: , LOCK_CONTROL
3643: FROM OE_PRICE_ADJUSTMENTS
3644: WHERE HEADER_ID = p_header_id AND LINE_ID IS NULL;
3645:
3646: l_implicit_rec l_header_adj_csr_p%ROWTYPE;
3647: l_entity NUMBER;

Line 3897: FROM oe_price_adjustments

3893:
3894: -- added for performance change
3895: SELECT price_adjustment_id
3896: INTO l_price_adjustment_id
3897: FROM oe_price_adjustments
3898: WHERE price_adjustment_id = l_price_adjustment_id
3899: FOR UPDATE NOWAIT;
3900:
3901: IF l_debug_level > 0 THEN

Line 4033: FROM oe_price_adjustments

4029: IS
4030:
4031: CURSOR lock_adj_hdr(p_header_id IN NUMBER) IS
4032: SELECT price_adjustment_id
4033: FROM oe_price_adjustments
4034: WHERE header_id = p_header_id
4035: FOR UPDATE NOWAIT;
4036:
4037: l_price_adjustment_id NUMBER;

Line 4070: FROM oe_price_adjustments

4066: IF p_price_adjustment_id <> FND_API.G_MISS_NUM THEN
4067:
4068: SELECT price_adjustment_id
4069: INTO l_price_adjustment_id
4070: FROM oe_price_adjustments
4071: WHERE price_adjustment_id = p_price_adjustment_id
4072: FOR UPDATE NOWAIT;
4073: END IF;
4074:

Line 4402: FROM oe_price_adjustments_v opa

4398: 'AMT',opa.operand,
4399: 'NEWPRICE',ool.unit_list_price-opa.operand))
4400: unit_discount_amount
4401: --Bug 3340636 Ends
4402: FROM oe_price_adjustments_v opa
4403: , oe_order_lines_all ool
4404: WHERE opa.HEADER_ID = p_header_id
4405: and opa.line_id is null
4406: and ool.line_id = p_line_id

Line 4421: FROM oe_price_adjustments_v opa

4417: ,opa.adjustment_type_code
4418: ,opa.operand
4419: ,opa.arithmetic_operator
4420: ,opa.adjusted_amount*(-1) unit_discount_amount
4421: FROM oe_price_adjustments_v opa
4422: , oe_order_lines_all ool
4423: WHERE opa.line_id =p_line_id
4424: and ool.line_id = p_line_id
4425: and ool.header_id = p_header_id

Line 5099: FROM oe_price_adjustments

5095: ELSE
5096: IF p_header_id IS NULL THEN
5097: BEGIN
5098: SELECT header_id INTO l_header_id
5099: FROM oe_price_adjustments
5100: WHERE price_adjustment_id = p_price_adjustment_id;
5101:
5102: IF l_header_id IS NULL THEN
5103: RETURN NULL;

Line 5137: FROM oe_price_adjustments

5133: END IF;
5134:
5135: SELECT nvl(operand,0) * decode(list_line_type_code, 'DIS', -1, 'SUR', 1)
5136: INTO l_operand
5137: FROM oe_price_adjustments
5138: WHERE price_adjustment_id = p_price_adjustment_id
5139: AND line_id IS NULL
5140: AND arithmetic_operator = '%';
5141: