APPS.OKC_ART_BLK_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 261: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER, OKC_ARTICLE_ADOPTIONS ADP

257: SELECT x_id, ART.article_id, VER.article_version_id, ART.org_id,
258: ART.ARTICLE_TITLE, VER.DISPLAY_NAME, ART.ARTICLE_TYPE,
259: nvl(VER.DEFAULT_SECTION, 'UNASSIGNED'), nvl(ADP.ADOPTION_STATUS,'DRAFT'),
260: VER.start_date,'Y', 'N', 'N'
261: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER, OKC_ARTICLE_ADOPTIONS ADP
262: WHERE VER.article_version_id = p_art_ver_tbl(i)
263: AND ART.ARTICLE_ID = VER.ARTICLE_ID
264: AND ART.ORG_ID = G_GLOBAL_ORG_ID
265: AND ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID

Line 898: UPDATE OKC_ARTICLE_ADOPTIONS

894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895:
896: IF (p_type = 'ADOPTED') THEN
897:
898: UPDATE OKC_ARTICLE_ADOPTIONS
899: SET
900: ADOPTION_TYPE = nvl(p_adoption_type, ADOPTION_TYPE),
901: ADOPTION_STATUS = nvl(p_adoption_status, ADOPTION_STATUS),
902: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 914: UPDATE OKC_ARTICLE_ADOPTIONS

910: AND LOCAL_ORG_ID = p_local_org_id;
911:
912: ELSIF (p_type = 'LOCALIZED') THEN
913:
914: UPDATE OKC_ARTICLE_ADOPTIONS
915: SET
916: ADOPTION_TYPE = nvl(p_adoption_type, ADOPTION_TYPE),
917: ADOPTION_STATUS = nvl(p_adoption_status, ADOPTION_STATUS),
918: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 1103: (SELECT 1 FROM OKC_ARTICLE_VERSIONS AV1, OKC_ARTICLE_ADOPTIONS ADP

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
1103: (SELECT 1 FROM OKC_ARTICLE_VERSIONS AV1, OKC_ARTICLE_ADOPTIONS ADP
1104: WHERE AV1.article_id = REL.target_article_id AND
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')

Line 1143: (SELECT 1 FROM OKC_ARTICLE_VERSIONS AV1, OKC_ARTICLE_ADOPTIONS ADP

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
1143: (SELECT 1 FROM OKC_ARTICLE_VERSIONS AV1, OKC_ARTICLE_ADOPTIONS ADP
1144: WHERE AV1.article_id = REL.source_article_id AND
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')

Line 1224: ( SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV1

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
1225: WHERE AV1.article_id = l_art_id_tbl(i)
1226: AND AV1.article_version_id <> l_art_ver_id_tbl(i)
1227: AND ADP.adoption_type = 'ADOPTED'
1228: AND ADP.global_article_version_id = AV1.article_version_id

Line 1238: ( SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV2

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
1239: WHERE AV2.article_id = l_art_id_tbl(i)
1240: AND AV2.article_version_id <> l_art_ver_id_tbl(i)
1241: AND ADP.adoption_type = 'ADOPTED'
1242: AND ADP.global_article_version_id = AV2.article_version_id

Line 1640: INSERT INTO OKC_ARTICLE_ADOPTIONS

1636: END IF;
1637:
1638: -- first insert rows in adoptions table for each clause and local org
1639: FORALL i IN l_org_id_tbl.FIRST.. l_org_id_tbl.LAST
1640: INSERT INTO OKC_ARTICLE_ADOPTIONS
1641: (
1642: GLOBAL_ARTICLE_VERSION_ID,
1643: ADOPTION_TYPE,
1644: LOCAL_ORG_ID,

Line 1677: UPDATE OKC_ARTICLE_ADOPTIONS

1673: IF (l_found) THEN
1674: -- need to update adoption type to 'AVAILABLE', status to NULL
1675:
1676: FORALL i IN l_non_uniq_art_ver_tbl.FIRST..l_non_uniq_art_ver_tbl.LAST
1677: UPDATE OKC_ARTICLE_ADOPTIONS
1678: SET
1679: ADOPTION_TYPE = 'AVAILABLE',
1680: ADOPTION_STATUS = NULL
1681: WHERE

Line 1699: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_ADOPTIONS ADP

1695: ARTICLE_VERSION_ID,
1696: ORG_ID
1697: )
1698: SELECT l_id, TMP.article_id, TMP.article_version_id, ADP.local_org_id
1699: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_ADOPTIONS ADP
1700: WHERE TMP.id = p_id AND
1701: TMP.global_yn = 'Y' AND
1702: ADP.global_article_version_id = TMP.article_version_id AND
1703: ADP.adoption_type = 'ADOPTED';