APPS.OKC_ART_BLK_PVT dependencies on OKC_ARTICLE_RELATNS_ALL

Line 1075: INSERT INTO OKC_ARTICLE_RELATNS_ALL

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

Line 1098: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

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

Line 1109: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL ARL1

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

Line 1115: INSERT INTO OKC_ARTICLE_RELATNS_ALL

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

Line 1138: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

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

Line 1149: (SELECT 1 FROM OKC_ARTICLE_RELATNS_ALL ARL1

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

Line 1220: DELETE FROM OKC_ARTICLE_RELATNS_ALL

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

Line 1234: DELETE FROM OKC_ARTICLE_RELATNS_ALL

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