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.

[Home] [Help]

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_UNEXP_ERROR';

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

266:
267: end get_email_address;
268:
269:
270: procedure Find_user_w_email (p_email in fnd_user.email_address%type,
271: x_role_name out nocopy varchar2,
272: x_user_name out nocopy varchar2,
273: x_notification_preference out nocopy varchar2,
274: x_message_name out nocopy varchar2) is

Line 281: l_email_address fnd_user.email_address%type;

277: -- three schema.
278: l_role_display_name wf_local_roles.display_name%type;
279: l_language wf_local_roles.language%type;
280: l_territory wf_local_roles.territory%type;
281: l_email_address fnd_user.email_address%type;
282:
283: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
284: SELECT user_name FROM fnd_user
285: WHERE email_address = p_email_address

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

279: l_language wf_local_roles.language%type;
280: l_territory wf_local_roles.territory%type;
281: l_email_address fnd_user.email_address%type;
282:
283: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
284: SELECT user_name FROM fnd_user
285: WHERE email_address = p_email_address
286: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
287:

Line 284: SELECT user_name FROM fnd_user

280: l_territory wf_local_roles.territory%type;
281: l_email_address fnd_user.email_address%type;
282:
283: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is
284: SELECT user_name FROM fnd_user
285: WHERE email_address = p_email_address
286: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
287:
288:

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

285: WHERE email_address = p_email_address
286: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
287:
288:
289: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
290: SELECT fu.user_name
291: FROM hz_parties p, fnd_user fu
292: WHERE p.party_id = fu.person_party_id
293: AND p.email_address = p_email_address;

Line 291: FROM hz_parties p, fnd_user fu

287:
288:
289: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
290: SELECT fu.user_name
291: FROM hz_parties p, fnd_user fu
292: WHERE p.party_id = fu.person_party_id
293: AND p.email_address = p_email_address;
294:
295:

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

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

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

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

Line 352: l_email_address fnd_user.email_address%type;

348: -- three schema.
349: l_role_display_name wf_local_roles.display_name%type;
350: l_language wf_local_roles.language%type;
351: l_territory wf_local_roles.territory%type;
352: l_email_address fnd_user.email_address%type;
353: l_user_name fnd_user.user_name%type;
354: l_notification_preference wf_local_roles.notification_preference%type;
355: i pls_integer := 0;
356:

Line 353: l_user_name fnd_user.user_name%type;

349: l_role_display_name wf_local_roles.display_name%type;
350: l_language wf_local_roles.language%type;
351: l_territory wf_local_roles.territory%type;
352: l_email_address fnd_user.email_address%type;
353: l_user_name fnd_user.user_name%type;
354: l_notification_preference wf_local_roles.notification_preference%type;
355: i pls_integer := 0;
356:
357: cursor get_user_fnd(p_email_address in fnd_user.email_address%type) is

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

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

Line 358: SELECT user_name FROM fnd_user

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

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

359: WHERE UPPER(email_address) = UPPER(p_email_address)
360: AND start_date <= sysdate AND nvl(end_date, sysdate + 1) > sysdate;
361:
362:
363: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
364: SELECT fu.user_name
365: FROM hz_parties p, fnd_user fu
366: WHERE p.party_id = fu.person_party_id
367: AND UPPER(p.email_address) = UPPER(p_email_address);

Line 365: FROM hz_parties p, fnd_user fu

361:
362:
363: cursor get_user_hz (p_email_address in fnd_user.user_name%type) is
364: SELECT fu.user_name
365: FROM hz_parties p, fnd_user fu
366: WHERE p.party_id = fu.person_party_id
367: AND UPPER(p.email_address) = UPPER(p_email_address);
368:
369:

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

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

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

478: end start_workflow;
479:
480:
481: procedure ForgottenPwdPvt
482: (p_username in fnd_user.user_name%type,
483: x_return_status out NOCOPY varchar2,
484: x_message_name out NOCOPY varchar2) is
485:
486: l_user_name fnd_user.user_name%type := upper(p_username);

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

482: (p_username in fnd_user.user_name%type,
483: x_return_status out NOCOPY varchar2,
484: x_message_name out NOCOPY varchar2) is
485:
486: l_user_name fnd_user.user_name%type := upper(p_username);
487: l_email_address varchar2(2000);
488: l_role_name wf_local_roles.name%type;
489: l_password varchar2(40);
490: l_notification_preference wf_local_roles.notification_preference%type;

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

569:
570: END ForgottenPwdPvt;
571:
572:
573: procedure ForgottenPwd(p_username in fnd_user.user_name%type,
574: x_return_status out NOCOPY varchar2,
575: x_message_name out NOCOPY varchar2) is
576: begin
577:

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

601:
602:
603:
604: procedure ForgottenUnamePvt
605: (p_email in fnd_user.email_address%type,
606: x_return_status out NOCOPY varchar2,
607: x_message_name out NOCOPY varchar2) is
608:
609: l_email_address varchar2(2000) := p_email;

Line 615: l_user_name fnd_user.user_name%type;

611: l_notification_preference wf_local_roles.notification_preference%type;
612: l_result wf_item_activity_statuses.activity_result_code%type;
613: l_status wf_item_activity_statuses.activity_status%type;
614: l_itemkey wf_items.item_key%type;
615: l_user_name fnd_user.user_name%type;
616: l_user_list UsersWEmail;
617: i pls_integer;
618: l_first pls_integer;
619: e pls_integer := 0;

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

