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_TEMPLATE_USAGES

Line 299: DELETE FROM OKC_TEMPLATE_USAGES

295: WHERE document_type=l_doc_type_tbl(i)
296: and document_id=l_doc_id_tbl(i);
297:
298: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
299: DELETE FROM OKC_TEMPLATE_USAGES
300: WHERE document_type=l_doc_type_tbl(i)
301: and document_id=l_doc_id_tbl(i);
302:
303: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 304: DELETE FROM OKC_TEMPLATE_USAGES_H

300: WHERE document_type=l_doc_type_tbl(i)
301: and document_id=l_doc_id_tbl(i);
302:
303: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
304: DELETE FROM OKC_TEMPLATE_USAGES_H
305: WHERE document_type=l_doc_type_tbl(i)
306: and document_id=l_doc_id_tbl(i);
307: END IF;
308:

Line 781: FROM OKC_TEMPLATE_USAGES

777: --11.5.10+ code changes for COntract Repository end
778:
779: CURSOR tu_csr IS
780: SELECT G_TRUE
781: FROM OKC_TEMPLATE_USAGES
782: WHERE DOCUMENT_TYPE = p_doc_type AND DOCUMENT_ID = p_doc_id;
783:
784: BEGIN
785:

Line 902: (SELECT template_id FROM okc_template_usages

898: IS NULL )
899:
900: OR (
901: document_type='TEMPLATE' AND document_id IN
902: (SELECT template_id FROM okc_template_usages
903: WHERE document_type=p_doc_type AND document_id=p_doc_id )
904: AND NOT EXISTS
905: (SELECT 'x' from okc_k_articles_b b
906: WHERE b.document_type=p_doc_type AND b.document_id=p_doc_id

Line 1009: FROM okc_template_usages_v tu,

1005: l_return_value VARCHAR2(1) := 'N';
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;

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 1582: l_contract_source_code okc_template_usages.contract_source_code%TYPE := 'STRUCTURED';

1578: l_article_change_date date;
1579: l_section_change_date date;
1580: l_article_h_change_date date;
1581: l_section_h_change_date date;
1582: l_contract_source_code okc_template_usages.contract_source_code%TYPE := 'STRUCTURED';
1583:
1584: Cursor l_get_max_art_date_csr IS
1585: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1586: FROM OKC_K_ARTICLES_B

Line 1610: FROM okc_template_usages

1606: AND DOCUMENT_ID=p_doc_id;
1607:
1608: Cursor l_get_contract_source_csr IS
1609: SELECT contract_source_code
1610: FROM okc_template_usages
1611: WHERE document_type = p_doc_type
1612: AND document_id = p_doc_id;
1613:
1614: Cursor l_get_max_usg_upd_date_csr IS

Line 1616: FROM okc_template_usages

1612: AND document_id = p_doc_id;
1613:
1614: Cursor l_get_max_usg_upd_date_csr IS
1615: SELECT MAX(last_update_date)
1616: FROM okc_template_usages
1617: WHERE document_type = p_doc_type
1618: AND document_id = p_doc_id;
1619:
1620: BEGIN

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 2896: FROM okc_template_usages

2892: ) RETURN VARCHAR2 IS
2893: l_api_name CONSTANT VARCHAR2(30) := 'Has_Terms';
2894: CURSOR tmpl_usages_csr IS
2895: SELECT 'Y'
2896: FROM okc_template_usages
2897: WHERE document_type = p_document_type
2898: AND document_id = p_document_id;
2899:
2900: l_value VARCHAR2(1);

Line 2932: FROM okc_template_usages

2928: ) RETURN VARCHAR2 IS
2929: l_api_name CONSTANT VARCHAR2(30) := 'Has_Valid_Terms';
2930: CURSOR tmpl_usages_csr IS
2931: SELECT contract_source_code
2932: FROM okc_template_usages
2933: WHERE document_type = p_document_type
2934: AND document_id = p_document_id;
2935:
2936: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

Line 2936: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

2932: FROM okc_template_usages
2933: WHERE document_type = p_document_type
2934: AND document_id = p_document_id;
2935:
2936: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
2937: l_rownotfound BOOLEAN := FALSE;
2938: BEGIN
2939: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2940: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Has_Valid_Terms');

Line 2991: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;

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;
2995: l_contract_source FND_LOOKUPS.MEANING%TYPE;

