APPS.OKC_CA_UTIL_PVT dependencies on OKC_CA_ART_VERSIONS_GT

Line 206: delete okc_ca_art_versions_gt

202: end;
203:
204: procedure remove_included( p_search_id in number) as
205: begin
206: delete okc_ca_art_versions_gt
207: where article_srch_id = p_search_id
208: and article_flag = 'S';
209: exception when others then null;
210: end;

Line 217: merge into okc_ca_art_versions_gt gt

213: p_alternates in varchar2
214: ) as
215: begin
216: if p_alternates = 'Y' THEN
217: merge into okc_ca_art_versions_gt gt
218: using (
219: select
220: article_srch_id,
221: art.article_id,

Line 247: okc_ca_art_versions_gt

243: org_id,
244: article_srch_id
245: from
246: okc_article_relatns_all,
247: okc_ca_art_versions_gt
248: where source_article_id = article_id
249: and org_id = article_org_id
250: and article_srch_id = p_search_id
251: and article_flag = 'U'

Line 297: okc_ca_art_versions_gt

293: org_id,
294: article_srch_id
295: from
296: okc_article_relatns_all,
297: okc_ca_art_versions_gt
298: where source_article_id = article_id
299: and org_id = article_org_id
300: and article_srch_id = p_search_id
301: and article_flag = 'U'

Line 373: merge into okc_ca_art_versions_gt gt

369: p_adoptions in varchar2
370: ) as
371: begin
372: if p_adoptions = 'Y' THEN
373: merge into okc_ca_art_versions_gt gt
374: using (
375: select
376: article_srch_id,
377: article_id,

Line 387: okc_ca_art_versions_gt t,

383: 'ADOPTED' adoption_type,
384: org_name
385: from
386: okc_article_adoptions a,
387: okc_ca_art_versions_gt t,
388: ( select
389: orgu.organization_id org_id,
390: orgu.name org_name
391: from

Line 452: merge into okc_ca_art_versions_gt gt

448: p_all_versions in varchar2
449: ) as
450: begin
451: if p_all_versions = 'Y' THEN
452: merge into okc_ca_art_versions_gt gt
453: using (
454: select
455: article_srch_id,
456: t.article_id,

Line 466: okc_ca_art_versions_gt t,

462: article_adoption_type,
463: org_name
464: from
465: okc_article_versions a,
466: okc_ca_art_versions_gt t,
467: ( select
468: orgu.organization_id org_id,
469: orgu.name org_name
470: from

Line 494: okc_ca_art_versions_gt t,

490: 'ADOPTED' adoption_type,
491: org_name
492: from
493: okc_article_versions a,
494: okc_ca_art_versions_gt t,
495: ( select
496: orgu.organization_id org_id,
497: orgu.name org_name
498: from

Line 563: merge into okc_ca_art_versions_gt gt

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,
567: a.article_id,

Line 580: okc_ca_art_versions_gt t,

576: t.article_version_number std_article_version_number
577: from
578: okc_articles_all a,
579: okc_article_versions v,
580: okc_ca_art_versions_gt t,
581: ( select
582: orgu.organization_id org_id,
583: orgu.name org_name
584: from