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_XPRT_UTIL_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 497: FROM okc_terms_templates_all t,

493:
494: CURSOR csr_org_rules_templates IS
495: -- Org Wide Rules
496: SELECT 'X'
497: FROM okc_terms_templates_all t,
498: okc_xprt_rule_hdrs_all h
499: WHERE t.org_id = h.org_id
500: AND t.intent = h.intent
501: AND h.status_code = 'ACTIVE'

Line 507: FROM okc_terms_templates_all

503: AND t.template_id = p_template_id ;
504:
505: CURSOR csr_template_dtls IS
506: SELECT NVL(contract_expert_enabled,'N')
507: FROM okc_terms_templates_all
508: WHERE template_id = p_template_id;
509:
510: l_dummy VARCHAR2(1);
511: l_expert_flag VARCHAR2(1);

Line 512: l_contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;

508: WHERE template_id = p_template_id;
509:
510: l_dummy VARCHAR2(1);
511: l_expert_flag VARCHAR2(1);
512: l_contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;
513:
514: BEGIN
515:
516: l_dummy := NULL;

Line 704: FROM okc_terms_templates_all

700:
701: CURSOR csr_templates IS
702: SELECT DECODE(parent_template_id, NULL, template_id, parent_template_id),
703: template_model_id
704: FROM okc_terms_templates_all
705: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID ;
706:
707: -- UIs for the template not attached to Production publication
708: CURSOR csr_template_ui(p_model_id IN NUMBER) IS

Line 725: l_template_id okc_terms_templates_all.template_id%TYPE;

721:
722:
723: l_api_version CONSTANT NUMBER := 1;
724: l_api_name CONSTANT VARCHAR2(30) := 'create_test_publication';
725: l_template_id okc_terms_templates_all.template_id%TYPE;
726: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
727: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
728: l_new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
729: l_run_id NUMBER;

Line 726: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;

722:
723: l_api_version CONSTANT NUMBER := 1;
724: l_api_name CONSTANT VARCHAR2(30) := 'create_test_publication';
725: l_template_id okc_terms_templates_all.template_id%TYPE;
726: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
727: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
728: l_new_ui_def_id cz_ui_defs.ui_def_id%TYPE;
729: l_run_id NUMBER;
730: l_publication_id NUMBER;

Line 948: select org_id, intent from okc_terms_templates_all where template_id = p_Template_Id;

944: l_login_id CONSTANT Number := Fnd_Global.Login_Id;
945: l_conc_request_id CONSTANT Number := Fnd_Global.Conc_Request_Id;
946:
947: cursor Template_Cursor is
948: select org_id, intent from okc_terms_templates_all where template_id = p_Template_Id;
949:
950: l_Org_Id NUMBER;
951: l_Intent VARCHAR2(1);
952:

Line 1812: FROM okc_terms_templates_all

1808: /*Bug 5032199 commented below cursor.Using REF cursor
1809: CURSOR csr_templates IS
1810: SELECT DECODE(parent_template_id, NULL, template_id, parent_template_id) template_id,
1811: template_model_id
1812: FROM okc_terms_templates_all
1813: WHERE template_id = DECODE(p_template_id,NULL,template_id,p_template_id)
1814: AND xprt_request_id = DECODE(p_calling_mode,'TEMPLATE_APPROVAL',xprt_request_id, FND_GLOBAL.CONC_REQUEST_ID);
1815: */
1816:

Line 1833: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;

1829: AND source_target_flag = 'S';
1830:
1831: l_api_version CONSTANT NUMBER := 1;
1832: l_api_name CONSTANT VARCHAR2(30) := 'create_production_publication';
1833: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
1834: l_run_id NUMBER;
1835: l_publication_id cz_model_publications.publication_id%TYPE;
1836: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1837: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

Line 1865: FROM okc_terms_templates_all

