APPS.EGO_ITEM_WS_PVT dependencies on FND_USER

Line 4939: l_fnd_user_name VARCHAR2(100);

4935: l_responsibility_id NUMBER;
4936: l_user_id NUMBER;
4937: l_security_group_id NUMBER;
4938: l_batch_id NUMBER;
4939: l_fnd_user_name VARCHAR2(100);
4940: l_responsibility_name VARCHAR2(100);
4941: l_responsibility_appl_name VARCHAR2(100);
4942: l_security_group_name VARCHAR2(100);
4943:

Line 4988: select fnd_user_name, responsibility_name, responsibility_appl_name, security_group_name

4984: -- Bug 8776414: End
4985:
4986: ELSIF l_mode = 'LIST' OR l_mode = 'HMDM' THEN
4987:
4988: select fnd_user_name, responsibility_name, responsibility_appl_name, security_group_name
4989: into l_fnd_user_name, l_responsibility_name, l_responsibility_appl_name, l_security_group_name
4990: from EGO_PUB_WS_PARAMS
4991: where session_id = p_session_id;
4992:

Line 4989: into l_fnd_user_name, l_responsibility_name, l_responsibility_appl_name, l_security_group_name

4985:
4986: ELSIF l_mode = 'LIST' OR l_mode = 'HMDM' THEN
4987:
4988: select fnd_user_name, responsibility_name, responsibility_appl_name, security_group_name
4989: into l_fnd_user_name, l_responsibility_name, l_responsibility_appl_name, l_security_group_name
4990: from EGO_PUB_WS_PARAMS
4991: where session_id = p_session_id;
4992:
4993: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

Line 5002: 'FND_USER_NAME',

4998: creation_date,
4999: created_by)
5000: VALUES (p_session_id,
5001: p_odi_session_id,
5002: 'FND_USER_NAME',
5003: 2,
5004: l_fnd_user_name,
5005: sysdate,
5006: 0);

Line 5004: l_fnd_user_name,

5000: VALUES (p_session_id,
5001: p_odi_session_id,
5002: 'FND_USER_NAME',
5003: 2,
5004: l_fnd_user_name,
5005: sysdate,
5006: 0);
5007:
5008: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

Line 5058: from fnd_user

5054:
5055: --retrieving user id from user name
5056: select user_id
5057: into l_user_id
5058: from fnd_user
5059: where user_name = l_fnd_user_name;
5060:
5061: --retrieving responsibility id from responsability name
5062: Select responsibility_id

Line 5059: where user_name = l_fnd_user_name;

5055: --retrieving user id from user name
5056: select user_id
5057: into l_user_id
5058: from fnd_user
5059: where user_name = l_fnd_user_name;
5060:
5061: --retrieving responsibility id from responsability name
5062: Select responsibility_id
5063: into l_responsibility_id