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_COPY_PVT dependencies on OKC_TEMPLATE_USAGES

Line 16: G_ATTACHED_CONTRACT_SOURCE CONSTANT okc_template_usages.contract_source_code%TYPE := 'ATTACHED';

12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_PVT';
13: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_TEMPLATE_DOC_TYPE CONSTANT okc_bus_doc_types_b.document_type%TYPE := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
16: G_ATTACHED_CONTRACT_SOURCE CONSTANT okc_template_usages.contract_source_code%TYPE := 'ATTACHED';
17:
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------

Line 2058: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;

2054: l_no_terms_found BOOLEAN :=FALSE;
2055: l_tmpl_usage_id NUMBER;
2056: lx_tmpl_usage_id NUMBER;
2057: l_term_instantiated VARCHAR2(1);
2058: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;
2059: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2060: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2061:
2062: CURSOR l_get_allwd_tmp_usages_csr IS

Line 2059: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;

2055: l_tmpl_usage_id NUMBER;
2056: lx_tmpl_usage_id NUMBER;
2057: l_term_instantiated VARCHAR2(1);
2058: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;
2059: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2060: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2061:
2062: CURSOR l_get_allwd_tmp_usages_csr IS
2063: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES

Line 2060: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;

2056: lx_tmpl_usage_id NUMBER;
2057: l_term_instantiated VARCHAR2(1);
2058: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;
2059: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2060: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2061:
2062: CURSOR l_get_allwd_tmp_usages_csr IS
2063: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES
2064: WHERE template_id=p_source_doc_id

Line 2076: SELECT '!' FROM OKC_TEMPLATE_USAGES

2072: SELECT name FROM OKC_BUS_DOC_TYPES_V
2073: WHERE document_type = p_target_doc_type;
2074:
2075: CURSOR l_check_tmp_usage_csr IS
2076: SELECT '!' FROM OKC_TEMPLATE_USAGES
2077: WHERE document_type = p_target_doc_type
2078: AND document_id = p_target_doc_id;
2079:
2080: CURSOR l_lock_usg_csr IS

Line 2081: SELECT ROWID FROM OKC_TEMPLATE_USAGES

2077: WHERE document_type = p_target_doc_type
2078: AND document_id = p_target_doc_id;
2079:
2080: CURSOR l_lock_usg_csr IS
2081: SELECT ROWID FROM OKC_TEMPLATE_USAGES
2082: WHERE DOCUMENT_TYPE=p_target_doc_type
2083: AND DOCUMENT_ID=p_target_doc_id
2084: FOR UPDATE NOWAIT;
2085:

Line 2087: SELECT * FROM OKC_TEMPLATE_USAGES

2083: AND DOCUMENT_ID=p_target_doc_id
2084: FOR UPDATE NOWAIT;
2085:
2086: CURSOR l_get_usage_csr IS
2087: SELECT * FROM OKC_TEMPLATE_USAGES
2088: WHERE DOCUMENT_TYPE=p_source_doc_type
2089: AND DOCUMENT_ID=p_source_doc_id;
2090:
2091: CURSOR l_get_target_usage IS

Line 2092: SELECT 'Y' FROM OKC_TEMPLATE_USAGES

2088: WHERE DOCUMENT_TYPE=p_source_doc_type
2089: AND DOCUMENT_ID=p_source_doc_id;
2090:
2091: CURSOR l_get_target_usage IS
2092: SELECT 'Y' FROM OKC_TEMPLATE_USAGES
2093: WHERE DOCUMENT_TYPE=p_target_doc_type
2094: AND DOCUMENT_ID=p_target_doc_id;
2095:
2096: CURSOR l_get_allwd_usage_csr(b_source_doc_id NUMBER) IS

Line 2451: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

