APPS.OKL_TRX_CONTRACTS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 639: FROM OKL_TXL_CNTRCT_LNS tcl

635: l_tclv_tbl tclv_tbl_type;
636:
637: CURSOR tcl_csr IS
638: SELECT tcl.id
639: FROM OKL_TXL_CNTRCT_LNS tcl
640: WHERE tcl.tcn_id = p_tcnv_rec.id;
641: BEGIN
642: FOR tcl_rec IN tcl_csr
643: LOOP

Line 836: l_stream_type_code OKL_TXL_CNTRCT_LNS.STREAM_TYPE_CODE%TYPE;

832: ,x_msg_data OUT NOCOPY VARCHAR2
833: ,p_tclv_rec IN tclv_rec_type
834: ,x_tclv_rec OUT NOCOPY tclv_rec_type) IS
835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
836: l_stream_type_code OKL_TXL_CNTRCT_LNS.STREAM_TYPE_CODE%TYPE;
837: l_stream_type_purpose OKL_TXL_CNTRCT_LNS.STREAM_TYPE_PURPOSE%TYPE;
838: CURSOR okl_strm_type_csr(sty_id IN OKL_TXL_CNTRCT_LNS.STY_ID%TYPE) IS
839: SELECT
840: code,

Line 837: l_stream_type_purpose OKL_TXL_CNTRCT_LNS.STREAM_TYPE_PURPOSE%TYPE;

833: ,p_tclv_rec IN tclv_rec_type
834: ,x_tclv_rec OUT NOCOPY tclv_rec_type) IS
835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
836: l_stream_type_code OKL_TXL_CNTRCT_LNS.STREAM_TYPE_CODE%TYPE;
837: l_stream_type_purpose OKL_TXL_CNTRCT_LNS.STREAM_TYPE_PURPOSE%TYPE;
838: CURSOR okl_strm_type_csr(sty_id IN OKL_TXL_CNTRCT_LNS.STY_ID%TYPE) IS
839: SELECT
840: code,
841: stream_type_purpose

Line 838: CURSOR okl_strm_type_csr(sty_id IN OKL_TXL_CNTRCT_LNS.STY_ID%TYPE) IS

834: ,x_tclv_rec OUT NOCOPY tclv_rec_type) IS
835: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
836: l_stream_type_code OKL_TXL_CNTRCT_LNS.STREAM_TYPE_CODE%TYPE;
837: l_stream_type_purpose OKL_TXL_CNTRCT_LNS.STREAM_TYPE_PURPOSE%TYPE;
838: CURSOR okl_strm_type_csr(sty_id IN OKL_TXL_CNTRCT_LNS.STY_ID%TYPE) IS
839: SELECT
840: code,
841: stream_type_purpose
842: FROM