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) 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) 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) 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) is
299: cursor c is select
300: SUMMARY_FLAG,
301: ENABLED_FLAG,
302: OWNED_LEASED,

Line 568: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

564: X_INVENTORIAL in VARCHAR2,
565: X_LAST_UPDATE_DATE in DATE,
566: X_LAST_UPDATED_BY in NUMBER,
567: X_LAST_UPDATE_LOGIN in NUMBER
568: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
569: begin
570: update FA_CATEGORIES_B set
571: SUMMARY_FLAG = X_SUMMARY_FLAG,
572: ENABLED_FLAG = X_ENABLED_FLAG,

Line 652: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

648: end UPDATE_ROW;
649:
650: procedure DELETE_ROW (
651: X_CATEGORY_ID in NUMBER
652: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
653: begin
654: delete from FA_CATEGORIES_TL
655: where CATEGORY_ID = X_CATEGORY_ID;
656:

Line 789: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

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

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

1003: X_GF_ATTRIBUTE18 in VARCHAR2 DEFAULT NULL,
1004: X_GF_ATTRIBUTE19 in VARCHAR2 DEFAULT NULL,
1005: X_GF_ATTRIBUTE20 in VARCHAR2 DEFAULT NULL,
1006: X_GF_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
1007: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
1008:
1009: h_record_exists number(15);
1010:
1011: user_id number;

Line 1179: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

1175:
1176: procedure TRANSLATE_ROW (
1177: X_CATEGORY_ID in NUMBER,
1178: X_DESCRIPTION in VARCHAR2
1179: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
1180: begin
1181:
1182: update FA_CATEGORIES_TL set
1183: DESCRIPTION = nvl(X_Description, DESCRIPTION),

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

1203: X_CATEGORY_ID in NUMBER,
1204: X_OWNER in VARCHAR2,
1205: X_LAST_UPDATE_DATE in DATE,
1206: X_DESCRIPTION in VARCHAR2,
1207: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
1208:
1209: user_id number;
1210:
1211: db_last_updated_by number;