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 643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Delete records from okc_k_articles_bh for the doc');

639: END IF;
640: --------------------------------------------
641:
642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Delete records from okc_k_articles_bh for the doc');
644: END IF;
645:
646: x_return_status:=OKC_K_ARTICLES_PVT.delete_version(
647: p_doc_type => p_doc_type,

Line 741: FROM okc_k_articles_b kart, okc_k_art_variables var

737: l_api_version CONSTANT NUMBER := 1;
738: l_api_name CONSTANT VARCHAR2(30) := 'Mark_Amendment';
739: CURSOR idlist_crs IS
740: SELECT distinct id, kart.object_version_number
741: FROM okc_k_articles_b kart, okc_k_art_variables var
742: WHERE document_type = p_doc_type
743: AND document_id = p_doc_id
744: AND var.cat_id = kart.id
745: AND kart.amendment_operation_code IS NULL

Line 864: FROM okc_k_articles_b

860: WHERE TEMPLATE_ID = l_base_template_id;
861:
862: CURSOR kart_csr IS
863: SELECT id, object_version_number
864: FROM okc_k_articles_b
865: WHERE document_type=G_TMPL_DOC_TYPE
866: AND document_id = p_template_id;
867:
868: CURSOR sect_csr IS

Line 1241: FROM okc_k_articles_b kart, okc_k_art_variables var

1237: i NUMBER := 1;
1238: l_doc_class VARCHAR2(30) := '?';
1239: CURSOR var_doc_lst_crs IS
1240: SELECT distinct var.variable_code
1241: FROM okc_k_articles_b kart, okc_k_art_variables var
1242: WHERE kart.document_type=p_doc_type AND kart.document_id=p_doc_id
1243: and var.cat_id=kart.id AND variable_type='S';
1244:
1245: CURSOR var_def_lst_crs IS

Line 1452: AND cat_id IN (SELECT id FROM okc_k_articles_b

1448: CURSOR var_lst_crs IS
1449: SELECT cat_id, object_version_number
1450: FROM okc_k_art_variables
1451: WHERE variable_code=p_variable_code
1452: AND cat_id IN (SELECT id FROM okc_k_articles_b
1453: WHERE document_type=p_doc_type AND document_id=p_doc_id);
1454: CURSOR art_lst_crs IS
1455: SELECT id, object_version_number
1456: FROM okc_k_articles_b a

Line 1456: FROM okc_k_articles_b a

1452: AND cat_id IN (SELECT id FROM okc_k_articles_b
1453: WHERE document_type=p_doc_type AND document_id=p_doc_id);
1454: CURSOR art_lst_crs IS
1455: SELECT id, object_version_number
1456: FROM okc_k_articles_b a
1457: WHERE document_type=p_doc_type AND document_id=p_doc_id
1458: and EXISTS (SELECT '!' FROM okc_k_art_variables v
1459: WHERE v.variable_code=p_variable_code AND v.cat_id = a.cat_id );
1460: BEGIN

Line 1957: FROM okc_k_articles_b

1953: FROM okc_allowed_tmpl_usages
1954: WHERE template_id = p_template_id
1955: UNION ALL
1956: SELECT 1
1957: FROM okc_k_articles_b
1958: WHERE document_type = 'TEMPLATE'
1959: AND document_id = p_template_id;
1960:
1961: BEGIN

Line 2112: FROM okc_k_articles_b kart,

2108: l_msg_count NUMBER;
2109:
2110: CURSOR l_art_amendment_csr IS
2111: SELECT 1
2112: FROM okc_k_articles_b kart,
2113: okc_template_usages usg
2114: WHERE usg.document_type = p_document_type
2115: AND usg.document_id = p_document_id
2116: AND usg.document_type = kart.document_type

Line 2232: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

2228: p_existing_summary_code IN VARCHAR2,
2229: p_existing_operation_code IN VARCHAR2, -- we don't need the parameter, but keep it for compatibility
2230: p_amend_operation_code IN VARCHAR2
2231: ) return VARCHAR2 IS
2232: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
2233:
2234: BEGIN
2235:
2236: IF p_existing_summary_code='ADDED' AND p_amend_operation_code ='DELETED' THEN

Line 2261: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

2257: p_existing_summary_code IN VARCHAR2,
2258: p_existing_operation_code IN VARCHAR2,
2259: p_amend_operation_code IN VARCHAR2
2260: ) return VARCHAR2 IS
2261: l_new_summary_code OKC_K_ARTICLES_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
2262:
2263: BEGIN
2264: l_new_summary_code:=get_summary_amend_code(p_existing_summary_code=>p_existing_summary_code,
2265: p_existing_operation_code=>p_existing_operation_code,

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

2443: cursor section_cur(l_section_id NUMBER) is
2444: select HEADING FROM OKC_SECTIONS_B WHERE ID = l_section_id ;
2445:
2446: cursor section_for_article_id(l_article_id NUMBER) is
2447: select HEADING FROM OKC_SECTIONS_B WHERE ID = (select scn_id from okc_k_articles_b where id = l_article_id) ;
2448:
2449:
2450: BEGIN
2451:

Line 3400: FROM okc_k_articles_b

3396: 'S' If the article record is NOT deleted and exists
3397: */
3398: CURSOR csr_check_article IS
3399: SELECT amendment_operation_code,summary_amend_operation_code
3400: FROM okc_k_articles_b
3401: WHERE id = p_cat_id
3402: AND sav_sae_id = p_article_id ;
3403: l_api_name CONSTANT VARCHAR2(30) := 'is_article_deleted';
3404: l_amendment_operation_code VARCHAR2(30);

Line 3620: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART

3616: AND TMPLC.selected_yn = 'Y'
3617: AND ARTV.article_id = TMPLC.article_id
3618: AND ARTV.article_version_id = TMPLC.article_version_id
3619: AND ARTV.article_status in ('DRAFT', 'REJECTED')
3620: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART
3621: WHERE KART.document_type = p_doc_type
3622: AND KART.document_id = p_doc_id
3623: AND KART.sav_sae_id = TMPLC.article_id);
3624:

