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) is
32:
33: CURSOR C is SELECT rowid FROM fa_bonus_rates
34: where bonus_rule = X_Bonus_Rule
35: and start_year = X_Start_Year;
126: X_ATTRIBUTE13 in VARCHAR2,
127: X_ATTRIBUTE14 in VARCHAR2,
128: X_ATTRIBUTE15 in VARCHAR2,
129: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
131: CURSOR C is
132: SELECT bonus_rule,
133: start_year,
134: end_year,
250: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
251: X_LAST_UPDATE_DATE in DATE,
252: X_LAST_UPDATED_BY in NUMBER,
253: X_LAST_UPDATE_LOGIN in NUMBER
254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
255:
256: begin
257: ad_zd_seed.prepare('fa_bonus_rates');
258: UPDATE fa_bonus_rates
295:
296: procedure DELETE_ROW (
297: X_BONUS_RULE in VARCHAR2,
298: X_START_YEAR in NUMBER
299: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
300:
301: begin
302: ad_zd_seed.prepare('fa_bonus_rates');
303: DELETE FROM fa_bonus_rates
338: X_ATTRIBUTE13 in VARCHAR2,
339: X_ATTRIBUTE14 in VARCHAR2,
340: X_ATTRIBUTE15 in VARCHAR2,
341: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2
342: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
343:
344: h_record_exists number(15);
345:
346: user_id number;
449: X_ATTRIBUTE13 in VARCHAR2,
450: X_ATTRIBUTE14 in VARCHAR2,
451: X_ATTRIBUTE15 in VARCHAR2,
452: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
453: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
454:
455: h_record_exists number(15);
456:
457: user_id number;