[Home] [Help]
10: X_CREATED_BY in NUMBER,
11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER,
14: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
15: cursor C is select ROWID from FA_LOOKUP_TYPES_B
16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin
78: X_LOOKUP_TYPE in VARCHAR2,
79: X_USER_MAINTAINABLE in VARCHAR2,
80: X_MEANING in VARCHAR2,
81: X_DESCRIPTION in VARCHAR2,
82: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
83: cursor c is select
84: USER_MAINTAINABLE
85: from FA_LOOKUP_TYPES_B
86: where LOOKUP_TYPE = X_LOOKUP_TYPE
132: X_DESCRIPTION in VARCHAR2,
133: X_LAST_UPDATE_DATE in DATE,
134: X_LAST_UPDATED_BY in NUMBER,
135: X_LAST_UPDATE_LOGIN in NUMBER,
136: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
137: begin
138: update FA_LOOKUP_TYPES_B set
139: USER_MAINTAINABLE = X_USER_MAINTAINABLE,
140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
162: end UPDATE_ROW;
163:
164: procedure DELETE_ROW (
165: X_LOOKUP_TYPE in VARCHAR2
166: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
167: begin
168: delete from FA_LOOKUP_TYPES_TL
169: where LOOKUP_TYPE = X_LOOKUP_TYPE;
170:
179: raise no_data_found;
180: end if;
181: end DELETE_ROW;
182:
183: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
184: is
185: begin
186: delete from FA_LOOKUP_TYPES_TL T
187: where not exists
251: X_LAST_UPDATE_DATE in DATE,
252: X_MEANING in VARCHAR2,
253: X_DESCRIPTION in VARCHAR2,
254: X_USER_MAINTAINABLE in VARCHAR2,
255: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
256:
257: h_record_exists number(15);
258:
259: user_id number;
322: X_OWNER in VARCHAR2,
323: X_LAST_UPDATE_DATE in DATE,
324: X_MEANING in VARCHAR2,
325: X_DESCRIPTION in VARCHAR2,
326: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
327:
328: user_id number;
329:
330: db_last_updated_by number;