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 FND_GLOBAL

Line 84: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
86: LAST_UPDATE_DATE = SYSDATE
87: WHERE CURRENT OF l_article_adoption_csr;
88: END IF;

Line 85: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
86: LAST_UPDATE_DATE = SYSDATE
87: WHERE CURRENT OF l_article_adoption_csr;
88: END IF;
89: CLOSE l_article_adoption_csr;

Line 370: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
372: LAST_UPDATE_DATE = SYSDATE
373: where global_article_version_id = p_article_version_id
374: and adoption_type = 'ADOPTED';

Line 371: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
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

Line 379: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
381: LAST_UPDATE_DATE = SYSDATE
382: where global_article_version_id = p_article_version_id
383: and adoption_type = 'AVAILABLE';

Line 380: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
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

Line 388: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
390: LAST_UPDATE_DATE = SYSDATE
391: where global_article_version_id = p_article_version_id
392: and adoption_type = 'AVAILABLE';

Line 389: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
390: LAST_UPDATE_DATE = SYSDATE
391: where global_article_version_id = p_article_version_id
392: and adoption_type = 'AVAILABLE';
393: end if;

Line 415: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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,
417: LAST_UPDATE_DATE = SYSDATE
418: WHERE current of l_article_version_csr;
419: end if;

Line 416: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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,
417: LAST_UPDATE_DATE = SYSDATE
418: WHERE current of l_article_version_csr;
419: end if;
420:

Line 576: l_user_id NUMBER := FND_GLOBAL.USER_ID;

572: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
573:
574: -- Above added for Bug 3737158
575:
576: l_user_id NUMBER := FND_GLOBAL.USER_ID;
577: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
578:
579: -- Below added for Bug 5958643
580: -- Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME

Line 577: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

573:
574: -- Above added for Bug 3737158
575:
576: l_user_id NUMBER := FND_GLOBAL.USER_ID;
577: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
578:
579: -- Below added for Bug 5958643
580: -- Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
581: