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.PO_CONTERMS_UTL_GRP dependencies on OKC_TERMS_TEMPLATES_ALL

Line 2725: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

2721:
2722: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Apply_ConTerms';
2723: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
2724:
2725: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2726: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2727: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
2728: l_k_doc_type VARCHAR2(240);
2729: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 2726: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

2722: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Apply_ConTerms';
2723: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
2724:
2725: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2726: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2727: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
2728: l_k_doc_type VARCHAR2(240);
2729: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
2730: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095

Line 2727: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;

2723: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
2724:
2725: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
2726: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
2727: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
2728: l_k_doc_type VARCHAR2(240);
2729: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
2730: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
2731: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095

Line 2999: l_template_desc okc_terms_templates_all.description%TYPE;

2995: x_return_status OUT NOCOPY VARCHAR2) IS
2996:
2997: l_api_name CONSTANT VARCHAR2 (30) := 'get_def_proc_contract_info';
2998: l_log_head CONSTANT VARCHAR2 (100) := g_log_head || l_api_name;
2999: l_template_desc okc_terms_templates_all.description%TYPE;
3000: l_contract_source VARCHAR2(2000);
3001: l_k_doc_type VARCHAR2 (240);
3002: l_msg_data VARCHAR2 (2000);
3003: l_msg_count NUMBER;

Line 3202: l_template_desc okc_terms_templates_all.description%TYPE;

3198:
3199: l_api_version CONSTANT NUMBER := 1;
3200: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Contract_Details';
3201: l_log_head CONSTANT VARCHAR2 (100) := g_log_head || l_api_name;
3202: l_template_desc okc_terms_templates_all.description%TYPE;
3203: l_contract_source VARCHAR2(2000);
3204: l_k_doc_type VARCHAR2(240);
3205: l_msg_data VARCHAR2(2000);
3206: l_msg_count NUMBER;

Line 3208: l_template_name_none_msg okc_terms_templates_all.template_name%TYPE;

3204: l_k_doc_type VARCHAR2(240);
3205: l_msg_data VARCHAR2(2000);
3206: l_msg_count NUMBER;
3207: l_progress NUMBER := 0;
3208: l_template_name_none_msg okc_terms_templates_all.template_name%TYPE;
3209: l_authoring_party_none_msg okc_template_usages.authoring_party_code%TYPE;
3210: BEGIN
3211:
3212: