APPS.OKE_KCOPY_PKG dependencies on OKC_K_ARTICLES_B

Line 938: FROM OKC_K_ARTICLES_B

934:
935: -- DECLARE ARTICLE cursor refer to contract headers
936: CURSOR hdr_art_csr IS
937: SELECT ID
938: FROM OKC_K_ARTICLES_B
939: WHERE OKC_K_ARTICLES_B.DNZ_CHR_ID = f_k_header_id
940: AND OKC_K_ARTICLES_B.CHR_ID is not null
941: AND OKC_K_ARTICLES_B.CLE_ID is null;
942:

Line 939: WHERE OKC_K_ARTICLES_B.DNZ_CHR_ID = f_k_header_id

935: -- DECLARE ARTICLE cursor refer to contract headers
936: CURSOR hdr_art_csr IS
937: SELECT ID
938: FROM OKC_K_ARTICLES_B
939: WHERE OKC_K_ARTICLES_B.DNZ_CHR_ID = f_k_header_id
940: AND OKC_K_ARTICLES_B.CHR_ID is not null
941: AND OKC_K_ARTICLES_B.CLE_ID is null;
942:
943: -- DECLARE ARTICLE cursor refer to contract lines

Line 940: AND OKC_K_ARTICLES_B.CHR_ID is not null

936: CURSOR hdr_art_csr IS
937: SELECT ID
938: FROM OKC_K_ARTICLES_B
939: WHERE OKC_K_ARTICLES_B.DNZ_CHR_ID = f_k_header_id
940: AND OKC_K_ARTICLES_B.CHR_ID is not null
941: AND OKC_K_ARTICLES_B.CLE_ID is null;
942:
943: -- DECLARE ARTICLE cursor refer to contract lines
944: CURSOR cle_art_csr IS

Line 941: AND OKC_K_ARTICLES_B.CLE_ID is null;

937: SELECT ID
938: FROM OKC_K_ARTICLES_B
939: WHERE OKC_K_ARTICLES_B.DNZ_CHR_ID = f_k_header_id
940: AND OKC_K_ARTICLES_B.CHR_ID is not null
941: AND OKC_K_ARTICLES_B.CLE_ID is null;
942:
943: -- DECLARE ARTICLE cursor refer to contract lines
944: CURSOR cle_art_csr IS
945: SELECT ID

Line 946: FROM OKC_K_ARTICLES_B

942:
943: -- DECLARE ARTICLE cursor refer to contract lines
944: CURSOR cle_art_csr IS
945: SELECT ID
946: FROM OKC_K_ARTICLES_B
947: WHERE OKC_K_ARTICLES_B.CLE_ID = f_k_line_id
948: AND OKC_K_ARTICLES_B.CHR_ID is null;
949:
950: CURSOR c_sav_sae_id(p_cat_id IN NUMBER) IS

Line 947: WHERE OKC_K_ARTICLES_B.CLE_ID = f_k_line_id

943: -- DECLARE ARTICLE cursor refer to contract lines
944: CURSOR cle_art_csr IS
945: SELECT ID
946: FROM OKC_K_ARTICLES_B
947: WHERE OKC_K_ARTICLES_B.CLE_ID = f_k_line_id
948: AND OKC_K_ARTICLES_B.CHR_ID is null;
949:
950: CURSOR c_sav_sae_id(p_cat_id IN NUMBER) IS
951: SELECT sav_sae_id

Line 948: AND OKC_K_ARTICLES_B.CHR_ID is null;

944: CURSOR cle_art_csr IS
945: SELECT ID
946: FROM OKC_K_ARTICLES_B
947: WHERE OKC_K_ARTICLES_B.CLE_ID = f_k_line_id
948: AND OKC_K_ARTICLES_B.CHR_ID is null;
949:
950: CURSOR c_sav_sae_id(p_cat_id IN NUMBER) IS
951: SELECT sav_sae_id
952: FROM okc_k_articles_b

Line 952: FROM okc_k_articles_b

948: AND OKC_K_ARTICLES_B.CHR_ID is null;
949:
950: CURSOR c_sav_sae_id(p_cat_id IN NUMBER) IS
951: SELECT sav_sae_id
952: FROM okc_k_articles_b
953: WHERE id = p_cat_id;
954:
955: CURSOR c_latest_version(p_sae_id IN NUMBER) IS
956: SELECT sav_release