1861:
1862: --START: Perf Bug 5032199 Using REF cursor
1863: IF(p_template_id IS NOT NULL) THEN
1864: l_sql_stmt := 'SELECT template_model_id
1865: FROM okc_terms_templates_all
1866: WHERE template_id = '||p_template_id||'
1867: AND xprt_request_id = DECODE('''||p_calling_mode||''',
1868: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';
1869: ELSE

Line 1871: FROM okc_terms_templates_all

1867: AND xprt_request_id = DECODE('''||p_calling_mode||''',
1868: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';
1869: ELSE
1870: l_sql_stmt := 'SELECT template_model_id
1871: FROM okc_terms_templates_all
1872: WHERE xprt_request_id = DECODE('''||p_calling_mode||''',
1873: ''TEMPLATE_APPROVAL'',xprt_request_id,'||FND_GLOBAL.CONC_REQUEST_ID||')';
1874: END IF;
1875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2052: FROM okc_terms_templates_all

2048: last_update_date = SYSDATE,
2049: last_update_login = FND_GLOBAL.LOGIN_ID
2050: WHERE question_rule_status = 'PENDINGPUB'
2051: AND template_id IN ( SELECT template_id
2052: FROM okc_terms_templates_all
2053: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2054: );
2055: -- Delete from okc_xprt_template_rules
2056: DELETE FROM okc_xprt_template_rules

Line 2059: FROM okc_terms_templates_all

2055: -- Delete from okc_xprt_template_rules
2056: DELETE FROM okc_xprt_template_rules
2057: WHERE NVL(deleted_flag,'N') = 'Y'
2058: AND template_id IN ( SELECT template_id
2059: FROM okc_terms_templates_all
2060: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2061: );
2062:
2063: -- Update published_flag in okc_xprt_template_rules

Line 2067: FROM okc_terms_templates_all

2063: -- Update published_flag in okc_xprt_template_rules
2064: UPDATE okc_xprt_template_rules
2065: SET published_flag = 'Y'
2066: WHERE template_id IN ( SELECT template_id
2067: FROM okc_terms_templates_all
2068: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2069: );
2070: END IF; -- p_calling_mode = 'PUBLISH'
2071:

Line 2207: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;

2203: l_api_name CONSTANT VARCHAR2(30) := 'validate_template_for_expert';
2204: l_api_version CONSTANT NUMBER := 1;
2205:
2206: l_ce_enabled VARCHAR2(50);
2207: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;
2208:
2209: l_qa_tbl_index NUMBER;
2210:
2211: l_template_rule_status_sev OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;

Line 2226: l_template_name okc_terms_templates_all.template_name%TYPE;

2222: l_template_no_rule_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2223: l_perf_template_no_rule VARCHAR2(1);
2224:
2225: l_tmpl_active_rule_exists VARCHAR2(1);
2226: l_template_name okc_terms_templates_all.template_name%TYPE;
2227: l_XPRT_SCN_CODE okc_terms_templates_all.XPRT_SCN_CODE%TYPE;
2228: l_section_name FND_LOOKUPS.MEANING%TYPE;
2229:
2230: CURSOR csr_template_dtls IS

Line 2227: l_XPRT_SCN_CODE okc_terms_templates_all.XPRT_SCN_CODE%TYPE;

2223: l_perf_template_no_rule VARCHAR2(1);
2224:
2225: l_tmpl_active_rule_exists VARCHAR2(1);
2226: l_template_name okc_terms_templates_all.template_name%TYPE;
2227: l_XPRT_SCN_CODE okc_terms_templates_all.XPRT_SCN_CODE%TYPE;
2228: l_section_name FND_LOOKUPS.MEANING%TYPE;
2229:
2230: CURSOR csr_template_dtls IS
2231: SELECT contract_expert_enabled , template_name , XPRT_SCN_CODE

Line 2232: FROM okc_terms_templates_all

2228: l_section_name FND_LOOKUPS.MEANING%TYPE;
2229:
2230: CURSOR csr_template_dtls IS
2231: SELECT contract_expert_enabled , template_name , XPRT_SCN_CODE
2232: FROM okc_terms_templates_all
2233: WHERE template_id = p_template_id;
2234:
2235:
2236: CURSOR csr_tmpl_non_active_rules IS

Line 2240: okc_terms_templates_all t

2236: CURSOR csr_tmpl_non_active_rules IS
2237: -- global rules not active
2238: SELECT 'X'
2239: FROM okc_xprt_rule_hdrs_all r,
2240: okc_terms_templates_all t
2241: WHERE t.org_id = r.org_id
2242: AND t.intent = r.intent
2243: AND t.template_id = p_template_id
2244: AND r.org_wide_flag = 'Y'

Line 2259: okc_terms_templates_all t

2255: CURSOR csr_tmpl_active_rules IS
2256: -- global Active rules
2257: SELECT 'X'
2258: FROM okc_xprt_rule_hdrs_all r,
2259: okc_terms_templates_all t
2260: WHERE t.org_id = r.org_id
2261: AND t.intent = r.intent
2262: AND t.template_id = p_template_id
2263: AND r.org_wide_flag = 'Y'

Line 2585: l_org_id okc_terms_templates_all.org_id%TYPE;

2581: l_param_value_tbl param_value_type;
2582: l_num_records NUMBER;
2583: l_rec_index NUMBER;
2584:
2585: l_org_id okc_terms_templates_all.org_id%TYPE;
2586: l_intent okc_terms_templates_all.intent%TYPE;
2587:
2588: CURSOR csr_config_effective_date IS
2589: SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY')

Line 2586: l_intent okc_terms_templates_all.intent%TYPE;

2582: l_num_records NUMBER;
2583: l_rec_index NUMBER;
2584:
2585: l_org_id okc_terms_templates_all.org_id%TYPE;
2586: l_intent okc_terms_templates_all.intent%TYPE;
2587:
2588: CURSOR csr_config_effective_date IS
2589: SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY')
2590: FROM dual;

Line 2595: FROM okc_terms_templates_all

2591:
2592: CURSOR csr_template_dtls IS
2593: SELECT org_id,
2594: intent
2595: FROM okc_terms_templates_all
2596: WHERE template_id = p_template_id;
2597:
2598: BEGIN
2599:

Line 4945: AND (rule.intent, rule.org_id) in (select intent, org_id from okc_terms_templates_all where template_id = p_template_id)

4941: SELECT 'x'
4942: FROM okc_xprt_rule_hdrs_all rule
4943: WHERE rule.rule_id = p_rule_id
4944: AND rule.org_wide_flag = 'Y'
4945: AND (rule.intent, rule.org_id) in (select intent, org_id from okc_terms_templates_all where template_id = p_template_id)
4946:
4947: UNION ALL
4948:
4949: --template specific rules

Line 6191: FROM okc_terms_templates_all t,

6187: AND h.status_code = 'ACTIVE'
6188: AND r.template_id = p_template_id
6189: UNION ALL
6190: SELECT h.rule_id
6191: FROM okc_terms_templates_all t,
6192: okc_xprt_rule_hdrs_all h
6193: WHERE t.org_id = h.org_id
6194: AND t.intent = h.intent
6195: AND h.status_code = 'ACTIVE'

Line 6555: FROM okc_terms_templates_all

6551: WHERE model_usage_id = -1 ; -- seeded for Any Usage
6552:
6553: CURSOR csr_template_key IS
6554: SELECT 'OKC:TEMPLATEMODEL:'||org_id||':'||intent||':'||template_id
6555: FROM okc_terms_templates_all
6556: WHERE template_id = p_template_id;
6557:
6558:
6559: BEGIN

Line 6817: FROM okc_terms_templates_all

6813: AND template_id = p_template_id;
6814:
6815: CURSOR csr_expert_enabled IS
6816: SELECT (nvl(contract_expert_enabled, 'N'))
6817: FROM okc_terms_templates_all
6818: WHERE template_id = p_template_id;
6819:
6820: -- bug 4234476
6821: -- For document_Type_class as Sourcing if variable_resolution_am IS NULL

Line 7825: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;

7821: l_doc_lib VARCHAR2(1);
7822: l_api_version CONSTANT NUMBER := 1;
7823: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
7824:
7825: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
7826: l_def_scn_code okc_article_versions.default_section%TYPE;
7827: l_scn_code okc_sections_b.scn_code%TYPE;
7828:
7829:

Line 7859: okc_terms_templates_all t

7855:
7856: CURSOR csr_xprt_scn_code IS
7857: SELECT NVL(t.xprt_scn_code,'UNASSIGNED')
7858: FROM okc_template_usages u,
7859: okc_terms_templates_all t
7860: WHERE u.template_id = t.template_id
7861: AND u.document_type = p_document_type
7862: AND u.document_id = p_document_id ;
7863:

Line 9061: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;

9057: l_api_version CONSTANT NUMBER := 1;
9058:
9059: -- Expert Profile Value and Template Expert Flag
9060: l_ce_enabled VARCHAR2(50);
9061: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;
9062:
9063: -- Header Information related local variables
9064: l_config_header_id NUMBER;
9065: l_config_rev_nbr NUMBER;

Line 9126: okc_terms_templates_all t

9122: nvl(u.contract_expert_finish_flag, 'N'),
9123: t.template_id,
9124: t.contract_expert_enabled
9125: FROM okc_template_usages u,
9126: okc_terms_templates_all t
9127: WHERE t.template_id = u.template_id
9128: AND u.document_type= p_document_type
9129: AND u.document_id = p_document_id;
9130:

Line 10464: okc_terms_templates_all t

10460: u.config_revision_number,
10461: t.template_id,
10462: t.contract_expert_enabled
10463: FROM okc_template_usages u,
10464: okc_terms_templates_all t
10465: WHERE t.template_id = u.template_id
10466: AND u.document_type= p_document_type
10467: AND u.document_id = p_document_id
10468: AND t.template_id = p_template_id;

Line 10587: FROM OKC_TERMS_TEMPLATES_ALL t,

10583: AND rhdr.rule_type = p_rule_type
10584: AND rhdr.status_code IN ('ACTIVE','PENDING_PUB')
10585: UNION ALL
10586: SELECT r.rule_id
10587: FROM OKC_TERMS_TEMPLATES_ALL t,
10588: okc_xprt_rule_hdrs_all r
10589: WHERE t.org_id = p_org_id
10590: AND t.intent = p_intent
10591: AND r.rule_type = p_rule_type

Line 10615: FROM okc_terms_templates_all

10611: AND xro.object_type='QUESTION';
10612:
10613: CURSOR csr_main IS
10614: SELECT org_id, intent
10615: FROM okc_terms_templates_all
10616: WHERE template_id = p_template_id;
10617:
10618: l_dummy VARCHAR2(1);
10619: l_return VARCHAR2(1);

Line 10761: from okc_template_usages u, okc_terms_templates_all a

10757: l_api_name CONSTANT VARCHAR2(30) := 'has_unanswered_questions';
10758:
10759: CURSOR doc_template_dtls_csr IS
10760: select u.template_id, a.contract_expert_enabled, u.contract_source_code, nvl(u.contract_expert_finish_flag, 'N')
10761: from okc_template_usages u, okc_terms_templates_all a
10762: where u.template_id = a.template_id
10763: and u.document_type = p_document_type
10764: and u.document_id = p_document_id;
10765:

Line 10767: l_template_id okc_terms_templates_all.template_id%type;

10763: and u.document_type = p_document_type
10764: and u.document_id = p_document_id;
10765:
10766: l_return_val VARCHAR2(1);
10767: l_template_id okc_terms_templates_all.template_id%type;
10768: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;
10769: l_contract_source okc_template_usages.contract_source_code%type;
10770: l_has_questions VARCHAR2(1);
10771: l_ce_enabled VARCHAR2(50);

Line 10768: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;

10764: and u.document_id = p_document_id;
10765:
10766: l_return_val VARCHAR2(1);
10767: l_template_id okc_terms_templates_all.template_id%type;
10768: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;
10769: l_contract_source okc_template_usages.contract_source_code%type;
10770: l_has_questions VARCHAR2(1);
10771: l_ce_enabled VARCHAR2(50);
10772: l_ce_finish_flag VARCHAR2(1);