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 857: FROM okc_terms_templates_all t,

853: Decode( NVL(t.ORG_ID,p_org_id), p_org_id,G_TRUE, G_FALSE)
854: ,G_FALSE)
855: ,G_FALSE)
856: ) upd
857: FROM okc_terms_templates_all t,
858: (SELECT Count(*) cnt FROM OKC_TERMS_TEMPLATES_ALL i WHERE i.PARENT_TEMPLATE_ID = p_doc_id) c
859: WHERE template_id = p_doc_id;
860:
861: --11.5.10+ code changes for COntract Repository Start

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

854: ,G_FALSE)
855: ,G_FALSE)
856: ) upd
857: FROM okc_terms_templates_all t,
858: (SELECT Count(*) cnt FROM OKC_TERMS_TEMPLATES_ALL i WHERE i.PARENT_TEMPLATE_ID = p_doc_id) c
859: WHERE template_id = p_doc_id;
860:
861: --11.5.10+ code changes for COntract Repository Start
862: CURSOR doc_class_cur IS

Line 1114: okc_terms_templates_all t

1110:
1111: CURSOR find_tmpl_crs IS
1112: SELECT 'Y'
1113: FROM okc_template_usages_v tu,
1114: okc_terms_templates_all t
1115: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1116: AND t.template_id = tu.template_id AND t.status_code = 'APPROVED'
1117: AND nvl(t.end_date,sysdate+1) <= sysdate;
1118:

Line 1423: FROM okc_template_usages_v tu, okc_terms_templates_all t

1419: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1420:
1421: CURSOR find_tmpl_crs IS
1422: SELECT t.template_id, t.template_name
1423: FROM okc_template_usages_v tu, okc_terms_templates_all t
1424: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
1425: AND t.template_id = tu.template_id;
1426:
1427: BEGIN

Line 1893: FROM okc_terms_templates_all

1889: FROM okc_bus_doc_types_b
1890: WHERE document_type=p_doc_type;
1891: CURSOR l_tmpl_csr IS
1892: SELECT status_code,nvl(end_date,sysdate+1) end_date
1893: FROM okc_terms_templates_all
1894: WHERE template_id = p_doc_id;
1895: BEGIN
1896:
1897: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2286: FROM okc_terms_templates_all

2282: l_return_value VARCHAR2(500);
2283:
2284: CURSOR c_get_template_name IS
2285: SELECT template_name
2286: FROM okc_terms_templates_all
2287: WHERE template_id = p_template_id;
2288: BEGIN
2289: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14700: Get_Template_Name');

Line 2376: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

2372: Function Get_Terms_Template(
2373: p_doc_type IN VARCHAR2,
2374: p_doc_id IN NUMBER
2375: ) Return varchar2 IS
2376: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2377: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2378: l_return_status Varchar2(1);
2379: l_msg_count NUMBER;
2380: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2377: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

2373: p_doc_type IN VARCHAR2,
2374: p_doc_id IN NUMBER
2375: ) Return varchar2 IS
2376: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2377: l_template_ID OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2378: l_return_status Varchar2(1);
2379: l_msg_count NUMBER;
2380: l_msg_data FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
2381: BEGIN

Line 2679: FROM okc_terms_templates_all

2675: description ,
2676: global_flag ,
2677: contract_expert_enabled,
2678: org_id
2679: FROM okc_terms_templates_all
2680: where template_id=b_template_id;
2681: BEGIN
2682: x_return_status := G_RET_STS_SUCCESS;
2683: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2793: FROM okc_template_usages_v tu, okc_terms_templates_all t

2789: SELECT t.template_id,
2790: t.template_name,
2791: t.instruction_text ,
2792: t.description
2793: FROM okc_template_usages_v tu, okc_terms_templates_all t
2794: WHERE tu.document_type = p_doc_type AND tu.document_id = p_doc_id
2795: AND t.template_id = tu.template_id;
2796:
2797: BEGIN

Line 3098: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

3094: ) IS
3095:
3096: l_api_version CONSTANT NUMBER := 1;
3097: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details';
3098: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3099: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
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;

Line 3099: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;

3095:
3096: l_api_version CONSTANT NUMBER := 1;
3097: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details';
3098: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3099: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
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;

Line 3100: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;

3096: l_api_version CONSTANT NUMBER := 1;
3097: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details';
3098: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3099: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
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;

Line 3117: OKC_TERMS_TEMPLATES_ALL t,

3113: t.description,
3114: party.alternate_name authoring_party,
3115: src.meaning contract_source
3116: FROM OKC_TEMPLATE_USAGES tu,
3117: OKC_TERMS_TEMPLATES_ALL t,
3118: okc_resp_parties_vl party,
3119: okc_bus_doc_types_b doc,
3120: fnd_lookups src
3121: WHERE t.template_id(+) = tu.template_id

Line 3248: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;

3244: ) IS
3245:
3246: l_api_version CONSTANT NUMBER := 1;
3247: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details_All';
3248: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3249: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
3250: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
3251: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
3252: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;

Line 3249: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;

3245:
3246: l_api_version CONSTANT NUMBER := 1;
3247: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details_All';
3248: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3249: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
3250: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
3251: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
3252: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;
3253: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

Line 3250: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;

