[Home] [Help]
420: AND bvar.variable_source = 'M'
421: AND bvar.clm_source IS NULL --CLM Changes
422: AND var.variable_code IN ( SELECT rcon.object_code variable_code -- LHS of Condition from Template rule
423: FROM okc_xprt_rule_hdrs_all rhdr,
424: okc_xprt_rule_conditions rcon,
425: okc_template_usages tuse,
426: okc_xprt_template_rules trule
427: WHERE tuse.document_id = p_doc_id
428: AND tuse.document_type = p_doc_type
435: GROUP BY rcon.object_code
436: UNION
437: SELECT rcon.object_value_code variable_code -- RHS of Condition from Template rule
438: FROM okc_xprt_rule_hdrs_all rhdr,
439: okc_xprt_rule_conditions rcon,
440: okc_template_usages tuse,
441: okc_xprt_template_rules trule
442: WHERE tuse.document_id = p_doc_id
443: AND tuse.document_type = p_doc_type
450: GROUP BY rcon.object_value_code
451: UNION
452: SELECT rcon.object_code variable_code -- LHS of Condition from Global Rule
453: FROM okc_xprt_rule_hdrs_all rhdr,
454: okc_xprt_rule_conditions rcon
455: WHERE rhdr.rule_id = rcon.rule_id
456: AND rhdr.org_id = p_org_id
457: AND rhdr.intent = p_intent
458: AND rhdr.org_wide_flag = 'Y'
462: GROUP BY rcon.object_code
463: UNION
464: SELECT rcon.object_value_code variable_code -- RHS of Condition from Global Rule
465: FROM okc_xprt_rule_hdrs_all rhdr,
466: okc_xprt_rule_conditions rcon
467: WHERE rhdr.rule_id = rcon.rule_id
468: AND rhdr.org_id = p_org_id
469: AND rhdr.intent = p_intent
470: AND rhdr.org_wide_flag = 'Y'
571: CURSOR csr_constants (p_intent VARCHAR2) IS
572: SELECT 'CONSTANT$' || v.object_value_code constant_id, --
573: q.default_value
574: FROM okc_xprt_rule_cond_vals v,
575: okc_xprt_rule_conditions c,
576: okc_xprt_rule_hdrs_all r,
577: okc_xprt_questions_b q
578: WHERE v.rule_condition_id = c.rule_condition_id
579: AND c.rule_id = r.rule_id
681: WHERE var.variable_source = 'P'
682: AND var.variable_code IN
683: (SELECT distinct rcon.object_code variable_code -- LHS of Condition from Template rule
684: FROM okc_xprt_rule_hdrs_all rhdr,
685: okc_xprt_rule_conditions rcon,
686: okc_template_usages tuse,
687: okc_xprt_template_rules trule
688: WHERE tuse.document_id = p_doc_id
689: AND tuse.document_type = p_doc_type
696: GROUP BY rcon.object_code
697: UNION
698: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Template rule
699: FROM okc_xprt_rule_hdrs_all rhdr,
700: okc_xprt_rule_conditions rcon,
701: okc_template_usages tuse,
702: okc_xprt_template_rules trule
703: WHERE tuse.document_id = p_doc_id
704: AND tuse.document_type = p_doc_type
711: GROUP BY rcon.object_value_code
712: UNION
713: SELECT distinct rcon.object_code variable_code -- LHS of Condition from Global Rule
714: FROM okc_xprt_rule_hdrs_all rhdr,
715: okc_xprt_rule_conditions rcon
716: WHERE rhdr.rule_id = rcon.rule_id
717: AND rhdr.org_id = p_org_id
718: AND rhdr.intent = p_intent
719: AND rhdr.org_wide_flag = 'Y'
723: GROUP BY rcon.object_code
724: UNION
725: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Global Rule
726: FROM okc_xprt_rule_hdrs_all rhdr,
727: okc_xprt_rule_conditions rcon
728: WHERE rhdr.rule_id = rcon.rule_id
729: AND rhdr.org_id = p_org_id
730: AND rhdr.intent = p_intent
731: AND rhdr.org_wide_flag = 'Y'
1023: FROM okc_xprt_rule_cond_vals val
1024: WHERE InStr(OBJECT_VALUE_CODE,p_variable_value_id||'_',1,1) = 1
1025: AND OBJECT_VALUE_CODE <> p_variable_value_id
1026: AND RULE_CONDITION_ID IN (SELECT rule_condition_id
1027: FROM OKC_XPRT_RULE_CONDITIONS
1028: WHERE OBJECT_CODE = 'OKC$S_ITEM'
1029: AND rule_id IN (SELECT rhdr.rule_id
1030: FROM okc_xprt_rule_hdrs_all rhdr,
1031: okc_template_usages tuse,