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_CEILING_TYPES_PKG

Source


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