APPS.OKL_SID_PVT dependencies on OKC_K_LINES_B

Line 39: FROM okc_k_lines_b cle,

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
42: AND cle.lse_id = lse.id;
43:

Line 52: ,okc_k_lines_b cle

48: WHERE EXISTS (SELECT t1.id
49: FROM okc_line_styles_b t1
50: ,okc_line_styles_b t2
51: ,okc_subclass_top_line t3
52: ,okc_k_lines_b cle
53: WHERE t1.lty_code = p_code
54: AND cle.id = p_cle_id
55: AND cle.lse_id = t1.id
56: AND t2.lty_code = G_FIN_LINE_LTY_CODE

Line 71: ,okc_k_lines_b cle

67: FROM okc_line_styles_b t1
68: ,okc_line_styles_b t2
69: ,okc_line_styles_b t3
70: ,okc_subclass_top_line t4
71: ,okc_k_lines_b cle
72: WHERE t1.lty_code = p_code
73: AND cle.id = p_cle_id
74: AND cle.lse_id = t1.id
75: AND t2.lty_code = p_code2

Line 199: FROM okc_k_lines_b cle,

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
202: AND cle.lse_id = lse.id;
203:

Line 212: ,okc_k_lines_b cle

208: WHERE EXISTS (SELECT t1.id
209: FROM okc_line_styles_b t1
210: ,okc_line_styles_b t2
211: ,okc_subclass_top_line t3
212: ,okc_k_lines_b cle
213: WHERE t1.lty_code = p_code
214: AND cle.id = p_cle_id
215: AND cle.lse_id = t1.id
216: AND t2.lty_code = G_FIN_LINE_LTY_CODE

Line 3031: FUNCTION create_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,

3027:
3028: ---------------------------------------------------------------------------
3029: -- PROCEDURE versioning
3030: ---------------------------------------------------------------------------
3031: FUNCTION create_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,
3032: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)
3033: RETURN VARCHAR2
3034: IS
3035: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

Line 3104: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);

3100: last_updated_by,
3101: last_update_date,
3102: last_update_login
3103: FROM OKL_SUPP_INVOICE_DTLS
3104: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
3105: RETURN l_return_status;
3106: EXCEPTION
3107: -- other appropriate handlers
3108: WHEN OTHERS THEN

Line 3123: FUNCTION restore_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,

3119: return l_return_status;
3120: END create_version;
3121: -----------------------------------------------------------------------------------------------------
3122:
3123: FUNCTION restore_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,
3124: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)
3125: RETURN VARCHAR2
3126: IS
3127: l_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;

Line 3193: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)

3189: last_updated_by,
3190: last_update_date,
3191: last_update_login
3192: FROM OKL_SUPP_INVOICE_DTLS_H
3193: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
3194: and major_version = p_major_version;
3195: RETURN l_return_status;
3196: EXCEPTION
3197: -- other appropriate handlers