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