APPS.OKL_CONTRACT_PVT dependencies on OKL_TXL_ITM_INSTS

Line 7338: FROM OKL_TXL_ITM_INSTS

7334: --cursor to get ib transaction line record
7335: CURSOR l_get_iti_csr (p_kle_id IN NUMBER) is
7336: SELECT tas_id,
7337: id
7338: FROM OKL_TXL_ITM_INSTS
7339: WHERE kle_id = p_kle_id;
7340:
7341: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7342: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

Line 7341: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;

7337: id
7338: FROM OKL_TXL_ITM_INSTS
7339: WHERE kle_id = p_kle_id;
7340:
7341: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7342: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
7343:
7344: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
7345: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 7342: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

7338: FROM OKL_TXL_ITM_INSTS
7339: WHERE kle_id = p_kle_id;
7340:
7341: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7342: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
7343:
7344: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
7345: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
7346: --Bug # 2522268

Line 7344: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

7340:
7341: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
7342: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
7343:
7344: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
7345: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
7346: --Bug # 2522268
7347:
7348: --Bug# 3143522 : delete supplier invoice details is line is deleted

Line 7790: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(

7786: If l_get_iti_csr%NOTFOUND Then
7787: Null;
7788: Else
7789: l_iipv_rec.id := l_iti_id;
7790: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(
7791: p_api_version => p_api_version,
7792: p_init_msg_list => p_init_msg_list,
7793: x_return_status => x_return_status,
7794: x_msg_count => x_msg_count,

Line 8187: FROM OKL_TXL_ITM_INSTS

8183: --cursor to get ib transaction line record
8184: CURSOR l_get_iti_csr (p_kle_id IN NUMBER) is
8185: SELECT tas_id,
8186: id
8187: FROM OKL_TXL_ITM_INSTS
8188: WHERE kle_id = p_kle_id;
8189:
8190: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8191: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

Line 8190: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;

8186: id
8187: FROM OKL_TXL_ITM_INSTS
8188: WHERE kle_id = p_kle_id;
8189:
8190: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8191: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
8192:
8193: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
8194: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;

Line 8191: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;

8187: FROM OKL_TXL_ITM_INSTS
8188: WHERE kle_id = p_kle_id;
8189:
8190: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8191: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
8192:
8193: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
8194: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
8195: --Bug # 2522268

Line 8193: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;

8189:
8190: l_iti_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
8191: l_iti_id OKL_TXL_ITM_INSTS.ID%TYPE;
8192:
8193: l_iipv_rec OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
8194: l_iti_thpv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
8195: --Bug # 2522268
8196:
8197:

Line 8755: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(

8751: Null;
8752: Else
8753:
8754: l_iipv_rec.id := l_iti_id;
8755: OKL_TXL_ITM_INSTS_PUB.delete_txl_itm_insts(
8756: p_api_version => p_api_version,
8757: p_init_msg_list => p_init_msg_list,
8758: x_return_status => x_return_status,
8759: x_msg_count => x_msg_count,