7:
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: FUNCTION calc_fin_info
11: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: FUNCTION calc_fin_info
11: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
9:
10: FUNCTION calc_fin_info
11: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
10: FUNCTION calc_fin_info
11: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
11: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
14: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
22: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
15: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
22: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
23: p_period_rec IN FA_API_TYPES.period_rec_type,
16: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
22: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
23: p_period_rec IN FA_API_TYPES.period_rec_type,
24: p_reclassed_asset_id IN NUMBER default null,
17: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
22: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
23: p_period_rec IN FA_API_TYPES.period_rec_type,
24: p_reclassed_asset_id IN NUMBER default null,
25: p_reclass_src_dest IN VARCHAR2 default null,
18: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
22: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
23: p_period_rec IN FA_API_TYPES.period_rec_type,
24: p_reclassed_asset_id IN NUMBER default null,
25: p_reclass_src_dest IN VARCHAR2 default null,
26: p_reclassed_asset_dpis IN DATE default null,
19: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
20: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
21: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
22: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
23: p_period_rec IN FA_API_TYPES.period_rec_type,
24: p_reclassed_asset_id IN NUMBER default null,
25: p_reclass_src_dest IN VARCHAR2 default null,
26: p_reclassed_asset_dpis IN DATE default null,
27: p_mrc_sob_type_code IN VARCHAR2,
24: p_reclassed_asset_id IN NUMBER default null,
25: p_reclass_src_dest IN VARCHAR2 default null,
26: p_reclassed_asset_dpis IN DATE default null,
27: p_mrc_sob_type_code IN VARCHAR2,
28: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
29: p_calling_fn IN VARCHAR2
30: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
31:
32:
26: p_reclassed_asset_dpis IN DATE default null,
27: p_mrc_sob_type_code IN VARCHAR2,
28: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
29: p_calling_fn IN VARCHAR2
30: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
31:
32:
33: l_adjust_type varchar2(15);
34: l_deprn_exp number := 0;
44: l_cost_to_insert number := 0;
45: l_clearing_to_insert number := 0;
46:
47: l_jdpis number;
48: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
49:
50: -- used for method cache
51: l_method_id number;
52: l_rate_source_rule varchar2(10);
159: -- Bug4958977: following 2 new variables
160: l_temp_thid number;
161: l_dpis_change boolean := FALSE;
162:
163: l_trans_rec FA_API_TYPES.trans_rec_type;
164: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
160: l_temp_thid number;
161: l_dpis_change boolean := FALSE;
162:
163: l_trans_rec FA_API_TYPES.trans_rec_type;
164: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
168: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
161: l_dpis_change boolean := FALSE;
162:
163: l_trans_rec FA_API_TYPES.trans_rec_type;
164: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
168: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
169: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; --Bug7008015
162:
163: l_trans_rec FA_API_TYPES.trans_rec_type;
164: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
168: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
169: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; --Bug7008015
170:
163: l_trans_rec FA_API_TYPES.trans_rec_type;
164: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
168: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
169: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; --Bug7008015
170:
171: l_recognize_gain_loss VARCHAR2(5); -- Bug8244128
164: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
168: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
169: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; --Bug7008015
170:
171: l_recognize_gain_loss VARCHAR2(5); -- Bug8244128
172:
165: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
166: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
167: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
168: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
169: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type; --Bug7008015
170:
171: l_recognize_gain_loss VARCHAR2(5); -- Bug8244128
172:
173: calc_err EXCEPTION;
2582: END calc_fin_info;
2583:
2584:
2585: FUNCTION calc_new_amounts
2586: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2587: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2583:
2584:
2585: FUNCTION calc_new_amounts
2586: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2587: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2584:
2585: FUNCTION calc_new_amounts
2586: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2587: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2585: FUNCTION calc_new_amounts
2586: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2587: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2586: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2587: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2587: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2588: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2596: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2589: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2596: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2597: p_mrc_sob_type_code IN VARCHAR2
2590: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2596: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2597: p_mrc_sob_type_code IN VARCHAR2
2598: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2591: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2596: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2597: p_mrc_sob_type_code IN VARCHAR2
2598: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2599:
2592: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2593: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2596: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2597: p_mrc_sob_type_code IN VARCHAR2
2598: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2599:
2600: l_reval_ceiling_adj NUMBER; -- BUG 2620221
2594: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2595: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2596: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2597: p_mrc_sob_type_code IN VARCHAR2
2598: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2599:
2600: l_reval_ceiling_adj NUMBER; -- BUG 2620221
2601:
2602: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_new_amounts';
2908:
2909: END calc_new_amounts;
2910:
2911: FUNCTION calc_derived_amounts
2912: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2909: END calc_new_amounts;
2910:
2911: FUNCTION calc_derived_amounts
2912: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2910:
2911: FUNCTION calc_derived_amounts
2912: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2911: FUNCTION calc_derived_amounts
2912: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2912: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2914: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2915: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2923: p_period_rec IN FA_API_TYPES.period_rec_type,
2916: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2923: p_period_rec IN FA_API_TYPES.period_rec_type,
2924: p_mrc_sob_type_code IN VARCHAR2
2917: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2923: p_period_rec IN FA_API_TYPES.period_rec_type,
2924: p_mrc_sob_type_code IN VARCHAR2
2925: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2918: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2923: p_period_rec IN FA_API_TYPES.period_rec_type,
2924: p_mrc_sob_type_code IN VARCHAR2
2925: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2926:
2919: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2920: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2923: p_period_rec IN FA_API_TYPES.period_rec_type,
2924: p_mrc_sob_type_code IN VARCHAR2
2925: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2926:
2927: l_count number := 0;
2921: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2922: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2923: p_period_rec IN FA_API_TYPES.period_rec_type,
2924: p_mrc_sob_type_code IN VARCHAR2
2925: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2926:
2927: l_count number := 0;
2928: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_derived_amounts';
2929: calc_err EXCEPTION;
3066: END calc_derived_amounts;
3067:
3068:
3069: FUNCTION calc_prorate_date
3070: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3071: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3072: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3073: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3074: p_period_rec IN FA_API_TYPES.period_rec_type
3067:
3068:
3069: FUNCTION calc_prorate_date
3070: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3071: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3072: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3073: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3074: p_period_rec IN FA_API_TYPES.period_rec_type
3075: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3068:
3069: FUNCTION calc_prorate_date
3070: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3071: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3072: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3073: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3074: p_period_rec IN FA_API_TYPES.period_rec_type
3075: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3076:
3069: FUNCTION calc_prorate_date
3070: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3071: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3072: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3073: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3074: p_period_rec IN FA_API_TYPES.period_rec_type
3075: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3076:
3077: l_count number:= 0;
3070: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3071: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3072: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3073: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3074: p_period_rec IN FA_API_TYPES.period_rec_type
3075: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3076:
3077: l_count number:= 0;
3078: l_prorate_calendar varchar2(15);
3071: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3072: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3073: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3074: p_period_rec IN FA_API_TYPES.period_rec_type
3075: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3076:
3077: l_count number:= 0;
3078: l_prorate_calendar varchar2(15);
3079: l_fiscal_year_name varchar2(30);
3171:
3172: END calc_prorate_date;
3173:
3174: FUNCTION calc_deprn_start_date
3175: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3176: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3178: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3179:
3172: END calc_prorate_date;
3173:
3174: FUNCTION calc_deprn_start_date
3175: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3176: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3178: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3179:
3180: l_dwaf varchar2(3);
3173:
3174: FUNCTION calc_deprn_start_date
3175: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3176: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3178: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3179:
3180: l_dwaf varchar2(3);
3181: l_fiscal_year_name varchar2(30);
3174: FUNCTION calc_deprn_start_date
3175: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3176: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3178: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3179:
3180: l_dwaf varchar2(3);
3181: l_fiscal_year_name varchar2(30);
3182: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_deprn_start_date';
3218: END calc_deprn_start_date;
3219:
3220:
3221: FUNCTION calc_rec_cost
3222: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3223: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3224: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3225: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3226:
3219:
3220:
3221: FUNCTION calc_rec_cost
3222: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3223: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3224: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3225: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3226:
3227: CURSOR c_get_rec_cost_w_ceiling IS
3220:
3221: FUNCTION calc_rec_cost
3222: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3223: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3224: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3225: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3226:
3227: CURSOR c_get_rec_cost_w_ceiling IS
3228: select least(px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value,
3221: FUNCTION calc_rec_cost
3222: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3223: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3224: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3225: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3226:
3227: CURSOR c_get_rec_cost_w_ceiling IS
3228: select least(px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value,
3229: nvl(ce.limit, px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value))
3310: END calc_rec_cost;
3311:
3312:
3313: FUNCTION calc_deprn_limit_adj_rec_cost
3314: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3315: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3316: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3317: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3318: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3311:
3312:
3313: FUNCTION calc_deprn_limit_adj_rec_cost
3314: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3315: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3316: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3317: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3318: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3319: p_called_from_faxama IN BOOLEAN DEFAULT FALSE, -- Bug 6604235
3312:
3313: FUNCTION calc_deprn_limit_adj_rec_cost
3314: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3315: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3316: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3317: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3318: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3319: p_called_from_faxama IN BOOLEAN DEFAULT FALSE, -- Bug 6604235
3320: p_mrc_sob_type_code IN VARCHAR2
3313: FUNCTION calc_deprn_limit_adj_rec_cost
3314: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3315: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3316: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3317: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3318: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3319: p_called_from_faxama IN BOOLEAN DEFAULT FALSE, -- Bug 6604235
3320: p_mrc_sob_type_code IN VARCHAR2
3321: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3314: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3315: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3316: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3317: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3318: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3319: p_called_from_faxama IN BOOLEAN DEFAULT FALSE, -- Bug 6604235
3320: p_mrc_sob_type_code IN VARCHAR2
3321: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3322:
3317: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3318: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3319: p_called_from_faxama IN BOOLEAN DEFAULT FALSE, -- Bug 6604235
3320: p_mrc_sob_type_code IN VARCHAR2
3321: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3322:
3323: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_limit';
3324: calc_err EXCEPTION;
3325:
3633: END calc_deprn_limit_adj_rec_cost;
3634:
3635:
3636: FUNCTION calc_itc_info
3637: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3638: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3639: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3640: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3641:
3634:
3635:
3636: FUNCTION calc_itc_info
3637: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3638: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3639: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3640: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3641:
3642:
3635:
3636: FUNCTION calc_itc_info
3637: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3638: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3639: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3640: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3641:
3642:
3643: l_itc_amount_rate number;
3636: FUNCTION calc_itc_info
3637: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3638: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3639: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
3640: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3641:
3642:
3643: l_itc_amount_rate number;
3644: l_basis_reduction_rate number;
3706:
3707: END calc_itc_info;
3708:
3709: FUNCTION calc_salvage_value
3710: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3711: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3712: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3707: END calc_itc_info;
3708:
3709: FUNCTION calc_salvage_value
3710: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3711: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3712: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3715: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3708:
3709: FUNCTION calc_salvage_value
3710: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3711: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3712: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3715: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3716: p_mrc_sob_type_code IN VARCHAR2
3709: FUNCTION calc_salvage_value
3710: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3711: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3712: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3715: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3716: p_mrc_sob_type_code IN VARCHAR2
3717: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3710: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3711: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3712: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3715: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3716: p_mrc_sob_type_code IN VARCHAR2
3717: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3718:
3711: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3712: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3715: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3716: p_mrc_sob_type_code IN VARCHAR2
3717: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3718:
3719: calc_err EXCEPTION;
3713: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3714: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3715: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3716: p_mrc_sob_type_code IN VARCHAR2
3717: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3718:
3719: calc_err EXCEPTION;
3720: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_salvage_value';
3721:
3908: END calc_salvage_value;
3909:
3910:
3911: FUNCTION calc_subcomp_life
3912: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3914: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3909:
3910:
3911: FUNCTION calc_subcomp_life
3912: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3914: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3910:
3911: FUNCTION calc_subcomp_life
3912: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3914: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3918: p_calling_fn IN VARCHAR2
3911: FUNCTION calc_subcomp_life
3912: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3914: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3918: p_calling_fn IN VARCHAR2
3919: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3912: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3914: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3918: p_calling_fn IN VARCHAR2
3919: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3920:
3913: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3914: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3918: p_calling_fn IN VARCHAR2
3919: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3920:
3921: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3915: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3916: p_period_rec IN FA_API_TYPES.period_rec_type,
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3918: p_calling_fn IN VARCHAR2
3919: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3920:
3921: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3922: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';
3923:
3917: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3918: p_calling_fn IN VARCHAR2
3919: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
3920:
3921: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3922: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';
3923:
3924: CURSOR RATE_DEF IS
3925: SELECT DISTINCT RATE_SOURCE_RULE
4199:
4200:
4201:
4202: FUNCTION calc_flags
4203: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4204: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4200:
4201:
4202: FUNCTION calc_flags
4203: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4204: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4201:
4202: FUNCTION calc_flags
4203: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4204: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4209: p_period_rec IN FA_API_TYPES.period_rec_type
4202: FUNCTION calc_flags
4203: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4204: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4209: p_period_rec IN FA_API_TYPES.period_rec_type
4210: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4203: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4204: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4209: p_period_rec IN FA_API_TYPES.period_rec_type
4210: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4211:
4204: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4209: p_period_rec IN FA_API_TYPES.period_rec_type
4210: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4211:
4212: l_first_period number := 0;
4205: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4209: p_period_rec IN FA_API_TYPES.period_rec_type
4210: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4211:
4212: l_first_period number := 0;
4213:
4206: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4207: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4208: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4209: p_period_rec IN FA_API_TYPES.period_rec_type
4210: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4211:
4212: l_first_period number := 0;
4213:
4214: l_current_fiscal_year number;
4492: END calc_flags;
4493:
4494:
4495: FUNCTION calc_deprn_info
4496: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4497: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4493:
4494:
4495: FUNCTION calc_deprn_info
4496: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4497: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4494:
4495: FUNCTION calc_deprn_info
4496: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4497: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4495: FUNCTION calc_deprn_info
4496: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4497: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4496: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4497: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4497: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4498: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4506: p_period_rec IN FA_API_TYPES.period_rec_type
4499: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4506: p_period_rec IN FA_API_TYPES.period_rec_type
4507: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4500: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4506: p_period_rec IN FA_API_TYPES.period_rec_type
4507: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4508:
4501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4506: p_period_rec IN FA_API_TYPES.period_rec_type
4507: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4508:
4509: l_count number;
4502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4506: p_period_rec IN FA_API_TYPES.period_rec_type
4507: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4508:
4509: l_count number;
4510: l_result boolean;
4503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4504: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4505: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4506: p_period_rec IN FA_API_TYPES.period_rec_type
4507: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4508:
4509: l_count number;
4510: l_result boolean;
4511: l_unit_of_measure FA_BOOKS.UNIT_OF_MEASURE%TYPE;
4813: END calc_deprn_info;
4814:
4815:
4816: FUNCTION calc_group_info
4817: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4818: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4814:
4815:
4816: FUNCTION calc_group_info
4817: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4818: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4822: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
4815:
4816: FUNCTION calc_group_info
4817: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4818: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4822: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
4823: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
4816: FUNCTION calc_group_info
4817: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4818: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4822: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
4823: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
4824:
4817: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4818: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4822: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
4823: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
4824:
4825: CURSOR c_find_member_asset IS
4818: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4822: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
4823: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
4824:
4825: CURSOR c_find_member_asset IS
4826: SELECT 'Y'
4819: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4820: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4821: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4822: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
4823: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
4824:
4825: CURSOR c_find_member_asset IS
4826: SELECT 'Y'
4827: FROM FA_BOOKS
5219:
5220: END calc_group_info;
5221:
5222: FUNCTION calc_member_info
5223: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5220: END calc_group_info;
5221:
5222: FUNCTION calc_member_info
5223: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5228: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
5221:
5222: FUNCTION calc_member_info
5223: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5228: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
5229: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5222: FUNCTION calc_member_info
5223: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5228: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
5229: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5230:
5223: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5228: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
5229: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5230:
5231: CURSOR c_get_group_values IS
5224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5228: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
5229: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5230:
5231: CURSOR c_get_group_values IS
5232: SELECT recognize_gain_loss,
5225: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5226: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5227: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5228: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type
5229: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5230:
5231: CURSOR c_get_group_values IS
5232: SELECT recognize_gain_loss,
5233: recapture_reserve_flag,
5474: --RELOCATED
5475: --RELOCATED Relocated to FAVAMRTB.pls
5476: --RELOCATED
5477: --RELOCATED FUNCTION calc_raf_adj_cost
5478: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5479: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5475: --RELOCATED Relocated to FAVAMRTB.pls
5476: --RELOCATED
5477: --RELOCATED FUNCTION calc_raf_adj_cost
5478: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5479: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5476: --RELOCATED
5477: --RELOCATED FUNCTION calc_raf_adj_cost
5478: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5479: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5477: --RELOCATED FUNCTION calc_raf_adj_cost
5478: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5479: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5485: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
5478: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
5479: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5485: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
5486: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
5479: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5485: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
5486: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
5487: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
5480: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5485: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
5486: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
5487: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
5488: --RELOCATED ) RETURN BOOLEAN IS
5481: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5485: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
5486: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
5487: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
5488: --RELOCATED ) RETURN BOOLEAN IS
5489: --RELOCATED
5482: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5483: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5484: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
5485: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
5486: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
5487: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
5488: --RELOCATED ) RETURN BOOLEAN IS
5489: --RELOCATED
5490: --RELOCATED
5496: --RELOCATED
5497:
5498:
5499: FUNCTION calc_standalone_info
5500: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
5501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5497:
5498:
5499: FUNCTION calc_standalone_info
5500: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
5501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5505: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5498:
5499: FUNCTION calc_standalone_info
5500: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
5501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5505: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5506:
5499: FUNCTION calc_standalone_info
5500: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
5501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5505: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5506:
5507: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
5500: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
5501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5505: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5506:
5507: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
5508:
5501: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5502: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5503: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
5504: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type
5505: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
5506:
5507: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
5508:
5509: BEGIN