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_GRP dependencies on OKC_CONTRACT_DOCS

Line 174: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(

170: -- Call attachement API to delete attachements from the document.
171: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Delete attachments for the doc');
173: END IF;
174: OKC_CONTRACT_DOCS_GRP.Delete_Ver_Attachments(
175: p_api_version => l_api_version,
176: p_init_msg_list => FND_API.G_FALSE,
177: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
178: p_commit => FND_API.G_FALSE,

Line 426: OKC_CONTRACT_DOCS_GRP.Delete_doc_Attachments(

422: END IF;
423: IF p_doc_tbl.COUNT > 0 THEN
424: FOR i in p_doc_tbl.FIRST..p_doc_tbl.LAST LOOP
425:
426: OKC_CONTRACT_DOCS_GRP.Delete_doc_Attachments(
427: p_api_version => l_api_version,
428: p_init_msg_list => FND_API.G_FALSE,
429: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
430: p_commit => FND_API.G_FALSE,

Line 2960: RETURN OKC_CONTRACT_DOCS_GRP.is_primary_terms_doc_mergeable(

2956: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2957: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Is_Primary_Terms_Doc_Mergeable');
2958: END IF;
2959:
2960: RETURN OKC_CONTRACT_DOCS_GRP.is_primary_terms_doc_mergeable(
2961: p_document_type => p_document_type,
2962: p_document_id => p_document_id );
2963:
2964: EXCEPTION

Line 2985: RETURN OKC_CONTRACT_DOCS_GRP.get_primary_terms_doc_file_id(

2981: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2982: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Primary_Terms_Doc_File_Id');
2983: END IF;
2984:
2985: RETURN OKC_CONTRACT_DOCS_GRP.get_primary_terms_doc_file_id(
2986: p_document_type => p_document_type,
2987: p_document_id => p_document_id );
2988:
2989: EXCEPTION

Line 3062: RETURN OKC_CONTRACT_DOCS_GRP.has_primary_contract_doc(

3058: RETURN 'N';
3059: ELSIF l_contract_source_code = 'STRUCTURED' THEN
3060: RETURN 'Y';
3061: ELSIF l_contract_source_code = 'ATTACHED' THEN
3062: RETURN OKC_CONTRACT_DOCS_GRP.has_primary_contract_doc(
3063: p_document_type => p_document_type,
3064: p_document_id => p_document_id);
3065: ELSE
3066: RETURN 'N';

Line 3288: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl

3284:
3285: CURSOR contract_doc_csr IS
3286: SELECT tl.media_id ,
3287: docs.generated_flag
3288: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3289: WHERE docs.primary_contract_doc_flag = 'Y'
3290: AND docs.business_document_version=-99
3291: AND docs.business_document_type = p_document_type
3292: AND docs.business_document_id = p_document_id

Line 3328: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl

3324: --Bug 4131467 Added cursor to fetch attachment details from history table if document_version is passed
3325: CURSOR contract_doc_ver_csr IS
3326: SELECT tl.media_id ,
3327: docs.generated_flag
3328: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3329: WHERE docs.primary_contract_doc_flag = 'Y'
3330: AND docs.business_document_version = p_document_version
3331: AND docs.business_document_type = p_document_type
3332: AND docs.business_document_id = p_document_id

Line 3391: --OKC_CONTRACT_DOCS_GRP.Get_Primary_Terms_Doc_File_Id logic has been substituted inline to improve performance.

3387: x_contract_source_code := l_contract_source_code;
3388: x_template_id := l_template_id;
3389:
3390: IF x_has_terms = 'Y' THEN
3391: --OKC_CONTRACT_DOCS_GRP.Get_Primary_Terms_Doc_File_Id logic has been substituted inline to improve performance.
3392: IF p_document_version is not NULL THEN
3393: --Doc version has been specified, fetch from history tables.
3394: -- Fix for bug# 4282242. The following block of code was missing in previous checkin 115.42.11510.11 .
3395: OPEN contract_doc_ver_csr;

Line 3938: select media_id from okc_contract_docs_details_vl

3934: ) RETURN VARCHAR2 IS
3935: l_api_name CONSTANT VARCHAR2(30) := 'Get_Deviations_File_Id';
3936:
3937: CURSOR doc_details_csr IS
3938: select media_id from okc_contract_docs_details_vl
3939: where business_document_id = p_document_id
3940: and business_document_type = p_document_type
3941: and category_code = 'OKC_REPO_APPROVAL_ABSTRACT'
3942: and datatype_id = 6;

Line 4142: FROM okc_contract_docs

4138: AND document_type = p_doc_type;
4139:
4140: CURSOR primary_kdoc_csr IS
4141: SELECT 'Y'
4142: FROM okc_contract_docs
4143: WHERE business_document_id = p_doc_id
4144: AND business_document_type = p_doc_type
4145: AND business_document_version = -99
4146: AND effective_from_id = business_document_id

Line 4152: FROM okc_contract_docs

4148: AND effective_from_version = business_document_version
4149: AND primary_contract_doc_flag = 'Y'
4150: UNION ALL
4151: SELECT 'Y'
4152: FROM okc_contract_docs
4153: WHERE business_document_id = p_doc_id
4154: AND business_document_type = p_doc_type
4155: AND business_document_version = -99
4156: AND delete_flag = 'Y'