[Home] [Help]
PACKAGE BODY: APPS.ASO_PRICE_ATTRIBUTES_PKG
Source
1 PACKAGE BODY ASO_PRICE_ATTRIBUTES_PKG as
2 /* $Header: asotpatb.pls 120.1 2005/06/29 12:39:52 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_PRICE_ATTRIBUTES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICE_ATTRIBUTES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotpatb.pls';
13
14 PROCEDURE Insert_Row(
15 px_PRICE_ATTRIBUTE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
16 p_CREATION_DATE DATE,
17 p_CREATED_BY NUMBER,
18 p_LAST_UPDATE_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_LAST_UPDATE_LOGIN NUMBER,
21 p_PROGRAM_APPLICATION_ID NUMBER,
22 p_PROGRAM_ID NUMBER,
23 p_PROGRAM_UPDATE_DATE DATE,
24 p_REQUEST_ID NUMBER,
25 p_QUOTE_HEADER_ID NUMBER,
26 p_QUOTE_LINE_ID NUMBER,
27 p_FLEX_TITLE VARCHAR2,
28 p_PRICING_CONTEXT VARCHAR2,
29 p_PRICING_ATTRIBUTE1 VARCHAR2,
30 p_PRICING_ATTRIBUTE2 VARCHAR2,
31 p_PRICING_ATTRIBUTE3 VARCHAR2,
32 p_PRICING_ATTRIBUTE4 VARCHAR2,
33 p_PRICING_ATTRIBUTE5 VARCHAR2,
34 p_PRICING_ATTRIBUTE6 VARCHAR2,
35 p_PRICING_ATTRIBUTE7 VARCHAR2,
36 p_PRICING_ATTRIBUTE8 VARCHAR2,
37 p_PRICING_ATTRIBUTE9 VARCHAR2,
38 p_PRICING_ATTRIBUTE10 VARCHAR2,
39 p_PRICING_ATTRIBUTE11 VARCHAR2,
40 p_PRICING_ATTRIBUTE12 VARCHAR2,
41 p_PRICING_ATTRIBUTE13 VARCHAR2,
42 p_PRICING_ATTRIBUTE14 VARCHAR2,
43 p_PRICING_ATTRIBUTE15 VARCHAR2,
44 p_PRICING_ATTRIBUTE16 VARCHAR2,
45 p_PRICING_ATTRIBUTE17 VARCHAR2,
46 p_PRICING_ATTRIBUTE18 VARCHAR2,
47 p_PRICING_ATTRIBUTE19 VARCHAR2,
48 p_PRICING_ATTRIBUTE20 VARCHAR2,
49 p_PRICING_ATTRIBUTE21 VARCHAR2,
50 p_PRICING_ATTRIBUTE22 VARCHAR2,
51 p_PRICING_ATTRIBUTE23 VARCHAR2,
52 p_PRICING_ATTRIBUTE24 VARCHAR2,
53 p_PRICING_ATTRIBUTE25 VARCHAR2,
54 p_PRICING_ATTRIBUTE26 VARCHAR2,
55 p_PRICING_ATTRIBUTE27 VARCHAR2,
56 p_PRICING_ATTRIBUTE28 VARCHAR2,
57 p_PRICING_ATTRIBUTE29 VARCHAR2,
58 p_PRICING_ATTRIBUTE30 VARCHAR2,
59 p_PRICING_ATTRIBUTE31 VARCHAR2,
60 p_PRICING_ATTRIBUTE32 VARCHAR2,
61 p_PRICING_ATTRIBUTE33 VARCHAR2,
62 p_PRICING_ATTRIBUTE34 VARCHAR2,
63 p_PRICING_ATTRIBUTE35 VARCHAR2,
64 p_PRICING_ATTRIBUTE36 VARCHAR2,
65 p_PRICING_ATTRIBUTE37 VARCHAR2,
66 p_PRICING_ATTRIBUTE38 VARCHAR2,
67 p_PRICING_ATTRIBUTE39 VARCHAR2,
68 p_PRICING_ATTRIBUTE40 VARCHAR2,
69 p_PRICING_ATTRIBUTE41 VARCHAR2,
70 p_PRICING_ATTRIBUTE42 VARCHAR2,
71 p_PRICING_ATTRIBUTE43 VARCHAR2,
72 p_PRICING_ATTRIBUTE44 VARCHAR2,
73 p_PRICING_ATTRIBUTE45 VARCHAR2,
74 p_PRICING_ATTRIBUTE46 VARCHAR2,
75 p_PRICING_ATTRIBUTE47 VARCHAR2,
76 p_PRICING_ATTRIBUTE48 VARCHAR2,
77 p_PRICING_ATTRIBUTE49 VARCHAR2,
78 p_PRICING_ATTRIBUTE50 VARCHAR2,
79 p_PRICING_ATTRIBUTE51 VARCHAR2,
80 p_PRICING_ATTRIBUTE52 VARCHAR2,
81 p_PRICING_ATTRIBUTE53 VARCHAR2,
82 p_PRICING_ATTRIBUTE54 VARCHAR2,
83 p_PRICING_ATTRIBUTE55 VARCHAR2,
84 p_PRICING_ATTRIBUTE56 VARCHAR2,
85 p_PRICING_ATTRIBUTE57 VARCHAR2,
86 p_PRICING_ATTRIBUTE58 VARCHAR2,
87 p_PRICING_ATTRIBUTE59 VARCHAR2,
88 p_PRICING_ATTRIBUTE60 VARCHAR2,
89 p_PRICING_ATTRIBUTE61 VARCHAR2,
90 p_PRICING_ATTRIBUTE62 VARCHAR2,
91 p_PRICING_ATTRIBUTE63 VARCHAR2,
92 p_PRICING_ATTRIBUTE64 VARCHAR2,
93 p_PRICING_ATTRIBUTE65 VARCHAR2,
94 p_PRICING_ATTRIBUTE66 VARCHAR2,
95 p_PRICING_ATTRIBUTE67 VARCHAR2,
96 p_PRICING_ATTRIBUTE68 VARCHAR2,
97 p_PRICING_ATTRIBUTE69 VARCHAR2,
98 p_PRICING_ATTRIBUTE70 VARCHAR2,
99 p_PRICING_ATTRIBUTE71 VARCHAR2,
100 p_PRICING_ATTRIBUTE72 VARCHAR2,
101 p_PRICING_ATTRIBUTE73 VARCHAR2,
102 p_PRICING_ATTRIBUTE74 VARCHAR2,
103 p_PRICING_ATTRIBUTE75 VARCHAR2,
104 p_PRICING_ATTRIBUTE76 VARCHAR2,
105 p_PRICING_ATTRIBUTE77 VARCHAR2,
106 p_PRICING_ATTRIBUTE78 VARCHAR2,
107 p_PRICING_ATTRIBUTE79 VARCHAR2,
108 p_PRICING_ATTRIBUTE80 VARCHAR2,
109 p_PRICING_ATTRIBUTE81 VARCHAR2,
110 p_PRICING_ATTRIBUTE82 VARCHAR2,
111 p_PRICING_ATTRIBUTE83 VARCHAR2,
112 p_PRICING_ATTRIBUTE84 VARCHAR2,
113 p_PRICING_ATTRIBUTE85 VARCHAR2,
114 p_PRICING_ATTRIBUTE86 VARCHAR2,
115 p_PRICING_ATTRIBUTE87 VARCHAR2,
116 p_PRICING_ATTRIBUTE88 VARCHAR2,
117 p_PRICING_ATTRIBUTE89 VARCHAR2,
118 p_PRICING_ATTRIBUTE90 VARCHAR2,
119 p_PRICING_ATTRIBUTE91 VARCHAR2,
120 p_PRICING_ATTRIBUTE92 VARCHAR2,
121 p_PRICING_ATTRIBUTE93 VARCHAR2,
122 p_PRICING_ATTRIBUTE94 VARCHAR2,
123 p_PRICING_ATTRIBUTE95 VARCHAR2,
124 p_PRICING_ATTRIBUTE96 VARCHAR2,
125 p_PRICING_ATTRIBUTE97 VARCHAR2,
126 p_PRICING_ATTRIBUTE98 VARCHAR2,
127 p_PRICING_ATTRIBUTE99 VARCHAR2,
128 p_PRICING_ATTRIBUTE100 VARCHAR2,
129 p_CONTEXT VARCHAR2,
130 p_ATTRIBUTE1 VARCHAR2,
131 p_ATTRIBUTE2 VARCHAR2,
132 p_ATTRIBUTE3 VARCHAR2,
133 p_ATTRIBUTE4 VARCHAR2,
134 p_ATTRIBUTE5 VARCHAR2,
135 p_ATTRIBUTE6 VARCHAR2,
136 p_ATTRIBUTE7 VARCHAR2,
137 p_ATTRIBUTE8 VARCHAR2,
138 p_ATTRIBUTE9 VARCHAR2,
139 p_ATTRIBUTE10 VARCHAR2,
140 p_ATTRIBUTE11 VARCHAR2,
141 p_ATTRIBUTE12 VARCHAR2,
142 p_ATTRIBUTE13 VARCHAR2,
143 p_ATTRIBUTE14 VARCHAR2,
144 p_ATTRIBUTE15 VARCHAR2,
145 p_ATTRIBUTE16 VARCHAR2,
146 p_ATTRIBUTE17 VARCHAR2,
147 p_ATTRIBUTE18 VARCHAR2,
148 p_ATTRIBUTE19 VARCHAR2,
149 p_ATTRIBUTE20 VARCHAR2,
150 p_OBJECT_VERSION_NUMBER NUMBER
151 )
152
153 IS
154 CURSOR C2 IS SELECT ASO_PRICE_ATTRIBUTES_S.nextval FROM sys.dual;
155 BEGIN
156 If (px_PRICE_ATTRIBUTE_ID IS NULL) OR (px_PRICE_ATTRIBUTE_ID = FND_API.G_MISS_NUM) then
157 OPEN C2;
158 FETCH C2 INTO px_PRICE_ATTRIBUTE_ID;
159 CLOSE C2;
160 End If;
161 INSERT INTO ASO_PRICE_ATTRIBUTES(
162 PRICE_ATTRIBUTE_ID,
163 CREATION_DATE,
164 CREATED_BY,
165 LAST_UPDATE_DATE,
166 LAST_UPDATED_BY,
167 LAST_UPDATE_LOGIN,
168 PROGRAM_APPLICATION_ID,
169 PROGRAM_ID,
170 PROGRAM_UPDATE_DATE,
171 REQUEST_ID,
172 QUOTE_HEADER_ID,
173 QUOTE_LINE_ID,
174 FLEX_TITLE,
175 PRICING_CONTEXT,
176 PRICING_ATTRIBUTE1,
177 PRICING_ATTRIBUTE2,
178 PRICING_ATTRIBUTE3,
179 PRICING_ATTRIBUTE4,
180 PRICING_ATTRIBUTE5,
181 PRICING_ATTRIBUTE6,
182 PRICING_ATTRIBUTE7,
183 PRICING_ATTRIBUTE8,
184 PRICING_ATTRIBUTE9,
185 PRICING_ATTRIBUTE10,
186 PRICING_ATTRIBUTE11,
187 PRICING_ATTRIBUTE12,
188 PRICING_ATTRIBUTE13,
189 PRICING_ATTRIBUTE14,
190 PRICING_ATTRIBUTE15,
191 PRICING_ATTRIBUTE16,
192 PRICING_ATTRIBUTE17,
193 PRICING_ATTRIBUTE18,
194 PRICING_ATTRIBUTE19,
195 PRICING_ATTRIBUTE20,
196 PRICING_ATTRIBUTE21,
197 PRICING_ATTRIBUTE22,
198 PRICING_ATTRIBUTE23,
199 PRICING_ATTRIBUTE24,
200 PRICING_ATTRIBUTE25,
201 PRICING_ATTRIBUTE26,
202 PRICING_ATTRIBUTE27,
203 PRICING_ATTRIBUTE28,
204 PRICING_ATTRIBUTE29,
205 PRICING_ATTRIBUTE30,
206 PRICING_ATTRIBUTE31,
207 PRICING_ATTRIBUTE32,
208 PRICING_ATTRIBUTE33,
209 PRICING_ATTRIBUTE34,
210 PRICING_ATTRIBUTE35,
211 PRICING_ATTRIBUTE36,
212 PRICING_ATTRIBUTE37,
213 PRICING_ATTRIBUTE38,
214 PRICING_ATTRIBUTE39,
215 PRICING_ATTRIBUTE40,
216 PRICING_ATTRIBUTE41,
217 PRICING_ATTRIBUTE42,
218 PRICING_ATTRIBUTE43,
219 PRICING_ATTRIBUTE44,
220 PRICING_ATTRIBUTE45,
221 PRICING_ATTRIBUTE46,
222 PRICING_ATTRIBUTE47,
223 PRICING_ATTRIBUTE48,
224 PRICING_ATTRIBUTE49,
225 PRICING_ATTRIBUTE50,
226 PRICING_ATTRIBUTE51,
227 PRICING_ATTRIBUTE52,
228 PRICING_ATTRIBUTE53,
229 PRICING_ATTRIBUTE54,
230 PRICING_ATTRIBUTE55,
231 PRICING_ATTRIBUTE56,
232 PRICING_ATTRIBUTE57,
233 PRICING_ATTRIBUTE58,
234 PRICING_ATTRIBUTE59,
235 PRICING_ATTRIBUTE60,
236 PRICING_ATTRIBUTE61,
237 PRICING_ATTRIBUTE62,
238 PRICING_ATTRIBUTE63,
239 PRICING_ATTRIBUTE64,
240 PRICING_ATTRIBUTE65,
241 PRICING_ATTRIBUTE66,
242 PRICING_ATTRIBUTE67,
243 PRICING_ATTRIBUTE68,
244 PRICING_ATTRIBUTE69,
245 PRICING_ATTRIBUTE70,
246 PRICING_ATTRIBUTE71,
247 PRICING_ATTRIBUTE72,
248 PRICING_ATTRIBUTE73,
249 PRICING_ATTRIBUTE74,
250 PRICING_ATTRIBUTE75,
251 PRICING_ATTRIBUTE76,
252 PRICING_ATTRIBUTE77,
253 PRICING_ATTRIBUTE78,
254 PRICING_ATTRIBUTE79,
255 PRICING_ATTRIBUTE80,
256 PRICING_ATTRIBUTE81,
257 PRICING_ATTRIBUTE82,
258 PRICING_ATTRIBUTE83,
259 PRICING_ATTRIBUTE84,
260 PRICING_ATTRIBUTE85,
261 PRICING_ATTRIBUTE86,
262 PRICING_ATTRIBUTE87,
263 PRICING_ATTRIBUTE88,
264 PRICING_ATTRIBUTE89,
265 PRICING_ATTRIBUTE90,
266 PRICING_ATTRIBUTE91,
267 PRICING_ATTRIBUTE92,
268 PRICING_ATTRIBUTE93,
269 PRICING_ATTRIBUTE94,
270 PRICING_ATTRIBUTE95,
271 PRICING_ATTRIBUTE96,
272 PRICING_ATTRIBUTE97,
273 PRICING_ATTRIBUTE98,
274 PRICING_ATTRIBUTE99,
275 PRICING_ATTRIBUTE100,
276 CONTEXT,
277 ATTRIBUTE1,
278 ATTRIBUTE2,
279 ATTRIBUTE3,
280 ATTRIBUTE4,
281 ATTRIBUTE5,
282 ATTRIBUTE6,
283 ATTRIBUTE7,
284 ATTRIBUTE8,
285 ATTRIBUTE9,
286 ATTRIBUTE10,
287 ATTRIBUTE11,
288 ATTRIBUTE12,
289 ATTRIBUTE13,
290 ATTRIBUTE14,
291 ATTRIBUTE15,
292 ATTRIBUTE16,
293 ATTRIBUTE17,
294 ATTRIBUTE18,
295 ATTRIBUTE19,
296 ATTRIBUTE20,
297 OBJECT_VERSION_NUMBER
298 ) VALUES (
299 px_PRICE_ATTRIBUTE_ID,
300 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
301 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
302 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
303 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
304 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
305 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
306 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
307 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
308 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
309 decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_HEADER_ID),
310 decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
311 decode( p_FLEX_TITLE, FND_API.G_MISS_CHAR, NULL, p_FLEX_TITLE),
312 decode( p_PRICING_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_PRICING_CONTEXT),
313 decode( p_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE1),
314 decode( p_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE2),
315 decode( p_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE3),
316 decode( p_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE4),
317 decode( p_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE5),
318 decode( p_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE6),
319 decode( p_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE7),
320 decode( p_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE8),
321 decode( p_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE9),
322 decode( p_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE10),
323 decode( p_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE11),
324 decode( p_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE12),
325 decode( p_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE13),
326 decode( p_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE14),
327 decode( p_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE15),
328 decode( p_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE16),
329 decode( p_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE17),
330 decode( p_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE18),
331 decode( p_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE19),
332 decode( p_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE20),
333 decode( p_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE21),
334 decode( p_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE22),
335 decode( p_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE23),
336 decode( p_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE24),
337 decode( p_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE25),
338 decode( p_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE26),
339 decode( p_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE27),
340 decode( p_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE28),
341 decode( p_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE29),
342 decode( p_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE30),
343 decode( p_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE31),
344 decode( p_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE32),
345 decode( p_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE33),
346 decode( p_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE34),
347 decode( p_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE35),
348 decode( p_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE36),
349 decode( p_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE37),
350 decode( p_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE38),
351 decode( p_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE39),
352 decode( p_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE40),
353 decode( p_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE41),
354 decode( p_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE42),
355 decode( p_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE43),
356 decode( p_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE44),
357 decode( p_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE45),
361 decode( p_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE49),
358 decode( p_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE46),
359 decode( p_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE47),
360 decode( p_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE48),
362 decode( p_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE50),
363 decode( p_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE51),
364 decode( p_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE52),
365 decode( p_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE53),
366 decode( p_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE54),
367 decode( p_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE55),
368 decode( p_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE56),
369 decode( p_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE57),
370 decode( p_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE58),
371 decode( p_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE59),
372 decode( p_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE60),
373 decode( p_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE61),
374 decode( p_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE62),
375 decode( p_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE63),
376 decode( p_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE64),
377 decode( p_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE65),
378 decode( p_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE66),
379 decode( p_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE67),
380 decode( p_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE68),
381 decode( p_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE69),
382 decode( p_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE70),
383 decode( p_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE71),
384 decode( p_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE72),
385 decode( p_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE73),
386 decode( p_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE74),
387 decode( p_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE75),
388 decode( p_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE76),
389 decode( p_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE77),
390 decode( p_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE78),
391 decode( p_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE79),
392 decode( p_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE80),
393 decode( p_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE81),
394 decode( p_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE82),
395 decode( p_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE83),
396 decode( p_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE84),
397 decode( p_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE85),
398 decode( p_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE86),
399 decode( p_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE87),
400 decode( p_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE88),
401 decode( p_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE89),
402 decode( p_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE90),
403 decode( p_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE91),
404 decode( p_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE92),
405 decode( p_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE93),
406 decode( p_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE94),
407 decode( p_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE95),
408 decode( p_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE96),
409 decode( p_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE97),
410 decode( p_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE98),
411 decode( p_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE99),
412 decode( p_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, NULL, p_PRICING_ATTRIBUTE100),
413 decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
414 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
415 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
416 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
417 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
418 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
419 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
420 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
421 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
422 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
423 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
424 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
425 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
426 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
430 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
427 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
428 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
429 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
431 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
432 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
433 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
434 decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)
435 );
436 End Insert_Row;
437
438 PROCEDURE Update_Row(
439 p_PRICE_ATTRIBUTE_ID NUMBER,
440 p_CREATION_DATE DATE,
441 p_CREATED_BY NUMBER,
442 p_LAST_UPDATE_DATE DATE,
443 p_LAST_UPDATED_BY NUMBER,
444 p_LAST_UPDATE_LOGIN NUMBER,
445 p_PROGRAM_APPLICATION_ID NUMBER,
446 p_PROGRAM_ID NUMBER,
447 p_PROGRAM_UPDATE_DATE DATE,
448 p_REQUEST_ID NUMBER,
449 p_QUOTE_HEADER_ID NUMBER,
450 p_QUOTE_LINE_ID NUMBER,
451 p_FLEX_TITLE VARCHAR2,
452 p_PRICING_CONTEXT VARCHAR2,
453 p_PRICING_ATTRIBUTE1 VARCHAR2,
454 p_PRICING_ATTRIBUTE2 VARCHAR2,
455 p_PRICING_ATTRIBUTE3 VARCHAR2,
456 p_PRICING_ATTRIBUTE4 VARCHAR2,
457 p_PRICING_ATTRIBUTE5 VARCHAR2,
458 p_PRICING_ATTRIBUTE6 VARCHAR2,
459 p_PRICING_ATTRIBUTE7 VARCHAR2,
460 p_PRICING_ATTRIBUTE8 VARCHAR2,
461 p_PRICING_ATTRIBUTE9 VARCHAR2,
462 p_PRICING_ATTRIBUTE10 VARCHAR2,
463 p_PRICING_ATTRIBUTE11 VARCHAR2,
464 p_PRICING_ATTRIBUTE12 VARCHAR2,
465 p_PRICING_ATTRIBUTE13 VARCHAR2,
466 p_PRICING_ATTRIBUTE14 VARCHAR2,
467 p_PRICING_ATTRIBUTE15 VARCHAR2,
468 p_PRICING_ATTRIBUTE16 VARCHAR2,
469 p_PRICING_ATTRIBUTE17 VARCHAR2,
470 p_PRICING_ATTRIBUTE18 VARCHAR2,
471 p_PRICING_ATTRIBUTE19 VARCHAR2,
472 p_PRICING_ATTRIBUTE20 VARCHAR2,
473 p_PRICING_ATTRIBUTE21 VARCHAR2,
474 p_PRICING_ATTRIBUTE22 VARCHAR2,
475 p_PRICING_ATTRIBUTE23 VARCHAR2,
476 p_PRICING_ATTRIBUTE24 VARCHAR2,
477 p_PRICING_ATTRIBUTE25 VARCHAR2,
478 p_PRICING_ATTRIBUTE26 VARCHAR2,
479 p_PRICING_ATTRIBUTE27 VARCHAR2,
480 p_PRICING_ATTRIBUTE28 VARCHAR2,
481 p_PRICING_ATTRIBUTE29 VARCHAR2,
482 p_PRICING_ATTRIBUTE30 VARCHAR2,
483 p_PRICING_ATTRIBUTE31 VARCHAR2,
484 p_PRICING_ATTRIBUTE32 VARCHAR2,
485 p_PRICING_ATTRIBUTE33 VARCHAR2,
486 p_PRICING_ATTRIBUTE34 VARCHAR2,
487 p_PRICING_ATTRIBUTE35 VARCHAR2,
488 p_PRICING_ATTRIBUTE36 VARCHAR2,
489 p_PRICING_ATTRIBUTE37 VARCHAR2,
490 p_PRICING_ATTRIBUTE38 VARCHAR2,
491 p_PRICING_ATTRIBUTE39 VARCHAR2,
492 p_PRICING_ATTRIBUTE40 VARCHAR2,
493 p_PRICING_ATTRIBUTE41 VARCHAR2,
494 p_PRICING_ATTRIBUTE42 VARCHAR2,
495 p_PRICING_ATTRIBUTE43 VARCHAR2,
496 p_PRICING_ATTRIBUTE44 VARCHAR2,
497 p_PRICING_ATTRIBUTE45 VARCHAR2,
498 p_PRICING_ATTRIBUTE46 VARCHAR2,
499 p_PRICING_ATTRIBUTE47 VARCHAR2,
500 p_PRICING_ATTRIBUTE48 VARCHAR2,
501 p_PRICING_ATTRIBUTE49 VARCHAR2,
502 p_PRICING_ATTRIBUTE50 VARCHAR2,
503 p_PRICING_ATTRIBUTE51 VARCHAR2,
504 p_PRICING_ATTRIBUTE52 VARCHAR2,
505 p_PRICING_ATTRIBUTE53 VARCHAR2,
506 p_PRICING_ATTRIBUTE54 VARCHAR2,
507 p_PRICING_ATTRIBUTE55 VARCHAR2,
508 p_PRICING_ATTRIBUTE56 VARCHAR2,
509 p_PRICING_ATTRIBUTE57 VARCHAR2,
510 p_PRICING_ATTRIBUTE58 VARCHAR2,
511 p_PRICING_ATTRIBUTE59 VARCHAR2,
512 p_PRICING_ATTRIBUTE60 VARCHAR2,
513 p_PRICING_ATTRIBUTE61 VARCHAR2,
514 p_PRICING_ATTRIBUTE62 VARCHAR2,
515 p_PRICING_ATTRIBUTE63 VARCHAR2,
516 p_PRICING_ATTRIBUTE64 VARCHAR2,
517 p_PRICING_ATTRIBUTE65 VARCHAR2,
518 p_PRICING_ATTRIBUTE66 VARCHAR2,
519 p_PRICING_ATTRIBUTE67 VARCHAR2,
520 p_PRICING_ATTRIBUTE68 VARCHAR2,
521 p_PRICING_ATTRIBUTE69 VARCHAR2,
522 p_PRICING_ATTRIBUTE70 VARCHAR2,
523 p_PRICING_ATTRIBUTE71 VARCHAR2,
524 p_PRICING_ATTRIBUTE72 VARCHAR2,
525 p_PRICING_ATTRIBUTE73 VARCHAR2,
526 p_PRICING_ATTRIBUTE74 VARCHAR2,
527 p_PRICING_ATTRIBUTE75 VARCHAR2,
528 p_PRICING_ATTRIBUTE76 VARCHAR2,
529 p_PRICING_ATTRIBUTE77 VARCHAR2,
530 p_PRICING_ATTRIBUTE78 VARCHAR2,
531 p_PRICING_ATTRIBUTE79 VARCHAR2,
532 p_PRICING_ATTRIBUTE80 VARCHAR2,
533 p_PRICING_ATTRIBUTE81 VARCHAR2,
534 p_PRICING_ATTRIBUTE82 VARCHAR2,
535 p_PRICING_ATTRIBUTE83 VARCHAR2,
536 p_PRICING_ATTRIBUTE84 VARCHAR2,
537 p_PRICING_ATTRIBUTE85 VARCHAR2,
538 p_PRICING_ATTRIBUTE86 VARCHAR2,
539 p_PRICING_ATTRIBUTE87 VARCHAR2,
540 p_PRICING_ATTRIBUTE88 VARCHAR2,
541 p_PRICING_ATTRIBUTE89 VARCHAR2,
542 p_PRICING_ATTRIBUTE90 VARCHAR2,
543 p_PRICING_ATTRIBUTE91 VARCHAR2,
544 p_PRICING_ATTRIBUTE92 VARCHAR2,
545 p_PRICING_ATTRIBUTE93 VARCHAR2,
546 p_PRICING_ATTRIBUTE94 VARCHAR2,
547 p_PRICING_ATTRIBUTE95 VARCHAR2,
551 p_PRICING_ATTRIBUTE99 VARCHAR2,
548 p_PRICING_ATTRIBUTE96 VARCHAR2,
549 p_PRICING_ATTRIBUTE97 VARCHAR2,
550 p_PRICING_ATTRIBUTE98 VARCHAR2,
552 p_PRICING_ATTRIBUTE100 VARCHAR2,
553 p_CONTEXT VARCHAR2,
554 p_ATTRIBUTE1 VARCHAR2,
555 p_ATTRIBUTE2 VARCHAR2,
556 p_ATTRIBUTE3 VARCHAR2,
557 p_ATTRIBUTE4 VARCHAR2,
558 p_ATTRIBUTE5 VARCHAR2,
559 p_ATTRIBUTE6 VARCHAR2,
560 p_ATTRIBUTE7 VARCHAR2,
561 p_ATTRIBUTE8 VARCHAR2,
562 p_ATTRIBUTE9 VARCHAR2,
563 p_ATTRIBUTE10 VARCHAR2,
564 p_ATTRIBUTE11 VARCHAR2,
565 p_ATTRIBUTE12 VARCHAR2,
566 p_ATTRIBUTE13 VARCHAR2,
567 p_ATTRIBUTE14 VARCHAR2,
568 p_ATTRIBUTE15 VARCHAR2,
569 p_ATTRIBUTE16 VARCHAR2,
570 p_ATTRIBUTE17 VARCHAR2,
571 p_ATTRIBUTE18 VARCHAR2,
572 p_ATTRIBUTE19 VARCHAR2,
573 p_ATTRIBUTE20 VARCHAR2,
574 p_OBJECT_VERSION_NUMBER NUMBER
575 )
576
577 IS
578 BEGIN
579 Update ASO_PRICE_ATTRIBUTES
580 SET
581 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
582 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
583 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
584 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
585 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
586 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
587 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
588 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
589 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
590 QUOTE_HEADER_ID = decode( p_QUOTE_HEADER_ID, FND_API.G_MISS_NUM, QUOTE_HEADER_ID, p_QUOTE_HEADER_ID),
591 QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
592 FLEX_TITLE = decode( p_FLEX_TITLE, FND_API.G_MISS_CHAR, FLEX_TITLE, p_FLEX_TITLE),
593 PRICING_CONTEXT = decode( p_PRICING_CONTEXT, FND_API.G_MISS_CHAR, PRICING_CONTEXT, p_PRICING_CONTEXT),
594 PRICING_ATTRIBUTE1 = decode( p_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE1, p_PRICING_ATTRIBUTE1),
595 PRICING_ATTRIBUTE2 = decode( p_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE2, p_PRICING_ATTRIBUTE2),
596 PRICING_ATTRIBUTE3 = decode( p_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE3, p_PRICING_ATTRIBUTE3),
597 PRICING_ATTRIBUTE4 = decode( p_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE4, p_PRICING_ATTRIBUTE4),
598 PRICING_ATTRIBUTE5 = decode( p_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE5, p_PRICING_ATTRIBUTE5),
599 PRICING_ATTRIBUTE6 = decode( p_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE6, p_PRICING_ATTRIBUTE6),
600 PRICING_ATTRIBUTE7 = decode( p_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE7, p_PRICING_ATTRIBUTE7),
601 PRICING_ATTRIBUTE8 = decode( p_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE8, p_PRICING_ATTRIBUTE8),
602 PRICING_ATTRIBUTE9 = decode( p_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE9, p_PRICING_ATTRIBUTE9),
603 PRICING_ATTRIBUTE10 = decode( p_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE10, p_PRICING_ATTRIBUTE10),
604 PRICING_ATTRIBUTE11 = decode( p_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE11, p_PRICING_ATTRIBUTE11),
605 PRICING_ATTRIBUTE12 = decode( p_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE12, p_PRICING_ATTRIBUTE12),
606 PRICING_ATTRIBUTE13 = decode( p_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE13, p_PRICING_ATTRIBUTE13),
607 PRICING_ATTRIBUTE14 = decode( p_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE14, p_PRICING_ATTRIBUTE14),
608 PRICING_ATTRIBUTE15 = decode( p_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE15, p_PRICING_ATTRIBUTE15),
609 PRICING_ATTRIBUTE16 = decode( p_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE16, p_PRICING_ATTRIBUTE16),
610 PRICING_ATTRIBUTE17 = decode( p_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE17, p_PRICING_ATTRIBUTE17),
611 PRICING_ATTRIBUTE18 = decode( p_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE18, p_PRICING_ATTRIBUTE18),
612 PRICING_ATTRIBUTE19 = decode( p_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE19, p_PRICING_ATTRIBUTE19),
613 PRICING_ATTRIBUTE20 = decode( p_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE20, p_PRICING_ATTRIBUTE20),
614 PRICING_ATTRIBUTE21 = decode( p_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE21, p_PRICING_ATTRIBUTE21),
615 PRICING_ATTRIBUTE22 = decode( p_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE22, p_PRICING_ATTRIBUTE22),
616 PRICING_ATTRIBUTE23 = decode( p_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE23, p_PRICING_ATTRIBUTE23),
617 PRICING_ATTRIBUTE24 = decode( p_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE24, p_PRICING_ATTRIBUTE24),
618 PRICING_ATTRIBUTE25 = decode( p_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE25, p_PRICING_ATTRIBUTE25),
619 PRICING_ATTRIBUTE26 = decode( p_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE26, p_PRICING_ATTRIBUTE26),
620 PRICING_ATTRIBUTE27 = decode( p_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE27, p_PRICING_ATTRIBUTE27),
624 PRICING_ATTRIBUTE31 = decode( p_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE31, p_PRICING_ATTRIBUTE31),
621 PRICING_ATTRIBUTE28 = decode( p_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE28, p_PRICING_ATTRIBUTE28),
622 PRICING_ATTRIBUTE29 = decode( p_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE29, p_PRICING_ATTRIBUTE29),
623 PRICING_ATTRIBUTE30 = decode( p_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE30, p_PRICING_ATTRIBUTE30),
625 PRICING_ATTRIBUTE32 = decode( p_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE32, p_PRICING_ATTRIBUTE32),
626 PRICING_ATTRIBUTE33 = decode( p_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE33, p_PRICING_ATTRIBUTE33),
627 PRICING_ATTRIBUTE34 = decode( p_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE34, p_PRICING_ATTRIBUTE34),
628 PRICING_ATTRIBUTE35 = decode( p_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE35, p_PRICING_ATTRIBUTE35),
629 PRICING_ATTRIBUTE36 = decode( p_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE36, p_PRICING_ATTRIBUTE36),
630 PRICING_ATTRIBUTE37 = decode( p_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE37, p_PRICING_ATTRIBUTE37),
631 PRICING_ATTRIBUTE38 = decode( p_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE38, p_PRICING_ATTRIBUTE38),
632 PRICING_ATTRIBUTE39 = decode( p_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE39, p_PRICING_ATTRIBUTE39),
633 PRICING_ATTRIBUTE40 = decode( p_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE40, p_PRICING_ATTRIBUTE40),
634 PRICING_ATTRIBUTE41 = decode( p_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE41, p_PRICING_ATTRIBUTE41),
635 PRICING_ATTRIBUTE42 = decode( p_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE42, p_PRICING_ATTRIBUTE42),
636 PRICING_ATTRIBUTE43 = decode( p_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE43, p_PRICING_ATTRIBUTE43),
637 PRICING_ATTRIBUTE44 = decode( p_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE44, p_PRICING_ATTRIBUTE44),
638 PRICING_ATTRIBUTE45 = decode( p_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE45, p_PRICING_ATTRIBUTE45),
639 PRICING_ATTRIBUTE46 = decode( p_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE46, p_PRICING_ATTRIBUTE46),
640 PRICING_ATTRIBUTE47 = decode( p_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE47, p_PRICING_ATTRIBUTE47),
641 PRICING_ATTRIBUTE48 = decode( p_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE48, p_PRICING_ATTRIBUTE48),
642 PRICING_ATTRIBUTE49 = decode( p_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE49, p_PRICING_ATTRIBUTE49),
643 PRICING_ATTRIBUTE50 = decode( p_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE50, p_PRICING_ATTRIBUTE50),
644 PRICING_ATTRIBUTE51 = decode( p_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE51, p_PRICING_ATTRIBUTE51),
645 PRICING_ATTRIBUTE52 = decode( p_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE52, p_PRICING_ATTRIBUTE52),
646 PRICING_ATTRIBUTE53 = decode( p_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE53, p_PRICING_ATTRIBUTE53),
647 PRICING_ATTRIBUTE54 = decode( p_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE54, p_PRICING_ATTRIBUTE54),
648 PRICING_ATTRIBUTE55 = decode( p_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE55, p_PRICING_ATTRIBUTE55),
649 PRICING_ATTRIBUTE56 = decode( p_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE56, p_PRICING_ATTRIBUTE56),
650 PRICING_ATTRIBUTE57 = decode( p_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE57, p_PRICING_ATTRIBUTE57),
651 PRICING_ATTRIBUTE58 = decode( p_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE58, p_PRICING_ATTRIBUTE58),
652 PRICING_ATTRIBUTE59 = decode( p_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE59, p_PRICING_ATTRIBUTE59),
653 PRICING_ATTRIBUTE60 = decode( p_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE60, p_PRICING_ATTRIBUTE60),
654 PRICING_ATTRIBUTE61 = decode( p_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE61, p_PRICING_ATTRIBUTE61),
655 PRICING_ATTRIBUTE62 = decode( p_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE62, p_PRICING_ATTRIBUTE62),
656 PRICING_ATTRIBUTE63 = decode( p_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE63, p_PRICING_ATTRIBUTE63),
657 PRICING_ATTRIBUTE64 = decode( p_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE64, p_PRICING_ATTRIBUTE64),
658 PRICING_ATTRIBUTE65 = decode( p_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE65, p_PRICING_ATTRIBUTE65),
659 PRICING_ATTRIBUTE66 = decode( p_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE66, p_PRICING_ATTRIBUTE66),
660 PRICING_ATTRIBUTE67 = decode( p_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE67, p_PRICING_ATTRIBUTE67),
661 PRICING_ATTRIBUTE68 = decode( p_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE68, p_PRICING_ATTRIBUTE68),
662 PRICING_ATTRIBUTE69 = decode( p_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE69, p_PRICING_ATTRIBUTE69),
663 PRICING_ATTRIBUTE70 = decode( p_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE70, p_PRICING_ATTRIBUTE70),
664 PRICING_ATTRIBUTE71 = decode( p_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE71, p_PRICING_ATTRIBUTE71),
665 PRICING_ATTRIBUTE72 = decode( p_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE72, p_PRICING_ATTRIBUTE72),
666 PRICING_ATTRIBUTE73 = decode( p_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE73, p_PRICING_ATTRIBUTE73),
667 PRICING_ATTRIBUTE74 = decode( p_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE74, p_PRICING_ATTRIBUTE74),
668 PRICING_ATTRIBUTE75 = decode( p_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE75, p_PRICING_ATTRIBUTE75),
669 PRICING_ATTRIBUTE76 = decode( p_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE76, p_PRICING_ATTRIBUTE76),
673 PRICING_ATTRIBUTE80 = decode( p_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE80, p_PRICING_ATTRIBUTE80),
670 PRICING_ATTRIBUTE77 = decode( p_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE77, p_PRICING_ATTRIBUTE77),
671 PRICING_ATTRIBUTE78 = decode( p_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE78, p_PRICING_ATTRIBUTE78),
672 PRICING_ATTRIBUTE79 = decode( p_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE79, p_PRICING_ATTRIBUTE79),
674 PRICING_ATTRIBUTE81 = decode( p_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE81, p_PRICING_ATTRIBUTE81),
675 PRICING_ATTRIBUTE82 = decode( p_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE82, p_PRICING_ATTRIBUTE82),
676 PRICING_ATTRIBUTE83 = decode( p_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE83, p_PRICING_ATTRIBUTE83),
677 PRICING_ATTRIBUTE84 = decode( p_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE84, p_PRICING_ATTRIBUTE84),
678 PRICING_ATTRIBUTE85 = decode( p_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE85, p_PRICING_ATTRIBUTE85),
679 PRICING_ATTRIBUTE86 = decode( p_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE86, p_PRICING_ATTRIBUTE86),
680 PRICING_ATTRIBUTE87 = decode( p_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE87, p_PRICING_ATTRIBUTE87),
681 PRICING_ATTRIBUTE88 = decode( p_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE88, p_PRICING_ATTRIBUTE88),
682 PRICING_ATTRIBUTE89 = decode( p_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE89, p_PRICING_ATTRIBUTE89),
683 PRICING_ATTRIBUTE90 = decode( p_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE90, p_PRICING_ATTRIBUTE90),
684 PRICING_ATTRIBUTE91 = decode( p_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE91, p_PRICING_ATTRIBUTE91),
685 PRICING_ATTRIBUTE92 = decode( p_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE92, p_PRICING_ATTRIBUTE92),
686 PRICING_ATTRIBUTE93 = decode( p_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE93, p_PRICING_ATTRIBUTE93),
687 PRICING_ATTRIBUTE94 = decode( p_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE94, p_PRICING_ATTRIBUTE94),
688 PRICING_ATTRIBUTE95 = decode( p_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE95, p_PRICING_ATTRIBUTE95),
689 PRICING_ATTRIBUTE96 = decode( p_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE96, p_PRICING_ATTRIBUTE96),
690 PRICING_ATTRIBUTE97 = decode( p_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE97, p_PRICING_ATTRIBUTE97),
691 PRICING_ATTRIBUTE98 = decode( p_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE98, p_PRICING_ATTRIBUTE98),
692 PRICING_ATTRIBUTE99 = decode( p_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE99, p_PRICING_ATTRIBUTE99),
693 PRICING_ATTRIBUTE100 = decode( p_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE100, p_PRICING_ATTRIBUTE100),
694 CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
695 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
696 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
697 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
698 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
699 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
700 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
701 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
702 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
703 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
704 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
705 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
706 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
707 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
708 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
709 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
710 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
711 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
712 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
713 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
714 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
715 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)
716 where PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID;
717
718 If (SQL%NOTFOUND) then
719 RAISE NO_DATA_FOUND;
720 End If;
721 END Update_Row;
722
723 PROCEDURE Delete_Row(
724 p_PRICE_ATTRIBUTE_ID NUMBER)
725 IS
726 BEGIN
727 DELETE FROM ASO_PRICE_ATTRIBUTES
728 WHERE PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID;
729 If (SQL%NOTFOUND) then
730 RAISE NO_DATA_FOUND;
731 End If;
732 END Delete_Row;
733
734
735 PROCEDURE Delete_Row(
736 p_QUOTE_LINE_ID NUMBER)
737 IS
738 BEGIN
739 DELETE FROM ASO_PRICE_ATTRIBUTES
740 WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
741 If (SQL%NOTFOUND) then
742 RAISE NO_DATA_FOUND;
743 End If;
744 END Delete_Row;
745
746 PROCEDURE Lock_Row(
747 --p_OBJECT_VERSION_NUMBER NUMBER,
751 p_LAST_UPDATE_DATE DATE,
748 p_PRICE_ATTRIBUTE_ID NUMBER,
749 p_CREATION_DATE DATE,
750 p_CREATED_BY NUMBER,
752 p_LAST_UPDATED_BY NUMBER,
753 p_LAST_UPDATE_LOGIN NUMBER,
754 p_PROGRAM_APPLICATION_ID NUMBER,
755 p_PROGRAM_ID NUMBER,
756 p_PROGRAM_UPDATE_DATE DATE,
757 p_REQUEST_ID NUMBER,
758 p_QUOTE_HEADER_ID NUMBER,
759 p_QUOTE_LINE_ID NUMBER,
760 p_FLEX_TITLE VARCHAR2,
761 p_PRICING_CONTEXT VARCHAR2,
762 p_PRICING_ATTRIBUTE1 VARCHAR2,
763 p_PRICING_ATTRIBUTE2 VARCHAR2,
764 p_PRICING_ATTRIBUTE3 VARCHAR2,
765 p_PRICING_ATTRIBUTE4 VARCHAR2,
766 p_PRICING_ATTRIBUTE5 VARCHAR2,
767 p_PRICING_ATTRIBUTE6 VARCHAR2,
768 p_PRICING_ATTRIBUTE7 VARCHAR2,
769 p_PRICING_ATTRIBUTE8 VARCHAR2,
770 p_PRICING_ATTRIBUTE9 VARCHAR2,
771 p_PRICING_ATTRIBUTE10 VARCHAR2,
772 p_PRICING_ATTRIBUTE11 VARCHAR2,
773 p_PRICING_ATTRIBUTE12 VARCHAR2,
774 p_PRICING_ATTRIBUTE13 VARCHAR2,
775 p_PRICING_ATTRIBUTE14 VARCHAR2,
776 p_PRICING_ATTRIBUTE15 VARCHAR2,
777 p_PRICING_ATTRIBUTE16 VARCHAR2,
778 p_PRICING_ATTRIBUTE17 VARCHAR2,
779 p_PRICING_ATTRIBUTE18 VARCHAR2,
780 p_PRICING_ATTRIBUTE19 VARCHAR2,
781 p_PRICING_ATTRIBUTE20 VARCHAR2,
782 p_PRICING_ATTRIBUTE21 VARCHAR2,
783 p_PRICING_ATTRIBUTE22 VARCHAR2,
784 p_PRICING_ATTRIBUTE23 VARCHAR2,
785 p_PRICING_ATTRIBUTE24 VARCHAR2,
786 p_PRICING_ATTRIBUTE25 VARCHAR2,
787 p_PRICING_ATTRIBUTE26 VARCHAR2,
788 p_PRICING_ATTRIBUTE27 VARCHAR2,
789 p_PRICING_ATTRIBUTE28 VARCHAR2,
790 p_PRICING_ATTRIBUTE29 VARCHAR2,
791 p_PRICING_ATTRIBUTE30 VARCHAR2,
792 p_PRICING_ATTRIBUTE31 VARCHAR2,
793 p_PRICING_ATTRIBUTE32 VARCHAR2,
794 p_PRICING_ATTRIBUTE33 VARCHAR2,
795 p_PRICING_ATTRIBUTE34 VARCHAR2,
796 p_PRICING_ATTRIBUTE35 VARCHAR2,
797 p_PRICING_ATTRIBUTE36 VARCHAR2,
798 p_PRICING_ATTRIBUTE37 VARCHAR2,
799 p_PRICING_ATTRIBUTE38 VARCHAR2,
800 p_PRICING_ATTRIBUTE39 VARCHAR2,
801 p_PRICING_ATTRIBUTE40 VARCHAR2,
802 p_PRICING_ATTRIBUTE41 VARCHAR2,
803 p_PRICING_ATTRIBUTE42 VARCHAR2,
804 p_PRICING_ATTRIBUTE43 VARCHAR2,
805 p_PRICING_ATTRIBUTE44 VARCHAR2,
806 p_PRICING_ATTRIBUTE45 VARCHAR2,
807 p_PRICING_ATTRIBUTE46 VARCHAR2,
808 p_PRICING_ATTRIBUTE47 VARCHAR2,
809 p_PRICING_ATTRIBUTE48 VARCHAR2,
810 p_PRICING_ATTRIBUTE49 VARCHAR2,
811 p_PRICING_ATTRIBUTE50 VARCHAR2,
812 p_PRICING_ATTRIBUTE51 VARCHAR2,
813 p_PRICING_ATTRIBUTE52 VARCHAR2,
814 p_PRICING_ATTRIBUTE53 VARCHAR2,
815 p_PRICING_ATTRIBUTE54 VARCHAR2,
816 p_PRICING_ATTRIBUTE55 VARCHAR2,
817 p_PRICING_ATTRIBUTE56 VARCHAR2,
818 p_PRICING_ATTRIBUTE57 VARCHAR2,
819 p_PRICING_ATTRIBUTE58 VARCHAR2,
820 p_PRICING_ATTRIBUTE59 VARCHAR2,
821 p_PRICING_ATTRIBUTE60 VARCHAR2,
822 p_PRICING_ATTRIBUTE61 VARCHAR2,
823 p_PRICING_ATTRIBUTE62 VARCHAR2,
824 p_PRICING_ATTRIBUTE63 VARCHAR2,
825 p_PRICING_ATTRIBUTE64 VARCHAR2,
826 p_PRICING_ATTRIBUTE65 VARCHAR2,
827 p_PRICING_ATTRIBUTE66 VARCHAR2,
828 p_PRICING_ATTRIBUTE67 VARCHAR2,
829 p_PRICING_ATTRIBUTE68 VARCHAR2,
830 p_PRICING_ATTRIBUTE69 VARCHAR2,
831 p_PRICING_ATTRIBUTE70 VARCHAR2,
832 p_PRICING_ATTRIBUTE71 VARCHAR2,
833 p_PRICING_ATTRIBUTE72 VARCHAR2,
834 p_PRICING_ATTRIBUTE73 VARCHAR2,
835 p_PRICING_ATTRIBUTE74 VARCHAR2,
836 p_PRICING_ATTRIBUTE75 VARCHAR2,
837 p_PRICING_ATTRIBUTE76 VARCHAR2,
838 p_PRICING_ATTRIBUTE77 VARCHAR2,
839 p_PRICING_ATTRIBUTE78 VARCHAR2,
840 p_PRICING_ATTRIBUTE79 VARCHAR2,
841 p_PRICING_ATTRIBUTE80 VARCHAR2,
842 p_PRICING_ATTRIBUTE81 VARCHAR2,
843 p_PRICING_ATTRIBUTE82 VARCHAR2,
844 p_PRICING_ATTRIBUTE83 VARCHAR2,
845 p_PRICING_ATTRIBUTE84 VARCHAR2,
846 p_PRICING_ATTRIBUTE85 VARCHAR2,
847 p_PRICING_ATTRIBUTE86 VARCHAR2,
848 p_PRICING_ATTRIBUTE87 VARCHAR2,
849 p_PRICING_ATTRIBUTE88 VARCHAR2,
850 p_PRICING_ATTRIBUTE89 VARCHAR2,
851 p_PRICING_ATTRIBUTE90 VARCHAR2,
852 p_PRICING_ATTRIBUTE91 VARCHAR2,
853 p_PRICING_ATTRIBUTE92 VARCHAR2,
854 p_PRICING_ATTRIBUTE93 VARCHAR2,
855 p_PRICING_ATTRIBUTE94 VARCHAR2,
856 p_PRICING_ATTRIBUTE95 VARCHAR2,
857 p_PRICING_ATTRIBUTE96 VARCHAR2,
858 p_PRICING_ATTRIBUTE97 VARCHAR2,
859 p_PRICING_ATTRIBUTE98 VARCHAR2,
860 p_PRICING_ATTRIBUTE99 VARCHAR2,
861 p_PRICING_ATTRIBUTE100 VARCHAR2,
862 p_CONTEXT VARCHAR2,
863 p_ATTRIBUTE1 VARCHAR2,
864 p_ATTRIBUTE2 VARCHAR2,
865 p_ATTRIBUTE3 VARCHAR2,
866 p_ATTRIBUTE4 VARCHAR2,
867 p_ATTRIBUTE5 VARCHAR2,
868 p_ATTRIBUTE6 VARCHAR2,
869 p_ATTRIBUTE7 VARCHAR2,
870 p_ATTRIBUTE8 VARCHAR2,
871 p_ATTRIBUTE9 VARCHAR2,
875 p_ATTRIBUTE13 VARCHAR2,
872 p_ATTRIBUTE10 VARCHAR2,
873 p_ATTRIBUTE11 VARCHAR2,
874 p_ATTRIBUTE12 VARCHAR2,
876 p_ATTRIBUTE14 VARCHAR2,
877 p_ATTRIBUTE15 VARCHAR2)
878
879 IS
880 CURSOR C IS
881 SELECT PRICING_ATTRIBUTE26,
882 --OBJECT_VERSION_NUMBER,
883 PRICING_ATTRIBUTE27,
884 PRICING_ATTRIBUTE28,
885 PRICING_ATTRIBUTE29,
886 PRICING_ATTRIBUTE30,
887 PRICING_ATTRIBUTE31,
888 PRICING_ATTRIBUTE32,
889 PRICING_ATTRIBUTE33,
890 PRICING_ATTRIBUTE34,
891 PRICING_ATTRIBUTE35,
892 PRICING_ATTRIBUTE36,
893 PRICING_ATTRIBUTE37,
894 PRICING_ATTRIBUTE38,
895 PRICING_ATTRIBUTE39,
896 PRICING_ATTRIBUTE40,
897 PRICING_ATTRIBUTE41,
898 PRICING_ATTRIBUTE42,
899 PRICING_ATTRIBUTE43,
900 PRICING_ATTRIBUTE44,
901 PRICING_ATTRIBUTE45,
902 PRICING_ATTRIBUTE46,
903 PRICING_ATTRIBUTE47,
904 PRICING_ATTRIBUTE48,
905 PRICING_ATTRIBUTE49,
906 PRICING_ATTRIBUTE50,
907 PRICING_ATTRIBUTE51,
908 PRICING_ATTRIBUTE52,
909 PRICING_ATTRIBUTE53,
910 PRICING_ATTRIBUTE54,
911 PRICING_ATTRIBUTE55,
912 PRICING_ATTRIBUTE56,
913 PRICING_ATTRIBUTE57,
914 PRICING_ATTRIBUTE58,
915 PRICING_ATTRIBUTE59,
916 PRICING_ATTRIBUTE60,
917 PRICING_ATTRIBUTE61,
918 PRICING_ATTRIBUTE62,
919 PRICING_ATTRIBUTE63,
920 PRICING_ATTRIBUTE64,
921 PRICING_ATTRIBUTE65,
922 PRICING_ATTRIBUTE66,
923 PRICING_ATTRIBUTE67,
924 PRICING_ATTRIBUTE68,
925 PRICING_ATTRIBUTE69,
926 PRICING_ATTRIBUTE70,
927 PRICING_ATTRIBUTE71,
928 PRICING_ATTRIBUTE72,
929 PRICING_ATTRIBUTE73,
930 PRICING_ATTRIBUTE74,
931 PRICING_ATTRIBUTE75,
932 PRICING_ATTRIBUTE76,
933 PRICING_ATTRIBUTE77,
934 PRICING_ATTRIBUTE78,
935 PRICING_ATTRIBUTE79,
936 PRICING_ATTRIBUTE80,
937 PRICING_ATTRIBUTE81,
938 PRICING_ATTRIBUTE82,
939 PRICING_ATTRIBUTE83,
940 PRICING_ATTRIBUTE84,
941 PRICING_ATTRIBUTE85,
942 PRICING_ATTRIBUTE86,
943 PRICING_ATTRIBUTE87,
944 PRICING_ATTRIBUTE88,
945 PRICING_ATTRIBUTE89,
946 PRICING_ATTRIBUTE90,
947 PRICING_ATTRIBUTE91,
948 PRICING_ATTRIBUTE92,
949 PRICING_ATTRIBUTE93,
950 PRICING_ATTRIBUTE94,
951 PRICING_ATTRIBUTE95,
952 PRICING_ATTRIBUTE96,
953 PRICING_ATTRIBUTE97,
954 PRICING_ATTRIBUTE98,
955 PRICING_ATTRIBUTE99,
956 PRICING_ATTRIBUTE100,
957 CONTEXT,
958 ATTRIBUTE1,
959 ATTRIBUTE2,
960 ATTRIBUTE3,
961 ATTRIBUTE4,
962 ATTRIBUTE5,
963 ATTRIBUTE6,
964 ATTRIBUTE7,
965 ATTRIBUTE8,
966 ATTRIBUTE9,
967 ATTRIBUTE10,
968 ATTRIBUTE11,
969 ATTRIBUTE12,
970 ATTRIBUTE13,
971 ATTRIBUTE14,
972 ATTRIBUTE15,
973 PRICE_ATTRIBUTE_ID,
974 CREATION_DATE,
975 CREATED_BY,
976 LAST_UPDATE_DATE,
977 LAST_UPDATED_BY,
978 LAST_UPDATE_LOGIN,
979 PROGRAM_APPLICATION_ID,
980 PROGRAM_ID,
981 PROGRAM_UPDATE_DATE,
982 REQUEST_ID,
983 QUOTE_HEADER_ID,
984 QUOTE_LINE_ID,
985 FLEX_TITLE,
986 PRICING_CONTEXT,
987 PRICING_ATTRIBUTE1,
988 PRICING_ATTRIBUTE2,
989 PRICING_ATTRIBUTE3,
990 PRICING_ATTRIBUTE4,
991 PRICING_ATTRIBUTE5,
992 PRICING_ATTRIBUTE6,
993 PRICING_ATTRIBUTE7,
994 PRICING_ATTRIBUTE8,
995 PRICING_ATTRIBUTE9,
996 PRICING_ATTRIBUTE10,
997 PRICING_ATTRIBUTE11,
998 PRICING_ATTRIBUTE12,
999 PRICING_ATTRIBUTE13,
1000 PRICING_ATTRIBUTE14,
1001 PRICING_ATTRIBUTE15,
1002 PRICING_ATTRIBUTE16,
1003 PRICING_ATTRIBUTE17,
1004 PRICING_ATTRIBUTE18,
1005 PRICING_ATTRIBUTE19,
1006 PRICING_ATTRIBUTE20,
1007 PRICING_ATTRIBUTE21,
1008 PRICING_ATTRIBUTE22,
1009 PRICING_ATTRIBUTE23,
1010 PRICING_ATTRIBUTE24,
1011 PRICING_ATTRIBUTE25
1012 FROM ASO_PRICE_ATTRIBUTES
1013 WHERE PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID
1014 FOR UPDATE of PRICE_ATTRIBUTE_ID NOWAIT;
1015 Recinfo C%ROWTYPE;
1016 BEGIN
1017 OPEN C;
1018 FETCH C INTO Recinfo;
1019 If (C%NOTFOUND) then
1020 CLOSE C;
1021 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1022 APP_EXCEPTION.RAISE_EXCEPTION;
1023 End If;
1024 CLOSE C;
1025 if (
1026 /*
1027 ( Recinfo.PRICE_ATTRIBUTE_ID = p_PRICE_ATTRIBUTE_ID)
1028 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
1029 OR ( ( Recinfo.CREATION_DATE IS NULL )
1030 AND ( p_CREATION_DATE IS NULL )))
1031 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
1032 OR ( ( Recinfo.CREATED_BY IS NULL )
1033 AND ( p_CREATED_BY IS NULL )))
1034 AND
1035 */
1036 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
1037 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
1038 AND ( p_LAST_UPDATE_DATE IS NULL )))
1039 /*
1040 AND
1041 ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
1042 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
1043 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
1044 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
1045 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
1046 AND ( p_LAST_UPDATED_BY IS NULL )))
1047 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
1048 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
1049 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
1050 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
1051 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
1052 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
1053 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
1057 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
1054 OR ( ( Recinfo.PROGRAM_ID IS NULL )
1055 AND ( p_PROGRAM_ID IS NULL )))
1056 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
1058 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
1059 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
1060 OR ( ( Recinfo.REQUEST_ID IS NULL )
1061 AND ( p_REQUEST_ID IS NULL )))
1062 AND ( ( Recinfo.QUOTE_HEADER_ID = p_QUOTE_HEADER_ID)
1063 OR ( ( Recinfo.QUOTE_HEADER_ID IS NULL )
1064 AND ( p_QUOTE_HEADER_ID IS NULL )))
1065 AND ( ( Recinfo.QUOTE_LINE_ID = p_QUOTE_LINE_ID)
1066 OR ( ( Recinfo.QUOTE_LINE_ID IS NULL )
1067 AND ( p_QUOTE_LINE_ID IS NULL )))
1068 AND ( ( Recinfo.FLEX_TITLE = p_FLEX_TITLE)
1069 OR ( ( Recinfo.FLEX_TITLE IS NULL )
1070 AND ( p_FLEX_TITLE IS NULL )))
1071 AND ( ( Recinfo.PRICING_CONTEXT = p_PRICING_CONTEXT)
1072 OR ( ( Recinfo.PRICING_CONTEXT IS NULL )
1073 AND ( p_PRICING_CONTEXT IS NULL )))
1074 AND ( ( Recinfo.PRICING_ATTRIBUTE1 = p_PRICING_ATTRIBUTE1)
1075 OR ( ( Recinfo.PRICING_ATTRIBUTE1 IS NULL )
1076 AND ( p_PRICING_ATTRIBUTE1 IS NULL )))
1077 AND ( ( Recinfo.PRICING_ATTRIBUTE2 = p_PRICING_ATTRIBUTE2)
1078 OR ( ( Recinfo.PRICING_ATTRIBUTE2 IS NULL )
1079 AND ( p_PRICING_ATTRIBUTE2 IS NULL )))
1080 AND ( ( Recinfo.PRICING_ATTRIBUTE3 = p_PRICING_ATTRIBUTE3)
1081 OR ( ( Recinfo.PRICING_ATTRIBUTE3 IS NULL )
1082 AND ( p_PRICING_ATTRIBUTE3 IS NULL )))
1083 AND ( ( Recinfo.PRICING_ATTRIBUTE4 = p_PRICING_ATTRIBUTE4)
1084 OR ( ( Recinfo.PRICING_ATTRIBUTE4 IS NULL )
1085 AND ( p_PRICING_ATTRIBUTE4 IS NULL )))
1086 AND ( ( Recinfo.PRICING_ATTRIBUTE5 = p_PRICING_ATTRIBUTE5)
1087 OR ( ( Recinfo.PRICING_ATTRIBUTE5 IS NULL )
1088 AND ( p_PRICING_ATTRIBUTE5 IS NULL )))
1089 AND ( ( Recinfo.PRICING_ATTRIBUTE6 = p_PRICING_ATTRIBUTE6)
1090 OR ( ( Recinfo.PRICING_ATTRIBUTE6 IS NULL )
1091 AND ( p_PRICING_ATTRIBUTE6 IS NULL )))
1092 AND ( ( Recinfo.PRICING_ATTRIBUTE7 = p_PRICING_ATTRIBUTE7)
1093 OR ( ( Recinfo.PRICING_ATTRIBUTE7 IS NULL )
1094 AND ( p_PRICING_ATTRIBUTE7 IS NULL )))
1095 AND ( ( Recinfo.PRICING_ATTRIBUTE8 = p_PRICING_ATTRIBUTE8)
1096 OR ( ( Recinfo.PRICING_ATTRIBUTE8 IS NULL )
1097 AND ( p_PRICING_ATTRIBUTE8 IS NULL )))
1098 AND ( ( Recinfo.PRICING_ATTRIBUTE9 = p_PRICING_ATTRIBUTE9)
1099 OR ( ( Recinfo.PRICING_ATTRIBUTE9 IS NULL )
1100 AND ( p_PRICING_ATTRIBUTE9 IS NULL )))
1101 AND ( ( Recinfo.PRICING_ATTRIBUTE10 = p_PRICING_ATTRIBUTE10)
1102 OR ( ( Recinfo.PRICING_ATTRIBUTE10 IS NULL )
1103 AND ( p_PRICING_ATTRIBUTE10 IS NULL )))
1104 AND ( ( Recinfo.PRICING_ATTRIBUTE11 = p_PRICING_ATTRIBUTE11)
1105 OR ( ( Recinfo.PRICING_ATTRIBUTE11 IS NULL )
1106 AND ( p_PRICING_ATTRIBUTE11 IS NULL )))
1107 AND ( ( Recinfo.PRICING_ATTRIBUTE12 = p_PRICING_ATTRIBUTE12)
1108 OR ( ( Recinfo.PRICING_ATTRIBUTE12 IS NULL )
1109 AND ( p_PRICING_ATTRIBUTE12 IS NULL )))
1110 AND ( ( Recinfo.PRICING_ATTRIBUTE13 = p_PRICING_ATTRIBUTE13)
1111 OR ( ( Recinfo.PRICING_ATTRIBUTE13 IS NULL )
1112 AND ( p_PRICING_ATTRIBUTE13 IS NULL )))
1113 AND ( ( Recinfo.PRICING_ATTRIBUTE14 = p_PRICING_ATTRIBUTE14)
1114 OR ( ( Recinfo.PRICING_ATTRIBUTE14 IS NULL )
1115 AND ( p_PRICING_ATTRIBUTE14 IS NULL )))
1116 AND ( ( Recinfo.PRICING_ATTRIBUTE15 = p_PRICING_ATTRIBUTE15)
1117 OR ( ( Recinfo.PRICING_ATTRIBUTE15 IS NULL )
1118 AND ( p_PRICING_ATTRIBUTE15 IS NULL )))
1119 AND ( ( Recinfo.PRICING_ATTRIBUTE16 = p_PRICING_ATTRIBUTE16)
1120 OR ( ( Recinfo.PRICING_ATTRIBUTE16 IS NULL )
1121 AND ( p_PRICING_ATTRIBUTE16 IS NULL )))
1122 AND ( ( Recinfo.PRICING_ATTRIBUTE17 = p_PRICING_ATTRIBUTE17)
1123 OR ( ( Recinfo.PRICING_ATTRIBUTE17 IS NULL )
1124 AND ( p_PRICING_ATTRIBUTE17 IS NULL )))
1125 AND ( ( Recinfo.PRICING_ATTRIBUTE18 = p_PRICING_ATTRIBUTE18)
1126 OR ( ( Recinfo.PRICING_ATTRIBUTE18 IS NULL )
1127 AND ( p_PRICING_ATTRIBUTE18 IS NULL )))
1128 AND ( ( Recinfo.PRICING_ATTRIBUTE19 = p_PRICING_ATTRIBUTE19)
1129 OR ( ( Recinfo.PRICING_ATTRIBUTE19 IS NULL )
1130 AND ( p_PRICING_ATTRIBUTE19 IS NULL )))
1131 AND ( ( Recinfo.PRICING_ATTRIBUTE20 = p_PRICING_ATTRIBUTE20)
1132 OR ( ( Recinfo.PRICING_ATTRIBUTE20 IS NULL )
1133 AND ( p_PRICING_ATTRIBUTE20 IS NULL )))
1134 AND ( ( Recinfo.PRICING_ATTRIBUTE21 = p_PRICING_ATTRIBUTE21)
1135 OR ( ( Recinfo.PRICING_ATTRIBUTE21 IS NULL )
1136 AND ( p_PRICING_ATTRIBUTE21 IS NULL )))
1137 AND ( ( Recinfo.PRICING_ATTRIBUTE22 = p_PRICING_ATTRIBUTE22)
1138 OR ( ( Recinfo.PRICING_ATTRIBUTE22 IS NULL )
1139 AND ( p_PRICING_ATTRIBUTE22 IS NULL )))
1140 AND ( ( Recinfo.PRICING_ATTRIBUTE23 = p_PRICING_ATTRIBUTE23)
1141 OR ( ( Recinfo.PRICING_ATTRIBUTE23 IS NULL )
1142 AND ( p_PRICING_ATTRIBUTE23 IS NULL )))
1143 AND ( ( Recinfo.PRICING_ATTRIBUTE24 = p_PRICING_ATTRIBUTE24)
1144 OR ( ( Recinfo.PRICING_ATTRIBUTE24 IS NULL )
1145 AND ( p_PRICING_ATTRIBUTE24 IS NULL )))
1146 AND ( ( Recinfo.PRICING_ATTRIBUTE25 = p_PRICING_ATTRIBUTE25)
1147 OR ( ( Recinfo.PRICING_ATTRIBUTE25 IS NULL )
1148 AND ( p_PRICING_ATTRIBUTE25 IS NULL )))
1149 AND ( ( Recinfo.PRICING_ATTRIBUTE26 = p_PRICING_ATTRIBUTE26)
1153 OR ( ( Recinfo.PRICING_ATTRIBUTE27 IS NULL )
1150 OR ( ( Recinfo.PRICING_ATTRIBUTE26 IS NULL )
1151 AND ( p_PRICING_ATTRIBUTE26 IS NULL )))
1152 AND ( ( Recinfo.PRICING_ATTRIBUTE27 = p_PRICING_ATTRIBUTE27)
1154 AND ( p_PRICING_ATTRIBUTE27 IS NULL )))
1155 AND ( ( Recinfo.PRICING_ATTRIBUTE28 = p_PRICING_ATTRIBUTE28)
1156 OR ( ( Recinfo.PRICING_ATTRIBUTE28 IS NULL )
1157 AND ( p_PRICING_ATTRIBUTE28 IS NULL )))
1158 AND ( ( Recinfo.PRICING_ATTRIBUTE29 = p_PRICING_ATTRIBUTE29)
1159 OR ( ( Recinfo.PRICING_ATTRIBUTE29 IS NULL )
1160 AND ( p_PRICING_ATTRIBUTE29 IS NULL )))
1161 AND ( ( Recinfo.PRICING_ATTRIBUTE30 = p_PRICING_ATTRIBUTE30)
1162 OR ( ( Recinfo.PRICING_ATTRIBUTE30 IS NULL )
1163 AND ( p_PRICING_ATTRIBUTE30 IS NULL )))
1164 AND ( ( Recinfo.PRICING_ATTRIBUTE31 = p_PRICING_ATTRIBUTE31)
1165 OR ( ( Recinfo.PRICING_ATTRIBUTE31 IS NULL )
1166 AND ( p_PRICING_ATTRIBUTE31 IS NULL )))
1167 AND ( ( Recinfo.PRICING_ATTRIBUTE32 = p_PRICING_ATTRIBUTE32)
1168 OR ( ( Recinfo.PRICING_ATTRIBUTE32 IS NULL )
1169 AND ( p_PRICING_ATTRIBUTE32 IS NULL )))
1170 AND ( ( Recinfo.PRICING_ATTRIBUTE33 = p_PRICING_ATTRIBUTE33)
1171 OR ( ( Recinfo.PRICING_ATTRIBUTE33 IS NULL )
1172 AND ( p_PRICING_ATTRIBUTE33 IS NULL )))
1173 AND ( ( Recinfo.PRICING_ATTRIBUTE34 = p_PRICING_ATTRIBUTE34)
1174 OR ( ( Recinfo.PRICING_ATTRIBUTE34 IS NULL )
1175 AND ( p_PRICING_ATTRIBUTE34 IS NULL )))
1176 AND ( ( Recinfo.PRICING_ATTRIBUTE35 = p_PRICING_ATTRIBUTE35)
1177 OR ( ( Recinfo.PRICING_ATTRIBUTE35 IS NULL )
1178 AND ( p_PRICING_ATTRIBUTE35 IS NULL )))
1179 AND ( ( Recinfo.PRICING_ATTRIBUTE36 = p_PRICING_ATTRIBUTE36)
1180 OR ( ( Recinfo.PRICING_ATTRIBUTE36 IS NULL )
1181 AND ( p_PRICING_ATTRIBUTE36 IS NULL )))
1182 AND ( ( Recinfo.PRICING_ATTRIBUTE37 = p_PRICING_ATTRIBUTE37)
1183 OR ( ( Recinfo.PRICING_ATTRIBUTE37 IS NULL )
1184 AND ( p_PRICING_ATTRIBUTE37 IS NULL )))
1185 AND ( ( Recinfo.PRICING_ATTRIBUTE38 = p_PRICING_ATTRIBUTE38)
1186 OR ( ( Recinfo.PRICING_ATTRIBUTE38 IS NULL )
1187 AND ( p_PRICING_ATTRIBUTE38 IS NULL )))
1188 AND ( ( Recinfo.PRICING_ATTRIBUTE39 = p_PRICING_ATTRIBUTE39)
1189 OR ( ( Recinfo.PRICING_ATTRIBUTE39 IS NULL )
1190 AND ( p_PRICING_ATTRIBUTE39 IS NULL )))
1191 AND ( ( Recinfo.PRICING_ATTRIBUTE40 = p_PRICING_ATTRIBUTE40)
1192 OR ( ( Recinfo.PRICING_ATTRIBUTE40 IS NULL )
1193 AND ( p_PRICING_ATTRIBUTE40 IS NULL )))
1194 AND ( ( Recinfo.PRICING_ATTRIBUTE41 = p_PRICING_ATTRIBUTE41)
1195 OR ( ( Recinfo.PRICING_ATTRIBUTE41 IS NULL )
1196 AND ( p_PRICING_ATTRIBUTE41 IS NULL )))
1197 AND ( ( Recinfo.PRICING_ATTRIBUTE42 = p_PRICING_ATTRIBUTE42)
1198 OR ( ( Recinfo.PRICING_ATTRIBUTE42 IS NULL )
1199 AND ( p_PRICING_ATTRIBUTE42 IS NULL )))
1200 AND ( ( Recinfo.PRICING_ATTRIBUTE43 = p_PRICING_ATTRIBUTE43)
1201 OR ( ( Recinfo.PRICING_ATTRIBUTE43 IS NULL )
1202 AND ( p_PRICING_ATTRIBUTE43 IS NULL )))
1203 AND ( ( Recinfo.PRICING_ATTRIBUTE44 = p_PRICING_ATTRIBUTE44)
1204 OR ( ( Recinfo.PRICING_ATTRIBUTE44 IS NULL )
1205 AND ( p_PRICING_ATTRIBUTE44 IS NULL )))
1206 AND ( ( Recinfo.PRICING_ATTRIBUTE45 = p_PRICING_ATTRIBUTE45)
1207 OR ( ( Recinfo.PRICING_ATTRIBUTE45 IS NULL )
1208 AND ( p_PRICING_ATTRIBUTE45 IS NULL )))
1209 AND ( ( Recinfo.PRICING_ATTRIBUTE46 = p_PRICING_ATTRIBUTE46)
1210 OR ( ( Recinfo.PRICING_ATTRIBUTE46 IS NULL )
1211 AND ( p_PRICING_ATTRIBUTE46 IS NULL )))
1212 AND ( ( Recinfo.PRICING_ATTRIBUTE47 = p_PRICING_ATTRIBUTE47)
1213 OR ( ( Recinfo.PRICING_ATTRIBUTE47 IS NULL )
1214 AND ( p_PRICING_ATTRIBUTE47 IS NULL )))
1215 AND ( ( Recinfo.PRICING_ATTRIBUTE48 = p_PRICING_ATTRIBUTE48)
1216 OR ( ( Recinfo.PRICING_ATTRIBUTE48 IS NULL )
1217 AND ( p_PRICING_ATTRIBUTE48 IS NULL )))
1218 AND ( ( Recinfo.PRICING_ATTRIBUTE49 = p_PRICING_ATTRIBUTE49)
1219 OR ( ( Recinfo.PRICING_ATTRIBUTE49 IS NULL )
1220 AND ( p_PRICING_ATTRIBUTE49 IS NULL )))
1221 AND ( ( Recinfo.PRICING_ATTRIBUTE50 = p_PRICING_ATTRIBUTE50)
1222 OR ( ( Recinfo.PRICING_ATTRIBUTE50 IS NULL )
1223 AND ( p_PRICING_ATTRIBUTE50 IS NULL )))
1224 AND ( ( Recinfo.PRICING_ATTRIBUTE51 = p_PRICING_ATTRIBUTE51)
1225 OR ( ( Recinfo.PRICING_ATTRIBUTE51 IS NULL )
1226 AND ( p_PRICING_ATTRIBUTE51 IS NULL )))
1227 AND ( ( Recinfo.PRICING_ATTRIBUTE52 = p_PRICING_ATTRIBUTE52)
1228 OR ( ( Recinfo.PRICING_ATTRIBUTE52 IS NULL )
1229 AND ( p_PRICING_ATTRIBUTE52 IS NULL )))
1230 AND ( ( Recinfo.PRICING_ATTRIBUTE53 = p_PRICING_ATTRIBUTE53)
1231 OR ( ( Recinfo.PRICING_ATTRIBUTE53 IS NULL )
1232 AND ( p_PRICING_ATTRIBUTE53 IS NULL )))
1233 AND ( ( Recinfo.PRICING_ATTRIBUTE54 = p_PRICING_ATTRIBUTE54)
1234 OR ( ( Recinfo.PRICING_ATTRIBUTE54 IS NULL )
1235 AND ( p_PRICING_ATTRIBUTE54 IS NULL )))
1236 AND ( ( Recinfo.PRICING_ATTRIBUTE55 = p_PRICING_ATTRIBUTE55)
1237 OR ( ( Recinfo.PRICING_ATTRIBUTE55 IS NULL )
1238 AND ( p_PRICING_ATTRIBUTE55 IS NULL )))
1239 AND ( ( Recinfo.PRICING_ATTRIBUTE56 = p_PRICING_ATTRIBUTE56)
1240 OR ( ( Recinfo.PRICING_ATTRIBUTE56 IS NULL )
1241 AND ( p_PRICING_ATTRIBUTE56 IS NULL )))
1242 AND ( ( Recinfo.PRICING_ATTRIBUTE57 = p_PRICING_ATTRIBUTE57)
1246 OR ( ( Recinfo.PRICING_ATTRIBUTE58 IS NULL )
1243 OR ( ( Recinfo.PRICING_ATTRIBUTE57 IS NULL )
1244 AND ( p_PRICING_ATTRIBUTE57 IS NULL )))
1245 AND ( ( Recinfo.PRICING_ATTRIBUTE58 = p_PRICING_ATTRIBUTE58)
1247 AND ( p_PRICING_ATTRIBUTE58 IS NULL )))
1248 AND ( ( Recinfo.PRICING_ATTRIBUTE59 = p_PRICING_ATTRIBUTE59)
1249 OR ( ( Recinfo.PRICING_ATTRIBUTE59 IS NULL )
1250 AND ( p_PRICING_ATTRIBUTE59 IS NULL )))
1251 AND ( ( Recinfo.PRICING_ATTRIBUTE60 = p_PRICING_ATTRIBUTE60)
1252 OR ( ( Recinfo.PRICING_ATTRIBUTE60 IS NULL )
1253 AND ( p_PRICING_ATTRIBUTE60 IS NULL )))
1254 AND ( ( Recinfo.PRICING_ATTRIBUTE61 = p_PRICING_ATTRIBUTE61)
1255 OR ( ( Recinfo.PRICING_ATTRIBUTE61 IS NULL )
1256 AND ( p_PRICING_ATTRIBUTE61 IS NULL )))
1257 AND ( ( Recinfo.PRICING_ATTRIBUTE62 = p_PRICING_ATTRIBUTE62)
1258 OR ( ( Recinfo.PRICING_ATTRIBUTE62 IS NULL )
1259 AND ( p_PRICING_ATTRIBUTE62 IS NULL )))
1260 AND ( ( Recinfo.PRICING_ATTRIBUTE63 = p_PRICING_ATTRIBUTE63)
1261 OR ( ( Recinfo.PRICING_ATTRIBUTE63 IS NULL )
1262 AND ( p_PRICING_ATTRIBUTE63 IS NULL )))
1263 AND ( ( Recinfo.PRICING_ATTRIBUTE64 = p_PRICING_ATTRIBUTE64)
1264 OR ( ( Recinfo.PRICING_ATTRIBUTE64 IS NULL )
1265 AND ( p_PRICING_ATTRIBUTE64 IS NULL )))
1266 AND ( ( Recinfo.PRICING_ATTRIBUTE65 = p_PRICING_ATTRIBUTE65)
1267 OR ( ( Recinfo.PRICING_ATTRIBUTE65 IS NULL )
1268 AND ( p_PRICING_ATTRIBUTE65 IS NULL )))
1269 AND ( ( Recinfo.PRICING_ATTRIBUTE66 = p_PRICING_ATTRIBUTE66)
1270 OR ( ( Recinfo.PRICING_ATTRIBUTE66 IS NULL )
1271 AND ( p_PRICING_ATTRIBUTE66 IS NULL )))
1272 AND ( ( Recinfo.PRICING_ATTRIBUTE67 = p_PRICING_ATTRIBUTE67)
1273 OR ( ( Recinfo.PRICING_ATTRIBUTE67 IS NULL )
1274 AND ( p_PRICING_ATTRIBUTE67 IS NULL )))
1275 AND ( ( Recinfo.PRICING_ATTRIBUTE68 = p_PRICING_ATTRIBUTE68)
1276 OR ( ( Recinfo.PRICING_ATTRIBUTE68 IS NULL )
1277 AND ( p_PRICING_ATTRIBUTE68 IS NULL )))
1278 AND ( ( Recinfo.PRICING_ATTRIBUTE69 = p_PRICING_ATTRIBUTE69)
1279 OR ( ( Recinfo.PRICING_ATTRIBUTE69 IS NULL )
1280 AND ( p_PRICING_ATTRIBUTE69 IS NULL )))
1281 AND ( ( Recinfo.PRICING_ATTRIBUTE70 = p_PRICING_ATTRIBUTE70)
1282 OR ( ( Recinfo.PRICING_ATTRIBUTE70 IS NULL )
1283 AND ( p_PRICING_ATTRIBUTE70 IS NULL )))
1284 AND ( ( Recinfo.PRICING_ATTRIBUTE71 = p_PRICING_ATTRIBUTE71)
1285 OR ( ( Recinfo.PRICING_ATTRIBUTE71 IS NULL )
1286 AND ( p_PRICING_ATTRIBUTE71 IS NULL )))
1287 AND ( ( Recinfo.PRICING_ATTRIBUTE72 = p_PRICING_ATTRIBUTE72)
1288 OR ( ( Recinfo.PRICING_ATTRIBUTE72 IS NULL )
1289 AND ( p_PRICING_ATTRIBUTE72 IS NULL )))
1290 AND ( ( Recinfo.PRICING_ATTRIBUTE73 = p_PRICING_ATTRIBUTE73)
1291 OR ( ( Recinfo.PRICING_ATTRIBUTE73 IS NULL )
1292 AND ( p_PRICING_ATTRIBUTE73 IS NULL )))
1293 AND ( ( Recinfo.PRICING_ATTRIBUTE74 = p_PRICING_ATTRIBUTE74)
1294 OR ( ( Recinfo.PRICING_ATTRIBUTE74 IS NULL )
1295 AND ( p_PRICING_ATTRIBUTE74 IS NULL )))
1296 AND ( ( Recinfo.PRICING_ATTRIBUTE75 = p_PRICING_ATTRIBUTE75)
1297 OR ( ( Recinfo.PRICING_ATTRIBUTE75 IS NULL )
1298 AND ( p_PRICING_ATTRIBUTE75 IS NULL )))
1299 AND ( ( Recinfo.PRICING_ATTRIBUTE76 = p_PRICING_ATTRIBUTE76)
1300 OR ( ( Recinfo.PRICING_ATTRIBUTE76 IS NULL )
1301 AND ( p_PRICING_ATTRIBUTE76 IS NULL )))
1302 AND ( ( Recinfo.PRICING_ATTRIBUTE77 = p_PRICING_ATTRIBUTE77)
1303 OR ( ( Recinfo.PRICING_ATTRIBUTE77 IS NULL )
1304 AND ( p_PRICING_ATTRIBUTE77 IS NULL )))
1305 AND ( ( Recinfo.PRICING_ATTRIBUTE78 = p_PRICING_ATTRIBUTE78)
1306 OR ( ( Recinfo.PRICING_ATTRIBUTE78 IS NULL )
1307 AND ( p_PRICING_ATTRIBUTE78 IS NULL )))
1308 AND ( ( Recinfo.PRICING_ATTRIBUTE79 = p_PRICING_ATTRIBUTE79)
1309 OR ( ( Recinfo.PRICING_ATTRIBUTE79 IS NULL )
1310 AND ( p_PRICING_ATTRIBUTE79 IS NULL )))
1311 AND ( ( Recinfo.PRICING_ATTRIBUTE80 = p_PRICING_ATTRIBUTE80)
1312 OR ( ( Recinfo.PRICING_ATTRIBUTE80 IS NULL )
1313 AND ( p_PRICING_ATTRIBUTE80 IS NULL )))
1314 AND ( ( Recinfo.PRICING_ATTRIBUTE81 = p_PRICING_ATTRIBUTE81)
1315 OR ( ( Recinfo.PRICING_ATTRIBUTE81 IS NULL )
1316 AND ( p_PRICING_ATTRIBUTE81 IS NULL )))
1317 AND ( ( Recinfo.PRICING_ATTRIBUTE82 = p_PRICING_ATTRIBUTE82)
1318 OR ( ( Recinfo.PRICING_ATTRIBUTE82 IS NULL )
1319 AND ( p_PRICING_ATTRIBUTE82 IS NULL )))
1320 AND ( ( Recinfo.PRICING_ATTRIBUTE83 = p_PRICING_ATTRIBUTE83)
1321 OR ( ( Recinfo.PRICING_ATTRIBUTE83 IS NULL )
1322 AND ( p_PRICING_ATTRIBUTE83 IS NULL )))
1323 AND ( ( Recinfo.PRICING_ATTRIBUTE84 = p_PRICING_ATTRIBUTE84)
1324 OR ( ( Recinfo.PRICING_ATTRIBUTE84 IS NULL )
1325 AND ( p_PRICING_ATTRIBUTE84 IS NULL )))
1326 AND ( ( Recinfo.PRICING_ATTRIBUTE85 = p_PRICING_ATTRIBUTE85)
1327 OR ( ( Recinfo.PRICING_ATTRIBUTE85 IS NULL )
1328 AND ( p_PRICING_ATTRIBUTE85 IS NULL )))
1329 AND ( ( Recinfo.PRICING_ATTRIBUTE86 = p_PRICING_ATTRIBUTE86)
1330 OR ( ( Recinfo.PRICING_ATTRIBUTE86 IS NULL )
1331 AND ( p_PRICING_ATTRIBUTE86 IS NULL )))
1332 AND ( ( Recinfo.PRICING_ATTRIBUTE87 = p_PRICING_ATTRIBUTE87)
1333 OR ( ( Recinfo.PRICING_ATTRIBUTE87 IS NULL )
1334 AND ( p_PRICING_ATTRIBUTE87 IS NULL )))
1335 AND ( ( Recinfo.PRICING_ATTRIBUTE88 = p_PRICING_ATTRIBUTE88)
1339 OR ( ( Recinfo.PRICING_ATTRIBUTE89 IS NULL )
1336 OR ( ( Recinfo.PRICING_ATTRIBUTE88 IS NULL )
1337 AND ( p_PRICING_ATTRIBUTE88 IS NULL )))
1338 AND ( ( Recinfo.PRICING_ATTRIBUTE89 = p_PRICING_ATTRIBUTE89)
1340 AND ( p_PRICING_ATTRIBUTE89 IS NULL )))
1341 AND ( ( Recinfo.PRICING_ATTRIBUTE90 = p_PRICING_ATTRIBUTE90)
1342 OR ( ( Recinfo.PRICING_ATTRIBUTE90 IS NULL )
1343 AND ( p_PRICING_ATTRIBUTE90 IS NULL )))
1344 AND ( ( Recinfo.PRICING_ATTRIBUTE91 = p_PRICING_ATTRIBUTE91)
1345 OR ( ( Recinfo.PRICING_ATTRIBUTE91 IS NULL )
1346 AND ( p_PRICING_ATTRIBUTE91 IS NULL )))
1347 AND ( ( Recinfo.PRICING_ATTRIBUTE92 = p_PRICING_ATTRIBUTE92)
1348 OR ( ( Recinfo.PRICING_ATTRIBUTE92 IS NULL )
1349 AND ( p_PRICING_ATTRIBUTE92 IS NULL )))
1350 AND ( ( Recinfo.PRICING_ATTRIBUTE93 = p_PRICING_ATTRIBUTE93)
1351 OR ( ( Recinfo.PRICING_ATTRIBUTE93 IS NULL )
1352 AND ( p_PRICING_ATTRIBUTE93 IS NULL )))
1353 AND ( ( Recinfo.PRICING_ATTRIBUTE94 = p_PRICING_ATTRIBUTE94)
1354 OR ( ( Recinfo.PRICING_ATTRIBUTE94 IS NULL )
1355 AND ( p_PRICING_ATTRIBUTE94 IS NULL )))
1356 AND ( ( Recinfo.PRICING_ATTRIBUTE95 = p_PRICING_ATTRIBUTE95)
1357 OR ( ( Recinfo.PRICING_ATTRIBUTE95 IS NULL )
1358 AND ( p_PRICING_ATTRIBUTE95 IS NULL )))
1359 AND ( ( Recinfo.PRICING_ATTRIBUTE96 = p_PRICING_ATTRIBUTE96)
1360 OR ( ( Recinfo.PRICING_ATTRIBUTE96 IS NULL )
1361 AND ( p_PRICING_ATTRIBUTE96 IS NULL )))
1362 AND ( ( Recinfo.PRICING_ATTRIBUTE97 = p_PRICING_ATTRIBUTE97)
1363 OR ( ( Recinfo.PRICING_ATTRIBUTE97 IS NULL )
1364 AND ( p_PRICING_ATTRIBUTE97 IS NULL )))
1365 AND ( ( Recinfo.PRICING_ATTRIBUTE98 = p_PRICING_ATTRIBUTE98)
1366 OR ( ( Recinfo.PRICING_ATTRIBUTE98 IS NULL )
1367 AND ( p_PRICING_ATTRIBUTE98 IS NULL )))
1368 AND ( ( Recinfo.PRICING_ATTRIBUTE99 = p_PRICING_ATTRIBUTE99)
1369 OR ( ( Recinfo.PRICING_ATTRIBUTE99 IS NULL )
1370 AND ( p_PRICING_ATTRIBUTE99 IS NULL )))
1371 AND ( ( Recinfo.PRICING_ATTRIBUTE100 = p_PRICING_ATTRIBUTE100)
1372 OR ( ( Recinfo.PRICING_ATTRIBUTE100 IS NULL )
1373 AND ( p_PRICING_ATTRIBUTE100 IS NULL )))
1374 AND ( ( Recinfo.CONTEXT = p_CONTEXT)
1375 OR ( ( Recinfo.CONTEXT IS NULL )
1376 AND ( p_CONTEXT IS NULL )))
1377 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
1378 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
1379 AND ( p_ATTRIBUTE1 IS NULL )))
1380 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
1381 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
1382 AND ( p_ATTRIBUTE2 IS NULL )))
1383 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
1384 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
1385 AND ( p_ATTRIBUTE3 IS NULL )))
1386 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
1387 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
1388 AND ( p_ATTRIBUTE4 IS NULL )))
1389 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
1390 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
1391 AND ( p_ATTRIBUTE5 IS NULL )))
1392 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
1393 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
1394 AND ( p_ATTRIBUTE6 IS NULL )))
1395 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
1396 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
1397 AND ( p_ATTRIBUTE7 IS NULL )))
1398 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
1399 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
1400 AND ( p_ATTRIBUTE8 IS NULL )))
1401 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
1402 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
1403 AND ( p_ATTRIBUTE9 IS NULL )))
1404 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
1405 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
1406 AND ( p_ATTRIBUTE10 IS NULL )))
1407 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
1408 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
1409 AND ( p_ATTRIBUTE11 IS NULL )))
1410 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
1411 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
1412 AND ( p_ATTRIBUTE12 IS NULL )))
1413 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
1414 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
1415 AND ( p_ATTRIBUTE13 IS NULL )))
1416 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
1417 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
1418 AND ( p_ATTRIBUTE14 IS NULL )))
1419 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
1420 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
1421 AND ( p_ATTRIBUTE15 IS NULL )))
1422 */
1423 ) then
1424 return;
1425 else
1426 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1427 APP_EXCEPTION.RAISE_EXCEPTION;
1428 End If;
1429 END Lock_Row;
1430
1431 End ASO_PRICE_ATTRIBUTES_PKG;