DBA Data[Home] [Help]

APPS.EGO_PUB_WS_UTIL dependencies on FND_USER

Line 427: l_fnd_user_name VARCHAR2(100);

423: p_web_service_name IN VARCHAR2)
424: IS
425:
426: l_mode VARCHAR2(10) := p_mode;
427: l_fnd_user_name VARCHAR2(100);
428: l_web_service_name VARCHAR2(100) := p_web_service_name;
429: l_responsibility_name VARCHAR2(200);
430: l_responsibility_appl_name VARCHAR2(200);
431: l_security_group_name VARCHAR2(200);

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

440: INTO l_mode
441: FROM EGO_PUB_WS_CONFIG
442: WHERE session_id = p_session_id;*/
443:
444: --RETRIEVING FND_USER_NAME, RESPONSIBILITY_NAME, RESPONSIBILITY_APPL_NAME, and
445: --SECURITY_GROUP_NAME depending on input mode
446:
447: --if mode is LIST or H-MDM, get authentication information from
448: --user calling the web service. This info is stored in table

Line 452: --retrieving and storing FND_USER_NAME

448: --user calling the web service. This info is stored in table
449: --EGO_PUB_WS_PARAMS and can be recovered with the session_id
450: IF Nvl(l_mode,'LIST') <> 'BATCH' THEN
451:
452: --retrieving and storing FND_USER_NAME
453: SELECT fnd_user_name
454: INTO l_fnd_user_name
455: FROM EGO_PUB_WS_PARAMS
456: WHERE session_id = p_session_id;

Line 453: SELECT fnd_user_name

449: --EGO_PUB_WS_PARAMS and can be recovered with the session_id
450: IF Nvl(l_mode,'LIST') <> 'BATCH' THEN
451:
452: --retrieving and storing FND_USER_NAME
453: SELECT fnd_user_name
454: INTO l_fnd_user_name
455: FROM EGO_PUB_WS_PARAMS
456: WHERE session_id = p_session_id;
457:

Line 454: INTO l_fnd_user_name

450: IF Nvl(l_mode,'LIST') <> 'BATCH' THEN
451:
452: --retrieving and storing FND_USER_NAME
453: SELECT fnd_user_name
454: INTO l_fnd_user_name
455: FROM EGO_PUB_WS_PARAMS
456: WHERE session_id = p_session_id;
457:
458: /*INSERT INTO tr_temp (Session_id, message)

Line 459: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/

455: FROM EGO_PUB_WS_PARAMS
456: WHERE session_id = p_session_id;
457:
458: /*INSERT INTO tr_temp (Session_id, message)
459: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/
460: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
461: odi_session_id,
462: Parameter_Name,
463: Data_Type,

Line 470: 'FND_USER_NAME',

466: created_by,
467: web_service_name)
468: VALUES( p_session_id,
469: p_session_id,
470: 'FND_USER_NAME',
471: 2,
472: l_fnd_user_name,
473: sysdate,
474: 0,

Line 472: l_fnd_user_name,

468: VALUES( p_session_id,
469: p_session_id,
470: 'FND_USER_NAME',
471: 2,
472: l_fnd_user_name,
473: sysdate,
474: 0,
475: l_web_service_name);
476:

Line 570: INTO l_fnd_user_name

566: WHERE batch_id = l_batch_id;
567:
568: --retrieving user name
569: SELECT USER_NAME
570: INTO l_fnd_user_name
571: FROM fnd_user
572: WHERE user_id = l_user_id;
573:
574: /*INSERT INTO tr_temp (Session_id, message)

Line 571: FROM fnd_user

567:
568: --retrieving user name
569: SELECT USER_NAME
570: INTO l_fnd_user_name
571: FROM fnd_user
572: WHERE user_id = l_user_id;
573:
574: /*INSERT INTO tr_temp (Session_id, message)
575: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/

Line 575: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/

571: FROM fnd_user
572: WHERE user_id = l_user_id;
573:
574: /*INSERT INTO tr_temp (Session_id, message)
575: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/
576:
577: --inserting user name
578: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
579: odi_session_id,

Line 588: 'FND_USER_NAME',

584: created_by,
585: web_service_name)
586: VALUES (p_session_id,
587: p_session_id,
588: 'FND_USER_NAME',
589: 2,
590: l_fnd_user_name,
591: sysdate,
592: 0,

Line 590: l_fnd_user_name,

586: VALUES (p_session_id,
587: p_session_id,
588: 'FND_USER_NAME',
589: 2,
590: l_fnd_user_name,
591: sysdate,
592: 0,
593: l_web_service_name);
594:

Line 854: --reading fnd user name

850:
851:
852: BEGIN
853:
854: --reading fnd user name
855: SELECT CHAR_VALUE
856: INTO l_user_name
857: FROM EGO_PUB_WS_CONFIG
858: WHERE SESSION_ID = p_session_id

Line 860: AND parameter_name = 'FND_USER_NAME';

856: INTO l_user_name
857: FROM EGO_PUB_WS_CONFIG
858: WHERE SESSION_ID = p_session_id
859: AND WEB_SERVICE_NAME = l_web_service_name
860: AND parameter_name = 'FND_USER_NAME';
861:
862: --retrieving user id from user name
863: SELECT USER_ID
864: INTO l_user_id

Line 865: FROM FND_USER

861:
862: --retrieving user id from user name
863: SELECT USER_ID
864: INTO l_user_id
865: FROM FND_USER
866: WHERE USER_NAME = l_user_name;
867:
868: --reading responsibility name
869: SELECT CHAR_VALUE