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_CONDITIONS

Line 408: okc_xprt_rule_conditions rcon,

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'
412: AND rcon.object_code = v.variable_code

Line 419: okc_xprt_rule_conditions rcon,

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'
423: AND rcon.object_code = v.variable_code

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 1024: FROM Okc_Xprt_Rule_Conditions Cond,

1020: DELETE FROM Okc_Xprt_Question_Orders
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

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 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 1126: FROM Okc_Xprt_Rule_Conditions Cond,

1122: DECLARE
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

Line 1136: FROM Okc_Xprt_Rule_Conditions Cond,

1132: AND Cond.Object_Type = 'QUESTION'
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

Line 1156: FROM Okc_Xprt_Rule_Conditions Cond,

1152: AND Outs.rule_id = Rules.rule_id
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

Line 1166: FROM Okc_Xprt_Rule_Conditions Cond,

1162: AND Cond.Object_Type = 'QUESTION'
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

Line 1255: FROM Okc_Xprt_Rule_Conditions Cond,

1251:
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

Line 1266: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1288: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1299: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1404: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1427: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1499: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1515: FROM Okc_Xprt_Rule_Conditions Cond,

1511: )
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'

Line 1540: FROM Okc_Xprt_Rule_Conditions Cond,

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

Line 1557: FROM Okc_Xprt_Rule_Conditions Cond,

1553: AND Rules.Status_Code = 'PENDINGPUB'
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'

Line 1750: FROM OKC_XPRT_RULE_CONDITIONS

