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 368: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 369: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 377: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 378: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 386: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 387: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 413: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

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

Line 414: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

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

Line 564: l_user_id NUMBER := FND_GLOBAL.USER_ID;

560: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
561:
562: -- Above added for Bug 3737158
563:
564: l_user_id NUMBER := FND_GLOBAL.USER_ID;
565: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
566:
567: -- Below added for Bug 5958643
568: -- Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME

Line 565: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

561:
562: -- Above added for Bug 3737158
563:
564: l_user_id NUMBER := FND_GLOBAL.USER_ID;
565: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
566:
567: -- Below added for Bug 5958643
568: -- Expected procedure name is SCHEMA.PACKAGENAME.PROCEDURENAME
569: