APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_K_ARTICLES_B

Line 3247: FROM OKC_K_ARTICLES_B KART

3243: --
3244: --
3245: CURSOR l_article_in_doc (b_article_id NUMBER) IS
3246: SELECT kart.orig_article_id
3247: FROM OKC_K_ARTICLES_B KART
3248: WHERE document_type = p_document_type
3249: AND document_id = p_document_id
3250: AND source_flag='R'
3251: AND NVL(kart.AMENDMENT_OPERATION_CODE, '?') <> 'DELETED'

Line 3265: FROM okc_k_articles_b kart

3261: p_document_id number,
3262: p_config_header_id number,
3263: p_config_rev_nbr number) IS
3264: SELECT orig_article_id
3265: FROM okc_k_articles_b kart
3266: WHERE kart.document_type = p_document_type
3267: AND kart.document_id = p_document_id
3268: AND kart.source_flag = 'R' -- from Contract Expert
3269: AND NVL(kart.AMENDMENT_OPERATION_CODE, '?') <> 'DELETED'

Line 3287: FROM okc_k_articles_b kart

3283: --
3284: CURSOR l_articles_only_in_doc_ruleng (p_document_type varchar2,
3285: p_document_id number) IS
3286: SELECT orig_article_id
3287: FROM okc_k_articles_b kart
3288: WHERE kart.document_type = p_document_type
3289: AND kart.document_id = p_document_id
3290: AND kart.source_flag = 'R' -- from Contract Expert
3291: AND NVL(kart.AMENDMENT_OPERATION_CODE, '?') <> 'DELETED'

Line 4636: select id, article_version_id, 'D' from okc_k_articles_b

4632: l_api_version CONSTANT NUMBER := 1;
4633: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
4634:
4635: CURSOR get_doc_article_ver_id(p_doc_id NUMBER,p_doc_type VARCHAR2,p_article_id NUMBER) IS
4636: select id, article_version_id, 'D' from okc_k_articles_b
4637: where document_id = p_doc_id
4638: and document_type = p_doc_type
4639: and ((sav_sae_id = p_article_id) or (ref_article_id = p_article_id))
4640: and source_flag = 'R'

Line 7841: select sav_sae_id, article_version_id from okc_k_articles_b

7837: AND a.article_id = ver.article_id
7838: AND ver.article_version_id = b_article_version_id;
7839:
7840: CURSOR get_doc_article_ver_id IS
7841: select sav_sae_id, article_version_id from okc_k_articles_b
7842: where document_id = p_document_id
7843: and document_type = p_document_type
7844: and ((sav_sae_id = p_article_id) or (ref_article_id = p_article_id))
7845: and source_flag = 'R'

Line 7874: OKC_K_ARTICLES_B art

7870:
7871: CURSOR l_get_doc_scn_csr (b_article_version_id NUMBER) IS
7872: SELECT scn.heading
7873: FROM OKC_SECTIONS_B scn,
7874: OKC_K_ARTICLES_B art
7875: WHERE art.document_type=p_document_type
7876: AND art.document_id =p_document_id
7877: AND art.article_version_id = b_article_version_id --Bug#4757731 replaced art.sav_sae_id with art.article_version_id
7878: AND art.scn_id = scn.id