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_RULES_ENGINE_PVT dependencies on OKC_XPRT_RULE_OUTCOMES_ACT_V

Line 287: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q

283: AND q.template_id = p_template_id
284: AND cond.object_value_code = q.question_id
285: UNION
286: SELECT distinct to_char(outcome.object_value_id), q.mandatory_flag display_flag
287: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q
288: WHERE rultmpl.template_id = p_template_id
289: AND outcome.rule_id = rultmpl.rule_id
290: AND outcome.object_type = 'QUESTION'
291: AND q.template_id = p_template_id

Line 295: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q

291: AND q.template_id = p_template_id
292: AND outcome.object_value_id = q.question_id
293: UNION
294: SELECT distinct to_char(outcome.object_value_id), q.mandatory_flag display_flag
295: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q
296: WHERE rul.org_wide_flag = 'Y'
297: AND outcome.rule_id = rul.rule_id
298: AND outcome.object_type = 'QUESTION'
299: AND q.template_id = p_template_id

Line 326: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

322: AND q.template_id = p_template_id
323: AND cond.object_value_code = q.question_id
324: UNION
325: SELECT distinct to_char(outcome.object_value_id), resp.response, q.mandatory_flag display_flag
326: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
327: WHERE rultmpl.template_id = p_template_id
328: AND outcome.rule_id = rultmpl.rule_id
329: AND outcome.object_type = 'QUESTION'
330: AND resp.doc_id (+) = p_doc_id

Line 337: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

333: AND q.template_id = p_template_id
334: AND outcome.object_value_id = q.question_id
335: UNION
336: SELECT distinct to_char(outcome.object_value_id), resp.response, q.mandatory_flag display_flag
337: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
338: WHERE rul.org_wide_flag = 'Y'
339: AND outcome.rule_id = rul.rule_id
340: AND outcome.object_type = 'QUESTION'
341: AND resp.doc_id (+) = p_doc_id

Line 648: AND object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id IN (SELECT * FROM table(success_rule_ids)) and object_type = 'QUESTION');

644: WHERE doc_id = p_doc_id
645: AND doc_type = p_doc_type
646: AND object_type = 'QUESTION'
647: AND display_flag <> 'Y'
648: AND object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id IN (SELECT * FROM table(success_rule_ids)) and object_type = 'QUESTION');
649: rows := sql%rowcount;
650: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '160: No. of questions updated with display_flag = Y: ' || rows);
652: END IF;

Line 1117: AND object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id IN (SELECT * FROM table(rule_ids1)) and object_type = 'QUESTION');

1113: WHERE doc_id = p_doc_id
1114: AND doc_type = p_doc_type
1115: AND object_type = 'QUESTION'
1116: AND display_flag <> 'Y' --it won't update if it is already Y, so that the rows1 count will not be included if there is no updation
1117: AND object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id IN (SELECT * FROM table(rule_ids1)) and object_type = 'QUESTION');
1118: rows1 := sql%rowcount;
1119:
1120: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1121: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, l_module, '160: No. of additional questions which are getting displayed based on the new rules that are evaluated: ' || rows1);

Line 1138: AND ques.object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id = rule_ids2(i) and object_type = 'QUESTION')

1134: WHERE ques.doc_id = p_doc_id
1135: AND ques.doc_type = p_doc_type
1136: AND ques.object_type = 'QUESTION'
1137: AND ques.display_flag <> 'N'
1138: AND ques.object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id = rule_ids2(i) and object_type = 'QUESTION')
1139: AND NOT EXISTS (SELECT 1 FROM okc_xprt_rule_outcomes_act_v d, okc_xprt_rule_eval_result_t t
1140: WHERE d.rule_id = t.rule_id AND t.doc_id = ques.doc_id AND t.doc_type = ques.doc_type AND nvl(t.result, '*') = 'Y' AND t.condition_id IS NULL
1141: AND to_char(d.object_value_id) = ques.object_code AND d.object_type = 'QUESTION');
1142: IF SQL%FOUND AND rule_ids2.count > 0 THEN

Line 1139: AND NOT EXISTS (SELECT 1 FROM okc_xprt_rule_outcomes_act_v d, okc_xprt_rule_eval_result_t t

1135: AND ques.doc_type = p_doc_type
1136: AND ques.object_type = 'QUESTION'
1137: AND ques.display_flag <> 'N'
1138: AND ques.object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id = rule_ids2(i) and object_type = 'QUESTION')
1139: AND NOT EXISTS (SELECT 1 FROM okc_xprt_rule_outcomes_act_v d, okc_xprt_rule_eval_result_t t
1140: WHERE d.rule_id = t.rule_id AND t.doc_id = ques.doc_id AND t.doc_type = ques.doc_type AND nvl(t.result, '*') = 'Y' AND t.condition_id IS NULL
1141: AND to_char(d.object_value_id) = ques.object_code AND d.object_type = 'QUESTION');
1142: IF SQL%FOUND AND rule_ids2.count > 0 THEN
1143: rows2 := sql%rowcount;

Line 1160: AND ques.object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id = rule_ids2(i) and object_type = 'QUESTION')

1156: WHERE ques.doc_id = p_doc_id
1157: AND ques.doc_type = p_doc_type
1158: AND ques.object_type = 'QUESTION'
1159: AND ques.value_or_response IS NOT NULL --it won't update if it is already NULL, so that re-evaluation of rules for additional questions take place only when it is an actual update
1160: AND ques.object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id = rule_ids2(i) and object_type = 'QUESTION')
1161: AND NOT EXISTS (SELECT 1 FROM okc_xprt_rule_outcomes_act_v d, okc_xprt_rule_eval_result_t t
1162: WHERE d.rule_id = t.rule_id AND t.doc_id = ques.doc_id AND t.doc_type = ques.doc_type AND nvl(t.result, '*') = 'Y' AND t.condition_id IS NULL
1163: AND to_char(d.object_value_id) = ques.object_code AND d.object_type = 'QUESTION')
1164: RETURNING ques.object_code BULK COLLECT INTO question_ids;

Line 1161: AND NOT EXISTS (SELECT 1 FROM okc_xprt_rule_outcomes_act_v d, okc_xprt_rule_eval_result_t t

1157: AND ques.doc_type = p_doc_type
1158: AND ques.object_type = 'QUESTION'
1159: AND ques.value_or_response IS NOT NULL --it won't update if it is already NULL, so that re-evaluation of rules for additional questions take place only when it is an actual update
1160: AND ques.object_code IN (SELECT object_value_id FROM okc_xprt_rule_outcomes_act_v WHERE rule_id = rule_ids2(i) and object_type = 'QUESTION')
1161: AND NOT EXISTS (SELECT 1 FROM okc_xprt_rule_outcomes_act_v d, okc_xprt_rule_eval_result_t t
1162: WHERE d.rule_id = t.rule_id AND t.doc_id = ques.doc_id AND t.doc_type = ques.doc_type AND nvl(t.result, '*') = 'Y' AND t.condition_id IS NULL
1163: AND to_char(d.object_value_id) = ques.object_code AND d.object_type = 'QUESTION')
1164: RETURNING ques.object_code BULK COLLECT INTO question_ids;
1165: