1: PACKAGE BODY FA_TAX_UPLOAD_PKG as
2: /* $Header: fataxupb.pls 120.19.12010000.1 2008/07/28 13:23:41 appldev ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE faxtaxup(
7: p_book_type_code IN VARCHAR2,
8: p_parent_request_id IN NUMBER,
119:
120: l_calling_fn VARCHAR2(30) := 'fa_tax_upload_pkg.faxtaxup';
121: l_string varchar2(250);
122:
123: l_trans_rec FA_API_TYPES.trans_rec_type;
124: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
120: l_calling_fn VARCHAR2(30) := 'fa_tax_upload_pkg.faxtaxup';
121: l_string varchar2(250);
122:
123: l_trans_rec FA_API_TYPES.trans_rec_type;
124: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
121: l_string varchar2(250);
122:
123: l_trans_rec FA_API_TYPES.trans_rec_type;
124: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
122:
123: l_trans_rec FA_API_TYPES.trans_rec_type;
124: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
123: l_trans_rec FA_API_TYPES.trans_rec_type;
124: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
125: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
126: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
134:
127: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
134:
135: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
128: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
134:
135: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
129: l_inv_tbl FA_API_TYPES.inv_tbl_type;
130: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
134:
135: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137:
131: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
134:
135: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137:
138: l_deprn_exp_amort_nbv number;
139:
132: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
133: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
134:
135: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137:
138: l_deprn_exp_amort_nbv number;
139:
140: CURSOR c_assets IS
843:
844: PROCEDURE write_message
845: (p_asset_number in varchar2,
846: p_message in varchar2,
847: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
848:
849:
850: l_message varchar2(30);
851: l_mesg varchar2(100);