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_SID_PVT dependencies on OKC_K_LINES_V

Line 32: p_id IN OKC_K_LINES_V.ID%TYPE) IS

28: -- Version : 1.0
29: -- End of Commnets
30:
31: PROCEDURE validate_cle_id(x_return_status OUT NOCOPY VARCHAR2,
32: p_id IN OKC_K_LINES_V.ID%TYPE) IS
33:
34: ln_dummy number := 0;
35: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
36:

Line 37: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

33:
34: ln_dummy number := 0;
35: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
36:
37: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
38: SELECT lse.lty_code
39: FROM okc_k_lines_b cle,
40: okc_line_styles_b lse
41: WHERE cle.id = p_cle_id

Line 44: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

40: okc_line_styles_b lse
41: WHERE cle.id = p_cle_id
42: AND cle.lse_id = lse.id;
43:
44: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
45: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
46: SELECT 1
47: FROM DUAL
48: WHERE EXISTS (SELECT t1.id

Line 61: CURSOR c_cle_id_validate2(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

57: AND t1.lse_parent_id = t2.id
58: AND t3.lse_id = t2.id
59: AND t3.scs_code = 'LEASE');
60:
61: CURSOR c_cle_id_validate2(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
62: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
63: p_code2 IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
64: SELECT 1
65: FROM DUAL

Line 192: p_id IN OKC_K_LINES_V.ID%TYPE) IS

188: -- Version : 1.0
189: -- End of Commnets
190:
191: PROCEDURE validate_fa_cle_id(x_return_status OUT NOCOPY VARCHAR2,
192: p_id IN OKC_K_LINES_V.ID%TYPE) IS
193:
194: ln_dummy number := 0;
195: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
196:

Line 197: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

193:
194: ln_dummy number := 0;
195: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
196:
197: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
198: SELECT lse.lty_code
199: FROM okc_k_lines_b cle,
200: okc_line_styles_b lse
201: WHERE cle.id = p_cle_id

Line 204: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

200: okc_line_styles_b lse
201: WHERE cle.id = p_cle_id
202: AND cle.lse_id = lse.id;
203:
204: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
205: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
206: SELECT 1
207: FROM DUAL
208: WHERE EXISTS (SELECT t1.id