APPS.OE_LIN dependencies on SO_PRICE_ADJUSTMENTS

Line 86: FROM SO_PRICE_ADJUSTMENTS

82: OR ENFORCE_LINE_PRICES_FLAG = 'N') AND ROWNUM = 1;
83: if (X_Check_Multiple_Adj_Flag = 'Y') then
84: begin
85: SELECT NULL INTO L_Dummy
86: FROM SO_PRICE_ADJUSTMENTS
87: WHERE HEADER_ID = X_HEADER_ID
88: AND LINE_ID = X_LINE_ID
89: AND NVL( AUTOMATIC_FLAG, 'N' ) = 'N'
90: HAVING COUNT(*) > 1;

Line 206: SO_PRICE_ADJUSTMENTS

202: end if;
203: begin
204:
205: SELECT NULL INTO dummy FROM
206: SO_PRICE_ADJUSTMENTS
207: WHERE HEADER_ID = P_HEADER_ID
208: AND LINE_ID = P_LINE_ID
209: AND AUTOMATIC_FLAG = 'N';
210:

Line 211: UPDATE SO_PRICE_ADJUSTMENTS

207: WHERE HEADER_ID = P_HEADER_ID
208: AND LINE_ID = P_LINE_ID
209: AND AUTOMATIC_FLAG = 'N';
210:
211: UPDATE SO_PRICE_ADJUSTMENTS
212: SET PERCENT =
213: P_MANUAL_DisCOUNT_PERCENT
214: , DisCOUNT_ID =
215: P_MANUAL_DisCOUNT_ID

Line 231: INSERT INTO SO_PRICE_ADJUSTMENTS

227: exception
228:
229: when no_data_found then
230:
231: INSERT INTO SO_PRICE_ADJUSTMENTS
232: ( PRICE_ADJUSTMENT_ID
233: , CREATION_DATE
234: , CREATED_BY
235: , LAST_UPDATE_DATE

Line 245: ( SO_PRICE_ADJUSTMENTS_S.NEXTVAL

241: , DisCOUNT_LINE_ID
242: , AUTOMATIC_FLAG
243: , PERCENT)
244: VALUES
245: ( SO_PRICE_ADJUSTMENTS_S.NEXTVAL
246: , SYSDATE
247: , P_USER_ID
248: , SYSDATE
249: , P_USER_ID

Line 262: DELETE FROM SO_PRICE_ADJUSTMENTS

258: P_Adjustment_Total := null;
259: end;
260:
261: else
262: DELETE FROM SO_PRICE_ADJUSTMENTS
263: WHERE HEADER_ID = P_HEADER_ID
264: AND LINE_ID = P_LINE_ID
265: AND AUTOMATIC_FLAG = 'N';
266:

Line 303: FROM SO_PRICE_ADJUSTMENTS

299: P_Return_Status:=OE_SUCCESS;
300:
301: SELECT NVL( SUM( NVL( PERCENT, 0 ) ), 0 )
302: INTO Lin_Obj_Adjustment_Total
303: FROM SO_PRICE_ADJUSTMENTS
304: WHERE HEADER_ID = Order_Header_Id
305: AND (( Lin_Obj_Apply_Order_Adjs_Flag = 'Y'
306: AND LINE_ID is NULL )
307: OR ( LINE_ID = Lin_Obj_Line_Id