[Home] [Help]
29: X_CREATED_BY in NUMBER,
30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER,
33: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
34: cursor C is select ROWID from FA_LOOKUPS_B
35: where LOOKUP_TYPE = X_LOOKUP_TYPE
36: and LOOKUP_CODE = X_LOOKUP_CODE
37: ;
158: X_ATTRIBUTE15 in VARCHAR2,
159: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
160: X_MEANING in VARCHAR2,
161: X_DESCRIPTION in VARCHAR2,
162: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
163: cursor c is select
164: ENABLED_FLAG,
165: START_DATE_ACTIVE,
166: END_DATE_ACTIVE,
288: X_DESCRIPTION in VARCHAR2,
289: X_LAST_UPDATE_DATE in DATE,
290: X_LAST_UPDATED_BY in NUMBER,
291: X_LAST_UPDATE_LOGIN in NUMBER,
292: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
293: begin
294: update FA_LOOKUPS_B set
295: ENABLED_FLAG = X_ENABLED_FLAG,
296: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
339:
340: procedure DELETE_ROW (
341: X_LOOKUP_TYPE in VARCHAR2,
342: X_LOOKUP_CODE in VARCHAR2,
343: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
344: begin
345: delete from FA_LOOKUPS_TL
346: where LOOKUP_TYPE = X_LOOKUP_TYPE
347: and LOOKUP_CODE = X_LOOKUP_CODE;
358: raise no_data_found;
359: end if;
360: end DELETE_ROW;
361:
362: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
363: is
364: begin
365: delete from FA_LOOKUPS_TL T
366: where not exists
459: X_ATTRIBUTE13 in VARCHAR2,
460: X_ATTRIBUTE14 in VARCHAR2,
461: X_ATTRIBUTE15 in VARCHAR2,
462: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
463: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
464:
465: h_record_exists number(15);
466:
467: user_id number;
571: X_OWNER in VARCHAR2,
572: X_LAST_UPDATE_DATE in DATE,
573: X_MEANING in VARCHAR2,
574: X_DESCRIPTION in VARCHAR2,
575: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
576:
577: user_id number;
578:
579: db_last_updated_by number;