11: p_book_type_code IN VARCHAR2,
12: p_amortize_flag IN VARCHAR2 := 'NO',
13: p_mr_req_id IN NUMBER := -1,
14: x_rule_change_exists OUT NOCOPY BOOLEAN,
15: x_old_rules OUT NOCOPY FA_LOAD_TBL_PKG.asset_deprn_info,
16: x_new_rules OUT NOCOPY FA_LOAD_TBL_PKG.asset_deprn_info,
17: x_use_rules OUT NOCOPY BOOLEAN,
18: x_prorate_date OUT NOCOPY DATE,
19: x_rate_source_rule OUT NOCOPY VARCHAR2,
12: p_amortize_flag IN VARCHAR2 := 'NO',
13: p_mr_req_id IN NUMBER := -1,
14: x_rule_change_exists OUT NOCOPY BOOLEAN,
15: x_old_rules OUT NOCOPY FA_LOAD_TBL_PKG.asset_deprn_info,
16: x_new_rules OUT NOCOPY FA_LOAD_TBL_PKG.asset_deprn_info,
17: x_use_rules OUT NOCOPY BOOLEAN,
18: x_prorate_date OUT NOCOPY DATE,
19: x_rate_source_rule OUT NOCOPY VARCHAR2,
20: x_deprn_basis_rule OUT NOCOPY VARCHAR2,
18: x_prorate_date OUT NOCOPY DATE,
19: x_rate_source_rule OUT NOCOPY VARCHAR2,
20: x_deprn_basis_rule OUT NOCOPY VARCHAR2,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
22: l_old_rules FA_LOAD_TBL_PKG.asset_deprn_info;
23: l_new_rules FA_LOAD_TBL_PKG.asset_deprn_info;
24: l_found BOOLEAN := FALSE;
25: CURSOR get_old_rules IS
26: SELECT book_type_code,
19: x_rate_source_rule OUT NOCOPY VARCHAR2,
20: x_deprn_basis_rule OUT NOCOPY VARCHAR2,
21: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
22: l_old_rules FA_LOAD_TBL_PKG.asset_deprn_info;
23: l_new_rules FA_LOAD_TBL_PKG.asset_deprn_info;
24: l_found BOOLEAN := FALSE;
25: CURSOR get_old_rules IS
26: SELECT book_type_code,
27: date_placed_in_service, date_placed_in_service,
44: FETCH get_old_rules INTO l_old_rules;
45: CLOSE get_old_rules;
46:
47: /* Get new depreciation rules. */
48: FA_LOAD_TBL_PKG.Get_Deprn_Rules(
49: p_book_type_code => p_book_type_code,
50: p_date_placed_in_service => l_old_rules.start_dpis,
51: x_deprn_rules_rec => l_new_rules,
52: x_found => l_found,