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.

[Home] [Help]

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 365: update okc_article_adoptions

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

Line 374: update okc_article_adoptions

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

Line 383: update okc_article_adoptions

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

Line 842: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
839: RAISE FND_API.G_EXC_ERROR ;
840: END IF;
841:
842: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
843: x_return_status => x_return_status,
844: p_global_article_version_id => p_article_version_id,
845: p_adoption_type => 'ADOPTED',
846: p_local_org_id => p_current_org_id,

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

1212: IF (l_debug = 'Y') THEN
1213: okc_debug.log('100: Entered approve of global article adopted as is at a local org', 2);
1214: END IF;
1215:
1216: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1217: x_return_status => x_return_status,
1218: p_global_article_version_id => p_article_version_id,
1219: p_adoption_type => 'ADOPTED',
1220: p_local_org_id => p_current_org_id ,

Line 1486: OKC_ARTICLE_ADOPTIONS_PVT.update_row(

1482: IF (l_debug = 'Y') THEN
1483: okc_debug.log('100: Entered reject of global article adopted as is at a local org', 2);
1484: END IF;
1485:
1486: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
1487: x_return_status => x_return_status,
1488: p_global_article_version_id => p_article_version_id,
1489: p_adoption_type => 'AVAILABLE',
1490: p_local_org_id => p_current_org_id ,

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