[Home] [Help]
PACKAGE BODY: APPS.QP_PRICING_ATTRIBUTE_PVT
Source
1 PACKAGE BODY QP_PRICING_ATTRIBUTE_PVT as
2 /* $Header: QPXVPRAB.pls 115.0 99/10/14 18:54:28 porting ship $ */
3
4 PROCEDURE Insert_Row(
5 X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
6 , X_CREATION_DATE DATE
7 , X_CREATED_BY NUMBER
8 , X_LAST_UPDATE_DATE DATE
9 , X_LAST_UPDATED_BY NUMBER
10 , X_LAST_UPDATE_LOGIN NUMBER
11 , X_PROGRAM_APPLICATION_ID NUMBER
12 , X_PROGRAM_ID NUMBER
13 , X_PROGRAM_UPDATE_DATE DATE
14 , X_REQUEST_ID NUMBER
15 , X_LIST_LINE_ID NUMBER
16 , X_EXCLUDER_FLAG VARCHAR2
17 , X_ACCUMULATE_FLAG VARCHAR2
18 , X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
19 , X_PRODUCT_ATTRIBUTE VARCHAR2
20 , X_PRODUCT_ATTR_VALUE VARCHAR2
21 , X_PRODUCT_UOM_CODE VARCHAR2
22 , X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
23 , X_PRICING_ATTRIBUTE VARCHAR2
24 , X_PRICING_ATTR_VALUE_FROM VARCHAR2
25 , X_PRICING_ATTR_VALUE_TO VARCHAR2
26 , X_ATTRIBUTE_GROUPING_NO NUMBER
27 , X_CONTEXT VARCHAR2
28 , X_ATTRIBUTE1 VARCHAR2
29 , X_ATTRIBUTE2 VARCHAR2
30 , X_ATTRIBUTE3 VARCHAR2
31 , X_ATTRIBUTE4 VARCHAR2
32 , X_ATTRIBUTE5 VARCHAR2
33 , X_ATTRIBUTE6 VARCHAR2
34 , X_ATTRIBUTE7 VARCHAR2
35 , X_ATTRIBUTE8 VARCHAR2
36 , X_ATTRIBUTE9 VARCHAR2
37 , X_ATTRIBUTE10 VARCHAR2
38 , X_ATTRIBUTE11 VARCHAR2
39 , X_ATTRIBUTE12 VARCHAR2
40 , X_ATTRIBUTE13 VARCHAR2
41 , X_ATTRIBUTE14 VARCHAR2
42 , X_ATTRIBUTE15 VARCHAR2
43 ) IS
44
45 cursor C is select PRICING_ATTRIBUTE_ID from QP_PRICING_ATTRIBUTES
46 where PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID;
47
48
49 BEGIN
50
51
52 insert into QP_PRICING_ATTRIBUTES
53 (
54 PRICING_ATTRIBUTE_ID
55 , CREATION_DATE
56 , CREATED_BY
57 , LAST_UPDATE_DATE
58 , LAST_UPDATED_BY
59 , LAST_UPDATE_LOGIN
60 , PROGRAM_APPLICATION_ID
61 , PROGRAM_ID
62 , PROGRAM_UPDATE_DATE
63 , REQUEST_ID
64 , LIST_LINE_ID
65 , EXCLUDER_FLAG
66 , ACCUMULATE_FLAG
67 , PRODUCT_ATTRIBUTE_CONTEXT
68 , PRODUCT_ATTRIBUTE
69 , PRODUCT_ATTR_VALUE
70 , PRODUCT_UOM_CODE
71 , PRICING_ATTRIBUTE_CONTEXT
72 , PRICING_ATTRIBUTE
73 , PRICING_ATTR_VALUE_FROM
74 , PRICING_ATTR_VALUE_TO
75 , ATTRIBUTE_GROUPING_NO
76 , CONTEXT
77 , ATTRIBUTE1
78 , ATTRIBUTE2
79 , ATTRIBUTE3
80 , ATTRIBUTE4
81 , ATTRIBUTE5
82 , ATTRIBUTE6
83 , ATTRIBUTE7
84 , ATTRIBUTE8
85 , ATTRIBUTE9
86 , ATTRIBUTE10
87 , ATTRIBUTE11
88 , ATTRIBUTE12
89 , ATTRIBUTE13
90 , ATTRIBUTE14
91 , ATTRIBUTE15
92 )
93 values
94 (
95 X_PRICING_ATTRIBUTE_ID
96 , X_CREATION_DATE
97 , X_CREATED_BY
98 , X_LAST_UPDATE_DATE
99 , X_LAST_UPDATED_BY
100 , X_LAST_UPDATE_LOGIN
101 , X_PROGRAM_APPLICATION_ID
102 , X_PROGRAM_ID
103 , X_PROGRAM_UPDATE_DATE
104 , X_REQUEST_ID
105 , X_LIST_LINE_ID
106 , X_EXCLUDER_FLAG
107 , X_ACCUMULATE_FLAG
108 , X_PRODUCT_ATTRIBUTE_CONTEXT
109 , X_PRODUCT_ATTRIBUTE
110 , X_PRODUCT_ATTR_VALUE
111 , X_PRODUCT_UOM_CODE
112 , X_PRICING_ATTRIBUTE_CONTEXT
113 , X_PRICING_ATTRIBUTE
114 , X_PRICING_ATTR_VALUE_FROM
115 , X_PRICING_ATTR_VALUE_TO
116 , X_ATTRIBUTE_GROUPING_NO
117 , X_CONTEXT
118 , X_ATTRIBUTE1
119 , X_ATTRIBUTE2
120 , X_ATTRIBUTE3
121 , X_ATTRIBUTE4
122 , X_ATTRIBUTE5
123 , X_ATTRIBUTE6
124 , X_ATTRIBUTE7
125 , X_ATTRIBUTE8
126 , X_ATTRIBUTE9
127 , X_ATTRIBUTE10
128 , X_ATTRIBUTE11
129 , X_ATTRIBUTE12
130 , X_ATTRIBUTE13
131 , X_ATTRIBUTE14
132 , X_ATTRIBUTE15
133 );
134
135 open C;
136
137 fetch C into X_PRICING_ATTRIBUTE_ID;
138 if (C%notfound) then
139 close C;
140 raise NO_DATA_FOUND;
141 end if;
142 close C;
143 end Insert_Row;
144
145 PROCEDURE Lock_Row(
146 X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
147 , X_CREATION_DATE DATE
148 , X_CREATED_BY NUMBER
149 , X_LAST_UPDATE_DATE DATE
150 , X_LAST_UPDATED_BY NUMBER
151 , X_LAST_UPDATE_LOGIN NUMBER
152 , X_PROGRAM_APPLICATION_ID NUMBER
153 , X_PROGRAM_ID NUMBER
154 , X_PROGRAM_UPDATE_DATE DATE
155 , X_REQUEST_ID NUMBER
156 , X_LIST_LINE_ID NUMBER
157 , X_EXCLUDER_FLAG VARCHAR2
158 , X_ACCUMULATE_FLAG VARCHAR2
159 , X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
163 , X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
160 , X_PRODUCT_ATTRIBUTE VARCHAR2
161 , X_PRODUCT_ATTR_VALUE VARCHAR2
162 , X_PRODUCT_UOM_CODE VARCHAR2
164 , X_PRICING_ATTRIBUTE VARCHAR2
165 , X_PRICING_ATTR_VALUE_FROM VARCHAR2
166 , X_PRICING_ATTR_VALUE_TO VARCHAR2
167 , X_ATTRIBUTE_GROUPING_NO NUMBER
168 , X_CONTEXT VARCHAR2
169 , X_ATTRIBUTE1 VARCHAR2
170 , X_ATTRIBUTE2 VARCHAR2
171 , X_ATTRIBUTE3 VARCHAR2
172 , X_ATTRIBUTE4 VARCHAR2
173 , X_ATTRIBUTE5 VARCHAR2
174 , X_ATTRIBUTE6 VARCHAR2
175 , X_ATTRIBUTE7 VARCHAR2
176 , X_ATTRIBUTE8 VARCHAR2
177 , X_ATTRIBUTE9 VARCHAR2
178 , X_ATTRIBUTE10 VARCHAR2
179 , X_ATTRIBUTE11 VARCHAR2
180 , X_ATTRIBUTE12 VARCHAR2
181 , X_ATTRIBUTE13 VARCHAR2
182 , X_ATTRIBUTE14 VARCHAR2
183 , X_ATTRIBUTE15 VARCHAR2
184 ) IS
185
186
187 cursor C is select * from QP_PRICING_ATTRIBUTES
188 where PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID
189 for update of PRICING_ATTRIBUTE_ID nowait;
190 Recinfo C%ROWTYPE;
191
192
193 BEGIN
194
195 open C;
196
197 fetch C into Recinfo;
198
199 if (C%notfound) then
200
201 close C;
202 FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
203 APP_EXCEPTION.Raise_Exception;
204
205 end if;
206
207 close C;
208
209 if (
210 ( Recinfo.PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID )
211 AND ( Recinfo.LIST_LINE_ID = X_LIST_LINE_ID )
212
213 AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
214 OR ( (Recinfo.CREATION_DATE IS NULL)
215 AND (X_CREATION_DATE IS NULL)))
216
217 AND ( ( Recinfo.CREATED_BY = X_CREATED_BY)
218 OR ( (Recinfo.CREATED_BY IS NULL)
219 AND (X_CREATED_BY IS NULL)))
220
221 AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE)
222 OR ( (Recinfo.LAST_UPDATE_DATE IS NULL)
223 AND (X_LAST_UPDATE_DATE IS NULL)))
224
225 AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY)
226 OR ( (Recinfo.LAST_UPDATED_BY IS NULL)
227 AND (X_LAST_UPDATED_BY IS NULL)))
228
229 AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN)
230 OR ( (Recinfo.LAST_UPDATE_LOGIN IS NULL)
231 AND (X_LAST_UPDATE_LOGIN IS NULL)))
232
233 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID)
234 OR ( (Recinfo.PROGRAM_APPLICATION_ID IS NULL)
235 AND (X_PROGRAM_APPLICATION_ID IS NULL)))
236
237 AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID)
238 OR ( (Recinfo.PROGRAM_ID IS NULL)
239 AND (X_PROGRAM_ID IS NULL)))
240
241 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE)
242 OR ( (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
246 OR ( (Recinfo.REQUEST_ID IS NULL)
243 AND (X_PROGRAM_UPDATE_DATE IS NULL)))
244
245 AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
247 AND (X_REQUEST_ID IS NULL)))
248
249 AND ( ( Recinfo.EXCLUDER_FLAG = X_EXCLUDER_FLAG )
250 OR ( (Recinfo.EXCLUDER_FLAG IS NULL)
251 AND (X_EXCLUDER_FLAG IS NULL)))
252
253 AND ( ( Recinfo.ACCUMULATE_FLAG = X_ACCUMULATE_FLAG )
254 OR ( (Recinfo.ACCUMULATE_FLAG IS NULL)
255 AND (X_ACCUMULATE_FLAG IS NULL)))
256
257 AND ( ( Recinfo.PRODUCT_ATTRIBUTE_CONTEXT = X_PRODUCT_ATTRIBUTE_CONTEXT )
258 OR ( (Recinfo.PRODUCT_ATTRIBUTE_CONTEXT IS NULL)
259 AND (X_PRODUCT_ATTRIBUTE_CONTEXT IS NULL)))
260
261 AND ( ( Recinfo.PRODUCT_ATTRIBUTE = X_PRODUCT_ATTRIBUTE )
262 OR ( (Recinfo.PRODUCT_ATTRIBUTE IS NULL)
263 AND (X_PRODUCT_ATTRIBUTE IS NULL)))
264
265 AND ( ( Recinfo.PRODUCT_ATTR_VALUE = X_PRODUCT_ATTR_VALUE )
266 OR ( (Recinfo.PRODUCT_ATTR_VALUE IS NULL)
267 AND (X_PRODUCT_ATTR_VALUE IS NULL)))
268
269 AND ( ( Recinfo.PRODUCT_UOM_CODE = X_PRODUCT_UOM_CODE )
270 OR ( (Recinfo.PRODUCT_UOM_CODE IS NULL)
271 AND (X_PRODUCT_UOM_CODE IS NULL)))
272
273 AND ( ( Recinfo.PRICING_ATTRIBUTE_CONTEXT = X_PRICING_ATTRIBUTE_CONTEXT )
274 OR ( (Recinfo.PRICING_ATTRIBUTE_CONTEXT IS NULL)
275 AND (X_PRICING_ATTRIBUTE_CONTEXT IS NULL)))
276
277 AND ( ( Recinfo.PRICING_ATTRIBUTE = X_PRICING_ATTRIBUTE )
278 OR ( (Recinfo.PRICING_ATTRIBUTE IS NULL)
279 AND (X_PRICING_ATTRIBUTE IS NULL)))
280
281 AND ( ( Recinfo.PRICING_ATTR_VALUE_FROM = X_PRICING_ATTR_VALUE_FROM )
282 OR ( (Recinfo.PRICING_ATTR_VALUE_FROM IS NULL)
283 AND (X_PRICING_ATTR_VALUE_FROM IS NULL)))
284
285 AND ( ( Recinfo.PRICING_ATTR_VALUE_TO = X_PRICING_ATTR_VALUE_TO )
286 OR ( (Recinfo.PRICING_ATTR_VALUE_TO IS NULL)
287 AND (X_PRICING_ATTR_VALUE_TO IS NULL)))
288
289 AND ( ( Recinfo.ATTRIBUTE_GROUPING_NO = X_ATTRIBUTE_GROUPING_NO )
290 OR ( (Recinfo.ATTRIBUTE_GROUPING_NO IS NULL)
291 AND (X_ATTRIBUTE_GROUPING_NO IS NULL)))
292
293 AND ( ( Recinfo.CONTEXT = X_CONTEXT )
294 OR ( (Recinfo.CONTEXT IS NULL)
295 AND (X_CONTEXT IS NULL)))
296
297 AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
298 OR ( (Recinfo.ATTRIBUTE1 IS NULL)
299 AND (X_ATTRIBUTE1 IS NULL)))
300
301 AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
302 OR ( (Recinfo.ATTRIBUTE2 IS NULL)
303 AND (X_ATTRIBUTE2 IS NULL)))
304
305 AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
306 OR ( (Recinfo.ATTRIBUTE3 IS NULL)
307 AND (X_ATTRIBUTE3 IS NULL)))
308
309 AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
310 OR ( (Recinfo.ATTRIBUTE4 IS NULL)
311 AND (X_ATTRIBUTE4 IS NULL)))
312
313 AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
314 OR ( (Recinfo.ATTRIBUTE5 IS NULL)
315 AND (X_ATTRIBUTE5 IS NULL)))
316
317 AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
318 OR ( (Recinfo.ATTRIBUTE6 IS NULL)
319 AND (X_ATTRIBUTE6 IS NULL)))
320
321 AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
322 OR ( (Recinfo.ATTRIBUTE7 IS NULL)
323 AND (X_ATTRIBUTE7 IS NULL)))
324
325 AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
326 OR ( (Recinfo.ATTRIBUTE8 IS NULL)
327 AND (X_ATTRIBUTE8 IS NULL)))
328
329 AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
330 OR ( (Recinfo.ATTRIBUTE9 IS NULL)
331 AND (X_ATTRIBUTE9 IS NULL)))
332
333 AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
334 OR ( (Recinfo.ATTRIBUTE10 IS NULL)
335 AND (X_ATTRIBUTE10 IS NULL)))
336
337 AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
338 OR ( (Recinfo.ATTRIBUTE11 IS NULL)
339 AND (X_ATTRIBUTE11 IS NULL)))
340
341 AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
342 OR ( (Recinfo.ATTRIBUTE12 IS NULL)
346 OR ( (Recinfo.ATTRIBUTE13 IS NULL)
343 AND (X_ATTRIBUTE12 IS NULL)))
344
345 AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
347 AND (X_ATTRIBUTE13 IS NULL)))
348
349 AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
350 OR ( (Recinfo.ATTRIBUTE14 IS NULL)
351 AND (X_ATTRIBUTE14 IS NULL)))
352
353 AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
354 OR ( (Recinfo.ATTRIBUTE15 IS NULL)
355 AND (X_ATTRIBUTE15 IS NULL)))
356
357 ) then
358
359 return;
360
361 else
362
363 FND_MESSAGE.Set_Name('FND','FORM_RECORD_CHANGED');
364 APP_EXCEPTION.Raise_Exception;
365
366 end if;
367
368 end Lock_Row;
369
370
371 PROCEDURE Update_Row(
372 X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
373 , X_CREATION_DATE DATE
374 , X_CREATED_BY NUMBER
375 , X_LAST_UPDATE_DATE DATE
376 , X_LAST_UPDATED_BY NUMBER
377 , X_LAST_UPDATE_LOGIN NUMBER
378 , X_PROGRAM_APPLICATION_ID NUMBER
379 , X_PROGRAM_ID NUMBER
380 , X_PROGRAM_UPDATE_DATE DATE
381 , X_REQUEST_ID NUMBER
382 , X_LIST_LINE_ID NUMBER
383 , X_EXCLUDER_FLAG VARCHAR2
384 , X_ACCUMULATE_FLAG VARCHAR2
385 , X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
386 , X_PRODUCT_ATTRIBUTE VARCHAR2
387 , X_PRODUCT_ATTR_VALUE VARCHAR2
388 , X_PRODUCT_UOM_CODE VARCHAR2
389 , X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
390 , X_PRICING_ATTRIBUTE VARCHAR2
391 , X_PRICING_ATTR_VALUE_FROM VARCHAR2
392 , X_PRICING_ATTR_VALUE_TO VARCHAR2
393 , X_ATTRIBUTE_GROUPING_NO NUMBER
394 , X_CONTEXT VARCHAR2
395 , X_ATTRIBUTE1 VARCHAR2
396 , X_ATTRIBUTE2 VARCHAR2
397 , X_ATTRIBUTE3 VARCHAR2
398 , X_ATTRIBUTE4 VARCHAR2
399 , X_ATTRIBUTE5 VARCHAR2
400 , X_ATTRIBUTE6 VARCHAR2
401 , X_ATTRIBUTE7 VARCHAR2
402 , X_ATTRIBUTE8 VARCHAR2
403 , X_ATTRIBUTE9 VARCHAR2
404 , X_ATTRIBUTE10 VARCHAR2
405 , X_ATTRIBUTE11 VARCHAR2
406 , X_ATTRIBUTE12 VARCHAR2
407 , X_ATTRIBUTE13 VARCHAR2
408 , X_ATTRIBUTE14 VARCHAR2
409 , X_ATTRIBUTE15 VARCHAR2
410 ) IS
411 begin
412
413 UPDATE QP_PRICING_ATTRIBUTES
414 SET
415 PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID
416 , CREATION_DATE = X_CREATION_DATE
417 , CREATED_BY = X_CREATED_BY
418 , LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
419 , LAST_UPDATED_BY = X_LAST_UPDATED_BY
420 , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
421 , PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID
422 , PROGRAM_ID = X_PROGRAM_ID
423 , PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
424 , REQUEST_ID = X_REQUEST_ID
425 , LIST_LINE_ID = X_LIST_LINE_ID
426 , EXCLUDER_FLAG = X_EXCLUDER_FLAG
427 , ACCUMULATE_FLAG = X_ACCUMULATE_FLAG
428 , PRODUCT_ATTRIBUTE_CONTEXT = X_PRODUCT_ATTRIBUTE_CONTEXT
429 , PRODUCT_ATTRIBUTE = X_PRODUCT_ATTRIBUTE
430 , PRODUCT_ATTR_VALUE = X_PRODUCT_ATTR_VALUE
431 , PRODUCT_UOM_CODE = X_PRODUCT_UOM_CODE
432 , PRICING_ATTRIBUTE_CONTEXT = X_PRICING_ATTRIBUTE_CONTEXT
433 , PRICING_ATTRIBUTE = X_PRICING_ATTRIBUTE
434 , PRICING_ATTR_VALUE_FROM = X_PRICING_ATTR_VALUE_FROM
435 , PRICING_ATTR_VALUE_TO = X_PRICING_ATTR_VALUE_TO
436 , ATTRIBUTE_GROUPING_NO = X_ATTRIBUTE_GROUPING_NO
437 , CONTEXT = X_CONTEXT
438 , ATTRIBUTE1 = X_ATTRIBUTE1
439 , ATTRIBUTE2 = X_ATTRIBUTE2
440 , ATTRIBUTE3 = X_ATTRIBUTE3
441 , ATTRIBUTE4 = X_ATTRIBUTE4
442 , ATTRIBUTE5 = X_ATTRIBUTE5
443 , ATTRIBUTE6 = X_ATTRIBUTE6
444 , ATTRIBUTE7 = X_ATTRIBUTE7
445 , ATTRIBUTE8 = X_ATTRIBUTE8
446 , ATTRIBUTE9 = X_ATTRIBUTE9
447 , ATTRIBUTE10 = X_ATTRIBUTE10
448 , ATTRIBUTE11 = X_ATTRIBUTE11
449 , ATTRIBUTE12 = X_ATTRIBUTE12
450 , ATTRIBUTE13 = X_ATTRIBUTE13
451 , ATTRIBUTE14 = X_ATTRIBUTE14
452 , ATTRIBUTE15 = X_ATTRIBUTE15
453 WHERE PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID;
454
455 if (sql%notfound) then
456 raise no_data_found;
457 end if;
458
459 END Update_Row;
460
461
462
463
464 PROCEDURE Delete_Row(
465 X_LIST_LINE_ID NUMBER
466 ) IS
467 begin
468
469 delete from QP_PRICING_ATTRIBUTES
470 where LIST_LINE_ID = LIST_LINE_ID;
471
472 if (SQL%NOTFOUND) then
473 Raise NO_DATA_FOUND;
474 end if;
475
476
477 END Delete_Row;
478
479
480
481
482 END QP_PRICING_ATTRIBUTE_PVT;