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 488: FROM okc_xprt_template_rules r,

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

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

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

Line 1026: Okc_Xprt_Template_Rules Assoc,

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

Line 1042: Okc_Xprt_Template_Rules Assoc,

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

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

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

Line 1128: Okc_Xprt_Template_Rules Assoc

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

Line 1138: Okc_Xprt_Template_Rules Assoc

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

Line 1148: Okc_Xprt_Template_Rules Assoc

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

Line 1257: Okc_Xprt_Template_Rules Assoc

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

Line 1268: Okc_Xprt_Template_Rules Assoc

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

Line 1279: Okc_Xprt_Template_Rules Assoc

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

Line 1406: Okc_Xprt_Template_Rules Assoc,

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

Line 1452: Okc_Xprt_Template_Rules Assoc,

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

Line 1501: Okc_Xprt_Template_Rules Assoc,

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

Line 1542: Okc_Xprt_Template_Rules Assoc,

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

Line 1584: Okc_Xprt_Template_Rules Assoc,

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

Line 1617: Okc_Xprt_Template_Rules Assoc,

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

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

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

Line 2055: -- Delete from okc_xprt_template_rules

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

Line 2056: DELETE FROM okc_xprt_template_rules

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

Line 2063: -- Update published_flag in okc_xprt_template_rules

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

Line 2064: UPDATE okc_xprt_template_rules

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

Line 2082: -- Delete from okc_xprt_template_rules

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

Line 2083: DELETE FROM okc_xprt_template_rules

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

Line 2087: -- Update published_flag in okc_xprt_template_rules

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

Line 2088: UPDATE okc_xprt_template_rules

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

Line 2249: FROM okc_xprt_template_rules tr,

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

Line 2268: FROM okc_xprt_template_rules tr,

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

Line 4952: okc_xprt_template_rules xtr

4948:
4949: --template specific rules
4950: SELECT 'x'
4951: FROM okc_xprt_rule_hdrs_all xrh,
4952: okc_xprt_template_rules xtr
4953: WHERE xrh.rule_id = xtr.rule_id
4954: AND xrh.rule_id = p_rule_id
4955: AND template_id=p_template_id;
4956:

Line 6184: FROM okc_xprt_template_rules r,

6180: -- Rules attached to template
6181: CURSOR csr_approval_rules IS
6182: -- Local Rules on Template
6183: SELECT r.rule_id
6184: FROM okc_xprt_template_rules r,
6185: okc_xprt_rule_hdrs_all h
6186: WHERE r.rule_id = h.rule_id
6187: AND h.status_code = 'ACTIVE'
6188: AND r.template_id = p_template_id

Line 10579: FROM okc_xprt_template_rules tr,

10575: RETURN VARCHAR2 IS
10576:
10577: CURSOR csr_rules(p_org_id NUMBER, p_intent VARCHAR2) IS
10578: SELECT tr.rule_id
10579: FROM okc_xprt_template_rules tr,
10580: okc_xprt_rule_hdrs_all rhdr
10581: WHERE tr.rule_id = rhdr.rule_id
10582: AND tr.template_id = p_template_id
10583: AND rhdr.rule_type = p_rule_type