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_TEMPLATE_RULES

Line 486: FROM okc_xprt_template_rules r,

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

Line 1006: for all rules associated to the template in table OKC_XPRT_TEMPLATE_RULES or rules

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:
1010: -- write to debug log file

Line 1024: Okc_Xprt_Template_Rules Assoc,

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
1027: AND Rules.Rule_Id = Assoc.Rule_Id
1028: AND Assoc.Template_Id = p_Template_Id

Line 1040: Okc_Xprt_Template_Rules Assoc,

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
1043: AND Rules.rule_id = Outs.rule_id
1044: AND Assoc.Template_Id = p_Template_Id

Line 1111: for all rules associated to the template in table OKC_XPRT_TEMPLATE_RULES or rules with ORG_WIDE_FLAG='Y' and status = 'ACTIVE'

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
1115: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 1126: Okc_Xprt_Template_Rules Assoc

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
1129: AND Assoc.Template_Id = p_Template_Id
1130: AND Cond.Object_Type = 'QUESTION'

Line 1136: Okc_Xprt_Template_Rules Assoc

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
1139: AND Assoc.Template_Id = p_Template_Id
1140: AND Cond.Object_Value_Type = 'QUESTION'

Line 1146: Okc_Xprt_Template_Rules Assoc

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
1149: AND Outs.Object_Type = 'QUESTION'
1150: AND Outs.rule_id = Rules.rule_id

Line 1255: Okc_Xprt_Template_Rules Assoc

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
1258: AND Assoc.Template_Id = p_Template_Id
1259: AND Cond.Object_Type = 'QUESTION'

Line 1266: Okc_Xprt_Template_Rules Assoc

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
1269: AND Assoc.Template_Id = p_Template_Id
1270: AND Cond.Object_Value_Type = 'QUESTION'

Line 1277: Okc_Xprt_Template_Rules Assoc

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
1280: AND Outs.Object_Type = 'QUESTION'
1281: And Outs.rule_id = Rules.rule_id

Line 1404: Okc_Xprt_Template_Rules Assoc,

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
1407: AND Rules.Rule_Id = Assoc.Rule_Id
1408: AND Assoc.Template_Id = p_Template_Id

Line 1450: Okc_Xprt_Template_Rules Assoc,

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
1453: AND Assoc.Template_Id = p_Template_Id
1454: AND to_char(Ord.Question_Id) = Outs.Object_Value_Id

Line 1499: Okc_Xprt_Template_Rules Assoc,

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
1502: AND Rules.Rule_Id = Assoc.Rule_Id
1503: AND Assoc.Template_Id = p_Template_Id

Line 1540: Okc_Xprt_Template_Rules Assoc,

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
1543: AND Rules.Rule_Id = Assoc.Rule_Id
1544: AND Assoc.Template_Id = p_Template_Id

Line 1582: Okc_Xprt_Template_Rules Assoc,

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
1585: AND Assoc.Template_Id = p_Template_Id
1586: AND to_char(Ord.Question_Id) = Outs.Object_Value_Id

Line 1615: Okc_Xprt_Template_Rules Assoc,

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
1618: AND Assoc.Template_Id = p_Template_Id
1619: AND to_char(Ord.Question_Id) = Outs.Object_Value_Id

Line 1787: Delete records from okc_xprt_template_rules where deleted_flag = 'Y'

1783: DELETE the UI attached to the production publication
1784: Update Test mode Publication to Production mode
1785: Update Rule status in the current concurrent request id
1786: Update the runtime_available_flag in okc_xprt_question_orders table
1787: Delete records from okc_xprt_template_rules where deleted_flag = 'Y'
1788: commit the work
1789:
1790: This procedure can also be called in Template approval flow with mode 'TEMPLATE_APPROVAL'
1791: This procedure does the following in 'TEMPLATE_APPROVAL' mode:

Line 2053: -- Delete from okc_xprt_template_rules

