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_EXT_BILLING_CHARGES_PVT dependencies on OKL_STRM_TYPE_V

Line 142: FROM okl_strm_type_v

138: AND sty_id = p_sty_id;
139:
140: CURSOR c_sty_id ( p_stream_name VARCHAR2 ) IS
141: SELECT id
142: FROM okl_strm_type_v
143: WHERE name = p_stream_name;
144:
145: CURSOR get_khr_id_csr ( p_contract_number VARCHAR2 ) IS
146: SELECT id

Line 163: FROM okl_strm_type_v

159: AND LANGUAGE = cp_language;
160:
161: CURSOR get_sty_id_csr ( p_sty_name VARCHAR2, p_purpose_code VARCHAR2 ) IS
162: SELECT id, billable_yn
163: FROM okl_strm_type_v
164: WHERE name = p_sty_name
165: AND stream_type_purpose = p_purpose_code;
166:
167: CURSOR get_sty_name_csr ( p_sty_id NUMBER ) IS

Line 169: FROM okl_strm_type_v

165: AND stream_type_purpose = p_purpose_code;
166:
167: CURSOR get_sty_name_csr ( p_sty_id NUMBER ) IS
168: SELECT name
169: FROM okl_strm_type_v
170: WHERE id = p_sty_id;
171:
172: CURSOR get_purpose_csr ( p_sty_name VARCHAR2 ) IS
173: SELECT stream_type_purpose

Line 174: FROM okl_strm_type_v

170: WHERE id = p_sty_id;
171:
172: CURSOR get_purpose_csr ( p_sty_name VARCHAR2 ) IS
173: SELECT stream_type_purpose
174: FROM okl_strm_type_v
175: WHERE name = p_sty_name;
176:
177: CURSOR get_kle_id_csr ( p_asset_number VARCHAR2 ) IS
178: SELECT ID

Line 212: l_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;

208: l_sty_id okl_strm_type_b.id%type;
209: l_currency_code fnd_currencies.currency_code%type;
210: l_khr_currency fnd_currencies.currency_code%type;
211: l_amount okl_trx_ar_invoices_v.amount%TYPE;
212: l_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
213: l_trx_type_name VARCHAR2(30);
214: l_trx_type_lang CONSTANT VARCHAR2(30) := 'US';
215: l_err_status VARCHAR2(1);
216: l_err_msg VARCHAR2(1995);

Line 248: , okl_strm_type_v sty

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
252: AND stm.say_code = 'CURR'

Line 262: okl_strm_type_v sty

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
266: AND stm.say_code = 'CURR'

Line 333: l_primary_sty_id OKL_STRM_TYPE_V.id%TYPE;

329:
330: p_man_inv_rec OKL_PAY_INVOICES_MAN_PVT.man_inv_rec_type;
331: x_man_inv_rec OKL_PAY_INVOICES_MAN_PVT.man_inv_rec_type;
332:
333: l_primary_sty_id OKL_STRM_TYPE_V.id%TYPE;
334: l_dependent_sty_id OKL_STRM_TYPE_V.id%TYPE;
335:
336: l_billable_yn OKL_STRM_TYPE_V.billable_yn%TYPE;
337:

Line 334: l_dependent_sty_id OKL_STRM_TYPE_V.id%TYPE;

330: p_man_inv_rec OKL_PAY_INVOICES_MAN_PVT.man_inv_rec_type;
331: x_man_inv_rec OKL_PAY_INVOICES_MAN_PVT.man_inv_rec_type;
332:
333: l_primary_sty_id OKL_STRM_TYPE_V.id%TYPE;
334: l_dependent_sty_id OKL_STRM_TYPE_V.id%TYPE;
335:
336: l_billable_yn OKL_STRM_TYPE_V.billable_yn%TYPE;
337:
338: l_sty_name OKL_STRM_TYPE_V.name%TYPE;

Line 336: l_billable_yn OKL_STRM_TYPE_V.billable_yn%TYPE;

332:
333: l_primary_sty_id OKL_STRM_TYPE_V.id%TYPE;
334: l_dependent_sty_id OKL_STRM_TYPE_V.id%TYPE;
335:
336: l_billable_yn OKL_STRM_TYPE_V.billable_yn%TYPE;
337:
338: l_sty_name OKL_STRM_TYPE_V.name%TYPE;
339: l_valid_strm_yn VARCHAR2(1);
340:

Line 338: l_sty_name OKL_STRM_TYPE_V.name%TYPE;

334: l_dependent_sty_id OKL_STRM_TYPE_V.id%TYPE;
335:
336: l_billable_yn OKL_STRM_TYPE_V.billable_yn%TYPE;
337:
338: l_sty_name OKL_STRM_TYPE_V.name%TYPE;
339: l_valid_strm_yn VARCHAR2(1);
340:
341: l_bill_try_id NUMBER;
342: l_cm_try_id NUMBER;

Line 486: l_sty_desc OKL_STRM_TYPE_V.name%TYPE;

482: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'PROCESSED';
483: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'ERROR';
484:
485: --added by kbbhavsa : Bug 5344799/5362220 : 27-June-06
486: l_sty_desc OKL_STRM_TYPE_V.name%TYPE;
487: l_temp_index NUMBER;
488: x_multiple_line_error EXCEPTION;
489: PRAGMA EXCEPTION_INIT (x_multiple_line_error, -24381 ); -- ORA-24381: error(s) in array DML
490:

Line 799: OKL_STRM_TYPE_V STY,

795: OKL_ST_GEN_TEMPLATES GTTV,
796: OKL_ST_GEN_TMPT_SETS GTSV,
797: OKL_AE_TMPT_SETS AES,
798: OKL_PRODUCTS PDT,
799: OKL_STRM_TYPE_V STY,
800: okl_k_headers khr,
801: okc_k_headers_b chr
802: WHERE
803: GTLV.GTT_ID = GTTV.ID AND

Line 829: OKL_STRM_TYPE_V STY,

825: OKL_ST_GEN_TEMPLATES GTTV,
826: OKL_ST_GEN_TMPT_SETS GTSV,
827: OKL_AE_TMPT_SETS AES,
828: OKL_PRODUCTS PDT,
829: OKL_STRM_TYPE_V STY,
830: okl_k_headers khr,
831: okc_k_headers_b chr
832: WHERE
833: GTLV.GTT_ID = GTTV.ID AND