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