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 406: okc_xprt_rule_conditions rcon,

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

Line 417: okc_xprt_rule_conditions rcon,

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

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

1018: DELETE FROM Okc_Xprt_Question_Orders
1019: WHERE Template_Id = p_Template_Id
1020: AND NOT EXISTS
1021: (SELECT 1
1022: FROM Okc_Xprt_Rule_Conditions Cond,
1023: okc_xprt_rule_hdrs_all Rules,
1024: Okc_Xprt_Template_Rules Assoc,
1025: Okc_xprt_questions_b quest
1026: WHERE Rules.Rule_Id = Cond.Rule_Id

Line 1052: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,

1048: AND quest.question_id = Okc_Xprt_Question_Orders.Question_Id
1049: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE','PENDINGPUB')
1050: UNION ALL --perf Bug#5030444 Replaced UNION with UNION ALL
1051: SELECT 1
1052: FROM Okc_Xprt_Rule_Conditions Cond, okc_xprt_rule_hdrs_all Rules,
1053: Okc_xprt_questions_b quest
1054: WHERE Rules.Rule_Id = Cond.Rule_Id
1055: AND Rules.Org_Wide_Flag = 'Y'
1056: 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 1124: FROM Okc_Xprt_Rule_Conditions Cond,

1120: DECLARE
1121: CURSOR Active_Draft_Rule_Questions IS
1122: SELECT * FROM (
1123: SELECT distinct To_Number(Cond.Object_Code) Question_Id, Rules.Status_Code
1124: FROM Okc_Xprt_Rule_Conditions Cond,
1125: okc_xprt_rule_hdrs_all Rules,
1126: Okc_Xprt_Template_Rules Assoc
1127: WHERE Rules.Rule_Id = Cond.Rule_Id
1128: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1134: FROM Okc_Xprt_Rule_Conditions Cond,

1130: AND Cond.Object_Type = 'QUESTION'
1131: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1132: UNION
1133: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id, Rules.Status_Code
1134: FROM Okc_Xprt_Rule_Conditions Cond,
1135: okc_xprt_rule_hdrs_all Rules,
1136: Okc_Xprt_Template_Rules Assoc
1137: WHERE Rules.Rule_Id = Cond.Rule_Id
1138: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1154: FROM Okc_Xprt_Rule_Conditions Cond,

1150: AND Outs.rule_id = Rules.rule_id
1151: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1152: UNION
1153: SELECT distinct To_Number(Cond.Object_Code) Question_Id, Rules.Status_Code
1154: FROM Okc_Xprt_Rule_Conditions Cond,
1155: okc_xprt_rule_hdrs_all Rules
1156: WHERE Rules.Rule_Id = Cond.Rule_Id
1157: AND Rules.Org_Wide_Flag = 'Y'
1158: AND Rules.Org_Id = l_Org_Id

Line 1164: FROM Okc_Xprt_Rule_Conditions Cond,

1160: AND Cond.Object_Type = 'QUESTION'
1161: AND Rules.Status_Code IN ('ACTIVE', 'DRAFT', 'REVISION', 'PENDINGDISABLE')
1162: UNION
1163: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id, Rules.Status_Code
1164: FROM Okc_Xprt_Rule_Conditions Cond,
1165: okc_xprt_rule_hdrs_all Rules
1166: WHERE Rules.Rule_Id = Cond.Rule_Id
1167: AND Rules.Org_Wide_Flag = 'Y'
1168: AND Rules.Org_Id = l_Org_Id

Line 1253: FROM Okc_Xprt_Rule_Conditions Cond,

1249:
1250: DECLARE
1251: CURSOR Pending_Rule_Questions IS
1252: SELECT distinct To_Number(Cond.Object_Code) Question_Id
1253: FROM Okc_Xprt_Rule_Conditions Cond,
1254: okc_xprt_rule_hdrs_all Rules,
1255: Okc_Xprt_Template_Rules Assoc
1256: WHERE Rules.Rule_Id = Cond.Rule_Id
1257: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1264: FROM Okc_Xprt_Rule_Conditions Cond,

1260: AND Rules.Status_Code IN ('PENDINGPUB')
1261: AND Rules.Request_Id = l_conc_request_id
1262: UNION
1263: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id
1264: FROM Okc_Xprt_Rule_Conditions Cond,
1265: okc_xprt_rule_hdrs_all Rules,
1266: Okc_Xprt_Template_Rules Assoc
1267: WHERE Rules.Rule_Id = Cond.Rule_Id
1268: AND Rules.Rule_Id = Assoc.Rule_Id

Line 1286: FROM Okc_Xprt_Rule_Conditions Cond,

1282: AND Rules.Status_Code IN ('PENDINGPUB')
1283: AND Rules.Request_Id = l_conc_request_id
1284: UNION
1285: SELECT distinct To_Number(Cond.Object_Code) Question_Id
1286: FROM Okc_Xprt_Rule_Conditions Cond,
1287: okc_xprt_rule_hdrs_all Rules
1288: WHERE Rules.Rule_Id = Cond.Rule_Id
1289: AND Rules.Org_Wide_Flag = 'Y'
1290: AND Rules.Org_Id = l_Org_Id

Line 1297: FROM Okc_Xprt_Rule_Conditions Cond,

1293: AND Rules.Status_Code IN ('PENDINGPUB')
1294: AND Rules.Request_Id = l_conc_request_id
1295: UNION
1296: SELECT distinct To_Number(Cond.Object_Value_Code) Question_Id
1297: FROM Okc_Xprt_Rule_Conditions Cond,
1298: okc_xprt_rule_hdrs_all Rules
1299: WHERE Rules.Rule_Id = Cond.Rule_Id
1300: AND Rules.Org_Wide_Flag = 'Y'
1301: AND Rules.Org_Id = l_Org_Id

Line 1402: FROM Okc_Xprt_Rule_Conditions Cond,

1398: Last_Update_Login = l_login_id
1399: WHERE Template_Id = p_Template_Id
1400: AND Question_Id IN
1401: (SELECT Ord.Question_Id
1402: FROM Okc_Xprt_Rule_Conditions Cond,
1403: okc_xprt_rule_hdrs_all Rules,
1404: Okc_Xprt_Template_Rules Assoc,
1405: Okc_Xprt_Question_Orders Ord
1406: WHERE Rules.Rule_Id = Cond.Rule_Id

Line 1425: FROM Okc_Xprt_Rule_Conditions Cond,

1421: Last_Update_Login = l_login_id
1422: WHERE Template_Id = p_Template_Id
1423: AND Question_Id IN
1424: (SELECT Ord.Question_Id
1425: FROM Okc_Xprt_Rule_Conditions Cond,
1426: okc_xprt_rule_hdrs_all Rules,
1427: Okc_Xprt_Question_Orders Ord
1428: WHERE Rules.Rule_Id = Cond.Rule_Id
1429: AND Rules.Org_Wide_Flag = 'Y'

Line 1497: FROM Okc_Xprt_Rule_Conditions Cond,

1493: Last_Update_Login = l_login_id
1494: WHERE Template_Id = p_Template_Id
1495: AND Question_Id IN
1496: (SELECT Ord.Question_Id
1497: FROM Okc_Xprt_Rule_Conditions Cond,
1498: okc_xprt_rule_hdrs_all Rules,
1499: Okc_Xprt_Template_Rules Assoc,
1500: Okc_Xprt_Question_Orders Ord
1501: WHERE Rules.Rule_Id = Cond.Rule_Id

Line 1513: FROM Okc_Xprt_Rule_Conditions Cond,

1509: )
1510: AND Rules.Status_Code = 'ACTIVE'
1511: UNION
1512: SELECT Ord.Question_Id
1513: FROM Okc_Xprt_Rule_Conditions Cond,
1514: okc_xprt_rule_hdrs_all Rules,
1515: Okc_Xprt_Question_Orders Ord
1516: WHERE Rules.Rule_Id = Cond.Rule_Id
1517: AND Rules.Org_Wide_Flag = 'Y'

Line 1538: FROM Okc_Xprt_Rule_Conditions Cond,

1534: Last_Update_Login = l_login_id
1535: WHERE Template_Id = p_Template_Id
1536: AND Question_Id IN
1537: (SELECT Ord.Question_Id
1538: FROM Okc_Xprt_Rule_Conditions Cond,
1539: okc_xprt_rule_hdrs_all Rules,
1540: Okc_Xprt_Template_Rules Assoc,
1541: Okc_Xprt_Question_Orders Ord
1542: WHERE Rules.Rule_Id = Cond.Rule_Id

Line 1555: FROM Okc_Xprt_Rule_Conditions Cond,

1551: AND Rules.Status_Code = 'PENDINGPUB'
1552: AND Rules.Request_Id = l_conc_request_id
1553: UNION
1554: SELECT Ord.Question_Id
1555: FROM Okc_Xprt_Rule_Conditions Cond,
1556: okc_xprt_rule_hdrs_all Rules,
1557: Okc_Xprt_Question_Orders Ord
1558: WHERE Rules.Rule_Id = Cond.Rule_Id
1559: AND Rules.Org_Wide_Flag = 'Y'

Line 1748: FROM OKC_XPRT_RULE_CONDITIONS

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

Line 4539: FROM okc_xprt_rule_conditions c,

4535: RETURN VARCHAR2 IS
4536:
4537: CURSOR csr_cond_clause_exists IS
4538: SELECT 'X'
4539: FROM okc_xprt_rule_conditions c,
4540: okc_xprt_rule_cond_vals cv
4541: WHERE c.rule_condition_id = cv.rule_condition_id
4542: AND c.object_value_type = 'CLAUSE'
4543: AND cv.object_value_code = p_clause_id

Line 4613: FROM okc_xprt_rule_conditions c,

4609: RETURN VARCHAR2 IS
4610:
4611: CURSOR csr_variable_val_exists IS
4612: SELECT 'X'
4613: FROM okc_xprt_rule_conditions c,
4614: okc_xprt_rule_cond_vals cv
4615: WHERE c.rule_condition_id = cv.rule_condition_id
4616: AND c.object_value_type = 'VARIABLE'
4617: AND cv.object_value_code = p_variable_code

Line 4622: FROM okc_xprt_rule_conditions c

4618: AND c.rule_id = p_rule_id ;
4619:
4620: CURSOR csr_variable_cond_exists IS
4621: SELECT 'X'
4622: FROM okc_xprt_rule_conditions c
4623: WHERE c.object_type = 'VARIABLE'
4624: AND c.object_code = p_variable_code
4625: AND c.rule_id = p_rule_id ;
4626:

Line 4684: okc_xprt_rule_conditions cond

4680: RETURN VARCHAR2 IS
4681: CURSOR question_exists IS
4682: SELECT 'x'
4683: FROM okc_xprt_rule_cond_vals cvals,
4684: okc_xprt_rule_conditions cond
4685: WHERE cond.rule_id = p_rule_id
4686: AND cond.rule_condition_id=cvals.rule_condition_id
4687: AND cond.object_value_type ='QUESTION'
4688: AND cvals.object_value_code=p_question_id

Line 4691: FROM okc_xprt_rule_conditions cond

4687: AND cond.object_value_type ='QUESTION'
4688: AND cvals.object_value_code=p_question_id
4689: UNION ALL
4690: SELECT 'x'
4691: FROM okc_xprt_rule_conditions cond
4692: WHERE cond.rule_id = p_rule_id
4693: AND cond.object_type ='QUESTION'
4694: AND cond.object_code=to_char(p_question_id)
4695: UNION ALL

Line 5483: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,

5479: RuleCond.Object_value_type,
5480: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5481: fvs.validation_type,
5482: fvs.longlist_flag
5483: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5484: fnd_flex_value_sets fvs
5485: where rtrim(RuleCond.OBJECT_VALUE_SET_NAME) = fvs.flex_value_set_name(+)
5486: and rule_condition_id=p_rule_condition_id;
5487:

Line 5533: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,

5529: RuleCond.Object_value_type,
5530: fvs.flex_value_set_id OBJECT_VALUE_SET_ID,
5531: fvs.validation_type,
5532: fvs.longlist_flag
5533: FROM OKC_XPRT_RULE_CONDITIONS RuleCond,
5534: fnd_flex_value_sets fvs
5535: where RuleCond.OBJECT_VALUE_SET_NAME = fvs.flex_value_set_name(+)
5536: and rule_condition_id=p_rule_condition_id;
5537:

Line 6285: FROM OKC_XPRT_RULE_CONDITIONS RuleCond

6281: RETURN VARCHAR2 IS
6282:
6283: CURSOR c1 IS
6284: SELECT RuleCond.Object_value_type
6285: FROM OKC_XPRT_RULE_CONDITIONS RuleCond
6286: where rule_condition_id=p_rule_condition_id;
6287:
6288: l_value VARCHAR2(1) := null;
6289: l_value_type VARCHAR2(30) ;

Line 6467: okc_xprt_rule_conditions c

6463: CURSOR csr_clause_exists IS
6464: -- All Clauses from Conditions
6465: SELECT 'N'
6466: FROM okc_xprt_rule_cond_vals v,
6467: okc_xprt_rule_conditions c
6468: WHERE v.rule_condition_id = c.rule_condition_id
6469: AND c.object_type = 'CLAUSE'
6470: AND v.object_value_code = to_char(p_article_id) -- Added to_char function. Fix for Bug 4063007
6471: UNION ALL

Line 7052: FROM okc_xprt_rule_conditions

7048:
7049: CURSOR l_rule_details_csr(p_dev_rule_id NUMBER) IS
7050: SELECT DISTINCT object_type type,
7051: object_code code
7052: FROM okc_xprt_rule_conditions
7053: WHERE rule_id = p_dev_rule_id
7054: AND object_type IN ('QUESTION','VARIABLE')
7055: UNION ALL
7056: SELECT DISTINCT object_value_type type,

Line 7058: FROM okc_xprt_rule_conditions

7054: AND object_type IN ('QUESTION','VARIABLE')
7055: UNION ALL
7056: SELECT DISTINCT object_value_type type,
7057: object_value_code code
7058: FROM okc_xprt_rule_conditions
7059: WHERE rule_id = p_dev_rule_id
7060: AND object_value_type IN ('QUESTION','VARIABLE');
7061:
7062: BEGIN

Line 10002: FROM okc_xprt_rule_conditions cond

9998:
9999:
10000: CURSOR csr_questions(p_rule_id NUMBER) IS
10001: SELECT object_code question_id
10002: FROM okc_xprt_rule_conditions cond
10003: WHERE cond.rule_id = p_rule_id
10004: AND cond.object_value_type ='QUESTION'
10005: UNION ALL
10006: SELECT object_code question_id

Line 10007: FROM okc_xprt_rule_conditions cond

10003: WHERE cond.rule_id = p_rule_id
10004: AND cond.object_value_type ='QUESTION'
10005: UNION ALL
10006: SELECT object_code question_id
10007: FROM okc_xprt_rule_conditions cond
10008: WHERE cond.rule_id = p_rule_id
10009: AND cond.object_type ='QUESTION'
10010: UNION ALL
10011: SELECT object_value_id||'' question_id