Line 3673: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART

3669: AND TMPLC.selected_yn = 'Y'
3670: AND ARTV.article_id = TMPLC.article_id
3671: AND ARTV.article_version_id = TMPLC.article_version_id
3672: AND ARTV.article_status = 'PENDING_APPROVAL'
3673: AND EXISTS (SELECT 1 FROM OKC_K_ARTICLES_B KART
3674: WHERE KART.document_type = p_doc_type
3675: AND KART.document_id = p_doc_id
3676: AND KART.sav_sae_id = TMPLC.article_id);
3677:

Line 3887: FROM okc_sections_b osb,okc_k_articles_b oka

3883: */
3884:
3885: CURSOR sec_name_csr (cp_template_id NUMBER, cp_article_id NUMBER)IS
3886: SELECT osb.heading, nvl(oka.label, '-98766554433.77'),osb.label section_label
3887: FROM okc_sections_b osb,okc_k_articles_b oka
3888: WHERE oka.document_id = cp_template_id
3889: AND oka.sav_sae_id = cp_article_id
3890: AND oka.scn_id = osb.id
3891: AND rownum < 3;

Line 3907: (SELECT sav_sae_id from okc_k_articles_b oka

3903: AND oaa.standard_yn = 'Y'
3904: AND oav.start_date <= cp_effective_date
3905: AND nvl(oav.end_date, nvl(cp_effective_date,sysdate) +1) >= nvl(cp_effective_date,sysdate)
3906: AND oaa.article_id in
3907: (SELECT sav_sae_id from okc_k_articles_b oka
3908: WHERE oka.document_id = cp_template_id
3909: AND oka.document_type='TEMPLATE');
3910:
3911: CURSOR valid_ver_csr (cp_article_id NUMBER, cp_article_version_id NUMBER,

Line 4209: okc_k_articles_b kart,

4205: CURSOR unadopted_art_chk_csr(lc_tmpl_id NUMBER,
4206: lc_org_id NUMBER) IS
4207: SELECT 'Y'
4208: FROM okc_terms_templates_all tmpl,
4209: okc_k_articles_b kart,
4210: okc_article_versions ver
4211: WHERE tmpl.template_id = lc_tmpl_id
4212: AND kart.document_id = tmpl.template_id
4213: AND kart.document_type = 'TEMPLATE'

Line 5015: FROM OKC_K_ARTICLES_B

5011: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
5012:
5013: Cursor l_get_max_art_date_csr IS
5014: SELECT max(Nvl(LAST_UPDATE_DATE,CREATION_DATE))
5015: FROM OKC_K_ARTICLES_B
5016: WHERE DOCUMENT_TYPE=p_document_type
5017: AND DOCUMENT_ID=p_document_id;
5018:
5019: Cursor l_get_max_scn_date_csr IS

Line 5028: SELECT ID FROM OKC_K_ARTICLES_B

5024:
5025: Cursor l_get_max_var_date_csr IS
5026: SELECT MAX(NVL(LAST_UPDATE_DATE,CREATION_DATE))
5027: FROM OKC_K_ART_VARIABLES WHERE CAT_ID IN (
5028: SELECT ID FROM OKC_K_ARTICLES_B
5029: WHERE DOCUMENT_TYPE = p_document_type
5030: AND DOCUMENT_ID = document_id);
5031:
5032: Cursor l_get_max_usg_upd_date_csr IS

Line 5117: of OKC_K_ARTICLES_B.

5113:
5114: /*
5115: Function Name : get_revert_art_version_id
5116: Purpose : This function returns the latest article_version_id of the ref_article_id queried using id
5117: of OKC_K_ARTICLES_B.
5118: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id
5119: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).
5120: */
5121:

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

5115: Function Name : get_revert_art_version_id
5116: Purpose : This function returns the latest article_version_id of the ref_article_id queried using id
5117: of OKC_K_ARTICLES_B.
5118: Usage : This function is used in the Revert to Standard UI to query the latest article_version_id
5119: for the ref_article_id of the article in OKC_K_ARTICLES_B queried using the id (primary_key).
5120: */
5121:
5122: FUNCTION get_revert_art_version_id(
5123: p_id IN NUMBER,

Line 5130: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;

5126: IS
5127:
5128: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
5129: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
5130: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;
5131: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
5132: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;
5133:
5134:

Line 5132: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;

5128: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
5129: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
5130: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;
5131: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
5132: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;
5133:
5134:
5135: -- Fix for bug# 5235082. Changed the query to use id instead of sav_sae_id
5136: cursor get_ref_article_id is

Line 5137: select ref_article_id from okc_k_articles_b

5133:
5134:
5135: -- Fix for bug# 5235082. Changed the query to use id instead of sav_sae_id
5136: cursor get_ref_article_id is
5137: select ref_article_id from okc_k_articles_b
5138: where id = p_id;
5139:
5140: BEGIN
5141: open get_ref_article_id;

Line 5205: FROM okc_k_articles_b KA,

5201: CURSOR csr_get_udv_with_procs IS
5202: SELECT VB.variable_code,
5203: KA.id,
5204: KA.article_version_id
5205: FROM okc_k_articles_b KA,
5206: okc_k_art_variables KV,
5207: okc_bus_variables_b VB
5208: WHERE VB.variable_code = KV.variable_code
5209: AND KA.id = KV.cat_id