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_CEILINGS_PKG

Source


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