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_OUTCOMES

Line 1007: the left and right hand side of OKC_XPRT_RULE_CONDITIONS or in OKC_XPRT_RULE_OUTCOMES

1003: l_Intent := Template_Rec.Intent;
1004: END LOOP;
1005: /*
1006: Delete questions from the table OKC_XPRT_QUESTION_ORDERS for the template where the questions do not exist in
1007: the left and right hand side of OKC_XPRT_RULE_CONDITIONS or in OKC_XPRT_RULE_OUTCOMES
1008: for all rules associated to the template in table OKC_XPRT_TEMPLATE_RULES or rules
1009: with ORG_WIDE_FLAG='Y' and status in ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGPUB')
1010: */
1011:

Line 1040: FROM Okc_Xprt_Rule_Outcomes Outs,

1036: AND quest.question_id = Okc_Xprt_Question_Orders.Question_Id
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

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 1112: the left and right hand side of OKC_XPRT_RULE_CONDITIONS or in OKC_XPRT_RULE_OUTCOMES

1108:
1109: /*
1110: 2. Open cursor to select questions for the template
1111: FROM
1112: the left and right hand side of OKC_XPRT_RULE_CONDITIONS or in OKC_XPRT_RULE_OUTCOMES
1113: for all rules associated to the template in table OKC_XPRT_TEMPLATE_RULES or rules with ORG_WIDE_FLAG='Y' and status = 'ACTIVE'
1114: */
1115:
1116: IF (Fnd_Log.Level_Procedure >= Fnd_Log.g_Current_Runtime_Level) THEN

Line 1146: FROM Okc_Xprt_Rule_Outcomes Outs,

1142: AND Cond.Object_Value_Type = 'QUESTION'
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

Line 1176: FROM Okc_Xprt_Rule_Outcomes Outs,

1172: AND Cond.Object_Value_Type = 'QUESTION'
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

Line 1277: FROM Okc_Xprt_Rule_Outcomes Outs,

1273: AND Rules.Status_Code IN ('PENDINGPUB')
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

Line 1310: FROM Okc_Xprt_Rule_Outcomes Outs,

1306: AND Rules.Status_Code IN ('PENDINGPUB')
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

Line 1450: FROM Okc_Xprt_Rule_Outcomes Outs,

1446: Last_Update_Login = l_login_id
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

Line 1470: FROM Okc_Xprt_Rule_Outcomes Outs,

1466: Last_Update_Login = l_login_id
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'

Line 1582: FROM Okc_Xprt_Rule_Outcomes Outs,

1578: Last_Update_Login = l_login_id
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

Line 1594: FROM Okc_Xprt_Rule_Outcomes Outs,

1590: AND Rules.Status_Code = 'ACTIVE'
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'

Line 1615: FROM Okc_Xprt_Rule_Outcomes Outs,

1611: Last_Update_Login = l_login_id
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

Line 1628: FROM Okc_Xprt_Rule_Outcomes Outs,

1624: AND Rules.Request_Id = l_conc_request_id
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'

Line 1758: FROM OKC_XPRT_RULE_OUTCOMES

1754: (object_value_type IN ('QUESTION','CONSTANT') AND
1755: object_value_code = to_char(p_question_id)) -- Added for bug 5663927
1756: UNION
1757: SELECT 'N'
1758: FROM OKC_XPRT_RULE_OUTCOMES
1759: WHERE object_type = 'QUESTION'
1760: AND object_value_id = p_question_id;
1761:
1762: l_ret VARCHAR2(1) := 'Y';

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 4746: FROM okc_xprt_rule_outcomes o

4742: AND c.rule_id = p_rule_id ;
4743:
4744: CURSOR csr_out_clause_exits IS
4745: SELECT 'X'
4746: FROM okc_xprt_rule_outcomes o
4747: WHERE o.rule_id = p_rule_id
4748: AND o.object_type = 'CLAUSE'
4749: AND o.object_value_id = p_clause_id ;
4750:

Line 4895: FROM okc_xprt_rule_outcomes xro

4891: AND cond.object_type ='QUESTION'
4892: AND cond.object_code=to_char(p_question_id)
4893: UNION ALL
4894: SELECT 'x'
4895: FROM okc_xprt_rule_outcomes xro
4896: WHERE xro.rule_id =p_rule_id
4897: AND xro.object_type='QUESTION'
4898: AND xro.object_value_id=p_question_id;
4899:

Line 6672: FROM okc_xprt_rule_outcomes o

6668: AND v.object_value_code = to_char(p_article_id) -- Added to_char function. Fix for Bug 4063007
6669: UNION ALL
6670: -- All Clauses from Outcome
6671: SELECT 'N'
6672: FROM okc_xprt_rule_outcomes o
6673: WHERE o.object_type = 'CLAUSE'
6674: AND o.object_value_id = p_article_id ; -- Removed to_char which is not needed here
6675:
6676: l_delete_flag VARCHAR2(1);

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 10609: FROM okc_xprt_rule_outcomes xro

10605: WHERE cond.rule_id = p_rule_id
10606: AND cond.object_type ='QUESTION'
10607: UNION ALL
10608: SELECT object_value_id||'' question_id
10609: FROM okc_xprt_rule_outcomes xro
10610: WHERE xro.rule_id = p_rule_id
10611: AND xro.object_type='QUESTION';
10612:
10613: CURSOR csr_main IS

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'