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 255: SELECT '!' FROM okc_template_usages_v

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

Line 265: FROM OKC_TEMPLATE_USAGES

261: WHERE template_id=p_doc_id;
262:
263: CURSOR objnum_tu_csr IS
264: SELECT object_version_number
265: FROM OKC_TEMPLATE_USAGES
266: WHERE DOCUMENT_TYPE = p_doc_type AND DOCUMENT_ID = p_doc_id;
267:
268: BEGIN
269: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 464: -- Delete record form okc_template_usages

460:
461: ------------------------------------------------
462:
463: --------------------------------------------
464: -- Delete record form okc_template_usages
465: --------------------------------------------
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages for the doc');
468: END IF;

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

463: --------------------------------------------
464: -- Delete record form okc_template_usages
465: --------------------------------------------
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages for the doc');
468: END IF;
469: l_objnum := -1;
470: OPEN objnum_tu_csr;
471: FETCH objnum_tu_csr INTO l_objnum;

Line 475: OKC_TEMPLATE_USAGES_PVT.delete_row(

471: FETCH objnum_tu_csr INTO l_objnum;
472: l_found := objnum_tu_csr%FOUND;
473: CLOSE objnum_tu_csr;
474: IF l_found THEN
475: OKC_TEMPLATE_USAGES_PVT.delete_row(
476: x_return_status => x_return_status,
477: p_document_type => p_doc_type,
478: p_document_id => p_doc_id,
479: p_object_version_number => l_objnum

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

631: END IF;
632: --------------------------------------------
633:
634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages_h for the doc');
636: END IF;
637:
638: x_return_status:=OKC_TEMPLATE_USAGES_PVT.delete_version(
639: p_doc_type => p_doc_type,

Line 638: x_return_status:=OKC_TEMPLATE_USAGES_PVT.delete_version(

634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3800: Delete a record from okc_template_usages_h for the doc');
636: END IF;
637:
638: x_return_status:=OKC_TEMPLATE_USAGES_PVT.delete_version(
639: p_doc_type => p_doc_type,
640: p_doc_id => p_doc_id,
641: p_major_version => p_version_number
642: );

Line 2071: okc_template_usages usg

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

Line 2082: okc_template_usages usg

2078: kart.summary_amend_operation_code IS NOT NULL)
2079: UNION ALL
2080: SELECT 1
2081: FROM okc_sections_b scn,
2082: okc_template_usages usg
2083: WHERE usg.document_type = p_document_type
2084: AND usg.document_id = p_document_id
2085: AND NVL(usg.contract_source_code,'STRUCTURED') = 'STRUCTURED'
2086: AND usg.document_type = scn.document_type

Line 2093: okc_template_usages usg

2089: scn.summary_amend_operation_code IS NOT NULL)
2090: UNION ALL
2091: SELECT 1
2092: FROM okc_contract_docs kdoc,
2093: okc_template_usages usg
2094: WHERE usg.document_type = p_document_type
2095: AND usg.document_id = p_document_id
2096: AND usg.document_type = kdoc.business_document_type
2097: AND usg.document_id = kdoc.business_document_id

Line 2107: OKC_TEMPLATE_USAGES_H usgH

2103: OR
2104: (
2105: exists (SELECT 1
2106: FROM
2107: OKC_TEMPLATE_USAGES_H usgH
2108: WHERE
2109: usgH.document_type = p_document_type
2110: AND usgH.document_id = p_document_id
2111: AND usgH.major_version < p_document_version

Line 2118: okc_template_usages usg

2114: )
2115: UNION ALL
2116: SELECT 1
2117: FROM okc_contract_docs kdoc,
2118: okc_template_usages usg
2119: WHERE usg.document_type = p_document_type
2120: AND usg.document_id = p_document_id
2121: AND usg.document_type = kdoc.business_document_type
2122: AND usg.document_id = kdoc.business_document_id

Line 2136: OKC_TEMPLATE_USAGES_H usgH

2132: OR
2133: (
2134: exists (SELECT 1
2135: FROM
2136: OKC_TEMPLATE_USAGES_H usgH
2137: WHERE
2138: usgH.document_type = p_document_type
2139: AND usgH.document_id = p_document_id
2140: AND usgH.major_version < p_document_version

Line 2583: FROM okc_template_usages tu

2579: x_adoption_type OUT NOCOPY VARCHAR2 ) IS
2580:
2581: CURSOR csr_effective_date IS
2582: SELECT tu.article_effective_date
2583: FROM okc_template_usages tu
2584: WHERE tu.document_type = p_document_type
2585: AND tu.document_id = p_document_id;
2586:
2587: -- effectivity date for templates

Line 2889: okc_template_usages u

2885:
2886: CURSOR l_org_id_csr IS
2887: SELECT t.org_id
2888: FROM okc_terms_templates_all t,
2889: okc_template_usages u
2890: WHERE t.template_id = u.template_id
2891: AND u.document_type = p_doc_type
2892: AND u.document_id = p_doc_id ;
2893:

Line 3113: from okc_template_usages a ,okc_terms_templates_all b

3109: select a.template_id, b.template_name, a.article_effective_date,
3110: a.doc_numbering_scheme,
3111: a.config_header_id, a.config_revision_number,
3112: a.valid_config_yn, b.org_id
3113: from okc_template_usages a ,okc_terms_templates_all b
3114: where a.template_id = b.template_id
3115: and a.document_id = p_document_id and a.document_type = p_document_type;
3116:
3117: cursor l_get_dflt_tmpl_dtls_csr is

Line 3214: UPDATE okc_template_usages

3210: l_update_date := true;
3211: l_update_date_with := p_eff_date;
3212: end if;
3213: if(l_update_date) then
3214: UPDATE okc_template_usages
3215: SET article_effective_date = l_update_date_with
3216: WHERE document_type = p_document_type
3217: AND document_id = p_document_id;
3218: end if;

Line 4273: UPDATE okc_template_usages

4269: -- Initialize API return status to success
4270: x_return_status := FND_API.G_RET_STS_SUCCESS;
4271:
4272: FORALL i IN p_doc_ids_tbl.FIRST..p_doc_ids_tbl.LAST
4273: UPDATE okc_template_usages
4274: SET contract_admin_id = p_new_con_admin_user_ids_tbl(i)
4275: WHERE document_id = p_doc_ids_tbl(i)
4276: AND document_type = p_doc_types_tbl(i);
4277:

Line 4567: FROM okc_template_usages usg

4563: l_terms_locked VARCHAR2(1);
4564:
4565: CURSOR l_terms_locked_csr IS
4566: SELECT lock_terms_flag
4567: FROM okc_template_usages usg
4568: WHERE usg.document_type = p_document_type
4569: AND usg.document_id = p_document_id
4570: ;
4571: BEGIN

Line 4769: okc_template_usages_v otuv,

4765: SELECT
4766: xdb.template_code
4767: FROM
4768: okc_terms_templates_all otta,
4769: okc_template_usages_v otuv,
4770: xdo_templates_b xdb
4771: WHERE otuv.document_id = p_doc_id
4772: AND otuv.document_type = p_doc_type
4773: AND otuv.template_id = otta.template_id

Line 4855: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4851: FND_MSG_PUB.initialize;
4852: END IF;
4853:
4854: x_return_status := G_RET_STS_SUCCESS;
4855: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4856: p_api_version => l_api_version,
4857: p_init_msg_list => p_init_msg_list ,
4858: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4859: p_commit => FND_API.G_FALSE,

Line 4920: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

4916: FND_MSG_PUB.initialize;
4917: END IF;
4918:
4919: x_return_status := G_RET_STS_SUCCESS;
4920: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4921: p_api_version => l_api_version,
4922: p_init_msg_list => p_init_msg_list ,
4923: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4924: p_commit => FND_API.G_FALSE,

Line 4962: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

4958: l_article_change_date date;
4959: l_section_change_date date;
4960: l_variable_change_date date;
4961: l_sys_last_update_date date;
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

Line 4985: FROM okc_template_usages

4981: AND DOCUMENT_ID = document_id);
4982:
4983: Cursor l_get_max_usg_upd_date_csr IS
4984: SELECT MAX(LAST_UPDATE_DATE)
4985: FROM okc_template_usages
4986: WHERE document_type = p_document_type
4987: AND document_id = p_document_id;
4988:
4989: Cursor l_get_contract_source_csr IS

Line 4991: FROM okc_template_usages

4987: AND document_id = p_document_id;
4988:
4989: Cursor l_get_contract_source_csr IS
4990: SELECT contract_source_code
4991: FROM okc_template_usages
4992: WHERE document_type = p_document_type
4993: AND document_id = p_document_id;
4994:
4995: BEGIN