APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_ITM_INSTS

Line 7440: FROM OKL_TXL_ITM_INSTS

7436: --cursor to get ib transaction line record
7437: CURSOR l_get_iti_csr (p_kle_id IN NUMBER) is
7438: SELECT tas_id,
7439: id
7440: FROM OKL_TXL_ITM_INSTS
7441: WHERE kle_id = p_kle_id;
7442:
7443: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7444: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

Line 7443: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;

7439: id
7440: FROM OKL_TXL_ITM_INSTS
7441: WHERE kle_id = p_kle_id;
7442:
7443: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7444: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
7445:
7446: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
7447: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 7444: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

7440: FROM OKL_TXL_ITM_INSTS
7441: WHERE kle_id = p_kle_id;
7442:
7443: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7444: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
7445:
7446: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
7447: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
7448: --Bug # 2522268

Line 7446: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

7442:
7443: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7444: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
7445:
7446: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
7447: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
7448: --Bug # 2522268
7449:
7450: --Bug# 3143522 : delete supplier invoice details is line is deleted

Line 7892: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(

7888: If l_get_iti_csr%NOTFOUND Then
7889: Null;
7890: Else
7891: l_iipv_rec.id := l_iti_id;
7892: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(
7893: p_api_version => p_api_version,
7894: p_init_msg_list => p_init_msg_list,
7895: x_return_status => x_return_status,
7896: x_msg_count => x_msg_count,

Line 8289: FROM OKL_TXL_ITM_INSTS

8285: --cursor to get ib transaction line record
8286: CURSOR l_get_iti_csr (p_kle_id IN NUMBER) is
8287: SELECT tas_id,
8288: id
8289: FROM OKL_TXL_ITM_INSTS
8290: WHERE kle_id = p_kle_id;
8291:
8292: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8293: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

Line 8292: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;

8288: id
8289: FROM OKL_TXL_ITM_INSTS
8290: WHERE kle_id = p_kle_id;
8291:
8292: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8293: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
8294:
8295: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
8296: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 8293: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

8289: FROM OKL_TXL_ITM_INSTS
8290: WHERE kle_id = p_kle_id;
8291:
8292: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8293: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
8294:
8295: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
8296: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
8297: --Bug # 2522268

Line 8295: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

8291:
8292: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8293: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
8294:
8295: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
8296: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
8297: --Bug # 2522268
8298:
8299:

Line 8857: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(

8853: Null;
8854: Else
8855:
8856: l_iipv_rec.id := l_iti_id;
8857: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(
8858: p_api_version => p_api_version,
8859: p_init_msg_list => p_init_msg_list,
8860: x_return_status => x_return_status,
8861: x_msg_count => x_msg_count,