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 5372: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

5368: where msi.organization_id = p_inv_org_id
5369: and msi.inventory_item_id = p_inv_item_id;
5370:
5371: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5372: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5373: l_klev_rec okl_contract_pub.klev_rec_type;
5374: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5375: lx_klev_rec okl_contract_pub.klev_rec_type;
5376:

Line 5374: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

5370:
5371: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5372: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5373: l_klev_rec okl_contract_pub.klev_rec_type;
5374: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5375: lx_klev_rec okl_contract_pub.klev_rec_type;
5376:
5377:
5378: BEGIN

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

5614: l_cimv_rec.dnz_chr_id := x_clev_rec.dnz_chr_id;
5615: l_cimv_rec.jtot_object1_code := 'OKX_SYSITEM';
5616: l_cimv_rec.exception_yn := 'N';
5617: -- Creation of Item Record for the above record information
5618: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
5619: p_init_msg_list => p_init_msg_list,
5620: x_return_status => x_return_status,
5621: x_msg_count => x_msg_count,
5622: x_msg_data => x_msg_data,

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

5779: p_msg_name => G_ITEM_RECORD);
5780: RAISE OKL_API.G_EXCEPTION_ERROR;
5781: END IF;
5782: -- Creation of Item Record for the above record information
5783: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
5784: p_init_msg_list => p_init_msg_list,
5785: x_return_status => x_return_status,
5786: x_msg_count => x_msg_count,
5787: x_msg_data => x_msg_data,

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

6040: FETCH c_asset_exist_chr into ln_dummy;
6041: CLOSE c_asset_exist_chr;
6042: IF ln_dummy <> 1 THEN
6043: -- Creation of Item Record for the above record information
6044: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
6045: p_init_msg_list => p_init_msg_list,
6046: x_return_status => x_return_status,
6047: x_msg_count => x_msg_count,
6048: x_msg_data => x_msg_data,

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

6101: END IF;
6102: ELSE
6103: -- Since id1,id12 are null , hence NO Asset Number we are creating a new asset Number
6104: -- Creation of Item Record for the above record information
6105: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
6106: p_init_msg_list => p_init_msg_list,
6107: x_return_status => x_return_status,
6108: x_msg_count => x_msg_count,
6109: x_msg_data => x_msg_data,

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

6278: p_msg_name => G_ITEM_RECORD);
6279: RAISE OKL_API.G_EXCEPTION_ERROR;
6280: END IF;
6281: -- Creation of Item Record for the above record information
6282: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
6283: p_init_msg_list => p_init_msg_list,
6284: x_return_status => x_return_status,
6285: x_msg_count => x_msg_count,
6286: x_msg_data => x_msg_data,

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

6523: p_msg_name => G_ITEM_RECORD);
6524: RAISE OKL_API.G_EXCEPTION_ERROR;
6525: END IF;
6526: -- Creation of Item Record for the above record information
6527: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
6528: p_init_msg_list => p_init_msg_list,
6529: x_return_status => x_return_status,
6530: x_msg_count => x_msg_count,
6531: x_msg_data => x_msg_data,

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

6731: p_msg_name => G_ITEM_RECORD);
6732: RAISE OKL_API.G_EXCEPTION_ERROR;
6733: END IF;
6734: -- Creation of Item Record for the above record information
6735: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
6736: p_init_msg_list => p_init_msg_list,
6737: x_return_status => x_return_status,
6738: x_msg_count => x_msg_count,
6739: x_msg_data => x_msg_data,

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

7789: (l_cimv_rec.object1_id2 IS NULL OR
7790: l_cimv_rec.object1_id2 = OKL_API.G_MISS_CHAR) THEN
7791: -- We have create the item rec,tal rec,trx rec and also create the iti rec
7792: -- Creation of Item Record for the above record information
7793: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
7794: p_init_msg_list => p_init_msg_list,
7795: x_return_status => x_return_status,
7796: x_msg_count => x_msg_count,
7797: x_msg_data => x_msg_data,

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

