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.

APPS.FA_CEILINGS_PKG dependencies on FA_CEILINGS

Line 1: PACKAGE BODY FA_CEILINGS_PKG as

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,

Line 34: CURSOR C is SELECT rowid FROM fa_ceilings

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:

Line 41: INSERT INTO fa_ceilings (

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,

Line 108: calling_fn => 'fa_ceilings_pkg.insert_row', p_log_level_rec => p_log_level_rec);

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;

Line 159: FROM fa_ceilings

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;

Line 272: UPDATE fa_ceilings

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,

Line 307: calling_fn => 'fa_ceilings_pkg.update_row', p_log_level_rec => p_log_level_rec);

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:

Line 320: DELETE FROM fa_ceilings

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:

Line 332: calling_fn => 'fa_ceilings_pkg.delete_row', p_log_level_rec => p_log_level_rec);

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:

Line 377: from fa_ceilings

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:

Line 384: fa_ceilings_pkg.update_row (

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,

Line 411: fa_ceilings_pkg.insert_row (

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,

Line 445: CALLED_FN => 'fa_ceilings_pkg.load_row',

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:

Line 446: CALLING_FN => 'upload fa_ceilings', p_log_level_rec => p_log_level_rec);

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*/

Line 492: from fa_ceilings

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:

Line 501: from fa_ceilings

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:

Line 510: fa_ceilings_pkg.update_row (

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,

Line 538: fa_ceilings_pkg.insert_row (

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,

Line 572: CALLED_FN => 'fa_ceilings_pkg.load_row',

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;

Line 573: CALLING_FN => 'upload fa_ceilings'

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:

Line 612: fa_ceilings_pkg.LOAD_ROW (

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,

Line 641: END FA_CEILINGS_PKG;

637: end if;
638:
639: END load_seed_row;
640:
641: END FA_CEILINGS_PKG;