DBA Data[Home] [Help]

APPS.OKL_COPY_ASSET_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 80: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;

76: G_GEN_ASSET_NUMBER CONSTANT VARCHAR2(200) := 'OKL_LLA_GEN_ASSET_NUMBER';
77: -------------------------------------------------------------------------------------------------
78: -- COMPOSITE GLOBAL VARIABLES
79: -------------------------------------------------------------------------------------------------
80: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
81: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;
82: subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
83: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
84: subtype trxv_tbl_type is OKL_TRX_ASSETS_PUB.thpv_tbl_type;

Line 81: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;

77: -------------------------------------------------------------------------------------------------
78: -- COMPOSITE GLOBAL VARIABLES
79: -------------------------------------------------------------------------------------------------
80: subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
81: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;
82: subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
83: subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
84: subtype trxv_tbl_type is OKL_TRX_ASSETS_PUB.thpv_tbl_type;
85: subtype talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;

Line 3932: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

3928: where msi.organization_id = p_inv_org_id
3929: and msi.inventory_item_id = p_inv_item_id;
3930:
3931: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
3932: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
3933: l_klev_rec okl_contract_pub.klev_rec_type;
3934: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
3935: lx_klev_rec okl_contract_pub.klev_rec_type;
3936:

Line 3934: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

3930:
3931: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
3932: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
3933: l_klev_rec okl_contract_pub.klev_rec_type;
3934: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
3935: lx_klev_rec okl_contract_pub.klev_rec_type;
3936:
3937: l_inv_item_id number;
3938: l_inv_org_id number;

Line 4337: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

4333: l_rate_exists varchar2(1);
4334: --Bug# 3621663
4335:
4336: --Bug# 3877032
4337: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
4338: l_fin_klev_rec okl_contract_pub.klev_rec_type;
4339: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
4340: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
4341:

Line 4339: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

4335:
4336: --Bug# 3877032
4337: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
4338: l_fin_klev_rec okl_contract_pub.klev_rec_type;
4339: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
4340: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
4341:
4342: BEGIN
4343: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4909: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,

4905: END IF;
4906: l_cimv_rec.object1_id1 := null;
4907: l_cimv_rec.object1_id2 := null;
4908: -- Updating of Item Record for the above record information
4909: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
4910: p_init_msg_list => p_init_msg_list,
4911: x_return_status => x_return_status,
4912: x_msg_count => x_msg_count,
4913: x_msg_data => x_msg_data,

Line 5231: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,

5227: END IF;
5228: l_cimv_rec.object1_id1 := null;
5229: l_cimv_rec.object1_id2 := null;
5230: -- Updating of Item Record for the above record information
5231: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
5232: p_init_msg_list => p_init_msg_list,
5233: x_return_status => x_return_status,
5234: x_msg_count => x_msg_count,
5235: x_msg_data => x_msg_data,

Line 5587: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

5583: p_new_chr_id IN NUMBER) IS
5584: l_api_name VARCHAR2(30) := 'LINK_COV_ASSET';
5585: l_new_cle_id OKC_K_LINES_B.ID%TYPE;
5586: l_new_lnk_cim_id NUMBER;
5587: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5588: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5589: --cursor to fetch original fin linked asset line id
5590: CURSOR l_orig_ast_csr(p_orig_lnk_cle_id IN NUMBER,
5591: p_new_chr_id IN NUMBER) IS

Line 5588: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

5584: l_api_name VARCHAR2(30) := 'LINK_COV_ASSET';
5585: l_new_cle_id OKC_K_LINES_B.ID%TYPE;
5586: l_new_lnk_cim_id NUMBER;
5587: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5588: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5589: --cursor to fetch original fin linked asset line id
5590: CURSOR l_orig_ast_csr(p_orig_lnk_cle_id IN NUMBER,
5591: p_new_chr_id IN NUMBER) IS
5592: SELECT new_cle.id

Line 5641: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

5637: and fin_ast_lseb.lty_code = 'FREE_FORM1'
5638: and fin_ast_cleb.dnz_chr_id = cov_ast_cim.dnz_chr_id);
5639:
5640:
5641: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
5642: l_fin_klev_rec okl_contract_pub.klev_rec_type;
5643: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
5644: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
5645:

Line 5643: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;

5639:
5640:
5641: l_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
5642: l_fin_klev_rec okl_contract_pub.klev_rec_type;
5643: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
5644: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
5645:
5646: BEGIN
5647: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5672: okl_okc_migration_pvt.update_contract_item(p_api_version => p_api_version,

5668: END IF;
5669: CLOSE l_orig_ast_csr;
5670: END IF;
5671: --update link contract item accordingly
5672: okl_okc_migration_pvt.update_contract_item(p_api_version => p_api_version,
5673: p_init_msg_list => p_init_msg_list,
5674: x_return_status => x_return_status,
5675: x_msg_count => x_msg_count,
5676: x_msg_data => x_msg_data,