[Home] [Help]
621: a.article_title
622: FROM okc_xprt_rule_cond_vals v,
623: okc_xprt_rule_conditions c,
624: okc_xprt_rule_hdrs_all r,
625: okc_articles_all a
626: WHERE v.rule_condition_id = c.rule_condition_id
627: AND c.rule_id = r.rule_id
628: AND a.article_id = to_number(v.object_value_code) -- Fixed for Bug 4935811. Removed to_char on article_id
629: AND c.object_type = 'CLAUSE'
634: SELECT to_char(o.object_value_id) article_id,
635: a.article_title
636: FROM okc_xprt_rule_outcomes o,
637: okc_xprt_rule_hdrs_all r,
638: okc_articles_all a
639: WHERE o.rule_id = r.rule_id
640: AND a.article_id = o.object_value_id
641: AND o.object_type = 'CLAUSE'
642: AND r.rule_id = p_rule_id
645:
646: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
647: SELECT v.article_status
648: FROM okc_article_versions v,
649: okc_articles_all a
650: WHERE a.article_id = v.article_id
651: AND a.article_id = p_article_id
652: AND v.article_status IN ('APPROVED','ON_HOLD')
653: AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1);
654:
655: CURSOR csr_approved_ver_exists(p_article_id IN NUMBER) IS
656: SELECT 'x'
657: FROM okc_article_versions v,
658: okc_articles_all a
659: WHERE a.article_id = v.article_id
660: AND a.article_id = p_article_id
661: AND v.article_status IN ('APPROVED','ON_HOLD');
662:
845: a.article_title
846: FROM okc_xprt_rule_cond_vals v,
847: okc_xprt_rule_conditions c,
848: okc_xprt_rule_hdrs_all r,
849: okc_articles_all a
850: WHERE v.rule_condition_id = c.rule_condition_id
851: AND c.rule_id = r.rule_id
852: AND to_char(a.article_id) = v.object_value_code
853: AND c.object_type = 'CLAUSE'
858: SELECT to_char(o.object_value_id) article_id,
859: a.article_title
860: FROM okc_xprt_rule_outcomes o,
861: okc_xprt_rule_hdrs_all r,
862: okc_articles_all a
863: WHERE o.rule_id = r.rule_id
864: AND a.article_id = o.object_value_id
865: AND o.object_type = 'CLAUSE'
866: AND r.rule_id = p_rule_id
869:
870: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
871: SELECT 'x'
872: FROM okc_article_versions v,
873: okc_articles_all a
874: WHERE a.article_id = v.article_id
875: AND a.article_id = p_article_id
876: AND v.article_status IN ('DRAFT','PENDING_APPROVAL','REJECTED')
877: -- AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1)
878: AND NOT EXISTS
879: (
880: SELECT 'x'
881: FROM okc_article_versions v,
882: okc_articles_all a
883: WHERE a.article_id = v.article_id
884: AND a.article_id = p_article_id
885: AND v.article_status IN ('APPROVED','ON_HOLD')
886: )