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 706: FROM OKC_TERMS_TEMPLATES_ALL

702:
703: CURSOR csr_template_dtls IS
704: SELECT template_name,
705: DECODE(parent_template_id, NULL, template_id, parent_template_id)
706: FROM OKC_TERMS_TEMPLATES_ALL
707: WHERE template_id = p_template_id ;
708:
709: /*
710: CURSOR csr_template_model_id(p_org_id IN NUMBER,

Line 742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;

738: l_rule_text cz_imp_rules.rule_text%TYPE;
739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
740:
741:
742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
743: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
744:
745: l_cz_imp_rules cz_imp_rules%ROWTYPE;
746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;

Line 743: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;

739: l_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
740:
741:
742: l_template_name OKC_TERMS_TEMPLATES_ALL.template_name%TYPE;
743: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE;
744:
745: l_cz_imp_rules cz_imp_rules%ROWTYPE;
746: l_tmpl_orig_sys_ref cz_devl_projects.orig_sys_ref%TYPE;
747:

Line 1237: FROM OKC_TERMS_TEMPLATES_ALL t,

1233: -- Templates Attached to each Rule
1234: CURSOR csr_templates(p_rule_id IN NUMBER) IS
1235: -- Local Rules
1236: SELECT r.template_id
1237: FROM OKC_TERMS_TEMPLATES_ALL t,
1238: okc_xprt_template_rules r
1239: WHERE r.template_id = t.template_id
1240: AND t.status_code IN ('APPROVED','ON_HOLD')
1241: AND t.contract_expert_enabled = 'Y'

Line 1247: FROM OKC_TERMS_TEMPLATES_ALL t,

1243: AND r.rule_id = p_rule_id
1244: UNION ALL
1245: -- Org Wide Rules
1246: SELECT t.template_id
1247: FROM OKC_TERMS_TEMPLATES_ALL t,
1248: okc_xprt_rule_hdrs_all r
1249: WHERE t.org_id = r.org_id
1250: AND t.intent = r.intent
1251: AND t.contract_expert_enabled = 'Y'

Line 1277: FROM OKC_TERMS_TEMPLATES_ALL t,

1273: -- list of templates to which the rule is currently attached
1274: (
1275: -- Local Rules
1276: SELECT to_char(r.template_id)
1277: FROM OKC_TERMS_TEMPLATES_ALL t,
1278: okc_xprt_template_rules r
1279: WHERE r.template_id = t.template_id
1280: AND t.status_code IN ('APPROVED','ON_HOLD')
1281: AND t.contract_expert_enabled = 'Y'

Line 1287: FROM OKC_TERMS_TEMPLATES_ALL t,

1283: AND r.rule_id = p_rule_id
1284: UNION ALL
1285: -- Org Wide Rules
1286: SELECT to_char(t.template_id)
1287: FROM OKC_TERMS_TEMPLATES_ALL t,
1288: okc_xprt_rule_hdrs_all r
1289: --,okc_xprt_template_rules tr -- Added for Bug 5005681
1290: WHERE t.org_id = r.org_id
1291: --AND tr.template_id = t.template_id -- Added for Bug 5005681

Line 1639: FROM OKC_TERMS_TEMPLATES_ALL t,

1635: AND r.template_id = p_template_id
1636: UNION ALL
1637: -- Global Active Rules for the template
1638: SELECT r.rule_id
1639: FROM OKC_TERMS_TEMPLATES_ALL t,
1640: okc_xprt_rule_hdrs_all r
1641: WHERE t.org_id = r.org_id
1642: AND t.intent = r.intent
1643: AND NVL(r.org_wide_flag,'N') = 'Y'

Line 1669: FROM OKC_TERMS_TEMPLATES_ALL

1665: AND r.template_id = p_template_id ;
1666:
1667: CURSOR csr_template_dtls IS
1668: SELECT parent_template_id
1669: FROM OKC_TERMS_TEMPLATES_ALL
1670: WHERE template_id = p_template_id ;
1671:
1672:
1673: -- Generate Run Id for Rule Import

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

1677:
1678:
1679: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';
1680: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1681: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE := NULL;
1682: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE := NULL;
1683:
1684:
1685:

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

1678:
1679: l_api_name CONSTANT VARCHAR2(30) := 'import_rule_temp_approval';
1680: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1681: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.parent_template_id%TYPE := NULL;
1682: l_template_id OKC_TERMS_TEMPLATES_ALL.template_id%TYPE := NULL;
1683:
1684:
1685:
1686: BEGIN

Line 2369: FROM OKC_TERMS_TEMPLATES_ALL t

2365:
2366: -- Added Org_id to the cusor for R12
2367: CURSOR csr_intents IS
2368: SELECT intent,org_id
2369: FROM OKC_TERMS_TEMPLATES_ALL t
2370: WHERE t.template_id = p_template_id;
2371:
2372: CURSOR csr_get_var_model_dtl (l_intent VARCHAR2) IS
2373: SELECT devl_project_id, orig_sys_ref