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 3071: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

3067:
3068: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Apply_ConTerms';
3069: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
3070:
3071: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
3072: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 3072: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

3068: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Apply_ConTerms';
3069: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
3070:
3071: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
3072: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095

Line 3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;

3069: l_log_head CONSTANT VARCHAR2(100) := g_log_head||l_api_name;
3070:
3071: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
3072: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
3073: l_template_desc OKC_TERMS_TEMPLATES_ALL.description%TYPE;
3074: l_k_doc_type VARCHAR2(240);
3075: l_document_type PO_HEADERS_ALL.type_lookup_code%TYPE;
3076: l_doc_number PO_HEADERS_ALL.segment1%TYPE; -- Bug 4096095
3077: l_agent_id PO_HEADERS_ALL.agent_id%TYPE; -- Bug 4096095

Line 3581: l_template_desc okc_terms_templates_all.description%TYPE;

3577: x_return_status OUT NOCOPY VARCHAR2) IS
3578:
3579: l_api_name CONSTANT VARCHAR2 (30) := 'get_def_proc_contract_info';
3580: l_log_head CONSTANT VARCHAR2 (100) := g_log_head || l_api_name;
3581: l_template_desc okc_terms_templates_all.description%TYPE;
3582: l_contract_source VARCHAR2(2000);
3583: l_k_doc_type VARCHAR2 (240);
3584: l_msg_data VARCHAR2 (2000);
3585: l_msg_count NUMBER;

Line 3784: l_template_desc okc_terms_templates_all.description%TYPE;

3780:
3781: l_api_version CONSTANT NUMBER := 1;
3782: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Contract_Details';
3783: l_log_head CONSTANT VARCHAR2 (100) := g_log_head || l_api_name;
3784: l_template_desc okc_terms_templates_all.description%TYPE;
3785: l_contract_source VARCHAR2(2000);
3786: l_k_doc_type VARCHAR2(240);
3787: l_msg_data VARCHAR2(2000);
3788: l_msg_count NUMBER;

Line 3790: l_template_name_none_msg okc_terms_templates_all.template_name%TYPE;

3786: l_k_doc_type VARCHAR2(240);
3787: l_msg_data VARCHAR2(2000);
3788: l_msg_count NUMBER;
3789: l_progress NUMBER := 0;
3790: l_template_name_none_msg okc_terms_templates_all.template_name%TYPE;
3791: l_authoring_party_none_msg okc_template_usages.authoring_party_code%TYPE;
3792: BEGIN
3793:
3794: