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 default null) 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 default null) 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 131: p_log_level_rec in fa_api_types.log_level_rec_type default null) is

127: X_ATTRIBUTE13 in VARCHAR2,
128: X_ATTRIBUTE14 in VARCHAR2,
129: X_ATTRIBUTE15 in VARCHAR2,
130: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
131: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
132: CURSOR C is
133: SELECT bonus_rule,
134: start_year,
135: end_year,

Line 253: p_log_level_rec in fa_api_types.log_level_rec_type default null) is

249: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
250: X_LAST_UPDATE_DATE in DATE,
251: X_LAST_UPDATED_BY in NUMBER,
252: X_LAST_UPDATE_LOGIN in NUMBER,
253: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
254:
255: begin
256:
257: UPDATE fa_bonus_rates

Line 299: p_log_level_rec in fa_api_types.log_level_rec_type default null) 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 default null) is
300:
301: begin
302:
303: DELETE FROM fa_bonus_rates

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

341: X_ATTRIBUTE13 in VARCHAR2,
342: X_ATTRIBUTE14 in VARCHAR2,
343: X_ATTRIBUTE15 in VARCHAR2,
344: X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
345: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
346:
347: h_record_exists number(15);
348:
349: user_id number;