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

Line 720: FROM OKC_TERMS_TEMPLATES_ALL

716:
717: CURSOR csr_template_dtls IS
718: SELECT template_name,
719: DECODE(parent_template_id, NULL, template_id, parent_template_id)
720: FROM OKC_TERMS_TEMPLATES_ALL
721: WHERE template_id = p_template_id ;
722:
723: /*
724: CURSOR csr_template_model_id(p_org_id IN NUMBER,

Line 756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

752: l_rule_text cz_imp_rules.rule_text%TYPE;
753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
754:
755:
756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
757: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
758:
759: l_cz_imp_rules cz_imp_rules%ROWTYPE;
760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

Line 757: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

753: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
754:
755:
756: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
757: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
758:
759: l_cz_imp_rules cz_imp_rules%ROWTYPE;
760: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
761:

Line 1251: FROM OKC_TERMS_TEMPLATES_ALL t,

1247: -- Templates Attached to each Rule
1248: CURSOR csr_templates(p_rule_id IN NUMBER) IS
1249: -- Local Rules
1250: SELECT r.template_id
1251: FROM OKC_TERMS_TEMPLATES_ALL t,
1252: okc_xprt_template_rules r
1253: WHERE r.template_id = t.template_id
1254: AND t.status_code IN ('APPROVED','ON_HOLD')
1255: AND t.contract_expert_enabled = 'Y'

Line 1261: FROM OKC_TERMS_TEMPLATES_ALL t,

1257: AND r.rule_id = p_rule_id
1258: UNION ALL
1259: -- Org Wide Rules
1260: SELECT t.template_id
1261: FROM OKC_TERMS_TEMPLATES_ALL t,
1262: okc_xprt_rule_hdrs_all r
1263: WHERE t.org_id = r.org_id
1264: AND t.intent = r.intent
1265: AND t.contract_expert_enabled = 'Y'

Line 1291: FROM OKC_TERMS_TEMPLATES_ALL t,

1287: -- list of templates to which the rule is currently attached
1288: (
1289: -- Local Rules
1290: SELECT to_char(r.template_id)
1291: FROM OKC_TERMS_TEMPLATES_ALL t,
1292: okc_xprt_template_rules r
1293: WHERE r.template_id = t.template_id
1294: AND t.status_code IN ('APPROVED','ON_HOLD')
1295: AND t.contract_expert_enabled = 'Y'

Line 1301: FROM OKC_TERMS_TEMPLATES_ALL t,

1297: AND r.rule_id = p_rule_id
1298: UNION ALL
1299: -- Org Wide Rules
1300: SELECT to_char(t.template_id)
1301: FROM OKC_TERMS_TEMPLATES_ALL t,
1302: okc_xprt_rule_hdrs_all r
1303: --,okc_xprt_template_rules tr -- Added for Bug 5005681
1304: WHERE t.org_id = r.org_id
1305: --AND tr.template_id = t.template_id -- Added for Bug 5005681

Line 1653: FROM OKC_TERMS_TEMPLATES_ALL t,

1649: AND r.template_id = p_template_id
1650: UNION ALL
1651: -- Global Active Rules for the template
1652: SELECT r.rule_id
1653: FROM OKC_TERMS_TEMPLATES_ALL t,
1654: okc_xprt_rule_hdrs_all r
1655: WHERE t.org_id = r.org_id
1656: AND t.intent = r.intent
1657: AND NVL(r.org_wide_flag,'N') = 'Y'

Line 1683: FROM OKC_TERMS_TEMPLATES_ALL

1679: AND r.template_id = p_template_id ;
1680:
1681: CURSOR csr_template_dtls IS
1682: SELECT parent_template_id
1683: FROM OKC_TERMS_TEMPLATES_ALL
1684: WHERE template_id = p_template_id ;
1685:
1686:
1687: -- Generate Run Id for Rule Import

Line 1695: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE := NULL;

1691:
1692:
1693: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';
1694: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1695: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE := NULL;
1696: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE := NULL;
1697:
1698:
1699:

Line 1696: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE := NULL;

1692:
1693: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';
1694: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1695: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE := NULL;
1696: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE := NULL;
1697:
1698:
1699:
1700: BEGIN

Line 2383: FROM OKC_TERMS_TEMPLATES_ALL t

2379:
2380: -- Added Org_id to the cusor for R12
2381: CURSOR csr_intents IS
2382: SELECT intent,org_id
2383: FROM OKC_TERMS_TEMPLATES_ALL t
2384: WHERE t.template_id = p_template_id;
2385:
2386: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
2387: SELECT devl_project_id, orig_sys_ref