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_CREATE_KLE_PVT dependencies on OKL_OKC_MIGRATION_PVT

Line 5413: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

5409: where msi.organization_id = p_inv_org_id
5410: and msi.inventory_item_id = p_inv_item_id;
5411:
5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5413: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5414: l_klev_rec okl_contract_pub.klev_rec_type;
5415: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5416: lx_klev_rec okl_contract_pub.klev_rec_type;
5417:

Line 5415: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

5411:
5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5413: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5414: l_klev_rec okl_contract_pub.klev_rec_type;
5415: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5416: lx_klev_rec okl_contract_pub.klev_rec_type;
5417:
5418:
5419: BEGIN

Line 5659: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,

5655: l_cimv_rec.dnz_chr_id := x_clev_rec.dnz_chr_id;
5656: l_cimv_rec.jtot_object1_code := 'OKX_SYSITEM';
5657: l_cimv_rec.exception_yn := 'N';
5658: -- Creation of Item Record for the above record information
5659: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
5660: p_init_msg_list => p_init_msg_list,
5661: x_return_status => x_return_status,
5662: x_msg_count => x_msg_count,
5663: x_msg_data => x_msg_data,

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

5820: p_msg_name => G_ITEM_RECORD);
5821: RAISE OKL_API.G_EXCEPTION_ERROR;
5822: END IF;
5823: -- Creation of Item Record for the above record information
5824: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
5825: p_init_msg_list => p_init_msg_list,
5826: x_return_status => x_return_status,
5827: x_msg_count => x_msg_count,
5828: x_msg_data => x_msg_data,

Line 6085: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,

6081: FETCH c_asset_exist_chr into ln_dummy;
6082: CLOSE c_asset_exist_chr;
6083: IF ln_dummy <> 1 THEN
6084: -- Creation of Item Record for the above record information
6085: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
6086: p_init_msg_list => p_init_msg_list,
6087: x_return_status => x_return_status,
6088: x_msg_count => x_msg_count,
6089: x_msg_data => x_msg_data,

Line 6146: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,

6142: END IF;
6143: ELSE
6144: -- Since id1,id12 are null , hence NO Asset Number we are creating a new asset Number
6145: -- Creation of Item Record for the above record information
6146: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
6147: p_init_msg_list => p_init_msg_list,
6148: x_return_status => x_return_status,
6149: x_msg_count => x_msg_count,
6150: x_msg_data => x_msg_data,

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

6319: p_msg_name => G_ITEM_RECORD);
6320: RAISE OKL_API.G_EXCEPTION_ERROR;
6321: END IF;
6322: -- Creation of Item Record for the above record information
6323: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
6324: p_init_msg_list => p_init_msg_list,
6325: x_return_status => x_return_status,
6326: x_msg_count => x_msg_count,
6327: x_msg_data => x_msg_data,

Line 6568: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,

6564: p_msg_name => G_ITEM_RECORD);
6565: RAISE OKL_API.G_EXCEPTION_ERROR;
6566: END IF;
6567: -- Creation of Item Record for the above record information
6568: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
6569: p_init_msg_list => p_init_msg_list,
6570: x_return_status => x_return_status,
6571: x_msg_count => x_msg_count,
6572: x_msg_data => x_msg_data,

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

6772: p_msg_name => G_ITEM_RECORD);
6773: RAISE OKL_API.G_EXCEPTION_ERROR;
6774: END IF;
6775: -- Creation of Item Record for the above record information
6776: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
6777: p_init_msg_list => p_init_msg_list,
6778: x_return_status => x_return_status,
6779: x_msg_count => x_msg_count,
6780: x_msg_data => x_msg_data,

Line 7834: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,

7830: (l_cimv_rec.object1_id2 IS NULL OR
7831: l_cimv_rec.object1_id2 = OKL_API.G_MISS_CHAR) THEN
7832: -- We have create the item rec,tal rec,trx rec and also create the iti rec
7833: -- Creation of Item Record for the above record information
7834: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
7835: p_init_msg_list => p_init_msg_list,
7836: x_return_status => x_return_status,
7837: x_msg_count => x_msg_count,
7838: x_msg_data => x_msg_data,

