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 2429: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Delete a record from okc_template_usages for the doc');

2425:
2426: /*kkolukul: clm changes- Delete entries from multiple templates table*/
2427:
2428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2429: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Delete a record from okc_template_usages for the doc');
2430: END IF;
2431:
2432: l_objnum := -1;
2433: OPEN objnum_mlp_tu_csr;

Line 2629: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;

2625: l_no_terms_found BOOLEAN :=FALSE;
2626: l_tmpl_usage_id NUMBER;
2627: lx_tmpl_usage_id NUMBER;
2628: l_term_instantiated VARCHAR2(1);
2629: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;
2630: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2631: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2632:
2633: CURSOR l_get_allwd_tmp_usages_csr IS

Line 2630: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;

2626: l_tmpl_usage_id NUMBER;
2627: lx_tmpl_usage_id NUMBER;
2628: l_term_instantiated VARCHAR2(1);
2629: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;
2630: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2631: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2632:
2633: CURSOR l_get_allwd_tmp_usages_csr IS
2634: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES

Line 2631: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;

2627: lx_tmpl_usage_id NUMBER;
2628: l_term_instantiated VARCHAR2(1);
2629: l_approval_abstract_text OKC_TEMPLATE_USAGES.APPROVAL_ABSTRACT_TEXT%TYPE;
2630: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
2631: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
2632:
2633: CURSOR l_get_allwd_tmp_usages_csr IS
2634: SELECT '!' FROM OKC_ALLOWED_TMPL_USAGES
2635: WHERE template_id=p_source_doc_id

Line 2647: SELECT '!' FROM OKC_TEMPLATE_USAGES

2643: SELECT name FROM OKC_BUS_DOC_TYPES_V
2644: WHERE document_type = p_target_doc_type;
2645:
2646: CURSOR l_check_tmp_usage_csr IS
2647: SELECT '!' FROM OKC_TEMPLATE_USAGES
2648: WHERE document_type = p_target_doc_type
2649: AND document_id = p_target_doc_id;
2650:
2651: CURSOR l_lock_usg_csr IS

Line 2652: SELECT ROWID FROM OKC_TEMPLATE_USAGES

2648: WHERE document_type = p_target_doc_type
2649: AND document_id = p_target_doc_id;
2650:
2651: CURSOR l_lock_usg_csr IS
2652: SELECT ROWID FROM OKC_TEMPLATE_USAGES
2653: WHERE DOCUMENT_TYPE=p_target_doc_type
2654: AND DOCUMENT_ID=p_target_doc_id
2655: FOR UPDATE NOWAIT;
2656:

Line 2658: SELECT * FROM OKC_TEMPLATE_USAGES

2654: AND DOCUMENT_ID=p_target_doc_id
2655: FOR UPDATE NOWAIT;
2656:
2657: CURSOR l_get_usage_csr IS
2658: SELECT * FROM OKC_TEMPLATE_USAGES
2659: WHERE DOCUMENT_TYPE=p_source_doc_type
2660: AND DOCUMENT_ID=p_source_doc_id;
2661:
2662: CURSOR l_get_tgt_usage_csr IS

Line 2663: SELECT * FROM OKC_TEMPLATE_USAGES

2659: WHERE DOCUMENT_TYPE=p_source_doc_type
2660: AND DOCUMENT_ID=p_source_doc_id;
2661:
2662: CURSOR l_get_tgt_usage_csr IS
2663: SELECT * FROM OKC_TEMPLATE_USAGES
2664: WHERE DOCUMENT_TYPE=p_target_doc_type
2665: AND DOCUMENT_ID=p_target_doc_id;
2666:
2667:

Line 2679: SELECT 'Y' FROM OKC_TEMPLATE_USAGES

2675: AND config_rev_nbr = c_config_rev_nbr;
2676: -- Bug 8246502 Changes Begins
2677:
2678: CURSOR l_get_target_usage IS
2679: SELECT 'Y' FROM OKC_TEMPLATE_USAGES
2680: WHERE DOCUMENT_TYPE=p_target_doc_type
2681: AND DOCUMENT_ID=p_target_doc_id;
2682:
2683: CURSOR l_get_allwd_usage_csr(b_source_doc_id NUMBER) IS

Line 3132: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

