eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_UTIL_PVT dependencies on OKC_K_ARTICLES_B

Line 602: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Delete records from okc_k_articles_bh for the doc');

598: END IF;
599: --------------------------------------------
600:
601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
602: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Delete records from okc_k_articles_bh for the doc');
603: END IF;
604:
605: x_return_status:=OKC_K_ARTICLES_PVT.delete_version(
606: p_doc_type => p_doc_type,

Line 700: FROM okc_k_articles_b kart, okc_k_art_variables var

696: l_api_version CONSTANT NUMBER := 1;
697: l_api_name CONSTANT VARCHAR2(30) := 'Mark_Amendment';
698: CURSOR idlist_crs IS
699: SELECT distinct id, kart.object_version_number
700: FROM okc_k_articles_b kart, okc_k_art_variables var
701: WHERE document_type = p_doc_type
702: AND document_id = p_doc_id
703: AND var.cat_id = kart.id
704: AND kart.amendment_operation_code IS NULL

Line 823: FROM okc_k_articles_b

819: WHERE TEMPLATE_ID = l_base_template_id;
820:
821: CURSOR kart_csr IS
822: SELECT id, object_version_number
823: FROM okc_k_articles_b
824: WHERE document_type=G_TMPL_DOC_TYPE
825: AND document_id = p_template_id;
826:
827: CURSOR sect_csr IS

Line 1200: FROM okc_k_articles_b kart, okc_k_art_variables var

1196: i NUMBER := 1;
1197: l_doc_class VARCHAR2(30) := '?';
1198: CURSOR var_doc_lst_crs IS
1199: SELECT distinct var.variable_code
1200: FROM okc_k_articles_b kart, okc_k_art_variables var
1201: WHERE kart.document_type=p_doc_type AND kart.document_id=p_doc_id
1202: and var.cat_id=kart.id AND variable_type='S';
1203:
1204: CURSOR var_def_lst_crs IS

Line 1410: AND cat_id IN (SELECT id FROM okc_k_articles_b

1406: CURSOR var_lst_crs IS
1407: SELECT cat_id, object_version_number
1408: FROM okc_k_art_variables
1409: WHERE variable_code=p_variable_code
1410: AND cat_id IN (SELECT id FROM okc_k_articles_b
1411: WHERE document_type=p_doc_type AND document_id=p_doc_id);
1412: CURSOR art_lst_crs IS
1413: SELECT id, object_version_number
1414: FROM okc_k_articles_b a

Line 1414: FROM okc_k_articles_b a

1410: AND cat_id IN (SELECT id FROM okc_k_articles_b
1411: WHERE document_type=p_doc_type AND document_id=p_doc_id);
1412: CURSOR art_lst_crs IS
1413: SELECT id, object_version_number
1414: FROM okc_k_articles_b a
1415: WHERE document_type=p_doc_type AND document_id=p_doc_id
1416: and EXISTS (SELECT '!' FROM okc_k_art_variables v
1417: WHERE v.variable_code=p_variable_code AND v.cat_id = a.cat_id );
1418: BEGIN

Line 1915: FROM okc_k_articles_b

1911: FROM okc_allowed_tmpl_usages
1912: WHERE template_id = p_template_id
1913: UNION ALL
1914: SELECT 1
1915: FROM okc_k_articles_b
1916: WHERE document_type = 'TEMPLATE'
1917: AND document_id = p_template_id;
1918:
1919: BEGIN

Line 2070: FROM okc_k_articles_b kart,

2066: l_msg_count NUMBER;
2067:
2068: CURSOR l_art_amendment_csr IS
2069: SELECT 1
2070: FROM okc_k_articles_b kart,
2071: okc_template_usages usg
2072: WHERE usg.document_type = p_document_type
2073: AND usg.document_id = p_document_id
2074: AND usg.document_type = kart.document_type

Line 2190: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

2186: p_existing_summary_code IN VARCHAR2,
2187: p_existing_operation_code IN VARCHAR2, -- we don't need the parameter, but keep it for compatibility
2188: p_amend_operation_code IN VARCHAR2
2189: ) return VARCHAR2 IS
2190: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
2191:
2192: BEGIN
2193:
2194: IF p_existing_summary_code='ADDED' AND p_amend_operation_code ='DELETED' THEN

Line 2219: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

2215: p_existing_summary_code IN VARCHAR2,
2216: p_existing_operation_code IN VARCHAR2,
2217: p_amend_operation_code IN VARCHAR2
2218: ) return VARCHAR2 IS
2219: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
2220:
2221: BEGIN
2222: l_new_summary_code:=get_summary_amend_code(p_existing_summary_code=>p_existing_summary_code,
2223: p_existing_operation_code=>p_existing_operation_code,

Line 2405: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;

2401: cursor section_cur(l_section_id NUMBER) is
2402: select HEADING FROM OKC_SECTIONS_B WHERE ID = l_section_id ;
2403:
2404: cursor section_for_article_id(l_article_id NUMBER) is
2405: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;
2406:
2407:
2408: BEGIN
2409:

Line 3358: FROM okc_k_articles_b

3354: 'S' If the article record is NOT deleted and exists
3355: */
3356: CURSOR csr_check_article IS
3357: SELECT amendment_operation_code,summary_amend_operation_code
3358: FROM okc_k_articles_b
3359: WHERE id = p_cat_id
3360: AND sav_sae_id = p_article_id ;
3361: l_api_name CONSTANT VARCHAR2(30) := 'is_article_deleted';
3362: l_amendment_operation_code VARCHAR2(30);

Line 3577: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART

3573: AND TMPLC.selected_yn = 'Y'
3574: AND ARTV.article_id = TMPLC.article_id
3575: AND ARTV.article_version_id = TMPLC.article_version_id
3576: AND ARTV.article_status in ('DRAFT', 'REJECTED')
3577: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART
3578: WHERE KART.document_type = p_doc_type
3579: AND KART.document_id = p_doc_id
3580: AND KART.sav_sae_id = TMPLC.article_id);
3581:

