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);
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
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;
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:
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)
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,
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,
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:
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)
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);*/
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,
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,
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:
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
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
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