7869: l_cimv_rec.object1_id1 <> OKL_API.G_MISS_CHAR) AND
7870: (l_cimv_rec.object1_id2 IS NOT NULL OR
7871: l_cimv_rec.object1_id2 <> OKL_API.G_MISS_CHAR)THEN
7872: -- Creation of Item Record for the above record information
7873: OKL_OKC_MIGRATION_PVT.create_contract_item(p_api_version => p_api_version,
7874: p_init_msg_list => p_init_msg_list,
7875: x_return_status => x_return_status,
7876: x_msg_count => x_msg_count,
7877: x_msg_data => x_msg_data,

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

8073: (l_cimv_rec.object1_id2 IS NULL OR
8074: l_cimv_rec.object1_id2 = OKL_API.G_MISS_CHAR) THEN
8075: -- We have create the item rec,tal rec,trx rec and also create the iti rec
8076: -- Creation of Item Record for the above record information
8077: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
8078: p_init_msg_list => p_init_msg_list,
8079: x_return_status => x_return_status,
8080: x_msg_count => x_msg_count,
8081: x_msg_data => x_msg_data,

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

8134: l_cimv_rec.object1_id1 <> OKL_API.G_MISS_CHAR) AND
8135: (l_cimv_rec.object1_id2 IS NOT NULL OR
8136: l_cimv_rec.object1_id2 <> OKL_API.G_MISS_CHAR) THEN
8137: -- Creation of Item Record for the above record information
8138: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
8139: p_init_msg_list => p_init_msg_list,
8140: x_return_status => x_return_status,
8141: x_msg_count => x_msg_count,
8142: x_msg_data => x_msg_data,

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

