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 381: DELETE FROM OKC_TEMPLATE_USAGES

377: WHERE document_type=l_doc_type_tbl(i)
378: and document_id=l_doc_id_tbl(i);
379:
380: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
381: DELETE FROM OKC_TEMPLATE_USAGES
382: WHERE document_type=l_doc_type_tbl(i)
383: and document_id=l_doc_id_tbl(i);
384:
385: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 386: DELETE FROM OKC_TEMPLATE_USAGES_H

382: WHERE document_type=l_doc_type_tbl(i)
383: and document_id=l_doc_id_tbl(i);
384:
385: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
386: DELETE FROM OKC_TEMPLATE_USAGES_H
387: WHERE document_type=l_doc_type_tbl(i)
388: and document_id=l_doc_id_tbl(i);
389:
390: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN

Line 872: FROM OKC_TEMPLATE_USAGES

868: --11.5.10+ code changes for COntract Repository end
869:
870: CURSOR tu_csr IS
871: SELECT G_TRUE
872: FROM OKC_TEMPLATE_USAGES
873: WHERE DOCUMENT_TYPE = p_doc_type
874: AND DOCUMENT_ID = p_doc_id
875: UNION ALL
876: SELECT G_TRUE

Line 878: WHERE NOT EXISTS (SELECT 'Y' FROM OKC_TEMPLATE_USAGES

874: AND DOCUMENT_ID = p_doc_id
875: UNION ALL
876: SELECT G_TRUE
877: FROM dual
878: WHERE NOT EXISTS (SELECT 'Y' FROM OKC_TEMPLATE_USAGES
879: WHERE DOCUMENT_TYPE = p_doc_type
880: AND DOCUMENT_ID = p_doc_id
881: )
882: AND EXISTS ( SELECT 'Y' FROM okc_deliverables

Line 1006: (SELECT template_id FROM okc_template_usages

1002: IS NULL )
1003:
1004: OR (
1005: document_type='TEMPLATE' AND document_id IN
1006: (SELECT template_id FROM okc_template_usages
1007: WHERE document_type=p_doc_type AND document_id=p_doc_id )
1008: AND NOT EXISTS
1009: (SELECT 'x' from okc_k_articles_b b
1010: WHERE b.document_type=p_doc_type AND b.document_id=p_doc_id

Line 1113: FROM okc_template_usages_v tu,

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

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

1682: l_article_change_date date;
1683: l_section_change_date date;
1684: l_article_h_change_date date;
1685: l_section_h_change_date date;
1686: l_contract_source_code okc_template_usages.contract_source_code%TYPE := 'STRUCTURED';
1687:
1688: Cursor l_get_max_art_date_csr IS
1689: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1690: FROM OKC_K_ARTICLES_B

Line 1714: FROM okc_template_usages

1710: AND DOCUMENT_ID=p_doc_id;
1711:
1712: Cursor l_get_contract_source_csr IS
1713: SELECT contract_source_code
1714: FROM okc_template_usages
1715: WHERE document_type = p_doc_type
1716: AND document_id = p_doc_id;
1717:
1718: Cursor l_get_max_usg_upd_date_csr IS

Line 1720: FROM okc_template_usages

1716: AND document_id = p_doc_id;
1717:
1718: Cursor l_get_max_usg_upd_date_csr IS
1719: SELECT MAX(last_update_date)
1720: FROM okc_template_usages
1721: WHERE document_type = p_doc_type
1722: AND document_id = p_doc_id;
1723:
1724: BEGIN

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

3002: ) RETURN VARCHAR2 IS
3003: l_api_name CONSTANT VARCHAR2(30) := 'Has_Terms';
3004: CURSOR tmpl_usages_csr IS
3005: SELECT 'Y'
3006: FROM okc_template_usages
3007: WHERE document_type = p_document_type
3008: AND document_id = p_document_id;
3009:
3010: l_value VARCHAR2(1);

Line 3042: FROM okc_template_usages

3038: ) RETURN VARCHAR2 IS
3039: l_api_name CONSTANT VARCHAR2(30) := 'Has_Valid_Terms';
3040: CURSOR tmpl_usages_csr IS
3041: SELECT contract_source_code
3042: FROM okc_template_usages
3043: WHERE document_type = p_document_type
3044: AND document_id = p_document_id;
3045:
3046: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

Line 3046: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

3042: FROM okc_template_usages
3043: WHERE document_type = p_document_type
3044: AND document_id = p_document_id;
3045:
3046: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3047: l_rownotfound BOOLEAN := FALSE;
3048: BEGIN
3049: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3050: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Has_Valid_Terms');

Line 3101: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;

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

Line 3102: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

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

Line 3103: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%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;
3105: l_contract_source FND_LOOKUPS.MEANING%TYPE;
3106:
3107: CURSOR terms_tmpl_csr IS

Line 3116: FROM OKC_TEMPLATE_USAGES tu,

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

Line 3251: l_template_id OKC_TEMPLATE_USAGES.TEMPLATE_ID%TYPE;

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

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

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

Line 3253: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%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;
3255: l_generated_flag VARCHAR2(1) := '?';
3256: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3257: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;

Line 3254: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%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;
3255: l_generated_flag VARCHAR2(1) := '?';
3256: l_media_id FND_DOCUMENTS_TL.MEDIA_ID%TYPE := -1;
3257: l_authoring_party OKC_RESP_PARTIES_TL.ALTERNATE_NAME%TYPE;
3258: l_contract_source FND_LOOKUPS.MEANING%TYPE;

Line 3270: FROM OKC_TEMPLATE_USAGES tu,

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

Line 3308: FROM OKC_TEMPLATE_USAGES_H tu,

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

Line 3503: FROM okc_template_usages

3499: ) RETURN VARCHAR2 IS
3500: l_api_name CONSTANT VARCHAR2(30) := 'Get_Authoring_Party_Code';
3501: CURSOR tmpl_usages_csr IS
3502: SELECT authoring_party_code
3503: FROM okc_template_usages
3504: WHERE document_type = p_document_type
3505: AND document_id = p_document_id;
3506:
3507: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

Line 3507: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;

3503: FROM okc_template_usages
3504: WHERE document_type = p_document_type
3505: AND document_id = p_document_id;
3506:
3507: l_authoring_party_code OKC_TEMPLATE_USAGES.AUTHORING_PARTY_CODE%TYPE;
3508:
3509: BEGIN
3510: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Authoring_Party_Code ');

Line 3537: FROM okc_template_usages

3533: ) RETURN VARCHAR2 IS
3534: l_api_name CONSTANT VARCHAR2(30) := 'Get_Contract_Source_Code';
3535: CURSOR tmpl_usages_csr IS
3536: SELECT contract_source_code
3537: FROM okc_template_usages
3538: WHERE document_type = p_document_type
3539: AND document_id = p_document_id;
3540:
3541: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

Line 3541: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;

3537: FROM okc_template_usages
3538: WHERE document_type = p_document_type
3539: AND document_id = p_document_id;
3540:
3541: l_contract_source_code OKC_TEMPLATE_USAGES.CONTRACT_SOURCE_CODE%TYPE;
3542:
3543: BEGIN
3544: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3545: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Get_Contract_Source_Code ');

Line 3898: FROM OKC_TEMPLATE_USAGES usg, OKC_BUS_DOC_TYPES_B types

3894: ) RETURN VARCHAR2 IS
3895: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Generate_Deviations';
3896: CURSOR tmpl_usages_csr IS
3897: SELECT usg.autogen_deviations_flag,types.application_id
3898: FROM OKC_TEMPLATE_USAGES usg, OKC_BUS_DOC_TYPES_B types
3899: WHERE usg.document_type = p_document_type
3900: AND usg.document_id = p_document_id
3901: AND types.document_type = usg.document_type;
3902:

Line 3903: l_autogen_deviations_flag OKC_TEMPLATE_USAGES.AUTOGEN_DEVIATIONS_FLAG%TYPE;

3899: WHERE usg.document_type = p_document_type
3900: AND usg.document_id = p_document_id
3901: AND types.document_type = usg.document_type;
3902:
3903: l_autogen_deviations_flag OKC_TEMPLATE_USAGES.AUTOGEN_DEVIATIONS_FLAG%TYPE;
3904: l_application_id OKC_BUS_DOC_TYPES_B.APPLICATION_ID%TYPE;
3905:
3906: BEGIN
3907: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4133: l_contract_source_code okc_template_usages.contract_source_code%TYPE;

4129: l_api_version CONSTANT NUMBER := 1;
4130: l_api_name CONSTANT VARCHAR2(30) := 'Contract_Terms_Amended';
4131: l_dummy VARCHAR2(1) := '?';
4132: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
4133: l_contract_source_code okc_template_usages.contract_source_code%TYPE;
4134: CURSOR contract_source_csr IS
4135: SELECT contract_source_code
4136: FROM okc_template_usages
4137: WHERE document_id = p_doc_id

Line 4136: FROM okc_template_usages

4132: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
4133: l_contract_source_code okc_template_usages.contract_source_code%TYPE;
4134: CURSOR contract_source_csr IS
4135: SELECT contract_source_code
4136: FROM okc_template_usages
4137: WHERE document_id = p_doc_id
4138: AND document_type = p_doc_type;
4139:
4140: CURSOR primary_kdoc_csr IS