Line 3630: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART

3626: AND TMPLC.selected_yn = 'Y'
3627: AND ARTV.article_id = TMPLC.article_id
3628: AND ARTV.article_version_id = TMPLC.article_version_id
3629: AND ARTV.article_status = 'PENDING_APPROVAL'
3630: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART
3631: WHERE KART.document_type = p_doc_type
3632: AND KART.document_id = p_doc_id
3633: AND KART.sav_sae_id = TMPLC.article_id);
3634:

Line 3838: FROM okc_sections_b osb,okc_k_articles_b oka

3834: */
3835:
3836: CURSOR sec_name_csr (cp_template_id NUMBER, cp_article_id NUMBER)IS
3837: SELECT osb.heading, nvl(oka.label, '-98766554433.77'),osb.label section_label
3838: FROM okc_sections_b osb,okc_k_articles_b oka
3839: WHERE oka.document_id = cp_template_id
3840: AND oka.sav_sae_id = cp_article_id
3841: AND oka.scn_id = osb.id
3842: AND rownum < 3;

Line 3858: (SELECT sav_sae_id from okc_k_articles_b oka

3854: AND oaa.standard_yn = 'Y'
3855: AND oav.start_date <= cp_effective_date
3856: AND nvl(oav.end_date, nvl(cp_effective_date,sysdate) +1) >= nvl(cp_effective_date,sysdate)
3857: AND oaa.article_id in
3858: (SELECT sav_sae_id from okc_k_articles_b oka
3859: WHERE oka.document_id = cp_template_id
3860: AND oka.document_type='TEMPLATE');
3861:
3862: CURSOR valid_ver_csr (cp_article_id NUMBER, cp_article_version_id NUMBER,

Line 4160: okc_k_articles_b kart,

4156: CURSOR unadopted_art_chk_csr(lc_tmpl_id NUMBER,
4157: lc_org_id NUMBER) IS
4158: SELECT 'Y'
4159: FROM okc_terms_templates_all tmpl,
4160: okc_k_articles_b kart,
4161: okc_article_versions ver
4162: WHERE tmpl.template_id = lc_tmpl_id
4163: AND kart.document_id = tmpl.template_id
4164: AND kart.document_type = 'TEMPLATE'

Line 4966: FROM OKC_K_ARTICLES_B

4962: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
4963:
4964: Cursor l_get_max_art_date_csr IS
4965: SELECT max(Nvl(LAST_UPDATE_DATE,CREATION_DATE))
4966: FROM OKC_K_ARTICLES_B
4967: WHERE DOCUMENT_TYPE=p_document_type
4968: AND DOCUMENT_ID=p_document_id;
4969:
4970: Cursor l_get_max_scn_date_csr IS

Line 4979: SELECT ID FROM OKC_K_ARTICLES_B

4975:
4976: Cursor l_get_max_var_date_csr IS
4977: SELECT MAX(NVL(LAST_UPDATE_DATE,CREATION_DATE))
4978: FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN (
4979: SELECT ID FROM OKC_K_ARTICLES_B
4980: WHERE DOCUMENT_TYPE = p_document_type
4981: AND DOCUMENT_ID = document_id);
4982:
4983: Cursor l_get_max_usg_upd_date_csr IS

Line 5068: of OKC_K_ARTICLES_B.

5064:
5065: /*
5066: Function Name : get_revert_art_version_id
5067: Purpose : This function returns the latest article_version_id of the ref_article_id queried using id
5068: of OKC_K_ARTICLES_B.
5069: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id
5070: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).
5071: */
5072:

Line 5070: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).

5066: Function Name : get_revert_art_version_id
5067: Purpose : This function returns the latest article_version_id of the ref_article_id queried using id
5068: of OKC_K_ARTICLES_B.
5069: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id
5070: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).
5071: */
5072:
5073: FUNCTION get_revert_art_version_id(
5074: p_id IN NUMBER,

Line 5081: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;

5077: IS
5078:
5079: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
5080: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
5081: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;
5082: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
5083: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;
5084:
5085:

Line 5083: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;

5079: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
5080: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
5081: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;
5082: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
5083: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;
5084:
5085:
5086: -- Fix for bug# 5235082. Changed the query to use id instead of sav_sae_id
5087: cursor get_ref_article_id is

Line 5088: select ref_article_id from okc_k_articles_b

5084:
5085:
5086: -- Fix for bug# 5235082. Changed the query to use id instead of sav_sae_id
5087: cursor get_ref_article_id is
5088: select ref_article_id from okc_k_articles_b
5089: where id = p_id;
5090:
5091: BEGIN
5092: open get_ref_article_id;

Line 5156: FROM okc_k_articles_b KA,

5152: CURSOR csr_get_udv_with_procs IS
5153: SELECT VB.variable_code,
5154: KA.id,
5155: KA.article_version_id
5156: FROM okc_k_articles_b KA,
5157: okc_k_art_variables KV,
5158: okc_bus_variables_b VB
5159: WHERE VB.variable_code = KV.variable_code
5160: AND KA.id = KV.cat_id