DBA Data[Home] [Help]

APPS.FA_BONUS_RATES_PKG dependencies on FA_API_TYPES

Line 31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

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;

Line 130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

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,

Line 254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

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

Line 299: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

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

Line 342: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

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;

Line 453: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is

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;