3: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
4: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
5: TYPE v30_tbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
6:
7: g_log_level_rec fa_api_types.log_level_rec_type;
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: --*********************** Private functions ******************************--
11: -- private declaration for books (mrc) wrapper
124:
125: -- source group asset
126: -- if not group reclass then this is the only group which is being
127: -- impacted by member trxn
128: l_trans_rec FA_API_TYPES.trans_rec_type;
129: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
125: -- source group asset
126: -- if not group reclass then this is the only group which is being
127: -- impacted by member trxn
128: l_trans_rec FA_API_TYPES.trans_rec_type;
129: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
126: -- if not group reclass then this is the only group which is being
127: -- impacted by member trxn
128: l_trans_rec FA_API_TYPES.trans_rec_type;
129: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
127: -- impacted by member trxn
128: l_trans_rec FA_API_TYPES.trans_rec_type;
129: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
128: l_trans_rec FA_API_TYPES.trans_rec_type;
129: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
129: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
130: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
131: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
132: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
140:
133: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
140:
141: l_asset_fin_rec_adj_null FA_API_TYPES.asset_fin_rec_type;
134: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
140:
141: l_asset_fin_rec_adj_null FA_API_TYPES.asset_fin_rec_type;
142: l_asset_deprn_rec_adj_null FA_API_TYPES.asset_deprn_rec_type;
135: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
136: l_asset_deprn_rec_old FA_API_TYPES.asset_deprn_rec_type;
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
140:
141: l_asset_fin_rec_adj_null FA_API_TYPES.asset_fin_rec_type;
142: l_asset_deprn_rec_adj_null FA_API_TYPES.asset_deprn_rec_type;
143:
137: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
140:
141: l_asset_fin_rec_adj_null FA_API_TYPES.asset_fin_rec_type;
142: l_asset_deprn_rec_adj_null FA_API_TYPES.asset_deprn_rec_type;
143:
144: l_trx_ref_rec fa_api_types.trx_ref_rec_type;
145:
138: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
139: l_period_rec FA_API_TYPES.period_rec_type;
140:
141: l_asset_fin_rec_adj_null FA_API_TYPES.asset_fin_rec_type;
142: l_asset_deprn_rec_adj_null FA_API_TYPES.asset_deprn_rec_type;
143:
144: l_trx_ref_rec fa_api_types.trx_ref_rec_type;
145:
146: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
140:
141: l_asset_fin_rec_adj_null FA_API_TYPES.asset_fin_rec_type;
142: l_asset_deprn_rec_adj_null FA_API_TYPES.asset_deprn_rec_type;
143:
144: l_trx_ref_rec fa_api_types.trx_ref_rec_type;
145:
146: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
147: l_mrc_sob_type_code varchar2(1);
148:
286: and book_type_code = l_asset_hdr_rec.book_type_code
287: and transaction_header_id = l_trans_rec.transaction_header_id
288: and set_of_books_id = l_asset_hdr_rec.set_of_books_id;
289:
290: l_unplanned_deprn_rec FA_API_TYPES.unplanned_deprn_rec_type;
291: l_group_deprn_amount NUMBER;
292: l_group_bonus_amount NUMBER;
293: l_return_code NUMBER;
294:
371: and tr.trx_reference_id(+) = th.trx_reference_id; --Added for bug 537059
372:
373:
374:
375: lm_trans_rec FA_API_TYPES.trans_rec_type;
376: lm_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
372:
373:
374:
375: lm_trans_rec FA_API_TYPES.trans_rec_type;
376: lm_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
380: lm_asset_type_rec FA_API_TYPES.asset_type_rec_type;
373:
374:
375: lm_trans_rec FA_API_TYPES.trans_rec_type;
376: lm_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
380: lm_asset_type_rec FA_API_TYPES.asset_type_rec_type;
381: lm_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
374:
375: lm_trans_rec FA_API_TYPES.trans_rec_type;
376: lm_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
380: lm_asset_type_rec FA_API_TYPES.asset_type_rec_type;
381: lm_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
382:
375: lm_trans_rec FA_API_TYPES.trans_rec_type;
376: lm_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
380: lm_asset_type_rec FA_API_TYPES.asset_type_rec_type;
381: lm_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
382:
383: l_mem_ret_thid NUMBER; -- Member asset retirement thid
376: lm_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
380: lm_asset_type_rec FA_API_TYPES.asset_type_rec_type;
381: lm_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
382:
383: l_mem_ret_thid NUMBER; -- Member asset retirement thid
384:
377: lm_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
378: lm_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
379: lm_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
380: lm_asset_type_rec FA_API_TYPES.asset_type_rec_type;
381: lm_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
382:
383: l_mem_ret_thid NUMBER; -- Member asset retirement thid
384:
385: l_return_status varchar2(10);
391: TRX_CUR boolean := FALSE;
392: BOOK_CUR boolean := FALSE;
393:
394: -- Bug 8862296 Changes start here
395: l_src_trans_rec FA_API_TYPES.trans_rec_type;
396: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
397: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
398: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
399: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
392: BOOK_CUR boolean := FALSE;
393:
394: -- Bug 8862296 Changes start here
395: l_src_trans_rec FA_API_TYPES.trans_rec_type;
396: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
397: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
398: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
399: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
400: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
393:
394: -- Bug 8862296 Changes start here
395: l_src_trans_rec FA_API_TYPES.trans_rec_type;
396: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
397: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
398: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
399: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
400: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
401:
394: -- Bug 8862296 Changes start here
395: l_src_trans_rec FA_API_TYPES.trans_rec_type;
396: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
397: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
398: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
399: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
400: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
401:
402: CURSOR c_get_trx_reference IS
395: l_src_trans_rec FA_API_TYPES.trans_rec_type;
396: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
397: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
398: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
399: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
400: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
401:
402: CURSOR c_get_trx_reference IS
403: SELECT SRC_ASSET_ID,
396: l_src_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
397: l_dest_trans_rec FA_API_TYPES.trans_rec_type;
398: l_dest_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
399: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
400: l_dest_inv_tbl FA_API_TYPES.inv_tbl_type;
401:
402: CURSOR c_get_trx_reference IS
403: SELECT SRC_ASSET_ID,
404: BOOK_TYPE_CODE,
1414:
1415: END do_all_books;
1416:
1417: FUNCTION do_group_reclass(
1418: p_trx_ref_rec IN fa_api_types.trx_ref_rec_type,
1419: p_mrc_sob_type_code IN VARCHAR2,
1420: p_set_of_books_id IN number,
1421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) --Bug 8941132 added p_log_level_rec
1422: RETURN BOOLEAN IS
1417: FUNCTION do_group_reclass(
1418: p_trx_ref_rec IN fa_api_types.trx_ref_rec_type,
1419: p_mrc_sob_type_code IN VARCHAR2,
1420: p_set_of_books_id IN number,
1421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) --Bug 8941132 added p_log_level_rec
1422: RETURN BOOLEAN IS
1423:
1424: l_mem_trans_rec fa_api_types.trans_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1420: p_set_of_books_id IN number,
1421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) --Bug 8941132 added p_log_level_rec
1422: RETURN BOOLEAN IS
1423:
1424: l_mem_trans_rec fa_api_types.trans_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) --Bug 8941132 added p_log_level_rec
1422: RETURN BOOLEAN IS
1423:
1424: l_mem_trans_rec fa_api_types.trans_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1422: RETURN BOOLEAN IS
1423:
1424: l_mem_trans_rec fa_api_types.trans_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1423:
1424: l_mem_trans_rec fa_api_types.trans_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1424: l_mem_trans_rec fa_api_types.trans_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1425: l_mem_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1426: l_mem_asset_desc_rec fa_api_types.asset_desc_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1427: l_mem_asset_type_rec fa_api_types.asset_type_rec_type;
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1428: l_mem_asset_cat_rec fa_api_types.asset_cat_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1429: l_mem_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1430: l_mem_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1431: l_mem_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1432: l_mem_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1433: l_mem_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1434: l_mem_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1435:
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1436: l_src_trans_rec fa_api_types.trans_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1437: l_src_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1438: l_src_asset_desc_rec fa_api_types.asset_desc_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1439: l_src_asset_type_rec fa_api_types.asset_type_rec_type;
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1440: l_src_asset_cat_rec fa_api_types.asset_cat_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1441: l_src_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1442: l_src_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1443: l_src_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1444: l_src_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1445: l_src_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1446: l_src_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1447:
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1448: l_dest_trans_rec fa_api_types.trans_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1449: l_dest_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1450: l_dest_asset_desc_rec fa_api_types.asset_desc_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1458: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1451: l_dest_asset_type_rec fa_api_types.asset_type_rec_type;
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1458: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1459:
1452: l_dest_asset_cat_rec fa_api_types.asset_cat_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1458: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1459:
1460: l_period_rec fa_api_types.period_rec_type;
1453: l_dest_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1458: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1459:
1460: l_period_rec fa_api_types.period_rec_type;
1461:
1454: l_dest_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
1455: l_dest_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1458: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1459:
1460: l_period_rec fa_api_types.period_rec_type;
1461:
1462: -- For calling faxama
1456: l_dest_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
1457: l_dest_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1458: l_dest_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
1459:
1460: l_period_rec fa_api_types.period_rec_type;
1461:
1462: -- For calling faxama
1463: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1464: l_bonus_deprn_exp number;
1459:
1460: l_period_rec fa_api_types.period_rec_type;
1461:
1462: -- For calling faxama
1463: l_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
1464: l_bonus_deprn_exp number;
1465: l_impairment_exp number;
1466: l_deprn_rsv number;
1467:
1489: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
1490: l_return_status2 VARCHAR2(1);
1491: l_msg_count NUMBER;
1492: l_msg_data VARCHAR2(2000);
1493: l_trans_rec FA_API_TYPES.trans_rec_type;
1494: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1495: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1496:
1497: l_distribution_id num_tbl;
1490: l_return_status2 VARCHAR2(1);
1491: l_msg_count NUMBER;
1492: l_msg_data VARCHAR2(2000);
1493: l_trans_rec FA_API_TYPES.trans_rec_type;
1494: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1495: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1496:
1497: l_distribution_id num_tbl;
1498: l_units_assigned num_tbl;
1491: l_msg_count NUMBER;
1492: l_msg_data VARCHAR2(2000);
1493: l_trans_rec FA_API_TYPES.trans_rec_type;
1494: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1495: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1496:
1497: l_distribution_id num_tbl;
1498: l_units_assigned num_tbl;
1499: l_code_combination_id num_tbl;
1548:
1549: --Bug 8941132 Start
1550: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1551:
1552: TYPE reclass_option_tbl IS TABLE OF FA_API_TYPES.group_reclass_options_rec_type INDEX BY BINARY_INTEGER;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1549: --Bug 8941132 Start
1550: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1551:
1552: TYPE reclass_option_tbl IS TABLE OF FA_API_TYPES.group_reclass_options_rec_type INDEX BY BINARY_INTEGER;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1557: TYPE amort_init_member_tbl IS TABLE OF FA_API_TYPES.amort_init_rec_type INDEX BY BINARY_INTEGER;
1550: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1551:
1552: TYPE reclass_option_tbl IS TABLE OF FA_API_TYPES.group_reclass_options_rec_type INDEX BY BINARY_INTEGER;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1557: TYPE amort_init_member_tbl IS TABLE OF FA_API_TYPES.amort_init_rec_type INDEX BY BINARY_INTEGER;
1558: TYPE asset_deprn_rec_tbl IS TABLE OF FA_API_TYPES.asset_deprn_rec_type INDEX BY BINARY_INTEGER;
1551:
1552: TYPE reclass_option_tbl IS TABLE OF FA_API_TYPES.group_reclass_options_rec_type INDEX BY BINARY_INTEGER;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1557: TYPE amort_init_member_tbl IS TABLE OF FA_API_TYPES.amort_init_rec_type INDEX BY BINARY_INTEGER;
1558: TYPE asset_deprn_rec_tbl IS TABLE OF FA_API_TYPES.asset_deprn_rec_type INDEX BY BINARY_INTEGER;
1559:
1552: TYPE reclass_option_tbl IS TABLE OF FA_API_TYPES.group_reclass_options_rec_type INDEX BY BINARY_INTEGER;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1557: TYPE amort_init_member_tbl IS TABLE OF FA_API_TYPES.amort_init_rec_type INDEX BY BINARY_INTEGER;
1558: TYPE asset_deprn_rec_tbl IS TABLE OF FA_API_TYPES.asset_deprn_rec_type INDEX BY BINARY_INTEGER;
1559:
1560: l_group_reclass_options_rec reclass_option_tbl;
1553: TYPE asset_fin_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_fin_rec_type INDEX BY BINARY_INTEGER;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1557: TYPE amort_init_member_tbl IS TABLE OF FA_API_TYPES.amort_init_rec_type INDEX BY BINARY_INTEGER;
1558: TYPE asset_deprn_rec_tbl IS TABLE OF FA_API_TYPES.asset_deprn_rec_type INDEX BY BINARY_INTEGER;
1559:
1560: l_group_reclass_options_rec reclass_option_tbl;
1561: l_grp_src_trans_rec trans_rec_new_tbl;
1554: TYPE trans_rec_new_tbl IS TABLE OF FA_API_TYPES.trans_rec_type INDEX BY BINARY_INTEGER;
1555: TYPE asset_hdr_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_hdr_rec_type INDEX BY BINARY_INTEGER;
1556: TYPE asset_type_rec_new_tbl IS TABLE OF FA_API_TYPES.asset_type_rec_type INDEX BY BINARY_INTEGER;
1557: TYPE amort_init_member_tbl IS TABLE OF FA_API_TYPES.amort_init_rec_type INDEX BY BINARY_INTEGER;
1558: TYPE asset_deprn_rec_tbl IS TABLE OF FA_API_TYPES.asset_deprn_rec_type INDEX BY BINARY_INTEGER;
1559:
1560: l_group_reclass_options_rec reclass_option_tbl;
1561: l_grp_src_trans_rec trans_rec_new_tbl;
1562: l_grp_src_asset_hdr_rec asset_hdr_rec_new_tbl;