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_BUS_DOC_TYPES_B

Line 520: FROM okc_bus_doc_types_b

516: and var.variable_type='S';
517:
518: CURSOR doc_cls_lst_crs IS
519: SELECT document_type_class
520: FROM okc_bus_doc_types_b
521: WHERE document_type=p_doc_type;
522:
523: BEGIN
524: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 864: FROM okc_bus_doc_types_b

860:
861: --11.5.10+ code changes for COntract Repository Start
862: CURSOR doc_class_cur IS
863: SELECT document_type_class
864: FROM okc_bus_doc_types_b
865: WHERE document_type = p_doc_type;
866:
867: l_doc_class okc_bus_doc_types_b.document_type_class%TYPE;
868: --11.5.10+ code changes for COntract Repository end

Line 867: l_doc_class okc_bus_doc_types_b.document_type_class%TYPE;

863: SELECT document_type_class
864: FROM okc_bus_doc_types_b
865: WHERE document_type = p_doc_type;
866:
867: l_doc_class okc_bus_doc_types_b.document_type_class%TYPE;
868: --11.5.10+ code changes for COntract Repository end
869:
870: CURSOR tu_csr IS
871: SELECT G_TRUE

Line 1889: FROM okc_bus_doc_types_b

1885: l_end_date DATE;
1886:
1887: CURSOR doc_cls_lst_crs IS
1888: SELECT document_type_class
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

Line 2416: FROM okc_bus_doc_types_b

2412: l_api_name CONSTANT VARCHAR2(30) := 'get_item_dtl_for_expert';
2413: l_doc_class VARCHAR2(30) := '?';
2414: CURSOR doc_cls_lst_crs IS
2415: SELECT document_type_class
2416: FROM okc_bus_doc_types_b
2417: WHERE document_type=p_doc_type;
2418: BEGIN
2419: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered get_item_dtl_for_expert');

Line 2585: FROM okc_bus_doc_types_b

2581: l_return_status VARCHAR2(1);
2582:
2583: CURSOR doc_cls_lst_crs IS
2584: SELECT document_type_class
2585: FROM okc_bus_doc_types_b
2586: WHERE document_type=p_doc_type;
2587: BEGIN
2588: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15900: Entered get_last_signed_revision');

Line 3119: okc_bus_doc_types_b doc,

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
3122: AND tu.authoring_party_code = party.resp_party_code
3123: AND tu.document_type = doc.document_type

Line 3273: okc_bus_doc_types_b doc,

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
3276: AND tu.authoring_party_code = party.resp_party_code
3277: AND tu.document_type = doc.document_type

Line 3311: okc_bus_doc_types_b doc,

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
3314: AND tu.authoring_party_code = party.resp_party_code
3315: AND tu.document_type = doc.document_type

Line 3582: OKC_BUS_DOC_TYPES_B doc

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
3585: AND doc.intent = tmpl.intent
3586: AND usg.template_id = tmpl.template_id

Line 3692: okc_bus_doc_types_b doc

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
3695: and party.intent = doc.intent
3696: and doc.document_type= p_document_type

Line 3808: OKC_BUS_DOC_TYPES_B doc

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
3811: AND usg.template_id = tmpl.template_id
3812: AND usg.document_type = p_document_type

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 3904: l_application_id OKC_BUS_DOC_TYPES_B.APPLICATION_ID%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
3908: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Entering Auto_Generate_Deviations ');