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 FND_DOCUMENTS_TL

Line 2862: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.

2858: END IF;
2859: RETURN 'E';
2860: END Is_Primary_Terms_Doc_Mergeable;
2861:
2862: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.
2863: -- 0 if document is mergeable.
2864: -- -1 if no primary document exists.
2865: FUNCTION Get_Primary_Terms_Doc_File_Id(
2866: p_document_type IN VARCHAR2,

Line 3146: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;

3142: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;
3143: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3144: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3145: l_generated_flag VARCHAR2(1) := '?';
3146: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3147: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3148: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3149:
3150: CURSOR terms_tmpl_csr IS

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

3174:
3175: CURSOR contract_doc_csr IS
3176: SELECT tl.media_id ,
3177: docs.generated_flag
3178: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3179: WHERE docs.primary_contract_doc_flag = 'Y'
3180: AND docs.business_document_version=-99
3181: AND docs.business_document_type = p_document_type
3182: AND docs.business_document_id = p_document_id

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

3214: --Bug 4131467 Added cursor to fetch attachment details from history table if document_version is passed
3215: CURSOR contract_doc_ver_csr IS
3216: SELECT tl.media_id ,
3217: docs.generated_flag
3218: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3219: WHERE docs.primary_contract_doc_flag = 'Y'
3220: AND docs.business_document_version = p_document_version
3221: AND docs.business_document_type = p_document_type
3222: AND docs.business_document_id = p_document_id

Line 3835: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;

3831: and category_code = 'OKC_REPO_APPROVAL_ABSTRACT'
3832: and datatype_id = 6;
3833:
3834: l_file_id VARCHAR2(2000):= NULL;
3835: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3836:
3837: BEGIN
3838: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3839: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Deviations_File_Id ');