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

Line 766: FROM okc_terms_templates_all t,

762: Decode( NVL(t.ORG_ID,p_org_id), p_org_id,G_TRUE, G_FALSE)
763: ,G_FALSE)
764: ,G_FALSE)
765: ) upd
766: FROM okc_terms_templates_all t,
767: (SELECT Count(*) cnt FROM OKC_TERMS_TEMPLATES_ALL i WHERE i.PARENT_TEMPLATE_ID = p_doc_id) c
768: WHERE template_id = p_doc_id;
769:
770: --11.5.10+ code changes for COntract Repository Start

Line 767: (SELECT Count(*) cnt FROM OKC_TERMS_TEMPLATES_ALL i WHERE i.PARENT_TEMPLATE_ID = p_doc_id) c

763: ,G_FALSE)
764: ,G_FALSE)
765: ) upd
766: FROM okc_terms_templates_all t,
767: (SELECT Count(*) cnt FROM OKC_TERMS_TEMPLATES_ALL i WHERE i.PARENT_TEMPLATE_ID = p_doc_id) c
768: WHERE template_id = p_doc_id;
769:
770: --11.5.10+ code changes for COntract Repository Start
771: CURSOR doc_class_cur IS

Line 1010: okc_terms_templates_all t

1006:
1007: CURSOR find_tmpl_crs IS
1008: SELECT 'Y'
1009: FROM okc_template_usages_v tu,
1010: okc_terms_templates_all t
1011: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1012: AND t.template_id = tu.template_id AND t.status_code = 'APPROVED'
1013: AND nvl(t.end_date,sysdate+1) <= sysdate;
1014:

Line 1319: FROM okc_template_usages_v tu, okc_terms_templates_all t

1315: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1316:
1317: CURSOR find_tmpl_crs IS
1318: SELECT t.template_id, t.template_name
1319: FROM okc_template_usages_v tu, okc_terms_templates_all t
1320: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1321: AND t.template_id = tu.template_id;
1322:
1323: BEGIN

Line 1787: FROM okc_terms_templates_all

1783: FROM okc_bus_doc_types_b
1784: WHERE document_type=p_doc_type;
1785: CURSOR l_tmpl_csr IS
1786: SELECT status_code,nvl(end_date,sysdate+1) end_date
1787: FROM okc_terms_templates_all
1788: WHERE template_id = p_doc_id;
1789: BEGIN
1790:
1791: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2177: FROM okc_terms_templates_all

2173: l_return_value VARCHAR2(500);
2174:
2175: CURSOR c_get_template_name IS
2176: SELECT template_name
2177: FROM okc_terms_templates_all
2178: WHERE template_id = p_template_id;
2179: BEGIN
2180: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2181: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: Get_Template_Name');

Line 2267: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

2263: Function Get_Terms_Template(
2264: p_doc_type IN VARCHAR2,
2265: p_doc_id IN NUMBER
2266: ) Return varchar2 IS
2267: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2268: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2269: l_return_status Varchar2(1);
2270: l_msg_count NUMBER;
2271: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2268: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

2264: p_doc_type IN VARCHAR2,
2265: p_doc_id IN NUMBER
2266: ) Return varchar2 IS
2267: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2268: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2269: l_return_status Varchar2(1);
2270: l_msg_count NUMBER;
2271: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2272: BEGIN

Line 2569: FROM okc_terms_templates_all

2565: description ,
2566: global_flag ,
2567: contract_expert_enabled,
2568: org_id
2569: FROM okc_terms_templates_all
2570: where template_id=b_template_id;
2571: BEGIN
2572: x_return_status := G_RET_STS_SUCCESS;
2573: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2683: FROM okc_template_usages_v tu, okc_terms_templates_all t

2679: SELECT t.template_id,
2680: t.template_name,
2681: t.instruction_text ,
2682: t.description
2683: FROM okc_template_usages_v tu, okc_terms_templates_all t
2684: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
2685: AND t.template_id = tu.template_id;
2686:
2687: BEGIN

Line 2988: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

2984: ) IS
2985:
2986: l_api_version CONSTANT NUMBER := 1;
2987: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details';
2988: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2989: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%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;

Line 2989: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;

2985:
2986: l_api_version CONSTANT NUMBER := 1;
2987: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details';
2988: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2989: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%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;

Line 2990: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

2986: l_api_version CONSTANT NUMBER := 1;
2987: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details';
2988: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2989: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%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;

Line 3007: OKC_TERMS_TEMPLATES_ALL t,

3003: t.description,
3004: party.alternate_name authoring_party,
3005: src.meaning contract_source
3006: FROM OKC_TEMPLATE_USAGES tu,
3007: OKC_TERMS_TEMPLATES_ALL t,
3008: okc_resp_parties_vl party,
3009: okc_bus_doc_types_b doc,
3010: fnd_lookups src
3011: WHERE t.template_id(+) = tu.template_id

Line 3138: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

3134: ) IS
3135:
3136: l_api_version CONSTANT NUMBER := 1;
3137: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details_All';
3138: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3139: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
3140: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
3141: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
3142: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;

