APPS.OKL_CONTRACT_PVT dependencies on OKL_STREAMS

Line 191: from OKL_STREAMS str

187: Select str.id strm_id,
188: str.kle_id,
189: str.sty_id,
190: str.sgn_code
191: from OKL_STREAMS str
192: where str.say_code = 'CURR'
193: and str.kle_id = cleId;
194:
195: l_strms_rec strms_csr%ROWTYPE;

Line 198: l_stmv_tbl okl_streams_pub.stmv_tbl_type;

194:
195: l_strms_rec strms_csr%ROWTYPE;
196: l_return_status VARCHAR2(1);
197: i NUMBER;
198: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
199: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
200: l_stream_update_err EXCEPTION;
201:
202: Begin

Line 199: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

195: l_strms_rec strms_csr%ROWTYPE;
196: l_return_status VARCHAR2(1);
197: i NUMBER;
198: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
199: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
200: l_stream_update_err EXCEPTION;
201:
202: Begin
203: -----

Line 218: Okl_Streams_pub.update_streams(

214: l_stmv_tbl(i).date_history := sysdate;
215: End Loop;
216: Close strms_csr;
217: If (l_stmv_tbl.COUNT > 0) then
218: Okl_Streams_pub.update_streams(
219: p_api_version => p_api_version,
220: p_init_msg_list => p_init_msg_list,
221: x_return_status => x_return_status,
222: x_msg_count => x_msg_count,

Line 294: FROM OKL_STREAMS str

290:
291: --Cursor to check whether streams exist
292: Cursor streams_exist_crs(p_cle_id IN NUMBER) is
293: SELECT 'Y'
294: FROM OKL_STREAMS str
295: WHERE str.kle_id = p_cle_id
296: And rownum < 2;
297:
298: l_streams_exists Varchar2(1) default 'N';

Line 4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

4251: l_chrv_rec chrv_rec_type;
4252: l_khrv_rec khrv_rec_type;
4253: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4254: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4258:
4259: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

Line 4285: FROM OKL_STREAMS

4281: AND rownum < 2;
4282:
4283: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4284: SELECT id stm_id
4285: FROM OKL_STREAMS
4286: WHERE khr_id = p_khr_id;
4287:
4288: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4289: SELECT id trx_id

Line 4761: OKL_STREAMS_PUB.delete_streams(

4757: END IF;
4758: -- Delete the streams for the contract
4759: FOR r_get_k_stream IN c_get_k_stream(p_khr_id => p_contract_id) LOOP
4760: l_stmv_rec.id := r_get_k_stream.stm_id;
4761: OKL_STREAMS_PUB.delete_streams(
4762: p_api_version => p_api_version,
4763: p_init_msg_list => p_init_msg_list,
4764: x_return_status => x_return_status,
4765: x_msg_count => x_msg_count,