3100: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
3101: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
3102: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3103: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3104: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3105: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3106:
3107: CURSOR terms_tmpl_csr IS
3108: SELECT tu.document_id,
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
3261: SELECT tu.document_id,