DBA Data[Home] [Help]

APPS.OKL_LIKE_KIND_EXCHANGE_PVT dependencies on FA_API_TYPES

Line 194: x_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is

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;

Line 200: l_trans_rec FA_API_TYPES.trans_rec_type;

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;

Line 201: l_dist_trans_rec FA_API_TYPES.trans_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;

Line 202: l_asset_hdr_rec FA_API_TYPES.asset_hdr_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;

Line 203: l_asset_desc_rec FA_API_TYPES.asset_desc_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;

Line 204: l_asset_cat_rec FA_API_TYPES.asset_cat_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;

Line 205: l_asset_type_rec FA_API_TYPES.asset_type_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;

Line 206: l_asset_fin_rec FA_API_TYPES.asset_fin_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;
210: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 207: l_asset_deprn_rec FA_API_TYPES.asset_deprn_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;
211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;

Line 208: l_asset_dist_rec FA_API_TYPES.asset_dist_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:

Line 209: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_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:
213: l_split_factor NUMBER;

Line 210: l_inv_tbl FA_API_TYPES.inv_tbl_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;
214: l_mesg VARCHAR2(2000);

Line 211: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_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);
215: l_mesg_len NUMBER;

Line 420: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS

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;

Line 425: l_trans_rec FA_API_TYPES.trans_rec_type;

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;

Line 426: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_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;

Line 427: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_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;

Line 428: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_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;

Line 429: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_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;

Line 430: l_inv_trans_rec FA_API_TYPES.inv_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;
434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 431: l_inv_tbl FA_API_TYPES.inv_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;

Line 432: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_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;

Line 433: l_asset_deprn_rec_new 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;

Line 434: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_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;
438: l_asset_id NUMBER := p_asset_id;

Line 435: l_inv_rec FA_API_TYPES.inv_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;
439: l_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE := p_book_type_code;

Line 436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_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;
440: l_adjust_cost NUMBER := p_adjust_cost;

Line 437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_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;
441: BEGIN

Line 572: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

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

Line 573: l_asset_fin_rec FA_API_TYPES.asset_fin_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
577: SELECT id