Line 3139: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;

3135:
3136: l_api_version CONSTANT NUMBER := 1;
3137: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details_All';
3138: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3139: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
3140: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
3141: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
3142: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;
3143: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

Line 3140: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;

3136: l_api_version CONSTANT NUMBER := 1;
3137: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details_All';
3138: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3139: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
3140: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
3141: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
3142: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;
3143: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3144: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

Line 3161: OKC_TERMS_TEMPLATES_ALL t,

3157: t.instruction_text,
3158: party.alternate_name authoring_party,
3159: src.meaning contract_source
3160: FROM OKC_TEMPLATE_USAGES tu,
3161: OKC_TERMS_TEMPLATES_ALL t,
3162: okc_resp_parties_vl party,
3163: okc_bus_doc_types_b doc,
3164: fnd_lookups src
3165: WHERE t.template_id(+) = tu.template_id

Line 3199: OKC_TERMS_TEMPLATES_ALL t,

3195: t.instruction_text,
3196: party.alternate_name authoring_party,
3197: src.meaning contract_source
3198: FROM OKC_TEMPLATE_USAGES_H tu,
3199: OKC_TERMS_TEMPLATES_ALL t,
3200: okc_resp_parties_vl party,
3201: okc_bus_doc_types_b doc,
3202: fnd_lookups src
3203: WHERE t.template_id(+) = tu.template_id

Line 3470: FROM OKC_TERMS_TEMPLATES_ALL tmpl,

3466: ) RETURN VARCHAR2 IS
3467:
3468: CURSOR terms_tmpl_csr IS
3469: SELECT 'Y'
3470: FROM OKC_TERMS_TEMPLATES_ALL tmpl,
3471: OKC_ALLOWED_TMPL_USAGES usg,
3472: OKC_BUS_DOC_TYPES_B doc
3473: WHERE tmpl.template_id = p_template_id
3474: AND doc.document_type = p_doc_type

Line 3580: FROM okc_terms_templates_all tmpl,

3576: SELECT tmpl.template_name,
3577: tmpl.description,
3578: okc_util.decode_lookup('OKC_CONTRACT_TERMS_SOURCES','STRUCTURED'),
3579: party.alternate_name
3580: FROM okc_terms_templates_all tmpl,
3581: okc_resp_parties_vl party,
3582: okc_bus_doc_types_b doc
3583: WHERE tmpl.template_id = p_template_id
3584: and party.document_type_class = doc.document_type_class

Line 3696: FROM OKC_TERMS_TEMPLATES_ALL tmpl,

3692: CURSOR terms_tmpl_csr IS
3693: SELECT tmpl.template_id,
3694: tmpl.template_name,
3695: tmpl.description
3696: FROM OKC_TERMS_TEMPLATES_ALL tmpl,
3697: OKC_ALLOWED_TMPL_USAGES usg,
3698: OKC_BUS_DOC_TYPES_B doc
3699: WHERE doc.document_type = p_document_type
3700: AND doc.intent = tmpl.intent

Line 4158: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;

4154: ) IS
4155:
4156: l_api_version CONSTANT NUMBER := 1;
4157: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4158: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4159: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4160: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4161: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4162:

Line 4159: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;

4155:
4156: l_api_version CONSTANT NUMBER := 1;
4157: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4158: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4159: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4160: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4161: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4162:
4163: CURSOR l_tmpl_csr IS

Line 4160: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;

4156: l_api_version CONSTANT NUMBER := 1;
4157: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4158: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4159: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4160: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4161: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4162:
4163: CURSOR l_tmpl_csr IS
4164: SELECT translated_from_tmpl_id, language, org_id, parent_template_id

Line 4161: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;

4157: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4158: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4159: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4160: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4161: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4162:
4163: CURSOR l_tmpl_csr IS
4164: SELECT translated_from_tmpl_id, language, org_id, parent_template_id
4165: FROM okc_terms_templates_all

Line 4165: FROM okc_terms_templates_all

4161: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4162:
4163: CURSOR l_tmpl_csr IS
4164: SELECT translated_from_tmpl_id, language, org_id, parent_template_id
4165: FROM okc_terms_templates_all
4166: WHERE template_id = p_template_id;
4167:
4168: CURSOR l_translated_csr( l_tmpl_id in number,l_org_id in number) IS
4169: SELECT template_id

Line 4170: FROM okc_terms_templates_all

4166: WHERE template_id = p_template_id;
4167:
4168: CURSOR l_translated_csr( l_tmpl_id in number,l_org_id in number) IS
4169: SELECT template_id
4170: FROM okc_terms_templates_all
4171: WHERE language = p_language
4172: AND org_id = l_org_id
4173: AND template_id = l_tmpl_id
4174: UNION ALL

Line 4176: FROM okc_terms_templates_all

4172: AND org_id = l_org_id
4173: AND template_id = l_tmpl_id
4174: UNION ALL
4175: SELECT template_id
4176: FROM okc_terms_templates_all
4177: WHERE language = p_language
4178: AND org_id = l_org_id
4179: AND translated_from_tmpl_id = l_tmpl_id;
4180: