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_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKC_STATUSES_V

Line 12476: FROM okc_statuses_v stv

12472: p_sts_code VARCHAR2
12473: )
12474: IS
12475: SELECT stv.ste_code ste_code
12476: FROM okc_statuses_v stv
12477: WHERE stv.code = p_sts_code;
12478:
12479: -- Cursor to get the meaning of the sts_code passed
12480: CURSOR get_sts_meaning_csr (

Line 12485: FROM okc_statuses_v stv

12481: p_sts_code IN VARCHAR2
12482: )
12483: IS
12484: SELECT stv.meaning meaning
12485: FROM okc_statuses_v stv
12486: WHERE stv.code = p_sts_code;
12487:
12488: -- RMUNJULU 18-FEB-03 2805703 cursor to get active
12489: -- service or fee lines attached to contract directly

Line 12506: l_ste_code okc_statuses_v.code%TYPE;

12502: l_api_name CONSTANT VARCHAR2 (30) := 'update_contract';
12503: l_api_version CONSTANT NUMBER := 1;
12504: l_id NUMBER := -9999;
12505: get_k_dtls_rec get_k_dtls_csr%ROWTYPE;
12506: l_ste_code okc_statuses_v.code%TYPE;
12507: lp_chrv_rec okc_contract_pub.chrv_rec_type;
12508: lx_chrv_rec okc_contract_pub.chrv_rec_type;
12509: l_sts_meaning VARCHAR2 (300);
12510: l_msg_tbl g_msg_tbl := px_msg_tbl;