APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_ARTICLE_RELATNS_ALL

Line 328: INSERT INTO OKC_ARTICLE_RELATNS_ALL(

324: AND ADP.LOCAL_ORG_ID = G_CURRENT_ORG_ID);
325:
326: -- Create Relationships for the org. as a copy of the global relationships
327:
328: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
329: SOURCE_ARTICLE_ID,
330: TARGET_ARTICLE_ID,
331: ORG_ID,
332: RELATIONSHIP_TYPE,

Line 350: FROM OKC_ARTICLE_RELATNS_ALL REL

346: sysdate,
347: G_User_Id,
348: G_Login_Id,
349: sysdate
350: FROM OKC_ARTICLE_RELATNS_ALL REL
351: WHERE ORG_ID = G_GLOBAL_ORG_ID
352: AND EXISTS
353: (SELECT 1 FROM OKC_ARTICLES_ALL SRC, OKC_ARTICLES_ALL TAR
354: WHERE SRC.orig_system_reference_code like 'OKCMIG%'

Line 361: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL REL1

357: AND TAR.org_id = G_GLOBAL_ORG_ID
358: AND TAR.article_id = REL.target_article_id
359: AND TAR.orig_system_reference_code = SRC.orig_system_reference_code)
360: AND NOT EXISTS
361: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL REL1
362: WHERE REL1.source_article_id = REL.source_article_id AND
363: REL1.target_article_id = REL.target_article_id AND
364: REL1.org_id = G_CURRENT_ORG_ID);
365:

Line 1453: INSERT INTO OKC_ARTICLE_RELATNS_ALL(

1449: -- Bulk insert Article relationships
1450: BEGIN
1451: G_context := 'ARL';
1452: FORALL i in article_id_tbl.FIRST ..article_id_tbl.LAST
1453: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
1454: SOURCE_ARTICLE_ID,
1455: TARGET_ARTICLE_ID,
1456: ORG_ID,
1457: RELATIONSHIP_TYPE,

Line 1486: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1

1482: AND SRC.article_id = article_id_tbl(i)
1483: AND art_process_status_tbl(i) = 'S'
1484: AND NOT EXISTS
1485: (SELECT /*+ NO_UNNEST */
1486: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1
1487: WHERE rel1.source_article_id = src.article_id and
1488: rel1.target_article_id = tar.article_id and
1489: rel1.org_id = org.organization_id);
1490:

Line 1515: INSERT INTO OKC_ARTICLE_RELATNS_ALL(

1511:
1512: BEGIN
1513: G_context := 'ARL2';
1514: FORALL i in article_id_tbl.FIRST ..article_id_tbl.LAST
1515: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
1516: SOURCE_ARTICLE_ID,
1517: TARGET_ARTICLE_ID,
1518: ORG_ID,
1519: RELATIONSHIP_TYPE,

Line 1548: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1

1544: AND TAR.article_id = article_id_tbl(i)
1545: AND art_process_status_tbl(i) = 'S'
1546: AND NOT EXISTS
1547: (SELECT /*+ NO_UNNEST */
1548: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1
1549: WHERE rel1.source_article_id = src.article_id and
1550: rel1.target_article_id = tar.article_id and
1551: rel1.org_id = org.organization_id);
1552:

Line 1577: INSERT INTO OKC_ARTICLE_RELATNS_ALL(

1573:
1574: BEGIN
1575: G_context := 'ARL3';
1576: FORALL i in article_id_tbl.FIRST ..article_id_tbl.LAST
1577: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
1578: SOURCE_ARTICLE_ID,
1579: TARGET_ARTICLE_ID,
1580: ORG_ID,
1581: RELATIONSHIP_TYPE,

Line 1610: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1

1606: AND SRC.article_id = article_id_tbl(i)
1607: AND art_process_status_tbl(i) = 'S'
1608: AND NOT EXISTS
1609: (SELECT /*+ NO_UNNEST */
1610: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1
1611: WHERE rel1.source_article_id = src.article_id and
1612: rel1.target_article_id = tar.article_id and
1613: rel1.org_id = org.organization_id);
1614:

Line 1639: INSERT INTO OKC_ARTICLE_RELATNS_ALL(

1635:
1636: BEGIN
1637: G_context := 'ARL4';
1638: FORALL i in article_id_tbl.FIRST ..article_id_tbl.LAST
1639: INSERT INTO OKC_ARTICLE_RELATNS_ALL(
1640: SOURCE_ARTICLE_ID,
1641: TARGET_ARTICLE_ID,
1642: ORG_ID,
1643: RELATIONSHIP_TYPE,

Line 1672: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1

1668: AND TAR.article_id = article_id_tbl(i)
1669: AND art_process_status_tbl(i) = 'S'
1670: AND NOT EXISTS
1671: (SELECT /*+ NO_UNNEST */
1672: 1 FROM OKC_ARTICLE_RELATNS_ALL REL1
1673: WHERE rel1.source_article_id = src.article_id and
1674: rel1.target_article_id = tar.article_id and
1675: rel1.org_id = org.organization_id);
1676: