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 294: FROM okc_articles_all art, okc_article_versions ver

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

Line 410: UPDATE OKC_ARTICLE_VERSIONS

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

Line 553: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART

549:
550: -- Below added for Bug 3737158
551: CURSOR l_article_lkup_csr(cp_article_version_id IN NUMBER) is
552: SELECT DEFAULT_SECTION, ARTICLE_TYPE
553: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART
554: WHERE
555: ART.ARTICLE_ID = VER.ARTICLE_ID
556: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
557:

Line 559: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;

555: ART.ARTICLE_ID = VER.ARTICLE_ID
556: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
557:
558:
559: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
560: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
561:
562: -- Above added for Bug 3737158
563:

Line 761: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

757: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
758: IF (l_debug = 'Y') THEN
759: okc_debug.log('100: Entered pending approval for global article at a global org', 2);
760: END IF;
761: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
762: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
763: x_return_status => x_return_status,
764: p_article_version_id => p_article_version_id,
765: p_article_id => NULL,

Line 884: (select 1 from okc_article_versions, okc_article_adoptions adp

880: sysdate
881: from OKC_ARTICLE_RELATNS_ALL ARL1
882: WHERE org_id = G_GLOBAL_ORG_ID
883: AND exists
884: (select 1 from okc_article_versions, okc_article_adoptions adp
885: where article_id = target_article_id
886: and adp.global_article_version_id = article_version_id
887: and adp.local_org_id = p_current_org_id
888: and adp.adoption_type = 'ADOPTED')

Line 890: (select 1 from okc_article_versions

886: and adp.global_article_version_id = article_version_id
887: and adp.local_org_id = p_current_org_id
888: and adp.adoption_type = 'ADOPTED')
889: AND EXISTS
890: (select 1 from okc_article_versions
891: where article_version_id = p_article_version_id
892: and source_article_id = article_id)
893: AND NOT EXISTS
894: (select 1 from okc_article_relatns_all ARL2

Line 926: (select 1 from okc_article_versions, okc_article_adoptions adp

922: sysdate
923: from OKC_ARTICLE_RELATNS_ALL ARL1
924: WHERE org_id = G_GLOBAL_ORG_ID
925: AND exists
926: (select 1 from okc_article_versions, okc_article_adoptions adp
927: where article_id = source_article_id
928: and adp.global_article_version_id = article_version_id
929: and adp.local_org_id = p_current_org_id
930: and adp.adoption_type = 'ADOPTED')

Line 932: (select 1 from okc_article_versions

928: and adp.global_article_version_id = article_version_id
929: and adp.local_org_id = p_current_org_id
930: and adp.adoption_type = 'ADOPTED')
931: AND EXISTS
932: (select 1 from okc_article_versions
933: where article_version_id = p_article_version_id
934: and target_article_id = article_id)
935: AND NOT EXISTS
936: (select 1 from okc_article_relatns_all ARL2

Line 949: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

945: IF (l_debug = 'Y') THEN
946: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);
947: END IF;
948:
949: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
950: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
951: x_return_status => x_return_status,
952: p_article_version_id => p_article_version_id,
953: p_article_id => NULL,

Line 1072: FROM okc_articles_all art, okc_article_versions ver

1068: l_delete_adoption VARCHAR2(1) := 'T';
1069: l_rowid ROWID;
1070: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1071: SELECT global_yn, org_id, art.article_id, start_date
1072: FROM okc_articles_all art, okc_article_versions ver
1073: WHERE ver.article_id = art.article_id
1074: AND ver.article_version_id = cp_article_version_id;
1075: l_article_version_rec l_article_version_csr%ROWTYPE;
1076: l_earlier_version_id NUMBER := NULL;

Line 1108: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1104: IF (l_debug = 'Y') THEN
1105: okc_debug.log('100: Entered approve of global article at a global org', 2);
1106: END IF;
1107:
1108: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1109: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1110: x_return_status => x_return_status,
1111: p_article_version_id => p_article_version_id,
1112: p_article_id => NULL,

Line 1235: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1231: IF (l_debug = 'Y') THEN
1232: okc_debug.log('100: Entered approve of local article at a local org', 2);
1233: END IF;
1234:
1235: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1236: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1237: x_return_status => x_return_status,
1238: p_article_version_id => p_article_version_id,
1239: p_article_id => NULL,

Line 1382: FROM okc_articles_all art, okc_article_versions ver

1378: l_delete_adoption VARCHAR2(1) := 'T';
1379: l_rowid ROWID;
1380: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1381: SELECT global_yn, org_id, art.article_id, start_date
1382: FROM okc_articles_all art, okc_article_versions ver
1383: WHERE ver.article_id = art.article_id
1384: AND ver.article_version_id = cp_article_version_id;
1385: l_article_version_rec l_article_version_csr%ROWTYPE;
1386: l_earlier_version_id NUMBER := NULL;

Line 1418: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1414: IF (p_current_org_id = G_GLOBAL_ORG_ID ) THEN
1415: IF (l_debug = 'Y') THEN
1416: okc_debug.log('100: Entered reject of global article at a global org', 2);
1417: END IF;
1418: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1419: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1420: x_return_status => x_return_status,
1421: p_article_version_id => p_article_version_id,
1422: p_article_id => NULL,

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

1503: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1504: WHERE source_article_id = l_article_version_rec.article_id
1505: AND org_id = p_current_org_id
1506: AND NOT EXISTS
1507: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV
1508: WHERE ARTICLE_ID = l_article_version_rec.article_id
1509: AND ARTICLE_VERSION_ID <> p_article_version_id
1510: AND ADP.ADOPTION_TYPE = 'ADOPTED'
1511: AND global_article_version_id = article_version_id

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

1514: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1515: WHERE target_article_id = l_article_version_rec.article_id
1516: AND org_id = p_current_org_id
1517: AND NOT EXISTS
1518: (SELECT 1 FROM OKC_ARTICLE_ADOPTIONS ADP, OKC_ARTICLE_VERSIONS AV
1519: WHERE ARTICLE_ID = l_article_version_rec.article_id
1520: AND ARTICLE_VERSION_ID <> p_article_version_id
1521: AND ADP.ADOPTION_TYPE = 'ADOPTED'
1522: AND global_article_version_id = article_version_id

Line 1533: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

1529: IF (l_debug = 'Y') THEN
1530: okc_debug.log('100: Entered reject of local article at a local org', 2);
1531: END IF;
1532:
1533: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1534: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1535: x_return_status => x_return_status,
1536: p_article_version_id => p_article_version_id,
1537: p_article_id => NULL,