DBA Data[Home] [Help]

APPS.FA_DEPRN_RULE_DETAILS_PKG dependencies on FA_API_TYPES

Line 21: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 114: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

110: p_use_rsv_after_imp_flag VARCHAR2 DEFAULT NULL,
111: p_last_update_date DATE,
112: p_last_updated_by NUMBER,
113: p_last_update_login NUMBER
114: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
115: CURSOR C IS
116: Select
117: deprn_rule_detail_id,
118: deprn_basis_rule_id,

Line 187: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

183: p_use_rsv_after_imp_flag VARCHAR2 DEFAULT NULL,
184: p_last_update_date DATE,
185: p_last_updated_by NUMBER,
186: p_last_update_login NUMBER
187: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
188:
189: BEGIN
190:
191: UPDATE FA_DEPRN_RULE_DETAILS

Line 216: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

212:
213: END Update_Row;
214:
215: PROCEDURE Delete_Row(p_deprn_rule_detail_id NUMBER
216: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
217: BEGIN
218:
219: DELETE FROM fa_deprn_rule_details
220: WHERE deprn_rule_detail_id = p_deprn_rule_detail_id;

Line 246: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

242: p_subtract_ytd_flag VARCHAR2,
243: p_allow_reduction_rate_flag VARCHAR2,
244: p_use_eofy_reserve_flag VARCHAR2,
245: p_use_rsv_after_imp_flag VARCHAR2 DEFAULT NULL
246: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
247:
248: h_record_exists number(15);
249: h_deprn_basis_rule_id number(15);
250: h_deprn_rule_detail_id number(15);

Line 335: p_log_level_rec IN FA_API_TYPES.log_level_rec_type

331: p_subtract_ytd_flag IN VARCHAR2,
332: p_allow_reduction_rate_flag IN VARCHAR2,
333: p_use_eofy_reserve_flag IN VARCHAR2,
334: p_use_rsv_after_imp_flag IN VARCHAR2 DEFAULT NULL,
335: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
336: default null ) IS
337:
338:
339: