DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_WHATIF_DEPRN_PKG

Line 184: fa_whatif_deprn_pkg.t_request_id.delete;

180: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE 1');
181:
182: ret := TRUE;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;

Line 185: fa_whatif_deprn_pkg.t_book_type_code.delete;

181:
182: ret := TRUE;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;

Line 186: fa_whatif_deprn_pkg.t_asset_id.delete;

182: ret := TRUE;
183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;

Line 187: fa_whatif_deprn_pkg.t_asset_number.delete;

183:
184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;

Line 188: fa_whatif_deprn_pkg.t_description.delete;

184: fa_whatif_deprn_pkg.t_request_id.delete;
185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;

Line 189: fa_whatif_deprn_pkg.t_tag_number.delete;

185: fa_whatif_deprn_pkg.t_book_type_code.delete;
186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;

Line 190: fa_whatif_deprn_pkg.t_serial_number.delete;

186: fa_whatif_deprn_pkg.t_asset_id.delete;
187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;

Line 191: fa_whatif_deprn_pkg.t_period_name.delete;

187: fa_whatif_deprn_pkg.t_asset_number.delete;
188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;

Line 192: fa_whatif_deprn_pkg.t_fiscal_year.delete;

188: fa_whatif_deprn_pkg.t_description.delete;
189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;

Line 193: fa_whatif_deprn_pkg.t_expense_acct.delete;

189: fa_whatif_deprn_pkg.t_tag_number.delete;
190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;

Line 194: fa_whatif_deprn_pkg.t_location.delete;

190: fa_whatif_deprn_pkg.t_serial_number.delete;
191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;

Line 195: fa_whatif_deprn_pkg.t_units.delete;

191: fa_whatif_deprn_pkg.t_period_name.delete;
192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;

Line 196: fa_whatif_deprn_pkg.t_employee_name.delete;

192: fa_whatif_deprn_pkg.t_fiscal_year.delete;
193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;

Line 197: fa_whatif_deprn_pkg.t_employee_number.delete;

193: fa_whatif_deprn_pkg.t_expense_acct.delete;
194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;

Line 198: fa_whatif_deprn_pkg.t_asset_key.delete;

194: fa_whatif_deprn_pkg.t_location.delete;
195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;

Line 199: fa_whatif_deprn_pkg.t_current_cost.delete;

195: fa_whatif_deprn_pkg.t_units.delete;
196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;

Line 200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;

196: fa_whatif_deprn_pkg.t_employee_name.delete;
197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;

Line 201: fa_whatif_deprn_pkg.t_current_method.delete;

197: fa_whatif_deprn_pkg.t_employee_number.delete;
198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;

Line 202: fa_whatif_deprn_pkg.t_current_life.delete;

198: fa_whatif_deprn_pkg.t_asset_key.delete;
199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;

Line 203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;

199: fa_whatif_deprn_pkg.t_current_cost.delete;
200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;

Line 204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;

200: fa_whatif_deprn_pkg.t_current_prorate_conv.delete;
201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;

Line 205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;

201: fa_whatif_deprn_pkg.t_current_method.delete;
202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;

Line 206: fa_whatif_deprn_pkg.t_depreciation.delete;

202: fa_whatif_deprn_pkg.t_current_life.delete;
203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;

Line 207: fa_whatif_deprn_pkg.t_new_depreciation.delete;

203: fa_whatif_deprn_pkg.t_current_basic_rate.delete;
204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;

Line 208: fa_whatif_deprn_pkg.t_created_by.delete;

204: fa_whatif_deprn_pkg.t_current_adjusted_rate.delete;
205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;

Line 209: fa_whatif_deprn_pkg.t_creation_date.delete;

205: fa_whatif_deprn_pkg.t_current_salvage_value.delete;
206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;

Line 210: fa_whatif_deprn_pkg.t_last_update_date.delete;

206: fa_whatif_deprn_pkg.t_depreciation.delete;
207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;

Line 211: fa_whatif_deprn_pkg.t_last_updated_by.delete;

207: fa_whatif_deprn_pkg.t_new_depreciation.delete;
208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;