3128: l_usage_rec.config_revision_number:=NULL;
3129: l_usage_rec.valid_config_yn:=NULL;
3130: end if;
3131: IF l_copy_xprt_data = 'Y' THEN --
3132: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3133: p_api_version => 1,
3134: p_init_msg_list => FND_API.G_FALSE,
3135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3136: p_commit => FND_API.G_FALSE,

Line 3170: 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);

3166: --new okc rules engine contract expert parameter
3167: p_contract_expert_finish_flag => l_usage_rec.contract_expert_finish_flag
3168: );
3169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3170: 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);
3171: END IF;
3172: ELSIF Nvl(l_copy_xprt_data,'N') = 'N' THEN
3173: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
3174: p_api_version => 1,

Line 3173: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

3169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3170: 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);
3171: END IF;
3172: ELSIF Nvl(l_copy_xprt_data,'N') = 'N' THEN
3173: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
3174: p_api_version => 1,
3175: p_init_msg_list => FND_API.G_FALSE,
3176: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3177: p_commit => FND_API.G_FALSE,

Line 3206: 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);

3202: );
3203:
3204:
3205: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3206: 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);
3207: END IF;
3208:
3209: END IF;
3210:

Line 3398: 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);

3394: OPEN l_lock_usg_csr;
3395: CLOSE l_lock_usg_csr;
3396:
3397: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3398: 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);
3399: END IF;
3400:
3401: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
3402:

Line 3404: UPDATE OKC_TEMPLATE_USAGES

3400:
3401: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
3402:
3403: --Added in 10+ word integration, update values for contract_source_code and authoring_party_code
3404: UPDATE OKC_TEMPLATE_USAGES
3405: SET TEMPLATE_ID = p_source_doc_id,
3406: DOC_NUMBERING_SCHEME = l_tmpl_rec.tmpl_numbering_scheme,
3407: ARTICLE_EFFECTIVE_DATE = p_article_effective_date, -- To Check and confirm with PMs
3408: CONTRACT_EXPERT_FINISH_FLAG = 'N',

Line 3431: UPDATE OKC_TEMPLATE_USAGES

3427:
3428: ELSE --configurator rule engine
3429:
3430: --Added in 10+ word integration, update values for contract_source_code and authoring_party_code
3431: UPDATE OKC_TEMPLATE_USAGES
3432: SET TEMPLATE_ID = p_source_doc_id,
3433: DOC_NUMBERING_SCHEME = l_tmpl_rec.tmpl_numbering_scheme,
3434: ARTICLE_EFFECTIVE_DATE = p_article_effective_date, -- To Check and confirm with PMs
3435: CONFIG_HEADER_ID = NULL,

Line 3498: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

3494: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3495: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500:Create template usage record ');
3496: END IF;
3497:
3498: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3499: p_api_version => 1,
3500: p_init_msg_list => FND_API.G_FALSE,
3501: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3502: p_commit => FND_API.G_FALSE,

Line 3522: 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);

3518: x_document_id => l_document_id
3519: );
3520:
3521: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3522: 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);
3523: END IF;
3524:
3525: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 3810: SELECT * FROM OKC_TEMPLATE_USAGES_H

3806: l_document_id NUMBER;
3807: l_term_found VARCHAR2(1):= NULL;
3808:
3809: CURSOR l_get_usage_csr IS
3810: SELECT * FROM OKC_TEMPLATE_USAGES_H
3811: WHERE DOCUMENT_TYPE=p_source_doc_type
3812: AND DOCUMENT_ID=p_source_doc_id
3813: AND MAJOR_VERSION=p_source_version_number;
3814:

Line 3816: SELECT 'Y' FROM OKC_TEMPLATE_USAGES

3812: AND DOCUMENT_ID=p_source_doc_id
3813: AND MAJOR_VERSION=p_source_version_number;
3814:
3815: CURSOR l_get_target_usage IS
3816: SELECT 'Y' FROM OKC_TEMPLATE_USAGES
3817: WHERE DOCUMENT_TYPE=p_target_doc_type
3818: AND DOCUMENT_ID=p_target_doc_id;
3819:
3820: CURSOR l_get_variables_csr IS

Line 3925: OKC_TEMPLATE_USAGES_GRP.create_template_usages(

3921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200:Create usage record ');
3923: END IF;
3924:
3925: OKC_TEMPLATE_USAGES_GRP.create_template_usages(
3926: p_api_version => 1,
3927: p_init_msg_list => FND_API.G_FALSE,
3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3929: p_commit => FND_API.G_FALSE,