APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_ARTICLE_RELATNS_ALL

Line 874: INSERT INTO OKC_ARTICLE_RELATNS_ALL

870: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
871: RAISE FND_API.G_EXC_ERROR ;
872: END IF;
873:
874: INSERT INTO OKC_ARTICLE_RELATNS_ALL
875: (
876: SOURCE_ARTICLE_ID,
877: TARGET_ARTICLE_ID,
878: ORG_ID,

Line 897: from OKC_ARTICLE_RELATNS_ALL ARL1

893: sysdate,
894: l_user_id,
895: l_login_id,
896: sysdate
897: from OKC_ARTICLE_RELATNS_ALL ARL1
898: WHERE org_id = G_GLOBAL_ORG_ID
899: AND exists
900: (select 1 from okc_article_versions, okc_article_adoptions adp
901: where article_id = target_article_id

Line 910: (select 1 from okc_article_relatns_all ARL2

906: (select 1 from okc_article_versions
907: where article_version_id = p_article_version_id
908: and source_article_id = article_id)
909: AND NOT EXISTS
910: (select 1 from okc_article_relatns_all ARL2
911: where arl1.source_article_id = arl2.source_article_id
912: and arl1.target_article_id = arl2.target_article_id
913: and arl1.relationship_type = arl2.relationship_type
914: and arl2.org_id = p_current_org_id);

Line 916: INSERT INTO OKC_ARTICLE_RELATNS_ALL

912: and arl1.target_article_id = arl2.target_article_id
913: and arl1.relationship_type = arl2.relationship_type
914: and arl2.org_id = p_current_org_id);
915:
916: INSERT INTO OKC_ARTICLE_RELATNS_ALL
917: (
918: SOURCE_ARTICLE_ID,
919: TARGET_ARTICLE_ID,
920: ORG_ID,

Line 939: from OKC_ARTICLE_RELATNS_ALL ARL1

935: sysdate,
936: l_user_id,
937: l_login_id,
938: sysdate
939: from OKC_ARTICLE_RELATNS_ALL ARL1
940: WHERE org_id = G_GLOBAL_ORG_ID
941: AND exists
942: (select 1 from okc_article_versions, okc_article_adoptions adp
943: where article_id = source_article_id

Line 952: (select 1 from okc_article_relatns_all ARL2

948: (select 1 from okc_article_versions
949: where article_version_id = p_article_version_id
950: and target_article_id = article_id)
951: AND NOT EXISTS
952: (select 1 from okc_article_relatns_all ARL2
953: where arl1.source_article_id = arl2.source_article_id
954: and arl1.target_article_id = arl2.target_article_id
955: and arl1.relationship_type = arl2.relationship_type
956: and arl2.org_id = p_current_org_id);

Line 1527: DELETE FROM OKC_ARTICLE_RELATNS_ALL

1523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1524: RAISE FND_API.G_EXC_ERROR ;
1525: END IF;
1526: --------------------------------------------
1527: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1528: WHERE source_article_id = l_article_version_rec.article_id
1529: AND org_id = p_current_org_id
1530: AND NOT EXISTS
1531: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV

Line 1538: DELETE FROM OKC_ARTICLE_RELATNS_ALL

1534: AND ADP.ADOPTION_TYPE = 'ADOPTED'
1535: AND global_article_version_id = article_version_id
1536: );
1537:
1538: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1539: WHERE target_article_id = l_article_version_rec.article_id
1540: AND org_id = p_current_org_id
1541: AND NOT EXISTS
1542: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV