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.EGO_ODI_PUB dependencies on FND_USER

Line 1066: --reading fnd user name

1062: --IF l_mode = 'LIST' OR l_mode = 'HMDM' THEN
1063:
1064: --raise_application_error(-20000, 'security information unavailable for LIST mode');
1065:
1066: --reading fnd user name
1067: select char_value
1068: into l_user_name
1069: from EGO_PUB_WS_CONFIG
1070: where session_id = p_session_id

Line 1072: and parameter_name = 'FND_USER_NAME';

1068: into l_user_name
1069: from EGO_PUB_WS_CONFIG
1070: where session_id = p_session_id
1071: and web_service_name = 'GET_ITEM_STRUCTURE'
1072: and parameter_name = 'FND_USER_NAME';
1073:
1074: --retrieving user id from user name
1075: select user_id
1076: into l_user_id

Line 1077: from fnd_user

1073:
1074: --retrieving user id from user name
1075: select user_id
1076: into l_user_id
1077: from fnd_user
1078: where user_name = l_user_name;
1079:
1080: --reading responsibility name
1081: select char_value

Line 2227: l_fnd_user_name VARCHAR2(100);

2223: IS
2224:
2225: l_mode VARCHAR2(10) :='BATCH';
2226: l_exists NUMBER;
2227: l_fnd_user_name VARCHAR2(100);
2228: l_responsibility_name VARCHAR2(100);
2229: l_responsibility_appl_name VARCHAR2(100);
2230: l_security_group_name VARCHAR2(100);
2231: l_retpayload VARCHAR2(10) :='Y';

Line 2438: --RETRIEVING FND_USER_NAME, RESPONSIBILITY_NAME, RESPONSIBILITY_APPL_NAME, and

2434: END LOOP;
2435:
2436:
2437:
2438: --RETRIEVING FND_USER_NAME, RESPONSIBILITY_NAME, RESPONSIBILITY_APPL_NAME, and
2439: --SECURITY_GROUP_NAME depending on input mode
2440:
2441: --if mode is LIST or H-MDM, get authentication information from
2442: --user calling the web service. This info is stored in table

Line 2446: --retrieving and storing FND_USER_NAME

2442: --user calling the web service. This info is stored in table
2443: --EGO_PUB_WS_PARAMS and can be recovered with the session_id
2444: IF l_mode <> 'BATCH' THEN
2445:
2446: --retrieving and storing FND_USER_NAME
2447: select fnd_user_name
2448: into l_fnd_user_name
2449: from EGO_PUB_WS_PARAMS
2450: where session_id = p_session_id;

Line 2447: select fnd_user_name

2443: --EGO_PUB_WS_PARAMS and can be recovered with the session_id
2444: IF l_mode <> 'BATCH' THEN
2445:
2446: --retrieving and storing FND_USER_NAME
2447: select fnd_user_name
2448: into l_fnd_user_name
2449: from EGO_PUB_WS_PARAMS
2450: where session_id = p_session_id;
2451:

Line 2448: into l_fnd_user_name

2444: IF l_mode <> 'BATCH' THEN
2445:
2446: --retrieving and storing FND_USER_NAME
2447: select fnd_user_name
2448: into l_fnd_user_name
2449: from EGO_PUB_WS_PARAMS
2450: where session_id = p_session_id;
2451:
2452: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

Line 2462: 'FND_USER_NAME',

2458: created_by,
2459: web_service_name)
2460: VALUES (p_session_id,
2461: p_odi_session_id,
2462: 'FND_USER_NAME',
2463: 2,
2464: l_fnd_user_name,
2465: sysdate,
2466: 0,

Line 2464: l_fnd_user_name,

2460: VALUES (p_session_id,
2461: p_odi_session_id,
2462: 'FND_USER_NAME',
2463: 2,
2464: l_fnd_user_name,
2465: sysdate,
2466: 0,
2467: 'GET_ITEM_STRUCTURE');
2468:

Line 2560: into l_fnd_user_name

2556: where batch_id = l_batch_id;
2557:
2558: --retrieving user name
2559: select USER_NAME
2560: into l_fnd_user_name
2561: from fnd_user
2562: where user_id = l_user_id;
2563:
2564: --inserting user name

Line 2561: from fnd_user

2557:
2558: --retrieving user name
2559: select USER_NAME
2560: into l_fnd_user_name
2561: from fnd_user
2562: where user_id = l_user_id;
2563:
2564: --inserting user name
2565: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

Line 2575: 'FND_USER_NAME',

2571: created_by,
2572: web_service_name)
2573: VALUES (p_session_id,
2574: p_odi_session_id,
2575: 'FND_USER_NAME',
2576: 2,
2577: l_fnd_user_name,
2578: sysdate,
2579: 0,

Line 2577: l_fnd_user_name,

2573: VALUES (p_session_id,
2574: p_odi_session_id,
2575: 'FND_USER_NAME',
2576: 2,
2577: l_fnd_user_name,
2578: sysdate,
2579: 0,
2580: 'GET_ITEM_STRUCTURE');
2581:

Line 4421: l_fnd_user_name VARCHAR2(100);

4417: l_batch_id NUMBER;
4418: l_batch_size NUMBER :=0;
4419:
4420: --for security
4421: l_fnd_user_name VARCHAR2(100);
4422: l_responsibility_name VARCHAR2(100);
4423: l_responsibility_appl_name VARCHAR2(100);
4424: l_security_group_name VARCHAR2(100);
4425:

Line 4664: --retrieving and storing FND_USER_NAME

4660: 'GET_ITEM_STRUCTURE');
4661:
4662: END LOOP;
4663:
4664: --retrieving and storing FND_USER_NAME
4665: select fnd_user_name
4666: into l_fnd_user_name
4667: from EGO_PUB_WS_PARAMS
4668: where session_id = p_session_id;