698: END ForgottenUnamePvt;
699:
700:
701: procedure ForgottenUname
702: (p_email in fnd_user.email_address%type,
703: x_return_status out NOCOPY varchar2,
704: x_message_name out NOCOPY varchar2) is
705: begin
706:

Line 776: l_user_name fnd_user.user_name%type;

772: funcmode in varchar2,
773: resultout in out NOCOPY varchar2) is
774:
775: l_auth_key varchar2(400);
776: l_user_name fnd_user.user_name%type;
777:
778: begin
779: if (funcmode = 'RUN') then
780: -- Check if the password is already set.

Line 826: l_user_name fnd_user.user_name%type;

822: resultout in out NOCOPY varchar2) is
823: l_auth_key varchar2(400);
824: l_param varchar2(32000);
825: l_url varchar2(32000) := 'http://yahoo.com';
826: l_user_name fnd_user.user_name%type;
827:
828: l_link_name varchar2(400) := 'Click here';
829:
830:

Line 935: l_user_name fnd_user.user_name%type;

931: itemkey in varchar2,
932: actid in number,
933: funcmode in varchar2,
934: resultout in out NOCOPY varchar2) is
935: l_user_name fnd_user.user_name%type;
936: begin
937:
938: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
939: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

946: itemkey => itemkey,
947: aname => 'USER_NAME');
948:
949: if ( l_user_name is not null ) then
950: fnd_user_pkg.disableuser( username => l_user_name );
951: end if;
952: end if;
953:
954: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

Line 970: l_user_name fnd_user.user_name%type;

966: x_no_attempts out NOCOPY varchar2,
967: x_return_status out NOCOPY varchar2,
968: x_message_name out NOCOPY varchar2)
969: IS
970: l_user_name fnd_user.user_name%type;
971: l_authkey varchar2(400);
972: l_notification_preference wf_local_roles.notification_preference%type;
973: l_email_address varchar2(2000);
974: l_pwd_changeable boolean := true;

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

1039: end ValidateAuthKey;
1040:
1041:
1042:
1043: PROCEDURE ValidateResetPwdReq (p_username in fnd_user.user_name%type,
1044: p_authkey in varchar2,
1045: p_itemkey in varchar2,
1046: x_no_attempts out NOCOPY varchar2,
1047: x_return_status out NOCOPY varchar2,

Line 1050: l_user_name fnd_user.user_name%type;

1046: x_no_attempts out NOCOPY varchar2,
1047: x_return_status out NOCOPY varchar2,
1048: x_message_name out NOCOPY varchar2)
1049: IS
1050: l_user_name fnd_user.user_name%type;
1051: l_authkey varchar2(400);
1052: l_notification_preference wf_local_roles.notification_preference%type;
1053: l_email_address varchar2(2000);
1054: l_pwd_changeable boolean := true;

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

1137:
1138: end ValidateResetPwdReq;
1139:
1140:
1141: PROCEDURE ValidatePassword( p_username in fnd_user.user_name%type,
1142: x_password in out NOCOPY varchar2,
1143: x_return_status out NOCOPY varchar2,
1144: x_message_name out NOCOPY varchar2,
1145: x_message_data out NOCOPY varchar2 )

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

1204: end decrementAttemptCounter;
1205:
1206:
1207: -- Private Method
1208: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,
1209: --p_usernameurl in fnd_user.user_name%type,
1210: p_password in varchar2 default null,
1211: p_itemkey in varchar2,
1212: p_authkey in varchar2,

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

1205:
1206:
1207: -- Private Method
1208: procedure ResetPwdPvt (p_username in fnd_user.user_name%type,
1209: --p_usernameurl in fnd_user.user_name%type,
1210: p_password in varchar2 default null,
1211: p_itemkey in varchar2,
1212: p_authkey in varchar2,
1213: x_no_attempts out NOCOPY varchar2,

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

1214: x_return_status out NOCOPY varchar2,
1215: x_message_name out NOCOPY varchar2,
1216: x_message_data out NOCOPY varchar2) IS
1217:
1218: l_user_name fnd_user.user_name%type := upper(p_username);
1219: -- l_email_address varchar2(2000);
1220: -- l_role_name wf_local_roles.name%type;
1221: l_password varchar2(40) := p_password;
1222: -- l_notification_preference wf_local_roles.notification_preference%type;

Line 1269: FND_USER_PKG.UpdateUserParty (

1265:
1266: if ( x_return_status = 'S' ) then
1267: BEGIN
1268:
1269: FND_USER_PKG.UpdateUserParty (
1270: x_user_name => l_user_name,
1271: x_owner => l_user_name,
1272: x_unencrypted_password => l_password,
1273: x_password_date => sysdate);

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

1276: x_return_status := 'E';
1277: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1278: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1279: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1280: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
1281: 'x_no_attempts: ' || x_no_attempts ||
1282: 'x_return_status: ' || x_return_status ||
1283: ' | x_message_name: ' || x_message_name );
1284: end if;

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

1298:
1299: END ResetPwdPvt;
1300:
1301:
1302: procedure ResetPassword( p_username in fnd_user.user_name%type,
1303: --p_usernameurl in fnd_user.user_name%type,
1304: p_password in varchar2 default null,
1305: p_itemkey in varchar2,
1306: p_authkey in varchar2,

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

1299: END ResetPwdPvt;
1300:
1301:
1302: procedure ResetPassword( p_username in fnd_user.user_name%type,
1303: --p_usernameurl in fnd_user.user_name%type,
1304: p_password in varchar2 default null,
1305: p_itemkey in varchar2,
1306: p_authkey in varchar2,
1307: x_no_attempts out NOCOPY varchar2,