2447: end if;
2448: if(l_legal_contact_id is null) then
2449: l_legal_contact_id := l_usage_rec.legal_contact_id;
2450: end if;
2451: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
2452: p_api_version => 1,
2453: p_init_msg_list => FND_API.G_FALSE,
2454: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2455: p_commit => FND_API.G_FALSE,

Line 2484: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600:After call to OKC_TEMPLATE_USAGES_GRP.create_template_usages x_return_status : '||x_return_status);

2480: p_contract_admin_id => l_contract_admin_id,
2481: p_legal_contact_id => l_legal_contact_id
2482: );
2483: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2484: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600:After call to OKC_TEMPLATE_USAGES_GRP.create_template_usages x_return_status : '||x_return_status);
2485: END IF;
2486: END IF; -- IF p_allow_duplicates <> Y' THEN
2487:
2488: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:Update the existing OKC_TEMPLATE_USAGES record with new template id : '||p_source_doc_id);

2641: OPEN l_lock_usg_csr;
2642: CLOSE l_lock_usg_csr;
2643:
2644: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:Update the existing OKC_TEMPLATE_USAGES record with new template id : '||p_source_doc_id);
2646: END IF;
2647:
2648: --Added in 10+ word integration, update values for contract_source_code and authoring_party_code
2649: UPDATE OKC_TEMPLATE_USAGES

Line 2649: UPDATE OKC_TEMPLATE_USAGES

2645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400:Update the existing OKC_TEMPLATE_USAGES record with new template id : '||p_source_doc_id);
2646: END IF;
2647:
2648: --Added in 10+ word integration, update values for contract_source_code and authoring_party_code
2649: UPDATE OKC_TEMPLATE_USAGES
2650: SET TEMPLATE_ID = p_source_doc_id,
2651: DOC_NUMBERING_SCHEME = l_tmpl_rec.tmpl_numbering_scheme,
2652: ARTICLE_EFFECTIVE_DATE = p_article_effective_date, -- To Check and confirm with PMs
2653: CONFIG_HEADER_ID = NULL,

Line 2691: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

2687: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2688: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500:Create template usage record ');
2689: END IF;
2690:
2691: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
2692: p_api_version => 1,
2693: p_init_msg_list => FND_API.G_FALSE,
2694: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2695: p_commit => FND_API.G_FALSE,

Line 2715: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500:After call to OKC_TEMPLATE_USAGES_GRP.create_template_usages x_return_status: '||x_return_status);

2711: x_document_id => l_document_id
2712: );
2713:
2714: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2715: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500:After call to OKC_TEMPLATE_USAGES_GRP.create_template_usages x_return_status: '||x_return_status);
2716: END IF;
2717:
2718: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 2995: SELECT * FROM OKC_TEMPLATE_USAGES_H

2991: l_document_id NUMBER;
2992: l_term_found VARCHAR2(1):= NULL;
2993:
2994: CURSOR l_get_usage_csr IS
2995: SELECT * FROM OKC_TEMPLATE_USAGES_H
2996: WHERE DOCUMENT_TYPE=p_source_doc_type
2997: AND DOCUMENT_ID=p_source_doc_id
2998: AND MAJOR_VERSION=p_source_version_number;
2999:

Line 3001: SELECT 'Y' FROM OKC_TEMPLATE_USAGES

2997: AND DOCUMENT_ID=p_source_doc_id
2998: AND MAJOR_VERSION=p_source_version_number;
2999:
3000: CURSOR l_get_target_usage IS
3001: SELECT 'Y' FROM OKC_TEMPLATE_USAGES
3002: WHERE DOCUMENT_TYPE=p_target_doc_type
3003: AND DOCUMENT_ID=p_target_doc_id;
3004:
3005: CURSOR l_get_variables_csr IS

Line 3100: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

3096: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3097: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200:Create usage record ');
3098: END IF;
3099:
3100: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3101: p_api_version => 1,
3102: p_init_msg_list => FND_API.G_FALSE,
3103: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3104: p_commit => FND_API.G_FALSE,