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.6 2005/07/28 00:20:41 tkawamur 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 default null) 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'

104:
105: exception
106: when others then
107: fa_srvr_msg.add_sql_error(
108: calling_fn => 'fa_ceilings_pkg.insert_row'
109: ,p_log_level_rec => p_log_level_rec);
110: raise;
111:
112:

Line 160: FROM fa_ceilings

156: attribute13,
157: attribute14,
158: attribute15,
159: attribute_category_code
160: FROM fa_ceilings
161: WHERE ceiling_name = X_Ceiling_Name
162: AND start_date = X_Start_Date
163: AND nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999)
164: 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 default null) 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'

303:
304: exception
305: when others then
306: fa_srvr_msg.add_sql_error(
307: calling_fn => 'fa_ceilings_pkg.update_row'
308: ,p_log_level_rec => p_log_level_rec);
309: raise;
310:
311: end UPDATE_ROW;

Line 321: DELETE FROM fa_ceilings

317: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
318:
319: begin
320:
321: DELETE FROM fa_ceilings
322: WHERE ceiling_name = X_Ceiling_Name
323: AND start_date = X_Start_Date
324: AND nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);
325:

Line 333: calling_fn => 'fa_ceilings_pkg.delete_row'

329:
330: exception
331: when others then
332: fa_srvr_msg.add_sql_error(
333: calling_fn => 'fa_ceilings_pkg.delete_row'
334: ,p_log_level_rec => p_log_level_rec);
335: raise;
336:
337: end DELETE_ROW;

Line 380: from fa_ceilings

376: user_id := fnd_load_util.owner_id (X_Owner);
377:
378: select count(*)
379: into h_record_exists
380: from fa_ceilings
381: where ceiling_name = X_Ceiling_Name
382: and start_date = X_Start_Date
383: and nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);
384:

Line 389: from fa_ceilings

385: if (h_record_exists > 0) then
386:
387: select last_updated_by, last_update_date
388: into db_last_updated_by, db_last_update_date
389: from fa_ceilings
390: where ceiling_name = X_Ceiling_Name
391: and start_date = X_Start_Date
392: and nvl (year_of_life, -9999) = nvl (X_Year_Of_Life, -9999);
393:

Line 398: fa_ceilings_pkg.update_row (

394: if (fnd_load_util.upload_test(user_id, x_last_update_date,
395: db_last_updated_by, db_last_update_date,
396: X_CUSTOM_MODE)) then
397:
398: fa_ceilings_pkg.update_row (
399: X_Ceiling_Name => X_Ceiling_Name,
400: X_Start_Date => X_Start_Date,
401: X_End_Date => X_End_Date,
402: X_Year_Of_Life => X_Year_Of_Life,

Line 426: fa_ceilings_pkg.insert_row (

422: X_Last_Update_Login => 0
423: ,p_log_level_rec => p_log_level_rec);
424: end if;
425: else
426: fa_ceilings_pkg.insert_row (
427: X_Rowid => row_id,
428: X_Ceiling_Name => X_Ceiling_Name,
429: X_Start_Date => X_Start_Date,
430: X_End_Date => X_End_Date,

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

456:
457: exception
458: when others then
459: FA_STANDARD_PKG.RAISE_ERROR(
460: CALLED_FN => 'fa_ceilings_pkg.load_row',
461: CALLING_FN => 'upload fa_ceilings'
462: ,p_log_level_rec => p_log_level_rec);
463:
464: end LOAD_ROW;

Line 461: CALLING_FN => 'upload fa_ceilings'

457: exception
458: when others then
459: FA_STANDARD_PKG.RAISE_ERROR(
460: CALLED_FN => 'fa_ceilings_pkg.load_row',
461: CALLING_FN => 'upload fa_ceilings'
462: ,p_log_level_rec => p_log_level_rec);
463:
464: end LOAD_ROW;
465:

Line 499: fa_ceilings_pkg.LOAD_ROW (

495:
496: if (x_upload_mode = 'NLS') then
497: null;
498: else
499: fa_ceilings_pkg.LOAD_ROW (
500: x_custom_mode => x_custom_mode,
501: x_ceiling_name => x_ceiling_name,
502: x_start_date => x_start_date,
503: x_end_date => x_end_date,

Line 528: END FA_CEILINGS_PKG;

524: end if;
525:
526: END load_seed_row;
527:
528: END FA_CEILINGS_PKG;