eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.FA_ITC_RECAPTURE_RATES_PKG

Source


1 PACKAGE BODY FA_ITC_RECAPTURE_RATES_PKG as
2 /* $Header: faxiitrb.pls 120.8 2009/04/10 07:45:19 deemitta ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_ITC_RECAPTURE_ID in NUMBER,
7   X_TAX_YEAR in NUMBER,
8   X_LIFE_IN_MONTHS in NUMBER,
9   X_YEAR_OF_RETIREMENT in NUMBER,
10   X_ITC_RECAPTURE_RATE in NUMBER,
11   X_ATTRIBUTE1 in VARCHAR2,
12   X_ATTRIBUTE2 in VARCHAR2,
13   X_ATTRIBUTE3 in VARCHAR2,
14   X_ATTRIBUTE4 in VARCHAR2,
15   X_ATTRIBUTE5 in VARCHAR2,
16   X_ATTRIBUTE6 in VARCHAR2,
17   X_ATTRIBUTE7 in VARCHAR2,
18   X_ATTRIBUTE8 in VARCHAR2,
19   X_ATTRIBUTE9 in VARCHAR2,
20   X_ATTRIBUTE10 in VARCHAR2,
21   X_ATTRIBUTE11 in VARCHAR2,
22   X_ATTRIBUTE12 in VARCHAR2,
23   X_ATTRIBUTE13 in VARCHAR2,
24   X_ATTRIBUTE14 in VARCHAR2,
25   X_ATTRIBUTE15 in VARCHAR2,
26   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
27   X_CREATION_DATE in DATE,
28   X_CREATED_BY in NUMBER,
29   X_LAST_UPDATE_DATE in DATE,
30   X_LAST_UPDATED_BY in NUMBER,
31   X_LAST_UPDATE_LOGIN in NUMBER
32 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
33 /*
34   CURSOR C is SELECT rowid FROM fa_itc_recapture_rates
35               WHERE  itc_recapture_id = X_Itc_Recapture_Id;
36 */
37 begin
38 
39   INSERT INTO fa_itc_recapture_rates (
40 	itc_recapture_id,
41 	tax_year,
42 	life_in_months,
43 	year_of_retirement,
44 	itc_recapture_rate,
45 	attribute1,
46 	attribute2,
47 	attribute3,
48 	attribute4,
49 	attribute5,
50 	attribute6,
51 	attribute7,
52 	attribute8,
53 	attribute9,
54 	attribute10,
55 	attribute11,
56 	attribute12,
57 	attribute13,
58 	attribute14,
59 	attribute15,
60 	attribute_category_code,
61 	creation_date,
62 	created_by,
63 	last_update_date,
64 	last_updated_by,
65 	last_update_login
66   ) VALUES (
67 	X_Itc_Recapture_Id,
68 	X_Tax_Year,
69 	X_Life_In_Months,
70 	X_Year_Of_Retirement,
71 	X_Itc_Recapture_Rate,
72 	X_Attribute1,
73 	X_Attribute2,
74 	X_Attribute3,
75 	X_Attribute4,
76 	X_Attribute5,
77 	X_Attribute6,
78 	X_Attribute7,
79 	X_Attribute8,
80 	X_Attribute9,
81 	X_Attribute10,
82 	X_Attribute11,
83 	X_Attribute12,
84 	X_Attribute13,
85 	X_Attribute14,
86 	X_Attribute15,
87 	X_Attribute_Category_Code,
88 	X_Creation_Date,
89 	X_Created_By,
90 	X_Last_Update_Date,
91 	X_Last_Updated_By,
92 	X_Last_Update_Login
93   );
94 /*
95   OPEN C;
96   FETCH C INTO X_Rowid;
97   if (C%NOTFOUND) then
98      CLOSE C;
99      Raise NO_DATA_FOUND;
100   end if;
101   CLOSE C;
102 */
103 exception
104   when others then
105         fa_srvr_msg.add_sql_error(
106                 calling_fn => 'fa_itc_recapture_rates_pkg.insert_row', p_log_level_rec => p_log_level_rec);
107         raise;
108 
109 end INSERT_ROW;
110 
111 procedure LOCK_ROW (
112   X_ITC_RECAPTURE_ID in NUMBER,
113   X_TAX_YEAR in NUMBER,
114   X_LIFE_IN_MONTHS in NUMBER,
115   X_YEAR_OF_RETIREMENT in NUMBER,
116   X_ITC_RECAPTURE_RATE in NUMBER,
117   X_ATTRIBUTE1 in VARCHAR2,
118   X_ATTRIBUTE2 in VARCHAR2,
119   X_ATTRIBUTE3 in VARCHAR2,
120   X_ATTRIBUTE4 in VARCHAR2,
121   X_ATTRIBUTE5 in VARCHAR2,
122   X_ATTRIBUTE6 in VARCHAR2,
123   X_ATTRIBUTE7 in VARCHAR2,
124   X_ATTRIBUTE8 in VARCHAR2,
125   X_ATTRIBUTE9 in VARCHAR2,
126   X_ATTRIBUTE10 in VARCHAR2,
127   X_ATTRIBUTE11 in VARCHAR2,
128   X_ATTRIBUTE12 in VARCHAR2,
129   X_ATTRIBUTE13 in VARCHAR2,
130   X_ATTRIBUTE14 in VARCHAR2,
131   X_ATTRIBUTE15 in VARCHAR2,
132   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
133 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
134   CURSOR C is
135       SELECT itc_recapture_id,
136              tax_year,
137              life_in_months,
138              year_of_retirement,
139              itc_recapture_rate,
140              attribute1,
141              attribute2,
142              attribute3,
143              attribute4,
144              attribute5,
145              attribute6,
146              attribute7,
147              attribute8,
148              attribute9,
149              attribute10,
150              attribute11,
151              attribute12,
152              attribute13,
153              attribute14,
154              attribute15,
155              attribute_category_code
156       FROM   fa_itc_recapture_rates
157       WHERE  itc_recapture_id = X_Itc_Recapture_Id
158       FOR UPDATE of itc_recapture_id NOWAIT;
159   Recinfo C%ROWTYPE;
160 
161 begin
162 
163   OPEN C;
164   FETCH C INTO Recinfo;
165   if (C%NOTFOUND) then
166       CLOSE C;
167       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
168       APP_EXCEPTION.Raise_Exception;
169   end if;
170   CLOSE C;
171   if (
172           (Recinfo.Itc_Recapture_Id = X_Itc_Recapture_Id)
173       AND (Recinfo.Tax_Year = X_Tax_Year)
174       AND (Recinfo.Life_In_Months = X_Life_In_Months)
175       AND (Recinfo.Year_Of_Retirement = X_Year_Of_Retirement)
176       AND (Recinfo.Itc_Recapture_Rate = X_Itc_Recapture_Rate)
177       AND ((Recinfo.Attribute1 = X_Attribute1)
178           OR ((Recinfo.Attribute1 IS NULL)
179           AND (X_Attribute1 IS NULL)))
180       AND ((Recinfo.Attribute2 = X_Attribute2)
181           OR ((Recinfo.Attribute2 IS NULL)
182           AND (X_Attribute2 IS NULL)))
183       AND ((Recinfo.Attribute3 = X_Attribute3)
184           OR ((Recinfo.Attribute3 IS NULL)
185           AND (X_Attribute3 IS NULL)))
186       AND ((Recinfo.Attribute4 = X_Attribute4)
187           OR ((Recinfo.Attribute4 IS NULL)
188           AND (X_Attribute4 IS NULL)))
189       AND ((Recinfo.Attribute5 = X_Attribute5)
190           OR ((Recinfo.Attribute5 IS NULL)
191           AND (X_Attribute5 IS NULL)))
192       AND ((Recinfo.Attribute6 = X_Attribute6)
193           OR ((Recinfo.Attribute6 IS NULL)
194           AND (X_Attribute6 IS NULL)))
195       AND ((Recinfo.Attribute7 = X_Attribute7)
196           OR ((Recinfo.Attribute7 IS NULL)
197           AND (X_Attribute7 IS NULL)))
198       AND ((Recinfo.Attribute8 = X_Attribute8)
199           OR ((Recinfo.Attribute8 IS NULL)
200           AND (X_Attribute8 IS NULL)))
201       AND ((Recinfo.Attribute9 = X_Attribute9)
202           OR ((Recinfo.Attribute9 IS NULL)
203           AND (X_Attribute9 IS NULL)))
204       AND ((Recinfo.Attribute10 = X_Attribute10)
205           OR ((Recinfo.Attribute10 IS NULL)
206           AND (X_Attribute10 IS NULL)))
207       AND ((Recinfo.Attribute11 = X_Attribute11)
208           OR ((Recinfo.Attribute11 IS NULL)
209           AND (X_Attribute11 IS NULL)))
210       AND ((Recinfo.Attribute12 = X_Attribute12)
211           OR ((Recinfo.Attribute12 IS NULL)
212           AND (X_Attribute12 IS NULL)))
213       AND ((Recinfo.Attribute13 = X_Attribute13)
214           OR ((Recinfo.Attribute13 IS NULL)
215           AND (X_Attribute13 IS NULL)))
216       AND ((Recinfo.Attribute14 = X_Attribute14)
217           OR ((Recinfo.Attribute14 IS NULL)
218           AND (X_Attribute14 IS NULL)))
219       AND ((Recinfo.Attribute15 = X_Attribute15)
220           OR ((Recinfo.Attribute15 IS NULL)
221           AND (X_Attribute15 IS NULL)))
222       AND ((Recinfo.Attribute_Category_Code = X_Attribute_Category_Code)
223           OR ((Recinfo.Attribute_Category_Code IS NULL)
224           AND (X_Attribute_Category_Code IS NULL)))
225      ) then
226       return;
227   else
228       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
229       APP_EXCEPTION.Raise_Exception;
230   end if;
231 
232 end LOCK_ROW;
233 
234 procedure UPDATE_ROW (
235   X_ITC_RECAPTURE_ID in NUMBER,
236   X_TAX_YEAR in NUMBER,
237   X_LIFE_IN_MONTHS in NUMBER,
238   X_YEAR_OF_RETIREMENT in NUMBER,
239   X_ITC_RECAPTURE_RATE in NUMBER,
240   X_ATTRIBUTE1 in VARCHAR2,
241   X_ATTRIBUTE2 in VARCHAR2,
242   X_ATTRIBUTE3 in VARCHAR2,
243   X_ATTRIBUTE4 in VARCHAR2,
244   X_ATTRIBUTE5 in VARCHAR2,
245   X_ATTRIBUTE6 in VARCHAR2,
246   X_ATTRIBUTE7 in VARCHAR2,
247   X_ATTRIBUTE8 in VARCHAR2,
248   X_ATTRIBUTE9 in VARCHAR2,
249   X_ATTRIBUTE10 in VARCHAR2,
250   X_ATTRIBUTE11 in VARCHAR2,
251   X_ATTRIBUTE12 in VARCHAR2,
252   X_ATTRIBUTE13 in VARCHAR2,
253   X_ATTRIBUTE14 in VARCHAR2,
254   X_ATTRIBUTE15 in VARCHAR2,
255   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
256   X_LAST_UPDATE_DATE in DATE,
257   X_LAST_UPDATED_BY in NUMBER,
258   X_LAST_UPDATE_LOGIN in NUMBER
259 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
260 
261 begin
262 
263   UPDATE fa_itc_recapture_rates
264   SET    itc_recapture_id = X_Itc_Recapture_Id,
265          tax_year = X_Tax_Year,
266          life_in_months = X_Life_In_Months,
267          year_of_retirement = X_Year_Of_Retirement,
268          itc_recapture_rate = X_Itc_Recapture_Rate,
269          attribute1 = X_Attribute1,
270          attribute2 = X_Attribute2,
271          attribute3 = X_Attribute3,
272          attribute4 = X_Attribute4,
273          attribute5 = X_Attribute5,
274          attribute6 = X_Attribute6,
275          attribute7 = X_Attribute7,
276          attribute8 = X_Attribute8,
277          attribute9 = X_Attribute9,
278          attribute10 = X_Attribute10,
279          attribute11 = X_Attribute11,
280          attribute12 = X_Attribute12,
281          attribute13 = X_Attribute13,
282          attribute14 = X_Attribute14,
283          attribute15 = X_Attribute15,
284          attribute_category_code = X_Attribute_Category_Code,
285          last_update_date = X_Last_Update_Date,
286          last_updated_by = X_Last_Updated_By,
287          last_update_login = X_Last_Update_Login
288   WHERE  itc_recapture_id = X_Itc_Recapture_Id;
289 
290   if (SQL%NOTFOUND) then
291      Raise NO_DATA_FOUND;
292   end if;
293 
294   exception
295     when others then
296         fa_srvr_msg.add_sql_error(
297                 calling_fn => 'fa_itc_recapture_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);
298         raise;
299 
300 end UPDATE_ROW;
301 
302 procedure DELETE_ROW (
303   X_ITC_RECAPTURE_ID in NUMBER
304 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
305 
306 begin
307 
308   DELETE FROM fa_itc_recapture_rates
309   WHERE  itc_recapture_id = X_Itc_Recapture_Id;
310 
311   if (SQL%NOTFOUND) then
312      Raise NO_DATA_FOUND;
313   end if;
314 
315   exception
316     when others then
317         fa_srvr_msg.add_sql_error(
318                 calling_fn => 'fa_itc_recapture_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);
319         raise;
320 
321 end DELETE_ROW;
322 
323 procedure LOAD_ROW (
324   X_ITC_RECAPTURE_ID in NUMBER,
325   X_OWNER in VARCHAR2,
326   X_TAX_YEAR in NUMBER,
327   X_LIFE_IN_MONTHS in NUMBER,
328   X_YEAR_OF_RETIREMENT in NUMBER,
329   X_ITC_RECAPTURE_RATE in NUMBER,
330   X_ATTRIBUTE1 in VARCHAR2,
331   X_ATTRIBUTE2 in VARCHAR2,
332   X_ATTRIBUTE3 in VARCHAR2,
333   X_ATTRIBUTE4 in VARCHAR2,
334   X_ATTRIBUTE5 in VARCHAR2,
335   X_ATTRIBUTE6 in VARCHAR2,
336   X_ATTRIBUTE7 in VARCHAR2,
337   X_ATTRIBUTE8 in VARCHAR2,
338   X_ATTRIBUTE9 in VARCHAR2,
339   X_ATTRIBUTE10 in VARCHAR2,
340   X_ATTRIBUTE11 in VARCHAR2,
341   X_ATTRIBUTE12 in VARCHAR2,
342   X_ATTRIBUTE13 in VARCHAR2,
343   X_ATTRIBUTE14 in VARCHAR2,
344   X_ATTRIBUTE15 in VARCHAR2,
345   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
346 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
347 
348   h_record_exists       number(15);
349 
350   user_id               number;
351   row_id                varchar2(64);
352 
353 begin
354 
355   if (X_Owner = 'SEED') then
356      user_id := 1;
357   else
358      user_id := 0;
359   end if;
360 
361   select count(*)
362   into   h_record_exists
363   from   fa_itc_recapture_rates
364   where  itc_recapture_id = X_Itc_Recapture_Id;
365 
366   if (h_record_exists > 0) then
367      fa_itc_recapture_rates_pkg.update_row (
368 	X_Itc_Recapture_Id		=> X_Itc_Recapture_Id,
369 	X_Tax_Year			=> X_Tax_Year,
370 	X_Life_In_Months		=> X_Life_In_Months,
371 	X_Year_Of_Retirement		=> X_Year_Of_Retirement,
372 	X_Itc_Recapture_Rate		=> X_Itc_Recapture_Rate,
373 	X_Attribute1			=> X_Attribute1,
374 	X_Attribute2			=> X_Attribute2,
375 	X_Attribute3			=> X_Attribute3,
376 	X_Attribute4			=> X_Attribute4,
377 	X_Attribute5			=> X_Attribute5,
378 	X_Attribute6			=> X_Attribute6,
379 	X_Attribute7			=> X_Attribute7,
380 	X_Attribute8			=> X_Attribute8,
381 	X_Attribute9			=> X_Attribute9,
382 	X_Attribute10			=> X_Attribute10,
383 	X_Attribute11			=> X_Attribute11,
384 	X_Attribute12			=> X_Attribute12,
385 	X_Attribute13			=> X_Attribute13,
386 	X_Attribute14			=> X_Attribute14,
387 	X_Attribute15			=> X_Attribute15,
388 	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
389 	X_Last_Update_Date		=> sysdate,
390 	X_Last_Updated_By		=> user_id,
391 	X_Last_Update_Login		=> 0
392      , p_log_level_rec => p_log_level_rec);
393   else
394      fa_itc_recapture_rates_pkg.insert_row (
395 	X_Rowid				=> row_id,
396 	X_Itc_Recapture_Id		=> X_Itc_Recapture_Id,
397 	X_Tax_Year			=> X_Tax_Year,
398 	X_Life_In_Months		=> X_Life_In_Months,
399 	X_Year_Of_Retirement		=> X_Year_Of_Retirement,
400 	X_Itc_Recapture_Rate		=> X_Itc_Recapture_Rate,
401 	X_Attribute1			=> X_Attribute1,
402 	X_Attribute2			=> X_Attribute2,
403 	X_Attribute3			=> X_Attribute3,
404 	X_Attribute4			=> X_Attribute4,
405 	X_Attribute5			=> X_Attribute5,
406 	X_Attribute6			=> X_Attribute6,
407 	X_Attribute7			=> X_Attribute7,
408 	X_Attribute8			=> X_Attribute8,
409 	X_Attribute9			=> X_Attribute9,
410 	X_Attribute10			=> X_Attribute10,
411 	X_Attribute11			=> X_Attribute11,
412 	X_Attribute12			=> X_Attribute12,
413 	X_Attribute13			=> X_Attribute13,
414 	X_Attribute14			=> X_Attribute14,
415 	X_Attribute15			=> X_Attribute15,
416 	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
417 	X_Creation_Date			=> sysdate,
418 	X_Created_By			=> user_id,
419 	X_Last_Update_Date		=> sysdate,
420 	X_Last_Updated_By		=> user_id,
421 	X_Last_Update_Login		=> 0
422      , p_log_level_rec => p_log_level_rec);
423   end if;
424 
425 exception
426   when others then
427        FA_STANDARD_PKG.RAISE_ERROR(
428                       CALLED_FN => 'fa_itc_recapture_rates_pkg.load_row',
429                       CALLING_FN => 'upload fa_itc_recapture_rates', p_log_level_rec => p_log_level_rec);
430 
431 end LOAD_ROW;
432 /*Bug 8355119 overloading function for release specific signatures*/
433 procedure LOAD_ROW (
434   X_CUSTOM_MODE in VARCHAR2,
435   X_ITC_RECAPTURE_ID in NUMBER,
436   X_OWNER in VARCHAR2,
437   X_LAST_UPDATE_DATE in DATE,
438   X_TAX_YEAR in NUMBER,
439   X_LIFE_IN_MONTHS in NUMBER,
440   X_YEAR_OF_RETIREMENT in NUMBER,
441   X_ITC_RECAPTURE_RATE in NUMBER,
442   X_ATTRIBUTE1 in VARCHAR2,
443   X_ATTRIBUTE2 in VARCHAR2,
444   X_ATTRIBUTE3 in VARCHAR2,
445   X_ATTRIBUTE4 in VARCHAR2,
446   X_ATTRIBUTE5 in VARCHAR2,
447   X_ATTRIBUTE6 in VARCHAR2,
448   X_ATTRIBUTE7 in VARCHAR2,
449   X_ATTRIBUTE8 in VARCHAR2,
450   X_ATTRIBUTE9 in VARCHAR2,
451   X_ATTRIBUTE10 in VARCHAR2,
452   X_ATTRIBUTE11 in VARCHAR2,
453   X_ATTRIBUTE12 in VARCHAR2,
454   X_ATTRIBUTE13 in VARCHAR2,
455   X_ATTRIBUTE14 in VARCHAR2,
456   X_ATTRIBUTE15 in VARCHAR2,
457   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
458   p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) is
459 
460   h_record_exists       number(15);
461 
462   user_id               number;
463   row_id                varchar2(64);
464 
465   db_last_updated_by    number;
466   db_last_update_date   date;
467 
468 begin
469 
470   user_id := fnd_load_util.owner_id (X_Owner);
471 
472   select count(*)
473   into   h_record_exists
474   from   fa_itc_recapture_rates
475   where  itc_recapture_id = X_Itc_Recapture_Id;
476 
477   if (h_record_exists > 0) then
478 
479      select last_updated_by, last_update_date
480      into   db_last_updated_by, db_last_update_date
481      from   fa_itc_recapture_rates
482      where  itc_recapture_id = X_Itc_Recapture_Id;
483 
484      if (fnd_load_util.upload_test(user_id, x_last_update_date,
485                                    db_last_updated_by, db_last_update_date,
486                                    X_CUSTOM_MODE)) then
487 
488         fa_itc_recapture_rates_pkg.update_row (
489            X_Itc_Recapture_Id        => X_Itc_Recapture_Id,
490            X_Tax_Year                => X_Tax_Year,
491            X_Life_In_Months          => X_Life_In_Months,
492            X_Year_Of_Retirement      => X_Year_Of_Retirement,
493            X_Itc_Recapture_Rate      => X_Itc_Recapture_Rate,
494            X_Attribute1              => X_Attribute1,
495            X_Attribute2              => X_Attribute2,
496            X_Attribute3              => X_Attribute3,
497            X_Attribute4              => X_Attribute4,
498            X_Attribute5              => X_Attribute5,
499            X_Attribute6              => X_Attribute6,
500            X_Attribute7              => X_Attribute7,
501            X_Attribute8              => X_Attribute8,
502            X_Attribute9              => X_Attribute9,
503            X_Attribute10             => X_Attribute10,
504            X_Attribute11             => X_Attribute11,
505            X_Attribute12             => X_Attribute12,
506            X_Attribute13             => X_Attribute13,
507            X_Attribute14             => X_Attribute14,
508            X_Attribute15             => X_Attribute15,
509            X_Attribute_Category_Code => X_Attribute_Category_Code,
510            X_Last_Update_Date        => sysdate,
511            X_Last_Updated_By         => user_id,
512            X_Last_Update_Login       => 0
513            ,p_log_level_rec => p_log_level_rec);
514      end if;
515   else
516      fa_itc_recapture_rates_pkg.insert_row (
517 	X_Rowid				=> row_id,
518 	X_Itc_Recapture_Id		=> X_Itc_Recapture_Id,
519 	X_Tax_Year			=> X_Tax_Year,
520 	X_Life_In_Months		=> X_Life_In_Months,
521 	X_Year_Of_Retirement		=> X_Year_Of_Retirement,
522 	X_Itc_Recapture_Rate		=> X_Itc_Recapture_Rate,
523 	X_Attribute1			=> X_Attribute1,
524 	X_Attribute2			=> X_Attribute2,
525 	X_Attribute3			=> X_Attribute3,
526 	X_Attribute4			=> X_Attribute4,
527 	X_Attribute5			=> X_Attribute5,
528 	X_Attribute6			=> X_Attribute6,
529 	X_Attribute7			=> X_Attribute7,
530 	X_Attribute8			=> X_Attribute8,
531 	X_Attribute9			=> X_Attribute9,
532 	X_Attribute10			=> X_Attribute10,
533 	X_Attribute11			=> X_Attribute11,
534 	X_Attribute12			=> X_Attribute12,
535 	X_Attribute13			=> X_Attribute13,
536 	X_Attribute14			=> X_Attribute14,
537 	X_Attribute15			=> X_Attribute15,
538 	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
539 	X_Creation_Date			=> sysdate,
540 	X_Created_By			=> user_id,
541 	X_Last_Update_Date		=> sysdate,
542 	X_Last_Updated_By		=> user_id,
543 	X_Last_Update_Login		=> 0
544 	,p_log_level_rec => p_log_level_rec);
545   end if;
546 
547 exception
548   when others then
549        FA_STANDARD_PKG.RAISE_ERROR(
550                       CALLED_FN => 'fa_itc_recapture_rates_pkg.load_row',
551                       CALLING_FN => 'upload fa_itc_recapture_rates'
552                       ,p_log_level_rec => p_log_level_rec);
553 
554 end LOAD_ROW;
555 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
556 procedure LOAD_SEED_ROW (
557           x_upload_mode                 IN VARCHAR2,
558           x_custom_mode                 IN VARCHAR2,
559           x_itc_recapture_id            IN NUMBER,
560           x_owner                       IN VARCHAR2,
561           x_last_update_date            IN DATE,
562           x_tax_year                    IN NUMBER,
563           x_life_in_months              IN NUMBER,
564           x_year_of_retirement          IN NUMBER,
565           x_itc_recapture_rate          IN NUMBER,
566           x_attribute1                  IN VARCHAR2,
567           x_attribute2                  IN VARCHAR2,
568           x_attribute3                  IN VARCHAR2,
569           x_attribute4                  IN VARCHAR2,
570           x_attribute5                  IN VARCHAR2,
571           x_attribute6                  IN VARCHAR2,
572           x_attribute7                  IN VARCHAR2,
573           x_attribute8                  IN VARCHAR2,
574           x_attribute9                  IN VARCHAR2,
575           x_attribute10                 IN VARCHAR2,
576           x_attribute11                 IN VARCHAR2,
577           x_attribute12                 IN VARCHAR2,
578           x_attribute13                 IN VARCHAR2,
579           x_attribute14                 IN VARCHAR2,
580           x_attribute15                 IN VARCHAR2,
581           x_attribute_category_code     IN VARCHAR2) IS
582 
583 
584 BEGIN
585 
586       if (x_upload_mode = 'NLS') then
587          null;
588       else
589         fa_itc_recapture_rates_pkg.LOAD_ROW (
590           x_custom_mode                 => x_custom_mode,
591           x_itc_recapture_id            => x_itc_recapture_id,
592           x_owner                       => x_owner,
593           x_last_update_date            => x_last_update_date,
594           x_tax_year                    => x_tax_year,
595           x_life_in_months              => x_life_in_months,
596           x_year_of_retirement          => x_year_of_retirement,
597           x_itc_recapture_rate          => x_itc_recapture_rate,
598           x_attribute1                  => x_attribute1,
599           x_attribute2                  => x_attribute2,
600           x_attribute3                  => x_attribute3,
601           x_attribute4                  => x_attribute4,
602           x_attribute5                  => x_attribute5,
603           x_attribute6                  => x_attribute6,
604           x_attribute7                  => x_attribute7,
605           x_attribute8                  => x_attribute8,
606           x_attribute9                  => x_attribute9,
607           x_attribute10                 => x_attribute10,
608           x_attribute11                 => x_attribute11,
609           x_attribute12                 => x_attribute12,
610           x_attribute13                 => x_attribute13,
611           x_attribute14                 => x_attribute14,
612           x_attribute15                 => x_attribute15,
613           x_attribute_category_code     => x_attribute_category_code);
614       end if;
615 
616 END LOAD_SEED_ROW;
617 
618 END FA_ITC_RECAPTURE_RATES_PKG;