1: PACKAGE FA_REVALUATION_PVT as
2: /* $Header: FAVRVLS.pls 120.1 2005/06/24 16:45:53 snarayan noship $ */
3:
4: FUNCTION do_reval
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2: /* $Header: FAVRVLS.pls 120.1 2005/06/24 16:45:53 snarayan noship $ */
3:
4: FUNCTION do_reval
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3:
4: FUNCTION do_reval
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
4: FUNCTION do_reval
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
12: p_period_rec IN FA_API_TYPES.period_rec_type,
5: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
12: p_period_rec IN FA_API_TYPES.period_rec_type,
13: p_mrc_sob_type_code IN VARCHAR2,
6: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
12: p_period_rec IN FA_API_TYPES.period_rec_type,
13: p_mrc_sob_type_code IN VARCHAR2,
14: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
12: p_period_rec IN FA_API_TYPES.period_rec_type,
13: p_mrc_sob_type_code IN VARCHAR2,
14: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
15: p_calling_fn IN VARCHAR2,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
12: p_period_rec IN FA_API_TYPES.period_rec_type,
13: p_mrc_sob_type_code IN VARCHAR2,
14: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
12: p_period_rec IN FA_API_TYPES.period_rec_type,
13: p_mrc_sob_type_code IN VARCHAR2,
14: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
17: ) RETURN BOOLEAN ;
18:
12: p_period_rec IN FA_API_TYPES.period_rec_type,
13: p_mrc_sob_type_code IN VARCHAR2,
14: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
17: ) RETURN BOOLEAN ;
18:
19: -----------------------------------------------------------------------------------
20:
20:
21: -- this function contains validation for reval on an asset
22:
23: FUNCTION validate_reval
24: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
21: -- this function contains validation for reval on an asset
22:
23: FUNCTION validate_reval
24: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
22:
23: FUNCTION validate_reval
24: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
23: FUNCTION validate_reval
24: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
31: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
24: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
31: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
25: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
31: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
33: ) RETURN BOOLEAN;
26: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
31: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
33: ) RETURN BOOLEAN;
34:
27: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
31: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
33: ) RETURN BOOLEAN;
34:
35: FUNCTION fareven
28: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
29: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
30: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
31: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
33: ) RETURN BOOLEAN;
34:
35: FUNCTION fareven
36: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
33: ) RETURN BOOLEAN;
34:
35: FUNCTION fareven
36: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
37: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
33: ) RETURN BOOLEAN;
34:
35: FUNCTION fareven
36: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
37: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
34:
35: FUNCTION fareven
36: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
37: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
35: FUNCTION fareven
36: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
37: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
36: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
37: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
37: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
45: p_period_rec IN FA_API_TYPES.period_rec_type,
38: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
45: p_period_rec IN FA_API_TYPES.period_rec_type,
46: p_mrc_sob_type_code IN VARCHAR2,
39: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
45: p_period_rec IN FA_API_TYPES.period_rec_type,
46: p_mrc_sob_type_code IN VARCHAR2,
47: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
40: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
45: p_period_rec IN FA_API_TYPES.period_rec_type,
46: p_mrc_sob_type_code IN VARCHAR2,
47: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
48: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct,
41: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
42: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
45: p_period_rec IN FA_API_TYPES.period_rec_type,
46: p_mrc_sob_type_code IN VARCHAR2,
47: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
48: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct,
49: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
44: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
45: p_period_rec IN FA_API_TYPES.period_rec_type,
46: p_mrc_sob_type_code IN VARCHAR2,
47: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
48: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct,
49: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
50: RETURN BOOLEAN;
51:
45: p_period_rec IN FA_API_TYPES.period_rec_type,
46: p_mrc_sob_type_code IN VARCHAR2,
47: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
48: x_reval_out OUT NOCOPY fa_std_types.reval_out_struct,
49: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
50: RETURN BOOLEAN;
51:
52: END FA_REVALUATION_PVT;