APPS.OKC_TERMS_MIGRATE_GRP dependencies on OKC_K_ARTICLES_B

Line 1791: FROM OKC_K_ARTICLES_B

1787: AND scn_id=lc_scn_id;
1788:
1789: CURSOR la_ref_seq_csr(lc_scn_id IN NUMBER) is
1790: SELECT nvl(max(display_sequence),0)
1791: FROM OKC_K_ARTICLES_B
1792: WHERE document_type = p_document_type
1793: AND document_id = p_document_id
1794: AND scn_id=lc_scn_id;
1795:

Line 2850: 4. p_k_clause_id should be the id of the clause in the table OKC_K_ARTICLES_B in target system.

2846: /*This API migrates variable values from external system to Contracts.
2847: 1. p_doc_type is the document type in the target system
2848: 2. p_doc_id is the document id in the target system.
2849: 3. p_k_clause_id or (p_clause_title and p_clause_version) are mandatory.
2850: 4. p_k_clause_id should be the id of the clause in the table OKC_K_ARTICLES_B in target system.
2851: We can pass this value if we are calling this API along with ADD Clause API.
2852: The clause_id o/p can be provided to this API directly.
2853:
2854: */

Line 3003: FROM okc_k_articles_b kb, okc_articles_all a , okc_article_versions v

2999: l_k_art_id := p_k_clause_id;
3000: ELSIF p_clause_title IS NOT NULL AND p_clause_version IS NOT NULL THEN
3001:
3002: SELECT kb.id INTO l_k_art_id
3003: FROM okc_k_articles_b kb, okc_articles_all a , okc_article_versions v
3004: WHERE a.article_title = p_clause_title AND a.org_id = G_CURRENT_ORG_ID
3005: AND kb.document_type = p_doc_type AND kb.document_id = p_doc_id
3006: AND v.article_version_number = p_clause_version AND a.article_id = v.article_id
3007: AND kb.sav_sae_id = a.article_id AND kb.article_version_id = v.article_version_id;

Line 6166: FROM okc_k_articles_b

6162: AND ART.org_id = l_org_id;
6163:
6164: CURSOR c_get_doc_art_id_csr(p_article_id NUMBER) IS
6165: SELECT id, object_version_number
6166: FROM okc_k_articles_b
6167: WHERE p_document_type = p_document_type
6168: AND document_id = p_document_id
6169: AND sav_sae_id = p_article_id;
6170:

Line 6392: FROM okc_k_articles_b

6388: l_object_version_number NUMBER;
6389:
6390: CURSOR c_get_doc_art_id_csr IS
6391: SELECT object_version_number
6392: FROM okc_k_articles_b
6393: WHERE p_document_type = p_document_type
6394: AND document_id = p_document_id
6395: AND id = p_clause_id;
6396: