APPS.OKL_RULE_PUB dependencies on OKC_K_HEADERS_V

Line 173: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS

169: l_rulv_rec_okc_out okc_rulv_rec_type;
170: l_clob clob;
171:
172: -- Start 14-Sep-2005 Manu
173: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
174: SELECT scs_code
175: FROM OKC_K_HEADERS_V
176: WHERE id = p_chr_id;
177: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;

Line 175: FROM OKC_K_HEADERS_V

171:
172: -- Start 14-Sep-2005 Manu
173: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
174: SELECT scs_code
175: FROM OKC_K_HEADERS_V
176: WHERE id = p_chr_id;
177: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;
178: -- End 14-Sep-2005 Manu
179: BEGIN

Line 177: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;

173: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
174: SELECT scs_code
175: FROM OKC_K_HEADERS_V
176: WHERE id = p_chr_id;
177: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;
178: -- End 14-Sep-2005 Manu
179: BEGIN
180: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
181: p_init_msg_list,

Line 494: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS

490: l_rulv_rec_okc_out okc_rulv_rec_type;
491: l_clob clob;
492:
493: -- Start 14-Sep-2005 Manu
494: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
495: SELECT scs_code
496: FROM OKC_K_HEADERS_V
497: WHERE id = p_chr_id;
498: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;

Line 496: FROM OKC_K_HEADERS_V

492:
493: -- Start 14-Sep-2005 Manu
494: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
495: SELECT scs_code
496: FROM OKC_K_HEADERS_V
497: WHERE id = p_chr_id;
498: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;
499: -- End 14-Sep-2005 Manu
500: BEGIN

Line 498: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;

494: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
495: SELECT scs_code
496: FROM OKC_K_HEADERS_V
497: WHERE id = p_chr_id;
498: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;
499: -- End 14-Sep-2005 Manu
500: BEGIN
501: x_return_status := OKL_API.G_RET_STS_SUCCESS;
502: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 990: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS

986:
987: l_dnz_chr_id OKC_RULES_B.dnz_chr_id%TYPE;
988:
989: -- Start 14-Sep-2005 Manu
990: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
991: SELECT scs_code
992: FROM OKC_K_HEADERS_V
993: WHERE id = p_chr_id;
994: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;

Line 992: FROM OKC_K_HEADERS_V

988:
989: -- Start 14-Sep-2005 Manu
990: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
991: SELECT scs_code
992: FROM OKC_K_HEADERS_V
993: WHERE id = p_chr_id;
994: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;
995: -- End 14-Sep-2005 Manu
996:

Line 994: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;

990: CURSOR lc_category_csr (p_chr_id IN OKC_K_HEADERS_V.ID%TYPE) IS
991: SELECT scs_code
992: FROM OKC_K_HEADERS_V
993: WHERE id = p_chr_id;
994: l_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE;
995: -- End 14-Sep-2005 Manu
996:
997: BEGIN
998: l_return_status := OKC_API.START_ACTIVITY(l_api_name,