2049: AND template_id IN ( SELECT template_id
2050: FROM okc_terms_templates_all
2051: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2052: );
2053: -- Delete from okc_xprt_template_rules
2054: DELETE FROM okc_xprt_template_rules
2055: WHERE NVL(deleted_flag,'N') = 'Y'
2056: AND template_id IN ( SELECT template_id
2057: FROM okc_terms_templates_all

Line 2054: DELETE FROM okc_xprt_template_rules

2050: FROM okc_terms_templates_all
2051: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2052: );
2053: -- Delete from okc_xprt_template_rules
2054: DELETE FROM okc_xprt_template_rules
2055: WHERE NVL(deleted_flag,'N') = 'Y'
2056: AND template_id IN ( SELECT template_id
2057: FROM okc_terms_templates_all
2058: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 2061: -- Update published_flag in okc_xprt_template_rules

2057: FROM okc_terms_templates_all
2058: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2059: );
2060:
2061: -- Update published_flag in okc_xprt_template_rules
2062: UPDATE okc_xprt_template_rules
2063: SET published_flag = 'Y'
2064: WHERE template_id IN ( SELECT template_id
2065: FROM okc_terms_templates_all

Line 2062: UPDATE okc_xprt_template_rules

2058: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID
2059: );
2060:
2061: -- Update published_flag in okc_xprt_template_rules
2062: UPDATE okc_xprt_template_rules
2063: SET published_flag = 'Y'
2064: WHERE template_id IN ( SELECT template_id
2065: FROM okc_terms_templates_all
2066: WHERE xprt_request_id = FND_GLOBAL.CONC_REQUEST_ID

Line 2080: -- Delete from okc_xprt_template_rules

2076: last_update_login = FND_GLOBAL.LOGIN_ID
2077: WHERE template_id= p_template_id
2078: AND question_rule_status = 'ACTIVE';
2079:
2080: -- Delete from okc_xprt_template_rules
2081: DELETE FROM okc_xprt_template_rules
2082: WHERE NVL(deleted_flag,'N') = 'Y'
2083: AND template_id = p_template_id;
2084:

Line 2081: DELETE FROM okc_xprt_template_rules

2077: WHERE template_id= p_template_id
2078: AND question_rule_status = 'ACTIVE';
2079:
2080: -- Delete from okc_xprt_template_rules
2081: DELETE FROM okc_xprt_template_rules
2082: WHERE NVL(deleted_flag,'N') = 'Y'
2083: AND template_id = p_template_id;
2084:
2085: -- Update published_flag in okc_xprt_template_rules

Line 2085: -- Update published_flag in okc_xprt_template_rules

2081: DELETE FROM okc_xprt_template_rules
2082: WHERE NVL(deleted_flag,'N') = 'Y'
2083: AND template_id = p_template_id;
2084:
2085: -- Update published_flag in okc_xprt_template_rules
2086: UPDATE okc_xprt_template_rules
2087: SET published_flag = 'Y'
2088: WHERE template_id= p_template_id ;
2089:

Line 2086: UPDATE okc_xprt_template_rules

2082: WHERE NVL(deleted_flag,'N') = 'Y'
2083: AND template_id = p_template_id;
2084:
2085: -- Update published_flag in okc_xprt_template_rules
2086: UPDATE okc_xprt_template_rules
2087: SET published_flag = 'Y'
2088: WHERE template_id= p_template_id ;
2089:
2090: END IF;

Line 2247: FROM okc_xprt_template_rules tr,

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

Line 2266: FROM okc_xprt_template_rules tr,

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

Line 4754: okc_xprt_template_rules xtr

4750:
4751: --template specific rules
4752: SELECT 'x'
4753: FROM okc_xprt_rule_hdrs_all xrh,
4754: okc_xprt_template_rules xtr
4755: WHERE xrh.rule_id = xtr.rule_id
4756: AND xrh.rule_id = p_rule_id
4757: AND template_id=p_template_id;
4758:

Line 5986: FROM okc_xprt_template_rules r,

5982: -- Rules attached to template
5983: CURSOR csr_approval_rules IS
5984: -- Local Rules on Template
5985: SELECT r.rule_id
5986: FROM okc_xprt_template_rules r,
5987: okc_xprt_rule_hdrs_all h
5988: WHERE r.rule_id = h.rule_id
5989: AND h.status_code = 'ACTIVE'
5990: AND r.template_id = p_template_id

Line 9982: FROM okc_xprt_template_rules tr,

9978: RETURN VARCHAR2 IS
9979:
9980: CURSOR csr_rules(p_org_id NUMBER, p_intent VARCHAR2) IS
9981: SELECT tr.rule_id
9982: FROM okc_xprt_template_rules tr,
9983: okc_xprt_rule_hdrs_all rhdr
9984: WHERE tr.rule_id = rhdr.rule_id
9985: AND tr.template_id = p_template_id
9986: AND rhdr.rule_type = p_rule_type