eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPLIT_ASSET_PVT dependencies on FA_API_TYPES

Line 2215: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type) IS

2211: x_msg_count OUT NOCOPY NUMBER,
2212: x_msg_data OUT NOCOPY VARCHAR2,
2213: p_asset_id IN NUMBER,
2214: p_book_type_code IN VARCHAR2,
2215: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type) IS
2216:
2217: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2218: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
2219: l_api_version CONSTANT NUMBER := 1.0;

Line 2221: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

2217: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2218: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
2219: l_api_version CONSTANT NUMBER := 1.0;
2220:
2221: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2222: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2223: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2224:
2225: l_deprn_reserve NUMBER;

Line 2222: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

2218: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
2219: l_api_version CONSTANT NUMBER := 1.0;
2220:
2221: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2222: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2223: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2224:
2225: l_deprn_reserve NUMBER;
2226:

Line 2223: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

2219: l_api_version CONSTANT NUMBER := 1.0;
2220:
2221: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2222: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2223: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2224:
2225: l_deprn_reserve NUMBER;
2226:
2227: BEGIN

Line 11040: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS

11036: p_sla_asset_chr_id IN Number,
11037: --Bug# 6373605--SLA populate source
11038: --Bug# 4028371
11039: x_fa_trx_date OUT NOCOPY date,
11040: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS
11041:
11042: l_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
11043: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADD';
11044: l_api_version CONSTANT NUMBER := 1.0;

Line 11046: l_trans_rec FA_API_TYPES.trans_rec_type;

11042: l_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
11043: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADD';
11044: l_api_version CONSTANT NUMBER := 1.0;
11045:
11046: l_trans_rec FA_API_TYPES.trans_rec_type;
11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

11043: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADD';
11044: l_api_version CONSTANT NUMBER := 1.0;
11045:
11046: l_trans_rec FA_API_TYPES.trans_rec_type;
11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

11044: l_api_version CONSTANT NUMBER := 1.0;
11045:
11046: l_trans_rec FA_API_TYPES.trans_rec_type;
11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

11045:
11046: l_trans_rec FA_API_TYPES.trans_rec_type;
11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

Line 11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

11046: l_trans_rec FA_API_TYPES.trans_rec_type;
11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

11047: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

11048: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

11049: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

11050: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11058: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

Line 11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

11051: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11058: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11059:

Line 11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

11052: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11058: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11059:
11060: l_split_factor NUMBER;

Line 11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;

11053: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11058: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11059:
11060: l_split_factor NUMBER;
11061:

Line 11058: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

11054: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11055: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11056: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11057: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11058: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11059:
11060: l_split_factor NUMBER;
11061:
11062: --cursor to get asset key ccid

Line 11143: l_asset_hdr_orig_rec FA_API_TYPES.asset_hdr_rec_type;

11139: --3156924:
11140: l_calling_interface Varchar2(30) := 'OKLRSPAB:Split Asset';
11141:
11142: --Bug# 5946411
11143: l_asset_hdr_orig_rec FA_API_TYPES.asset_hdr_rec_type;
11144:
11145: -- bug 6061103 -- start
11146: CURSOR l_cleb_sts_csr(pcleid IN NUMBER) IS
11147: SELECT cleb.sts_code sts_code,

Line 11177: l_adj_trans_rec FA_API_TYPES.trans_rec_type;

11173: l_temp_bonus_ytd_deprn number;
11174: l_temp_bonus_deprn_reserve number;
11175: l_amortization_date DATE;
11176: l_special_treatment_required VARCHAR2(1);
11177: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

Line 11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

11174: l_temp_bonus_deprn_reserve number;
11175: l_amortization_date DATE;
11176: l_special_treatment_required VARCHAR2(1);
11177: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

11175: l_amortization_date DATE;
11176: l_special_treatment_required VARCHAR2(1);
11177: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

11176: l_special_treatment_required VARCHAR2(1);
11177: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;

Line 11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

11177: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

11178: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;

11179: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;

11180: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;

Line 11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

11181: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

11182: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11190: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

11183: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11190: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11191: -- bug 6061103 -- end

Line 11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;

11184: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11190: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11191: -- bug 6061103 -- end
11192:

Line 11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

11185: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11190: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11191: -- bug 6061103 -- end
11192:
11193: --Bug# 6373605 begin

Line 11190: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

11186: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11187: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11188: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11189: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11190: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11191: -- bug 6061103 -- end
11192:
11193: --Bug# 6373605 begin
11194: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;

Line 11199: x_log_level_rec FA_API_TYPES.log_level_rec_type;

11195: l_fxlv_rec okl_sla_acc_sources_pvt.fxlv_rec_type;
11196: --Bug# 6373605 end
11197:
11198: --Bug# 6955027
11199: x_log_level_rec FA_API_TYPES.log_level_rec_type;
11200:
11201: BEGIN
11202: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11203: -- Call start_activity to create savepoint, check compatibility

Line 11681: l_trans_rec fa_api_types.trans_rec_type;

11677: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_UNIT_ADJ';
11678: l_api_version CONSTANT NUMBER := 1.0;
11679:
11680:
11681: l_trans_rec fa_api_types.trans_rec_type;
11682: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
11683: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
11684:
11685: l_calling_interface VARCHAR2(30) := 'OKL:Split Asset';

