[Home] [Help]
PACKAGE BODY: APPS.OKE_FUNDINGALLOCATION_PVT
Source
1 package body OKE_FundingAllocation_PVT as
2 /* $Header: OKEVKFAB.pls 115.15 2002/11/27 20:26:56 syho ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Fund_Allocation_Id NUMBER,
7 X_Funding_Source_Id NUMBER,
8 X_Object_Id NUMBER,
9 X_K_Line_Id NUMBER,
10 X_Project_Id NUMBER,
11 X_Task_Id NUMBER,
12 X_Amount NUMBER,
13 X_Previous_Amount NUMBER,
14 X_Hard_Limit NUMBER,
15 X_Revenue_Hard_Limit NUMBER,
16 X_Fund_Type VARCHAR2,
17 X_Funding_Status VARCHAR2,
18 X_Fiscal_Year VARCHAR2,
19 X_Reference1 VARCHAR2,
20 X_Reference2 VARCHAR2,
21 X_Reference3 VARCHAR2,
22 X_PA_Conversion_Type VARCHAR2,
23 X_PA_Conversion_Date DATE,
24 X_PA_Conversion_Rate NUMBER,
25 X_Insert_Update_Flag VARCHAR2,
26 X_Start_Date_Active DATE,
27 X_End_Date_Active DATE,
28 X_Funding_Category VARCHAR2,
29 X_Last_Update_Date DATE,
30 X_Last_Updated_By NUMBER,
31 X_Creation_Date DATE,
32 X_Created_By NUMBER,
33 X_Last_Update_Login NUMBER,
34 X_Attribute_Category VARCHAR2,
35 X_Attribute1 VARCHAR2,
36 X_Attribute2 VARCHAR2,
37 X_Attribute3 VARCHAR2,
38 X_Attribute4 VARCHAR2,
39 X_Attribute5 VARCHAR2,
40 X_Attribute6 VARCHAR2,
41 X_Attribute7 VARCHAR2,
42 X_Attribute8 VARCHAR2,
43 X_Attribute9 VARCHAR2,
44 X_Attribute10 VARCHAR2,
45 X_Attribute11 VARCHAR2,
46 X_Attribute12 VARCHAR2,
47 X_Attribute13 VARCHAR2,
48 X_Attribute14 VARCHAR2,
49 X_Attribute15 VARCHAR2,
50 X_PA_Attribute_Category VARCHAR2,
51 X_PA_Attribute1 VARCHAR2,
52 X_PA_Attribute2 VARCHAR2,
53 X_PA_Attribute3 VARCHAR2,
54 X_PA_Attribute4 VARCHAR2,
55 X_PA_Attribute5 VARCHAR2,
56 X_PA_Attribute6 VARCHAR2,
57 X_PA_Attribute7 VARCHAR2,
58 X_PA_Attribute8 VARCHAR2,
59 X_PA_Attribute9 VARCHAR2,
60 X_PA_Attribute10 VARCHAR2
61 ) is
62
63 cursor C is
64 select rowid
65 from OKE_K_FUND_ALLOCATIONS
66 where fund_allocation_id = X_fund_allocation_id;
67
68 cursor c1 is
69 select major_version + 1
70 from okc_k_vers_numbers
71 where chr_id = x_object_id
72 for update of chr_id nowait;
73
74 l_version number;
75
76 begin
77
78 open c1;
79 fetch c1 into l_version;
80 if (c1%notfound) then
81 close c1;
82 raise no_data_found;
83 end if;
84 close c1;
85
86 insert into OKE_K_FUND_ALLOCATIONS(
87 fund_allocation_id,
88 funding_source_id,
89 object_id,
90 k_line_id,
91 project_id,
92 task_id,
93 amount,
94 previous_amount,
95 hard_limit,
96 revenue_hard_limit,
97 fund_type,
98 funding_status,
99 fiscal_year,
100 reference1,
101 reference2,
102 reference3,
103 pa_conversion_type,
104 pa_conversion_date,
105 pa_conversion_rate,
106 insert_update_flag,
107 start_date_active,
108 end_date_active,
109 funding_category,
110 created_in_version,
111 last_update_date,
112 last_updated_by,
113 creation_date,
114 created_by,
115 last_update_login,
116 attribute_category,
117 attribute1,
118 attribute2,
119 attribute3,
120 attribute4,
121 attribute5,
122 attribute6,
123 attribute7,
124 attribute8,
125 attribute9,
126 attribute10,
127 attribute11,
128 attribute12,
129 attribute13,
130 attribute14,
131 attribute15,
132 pa_attribute_category,
133 pa_attribute1,
134 pa_attribute2,
135 pa_attribute3,
136 pa_attribute4,
137 pa_attribute5,
138 pa_attribute6,
139 pa_attribute7,
140 pa_attribute8,
141 pa_attribute9,
142 pa_attribute10
143 ) VALUES (
144 X_Fund_Allocation_Id,
145 X_Funding_Source_Id,
146 X_Object_Id,
147 X_K_Line_Id,
148 X_Project_Id,
149 X_Task_Id,
150 X_Amount,
151 X_Previous_Amount,
152 X_Hard_Limit,
153 X_Revenue_Hard_Limit,
154 X_Fund_Type,
155 X_Funding_Status,
156 X_Fiscal_Year,
157 X_Reference1,
158 X_Reference2,
159 X_Reference3,
160 X_PA_Conversion_Type,
161 X_PA_Conversion_Date,
162 X_PA_Conversion_Rate,
163 X_Insert_Update_Flag,
164 X_Start_Date_Active,
165 X_End_Date_Active,
166 X_Funding_Category,
167 l_version,
168 X_Last_Update_Date,
169 X_Last_Updated_By,
170 X_Creation_Date,
171 X_Created_By,
172 X_Last_Update_Login,
173 X_Attribute_Category,
174 X_Attribute1,
175 X_Attribute2,
176 X_Attribute3,
177 X_Attribute4,
178 X_Attribute5,
179 X_Attribute6,
180 X_Attribute7,
181 X_Attribute8,
182 X_Attribute9,
183 X_Attribute10,
184 X_Attribute11,
185 X_Attribute12,
186 X_Attribute13,
187 X_Attribute14,
188 X_Attribute15,
189 X_PA_Attribute_Category,
190 X_PA_Attribute1,
191 X_PA_Attribute2,
192 X_PA_Attribute3,
193 X_PA_Attribute4,
194 X_PA_Attribute5,
195 X_PA_Attribute6,
196 X_PA_Attribute7,
197 X_PA_Attribute8,
198 X_PA_Attribute9,
199 X_PA_Attribute10
200 );
201
202 open c;
203 fetch c into X_Rowid;
204 if (c%notfound) then
205 close c;
206 raise no_data_found;
207 end if;
208 close c;
209
210 end Insert_Row;
211
212
213 PROCEDURE Lock_Row(X_Fund_Allocation_Id NUMBER,
214 X_Funding_Source_Id NUMBER,
215 X_Object_Id NUMBER,
216 X_K_Line_Id NUMBER,
217 X_Project_Id NUMBER,
218 X_Task_Id NUMBER,
219 X_Amount NUMBER,
220 X_Previous_Amount NUMBER,
221 X_Hard_Limit NUMBER,
222 X_Revenue_Hard_Limit NUMBER,
223 X_Fund_Type VARCHAR2,
224 X_Funding_Status VARCHAR2,
225 X_Fiscal_Year VARCHAR2,
226 X_Reference1 VARCHAR2,
227 X_Reference2 VARCHAR2,
228 X_Reference3 VARCHAR2,
229 X_PA_Conversion_Type VARCHAR2,
230 X_PA_Conversion_Date DATE,
231 X_PA_Conversion_Rate NUMBER,
232 X_Start_Date_Active DATE,
233 X_End_Date_Active DATE,
234 X_Funding_Category VARCHAR2,
235 X_Attribute_Category VARCHAR2,
236 X_Attribute1 VARCHAR2,
237 X_Attribute2 VARCHAR2,
238 X_Attribute3 VARCHAR2,
239 X_Attribute4 VARCHAR2,
240 X_Attribute5 VARCHAR2,
241 X_Attribute6 VARCHAR2,
242 X_Attribute7 VARCHAR2,
243 X_Attribute8 VARCHAR2,
244 X_Attribute9 VARCHAR2,
245 X_Attribute10 VARCHAR2,
246 X_Attribute11 VARCHAR2,
247 X_Attribute12 VARCHAR2,
248 X_Attribute13 VARCHAR2,
249 X_Attribute14 VARCHAR2,
250 X_Attribute15 VARCHAR2,
251 X_PA_Attribute_Category VARCHAR2,
252 X_PA_Attribute1 VARCHAR2,
253 X_PA_Attribute2 VARCHAR2,
254 X_PA_Attribute3 VARCHAR2,
255 X_PA_Attribute4 VARCHAR2,
256 X_PA_Attribute5 VARCHAR2,
257 X_PA_Attribute6 VARCHAR2,
258 X_PA_Attribute7 VARCHAR2,
259 X_PA_Attribute8 VARCHAR2,
260 X_PA_Attribute9 VARCHAR2,
261 X_PA_Attribute10 VARCHAR2
262 ) is
263
264 cursor c is
265 select fund_allocation_id,
266 funding_source_id,
267 object_id,
268 k_line_id,
269 project_id,
270 task_id,
271 amount,
272 previous_amount,
273 hard_limit,
274 revenue_hard_limit,
275 fund_type,
276 funding_status,
277 fiscal_year,
278 reference1,
279 reference2,
280 reference3,
281 pa_conversion_type,
282 pa_conversion_date,
283 pa_conversion_rate,
284 start_date_active,
285 end_date_active,
286 funding_category,
287 attribute_category,
288 attribute1,
289 attribute2,
290 attribute3,
291 attribute4,
292 attribute5,
293 attribute6,
294 attribute7,
295 attribute8,
296 attribute9,
297 attribute10,
298 attribute11,
299 attribute12,
300 attribute13,
301 attribute14,
302 attribute15,
303 pa_attribute_category,
304 pa_attribute1,
305 pa_attribute2,
306 pa_attribute3,
307 pa_attribute4,
308 pa_attribute5,
309 pa_attribute6,
310 pa_attribute7,
311 pa_attribute8,
312 pa_attribute9,
313 pa_attribute10
314 from OKE_K_FUND_ALLOCATIONS
315 where fund_allocation_id = X_Fund_Allocation_Id
316 for update of fund_allocation_id nowait;
317
318 recinfo c%rowtype;
319
320 begin
321
322 open c;
323 fetch c into recinfo;
324 if (c%notfound) then
325 close c;
326 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
327 app_exception.raise_exception;
328 end if;
329 close c;
330
331 if ( ((recinfo.object_id = X_Object_Id)
332 OR ((recinfo.object_id is null) AND (X_Object_Id is null)))
333 AND ((recinfo.start_date_active = X_Start_Date_Active)
334 OR ((recinfo.start_date_active is null) AND (X_Start_Date_Active is null)))
335 AND ((recinfo.end_date_active = X_End_Date_Active)
336 OR ((recinfo.end_date_active is null) AND (X_End_Date_Active is null)))
337 AND ((recinfo.k_line_id = X_K_Line_Id)
338 OR ((recinfo.k_line_id is null) AND (X_K_Line_Id is null)))
339 AND ((recinfo.hard_limit = X_Hard_Limit)
340 OR ((recinfo.hard_limit is null) AND (X_Hard_Limit is null)))
341 AND ((recinfo.revenue_hard_limit = X_Revenue_Hard_Limit)
342 OR ((recinfo.revenue_hard_limit is null) AND (X_Revenue_Hard_Limit is null)))
343 AND ((recinfo.project_id = X_Project_Id)
344 OR ((recinfo.project_id is null) AND (X_Project_Id is null)))
345 AND ((recinfo.task_id = X_Task_Id)
346 OR ((recinfo.task_id is null) AND (X_Task_Id is null)))
347 AND ((rtrim(recinfo.funding_status) = rtrim(X_Funding_Status))
348 OR ((recinfo.funding_status is null) AND (X_Funding_Status is null)))
349 AND ((rtrim(recinfo.funding_category) = rtrim(X_Funding_Category))
350 OR ((recinfo.funding_category is null) AND (X_Funding_Category is null)))
351 AND ((rtrim(recinfo.fiscal_year) = rtrim(X_Fiscal_Year))
352 OR ((recinfo.fiscal_year is null) AND (X_Fiscal_Year is null)))
353 AND ((rtrim(recinfo.fund_type) = rtrim(X_Fund_Type))
354 OR ((recinfo.fund_type is null) AND (X_Fund_Type is null)))
355 AND ((rtrim(recinfo.reference1) = rtrim(X_Reference1))
356 OR ((recinfo.reference1 is null) AND (X_Reference1 is null)))
357 AND ((rtrim(recinfo.reference2) = rtrim(X_Reference2))
358 OR ((recinfo.reference2 is null) AND (X_Reference2 is null)))
359 AND ((rtrim(recinfo.reference3) = rtrim(X_Reference3))
360 OR ((recinfo.reference3 is null) AND (X_Reference3 is null)))
361 AND ((rtrim(recinfo.pa_conversion_type) = rtrim(X_pa_conversion_type))
362 OR ((recinfo.pa_conversion_type is null) AND (X_pa_conversion_type is null)))
363 AND ((recinfo.pa_conversion_date = X_pa_conversion_date)
364 OR ((recinfo.pa_conversion_date is null) AND (X_pa_conversion_date is null)))
365 AND ((recinfo.pa_conversion_rate = X_pa_conversion_rate)
366 OR ((recinfo.pa_conversion_rate is null) AND (X_pa_conversion_rate is null)))
367 AND (recinfo.amount = X_Amount)
368 AND (recinfo.previous_amount = X_Previous_Amount)
372 OR ((recinfo.attribute_category is null) AND (X_Attribute_Category is null)))
369 AND (recinfo.fund_allocation_id = X_Fund_Allocation_Id)
370 AND (recinfo.funding_source_id = X_Funding_Source_Id)
371 AND ((rtrim(recinfo.attribute_category) = rtrim(X_Attribute_Category))
373 AND ((rtrim(recinfo.attribute1) = rtrim(X_Attribute1))
374 OR ((recinfo.attribute1 is null) AND (X_Attribute1 is null)))
375 AND ((rtrim(recinfo.attribute2) = rtrim(X_Attribute2))
376 OR ((recinfo.attribute2 is null) AND (X_Attribute2 is null)))
377 AND ((rtrim(recinfo.attribute3) = rtrim(X_Attribute3))
378 OR ((recinfo.attribute3 is null) AND (X_Attribute3 is null)))
379 AND ((rtrim(recinfo.attribute4) = rtrim(X_Attribute4))
380 OR ((recinfo.attribute4 is null) AND (X_Attribute4 is null)))
381 AND ((rtrim(recinfo.attribute5) = rtrim(X_Attribute5))
382 OR ((recinfo.attribute5 is null) AND (X_Attribute5 is null)))
383 AND ((rtrim(recinfo.attribute6) = rtrim(X_Attribute6))
384 OR ((recinfo.attribute6 is null) AND (X_Attribute6 is null)))
385 AND ((rtrim(recinfo.attribute7) = rtrim(X_Attribute7))
386 OR ((recinfo.attribute7 is null) AND (X_Attribute7 is null)))
387 AND ((rtrim(recinfo.attribute8) = rtrim(X_Attribute8))
388 OR ((recinfo.attribute8 is null) AND (X_Attribute8 is null)))
389 AND ((rtrim(recinfo.attribute9) = rtrim(X_Attribute9))
390 OR ((recinfo.attribute9 is null) AND (X_Attribute9 is null)))
391 AND ((rtrim(recinfo.attribute10) = rtrim(X_Attribute10))
392 OR ((recinfo.attribute10 is null) AND (X_Attribute10 is null)))
393 AND ((rtrim(recinfo.attribute11) = rtrim(X_Attribute11))
394 OR ((recinfo.attribute11 is null) AND (X_Attribute11 is null)))
395 AND ((rtrim(recinfo.attribute12) = rtrim(X_Attribute12))
396 OR ((recinfo.attribute12 is null) AND (X_Attribute12 is null)))
397 AND ((rtrim(recinfo.attribute13) = rtrim(X_Attribute13))
398 OR ((recinfo.attribute13 is null) AND (X_Attribute13 is null)))
399 AND ((rtrim(recinfo.attribute14) = rtrim(X_Attribute14))
400 OR ((recinfo.attribute14 is null) AND (X_Attribute14 is null)))
401 AND ((rtrim(recinfo.attribute15) = rtrim(X_Attribute15))
402 OR ((recinfo.attribute15 is null) AND (X_Attribute15 is null)))
403 AND ((rtrim(recinfo.pa_attribute_category) = rtrim(X_PA_Attribute_Category))
404 OR ((recinfo.pa_attribute_category is null) AND (X_PA_Attribute_Category is null)))
405 AND ((rtrim(recinfo.pa_attribute1) = rtrim(X_PA_Attribute1))
406 OR ((recinfo.pa_attribute1 is null) AND (X_PA_Attribute1 is null)))
407 AND ((rtrim(recinfo.pa_attribute2) = rtrim(X_PA_Attribute2))
408 OR ((recinfo.pa_attribute2 is null) AND (X_PA_Attribute2 is null)))
409 AND ((rtrim(recinfo.pa_attribute3) = rtrim(X_PA_Attribute3))
410 OR ((recinfo.pa_attribute3 is null) AND (X_PA_Attribute3 is null)))
411 AND ((rtrim(recinfo.pa_attribute4) = rtrim(X_PA_Attribute4))
412 OR ((recinfo.pa_attribute4 is null) AND (X_PA_Attribute4 is null)))
413 AND ((rtrim(recinfo.pa_attribute5) = rtrim(X_PA_Attribute5))
414 OR ((recinfo.pa_attribute5 is null) AND (X_PA_Attribute5 is null)))
415 AND ((rtrim(recinfo.pa_attribute6) = rtrim(X_PA_Attribute6))
416 OR ((recinfo.pa_attribute6 is null) AND (X_PA_Attribute6 is null)))
417 AND ((rtrim(recinfo.pa_attribute7) = rtrim(X_PA_Attribute7))
418 OR ((recinfo.pa_attribute7 is null) AND (X_PA_Attribute7 is null)))
419 AND ((rtrim(recinfo.pa_attribute8) = rtrim(X_PA_Attribute8))
420 OR ((recinfo.pa_attribute8 is null) AND (X_PA_Attribute8 is null)))
421 AND ((rtrim(recinfo.pa_attribute9) = rtrim(X_PA_Attribute9))
422 OR ((recinfo.pa_attribute9 is null) AND (X_PA_Attribute9 is null)))
423 AND ((rtrim(recinfo.pa_attribute10) = rtrim(X_PA_Attribute10))
424 OR ((recinfo.pa_attribute10 is null) AND (X_PA_Attribute10 is null)))
425 ) then
426 null;
427 else
428 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429 app_exception.raise_exception;
430 end if;
431
432 end Lock_Row;
433
434
435 PROCEDURE Update_Row(X_Fund_Allocation_Id NUMBER,
436 X_Amount NUMBER,
437 X_Previous_Amount NUMBER,
438 X_Object_Id NUMBER,
439 X_K_Line_Id NUMBER,
440 X_Project_Id NUMBER,
441 X_Task_Id NUMBER,
442 X_Hard_Limit NUMBER,
443 X_Revenue_Hard_Limit NUMBER,
444 X_Fund_Type VARCHAR2,
445 X_Funding_Status VARCHAR2,
446 X_Fiscal_Year VARCHAR2,
447 X_Reference1 VARCHAR2,
448 X_Reference2 VARCHAR2,
449 X_Reference3 VARCHAR2,
450 X_PA_Conversion_Type VARCHAR2,
451 X_PA_Conversion_Date DATE,
452 X_PA_Conversion_Rate NUMBER,
453 X_Start_Date_Active DATE,
454 X_End_Date_Active DATE,
455 X_Insert_Update_Flag VARCHAR2,
456 X_Funding_Category VARCHAR2,
457 X_Last_Update_Date DATE,
458 X_Last_Updated_By NUMBER,
459 X_Last_Update_Login NUMBER,
460 X_Attribute_Category VARCHAR2,
461 X_Attribute1 VARCHAR2,
462 X_Attribute2 VARCHAR2,
463 X_Attribute3 VARCHAR2,
467 X_Attribute7 VARCHAR2,
464 X_Attribute4 VARCHAR2,
465 X_Attribute5 VARCHAR2,
466 X_Attribute6 VARCHAR2,
468 X_Attribute8 VARCHAR2,
469 X_Attribute9 VARCHAR2,
470 X_Attribute10 VARCHAR2,
471 X_Attribute11 VARCHAR2,
472 X_Attribute12 VARCHAR2,
473 X_Attribute13 VARCHAR2,
474 X_Attribute14 VARCHAR2,
475 X_Attribute15 VARCHAR2,
476 X_PA_Attribute_Category VARCHAR2,
477 X_PA_Attribute1 VARCHAR2,
478 X_PA_Attribute2 VARCHAR2,
479 X_PA_Attribute3 VARCHAR2,
480 X_PA_Attribute4 VARCHAR2,
481 X_PA_Attribute5 VARCHAR2,
482 X_PA_Attribute6 VARCHAR2,
483 X_PA_Attribute7 VARCHAR2,
484 X_PA_Attribute8 VARCHAR2,
485 X_PA_Attribute9 VARCHAR2,
486 X_PA_Attribute10 VARCHAR2
487 ) is
488
489 cursor c1 is
490 select major_version + 1
491 from okc_k_vers_numbers
492 where chr_id = x_object_id
493 for update of chr_id nowait;
494
495 l_version number;
496
497 begin
498
499 open c1;
500 fetch c1 into l_version;
501 if (c1%notfound) then
502 close c1;
503 raise no_data_found;
504 end if;
505 close c1;
506
507 update OKE_K_FUND_ALLOCATIONS
508 set
509 amount = X_Amount,
510 previous_amount = X_Previous_Amount,
511 k_line_id = X_K_Line_Id,
512 project_id = X_Project_Id,
513 task_id = X_Task_Id,
514 hard_limit = X_Hard_Limit,
515 revenue_hard_limit = X_Revenue_Hard_Limit,
516 fund_type = X_Fund_Type,
517 funding_status = X_Funding_Status,
518 fiscal_year = X_Fiscal_Year,
519 reference1 = X_Reference1,
520 reference2 = X_Reference2,
521 reference3 = X_Reference3,
522 pa_conversion_type = X_PA_Conversion_Type,
523 pa_conversion_date = X_PA_Conversion_Date,
524 pa_conversion_rate = X_PA_Conversion_Rate,
525 insert_update_flag = X_Insert_Update_Flag,
526 start_date_active = X_Start_Date_Active,
527 end_date_active = X_End_Date_Active,
528 funding_category = X_Funding_Category,
529 updated_in_version = l_version,
530 last_update_date = X_Last_Update_Date,
531 last_updated_by = X_Last_Updated_By,
532 last_update_login = X_Last_Update_Login,
533 attribute_Category = X_Attribute_Category,
534 attribute1 = X_Attribute1,
535 attribute2 = X_Attribute2,
536 attribute3 = X_Attribute3,
537 attribute4 = X_Attribute4,
538 attribute5 = X_Attribute5,
539 attribute6 = X_Attribute6,
540 attribute7 = X_Attribute7,
541 attribute8 = X_Attribute8,
542 attribute9 = X_Attribute9,
543 attribute10 = X_Attribute10,
544 attribute11 = X_Attribute11,
545 attribute12 = X_Attribute12,
546 attribute13 = X_Attribute13,
547 attribute14 = X_Attribute14,
548 attribute15 = X_Attribute15,
549 pa_attribute_Category = X_PA_Attribute_Category,
550 pa_attribute1 = X_PA_Attribute1,
551 pa_attribute2 = X_PA_Attribute2,
552 pa_attribute3 = X_PA_Attribute3,
553 pa_attribute4 = X_PA_Attribute4,
554 pa_attribute5 = X_PA_Attribute5,
555 pa_attribute6 = X_PA_Attribute6,
556 pa_attribute7 = X_PA_Attribute7,
557 pa_attribute8 = X_PA_Attribute8,
558 pa_attribute9 = X_PA_Attribute9,
559 pa_attribute10 = X_PA_Attribute10
560 where fund_allocation_id = X_Fund_Allocation_Id;
561
562 if (sql%notfound) then
563 raise no_data_found;
564 end if;
565
566 end Update_Row;
567
568 PROCEDURE Delete_Row(X_Rowid VARCHAR2
569 ) is
570
571 begin
572
573 DELETE FROM OKE_K_FUND_ALLOCATIONS
574 WHERE rowid = X_Rowid;
575
576 if (SQL%NOTFOUND) then
577 Raise NO_DATA_FOUND;
578 end if;
579
580 end delete_row;
581
582 end OKE_FundingAllocation_PVT;