[Home] [Help]
PACKAGE BODY: APPS.ASO_PRICE_ADJUSTMENTS_PKG
Source
1 PACKAGE BODY ASO_PRICE_ADJUSTMENTS_PKG as
2 /* $Header: asotpadb.pls 120.1 2005/06/29 12:39:37 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PRICE_ADJUSTMENTS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11
12 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICE_ADJUSTMENTS_PKG';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotpadb.pls';
14
15 PROCEDURE Insert_Row(
16 px_PRICE_ADJUSTMENT_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
17 p_CREATION_DATE DATE,
18 p_CREATED_BY NUMBER,
19 p_LAST_UPDATE_DATE DATE,
20 p_LAST_UPDATED_BY NUMBER,
21 p_LAST_UPDATE_LOGIN NUMBER,
22 p_PROGRAM_APPLICATION_ID NUMBER,
23 p_PROGRAM_ID NUMBER,
24 p_PROGRAM_UPDATE_DATE DATE,
25 p_REQUEST_ID NUMBER,
26 p_QUOTE_HEADER_ID NUMBER,
27 p_QUOTE_LINE_ID NUMBER,
28 p_MODIFIER_HEADER_ID NUMBER,
29 p_MODIFIER_LINE_ID NUMBER,
30 p_MODIFIER_LINE_TYPE_CODE VARCHAR2,
31 p_MODIFIER_MECHANISM_TYPE_CODE VARCHAR2,
32 p_MODIFIED_FROM NUMBER,
33 p_MODIFIED_TO NUMBER,
34 p_OPERAND NUMBER,
35 p_ARITHMETIC_OPERATOR VARCHAR2,
36 p_AUTOMATIC_FLAG VARCHAR2,
37 p_UPDATE_ALLOWABLE_FLAG VARCHAR2,
38 p_UPDATED_FLAG VARCHAR2,
39 p_APPLIED_FLAG VARCHAR2,
40 p_ON_INVOICE_FLAG VARCHAR2,
41 p_PRICING_PHASE_ID NUMBER,
42 p_ATTRIBUTE_CATEGORY VARCHAR2,
43 p_ATTRIBUTE1 VARCHAR2,
44 p_ATTRIBUTE2 VARCHAR2,
45 p_ATTRIBUTE3 VARCHAR2,
46 p_ATTRIBUTE4 VARCHAR2,
47 p_ATTRIBUTE5 VARCHAR2,
48 p_ATTRIBUTE6 VARCHAR2,
49 p_ATTRIBUTE7 VARCHAR2,
50 p_ATTRIBUTE8 VARCHAR2,
51 p_ATTRIBUTE9 VARCHAR2,
52 p_ATTRIBUTE10 VARCHAR2,
53 p_ATTRIBUTE11 VARCHAR2,
54 p_ATTRIBUTE12 VARCHAR2,
55 p_ATTRIBUTE13 VARCHAR2,
56 p_ATTRIBUTE14 VARCHAR2,
57 p_ATTRIBUTE15 VARCHAR2,
58 p_ATTRIBUTE16 VARCHAR2,
59 p_ATTRIBUTE17 VARCHAR2,
60 p_ATTRIBUTE18 VARCHAR2,
61 p_ATTRIBUTE19 VARCHAR2,
62 p_ATTRIBUTE20 VARCHAR2,
63 p_ORIG_SYS_DISCOUNT_REF VARCHAR2 := NULL ,
64 p_CHANGE_SEQUENCE VARCHAR2 := NULL ,
65 -- p_LIST_HEADER_ID NUMBER := NULL ,
66 -- p_LIST_LINE_ID NUMBER := NULL ,
67 -- p_LIST_LINE_TYPE_CODE VARCHAR2 := NULL,
68 p_UPDATE_ALLOWED VARCHAR2 := NULL,
69 p_CHANGE_REASON_CODE VARCHAR2 := NULL,
70 p_CHANGE_REASON_TEXT VARCHAR2 := NULL,
71 p_COST_ID NUMBER := NULL,
72 p_TAX_CODE VARCHAR2 := NULL,
73 p_TAX_EXEMPT_FLAG VARCHAR2 := NULL,
74 p_TAX_EXEMPT_NUMBER VARCHAR2 := NULL,
75 p_TAX_EXEMPT_REASON_CODE VARCHAR2 := NULL,
76 p_PARENT_ADJUSTMENT_ID NUMBER := NULL,
77 p_INVOICED_FLAG VARCHAR2 := NULL,
78 p_ESTIMATED_FLAG VARCHAR2 := NULL,
79 p_INC_IN_SALES_PERFORMANCE VARCHAR2 := NULL,
80 p_SPLIT_ACTION_CODE VARCHAR2 := NULL,
81 p_ADJUSTED_AMOUNT NUMBER := NULL,
82 p_CHARGE_TYPE_CODE VARCHAR2 := NULL,
83 p_CHARGE_SUBTYPE_CODE VARCHAR2 := NULL,
84 p_RANGE_BREAK_QUANTITY NUMBER := NULL,
85 p_ACCRUAL_CONVERSION_RATE NUMBER := NULL ,
86 p_PRICING_GROUP_SEQUENCE NUMBER := NULL,
87 p_ACCRUAL_FLAG VARCHAR2 := NULL,
88 p_LIST_LINE_NO VARCHAR2 := NULL,
89 p_SOURCE_SYSTEM_CODE VARCHAR2 := NULL ,
90 p_BENEFIT_QTY NUMBER := NULL,
91 p_BENEFIT_UOM_CODE VARCHAR2 := NULL,
92 p_PRINT_ON_INVOICE_FLAG VARCHAR2 := NULL,
93 p_EXPIRATION_DATE DATE := NULL,
94 p_REBATE_TRANSACTION_TYPE_CODE VARCHAR2 := NULL,
95 p_REBATE_TRANSACTION_REFERENCE VARCHAR2 := NULL,
96 p_REBATE_PAYMENT_SYSTEM_CODE VARCHAR2 := NULL,
97 p_REDEEMED_DATE DATE := NULL,
98 p_REDEEMED_FLAG VARCHAR2 := NULL,
99 p_MODIFIER_LEVEL_CODE VARCHAR2 := NULL,
100 p_PRICE_BREAK_TYPE_CODE VARCHAR2 := NULL,
101 p_SUBSTITUTION_ATTRIBUTE VARCHAR2 := NULL,
102 p_PRORATION_TYPE_CODE VARCHAR2 := NULL,
103 p_INCLUDE_ON_RETURNS_FLAG VARCHAR2 := NULL,
104 p_CREDIT_OR_CHARGE_FLAG VARCHAR2 := NULL,
105 p_quote_shipment_id NUMBER := NULL,
106 p_OPERAND_PER_PQTY NUMBER := NULL,
107 p_ADJUSTED_AMOUNT_PER_PQTY NUMBER := NULL,
108 p_OBJECT_VERSION_NUMBER NUMBER)
109
110 IS
111 CURSOR C2 IS SELECT ASO_PRICE_ADJUSTMENTS_S.nextval FROM sys.dual;
112 BEGIN
113 If (px_PRICE_ADJUSTMENT_ID IS NULL) OR (px_PRICE_ADJUSTMENT_ID = FND_API.G_MISS_NUM) then
114 OPEN C2;
115 FETCH C2 INTO px_PRICE_ADJUSTMENT_ID;
116 CLOSE C2;
117 End If;
118 INSERT INTO ASO_PRICE_ADJUSTMENTS(
119 PRICE_ADJUSTMENT_ID,
120 CREATION_DATE,
121 CREATED_BY,
122 LAST_UPDATE_DATE,
123 LAST_UPDATED_BY,
124 LAST_UPDATE_LOGIN,
125 PROGRAM_APPLICATION_ID,
126 PROGRAM_ID,
127 PROGRAM_UPDATE_DATE,
128 REQUEST_ID,
129 QUOTE_HEADER_ID,
130 QUOTE_LINE_ID,
131 MODIFIER_HEADER_ID,
132 MODIFIER_LINE_ID,
133 MODIFIER_LINE_TYPE_CODE,
134 MODIFIER_MECHANISM_TYPE_CODE,
135 MODIFIED_FROM,
136 MODIFIED_TO,
137 OPERAND,
138 ARITHMETIC_OPERATOR,
139 AUTOMATIC_FLAG,
140 UPDATE_ALLOWABLE_FLAG,
141 UPDATED_FLAG,
142 APPLIED_FLAG,
143 ON_INVOICE_FLAG,
144 PRICING_PHASE_ID,
145 ATTRIBUTE_CATEGORY,
146 ATTRIBUTE1,
147 ATTRIBUTE2,
148 ATTRIBUTE3,
149 ATTRIBUTE4,
150 ATTRIBUTE5,
151 ATTRIBUTE6,
152 ATTRIBUTE7,
153 ATTRIBUTE8,
154 ATTRIBUTE9,
155 ATTRIBUTE10,
156 ATTRIBUTE11,
157 ATTRIBUTE12,
158 ATTRIBUTE13,
159 ATTRIBUTE14,
160 ATTRIBUTE15,
161 ATTRIBUTE16,
162 ATTRIBUTE17,
163 ATTRIBUTE18,
164 ATTRIBUTE19,
165 ATTRIBUTE20,
166 ORIG_SYS_DISCOUNT_REF ,
167 CHANGE_SEQUENCE ,
168 UPDATE_ALLOWED ,
169 CHANGE_REASON_CODE ,
170 CHANGE_REASON_TEXT ,
171 COST_ID ,
172 TAX_CODE ,
173 TAX_EXEMPT_FLAG ,
174 TAX_EXEMPT_NUMBER ,
175 TAX_EXEMPT_REASON_CODE ,
176 PARENT_ADJUSTMENT_ID ,
177 INVOICED_FLAG ,
178 ESTIMATED_FLAG ,
179 INC_IN_SALES_PERFORMANCE ,
180 SPLIT_ACTION_CODE ,
181 ADJUSTED_AMOUNT ,
182 CHARGE_TYPE_CODE ,
183 CHARGE_SUBTYPE_CODE ,
184 RANGE_BREAK_QUANTITY ,
185 ACCRUAL_CONVERSION_RATE ,
186 PRICING_GROUP_SEQUENCE ,
187 ACCRUAL_FLAG ,
188 LIST_LINE_NO ,
189 SOURCE_SYSTEM_CODE ,
190 BENEFIT_QTY ,
191 BENEFIT_UOM_CODE ,
192 PRINT_ON_INVOICE_FLAG ,
193 EXPIRATION_DATE ,
194 REBATE_TRANSACTION_TYPE_CODE ,
195 REBATE_TRANSACTION_REFERENCE ,
196 REBATE_PAYMENT_SYSTEM_CODE ,
197 REDEEMED_DATE ,
198 REDEEMED_FLAG ,
199 MODIFIER_LEVEL_CODE ,
200 PRICE_BREAK_TYPE_CODE ,
201 SUBSTITUTION_ATTRIBUTE ,
202 PRORATION_TYPE_CODE ,
203 INCLUDE_ON_RETURNS_FLAG ,
204 CREDIT_OR_CHARGE_FLAG ,
205 quote_shipment_id,
206 OPERAND_PER_PQTY,
207 ADJUSTED_AMOUNT_PER_PQTY,
208 OBJECT_VERSION_NUMBER
209 )
210 VALUES (
211 px_PRICE_ADJUSTMENT_ID,
212 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
213 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
214 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
215 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
216 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
217 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
218 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
219 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
220 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
221 decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
222 decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
223 decode( p_MODIFIER_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_MODIFIER_HEADER_ID),
224 decode( p_MODIFIER_LINE_ID, FND_API.G_MISS_NUM, NULL, p_MODIFIER_LINE_ID),
225 decode( p_MODIFIER_LINE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODIFIER_LINE_TYPE_CODE),
226 decode( p_MODIFIER_MECHANISM_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MODIFIER_MECHANISM_TYPE_CODE),
227 decode( p_MODIFIED_FROM, FND_API.G_MISS_NUM, NULL, p_MODIFIED_FROM),
228 decode( p_MODIFIED_TO, FND_API.G_MISS_NUM, NULL, p_MODIFIED_TO),
229 decode( p_OPERAND, FND_API.G_MISS_NUM, NULL, p_OPERAND),
230 decode( p_ARITHMETIC_OPERATOR, FND_API.G_MISS_CHAR, NULL, p_ARITHMETIC_OPERATOR),
231 decode( p_AUTOMATIC_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_FLAG),
232 decode( p_UPDATE_ALLOWABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWABLE_FLAG),
233 decode( p_UPDATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATED_FLAG),
234 decode( p_APPLIED_FLAG, FND_API.G_MISS_CHAR, NULL, p_APPLIED_FLAG),
235 decode( p_ON_INVOICE_FLAG, FND_API.G_MISS_CHAR, NULL, p_ON_INVOICE_FLAG),
236 decode( p_PRICING_PHASE_ID, FND_API.G_MISS_NUM, NULL, p_PRICING_PHASE_ID),
237 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
238 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
239 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
240 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
241 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
242 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
243 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
244 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
245 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
246 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
247 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
248 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
249 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
250 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
251 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
252 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
253 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
254 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
255 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
256 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
257 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
258 decode( p_ORIG_SYS_DISCOUNT_REF, FND_API.G_MISS_CHAR, NULL, p_ORIG_SYS_DISCOUNT_REF),
259 decode( p_CHANGE_SEQUENCE, FND_API.G_MISS_CHAR, NULL,p_CHANGE_SEQUENCE) ,
260 decode( p_UPDATE_ALLOWED, FND_API.G_MISS_CHAR, NULL,p_UPDATE_ALLOWED) ,
261 decode( p_CHANGE_REASON_CODE, FND_API.G_MISS_CHAR, NULL,p_CHANGE_REASON_CODE) ,
262 decode( p_CHANGE_REASON_TEXT, FND_API.G_MISS_CHAR, NULL,p_CHANGE_REASON_TEXT) ,
263 decode( p_COST_ID, FND_API.G_MISS_NUM, NULL,p_COST_ID) ,
264 decode( p_TAX_CODE, FND_API.G_MISS_CHAR, NULL,p_TAX_CODE) ,
265 decode( p_TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR, NULL,p_TAX_EXEMPT_FLAG) ,
266 decode( p_TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR, NULL,p_TAX_EXEMPT_NUMBER) ,
267 decode( p_TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR, NULL,p_TAX_EXEMPT_REASON_CODE) ,
268 decode( p_PARENT_ADJUSTMENT_ID, FND_API.G_MISS_NUM, NULL,p_PARENT_ADJUSTMENT_ID) ,
269 decode( p_INVOICED_FLAG, FND_API.G_MISS_CHAR, NULL,p_INVOICED_FLAG) ,
270 decode( p_ESTIMATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_ESTIMATED_FLAG) ,
271 decode( p_INC_IN_SALES_PERFORMANCE, FND_API.G_MISS_CHAR, NULL,p_INC_IN_SALES_PERFORMANCE) ,
272 decode( p_SPLIT_ACTION_CODE, FND_API.G_MISS_CHAR, NULL,p_SPLIT_ACTION_CODE) ,
273 decode( p_ADJUSTED_AMOUNT, FND_API.G_MISS_NUM, NULL,p_ADJUSTED_AMOUNT) ,
274 decode( p_CHARGE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,p_CHARGE_TYPE_CODE) ,
275 decode( p_CHARGE_SUBTYPE_CODE, FND_API.G_MISS_CHAR, NULL,p_CHARGE_SUBTYPE_CODE) ,
276 decode( p_RANGE_BREAK_QUANTITY, FND_API.G_MISS_NUM, NULL,p_RANGE_BREAK_QUANTITY) ,
277 decode( p_ACCRUAL_CONVERSION_RATE, FND_API.G_MISS_NUM, NULL,p_ACCRUAL_CONVERSION_RATE) ,
278 decode( p_PRICING_GROUP_SEQUENCE, FND_API.G_MISS_NUM, NULL,p_PRICING_GROUP_SEQUENCE) ,
279 decode( p_ACCRUAL_FLAG, FND_API.G_MISS_CHAR, NULL,p_ACCRUAL_FLAG) ,
280 decode( p_LIST_LINE_NO, FND_API.G_MISS_CHAR, NULL,p_LIST_LINE_NO) ,
281 decode( p_SOURCE_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL,p_SOURCE_SYSTEM_CODE) ,
285 ASO_UTILITY_PVT.decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE, NULL,p_EXPIRATION_DATE) ,
282 decode( p_BENEFIT_QTY, FND_API.G_MISS_NUM, NULL,p_BENEFIT_QTY) ,
283 decode( p_BENEFIT_UOM_CODE, FND_API.G_MISS_CHAR, NULL,p_BENEFIT_UOM_CODE) ,
284 decode( p_PRINT_ON_INVOICE_FLAG, FND_API.G_MISS_CHAR, NULL,p_PRINT_ON_INVOICE_FLAG) ,
286 decode( p_REBATE_TRANSACTION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,p_REBATE_TRANSACTION_TYPE_CODE) ,
287 decode( p_REBATE_TRANSACTION_REFERENCE, FND_API.G_MISS_CHAR, NULL,p_REBATE_TRANSACTION_REFERENCE) ,
288 decode( p_REBATE_PAYMENT_SYSTEM_CODE, FND_API.G_MISS_CHAR, NULL,p_REBATE_PAYMENT_SYSTEM_CODE) ,
289 ASO_UTILITY_PVT.decode( p_REDEEMED_DATE, FND_API.G_MISS_DATE, NULL,p_REDEEMED_DATE) ,
290 decode( p_REDEEMED_FLAG, FND_API.G_MISS_CHAR, NULL,p_REDEEMED_FLAG) ,
291 decode( p_MODIFIER_LEVEL_CODE, FND_API.G_MISS_CHAR, NULL,p_MODIFIER_LEVEL_CODE) ,
292 decode( p_PRICE_BREAK_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,p_PRICE_BREAK_TYPE_CODE) ,
293 decode( p_SUBSTITUTION_ATTRIBUTE, FND_API.G_MISS_CHAR, NULL,p_SUBSTITUTION_ATTRIBUTE) ,
294 decode( p_PRORATION_TYPE_CODE, FND_API.G_MISS_CHAR, NULL,p_PRORATION_TYPE_CODE) ,
295 decode( p_INCLUDE_ON_RETURNS_FLAG, FND_API.G_MISS_CHAR, NULL,p_INCLUDE_ON_RETURNS_FLAG) ,
296 decode( p_CREDIT_OR_CHARGE_FLAG, FND_API.G_MISS_CHAR, NULL,p_CREDIT_OR_CHARGE_FLAG) ,
297 decode( p_quote_shipment_id, FND_API.G_MISS_NUM, NULL,p_quote_shipment_id),
298 decode( p_OPERAND_PER_PQTY, FND_API.G_MISS_NUM, NULL,p_OPERAND_PER_PQTY),
299 decode( p_ADJUSTED_AMOUNT_PER_PQTY, FND_API.G_MISS_NUM, NULL,p_ADJUSTED_AMOUNT_PER_PQTY),
300 decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)
301 );
302 End Insert_Row;
303
304 PROCEDURE Update_Row(
305 p_PRICE_ADJUSTMENT_ID NUMBER,
306 p_CREATION_DATE DATE,
307 p_CREATED_BY NUMBER,
308 p_LAST_UPDATE_DATE DATE,
309 p_LAST_UPDATED_BY NUMBER,
310 p_LAST_UPDATE_LOGIN NUMBER,
311 p_PROGRAM_APPLICATION_ID NUMBER,
312 p_PROGRAM_ID NUMBER,
313 p_PROGRAM_UPDATE_DATE DATE,
314 p_REQUEST_ID NUMBER,
315 p_QUOTE_HEADER_ID NUMBER,
316 p_QUOTE_LINE_ID NUMBER,
317 p_MODIFIER_HEADER_ID NUMBER,
318 p_MODIFIER_LINE_ID NUMBER,
319 p_MODIFIER_LINE_TYPE_CODE VARCHAR2,
320 p_MODIFIER_MECHANISM_TYPE_CODE VARCHAR2,
321 p_MODIFIED_FROM NUMBER,
322 p_MODIFIED_TO NUMBER,
323 p_OPERAND NUMBER,
324 p_ARITHMETIC_OPERATOR VARCHAR2,
325 p_AUTOMATIC_FLAG VARCHAR2,
326 p_UPDATE_ALLOWABLE_FLAG VARCHAR2,
327 p_UPDATED_FLAG VARCHAR2,
328 p_APPLIED_FLAG VARCHAR2,
329 p_ON_INVOICE_FLAG VARCHAR2,
330 p_PRICING_PHASE_ID NUMBER,
331 p_ATTRIBUTE_CATEGORY VARCHAR2,
332 p_ATTRIBUTE1 VARCHAR2,
333 p_ATTRIBUTE2 VARCHAR2,
334 p_ATTRIBUTE3 VARCHAR2,
335 p_ATTRIBUTE4 VARCHAR2,
336 p_ATTRIBUTE5 VARCHAR2,
337 p_ATTRIBUTE6 VARCHAR2,
338 p_ATTRIBUTE7 VARCHAR2,
339 p_ATTRIBUTE8 VARCHAR2,
340 p_ATTRIBUTE9 VARCHAR2,
341 p_ATTRIBUTE10 VARCHAR2,
342 p_ATTRIBUTE11 VARCHAR2,
343 p_ATTRIBUTE12 VARCHAR2,
344 p_ATTRIBUTE13 VARCHAR2,
345 p_ATTRIBUTE14 VARCHAR2,
346 p_ATTRIBUTE15 VARCHAR2,
347 p_ATTRIBUTE16 VARCHAR2,
348 p_ATTRIBUTE17 VARCHAR2,
349 p_ATTRIBUTE18 VARCHAR2,
350 p_ATTRIBUTE19 VARCHAR2,
351 p_ATTRIBUTE20 VARCHAR2,
352 p_ORIG_SYS_DISCOUNT_REF VARCHAR2,
353 p_CHANGE_SEQUENCE VARCHAR2,
354 --p_LIST_HEADER_ID NUMBER,
355 --p_LIST_LINE_ID NUMBER,
356 --p_LIST_LINE_TYPE_CODE VARCHAR2,
357 p_UPDATE_ALLOWED VARCHAR2,
358 p_CHANGE_REASON_CODE VARCHAR2,
359 p_CHANGE_REASON_TEXT VARCHAR2,
360 p_COST_ID NUMBER,
361 p_TAX_CODE VARCHAR2,
362 p_TAX_EXEMPT_FLAG VARCHAR2,
363 p_TAX_EXEMPT_NUMBER VARCHAR2,
364 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
365 p_PARENT_ADJUSTMENT_ID NUMBER,
366 p_INVOICED_FLAG VARCHAR2,
367 p_ESTIMATED_FLAG VARCHAR2,
368 p_INC_IN_SALES_PERFORMANCE VARCHAR2,
369 p_SPLIT_ACTION_CODE VARCHAR2,
373 p_RANGE_BREAK_QUANTITY NUMBER,
370 p_ADJUSTED_AMOUNT NUMBER,
371 p_CHARGE_TYPE_CODE VARCHAR2,
372 p_CHARGE_SUBTYPE_CODE VARCHAR2,
374 p_ACCRUAL_CONVERSION_RATE NUMBER,
375 p_PRICING_GROUP_SEQUENCE NUMBER,
376 p_ACCRUAL_FLAG VARCHAR2,
377 p_LIST_LINE_NO VARCHAR2,
378 p_SOURCE_SYSTEM_CODE VARCHAR2,
379 p_BENEFIT_QTY NUMBER,
380 p_BENEFIT_UOM_CODE VARCHAR2,
381 p_PRINT_ON_INVOICE_FLAG VARCHAR2,
382 p_EXPIRATION_DATE DATE,
383 p_REBATE_TRANSACTION_TYPE_CODE VARCHAR2,
384 p_REBATE_TRANSACTION_REFERENCE VARCHAR2,
385 p_REBATE_PAYMENT_SYSTEM_CODE VARCHAR2,
386 p_REDEEMED_DATE DATE,
387 p_REDEEMED_FLAG VARCHAR2,
388 p_MODIFIER_LEVEL_CODE VARCHAR2,
389 p_PRICE_BREAK_TYPE_CODE VARCHAR2,
390 p_SUBSTITUTION_ATTRIBUTE VARCHAR2,
391 p_PRORATION_TYPE_CODE VARCHAR2,
392 p_INCLUDE_ON_RETURNS_FLAG VARCHAR2,
393 p_CREDIT_OR_CHARGE_FLAG VARCHAR2,
394 p_quote_shipment_id NUMBER,
395 p_OPERAND_PER_PQTY NUMBER,
396 p_ADJUSTED_AMOUNT_PER_PQTY NUMBER,
397 p_OBJECT_VERSION_NUMBER NUMBER
398 )
399
400 IS
401 BEGIN
402 Update ASO_PRICE_ADJUSTMENTS
403 SET
404 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
405 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
406 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
407 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
408 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
409 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
410 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
411 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
412 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
413 QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
414 QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
415 MODIFIER_HEADER_ID = decode( p_MODIFIER_HEADER_ID, FND_API.G_MISS_NUM, MODIFIER_HEADER_ID, p_MODIFIER_HEADER_ID),
416 MODIFIER_LINE_ID = decode( p_MODIFIER_LINE_ID, FND_API.G_MISS_NUM, MODIFIER_LINE_ID, p_MODIFIER_LINE_ID),
417 MODIFIER_LINE_TYPE_CODE = decode( p_MODIFIER_LINE_TYPE_CODE, FND_API.G_MISS_CHAR, MODIFIER_LINE_TYPE_CODE, p_MODIFIER_LINE_TYPE_CODE),
418 MODIFIER_MECHANISM_TYPE_CODE = decode( p_MODIFIER_MECHANISM_TYPE_CODE, FND_API.G_MISS_CHAR, MODIFIER_MECHANISM_TYPE_CODE, p_MODIFIER_MECHANISM_TYPE_CODE),
419 MODIFIED_FROM = decode( p_MODIFIED_FROM, FND_API.G_MISS_NUM, MODIFIED_FROM, p_MODIFIED_FROM),
420 MODIFIED_TO = decode( p_MODIFIED_TO, FND_API.G_MISS_NUM, MODIFIED_TO, p_MODIFIED_TO),
421 OPERAND = decode( p_OPERAND, FND_API.G_MISS_NUM, OPERAND, p_OPERAND),
422 ARITHMETIC_OPERATOR = decode( p_ARITHMETIC_OPERATOR, FND_API.G_MISS_CHAR, ARITHMETIC_OPERATOR, p_ARITHMETIC_OPERATOR),
423 AUTOMATIC_FLAG = decode( p_AUTOMATIC_FLAG, FND_API.G_MISS_CHAR, AUTOMATIC_FLAG, p_AUTOMATIC_FLAG),
424 UPDATE_ALLOWABLE_FLAG = decode( p_UPDATE_ALLOWABLE_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWABLE_FLAG, p_UPDATE_ALLOWABLE_FLAG),
425 UPDATED_FLAG = decode( p_UPDATED_FLAG, FND_API.G_MISS_CHAR, UPDATED_FLAG, p_UPDATED_FLAG),
426 APPLIED_FLAG = decode( p_APPLIED_FLAG, FND_API.G_MISS_CHAR, APPLIED_FLAG, p_APPLIED_FLAG),
427 ON_INVOICE_FLAG = decode( p_ON_INVOICE_FLAG, FND_API.G_MISS_CHAR, ON_INVOICE_FLAG, p_ON_INVOICE_FLAG),
428 PRICING_PHASE_ID = decode( p_PRICING_PHASE_ID, FND_API.G_MISS_NUM, PRICING_PHASE_ID, p_PRICING_PHASE_ID),
429 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
430 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
431 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
432 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
433 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
434 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
435 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
436 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
437 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
438 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
439 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
440 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
441 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
442 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
446 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
443 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
444 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15) ,
445 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
447 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
448 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
449 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
450 ORIG_SYS_DISCOUNT_REF = decode( p_ORIG_SYS_DISCOUNT_REF, FND_API.G_MISS_CHAR, ORIG_SYS_DISCOUNT_REF, p_ORIG_SYS_DISCOUNT_REF),
451 CHANGE_SEQUENCE = decode( p_CHANGE_SEQUENCE, FND_API.G_MISS_CHAR, CHANGE_SEQUENCE,p_CHANGE_SEQUENCE),
452 UPDATE_ALLOWED = decode( p_UPDATE_ALLOWED, FND_API.G_MISS_CHAR, UPDATE_ALLOWED,p_UPDATE_ALLOWED),
453 CHANGE_REASON_CODE = decode( p_CHANGE_REASON_CODE, FND_API.G_MISS_CHAR, CHANGE_REASON_CODE,p_CHANGE_REASON_CODE),
454 CHANGE_REASON_TEXT = decode( p_CHANGE_REASON_TEXT, FND_API.G_MISS_CHAR, CHANGE_REASON_TEXT,p_CHANGE_REASON_TEXT),
455 COST_ID = decode( p_COST_ID, FND_API.G_MISS_NUM, COST_ID,p_COST_ID),
456 TAX_CODE = decode( p_TAX_CODE, FND_API.G_MISS_CHAR, TAX_CODE,p_TAX_CODE),
457 TAX_EXEMPT_FLAG = decode( p_TAX_EXEMPT_FLAG, FND_API.G_MISS_CHAR, TAX_EXEMPT_FLAG,p_TAX_EXEMPT_FLAG),
458 TAX_EXEMPT_NUMBER = decode( p_TAX_EXEMPT_NUMBER, FND_API.G_MISS_CHAR, TAX_EXEMPT_NUMBER,p_TAX_EXEMPT_NUMBER),
459 TAX_EXEMPT_REASON_CODE = decode( p_TAX_EXEMPT_REASON_CODE, FND_API.G_MISS_CHAR, TAX_EXEMPT_REASON_CODE,p_TAX_EXEMPT_REASON_CODE),
460 PARENT_ADJUSTMENT_ID = decode( p_PARENT_ADJUSTMENT_ID, FND_API.G_MISS_NUM, PARENT_ADJUSTMENT_ID,p_PARENT_ADJUSTMENT_ID),
461 INVOICED_FLAG = decode( p_INVOICED_FLAG, FND_API.G_MISS_CHAR, INVOICED_FLAG,p_INVOICED_FLAG),
462 ESTIMATED_FLAG = decode( p_ESTIMATED_FLAG, FND_API.G_MISS_CHAR, ESTIMATED_FLAG,p_ESTIMATED_FLAG),
463 INC_IN_SALES_PERFORMANCE = decode( p_INC_IN_SALES_PERFORMANCE, FND_API.G_MISS_CHAR, INC_IN_SALES_PERFORMANCE,p_INC_IN_SALES_PERFORMANCE),
464 SPLIT_ACTION_CODE = decode ( p_SPLIT_ACTION_CODE, FND_API.G_MISS_CHAR, SPLIT_ACTION_CODE,p_SPLIT_ACTION_CODE),
465 ADJUSTED_AMOUNT = decode ( p_ADJUSTED_AMOUNT, FND_API.G_MISS_NUM, ADJUSTED_AMOUNT,p_ADJUSTED_AMOUNT),
466 CHARGE_TYPE_CODE = decode ( p_CHARGE_TYPE_CODE, FND_API.G_MISS_CHAR, CHARGE_TYPE_CODE,p_CHARGE_TYPE_CODE),
467 CHARGE_SUBTYPE_CODE = decode ( p_CHARGE_SUBTYPE_CODE, FND_API.G_MISS_CHAR, CHARGE_SUBTYPE_CODE,p_CHARGE_SUBTYPE_CODE),
468 RANGE_BREAK_QUANTITY = decode ( p_RANGE_BREAK_QUANTITY, FND_API.G_MISS_NUM, RANGE_BREAK_QUANTITY,p_RANGE_BREAK_QUANTITY),
469 ACCRUAL_CONVERSION_RATE = decode ( p_ACCRUAL_CONVERSION_RATE, FND_API.G_MISS_NUM, ACCRUAL_CONVERSION_RATE,p_ACCRUAL_CONVERSION_RATE),
470 PRICING_GROUP_SEQUENCE = decode ( p_PRICING_GROUP_SEQUENCE, FND_API.G_MISS_NUM, PRICING_GROUP_SEQUENCE,p_PRICING_GROUP_SEQUENCE),
471 ACCRUAL_FLAG = decode ( p_ACCRUAL_FLAG, FND_API.G_MISS_CHAR, ACCRUAL_FLAG,p_ACCRUAL_FLAG),
472 LIST_LINE_NO = decode ( p_LIST_LINE_NO, FND_API.G_MISS_CHAR, LIST_LINE_NO,p_LIST_LINE_NO),
473 SOURCE_SYSTEM_CODE = decode ( p_SOURCE_SYSTEM_CODE, FND_API.G_MISS_CHAR, SOURCE_SYSTEM_CODE,p_SOURCE_SYSTEM_CODE),
474 BENEFIT_QTY = decode ( p_BENEFIT_QTY, FND_API.G_MISS_NUM, BENEFIT_QTY,p_BENEFIT_QTY),
475 BENEFIT_UOM_CODE = decode ( p_BENEFIT_UOM_CODE, FND_API.G_MISS_CHAR, BENEFIT_UOM_CODE,p_BENEFIT_UOM_CODE),
476 PRINT_ON_INVOICE_FLAG = decode ( p_PRINT_ON_INVOICE_FLAG, FND_API.G_MISS_CHAR, PRINT_ON_INVOICE_FLAG,p_PRINT_ON_INVOICE_FLAG),
477 EXPIRATION_DATE = ASO_UTILITY_PVT.decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE, EXPIRATION_DATE,p_EXPIRATION_DATE),
478 REBATE_TRANSACTION_TYPE_CODE = decode( p_REBATE_TRANSACTION_TYPE_CODE, FND_API.G_MISS_CHAR, REBATE_TRANSACTION_TYPE_CODE,p_REBATE_TRANSACTION_TYPE_CODE),
479 REBATE_TRANSACTION_REFERENCE = decode( p_REBATE_TRANSACTION_REFERENCE, FND_API.G_MISS_CHAR, REBATE_TRANSACTION_REFERENCE,p_REBATE_TRANSACTION_REFERENCE),
480 REBATE_PAYMENT_SYSTEM_CODE = decode( p_REBATE_PAYMENT_SYSTEM_CODE, FND_API.G_MISS_CHAR, REBATE_PAYMENT_SYSTEM_CODE,p_REBATE_PAYMENT_SYSTEM_CODE),
481 REDEEMED_DATE = ASO_UTILITY_PVT.decode( p_REDEEMED_DATE, FND_API.G_MISS_DATE, REDEEMED_DATE,p_REDEEMED_DATE),
482 REDEEMED_FLAG = decode( p_REDEEMED_FLAG, FND_API.G_MISS_CHAR, REDEEMED_FLAG,p_REDEEMED_FLAG),
483 MODIFIER_LEVEL_CODE = decode( p_MODIFIER_LEVEL_CODE, FND_API.G_MISS_CHAR, MODIFIER_LEVEL_CODE,p_MODIFIER_LEVEL_CODE),
484 PRICE_BREAK_TYPE_CODE = decode( p_PRICE_BREAK_TYPE_CODE, FND_API.G_MISS_CHAR, PRICE_BREAK_TYPE_CODE,p_PRICE_BREAK_TYPE_CODE),
485 SUBSTITUTION_ATTRIBUTE = decode( p_SUBSTITUTION_ATTRIBUTE, FND_API.G_MISS_CHAR, SUBSTITUTION_ATTRIBUTE,p_SUBSTITUTION_ATTRIBUTE),
486 PRORATION_TYPE_CODE = decode( p_PRORATION_TYPE_CODE, FND_API.G_MISS_CHAR, PRORATION_TYPE_CODE,p_PRORATION_TYPE_CODE),
487 INCLUDE_ON_RETURNS_FLAG = decode( p_INCLUDE_ON_RETURNS_FLAG, FND_API.G_MISS_CHAR, INCLUDE_ON_RETURNS_FLAG,p_INCLUDE_ON_RETURNS_FLAG),
488 CREDIT_OR_CHARGE_FLAG = decode( p_CREDIT_OR_CHARGE_FLAG, FND_API.G_MISS_CHAR, CREDIT_OR_CHARGE_FLAG,p_CREDIT_OR_CHARGE_FLAG),
489 quote_shipment_id = decode( p_quote_shipment_id, FND_API.G_MISS_NUM, quote_shipment_id,p_quote_shipment_id),
490 OPERAND_PER_PQTY = decode( p_OPERAND_PER_PQTY, FND_API.G_MISS_NUM, OPERAND_PER_PQTY,p_OPERAND_PER_PQTY),
491 ADJUSTED_AMOUNT_PER_PQTY = decode( p_ADJUSTED_AMOUNT_PER_PQTY, FND_API.G_MISS_NUM, ADJUSTED_AMOUNT_PER_PQTY,p_ADJUSTED_AMOUNT_PER_PQTY),
492 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1)
493 where PRICE_ADJUSTMENT_ID = p_PRICE_ADJUSTMENT_ID;
494
495 If (SQL%NOTFOUND) then
496 RAISE NO_DATA_FOUND;
497 End If;
498 END Update_Row;
499
500 PROCEDURE Delete_Row(
501 p_PRICE_ADJUSTMENT_ID NUMBER)
505 WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJUSTMENT_ID;
502 IS
503 BEGIN
504 DELETE FROM ASO_PRICE_ADJUSTMENTS
506 If (SQL%NOTFOUND) then
507 RAISE NO_DATA_FOUND;
508 End If;
509 END Delete_Row;
510
511
512 PROCEDURE Delete_Row(
513 p_PRICE_ADJ_ID NUMBER)
514 IS
515
516 BEGIN
517
518 DELETE FROM ASO_PRICE_ADJ_ATTRIBS
519 WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID;
520 If (SQL%NOTFOUND) then
521 null;
522 End If;
523
524 -- delete from aso_price adjustments the id and the related id
525 DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
526 WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID
527 OR RLTD_PRICE_ADJ_ID = p_PRICE_ADJ_ID;
528 If (SQL%NOTFOUND) then
529 null;
530 End If;
531
532
533 -- delete from aso_price_adjustments
534
535 DELETE FROM ASO_PRICE_ADJUSTMENTS
536 WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJ_ID;
537 If (SQL%NOTFOUND) then
538 null;
539 RAISE NO_DATA_FOUND;
540 End If;
541 END Delete_Row;
542
543 PROCEDURE Delete_Row(
544 p_LINE_ID NUMBER,
545 p_TYPE_CODE VARCHAR2)
546 IS
547 l_price_adj_id NUMBER;
548
549
550 Cursor C_line_adj(l_quote_line_id NUMBER) IS
551 SELECT price_adjustment_id
552 FROM aso_price_adjustments
553 where quote_line_id = l_quote_line_id;
554
555 Cursor C_shipment_adj(l_quote_shipment_id NUMBER) IS
556 SELECT price_adjustment_id
557 FROM aso_price_adjustments
558 where quote_shipment_id = l_quote_shipment_id;
559
560 BEGIN
561
562 If p_TYPE_CODE = 'QUOTE_LINE' THEN
563
564 DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
565 WHERE QUOTE_LINE_ID = p_line_id;
566 If (SQL%NOTFOUND) then
567 null;
568 End If;
569
570 For i in C_line_adj(p_line_id) LOOP
571 Delete_Row( p_PRICE_ADJ_ID => i.price_adjustment_id);
572 END LOOP;
573
574 elsif p_TYPE_CODE = 'SHIPMENT_LINE' THEN
575
576 DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
577 WHERE QUOTE_SHIPMENT_ID = p_line_id;
578 If (SQL%NOTFOUND) then
579 null;
580 End If;
581
582 For i in C_shipment_adj(p_line_id) LOOP
583 Delete_Row( p_PRICE_ADJ_ID => i.price_adjustment_id);
584 END LOOP;
585
586 end if;
587
588 END Delete_Row;
589
590 PROCEDURE Lock_Row(
591 --p_OBJECT_VERSION_NUMBER NUMBER,
592 p_PRICE_ADJUSTMENT_ID NUMBER,
593 p_CREATION_DATE DATE,
594 p_CREATED_BY NUMBER,
595 p_LAST_UPDATE_DATE DATE,
596 p_LAST_UPDATED_BY NUMBER,
597 p_LAST_UPDATE_LOGIN NUMBER,
598 p_PROGRAM_APPLICATION_ID NUMBER,
599 p_PROGRAM_ID NUMBER,
600 p_PROGRAM_UPDATE_DATE DATE,
601 p_REQUEST_ID NUMBER,
602 p_QUOTE_HEADER_ID NUMBER,
603 p_QUOTE_LINE_ID NUMBER,
604 p_MODIFIER_HEADER_ID NUMBER,
605 p_MODIFIER_LINE_ID NUMBER,
606 p_MODIFIER_LINE_TYPE_CODE VARCHAR2,
607 p_MODIFIER_MECHANISM_TYPE_CODE VARCHAR2,
608 p_MODIFIED_FROM NUMBER,
609 p_MODIFIED_TO NUMBER,
610 p_OPERAND NUMBER,
611 p_ARITHMETIC_OPERATOR VARCHAR2,
612 p_AUTOMATIC_FLAG VARCHAR2,
613 p_UPDATE_ALLOWABLE_FLAG VARCHAR2,
614 p_UPDATED_FLAG VARCHAR2,
615 p_APPLIED_FLAG VARCHAR2,
616 p_ON_INVOICE_FLAG VARCHAR2,
617 p_PRICING_PHASE_ID NUMBER,
618 p_ATTRIBUTE_CATEGORY VARCHAR2,
619 p_ATTRIBUTE1 VARCHAR2,
620 p_ATTRIBUTE2 VARCHAR2,
621 p_ATTRIBUTE3 VARCHAR2,
622 p_ATTRIBUTE4 VARCHAR2,
623 p_ATTRIBUTE5 VARCHAR2,
624 p_ATTRIBUTE6 VARCHAR2,
625 p_ATTRIBUTE7 VARCHAR2,
626 p_ATTRIBUTE8 VARCHAR2,
627 p_ATTRIBUTE9 VARCHAR2,
628 p_ATTRIBUTE10 VARCHAR2,
629 p_ATTRIBUTE11 VARCHAR2,
630 p_ATTRIBUTE12 VARCHAR2,
631 p_ATTRIBUTE13 VARCHAR2,
632 p_ATTRIBUTE14 VARCHAR2,
633 p_ATTRIBUTE15 VARCHAR2,
634 p_ORIG_SYS_DISCOUNT_REF VARCHAR2 ,
635 p_CHANGE_SEQUENCE VARCHAR2,
636 -- p_LIST_HEADER_ID NUMBER,
637 -- p_LIST_LINE_ID NUMBER,
638 -- p_LIST_LINE_TYPE_CODE VARCHAR2,
639 p_UPDATE_ALLOWED VARCHAR2,
640 p_CHANGE_REASON_CODE VARCHAR2,
641 p_CHANGE_REASON_TEXT VARCHAR2,
642 p_COST_ID NUMBER,
643 p_TAX_CODE VARCHAR2,
644 p_TAX_EXEMPT_FLAG VARCHAR2,
645 p_TAX_EXEMPT_NUMBER VARCHAR2,
646 p_TAX_EXEMPT_REASON_CODE VARCHAR2,
647 p_PARENT_ADJUSTMENT_ID NUMBER,
648 p_INVOICED_FLAG VARCHAR2,
649 p_ESTIMATED_FLAG VARCHAR2,
650 p_INC_IN_SALES_PERFORMANCE VARCHAR2,
651 p_SPLIT_ACTION_CODE VARCHAR2,
652 p_ADJUSTED_AMOUNT NUMBER,
653 p_CHARGE_TYPE_CODE VARCHAR2,
654 p_CHARGE_SUBTYPE_CODE VARCHAR2,
658 p_ACCRUAL_FLAG VARCHAR2,
655 p_RANGE_BREAK_QUANTITY NUMBER,
656 p_ACCRUAL_CONVERSION_RATE NUMBER,
657 p_PRICING_GROUP_SEQUENCE NUMBER,
659 p_LIST_LINE_NO VARCHAR2,
660 p_SOURCE_SYSTEM_CODE VARCHAR2,
661 p_BENEFIT_QTY NUMBER,
662 p_BENEFIT_UOM_CODE VARCHAR2,
663 p_PRINT_ON_INVOICE_FLAG VARCHAR2,
664 p_EXPIRATION_DATE DATE,
665 p_REBATE_TRANSACTION_TYPE_CODE VARCHAR2,
666 p_REBATE_TRANSACTION_REFERENCE VARCHAR2,
667 p_REBATE_PAYMENT_SYSTEM_CODE VARCHAR2,
668 p_REDEEMED_DATE DATE,
669 p_REDEEMED_FLAG VARCHAR2,
670 p_MODIFIER_LEVEL_CODE VARCHAR2,
671 p_PRICE_BREAK_TYPE_CODE VARCHAR2,
672 p_SUBSTITUTION_ATTRIBUTE VARCHAR2,
673 p_PRORATION_TYPE_CODE VARCHAR2,
674 p_INCLUDE_ON_RETURNS_FLAG VARCHAR2,
675 p_CREDIT_OR_CHARGE_FLAG VARCHAR2,
676 p_quote_shipment_id NUMBER)
677
678 IS
679 CURSOR C IS
680 SELECT TAX_CODE,
681 --OBJECT_VERSION_NUMBER,
682 TAX_EXEMPT_FLAG,
683 TAX_EXEMPT_NUMBER,
684 TAX_EXEMPT_REASON_CODE,
685 PARENT_ADJUSTMENT_ID,
686 INVOICED_FLAG,
687 ESTIMATED_FLAG,
688 INC_IN_SALES_PERFORMANCE,
689 SPLIT_ACTION_CODE,
690 ADJUSTED_AMOUNT,
691 CHARGE_TYPE_CODE,
692 CHARGE_SUBTYPE_CODE,
693 RANGE_BREAK_QUANTITY,
694 ACCRUAL_CONVERSION_RATE,
695 PRICING_GROUP_SEQUENCE,
696 ACCRUAL_FLAG,
697 LIST_LINE_NO,
698 SOURCE_SYSTEM_CODE,
699 BENEFIT_QTY,
700 BENEFIT_UOM_CODE,
701 PRINT_ON_INVOICE_FLAG,
702 EXPIRATION_DATE,
703 REBATE_TRANSACTION_TYPE_CODE,
704 REBATE_TRANSACTION_REFERENCE,
705 REBATE_PAYMENT_SYSTEM_CODE,
706 REDEEMED_DATE,
707 REDEEMED_FLAG,
708 MODIFIER_LEVEL_CODE,
709 PRICE_BREAK_TYPE_CODE,
710 SUBSTITUTION_ATTRIBUTE,
711 PRORATION_TYPE_CODE,
712 INCLUDE_ON_RETURNS_FLAG,
713 CREDIT_OR_CHARGE_FLAG,
714 ORIG_SYS_DISCOUNT_REF,
715 MODIFIED_TO,
716 OPERAND,
717 ARITHMETIC_OPERATOR,
718 AUTOMATIC_FLAG,
719 UPDATE_ALLOWABLE_FLAG,
720 UPDATED_FLAG,
721 APPLIED_FLAG,
722 ON_INVOICE_FLAG,
723 PRICING_PHASE_ID,
724 ATTRIBUTE_CATEGORY,
725 ATTRIBUTE1,
726 ATTRIBUTE2,
727 ATTRIBUTE3,
728 ATTRIBUTE4,
729 ATTRIBUTE5,
730 ATTRIBUTE6,
731 ATTRIBUTE7,
732 ATTRIBUTE8,
733 ATTRIBUTE9,
734 ATTRIBUTE10,
735 ATTRIBUTE11,
736 ATTRIBUTE12,
737 ATTRIBUTE13,
738 ATTRIBUTE14,
739 ATTRIBUTE15,
740 CHANGE_REASON_CODE,
741 CHANGE_REASON_TEXT,
742 COST_ID,
743 PRICE_ADJUSTMENT_ID,
744 CREATION_DATE,
745 CREATED_BY,
746 LAST_UPDATE_DATE,
747 LAST_UPDATED_BY,
748 LAST_UPDATE_LOGIN,
749 PROGRAM_APPLICATION_ID,
750 PROGRAM_ID,
751 PROGRAM_UPDATE_DATE,
752 REQUEST_ID,
753 QUOTE_HEADER_ID,
754 QUOTE_LINE_ID,
755 MODIFIER_HEADER_ID,
756 MODIFIER_LINE_ID,
757 MODIFIER_LINE_TYPE_CODE,
758 MODIFIER_MECHANISM_TYPE_CODE,
759 MODIFIED_FROM,
760 LIST_LINE_TYPE_CODE,
761 UPDATE_ALLOWED,
762 CHANGE_SEQUENCE,
763 LIST_HEADER_ID,
764 LIST_LINE_ID,
765 quote_shipment_id
766 FROM ASO_PRICE_ADJUSTMENTS
767 WHERE PRICE_ADJUSTMENT_ID = p_PRICE_ADJUSTMENT_ID
768 FOR UPDATE of PRICE_ADJUSTMENT_ID NOWAIT;
769 Recinfo C%ROWTYPE;
770 BEGIN
771 OPEN C;
772 FETCH C INTO Recinfo;
773 If (C%NOTFOUND) then
774 CLOSE C;
775 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
776 APP_EXCEPTION.RAISE_EXCEPTION;
777 End If;
778 CLOSE C;
779 if (
780 /*
781 ( Recinfo.PRICE_ADJUSTMENT_ID = p_PRICE_ADJUSTMENT_ID)
782 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
783 OR ( ( Recinfo.CREATION_DATE IS NULL )
784 AND ( p_CREATION_DATE IS NULL )))
785 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
786 OR ( ( Recinfo.CREATED_BY IS NULL )
787 AND ( p_CREATED_BY IS NULL )))
788 AND
789 */
790 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
791 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
792 AND ( p_LAST_UPDATE_DATE IS NULL )))
793 /*
794 AND
795 ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
796 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
797 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
798 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
799 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
800 AND ( p_LAST_UPDATED_BY IS NULL )))
801 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
802 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
803 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
804 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
805 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
806 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
807 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
808 OR ( ( Recinfo.PROGRAM_ID IS NULL )
809 AND ( p_PROGRAM_ID IS NULL )))
810 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
811 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
815 AND ( p_REQUEST_ID IS NULL )))
812 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
813 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
814 OR ( ( Recinfo.REQUEST_ID IS NULL )
816 AND ( ( Recinfo.QUOTE_HEADER_ID = p_QUOTE_HEADER_ID)
817 OR ( ( Recinfo.QUOTE_HEADER_ID IS NULL )
818 AND ( p_QUOTE_HEADER_ID IS NULL )))
819 AND ( ( Recinfo.QUOTE_LINE_ID = p_QUOTE_LINE_ID)
820 OR ( ( Recinfo.QUOTE_LINE_ID IS NULL )
821 AND ( p_QUOTE_LINE_ID IS NULL )))
822 AND ( ( Recinfo.MODIFIER_HEADER_ID = p_MODIFIER_HEADER_ID)
823 OR ( ( Recinfo.MODIFIER_HEADER_ID IS NULL )
824 AND ( p_MODIFIER_HEADER_ID IS NULL )))
825 AND ( ( Recinfo.MODIFIER_LINE_ID = p_MODIFIER_LINE_ID)
826 OR ( ( Recinfo.MODIFIER_LINE_ID IS NULL )
827 AND ( p_MODIFIER_LINE_ID IS NULL )))
828 AND ( ( Recinfo.MODIFIER_LINE_TYPE_CODE = p_MODIFIER_LINE_TYPE_CODE)
829 OR ( ( Recinfo.MODIFIER_LINE_TYPE_CODE IS NULL )
830 AND ( p_MODIFIER_LINE_TYPE_CODE IS NULL )))
831 AND ( ( Recinfo.MODIFIER_MECHANISM_TYPE_CODE = p_MODIFIER_MECHANISM_TYPE_CODE)
832 OR ( ( Recinfo.MODIFIER_MECHANISM_TYPE_CODE IS NULL )
833 AND ( p_MODIFIER_MECHANISM_TYPE_CODE IS NULL )))
834 AND ( ( Recinfo.MODIFIED_FROM = p_MODIFIED_FROM)
835 OR ( ( Recinfo.MODIFIED_FROM IS NULL )
836 AND ( p_MODIFIED_FROM IS NULL )))
837 AND ( ( Recinfo.MODIFIED_TO = p_MODIFIED_TO)
838 OR ( ( Recinfo.MODIFIED_TO IS NULL )
839 AND ( p_MODIFIED_TO IS NULL )))
840 AND ( ( Recinfo.OPERAND = p_OPERAND)
841 OR ( ( Recinfo.OPERAND IS NULL )
842 AND ( p_OPERAND IS NULL )))
843 AND ( ( Recinfo.ARITHMETIC_OPERATOR = p_ARITHMETIC_OPERATOR)
844 OR ( ( Recinfo.ARITHMETIC_OPERATOR IS NULL )
845 AND ( p_ARITHMETIC_OPERATOR IS NULL )))
846 AND ( ( Recinfo.AUTOMATIC_FLAG = p_AUTOMATIC_FLAG)
847 OR ( ( Recinfo.AUTOMATIC_FLAG IS NULL )
848 AND ( p_AUTOMATIC_FLAG IS NULL )))
849 AND ( ( Recinfo.UPDATE_ALLOWABLE_FLAG = p_UPDATE_ALLOWABLE_FLAG)
850 OR ( ( Recinfo.UPDATE_ALLOWABLE_FLAG IS NULL )
851 AND ( p_UPDATE_ALLOWABLE_FLAG IS NULL )))
852 AND ( ( Recinfo.UPDATED_FLAG = p_UPDATED_FLAG)
853 OR ( ( Recinfo.UPDATED_FLAG IS NULL )
854 AND ( p_UPDATED_FLAG IS NULL )))
855 AND ( ( Recinfo.APPLIED_FLAG = p_APPLIED_FLAG)
856 OR ( ( Recinfo.APPLIED_FLAG IS NULL )
857 AND ( p_APPLIED_FLAG IS NULL )))
858 AND ( ( Recinfo.ON_INVOICE_FLAG = p_ON_INVOICE_FLAG)
859 OR ( ( Recinfo.ON_INVOICE_FLAG IS NULL )
860 AND ( p_ON_INVOICE_FLAG IS NULL )))
861 AND ( ( Recinfo.PRICING_PHASE_ID = p_PRICING_PHASE_ID)
862 OR ( ( Recinfo.PRICING_PHASE_ID IS NULL )
863 AND ( p_PRICING_PHASE_ID IS NULL )))
864 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
865 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
866 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
867 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
868 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
869 AND ( p_ATTRIBUTE1 IS NULL )))
870 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
871 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
872 AND ( p_ATTRIBUTE2 IS NULL )))
873 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
874 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
875 AND ( p_ATTRIBUTE3 IS NULL )))
876 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
877 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
878 AND ( p_ATTRIBUTE4 IS NULL )))
879 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
880 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
881 AND ( p_ATTRIBUTE5 IS NULL )))
882 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
883 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
884 AND ( p_ATTRIBUTE6 IS NULL )))
885 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
886 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
887 AND ( p_ATTRIBUTE7 IS NULL )))
888 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
889 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
890 AND ( p_ATTRIBUTE8 IS NULL )))
891 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
892 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
893 AND ( p_ATTRIBUTE9 IS NULL )))
894 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
895 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
896 AND ( p_ATTRIBUTE10 IS NULL )))
897 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
898 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
899 AND ( p_ATTRIBUTE11 IS NULL )))
900 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
901 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
902 AND ( p_ATTRIBUTE12 IS NULL )))
903 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
904 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
905 AND ( p_ATTRIBUTE13 IS NULL )))
906 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
907 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
908 AND ( p_ATTRIBUTE14 IS NULL )))
909 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
910 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
911 AND ( p_ATTRIBUTE15 IS NULL )))
912 AND ( ( Recinfo.ORIG_SYS_DISCOUNT_REF = p_ORIG_SYS_DISCOUNT_REF)
913 OR ( ( Recinfo.ORIG_SYS_DISCOUNT_REF IS NULL )
914 AND ( p_ORIG_SYS_DISCOUNT_REF IS NULL )))
918 AND ( ( Recinfo.UPDATE_ALLOWED = p_UPDATE_ALLOWED)
915 AND ( ( Recinfo.CHANGE_SEQUENCE = p_CHANGE_SEQUENCE)
916 OR ( ( Recinfo.CHANGE_SEQUENCE IS NULL )
917 AND ( p_CHANGE_SEQUENCE IS NULL )))
919 OR ( ( Recinfo.UPDATE_ALLOWED IS NULL )
920 AND ( p_UPDATE_ALLOWED IS NULL )))
921 AND ( ( Recinfo.CHANGE_REASON_CODE = p_CHANGE_REASON_CODE)
922 OR ( ( Recinfo.CHANGE_REASON_CODE IS NULL )
923 AND ( p_CHANGE_REASON_CODE IS NULL )))
924 AND ( ( Recinfo.COST_ID = p_COST_ID)
925 OR ( ( Recinfo.COST_ID IS NULL )
926 AND ( p_COST_ID IS NULL )))
927 AND ( ( Recinfo.TAX_CODE = p_TAX_CODE)
928 OR ( ( Recinfo.TAX_CODE IS NULL )
929 AND ( p_TAX_CODE IS NULL )))
930 AND ( ( Recinfo.TAX_EXEMPT_FLAG = p_TAX_EXEMPT_FLAG)
931 OR ( ( Recinfo.TAX_EXEMPT_FLAG IS NULL )
932 AND ( p_TAX_EXEMPT_FLAG IS NULL )))
933 AND ( ( Recinfo.TAX_EXEMPT_NUMBER = p_TAX_EXEMPT_NUMBER)
934 OR ( ( Recinfo.TAX_EXEMPT_NUMBER IS NULL )
935 AND ( p_TAX_EXEMPT_NUMBER IS NULL )))
936 AND ( ( Recinfo.TAX_EXEMPT_REASON_CODE = p_TAX_EXEMPT_REASON_CODE)
937 OR ( ( Recinfo.TAX_EXEMPT_REASON_CODE IS NULL )
938 AND ( p_TAX_EXEMPT_REASON_CODE IS NULL )))
939 AND ( ( Recinfo.PARENT_ADJUSTMENT_ID = p_PARENT_ADJUSTMENT_ID)
940 OR ( ( Recinfo.PARENT_ADJUSTMENT_ID IS NULL )
941 AND ( p_PARENT_ADJUSTMENT_ID IS NULL )))
942 AND ( ( Recinfo.INVOICED_FLAG = p_INVOICED_FLAG)
943 OR ( ( Recinfo.INVOICED_FLAG IS NULL )
944 AND ( p_INVOICED_FLAG IS NULL )))
945 AND ( ( Recinfo.ESTIMATED_FLAG = p_ESTIMATED_FLAG)
946 OR ( ( Recinfo.ESTIMATED_FLAG IS NULL )
947 AND ( p_ESTIMATED_FLAG IS NULL )))
948 AND ( ( Recinfo.INC_IN_SALES_PERFORMANCE = p_INC_IN_SALES_PERFORMANCE)
949 OR ( ( Recinfo.INC_IN_SALES_PERFORMANCE IS NULL )
950 AND ( p_INC_IN_SALES_PERFORMANCE IS NULL )))
951 AND ( ( Recinfo.SPLIT_ACTION_CODE = p_SPLIT_ACTION_CODE)
952 OR ( ( Recinfo.SPLIT_ACTION_CODE IS NULL )
953 AND ( p_SPLIT_ACTION_CODE IS NULL )))
954 AND ( ( Recinfo.ADJUSTED_AMOUNT = p_ADJUSTED_AMOUNT)
955 OR ( ( Recinfo.ADJUSTED_AMOUNT IS NULL )
956 AND ( p_ADJUSTED_AMOUNT IS NULL )))
957 AND ( ( Recinfo.CHARGE_TYPE_CODE = p_CHARGE_TYPE_CODE)
958 OR ( ( Recinfo.CHARGE_TYPE_CODE IS NULL )
959 AND ( p_CHARGE_TYPE_CODE IS NULL )))
960 AND ( ( Recinfo.CHARGE_SUBTYPE_CODE = p_CHARGE_SUBTYPE_CODE)
961 OR ( ( Recinfo.CHARGE_SUBTYPE_CODE IS NULL )
962 AND ( p_CHARGE_SUBTYPE_CODE IS NULL )))
963 AND ( ( Recinfo.RANGE_BREAK_QUANTITY = p_RANGE_BREAK_QUANTITY)
964 OR ( ( Recinfo.RANGE_BREAK_QUANTITY IS NULL )
965 AND ( p_RANGE_BREAK_QUANTITY IS NULL )))
966 AND ( ( Recinfo.ACCRUAL_CONVERSION_RATE = p_ACCRUAL_CONVERSION_RATE)
967 OR ( ( Recinfo.ACCRUAL_CONVERSION_RATE IS NULL )
968 AND ( p_ACCRUAL_CONVERSION_RATE IS NULL )))
969 AND ( ( Recinfo.PRICING_GROUP_SEQUENCE = p_PRICING_GROUP_SEQUENCE)
970 OR ( ( Recinfo.PRICING_GROUP_SEQUENCE IS NULL )
971 AND ( p_PRICING_GROUP_SEQUENCE IS NULL )))
972 AND ( ( Recinfo.ACCRUAL_FLAG = p_ACCRUAL_FLAG)
973 OR ( ( Recinfo.ACCRUAL_FLAG IS NULL )
974 AND ( p_ACCRUAL_FLAG IS NULL )))
975 AND ( ( Recinfo.LIST_LINE_NO = p_LIST_LINE_NO)
976 OR ( ( Recinfo.LIST_LINE_NO IS NULL )
977 AND ( p_LIST_LINE_NO IS NULL )))
978 AND ( ( Recinfo.SOURCE_SYSTEM_CODE = p_SOURCE_SYSTEM_CODE)
979 OR ( ( Recinfo.SOURCE_SYSTEM_CODE IS NULL )
980 AND ( p_SOURCE_SYSTEM_CODE IS NULL )))
981 AND ( ( Recinfo.BENEFIT_QTY = p_BENEFIT_QTY)
982 OR ( ( Recinfo.BENEFIT_QTY IS NULL )
983 AND ( p_BENEFIT_QTY IS NULL )))
984 AND ( ( Recinfo.BENEFIT_UOM_CODE = p_BENEFIT_UOM_CODE)
985 OR ( ( Recinfo.BENEFIT_UOM_CODE IS NULL )
986 AND ( p_BENEFIT_UOM_CODE IS NULL )))
987 AND ( ( Recinfo.PRINT_ON_INVOICE_FLAG = p_PRINT_ON_INVOICE_FLAG)
988 OR ( ( Recinfo.PRINT_ON_INVOICE_FLAG IS NULL )
989 AND ( p_PRINT_ON_INVOICE_FLAG IS NULL )))
990 AND ( ( Recinfo.EXPIRATION_DATE = p_EXPIRATION_DATE)
991 OR ( ( Recinfo.EXPIRATION_DATE IS NULL )
992 AND ( p_EXPIRATION_DATE IS NULL )))
993 AND ( ( Recinfo.REBATE_TRANSACTION_TYPE_CODE = p_REBATE_TRANSACTION_TYPE_CODE)
994 OR ( ( Recinfo.REBATE_TRANSACTION_TYPE_CODE IS NULL )
995 AND ( p_REBATE_TRANSACTION_TYPE_CODE IS NULL )))
996 AND ( ( Recinfo.REBATE_TRANSACTION_REFERENCE = p_REBATE_TRANSACTION_REFERENCE)
997 OR ( ( Recinfo.REBATE_TRANSACTION_REFERENCE IS NULL )
998 AND ( p_REBATE_TRANSACTION_REFERENCE IS NULL )))
999 AND ( ( Recinfo.REBATE_PAYMENT_SYSTEM_CODE = p_REBATE_PAYMENT_SYSTEM_CODE)
1000 OR ( ( Recinfo.REBATE_PAYMENT_SYSTEM_CODE IS NULL )
1001 AND ( p_REBATE_PAYMENT_SYSTEM_CODE IS NULL )))
1002 AND ( ( Recinfo.REDEEMED_DATE = p_REDEEMED_DATE)
1003 OR ( ( Recinfo.REDEEMED_DATE IS NULL )
1004 AND ( p_REDEEMED_DATE IS NULL )))
1005 AND ( ( Recinfo.REDEEMED_FLAG = p_REDEEMED_FLAG)
1006 OR ( ( Recinfo.REDEEMED_FLAG IS NULL )
1007 AND ( p_REDEEMED_FLAG IS NULL )))
1008 AND ( ( Recinfo.MODIFIER_LEVEL_CODE = p_MODIFIER_LEVEL_CODE)
1009 OR ( ( Recinfo.MODIFIER_LEVEL_CODE IS NULL )
1010 AND ( p_MODIFIER_LEVEL_CODE IS NULL )))
1014 AND ( ( Recinfo.SUBSTITUTION_ATTRIBUTE = p_SUBSTITUTION_ATTRIBUTE)
1011 AND ( ( Recinfo.PRICE_BREAK_TYPE_CODE = p_PRICE_BREAK_TYPE_CODE)
1012 OR ( ( Recinfo.PRICE_BREAK_TYPE_CODE IS NULL )
1013 AND ( p_PRICE_BREAK_TYPE_CODE IS NULL )))
1015 OR ( ( Recinfo.SUBSTITUTION_ATTRIBUTE IS NULL )
1016 AND ( p_SUBSTITUTION_ATTRIBUTE IS NULL )))
1017 AND ( ( Recinfo.PRORATION_TYPE_CODE = p_PRORATION_TYPE_CODE)
1018 OR ( ( Recinfo.PRORATION_TYPE_CODE IS NULL )
1019 AND ( p_PRORATION_TYPE_CODE IS NULL )))
1020 AND ( ( Recinfo.INCLUDE_ON_RETURNS_FLAG = p_INCLUDE_ON_RETURNS_FLAG)
1021 OR ( ( Recinfo.INCLUDE_ON_RETURNS_FLAG IS NULL )
1022 AND ( p_INCLUDE_ON_RETURNS_FLAG IS NULL )))
1023 AND ( ( Recinfo.CREDIT_OR_CHARGE_FLAG = p_CREDIT_OR_CHARGE_FLAG)
1024 OR ( ( Recinfo.CREDIT_OR_CHARGE_FLAG IS NULL )
1025 AND ( p_CREDIT_OR_CHARGE_FLAG IS NULL )))
1026 AND ( ( Recinfo.quote_shipment_id = p_quote_shipment_id)
1027 OR ( ( Recinfo.quote_shipment_id IS NULL )
1028 AND ( p_quote_shipment_id IS NULL )))
1029 */
1030 ) then
1031 return;
1032 else
1033 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1034 APP_EXCEPTION.RAISE_EXCEPTION;
1035 End If;
1036 END Lock_Row;
1037
1038 End ASO_PRICE_ADJUSTMENTS_PKG;