APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on OKC_XPRT_TEMPLATE_RULES

Line 1252: okc_xprt_template_rules r

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'
1256: AND NVL(r.deleted_flag,'N') = 'N'

Line 1292: okc_xprt_template_rules r

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'
1296: AND NVL(r.deleted_flag,'N') = 'N'

Line 1303: --,okc_xprt_template_rules tr -- Added for Bug 5005681

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
1306: --AND tr.rule_id = r.rule_id -- Added for Bug 5005681
1307: AND t.intent = r.intent

Line 1321: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

1317: FROM dual;
1318:
1319:
1320: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1321: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1322: l_template_id okc_xprt_template_rules.template_id%TYPE;
1323: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;
1324:
1325:

Line 1322: l_template_id okc_xprt_template_rules.template_id%TYPE;

1318:
1319:
1320: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1321: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1322: l_template_id okc_xprt_template_rules.template_id%TYPE;
1323: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;
1324:
1325:
1326: BEGIN

Line 1511: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

1507: FROM dual;
1508:
1509:
1510: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1511: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1512: l_template_id okc_xprt_template_rules.template_id%TYPE;
1513:
1514:
1515: BEGIN

Line 1512: l_template_id okc_xprt_template_rules.template_id%TYPE;

1508:
1509:
1510: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1511: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1512: l_template_id okc_xprt_template_rules.template_id%TYPE;
1513:
1514:
1515: BEGIN
1516: -- start debug log

Line 1644: FROM okc_xprt_template_rules r,

1640:
1641: CURSOR csr_template_rules IS
1642: -- Local Active Rules for template
1643: SELECT r.rule_id
1644: FROM okc_xprt_template_rules r,
1645: okc_xprt_rule_hdrs_all h
1646: WHERE r.rule_id = h.rule_id
1647: AND h.status_code = 'ACTIVE'
1648: AND NVL(r.deleted_flag,'N') = 'N'

Line 1665: FROM okc_xprt_template_rules r,

1661: CURSOR csr_parent_tmpl_rules(p_parent_tmpl_id IN NUMBER) IS
1662: -- Local Active Rules on Parent Template to be deleted
1663: -- Delete rules on parent template and not on the revision template
1664: SELECT r.rule_id
1665: FROM okc_xprt_template_rules r,
1666: okc_xprt_rule_hdrs_all h
1667: WHERE r.rule_id = h.rule_id
1668: AND h.status_code = 'ACTIVE'
1669: AND NVL(r.deleted_flag,'N') = 'N'

Line 1674: FROM okc_xprt_template_rules r,

1670: AND r.template_id = p_parent_tmpl_id
1671: MINUS
1672: -- current local rules on revision template
1673: SELECT r.rule_id
1674: FROM okc_xprt_template_rules r,
1675: okc_xprt_rule_hdrs_all h
1676: WHERE r.rule_id = h.rule_id
1677: AND h.status_code = 'ACTIVE'
1678: AND NVL(r.deleted_flag,'N') = 'N'

Line 1694: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

1690: FROM dual;
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: