DBA Data[Home] [Help]

APPS.FA_CATEGORIES_PKG dependencies on FA_API_TYPES

Line 68: p_log_level_rec in fa_api_types.log_level_rec_type default null) is

64: X_CREATED_BY in NUMBER,
65: X_LAST_UPDATE_DATE in DATE,
66: X_LAST_UPDATED_BY in NUMBER,
67: X_LAST_UPDATE_LOGIN in NUMBER,
68: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
69: cursor C is select ROWID from FA_CATEGORIES_B
70: where CATEGORY_ID = X_CATEGORY_ID
71: ;
72: begin

Line 298: p_log_level_rec in fa_api_types.log_level_rec_type default null) is

294: X_GLOBAL_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
295: X_GLOBAL_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
296: X_GLOBAL_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
297: X_INVENTORIAL in VARCHAR2,
298: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
299: cursor c is select
300: SUMMARY_FLAG,
301: ENABLED_FLAG,
302: OWNED_LEASED,

Line 566: p_log_level_rec in fa_api_types.log_level_rec_type default null) is

562: X_INVENTORIAL in VARCHAR2,
563: X_LAST_UPDATE_DATE in DATE,
564: X_LAST_UPDATED_BY in NUMBER,
565: X_LAST_UPDATE_LOGIN in NUMBER,
566: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
567: begin
568: update FA_CATEGORIES_B set
569: SUMMARY_FLAG = X_SUMMARY_FLAG,
570: ENABLED_FLAG = X_ENABLED_FLAG,

Line 650: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is

646: end UPDATE_ROW;
647:
648: procedure DELETE_ROW (
649: X_CATEGORY_ID in NUMBER
650: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
651: begin
652: delete from FA_CATEGORIES_TL
653: where CATEGORY_ID = X_CATEGORY_ID;
654:

Line 667: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

663: raise no_data_found;
664: end if;
665: end DELETE_ROW;
666:
667: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
668: is
669: begin
670: delete from FA_CATEGORIES_TL T
671: where not exists

Line 790: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is

786: X_GF_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
787: X_GF_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
788: X_GF_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
789: X_GF_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
790: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
791:
792: h_record_exists number(15);
793:
794: user_id number;

Line 965: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is

961: X_CATEGORY_ID in NUMBER,
962: X_OWNER in VARCHAR2,
963: X_LAST_UPDATE_DATE in DATE,
964: X_DESCRIPTION in VARCHAR2,
965: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
966:
967: user_id number;
968:
969: db_last_updated_by number;