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_XPRT_RULE_HDRS_ALL

Line 407: FROM okc_xprt_rule_hdrs_all rhdr,

403:
404: CURSOR c1 IS
405: --Check the Variable Type for line level
406: SELECT NVL(v.line_level_flag,'N') line_level_flag
407: FROM okc_xprt_rule_hdrs_all rhdr,
408: okc_xprt_rule_conditions rcon,
409: okc_bus_variables_b v
410: WHERE rhdr.rule_id = rcon.rule_id
411: AND rcon.object_type = 'VARIABLE'

Line 418: FROM okc_xprt_rule_hdrs_all rhdr,

414: AND v.line_level_flag = 'Y'
415: AND rhdr.rule_id = p_rule_id
416: UNION
417: SELECT NVL(v.line_level_flag,'N') line_level_flag
418: FROM okc_xprt_rule_hdrs_all rhdr,
419: okc_xprt_rule_conditions rcon,
420: okc_bus_variables_b v
421: WHERE rhdr.rule_id = rcon.rule_id
422: AND rcon.object_value_type = 'VARIABLE'

Line 489: okc_xprt_rule_hdrs_all h

485: CURSOR csr_local_rules_templates IS
486: -- Local Rules on Template
487: SELECT 'X'
488: FROM okc_xprt_template_rules r,
489: okc_xprt_rule_hdrs_all h
490: WHERE r.rule_id = h.rule_id
491: AND h.status_code = 'ACTIVE'
492: AND template_id = p_template_id ;
493:

Line 498: okc_xprt_rule_hdrs_all h

494: CURSOR csr_org_rules_templates IS
495: -- Org Wide Rules
496: SELECT 'X'
497: FROM okc_terms_templates_all t,
498: okc_xprt_rule_hdrs_all h
499: WHERE t.org_id = h.org_id
500: AND t.intent = h.intent
501: AND h.status_code = 'ACTIVE'
502: AND NVL(h.org_wide_flag,'N') = 'Y'

Line 1025: okc_xprt_rule_hdrs_all Rules,

