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

Line 7: -- 2) FND User

3:
4: g_itemtype wf_item_types.name%type := 'UMXUPWD';
5: -- Private function to get the email address of the active user from
6: -- 1) WF local roles
7: -- 2) FND User
8: -- 3) The first TCA party
9: procedure get_email_address (p_user_name in fnd_user.user_name%type,
10: x_role_name out nocopy varchar2,
11: x_email_address out nocopy varchar2,

Line 9: procedure get_email_address (p_user_name in fnd_user.user_name%type,

5: -- Private function to get the email address of the active user from
6: -- 1) WF local roles
7: -- 2) FND User
8: -- 3) The first TCA party
9: procedure get_email_address (p_user_name in fnd_user.user_name%type,
10: x_role_name out nocopy varchar2,
11: x_email_address out nocopy varchar2,
12: x_notification_preference out nocopy varchar2,
13: x_message_name out nocopy varchar2,

Line 22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is

18: l_role_display_name wf_local_roles.display_name%type;
19: l_language wf_local_roles.language%type;
20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
23: SELECT email_address
24: FROM fnd_user
25: WHERE user_name = p_user_name
26: AND start_date <= sysdate

Line 24: FROM fnd_user

20: l_territory wf_local_roles.territory%type;
21:
22: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
23: SELECT email_address
24: FROM fnd_user
25: WHERE user_name = p_user_name
26: AND start_date <= sysdate
27: AND nvl(end_date, sysdate + 1) > sysdate;
28:

Line 29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is

25: WHERE user_name = p_user_name
26: AND start_date <= sysdate
27: AND nvl(end_date, sysdate + 1) > sysdate;
28:
29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
30: SELECT hzp.email_address
31: FROM hz_parties hzp, fnd_user fu
32: WHERE hzp.party_id = fu.person_party_id
33: AND fu.user_name = p_user_name;

Line 31: FROM hz_parties hzp, fnd_user fu

27: AND nvl(end_date, sysdate + 1) > sysdate;
28:
29: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
30: SELECT hzp.email_address
31: FROM hz_parties hzp, fnd_user fu
32: WHERE hzp.party_id = fu.person_party_id
33: AND fu.user_name = p_user_name;
34:
35: begin

Line 50: -- Try to get the email from fnd_user

46:
47: if x_email_address is not null then
48: x_role_name := p_user_name;
49: else
50: -- Try to get the email from fnd_user
51: open get_fnd_email (p_user_name);
52: fetch get_fnd_email into x_email_address;
53: if (get_fnd_email%NOTFOUND) then
54: x_message_name := 'UMX_FORGOT_PWD_INVALID_ACCT';

Line 81: function get_username_from_userid (p_user_id in fnd_user.user_id%type) return fnd_user.user_name%type is

77: end if;
78:
79: end get_email_address;
80:
81: function get_username_from_userid (p_user_id in fnd_user.user_id%type) return fnd_user.user_name%type is
82:
83: cursor get_username_from_userid is
84: select user_name
85: from fnd_user

Line 85: from fnd_user

81: function get_username_from_userid (p_user_id in fnd_user.user_id%type) return fnd_user.user_name%type is
82:
83: cursor get_username_from_userid is
84: select user_name
85: from fnd_user
86: where user_id = p_user_id;
87:
88: l_user_name fnd_user.user_name%type;
89:

Line 88: l_user_name fnd_user.user_name%type;

84: select user_name
85: from fnd_user
86: where user_id = p_user_id;
87:
88: l_user_name fnd_user.user_name%type;
89:
90: begin
91:
92: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 136: Procedure validate_password (p_username in fnd_user.user_name%type,

132: -- - Returns FND_API.G_RET_STS_ERROR if failed
133: -- x_message_data - Reason why it is failed.
134: -- Errors :
135: -- Other Comments :
136: Procedure validate_password (p_username in fnd_user.user_name%type,
137: p_password in varchar2,
138: x_return_status out NOCOPY varchar2,
139: x_message_data out NOCOPY varchar2) is
140:

Line 233: Procedure SetPassword (p_username in fnd_user.user_name%type,

229: return x_password;
230:
231: end generate_password;
232:
233: Procedure SetPassword (p_username in fnd_user.user_name%type,
234: x_password in out NOCOPY varchar2) is
235:
236: l_result varchar2(10);
237: v_counter BINARY_INTEGER := 1;

Line 292: l_user_name fnd_user.user_name%type;

288: funcmode in varchar2,
289: resultout in out NOCOPY varchar2) is
290:
291: l_password varchar2(40);
292: l_user_name fnd_user.user_name%type;
293:
294: begin
295: if (funcmode = 'RUN') then
296: -- Check if the password is already set.

Line 333: -- Description: Calls FND_USER_PKG.UpdateUserParty

329: end;
330:
331: -------------------------------------------------------------------
332: -- Name: UpdatePassword_WF
333: -- Description: Calls FND_USER_PKG.UpdateUserParty
334: -------------------------------------------------------------------
335: Procedure UpdatePassword_WF(itemtype in varchar2,
336: itemkey in varchar2,
337: actid in number,

Line 345: FND_USER_PKG.UpdateUserParty (

341: begin
342:
343: if (funcmode = 'RUN') then
344:
345: FND_USER_PKG.UpdateUserParty (
346: x_user_name =>
347: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
348: 'USER_NAME', TRUE),
349: x_owner => null,

Line 353: x_password_date => fnd_user_pkg.null_date);

349: x_owner => null,
350: x_unencrypted_password =>
351: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
352: 'PASSWORD', TRUE),
353: x_password_date => fnd_user_pkg.null_date);
354:
355: end if;
356:
357: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

Line 372: FROM fnd_user

368: /* this method returns a formatted name to be used for display name*/
369: function getDisplayName(username in varchar2) return varchar2 is
370: cursor C_party_id is
371: SELECT person_party_id
372: FROM fnd_user
373: where user_name = username;
374:
375: x_return_status varchar2(40);
376: x_msg_count NUMBER;

Line 407: -- is set to FND-username

403: -- Name: CreateRole
404: -- Description: Creates an adhoc role with notification preference always set
405: -- to 'MAIL'. This would ensure that the user would get an email
406: -- for all password related notifications. The name of the role
407: -- is set to FND-username
408: -------------------------------------------------------------------
409: Procedure CreateRole(itemtype in varchar2,
410: itemkey in varchar2,
411: actid in number,

Line 417: l_username fnd_user.user_name%type;

413: resultout in out NOCOPY varchar2) is
414:
415: l_role_name wf_local_roles.name%type;
416: l_notification_preference wf_local_roles.notification_preference%type;
417: l_username fnd_user.user_name%type;
418: l_display_name varchar2(4000);
419: begin
420:
421: if (funcmode = 'RUN') then

Line 546: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,

542: end if;
543: end start_workflow;
544:
545: -- Private Method
546: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,
547: p_password in varchar2 default null,
548: p_user_appr_msg_name in varchar2 default null,
549: p_pwd_reset_msg_name in varchar2 default null,
550: p_check_identity in varchar2 default 'Y',

Line 556: l_user_name fnd_user.user_name%type := upper(p_username);

552: x_return_status out NOCOPY varchar2,
553: x_message_name out NOCOPY varchar2,
554: x_message_data out NOCOPY varchar2) is
555:
556: l_user_name fnd_user.user_name%type := upper(p_username);
557: l_email_address varchar2(2000);
558: l_role_name wf_local_roles.name%type;
559: l_password varchar2(40);
560: l_notification_preference wf_local_roles.notification_preference%type;

Line 624: FND_USER_PKG.UpdateUserParty (

620: -- Reset the password without starting a workflow
621: l_password := p_password;
622: SetPassword (p_username => l_user_name,
623: x_password => l_password);
624: FND_USER_PKG.UpdateUserParty (
625: x_user_name => l_user_name,
626: x_owner => null,
627: x_unencrypted_password => l_password,
628: x_password_date => fnd_user_pkg.null_date);

Line 628: x_password_date => fnd_user_pkg.null_date);

624: FND_USER_PKG.UpdateUserParty (
625: x_user_name => l_user_name,
626: x_owner => null,
627: x_unencrypted_password => l_password,
628: x_password_date => fnd_user_pkg.null_date);
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630: end if;
631: end if;
632: end if;

Line 670: procedure ResetPwd (p_username in fnd_user.user_name%type,

666:
667: END ResetPwdPvt;
668:
669:
670: procedure ResetPwd (p_username in fnd_user.user_name%type,
671: p_password in varchar2 default null,
672: p_user_appr_msg_name in varchar2 default null,
673: p_pwd_reset_msg_name in varchar2 default null,
674: p_check_identity in varchar2 default 'Y',

Line 710: procedure ForgotPwd(p_username in fnd_user.user_name%type,

706: end if;
707:
708: end ResetPwd;
709:
710: procedure ForgotPwd(p_username in fnd_user.user_name%type,
711: p_user_appr_msg_name in varchar2 default null,
712: p_pwd_reset_msg_name in varchar2 default null,
713: p_check_identity in varchar2 default 'Y',
714: x_return_status out NOCOPY varchar2,