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 OKL_OKC_MIGRATION_PVT

Line 687: subtype clev_tbl_type is OKL_OKC_MIGRATION_PVT.clev_tbl_type;

683:
684:
685: rec_count NUMBER;
686: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
687: subtype clev_tbl_type is OKL_OKC_MIGRATION_PVT.clev_tbl_type;
688:
689: l_clev_price_tbl clev_tbl_type;
690: lx_clev_price_tbl clev_tbl_type;
691: l_klev_price_tbl klev_tbl_type;

Line 2369: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

2365: l_parent_unit NUMBER;
2366: l_child_unit NUMBER;
2367: l_split_factor NUMBER;
2368: l_term_date DATE;
2369: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2370: l_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2371: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2372: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2373: l_chld_total_flr_price NUMBER:=0.0;

Line 2371: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

2367: l_split_factor NUMBER;
2368: l_term_date DATE;
2369: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2370: l_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2371: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2372: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2373: l_chld_total_flr_price NUMBER:=0.0;
2374: begin
2375: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8628: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

8624: WHERE msi.organization_id = p_inv_org_id
8625: AND msi.inventory_item_id = p_inv_item_id;
8626:
8627: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;
8628: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8629: l_klev_rec okl_contract_pub.klev_rec_type;
8630: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
8631: lx_klev_rec okl_contract_pub.klev_rec_type;
8632:

Line 8630: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

8626:
8627: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;
8628: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8629: l_klev_rec okl_contract_pub.klev_rec_type;
8630: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
8631: lx_klev_rec okl_contract_pub.klev_rec_type;
8632:
8633:
8634: BEGIN

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

9242: END IF;
9243:
9244: --dbms_output.put_line('Number of items'|| to_char(lupd_cimv_rec.number_of_items));
9245: --update the item record
9246: OKL_OKC_MIGRATION_PVT.update_contract_item( p_api_version => p_api_version,
9247: p_init_msg_list => p_init_msg_list,
9248: x_return_status => x_return_status,
9249: x_msg_count => x_msg_count,
9250: x_msg_data => x_msg_data,

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

9829: l_lnk_cimv_rec.LAST_UPDATED_BY := OKL_API.G_MISS_NUM;
9830: l_lnk_cimv_rec.LAST_UPDATE_DATE := OKL_API.G_MISS_DATE;
9831: l_lnk_cimv_rec.LAST_UPDATE_LOGIN := OKL_API.G_MISS_NUM;
9832:
9833: OKL_OKC_MIGRATION_PVT.create_contract_item( p_api_version => p_api_version,
9834: p_init_msg_list => p_init_msg_list,
9835: x_return_status => x_return_status,
9836: x_msg_count => x_msg_count,
9837: x_msg_data => x_msg_data,

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

10209: END IF;
10210: END LOOP;
10211:
10212: --update original item record
10213: OKL_OKC_MIGRATION_PVT.update_contract_item( p_api_version => p_api_version,
10214: p_init_msg_list => p_init_msg_list,
10215: x_return_status => x_return_status,
10216: x_msg_count => x_msg_count,
10217: x_msg_data => x_msg_data,

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

10237: l_lnk_cimv_rec.LAST_UPDATED_BY := OKL_API.G_MISS_NUM;
10238: l_lnk_cimv_rec.LAST_UPDATE_DATE := OKL_API.G_MISS_DATE;
10239: l_lnk_cimv_rec.LAST_UPDATE_LOGIN := OKL_API.G_MISS_NUM;
10240:
10241: OKL_OKC_MIGRATION_PVT.create_contract_item( p_api_version => p_api_version,
10242: p_init_msg_list => p_init_msg_list,
10243: x_return_status => x_return_status,
10244: x_msg_count => x_msg_count,
10245: x_msg_data => x_msg_data,

Line 10605: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

10601: CONNECT BY PRIOR id = cle_id
10602: START WITH id = p_cle_id;
10603:
10604: c_lines_rec c_lines_cur%ROWTYPE;
10605: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
10606: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
10607:
10608: --Bug#3066375 :
10609: --Cursor to fetch linked asset lines for parent asset being abandoned

Line 10606: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

10602: START WITH id = p_cle_id;
10603:
10604: c_lines_rec c_lines_cur%ROWTYPE;
10605: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
10606: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
10607:
10608: --Bug#3066375 :
10609: --Cursor to fetch linked asset lines for parent asset being abandoned
10610: CURSOR l_lnk_asst_csr (p_cle_id IN NUMBER) IS

Line 10628: l_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;

10624: AND lnk_cim.object1_id2 = '#'
10625: AND lnk_cim.jtot_object1_code = 'OKX_COVASST';
10626:
10627: l_lnk_cle_id okc_k_lines_b.id%TYPE;
10628: l_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10629: lx_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10630:
10631: BEGIN
10632: -----

Line 10629: lx_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;

10625: AND lnk_cim.jtot_object1_code = 'OKX_COVASST';
10626:
10627: l_lnk_cle_id okc_k_lines_b.id%TYPE;
10628: l_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10629: lx_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10630:
10631: BEGIN
10632: -----
10633: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 10655: okl_okc_migration_pvt.update_contract_line(

10651: EXIT WHEN c_lines_cur%NOTFOUND;
10652: l_clev_rec.id := c_lines_rec.id;
10653: l_clev_rec.sts_code := 'ABANDONED';
10654:
10655: okl_okc_migration_pvt.update_contract_line(
10656: p_api_version => p_api_version,
10657: p_init_msg_list => p_init_msg_list,
10658: x_return_status => x_return_status,
10659: x_msg_count => x_msg_count,

Line 10672: okl_okc_migration_pvt.update_contract_line(

10668: EXIT WHEN l_lnk_asst_csr%NOTFOUND;
10669: l_lnk_clev_rec.id := l_lnk_cle_id;
10670: l_lnk_clev_rec.sts_code := 'ABANDONED';
10671:
10672: okl_okc_migration_pvt.update_contract_line(
10673: p_api_version => p_api_version,
10674: p_init_msg_list => p_init_msg_list,
10675: x_return_status => x_return_status,
10676: x_msg_count => x_msg_count,

Line 14133: l_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

14129:
14130: l_new_ib_cle_id OKC_K_LINES_B.ID%TYPE;
14131:
14132: --table of line records for updating statuses of the new lines
14133: l_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14134: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14135: j NUMBER DEFAULT 0;
14136:
14137: -- Bug# 5946411: ER

Line 14134: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

14130: l_new_ib_cle_id OKC_K_LINES_B.ID%TYPE;
14131:
14132: --table of line records for updating statuses of the new lines
14133: l_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14134: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14135: j NUMBER DEFAULT 0;
14136:
14137: -- Bug# 5946411: ER
14138: --cursor to check the status of asset

Line 14299: OKL_OKC_MIGRATION_PVT.update_contract_line(

14295: --
14296: END LOOP;
14297: --change status of newly created lines to BOOKED
14298: IF l_clev_tbl.COUNT > 0 THEN
14299: OKL_OKC_MIGRATION_PVT.update_contract_line(
14300: p_api_version => p_api_version,
14301: p_init_msg_list => p_init_msg_list,
14302: x_return_status => x_return_status,
14303: x_msg_count => x_msg_count,

Line 14396: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

14392: AND cleb.cle_id = p_cle_id;
14393:
14394: l_instcle_id NUMBER DEFAULT NULL;
14395:
14396: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14397: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14398:
14399: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
14400:

Line 14397: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

14393:
14394: l_instcle_id NUMBER DEFAULT NULL;
14395:
14396: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14397: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14398:
14399: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
14400:
14401: BEGIN

Line 14458: OKL_OKC_MIGRATION_PVT.update_contract_line(p_api_version => p_api_version,

14454: CLOSE l_instcle_csr;
14455: IF NVL(l_instcle_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM THEN
14456: l_clev_rec.id := l_instcle_id;
14457: l_clev_rec.cle_id := l_child_fina_cle_id;
14458: OKL_OKC_MIGRATION_PVT.update_contract_line(p_api_version => p_api_version,
14459: p_init_msg_list => p_init_msg_list,
14460: x_return_status => x_return_status,
14461: x_msg_count => x_msg_count,
14462: x_msg_data => x_msg_data,

Line 14537: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

14533: l_cap_amount NUMBER;
14534: l_residual_value NUMBER;
14535:
14536:
14537: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14538: l_klev_rec okl_contract_pub.klev_rec_type;
14539: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14540: lx_klev_rec okl_contract_pub.klev_rec_type;
14541:

Line 14539: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

14535:
14536:
14537: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14538: l_klev_rec okl_contract_pub.klev_rec_type;
14539: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14540: lx_klev_rec okl_contract_pub.klev_rec_type;
14541:
14542: i NUMBER;
14543:

Line 14982: l_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;

14978: where kle.id = p_cle_id;
14979:
14980: l_exp_cost_rec l_exp_cost_csr%ROWTYPE;
14981:
14982: l_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14983: lx_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14984: l_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14985: lx_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14986:

Line 14983: lx_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;

14979:
14980: l_exp_cost_rec l_exp_cost_csr%ROWTYPE;
14981:
14982: l_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14983: lx_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14984: l_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14985: lx_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14986:
14987: --Bug# 6373605 start

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

15559: l_cimv_rec.jtot_object1_code := 'OKX_ASSET';
15560: l_cimv_rec.number_of_items := l_txdv_rec.quantity;
15561: --dbms_output.put_line('Asset Id :'||to_char(l_asset_hdr_rec.asset_id));
15562:
15563: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
15564: p_init_msg_list => p_init_msg_list,
15565: x_return_status => x_return_status,
15566: x_msg_count => x_msg_count,
15567: x_msg_data => x_msg_data,

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

15635: l_cimv_rec.object1_id1 := TO_CHAR(l_csi_instance_id);
15636: l_cimv_rec.object1_id2 := '#';
15637: l_cimv_rec.jtot_object1_code := 'OKX_IB_ITEM';
15638:
15639: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
15640: p_init_msg_list => p_init_msg_list,
15641: x_return_status => x_return_status,
15642: x_msg_count => x_msg_count,
15643: x_msg_data => x_msg_data,

Line 16124: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;

16120: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
16121: ) IS
16122:
16123: l_proc_name VARCHAR2(35) := 'VERSION_CONTRACT';
16124: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16125: x_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16126:
16127: BEGIN
16128:

Line 16125: x_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;

16121: ) IS
16122:
16123: l_proc_name VARCHAR2(35) := 'VERSION_CONTRACT';
16124: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16125: x_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16126:
16127: BEGIN
16128:
16129: x_return_status := OKC_API.G_RET_STS_SUCCESS;