1021: WHERE Template_Id = p_Template_Id
1022: AND NOT EXISTS
1023: (SELECT 1
1024: FROM Okc_Xprt_Rule_Conditions Cond,
1025: okc_xprt_rule_hdrs_all Rules,
1026: Okc_Xprt_Template_Rules Assoc,
1027: Okc_xprt_questions_b quest
1028: WHERE Rules.Rule_Id = Cond.Rule_Id
1029: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1041: okc_xprt_rule_hdrs_all Rules,

1037: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1038: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1039: SELECT 1
1040: FROM Okc_Xprt_Rule_Outcomes Outs,
1041: okc_xprt_rule_hdrs_all Rules,
1042: Okc_Xprt_Template_Rules Assoc,
1043: Okc_xprt_questions_b quest
1044: WHERE Rules.Rule_Id = Assoc.Rule_Id
1045: AND Rules.rule_id = Outs.rule_id

Line 1054: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,

1050: AND quest.question_id = Okc_Xprt_Question_Orders.Question_Id
1051: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1052: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1053: SELECT 1
1054: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,
1055: Okc_xprt_questions_b quest
1056: WHERE Rules.Rule_Id = Cond.Rule_Id
1057: AND Rules.Org_Wide_Flag = 'Y'
1058: AND Rules.Org_Id = l_Org_Id

Line 1069: FROM Okc_Xprt_Rule_Outcomes Outs, okc_xprt_rule_hdrs_all Rules,

1065: AND quest.question_id = Okc_Xprt_Question_Orders.Question_Id
1066: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1067: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1068: SELECT 1
1069: FROM Okc_Xprt_Rule_Outcomes Outs, okc_xprt_rule_hdrs_all Rules,
1070: Okc_xprt_questions_b quest
1071: WHERE Rules.Rule_Id = Outs.Rule_Id
1072: AND Rules.Org_Wide_Flag = 'Y'
1073: AND Rules.Org_Id = l_Org_Id

Line 1127: okc_xprt_rule_hdrs_all Rules,

1123: CURSOR Active_Draft_Rule_Questions IS
1124: SELECT * FROM (
1125: SELECT distinct To_Number(Cond.Object_Code) Question_Id, Rules.Status_Code
1126: FROM Okc_Xprt_Rule_Conditions Cond,
1127: okc_xprt_rule_hdrs_all Rules,
1128: Okc_Xprt_Template_Rules Assoc
1129: WHERE Rules.Rule_Id = Cond.Rule_Id
1130: AND Rules.Rule_Id = Assoc.Rule_Id
1131: AND Assoc.Template_Id = p_Template_Id

Line 1137: okc_xprt_rule_hdrs_all Rules,

1133: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1134: UNION
1135: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id, Rules.Status_Code
1136: FROM Okc_Xprt_Rule_Conditions Cond,
1137: okc_xprt_rule_hdrs_all Rules,
1138: Okc_Xprt_Template_Rules Assoc
1139: WHERE Rules.Rule_Id = Cond.Rule_Id
1140: AND Rules.Rule_Id = Assoc.Rule_Id
1141: AND Assoc.Template_Id = p_Template_Id

Line 1147: okc_xprt_rule_hdrs_all Rules,

1143: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1144: UNION
1145: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id, Rules.Status_Code
1146: FROM Okc_Xprt_Rule_Outcomes Outs,
1147: okc_xprt_rule_hdrs_all Rules,
1148: Okc_Xprt_Template_Rules Assoc
1149: WHERE Rules.Rule_Id = Assoc.Rule_Id
1150: AND Assoc.Template_Id = p_Template_Id
1151: AND Outs.Object_Type = 'QUESTION'

Line 1157: okc_xprt_rule_hdrs_all Rules

1153: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1154: UNION
1155: SELECT distinct To_Number(Cond.Object_Code) Question_Id, Rules.Status_Code
1156: FROM Okc_Xprt_Rule_Conditions Cond,
1157: okc_xprt_rule_hdrs_all Rules
1158: WHERE Rules.Rule_Id = Cond.Rule_Id
1159: AND Rules.Org_Wide_Flag = 'Y'
1160: AND Rules.Org_Id = l_Org_Id
1161: AND Rules.Intent = l_Intent

Line 1167: okc_xprt_rule_hdrs_all Rules

1163: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1164: UNION
1165: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id, Rules.Status_Code
1166: FROM Okc_Xprt_Rule_Conditions Cond,
1167: okc_xprt_rule_hdrs_all Rules
1168: WHERE Rules.Rule_Id = Cond.Rule_Id
1169: AND Rules.Org_Wide_Flag = 'Y'
1170: AND Rules.Org_Id = l_Org_Id
1171: AND Rules.Intent = l_Intent

Line 1177: okc_xprt_rule_hdrs_all Rules

1173: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1174: UNION
1175: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id, Rules.Status_Code
1176: FROM Okc_Xprt_Rule_Outcomes Outs,
1177: okc_xprt_rule_hdrs_all Rules
1178: WHERE Rules.Rule_Id = Outs.Rule_Id
1179: AND Rules.Org_Wide_Flag = 'Y'
1180: AND Rules.Org_Id = l_Org_Id
1181: AND Rules.Intent = l_Intent

Line 1256: okc_xprt_rule_hdrs_all Rules,

1252: DECLARE
1253: CURSOR Pending_Rule_Questions IS
1254: SELECT distinct To_Number(Cond.Object_Code) Question_Id
1255: FROM Okc_Xprt_Rule_Conditions Cond,
1256: okc_xprt_rule_hdrs_all Rules,
1257: Okc_Xprt_Template_Rules Assoc
1258: WHERE Rules.Rule_Id = Cond.Rule_Id
1259: AND Rules.Rule_Id = Assoc.Rule_Id
1260: AND Assoc.Template_Id = p_Template_Id

Line 1267: okc_xprt_rule_hdrs_all Rules,

1263: AND Rules.Request_Id = l_conc_request_id
1264: UNION
1265: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id
1266: FROM Okc_Xprt_Rule_Conditions Cond,
1267: okc_xprt_rule_hdrs_all Rules,
1268: Okc_Xprt_Template_Rules Assoc
1269: WHERE Rules.Rule_Id = Cond.Rule_Id
1270: AND Rules.Rule_Id = Assoc.Rule_Id
1271: AND Assoc.Template_Id = p_Template_Id

Line 1278: okc_xprt_rule_hdrs_all Rules,

1274: AND Rules.Request_Id = l_conc_request_id
1275: UNION
1276: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id
1277: FROM Okc_Xprt_Rule_Outcomes Outs,
1278: okc_xprt_rule_hdrs_all Rules,
1279: Okc_Xprt_Template_Rules Assoc
1280: WHERE Rules.Rule_Id = Assoc.Rule_Id
1281: AND Assoc.Template_Id = p_Template_Id
1282: AND Outs.Object_Type = 'QUESTION'

Line 1289: okc_xprt_rule_hdrs_all Rules

1285: AND Rules.Request_Id = l_conc_request_id
1286: UNION
1287: SELECT distinct To_Number(Cond.Object_Code) Question_Id
1288: FROM Okc_Xprt_Rule_Conditions Cond,
1289: okc_xprt_rule_hdrs_all Rules
1290: WHERE Rules.Rule_Id = Cond.Rule_Id
1291: AND Rules.Org_Wide_Flag = 'Y'
1292: AND Rules.Org_Id = l_Org_Id
1293: AND Rules.Intent = l_Intent

Line 1300: okc_xprt_rule_hdrs_all Rules

1296: AND Rules.Request_Id = l_conc_request_id
1297: UNION
1298: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id
1299: FROM Okc_Xprt_Rule_Conditions Cond,
1300: okc_xprt_rule_hdrs_all Rules
1301: WHERE Rules.Rule_Id = Cond.Rule_Id
1302: AND Rules.Org_Wide_Flag = 'Y'
1303: AND Rules.Org_Id = l_Org_Id
1304: AND Rules.Intent = l_Intent

Line 1311: okc_xprt_rule_hdrs_all Rules

1307: AND Rules.Request_Id = l_conc_request_id
1308: UNION
1309: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id
1310: FROM Okc_Xprt_Rule_Outcomes Outs,
1311: okc_xprt_rule_hdrs_all Rules
1312: WHERE Rules.Rule_Id = Outs.Rule_Id
1313: AND Rules.Org_Wide_Flag = 'Y'
1314: AND Rules.Org_Id = l_Org_Id
1315: AND Rules.Intent = l_Intent

Line 1405: okc_xprt_rule_hdrs_all Rules,

1401: WHERE Template_Id = p_Template_Id
1402: AND Question_Id IN
1403: (SELECT Ord.Question_Id
1404: FROM Okc_Xprt_Rule_Conditions Cond,
1405: okc_xprt_rule_hdrs_all Rules,
1406: Okc_Xprt_Template_Rules Assoc,
1407: Okc_Xprt_Question_Orders Ord
1408: WHERE Rules.Rule_Id = Cond.Rule_Id
1409: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1428: okc_xprt_rule_hdrs_all Rules,

1424: WHERE Template_Id = p_Template_Id
1425: AND Question_Id IN
1426: (SELECT Ord.Question_Id
1427: FROM Okc_Xprt_Rule_Conditions Cond,
1428: okc_xprt_rule_hdrs_all Rules,
1429: Okc_Xprt_Question_Orders Ord
1430: WHERE Rules.Rule_Id = Cond.Rule_Id
1431: AND Rules.Org_Wide_Flag = 'Y'
1432: AND Rules.Org_Id = l_Org_Id

Line 1451: okc_xprt_rule_hdrs_all Rules,

1447: WHERE Template_Id = p_Template_Id
1448: AND Question_Id IN
1449: (SELECT Ord.Question_Id
1450: FROM Okc_Xprt_Rule_Outcomes Outs,
1451: okc_xprt_rule_hdrs_all Rules,
1452: Okc_Xprt_Template_Rules Assoc,
1453: Okc_Xprt_Question_Orders Ord
1454: WHERE Rules.Rule_Id = Assoc.Rule_Id
1455: AND Assoc.Template_Id = p_Template_Id

Line 1471: okc_xprt_rule_hdrs_all Rules,

1467: WHERE Template_Id = p_Template_Id
1468: AND Question_Id IN
1469: (SELECT Ord.Question_Id
1470: FROM Okc_Xprt_Rule_Outcomes Outs,
1471: okc_xprt_rule_hdrs_all Rules,
1472: Okc_Xprt_Question_Orders Ord
1473: WHERE Rules.Rule_Id = Outs.Rule_Id
1474: AND Rules.Org_Wide_Flag = 'Y'
1475: AND Rules.Org_Id = l_Org_Id

Line 1500: okc_xprt_rule_hdrs_all Rules,

1496: WHERE Template_Id = p_Template_Id
1497: AND Question_Id IN
1498: (SELECT Ord.Question_Id
1499: FROM Okc_Xprt_Rule_Conditions Cond,
1500: okc_xprt_rule_hdrs_all Rules,
1501: Okc_Xprt_Template_Rules Assoc,
1502: Okc_Xprt_Question_Orders Ord
1503: WHERE Rules.Rule_Id = Cond.Rule_Id
1504: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1516: okc_xprt_rule_hdrs_all Rules,

1512: AND Rules.Status_Code = 'ACTIVE'
1513: UNION
1514: SELECT Ord.Question_Id
1515: FROM Okc_Xprt_Rule_Conditions Cond,
1516: okc_xprt_rule_hdrs_all Rules,
1517: Okc_Xprt_Question_Orders Ord
1518: WHERE Rules.Rule_Id = Cond.Rule_Id
1519: AND Rules.Org_Wide_Flag = 'Y'
1520: AND Rules.Org_Id = l_Org_Id

Line 1541: okc_xprt_rule_hdrs_all Rules,

1537: WHERE Template_Id = p_Template_Id
1538: AND Question_Id IN
1539: (SELECT Ord.Question_Id
1540: FROM Okc_Xprt_Rule_Conditions Cond,
1541: okc_xprt_rule_hdrs_all Rules,
1542: Okc_Xprt_Template_Rules Assoc,
1543: Okc_Xprt_Question_Orders Ord
1544: WHERE Rules.Rule_Id = Cond.Rule_Id
1545: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1558: okc_xprt_rule_hdrs_all Rules,

1554: AND Rules.Request_Id = l_conc_request_id
1555: UNION
1556: SELECT Ord.Question_Id
1557: FROM Okc_Xprt_Rule_Conditions Cond,
1558: okc_xprt_rule_hdrs_all Rules,
1559: Okc_Xprt_Question_Orders Ord
1560: WHERE Rules.Rule_Id = Cond.Rule_Id
1561: AND Rules.Org_Wide_Flag = 'Y'
1562: AND Rules.Org_Id = l_Org_Id

Line 1583: okc_xprt_rule_hdrs_all Rules,

1579: WHERE Template_Id = p_Template_Id
1580: AND Question_Id IN
1581: (SELECT Ord.Question_Id
1582: FROM Okc_Xprt_Rule_Outcomes Outs,
1583: okc_xprt_rule_hdrs_all Rules,
1584: Okc_Xprt_Template_Rules Assoc,
1585: Okc_Xprt_Question_Orders Ord
1586: WHERE Rules.Rule_Id = Assoc.Rule_Id
1587: AND Assoc.Template_Id = p_Template_Id

Line 1595: okc_xprt_rule_hdrs_all Rules,

1591: AND rules.rule_id = outs.rule_id
1592: UNION
1593: SELECT Ord.Question_Id
1594: FROM Okc_Xprt_Rule_Outcomes Outs,
1595: okc_xprt_rule_hdrs_all Rules,
1596: Okc_Xprt_Question_Orders Ord
1597: WHERE Rules.Rule_Id = Outs.Rule_Id
1598: AND Rules.Org_Wide_Flag = 'Y'
1599: AND Rules.Org_Id = l_Org_Id

Line 1616: okc_xprt_rule_hdrs_all Rules,

1612: WHERE Template_Id = p_Template_Id
1613: AND Question_Id IN
1614: (SELECT Ord.Question_Id
1615: FROM Okc_Xprt_Rule_Outcomes Outs,
1616: okc_xprt_rule_hdrs_all Rules,
1617: Okc_Xprt_Template_Rules Assoc,
1618: Okc_Xprt_Question_Orders Ord
1619: WHERE Rules.Rule_Id = Assoc.Rule_Id
1620: AND Assoc.Template_Id = p_Template_Id

Line 1629: okc_xprt_rule_hdrs_all Rules,

1625: AND rules.rule_id = outs.rule_id
1626: UNION
1627: SELECT Ord.Question_Id
1628: FROM Okc_Xprt_Rule_Outcomes Outs,
1629: okc_xprt_rule_hdrs_all Rules,
1630: Okc_Xprt_Question_Orders Ord
1631: WHERE Rules.Rule_Id = Outs.Rule_Id
1632: AND Rules.Org_Wide_Flag = 'Y'
1633: AND Rules.Org_Id = l_Org_Id

Line 1819: FROM okc_xprt_rule_hdrs_all

1815: */
1816:
1817: CURSOR csr_rules IS
1818: SELECT rule_id
1819: FROM okc_xprt_rule_hdrs_all
1820: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
1821:
1822: CURSOR csr_get_publication_id (p_template_model_id NUMBER, p_publication_mode VARCHAR2) IS
1823: SELECT publication_id ,

Line 1837: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;

1833: l_template_model_id okc_terms_templates_all.template_model_id%TYPE;
1834: l_run_id NUMBER;
1835: l_publication_id cz_model_publications.publication_id%TYPE;
1836: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1837: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1838: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1839:
1840: --Bug 5032199 Using REF cursor
1841: TYPE cur_type IS REF CURSOR;

Line 1838: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;

1834: l_run_id NUMBER;
1835: l_publication_id cz_model_publications.publication_id%TYPE;
1836: l_ui_def_id cz_model_publications.ui_def_id%TYPE;
1837: l_rule_id okc_xprt_rule_hdrs_all.rule_id%TYPE;
1838: l_line_level_flag okc_xprt_rule_hdrs_all.line_level_flag%TYPE;
1839:
1840: --Bug 5032199 Using REF cursor
1841: TYPE cur_type IS REF CURSOR;
1842: csr_templates cur_type;

Line 2102: UPDATE okc_xprt_rule_hdrs_all

2098: EXIT WHEN csr_rules%NOTFOUND;
2099:
2100: SELECT okc_xprt_util_pvt.is_rule_line_level(l_rule_id) INTO l_line_level_flag FROM DUAL;
2101:
2102: UPDATE okc_xprt_rule_hdrs_all
2103: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
2104: published_flag = 'Y',
2105: line_level_flag = l_line_level_flag, --is_rule_line_level(l_rule_id),
2106: last_updated_by = FND_GLOBAL.USER_ID,

Line 2239: FROM okc_xprt_rule_hdrs_all r,

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

Line 2250: okc_xprt_rule_hdrs_all r

2246: UNION ALL
2247: -- Local rules not active
2248: SELECT 'X'
2249: FROM okc_xprt_template_rules tr,
2250: okc_xprt_rule_hdrs_all r
2251: WHERE tr.template_id = p_template_id
2252: AND tr.rule_id = r.rule_id
2253: AND r.status_code NOT IN ('ACTIVE','INACTIVE');
2254:

Line 2258: FROM okc_xprt_rule_hdrs_all r,

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

Line 2269: okc_xprt_rule_hdrs_all r

2265: UNION ALL
2266: -- Local Active rules
2267: SELECT 'X'
2268: FROM okc_xprt_template_rules tr,
2269: okc_xprt_rule_hdrs_all r
2270: WHERE tr.template_id = p_template_id
2271: AND tr.rule_id = r.rule_id
2272: AND r.status_code = 'ACTIVE' ;
2273:

Line 3230: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

3226: -- that are in the OKC rules engine
3227:
3228: CURSOR c_expert_articles_from_ruleng IS
3229: SELECT distinct outcome.object_value_id
3230: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
3231: WHERE rultmp.doc_id = p_document_id
3232: AND rultmp.doc_type = p_document_type
3233: AND rultmp.condition_id IS NULL
3234: AND nvl(rultmp.result, '*' ) = 'Y'

Line 3296: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

3292: AND NVL(kart.SUMMARY_AMEND_OPERATION_CODE, '?') <> 'DELETED'
3293: --AND (nvl(nvl(kart.ref_article_id, kart.sav_sae_id), -1) not in (
3294: AND (kart.orig_article_id NOT IN (
3295: SELECT distinct outcome.object_value_id
3296: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
3297: WHERE rultmp.doc_id = p_document_id
3298: AND rultmp.doc_type = p_document_type
3299: AND rultmp.condition_id IS NULL
3300: AND nvl(rultmp.result, '*' ) = 'Y'

Line 3850: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

3846: --cursors used for new OKC rules engine
3847:
3848: CURSOR c_all_expert_articles IS
3849: SELECT distinct outcome.object_value_id
3850: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
3851: WHERE rultmp.doc_id = p_document_id
3852: AND rultmp.doc_type = p_document_type
3853: AND rultmp.condition_id IS NULL
3854: AND nvl(rultmp.result, '*' ) = 'Y'

Line 3862: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver

3858: AND outcome.object_type = 'CLAUSE';
3859:
3860: CURSOR c_expert_nonprovision_articles IS
3861: SELECT distinct outcome.object_value_id
3862: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver
3863: WHERE rultmp.doc_id = p_document_id
3864: AND rultmp.doc_type = p_document_type
3865: AND rultmp.condition_id IS NULL
3866: AND nvl(rultmp.result, '*' ) = 'Y'

Line 4942: FROM okc_xprt_rule_hdrs_all rule

4938: CURSOR all_rules IS
4939:
4940: -- org wide rules applicable to given template
4941: SELECT 'x'
4942: FROM okc_xprt_rule_hdrs_all rule
4943: WHERE rule.rule_id = p_rule_id
4944: AND rule.org_wide_flag = 'Y'
4945: AND (rule.intent, rule.org_id) in (select intent, org_id from okc_terms_templates_all where template_id = p_template_id)
4946:

Line 4951: FROM okc_xprt_rule_hdrs_all xrh,

4947: UNION ALL
4948:
4949: --template specific rules
4950: SELECT 'x'
4951: FROM okc_xprt_rule_hdrs_all xrh,
4952: okc_xprt_template_rules xtr
4953: WHERE xrh.rule_id = xtr.rule_id
4954: AND xrh.rule_id = p_rule_id
4955: AND template_id=p_template_id;

Line 4994: from okc_xprt_rule_hdrs_all

4990:
4991: IS
4992: CURSOR c1 is
4993: select 'x'
4994: from okc_xprt_rule_hdrs_all
4995: where org_wide_flag='Y';
4996: --Bug#4779070 commented below condition
4997: /*and NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
4998: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,

Line 6096: UPDATE okc_xprt_rule_hdrs_all

6092:
6093: x_return_status := G_RET_STS_SUCCESS;
6094:
6095: -- Update Rule status
6096: UPDATE okc_xprt_rule_hdrs_all
6097: SET status_code = DECODE (p_calling_mode, 'PUBLISH', 'ACTIVE', 'DISABLE', 'INACTIVE', 'SYNC', 'ACTIVE'),
6098: published_flag = 'Y',
6099: last_updated_by = FND_GLOBAL.USER_ID,
6100: last_update_date = SYSDATE,

Line 6177: FROM okc_xprt_rule_hdrs_all

6173:
6174: -- Rules under Publication
6175: CURSOR csr_publish_rules IS
6176: SELECT rule_id
6177: FROM okc_xprt_rule_hdrs_all
6178: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
6179:
6180: -- Rules attached to template
6181: CURSOR csr_approval_rules IS

Line 6185: okc_xprt_rule_hdrs_all h

6181: CURSOR csr_approval_rules IS
6182: -- Local Rules on Template
6183: SELECT r.rule_id
6184: FROM okc_xprt_template_rules r,
6185: okc_xprt_rule_hdrs_all h
6186: WHERE r.rule_id = h.rule_id
6187: AND h.status_code = 'ACTIVE'
6188: AND r.template_id = p_template_id
6189: UNION ALL

Line 6192: okc_xprt_rule_hdrs_all h

6188: AND r.template_id = p_template_id
6189: UNION ALL
6190: SELECT h.rule_id
6191: FROM okc_terms_templates_all t,
6192: okc_xprt_rule_hdrs_all h
6193: WHERE t.org_id = h.org_id
6194: AND t.intent = h.intent
6195: AND h.status_code = 'ACTIVE'
6196: AND NVL(h.org_wide_flag,'N') = 'Y'

Line 7098: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

7094: --cursors used for new OKC rules engine
7095:
7096: CURSOR c_all_expert_articles IS
7097: SELECT distinct outcome.object_value_id
7098: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
7099: WHERE rultmp.doc_id = p_document_id
7100: AND rultmp.doc_type = p_document_type
7101: AND rultmp.condition_id IS NULL
7102: AND nvl(rultmp.result, '*' ) = 'Y'

Line 7110: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver

7106: AND outcome.object_type = 'CLAUSE';
7107:
7108: CURSOR c_expert_nonprovision_articles IS
7109: SELECT distinct outcome.object_value_id
7110: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver
7111: WHERE rultmp.doc_id = p_document_id
7112: AND rultmp.doc_type = p_document_type
7113: AND rultmp.condition_id IS NULL
7114: AND nvl(rultmp.result, '*' ) = 'Y'

Line 7125: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul

7121: AND nvl(ver.provision_yn, '*') = 'N';
7122:
7123: CURSOR c_expert_deviations IS
7124: SELECT null line_number, rul.rule_id
7125: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul
7126: WHERE rultmp.doc_id = p_document_id
7127: AND rultmp.doc_type = p_document_type
7128: AND rultmp.condition_id IS NULL
7129: AND nvl(rultmp.result, '*' ) = 'Y'

Line 8142: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

8138: l_api_version CONSTANT NUMBER := 1;
8139: l_api_name CONSTANT VARCHAR2(30) := 'populate_terms_deviations_tbl';
8140:
8141: j BINARY_INTEGER :=0;
8142: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
8143: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
8144: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
8145: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
8146:

Line 8143: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;

8139: l_api_name CONSTANT VARCHAR2(30) := 'populate_terms_deviations_tbl';
8140:
8141: j BINARY_INTEGER :=0;
8142: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
8143: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
8144: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
8145: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
8146:
8147: l_article_id NUMBER;

Line 8167: FROM okc_xprt_rule_hdrs_all

8163: --
8164: CURSOR l_get_rul_details_csr (p_rule_id NUMBER) IS
8165: SELECT rule_name,
8166: rule_description
8167: FROM okc_xprt_rule_hdrs_all
8168: WHERE rule_id = p_rule_id;
8169:
8170: --
8171: -- Currsor to Select Item name and Description

Line 10580: okc_xprt_rule_hdrs_all rhdr

10576:
10577: CURSOR csr_rules(p_org_id NUMBER, p_intent VARCHAR2) IS
10578: SELECT tr.rule_id
10579: FROM okc_xprt_template_rules tr,
10580: okc_xprt_rule_hdrs_all rhdr
10581: WHERE tr.rule_id = rhdr.rule_id
10582: AND tr.template_id = p_template_id
10583: AND rhdr.rule_type = p_rule_type
10584: AND rhdr.status_code IN ('ACTIVE','PENDING_PUB')

Line 10588: okc_xprt_rule_hdrs_all r

10584: AND rhdr.status_code IN ('ACTIVE','PENDING_PUB')
10585: UNION ALL
10586: SELECT r.rule_id
10587: FROM OKC_TERMS_TEMPLATES_ALL t,
10588: okc_xprt_rule_hdrs_all r
10589: WHERE t.org_id = p_org_id
10590: AND t.intent = p_intent
10591: AND r.rule_type = p_rule_type
10592: AND r.status_code IN ('ACTIVE','PENDING_PUB')

Line 10883: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

10879: -- Currsor to Select the Expert Articles
10880:
10881: CURSOR c_get_expert_articles IS
10882: SELECT distinct outcome.object_value_id
10883: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
10884: WHERE rultmp.doc_id = p_document_id
10885: AND rultmp.doc_type = p_document_type
10886: AND rultmp.condition_id IS NULL
10887: AND nvl(rultmp.result, '*' ) = 'Y'