APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TXL_ITM_INSTS_PUB

Line 4930: okl_txl_itm_insts_pub.create_txl_itm_insts

4926: RAISE OKL_API.G_EXCEPTION_ERROR;
4927: END IF;
4928: l_itiv_rec.instance_number_ib := l_instance_number;
4929: --create record
4930: okl_txl_itm_insts_pub.create_txl_itm_insts
4931: (p_api_version => p_api_version,
4932: p_init_msg_list => p_init_msg_list,
4933: x_return_status => x_return_status,
4934: x_msg_count => x_msg_count,

Line 5327: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5323: --Bug# 5946411: ER -- End
5324:
5325: srl_num_rec2 srl_num_csr2%ROWTYPE;
5326:
5327: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5328: i NUMBER DEFAULT 0;
5329: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5330:
5331: --Cursor to get install site use id

Line 5329: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5325: srl_num_rec2 srl_num_csr2%ROWTYPE;
5326:
5327: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5328: i NUMBER DEFAULT 0;
5329: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5330:
5331: --Cursor to get install site use id
5332: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
5333: SELECT TO_CHAR(Party_site_use_id) party_site_use_id

Line 5638: okl_txl_itm_insts_pub.create_txl_itm_insts(

5634: CLOSE srl_num_csr;
5635: END IF; --srl_tbl count is = 0
5636: IF l_iipv_tbl.COUNT > 0 THEN
5637: --call api to create records for srl num trx
5638: okl_txl_itm_insts_pub.create_txl_itm_insts(
5639: p_api_version => p_api_version,
5640: p_init_msg_list => p_init_msg_list,
5641: x_return_status => x_return_status,
5642: x_msg_count => x_msg_count,

Line 5842: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5838: FROM okl_txl_itm_insts
5839: WHERE tal_id = p_tal_id
5840: AND tal_type = 'ALI';
5841:
5842: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5843: l_iipv_count NUMBER;
5844: l_iipv_id NUMBER;
5845:
5846: l_ib_tbl ib_tbl_type;

Line 6577: okl_txl_itm_insts_pub.delete_txl_itm_insts(

6573: CLOSE get_srl_csr;
6574:
6575: IF l_iipv_tbl.COUNT > 0 THEN
6576: --delete the old records
6577: okl_txl_itm_insts_pub.delete_txl_itm_insts(
6578: p_api_version => p_api_version,
6579: p_init_msg_list => p_init_msg_list,
6580: x_return_status => x_return_status,
6581: x_msg_count => x_msg_count,

Line 13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13373: AND NVL(selected_for_split_flag,'N') = 'Y';
13374:
13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13376:
13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13379:
13380:
13381: BEGIN

Line 13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13374:
13375: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13376:
13377: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13378: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13379:
13380:
13381: BEGIN
13382: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 13586: okl_txl_itm_insts_pub.update_txl_itm_insts

13582: l_iipv_rec.selected_for_split_flag := 'P';
13583: --dbms_output.put_line('before update of txl itm insts sts'||x_return_status);
13584: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.id));
13585: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.kle_id));
13586: okl_txl_itm_insts_pub.update_txl_itm_insts
13587: (p_api_version => p_api_version,
13588: p_init_msg_list => p_init_msg_list,
13589: x_return_status => x_return_status,
13590: x_msg_count => x_msg_count,