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.

[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_RULE_OUTCOMES

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

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

Line 1038: FROM Okc_Xprt_Rule_Outcomes Outs,

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

Line 1067: FROM Okc_Xprt_Rule_Outcomes Outs, okc_xprt_rule_hdrs_all Rules,

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

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

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

Line 1144: FROM Okc_Xprt_Rule_Outcomes Outs,

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

Line 1174: FROM Okc_Xprt_Rule_Outcomes Outs,

1170: AND Cond.Object_Value_Type = 'QUESTION'
1171: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1172: UNION
1173: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id, Rules.Status_Code
1174: FROM Okc_Xprt_Rule_Outcomes Outs,
1175: okc_xprt_rule_hdrs_all Rules
1176: WHERE Rules.Rule_Id = Outs.Rule_Id
1177: AND Rules.Org_Wide_Flag = 'Y'
1178: AND Rules.Org_Id = l_Org_Id

Line 1275: FROM Okc_Xprt_Rule_Outcomes Outs,

1271: AND Rules.Status_Code IN ('PENDINGPUB')
1272: AND Rules.Request_Id = l_conc_request_id
1273: UNION
1274: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id
1275: FROM Okc_Xprt_Rule_Outcomes Outs,
1276: okc_xprt_rule_hdrs_all Rules,
1277: Okc_Xprt_Template_Rules Assoc
1278: WHERE Rules.Rule_Id = Assoc.Rule_Id
1279: AND Assoc.Template_Id = p_Template_Id

Line 1308: FROM Okc_Xprt_Rule_Outcomes Outs,

1304: AND Rules.Status_Code IN ('PENDINGPUB')
1305: AND Rules.Request_Id = l_conc_request_id
1306: UNION
1307: SELECT distinct To_Number(Outs.Object_Value_Id) Question_Id
1308: FROM Okc_Xprt_Rule_Outcomes Outs,
1309: okc_xprt_rule_hdrs_all Rules
1310: WHERE Rules.Rule_Id = Outs.Rule_Id
1311: AND Rules.Org_Wide_Flag = 'Y'
1312: AND Rules.Org_Id = l_Org_Id

Line 1448: FROM Okc_Xprt_Rule_Outcomes Outs,

1444: Last_Update_Login = l_login_id
1445: WHERE Template_Id = p_Template_Id
1446: AND Question_Id IN
1447: (SELECT Ord.Question_Id
1448: FROM Okc_Xprt_Rule_Outcomes Outs,
1449: okc_xprt_rule_hdrs_all Rules,
1450: Okc_Xprt_Template_Rules Assoc,
1451: Okc_Xprt_Question_Orders Ord
1452: WHERE Rules.Rule_Id = Assoc.Rule_Id

Line 1468: FROM Okc_Xprt_Rule_Outcomes Outs,

1464: Last_Update_Login = l_login_id
1465: WHERE Template_Id = p_Template_Id
1466: AND Question_Id IN
1467: (SELECT Ord.Question_Id
1468: FROM Okc_Xprt_Rule_Outcomes Outs,
1469: okc_xprt_rule_hdrs_all Rules,
1470: Okc_Xprt_Question_Orders Ord
1471: WHERE Rules.Rule_Id = Outs.Rule_Id
1472: AND Rules.Org_Wide_Flag = 'Y'

Line 1580: FROM Okc_Xprt_Rule_Outcomes Outs,

1576: Last_Update_Login = l_login_id
1577: WHERE Template_Id = p_Template_Id
1578: AND Question_Id IN
1579: (SELECT Ord.Question_Id
1580: FROM Okc_Xprt_Rule_Outcomes Outs,
1581: okc_xprt_rule_hdrs_all Rules,
1582: Okc_Xprt_Template_Rules Assoc,
1583: Okc_Xprt_Question_Orders Ord
1584: WHERE Rules.Rule_Id = Assoc.Rule_Id

Line 1592: FROM Okc_Xprt_Rule_Outcomes Outs,

1588: AND Rules.Status_Code = 'ACTIVE'
1589: AND rules.rule_id = outs.rule_id
1590: UNION
1591: SELECT Ord.Question_Id
1592: FROM Okc_Xprt_Rule_Outcomes Outs,
1593: okc_xprt_rule_hdrs_all Rules,
1594: Okc_Xprt_Question_Orders Ord
1595: WHERE Rules.Rule_Id = Outs.Rule_Id
1596: AND Rules.Org_Wide_Flag = 'Y'

Line 1613: FROM Okc_Xprt_Rule_Outcomes Outs,

1609: Last_Update_Login = l_login_id
1610: WHERE Template_Id = p_Template_Id
1611: AND Question_Id IN
1612: (SELECT Ord.Question_Id
1613: FROM Okc_Xprt_Rule_Outcomes Outs,
1614: okc_xprt_rule_hdrs_all Rules,
1615: Okc_Xprt_Template_Rules Assoc,
1616: Okc_Xprt_Question_Orders Ord
1617: WHERE Rules.Rule_Id = Assoc.Rule_Id

Line 1626: FROM Okc_Xprt_Rule_Outcomes Outs,

1622: AND Rules.Request_Id = l_conc_request_id
1623: AND rules.rule_id = outs.rule_id
1624: UNION
1625: SELECT Ord.Question_Id
1626: FROM Okc_Xprt_Rule_Outcomes Outs,
1627: okc_xprt_rule_hdrs_all Rules,
1628: Okc_Xprt_Question_Orders Ord
1629: WHERE Rules.Rule_Id = Outs.Rule_Id
1630: AND Rules.Org_Wide_Flag = 'Y'

Line 1756: FROM OKC_XPRT_RULE_OUTCOMES

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

Line 4548: FROM okc_xprt_rule_outcomes o

4544: AND c.rule_id = p_rule_id ;
4545:
4546: CURSOR csr_out_clause_exits IS
4547: SELECT 'X'
4548: FROM okc_xprt_rule_outcomes o
4549: WHERE o.rule_id = p_rule_id
4550: AND o.object_type = 'CLAUSE'
4551: AND o.object_value_id = p_clause_id ;
4552:

Line 4697: FROM okc_xprt_rule_outcomes xro

4693: AND cond.object_type ='QUESTION'
4694: AND cond.object_code=to_char(p_question_id)
4695: UNION ALL
4696: SELECT 'x'
4697: FROM okc_xprt_rule_outcomes xro
4698: WHERE xro.rule_id =p_rule_id
4699: AND xro.object_type='QUESTION'
4700: AND xro.object_value_id=p_question_id;
4701:

Line 6474: FROM okc_xprt_rule_outcomes o

6470: AND v.object_value_code = to_char(p_article_id) -- Added to_char function. Fix for Bug 4063007
6471: UNION ALL
6472: -- All Clauses from Outcome
6473: SELECT 'N'
6474: FROM okc_xprt_rule_outcomes o
6475: WHERE o.object_type = 'CLAUSE'
6476: AND o.object_value_id = p_article_id ; -- Removed to_char which is not needed here
6477:
6478: l_delete_flag VARCHAR2(1);

Line 10012: FROM okc_xprt_rule_outcomes xro

10008: WHERE cond.rule_id = p_rule_id
10009: AND cond.object_type ='QUESTION'
10010: UNION ALL
10011: SELECT object_value_id||'' question_id
10012: FROM okc_xprt_rule_outcomes xro
10013: WHERE xro.rule_id = p_rule_id
10014: AND xro.object_type='QUESTION';
10015:
10016: CURSOR csr_main IS