5: G_primary_salvage_value NUMBER;
6: G_primary_deprn_limit_amount NUMBER;
7:
8: FUNCTION calc_fin_info
9: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6: G_primary_deprn_limit_amount NUMBER;
7:
8: FUNCTION calc_fin_info
9: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
7:
8: FUNCTION calc_fin_info
9: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
8: FUNCTION calc_fin_info
9: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
9: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
10: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
10: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
11: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
20: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
20: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
21: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
20: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
21: p_period_rec IN FA_API_TYPES.period_rec_type,
22: p_reclassed_asset_id IN NUMBER default null,
15: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
20: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
21: p_period_rec IN FA_API_TYPES.period_rec_type,
22: p_reclassed_asset_id IN NUMBER default null,
23: p_reclass_src_dest IN VARCHAR2 default null,
16: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
20: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
21: p_period_rec IN FA_API_TYPES.period_rec_type,
22: p_reclassed_asset_id IN NUMBER default null,
23: p_reclass_src_dest IN VARCHAR2 default null,
24: p_reclassed_asset_dpis IN DATE default null,
17: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
18: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
19: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
20: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
21: p_period_rec IN FA_API_TYPES.period_rec_type,
22: p_reclassed_asset_id IN NUMBER default null,
23: p_reclass_src_dest IN VARCHAR2 default null,
24: p_reclassed_asset_dpis IN DATE default null,
25: p_mrc_sob_type_code IN VARCHAR2,
22: p_reclassed_asset_id IN NUMBER default null,
23: p_reclass_src_dest IN VARCHAR2 default null,
24: p_reclassed_asset_dpis IN DATE default null,
25: p_mrc_sob_type_code IN VARCHAR2,
26: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
27: p_calling_fn IN VARCHAR2,
28: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
29: ) RETURN BOOLEAN IS
30:
24: p_reclassed_asset_dpis IN DATE default null,
25: p_mrc_sob_type_code IN VARCHAR2,
26: p_group_reclass_options_rec IN OUT NOCOPY FA_API_TYPES.group_reclass_options_rec_type,
27: p_calling_fn IN VARCHAR2,
28: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
29: ) RETURN BOOLEAN IS
30:
31:
32: l_adjust_type varchar2(15);
40: l_clearing number := 0;
41: l_cost_to_insert number := 0;
42: l_clearing_to_insert number := 0;
43: l_jdpis number;
44: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
45:
46: -- used for method cache
47: l_method_id number;
48: l_rate_source_rule varchar2(10);
112: -- Bug4958977: following 2 new variables
113: l_temp_thid number;
114: l_dpis_change boolean := FALSE;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
119: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
120: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
113: l_temp_thid number;
114: l_dpis_change boolean := FALSE;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
119: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
120: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
121: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
114: l_dpis_change boolean := FALSE;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
119: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
120: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
121: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
122:
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
119: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
120: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
121: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
122:
123:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
119: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
120: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
121: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
122:
123:
124: calc_err EXCEPTION;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
119: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
120: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
121: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
122:
123:
124: calc_err EXCEPTION;
125:
1918: END calc_fin_info;
1919:
1920:
1921: FUNCTION calc_new_amounts
1922: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1923: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1919:
1920:
1921: FUNCTION calc_new_amounts
1922: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1923: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1920:
1921: FUNCTION calc_new_amounts
1922: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1923: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1921: FUNCTION calc_new_amounts
1922: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1923: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1922: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
1923: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1923: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1924: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1932: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1925: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1932: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1933: p_mrc_sob_type_code IN VARCHAR2,
1926: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1932: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1933: p_mrc_sob_type_code IN VARCHAR2,
1934: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1927: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1932: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1933: p_mrc_sob_type_code IN VARCHAR2,
1934: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1935: ) RETURN BOOLEAN IS
1928: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
1929: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1932: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1933: p_mrc_sob_type_code IN VARCHAR2,
1934: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1935: ) RETURN BOOLEAN IS
1936:
1930: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
1931: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
1932: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
1933: p_mrc_sob_type_code IN VARCHAR2,
1934: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1935: ) RETURN BOOLEAN IS
1936:
1937: l_reval_ceiling_adj NUMBER; -- BUG 2620221
1938:
2219:
2220: END calc_new_amounts;
2221:
2222: FUNCTION calc_derived_amounts
2223: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2220: END calc_new_amounts;
2221:
2222: FUNCTION calc_derived_amounts
2223: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2221:
2222: FUNCTION calc_derived_amounts
2223: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2222: FUNCTION calc_derived_amounts
2223: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2223: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
2224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2224: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2225: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2226: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2234: p_period_rec IN FA_API_TYPES.period_rec_type,
2227: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2234: p_period_rec IN FA_API_TYPES.period_rec_type,
2235: p_mrc_sob_type_code IN VARCHAR2,
2228: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2234: p_period_rec IN FA_API_TYPES.period_rec_type,
2235: p_mrc_sob_type_code IN VARCHAR2,
2236: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2229: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2234: p_period_rec IN FA_API_TYPES.period_rec_type,
2235: p_mrc_sob_type_code IN VARCHAR2,
2236: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2237: ) RETURN BOOLEAN IS
2230: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2231: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2234: p_period_rec IN FA_API_TYPES.period_rec_type,
2235: p_mrc_sob_type_code IN VARCHAR2,
2236: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2237: ) RETURN BOOLEAN IS
2238:
2232: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
2233: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
2234: p_period_rec IN FA_API_TYPES.period_rec_type,
2235: p_mrc_sob_type_code IN VARCHAR2,
2236: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2237: ) RETURN BOOLEAN IS
2238:
2239: l_count number := 0;
2240: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_derived_amounts';
2372: END calc_derived_amounts;
2373:
2374:
2375: FUNCTION calc_prorate_date
2376: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2377: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2378: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2379: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2380: p_period_rec IN FA_API_TYPES.period_rec_type,
2373:
2374:
2375: FUNCTION calc_prorate_date
2376: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2377: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2378: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2379: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2380: p_period_rec IN FA_API_TYPES.period_rec_type,
2381: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2374:
2375: FUNCTION calc_prorate_date
2376: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2377: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2378: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2379: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2380: p_period_rec IN FA_API_TYPES.period_rec_type,
2381: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2382: ) RETURN BOOLEAN IS
2375: FUNCTION calc_prorate_date
2376: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2377: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2378: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2379: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2380: p_period_rec IN FA_API_TYPES.period_rec_type,
2381: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2382: ) RETURN BOOLEAN IS
2383:
2376: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2377: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2378: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2379: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2380: p_period_rec IN FA_API_TYPES.period_rec_type,
2381: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2382: ) RETURN BOOLEAN IS
2383:
2384: l_count number:= 0;
2377: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2378: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2379: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2380: p_period_rec IN FA_API_TYPES.period_rec_type,
2381: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2382: ) RETURN BOOLEAN IS
2383:
2384: l_count number:= 0;
2385: l_prorate_calendar varchar2(15);
2479:
2480: END calc_prorate_date;
2481:
2482: FUNCTION calc_deprn_start_date
2483: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2484: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2485: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2486: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2487: ) RETURN BOOLEAN IS
2480: END calc_prorate_date;
2481:
2482: FUNCTION calc_deprn_start_date
2483: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2484: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2485: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2486: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2487: ) RETURN BOOLEAN IS
2488:
2481:
2482: FUNCTION calc_deprn_start_date
2483: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2484: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2485: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2486: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2487: ) RETURN BOOLEAN IS
2488:
2489: l_dwaf varchar2(3);
2482: FUNCTION calc_deprn_start_date
2483: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2484: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2485: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2486: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2487: ) RETURN BOOLEAN IS
2488:
2489: l_dwaf varchar2(3);
2490: l_fiscal_year_name varchar2(30);
2528: END calc_deprn_start_date;
2529:
2530:
2531: FUNCTION calc_rec_cost
2532: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2533: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2534: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2535: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2536: ) RETURN BOOLEAN IS
2529:
2530:
2531: FUNCTION calc_rec_cost
2532: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2533: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2534: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2535: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2536: ) RETURN BOOLEAN IS
2537:
2530:
2531: FUNCTION calc_rec_cost
2532: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2533: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2534: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2535: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2536: ) RETURN BOOLEAN IS
2537:
2538: CURSOR c_get_rec_cost_w_ceiling IS
2531: FUNCTION calc_rec_cost
2532: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2533: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2534: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2535: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2536: ) RETURN BOOLEAN IS
2537:
2538: CURSOR c_get_rec_cost_w_ceiling IS
2539: select least(px_asset_fin_rec_new.cost - px_asset_fin_rec_new.salvage_value,
2621: END calc_rec_cost;
2622:
2623:
2624: FUNCTION calc_deprn_limit_adj_rec_cost
2625: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2626: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2627: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2628: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2629: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2622:
2623:
2624: FUNCTION calc_deprn_limit_adj_rec_cost
2625: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2626: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2627: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2628: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2629: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2630: p_mrc_sob_type_code IN VARCHAR2,
2623:
2624: FUNCTION calc_deprn_limit_adj_rec_cost
2625: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2626: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2627: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2628: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2629: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2630: p_mrc_sob_type_code IN VARCHAR2,
2631: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2624: FUNCTION calc_deprn_limit_adj_rec_cost
2625: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2626: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2627: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2628: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2629: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2630: p_mrc_sob_type_code IN VARCHAR2,
2631: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2632: ) RETURN BOOLEAN IS
2625: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2626: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2627: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2628: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2629: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2630: p_mrc_sob_type_code IN VARCHAR2,
2631: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2632: ) RETURN BOOLEAN IS
2633:
2627: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2628: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2629: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2630: p_mrc_sob_type_code IN VARCHAR2,
2631: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2632: ) RETURN BOOLEAN IS
2633:
2634: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_limit';
2635: calc_err EXCEPTION;
2877: END calc_deprn_limit_adj_rec_cost;
2878:
2879:
2880: FUNCTION calc_itc_info
2881: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2882: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2883: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2884: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2885: ) RETURN BOOLEAN IS
2878:
2879:
2880: FUNCTION calc_itc_info
2881: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2882: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2883: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2884: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2885: ) RETURN BOOLEAN IS
2886:
2879:
2880: FUNCTION calc_itc_info
2881: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2882: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2883: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2884: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2885: ) RETURN BOOLEAN IS
2886:
2887:
2880: FUNCTION calc_itc_info
2881: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2882: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2883: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2884: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2885: ) RETURN BOOLEAN IS
2886:
2887:
2888: l_itc_amount_rate number;
2949:
2950: END calc_itc_info;
2951:
2952: FUNCTION calc_salvage_value
2953: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2954: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2955: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2950: END calc_itc_info;
2951:
2952: FUNCTION calc_salvage_value
2953: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2954: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2955: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2958: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2951:
2952: FUNCTION calc_salvage_value
2953: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2954: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2955: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2958: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2959: p_mrc_sob_type_code IN VARCHAR2,
2952: FUNCTION calc_salvage_value
2953: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2954: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2955: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2958: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2959: p_mrc_sob_type_code IN VARCHAR2,
2960: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2953: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
2954: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2955: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2958: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2959: p_mrc_sob_type_code IN VARCHAR2,
2960: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2961: ) RETURN BOOLEAN IS
2954: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
2955: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2958: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2959: p_mrc_sob_type_code IN VARCHAR2,
2960: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2961: ) RETURN BOOLEAN IS
2962:
2956: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
2957: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
2958: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
2959: p_mrc_sob_type_code IN VARCHAR2,
2960: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2961: ) RETURN BOOLEAN IS
2962:
2963: calc_err EXCEPTION;
2964: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_salvage_value';
3147: END calc_salvage_value;
3148:
3149:
3150: FUNCTION calc_subcomp_life
3151: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3152: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3153: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3148:
3149:
3150: FUNCTION calc_subcomp_life
3151: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3152: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3153: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3156: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3149:
3150: FUNCTION calc_subcomp_life
3151: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3152: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3153: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3156: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3157: p_calling_fn IN VARCHAR2,
3150: FUNCTION calc_subcomp_life
3151: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3152: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3153: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3156: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3157: p_calling_fn IN VARCHAR2,
3158: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3151: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3152: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3153: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3156: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3157: p_calling_fn IN VARCHAR2,
3158: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3159: ) RETURN BOOLEAN IS
3152: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3153: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3156: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3157: p_calling_fn IN VARCHAR2,
3158: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3159: ) RETURN BOOLEAN IS
3160:
3154: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3155: p_period_rec IN FA_API_TYPES.period_rec_type,
3156: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3157: p_calling_fn IN VARCHAR2,
3158: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3159: ) RETURN BOOLEAN IS
3160:
3161: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3162: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';
3157: p_calling_fn IN VARCHAR2,
3158: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3159: ) RETURN BOOLEAN IS
3160:
3161: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3162: l_calling_fn varchar2(40) := 'fa_asset_calc_pvt.calc_subcomp_life';
3163:
3164: CURSOR RATE_DEF IS
3165: SELECT DISTINCT RATE_SOURCE_RULE
3440:
3441:
3442:
3443: FUNCTION calc_flags
3444: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3445: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3441:
3442:
3443: FUNCTION calc_flags
3444: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3445: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3442:
3443: FUNCTION calc_flags
3444: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3445: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3450: p_period_rec IN FA_API_TYPES.period_rec_type,
3443: FUNCTION calc_flags
3444: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3445: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3450: p_period_rec IN FA_API_TYPES.period_rec_type,
3451: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3444: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3445: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3450: p_period_rec IN FA_API_TYPES.period_rec_type,
3451: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3452: ) RETURN BOOLEAN IS
3445: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3450: p_period_rec IN FA_API_TYPES.period_rec_type,
3451: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3452: ) RETURN BOOLEAN IS
3453:
3446: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3450: p_period_rec IN FA_API_TYPES.period_rec_type,
3451: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3452: ) RETURN BOOLEAN IS
3453:
3454: l_first_period number := 0;
3447: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3448: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3449: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
3450: p_period_rec IN FA_API_TYPES.period_rec_type,
3451: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3452: ) RETURN BOOLEAN IS
3453:
3454: l_first_period number := 0;
3455:
3729: END calc_flags;
3730:
3731:
3732: FUNCTION calc_deprn_info
3733: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3734: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3730:
3731:
3732: FUNCTION calc_deprn_info
3733: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3734: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3731:
3732: FUNCTION calc_deprn_info
3733: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3734: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3732: FUNCTION calc_deprn_info
3733: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3734: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3733: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
3734: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3734: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3735: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3743: p_period_rec IN FA_API_TYPES.period_rec_type,
3736: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3743: p_period_rec IN FA_API_TYPES.period_rec_type,
3744: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3737: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3743: p_period_rec IN FA_API_TYPES.period_rec_type,
3744: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3745: ) RETURN BOOLEAN IS
3738: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3743: p_period_rec IN FA_API_TYPES.period_rec_type,
3744: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3745: ) RETURN BOOLEAN IS
3746:
3739: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3743: p_period_rec IN FA_API_TYPES.period_rec_type,
3744: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3745: ) RETURN BOOLEAN IS
3746:
3747: l_count number;
3740: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
3741: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
3742: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
3743: p_period_rec IN FA_API_TYPES.period_rec_type,
3744: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3745: ) RETURN BOOLEAN IS
3746:
3747: l_count number;
3748: l_result boolean;
4044: END calc_deprn_info;
4045:
4046:
4047: FUNCTION calc_group_info
4048: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4049: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4045:
4046:
4047: FUNCTION calc_group_info
4048: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4049: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4053: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4046:
4047: FUNCTION calc_group_info
4048: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4049: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4053: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4054: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4047: FUNCTION calc_group_info
4048: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4049: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4053: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4054: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4055: ) return boolean IS
4048: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4049: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4053: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4054: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4055: ) return boolean IS
4056:
4049: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4053: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4054: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4055: ) return boolean IS
4056:
4057: CURSOR c_find_member_asset IS
4050: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4051: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4052: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4053: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4054: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4055: ) return boolean IS
4056:
4057: CURSOR c_find_member_asset IS
4058: SELECT 'Y'
4449:
4450: END calc_group_info;
4451:
4452: FUNCTION calc_member_info
4453: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4454: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4450: END calc_group_info;
4451:
4452: FUNCTION calc_member_info
4453: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4454: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4458: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4451:
4452: FUNCTION calc_member_info
4453: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4454: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4458: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4452: FUNCTION calc_member_info
4453: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4454: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4458: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4460: ) return boolean IS
4453: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4454: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4458: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4460: ) return boolean IS
4461:
4454: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4458: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4460: ) return boolean IS
4461:
4462: CURSOR c_get_group_values IS
4455: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4456: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4457: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4458: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4460: ) return boolean IS
4461:
4462: CURSOR c_get_group_values IS
4463: SELECT recognize_gain_loss,
4685: --RELOCATED
4686: --RELOCATED Relocated to FAVAMRTB.pls
4687: --RELOCATED
4688: --RELOCATED FUNCTION calc_raf_adj_cost
4689: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4690: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4686: --RELOCATED Relocated to FAVAMRTB.pls
4687: --RELOCATED
4688: --RELOCATED FUNCTION calc_raf_adj_cost
4689: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4690: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4687: --RELOCATED
4688: --RELOCATED FUNCTION calc_raf_adj_cost
4689: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4690: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4688: --RELOCATED FUNCTION calc_raf_adj_cost
4689: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4690: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4696: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4689: --RELOCATED (p_trans_rec IN FA_API_TYPES.trans_rec_type,
4690: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4696: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4697: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
4690: --RELOCATED p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4696: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4697: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
4698: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
4691: --RELOCATED p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4696: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4697: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
4698: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
4699: --RELOCATED ) RETURN BOOLEAN IS
4692: --RELOCATED p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4696: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4697: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
4698: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
4699: --RELOCATED ) RETURN BOOLEAN IS
4700: --RELOCATED
4693: --RELOCATED p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4694: --RELOCATED px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4695: --RELOCATED p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type,
4696: --RELOCATED p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4697: --RELOCATED p_period_rec IN FA_API_TYPES.period_rec_type,
4698: --RELOCATED p_mrc_sob_type_code IN VARCHAR2
4699: --RELOCATED ) RETURN BOOLEAN IS
4700: --RELOCATED
4701: --RELOCATED
4707: --RELOCATED
4708:
4709:
4710: FUNCTION calc_standalone_info
4711: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
4712: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4713: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4714: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4708:
4709:
4710: FUNCTION calc_standalone_info
4711: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
4712: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4713: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4714: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4709:
4710: FUNCTION calc_standalone_info
4711: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
4712: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4713: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4714: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4717: ) return boolean IS
4710: FUNCTION calc_standalone_info
4711: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
4712: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4713: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4714: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4717: ) return boolean IS
4718:
4711: (p_asset_hdr_rec IN FA_API_TYPES.asset_Hdr_rec_type,
4712: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4713: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4714: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4717: ) return boolean IS
4718:
4719: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
4712: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4713: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4714: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4715: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
4716: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
4717: ) return boolean IS
4718:
4719: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_standalone_info';
4720: