APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_ARTICLE_ADOPTIONS

Line 290: INSERT INTO OKC_ARTICLE_ADOPTIONS

286: RAISE FND_API.G_EXC_ERROR ;
287: END IF;
288:
289:
290: INSERT INTO OKC_ARTICLE_ADOPTIONS
291: (
292: GLOBAL_ARTICLE_VERSION_ID,
293: ADOPTION_TYPE,
294: LOCAL_ORG_ID,

Line 322: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP

318: AND VER.ORIG_SYSTEM_REFERENCE_CODE = ART.ORIG_SYSTEM_REFERENCE_CODE
319: AND ART.ARTICLE_ID = VER.ARTICLE_ID
320: AND ART.ORG_ID = G_GLOBAL_ORG_ID
321: AND NOT EXISTS
322: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP
323: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
324: AND ADP.LOCAL_ORG_ID = G_CURRENT_ORG_ID);
325:
326: -- Create Relationships for the org. as a copy of the global relationships

Line 1703: INSERT INTO OKC_ARTICLE_ADOPTIONS

1699: G_context := 'ADP';
1700:
1701: -- Bulk insert Article Adoptions
1702: FORALL i in t_article_version_id_tbl.FIRST ..t_article_version_id_tbl.LAST
1703: INSERT INTO OKC_ARTICLE_ADOPTIONS
1704: (
1705: GLOBAL_ARTICLE_VERSION_ID,
1706: ADOPTION_TYPE,
1707: LOCAL_ORG_ID,

Line 1734: 1 FROM OKC_ARTICLE_ADOPTIONS

1730: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1731: AND ORGANIZATION_ID <> G_GLOBAL_ORG_ID
1732: AND NOT EXISTS
1733: (SELECT /*+ NO_UNNEST */
1734: 1 FROM OKC_ARTICLE_ADOPTIONS
1735: WHERE GLOBAL_ARTICLE_VERSION_ID = t_article_version_id_tbl(i)
1736: AND LOCAL_ORG_ID = ORGANIZATION_ID);
1737: EXCEPTION
1738: WHEN OTHERS THEN