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 899: UPDATE OKC_ARTICLE_ADOPTIONS

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

Line 915: UPDATE OKC_ARTICLE_ADOPTIONS

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

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

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

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

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

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

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

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

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

Line 1641: INSERT INTO OKC_ARTICLE_ADOPTIONS

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

Line 1678: UPDATE OKC_ARTICLE_ADOPTIONS

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

Line 1700: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_ADOPTIONS ADP

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