APPS.OKL_VIB_PVT dependencies on OKC_K_LINES_V

Line 24: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

20: -- Version : 1.0
21: -- End of Commnets
22:
23: PROCEDURE validate_dnz_chr_id(x_return_status OUT NOCOPY VARCHAR2,
24: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
25:
26: ln_dummy number := 0;
27:
28: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

Line 28: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS

24: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
25:
26: ln_dummy number := 0;
27:
28: CURSOR c_dnz_chr_id_validate(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
29: SELECT 1
30: FROM DUAL
31: WHERE EXISTS (SELECT id
32: FROM okc_k_headers_b

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

99: -- Version : 1.0
100: -- End of Commnets
101:
102: PROCEDURE validate_ib_cle_id(x_return_status OUT NOCOPY VARCHAR2,
103: p_id IN OKC_K_LINES_V.ID%TYPE) IS
104:
105: ln_dummy number := 0;
106: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
107:

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

104:
105: ln_dummy number := 0;
106: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
107:
108: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
109: SELECT lse.lty_code
110: FROM okc_k_lines_b cle,
111: okc_line_styles_b lse
112: WHERE cle.id = p_cle_id

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

112: WHERE cle.id = p_cle_id
113: AND cle.lse_id = lse.id;
114:
115:
116: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,
117: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
118: p_code2 IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
119: SELECT 1
120: FROM DUAL