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_ARTICLES_GRP dependencies on FND_GLOBAL

Line 2354: l_user_id NUMBER := FND_GLOBAL.USER_ID;

2350: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2351: i NUMBER := 0;
2352: l_clob CLOB;
2353: -- Bug 3917777
2354: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2355: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2356: BEGIN
2357:
2358: IF (l_debug = 'Y') THEN

Line 2355: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

2351: i NUMBER := 0;
2352: l_clob CLOB;
2353: -- Bug 3917777
2354: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2355: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2356: BEGIN
2357:
2358: IF (l_debug = 'Y') THEN
2359: okc_debug.log('600: Entered create_article_version', 2);

Line 2759: l_user_id NUMBER := FND_GLOBAL.USER_ID;

2755: k number := 0;
2756: l_existing_variables_tbl variable_code_tbl_type;
2757: l_variable_found VARCHAR2(1) := 'F';
2758: -- Bug 3917777
2759: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2760: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2761:
2762: CURSOR existing_art_variable_csr (cp_article_version_id IN NUMBER) IS
2763: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES

Line 2760: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

2756: l_existing_variables_tbl variable_code_tbl_type;
2757: l_variable_found VARCHAR2(1) := 'F';
2758: -- Bug 3917777
2759: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2760: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2761:
2762: CURSOR existing_art_variable_csr (cp_article_version_id IN NUMBER) IS
2763: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES
2764: WHERE ARTICLE_VERSION_ID = cp_article_version_id;

Line 3309: l_user_id NUMBER := FND_GLOBAL.USER_ID;

3305: FROM OKC_ARTICLE_RELATNS_ALL
3306: WHERE source_article_id = cp_article_id
3307: AND org_id = cp_org_id;
3308:
3309: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3310: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3311: BEGIN
3312: IF (l_debug = 'Y') THEN
3313: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);

Line 3310: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3306: WHERE source_article_id = cp_article_id
3307: AND org_id = cp_org_id;
3308:
3309: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3310: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3311: BEGIN
3312: IF (l_debug = 'Y') THEN
3313: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);
3314: END IF;

Line 4099: l_user_id NUMBER := FND_GLOBAL.USER_ID;

4095: AND V1.ARTICLE_STATUS = 'APPROVED'
4096: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE
4097: );
4098:
4099: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4100: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4101: l_src_local_article_id NUMBER;
4102: l_tar_local_article_id NUMBER;
4103: l_rownotfound BOOLEAN := FALSE;

Line 4100: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

4096: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE
4097: );
4098:
4099: l_user_id NUMBER := FND_GLOBAL.USER_ID;
4100: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
4101: l_src_local_article_id NUMBER;
4102: l_tar_local_article_id NUMBER;
4103: l_rownotfound BOOLEAN := FALSE;
4104: