APPS.OKC_TERMS_UTIL_GRP dependencies on FND_DOCUMENTS_TL

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

2968: END IF;
2969: RETURN 'E';
2970: END Is_Primary_Terms_Doc_Mergeable;
2971:
2972: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.
2973: -- 0 if document is mergeable.
2974: -- -1 if no primary document exists.
2975: FUNCTION Get_Primary_Terms_Doc_File_Id(
2976: p_document_type IN VARCHAR2,

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

3252: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;
3253: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3254: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3255: l_generated_flag VARCHAR2(1) := '?';
3256: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3257: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3258: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3259:
3260: CURSOR terms_tmpl_csr IS

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 3945: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;

3941: and category_code = 'OKC_REPO_APPROVAL_ABSTRACT'
3942: and datatype_id = 6;
3943:
3944: l_file_id VARCHAR2(2000):= NULL;
3945: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3946:
3947: BEGIN
3948: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3949: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Deviations_File_Id ');