1: PACKAGE BODY FA_RESERVE_TRANSFER_PVT AS
2: /* $Header: FAVRSVXB.pls 120.9 2009/04/15 15:14:49 bridgway ship $ */
3:
4: FUNCTION do_adjustment
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: FAVRSVXB.pls 120.9 2009/04/15 15:14:49 bridgway ship $ */
3:
4: FUNCTION do_adjustment
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_adjustment
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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
4: FUNCTION do_adjustment
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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
14: p_period_rec IN FA_API_TYPES.period_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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
14: p_period_rec IN FA_API_TYPES.period_rec_type,
15: p_mrc_sob_type_code 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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
14: p_period_rec IN FA_API_TYPES.period_rec_type,
15: p_mrc_sob_type_code IN VARCHAR2,
16: p_source_dest IN VARCHAR2,
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: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
14: p_period_rec IN FA_API_TYPES.period_rec_type,
15: p_mrc_sob_type_code IN VARCHAR2,
16: p_source_dest IN VARCHAR2,
17: p_amount IN NUMBER
10: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
11: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: x_asset_deprn_rec_new OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
14: p_period_rec IN FA_API_TYPES.period_rec_type,
15: p_mrc_sob_type_code IN VARCHAR2,
16: p_source_dest IN VARCHAR2,
17: p_amount IN NUMBER
18: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
14: p_period_rec IN FA_API_TYPES.period_rec_type,
15: p_mrc_sob_type_code IN VARCHAR2,
16: p_source_dest IN VARCHAR2,
17: p_amount IN NUMBER
18: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
19:
20: -- used for new group code
21: l_adj fa_adjust_type_pkg.fa_adj_row_struct;
22: l_bks_rowid varchar2(30);
28: l_deprn_exp NUMBER := 0;
29: l_bonus_deprn_exp NUMBER := 0;
30: l_impairment_exp NUMBER := 0;
31: l_deprn_rsv NUMBER := 0;
32: l_asset_deprn_rec_adj FA_API_TYPES.ASSET_DEPRN_REC_TYPE;
33:
34: l_calling_fn VARCHAR2(35) := 'fa_group_reserve_pvt.do_transfer';
35: adj_err EXCEPTION;
36: