APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ARTICLES_ALL

Line 48: FROM okc_articles_all lib,

44: CURSOR csr_target_dtls IS
45: SELECT NVL(standard_yn,'N') standard_flag,
46: kart.article_version_id,
47: kart.ORIG_SYSTEM_REFERENCE_ID1
48: FROM okc_articles_all lib,
49: okc_k_articles_b kart
50: WHERE lib.article_id = kart.sav_sae_id
51: AND kart.id= p_cat_id;
52:

Line 98: FROM okc_articles_all lib,

94: RETURN VARCHAR2 IS
95: l_api_name CONSTANT VARCHAR2(30) := 'get_orig_var_val';
96: CURSOR csr_orig_target_dtls IS
97: SELECT kart1.id
98: FROM okc_articles_all lib,
99: okc_k_articles_b kart,
100: okc_k_articles_b kart1
101: WHERE lib.article_id = kart.sav_sae_id
102: AND kart.id= p_cat_id

Line 145: FROM okc_articles_all lib,

141: CURSOR csr_target_dtls IS
142: SELECT NVL(standard_yn,'N') standard_flag,
143: kart.article_version_id,
144: kart.ORIG_SYSTEM_REFERENCE_ID1
145: FROM okc_articles_all lib,
146: okc_k_articles_b kart
147: WHERE lib.article_id = kart.sav_sae_id
148: AND kart.id= p_cat_id;
149:

Line 403: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;

399: l_discard Boolean;
400: l_standard_yn VARCHAR2(1) ;
401: l_global_yn VARCHAR2(1) ;
402: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
403: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
404: k NUMBER := 0;
405:
406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
407: TYPE AttributeCategoryList IS TABLE OF OKC_K_ARTICLES_B.ATTRIBUTE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 486: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL

482: SELECT nvl(PROVISION_ALLOWED_YN,'Y') FROM OKC_BUS_DOC_TYPES_B
483: WHERE DOCUMENT_TYPE=p_target_doc_type;
484:
485: CURSOR l_get_std_csr(b_article_id NUMBER) IS
486: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL
487: WHERE article_id=b_article_id;
488:
489: CURSOR l_get_global_csr IS
490: SELECT global_flag FROM OKC_TERMS_TEMPLATES_ALL

Line 685: x_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

681: WHERE ARTICLE_VERSION_ID=b_article_version_id;
682:
683: l_article_rec l_get_article_csr%ROWTYPE;
684: l_local_article_rec l_get_local_article_csr%ROWTYPE;
685: x_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
686:
687: l_article_org_id NUMBER;
688:
689: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS

Line 691: FROM OKC_ARTICLES_ALL

687: l_article_org_id NUMBER;
688:
689: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
690: SELECT org_id
691: FROM OKC_ARTICLES_ALL
692: WHERE article_id = b_article_id;
693:
694: CURSOR l_get_max_local_article_csr(b_article_id IN NUMBER, b_article_org_id IN NUMBER) IS
695: SELECT DECODE(ADP.LOCAL_ARTICLE_VERSION_ID,NULL,ADP.GLOBAL_ARTICLE_VERSION_ID,ADP.LOCAL_ARTICLE_VERSION_ID),