DBA Data[Home] [Help]

APPS.FA_DEPRN_RULE_DETAILS_PKG dependencies on FA_API_TYPES

Line 20: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

16: p_last_updated_by NUMBER,
17: p_created_by NUMBER,
18: p_creation_date DATE,
19: p_last_update_login NUMBER,
20: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
21: CURSOR C is SELECT FA_DEPRN_RULE_DETAILS_S.nextval from sys.dual;
22:
23: CURSOR C_RULE is
24: select deprn_basis_rule_id

Line 111: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

107: p_use_eofy_reserve_flag VARCHAR2,
108: p_last_update_date DATE,
109: p_last_updated_by NUMBER,
110: p_last_update_login NUMBER,
111: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
112: CURSOR C IS
113: Select deprn_rule_detail_id,
114: deprn_basis_rule_id,
115: rule_name,

Line 179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

175: p_use_eofy_reserve_flag VARCHAR2,
176: p_last_update_date DATE,
177: p_last_updated_by NUMBER,
178: p_last_update_login NUMBER,
179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
180:
181: BEGIN
182:
183: UPDATE FA_DEPRN_RULE_DETAILS

Line 208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

204:
205: END Update_Row;
206:
207: PROCEDURE Delete_Row(p_deprn_rule_detail_id NUMBER,
208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
209: BEGIN
210:
211: DELETE FROM fa_deprn_rule_details
212: WHERE deprn_rule_detail_id = p_deprn_rule_detail_id;

Line 240: p_log_level_rec IN FA_API_TYPES.log_level_rec_type

236: p_period_update_flag IN VARCHAR2,
237: p_subtract_ytd_flag IN VARCHAR2,
238: p_allow_reduction_rate_flag IN VARCHAR2,
239: p_use_eofy_reserve_flag IN VARCHAR2,
240: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
241: default null ) IS
242:
243:
244: