APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TXL_ITM_INSTS_PUB

Line 4958: okl_txl_itm_insts_pub.create_txl_itm_insts

4954: RAISE OKL_API.G_EXCEPTION_ERROR;
4955: END IF;
4956: l_itiv_rec.instance_number_ib := l_instance_number;
4957: --create record
4958: okl_txl_itm_insts_pub.create_txl_itm_insts
4959: (p_api_version => p_api_version,
4960: p_init_msg_list => p_init_msg_list,
4961: x_return_status => x_return_status,
4962: x_msg_count => x_msg_count,

Line 5355: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5351: --Bug# 5946411: ER -- End
5352:
5353: srl_num_rec2 srl_num_csr2%ROWTYPE;
5354:
5355: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5356: i NUMBER DEFAULT 0;
5357: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5358:
5359: --Cursor to get install site use id

Line 5357: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5353: srl_num_rec2 srl_num_csr2%ROWTYPE;
5354:
5355: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5356: i NUMBER DEFAULT 0;
5357: lx_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5358:
5359: --Cursor to get install site use id
5360: CURSOR inst_site_csr (pty_site_id IN NUMBER) IS
5361: SELECT TO_CHAR(Party_site_use_id) party_site_use_id

Line 5666: okl_txl_itm_insts_pub.create_txl_itm_insts(

5662: CLOSE srl_num_csr;
5663: END IF; --srl_tbl count is = 0
5664: IF l_iipv_tbl.COUNT > 0 THEN
5665: --call api to create records for srl num trx
5666: okl_txl_itm_insts_pub.create_txl_itm_insts(
5667: p_api_version => p_api_version,
5668: p_init_msg_list => p_init_msg_list,
5669: x_return_status => x_return_status,
5670: x_msg_count => x_msg_count,

Line 5870: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;

5866: FROM okl_txl_itm_insts
5867: WHERE tal_id = p_tal_id
5868: AND tal_type = 'ALI';
5869:
5870: l_iipv_tbl okl_txl_itm_insts_pub.iipv_tbl_type;
5871: l_iipv_count NUMBER;
5872: l_iipv_id NUMBER;
5873:
5874: l_ib_tbl ib_tbl_type;

Line 6630: okl_txl_itm_insts_pub.delete_txl_itm_insts(

6626: CLOSE get_srl_csr;
6627:
6628: IF l_iipv_tbl.COUNT > 0 THEN
6629: --delete the old records
6630: okl_txl_itm_insts_pub.delete_txl_itm_insts(
6631: p_api_version => p_api_version,
6632: p_init_msg_list => p_init_msg_list,
6633: x_return_status => x_return_status,
6634: x_msg_count => x_msg_count,

Line 13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13426: AND NVL(selected_for_split_flag,'N') = 'Y';
13427:
13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13429:
13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13432:
13433:
13434: BEGIN

Line 13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

13427:
13428: l_itiv_id OKL_TXL_ITM_INSTS.ID%TYPE;
13429:
13430: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13431: lx_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
13432:
13433:
13434: BEGIN
13435: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 13639: okl_txl_itm_insts_pub.update_txl_itm_insts

13635: l_iipv_rec.selected_for_split_flag := 'P';
13636: --dbms_output.put_line('before update of txl itm insts sts'||x_return_status);
13637: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.id));
13638: --dbms_output.put_line('before update of txl itm insts sts'||to_char(l_iipv_rec.kle_id));
13639: okl_txl_itm_insts_pub.update_txl_itm_insts
13640: (p_api_version => p_api_version,
13641: p_init_msg_list => p_init_msg_list,
13642: x_return_status => x_return_status,
13643: x_msg_count => x_msg_count,