Line 212: fa_whatif_deprn_pkg.t_last_update_login.delete;

208: fa_whatif_deprn_pkg.t_created_by.delete;
209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;

Line 213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;

209: fa_whatif_deprn_pkg.t_creation_date.delete;
210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;

Line 214: fa_whatif_deprn_pkg.t_category.delete;

210: fa_whatif_deprn_pkg.t_last_update_date.delete;
211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;

Line 215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;

211: fa_whatif_deprn_pkg.t_last_updated_by.delete;
212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;

Line 216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;

212: fa_whatif_deprn_pkg.t_last_update_login.delete;
213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;

Line 217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;

213: fa_whatif_deprn_pkg.t_date_placed_in_service.delete;
214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:

Line 218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;

214: fa_whatif_deprn_pkg.t_category.delete;
215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
222: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';

Line 219: fa_whatif_deprn_pkg.t_period_num.delete;

215: fa_whatif_deprn_pkg.t_accumulated_deprn.delete;
216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
222: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
223: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';

Line 220: fa_whatif_deprn_pkg.t_currency_code.delete;

216: fa_whatif_deprn_pkg.t_bonus_depreciation.delete;
217: fa_whatif_deprn_pkg.t_new_bonus_depreciation.delete;
218: fa_whatif_deprn_pkg.t_current_bonus_rule.delete;
219: fa_whatif_deprn_pkg.t_period_num.delete;
220: fa_whatif_deprn_pkg.t_currency_code.delete;
221:
222: if (X_exp_amt = 'YES') then X_exp_amt := 'AMORTIZED';
223: elsif (X_exp_amt = 'NO') then X_exp_amt := 'EXPENSED';
224: end if;

Line 341: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN

337: h_cntr3 := h_cntr3 + 1;
338: end loop;
339: --ERnos 6612615 what-if end
340: -- RUN IN NORMAL MODE TO GET DEPRN GIVEN CURRENT STATE
341: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
342:
343: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
344:
345: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

Line 345: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

341: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
342:
343: h_mesg_name := 'FA_WHATIF_ASSET_NORMAL_MODE';
344:
345: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
346: X_asset_id => X_assets(h_count),
347: X_mode => 'NORMAL',
348: X_book => X_book,
349: X_start_per => X_start_per,

Line 384: fa_whatif_deprn_pkg.g_deprn.delete;

380:
381: if (ret = FALSE) then
382: x_return_status := 2;
383:
384: fa_whatif_deprn_pkg.g_deprn.delete;
385: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
386: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
387: h_mesg_str := fnd_message.get;
388: fa_rx_conc_mesg_pkg.log(h_mesg_str);

Line 394: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN

390: end if;
391:
392:
393: -- RUN IN EXPENSED/AMORTIZED MODE TO GET DEPRN IN ADJUSTED STATE
394: -- STORES RESULTS IN FA_WHATIF_DEPRN_PKG.G_DEPRN
395:
396: h_mesg_name := 'FA_WHATIF_ASSET_ADJ_MODE';
397:
398: if (X_prorate_conv is not null) or

Line 406: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

402: (X_life is not null) or
403: (X_salvage_pct is not null) then
404: --tk_util.debug('Processing');
405:
406: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
407: X_asset_id => X_assets(h_count),
408: X_mode => X_exp_amt,
409: X_book => X_book,
410: X_start_per => X_start_per,

Line 445: fa_whatif_deprn_pkg.g_deprn.delete;

441:
442: if (ret = FALSE) then
443: x_return_status := 2;
444:
445: fa_whatif_deprn_pkg.g_deprn.delete;
446: fnd_message.set_name('OFA','FA_WHATIF_ASSET_ADJ_MODE');
447: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
448: h_mesg_str := fnd_message.get;
449: fa_rx_conc_mesg_pkg.log(h_mesg_str);

