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

Line 133: from fnd_user

129:
130: BEGIN
131: SELECT user_id
132: into l_user_id
133: from fnd_user
134: where user_name = upper(c_user_name);
135:
136: BEGIN
137: SELECT 'LDAP'

Line 139: FROM fnd_user

135:
136: BEGIN
137: SELECT 'LDAP'
138: INTO l_auth_mode
139: FROM fnd_user
140: WHERE l_user_id = icx_sec.g_user_id
141: AND upper(encrypted_user_password)='EXTERNAL';
142:
143: EXCEPTION

Line 177: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.user.password.reset_requested',

173: WF_EVENT.AddParameterToList('X_USER_NAME', upper(p_name), e_parameters);
174: -- WF_EVENT.AddParameterToList('X_UNENCRYPTED_PASSWORD', p_password,e_parameters);
175: -- WF_EVENT.AddParameterToList('X_PASSWORD_LIFESPAN_DAYS', p_expire_days,e_parameters);
176:
177: WF_EVENT.Raise(p_event_name=>'oracle.apps.fnd.user.password.reset_requested',
178: p_event_key=>seq, p_parameters=>e_parameters);
179:
180: -- DBMS_RANDOM.terminate;
181:

Line 234: -- Description: Calls FND_USER_PKG.UpdateUser

230: */
231:
232: -------------------------------------------------------------------
233: -- Name: UpdatePassword_WF
234: -- Description: Calls FND_USER_PKG.UpdateUser
235: -------------------------------------------------------------------
236:
237:
238: Procedure UpdatePassword_WF(itemtype in varchar2,

Line 251: FND_USER_PKG.UpdateUser(

247: if (funcmode = 'RUN') then
248:
249: l_user_name := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
250: 'X_USER_NAME');
251: FND_USER_PKG.UpdateUser(
252: x_user_name=> l_user_name,
253: x_owner=>'CUST',
254: x_unencrypted_password=>
255: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,

Line 259: x_password_date=> fnd_user_pkg.null_date,

255: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
256: 'X_UNENCRYPTED_PASSWORD',
257: TRUE),
258: -- setting password date to null for force passwd change for user
259: x_password_date=> fnd_user_pkg.null_date,
260: /*
261: x_password_date=>
262: WF_ENGINE.GetActivityAttrDate(itemtype, itemkey, actid,
263: 'X_PASSWORD_DATE', TRUE),

Line 284: update fnd_user set

280: -- password upon first logon. refer to bug 2679640
281:
282: -- removing direct update as bug 2679640 has been fixed
283: /*
284: update fnd_user set
285: password_date = null
286: where user_name = l_user_name;
287: */
288:

Line 310: -- is set to FND-username

306: -- Name: CreateRole
307: -- Description: Creates an adhoc role with notification preference always set
308: -- to 'MAIL'. This would ensure that the user would get an email
309: -- for all password related notifications. The name of the role
310: -- is set to FND-username
311: -------------------------------------------------------------------
312: Procedure CreateRole(itemtype in varchar2,
313: itemkey in varchar2,
314: actid in number,

Line 328: from fnd_user

324: l_user_role varchar2(400);
325:
326: cursor c_fnd_email is
327: select email_address
328: from fnd_user
329: where user_name = l_user_name;
330:
331: cursor c_party_email is
332: select hzp.email_address

Line 333: from hz_parties hzp, fnd_user fu

329: where user_name = l_user_name;
330:
331: cursor c_party_email is
332: select hzp.email_address
333: from hz_parties hzp, fnd_user fu
334: where hzp.party_id = fu.customer_id
335: and fu.user_name = l_user_name;
336:
337: begin

Line 381: -- set the role in fnd_user workflow to the new role

377:
378:
379:
380:
381: -- set the role in fnd_user workflow to the new role
382:
383: wf_engine.SetItemAttrText
384: (itemtype => itemtype,
385: itemkey => itemkey,

Line 477: from hz_parties hzp, fnd_user fu

473: and wfa.text_value = p_name;
474:
475: cursor c_party_email is
476: select hzp.email_address
477: from hz_parties hzp, fnd_user fu
478: where hzp.party_id = fu.customer_id
479: and fu.user_name = p_name;
480:
481: begin

Line 505: from fnd_user

501: SELECT user_id,
502: decode(upper(encrypted_user_password),'EXTERNAL','EXTERNAL','FND'),
503: email_address
504: into l_user_id, l_auth_mode, l_fnd_email_address
505: from fnd_user
506: where user_name = p_name
507: and start_date <= sysdate
508: and nvl(end_date, sysdate + 1) > sysdate;
509:

Line 526: -- get the email from fnd_user in case hr email is null

522: email_address, notification_preference, language, territory);
523:
524:
525: if email_address is null then
526: -- get the email from fnd_user in case hr email is null
527: email_address := l_fnd_email_address;
528:
529: if email_address is null then
530: -- if email is still null then get it from tca

Line 644: from hz_parties hzp, fnd_user fu

640: and wfa.text_value = p_name;
641:
642: cursor c_party_email is
643: select hzp.email_address
644: from hz_parties hzp, fnd_user fu
645: where hzp.party_id = fu.customer_id
646: and fu.user_name = p_name;
647:
648: begin

Line 665: from fnd_user

661: SELECT user_id,
662: decode(upper(encrypted_user_password),'EXTERNAL','EXTERNAL','FND'),
663: email_address
664: into l_user_id, l_auth_mode, l_fnd_email_address
665: from fnd_user
666: where user_name = p_name
667: and start_date <= sysdate
668: and nvl(end_date, sysdate + 1) > sysdate;
669:

Line 675: -- get the email from fnd_user in case hr email is null

671: WF_DIRECTORY.GetRoleInfo(p_name, display_name,
672: email_address, notification_preference, language, territory);
673:
674: if email_address is null then
675: -- get the email from fnd_user in case hr email is null
676: email_address := l_fnd_email_address;
677:
678: if email_address is null then
679: -- if email is still null then get it from tca