DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_RESP_PARTIES_TL

Line 2994: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;

2990: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2991: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
2992: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
2993: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
2994: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
2995: l_contract_source FND_LOOKUPS.MEANING%TYPE;
2996:
2997: CURSOR terms_tmpl_csr IS
2998: SELECT tu.document_id,

Line 3147: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;

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
3151: SELECT tu.document_id,