[Home] [Help]
PACKAGE BODY: APPS.IGI_IGI_ITR_CHARGE_RANGES_PKG
Source
1 PACKAGE BODY IGI_IGI_ITR_CHARGE_RANGES_PKG as
2 -- $Header: igiitrfb.pls 120.6.12000000.1 2007/09/12 10:30:56 mbremkum ship $
3 --
4
5 l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6 l_state_level number := FND_LOG.LEVEL_STATEMENT;
7 l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
8 l_event_level number := FND_LOG.LEVEL_EVENT;
9 l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
10 l_error_level number := FND_LOG.LEVEL_ERROR;
11 l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
12
13
14 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
15 X_Charge_Range_Id IN OUT NOCOPY NUMBER,
16 X_Charge_Center_Id NUMBER,
17 X_Segment1_Low VARCHAR2,
18 X_Segment1_High VARCHAR2,
19 X_Segment2_Low VARCHAR2,
20 X_Segment2_High VARCHAR2,
21 X_Segment3_Low VARCHAR2,
22 X_Segment3_High VARCHAR2,
23 X_Segment4_Low VARCHAR2,
24 X_Segment4_High VARCHAR2,
25 X_Segment5_Low VARCHAR2,
26 X_Segment5_High VARCHAR2,
27 X_Segment6_Low VARCHAR2,
28 X_Segment6_High VARCHAR2,
29 X_Segment7_Low VARCHAR2,
30 X_Segment7_High VARCHAR2,
31 X_Segment8_Low VARCHAR2,
32 X_Segment8_High VARCHAR2,
33 X_Segment9_Low VARCHAR2,
34 X_Segment9_High VARCHAR2,
35 X_Segment10_Low VARCHAR2,
36 X_Segment10_High VARCHAR2,
37 X_Segment11_Low VARCHAR2,
38 X_Segment11_High VARCHAR2,
39 X_Segment12_Low VARCHAR2,
40 X_Segment12_High VARCHAR2,
41 X_Segment13_Low VARCHAR2,
42 X_Segment13_High VARCHAR2,
43 X_Segment14_Low VARCHAR2,
44 X_Segment14_High VARCHAR2,
45 X_Segment15_Low VARCHAR2,
46 X_Segment15_High VARCHAR2,
47 X_Segment16_Low VARCHAR2,
48 X_Segment16_High VARCHAR2,
49 X_Segment17_Low VARCHAR2,
50 X_Segment17_High VARCHAR2,
51 X_Segment18_Low VARCHAR2,
52 X_Segment18_High VARCHAR2,
53 X_Segment19_Low VARCHAR2,
54 X_Segment19_High VARCHAR2,
55 X_Segment20_Low VARCHAR2,
56 X_Segment20_High VARCHAR2,
57 X_Segment21_Low VARCHAR2,
58 X_Segment21_High VARCHAR2,
59 X_Segment22_Low VARCHAR2,
60 X_Segment22_High VARCHAR2,
61 X_Segment23_Low VARCHAR2,
62 X_Segment23_High VARCHAR2,
63 X_Segment24_Low VARCHAR2,
64 X_Segment24_High VARCHAR2,
65 X_Segment25_Low VARCHAR2,
66 X_Segment25_High VARCHAR2,
67 X_Segment26_Low VARCHAR2,
68 X_Segment26_High VARCHAR2,
69 X_Segment27_Low VARCHAR2,
70 X_Segment27_High VARCHAR2,
71 X_Segment28_Low VARCHAR2,
72 X_Segment28_High VARCHAR2,
73 X_Segment29_Low VARCHAR2,
74 X_Segment29_High VARCHAR2,
75 X_Segment30_Low VARCHAR2,
76 X_Segment30_High VARCHAR2,
77 X_Creation_Date DATE,
78 X_Created_By NUMBER,
79 X_Last_Update_Date DATE,
80 X_Last_Updated_By NUMBER,
81 X_Last_Update_Login NUMBER
82 ) IS
83 CURSOR C IS SELECT rowid FROM IGI_ITR_CHARGE_RANGES
84 WHERE charge_range_id = X_Charge_Range_Id
85 AND charge_center_id = X_Charge_Center_Id;
86 CURSOR C2 IS SELECT IGI_IGI_itr_charge_ranges_s.nextval FROM sys.dual;
87 BEGIN
88 if (X_Charge_Range_Id is NULL) then
89 OPEN C2;
90 FETCH C2 INTO X_Charge_Range_Id;
91 CLOSE C2;
92 end if;
93 INSERT INTO IGI_ITR_CHARGE_RANGES(
94 charge_range_id,
95 charge_center_id,
96 segment1_low,
97 segment1_high,
98 segment2_low,
99 segment2_high,
100 segment3_low,
101 segment3_high,
102 segment4_low,
103 segment4_high,
104 segment5_low,
105 segment5_high,
106 segment6_low,
107 segment6_high,
108 segment7_low,
109 segment7_high,
110 segment8_low,
111 segment8_high,
112 segment9_low,
113 segment9_high,
114 segment10_low,
115 segment10_high,
116 segment11_low,
117 segment11_high,
118 segment12_low,
119 segment12_high,
120 segment13_low,
121 segment13_high,
122 segment14_low,
123 segment14_high,
124 segment15_low,
125 segment15_high,
126 segment16_low,
127 segment16_high,
128 segment17_low,
129 segment17_high,
130 segment18_low,
131 segment18_high,
132 segment19_low,
133 segment19_high,
134 segment20_low,
135 segment20_high,
136 segment21_low,
137 segment21_high,
138 segment22_low,
139 segment22_high,
140 segment23_low,
141 segment23_high,
142 segment24_low,
143 segment24_high,
144 segment25_low,
145 segment25_high,
146 segment26_low,
147 segment26_high,
148 segment27_low,
149 segment27_high,
150 segment28_low,
151 segment28_high,
152 segment29_low,
153 segment29_high,
154 segment30_low,
155 segment30_high,
156 creation_date,
157 created_by,
158 last_update_date,
159 last_updated_by,
160 last_update_login
161 ) VALUES (
162 X_Charge_Range_Id,
163 X_Charge_Center_Id,
164 X_Segment1_Low,
165 X_Segment1_High,
166 X_Segment2_Low,
167 X_Segment2_High,
168 X_Segment3_Low,
169 X_Segment3_High,
170 X_Segment4_Low,
171 X_Segment4_High,
172 X_Segment5_Low,
173 X_Segment5_High,
174 X_Segment6_Low,
175 X_Segment6_High,
176 X_Segment7_Low,
177 X_Segment7_High,
178 X_Segment8_Low,
179 X_Segment8_High,
180 X_Segment9_Low,
181 X_Segment9_High,
182 X_Segment10_Low,
183 X_Segment10_High,
184 X_Segment11_Low,
185 X_Segment11_High,
186 X_Segment12_Low,
187 X_Segment12_High,
188 X_Segment13_Low,
189 X_Segment13_High,
190 X_Segment14_Low,
191 X_Segment14_High,
192 X_Segment15_Low,
193 X_Segment15_High,
194 X_Segment16_Low,
195 X_Segment16_High,
196 X_Segment17_Low,
197 X_Segment17_High,
198 X_Segment18_Low,
199 X_Segment18_High,
200 X_Segment19_Low,
201 X_Segment19_High,
202 X_Segment20_Low,
203 X_Segment20_High,
204 X_Segment21_Low,
205 X_Segment21_High,
206 X_Segment22_Low,
207 X_Segment22_High,
208 X_Segment23_Low,
209 X_Segment23_High,
210 X_Segment24_Low,
211 X_Segment24_High,
212 X_Segment25_Low,
213 X_Segment25_High,
214 X_Segment26_Low,
215 X_Segment26_High,
216 X_Segment27_Low,
217 X_Segment27_High,
218 X_Segment28_Low,
219 X_Segment28_High,
220 X_Segment29_Low,
221 X_Segment29_High,
222 X_Segment30_Low,
223 X_Segment30_High,
224 X_Creation_Date,
225 X_Created_By,
226 X_Last_Update_Date,
227 X_Last_Updated_By,
228 X_Last_Update_Login
229 );
230 OPEN C;
231 FETCH C INTO X_Rowid;
232 if (C%NOTFOUND) then
233 CLOSE C;
234 Raise NO_DATA_FOUND;
235 end if;
236 CLOSE C;
237 END Insert_Row;
238
239
240 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
241 X_Charge_Range_Id NUMBER,
242 X_Charge_Center_Id NUMBER,
243 X_Segment1_Low VARCHAR2,
244 X_Segment1_High VARCHAR2,
245 X_Segment2_Low VARCHAR2,
246 X_Segment2_High VARCHAR2,
247 X_Segment3_Low VARCHAR2,
248 X_Segment3_High VARCHAR2,
249 X_Segment4_Low VARCHAR2,
250 X_Segment4_High VARCHAR2,
251 X_Segment5_Low VARCHAR2,
252 X_Segment5_High VARCHAR2,
253 X_Segment6_Low VARCHAR2,
254 X_Segment6_High VARCHAR2,
255 X_Segment7_Low VARCHAR2,
256 X_Segment7_High VARCHAR2,
257 X_Segment8_Low VARCHAR2,
258 X_Segment8_High VARCHAR2,
259 X_Segment9_Low VARCHAR2,
260 X_Segment9_High VARCHAR2,
261 X_Segment10_Low VARCHAR2,
262 X_Segment10_High VARCHAR2,
263 X_Segment11_Low VARCHAR2,
264 X_Segment11_High VARCHAR2,
265 X_Segment12_Low VARCHAR2,
266 X_Segment12_High VARCHAR2,
267 X_Segment13_Low VARCHAR2,
268 X_Segment13_High VARCHAR2,
269 X_Segment14_Low VARCHAR2,
270 X_Segment14_High VARCHAR2,
271 X_Segment15_Low VARCHAR2,
272 X_Segment15_High VARCHAR2,
273 X_Segment16_Low VARCHAR2,
274 X_Segment16_High VARCHAR2,
275 X_Segment17_Low VARCHAR2,
276 X_Segment17_High VARCHAR2,
277 X_Segment18_Low VARCHAR2,
278 X_Segment18_High VARCHAR2,
279 X_Segment19_Low VARCHAR2,
280 X_Segment19_High VARCHAR2,
281 X_Segment20_Low VARCHAR2,
282 X_Segment20_High VARCHAR2,
283 X_Segment21_Low VARCHAR2,
284 X_Segment21_High VARCHAR2,
285 X_Segment22_Low VARCHAR2,
289 X_Segment24_Low VARCHAR2,
286 X_Segment22_High VARCHAR2,
287 X_Segment23_Low VARCHAR2,
288 X_Segment23_High VARCHAR2,
290 X_Segment24_High VARCHAR2,
291 X_Segment25_Low VARCHAR2,
292 X_Segment25_High VARCHAR2,
293 X_Segment26_Low VARCHAR2,
294 X_Segment26_High VARCHAR2,
295 X_Segment27_Low VARCHAR2,
296 X_Segment27_High VARCHAR2,
297 X_Segment28_Low VARCHAR2,
298 X_Segment28_High VARCHAR2,
299 X_Segment29_Low VARCHAR2,
300 X_Segment29_High VARCHAR2,
301 X_Segment30_Low VARCHAR2,
302 X_Segment30_High VARCHAR2
303 ) IS
304
305 CURSOR C IS
306 SELECT *
307 FROM IGI_ITR_CHARGE_RANGES
308 WHERE rowid = X_Rowid
309 FOR UPDATE of Charge_Range_Id NOWAIT;
310 Recinfo C%ROWTYPE;
311
312 BEGIN
313 OPEN C;
314 FETCH C INTO Recinfo;
315 if (C%NOTFOUND) then
316 CLOSE C;
317 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
318
319 IF ( l_excep_level >= l_debug_level) THEN
320 FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrfb.IGI_IGI_ITR_CHARGE_RANGES_PKG.lock_row.msg1', FALSE);
321 END IF;
322
323 APP_EXCEPTION.Raise_Exception;
324 end if;
325 CLOSE C;
326 if (
327 (Recinfo.charge_range_id = X_Charge_Range_Id)
328 AND (Recinfo.charge_center_id = X_Charge_Center_Id)
329 AND ( NVL(Recinfo.segment1_low,'x') = nvl(X_Segment1_Low,'x'))
330 AND (nvl(Recinfo.segment1_high,'x') = nvl(X_Segment1_High,'x'))
331 AND (nvl(Recinfo.segment2_low,'x') = nvl(X_Segment2_Low,'x'))
332 AND (nvl(Recinfo.segment2_high,'x') = nvl(X_Segment2_High,'x'))
333 AND (nvl(Recinfo.segment3_low,'x') = nvl(X_Segment3_Low,'x'))
334 AND (nvl(Recinfo.segment3_high,'x') = nvl(X_Segment3_High,'x'))
335 AND (nvl(Recinfo.segment4_low,'x') = nvl(X_Segment4_Low,'x'))
336 AND (nvl(Recinfo.segment4_high,'x') = nvl(X_Segment4_High,'x'))
337 AND (nvl(Recinfo.segment5_low,'x') = nvl(X_Segment5_Low,'x'))
338 AND (nvl(Recinfo.segment5_high,'x') = nvl(X_Segment5_High,'x'))
339 AND (nvl(Recinfo.segment6_low,'x') = nvl(X_Segment6_Low,'x'))
340 AND (nvl(Recinfo.segment6_high,'x') = nvl(X_Segment6_High,'x'))
341 AND (nvl(Recinfo.segment7_low,'x') = nvl(X_Segment7_Low,'x'))
342 AND (nvl(Recinfo.segment7_high,'x') = nvl(X_Segment7_High,'x'))
343 AND (nvl(Recinfo.segment8_low,'x') = nvl(X_Segment8_Low,'x'))
344 AND (nvl(Recinfo.segment8_high,'x') = nvl(X_Segment8_High,'x'))
345 AND (nvl(Recinfo.segment9_low,'x') = nvl(X_Segment9_Low,'x'))
346 AND (nvl(Recinfo.segment9_high,'x') = nvl(X_Segment9_High,'x'))
347 AND (nvl(Recinfo.segment10_low,'x') = nvl(X_Segment10_Low,'x'))
348 AND (nvl(Recinfo.segment10_high,'x') = nvl(X_Segment10_High,'x'))
349 AND (nvl(Recinfo.segment11_low,'x') = nvl(X_Segment11_Low,'x'))
350 AND (nvl(Recinfo.segment11_high,'x') = nvl(X_Segment11_High,'x'))
351 AND (nvl(Recinfo.segment12_low,'x') = nvl(X_Segment12_Low,'x'))
352 AND (nvl(Recinfo.segment12_high,'x') = nvl(X_Segment12_High,'x'))
353 AND (nvl(Recinfo.segment13_low,'x') = nvl(X_Segment13_Low,'x'))
354 AND (nvl(Recinfo.segment13_high,'x') = nvl(X_Segment13_High,'x'))
355 AND (nvl(Recinfo.segment14_low,'x') = nvl(X_Segment14_Low,'x'))
356 AND (nvl(Recinfo.segment14_high,'x') = nvl(X_Segment14_High,'x'))
357 AND (nvl(Recinfo.segment15_low,'x') = nvl(X_Segment15_Low,'x'))
358 AND (nvl(Recinfo.segment15_high,'x') = nvl(X_Segment15_High,'x'))
359 AND (nvl(Recinfo.segment16_low,'x') = nvl(X_Segment16_Low,'x'))
360 AND (nvl(Recinfo.segment16_high,'x') = nvl(X_Segment16_High,'x'))
361 AND (nvl(Recinfo.segment17_low,'x') = nvl(X_Segment17_Low,'x'))
362 AND (nvl(Recinfo.segment17_high,'x') = nvl(X_Segment17_High,'x'))
363 AND (nvl(Recinfo.segment18_low,'x') = nvl(X_Segment18_Low,'x'))
364 AND (nvl(Recinfo.segment18_high,'x') = nvl(X_Segment18_High,'x'))
365 AND (nvl(Recinfo.segment19_low,'x') = nvl(X_Segment19_Low,'x'))
366 AND (nvl(Recinfo.segment19_high,'x') = nvl(X_Segment19_High,'x'))
367 AND (nvl(Recinfo.segment20_low,'x') = nvl(X_Segment20_Low,'x'))
368 AND (nvl(Recinfo.segment20_high,'x') = nvl(X_Segment20_High,'x'))
369 AND (nvl(Recinfo.segment21_low,'x') = nvl(X_Segment21_Low,'x'))
370 AND (nvl(Recinfo.segment21_high,'x') = nvl(X_Segment21_High,'x'))
371 AND (nvl(Recinfo.segment22_low,'x') = nvl(X_Segment22_Low,'x'))
372 AND (nvl(Recinfo.segment22_high,'x') = nvl(X_Segment22_High,'x'))
373 AND (nvl(Recinfo.segment23_low,'x') = nvl(X_Segment23_Low,'x'))
374 AND (nvl(Recinfo.segment23_high,'x') = nvl(X_Segment23_High,'x'))
375 AND (nvl(Recinfo.segment24_low,'x') = nvl(X_Segment24_Low,'x'))
376 AND (nvl(Recinfo.segment24_high,'x') = nvl(X_Segment24_High,'x'))
377 AND (nvl(Recinfo.segment25_low,'x') = nvl(X_Segment25_Low,'x'))
378 AND (nvl(Recinfo.segment25_high,'x') = nvl(X_Segment25_High,'x'))
379 AND (nvl(Recinfo.segment26_low,'x') = nvl(X_Segment26_Low,'x'))
380 AND (nvl(Recinfo.segment26_high,'x') = nvl(X_Segment26_High,'x'))
381 AND (nvl(Recinfo.segment27_low,'x') = nvl(X_Segment27_Low,'x'))
385 AND (nvl(Recinfo.segment29_low,'x') = nvl(X_Segment29_Low,'x'))
382 AND (nvl(Recinfo.segment27_high,'x') = nvl(X_Segment27_High,'x'))
383 AND (nvl(Recinfo.segment28_low,'x') = nvl(X_Segment28_Low,'x'))
384 AND (nvl(Recinfo.segment28_high,'x') = nvl(X_Segment28_High,'x'))
386 AND (nvl(Recinfo.segment29_high,'x') = nvl(X_Segment29_High,'x'))
387 ) then
388 if(
389 (nvl(Recinfo.segment30_low,'x') = nvl(X_Segment30_Low,'x'))
390 AND (nvl(Recinfo.segment30_high,'x') = nvl(X_Segment30_High,'x'))
391 ) then
392 return;
393 else
394 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
395
396 IF ( l_excep_level >= l_debug_level) THEN
397 FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrfb.IGI_IGI_ITR_CHARGE_RANGES_PKG.lock_row.msg2', FALSE);
398 end if;
399 END IF;
400
401 APP_EXCEPTION.Raise_Exception;
402 end if;
403 END Lock_Row;
404
405 PROCEDURE Update_Row(X_Rowid VARCHAR2,
406 X_Charge_Range_Id NUMBER,
407 X_Charge_Center_Id NUMBER,
408 X_Segment1_Low VARCHAR2,
409 X_Segment1_High VARCHAR2,
410 X_Segment2_Low VARCHAR2,
411 X_Segment2_High VARCHAR2,
412 X_Segment3_Low VARCHAR2,
413 X_Segment3_High VARCHAR2,
414 X_Segment4_Low VARCHAR2,
415 X_Segment4_High VARCHAR2,
416 X_Segment5_Low VARCHAR2,
417 X_Segment5_High VARCHAR2,
418 X_Segment6_Low VARCHAR2,
419 X_Segment6_High VARCHAR2,
420 X_Segment7_Low VARCHAR2,
421 X_Segment7_High VARCHAR2,
422 X_Segment8_Low VARCHAR2,
423 X_Segment8_High VARCHAR2,
424 X_Segment9_Low VARCHAR2,
425 X_Segment9_High VARCHAR2,
426 X_Segment10_Low VARCHAR2,
427 X_Segment10_High VARCHAR2,
428 X_Segment11_Low VARCHAR2,
429 X_Segment11_High VARCHAR2,
430 X_Segment12_Low VARCHAR2,
431 X_Segment12_High VARCHAR2,
432 X_Segment13_Low VARCHAR2,
433 X_Segment13_High VARCHAR2,
434 X_Segment14_Low VARCHAR2,
435 X_Segment14_High VARCHAR2,
436 X_Segment15_Low VARCHAR2,
437 X_Segment15_High VARCHAR2,
438 X_Segment16_Low VARCHAR2,
439 X_Segment16_High VARCHAR2,
440 X_Segment17_Low VARCHAR2,
441 X_Segment17_High VARCHAR2,
442 X_Segment18_Low VARCHAR2,
443 X_Segment18_High VARCHAR2,
444 X_Segment19_Low VARCHAR2,
445 X_Segment19_High VARCHAR2,
446 X_Segment20_Low VARCHAR2,
447 X_Segment20_High VARCHAR2,
448 X_Segment21_Low VARCHAR2,
449 X_Segment21_High VARCHAR2,
450 X_Segment22_Low VARCHAR2,
451 X_Segment22_High VARCHAR2,
452 X_Segment23_Low VARCHAR2,
453 X_Segment23_High VARCHAR2,
454 X_Segment24_Low VARCHAR2,
455 X_Segment24_High VARCHAR2,
456 X_Segment25_Low VARCHAR2,
457 X_Segment25_High VARCHAR2,
458 X_Segment26_Low VARCHAR2,
459 X_Segment26_High VARCHAR2,
460 X_Segment27_Low VARCHAR2,
461 X_Segment27_High VARCHAR2,
462 X_Segment28_Low VARCHAR2,
463 X_Segment28_High VARCHAR2,
464 X_Segment29_Low VARCHAR2,
465 X_Segment29_High VARCHAR2,
466 X_Segment30_Low VARCHAR2,
467 X_Segment30_High VARCHAR2,
468 X_Last_Update_Date DATE,
469 X_Last_Updated_By NUMBER,
470 X_Last_Update_Login NUMBER
471 ) IS
472 BEGIN
473 UPDATE IGI_ITR_CHARGE_RANGES
474 SET
475 charge_range_id = X_Charge_Range_Id,
476 charge_center_id = X_Charge_Center_Id,
477 segment1_low = X_Segment1_Low,
478 segment1_high = X_Segment1_High,
479 segment2_low = X_Segment2_Low,
480 segment2_high = X_Segment2_High,
481 segment3_low = X_Segment3_Low,
482 segment3_high = X_Segment3_High,
483 segment4_low = X_Segment4_Low,
484 segment4_high = X_Segment4_High,
485 segment5_low = X_Segment5_Low,
486 segment5_high = X_Segment5_High,
487 segment6_low = X_Segment6_Low,
488 segment6_high = X_Segment6_High,
489 segment7_low = X_Segment7_Low,
490 segment7_high = X_Segment7_High,
491 segment8_low = X_Segment8_Low,
492 segment8_high = X_Segment8_High,
493 segment9_low = X_Segment9_Low,
494 segment9_high = X_Segment9_High,
495 segment10_low = X_Segment10_Low,
496 segment10_high = X_Segment10_High,
497 segment11_low = X_Segment11_Low,
498 segment11_high = X_Segment11_High,
499 segment12_low = X_Segment12_Low,
500 segment12_high = X_Segment12_High,
501 segment13_low = X_Segment13_Low,
502 segment13_high = X_Segment13_High,
503 segment14_low = X_Segment14_Low,
504 segment14_high = X_Segment14_High,
505 segment15_low = X_Segment15_Low,
506 segment15_high = X_Segment15_High,
507 segment16_low = X_Segment16_Low,
508 segment16_high = X_Segment16_High,
509 segment17_low = X_Segment17_Low,
510 segment17_high = X_Segment17_High,
511 segment18_low = X_Segment18_Low,
512 segment18_high = X_Segment18_High,
513 segment19_low = X_Segment19_Low,
514 segment19_high = X_Segment19_High,
515 segment20_low = X_Segment20_Low,
516 segment20_high = X_Segment20_High,
517 segment21_low = X_Segment21_Low,
518 segment21_high = X_Segment21_High,
519 segment22_low = X_Segment22_Low,
520 segment22_high = X_Segment22_High,
521 segment23_low = X_Segment23_Low,
522 segment23_high = X_Segment23_High,
523 segment24_low = X_Segment24_Low,
524 segment24_high = X_Segment24_High,
525 segment25_low = X_Segment25_Low,
526 segment25_high = X_Segment25_High,
527 segment26_low = X_Segment26_Low,
528 segment26_high = X_Segment26_High,
529 segment27_low = X_Segment27_Low,
530 segment27_high = X_Segment27_High,
531 segment28_low = X_Segment28_Low,
532 segment28_high = X_Segment28_High,
533 segment29_low = X_Segment29_Low,
534 segment29_high = X_Segment29_High,
535 segment30_low = X_Segment30_Low,
536 segment30_high = X_Segment30_High,
537 last_update_date = X_Last_Update_Date,
538 last_updated_by = X_Last_Updated_By,
539 last_update_login = X_Last_Update_Login
540 WHERE rowid = X_Rowid;
541
542 if (SQL%NOTFOUND) then
543 Raise NO_DATA_FOUND;
544 end if;
545 END Update_Row;
546
547 PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
548 BEGIN
549 DELETE FROM IGI_ITR_CHARGE_RANGES
550 WHERE rowid = X_Rowid;
551
552 if (SQL%NOTFOUND) then
553 Raise NO_DATA_FOUND;
554 end if;
555 END Delete_Row;
556
557 END IGI_IGI_ITR_CHARGE_RANGES_PKG;