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 680: subtype clev_tbl_type is OKL_OKC_MIGRATION_PVT.clev_tbl_type;

676:
677:
678: rec_count NUMBER;
679: subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
680: subtype clev_tbl_type is OKL_OKC_MIGRATION_PVT.clev_tbl_type;
681:
682: l_clev_price_tbl clev_tbl_type;
683: lx_clev_price_tbl clev_tbl_type;
684: l_klev_price_tbl klev_tbl_type;

Line 2341: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

2337: l_parent_unit NUMBER;
2338: l_child_unit NUMBER;
2339: l_split_factor NUMBER;
2340: l_term_date DATE;
2341: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2342: l_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2343: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2344: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2345: l_chld_total_flr_price NUMBER:=0.0;

Line 2343: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

2339: l_split_factor NUMBER;
2340: l_term_date DATE;
2341: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2342: l_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2343: lx_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
2344: lx_klev_rec OKL_CONTRACT_PUB.klev_rec_type;
2345: l_chld_total_flr_price NUMBER:=0.0;
2346: begin
2347: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8575: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

8571: WHERE msi.organization_id = p_inv_org_id
8572: AND msi.inventory_item_id = p_inv_item_id;
8573:
8574: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;
8575: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8576: l_klev_rec okl_contract_pub.klev_rec_type;
8577: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
8578: lx_klev_rec okl_contract_pub.klev_rec_type;
8579:

Line 8577: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

8573:
8574: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;
8575: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8576: l_klev_rec okl_contract_pub.klev_rec_type;
8577: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
8578: lx_klev_rec okl_contract_pub.klev_rec_type;
8579:
8580:
8581: BEGIN

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

9189: END IF;
9190:
9191: --dbms_output.put_line('Number of items'|| to_char(lupd_cimv_rec.number_of_items));
9192: --update the item record
9193: OKL_OKC_MIGRATION_PVT.update_contract_item( p_api_version => p_api_version,
9194: p_init_msg_list => p_init_msg_list,
9195: x_return_status => x_return_status,
9196: x_msg_count => x_msg_count,
9197: x_msg_data => x_msg_data,

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

9776: l_lnk_cimv_rec.LAST_UPDATED_BY := OKL_API.G_MISS_NUM;
9777: l_lnk_cimv_rec.LAST_UPDATE_DATE := OKL_API.G_MISS_DATE;
9778: l_lnk_cimv_rec.LAST_UPDATE_LOGIN := OKL_API.G_MISS_NUM;
9779:
9780: OKL_OKC_MIGRATION_PVT.create_contract_item( p_api_version => p_api_version,
9781: p_init_msg_list => p_init_msg_list,
9782: x_return_status => x_return_status,
9783: x_msg_count => x_msg_count,
9784: x_msg_data => x_msg_data,

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

10156: END IF;
10157: END LOOP;
10158:
10159: --update original item record
10160: OKL_OKC_MIGRATION_PVT.update_contract_item( p_api_version => p_api_version,
10161: p_init_msg_list => p_init_msg_list,
10162: x_return_status => x_return_status,
10163: x_msg_count => x_msg_count,
10164: x_msg_data => x_msg_data,

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

10184: l_lnk_cimv_rec.LAST_UPDATED_BY := OKL_API.G_MISS_NUM;
10185: l_lnk_cimv_rec.LAST_UPDATE_DATE := OKL_API.G_MISS_DATE;
10186: l_lnk_cimv_rec.LAST_UPDATE_LOGIN := OKL_API.G_MISS_NUM;
10187:
10188: OKL_OKC_MIGRATION_PVT.create_contract_item( p_api_version => p_api_version,
10189: p_init_msg_list => p_init_msg_list,
10190: x_return_status => x_return_status,
10191: x_msg_count => x_msg_count,
10192: x_msg_data => x_msg_data,

Line 10552: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

10548: CONNECT BY PRIOR id = cle_id
10549: START WITH id = p_cle_id;
10550:
10551: c_lines_rec c_lines_cur%ROWTYPE;
10552: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
10553: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
10554:
10555: --Bug#3066375 :
10556: --Cursor to fetch linked asset lines for parent asset being abandoned

Line 10553: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

10549: START WITH id = p_cle_id;
10550:
10551: c_lines_rec c_lines_cur%ROWTYPE;
10552: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
10553: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
10554:
10555: --Bug#3066375 :
10556: --Cursor to fetch linked asset lines for parent asset being abandoned
10557: CURSOR l_lnk_asst_csr (p_cle_id IN NUMBER) IS

Line 10575: l_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;

10571: AND lnk_cim.object1_id2 = '#'
10572: AND lnk_cim.jtot_object1_code = 'OKX_COVASST';
10573:
10574: l_lnk_cle_id okc_k_lines_b.id%TYPE;
10575: l_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10576: lx_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10577:
10578: BEGIN
10579: -----

Line 10576: lx_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;

10572: AND lnk_cim.jtot_object1_code = 'OKX_COVASST';
10573:
10574: l_lnk_cle_id okc_k_lines_b.id%TYPE;
10575: l_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10576: lx_lnk_clev_rec okl_okc_migration_pvt.clev_rec_type;
10577:
10578: BEGIN
10579: -----
10580: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 10602: okl_okc_migration_pvt.update_contract_line(

10598: EXIT WHEN c_lines_cur%NOTFOUND;
10599: l_clev_rec.id := c_lines_rec.id;
10600: l_clev_rec.sts_code := 'ABANDONED';
10601:
10602: okl_okc_migration_pvt.update_contract_line(
10603: p_api_version => p_api_version,
10604: p_init_msg_list => p_init_msg_list,
10605: x_return_status => x_return_status,
10606: x_msg_count => x_msg_count,

Line 10619: okl_okc_migration_pvt.update_contract_line(

10615: EXIT WHEN l_lnk_asst_csr%NOTFOUND;
10616: l_lnk_clev_rec.id := l_lnk_cle_id;
10617: l_lnk_clev_rec.sts_code := 'ABANDONED';
10618:
10619: okl_okc_migration_pvt.update_contract_line(
10620: p_api_version => p_api_version,
10621: p_init_msg_list => p_init_msg_list,
10622: x_return_status => x_return_status,
10623: x_msg_count => x_msg_count,

Line 14080: l_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

14076:
14077: l_new_ib_cle_id OKC_K_LINES_B.ID%TYPE;
14078:
14079: --table of line records for updating statuses of the new lines
14080: l_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14081: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14082: j NUMBER DEFAULT 0;
14083:
14084: -- Bug# 5946411: ER

Line 14081: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

14077: l_new_ib_cle_id OKC_K_LINES_B.ID%TYPE;
14078:
14079: --table of line records for updating statuses of the new lines
14080: l_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14081: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
14082: j NUMBER DEFAULT 0;
14083:
14084: -- Bug# 5946411: ER
14085: --cursor to check the status of asset

Line 14246: OKL_OKC_MIGRATION_PVT.update_contract_line(

14242: --
14243: END LOOP;
14244: --change status of newly created lines to BOOKED
14245: IF l_clev_tbl.COUNT > 0 THEN
14246: OKL_OKC_MIGRATION_PVT.update_contract_line(
14247: p_api_version => p_api_version,
14248: p_init_msg_list => p_init_msg_list,
14249: x_return_status => x_return_status,
14250: x_msg_count => x_msg_count,

Line 14343: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

14339: AND cleb.cle_id = p_cle_id;
14340:
14341: l_instcle_id NUMBER DEFAULT NULL;
14342:
14343: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14344: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14345:
14346: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
14347:

Line 14344: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

14340:
14341: l_instcle_id NUMBER DEFAULT NULL;
14342:
14343: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14344: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14345:
14346: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
14347:
14348: BEGIN

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

14401: CLOSE l_instcle_csr;
14402: IF NVL(l_instcle_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM THEN
14403: l_clev_rec.id := l_instcle_id;
14404: l_clev_rec.cle_id := l_child_fina_cle_id;
14405: OKL_OKC_MIGRATION_PVT.update_contract_line(p_api_version => p_api_version,
14406: p_init_msg_list => p_init_msg_list,
14407: x_return_status => x_return_status,
14408: x_msg_count => x_msg_count,
14409: x_msg_data => x_msg_data,

Line 14484: l_clev_rec okl_okc_migration_pvt.clev_rec_type;

14480: l_cap_amount NUMBER;
14481: l_residual_value NUMBER;
14482:
14483:
14484: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14485: l_klev_rec okl_contract_pub.klev_rec_type;
14486: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14487: lx_klev_rec okl_contract_pub.klev_rec_type;
14488:

Line 14486: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

14482:
14483:
14484: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
14485: l_klev_rec okl_contract_pub.klev_rec_type;
14486: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
14487: lx_klev_rec okl_contract_pub.klev_rec_type;
14488:
14489: i NUMBER;
14490:

Line 14917: l_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;

14913: where kle.id = p_cle_id;
14914:
14915: l_exp_cost_rec l_exp_cost_csr%ROWTYPE;
14916:
14917: l_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14918: lx_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14919: l_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14920: lx_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14921:

Line 14918: lx_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;

14914:
14915: l_exp_cost_rec l_exp_cost_csr%ROWTYPE;
14916:
14917: l_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14918: lx_clev_exp_cost_rec okl_okc_migration_pvt.clev_rec_type;
14919: l_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14920: lx_klev_exp_cost_rec okl_contract_pub.klev_rec_type;
14921:
14922: --Bug# 6373605 start

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

15467: l_cimv_rec.jtot_object1_code := 'OKX_ASSET';
15468: l_cimv_rec.number_of_items := l_txdv_rec.quantity;
15469: --dbms_output.put_line('Asset Id :'||to_char(l_asset_hdr_rec.asset_id));
15470:
15471: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
15472: p_init_msg_list => p_init_msg_list,
15473: x_return_status => x_return_status,
15474: x_msg_count => x_msg_count,
15475: x_msg_data => x_msg_data,

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

15543: l_cimv_rec.object1_id1 := TO_CHAR(l_csi_instance_id);
15544: l_cimv_rec.object1_id2 := '#';
15545: l_cimv_rec.jtot_object1_code := 'OKX_IB_ITEM';
15546:
15547: OKL_OKC_MIGRATION_PVT.update_contract_item(p_api_version => p_api_version,
15548: p_init_msg_list => p_init_msg_list,
15549: x_return_status => x_return_status,
15550: x_msg_count => x_msg_count,
15551: x_msg_data => x_msg_data,

Line 16032: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;

16028: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
16029: ) IS
16030:
16031: l_proc_name VARCHAR2(35) := 'VERSION_CONTRACT';
16032: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16033: x_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16034:
16035: BEGIN
16036:

Line 16033: x_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;

16029: ) IS
16030:
16031: l_proc_name VARCHAR2(35) := 'VERSION_CONTRACT';
16032: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16033: x_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;
16034:
16035: BEGIN
16036:
16037: x_return_status := OKC_API.G_RET_STS_SUCCESS;