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_BONUS_RATES_PKG

Source


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