APPS.FA_CEILINGS_PKG dependencies on FA_CEILINGS_PKG

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 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 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 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 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 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 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;