Line 7914: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,

7910: l_cimv_rec.object1_id1 <> OKL_API.G_MISS_CHAR) AND
7911: (l_cimv_rec.object1_id2 IS NOT NULL OR
7912: l_cimv_rec.object1_id2 <> OKL_API.G_MISS_CHAR)THEN
7913: -- Creation of Item Record for the above record information
7914: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
7915: p_init_msg_list => p_init_msg_list,
7916: x_return_status => x_return_status,
7917: x_msg_count => x_msg_count,
7918: x_msg_data => x_msg_data,

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

8114: (l_cimv_rec.object1_id2 IS NULL OR
8115: l_cimv_rec.object1_id2 = OKL_API.G_MISS_CHAR) THEN
8116: -- We have create the item rec,tal rec,trx rec and also create the iti rec
8117: -- Creation of Item Record for the above record information
8118: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
8119: p_init_msg_list => p_init_msg_list,
8120: x_return_status => x_return_status,
8121: x_msg_count => x_msg_count,
8122: x_msg_data => x_msg_data,

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

8175: l_cimv_rec.object1_id1 <> OKL_API.G_MISS_CHAR) AND
8176: (l_cimv_rec.object1_id2 IS NOT NULL OR
8177: l_cimv_rec.object1_id2 <> OKL_API.G_MISS_CHAR) THEN
8178: -- Creation of Item Record for the above record information
8179: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
8180: p_init_msg_list => p_init_msg_list,
8181: x_return_status => x_return_status,
8182: x_msg_count => x_msg_count,
8183: x_msg_data => x_msg_data,

Line 11869: OKL_OKC_MIGRATION_PVT.create_k_party_role(p_api_version => p_api_version,

11865: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
11866: -- to create records in tables
11867: -- okc_k_party_roles_b and okl_k_party_roles
11868: /*
11869: OKL_OKC_MIGRATION_PVT.create_k_party_role(p_api_version => p_api_version,
11870: p_init_msg_list => p_init_msg_list,
11871: x_return_status => x_return_status,
11872: x_msg_count => x_msg_count,
11873: x_msg_data => x_msg_data,

Line 12060: OKL_OKC_MIGRATION_PVT.update_k_party_role(p_api_version => p_api_version,

12056: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
12057: -- to update records in tables
12058: -- okc_k_party_roles_b and okl_k_party_roles
12059: /*
12060: OKL_OKC_MIGRATION_PVT.update_k_party_role(p_api_version => p_api_version,
12061: p_init_msg_list => p_init_msg_list,
12062: x_return_status => x_return_status,
12063: x_msg_count => x_msg_count,
12064: x_msg_data => x_msg_data,

Line 12580: l_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;

12576: AND rgpb.dnz_chr_id = p_chr_id;
12577:
12578:
12579: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
12580: l_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
12581:
12582:
12583: --cursor to get cost and salvage value for corporate book
12584: CURSOR l_corpbook_csr (p_cle_id in number,

Line 12685: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

12681: where cle_id = p_cle_id
12682: and dnz_chr_id = p_chr_id;
12683:
12684: l_cpl_id OKC_K_PARTY_ROLES_B.ID%TYPE;
12685: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
12686:
12687:
12688: --cursor to get supplier invoice details
12689: CURSOR l_sid_csr (p_cle_id in NUMBER) IS

Line 12714: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

12710: WHERE cle_id = p_cle_id
12711: And dnz_chr_id = p_chr_id;
12712:
12713: l_cim_id OKC_K_ITEMS.ID%TYPE;
12714: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12715: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12716:
12717:
12718: --Cursor to get hdr date

Line 12715: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

12711: And dnz_chr_id = p_chr_id;
12712:
12713: l_cim_id OKC_K_ITEMS.ID%TYPE;
12714: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12715: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12716:
12717:
12718: --Cursor to get hdr date
12719: CURSOR l_hdr_csr (p_chr_id IN NUMBER) is

Line 13137: OKL_OKC_MIGRATION_PVT.update_contract_item

13133: l_upd_cimv_rec.id := l_cim_id;
13134: l_upd_cimv_rec.object1_id1 := l_orig_cim_rec.object1_id1;
13135: l_upd_cimv_rec.object1_id2 := l_orig_cim_rec.object1_id2;
13136:
13137: OKL_OKC_MIGRATION_PVT.update_contract_item
13138: (p_api_version => p_api_version,
13139: p_init_msg_list => p_init_msg_list,
13140: x_return_status => x_return_status,
13141: x_msg_count => x_msg_count,

Line 13213: OKL_OKC_MIGRATION_PVT.delete_k_party_role

13209: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
13210: -- to delete records in tables
13211: -- okc_k_party_roles_b and okl_k_party_roles
13212: /*
13213: OKL_OKC_MIGRATION_PVT.delete_k_party_role
13214: ( p_api_version => p_api_version,
13215: p_init_msg_list => p_init_msg_list,
13216: x_return_status => x_return_status,
13217: x_msg_count => x_msg_count,

Line 13345: okl_okc_migration_pvt.update_contract_item

13341: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
13342: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
13343: END IF;
13344:
13345: okl_okc_migration_pvt.update_contract_item
13346: (p_api_version => p_api_version,
13347: p_init_msg_list => p_init_msg_list,
13348: x_return_status => x_return_status,
13349: x_msg_count => x_msg_count,

Line 13690: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

13686: AND cleb.lse_id = lseb.id
13687: AND lseb.lty_code in ('LINK_SERV_ASSET','LINK_FEE_ASSET','LINK_USAGE_ASSET');
13688:
13689: l_cim_id OKC_K_ITEMS.ID%TYPE;
13690: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13691: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13692:
13693: --cursor to get information about SLH/SLL to sync back
13694: CURSOR l_slh_csr(p_cle_id in number,

Line 13691: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

13687: AND lseb.lty_code in ('LINK_SERV_ASSET','LINK_FEE_ASSET','LINK_USAGE_ASSET');
13688:
13689: l_cim_id OKC_K_ITEMS.ID%TYPE;
13690: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13691: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13692:
13693: --cursor to get information about SLH/SLL to sync back
13694: CURSOR l_slh_csr(p_cle_id in number,
13695: p_orig_cle_id in number,

Line 13868: OKL_OKC_MIGRATION_PVT.update_contract_item

13864: Fetch l_lnk_ast_csr into l_cim_id;
13865: Exit when l_lnk_ast_csr%NOTFOUND;
13866: l_cimv_rec.id := l_cim_id;
13867: l_cimv_rec.object1_id1 := to_char(p_cle_id);
13868: OKL_OKC_MIGRATION_PVT.update_contract_item
13869: (p_api_version => p_api_version,
13870: p_init_msg_list => p_init_msg_list,
13871: x_return_status => x_return_status,
13872: x_msg_count => x_msg_count,

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

14906:
14907: l_cimv_model_rec.object1_id1 := p_cimv_model_rec.object1_id1;
14908: l_cimv_model_rec.object1_id2 := p_cimv_model_rec.object1_id2;
14909:
14910: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
14911: p_init_msg_list => p_init_msg_list,
14912: x_return_status => x_return_status,
14913: x_msg_count => x_msg_count,
14914: x_msg_data => x_msg_data,

Line 16543: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;

16539:
16540: l_corp_net_book_value number;
16541: l_expected_cost number;
16542:
16543: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16544: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16545: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16546: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16547: --End Bug# 4631549

Line 16544: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;

16540: l_corp_net_book_value number;
16541: l_expected_cost number;
16542:
16543: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16544: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16545: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16546: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16547: --End Bug# 4631549
16548:

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

17182: --Build addon cimv item rec
17183: r_cimv_addon_rec.number_of_items := l_cimv_model_rec_out.number_of_items;
17184: -- Updating of the addon Item Record
17185:
17186: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
17187: p_init_msg_list => p_init_msg_list,
17188: x_return_status => x_return_status,
17189: x_msg_count => x_msg_count,
17190: x_msg_data => x_msg_data,