eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROP_TAX_ADJ_PVT dependencies on OKL_STREAMS

Line 64: okl_streams stm,

60: ------------------------------------------------------------
61: CURSOR actual_property_tax_csr ( p_khr_id IN NUMBER, p_kle_id IN NUMBER ) IS
62: SELECT NVL(SUM(ste.amount),0) amount
63: FROM okl_strm_elements ste,
64: okl_streams stm,
65: okl_strm_type_v sty,
66: okc_k_headers_b khr,
67: okl_k_headers khl,
68: okc_k_lines_b kle,

Line 95: okl_streams stm,

91: SELECT SUM(AMOUNT)
92: FROM (
93: SELECT NVL(SUM(ste.amount),0) amount
94: FROM okl_strm_elements ste,
95: okl_streams stm,
96: okl_strm_type_v sty,
97: okc_k_headers_b khr,
98: okl_k_headers khl,
99: okc_k_lines_b kle,

Line 163: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

159:
160: -- -------------------------------------------------
161: -- Streams Record
162: -- -------------------------------------------------
163: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
164: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
165: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
166:
167: -- -------------------------------------------------

Line 164: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

160: -- -------------------------------------------------
161: -- Streams Record
162: -- -------------------------------------------------
163: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
164: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
165: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
166:
167: -- -------------------------------------------------
168: -- Stream Elements Record

Line 165: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;

161: -- Streams Record
162: -- -------------------------------------------------
163: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
164: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
165: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
166:
167: -- -------------------------------------------------
168: -- Stream Elements Record
169: -- -------------------------------------------------

Line 187: FROM okl_streams stm,

183: -- Get Count of specific stream type
184: ------------------------------------------------------------
185: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_name VARCHAR2 ) IS
186: SELECT count(*)
187: FROM okl_streams stm,
188: okl_strm_type_v sty
189: WHERE stm.khr_id = p_khr_id
190: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
191: AND stm.sty_id = sty.id

Line 216: FROM okl_streams stm,

212: -- Get stm_id of Adjusted Property Tax record
213: ------------------------------------------------------------
214: CURSOR c_stm_id_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_name VARCHAR2 ) IS
215: SELECT stm.id
216: FROM okl_streams stm,
217: okl_strm_type_v sty
218: WHERE stm.khr_id = p_khr_id
219: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
220: AND stm.sty_id = sty.id

Line 376: OKL_STREAMS_UTIL.get_dependent_stream_type

372: ----------------------------------------
373: -- Get sty_id for adjusted property tax
374: ----------------------------------------
375: l_sty_id := NULL;
376: OKL_STREAMS_UTIL.get_dependent_stream_type
377: ( term_contracts_rec.ID,
378: 'ACTUAL_PROPERTY_TAX',
379: 'ADJUSTED_PROPERTY_TAX',
380: x_return_status,

Line 500: Okl_Streams_Pub.create_streams(

496: l_stmv_rec.comments := 'Adjusted Property Tax';
497:
498: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Creating Adjusted Property Tax Streams');
499:
500: Okl_Streams_Pub.create_streams(
501: p_api_version => p_api_version,
502: p_init_msg_list => p_init_msg_list,
503: x_return_status => x_return_status,
504: x_msg_count => x_msg_count,