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_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.8 2009/04/10 07:41:36 deemitta 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) 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', p_log_level_rec => p_log_level_rec);

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:

Line 150: FROM fa_ceiling_types

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:

Line 255: UPDATE fa_ceiling_types

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,

Line 288: calling_fn => 'fa_ceiling_types_pkg.update_row', p_log_level_rec => p_log_level_rec);

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:

Line 299: DELETE FROM fa_ceiling_types

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;

Line 309: calling_fn => 'fa_ceiling_types_pkg.delete_row', p_log_level_rec => p_log_level_rec);

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:

Line 353: from fa_ceiling_types

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 (

Line 357: fa_ceiling_types_pkg.update_row (

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,

Line 383: fa_ceiling_types_pkg.insert_row (

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,

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

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:

Line 417: CALLING_FN => 'upload fa_ceiling_types', p_log_level_rec => p_log_level_rec);

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

Line 462: from fa_ceiling_types

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:

Line 469: from fa_ceiling_types

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,

Line 476: fa_ceiling_types_pkg.update_row (

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,

Line 503: fa_ceiling_types_pkg.insert_row (

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,

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

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;

Line 537: CALLING_FN => 'upload fa_ceiling_types'

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:

Line 575: fa_ceiling_types_pkg.LOAD_ROW (

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,

Line 605: END FA_CEILING_TYPES_PKG;

601:
602: END LOAD_SEED_ROW;
603:
604:
605: END FA_CEILING_TYPES_PKG;