eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ART_BLK_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 205: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

201: SELECT x_id, ART.article_id, VER.article_version_id, ART.org_id,
202: ART.ARTICLE_TITLE, VER.DISPLAY_NAME, ART.ARTICLE_TYPE,
203: nvl(VER.DEFAULT_SECTION, 'UNASSIGNED'), nvl(VER.ARTICLE_STATUS,'DRAFT'),
204: VER.start_date, 'N', nvl(VER.GLOBAL_YN, 'N'), 'N'
205: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
206: WHERE VER.article_version_id = p_art_ver_tbl(i)
207: AND ART.ARTICLE_ID = VER.ARTICLE_ID
208: AND ART.ORG_ID = G_GLOBAL_ORG_ID;
209:

Line 234: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

230: SELECT x_id, ART.article_id, VER.article_version_id, ART.org_id,
231: ART.ARTICLE_TITLE, VER.DISPLAY_NAME, ART.ARTICLE_TYPE,
232: nvl(VER.DEFAULT_SECTION, 'UNASSIGNED'), nvl(VER.ARTICLE_STATUS,'DRAFT'),
233: VER.start_date,'N', 'N', decode(VER.ADOPTION_TYPE, 'LOCALIZED', 'Y', 'N')
234: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
235: WHERE VER.article_version_id = p_art_ver_tbl(i)
236: AND ART.ARTICLE_ID = VER.ARTICLE_ID
237: AND ART.ORG_ID = p_org_id;
238:

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 827: UPDATE OKC_ARTICLE_VERSIONS

823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: IF (p_status = 'APPROVED') THEN
826:
827: UPDATE OKC_ARTICLE_VERSIONS
828: SET
829: ARTICLE_STATUS = p_status,
830: -- date approved must also be updated
831: DATE_APPROVED = l_date,

Line 842: UPDATE OKC_ARTICLE_VERSIONS

838: (SELECT article_version_id FROM OKC_ART_BLK_TEMP
839: WHERE id = p_id AND adopt_asis_yn = 'N');
840: ELSE
841:
842: UPDATE OKC_ARTICLE_VERSIONS
843: SET
844: ARTICLE_STATUS = p_status,
845: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
846: LAST_UPDATED_BY = G_USER_ID,

Line 976: OKC_ARTICLE_VERSIONS PREV

972: --determine all previous versions that have a null end date
973: CURSOR l_prev_ver_csr(cp_id IN NUMBER) IS
974: SELECT PREV.article_version_id, TMP.start_date
975: FROM OKC_ART_BLK_TEMP TMP,
976: OKC_ARTICLE_VERSIONS PREV
977: WHERE TMP.id = cp_id AND
978: TMP.adopt_asis_yn = 'N' AND
979: PREV.article_id = TMP.article_id AND
980: PREV.article_version_id <> TMP.article_version_id AND

Line 982: FROM OKC_ARTICLE_VERSIONS VER

978: TMP.adopt_asis_yn = 'N' AND
979: PREV.article_id = TMP.article_id AND
980: PREV.article_version_id <> TMP.article_version_id AND
981: PREV.start_date = (SELECT max(VER.start_date)
982: FROM OKC_ARTICLE_VERSIONS VER
983: WHERE VER.article_id = TMP.article_id AND
984: VER.article_version_id <> TMP.article_version_id)
985: AND PREV.end_date IS NULL;
986:

Line 1011: UPDATE OKC_ARTICLE_VERSIONS

1007: CLOSE l_prev_ver_csr;
1008:
1009: IF l_found THEN
1010: FORALL i IN l_prev_ver_id_tbl.FIRST..l_prev_ver_id_tbl.LAST
1011: UPDATE OKC_ARTICLE_VERSIONS
1012: SET
1013: END_DATE = l_start_date_tbl(i) - l_one_sec,
1014: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
1015: LAST_UPDATED_BY = G_USER_ID,

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