APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ARTICLES_ALL

Line 50: FROM okc_articles_all lib,

46: RETURN CLOB IS
47: l_api_name CONSTANT VARCHAR2(30) := 'get_orig_var_val_xml';
48: CURSOR csr_orig_target_dtls IS
49: SELECT kart1.id
50: FROM okc_articles_all lib,
51: okc_k_articles_b kart,
52: okc_k_articles_b kart1
53: WHERE lib.article_id = kart.sav_sae_id
54: AND kart.id= p_cat_id

Line 103: FROM okc_articles_all lib,

99: CURSOR csr_target_dtls IS
100: SELECT NVL(standard_yn,'N') standard_flag,
101: kart.article_version_id,
102: kart.ORIG_SYSTEM_REFERENCE_ID1
103: FROM okc_articles_all lib,
104: okc_k_articles_b kart
105: WHERE lib.article_id = kart.sav_sae_id
106: AND kart.id= p_cat_id;
107:

Line 153: FROM okc_articles_all lib,

149: RETURN VARCHAR2 IS
150: l_api_name CONSTANT VARCHAR2(30) := 'get_orig_var_val';
151: CURSOR csr_orig_target_dtls IS
152: SELECT kart1.id
153: FROM okc_articles_all lib,
154: okc_k_articles_b kart,
155: okc_k_articles_b kart1
156: WHERE lib.article_id = kart.sav_sae_id
157: AND kart.id= p_cat_id

Line 212: FROM okc_articles_all lib,

208: CURSOR csr_target_dtls IS
209: SELECT NVL(standard_yn,'N') standard_flag,
210: kart.article_version_id,
211: kart.ORIG_SYSTEM_REFERENCE_ID1
212: FROM okc_articles_all lib,
213: okc_k_articles_b kart
214: WHERE lib.article_id = kart.sav_sae_id
215: AND kart.id= p_cat_id;
216:

Line 641: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;

637: l_discard Boolean;
638: l_standard_yn VARCHAR2(1) ;
639: l_global_yn VARCHAR2(1) ;
640: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
641: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
642: k NUMBER := 0;
643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
645: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 727: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL

723: SELECT nvl(PROVISION_ALLOWED_YN,'Y') FROM OKC_BUS_DOC_TYPES_B
724: WHERE DOCUMENT_TYPE=p_target_doc_type;
725:
726: CURSOR l_get_std_csr(b_article_id NUMBER) IS
727: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL
728: WHERE article_id=b_article_id;
729:
730: CURSOR l_get_global_csr IS
731: SELECT global_flag FROM OKC_TERMS_TEMPLATES_ALL

Line 941: x_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

937: WHERE ARTICLE_VERSION_ID=b_article_version_id;
938:
939: l_article_rec l_get_article_csr%ROWTYPE;
940: l_local_article_rec l_get_local_article_csr%ROWTYPE;
941: x_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
942:
943: l_article_org_id NUMBER;
944:
945: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS

Line 947: FROM OKC_ARTICLES_ALL

943: l_article_org_id NUMBER;
944:
945: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
946: SELECT org_id
947: FROM OKC_ARTICLES_ALL
948: WHERE article_id = b_article_id;
949:
950: CURSOR l_get_max_local_article_csr(b_article_id IN NUMBER, b_article_org_id IN NUMBER) IS
951: SELECT DECODE(ADP.LOCAL_ARTICLE_VERSION_ID,NULL,ADP.GLOBAL_ARTICLE_VERSION_ID,ADP.LOCAL_ARTICLE_VERSION_ID),