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_RATES_PKG

Source


1 PACKAGE BODY FA_ITC_RATES_PKG as
2 /* $Header: faxiitcb.pls 120.8 2009/04/10 07:44:21 deemitta ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_ITC_AMOUNT_ID in NUMBER,
7   X_TAX_YEAR in NUMBER,
8   X_LIFE_IN_MONTHS in NUMBER,
9   X_ITC_AMOUNT_RATE in NUMBER,
10   X_BASIS_REDUCTION_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_rates
35               WHERE itc_amount_id = X_Itc_Amount_Id;
36 
37 begin
38 
39   INSERT INTO fa_itc_rates (
40 	itc_amount_id,
41 	tax_year,
42 	life_in_months,
43 	itc_amount_rate,
44 	basis_reduction_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_Amount_Id,
68 	X_Tax_Year,
69 	X_Life_In_Months,
70 	X_Itc_Amount_Rate,
71 	X_Basis_Reduction_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_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_AMOUNT_ID in NUMBER,
113   X_TAX_YEAR in NUMBER,
114   X_LIFE_IN_MONTHS in NUMBER,
115   X_ITC_AMOUNT_RATE in NUMBER,
116   X_BASIS_REDUCTION_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_amount_id,
136              tax_year,
137              life_in_months,
138              itc_amount_rate,
139              basis_reduction_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_rates
157       WHERE  itc_amount_id = X_Itc_Amount_Id
158       FOR UPDATE of itc_amount_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_Amount_Id = X_Itc_Amount_Id)
173       AND (Recinfo.Tax_Year = X_Tax_Year)
174       AND (Recinfo.Life_In_Months = X_Life_In_Months)
175       AND (Recinfo.Itc_Amount_Rate = X_Itc_Amount_Rate)
176       AND ((Recinfo.Attribute1 = X_Attribute1)
177           OR ((Recinfo.Attribute1 IS NULL)
178           AND (X_Attribute1 IS NULL)))
179       AND ((Recinfo.Attribute2 = X_Attribute2)
180           OR ((Recinfo.Attribute2 IS NULL)
181           AND (X_Attribute2 IS NULL)))
182       AND ((Recinfo.Attribute3 = X_Attribute3)
183           OR ((Recinfo.Attribute3 IS NULL)
184           AND (X_Attribute3 IS NULL)))
185       AND ((Recinfo.Attribute4 = X_Attribute4)
186           OR ((Recinfo.Attribute4 IS NULL)
187           AND (X_Attribute4 IS NULL)))
188       AND ((Recinfo.Attribute5 = X_Attribute5)
189           OR ((Recinfo.Attribute5 IS NULL)
190           AND (X_Attribute5 IS NULL)))
191       AND ((Recinfo.Attribute6 = X_Attribute6)
192           OR ((Recinfo.Attribute6 IS NULL)
193           AND (X_Attribute6 IS NULL)))
194       AND ((Recinfo.Attribute7 = X_Attribute7)
195           OR ((Recinfo.Attribute7 IS NULL)
196           AND (X_Attribute7 IS NULL)))
197       AND ((Recinfo.Attribute8 = X_Attribute8)
198           OR ((Recinfo.Attribute8 IS NULL)
199           AND (X_Attribute8 IS NULL)))
200       AND ((Recinfo.Attribute9 = X_Attribute9)
201           OR ((Recinfo.Attribute9 IS NULL)
202           AND (X_Attribute9 IS NULL)))
203       AND ((Recinfo.Attribute10 = X_Attribute10)
204           OR ((Recinfo.Attribute10 IS NULL)
205           AND (X_Attribute10 IS NULL)))
206       AND ((Recinfo.Attribute11 = X_Attribute11)
207           OR ((Recinfo.Attribute11 IS NULL)
208           AND (X_Attribute11 IS NULL)))
209       AND ((Recinfo.Attribute12 = X_Attribute12)
210           OR ((Recinfo.Attribute12 IS NULL)
211           AND (X_Attribute12 IS NULL)))
212       AND ((Recinfo.Attribute13 = X_Attribute13)
213           OR ((Recinfo.Attribute13 IS NULL)
214           AND (X_Attribute13 IS NULL)))
215       AND ((Recinfo.Attribute14 = X_Attribute14)
216           OR ((Recinfo.Attribute14 IS NULL)
217           AND (X_Attribute14 IS NULL)))
218       AND ((Recinfo.Attribute15 = X_Attribute15)
219           OR ((Recinfo.Attribute15 IS NULL)
220           AND (X_Attribute15 IS NULL)))
221       AND ((Recinfo.Attribute_Category_Code = X_Attribute_Category_Code)
222           OR ((Recinfo.Attribute_Category_Code IS NULL)
223           AND (X_Attribute_Category_Code IS NULL)))
224      ) then
225       return;
226   else
227       FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
228       APP_EXCEPTION.Raise_Exception;
229   end if;
230 
231 end LOCK_ROW;
232 
233 procedure UPDATE_ROW (
234   X_ITC_AMOUNT_ID in NUMBER,
235   X_TAX_YEAR in NUMBER,
236   X_LIFE_IN_MONTHS in NUMBER,
237   X_ITC_AMOUNT_RATE in NUMBER,
238   X_BASIS_REDUCTION_RATE in NUMBER,
239   X_ATTRIBUTE1 in VARCHAR2,
240   X_ATTRIBUTE2 in VARCHAR2,
241   X_ATTRIBUTE3 in VARCHAR2,
242   X_ATTRIBUTE4 in VARCHAR2,
243   X_ATTRIBUTE5 in VARCHAR2,
244   X_ATTRIBUTE6 in VARCHAR2,
245   X_ATTRIBUTE7 in VARCHAR2,
246   X_ATTRIBUTE8 in VARCHAR2,
247   X_ATTRIBUTE9 in VARCHAR2,
248   X_ATTRIBUTE10 in VARCHAR2,
249   X_ATTRIBUTE11 in VARCHAR2,
250   X_ATTRIBUTE12 in VARCHAR2,
251   X_ATTRIBUTE13 in VARCHAR2,
252   X_ATTRIBUTE14 in VARCHAR2,
253   X_ATTRIBUTE15 in VARCHAR2,
254   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
255   X_LAST_UPDATE_DATE in DATE,
256   X_LAST_UPDATED_BY in NUMBER,
257   X_LAST_UPDATE_LOGIN in NUMBER
258 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
259 
260 begin
261 
262   UPDATE fa_itc_rates
263   SET    itc_amount_id = X_Itc_Amount_Id,
264          tax_year = X_Tax_Year,
265          life_in_months = X_Life_In_Months,
266          itc_amount_rate = X_Itc_Amount_Rate,
267          basis_reduction_rate = X_Basis_Reduction_Rate,
268          attribute1 = X_Attribute1,
269          attribute2 = X_Attribute2,
270          attribute3 = X_Attribute3,
271          attribute4 = X_Attribute4,
272          attribute5 = X_Attribute5,
273          attribute6 = X_Attribute5,
274          attribute7 = X_Attribute7,
275          attribute8 = X_Attribute8,
276          attribute9 = X_Attribute9,
277          attribute10 = X_Attribute10,
278          attribute11 = X_Attribute11,
279          attribute12 = X_Attribute12,
280          attribute13 = X_Attribute13,
281          attribute14 = X_Attribute14,
282          attribute15 = X_Attribute15,
283          attribute_category_code = X_Attribute_Category_Code,
284          last_update_date = X_Last_Update_Date,
285          last_updated_by = X_Last_Updated_By,
286          last_update_login = X_Last_Update_Login
287   WHERE  itc_amount_id = X_Itc_Amount_Id;
288 
289   if (SQL%NOTFOUND) then
290      Raise NO_DATA_FOUND;
291   end if;
292 
293   exception
294     when others then
295         fa_srvr_msg.add_sql_error(
296                 calling_fn => 'fa_itc_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);
297         raise;
298 
299 end UPDATE_ROW;
300 
301 procedure DELETE_ROW (
302   X_ITC_AMOUNT_ID in NUMBER
303 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
304 
305 begin
306 
307   DELETE FROM fa_itc_rates
308   WHERE  itc_amount_id = X_Itc_Amount_Id;
309 
310   if (SQL%NOTFOUND) then
311      Raise NO_DATA_FOUND;
312   end if;
313 
314   exception
315     when others then
316         fa_srvr_msg.add_sql_error(
317                 calling_fn => 'fa_itc_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);
318         raise;
319 
320 end DELETE_ROW;
321 
322 procedure LOAD_ROW (
323   X_ITC_AMOUNT_ID in NUMBER,
324   X_OWNER in VARCHAR2,
325   X_TAX_YEAR in NUMBER,
326   X_LIFE_IN_MONTHS in NUMBER,
327   X_ITC_AMOUNT_RATE in NUMBER,
328   X_BASIS_REDUCTION_RATE in NUMBER,
329   X_ATTRIBUTE1 in VARCHAR2,
330   X_ATTRIBUTE2 in VARCHAR2,
331   X_ATTRIBUTE3 in VARCHAR2,
332   X_ATTRIBUTE4 in VARCHAR2,
333   X_ATTRIBUTE5 in VARCHAR2,
334   X_ATTRIBUTE6 in VARCHAR2,
335   X_ATTRIBUTE7 in VARCHAR2,
336   X_ATTRIBUTE8 in VARCHAR2,
337   X_ATTRIBUTE9 in VARCHAR2,
338   X_ATTRIBUTE10 in VARCHAR2,
339   X_ATTRIBUTE11 in VARCHAR2,
340   X_ATTRIBUTE12 in VARCHAR2,
341   X_ATTRIBUTE13 in VARCHAR2,
342   X_ATTRIBUTE14 in VARCHAR2,
343   X_ATTRIBUTE15 in VARCHAR2,
344   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
345 , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) is
346 
347   h_record_exists       number(15);
348 
349   user_id               number;
350   row_id                varchar2(64);
351 
352 begin
353 
354   if (X_Owner = 'SEED') then
355      user_id := 1;
356   else
357      user_id := 0;
358   end if;
359 
360   select count(*)
361   into h_record_exists
362   from fa_itc_rates
363   where itc_amount_id = X_Itc_Amount_Id;
364 
365   if (h_record_exists > 0) then
366      fa_itc_rates_pkg.update_row (
367 	X_Itc_Amount_Id			=> X_Itc_Amount_Id,
368 	X_Tax_Year			=> X_Tax_Year,
369 	X_Life_In_Months		=> X_Life_In_Months,
370 	X_Itc_Amount_Rate		=> X_Itc_Amount_Rate,
371 	X_Basis_Reduction_Rate		=> X_Basis_Reduction_Rate,
372 	X_Attribute1			=> X_Attribute1,
373 	X_Attribute2			=> X_Attribute2,
374 	X_Attribute3			=> X_Attribute3,
375 	X_Attribute4			=> X_Attribute4,
379 	X_Attribute8			=> X_Attribute8,
376 	X_Attribute5			=> X_Attribute5,
377 	X_Attribute6			=> X_Attribute6,
378 	X_Attribute7			=> X_Attribute7,
380 	X_Attribute9			=> X_Attribute9,
381 	X_Attribute10			=> X_Attribute10,
382 	X_Attribute11			=> X_Attribute11,
383 	X_Attribute12			=> X_Attribute12,
384 	X_Attribute13			=> X_Attribute13,
385 	X_Attribute14			=> X_Attribute14,
386 	X_Attribute15			=> X_Attribute15,
387 	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
388 	X_Last_Update_Date		=> sysdate,
389 	X_Last_Updated_By		=> user_id,
390 	X_Last_Update_Login		=> 0
391      , p_log_level_rec => p_log_level_rec);
392   else
393      fa_itc_rates_pkg.insert_row (
394 	X_Rowid				=> row_id,
395 	X_Itc_Amount_Id			=> X_Itc_Amount_Id,
396 	X_Tax_Year			=> X_Tax_Year,
397 	X_Life_In_Months		=> X_Life_In_Months,
398 	X_Itc_Amount_Rate		=> X_Itc_Amount_Rate,
399 	X_Basis_Reduction_Rate		=> X_Basis_Reduction_Rate,
400 	X_Attribute1			=> X_Attribute1,
401 	X_Attribute2			=> X_Attribute2,
402 	X_Attribute3			=> X_Attribute3,
403 	X_Attribute4			=> X_Attribute4,
404 	X_Attribute5			=> X_Attribute5,
405 	X_Attribute6			=> X_Attribute6,
406 	X_Attribute7			=> X_Attribute7,
407 	X_Attribute8			=> X_Attribute8,
408 	X_Attribute9			=> X_Attribute9,
409 	X_Attribute10			=> X_Attribute10,
410 	X_Attribute11			=> X_Attribute11,
411 	X_Attribute12			=> X_Attribute12,
412 	X_Attribute13			=> X_Attribute13,
413 	X_Attribute14			=> X_Attribute14,
414 	X_Attribute15			=> X_Attribute15,
415 	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
416 	X_Creation_Date			=> sysdate,
417 	X_Created_By			=> user_id,
418 	x_Last_Update_Date		=> sysdate,
419 	X_Last_Updated_By		=> user_id,
420 	X_Last_Update_Login		=> 0
421      , p_log_level_rec => p_log_level_rec);
422   end if;
423 
424 exception
425   when others then
426        FA_STANDARD_PKG.RAISE_ERROR(
427                       CALLED_FN => 'fa_itc_rates_pkg.load_row',
428                       CALLING_FN => 'upload fa_itc_rates', p_log_level_rec => p_log_level_rec);
429 
430 end LOAD_ROW;
431 
432 /*Bug 8355119 overloading function for release specific signatures*/
433 
434 procedure LOAD_ROW (
435   X_CUSTOM_MODE in VARCHAR2,
436   X_ITC_AMOUNT_ID in NUMBER,
437   X_OWNER in VARCHAR2,
438   X_LAST_UPDATE_DATE in DATE,
439   X_TAX_YEAR in NUMBER,
440   X_LIFE_IN_MONTHS in NUMBER,
441   X_ITC_AMOUNT_RATE in NUMBER,
442   X_BASIS_REDUCTION_RATE in NUMBER,
443   X_ATTRIBUTE1 in VARCHAR2,
444   X_ATTRIBUTE2 in VARCHAR2,
445   X_ATTRIBUTE3 in VARCHAR2,
446   X_ATTRIBUTE4 in VARCHAR2,
447   X_ATTRIBUTE5 in VARCHAR2,
448   X_ATTRIBUTE6 in VARCHAR2,
449   X_ATTRIBUTE7 in VARCHAR2,
450   X_ATTRIBUTE8 in VARCHAR2,
451   X_ATTRIBUTE9 in VARCHAR2,
452   X_ATTRIBUTE10 in VARCHAR2,
453   X_ATTRIBUTE11 in VARCHAR2,
454   X_ATTRIBUTE12 in VARCHAR2,
455   X_ATTRIBUTE13 in VARCHAR2,
456   X_ATTRIBUTE14 in VARCHAR2,
457   X_ATTRIBUTE15 in VARCHAR2,
458   X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
459   p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type default null) is
460 
461   h_record_exists       number(15);
462 
463   user_id               number;
464   row_id                varchar2(64);
465 
466   db_last_updated_by    number;
467   db_last_update_date   date;
468 
469 begin
470 
471   user_id := fnd_load_util.owner_id (X_Owner);
472 
473   select count(*)
474   into h_record_exists
475   from fa_itc_rates
476   where itc_amount_id = X_Itc_Amount_Id;
477 
478   if (h_record_exists > 0) then
479 
480      select last_updated_by, last_update_date
481      into   db_last_updated_by, db_last_update_date
482      from fa_itc_rates
483      where itc_amount_id = X_Itc_Amount_Id;
484 
485      if (fnd_load_util.upload_test(user_id, x_last_update_date,
486                                    db_last_updated_by, db_last_update_date,
487                                    X_CUSTOM_MODE)) then
488 
489         fa_itc_rates_pkg.update_row (
490            X_Itc_Amount_Id           => X_Itc_Amount_Id,
491            X_Tax_Year                => X_Tax_Year,
492            X_Life_In_Months          => X_Life_In_Months,
493            X_Itc_Amount_Rate         => X_Itc_Amount_Rate,
494            X_Basis_Reduction_Rate    => X_Basis_Reduction_Rate,
495            X_Attribute1              => X_Attribute1,
496            X_Attribute2              => X_Attribute2,
497            X_Attribute3              => X_Attribute3,
498            X_Attribute4              => X_Attribute4,
499            X_Attribute5              => X_Attribute5,
500            X_Attribute6              => X_Attribute6,
501            X_Attribute7              => X_Attribute7,
502            X_Attribute8              => X_Attribute8,
503            X_Attribute9              => X_Attribute9,
504            X_Attribute10             => X_Attribute10,
505            X_Attribute11             => X_Attribute11,
506            X_Attribute12             => X_Attribute12,
507            X_Attribute13             => X_Attribute13,
508            X_Attribute14             => X_Attribute14,
509            X_Attribute15             => X_Attribute15,
510            X_Attribute_Category_Code => X_Attribute_Category_Code,
511            X_Last_Update_Date        => sysdate,
512            X_Last_Updated_By         => user_id,
513            X_Last_Update_Login       => 0
514            ,p_log_level_rec => p_log_level_rec);
515      end if;
516   else
517      fa_itc_rates_pkg.insert_row (
518 	X_Rowid				=> row_id,
519 	X_Itc_Amount_Id			=> X_Itc_Amount_Id,
520 	X_Tax_Year			=> X_Tax_Year,
521 	X_Life_In_Months		=> X_Life_In_Months,
522 	X_Itc_Amount_Rate		=> X_Itc_Amount_Rate,
526 	X_Attribute3			=> X_Attribute3,
523 	X_Basis_Reduction_Rate		=> X_Basis_Reduction_Rate,
524 	X_Attribute1			=> X_Attribute1,
525 	X_Attribute2			=> X_Attribute2,
527 	X_Attribute4			=> X_Attribute4,
528 	X_Attribute5			=> X_Attribute5,
529 	X_Attribute6			=> X_Attribute6,
530 	X_Attribute7			=> X_Attribute7,
531 	X_Attribute8			=> X_Attribute8,
532 	X_Attribute9			=> X_Attribute9,
533 	X_Attribute10			=> X_Attribute10,
534 	X_Attribute11			=> X_Attribute11,
535 	X_Attribute12			=> X_Attribute12,
536 	X_Attribute13			=> X_Attribute13,
537 	X_Attribute14			=> X_Attribute14,
538 	X_Attribute15			=> X_Attribute15,
539 	X_Attribute_Category_Code	=> X_Attribute_Category_Code,
540 	X_Creation_Date			=> sysdate,
541 	X_Created_By			=> user_id,
542 	x_Last_Update_Date		=> sysdate,
543 	X_Last_Updated_By		=> user_id,
544 	X_Last_Update_Login		=> 0
545 	,p_log_level_rec => p_log_level_rec);
546   end if;
547 
548 exception
549   when others then
550        FA_STANDARD_PKG.RAISE_ERROR(
551                       CALLED_FN => 'fa_itc_rates_pkg.load_row',
552                       CALLING_FN => 'upload fa_itc_rates'
553                       ,p_log_level_rec => p_log_level_rec);
554 
555 end LOAD_ROW;
556 
557 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
558 procedure LOAD_SEED_ROW (
559           x_upload_mode                 IN VARCHAR2,
560           x_custom_mode                 IN VARCHAR2,
561           x_itc_amount_id               IN NUMBER,
562           x_owner                       IN VARCHAR2,
563           x_last_update_date            IN DATE,
564           x_tax_year                    IN NUMBER,
565           x_life_in_months              IN NUMBER,
566           x_itc_amount_rate             IN NUMBER,
567           x_basis_reduction_rate        IN NUMBER,
568           x_attribute1                  IN VARCHAR2,
569           x_attribute2                  IN VARCHAR2,
570           x_attribute3                  IN VARCHAR2,
571           x_attribute4                  IN VARCHAR2,
572           x_attribute5                  IN VARCHAR2,
573           x_attribute6                  IN VARCHAR2,
574           x_attribute7                  IN VARCHAR2,
575           x_attribute8                  IN VARCHAR2,
576           x_attribute9                  IN VARCHAR2,
577           x_attribute10                 IN VARCHAR2,
578           x_attribute11                 IN VARCHAR2,
579           x_attribute12                 IN VARCHAR2,
580           x_attribute13                 IN VARCHAR2,
581           x_attribute14                 IN VARCHAR2,
582           x_attribute15                 IN VARCHAR2,
583           x_attribute_category_code     IN VARCHAR2) IS
584 
585 
586 BEGIN
587 
588       if (x_upload_mode = 'NLS') then
589          null;
590       else
591         fa_itc_rates_pkg.LOAD_ROW (
592           x_custom_mode                 => x_custom_mode,
593           x_itc_amount_id               => x_itc_amount_id,
594           x_owner                       => x_owner,
595           x_last_update_date            => x_last_update_date,
596           x_tax_year                    => x_tax_year,
597           x_life_in_months              => x_life_in_months,
598           x_itc_amount_rate             => x_itc_amount_rate,
599           x_basis_reduction_rate        => x_basis_reduction_rate,
600           x_attribute1                  => x_attribute1,
601           x_attribute2                  => x_attribute2,
602           x_attribute3                  => x_attribute3,
603           x_attribute4                  => x_attribute4,
604           x_attribute5                  => x_attribute5,
605           x_attribute6                  => x_attribute6,
606           x_attribute7                  => x_attribute7,
607           x_attribute8                  => x_attribute8,
608           x_attribute9                  => x_attribute9,
609           x_attribute10                 => x_attribute10,
610           x_attribute11                 => x_attribute11,
611           x_attribute12                 => x_attribute12,
612           x_attribute13                 => x_attribute13,
613           x_attribute14                 => x_attribute14,
614           x_attribute15                 => x_attribute15,
615           x_attribute_category_code     => x_attribute_category_code);
616       end if;
617 
618 END LOAD_SEED_ROW;
619 
620 END FA_ITC_RATES_PKG;