6: G_PKG_NAME CONSTANT varchar2(30) := 'FA_REVALUATION_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Revaluation API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11: g_release number := fa_cache_pkg.fazarel_release;
12:
13: --*********************** Private functions ******************************--
14:
17: g_cip_cost number := 0;
18: g_cost number := 0;
19:
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
18: g_cost number := 0;
19:
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
19:
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
20: FUNCTION do_all_books
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
28:
21: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
28:
29:
22: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
28:
29:
30: --*********************** Public procedures ******************************--
23: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
24: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
25: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
26: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
27: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
28:
29:
30: --*********************** Public procedures ******************************--
31:
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:
42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:
42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
47:
40: x_msg_data OUT NOCOPY VARCHAR2,
41:
42: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
43: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
44: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type) IS
45:
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
45:
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
46: l_reporting_flag varchar2(1);
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
47:
48: x_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
49: x_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
56:
57: l_calling_fn VARCHAR2(35) := 'fa_reval_pub.do_reval';
50: x_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
56:
57: l_calling_fn VARCHAR2(35) := 'fa_reval_pub.do_reval';
58: reval_err EXCEPTION;
51: x_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
52:
53: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
54: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
55: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
56:
57: l_calling_fn VARCHAR2(35) := 'fa_reval_pub.do_reval';
58: reval_err EXCEPTION;
59:
259: -- book calling the private api for each.
260:
261:
262: FUNCTION do_all_books
263: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
264: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
260:
261:
262: FUNCTION do_all_books
263: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
264: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
261:
262: FUNCTION do_all_books
263: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
264: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
269: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
262: FUNCTION do_all_books
263: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
264: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
269: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
270:
263: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
264: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
269: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
270:
271: -- used for calling private api for reporting books
264: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
269: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
270:
271: -- used for calling private api for reporting books
272: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
265: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
266: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
267: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
269: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
270:
271: -- used for calling private api for reporting books
272: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
273:
268: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type
269: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
270:
271: -- used for calling private api for reporting books
272: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
273:
274: -- used for retrieving "old" and "new" structs from private api calls
275: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
276: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
271: -- used for calling private api for reporting books
272: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
273:
274: -- used for retrieving "old" and "new" structs from private api calls
275: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
276: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
277:
278: l_reporting_flag varchar2(1);
279:
272: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
273:
274: -- used for retrieving "old" and "new" structs from private api calls
275: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
276: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
277:
278: l_reporting_flag varchar2(1);
279:
280: l_period_rec FA_API_TYPES.period_rec_type;
276: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
277:
278: l_reporting_flag varchar2(1);
279:
280: l_period_rec FA_API_TYPES.period_rec_type;
281: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
282:
283: l_transaction_date date;
284: l_return_status NUMBER;