Line 11682: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

11678: l_api_version CONSTANT NUMBER := 1.0;
11679:
11680:
11681: l_trans_rec fa_api_types.trans_rec_type;
11682: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
11683: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
11684:
11685: l_calling_interface VARCHAR2(30) := 'OKL:Split Asset';
11686: l_units_to_adjust NUMBER;

Line 11683: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

11679:
11680:
11681: l_trans_rec fa_api_types.trans_rec_type;
11682: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
11683: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
11684:
11685: l_calling_interface VARCHAR2(30) := 'OKL:Split Asset';
11686: l_units_to_adjust NUMBER;
11687: i NUMBER;

Line 11854: l_trans_rec FA_API_TYPES.trans_rec_type;

11850: l_split_factor NUMBER;
11851: l_units_to_retire NUMBER;
11852:
11853: /* define local record types */
11854: l_trans_rec FA_API_TYPES.trans_rec_type;
11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

11851: l_units_to_retire NUMBER;
11852:
11853: /* define local record types */
11854: l_trans_rec FA_API_TYPES.trans_rec_type;
11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

11852:
11853: /* define local record types */
11854: l_trans_rec FA_API_TYPES.trans_rec_type;
11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11860: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

Line 11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

11853: /* define local record types */
11854: l_trans_rec FA_API_TYPES.trans_rec_type;
11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11860: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11861:

Line 11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

11854: l_trans_rec FA_API_TYPES.trans_rec_type;
11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11860: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11861:
11862:

Line 11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;

11855: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11860: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11861:
11862:
11863: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 11860: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

11856: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11857: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11858: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11859: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11860: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11861:
11862:
11863: l_commit VARCHAR2(1) := FND_API.G_FALSE;
11864: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 12247: l_trans_rec FA_API_TYPES.trans_rec_type;

12243: l_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
12244: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADJUST';
12245: l_api_version CONSTANT NUMBER := 1.0;
12246:
12247: l_trans_rec FA_API_TYPES.trans_rec_type;
12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

12244: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADJUST';
12245: l_api_version CONSTANT NUMBER := 1.0;
12246:
12247: l_trans_rec FA_API_TYPES.trans_rec_type;
12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

Line 12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

12245: l_api_version CONSTANT NUMBER := 1.0;
12246:
12247: l_trans_rec FA_API_TYPES.trans_rec_type;
12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

12246:
12247: l_trans_rec FA_API_TYPES.trans_rec_type;
12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

12247: l_trans_rec FA_API_TYPES.trans_rec_type;
12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

12248: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

12249: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;

12250: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

12251: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;
12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

12252: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;
12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

12253: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;
12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12261:

Line 12258: l_inv_rec FA_API_TYPES.inv_rec_type;

12254: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;
12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12261:
12262: --parameters for unit adjustment

Line 12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

12255: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;
12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12261:
12262: --parameters for unit adjustment
12263: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

12256: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12257: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12258: l_inv_rec FA_API_TYPES.inv_rec_type;
12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12261:
12262: --parameters for unit adjustment
12263: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12264: l_trans_rec_ua FA_API_TYPES.trans_rec_type;

Line 12263: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

12259: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12261:
12262: --parameters for unit adjustment
12263: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12264: l_trans_rec_ua FA_API_TYPES.trans_rec_type;
12265: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;
12266:
12267:

Line 12264: l_trans_rec_ua FA_API_TYPES.trans_rec_type;

12260: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12261:
12262: --parameters for unit adjustment
12263: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12264: l_trans_rec_ua FA_API_TYPES.trans_rec_type;
12265: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;
12266:
12267:
12268: l_split_factor NUMBER;

Line 12265: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;

12261:
12262: --parameters for unit adjustment
12263: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12264: l_trans_rec_ua FA_API_TYPES.trans_rec_type;
12265: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;
12266:
12267:
12268: l_split_factor NUMBER;
12269: l_units_to_adjust NUMBER;

Line 12390: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

12386: l_chr_id number;
12387: -- Bug# 6061103 end
12388:
12389: --Bug# 5946411: avsingh - parameters for getting depreciation reserve
12390: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12391: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12392: BEGIN
12393: x_return_status := OKL_API.G_RET_STS_SUCCESS;
12394: --call start activity to set savepoint

Line 12391: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

12387: -- Bug# 6061103 end
12388:
12389: --Bug# 5946411: avsingh - parameters for getting depreciation reserve
12390: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12391: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12392: BEGIN
12393: x_return_status := OKL_API.G_RET_STS_SUCCESS;
12394: --call start activity to set savepoint
12395: x_return_status := OKL_API.START_ACTIVITY( SUBSTR(l_api_name,1,26),

Line 14730: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

14726: WHERE txd.target_kle_id = cim.cle_id
14727: AND txd.id = p_id
14728: );
14729:
14730: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14731: l_cim_id NUMBER;
14732: l_cimv_rec cimv_rec_type;
14733: l_cimv_rec_out cimv_rec_type;
14734: l_cim_cle_id NUMBER;