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 495: FROM okc_terms_templates_all t,

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

Line 505: FROM okc_terms_templates_all

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

Line 510: l_contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;

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

Line 702: FROM okc_terms_templates_all

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

Line 723: l_template_id okc_terms_templates_all.template_id%TYPE;

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

Line 724: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;

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

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

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

Line 1810: FROM okc_terms_templates_all

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

Line 1831: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;

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

Line 1863: FROM okc_terms_templates_all

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

Line 1869: FROM okc_terms_templates_all

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

Line 2050: FROM okc_terms_templates_all

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

Line 2057: FROM okc_terms_templates_all

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

Line 2065: FROM okc_terms_templates_all

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

Line 2205: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;

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

Line 2224: l_template_name okc_terms_templates_all.template_name%TYPE;

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

Line 2225: l_XPRT_SCN_CODE okc_terms_templates_all.XPRT_SCN_CODE%TYPE;

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

Line 2230: FROM okc_terms_templates_all

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

Line 2238: okc_terms_templates_all t

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

Line 2257: okc_terms_templates_all t

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

Line 2583: l_org_id okc_terms_templates_all.org_id%TYPE;

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

Line 2584: l_intent okc_terms_templates_all.intent%TYPE;

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

Line 2593: FROM okc_terms_templates_all

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

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

4743: SELECT 'x'
4744: FROM okc_xprt_rule_hdrs_all rule
4745: WHERE rule.rule_id = p_rule_id
4746: AND rule.org_wide_flag = 'Y'
4747: AND (rule.intent, rule.org_id) in (select intent, org_id from okc_terms_templates_all where template_id = p_template_id)
4748:
4749: UNION ALL
4750:
4751: --template specific rules

Line 5993: FROM okc_terms_templates_all t,

5989: AND h.status_code = 'ACTIVE'
5990: AND r.template_id = p_template_id
5991: UNION ALL
5992: SELECT h.rule_id
5993: FROM okc_terms_templates_all t,
5994: okc_xprt_rule_hdrs_all h
5995: WHERE t.org_id = h.org_id
5996: AND t.intent = h.intent
5997: AND h.status_code = 'ACTIVE'

Line 6357: FROM okc_terms_templates_all

6353: WHERE model_usage_id = -1 ; -- seeded for Any Usage
6354:
6355: CURSOR csr_template_key IS
6356: SELECT 'OKC:TEMPLATEMODEL:'||org_id||':'||intent||':'||template_id
6357: FROM okc_terms_templates_all
6358: WHERE template_id = p_template_id;
6359:
6360:
6361: BEGIN

Line 6617: FROM okc_terms_templates_all

6613: AND template_id = p_template_id;
6614:
6615: CURSOR csr_expert_enabled IS
6616: SELECT (nvl(contract_expert_enabled, 'N'))
6617: FROM okc_terms_templates_all
6618: WHERE template_id = p_template_id;
6619:
6620: -- bug 4234476
6621: -- For document_Type_class as Sourcing if variable_resolution_am IS NULL

Line 7542: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;

7538: l_doc_lib VARCHAR2(1);
7539: l_api_version CONSTANT NUMBER := 1;
7540: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
7541:
7542: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
7543: l_def_scn_code okc_article_versions.default_section%TYPE;
7544: l_scn_code okc_sections_b.scn_code%TYPE;
7545:
7546:

Line 7574: okc_terms_templates_all t

7570:
7571: CURSOR csr_xprt_scn_code IS
7572: SELECT NVL(t.xprt_scn_code,'UNASSIGNED')
7573: FROM okc_template_usages u,
7574: okc_terms_templates_all t
7575: WHERE u.template_id = t.template_id
7576: AND u.document_type = p_document_type
7577: AND u.document_id = p_document_id ;
7578:

Line 8734: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;

8730: l_api_version CONSTANT NUMBER := 1;
8731:
8732: -- Expert Profile Value and Template Expert Flag
8733: l_ce_enabled VARCHAR2(50);
8734: l_template_ce_enabled okc_terms_templates_all.contract_expert_enabled%TYPE;
8735:
8736: -- Header Information related local variables
8737: l_config_header_id NUMBER;
8738: l_config_rev_nbr NUMBER;

Line 8796: okc_terms_templates_all t

8792: u.config_revision_number,
8793: t.template_id,
8794: t.contract_expert_enabled
8795: FROM okc_template_usages u,
8796: okc_terms_templates_all t
8797: WHERE t.template_id = u.template_id
8798: AND u.document_type= p_document_type
8799: AND u.document_id = p_document_id;
8800:

Line 9867: okc_terms_templates_all t

9863: u.config_revision_number,
9864: t.template_id,
9865: t.contract_expert_enabled
9866: FROM okc_template_usages u,
9867: okc_terms_templates_all t
9868: WHERE t.template_id = u.template_id
9869: AND u.document_type= p_document_type
9870: AND u.document_id = p_document_id
9871: AND t.template_id = p_template_id;

Line 9990: FROM OKC_TERMS_TEMPLATES_ALL t,

9986: AND rhdr.rule_type = p_rule_type
9987: AND rhdr.status_code IN ('ACTIVE','PENDING_PUB')
9988: UNION ALL
9989: SELECT r.rule_id
9990: FROM OKC_TERMS_TEMPLATES_ALL t,
9991: okc_xprt_rule_hdrs_all r
9992: WHERE t.org_id = p_org_id
9993: AND t.intent = p_intent
9994: AND r.rule_type = p_rule_type

Line 10018: FROM okc_terms_templates_all

10014: AND xro.object_type='QUESTION';
10015:
10016: CURSOR csr_main IS
10017: SELECT org_id, intent
10018: FROM okc_terms_templates_all
10019: WHERE template_id = p_template_id;
10020:
10021: l_dummy VARCHAR2(1);
10022: l_return VARCHAR2(1);

Line 10164: from okc_template_usages u, okc_terms_templates_all a

10160: l_api_name CONSTANT VARCHAR2(30) := 'has_unanswered_questions';
10161:
10162: CURSOR doc_template_dtls_csr IS
10163: select u.template_id, a.contract_expert_enabled, u.contract_source_code
10164: from okc_template_usages u, okc_terms_templates_all a
10165: where u.template_id = a.template_id
10166: and u.document_type = p_document_type
10167: and u.document_id = p_document_id;
10168:

Line 10170: l_template_id okc_terms_templates_all.template_id%type;

10166: and u.document_type = p_document_type
10167: and u.document_id = p_document_id;
10168:
10169: l_return_val VARCHAR2(1);
10170: l_template_id okc_terms_templates_all.template_id%type;
10171: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;
10172: l_contract_source okc_template_usages.contract_source_code%type;
10173: l_has_questions VARCHAR2(1);
10174: l_ce_enabled VARCHAR2(50);

Line 10171: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;

10167: and u.document_id = p_document_id;
10168:
10169: l_return_val VARCHAR2(1);
10170: l_template_id okc_terms_templates_all.template_id%type;
10171: l_expert_enabled okc_terms_templates_all.contract_expert_enabled%type;
10172: l_contract_source okc_template_usages.contract_source_code%type;
10173: l_has_questions VARCHAR2(1);
10174: l_ce_enabled VARCHAR2(50);
10175: