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_TEMPLATE_USAGES

Line 258: SELECT '!' FROM okc_template_usages_v

254: SELECT '!' FROM okc_terms_templates
255: WHERE parent_template_id = p_doc_id;
256:
257: CURSOR tmpl_usd_crs IS
258: SELECT '!' FROM okc_template_usages_v
259: WHERE TEMPLATE_ID = p_doc_id AND ROWNUM=1;
260:
261: CURSOR tt_csr IS
262: SELECT TEMPLATE_ID, object_version_number,template_model_id

Line 268: FROM OKC_TEMPLATE_USAGES

264: WHERE template_id=p_doc_id;
265:
266: CURSOR objnum_tu_csr IS
267: SELECT object_version_number
268: FROM OKC_TEMPLATE_USAGES
269: WHERE DOCUMENT_TYPE = p_doc_type AND DOCUMENT_ID = p_doc_id;
270:
271: CURSOR objnum_mlp_tu_csr IS
272: SELECT object_version_number

Line 475: -- Delete record form okc_template_usages

471:
472: ------------------------------------------------
473:
474: --------------------------------------------
475: -- Delete record form okc_template_usages
476: --------------------------------------------
477: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages for the doc');
479: END IF;

Line 478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages for the doc');

474: --------------------------------------------
475: -- Delete record form okc_template_usages
476: --------------------------------------------
477: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages for the doc');
479: END IF;
480: l_objnum := -1;
481: OPEN objnum_tu_csr;
482: FETCH objnum_tu_csr INTO l_objnum;

Line 486: OKC_TEMPLATE_USAGES_PVT.delete_row(

482: FETCH objnum_tu_csr INTO l_objnum;
483: l_found := objnum_tu_csr%FOUND;
484: CLOSE objnum_tu_csr;
485: IF l_found THEN
486: OKC_TEMPLATE_USAGES_PVT.delete_row(
487: x_return_status => x_return_status,
488: p_document_type => p_doc_type,
489: p_document_id => p_doc_id,
490: p_object_version_number => l_objnum

Line 507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Delete a record from okc_template_usages for the doc');

503: -- kkolukul: CLM changes: Delete records from okc_mlp_template_usages
504: --Delete records from okc_mlp_template_usages when removing terms.
505: --------------------------------------------
506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Delete a record from okc_template_usages for the doc');
508: END IF;
509:
510: l_objnum := -1;
511: OPEN objnum_mlp_tu_csr;

Line 676: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages_h for the doc');

672: END IF;
673: --------------------------------------------
674:
675: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages_h for the doc');
677: END IF;
678:
679: x_return_status:=OKC_TEMPLATE_USAGES_PVT.delete_version(
680: p_doc_type => p_doc_type,

Line 679: x_return_status:=OKC_TEMPLATE_USAGES_PVT.delete_version(

675: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages_h for the doc');
677: END IF;
678:
679: x_return_status:=OKC_TEMPLATE_USAGES_PVT.delete_version(
680: p_doc_type => p_doc_type,
681: p_doc_id => p_doc_id,
682: p_major_version => p_version_number
683: );

Line 2113: okc_template_usages usg

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
2117: AND usg.document_id = kart.document_id

Line 2124: okc_template_usages usg

2120: kart.summary_amend_operation_code IS NOT NULL)
2121: UNION ALL
2122: SELECT 1
2123: FROM okc_sections_b scn,
2124: okc_template_usages usg
2125: WHERE usg.document_type = p_document_type
2126: AND usg.document_id = p_document_id
2127: AND NVL(usg.contract_source_code,'STRUCTURED') = 'STRUCTURED'
2128: AND usg.document_type = scn.document_type

Line 2135: okc_template_usages usg

2131: scn.summary_amend_operation_code IS NOT NULL)
2132: UNION ALL
2133: SELECT 1
2134: FROM okc_contract_docs kdoc,
2135: okc_template_usages usg
2136: WHERE usg.document_type = p_document_type
2137: AND usg.document_id = p_document_id
2138: AND usg.document_type = kdoc.business_document_type
2139: AND usg.document_id = kdoc.business_document_id

Line 2149: OKC_TEMPLATE_USAGES_H usgH

2145: OR
2146: (
2147: exists (SELECT 1
2148: FROM
2149: OKC_TEMPLATE_USAGES_H usgH
2150: WHERE
2151: usgH.document_type = p_document_type
2152: AND usgH.document_id = p_document_id
2153: AND usgH.major_version < p_document_version

Line 2160: okc_template_usages usg

2156: )
2157: UNION ALL
2158: SELECT 1
2159: FROM okc_contract_docs kdoc,
2160: okc_template_usages usg
2161: WHERE usg.document_type = p_document_type
2162: AND usg.document_id = p_document_id
2163: AND usg.document_type = kdoc.business_document_type
2164: AND usg.document_id = kdoc.business_document_id

Line 2178: OKC_TEMPLATE_USAGES_H usgH

2174: OR
2175: (
2176: exists (SELECT 1
2177: FROM
2178: OKC_TEMPLATE_USAGES_H usgH
2179: WHERE
2180: usgH.document_type = p_document_type
2181: AND usgH.document_id = p_document_id
2182: AND usgH.major_version < p_document_version

Line 2625: FROM okc_template_usages tu

2621: x_adoption_type OUT NOCOPY VARCHAR2 ) IS
2622:
2623: CURSOR csr_effective_date IS
2624: SELECT tu.article_effective_date
2625: FROM okc_template_usages tu
2626: WHERE tu.document_type = p_document_type
2627: AND tu.document_id = p_document_id;
2628:
2629: -- effectivity date for templates

Line 2931: okc_template_usages u

2927:
2928: CURSOR l_org_id_csr IS
2929: SELECT t.org_id
2930: FROM okc_terms_templates_all t,
2931: okc_template_usages u
2932: WHERE t.template_id = u.template_id
2933: AND u.document_type = p_doc_type
2934: AND u.document_id = p_doc_id ;
2935:

Line 3155: from okc_template_usages a ,okc_terms_templates_all b

3151: select a.template_id, b.template_name, a.article_effective_date,
3152: a.doc_numbering_scheme,
3153: a.config_header_id, a.config_revision_number,
3154: a.valid_config_yn, b.org_id
3155: from okc_template_usages a ,okc_terms_templates_all b
3156: where a.template_id = b.template_id
3157: and a.document_id = p_document_id and a.document_type = p_document_type;
3158:
3159: cursor l_get_dflt_tmpl_dtls_csr is

Line 3256: UPDATE okc_template_usages

3252: l_update_date := true;
3253: l_update_date_with := p_eff_date;
3254: end if;
3255: if(l_update_date and l_update_date_with is NOT NULL) then
3256: UPDATE okc_template_usages
3257: SET article_effective_date = l_update_date_with
3258: WHERE document_type = p_document_type
3259: AND document_id = p_document_id;
3260: end if;

Line 4322: UPDATE okc_template_usages

4318: -- Initialize API return status to success
4319: x_return_status := FND_API.G_RET_STS_SUCCESS;
4320:
4321: FORALL i IN p_doc_ids_tbl.FIRST..p_doc_ids_tbl.LAST
4322: UPDATE okc_template_usages
4323: SET contract_admin_id = p_new_con_admin_user_ids_tbl(i)
4324: WHERE document_id = p_doc_ids_tbl(i)
4325: AND document_type = p_doc_types_tbl(i);
4326:

Line 4616: FROM okc_template_usages usg

4612: l_terms_locked VARCHAR2(1);
4613:
4614: CURSOR l_terms_locked_csr IS
4615: SELECT lock_terms_flag
4616: FROM okc_template_usages usg
4617: WHERE usg.document_type = p_document_type
4618: AND usg.document_id = p_document_id
4619: ;
4620: BEGIN

Line 4818: okc_template_usages_v otuv,

4814: SELECT
4815: xdb.template_code
4816: FROM
4817: okc_terms_templates_all otta,
4818: okc_template_usages_v otuv,
4819: xdo_templates_b xdb
4820: WHERE otuv.document_id = p_doc_id
4821: AND otuv.document_type = p_doc_type
4822: AND otuv.template_id = otta.template_id

Line 4904: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4900: FND_MSG_PUB.initialize;
4901: END IF;
4902:
4903: x_return_status := G_RET_STS_SUCCESS;
4904: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4905: p_api_version => l_api_version,
4906: p_init_msg_list => p_init_msg_list ,
4907: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4908: p_commit => FND_API.G_FALSE,

Line 4969: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4965: FND_MSG_PUB.initialize;
4966: END IF;
4967:
4968: x_return_status := G_RET_STS_SUCCESS;
4969: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4970: p_api_version => l_api_version,
4971: p_init_msg_list => p_init_msg_list ,
4972: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4973: p_commit => FND_API.G_FALSE,

Line 5011: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

5007: l_article_change_date date;
5008: l_section_change_date date;
5009: l_variable_change_date date;
5010: l_sys_last_update_date date;
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

Line 5034: FROM okc_template_usages

5030: AND DOCUMENT_ID = document_id);
5031:
5032: Cursor l_get_max_usg_upd_date_csr IS
5033: SELECT MAX(LAST_UPDATE_DATE)
5034: FROM okc_template_usages
5035: WHERE document_type = p_document_type
5036: AND document_id = p_document_id;
5037:
5038: Cursor l_get_contract_source_csr IS

Line 5040: FROM okc_template_usages

5036: AND document_id = p_document_id;
5037:
5038: Cursor l_get_contract_source_csr IS
5039: SELECT contract_source_code
5040: FROM okc_template_usages
5041: WHERE document_type = p_document_type
5042: AND document_id = p_document_id;
5043:
5044: BEGIN