1: PACKAGE BODY FA_MASSCHG_PKG as
2: /* $Header: FAMACHB.pls 120.27 2010/10/30 12:06:08 saalampa ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: PROCEDURE do_mass_change (
7: p_mass_change_id IN NUMBER,
8: p_parent_request_id IN NUMBER,
109: l_old_deprn_limit number;
110: l_old_deprn_limit_amount number;
111:
112:
113: l_period_rec FA_API_TYPES.period_rec_type;
114: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
110: l_old_deprn_limit_amount number;
111:
112:
113: l_period_rec FA_API_TYPES.period_rec_type;
114: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
112:
113: l_period_rec FA_API_TYPES.period_rec_type;
114: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
113: l_period_rec FA_API_TYPES.period_rec_type;
114: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
114: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
115:
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
116: l_trans_rec FA_API_TYPES.trans_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
117: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
125: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
118: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
125: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
126: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
119: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
125: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
126: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
127:
120: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
125: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
126: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
127:
128: l_mesg_name VARCHAR2(30);
121: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
125: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
126: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
127:
128: l_mesg_name VARCHAR2(30);
129:
122: l_inv_tbl FA_API_TYPES.inv_tbl_type;
123: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
124: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
125: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
126: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
127:
128: l_mesg_name VARCHAR2(30);
129:
130: -- mass change info