[Home] [Help]
PACKAGE BODY: APPS.JL_ZZ_GL_AXI_MODEL_RANGES_PKG
Source
1 PACKAGE BODY JL_ZZ_GL_AXI_MODEL_RANGES_PKG AS
2 /* $Header: jlzzgmrb.pls 115.1 2002/11/13 23:55:46 vsidhart ship $ */
3 ------------------------------------------------------------
4 -- Insert row procedure --
5 ------------------------------------------------------------
6 PROCEDURE Insert_Row (p_rowid IN OUT NOCOPY VARCHAR2
7 , p_model_id NUMBER
8 , p_last_update_date DATE
9 , p_last_updated_by NUMBER
10 , p_creation_date DATE
11 , p_created_by NUMBER
12 , p_last_update_login NUMBER
13 , p_set_of_books_id NUMBER
14 , p_segment1_low VARCHAR2
15 , p_segment1_high VARCHAR2
16 , p_segment2_low VARCHAR2
17 , p_segment2_high VARCHAR2
18 , p_segment3_low VARCHAR2
19 , p_segment3_high VARCHAR2
20 , p_segment4_low VARCHAR2
21 , p_segment4_high VARCHAR2
22 , p_segment5_low VARCHAR2
23 , p_segment5_high VARCHAR2
24 , p_segment6_low VARCHAR2
25 , p_segment6_high VARCHAR2
26 , p_segment7_low VARCHAR2
27 , p_segment7_high VARCHAR2
28 , p_segment8_low VARCHAR2
29 , p_segment8_high VARCHAR2
30 , p_segment9_low VARCHAR2
31 , p_segment9_high VARCHAR2
32 , p_segment10_low VARCHAR2
33 , p_segment10_high VARCHAR2
34 , p_segment11_low VARCHAR2
35 , p_segment11_high VARCHAR2
36 , p_segment12_low VARCHAR2
37 , p_segment12_high VARCHAR2
38 , p_segment13_low VARCHAR2
39 , p_segment13_high VARCHAR2
40 , p_segment14_low VARCHAR2
41 , p_segment14_high VARCHAR2
42 , p_segment15_low VARCHAR2
43 , p_segment15_high VARCHAR2
44 , p_segment16_low VARCHAR2
45 , p_segment16_high VARCHAR2
46 , p_segment17_low VARCHAR2
47 , p_segment17_high VARCHAR2
48 , p_segment18_low VARCHAR2
49 , p_segment18_high VARCHAR2
50 , p_segment19_low VARCHAR2
51 , p_segment19_high VARCHAR2
52 , p_segment20_low VARCHAR2
53 , p_segment20_high VARCHAR2
54 , p_segment21_low VARCHAR2
55 , p_segment21_high VARCHAR2
56 , p_segment22_low VARCHAR2
57 , p_segment22_high VARCHAR2
58 , p_segment23_low VARCHAR2
59 , p_segment23_high VARCHAR2
60 , p_segment24_low VARCHAR2
61 , p_segment24_high VARCHAR2
62 , p_segment25_low VARCHAR2
63 , p_segment25_high VARCHAR2
64 , p_segment26_low VARCHAR2
65 , p_segment26_high VARCHAR2
66 , p_segment27_low VARCHAR2
67 , p_segment27_high VARCHAR2
68 , p_segment28_low VARCHAR2
69 , p_segment28_high VARCHAR2
70 , p_segment29_low VARCHAR2
71 , p_segment29_high VARCHAR2
72 , p_segment30_low VARCHAR2
73 , p_segment30_high VARCHAR2
74 , p_attribute_category VARCHAR2
75 , p_attribute1 VARCHAR2
76 , p_attribute2 VARCHAR2
77 , p_attribute3 VARCHAR2
78 , p_attribute4 VARCHAR2
79 , p_attribute5 VARCHAR2
80 , p_attribute6 VARCHAR2
81 , p_attribute7 VARCHAR2
82 , p_attribute8 VARCHAR2
83 , p_attribute9 VARCHAR2
84 , p_attribute10 VARCHAR2
85 , p_attribute11 VARCHAR2
86 , p_attribute12 VARCHAR2
87 , p_attribute13 VARCHAR2
88 , p_attribute14 VARCHAR2
89 , p_attribute15 VARCHAR2
90 , p_calling_sequence IN VARCHAR2) IS
91
92 ------------------------------------------------------------
93 -- Main cursor --
94 ------------------------------------------------------------
95 CURSOR C IS
96 SELECT ROWID
97 FROM jl_zz_gl_axi_model_ranges
98 WHERE model_id = p_model_id;
99
100 current_calling_sequence VARCHAR2(2000);
101 debug_info VARCHAR2(100);
102
103 BEGIN
104
105 current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.INSERT_ROW <-' ||
106 p_calling_sequence;
107
108 debug_info := 'INSERT INTO JL_ZZ_GL_AXI_MODEL_RANGES';
109
110 INSERT INTO jl_zz_gl_axi_model_ranges
111 ( model_id
112 , last_update_date
113 , last_updated_by
114 , creation_date
115 , created_by
116 , last_update_login
117 , set_of_books_id
118 , segment1_low
119 , segment1_high
120 , segment2_low
121 , segment2_high
122 , segment3_low
123 , segment3_high
124 , segment4_low
125 , segment4_high
126 , segment5_low
127 , segment5_high
128 , segment6_low
129 , segment6_high
130 , segment7_low
131 , segment7_high
132 , segment8_low
133 , segment8_high
134 , segment9_low
135 , segment9_high
136 , segment10_low
137 , segment10_high
138 , segment11_low
139 , segment11_high
140 , segment12_low
141 , segment12_high
142 , segment13_low
143 , segment13_high
144 , segment14_low
145 , segment14_high
146 , segment15_low
147 , segment15_high
148 , segment16_low
149 , segment16_high
150 , segment17_low
151 , segment17_high
152 , segment18_low
153 , segment18_high
154 , segment19_low
155 , segment19_high
156 , segment20_low
157 , segment20_high
158 , segment21_low
159 , segment21_high
160 , segment22_low
161 , segment22_high
162 , segment23_low
163 , segment23_high
164 , segment24_low
165 , segment24_high
166 , segment25_low
167 , segment25_high
168 , segment26_low
169 , segment26_high
170 , segment27_low
171 , segment27_high
172 , segment28_low
173 , segment28_high
174 , segment29_low
175 , segment29_high
176 , segment30_low
177 , segment30_high
178 , attribute_category
179 , attribute1
180 , attribute2
181 , attribute3
182 , attribute4
183 , attribute5
184 , attribute6
185 , attribute7
186 , attribute8
187 , attribute9
188 , attribute10
189 , attribute11
190 , attribute12
191 , attribute13
192 , attribute14
193 , attribute15)
194 VALUES (p_model_id
195 , p_last_update_date
196 , p_last_updated_by
197 , p_creation_date
198 , p_created_by
199 , p_last_update_login
200 , p_set_of_books_id
201 , p_segment1_low
202 , p_segment1_high
203 , p_segment2_low
204 , p_segment2_high
205 , p_segment3_low
206 , p_segment3_high
207 , p_segment4_low
208 , p_segment4_high
209 , p_segment5_low
210 , p_segment5_high
211 , p_segment6_low
212 , p_segment6_high
213 , p_segment7_low
214 , p_segment7_high
215 , p_segment8_low
216 , p_segment8_high
217 , p_segment9_low
218 , p_segment9_high
219 , p_segment10_low
220 , p_segment10_high
221 , p_segment11_low
222 , p_segment11_high
223 , p_segment12_low
224 , p_segment12_high
225 , p_segment13_low
226 , p_segment13_high
227 , p_segment14_low
228 , p_segment14_high
229 , p_segment15_low
230 , p_segment15_high
231 , p_segment16_low
232 , p_segment16_high
233 , p_segment17_low
234 , p_segment17_high
235 , p_segment18_low
236 , p_segment18_high
237 , p_segment19_low
238 , p_segment19_high
239 , p_segment20_low
240 , p_segment20_high
241 , p_segment21_low
242 , p_segment21_high
243 , p_segment22_low
244 , p_segment22_high
245 , p_segment23_low
246 , p_segment23_high
247 , p_segment24_low
248 , p_segment24_high
249 , p_segment25_low
250 , p_segment25_high
251 , p_segment26_low
252 , p_segment26_high
253 , p_segment27_low
254 , p_segment27_high
255 , p_segment28_low
256 , p_segment28_high
257 , p_segment29_low
258 , p_segment29_high
259 , p_segment30_low
260 , p_segment30_high
261 , p_attribute_category
262 , p_attribute1
263 , p_attribute2
264 , p_attribute3
265 , p_attribute4
266 , p_attribute5
267 , p_attribute6
268 , p_attribute7
269 , p_attribute8
270 , p_attribute9
271 , p_attribute10
272 , p_attribute11
273 , p_attribute12
274 , p_attribute13
275 , p_attribute14
276 , p_attribute15);
277
278 debug_info := 'OPEN CURSOR C';
279
280 OPEN c;
281
282 debug_info := 'FETCH CURSOR C';
283
284 FETCH c INTO p_rowid;
285
286 IF ( c%NOTFOUND ) THEN
287
288 debug_info := 'CLOSE CURSOR C - DATA NOTFOUND';
289 CLOSE c;
290 RAISE NO_DATA_FOUND;
291 END IF;
292
293 debug_info := 'CLOSE CURSOR C';
294 CLOSE C;
295
296 EXCEPTION
297 WHEN OTHERS THEN
298 IF (SQLCODE <> -20001) THEN
299 fnd_message.set_name('SQLGL','GL_DEBUG');
300 fnd_message.set_token('ERROR',SQLERRM);
301 fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
302 fnd_message.set_token('PARAMETERS','MODEL_ID = '||p_model_id);
303 fnd_message.set_token('DEBUG_INFO',debug_info);
304 END IF;
305
306 app_exception.raise_exception;
307
308 END Insert_Row;
309
310 ------------------------------------------------------------
311 -- Update row procedure --
312 ------------------------------------------------------------
313 PROCEDURE Update_Row (p_rowid VARCHAR2
314 , p_model_id NUMBER
315 , p_last_update_date DATE
316 , p_last_updated_by NUMBER
317 , p_creation_date DATE
318 , p_created_by NUMBER
319 , p_last_update_login NUMBER
320 , p_set_of_books_id NUMBER
321 , p_segment1_low VARCHAR2
322 , p_segment1_high VARCHAR2
323 , p_segment2_low VARCHAR2
324 , p_segment2_high VARCHAR2
325 , p_segment3_low VARCHAR2
326 , p_segment3_high VARCHAR2
327 , p_segment4_low VARCHAR2
328 , p_segment4_high VARCHAR2
329 , p_segment5_low VARCHAR2
330 , p_segment5_high VARCHAR2
331 , p_segment6_low VARCHAR2
332 , p_segment6_high VARCHAR2
333 , p_segment7_low VARCHAR2
334 , p_segment7_high VARCHAR2
335 , p_segment8_low VARCHAR2
336 , p_segment8_high VARCHAR2
337 , p_segment9_low VARCHAR2
338 , p_segment9_high VARCHAR2
339 , p_segment10_low VARCHAR2
340 , p_segment10_high VARCHAR2
341 , p_segment11_low VARCHAR2
342 , p_segment11_high VARCHAR2
343 , p_segment12_low VARCHAR2
344 , p_segment12_high VARCHAR2
345 , p_segment13_low VARCHAR2
346 , p_segment13_high VARCHAR2
347 , p_segment14_low VARCHAR2
351 , p_segment16_low VARCHAR2
348 , p_segment14_high VARCHAR2
349 , p_segment15_low VARCHAR2
350 , p_segment15_high VARCHAR2
352 , p_segment16_high VARCHAR2
353 , p_segment17_low VARCHAR2
354 , p_segment17_high VARCHAR2
355 , p_segment18_low VARCHAR2
356 , p_segment18_high VARCHAR2
357 , p_segment19_low VARCHAR2
358 , p_segment19_high VARCHAR2
359 , p_segment20_low VARCHAR2
360 , p_segment20_high VARCHAR2
361 , p_segment21_low VARCHAR2
362 , p_segment21_high VARCHAR2
363 , p_segment22_low VARCHAR2
364 , p_segment22_high VARCHAR2
365 , p_segment23_low VARCHAR2
366 , p_segment23_high VARCHAR2
367 , p_segment24_low VARCHAR2
368 , p_segment24_high VARCHAR2
369 , p_segment25_low VARCHAR2
370 , p_segment25_high VARCHAR2
371 , p_segment26_low VARCHAR2
372 , p_segment26_high VARCHAR2
373 , p_segment27_low VARCHAR2
374 , p_segment27_high VARCHAR2
375 , p_segment28_low VARCHAR2
376 , p_segment28_high VARCHAR2
377 , p_segment29_low VARCHAR2
378 , p_segment29_high VARCHAR2
379 , p_segment30_low VARCHAR2
380 , p_segment30_high VARCHAR2
381 , p_attribute_category VARCHAR2
382 , p_attribute1 VARCHAR2
383 , p_attribute2 VARCHAR2
384 , p_attribute3 VARCHAR2
385 , p_attribute4 VARCHAR2
386 , p_attribute5 VARCHAR2
387 , p_attribute6 VARCHAR2
388 , p_attribute7 VARCHAR2
389 , p_attribute8 VARCHAR2
390 , p_attribute9 VARCHAR2
391 , p_attribute10 VARCHAR2
392 , p_attribute11 VARCHAR2
393 , p_attribute12 VARCHAR2
394 , p_attribute13 VARCHAR2
395 , p_attribute14 VARCHAR2
396 , p_attribute15 VARCHAR2
397 , p_calling_sequence in VARCHAR2) IS
398
399 current_calling_sequence VARCHAR2(2000);
400 debug_info VARCHAR2(100);
401
402 BEGIN
403 current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.UPDATE_ROW <-' ||
404 p_calling_sequence;
405
406 debug_info := 'UPDATE JL_ZZ_GL_AXI_MODEL_RANGES';
407
408 UPDATE jl_zz_gl_axi_model_ranges
409 SET model_id = p_model_id
410 , last_update_date = p_last_update_date
411 , last_updated_by = p_last_updated_by
412 , creation_date = p_creation_date
413 , created_by = p_created_by
414 , last_update_login = p_last_update_login
415 , set_of_books_id = p_set_of_books_id
416 , segment1_low = p_segment1_low
417 , segment1_high = p_segment1_high
418 , segment2_low = p_segment2_low
419 , segment2_high = p_segment2_high
420 , segment3_low = p_segment3_low
421 , segment3_high = p_segment3_high
422 , segment4_low = p_segment4_low
423 , segment4_high = p_segment4_high
424 , segment5_low = p_segment5_low
425 , segment5_high = p_segment5_high
426 , segment6_low = p_segment6_low
427 , segment6_high = p_segment6_high
428 , segment7_low = p_segment7_low
429 , segment7_high = p_segment7_high
430 , segment8_low = p_segment8_low
431 , segment8_high = p_segment8_high
432 , segment9_low = p_segment9_low
433 , segment9_high = p_segment9_high
434 , segment10_low = p_segment10_low
435 , segment10_high = p_segment10_high
436 , segment11_low = p_segment11_low
437 , segment11_high = p_segment11_high
438 , segment12_low = p_segment12_low
439 , segment12_high = p_segment12_high
440 , segment13_low = p_segment13_low
441 , segment13_high = p_segment13_high
442 , segment14_low = p_segment14_low
443 , segment14_high = p_segment14_high
444 , segment15_low = p_segment15_low
445 , segment15_high = p_segment15_high
446 , segment16_low = p_segment16_low
447 , segment16_high = p_segment16_high
448 , segment17_low = p_segment17_low
449 , segment17_high = p_segment17_high
450 , segment18_low = p_segment18_low
451 , segment18_high = p_segment18_high
452 , segment19_low = p_segment19_low
453 , segment19_high = p_segment19_high
454 , segment20_low = p_segment20_low
455 , segment20_high = p_segment20_high
456 , segment21_low = p_segment21_low
460 , segment23_low = p_segment23_low
457 , segment21_high = p_segment21_high
458 , segment22_low = p_segment22_low
459 , segment22_high = p_segment22_high
461 , segment23_high = p_segment23_high
462 , segment24_low = p_segment24_low
463 , segment24_high = p_segment24_high
464 , segment25_low = p_segment25_low
465 , segment25_high = p_segment25_high
466 , segment26_low = p_segment26_low
467 , segment26_high = p_segment26_high
468 , segment27_low = p_segment27_low
469 , segment27_high = p_segment27_high
470 , segment28_low = p_segment28_low
471 , segment28_high = p_segment28_high
472 , segment29_low = p_segment29_low
473 , segment29_high = p_segment29_high
474 , segment30_low = p_segment30_low
475 , segment30_high = p_segment30_high
476 , attribute_category= p_attribute_category
477 , attribute1 = p_attribute1
478 , attribute2 = p_attribute2
479 , attribute3 = p_attribute3
480 , attribute4 = p_attribute4
481 , attribute5 = p_attribute5
482 , attribute6 = p_attribute6
483 , attribute7 = p_attribute7
484 , attribute8 = p_attribute8
485 , attribute9 = p_attribute9
486 , attribute10 = p_attribute10
487 , attribute11 = p_attribute11
488 , attribute12 = p_attribute12
489 , attribute13 = p_attribute13
490 , attribute14 = p_attribute14
491 , attribute15 = p_attribute15
492 WHERE rowid = P_Rowid;
493
494 IF (SQL%NOTFOUND) THEN
495 RAISE NO_DATA_FOUND;
496 END IF;
497
498 EXCEPTION
499 WHEN OTHERS THEN
500 IF (SQLCODE <> -20001) THEN
501 fnd_message.set_name ('SQLGL','GL_DEBUG');
502 fnd_message.set_token ('ERROR',SQLERRM);
503 fnd_message.set_token ('CALLING_SEQUENCE',current_calling_sequence);
504 fnd_message.set_token ('PARAMETERS','MODEL_ID = '||p_model_id);
505 fnd_message.set_token ('DEBUG_INFO',debug_info);
506 END IF;
507
508 app_exception.raise_exception;
509 END Update_Row;
510
511 ------------------------------------------------------------
512 -- Delete row procedure --
513 ------------------------------------------------------------
514 PROCEDURE delete_row (p_rowid VARCHAR2
515 , p_calling_sequence IN VARCHAR2) IS
516
517 current_calling_sequence VARCHAR2(2000);
518 debug_info VARCHAR2(100);
519
520 BEGIN
521 current_calling_sequence := 'JL_ZZ_GL_AXI_MODEL_RANGES_PKG.DELETE_ROW <-' ||
522 p_calling_sequence;
523
524 debug_info := 'DELETE FROM JL_ZZ_GL_AXI_MODEL_RANGES';
525
526 DELETE FROM jl_zz_gl_axi_model_ranges
527 WHERE rowid = P_Rowid;
528
529 IF (SQL%NOTFOUND) THEN
530 RAISE NO_DATA_FOUND;
531 END IF;
532
533 EXCEPTION
534 WHEN OTHERS THEN
535 IF (SQLCODE <> -20001) THEN
536 fnd_message.set_name ('SQLGL','GL_DEBUG');
537 fnd_message.set_token ('ERROR',SQLERRM);
538 fnd_message.set_token ('CALLING_SEQUENCE',CURRENT_CALLING_SEQUENCE);
539 fnd_message.set_token ('PARAMETERS','MODEL_ID = '||P_ROWID);
540 fnd_message.set_token ('DEBUG_INFO',DEBUG_INFO);
541 END IF;
542
543 app_exception.raise_exception;
544 END delete_row;
545
546 END JL_ZZ_GL_AXI_MODEL_RANGES_PKG;