APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKL_STREAMS

Line 136: FROM okl_streams

132: l_stm_id NUMBER;
133:
134: CURSOR c_stm_id ( p_khr_id NUMBER, p_sty_id NUMBER ) IS
135: SELECT id
136: FROM okl_streams
137: WHERE khr_id = p_khr_id
138: AND sty_id = p_sty_id;
139:
140: CURSOR c_sty_id ( p_stream_name VARCHAR2 ) IS

Line 247: FROM okl_streams stm

243: -- Get Count of specific stream type
244: ------------------------------------------------------------
245: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER ) IS
246: SELECT count(*)
247: FROM okl_streams stm
248: , okl_strm_type_v sty
249: WHERE stm.khr_id = p_khr_id
250: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
251: AND stm.sty_id = sty.id

Line 261: FROM okl_streams stm,

257: -- Get stm_id of Actual Property Tax record
258: ------------------------------------------------------------
259: CURSOR c_stm_id_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER ) IS
260: SELECT stm.id
261: FROM okl_streams stm,
262: okl_strm_type_v sty
263: WHERE stm.khr_id = p_khr_id
264: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
265: AND stm.sty_id = sty.id

Line 320: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

316:
317: -- -------------------------------------------------
318: -- Streams Record
319: -- -------------------------------------------------
320: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
321: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
322: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
323: -- -------------------------------------------------
324: -- Stream Elements Record

Line 321: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

317: -- -------------------------------------------------
318: -- Streams Record
319: -- -------------------------------------------------
320: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
321: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
322: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
323: -- -------------------------------------------------
324: -- Stream Elements Record
325: -- -------------------------------------------------

Line 322: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;

318: -- Streams Record
319: -- -------------------------------------------------
320: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
321: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
322: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
323: -- -------------------------------------------------
324: -- Stream Elements Record
325: -- -------------------------------------------------
326: p_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 373: TYPE stm_tbl_type IS TABLE OF OKL_STREAMS%ROWTYPE INDEX BY BINARY_INTEGER;

369: -- Base tables for insert
370: TYPE tai_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_B%ROWTYPE INDEX BY BINARY_INTEGER;
371: TYPE til_tbl_type IS TABLE OF OKL_TXL_AR_INV_LNS_B%ROWTYPE INDEX BY BINARY_INTEGER;
372: TYPE ptc_tbl_type IS TABLE OF OKL_PROPERTY_TAX_B%ROWTYPE INDEX BY BINARY_INTEGER;
373: TYPE stm_tbl_type IS TABLE OF OKL_STREAMS%ROWTYPE INDEX BY BINARY_INTEGER;
374: TYPE sel_tbl_type IS TABLE OF OKL_STRM_ELEMENTS%ROWTYPE INDEX BY BINARY_INTEGER;
375:
376: -- TL tables for insert
377: TYPE taitl_tbl_type IS TABLE OF OKL_TRX_AR_INVOICES_TL%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1490: insert into okl_streams

1486:
1487: -- insert stm records
1488: if stm_tbl.count > 0 then
1489: forall i in stm_tbl.first..stm_tbl.last
1490: insert into okl_streams
1491: values stm_tbl(i);
1492: commit;
1493: stm_tbl.delete;
1494: end if;