Line 2992: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

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;
2995: l_contract_source FND_LOOKUPS.MEANING%TYPE;
2996:

Line 2993: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%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;
2995: l_contract_source FND_LOOKUPS.MEANING%TYPE;
2996:
2997: CURSOR terms_tmpl_csr IS

Line 3006: FROM OKC_TEMPLATE_USAGES tu,

3002: t.template_name,
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

Line 3141: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;

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;
3145: l_generated_flag VARCHAR2(1) := '?';

Line 3142: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE := NULL;

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;
3145: l_generated_flag VARCHAR2(1) := '?';
3146: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;

Line 3143: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%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;
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;

Line 3144: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%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;
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;

Line 3160: FROM OKC_TEMPLATE_USAGES tu,

3156: t.description,
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

Line 3198: FROM OKC_TEMPLATE_USAGES_H tu,

3194: t.description,
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

Line 3393: FROM okc_template_usages

3389: ) RETURN VARCHAR2 IS
3390: l_api_name CONSTANT VARCHAR2(30) := 'Get_Authoring_Party_Code';
3391: CURSOR tmpl_usages_csr IS
3392: SELECT authoring_party_code
3393: FROM okc_template_usages
3394: WHERE document_type = p_document_type
3395: AND document_id = p_document_id;
3396:
3397: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

Line 3397: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

3393: FROM okc_template_usages
3394: WHERE document_type = p_document_type
3395: AND document_id = p_document_id;
3396:
3397: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3398:
3399: BEGIN
3400: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Authoring_Party_Code ');

Line 3427: FROM okc_template_usages

3423: ) RETURN VARCHAR2 IS
3424: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Source_Code';
3425: CURSOR tmpl_usages_csr IS
3426: SELECT contract_source_code
3427: FROM okc_template_usages
3428: WHERE document_type = p_document_type
3429: AND document_id = p_document_id;
3430:
3431: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

Line 3431: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

3427: FROM okc_template_usages
3428: WHERE document_type = p_document_type
3429: AND document_id = p_document_id;
3430:
3431: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3432:
3433: BEGIN
3434: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3435: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Contract_Source_Code ');

Line 3788: FROM OKC_TEMPLATE_USAGES usg, OKC_BUS_DOC_TYPES_B types

3784: ) RETURN VARCHAR2 IS
3785: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Generate_Deviations';
3786: CURSOR tmpl_usages_csr IS
3787: SELECT usg.autogen_deviations_flag,types.application_id
3788: FROM OKC_TEMPLATE_USAGES usg, OKC_BUS_DOC_TYPES_B types
3789: WHERE usg.document_type = p_document_type
3790: AND usg.document_id = p_document_id
3791: AND types.document_type = usg.document_type;
3792:

Line 3793: l_autogen_deviations_flag OKC_TEMPLATE_USAGES.AUTOGEN_DEVIATIONS_FLAG%TYPE;

3789: WHERE usg.document_type = p_document_type
3790: AND usg.document_id = p_document_id
3791: AND types.document_type = usg.document_type;
3792:
3793: l_autogen_deviations_flag OKC_TEMPLATE_USAGES.AUTOGEN_DEVIATIONS_FLAG%TYPE;
3794: l_application_id OKC_BUS_DOC_TYPES_B.APPLICATION_ID%TYPE;
3795:
3796: BEGIN
3797: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4023: l_contract_source_code okc_template_usages.contract_source_code%TYPE;

4019: l_api_version CONSTANT NUMBER := 1;
4020: l_api_name CONSTANT VARCHAR2(30) := 'Contract_Terms_Amended';
4021: l_dummy VARCHAR2(1) := '?';
4022: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
4023: l_contract_source_code okc_template_usages.contract_source_code%TYPE;
4024: CURSOR contract_source_csr IS
4025: SELECT contract_source_code
4026: FROM okc_template_usages
4027: WHERE document_id = p_doc_id

Line 4026: FROM okc_template_usages

4022: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
4023: l_contract_source_code okc_template_usages.contract_source_code%TYPE;
4024: CURSOR contract_source_csr IS
4025: SELECT contract_source_code
4026: FROM okc_template_usages
4027: WHERE document_id = p_doc_id
4028: AND document_type = p_doc_type;
4029:
4030: CURSOR primary_kdoc_csr IS