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 2187: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type) IS

2183: x_msg_count OUT NOCOPY NUMBER,
2184: x_msg_data OUT NOCOPY VARCHAR2,
2185: p_asset_id IN NUMBER,
2186: p_book_type_code IN VARCHAR2,
2187: x_asset_deprn_rec OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type) IS
2188:
2189: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2190: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
2191: l_api_version CONSTANT NUMBER := 1.0;

Line 2193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

2189: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2190: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
2191: l_api_version CONSTANT NUMBER := 1.0;
2192:
2193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2194: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2195: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2196:
2197: l_deprn_reserve NUMBER;

Line 2194: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

2190: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEPRN_RESERVE';
2191: l_api_version CONSTANT NUMBER := 1.0;
2192:
2193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2194: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2195: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2196:
2197: l_deprn_reserve NUMBER;
2198:

Line 2195: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

2191: l_api_version CONSTANT NUMBER := 1.0;
2192:
2193: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2194: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2195: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2196:
2197: l_deprn_reserve NUMBER;
2198:
2199: BEGIN

Line 10987: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS

10983: p_sla_asset_chr_id IN Number,
10984: --Bug# 6373605--SLA populate source
10985: --Bug# 4028371
10986: x_fa_trx_date OUT NOCOPY date,
10987: x_asset_hdr_rec OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS
10988:
10989: l_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
10990: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADD';
10991: l_api_version CONSTANT NUMBER := 1.0;

Line 10993: l_trans_rec FA_API_TYPES.trans_rec_type;

10989: l_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
10990: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADD';
10991: l_api_version CONSTANT NUMBER := 1.0;
10992:
10993: l_trans_rec FA_API_TYPES.trans_rec_type;
10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

10990: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADD';
10991: l_api_version CONSTANT NUMBER := 1.0;
10992:
10993: l_trans_rec FA_API_TYPES.trans_rec_type;
10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

10991: l_api_version CONSTANT NUMBER := 1.0;
10992:
10993: l_trans_rec FA_API_TYPES.trans_rec_type;
10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

10992:
10993: l_trans_rec FA_API_TYPES.trans_rec_type;
10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

Line 10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

10993: l_trans_rec FA_API_TYPES.trans_rec_type;
10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

10994: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

10995: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

10996: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

10997: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11005: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

Line 11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

10998: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11005: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11006:

Line 11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

10999: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11005: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11006:
11007: l_split_factor NUMBER;

Line 11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;

11000: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11005: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11006:
11007: l_split_factor NUMBER;
11008:

Line 11005: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;

11001: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11002: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
11003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11004: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11005: l_asset_hierarchy_rec fa_api_types.asset_hierarchy_rec_type;
11006:
11007: l_split_factor NUMBER;
11008:
11009: --cursor to get asset key ccid

Line 11090: l_asset_hdr_orig_rec FA_API_TYPES.asset_hdr_rec_type;

11086: --3156924:
11087: l_calling_interface Varchar2(30) := 'OKLRSPAB:Split Asset';
11088:
11089: --Bug# 5946411
11090: l_asset_hdr_orig_rec FA_API_TYPES.asset_hdr_rec_type;
11091:
11092: -- bug 6061103 -- start
11093: CURSOR l_cleb_sts_csr(pcleid IN NUMBER) IS
11094: SELECT cleb.sts_code sts_code,

Line 11124: l_adj_trans_rec FA_API_TYPES.trans_rec_type;

11120: l_temp_bonus_ytd_deprn number;
11121: l_temp_bonus_deprn_reserve number;
11122: l_amortization_date DATE;
11123: l_special_treatment_required VARCHAR2(1);
11124: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

Line 11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

11121: l_temp_bonus_deprn_reserve number;
11122: l_amortization_date DATE;
11123: l_special_treatment_required VARCHAR2(1);
11124: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

11122: l_amortization_date DATE;
11123: l_special_treatment_required VARCHAR2(1);
11124: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

11123: l_special_treatment_required VARCHAR2(1);
11124: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;

Line 11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

11124: l_adj_trans_rec FA_API_TYPES.trans_rec_type;
11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

11125: l_adj_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;

11126: l_adj_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;

11127: l_adj_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;

Line 11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

11128: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

11129: l_adj_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11137: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

11130: l_adj_inv_tbl FA_API_TYPES.inv_tbl_type;
11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11137: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11138: -- bug 6061103 -- end

Line 11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;

11131: l_adj_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11137: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11138: -- bug 6061103 -- end
11139:

Line 11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

11132: l_adj_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11137: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11138: -- bug 6061103 -- end
11139:
11140: --Bug# 6373605 begin

Line 11137: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

11133: l_adj_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
11134: l_adj_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
11135: l_adj_inv_rec FA_API_TYPES.inv_rec_type;
11136: l_adj_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
11137: l_adj_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
11138: -- bug 6061103 -- end
11139:
11140: --Bug# 6373605 begin
11141: l_fxhv_rec okl_sla_acc_sources_pvt.fxhv_rec_type;

Line 11146: x_log_level_rec FA_API_TYPES.log_level_rec_type;

11142: l_fxlv_rec okl_sla_acc_sources_pvt.fxlv_rec_type;
11143: --Bug# 6373605 end
11144:
11145: --Bug# 6955027
11146: x_log_level_rec FA_API_TYPES.log_level_rec_type;
11147:
11148: BEGIN
11149: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11150: -- Call start_activity to create savepoint, check compatibility

Line 11628: l_trans_rec fa_api_types.trans_rec_type;

11624: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_UNIT_ADJ';
11625: l_api_version CONSTANT NUMBER := 1.0;
11626:
11627:
11628: l_trans_rec fa_api_types.trans_rec_type;
11629: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
11630: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
11631:
11632: l_calling_interface VARCHAR2(30) := 'OKL:Split Asset';

Line 11629: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

11625: l_api_version CONSTANT NUMBER := 1.0;
11626:
11627:
11628: l_trans_rec fa_api_types.trans_rec_type;
11629: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
11630: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
11631:
11632: l_calling_interface VARCHAR2(30) := 'OKL:Split Asset';
11633: l_units_to_adjust NUMBER;

Line 11630: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

11626:
11627:
11628: l_trans_rec fa_api_types.trans_rec_type;
11629: l_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
11630: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
11631:
11632: l_calling_interface VARCHAR2(30) := 'OKL:Split Asset';
11633: l_units_to_adjust NUMBER;
11634: i NUMBER;

Line 11801: l_trans_rec FA_API_TYPES.trans_rec_type;

11797: l_split_factor NUMBER;
11798: l_units_to_retire NUMBER;
11799:
11800: /* define local record types */
11801: l_trans_rec FA_API_TYPES.trans_rec_type;
11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

11798: l_units_to_retire NUMBER;
11799:
11800: /* define local record types */
11801: l_trans_rec FA_API_TYPES.trans_rec_type;
11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

11799:
11800: /* define local record types */
11801: l_trans_rec FA_API_TYPES.trans_rec_type;
11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11807: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

Line 11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

11800: /* define local record types */
11801: l_trans_rec FA_API_TYPES.trans_rec_type;
11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11807: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11808:

Line 11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

11801: l_trans_rec FA_API_TYPES.trans_rec_type;
11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11807: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11808:
11809:

Line 11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;

11802: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11807: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11808:
11809:
11810: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 11807: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

11803: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
11804: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
11805: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
11806: l_inv_tbl FA_API_TYPES.inv_tbl_type;
11807: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
11808:
11809:
11810: l_commit VARCHAR2(1) := FND_API.G_FALSE;
11811: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

Line 12194: l_trans_rec FA_API_TYPES.trans_rec_type;

12190: l_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
12191: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADJUST';
12192: l_api_version CONSTANT NUMBER := 1.0;
12193:
12194: l_trans_rec FA_API_TYPES.trans_rec_type;
12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

Line 12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

12191: l_api_name CONSTANT VARCHAR2(30) := 'FIXED_ASSET_ADJUST';
12192: l_api_version CONSTANT NUMBER := 1.0;
12193:
12194: l_trans_rec FA_API_TYPES.trans_rec_type;
12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

Line 12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

12192: l_api_version CONSTANT NUMBER := 1.0;
12193:
12194: l_trans_rec FA_API_TYPES.trans_rec_type;
12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

12193:
12194: l_trans_rec FA_API_TYPES.trans_rec_type;
12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

12194: l_trans_rec FA_API_TYPES.trans_rec_type;
12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;

12195: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

12196: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;

12197: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

12198: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;
12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

12199: --l_asset_fin_glob_dff_rec FA_API_TYPES.asset_fin_glob_dff_rec_type;
12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;
12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

12200: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;
12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12208:

Line 12205: l_inv_rec FA_API_TYPES.inv_rec_type;

12201: l_inv_tbl FA_API_TYPES.inv_tbl_type;
12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;
12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12208:
12209: --parameters for unit adjustment

Line 12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

12202: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;
12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12208:
12209: --parameters for unit adjustment
12210: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;

12203: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
12204: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
12205: l_inv_rec FA_API_TYPES.inv_rec_type;
12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12208:
12209: --parameters for unit adjustment
12210: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12211: l_trans_rec_ua FA_API_TYPES.trans_rec_type;

Line 12210: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

12206: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12208:
12209: --parameters for unit adjustment
12210: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12211: l_trans_rec_ua FA_API_TYPES.trans_rec_type;
12212: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;
12213:
12214:

Line 12211: l_trans_rec_ua FA_API_TYPES.trans_rec_type;

12207: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
12208:
12209: --parameters for unit adjustment
12210: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12211: l_trans_rec_ua FA_API_TYPES.trans_rec_type;
12212: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;
12213:
12214:
12215: l_split_factor NUMBER;

Line 12212: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;

12208:
12209: --parameters for unit adjustment
12210: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
12211: l_trans_rec_ua FA_API_TYPES.trans_rec_type;
12212: l_asset_hdr_rec_ua FA_API_TYPES.asset_hdr_rec_type;
12213:
12214:
12215: l_split_factor NUMBER;
12216: l_units_to_adjust NUMBER;

Line 12337: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

12333: l_chr_id number;
12334: -- Bug# 6061103 end
12335:
12336: --Bug# 5946411: avsingh - parameters for getting depreciation reserve
12337: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12338: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12339: BEGIN
12340: x_return_status := OKL_API.G_RET_STS_SUCCESS;
12341: --call start activity to set savepoint

Line 12338: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

12334: -- Bug# 6061103 end
12335:
12336: --Bug# 5946411: avsingh - parameters for getting depreciation reserve
12337: l_fa_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
12338: l_fa_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
12339: BEGIN
12340: x_return_status := OKL_API.G_RET_STS_SUCCESS;
12341: --call start activity to set savepoint
12342: x_return_status := OKL_API.START_ACTIVITY( SUBSTR(l_api_name,1,26),

Line 14677: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

14673: WHERE txd.target_kle_id = cim.cle_id
14674: AND txd.id = p_id
14675: );
14676:
14677: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
14678: l_cim_id NUMBER;
14679: l_cimv_rec cimv_rec_type;
14680: l_cimv_rec_out cimv_rec_type;
14681: l_cim_cle_id NUMBER;