[Home] [Help]
340: gt.article_org_id,
341: gt.article_flag,
342: gt.article_title,
343: gt.article_type,
344: gt.article_standard_yn,
345: gt.article_version_number,
346: gt.article_adoption_type,
347: gt.article_org_name,
348: gt.std_article_title,
399: and global_article_version_id = article_version_id
400: and article_adoption_type = 'GLOBAL'
401: and a.adoption_type = 'ADOPTED'
402: and a.adoption_status = 'APPROVED'
403: and article_standard_yn = 'Y'
404: and org.org_id = a.local_org_id
405: ) ado
406: on (
407: gt.article_srch_id = ado.article_srch_id
419: gt.article_org_id,
420: gt.article_flag,
421: gt.article_title,
422: gt.article_type,
423: gt.article_standard_yn,
424: gt.article_version_number,
425: gt.article_adoption_type,
426: gt.article_org_name,
427: gt.std_article_title,
530: gt.article_org_id,
531: gt.article_flag,
532: gt.article_title,
533: gt.article_type,
534: gt.article_standard_yn,
535: gt.article_version_number,
536: gt.article_adoption_type,
537: gt.article_org_name,
538: gt.std_article_title,
554: end if;
555: exception when others then null;
556: end;
557:
558: procedure include_non_standard( p_search_id in number,
559: p_non_standard in varchar2
560: ) as
561: begin
562: if p_non_standard in ( 'A', 'N' ) then
555: exception when others then null;
556: end;
557:
558: procedure include_non_standard( p_search_id in number,
559: p_non_standard in varchar2
560: ) as
561: begin
562: if p_non_standard in ( 'A', 'N' ) then
563: merge into okc_ca_art_versions_gt gt
558: procedure include_non_standard( p_search_id in number,
559: p_non_standard in varchar2
560: ) as
561: begin
562: if p_non_standard in ( 'A', 'N' ) then
563: merge into okc_ca_art_versions_gt gt
564: using (
565: select
566: article_srch_id,
569: a.org_id,
570: a.article_title,
571: a.article_type,
572: v.article_version_number,
573: 'NON-STANDARD' adoption_type,
574: org_name,
575: t.article_title std_article_title,
576: t.article_version_number std_article_version_number
577: from
587: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
588: and orgi.organization_id = orgu.organization_id
589: ) org
590: where a.article_id = v.article_id
591: and standard_yn = 'N'
592: and article_srch_id = p_search_id
593: and t.article_version_id = std_article_version_id
594: and t.article_org_id = org.org_id
595: and t.article_org_id = a.org_id
598: gt.article_srch_id = non.article_srch_id
599: and gt.article_id = non.article_id
600: and gt.article_version_id = non.article_version_id
601: and gt.article_org_id = non.org_id
602: and gt.article_standard_yn = 'N'
603: )
604: when matched then
605: update set gt.object_version_number = gt.object_version_number+1
606: when not matched then
611: gt.article_org_id,
612: gt.article_flag,
613: gt.article_title,
614: gt.article_type,
615: gt.article_standard_yn,
616: gt.article_version_number,
617: gt.article_adoption_type,
618: gt.article_org_name,
619: gt.std_article_title,
642: procedure include_articles( p_search_id in number,
643: p_alternates in varchar2,
644: p_adoptions in varchar2,
645: p_all_versions in varchar2,
646: p_non_standard in varchar2
647: ) as
648: begin
649: remove_included(p_search_id);
650: include_alternates(p_search_id, p_alternates);
649: remove_included(p_search_id);
650: include_alternates(p_search_id, p_alternates);
651: include_all_versions(p_search_id, p_all_versions);
652: include_adoptions(p_search_id, p_adoptions);
653: include_non_standard(p_search_id, p_non_standard);
654: exception when others then null;
655: end;
656:
657: function article_number( p_article_id in number)