1746: p_question_id IN NUMBER)
1747: RETURN VARCHAR2 IS
1748: CURSOR used_in_rule_cond_crs IS
1749: SELECT 'N'
1750: FROM OKC_XPRT_RULE_CONDITIONS
1751: WHERE (object_type IN ('QUESTION','CONSTANT') AND
1752: object_code = to_char(p_question_id) ) -- Added for bug 5663927
1753: OR
1754: (object_value_type IN ('QUESTION','CONSTANT') AND

Line 4737: FROM okc_xprt_rule_conditions c,

4733: RETURN VARCHAR2 IS
4734:
4735: CURSOR csr_cond_clause_exists IS
4736: SELECT 'X'
4737: FROM okc_xprt_rule_conditions c,
4738: okc_xprt_rule_cond_vals cv
4739: WHERE c.rule_condition_id = cv.rule_condition_id
4740: AND c.object_value_type = 'CLAUSE'
4741: AND cv.object_value_code = p_clause_id

Line 4811: FROM okc_xprt_rule_conditions c,

4807: RETURN VARCHAR2 IS
4808:
4809: CURSOR csr_variable_val_exists IS
4810: SELECT 'X'
4811: FROM okc_xprt_rule_conditions c,
4812: okc_xprt_rule_cond_vals cv
4813: WHERE c.rule_condition_id = cv.rule_condition_id
4814: AND c.object_value_type = 'VARIABLE'
4815: AND cv.object_value_code = p_variable_code

Line 4820: FROM okc_xprt_rule_conditions c

4816: AND c.rule_id = p_rule_id ;
4817:
4818: CURSOR csr_variable_cond_exists IS
4819: SELECT 'X'
4820: FROM okc_xprt_rule_conditions c
4821: WHERE c.object_type = 'VARIABLE'
4822: AND c.object_code = p_variable_code
4823: AND c.rule_id = p_rule_id ;
4824:

Line 4882: okc_xprt_rule_conditions cond

4878: RETURN VARCHAR2 IS
4879: CURSOR question_exists IS
4880: SELECT 'x'
4881: FROM okc_xprt_rule_cond_vals cvals,
4882: okc_xprt_rule_conditions cond
4883: WHERE cond.rule_id = p_rule_id
4884: AND cond.rule_condition_id=cvals.rule_condition_id
4885: AND cond.object_value_type ='QUESTION'
4886: AND cvals.object_value_code=p_question_id

Line 4889: FROM okc_xprt_rule_conditions cond

4885: AND cond.object_value_type ='QUESTION'
4886: AND cvals.object_value_code=p_question_id
4887: UNION ALL
4888: SELECT 'x'
4889: FROM okc_xprt_rule_conditions cond
4890: WHERE cond.rule_id = p_rule_id
4891: AND cond.object_type ='QUESTION'
4892: AND cond.object_code=to_char(p_question_id)
4893: UNION ALL

Line 5681: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,

5677: RuleCond.Object_value_type,
5678: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5679: fvs.validation_type,
5680: fvs.longlist_flag
5681: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5682: fnd_flex_value_sets fvs
5683: where rtrim(RuleCond.OBJECT_VALUE_SET_NAME) = fvs.flex_value_set_name(+)
5684: and rule_condition_id=p_rule_condition_id;
5685:

Line 5731: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,

5727: RuleCond.Object_value_type,
5728: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5729: fvs.validation_type,
5730: fvs.longlist_flag
5731: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5732: fnd_flex_value_sets fvs
5733: where RuleCond.OBJECT_VALUE_SET_NAME = fvs.flex_value_set_name(+)
5734: and rule_condition_id=p_rule_condition_id;
5735:

Line 6483: FROM OKC_XPRT_RULE_CONDITIONS RuleCond

6479: RETURN VARCHAR2 IS
6480:
6481: CURSOR c1 IS
6482: SELECT RuleCond.Object_value_type
6483: FROM OKC_XPRT_RULE_CONDITIONS RuleCond
6484: where rule_condition_id=p_rule_condition_id;
6485:
6486: l_value VARCHAR2(1) := null;
6487: l_value_type VARCHAR2(30) ;

Line 6665: okc_xprt_rule_conditions c

6661: CURSOR csr_clause_exists IS
6662: -- All Clauses from Conditions
6663: SELECT 'N'
6664: FROM okc_xprt_rule_cond_vals v,
6665: okc_xprt_rule_conditions c
6666: WHERE v.rule_condition_id = c.rule_condition_id
6667: AND c.object_type = 'CLAUSE'
6668: AND v.object_value_code = to_char(p_article_id) -- Added to_char function. Fix for Bug 4063007
6669: UNION ALL

Line 7335: FROM okc_xprt_rule_conditions

7331:
7332: CURSOR l_rule_details_csr(p_dev_rule_id NUMBER) IS
7333: SELECT DISTINCT object_type type,
7334: object_code code
7335: FROM okc_xprt_rule_conditions
7336: WHERE rule_id = p_dev_rule_id
7337: AND object_type IN ('QUESTION','VARIABLE')
7338: UNION ALL
7339: SELECT DISTINCT object_value_type type,

Line 7341: FROM okc_xprt_rule_conditions

7337: AND object_type IN ('QUESTION','VARIABLE')
7338: UNION ALL
7339: SELECT DISTINCT object_value_type type,
7340: object_value_code code
7341: FROM okc_xprt_rule_conditions
7342: WHERE rule_id = p_dev_rule_id
7343: AND object_value_type IN ('QUESTION','VARIABLE');
7344:
7345: BEGIN

Line 10599: FROM okc_xprt_rule_conditions cond

10595:
10596:
10597: CURSOR csr_questions(p_rule_id NUMBER) IS
10598: SELECT object_code question_id
10599: FROM okc_xprt_rule_conditions cond
10600: WHERE cond.rule_id = p_rule_id
10601: AND cond.object_value_type ='QUESTION'
10602: UNION ALL
10603: SELECT object_code question_id

Line 10604: FROM okc_xprt_rule_conditions cond

10600: WHERE cond.rule_id = p_rule_id
10601: AND cond.object_value_type ='QUESTION'
10602: UNION ALL
10603: SELECT object_code question_id
10604: FROM okc_xprt_rule_conditions cond
10605: WHERE cond.rule_id = p_rule_id
10606: AND cond.object_type ='QUESTION'
10607: UNION ALL
10608: SELECT object_value_id||'' question_id