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_LOGIN_HELP_PVT dependencies on FND_USER

Line 31: FROM fnd_user

27:
28: function GetDisplayName(username in varchar2) return varchar2 is
29: cursor C_party_id is
30: SELECT person_party_id
31: FROM fnd_user
32: where user_name = username;
33:
34: x_return_status varchar2(40);
35: x_msg_count NUMBER;

Line 68: -- is set to FND-username

64: -- Name: CreateRole
65: -- Description: Creates an adhoc role with notification preference always set
66: -- to 'MAIL'. This would ensure that the user would get an email
67: -- for all password related notifications. The name of the role
68: -- is set to FND-username
69: -------------------------------------------------------------------
70: Procedure CreateRole(itemtype in varchar2,
71: itemkey in varchar2,
72: actid in number,

Line 78: l_username fnd_user.user_name%type;

74: resultout in out NOCOPY varchar2) is
75:
76: l_role_name wf_local_roles.name%type;
77: l_notification_preference wf_local_roles.notification_preference%type;
78: l_username fnd_user.user_name%type;
79: l_display_name varchar2(4000);
80: begin
81:
82: if (funcmode = 'RUN') then

Line 121: l_user_name fnd_user.user_name%type := username;

117:
118: Function getCurrNoActiveReqs( username IN varchar2 ) return pls_integer is
119: l_no pls_integer := 0;
120: l_item_key wf_items.item_key%type;
121: l_user_name fnd_user.user_name%type := username;
122: Begin
123: select count(*) into l_no from
124: (
125: SELECT WorkflowItemEO.ITEM_TYPE,

Line 192: -- 2) FND User

188:
189:
190: -- Private function to get the email address of the active user from
191: -- 1) WF local roles
192: -- 2) FND User
193: -- 3) The first TCA party
194: procedure Get_email_address (p_user_name in fnd_user.user_name%type,
195: x_role_name out nocopy varchar2,
196: x_email_address out nocopy varchar2,

Line 194: procedure Get_email_address (p_user_name in fnd_user.user_name%type,

190: -- Private function to get the email address of the active user from
191: -- 1) WF local roles
192: -- 2) FND User
193: -- 3) The first TCA party
194: procedure Get_email_address (p_user_name in fnd_user.user_name%type,
195: x_role_name out nocopy varchar2,
196: x_email_address out nocopy varchar2,
197: x_notification_preference out nocopy varchar2,
198: x_message_name out nocopy varchar2) is

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

202: l_role_display_name wf_local_roles.display_name%type;
203: l_language wf_local_roles.language%type;
204: l_territory wf_local_roles.territory%type;
205:
206: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
207: SELECT email_address
208: FROM fnd_user
209: WHERE user_name = p_user_name
210: AND start_date <= sysdate

Line 208: FROM fnd_user

204: l_territory wf_local_roles.territory%type;
205:
206: cursor get_fnd_email (p_user_name in fnd_user.user_name%type) is
207: SELECT email_address
208: FROM fnd_user
209: WHERE user_name = p_user_name
210: AND start_date <= sysdate
211: AND nvl(end_date, sysdate + 1) > sysdate;
212:

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

209: WHERE user_name = p_user_name
210: AND start_date <= sysdate
211: AND nvl(end_date, sysdate + 1) > sysdate;
212:
213: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
214: SELECT hzp.email_address
215: FROM hz_parties hzp, fnd_user fu
216: WHERE hzp.party_id = fu.person_party_id
217: AND fu.user_name = p_user_name;

Line 215: FROM hz_parties hzp, fnd_user fu

211: AND nvl(end_date, sysdate + 1) > sysdate;
212:
213: cursor get_tca_email (p_user_name in fnd_user.user_name%type) is
214: SELECT hzp.email_address
215: FROM hz_parties hzp, fnd_user fu
216: WHERE hzp.party_id = fu.person_party_id
217: AND fu.user_name = p_user_name;
218:
219: begin

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

230:
231: if x_email_address is not null then
232: x_role_name := p_user_name;
233: else
234: -- Try to get the email from fnd_user
235: open get_fnd_email (p_user_name);
236: fetch get_fnd_email into x_email_address;
237: if (get_fnd_email%NOTFOUND) then
238: x_message_name := 'UMX_LOGIN_HELP_INVALID_ACCT';

Line 265: procedure Find_user_w_email (p_email in fnd_user.email_address%type,

261:
262: end get_email_address;
263:
264:
265: procedure Find_user_w_email (p_email in fnd_user.email_address%type,
266: x_role_name out nocopy varchar2,
267: x_user_name out nocopy varchar2,
268: x_notification_preference out nocopy varchar2,
269: x_message_name out nocopy varchar2) is

Line 276: l_email_address fnd_user.email_address%type;

272: -- three schema.
273: l_role_display_name wf_local_roles.display_name%type;
274: l_language wf_local_roles.language%type;
275: l_territory wf_local_roles.territory%type;
276: l_email_address fnd_user.email_address%type;
277:
278: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
279: SELECT user_name FROM fnd_user
280: WHERE email_address = p_email_address

Line 278: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is

274: l_language wf_local_roles.language%type;
275: l_territory wf_local_roles.territory%type;
276: l_email_address fnd_user.email_address%type;
277:
278: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
279: SELECT user_name FROM fnd_user
280: WHERE email_address = p_email_address
281: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
282:

Line 279: SELECT user_name FROM fnd_user

275: l_territory wf_local_roles.territory%type;
276: l_email_address fnd_user.email_address%type;
277:
278: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
279: SELECT user_name FROM fnd_user
280: WHERE email_address = p_email_address
281: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
282:
283:

Line 284: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is

280: WHERE email_address = p_email_address
281: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
282:
283:
284: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
285: SELECT fu.user_name
286: FROM hz_parties p, fnd_user fu
287: WHERE p.party_id = fu.person_party_id
288: AND p.email_address = p_email_address;

Line 286: FROM hz_parties p, fnd_user fu

282:
283:
284: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
285: SELECT fu.user_name
286: FROM hz_parties p, fnd_user fu
287: WHERE p.party_id = fu.person_party_id
288: AND p.email_address = p_email_address;
289:
290:

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

301: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
302: x_notification_preference, l_language, l_territory);
303: */
304:
305: -- Try to get the email from fnd_user
306: open get_user_fnd (p_email);
307: fetch get_user_fnd into x_user_name;
308: if (get_user_fnd%NOTFOUND) then
309: --x_message_name := 'UMX_FORGOT_PWD_INVALID_ACCT';

