APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on OKC_XPRT_TEMPLATE_RULES

Line 1238: okc_xprt_template_rules r

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

Line 1278: okc_xprt_template_rules r

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

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

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

Line 1307: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

1303: FROM dual;
1304:
1305:
1306: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1307: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1308: l_template_id okc_xprt_template_rules.template_id%TYPE;
1309: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;
1310:
1311:

Line 1308: l_template_id okc_xprt_template_rules.template_id%TYPE;

1304:
1305:
1306: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_publish';
1307: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1308: l_template_id okc_xprt_template_rules.template_id%TYPE;
1309: l_published_flag okc_xprt_rule_hdrs_all.published_flag%TYPE;
1310:
1311:
1312: BEGIN

Line 1497: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

1493: FROM dual;
1494:
1495:
1496: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1497: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1498: l_template_id okc_xprt_template_rules.template_id%TYPE;
1499:
1500:
1501: BEGIN

Line 1498: l_template_id okc_xprt_template_rules.template_id%TYPE;

1494:
1495:
1496: l_api_name CONSTANT VARCHAR2(30) := 'import_rules_disable';
1497: l_rule_id okc_xprt_template_rules.rule_id%TYPE;
1498: l_template_id okc_xprt_template_rules.template_id%TYPE;
1499:
1500:
1501: BEGIN
1502: -- start debug log

Line 1630: FROM okc_xprt_template_rules r,

1626:
1627: CURSOR csr_template_rules IS
1628: -- Local Active Rules for template
1629: SELECT r.rule_id
1630: FROM okc_xprt_template_rules r,
1631: okc_xprt_rule_hdrs_all h
1632: WHERE r.rule_id = h.rule_id
1633: AND h.status_code = 'ACTIVE'
1634: AND NVL(r.deleted_flag,'N') = 'N'

Line 1651: FROM okc_xprt_template_rules r,

1647: CURSOR csr_parent_tmpl_rules(p_parent_tmpl_id IN NUMBER) IS
1648: -- Local Active Rules on Parent Template to be deleted
1649: -- Delete rules on parent template and not on the revision template
1650: SELECT r.rule_id
1651: FROM okc_xprt_template_rules r,
1652: okc_xprt_rule_hdrs_all h
1653: WHERE r.rule_id = h.rule_id
1654: AND h.status_code = 'ACTIVE'
1655: AND NVL(r.deleted_flag,'N') = 'N'

Line 1660: FROM okc_xprt_template_rules r,

1656: AND r.template_id = p_parent_tmpl_id
1657: MINUS
1658: -- current local rules on revision template
1659: SELECT r.rule_id
1660: FROM okc_xprt_template_rules r,
1661: okc_xprt_rule_hdrs_all h
1662: WHERE r.rule_id = h.rule_id
1663: AND h.status_code = 'ACTIVE'
1664: AND NVL(r.deleted_flag,'N') = 'N'

Line 1680: l_rule_id okc_xprt_template_rules.rule_id%TYPE;

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