APPS.OKC_XPRT_QA_PVT dependencies on OKC_ARTICLES_ALL

Line 150: FROM okc_articles_all

146:
147: CURSOR csr_get_article_number(p_article_id IN NUMBER)
148: IS
149: SELECT article_number
150: FROM okc_articles_all
151: WHERE article_id= p_article_id;
152: l_art_number okc_articles_all.article_number%TYPE;
153: l_clause_title VARCHAR2(2000);
154:

Line 152: l_art_number okc_articles_all.article_number%TYPE;

148: IS
149: SELECT article_number
150: FROM okc_articles_all
151: WHERE article_id= p_article_id;
152: l_art_number okc_articles_all.article_number%TYPE;
153: l_clause_title VARCHAR2(2000);
154:
155: BEGIN
156: IF g_concat_art_no = 'Y' THEN

Line 663: okc_articles_all a

659: a.article_title
660: FROM okc_xprt_rule_cond_vals v,
661: okc_xprt_rule_conditions c,
662: okc_xprt_rule_hdrs_all r,
663: okc_articles_all a
664: WHERE v.rule_condition_id = c.rule_condition_id
665: AND c.rule_id = r.rule_id
666: AND a.article_id = to_number(v.object_value_code) -- Fixed for Bug 4935811. Removed to_char on article_id
667: AND c.object_type = 'CLAUSE'

Line 676: okc_articles_all a

672: SELECT to_char(o.object_value_id) article_id,
673: a.article_title
674: FROM okc_xprt_rule_outcomes o,
675: okc_xprt_rule_hdrs_all r,
676: okc_articles_all a
677: WHERE o.rule_id = r.rule_id
678: AND a.article_id = o.object_value_id
679: AND o.object_type = 'CLAUSE'
680: AND r.rule_id = p_rule_id

Line 687: okc_articles_all a

683:
684: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
685: SELECT v.article_status
686: FROM okc_article_versions v,
687: okc_articles_all a
688: WHERE a.article_id = v.article_id
689: AND a.article_id = p_article_id
690: AND v.article_status IN ('APPROVED','ON_HOLD')
691: AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1);

Line 696: okc_articles_all a

692:
693: CURSOR csr_approved_ver_exists(p_article_id IN NUMBER) IS
694: SELECT 'x'
695: FROM okc_article_versions v,
696: okc_articles_all a
697: WHERE a.article_id = v.article_id
698: AND a.article_id = p_article_id
699: AND v.article_status IN ('APPROVED','ON_HOLD');
700:

Line 908: okc_articles_all a

904: a.article_title
905: FROM okc_xprt_rule_cond_vals v,
906: okc_xprt_rule_conditions c,
907: okc_xprt_rule_hdrs_all r,
908: okc_articles_all a
909: WHERE v.rule_condition_id = c.rule_condition_id
910: AND c.rule_id = r.rule_id
911: AND to_char(a.article_id) = v.object_value_code
912: AND c.object_type = 'CLAUSE'

Line 921: okc_articles_all a

917: SELECT to_char(o.object_value_id) article_id,
918: a.article_title
919: FROM okc_xprt_rule_outcomes o,
920: okc_xprt_rule_hdrs_all r,
921: okc_articles_all a
922: WHERE o.rule_id = r.rule_id
923: AND a.article_id = o.object_value_id
924: AND o.object_type = 'CLAUSE'
925: AND r.rule_id = p_rule_id

Line 932: okc_articles_all a

928:
929: CURSOR l_check_art_effectivity(p_article_id IN NUMBER) IS
930: SELECT 'x'
931: FROM okc_article_versions v,
932: okc_articles_all a
933: WHERE a.article_id = v.article_id
934: AND a.article_id = p_article_id
935: AND v.article_status IN ('DRAFT','PENDING_APPROVAL','REJECTED')
936: -- AND sysdate BETWEEN v.start_date AND NVL(v.end_date,sysdate+1)

Line 941: okc_articles_all a

937: AND NOT EXISTS
938: (
939: SELECT 'x'
940: FROM okc_article_versions v,
941: okc_articles_all a
942: WHERE a.article_id = v.article_id
943: AND a.article_id = p_article_id
944: AND v.article_status IN ('APPROVED','ON_HOLD')
945: )