190: p_rep_asset_rec IN rep_asset_rec_type,
191: p_asdt_rec IN asset_details_rec_type,
192: p_txlv_rec IN OKL_TXL_ASSETS_PUB.tlpv_rec_type,
193: p_txdv_rec IN OKL_TXD_ASSETS_PUB.adpv_rec_type,
194: x_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is
195:
196: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
197: l_api_name CONSTANT VARCHAR2(2000) := 'CREATE_FIXED_ASSET';
198: l_api_version CONSTANT NUMBER := 1.0;
196: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
197: l_api_name CONSTANT VARCHAR2(2000) := 'CREATE_FIXED_ASSET';
198: l_api_version CONSTANT NUMBER := 1.0;
199:
200: l_trans_rec FA_API_TYPES.trans_rec_type;
201: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
197: l_api_name CONSTANT VARCHAR2(2000) := 'CREATE_FIXED_ASSET';
198: l_api_version CONSTANT NUMBER := 1.0;
199:
200: l_trans_rec FA_API_TYPES.trans_rec_type;
201: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
198: l_api_version CONSTANT NUMBER := 1.0;
199:
200: l_trans_rec FA_API_TYPES.trans_rec_type;
201: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
199:
200: l_trans_rec FA_API_TYPES.trans_rec_type;
201: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
200: l_trans_rec FA_API_TYPES.trans_rec_type;
201: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
201: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;
203: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;
211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
204: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;
211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
212:
205: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;
211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
212:
213: l_split_factor NUMBER;
206: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;
211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
212:
213: l_split_factor NUMBER;
214: l_mesg VARCHAR2(2000);
207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
208: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;
211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
212:
213: l_split_factor NUMBER;
214: l_mesg VARCHAR2(2000);
215: l_mesg_len NUMBER;
416: x_msg_data OUT NOCOPY VARCHAR2,
417: p_asset_id IN NUMBER,
418: p_book_type_code IN OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE,
419: p_adjust_cost IN NUMBER,
420: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
421:
422:
423: l_api_name CONSTANT varchar2(30) := 'ADJUST_FIXED_ASSET';
424: l_api_version CONSTANT NUMBER := 1.0;
421:
422:
423: l_api_name CONSTANT varchar2(30) := 'ADJUST_FIXED_ASSET';
424: l_api_version CONSTANT NUMBER := 1.0;
425: l_trans_rec FA_API_TYPES.trans_rec_type;
426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
422:
423: l_api_name CONSTANT varchar2(30) := 'ADJUST_FIXED_ASSET';
424: l_api_version CONSTANT NUMBER := 1.0;
425: l_trans_rec FA_API_TYPES.trans_rec_type;
426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
423: l_api_name CONSTANT varchar2(30) := 'ADJUST_FIXED_ASSET';
424: l_api_version CONSTANT NUMBER := 1.0;
425: l_trans_rec FA_API_TYPES.trans_rec_type;
426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
424: l_api_version CONSTANT NUMBER := 1.0;
425: l_trans_rec FA_API_TYPES.trans_rec_type;
426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
425: l_trans_rec FA_API_TYPES.trans_rec_type;
426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
430: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
438: l_asset_id NUMBER := p_asset_id;
431: l_inv_tbl FA_API_TYPES.inv_tbl_type;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
438: l_asset_id NUMBER := p_asset_id;
439: l_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE := p_book_type_code;
432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
438: l_asset_id NUMBER := p_asset_id;
439: l_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE := p_book_type_code;
440: l_adjust_cost NUMBER := p_adjust_cost;
433: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
438: l_asset_id NUMBER := p_asset_id;
439: l_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE := p_book_type_code;
440: l_adjust_cost NUMBER := p_adjust_cost;
441: BEGIN
568: x_talv_rec OKL_TXL_ASSETS_PUB.tlpv_rec_type;
569: x_txdv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
570: l_asdt_rec asset_details_rec_type;
571: l_txdt_rec asset_details_rec_type;
572: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
573: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
574:
575: -- cursor to get transaction type id
576: CURSOR trx_types_csr IS
569: x_txdv_rec OKL_TXD_ASSETS_PUB.adpv_rec_type;
570: l_asdt_rec asset_details_rec_type;
571: l_txdt_rec asset_details_rec_type;
572: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
573: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
574:
575: -- cursor to get transaction type id
576: CURSOR trx_types_csr IS
577: SELECT id