[Home] [Help]
3225: --
3226: --
3227: CURSOR l_article_in_doc (b_article_id NUMBER) IS
3228: SELECT kart.orig_article_id
3229: FROM OKC_K_ARTICLES_B KART
3230: WHERE document_type = p_document_type
3231: AND document_id = p_document_id
3232: AND source_flag='R'
3233: AND NVL(kart.AMENDMENT_OPERATION_CODE, '?') <> 'DELETED'
3243: p_document_id number,
3244: p_config_header_id number,
3245: p_config_rev_nbr number) IS
3246: SELECT orig_article_id
3247: FROM okc_k_articles_b kart
3248: WHERE kart.document_type = p_document_type
3249: AND kart.document_id = p_document_id
3250: AND kart.source_flag = 'R' -- from Contract Expert
3251: AND NVL(kart.AMENDMENT_OPERATION_CODE, '?') <> 'DELETED'
4434: l_api_version CONSTANT NUMBER := 1;
4435: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
4436:
4437: CURSOR get_doc_article_ver_id(p_doc_id NUMBER,p_doc_type VARCHAR2,p_article_id NUMBER) IS
4438: select id, article_version_id, 'D' from okc_k_articles_b
4439: where document_id = p_doc_id
4440: and document_type = p_doc_type
4441: and ((sav_sae_id = p_article_id) or (ref_article_id = p_article_id))
4442: and source_flag = 'R'
7552: AND a.article_id = ver.article_id
7553: AND ver.article_version_id = b_article_version_id;
7554:
7555: CURSOR get_doc_article_ver_id IS
7556: select sav_sae_id, article_version_id from okc_k_articles_b
7557: where document_id = p_document_id
7558: and document_type = p_document_type
7559: and ((sav_sae_id = p_article_id) or (ref_article_id = p_article_id))
7560: and source_flag = 'R'
7585:
7586: CURSOR l_get_doc_scn_csr (b_article_version_id NUMBER) IS
7587: SELECT scn.heading
7588: FROM OKC_SECTIONS_B scn,
7589: OKC_K_ARTICLES_B art
7590: WHERE art.document_type=p_document_type
7591: AND art.document_id =p_document_id
7592: AND art.article_version_id = b_article_version_id --Bug#4757731 replaced art.sav_sae_id with art.article_version_id
7593: AND art.scn_id = scn.id