APPS.FA_CEILING_TYPES_PKG dependencies on FA_CEILING_TYPES

Line 1: PACKAGE BODY FA_CEILING_TYPES_PKG as

1: PACKAGE BODY FA_CEILING_TYPES_PKG as
2: /* $Header: faxictyb.pls 120.6 2005/07/28 00:20:36 tkawamur ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 33: CURSOR C is SELECT rowid FROM fa_ceiling_types

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 default null) 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 (

Line 37: INSERT INTO fa_ceiling_types (

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,

Line 102: calling_fn => 'fa_ceiling_types_pkg.insert_row'

98:
99: exception
100: when others then
101: fa_srvr_msg.add_sql_error(
102: calling_fn => 'fa_ceiling_types_pkg.insert_row'
103: ,p_log_level_rec => p_log_level_rec);
104: raise;
105:
106: end INSERT_ROW;

Line 151: FROM fa_ceiling_types

147: attribute13,
148: attribute14,
149: attribute15,
150: attribute_category_code
151: FROM fa_ceiling_types
152: WHERE ceiling_name = X_Ceiling_Name
153: FOR UPDATE of ceiling_name NOWAIT;
154: Recinfo C%ROWTYPE;
155:

Line 255: UPDATE fa_ceiling_types

251: p_log_level_rec in fa_api_types.log_level_rec_type default null) 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,

Line 288: calling_fn => 'fa_ceiling_types_pkg.update_row'

284:
285: exception
286: when others then
287: fa_srvr_msg.add_sql_error(
288: calling_fn => 'fa_ceiling_types_pkg.update_row'
289: ,p_log_level_rec => p_log_level_rec);
290: raise;
291:
292: end UPDATE_ROW;

Line 300: DELETE FROM fa_ceiling_types

296: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
297:
298: begin
299:
300: DELETE FROM fa_ceiling_types
301: WHERE ceiling_name = X_Ceiling_Name;
302:
303: if (SQL%NOTFOUND) then
304: Raise NO_DATA_FOUND;

Line 310: calling_fn => 'fa_ceiling_types_pkg.delete_row'

306:
307: exception
308: when others then
309: fa_srvr_msg.add_sql_error(
310: calling_fn => 'fa_ceiling_types_pkg.delete_row'
311: ,p_log_level_rec => p_log_level_rec);
312: raise;
313:
314: end DELETE_ROW;

Line 356: from fa_ceiling_types

352: user_id := fnd_load_util.owner_id (X_Owner);
353:
354: select count(*)
355: into h_record_exists
356: from fa_ceiling_types
357: where ceiling_name = X_Ceiling_Name;
358:
359: if (h_record_exists > 0) then
360:

Line 363: from fa_ceiling_types

359: if (h_record_exists > 0) then
360:
361: select last_updated_by, last_update_date
362: into db_last_updated_by, db_last_update_date
363: from fa_ceiling_types
364: where ceiling_name = X_Ceiling_Name;
365:
366: if (fnd_load_util.upload_test(user_id, x_last_update_date,
367: db_last_updated_by, db_last_update_date,

Line 370: fa_ceiling_types_pkg.update_row (

366: if (fnd_load_util.upload_test(user_id, x_last_update_date,
367: db_last_updated_by, db_last_update_date,
368: X_CUSTOM_MODE)) then
369:
370: fa_ceiling_types_pkg.update_row (
371: X_Ceiling_Type => X_Ceiling_Type,
372: X_Ceiling_Name => X_Ceiling_Name,
373: X_Currency_Code => X_Currency_Code,
374: X_Description => X_Description,

Line 397: fa_ceiling_types_pkg.insert_row (

393: X_Last_Update_Login => 0
394: ,p_log_level_rec => p_log_level_rec);
395: end if;
396: else
397: fa_ceiling_types_pkg.insert_row (
398: X_Rowid => row_id,
399: X_Ceiling_Type => X_Ceiling_Type,
400: X_Ceiling_Name => X_Ceiling_Name,
401: X_Currency_Code => X_Currency_Code,

Line 430: CALLED_FN => 'fa_ceiling_types.load_row',

426:
427: exception
428: when others then
429: FA_STANDARD_PKG.RAISE_ERROR(
430: CALLED_FN => 'fa_ceiling_types.load_row',
431: CALLING_FN => 'upload fa_ceiling_types'
432: ,p_log_level_rec => p_log_level_rec);
433:
434: end LOAD_ROW;

Line 431: CALLING_FN => 'upload fa_ceiling_types'

427: exception
428: when others then
429: FA_STANDARD_PKG.RAISE_ERROR(
430: CALLED_FN => 'fa_ceiling_types.load_row',
431: CALLING_FN => 'upload fa_ceiling_types'
432: ,p_log_level_rec => p_log_level_rec);
433:
434: end LOAD_ROW;
435:

Line 468: fa_ceiling_types_pkg.LOAD_ROW (

464:
465: if (x_upload_mode = 'NLS') then
466: null;
467: else
468: fa_ceiling_types_pkg.LOAD_ROW (
469: x_custom_mode => x_custom_mode,
470: x_ceiling_type => x_ceiling_type,
471: x_ceiling_name => x_ceiling_name,
472: x_owner => x_owner,

Line 497: END FA_CEILING_TYPES_PKG;

493: end if;
494:
495: END LOAD_SEED_ROW;
496:
497: END FA_CEILING_TYPES_PKG;