[Home] [Help]
74: PROCEDURE populate_rule_cond_eval_table IS
75:
76: CURSOR c_rules IS
77: SELECT rule.rule_id, rule.condition_expr_code
78: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule
79: WHERE rultmpl.template_id = p_template_id
80: AND rule.rule_id = rultmpl.rule_id
81: UNION ALL
82: SELECT rule.rule_id, rule.condition_expr_code
86: AND rule.org_wide_flag = 'Y';
87:
88: CURSOR c_rule_conditions IS
89: SELECT cond.rule_id, cond.rule_condition_id, cond.object_type condition_type, cond.object_code, rule.condition_expr_code, cond.object_value_type, cond.object_value_code, cond.operator
90: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond
91: WHERE rultmpl.template_id = p_template_id
92: AND rule.rule_id = rultmpl.rule_id
93: AND cond.rule_id = rule.rule_id
94: UNION ALL
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
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