APPS.OKL_VFA_PVT dependencies on OKC_K_LINES_V

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

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

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

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

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

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

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

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

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

112: okc_line_styles_b lse
113: WHERE cle.id = p_cle_id
114: AND cle.lse_id = lse.id;
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) IS
118: SELECT 1
119: FROM DUAL
120: WHERE EXISTS (SELECT t1.id