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_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 133: okc_article_versions av

129: av.end_date,
130: av.article_version_number,
131: av.article_version_id
132: from
133: okc_article_versions av
134: where
135: av.article_id = p_article_id
136: and
137: av.start_date = (select

Line 140: okc_article_versions av1

136: and
137: av.start_date = (select
138: max(av1.start_date)
139: from
140: okc_article_versions av1
141: where
142: av1.article_id = av.article_id
143: and
144: av1.end_date is null

Line 166: FROM OKC_ARTICLE_VERSIONS A

162: A.START_DATE, A.END_DATE,
163: MAX(A.START_DATE) OVER (PARTITION BY A.ARTICLE_ID) AS MAX_START_DATE,
164: A.ARTICLE_VERSION_NUMBER,
165: A.ARTICLE_VERSION_ID
166: FROM OKC_ARTICLE_VERSIONS A
167: WHERE A.ARTICLE_ID = p_article_id
168: AND A.END_DATE IS NULL
169: AND ARTICLE_VERSION_ID <> p_article_version_id
170: ) S

Line 188: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: OPEN l_earlier_version_csr(p_article_id, p_article_version_id);
186: FETCH l_earlier_version_csr INTO l_earlier_version_rec ;
187: IF l_earlier_version_csr%FOUND THEN
188: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
189: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
190: x_return_status => x_return_status,
191: p_article_version_id => l_earlier_version_rec.article_version_id,
192: p_article_id => NULL,

Line 296: FROM okc_articles_all art, okc_article_versions ver

292: l_new_article_status VARCHAR2(30) := NULL;
293:
294: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
295: SELECT org_id, article_status, global_yn, art.article_id
296: FROM okc_articles_all art, okc_article_versions ver
297: WHERE ver.article_id = art.article_id
298: AND ver.article_version_id = cp_article_version_id
299: AND art.standard_yn = 'Y'
300: FOR UPDATE OF start_date;

Line 412: UPDATE OKC_ARTICLE_VERSIONS

408: IF (l_debug = 'Y') THEN
409: okc_debug.log('160: Starting Update Article Status ', 2);
410: END IF;
411:
412: UPDATE OKC_ARTICLE_VERSIONS
413: SET ARTICLE_STATUS = l_new_article_status,
414: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
415: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
416: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 565: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART

561:
562: -- Below added for Bug 3737158
563: CURSOR l_article_lkup_csr(cp_article_version_id IN NUMBER) is
564: SELECT DEFAULT_SECTION, ARTICLE_TYPE
565: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART
566: WHERE
567: ART.ARTICLE_ID = VER.ARTICLE_ID
568: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
569:

Line 571: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

567: ART.ARTICLE_ID = VER.ARTICLE_ID
568: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
569:
570:
571: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
572: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
573:
574: -- Above added for Bug 3737158
575:

Line 775: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

771: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
772: IF (l_debug = 'Y') THEN
773: okc_debug.log('100: Entered pending approval for global article at a global org', 2);
774: END IF;
775: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
776: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
777: x_return_status => x_return_status,
778: p_article_version_id => p_article_version_id,
779: p_article_id => NULL,

Line 900: (select 1 from okc_article_versions, okc_article_adoptions adp

896: sysdate
897: from OKC_ARTICLE_RELATNS_ALL ARL1
898: WHERE org_id = G_GLOBAL_ORG_ID
899: AND exists
900: (select 1 from okc_article_versions, okc_article_adoptions adp
901: where article_id = target_article_id
902: and adp.global_article_version_id = article_version_id
903: and adp.local_org_id = p_current_org_id
904: and adp.adoption_type = 'ADOPTED')

Line 906: (select 1 from okc_article_versions

902: and adp.global_article_version_id = article_version_id
903: and adp.local_org_id = p_current_org_id
904: and adp.adoption_type = 'ADOPTED')
905: AND EXISTS
906: (select 1 from okc_article_versions
907: where article_version_id = p_article_version_id
908: and source_article_id = article_id)
909: AND NOT EXISTS
910: (select 1 from okc_article_relatns_all ARL2

Line 942: (select 1 from okc_article_versions, okc_article_adoptions adp

938: sysdate
939: from OKC_ARTICLE_RELATNS_ALL ARL1
940: WHERE org_id = G_GLOBAL_ORG_ID
941: AND exists
942: (select 1 from okc_article_versions, okc_article_adoptions adp
943: where article_id = source_article_id
944: and adp.global_article_version_id = article_version_id
945: and adp.local_org_id = p_current_org_id
946: and adp.adoption_type = 'ADOPTED')

Line 948: (select 1 from okc_article_versions

944: and adp.global_article_version_id = article_version_id
945: and adp.local_org_id = p_current_org_id
946: and adp.adoption_type = 'ADOPTED')
947: AND EXISTS
948: (select 1 from okc_article_versions
949: where article_version_id = p_article_version_id
950: and target_article_id = article_id)
951: AND NOT EXISTS
952: (select 1 from okc_article_relatns_all ARL2

Line 965: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

961: IF (l_debug = 'Y') THEN
962: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);
963: END IF;
964:
965: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
966: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
967: x_return_status => x_return_status,
968: p_article_version_id => p_article_version_id,
969: p_article_id => NULL,

Line 1090: FROM okc_articles_all art, okc_article_versions ver

1086: l_delete_adoption VARCHAR2(1) := 'T';
1087: l_rowid ROWID;
1088: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1089: SELECT global_yn, org_id, art.article_id, start_date
1090: FROM okc_articles_all art, okc_article_versions ver
1091: WHERE ver.article_id = art.article_id
1092: AND ver.article_version_id = cp_article_version_id;
1093: l_article_version_rec l_article_version_csr%ROWTYPE;
1094: l_earlier_version_id NUMBER := NULL;

Line 1126: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1122: IF (l_debug = 'Y') THEN
1123: okc_debug.log('100: Entered approve of global article at a global org', 2);
1124: END IF;
1125:
1126: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1127: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1128: x_return_status => x_return_status,
1129: p_article_version_id => p_article_version_id,
1130: p_article_id => NULL,

Line 1255: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1251: IF (l_debug = 'Y') THEN
1252: okc_debug.log('100: Entered approve of local article at a local org', 2);
1253: END IF;
1254:
1255: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1256: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1257: x_return_status => x_return_status,
1258: p_article_version_id => p_article_version_id,
1259: p_article_id => NULL,

Line 1404: FROM okc_articles_all art, okc_article_versions ver

1400: l_delete_adoption VARCHAR2(1) := 'T';
1401: l_rowid ROWID;
1402: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1403: SELECT global_yn, org_id, art.article_id, start_date
1404: FROM okc_articles_all art, okc_article_versions ver
1405: WHERE ver.article_id = art.article_id
1406: AND ver.article_version_id = cp_article_version_id;
1407: l_article_version_rec l_article_version_csr%ROWTYPE;
1408: l_earlier_version_id NUMBER := NULL;

Line 1440: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1436: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
1437: IF (l_debug = 'Y') THEN
1438: okc_debug.log('100: Entered reject of global article at a global org', 2);
1439: END IF;
1440: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1441: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1442: x_return_status => x_return_status,
1443: p_article_version_id => p_article_version_id,
1444: p_article_id => NULL,

Line 1531: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV

1527: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1528: WHERE source_article_id = l_article_version_rec.article_id
1529: AND org_id = p_current_org_id
1530: AND NOT EXISTS
1531: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV
1532: WHERE ARTICLE_ID = l_article_version_rec.article_id
1533: AND ARTICLE_VERSION_ID <> p_article_version_id
1534: AND ADP.ADOPTION_TYPE = 'ADOPTED'
1535: AND global_article_version_id = article_version_id

Line 1542: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV

1538: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1539: WHERE target_article_id = l_article_version_rec.article_id
1540: AND org_id = p_current_org_id
1541: AND NOT EXISTS
1542: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV
1543: WHERE ARTICLE_ID = l_article_version_rec.article_id
1544: AND ARTICLE_VERSION_ID <> p_article_version_id
1545: AND ADP.ADOPTION_TYPE = 'ADOPTED'
1546: AND global_article_version_id = article_version_id

Line 1557: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1553: IF (l_debug = 'Y') THEN
1554: okc_debug.log('100: Entered reject of local article at a local org', 2);
1555: END IF;
1556:
1557: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1558: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1559: x_return_status => x_return_status,
1560: p_article_version_id => p_article_version_id,
1561: p_article_id => NULL,