11780: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
11781: -- to create records in tables
11782: -- okc_k_party_roles_b and okl_k_party_roles
11783: /*
11784: OKL_OKC_MIGRATION_PVT.create_k_party_role(p_api_version => p_api_version,
11785: p_init_msg_list => p_init_msg_list,
11786: x_return_status => x_return_status,
11787: x_msg_count => x_msg_count,
11788: x_msg_data => x_msg_data,

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

11971: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
11972: -- to update records in tables
11973: -- okc_k_party_roles_b and okl_k_party_roles
11974: /*
11975: OKL_OKC_MIGRATION_PVT.update_k_party_role(p_api_version => p_api_version,
11976: p_init_msg_list => p_init_msg_list,
11977: x_return_status => x_return_status,
11978: x_msg_count => x_msg_count,
11979: x_msg_data => x_msg_data,

Line 12494: l_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;

12490: AND rgpb.dnz_chr_id = p_chr_id;
12491:
12492:
12493: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
12494: l_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
12495:
12496:
12497: --cursor to get cost and salvage value for corporate book
12498: CURSOR l_corpbook_csr (p_cle_id in number,

Line 12599: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

12595: where cle_id = p_cle_id
12596: and dnz_chr_id = p_chr_id;
12597:
12598: l_cpl_id OKC_K_PARTY_ROLES_B.ID%TYPE;
12599: l_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;
12600:
12601:
12602: --cursor to get supplier invoice details
12603: CURSOR l_sid_csr (p_cle_id in NUMBER) IS

Line 12628: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

12624: WHERE cle_id = p_cle_id
12625: And dnz_chr_id = p_chr_id;
12626:
12627: l_cim_id OKC_K_ITEMS.ID%TYPE;
12628: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12629: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12630:
12631:
12632: --Cursor to get hdr date

Line 12629: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

12625: And dnz_chr_id = p_chr_id;
12626:
12627: l_cim_id OKC_K_ITEMS.ID%TYPE;
12628: l_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12629: lx_upd_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
12630:
12631:
12632: --Cursor to get hdr date
12633: CURSOR l_hdr_csr (p_chr_id IN NUMBER) is

Line 13038: OKL_OKC_MIGRATION_PVT.update_contract_item

13034: l_upd_cimv_rec.id := l_cim_id;
13035: l_upd_cimv_rec.object1_id1 := l_orig_cim_rec.object1_id1;
13036: l_upd_cimv_rec.object1_id2 := l_orig_cim_rec.object1_id2;
13037:
13038: OKL_OKC_MIGRATION_PVT.update_contract_item
13039: (p_api_version => p_api_version,
13040: p_init_msg_list => p_init_msg_list,
13041: x_return_status => x_return_status,
13042: x_msg_count => x_msg_count,

Line 13114: OKL_OKC_MIGRATION_PVT.delete_k_party_role

13110: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
13111: -- to delete records in tables
13112: -- okc_k_party_roles_b and okl_k_party_roles
13113: /*
13114: OKL_OKC_MIGRATION_PVT.delete_k_party_role
13115: ( p_api_version => p_api_version,
13116: p_init_msg_list => p_init_msg_list,
13117: x_return_status => x_return_status,
13118: x_msg_count => x_msg_count,

Line 13246: okl_okc_migration_pvt.update_contract_item

13242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
13243: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
13244: END IF;
13245:
13246: okl_okc_migration_pvt.update_contract_item
13247: (p_api_version => p_api_version,
13248: p_init_msg_list => p_init_msg_list,
13249: x_return_status => x_return_status,
13250: x_msg_count => x_msg_count,

Line 13591: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

13587: AND cleb.lse_id = lseb.id
13588: AND lseb.lty_code in ('LINK_SERV_ASSET','LINK_FEE_ASSET','LINK_USAGE_ASSET');
13589:
13590: l_cim_id OKC_K_ITEMS.ID%TYPE;
13591: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13592: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13593:
13594: --cursor to get information about SLH/SLL to sync back
13595: CURSOR l_slh_csr(p_cle_id in number,

Line 13592: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;

13588: AND lseb.lty_code in ('LINK_SERV_ASSET','LINK_FEE_ASSET','LINK_USAGE_ASSET');
13589:
13590: l_cim_id OKC_K_ITEMS.ID%TYPE;
13591: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13592: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
13593:
13594: --cursor to get information about SLH/SLL to sync back
13595: CURSOR l_slh_csr(p_cle_id in number,
13596: p_orig_cle_id in number,

Line 13769: OKL_OKC_MIGRATION_PVT.update_contract_item

13765: Fetch l_lnk_ast_csr into l_cim_id;
13766: Exit when l_lnk_ast_csr%NOTFOUND;
13767: l_cimv_rec.id := l_cim_id;
13768: l_cimv_rec.object1_id1 := to_char(p_cle_id);
13769: OKL_OKC_MIGRATION_PVT.update_contract_item
13770: (p_api_version => p_api_version,
13771: p_init_msg_list => p_init_msg_list,
13772: x_return_status => x_return_status,
13773: x_msg_count => x_msg_count,

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

14798:
14799: l_cimv_model_rec.object1_id1 := p_cimv_model_rec.object1_id1;
14800: l_cimv_model_rec.object1_id2 := p_cimv_model_rec.object1_id2;
14801:
14802: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
14803: p_init_msg_list => p_init_msg_list,
14804: x_return_status => x_return_status,
14805: x_msg_count => x_msg_count,
14806: x_msg_data => x_msg_data,

Line 16381: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;

16377:
16378: l_corp_net_book_value number;
16379: l_expected_cost number;
16380:
16381: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16382: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16383: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16384: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16385: --End Bug# 4631549

Line 16382: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;

16378: l_corp_net_book_value number;
16379: l_expected_cost number;
16380:
16381: l_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16382: lx_clev_fin_rec2 okl_okc_migration_pvt.clev_rec_type;
16383: l_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16384: lx_klev_fin_rec2 okl_contract_pub.klev_rec_type;
16385: --End Bug# 4631549
16386: BEGIN

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

16987: --Build addon cimv item rec
16988: r_cimv_addon_rec.number_of_items := l_cimv_model_rec_out.number_of_items;
16989: -- Updating of the addon Item Record
16990:
16991: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
16992: p_init_msg_list => p_init_msg_list,
16993: x_return_status => x_return_status,
16994: x_msg_count => x_msg_count,
16995: x_msg_data => x_msg_data,