Line 4665: select fnd_user_name

4661:
4662: END LOOP;
4663:
4664: --retrieving and storing FND_USER_NAME
4665: select fnd_user_name
4666: into l_fnd_user_name
4667: from EGO_PUB_WS_PARAMS
4668: where session_id = p_session_id;
4669:

Line 4666: into l_fnd_user_name

4662: END LOOP;
4663:
4664: --retrieving and storing FND_USER_NAME
4665: select fnd_user_name
4666: into l_fnd_user_name
4667: from EGO_PUB_WS_PARAMS
4668: where session_id = p_session_id;
4669:
4670: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

Line 4680: 'FND_USER_NAME',

4676: created_by,
4677: web_service_name)
4678: VALUES (p_session_id,
4679: -1,
4680: 'FND_USER_NAME',
4681: 2,
4682: l_fnd_user_name,
4683: sysdate,
4684: 0,

Line 4682: l_fnd_user_name,

4678: VALUES (p_session_id,
4679: -1,
4680: 'FND_USER_NAME',
4681: 2,
4682: l_fnd_user_name,
4683: sysdate,
4684: 0,
4685: 'GET_ITEM_STRUCTURE');
4686:

Line 6900: SELECT fnd_user_name,responsibility_appl_name,responsibility_name

6896:
6897: /*Cursor to get I/P value for user_name, resp_name and appl_name */
6898: CURSOR Cur_ws_input (cp_session_id NUMBER )
6899: IS
6900: SELECT fnd_user_name,responsibility_appl_name,responsibility_name
6901: FROM ego_pub_ws_params
6902: WHERE session_id=cp_session_id;
6903:
6904:

Line 6911: FROM fnd_user_resp_groups_direct furgd, fnd_responsibility fr

6907: CURSOR Cur_priv(cp_user_id NUMBER,
6908: cp_resp_id NUMBER)
6909: IS
6910: SELECT Count(furgd.responsibility_id) val
6911: FROM fnd_user_resp_groups_direct furgd, fnd_responsibility fr
6912: WHERE furgd.responsibility_id=fr.responsibility_id
6913: AND fr.menu_id IN
6914: (SELECT menu_id
6915: FROM fnd_menu_entries

Line 6979: FROM FND_USER

6975:
6976: /*Get username for passed in user id*/
6977: BEGIN
6978: SELECT USER_NAME INTO l_user_name
6979: FROM FND_USER
6980: WHERE USER_ID =l_user_id;
6981: EXCEPTION
6982: WHEN No_Data_Found THEN
6983: --Dbms_Output.put_line( ' The User name is not a valid user name.');

Line 7006: l_user_name:=i.fnd_user_name;

7002:
7003:
7004: FOR i IN Cur_ws_input(p_session_id)
7005: LOOP
7006: l_user_name:=i.fnd_user_name;
7007: l_appl_name:=i.responsibility_appl_name;
7008: l_resp_key:=i.responsibility_name;
7009: END LOOP;
7010:

Line 7014: FROM FND_USER

7010:
7011: /*Get userId for passed in user name*/
7012: BEGIN
7013: SELECT USER_ID INTO l_user_id
7014: FROM FND_USER
7015: WHERE USER_NAME =l_user_name;
7016: EXCEPTION
7017: WHEN No_Data_Found THEN
7018: --Dbms_Output.put_line( ' The User name is not a valid user name.');