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_ADOPTIONS

Line 63: SELECT rowid from OKC_ARTICLE_ADOPTIONS

59: x_return_status OUT NOCOPY VARCHAR2) IS
60:
61: CURSOR l_article_adoption_csr(cp_article_version_id IN NUMBER,
62: cp_local_org_id IN NUMBER) is
63: SELECT rowid from OKC_ARTICLE_ADOPTIONS
64: WHERE LOCAL_ARTICLE_VERSION_ID = cp_article_version_id
65: AND LOCAL_ORG_ID = cp_local_org_id
66: AND ADOPTION_TYPE = 'LOCALIZED'
67: FOR UPDATE OF object_version_number ;

Line 81: UPDATE OKC_ARTICLE_ADOPTIONS

77: OPEN l_article_adoption_csr(p_article_version_id,
78: p_org_id) ;
79: FETCH l_article_adoption_csr INTO l_rowid;
80: IF l_article_adoption_csr%FOUND THEN
81: UPDATE OKC_ARTICLE_ADOPTIONS
82: SET ADOPTION_STATUS = p_article_status,
83: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
84: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
85: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 367: update okc_article_adoptions

363: okc_debug.log('120: Starting Update Adoption Statuses if Global Article ', 2);
364: END IF;
365: begin
366: if l_article_version_rec.global_yn = 'Y' then
367: update okc_article_adoptions
368: set adoption_status = l_new_article_status,
369: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
370: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
371: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 376: update okc_article_adoptions

372: LAST_UPDATE_DATE = SYSDATE
373: where global_article_version_id = p_article_version_id
374: and adoption_type = 'ADOPTED';
375: if l_new_article_status = 'ON_HOLD' then
376: update okc_article_adoptions
377: set adoption_status = l_new_article_status,
378: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
379: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
380: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 385: update okc_article_adoptions

381: LAST_UPDATE_DATE = SYSDATE
382: where global_article_version_id = p_article_version_id
383: and adoption_type = 'AVAILABLE';
384: elsif l_new_article_status = 'APPROVED' then
385: update okc_article_adoptions
386: set adoption_status = null,
387: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
388: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
389: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 858: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

854: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
855: RAISE FND_API.G_EXC_ERROR ;
856: END IF;
857:
858: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
859: x_return_status => x_return_status,
860: p_global_article_version_id => p_article_version_id,
861: p_adoption_type => 'ADOPTED',
862: p_local_org_id => p_current_org_id,

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 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 1236: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

1232: IF (l_debug = 'Y') THEN
1233: okc_debug.log('100: Entered approve of global article adopted as is at a local org', 2);
1234: END IF;
1235:
1236: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1237: x_return_status => x_return_status,
1238: p_global_article_version_id => p_article_version_id,
1239: p_adoption_type => 'ADOPTED',
1240: p_local_org_id => p_current_org_id ,

Line 1510: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

1506: IF (l_debug = 'Y') THEN
1507: okc_debug.log('100: Entered reject of global article adopted as is at a local org', 2);
1508: END IF;
1509:
1510: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1511: x_return_status => x_return_status,
1512: p_global_article_version_id => p_article_version_id,
1513: p_adoption_type => 'AVAILABLE',
1514: p_local_org_id => p_current_org_id ,

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