[Home] [Help]
PACKAGE BODY: APPS.ARP_RTE_PKG
Source
1 PACKAGE BODY ARP_RTE_PKG as
2 /* $Header: ARXIRTEB.pls 120.2 2005/07/26 15:30:15 naneja noship $ */
3 /* Purpose : This package has the server side table handlers for the
4 table RA_TAX_EXEMPTIONS. This file holds the package body. */
5
6 --
7 -- PRIVATE Procedures/Functions
8 --
9
10
11 --
12 -- PUBLIC Procedures/Functions
13 --
14
15 --
16 -- p_org_id is added for MOAC compliance for 11iX
17 --
18 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
19 p_Tax_exemption_id IN OUT NOCOPY NUMBER,
20 p_Last_updated_by NUMBER,
21 p_Last_update_date DATE,
22 p_Created_by NUMBER,
23 p_Creation_date DATE,
24 p_Status VARCHAR2,
25 p_Inventory_item_id NUMBER,
26 p_Customer_id NUMBER,
27 p_Site_use_id NUMBER,
28 p_Exemption_type VARCHAR2,
29 p_Tax_code VARCHAR2,
30 p_Percent_exempt NUMBER,
31 p_Customer_exemption_number VARCHAR2,
32 p_Start_date DATE,
33 p_End_date DATE,
34 p_Location_context VARCHAR2,
35 p_Location_id_segment_1 NUMBER,
36 p_Location_id_segment_2 NUMBER,
37 p_Location_id_segment_3 NUMBER,
38 p_Location_id_segment_4 NUMBER,
39 p_Location_id_segment_5 NUMBER,
40 p_Location_id_segment_6 NUMBER,
41 p_Location_id_segment_7 NUMBER,
42 p_Location_id_segment_8 NUMBER,
43 p_Location_id_segment_9 NUMBER,
44 p_Location_id_segment_10 NUMBER,
45 p_Attribute_category VARCHAR2,
46 p_Attribute1 VARCHAR2,
47 p_Attribute2 VARCHAR2,
48 p_Attribute3 VARCHAR2,
49 p_Attribute4 VARCHAR2,
50 p_Attribute5 VARCHAR2,
51 p_Attribute6 VARCHAR2,
52 p_Attribute7 VARCHAR2,
53 p_Attribute8 VARCHAR2,
54 p_Attribute9 VARCHAR2,
55 p_Attribute10 VARCHAR2,
56 p_Attribute11 VARCHAR2,
57 p_Attribute12 VARCHAR2,
58 p_Attribute13 VARCHAR2,
59 p_Attribute14 VARCHAR2,
60 p_Attribute15 VARCHAR2,
61 p_In_use_flag VARCHAR2,
62 p_Program_id NUMBER,
63 p_Program_update_date DATE,
64 p_Request_id NUMBER,
65 p_Program_application_id NUMBER,
66 p_Reason_code VARCHAR2,
67 p_Exempt_Context VARCHAR2,
68 p_Exempt_percent1 NUMBER,
69 p_Exempt_percent2 NUMBER,
70 p_Exempt_percent3 NUMBER,
71 p_Exempt_percent4 NUMBER,
72 p_Exempt_percent5 NUMBER,
73 p_Exempt_percent6 NUMBER,
74 p_Exempt_percent7 NUMBER,
75 p_Exempt_percent8 NUMBER,
76 p_Exempt_percent9 NUMBER,
77 p_Exempt_percent10 NUMBER,
78 p_org_id NUMBER
79 )
80 IS
81 CURSOR C IS SELECT rowid FROM RA_TAX_EXEMPTIONS
82 WHERE tax_exemption_id = p_Tax_exemption_id;
83
84 CURSOR C2 IS SELECT ra_tax_exemptions_s.nextval FROM dual;
85 BEGIN
86
87
88 if (p_Tax_Exemption_Id is NULL) then
89 OPEN C2;
90 FETCH C2 INTO p_Tax_Exemption_id;
91 CLOSE C2;
92 end if;
93
94 INSERT INTO RA_TAX_EXEMPTIONS(
95 Tax_exemption_id,
96 Last_updated_by,
97 Last_update_date,
98 Created_by,
99 Creation_date,
100 Status,
101 Inventory_item_id,
102 Customer_id,
103 Site_use_id,
104 Exemption_type,
105 Tax_code,
106 Percent_exempt,
107 Customer_exemption_number,
108 Start_date,
109 End_date,
110 Location_context,
111 Location_id_segment_1,
112 Location_id_segment_2,
113 Location_id_segment_3,
114 Location_id_segment_4,
115 Location_id_segment_5,
116 Location_id_segment_6,
117 Location_id_segment_7,
118 Location_id_segment_8,
119 Location_id_segment_9,
120 Location_id_segment_10,
121 Attribute_category,
122 Attribute1,
123 Attribute2,
124 Attribute3,
125 Attribute4,
126 Attribute5,
127 Attribute6,
128 Attribute7,
129 Attribute8,
130 Attribute9,
131 Attribute10,
132 Attribute11,
133 Attribute12,
134 Attribute13,
135 Attribute14,
136 Attribute15,
137 In_use_flag,
138 Program_id,
139 Program_update_date,
140 Request_id,
141 Program_application_id,
142 Reason_code,
143 Exempt_Context,
144 Exempt_percent1,
145 Exempt_percent2,
146 Exempt_percent3,
147 Exempt_percent4,
148 Exempt_percent5,
149 Exempt_percent6,
150 Exempt_percent7,
151 Exempt_percent8,
152 Exempt_percent9,
153 Exempt_percent10,
154 org_id
155 )
156 VALUES (
157 p_Tax_exemption_id,
158 p_Last_updated_by,
159 p_Last_update_date,
160 p_Created_by,
161 p_Creation_date,
162 p_Status,
163 p_Inventory_item_id,
164 p_Customer_id,
165 p_Site_use_id,
166 p_Exemption_type,
167 p_Tax_code,
168 p_Percent_exempt,
169 p_Customer_exemption_number,
170 p_Start_date,
171 p_End_date,
172 p_Location_context,
173 p_Location_id_segment_1,
174 p_Location_id_segment_2,
175 p_Location_id_segment_3,
176 p_Location_id_segment_4,
177 p_Location_id_segment_5,
178 p_Location_id_segment_6,
179 p_Location_id_segment_7,
180 p_Location_id_segment_8,
181 p_Location_id_segment_9,
182 p_Location_id_segment_10,
183 p_Attribute_category,
184 p_Attribute1,
185 p_Attribute2,
186 p_Attribute3,
187 p_Attribute4,
188 p_Attribute5,
189 p_Attribute6,
190 p_Attribute7,
191 p_Attribute8,
192 p_Attribute9,
193 p_Attribute10,
194 p_Attribute11,
195 p_Attribute12,
196 p_Attribute13,
197 p_Attribute14,
198 p_Attribute15,
199 p_In_use_flag,
200 p_Program_id,
201 p_Program_update_date,
202 p_Request_id,
203 p_Program_application_id,
204 p_Reason_code,
205 p_Exempt_Context,
206 p_Exempt_percent1,
207 p_Exempt_percent2,
208 p_Exempt_percent3,
209 p_Exempt_percent4,
210 p_Exempt_percent5,
211 p_Exempt_percent6,
212 p_Exempt_percent7,
213 p_Exempt_percent8,
214 p_Exempt_percent9,
215 p_Exempt_percent10,
216 p_org_id
217 );
218
219 OPEN C;
220 FETCH C INTO p_Rowid;
221 if (C%NOTFOUND) then
222 CLOSE C;
223 Raise NO_DATA_FOUND;
224 end if;
225 CLOSE C;
226
227 END Insert_Row;
228
229
230 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
231 p_Tax_exemption_id NUMBER,
232 p_Last_updated_by NUMBER,
233 p_Last_update_date DATE,
234 p_Created_by NUMBER,
235 p_Creation_date DATE,
236 p_Status VARCHAR2,
237 p_Inventory_item_id NUMBER,
238 p_Customer_id NUMBER,
239 p_Site_use_id NUMBER,
240 p_Exemption_type VARCHAR2,
241 p_Tax_code VARCHAR2,
242 p_Percent_exempt NUMBER,
243 p_Customer_exemption_number VARCHAR2,
244 p_Start_date DATE,
245 p_End_date DATE,
246 p_Location_context VARCHAR2,
247 p_Location_id_segment_1 NUMBER,
248 p_Location_id_segment_2 NUMBER,
249 p_Location_id_segment_3 NUMBER,
250 p_Location_id_segment_4 NUMBER,
251 p_Location_id_segment_5 NUMBER,
252 p_Location_id_segment_6 NUMBER,
253 p_Location_id_segment_7 NUMBER,
254 p_Location_id_segment_8 NUMBER,
255 p_Location_id_segment_9 NUMBER,
256 p_Location_id_segment_10 NUMBER,
257 p_Attribute_category VARCHAR2,
258 p_Attribute1 VARCHAR2,
259 p_Attribute2 VARCHAR2,
260 p_Attribute3 VARCHAR2,
261 p_Attribute4 VARCHAR2,
262 p_Attribute5 VARCHAR2,
263 p_Attribute6 VARCHAR2,
264 p_Attribute7 VARCHAR2,
265 p_Attribute8 VARCHAR2,
266 p_Attribute9 VARCHAR2,
267 p_Attribute10 VARCHAR2,
268 p_Attribute11 VARCHAR2,
269 p_Attribute12 VARCHAR2,
270 p_Attribute13 VARCHAR2,
271 p_Attribute14 VARCHAR2,
272 p_Attribute15 VARCHAR2,
273 p_In_use_flag VARCHAR2,
274 p_Program_id NUMBER,
275 p_Program_update_date DATE,
276 p_Request_id NUMBER,
277 p_Program_application_id NUMBER,
278 p_Reason_code VARCHAR2,
279 p_Exempt_Context VARCHAR2,
280 p_Exempt_percent1 NUMBER,
281 p_Exempt_percent2 NUMBER,
282 p_Exempt_percent3 NUMBER,
283 p_Exempt_percent4 NUMBER,
284 p_Exempt_percent5 NUMBER,
285 p_Exempt_percent6 NUMBER,
286 p_Exempt_percent7 NUMBER,
287 p_Exempt_percent8 NUMBER,
288 p_Exempt_percent9 NUMBER,
289 p_Exempt_percent10 NUMBER
290 ) IS
291 CURSOR C IS
292 SELECT *
293 FROM RA_TAX_EXEMPTIONS
294 WHERE rowid = p_Rowid
295 FOR UPDATE of Tax_Exemption_Id NOWAIT;
296 Recinfo C%ROWTYPE;
297
298
299 BEGIN
300 OPEN C;
301 FETCH C INTO Recinfo;
302 if (C%NOTFOUND) then
303 CLOSE C;
304 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
305 APP_EXCEPTION.Raise_Exception;
306 end if;
307 CLOSE C;
308 if ( (Recinfo.tax_exemption_id = p_Tax_Exemption_id)
309 AND (Recinfo.status = p_Status)
310 AND ( (Recinfo.inventory_item_id = p_Inventory_item_id)
311 OR ( (Recinfo.inventory_item_id IS NULL)
312 AND (p_inventory_item_id IS NULL)))
313 AND ( (Recinfo.customer_id = p_customer_id)
314 OR ( (Recinfo.customer_id IS NULL)
315 AND (p_customer_id IS NULL)))
316 AND ( (Recinfo.site_use_id = p_site_use_id)
317 OR ( (Recinfo.site_use_id IS NULL)
318 AND (p_site_use_id IS NULL)))
319 AND (Recinfo.exemption_type = p_Exemption_type)
320 AND (Recinfo.tax_code = p_Tax_code)
321 AND (Recinfo.percent_exempt = p_Percent_exempt)
322 AND ( (Recinfo.customer_exemption_number =
323 p_customer_exemption_number)
324 OR ( (Recinfo.customer_exemption_number IS NULL)
325 AND (p_customer_exemption_number IS NULL)))
326 AND (Recinfo.start_date = p_Start_date)
327 AND ( (Recinfo.end_date = p_end_date)
328 OR ( (Recinfo.end_date IS NULL)
329 AND (p_end_date IS NULL)))
330 AND ( (Recinfo.location_context = p_location_context)
331 OR ( (Recinfo.location_context IS NULL)
332 AND (p_location_context IS NULL)))
333 AND ( (Recinfo.location_id_segment_1 = p_Location_Id_Segment_1)
334 OR ( (Recinfo.location_id_segment_1 IS NULL)
335 AND (p_Location_Id_Segment_1 IS NULL)))
336 AND ( (Recinfo.location_id_segment_2 = p_Location_Id_Segment_2)
337 OR ( (Recinfo.location_id_segment_2 IS NULL)
338 AND (p_Location_Id_Segment_2 IS NULL)))
339 AND ( (Recinfo.location_id_segment_3 = p_Location_Id_Segment_3)
340 OR ( (Recinfo.location_id_segment_3 IS NULL)
341 AND (p_Location_Id_Segment_3 IS NULL)))
342 AND ( (Recinfo.location_id_segment_4 = p_Location_Id_Segment_4)
343 OR ( (Recinfo.location_id_segment_4 IS NULL)
344 AND (p_Location_Id_Segment_4 IS NULL)))
345 AND ( (Recinfo.location_id_segment_5 = p_Location_Id_Segment_5)
346 OR ( (Recinfo.location_id_segment_5 IS NULL)
347 AND (p_Location_Id_Segment_5 IS NULL)))
348 AND ( (Recinfo.location_id_segment_6 = p_Location_Id_Segment_6)
349 OR ( (Recinfo.location_id_segment_6 IS NULL)
350 AND (p_Location_Id_Segment_6 IS NULL)))
351 AND ( (Recinfo.location_id_segment_7 = p_Location_Id_Segment_7)
352 OR ( (Recinfo.location_id_segment_7 IS NULL)
353 AND (p_Location_Id_Segment_7 IS NULL)))
354 AND ( (Recinfo.location_id_segment_8 = p_Location_Id_Segment_8)
355 OR ( (Recinfo.location_id_segment_8 IS NULL)
356 AND (p_Location_Id_Segment_8 IS NULL)))
357 AND ( (Recinfo.location_id_segment_9 = p_Location_Id_Segment_9)
358 OR ( (Recinfo.location_id_segment_9 IS NULL)
359 AND (p_Location_Id_Segment_9 IS NULL)))
360 AND ( (Recinfo.location_id_segment_10 = p_Location_Id_Segment_10)
361 OR ( (Recinfo.location_id_segment_10 IS NULL)
362 AND (p_Location_Id_Segment_10 IS NULL)))
363 AND ( (Recinfo.attribute_category = p_Attribute_Category)
364 OR ( (Recinfo.attribute_category IS NULL)
365 AND (p_Attribute_Category IS NULL)))
366 AND ( (Recinfo.attribute1 = p_Attribute1)
367 OR ( (Recinfo.attribute1 IS NULL)
368 AND (p_Attribute1 IS NULL)))
369 AND ( (Recinfo.attribute2 = p_Attribute2)
370 OR ( (Recinfo.attribute2 IS NULL)
371 AND (p_Attribute2 IS NULL)))
372 AND ( (Recinfo.attribute3 = p_Attribute3)
373 OR ( (Recinfo.attribute3 IS NULL)
374 AND (p_Attribute3 IS NULL)))
375 AND ( (Recinfo.attribute4 = p_Attribute4)
376 OR ( (Recinfo.attribute4 IS NULL)
377 AND (p_Attribute4 IS NULL)))
378 AND ( (Recinfo.attribute5 = p_Attribute5)
379 OR ( (Recinfo.attribute5 IS NULL)
380 AND (p_Attribute5 IS NULL)))
381 AND ( (Recinfo.attribute6 = p_Attribute6)
382 OR ( (Recinfo.attribute6 IS NULL)
383 AND (p_Attribute6 IS NULL)))
384 AND ( (Recinfo.attribute7 = p_Attribute7)
385 OR ( (Recinfo.attribute7 IS NULL)
386 AND (p_Attribute7 IS NULL)))
387 AND ( (Recinfo.attribute8 = p_Attribute8)
388 OR ( (Recinfo.attribute8 IS NULL)
389 AND (p_Attribute8 IS NULL)))
390 AND ( (Recinfo.attribute9 = p_Attribute9)
391 OR ( (Recinfo.attribute9 IS NULL)
392 AND (p_Attribute9 IS NULL)))
393 AND ( (Recinfo.attribute10 = p_Attribute10)
394 OR ( (Recinfo.attribute10 IS NULL)
395 AND (p_Attribute10 IS NULL)))
396 AND ( (Recinfo.attribute11 = p_Attribute11)
397 OR ( (Recinfo.attribute11 IS NULL)
398 AND (p_Attribute11 IS NULL)))
399 AND ( (Recinfo.attribute12 = p_Attribute12)
400 OR ( (Recinfo.attribute12 IS NULL)
401 AND (p_Attribute12 IS NULL)))
402 AND ( (Recinfo.attribute13 = p_Attribute13)
403 OR ( (Recinfo.attribute13 IS NULL)
407 AND (p_Attribute14 IS NULL)))
404 AND (p_Attribute13 IS NULL)))
405 AND ( (Recinfo.attribute14 = p_Attribute14)
406 OR ( (Recinfo.attribute14 IS NULL)
408 AND ( (Recinfo.attribute15 = p_Attribute15)
409 OR ( (Recinfo.attribute15 IS NULL)
410 AND (p_Attribute15 IS NULL)))
411 AND (Recinfo.in_use_flag = p_In_use_flag)
412 AND ( (Recinfo.program_id = p_program_id)
413 OR ( (Recinfo.program_id IS NULL)
414 AND (p_program_id IS NULL)))
415 AND ( (Recinfo.program_update_date = p_program_update_date)
416 OR ( (Recinfo.program_update_date IS NULL)
417 AND (p_program_update_date IS NULL)))
418 AND ( (Recinfo.request_id = p_request_id)
419 OR ( (Recinfo.request_id IS NULL)
420 AND (p_request_id IS NULL)))
421 AND ( (Recinfo.program_application_id = p_program_application_id)
422 OR ( (Recinfo.program_application_id IS NULL)
423 AND (p_program_application_id IS NULL)))
424 AND ( (Recinfo.reason_code = p_reason_code)
425 OR ( (Recinfo.reason_code IS NULL)
426 AND (p_reason_code IS NULL)))
427 AND ( (Recinfo.Exempt_Context = p_Exempt_Context)
428 OR ( (Recinfo.Exempt_Context IS NULL)
429 AND (p_Exempt_context IS NULL)))
430 AND ( (Recinfo.Exempt_Percent1 = p_Exempt_Percent1)
431 OR ( (Recinfo.Exempt_Percent1 IS NULL)
432 AND (p_Exempt_Percent1 IS NULL)))
433 AND ( (Recinfo.Exempt_Percent2 = p_Exempt_Percent2)
434 OR ( (Recinfo.Exempt_Percent2 IS NULL)
435 AND (p_Exempt_Percent2 IS NULL)))
436 AND ( (Recinfo.Exempt_Percent3 = p_Exempt_Percent3)
437 OR ( (Recinfo.Exempt_Percent3 IS NULL)
438 AND (p_Exempt_Percent3 IS NULL)))
439 AND ( (Recinfo.Exempt_Percent4 = p_Exempt_Percent4)
440 OR ( (Recinfo.Exempt_Percent4 IS NULL)
441 AND (p_Exempt_Percent4 IS NULL)))
442 AND ( (Recinfo.Exempt_Percent5 = p_Exempt_Percent5)
443 OR ( (Recinfo.Exempt_Percent5 IS NULL)
444 AND (p_Exempt_Percent5 IS NULL)))
445 AND ( (Recinfo.Exempt_Percent6 = p_Exempt_Percent6)
446 OR ( (Recinfo.Exempt_Percent6 IS NULL)
447 AND (p_Exempt_Percent6 IS NULL)))
448 AND ( (Recinfo.Exempt_Percent7 = p_Exempt_Percent7)
449 OR ( (Recinfo.Exempt_Percent7 IS NULL)
450 AND (p_Exempt_Percent7 IS NULL)))
451 AND ( (Recinfo.Exempt_Percent8 = p_Exempt_Percent8)
452 OR ( (Recinfo.Exempt_Percent8 IS NULL)
453 AND (p_Exempt_Percent8 IS NULL)))
454 AND ( (Recinfo.Exempt_Percent9 = p_Exempt_Percent9)
455 OR ( (Recinfo.Exempt_Percent9 IS NULL)
456 AND (p_Exempt_Percent9 IS NULL)))
457 AND ( (Recinfo.Exempt_Percent10 = p_Exempt_Percent10)
458 OR ( (Recinfo.Exempt_Percent10 IS NULL)
459 AND (p_Exempt_Percent10 IS NULL)))
460 ) then
461 return;
462 else
463 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
464 APP_EXCEPTION.Raise_Exception;
465 end if;
466
467 END Lock_Row;
468
469
470
471 PROCEDURE Update_Row(p_Rowid VARCHAR2,
472 p_Tax_exemption_id NUMBER,
473 p_Last_updated_by NUMBER,
474 p_Last_update_date DATE,
475 p_Created_by NUMBER,
476 p_Creation_date DATE,
477 p_Status VARCHAR2,
478 p_Inventory_item_id NUMBER,
479 p_Customer_id NUMBER,
480 p_Site_use_id NUMBER,
481 p_Exemption_type VARCHAR2,
482 p_Tax_code VARCHAR2,
483 p_Percent_exempt NUMBER,
484 p_Customer_exemption_number VARCHAR2,
485 p_Start_date DATE,
486 p_End_date DATE,
487 p_Location_context VARCHAR2,
488 p_Location_id_segment_1 NUMBER,
489 p_Location_id_segment_2 NUMBER,
490 p_Location_id_segment_3 NUMBER,
491 p_Location_id_segment_4 NUMBER,
492 p_Location_id_segment_5 NUMBER,
493 p_Location_id_segment_6 NUMBER,
494 p_Location_id_segment_7 NUMBER,
495 p_Location_id_segment_8 NUMBER,
496 p_Location_id_segment_9 NUMBER,
497 p_Location_id_segment_10 NUMBER,
498 p_Attribute_category VARCHAR2,
499 p_Attribute1 VARCHAR2,
500 p_Attribute2 VARCHAR2,
501 p_Attribute3 VARCHAR2,
502 p_Attribute4 VARCHAR2,
503 p_Attribute5 VARCHAR2,
504 p_Attribute6 VARCHAR2,
505 p_Attribute7 VARCHAR2,
506 p_Attribute8 VARCHAR2,
507 p_Attribute9 VARCHAR2,
508 p_Attribute10 VARCHAR2,
509 p_Attribute11 VARCHAR2,
510 p_Attribute12 VARCHAR2,
511 p_Attribute13 VARCHAR2,
512 p_Attribute14 VARCHAR2,
513 p_Attribute15 VARCHAR2,
514 p_In_use_flag VARCHAR2,
515 p_Program_id NUMBER,
516 p_Program_update_date DATE,
517 p_Request_id NUMBER,
518 p_Program_application_id NUMBER,
519 p_Reason_code VARCHAR2,
523 p_Exempt_percent3 NUMBER,
520 p_Exempt_Context VARCHAR2,
521 p_Exempt_percent1 NUMBER,
522 p_Exempt_percent2 NUMBER,
524 p_Exempt_percent4 NUMBER,
525 p_Exempt_percent5 NUMBER,
526 p_Exempt_percent6 NUMBER,
527 p_Exempt_percent7 NUMBER,
528 p_Exempt_percent8 NUMBER,
529 p_Exempt_percent9 NUMBER,
530 p_Exempt_percent10 NUMBER
531 ) IS
532 BEGIN
533
534
535 UPDATE RA_TAX_EXEMPTIONS
536 SET
537 Tax_exemption_id = p_Tax_exemption_id,
538 Last_updated_by = p_Last_updated_by,
539 Last_update_date = p_Last_update_date,
540 Created_by = p_Created_by,
541 Creation_date = p_Creation_date,
542 Status = p_Status,
543 Inventory_item_id = p_Inventory_item_id,
544 Customer_id = p_Customer_id,
545 Site_use_id = p_Site_use_id,
546 Exemption_type = p_Exemption_type,
547 Tax_code = p_Tax_code,
548 Percent_exempt = p_Percent_exempt,
549 Customer_exemption_number = p_Customer_exemption_number,
550 Start_date = p_Start_date,
551 End_date = p_End_date,
552 Location_context = p_Location_context,
553 Location_id_segment_1 = p_Location_id_segment_1,
554 Location_id_segment_2 = p_Location_id_segment_2,
555 Location_id_segment_3 = p_Location_id_segment_3,
556 Location_id_segment_4 = p_Location_id_segment_4,
557 Location_id_segment_5 = p_Location_id_segment_5,
558 Location_id_segment_6 = p_Location_id_segment_6,
559 Location_id_segment_7 = p_Location_id_segment_7,
560 Location_id_segment_8 = p_Location_id_segment_8,
561 Location_id_segment_9 = p_Location_id_segment_9,
562 Location_id_segment_10 = p_Location_id_segment_10,
563 Attribute_category = p_Attribute_category,
564 Attribute1 = p_Attribute1,
565 Attribute2 = p_Attribute2,
566 Attribute3 = p_Attribute3,
567 Attribute4 = p_Attribute4,
568 Attribute5 = p_Attribute5,
569 Attribute6 = p_Attribute6,
570 Attribute7 = p_Attribute7,
571 Attribute8 = p_Attribute8,
572 Attribute9 = p_Attribute9,
573 Attribute10 = p_Attribute10,
574 Attribute11 = p_Attribute11,
575 Attribute12 = p_Attribute12,
576 Attribute13 = p_Attribute13,
577 Attribute14 = p_Attribute14,
578 Attribute15 = p_Attribute15,
579 In_use_flag = p_In_use_flag,
580 Program_id = p_Program_id,
581 Program_update_date = p_Program_update_date,
582 Request_id = p_Request_id,
583 Program_application_id = p_Program_application_id,
584 Reason_code = p_Reason_code,
585 Exempt_Context = p_Exempt_Context,
586 Exempt_Percent1 = p_Exempt_percent1,
587 Exempt_Percent2 = p_Exempt_percent2,
588 Exempt_Percent3 = p_Exempt_percent3,
589 Exempt_Percent4 = p_Exempt_percent4,
590 Exempt_Percent5 = p_Exempt_percent5,
591 Exempt_Percent6 = p_Exempt_percent6,
592 Exempt_Percent7 = p_Exempt_percent7,
593 Exempt_Percent8 = p_Exempt_percent8,
594 Exempt_Percent9 = p_Exempt_percent9,
595 Exempt_Percent10 = p_Exempt_percent10
596
597 WHERE rowid = p_Rowid;
598
599 if (SQL%NOTFOUND) then
600 Raise NO_DATA_FOUND;
601 end if;
602
603 END Update_Row;
604
605
606 PROCEDURE Delete_Row(p_Rowid VARCHAR2) IS
607 BEGIN
608 DELETE FROM RA_TAX_EXEMPTIONS
609 WHERE rowid = p_Rowid;
610
611 if (SQL%NOTFOUND) then
612 Raise NO_DATA_FOUND;
613 end if;
614
615 END Delete_Row;
616
617
618 END ARP_RTE_PKG;