Line 339: procedure Find_users_w_email( p_email in fnd_user.email_address%type,

335: end if;
336:
337: end find_user_w_email;
338:
339: procedure Find_users_w_email( p_email in fnd_user.email_address%type,
340: x_users out NOCOPY UsersWEmail ) is
341:
342: -- TCA Party declares email address as varchar2 2000, largest amount the
343: -- three schema.

Line 347: l_email_address fnd_user.email_address%type;

343: -- three schema.
344: l_role_display_name wf_local_roles.display_name%type;
345: l_language wf_local_roles.language%type;
346: l_territory wf_local_roles.territory%type;
347: l_email_address fnd_user.email_address%type;
348: l_user_name fnd_user.user_name%type;
349: l_notification_preference wf_local_roles.notification_preference%type;
350: i pls_integer := 0;
351:

Line 348: l_user_name fnd_user.user_name%type;

344: l_role_display_name wf_local_roles.display_name%type;
345: l_language wf_local_roles.language%type;
346: l_territory wf_local_roles.territory%type;
347: l_email_address fnd_user.email_address%type;
348: l_user_name fnd_user.user_name%type;
349: l_notification_preference wf_local_roles.notification_preference%type;
350: i pls_integer := 0;
351:
352: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is

Line 352: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is

348: l_user_name fnd_user.user_name%type;
349: l_notification_preference wf_local_roles.notification_preference%type;
350: i pls_integer := 0;
351:
352: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
353: SELECT user_name FROM fnd_user
354: WHERE UPPER(email_address) = UPPER(p_email_address)
355: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
356:

Line 353: SELECT user_name FROM fnd_user

349: l_notification_preference wf_local_roles.notification_preference%type;
350: i pls_integer := 0;
351:
352: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
353: SELECT user_name FROM fnd_user
354: WHERE UPPER(email_address) = UPPER(p_email_address)
355: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
356:
357:

Line 358: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is

354: WHERE UPPER(email_address) = UPPER(p_email_address)
355: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
356:
357:
358: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
359: SELECT fu.user_name
360: FROM hz_parties p, fnd_user fu
361: WHERE p.party_id = fu.person_party_id
362: AND UPPER(p.email_address) = UPPER(p_email_address);

Line 360: FROM hz_parties p, fnd_user fu

356:
357:
358: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
359: SELECT fu.user_name
360: FROM hz_parties p, fnd_user fu
361: WHERE p.party_id = fu.person_party_id
362: AND UPPER(p.email_address) = UPPER(p_email_address);
363:
364:

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

369: 'fnd.plsql.UMXVUPWB.find_users_w_email.begin',
370: 'p_email: ' || p_email);
371: end if;
372:
373: -- Try to get the email from fnd_user
374: --open get_user_fnd (p_email);
375: --fetch get_user_fnd into l_user_name;
376: for aUser in get_user_fnd(p_email) loop
377: WF_DIRECTORY.GetRoleInfo ( aUser.user_name, l_role_display_name, l_email_address,

Line 477: (p_username in fnd_user.user_name%type,

473: end start_workflow;
474:
475:
476: procedure ForgottenPwdPvt
477: (p_username in fnd_user.user_name%type,
478: x_return_status out NOCOPY varchar2,
479: x_message_name out NOCOPY varchar2) is
480:
481: l_user_name fnd_user.user_name%type := upper(p_username);

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

477: (p_username in fnd_user.user_name%type,
478: x_return_status out NOCOPY varchar2,
479: x_message_name out NOCOPY varchar2) is
480:
481: l_user_name fnd_user.user_name%type := upper(p_username);
482: l_email_address varchar2(2000);
483: l_role_name wf_local_roles.name%type;
484: l_password varchar2(40);
485: l_notification_preference wf_local_roles.notification_preference%type;

Line 556: procedure ForgottenPwd(p_username in fnd_user.user_name%type,

552:
553: END ForgottenPwdPvt;
554:
555:
556: procedure ForgottenPwd(p_username in fnd_user.user_name%type,
557: x_return_status out NOCOPY varchar2,
558: x_message_name out NOCOPY varchar2) is
559: begin
560:

Line 588: (p_email in fnd_user.email_address%type,

584:
585:
586:
587: procedure ForgottenUnamePvt
588: (p_email in fnd_user.email_address%type,
589: x_return_status out NOCOPY varchar2,
590: x_message_name out NOCOPY varchar2) is
591:
592: l_email_address varchar2(2000) := p_email;

Line 598: l_user_name fnd_user.user_name%type;

594: l_notification_preference wf_local_roles.notification_preference%type;
595: l_result wf_item_activity_statuses.activity_result_code%type;
596: l_status wf_item_activity_statuses.activity_status%type;
597: l_itemkey wf_items.item_key%type;
598: l_user_name fnd_user.user_name%type;
599: l_user_list UsersWEmail;
600: i pls_integer;
601: l_first pls_integer;
602: e pls_integer := 0;

Line 678: (p_email in fnd_user.email_address%type,

674: END ForgottenUnamePvt;
675:
676:
677: procedure ForgottenUname
678: (p_email in fnd_user.email_address%type,
679: x_return_status out NOCOPY varchar2,
680: x_message_name out NOCOPY varchar2) is
681: begin
682:

Line 752: l_user_name fnd_user.user_name%type;

748: funcmode in varchar2,
749: resultout in out NOCOPY varchar2) is
750:
751: l_auth_key varchar2(400);
752: l_user_name fnd_user.user_name%type;
753:
754: begin
755: if (funcmode = 'RUN') then
756: -- Check if the password is already set.

Line 802: l_user_name fnd_user.user_name%type;

798: resultout in out NOCOPY varchar2) is
799: l_auth_key varchar2(400);
800: l_param varchar2(32000);
801: l_url varchar2(32000) := 'http://yahoo.com';
802: l_user_name fnd_user.user_name%type;
803:
804: l_link_name varchar2(400) := 'Click here';
805:
806:

Line 911: l_user_name fnd_user.user_name%type;

907: itemkey in varchar2,
908: actid in number,
909: funcmode in varchar2,
910: resultout in out NOCOPY varchar2) is
911: l_user_name fnd_user.user_name%type;
912: begin
913:
914: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
915: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 926: fnd_user_pkg.disableuser( username => l_user_name );

922: itemkey => itemkey,
923: aname => 'USER_NAME');
924:
925: if ( l_user_name is not null ) then
926: fnd_user_pkg.disableuser( username => l_user_name );
927: end if;
928: end if;
929:
930: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

Line 947: l_user_name fnd_user.user_name%type;

943: x_no_attempts out NOCOPY varchar2,
944: x_return_status out NOCOPY varchar2,
945: x_message_name out NOCOPY varchar2)
946: IS
947: l_user_name fnd_user.user_name%type;
948: l_authkey varchar2(400);
949: l_notification_preference wf_local_roles.notification_preference%type;
950: l_email_address varchar2(2000);
951: l_pwd_changeable boolean := true;

Line 1020: PROCEDURE ValidateResetPwdReq (p_username in fnd_user.user_name%type,

1016:
1017: end ValidateAuthKey;
1018:
1019:
1020: PROCEDURE ValidateResetPwdReq (p_username in fnd_user.user_name%type,
1021: p_authkey in varchar2,
1022: p_itemkey in varchar2,
1023: x_no_attempts out NOCOPY varchar2,
1024: x_return_status out NOCOPY varchar2,

Line 1027: l_user_name fnd_user.user_name%type;

1023: x_no_attempts out NOCOPY varchar2,
1024: x_return_status out NOCOPY varchar2,
1025: x_message_name out NOCOPY varchar2)
1026: IS
1027: l_user_name fnd_user.user_name%type;
1028: l_authkey varchar2(400);
1029: l_notification_preference wf_local_roles.notification_preference%type;
1030: l_email_address varchar2(2000);
1031: l_pwd_changeable boolean := true;

Line 1120: PROCEDURE ValidatePassword( p_username in fnd_user.user_name%type,

1116:
1117: end ValidateResetPwdReq;
1118:
1119:
1120: PROCEDURE ValidatePassword( p_username in fnd_user.user_name%type,
1121: x_password in out NOCOPY varchar2,
1122: x_return_status out NOCOPY varchar2,
1123: x_message_name out NOCOPY varchar2,
1124: x_message_data out NOCOPY varchar2 )

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

1184: end decrementAttemptCounter;
1185:
1186:
1187: -- Private Method
1188: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,
1189: --p_usernameurl in fnd_user.user_name%type,
1190: p_password in varchar2 default null,
1191: p_itemkey in varchar2,
1192: p_authkey in varchar2,

Line 1189: --p_usernameurl in fnd_user.user_name%type,

1185:
1186:
1187: -- Private Method
1188: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,
1189: --p_usernameurl in fnd_user.user_name%type,
1190: p_password in varchar2 default null,
1191: p_itemkey in varchar2,
1192: p_authkey in varchar2,
1193: x_no_attempts out NOCOPY varchar2,

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

1194: x_return_status out NOCOPY varchar2,
1195: x_message_name out NOCOPY varchar2,
1196: x_message_data out NOCOPY varchar2) IS
1197:
1198: l_user_name fnd_user.user_name%type := upper(p_username);
1199: -- l_email_address varchar2(2000);
1200: -- l_role_name wf_local_roles.name%type;
1201: l_password varchar2(40) := p_password;
1202: -- l_notification_preference wf_local_roles.notification_preference%type;

Line 1249: FND_USER_PKG.UpdateUserParty (

1245:
1246: if ( x_return_status = 'S' ) then
1247: BEGIN
1248:
1249: FND_USER_PKG.UpdateUserParty (
1250: x_user_name => l_user_name,
1251: x_owner => null,
1252: x_unencrypted_password => l_password,
1253: x_password_date => sysdate);

Line 1260: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',

1256: x_return_status := 'E';
1257: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1258: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1259: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1260: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
1261: 'x_no_attempts: ' || x_no_attempts ||
1262: 'x_return_status: ' || x_return_status ||
1263: ' | x_message_name: ' || x_message_name );
1264: end if;

Line 1282: procedure ResetPassword( p_username in fnd_user.user_name%type,

1278:
1279: END ResetPwdPvt;
1280:
1281:
1282: procedure ResetPassword( p_username in fnd_user.user_name%type,
1283: --p_usernameurl in fnd_user.user_name%type,
1284: p_password in varchar2 default null,
1285: p_itemkey in varchar2,
1286: p_authkey in varchar2,

Line 1283: --p_usernameurl in fnd_user.user_name%type,

1279: END ResetPwdPvt;
1280:
1281:
1282: procedure ResetPassword( p_username in fnd_user.user_name%type,
1283: --p_usernameurl in fnd_user.user_name%type,
1284: p_password in varchar2 default null,
1285: p_itemkey in varchar2,
1286: p_authkey in varchar2,
1287: x_no_attempts out NOCOPY varchar2,