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 430: FROM okc_bus_doc_types_b

426: and var.variable_type='S';
427:
428: CURSOR doc_cls_lst_crs IS
429: SELECT document_type_class
430: FROM okc_bus_doc_types_b
431: WHERE document_type=p_doc_type;
432:
433: BEGIN
434: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 773: FROM okc_bus_doc_types_b

769:
770: --11.5.10+ code changes for COntract Repository Start
771: CURSOR doc_class_cur IS
772: SELECT document_type_class
773: FROM okc_bus_doc_types_b
774: WHERE document_type = p_doc_type;
775:
776: l_doc_class okc_bus_doc_types_b.document_type_class%TYPE;
777: --11.5.10+ code changes for COntract Repository end

Line 776: l_doc_class okc_bus_doc_types_b.document_type_class%TYPE;

772: SELECT document_type_class
773: FROM okc_bus_doc_types_b
774: WHERE document_type = p_doc_type;
775:
776: l_doc_class okc_bus_doc_types_b.document_type_class%TYPE;
777: --11.5.10+ code changes for COntract Repository end
778:
779: CURSOR tu_csr IS
780: SELECT G_TRUE

Line 1783: FROM okc_bus_doc_types_b

1779: l_end_date DATE;
1780:
1781: CURSOR doc_cls_lst_crs IS
1782: SELECT document_type_class
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

Line 2307: FROM okc_bus_doc_types_b

2303: l_api_name CONSTANT VARCHAR2(30) := 'get_item_dtl_for_expert';
2304: l_doc_class VARCHAR2(30) := '?';
2305: CURSOR doc_cls_lst_crs IS
2306: SELECT document_type_class
2307: FROM okc_bus_doc_types_b
2308: WHERE document_type=p_doc_type;
2309: BEGIN
2310: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2311: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15400: Entered get_item_dtl_for_expert');

Line 2476: FROM okc_bus_doc_types_b

2472: l_return_status VARCHAR2(1);
2473:
2474: CURSOR doc_cls_lst_crs IS
2475: SELECT document_type_class
2476: FROM okc_bus_doc_types_b
2477: WHERE document_type=p_doc_type;
2478: BEGIN
2479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2480: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15900: Entered get_last_signed_revision');

Line 3009: okc_bus_doc_types_b doc,

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

Line 3163: okc_bus_doc_types_b doc,

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

Line 3201: okc_bus_doc_types_b doc,

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

Line 3472: OKC_BUS_DOC_TYPES_B doc

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

Line 3582: okc_bus_doc_types_b doc

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

Line 3698: OKC_BUS_DOC_TYPES_B doc

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

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