APPS.HR_TRANSACTION_SS dependencies on FND_USER

Line 25: userId fnd_user.user_id%type;

21: c_proc constant varchar2(60) := 'setRespondedUserCtx';
22: contextUser wf_users.name%type;
23: contextProxyUser wf_users.name%type;
24:
25: userId fnd_user.user_id%type;
26: c_user_name wf_users.name%type;
27: l_user_role_count number default 0;
28: cursor username is
29: select user_id from fnd_user where user_name=contextUser;

Line 29: select user_id from fnd_user where user_name=contextUser;

25: userId fnd_user.user_id%type;
26: c_user_name wf_users.name%type;
27: l_user_role_count number default 0;
28: cursor username is
29: select user_id from fnd_user where user_name=contextUser;
30: cursor user_role_name is
31: select name from wf_roles where UPPER(EMAIL_ADDRESS) = UPPER(substr (contextUser, 7)) and ORIG_SYSTEM = 'PER' and STATUS = 'ACTIVE';
32: begin
33: if g_debug then

Line 68: Functionally we will call apps intialization only if we have valid FND user

64: 3. mail address of the responder not found on any role in the
65: directory service,then context_user = 'email:'
66:
67:
68: Functionally we will call apps intialization only if we have valid FND user
69: and context user does not match the fnd_global.user_name
70: */
71:
72: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then

Line 78: -- check if the role is a valid FND user

74: -- check if the role is same as fnd_global.user_name
75: if(contextUser<>fnd_global.user_name) then
76: if(nvl(contextProxyUser,contextUser)<>fnd_global.user_name) then
77:
78: -- check if the role is a valid FND user
79: if g_debug then
80: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name',7);
81: end if;
82: open username;

Line 86: hr_utility.set_location('found a valid fnd user corresponding to context user',8);

82: open username;
83: fetch username into userId;
84: if username%found then
85: if g_debug then
86: hr_utility.set_location('found a valid fnd user corresponding to context user',8);
87: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,9);
88: end if;
89: -- call the apps intialization
90: fnd_global.apps_initialize(userId,null,null,null,null);

Line 129: -- check if the role is a valid FND user

125: hr_utility.set_location('c_user_name ' || c_user_name,13);
126: if user_role_name%found then
127:
128: if(c_user_name<>fnd_global.user_name) then
129: -- check if the role is a valid FND user
130: if g_debug then
131: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name for email',13);
132: end if;
133: contextUser := c_user_name;

Line 138: hr_utility.set_location('found a valid fnd user corresponding to context user',14);

134: open username;
135: fetch username into userId;
136: if username%found then
137: if g_debug then
138: hr_utility.set_location('found a valid fnd user corresponding to context user',14);
139: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,15);
140: end if;
141: -- call the apps intialization
142: fnd_global.apps_initialize(userId,null,null,null,null);

Line 299: select employee_id into c_return_person from fnd_user where user_name = c_return_user ;

295: IF ( c_return_user IS NULL OR c_creator_user = c_return_user ) THEN
296: c_rfc_initiator := 'Y';
297: ELSE
298: c_rfc_initiator := 'N';
299: select employee_id into c_return_person from fnd_user where user_name = c_return_user ;
300: END IF;
301: --ns end
302:
303: for i in 1..c_all_approvers.count loop