[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_LINES_PKG
Source
1 PACKAGE BODY ASO_QUOTE_LINES_PKG as
2 /* $Header: asotqlnb.pls 120.2.12020000.2 2012/11/19 11:00:33 rassharm ship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_LINES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_LINES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotqlnb.pls';
13
14
15 PROCEDURE Insert_Row(
16 px_QUOTE_LINE_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_REQUEST_ID NUMBER,
23 p_PROGRAM_APPLICATION_ID NUMBER,
24 p_PROGRAM_ID NUMBER,
25 p_PROGRAM_UPDATE_DATE DATE,
26 p_QUOTE_HEADER_ID NUMBER,
27 p_ORG_ID NUMBER,
28 p_LINE_CATEGORY_CODE VARCHAR2,
29 p_ITEM_TYPE_CODE VARCHAR2,
30 p_LINE_NUMBER NUMBER,
31 p_START_DATE_ACTIVE DATE,
32 p_END_DATE_ACTIVE DATE,
33 p_ORDER_LINE_TYPE_ID NUMBER,
34 p_INVOICE_TO_PARTY_SITE_ID NUMBER,
35 p_INVOICE_TO_PARTY_ID NUMBER,
36 p_INVOICE_TO_CUST_ACCOUNT_ID NUMBER,
37 p_ORGANIZATION_ID NUMBER,
38 p_INVENTORY_ITEM_ID NUMBER,
39 p_QUANTITY NUMBER,
40 p_UOM_CODE VARCHAR2,
41 p_MARKETING_SOURCE_CODE_ID NUMBER,
42 p_PRICE_LIST_ID NUMBER,
43 p_PRICE_LIST_LINE_ID NUMBER,
44 p_CURRENCY_CODE VARCHAR2,
45 p_LINE_LIST_PRICE NUMBER,
46 p_LINE_ADJUSTED_AMOUNT NUMBER,
47 p_LINE_ADJUSTED_PERCENT NUMBER,
48 p_LINE_QUOTE_PRICE NUMBER,
49 p_RELATED_ITEM_ID NUMBER,
50 p_ITEM_RELATIONSHIP_TYPE VARCHAR2,
51 p_ACCOUNTING_RULE_ID NUMBER,
52 p_INVOICING_RULE_ID NUMBER,
53 p_SPLIT_SHIPMENT_FLAG VARCHAR2,
54 p_BACKORDER_FLAG VARCHAR2,
55 p_MINISITE_ID NUMBER,
56 p_SECTION_ID NUMBER,
57 p_ATTRIBUTE_CATEGORY VARCHAR2,
58 p_ATTRIBUTE1 VARCHAR2,
59 p_ATTRIBUTE2 VARCHAR2,
60 p_ATTRIBUTE3 VARCHAR2,
61 p_ATTRIBUTE4 VARCHAR2,
62 p_ATTRIBUTE5 VARCHAR2,
63 p_ATTRIBUTE6 VARCHAR2,
64 p_ATTRIBUTE7 VARCHAR2,
65 p_ATTRIBUTE8 VARCHAR2,
66 p_ATTRIBUTE9 VARCHAR2,
67 p_ATTRIBUTE10 VARCHAR2,
68 p_ATTRIBUTE11 VARCHAR2,
69 p_ATTRIBUTE12 VARCHAR2,
70 p_ATTRIBUTE13 VARCHAR2,
71 p_ATTRIBUTE14 VARCHAR2,
72 p_ATTRIBUTE15 VARCHAR2,
73 p_ATTRIBUTE16 VARCHAR2,
74 p_ATTRIBUTE17 VARCHAR2,
75 p_ATTRIBUTE18 VARCHAR2,
76 p_ATTRIBUTE19 VARCHAR2,
77 p_ATTRIBUTE20 VARCHAR2,
78 p_PRICED_PRICE_LIST_ID NUMBER,
79 p_AGREEMENT_ID NUMBER,
80 p_COMMITMENT_ID NUMBER,
81 p_DISPLAY_ARITHMETIC_OPERATOR VARCHAR2,
82 p_LINE_TYPE_SOURCE_FLAG VARCHAR2,
83 p_SERVICE_ITEM_FLAG VARCHAR2,
84 p_SERVICEABLE_PRODUCT_FLAG VARCHAR2,
85 p_INVOICE_TO_CUST_PARTY_ID NUMBER,
86 p_selling_price_change VARCHAR2,
87 p_recalculate_flag VARCHAR2,
88 p_pricing_line_type_indicator VARCHAR2,
89 p_END_CUSTOMER_PARTY_ID NUMBER,
90 p_END_CUSTOMER_CUST_PARTY_ID NUMBER,
91 p_END_CUSTOMER_PARTY_SITE_ID NUMBER,
92 p_END_CUSTOMER_CUST_ACCOUNT_ID NUMBER,
93 p_OBJECT_VERSION_NUMBER NUMBER,
94 p_CHARGE_PERIODICITY_CODE VARCHAR2, -- Recurring charges Change
95 p_SHIP_MODEL_COMPLETE_FLAG VARCHAR2,
96 p_LINE_PAYNOW_CHARGES NUMBER,
97 p_LINE_PAYNOW_TAX NUMBER,
98 p_LINE_PAYNOW_SUBTOTAL NUMBER,
99 p_PRICING_QUANTITY_UOM VARCHAR2,
100 p_PRICING_QUANTITY NUMBER,
101 p_CONFIG_MODEL_TYPE VARCHAR2
102 )
103
104 IS
105 CURSOR C2 IS SELECT ASO_QUOTE_LINES_S.nextval FROM sys.dual;
106
107
108 BEGIN
109 If (px_QUOTE_LINE_ID IS NULL) OR (px_QUOTE_LINE_ID = FND_API.G_MISS_NUM) then
110
111
112 OPEN C2;
113 FETCH C2 INTO px_QUOTE_LINE_ID;
114 CLOSE C2;
115
116 End If;
117 INSERT INTO ASO_QUOTE_LINES_ALL(
118 QUOTE_LINE_ID,
119 CREATION_DATE,
120 CREATED_BY,
121 LAST_UPDATE_DATE,
122 LAST_UPDATED_BY,
123 LAST_UPDATE_LOGIN,
124 REQUEST_ID,
125 PROGRAM_APPLICATION_ID,
126 PROGRAM_ID,
127 PROGRAM_UPDATE_DATE,
128 QUOTE_HEADER_ID,
129 ORG_ID,
130 LINE_CATEGORY_CODE,
131 ITEM_TYPE_CODE,
132 LINE_NUMBER,
133 START_DATE_ACTIVE,
134 END_DATE_ACTIVE,
135 ORDER_LINE_TYPE_ID,
136 INVOICE_TO_PARTY_SITE_ID,
137 INVOICE_TO_PARTY_ID,
138 INVOICE_TO_CUST_ACCOUNT_ID,
139 ORGANIZATION_ID,
140 INVENTORY_ITEM_ID,
141 QUANTITY,
142 UOM_CODE,
143 MARKETING_SOURCE_CODE_ID,
144 PRICE_LIST_ID,
145 PRICE_LIST_LINE_ID,
146 CURRENCY_CODE,
147 LINE_LIST_PRICE,
148 LINE_ADJUSTED_AMOUNT,
149 LINE_ADJUSTED_PERCENT,
150 LINE_QUOTE_PRICE,
151 RELATED_ITEM_ID,
152 ITEM_RELATIONSHIP_TYPE,
153 ACCOUNTING_RULE_ID,
154 INVOICING_RULE_ID,
155 SPLIT_SHIPMENT_FLAG,
156 BACKORDER_FLAG,
157 MINISITE_ID,
158 SECTION_ID,
159 ATTRIBUTE_CATEGORY,
160 ATTRIBUTE1,
161 ATTRIBUTE2,
162 ATTRIBUTE3,
163 ATTRIBUTE4,
164 ATTRIBUTE5,
165 ATTRIBUTE6,
166 ATTRIBUTE7,
167 ATTRIBUTE8,
168 ATTRIBUTE9,
169 ATTRIBUTE10,
170 ATTRIBUTE11,
171 ATTRIBUTE12,
172 ATTRIBUTE13,
173 ATTRIBUTE14,
174 ATTRIBUTE15,
175 ATTRIBUTE16,
176 ATTRIBUTE17,
177 ATTRIBUTE18,
178 ATTRIBUTE19,
179 ATTRIBUTE20,
180 PRICED_PRICE_LIST_ID,
181 AGREEMENT_ID,
182 COMMITMENT_ID,
183 DISPLAY_ARITHMETIC_OPERATOR,
184 LINE_TYPE_SOURCE_FLAG,
185 SERVICE_ITEM_FLAG,
186 SERVICEABLE_PRODUCT_FLAG,
187 INVOICE_TO_CUST_PARTY_ID,
188 selling_price_change,
189 recalculate_flag,
190 pricing_line_type_indicator,
191 END_CUSTOMER_PARTY_ID,
192 END_CUSTOMER_CUST_PARTY_ID,
193 END_CUSTOMER_PARTY_SITE_ID,
194 END_CUSTOMER_CUST_ACCOUNT_ID,
195 OBJECT_VERSION_NUMBER,
196 CHARGE_PERIODICITY_CODE, -- Recurring charges Change
197 SHIP_MODEL_COMPLETE_FLAG,
198 LINE_PAYNOW_CHARGES,
199 LINE_PAYNOW_TAX,
200 LINE_PAYNOW_SUBTOTAL,
201 PRICING_QUANTITY_UOM,
202 PRICING_QUANTITY,
203 CONFIG_MODEL_TYPE
204 ) VALUES (
205 px_QUOTE_LINE_ID,
206 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
207 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
208 ASO_UTILITY_PVT.decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
209 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY), decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
210 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
211 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
212 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
213 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
214 decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
215 decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
216 decode( p_LINE_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_LINE_CATEGORY_CODE),
217 decode( p_ITEM_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_ITEM_TYPE_CODE),
218 decode( p_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, p_LINE_NUMBER),
219 ASO_UTILITY_PVT.decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
220 ASO_UTILITY_PVT.decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
221 decode( p_ORDER_LINE_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_LINE_TYPE_ID),
222 decode( p_INVOICE_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_PARTY_SITE_ID),
223 decode( p_INVOICE_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_PARTY_ID),
224 decode( p_INVOICE_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_CUST_ACCOUNT_ID),
225 decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID),
226 decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID),
227 decode( p_QUANTITY, FND_API.G_MISS_NUM, NULL, p_QUANTITY),
228 decode( p_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_UOM_CODE),
229 decode( p_MARKETING_SOURCE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_MARKETING_SOURCE_CODE_ID),
230 decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
231 decode( p_PRICE_LIST_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_LINE_ID),
232 decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
233 decode( p_LINE_LIST_PRICE, FND_API.G_MISS_NUM, NULL, p_LINE_LIST_PRICE),
234 decode( p_LINE_ADJUSTED_AMOUNT, FND_API.G_MISS_NUM, NULL, p_LINE_ADJUSTED_AMOUNT),
235 decode( p_LINE_ADJUSTED_PERCENT, FND_API.G_MISS_NUM, NULL, p_LINE_ADJUSTED_PERCENT),
236 decode( p_LINE_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_LINE_QUOTE_PRICE),
237 decode( p_RELATED_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_RELATED_ITEM_ID),
238 decode( p_ITEM_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, NULL, p_ITEM_RELATIONSHIP_TYPE),
239 decode( p_ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM, NULL, p_ACCOUNTING_RULE_ID),
240 decode( p_INVOICING_RULE_ID, FND_API.G_MISS_NUM, NULL, p_INVOICING_RULE_ID),
241 decode( p_SPLIT_SHIPMENT_FLAG, FND_API.G_MISS_CHAR, NULL, p_SPLIT_SHIPMENT_FLAG),
242 decode( p_BACKORDER_FLAG, FND_API.G_MISS_CHAR, NULL, p_BACKORDER_FLAG),
243 decode( p_MINISITE_ID, FND_API.G_MISS_NUM, NULL, p_MINISITE_ID),
244 decode( p_SECTION_ID, FND_API.G_MISS_NUM, NULL, p_SECTION_ID),
245 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
246 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
247 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
248 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
249 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
250 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
251 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
252 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
253 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
254 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
255 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
256 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
257 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
258 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
259 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
260 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
261 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
262 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
263 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
264 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
265 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
266 decode( p_PRICED_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICED_PRICE_LIST_ID),
267 decode( p_AGREEMENT_ID, FND_API.G_MISS_NUM, NULL, p_AGREEMENT_ID),
268 decode( p_COMMITMENT_ID, FND_API.G_MISS_NUM, NULL, p_COMMITMENT_ID),
269 decode( p_DISPLAY_ARITHMETIC_OPERATOR,FND_API.G_MISS_CHAR, NULL,p_DISPLAY_ARITHMETIC_OPERATOR),
270 decode( p_LINE_TYPE_SOURCE_FLAG,FND_API.G_MISS_CHAR, NULL,p_LINE_TYPE_SOURCE_FLAG),
271 decode( p_SERVICE_ITEM_FLAG,FND_API.G_MISS_CHAR, NULL,p_SERVICE_ITEM_FLAG),
272 decode( p_SERVICEABLE_PRODUCT_FLAG,FND_API.G_MISS_CHAR, NULL,p_SERVICEABLE_PRODUCT_FLAG),
273 decode( p_INVOICE_TO_CUST_PARTY_ID,FND_API.G_MISS_NUM, NULL,p_INVOICE_TO_CUST_PARTY_ID),
274 decode( p_selling_price_change,FND_API.G_MISS_CHAR, 'N',p_selling_price_change),
275 decode( p_recalculate_flag,FND_API.G_MISS_CHAR, 'N',p_recalculate_flag),
276 decode( p_pricing_line_type_indicator, fnd_api.g_miss_char, null, p_pricing_line_type_indicator),
277 decode( p_END_CUSTOMER_PARTY_ID,FND_API.G_MISS_NUM, NULL,p_END_CUSTOMER_PARTY_ID),
278 decode( p_END_CUSTOMER_CUST_PARTY_ID,FND_API.G_MISS_NUM, NULL,p_END_CUSTOMER_CUST_PARTY_ID),
279 decode( p_END_CUSTOMER_PARTY_SITE_ID,FND_API.G_MISS_NUM, NULL,p_END_CUSTOMER_PARTY_SITE_ID),
280 decode( p_END_CUSTOMER_CUST_ACCOUNT_ID,FND_API.G_MISS_NUM, NULL,p_END_CUSTOMER_CUST_ACCOUNT_ID),
284 decode ( p_LINE_PAYNOW_CHARGES,FND_API.G_MISS_NUM,NULL,p_LINE_PAYNOW_CHARGES),
281 decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
282 decode ( p_CHARGE_PERIODICITY_CODE,FND_API.G_MISS_CHAR,NULL,p_CHARGE_PERIODICITY_CODE), -- Recurring charges Change
283 decode ( p_SHIP_MODEL_COMPLETE_FLAG,FND_API.G_MISS_CHAR,NULL,p_SHIP_MODEL_COMPLETE_FLAG),
285 decode ( p_LINE_PAYNOW_TAX,FND_API.G_MISS_NUM,NULL,p_LINE_PAYNOW_TAX),
286 decode ( p_LINE_PAYNOW_SUBTOTAL,FND_API.G_MISS_NUM,NULL,p_LINE_PAYNOW_SUBTOTAL),
287 decode( p_pricing_quantity_uom, fnd_api.g_miss_char, null, p_pricing_quantity_uom),
288 decode (p_pricing_quantity,FND_API.G_MISS_NUM,NULL,p_pricing_quantity),
289 decode( p_CONFIG_MODEL_TYPE, fnd_api.g_miss_char, null, p_CONFIG_MODEL_TYPE)
290 );
291 End Insert_Row;
292
293 PROCEDURE Update_Row(
294 p_QUOTE_LINE_ID NUMBER,
295 p_CREATION_DATE DATE,
296 p_CREATED_BY NUMBER,
297 p_LAST_UPDATE_DATE DATE,
298 p_LAST_UPDATED_BY NUMBER,
299 p_LAST_UPDATE_LOGIN NUMBER,
300 p_REQUEST_ID NUMBER,
301 p_PROGRAM_APPLICATION_ID NUMBER,
302 p_PROGRAM_ID NUMBER,
303 p_PROGRAM_UPDATE_DATE DATE,
304 p_QUOTE_HEADER_ID NUMBER,
305 p_ORG_ID NUMBER,
306 p_LINE_CATEGORY_CODE VARCHAR2,
307 p_ITEM_TYPE_CODE VARCHAR2,
308 p_LINE_NUMBER NUMBER,
309 p_START_DATE_ACTIVE DATE,
310 p_END_DATE_ACTIVE DATE,
311 p_ORDER_LINE_TYPE_ID NUMBER,
312 p_INVOICE_TO_PARTY_SITE_ID NUMBER,
313 p_INVOICE_TO_PARTY_ID NUMBER,
314 p_INVOICE_TO_CUST_ACCOUNT_ID NUMBER,
315 p_ORGANIZATION_ID NUMBER,
316 p_INVENTORY_ITEM_ID NUMBER,
317 p_QUANTITY NUMBER,
318 p_UOM_CODE VARCHAR2,
319 p_MARKETING_SOURCE_CODE_ID NUMBER,
320 p_PRICE_LIST_ID NUMBER,
321 p_PRICE_LIST_LINE_ID NUMBER,
322 p_CURRENCY_CODE VARCHAR2,
323 p_LINE_LIST_PRICE NUMBER,
324 p_LINE_ADJUSTED_AMOUNT NUMBER,
325 p_LINE_ADJUSTED_PERCENT NUMBER,
326 p_LINE_QUOTE_PRICE NUMBER,
327 p_RELATED_ITEM_ID NUMBER,
328 p_ITEM_RELATIONSHIP_TYPE VARCHAR2,
329 p_ACCOUNTING_RULE_ID NUMBER,
330 p_INVOICING_RULE_ID NUMBER,
331 p_SPLIT_SHIPMENT_FLAG VARCHAR2,
332 p_BACKORDER_FLAG VARCHAR2,
333 p_MINISITE_ID NUMBER,
334 p_SECTION_ID NUMBER,
335 p_ATTRIBUTE_CATEGORY VARCHAR2,
336 p_ATTRIBUTE1 VARCHAR2,
337 p_ATTRIBUTE2 VARCHAR2,
338 p_ATTRIBUTE3 VARCHAR2,
339 p_ATTRIBUTE4 VARCHAR2,
340 p_ATTRIBUTE5 VARCHAR2,
341 p_ATTRIBUTE6 VARCHAR2,
342 p_ATTRIBUTE7 VARCHAR2,
343 p_ATTRIBUTE8 VARCHAR2,
344 p_ATTRIBUTE9 VARCHAR2,
345 p_ATTRIBUTE10 VARCHAR2,
346 p_ATTRIBUTE11 VARCHAR2,
347 p_ATTRIBUTE12 VARCHAR2,
348 p_ATTRIBUTE13 VARCHAR2,
349 p_ATTRIBUTE14 VARCHAR2,
350 p_ATTRIBUTE15 VARCHAR2,
351 p_ATTRIBUTE16 VARCHAR2,
352 p_ATTRIBUTE17 VARCHAR2,
353 p_ATTRIBUTE18 VARCHAR2,
354 p_ATTRIBUTE19 VARCHAR2,
355 p_ATTRIBUTE20 VARCHAR2,
356 p_PRICED_PRICE_LIST_ID NUMBER,
357 p_AGREEMENT_ID NUMBER,
358 p_COMMITMENT_ID NUMBER,
359 p_DISPLAY_ARITHMETIC_OPERATOR VARCHAR2,
360 p_LINE_TYPE_SOURCE_FLAG VARCHAR2,
361 p_SERVICE_ITEM_FLAG VARCHAR2,
362 p_SERVICEABLE_PRODUCT_FLAG VARCHAR2,
363 p_INVOICE_TO_CUST_PARTY_ID NUMBER,
364 p_selling_price_change VARCHAR2,
365 p_recalculate_flag VARCHAR2,
366 p_pricing_line_type_indicator VARCHAR2,
367 p_END_CUSTOMER_PARTY_ID NUMBER,
368 p_END_CUSTOMER_CUST_PARTY_ID NUMBER,
369 p_END_CUSTOMER_PARTY_SITE_ID NUMBER,
370 p_END_CUSTOMER_CUST_ACCOUNT_ID NUMBER,
371 p_OBJECT_VERSION_NUMBER NUMBER,
372 p_CHARGE_PERIODICITY_CODE VARCHAR2,
373 p_SHIP_MODEL_COMPLETE_FLAG VARCHAR2,
374 p_LINE_PAYNOW_CHARGES NUMBER,
375 p_LINE_PAYNOW_TAX NUMBER,
376 p_LINE_PAYNOW_SUBTOTAL NUMBER,
377 p_PRICING_QUANTITY_UOM VARCHAR2,
378 p_PRICING_QUANTITY NUMBER,
379 p_CONFIG_MODEL_TYPE VARCHAR2
380 )
381
382 IS
383 BEGIN
384 Update ASO_QUOTE_LINES_ALL
385 SET
386 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
387 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,p_CREATED_BY),*/
388 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
389 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
390 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
391 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
392 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
393 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
394 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
395 QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
399 LINE_NUMBER = decode( p_LINE_NUMBER, FND_API.G_MISS_NUM, LINE_NUMBER, p_LINE_NUMBER),
396 ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
397 LINE_CATEGORY_CODE = decode( p_LINE_CATEGORY_CODE, FND_API.G_MISS_CHAR, LINE_CATEGORY_CODE, p_LINE_CATEGORY_CODE),
398 ITEM_TYPE_CODE = decode( p_ITEM_TYPE_CODE, FND_API.G_MISS_CHAR, ITEM_TYPE_CODE, p_ITEM_TYPE_CODE),
400 START_DATE_ACTIVE = ASO_UTILITY_PVT.decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
401 END_DATE_ACTIVE = ASO_UTILITY_PVT.decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
402 ORDER_LINE_TYPE_ID = decode( p_ORDER_LINE_TYPE_ID, FND_API.G_MISS_NUM, ORDER_LINE_TYPE_ID, p_ORDER_LINE_TYPE_ID),
403 INVOICE_TO_PARTY_SITE_ID = decode( p_INVOICE_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, INVOICE_TO_PARTY_SITE_ID, p_INVOICE_TO_PARTY_SITE_ID),
404 INVOICE_TO_PARTY_ID = decode( p_INVOICE_TO_PARTY_ID, FND_API.G_MISS_NUM, INVOICE_TO_PARTY_ID, p_INVOICE_TO_PARTY_ID),
405 INVOICE_TO_CUST_ACCOUNT_ID = decode( p_INVOICE_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, INVOICE_TO_CUST_ACCOUNT_ID, p_INVOICE_TO_CUST_ACCOUNT_ID),
406 ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID),
407 INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
408 QUANTITY = decode( p_QUANTITY, FND_API.G_MISS_NUM, QUANTITY, p_QUANTITY),
409 UOM_CODE = decode( p_UOM_CODE, FND_API.G_MISS_CHAR, UOM_CODE, p_UOM_CODE),
410 MARKETING_SOURCE_CODE_ID = decode( p_MARKETING_SOURCE_CODE_ID, FND_API.G_MISS_NUM, MARKETING_SOURCE_CODE_ID, p_MARKETING_SOURCE_CODE_ID),
411 PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
412 PRICE_LIST_LINE_ID = decode( p_PRICE_LIST_LINE_ID, FND_API.G_MISS_NUM, PRICE_LIST_LINE_ID, p_PRICE_LIST_LINE_ID),
413 CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
414 LINE_LIST_PRICE = decode( p_LINE_LIST_PRICE, FND_API.G_MISS_NUM, LINE_LIST_PRICE, p_LINE_LIST_PRICE),
415 LINE_ADJUSTED_AMOUNT = decode( p_LINE_ADJUSTED_AMOUNT, FND_API.G_MISS_NUM, LINE_ADJUSTED_AMOUNT, p_LINE_ADJUSTED_AMOUNT),
416 LINE_ADJUSTED_PERCENT = decode( p_LINE_ADJUSTED_PERCENT, FND_API.G_MISS_NUM, LINE_ADJUSTED_PERCENT, p_LINE_ADJUSTED_PERCENT),
417 LINE_QUOTE_PRICE = decode( p_LINE_QUOTE_PRICE, FND_API.G_MISS_NUM, LINE_QUOTE_PRICE, p_LINE_QUOTE_PRICE),
418 RELATED_ITEM_ID = decode( p_RELATED_ITEM_ID, FND_API.G_MISS_NUM, RELATED_ITEM_ID, p_RELATED_ITEM_ID),
419 ITEM_RELATIONSHIP_TYPE = decode( p_ITEM_RELATIONSHIP_TYPE, FND_API.G_MISS_CHAR, ITEM_RELATIONSHIP_TYPE, p_ITEM_RELATIONSHIP_TYPE),
420 ACCOUNTING_RULE_ID = decode( p_ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM, ACCOUNTING_RULE_ID, p_ACCOUNTING_RULE_ID),
421 INVOICING_RULE_ID = decode( p_INVOICING_RULE_ID, FND_API.G_MISS_NUM, INVOICING_RULE_ID, p_INVOICING_RULE_ID),
422 SPLIT_SHIPMENT_FLAG = decode( p_SPLIT_SHIPMENT_FLAG, FND_API.G_MISS_CHAR, SPLIT_SHIPMENT_FLAG, p_SPLIT_SHIPMENT_FLAG),
423 BACKORDER_FLAG = decode( p_BACKORDER_FLAG, FND_API.G_MISS_CHAR, BACKORDER_FLAG, p_BACKORDER_FLAG),
424 MINISITE_ID = decode( p_MINISITE_ID, FND_API.G_MISS_NUM, MINISITE_ID, p_MINISITE_ID),
425 SECTION_ID = decode( p_SECTION_ID, FND_API.G_MISS_NUM, SECTION_ID, p_SECTION_ID),
426 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
427 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
428 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
429 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
430 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
431 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
432 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
433 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
434 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
435 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
436 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
437 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
438 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
439 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
440 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
441 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
442 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
443 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
444 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
445 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
446 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
447 PRICED_PRICE_LIST_ID = decode( p_PRICED_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICED_PRICE_LIST_ID, p_PRICED_PRICE_LIST_ID),
448 AGREEMENT_ID = decode( p_AGREEMENT_ID, FND_API.G_MISS_NUM, AGREEMENT_ID, p_AGREEMENT_ID),
449 COMMITMENT_ID = decode( p_COMMITMENT_ID, FND_API.G_MISS_NUM, COMMITMENT_ID, p_COMMITMENT_ID),
450 DISPLAY_ARITHMETIC_OPERATOR = decode( p_DISPLAY_ARITHMETIC_OPERATOR, FND_API.G_MISS_char, DISPLAY_ARITHMETIC_OPERATOR, p_DISPLAY_ARITHMETIC_OPERATOR),
451 LINE_TYPE_SOURCE_FLAG = decode( p_LINE_TYPE_SOURCE_FLAG, FND_API.G_MISS_CHAR, LINE_TYPE_SOURCE_FLAG, p_LINE_TYPE_SOURCE_FLAG),
455 SELLING_PRICE_CHANGE = decode(p_SELLING_PRICE_CHANGE,FND_API.G_MISS_CHAR,SELLING_PRICE_CHANGE,p_SELLING_PRICE_CHANGE),
452 SERVICE_ITEM_FLAG = decode( p_SERVICE_ITEM_FLAG, FND_API.G_MISS_CHAR, SERVICE_ITEM_FLAG, p_SERVICE_ITEM_FLAG),
453 SERVICEABLE_PRODUCT_FLAG = decode( p_SERVICEABLE_PRODUCT_FLAG, FND_API.G_MISS_CHAR, SERVICEABLE_PRODUCT_FLAG, p_SERVICEABLE_PRODUCT_FLAG),
454 INVOICE_TO_CUST_PARTY_ID = decode( p_INVOICE_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, INVOICE_TO_CUST_PARTY_ID, p_INVOICE_TO_CUST_PARTY_ID),
456 RECALCULATE_FLAG = decode(p_RECALCULATE_FLAG,FND_API.G_MISS_CHAR,RECALCULATE_FLAG,p_RECALCULATE_FLAG),
457 pricing_line_type_indicator = decode(p_pricing_line_type_indicator,fnd_api.g_miss_char,pricing_line_type_indicator,p_pricing_line_type_indicator),
458 END_CUSTOMER_PARTY_ID = decode( p_END_CUSTOMER_PARTY_ID, FND_API.G_MISS_NUM, END_CUSTOMER_PARTY_ID, p_END_CUSTOMER_PARTY_ID),
459 END_CUSTOMER_CUST_PARTY_ID = decode( p_END_CUSTOMER_CUST_PARTY_ID, FND_API.G_MISS_NUM, END_CUSTOMER_CUST_PARTY_ID, p_END_CUSTOMER_CUST_PARTY_ID),
460 END_CUSTOMER_PARTY_SITE_ID = decode( p_END_CUSTOMER_PARTY_SITE_ID, FND_API.G_MISS_NUM, END_CUSTOMER_PARTY_SITE_ID, p_END_CUSTOMER_PARTY_SITE_ID),
461 END_CUSTOMER_CUST_ACCOUNT_ID = decode( p_END_CUSTOMER_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, END_CUSTOMER_CUST_ACCOUNT_ID, p_END_CUSTOMER_CUST_ACCOUNT_ID),
462 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),
463 CHARGE_PERIODICITY_CODE = decode( p_CHARGE_PERIODICITY_CODE, FND_API.G_MISS_CHAR, CHARGE_PERIODICITY_CODE, p_CHARGE_PERIODICITY_CODE), -- Recurring charges Change
464
465 SHIP_MODEL_COMPLETE_FLAG = decode( p_SHIP_MODEL_COMPLETE_FLAG, FND_API.G_MISS_CHAR, SHIP_MODEL_COMPLETE_FLAG, p_SHIP_MODEL_COMPLETE_FLAG),
466
467 LINE_PAYNOW_CHARGES = decode( p_LINE_PAYNOW_CHARGES, FND_API.G_MISS_NUM,LINE_PAYNOW_CHARGES,p_LINE_PAYNOW_CHARGES),
468 LINE_PAYNOW_TAX = decode( p_LINE_PAYNOW_TAX, FND_API.G_MISS_NUM,LINE_PAYNOW_TAX,p_LINE_PAYNOW_TAX),
469 LINE_PAYNOW_SUBTOTAL = decode( p_LINE_PAYNOW_SUBTOTAL, FND_API.G_MISS_NUM,LINE_PAYNOW_SUBTOTAL,p_LINE_PAYNOW_SUBTOTAL),
470 PRICING_QUANTITY_UOM = decode( p_PRICING_QUANTITY_UOM, FND_API.G_MISS_CHAR, PRICING_QUANTITY_UOM, p_PRICING_QUANTITY_UOM),
471 PRICING_QUANTITY = decode( p_PRICING_QUANTITY, FND_API.G_MISS_NUM,PRICING_QUANTITY,p_PRICING_QUANTITY),
472 CONFIG_MODEL_TYPE = decode( p_CONFIG_MODEL_TYPE, FND_API.G_MISS_CHAR, CONFIG_MODEL_TYPE, p_CONFIG_MODEL_TYPE)
473
474 where QUOTE_LINE_ID = p_QUOTE_LINE_ID;
475
476
477 If (SQL%NOTFOUND) then
478 RAISE NO_DATA_FOUND;
479 End If;
480 END Update_Row;
481
482 PROCEDURE Delete_Row(
483 p_QUOTE_LINE_ID NUMBER)
484 IS
485 BEGIN
486 DELETE FROM ASO_QUOTE_LINES_ALL
487 WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
488
489 If (SQL%NOTFOUND) then
490 RAISE NO_DATA_FOUND;
491 End If;
492 END Delete_Row;
493
494 PROCEDURE Lock_Row(
495 --p_OBJECT_VERSION_NUMBER NUMBER,
496 p_QUOTE_LINE_ID NUMBER,
497 p_CREATION_DATE DATE,
498 p_CREATED_BY NUMBER,
499 p_LAST_UPDATE_DATE DATE,
500 p_LAST_UPDATED_BY NUMBER,
501 p_LAST_UPDATE_LOGIN NUMBER,
502 p_REQUEST_ID NUMBER,
503 p_PROGRAM_APPLICATION_ID NUMBER,
504 p_PROGRAM_ID NUMBER,
505 p_PROGRAM_UPDATE_DATE DATE,
506 p_QUOTE_HEADER_ID NUMBER,
507 p_ORG_ID NUMBER,
508 p_LINE_CATEGORY_CODE VARCHAR2,
509 p_ITEM_TYPE_CODE VARCHAR2,
510 p_LINE_NUMBER NUMBER,
511 p_START_DATE_ACTIVE DATE,
512 p_END_DATE_ACTIVE DATE,
513 p_ORDER_LINE_TYPE_ID NUMBER,
514 p_INVOICE_TO_PARTY_SITE_ID NUMBER,
515 p_INVOICE_TO_PARTY_ID NUMBER,
516 p_ORGANIZATION_ID NUMBER,
517 p_INVENTORY_ITEM_ID NUMBER,
518 p_QUANTITY NUMBER,
519 p_UOM_CODE VARCHAR2,
520 p_MARKETING_SOURCE_CODE_ID NUMBER,
521 p_PRICE_LIST_ID NUMBER,
522 p_PRICE_LIST_LINE_ID NUMBER,
523 p_CURRENCY_CODE VARCHAR2,
524 p_LINE_LIST_PRICE NUMBER,
525 p_LINE_ADJUSTED_AMOUNT NUMBER,
526 p_LINE_ADJUSTED_PERCENT NUMBER,
527 p_LINE_QUOTE_PRICE NUMBER,
528 p_RELATED_ITEM_ID NUMBER,
529 p_ITEM_RELATIONSHIP_TYPE VARCHAR2,
530 p_ACCOUNTING_RULE_ID NUMBER,
531 p_INVOICING_RULE_ID NUMBER,
532 p_SPLIT_SHIPMENT_FLAG VARCHAR2,
533 p_BACKORDER_FLAG VARCHAR2,
534 p_ATTRIBUTE_CATEGORY VARCHAR2,
535 p_ATTRIBUTE1 VARCHAR2,
536 p_ATTRIBUTE2 VARCHAR2,
537 p_ATTRIBUTE3 VARCHAR2,
538 p_ATTRIBUTE4 VARCHAR2,
539 p_ATTRIBUTE5 VARCHAR2,
540 p_ATTRIBUTE6 VARCHAR2,
541 p_ATTRIBUTE7 VARCHAR2,
542 p_ATTRIBUTE8 VARCHAR2,
543 p_ATTRIBUTE9 VARCHAR2,
544 p_ATTRIBUTE10 VARCHAR2,
545 p_ATTRIBUTE11 VARCHAR2,
546 p_ATTRIBUTE12 VARCHAR2,
547 p_ATTRIBUTE13 VARCHAR2,
548 p_ATTRIBUTE14 VARCHAR2,
549 p_ATTRIBUTE15 VARCHAR2 /* ,
550 p_PRICED_PRICE_LIST_ID NUMBER,
551 p_AGREEMENT_ID NUMBER,
552 p_COMMITMENT_ID NUMBER,
553 p_DISPLAY_ARITHMETIC_OPERATOR VARCHAR2*/
554 )
555
556 IS
557 CURSOR C IS
558 SELECT QUOTE_LINE_ID,
559 --OBJECT_VERSION_NUMBER,
560 CREATION_DATE,
561 CREATED_BY,
562 LAST_UPDATE_DATE,
563 LAST_UPDATED_BY,
564 LAST_UPDATE_LOGIN,
565 REQUEST_ID,
566 PROGRAM_APPLICATION_ID,
567 PROGRAM_ID,
568 PROGRAM_UPDATE_DATE,
569 QUOTE_HEADER_ID,
570 ORG_ID,
574 START_DATE_ACTIVE,
571 LINE_CATEGORY_CODE,
572 ITEM_TYPE_CODE,
573 LINE_NUMBER,
575 END_DATE_ACTIVE,
576 ORDER_LINE_TYPE_ID,
577 INVOICE_TO_PARTY_SITE_ID,
578 INVOICE_TO_PARTY_ID,
579 ORGANIZATION_ID,
580 INVENTORY_ITEM_ID,
581 QUANTITY,
582 UOM_CODE,
583 MARKETING_SOURCE_CODE_ID,
584 PRICE_LIST_ID,
585 PRICE_LIST_LINE_ID,
586 CURRENCY_CODE,
587 LINE_LIST_PRICE,
588 LINE_ADJUSTED_AMOUNT,
589 LINE_ADJUSTED_PERCENT,
590 LINE_QUOTE_PRICE,
591 RELATED_ITEM_ID,
592 ITEM_RELATIONSHIP_TYPE,
593 ACCOUNTING_RULE_ID,
594 INVOICING_RULE_ID,
595 SPLIT_SHIPMENT_FLAG,
596 BACKORDER_FLAG,
597 ATTRIBUTE_CATEGORY,
598 ATTRIBUTE1,
599 ATTRIBUTE2,
600 ATTRIBUTE3,
601 ATTRIBUTE4,
602 ATTRIBUTE5,
603 ATTRIBUTE6,
604 ATTRIBUTE7,
605 ATTRIBUTE8,
606 ATTRIBUTE9,
607 ATTRIBUTE10,
608 ATTRIBUTE11,
609 ATTRIBUTE12,
610 ATTRIBUTE13,
611 ATTRIBUTE14,
612 ATTRIBUTE15 /*,
613 PRICED_PRICE_LIST_ID ,
614 AGREEMENT_ID ,
615 COMMITMENT_ID ,
616 DISPLAY_ARITHMETIC_OPERATOR */
617 FROM ASO_QUOTE_LINES_ALL
618 WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID
619 FOR UPDATE of QUOTE_LINE_ID NOWAIT;
620 Recinfo C%ROWTYPE;
621 BEGIN
622 OPEN C;
623 FETCH C INTO Recinfo;
624 If (C%NOTFOUND) then
625 CLOSE C;
626 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
627 APP_EXCEPTION.RAISE_EXCEPTION;
628 End If;
629 CLOSE C;
630 if (
631
632 /*
633 ( Recinfo.QUOTE_LINE_ID = p_QUOTE_LINE_ID)
634 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
635 OR ( ( Recinfo.CREATION_DATE IS NULL )
636 AND ( p_CREATION_DATE IS NULL )))
637 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
638 OR ( ( Recinfo.CREATED_BY IS NULL )
639 AND ( p_CREATED_BY IS NULL )))
640 AND
641 */
642 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
643 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
644 AND ( p_LAST_UPDATE_DATE IS NULL )))
645 /*
646 AND
647 ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
648 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
649 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
650
651 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
652 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
653 AND ( p_LAST_UPDATED_BY IS NULL )))
654
655 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
656 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
657 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
658 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
659 OR ( ( Recinfo.REQUEST_ID IS NULL )
660 AND ( p_REQUEST_ID IS NULL )))
661 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
662 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
663 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
664 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
665 OR ( ( Recinfo.PROGRAM_ID IS NULL )
666 AND ( p_PROGRAM_ID IS NULL )))
667 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
668 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
669 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
670 AND ( ( Recinfo.QUOTE_HEADER_ID = p_QUOTE_HEADER_ID)
671 OR ( ( Recinfo.QUOTE_HEADER_ID IS NULL )
672 AND ( p_QUOTE_HEADER_ID IS NULL )))
673 AND ( ( Recinfo.ORG_ID = p_ORG_ID)
674 OR ( ( Recinfo.ORG_ID IS NULL )
675 AND ( p_ORG_ID IS NULL )))
676 AND ( ( Recinfo.LINE_CATEGORY_CODE = p_LINE_CATEGORY_CODE)
677 OR ( ( Recinfo.LINE_CATEGORY_CODE IS NULL )
678 AND ( p_LINE_CATEGORY_CODE IS NULL )))
679 AND ( ( Recinfo.ITEM_TYPE_CODE = p_ITEM_TYPE_CODE)
680 OR ( ( Recinfo.ITEM_TYPE_CODE IS NULL )
681 AND ( p_ITEM_TYPE_CODE IS NULL )))
682 AND ( ( Recinfo.LINE_NUMBER = p_LINE_NUMBER)
683 OR ( ( Recinfo.LINE_NUMBER IS NULL )
684 AND ( p_LINE_NUMBER IS NULL )))
685 AND ( ( Recinfo.START_DATE_ACTIVE = p_START_DATE_ACTIVE)
686 OR ( ( Recinfo.START_DATE_ACTIVE IS NULL )
687 AND ( p_START_DATE_ACTIVE IS NULL )))
688 AND ( ( Recinfo.END_DATE_ACTIVE = p_END_DATE_ACTIVE)
689 OR ( ( Recinfo.END_DATE_ACTIVE IS NULL )
690 AND ( p_END_DATE_ACTIVE IS NULL )))
691 AND ( ( Recinfo.ORDER_LINE_TYPE_ID = p_ORDER_LINE_TYPE_ID)
692 OR ( ( Recinfo.ORDER_LINE_TYPE_ID IS NULL )
693 AND ( p_ORDER_LINE_TYPE_ID IS NULL )))
694 AND ( ( Recinfo.INVOICE_TO_PARTY_SITE_ID = p_INVOICE_TO_PARTY_SITE_ID)
695 OR ( ( Recinfo.INVOICE_TO_PARTY_SITE_ID IS NULL )
696 AND ( p_INVOICE_TO_PARTY_SITE_ID IS NULL )))
697 AND ( ( Recinfo.INVOICE_TO_PARTY_ID = p_INVOICE_TO_PARTY_ID)
698 OR ( ( Recinfo.INVOICE_TO_PARTY_ID IS NULL )
699 AND ( p_INVOICE_TO_PARTY_ID IS NULL )))
700 AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
701 OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
702 AND ( p_ORGANIZATION_ID IS NULL )))
703 AND ( ( Recinfo.INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID)
704 OR ( ( Recinfo.INVENTORY_ITEM_ID IS NULL )
705 AND ( p_INVENTORY_ITEM_ID IS NULL )))
706 AND ( ( Recinfo.QUANTITY = p_QUANTITY)
707 OR ( ( Recinfo.QUANTITY IS NULL )
708 AND ( p_QUANTITY IS NULL )))
712 AND ( ( Recinfo.MARKETING_SOURCE_CODE_ID = p_MARKETING_SOURCE_CODE_ID)
709 AND ( ( Recinfo.UOM_CODE = p_UOM_CODE)
710 OR ( ( Recinfo.UOM_CODE IS NULL )
711 AND ( p_UOM_CODE IS NULL )))
713 OR ( ( Recinfo.MARKETING_SOURCE_CODE_ID IS NULL )
714 AND ( p_MARKETING_SOURCE_CODE_ID IS NULL )))
715 AND ( ( Recinfo.PRICE_LIST_ID = p_PRICE_LIST_ID)
716 OR ( ( Recinfo.PRICE_LIST_ID IS NULL )
717 AND ( p_PRICE_LIST_ID IS NULL )))
718 AND ( ( Recinfo.PRICE_LIST_LINE_ID = p_PRICE_LIST_LINE_ID)
719 OR ( ( Recinfo.PRICE_LIST_LINE_ID IS NULL )
720 AND ( p_PRICE_LIST_LINE_ID IS NULL )))
721 AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
722 OR ( ( Recinfo.CURRENCY_CODE IS NULL )
723 AND ( p_CURRENCY_CODE IS NULL )))
724 AND ( ( Recinfo.LINE_LIST_PRICE = p_LINE_LIST_PRICE)
725 OR ( ( Recinfo.LINE_LIST_PRICE IS NULL )
726 AND ( p_LINE_LIST_PRICE IS NULL )))
727 AND ( ( Recinfo.LINE_ADJUSTED_AMOUNT = p_LINE_ADJUSTED_AMOUNT)
728 OR ( ( Recinfo.LINE_ADJUSTED_AMOUNT IS NULL )
729 AND ( p_LINE_ADJUSTED_AMOUNT IS NULL )))
730 AND ( ( Recinfo.LINE_ADJUSTED_PERCENT = p_LINE_ADJUSTED_PERCENT)
731 OR ( ( Recinfo.LINE_ADJUSTED_PERCENT IS NULL )
732 AND ( p_LINE_ADJUSTED_PERCENT IS NULL )))
733 AND ( ( Recinfo.LINE_QUOTE_PRICE = p_LINE_QUOTE_PRICE)
734 OR ( ( Recinfo.LINE_QUOTE_PRICE IS NULL )
735 AND ( p_LINE_QUOTE_PRICE IS NULL )))
736 AND ( ( Recinfo.RELATED_ITEM_ID = p_RELATED_ITEM_ID)
737 OR ( ( Recinfo.RELATED_ITEM_ID IS NULL )
738 AND ( p_RELATED_ITEM_ID IS NULL )))
739 AND ( ( Recinfo.ITEM_RELATIONSHIP_TYPE = p_ITEM_RELATIONSHIP_TYPE)
740 OR ( ( Recinfo.ITEM_RELATIONSHIP_TYPE IS NULL )
741 AND ( p_ITEM_RELATIONSHIP_TYPE IS NULL )))
742 AND ( ( Recinfo.ACCOUNTING_RULE_ID = p_ACCOUNTING_RULE_ID)
743 OR ( ( Recinfo.ACCOUNTING_RULE_ID IS NULL )
744 AND ( p_ACCOUNTING_RULE_ID IS NULL )))
745 AND ( ( Recinfo.INVOICING_RULE_ID = p_INVOICING_RULE_ID)
746 OR ( ( Recinfo.INVOICING_RULE_ID IS NULL )
747 AND ( p_INVOICING_RULE_ID IS NULL )))
748 AND ( ( Recinfo.SPLIT_SHIPMENT_FLAG = p_SPLIT_SHIPMENT_FLAG)
749 OR ( ( Recinfo.SPLIT_SHIPMENT_FLAG IS NULL )
750 AND ( p_SPLIT_SHIPMENT_FLAG IS NULL )))
751 AND ( ( Recinfo.BACKORDER_FLAG = p_BACKORDER_FLAG)
752 OR ( ( Recinfo.BACKORDER_FLAG IS NULL )
753 AND ( p_BACKORDER_FLAG IS NULL )))
754 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
755 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
756 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
757 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
758 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
759 AND ( p_ATTRIBUTE1 IS NULL )))
760 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
761 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
762 AND ( p_ATTRIBUTE2 IS NULL )))
763 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
764 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
765 AND ( p_ATTRIBUTE3 IS NULL )))
766 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
767 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
768 AND ( p_ATTRIBUTE4 IS NULL )))
769 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
770 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
771 AND ( p_ATTRIBUTE5 IS NULL )))
772 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
773 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
774 AND ( p_ATTRIBUTE6 IS NULL )))
775 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
776 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
777 AND ( p_ATTRIBUTE7 IS NULL )))
778 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
779 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
780 AND ( p_ATTRIBUTE8 IS NULL )))
781 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
782 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
783 AND ( p_ATTRIBUTE9 IS NULL )))
784 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
785 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
786 AND ( p_ATTRIBUTE10 IS NULL )))
787 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
788 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
789 AND ( p_ATTRIBUTE11 IS NULL )))
790 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
791 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
792 AND ( p_ATTRIBUTE12 IS NULL )))
793 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
794 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
795 AND ( p_ATTRIBUTE13 IS NULL )))
796 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
797 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
798 AND ( p_ATTRIBUTE14 IS NULL )))
799 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
800 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
801 AND ( p_ATTRIBUTE15 IS NULL )))
802 */
803 ) then
804 return;
805 else
806 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
807 APP_EXCEPTION.RAISE_EXCEPTION;
808
809 End If;
810 END Lock_Row;
811
812 End ASO_QUOTE_LINES_PKG;