[Home] [Help]
27: X_CREATED_BY in NUMBER,
28: X_LAST_UPDATE_DATE in DATE,
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 default null) is
32:
33: CURSOR C is SELECT rowid FROM fa_ceiling_types
34: WHERE ceiling_name = X_Ceiling_Name;
35: begin
125: X_ATTRIBUTE13 in VARCHAR2,
126: X_ATTRIBUTE14 in VARCHAR2,
127: X_ATTRIBUTE15 in VARCHAR2,
128: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
129: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
130: CURSOR C is
131: SELECT ceiling_name,
132: ceiling_type,
133: currency_code,
247: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
248: X_LAST_UPDATE_DATE in DATE,
249: X_LAST_UPDATED_BY in NUMBER,
250: X_LAST_UPDATE_LOGIN in NUMBER,
251: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
252:
253: begin
254:
255: UPDATE fa_ceiling_types
292: end UPDATE_ROW;
293:
294: procedure DELETE_ROW (
295: X_CEILING_NAME in VARCHAR2
296: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
297:
298: begin
299:
300: DELETE FROM fa_ceiling_types
336: X_ATTRIBUTE13 in VARCHAR2,
337: X_ATTRIBUTE14 in VARCHAR2,
338: X_ATTRIBUTE15 in VARCHAR2,
339: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
340: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
341:
342: h_record_exists number(15);
343:
344: user_id number;