APPS.OKC_ART_BLK_PVT dependencies on OKC_ARTICLE_RELATNS_ALL

Line 1076: INSERT INTO OKC_ARTICLE_RELATNS_ALL

1072: okc_debug.log('100: Entering adopt_relationships_blk: p_id='||p_id);
1073: END IF;
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075:
1076: INSERT INTO OKC_ARTICLE_RELATNS_ALL
1077: (
1078: SOURCE_ARTICLE_ID,
1079: TARGET_ARTICLE_ID,
1080: ORG_ID,

Line 1099: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

1095: l_date,
1096: G_USER_ID,
1097: G_LOGIN_ID,
1098: l_date
1099: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL
1100: WHERE TMP.id = p_id AND
1101: REL.org_id = G_GLOBAL_ORG_ID AND
1102: REL.source_article_id = TMP.article_id AND
1103: EXISTS

Line 1110: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL ARL1

1106: ADP.global_article_version_id = AV1.article_version_id AND
1107: ADP.local_org_id = TMP.org_id AND
1108: ADP.adoption_type = 'ADOPTED')
1109: AND NOT EXISTS
1110: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL ARL1
1111: WHERE REL.source_article_id = ARL1.source_article_id AND
1112: REL.target_article_id = ARL1.target_article_id AND
1113: REL.relationship_type = ARL1.relationship_type AND
1114: ARL1.org_id = TMP.org_id);

Line 1116: INSERT INTO OKC_ARTICLE_RELATNS_ALL

1112: REL.target_article_id = ARL1.target_article_id AND
1113: REL.relationship_type = ARL1.relationship_type AND
1114: ARL1.org_id = TMP.org_id);
1115:
1116: INSERT INTO OKC_ARTICLE_RELATNS_ALL
1117: (
1118: SOURCE_ARTICLE_ID,
1119: TARGET_ARTICLE_ID,
1120: ORG_ID,

Line 1139: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

1135: l_date,
1136: G_USER_ID,
1137: G_LOGIN_ID,
1138: l_date
1139: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL
1140: WHERE TMP.id = p_id AND
1141: REL.org_id = G_GLOBAL_ORG_ID AND
1142: REL.target_article_id = TMP.article_id AND
1143: EXISTS

Line 1150: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL ARL1

1146: ADP.global_article_version_id = AV1.article_version_id AND
1147: ADP.local_org_id = TMP.org_id AND
1148: ADP.adoption_type = 'ADOPTED')
1149: AND NOT EXISTS
1150: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL ARL1
1151: WHERE REL.source_article_id = ARL1.source_article_id AND
1152: REL.target_article_id = ARL1.target_article_id AND
1153: REL.relationship_type = ARL1.relationship_type AND
1154: ARL1.org_id = TMP.org_id);

Line 1221: DELETE FROM OKC_ARTICLE_RELATNS_ALL

1217: END IF;
1218:
1219: -- delete where source article has not been adopted
1220: FORALL i IN l_art_id_tbl.FIRST..l_art_id_tbl.LAST
1221: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1222: WHERE org_id = p_org_id
1223: AND source_article_id = l_art_id_tbl(i)
1224: AND NOT EXISTS
1225: ( SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV1

Line 1235: DELETE FROM OKC_ARTICLE_RELATNS_ALL

1231: );
1232:
1233: -- delete where target article has not been adopted
1234: FORALL i IN l_art_id_tbl.FIRST..l_art_id_tbl.LAST
1235: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1236: WHERE org_id = p_org_id
1237: AND target_article_id = l_art_id_tbl(i)
1238: AND NOT EXISTS
1239: ( SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV2