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

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

Line 843: UPDATE OKC_ARTICLE_VERSIONS

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

Line 977: OKC_ARTICLE_VERSIONS PREV

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

Line 983: FROM OKC_ARTICLE_VERSIONS VER

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

Line 1012: UPDATE OKC_ARTICLE_VERSIONS

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

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