[Home] [Help]
28: X_CREATED_BY in NUMBER,
29: X_LAST_UPDATE_DATE in DATE,
30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
33:
34: CURSOR C is SELECT rowid FROM fa_ceilings
35: WHERE ceiling_name = X_Ceiling_Name
36: AND start_date = X_Start_Date
132: X_ATTRIBUTE13 in VARCHAR2,
133: X_ATTRIBUTE14 in VARCHAR2,
134: X_ATTRIBUTE15 in VARCHAR2,
135: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
136: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
137:
138: CURSOR C is SELECT ceiling_name,
139: start_date,
140: year_of_life,
264: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
265: X_LAST_UPDATE_DATE in DATE,
266: X_LAST_UPDATED_BY in NUMBER,
267: X_LAST_UPDATE_LOGIN in NUMBER
268: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
269:
270: begin
271:
272: UPDATE fa_ceilings
312: procedure DELETE_ROW (
313: X_CEILING_NAME in VARCHAR2,
314: X_START_DATE in DATE,
315: X_YEAR_OF_LIFE in NUMBER
316: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
317:
318: begin
319:
320: DELETE FROM fa_ceilings
356: X_ATTRIBUTE13 in VARCHAR2,
357: X_ATTRIBUTE14 in VARCHAR2,
358: X_ATTRIBUTE15 in VARCHAR2,
359: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
360: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
361:
362: h_record_exists number(15);
363:
364: user_id number;
472: X_ATTRIBUTE13 in VARCHAR2,
473: X_ATTRIBUTE14 in VARCHAR2,
474: X_ATTRIBUTE15 in VARCHAR2,
475: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
476: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
477:
478: h_record_exists number(15);
479:
480: user_id number;