Line 460: ret := fa_whatif_deprn_pkg.whatif_insert_itf (

456:
457: h_mesg_name := 'FA_WHATIF_ASSET_COMMIT';
458:
459: --tk_util.debug('h_count:X_num_assets: '||to_char(h_count)||':'||to_char(X_num_assets));
460: ret := fa_whatif_deprn_pkg.whatif_insert_itf (
461: X_asset_id => X_assets(h_count),
462: X_book => X_book,
463: X_request_id => X_request_id,
464: X_num_pers => X_num_per,

Line 479: fa_whatif_deprn_pkg.g_deprn.delete;

475: -- X_seg_table => seg_table,
476: if (ret = FALSE) then
477: x_return_status := 2;
478:
479: fa_whatif_deprn_pkg.g_deprn.delete;
480: fnd_message.set_name('OFA','FA_WHATIF_ASSET_COMMIT');
481: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
482: h_mesg_str := fnd_message.get;
483: fa_rx_conc_mesg_pkg.log(h_mesg_str);

Line 543: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (

539: -- HYPOTHETICAL ASSET
540:
541: --fa_rx_conc_mesg_pkg.log('IN HERE IN HERE');
542:
543: ret := fa_whatif_deprn_pkg.whatif_deprn_asset (
544: X_asset_id => 0,
545: X_mode => 'HYPOTHETICAL',
546: X_book => X_book,
547: X_start_per => X_start_per,

Line 584: fa_whatif_deprn_pkg.g_deprn.delete;

580:
581: if (ret = FALSE) then
582: x_return_status := 2;
583:
584: fa_whatif_deprn_pkg.g_deprn.delete;
585: fnd_message.set_name('OFA','FA_WHATIF_ASSET_NORMAL_MODE');
586: h_mesg_str := fnd_message.get;
587: fa_rx_conc_mesg_pkg.log(h_mesg_str);
588: return (FALSE);

Line 635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,

631: last_updated_by, last_update_login,category,date_placed_in_service,
632: accumulated_deprn,currency_code
633: ) values (
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,

Line 636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,

632: accumulated_deprn,currency_code
633: ) values (
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,

Line 637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,

633: ) values (
634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,

Line 638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,

634: X_request_id, NULL, NULL, NULL, NULL, NULL,
635: fa_whatif_deprn_pkg.g_deprn(h_count).period_name,
636: fa_whatif_deprn_pkg.g_deprn(h_count).fiscal_year, NULL,
637: fa_whatif_deprn_pkg.g_deprn(h_count).deprn,
638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,

Line 642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,

638: fa_whatif_deprn_pkg.g_deprn(h_count).new_deprn,
639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
644: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
645: h_concat_str, X_dpis,
646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);

Line 643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,

639: NULL, NULL, NULL, NULL,
640: NULL, X_cost, X_prorate_conv, X_method,
641: X_life, h_basic_rate, X_adjusted_rate, h_sal,
642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
644: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
645: h_concat_str, X_dpis,
646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
647:

Line 646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);

642: fa_whatif_deprn_pkg.g_deprn(h_count).bonus_deprn,
643: fa_whatif_deprn_pkg.g_deprn(h_count).new_bonus_deprn,
644: X_user_id, sysdate, sysdate, X_user_id, h_login_id,
645: h_concat_str, X_dpis,
646: fa_whatif_deprn_pkg.g_deprn(h_count).new_rsv,h_currency);
647:
648: h_count := h_count + 1;
649: end loop;
650:

Line 653: fa_whatif_deprn_pkg.g_deprn.delete;

649: end loop;
650:
651: end if;
652:
653: fa_whatif_deprn_pkg.g_deprn.delete;
654:
655: -- errbuf := '';
656: return ret;
657:

Line 664: fa_whatif_deprn_pkg.g_deprn.delete;

660: if SQLCODE <> 0 then
661: fa_Rx_conc_mesg_pkg.log(SQLERRM);
662: end if;
663:
664: fa_whatif_deprn_pkg.g_deprn.delete;
665: fnd_message.set_name('OFA',h_mesg_name);
666: if h_mesg_name like 'FA_WHATIF_ASSET%' then
667: fnd_message.set_token('ASSET_ID',X_assets(h_count),FALSE);
668: end if;