3246: l_api_version CONSTANT NUMBER := 1;
3247: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Details_All';
3248: l_tmpl_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
3249: l_template_desc OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
3250: l_instruction OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
3251: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;
3252: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;
3253: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3254: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

Line 3271: OKC_TERMS_TEMPLATES_ALL t,

3267: t.instruction_text,
3268: party.alternate_name authoring_party,
3269: src.meaning contract_source
3270: FROM OKC_TEMPLATE_USAGES tu,
3271: OKC_TERMS_TEMPLATES_ALL t,
3272: okc_resp_parties_vl party,
3273: okc_bus_doc_types_b doc,
3274: fnd_lookups src
3275: WHERE t.template_id(+) = tu.template_id

Line 3309: OKC_TERMS_TEMPLATES_ALL t,

3305: t.instruction_text,
3306: party.alternate_name authoring_party,
3307: src.meaning contract_source
3308: FROM OKC_TEMPLATE_USAGES_H tu,
3309: OKC_TERMS_TEMPLATES_ALL t,
3310: okc_resp_parties_vl party,
3311: okc_bus_doc_types_b doc,
3312: fnd_lookups src
3313: WHERE t.template_id(+) = tu.template_id

Line 3580: FROM OKC_TERMS_TEMPLATES_ALL tmpl,

3576: ) RETURN VARCHAR2 IS
3577:
3578: CURSOR terms_tmpl_csr IS
3579: SELECT 'Y'
3580: FROM OKC_TERMS_TEMPLATES_ALL tmpl,
3581: OKC_ALLOWED_TMPL_USAGES usg,
3582: OKC_BUS_DOC_TYPES_B doc
3583: WHERE tmpl.template_id = p_template_id
3584: AND doc.document_type = p_doc_type

Line 3690: FROM okc_terms_templates_all tmpl,

3686: SELECT tmpl.template_name,
3687: tmpl.description,
3688: okc_util.decode_lookup('OKC_CONTRACT_TERMS_SOURCES','STRUCTURED'),
3689: party.alternate_name
3690: FROM okc_terms_templates_all tmpl,
3691: okc_resp_parties_vl party,
3692: okc_bus_doc_types_b doc
3693: WHERE tmpl.template_id = p_template_id
3694: and party.document_type_class = doc.document_type_class

Line 3806: FROM OKC_TERMS_TEMPLATES_ALL tmpl,

3802: CURSOR terms_tmpl_csr IS
3803: SELECT tmpl.template_id,
3804: tmpl.template_name,
3805: tmpl.description
3806: FROM OKC_TERMS_TEMPLATES_ALL tmpl,
3807: OKC_ALLOWED_TMPL_USAGES usg,
3808: OKC_BUS_DOC_TYPES_B doc
3809: WHERE doc.document_type = p_document_type
3810: AND doc.intent = tmpl.intent

Line 4268: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;

4264: ) IS
4265:
4266: l_api_version CONSTANT NUMBER := 1;
4267: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4268: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4269: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4270: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4271: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4272:

Line 4269: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;

4265:
4266: l_api_version CONSTANT NUMBER := 1;
4267: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4268: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4269: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4270: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4271: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4272:
4273: CURSOR l_tmpl_csr IS

Line 4270: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;

4266: l_api_version CONSTANT NUMBER := 1;
4267: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4268: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4269: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4270: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4271: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4272:
4273: CURSOR l_tmpl_csr IS
4274: SELECT translated_from_tmpl_id, language, org_id, parent_template_id

Line 4271: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;

4267: l_api_name CONSTANT VARCHAR2(30) := 'get_translated_template';
4268: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.translated_from_tmpl_id%TYPE;
4269: l_language OKC_TERMS_TEMPLATES_ALL.language%TYPE;
4270: l_org_id OKC_TERMS_TEMPLATES_ALL.org_id%TYPE;
4271: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4272:
4273: CURSOR l_tmpl_csr IS
4274: SELECT translated_from_tmpl_id, language, org_id, parent_template_id
4275: FROM okc_terms_templates_all

Line 4275: FROM okc_terms_templates_all

4271: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE;
4272:
4273: CURSOR l_tmpl_csr IS
4274: SELECT translated_from_tmpl_id, language, org_id, parent_template_id
4275: FROM okc_terms_templates_all
4276: WHERE template_id = p_template_id;
4277:
4278: CURSOR l_translated_csr( l_tmpl_id in number,l_org_id in number) IS
4279: SELECT template_id

Line 4280: FROM okc_terms_templates_all

4276: WHERE template_id = p_template_id;
4277:
4278: CURSOR l_translated_csr( l_tmpl_id in number,l_org_id in number) IS
4279: SELECT template_id
4280: FROM okc_terms_templates_all
4281: WHERE language = p_language
4282: AND org_id = l_org_id
4283: AND template_id = l_tmpl_id
4284: UNION ALL

Line 4286: FROM okc_terms_templates_all

4282: AND org_id = l_org_id
4283: AND template_id = l_tmpl_id
4284: UNION ALL
4285: SELECT template_id
4286: FROM okc_terms_templates_all
4287: WHERE language = p_language
4288: AND org_id = l_org_id
4289: AND translated_from_tmpl_id = l_tmpl_id;
4290: