1: PACKAGE BODY FA_RESERVE_TRANSFER_PVT AS
2: /* $Header: FAVRSVXB.pls 120.7 2005/07/25 10:04:05 yyoon noship $ */
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.7 2005/07/25 10:04:05 yyoon noship $ */
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 default null) 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 default null) 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);
27: --
28: l_deprn_exp NUMBER := 0;
29: l_bonus_deprn_exp NUMBER := 0;
30: l_deprn_rsv NUMBER := 0;
31: l_asset_deprn_rec_adj FA_API_TYPES.ASSET_DEPRN_REC_TYPE;
32:
33: l_calling_fn VARCHAR2(35) := 'fa_group_reserve_pvt.do_transfer';
34: adj_err EXCEPTION;
35: