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

Line 13: from FND_USER

9:
10: cursor getPersonPartyId ( x_user_id in number ) is
11:
12: select PERSON_PARTY_ID
13: from FND_USER
14: where USER_ID = X_USER_ID
15: and nvl( END_DATE, sysdate+1) > sysdate;
16:
17: cursor getRegSvcFromRegCode ( x_reg_service_code in varchar2 ) is

Line 292: -- FND_USER table.

288: -- Function : is_username_available
289: -- Type : PRIVATE
290: -- Pre_reqs : None
291: -- Description : It will query if username is being used in
292: -- FND_USER table.
293: -- input parameters :
294: -- @param p_username
295: -- Description: username to perform the check
296: -- Required : Y

Line 302: function is_username_available (p_username in FND_USER.USER_NAME%TYPE) return boolean is

298: -- Description : It will output boolean value of true or false.
299: -- true - username is available
300: -- false - username is not available
301: --
302: function is_username_available (p_username in FND_USER.USER_NAME%TYPE) return boolean is
303:
304: cursor getUserFromFNDUSER (l_username in fnd_user.user_name%type) is
305: select user_name
306: from fnd_user

Line 304: cursor getUserFromFNDUSER (l_username in fnd_user.user_name%type) is

300: -- false - username is not available
301: --
302: function is_username_available (p_username in FND_USER.USER_NAME%TYPE) return boolean is
303:
304: cursor getUserFromFNDUSER (l_username in fnd_user.user_name%type) is
305: select user_name
306: from fnd_user
307: where user_name = l_username;
308:

Line 306: from fnd_user

302: function is_username_available (p_username in FND_USER.USER_NAME%TYPE) return boolean is
303:
304: cursor getUserFromFNDUSER (l_username in fnd_user.user_name%type) is
305: select user_name
306: from fnd_user
307: where user_name = l_username;
308:
309: l_username_available boolean;
310: l_username fnd_user.user_name%type;

Line 310: l_username fnd_user.user_name%type;

306: from fnd_user
307: where user_name = l_username;
308:
309: l_username_available boolean;
310: l_username fnd_user.user_name%type;
311:
312: begin
313:
314: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 333: -- Query didn't find out username in FND_USER table,

329:
330: open getUserFromFNDUSER (l_username);
331: fetch getUserFromFNDUSER into l_username;
332: if (getUserFromFNDUSER%notfound) then
333: -- Query didn't find out username in FND_USER table,
334: -- username is available
335: l_username_available := true;
336:
337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 366: -- 1) Call fnd_user_pkg.reserve_username API to reserve

362: -- Function : reserve_username
363: -- Type : Private
364: -- Pre_reqs : None
365: -- Description : This API will ...
366: -- 1) Call fnd_user_pkg.reserve_username API to reserve
367: -- the requested username.
368: -- 2) Update the UMX_REG_REQUESTS table with the
369: -- requested for username and requested by username
370: -- (if requested by is null).

Line 387: p_username in FND_USER.USER_NAME%TYPE,

383: -- successfully reserved or null if otherwise.
384: --
385: function reserve_username (
386: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
387: p_username in FND_USER.USER_NAME%TYPE,
388: p_owner in varchar2 default null,
389: p_unencrypted_password in varchar2,
390: p_session_number in number default 0,
391: p_last_logon_date in date default null,

Line 397: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,

393: p_password_date in date default null,
394: p_password_accesses_left in number default null,
395: p_password_lifespan_accesses in number default null,
396: p_password_lifespan_days in number default null,
397: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,
398: p_fax in varchar2 default null,
399: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
400: ) return fnd_user.user_id%type is
401:

Line 399: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null

395: p_password_lifespan_accesses in number default null,
396: p_password_lifespan_days in number default null,
397: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,
398: p_fax in varchar2 default null,
399: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
400: ) return fnd_user.user_id%type is
401:
402: l_user_id fnd_user.user_id%type;
403: l_requested_by_user_id UMX_reg_requests.requested_by_user_id%type;

Line 400: ) return fnd_user.user_id%type is

396: p_password_lifespan_days in number default null,
397: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,
398: p_fax in varchar2 default null,
399: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
400: ) return fnd_user.user_id%type is
401:
402: l_user_id fnd_user.user_id%type;
403: l_requested_by_user_id UMX_reg_requests.requested_by_user_id%type;
404:

Line 402: l_user_id fnd_user.user_id%type;

398: p_fax in varchar2 default null,
399: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
400: ) return fnd_user.user_id%type is
401:
402: l_user_id fnd_user.user_id%type;
403: l_requested_by_user_id UMX_reg_requests.requested_by_user_id%type;
404:
405: cursor getRequestedByUserId (p_reg_request_id in UMX_reg_requests.reg_request_id%type) is
406: select requested_by_user_id

Line 430: -- First call fnd's resrve_username to reserve a username in FND user table.

426: ' | fax: ' || p_fax ||
427: ' | personPartyId: ' || p_person_party_id);
428: end if;
429:
430: -- First call fnd's resrve_username to reserve a username in FND user table.
431: -- Still waiting for their true implementation from the proposal
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVRRSB.reserve_username',

Line 435: 'Before calling fnd_user_pkg.CreatePendingUser');

431: -- Still waiting for their true implementation from the proposal
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVRRSB.reserve_username',
435: 'Before calling fnd_user_pkg.CreatePendingUser');
436: end if;
437:
438: l_user_id := fnd_user_pkg.CreatePendingUser (
439: x_user_name => p_username,

Line 438: l_user_id := fnd_user_pkg.CreatePendingUser (

434: 'fnd.plsql.UMXVRRSB.reserve_username',
435: 'Before calling fnd_user_pkg.CreatePendingUser');
436: end if;
437:
438: l_user_id := fnd_user_pkg.CreatePendingUser (
439: x_user_name => p_username,
440: x_owner => p_owner,
441: x_unencrypted_password => p_unencrypted_password,
442: x_session_number => p_session_number,

Line 444: x_password_date => nvl (p_password_date, fnd_user_pkg.null_date),

440: x_owner => p_owner,
441: x_unencrypted_password => p_unencrypted_password,
442: x_session_number => p_session_number,
443: x_description => p_description,
444: x_password_date => nvl (p_password_date, fnd_user_pkg.null_date),
445: x_password_accesses_left => p_password_accesses_left,
446: x_password_lifespan_accesses => p_password_lifespan_accesses,
447: x_password_lifespan_days => p_password_lifespan_days,
448: x_email_address => p_email_address,

Line 455: 'After calling fnd_user_pkg.CreatePendingUser');

451:
452: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
453: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
454: 'fnd.plsql.UMXVRRSB.reserve_username',
455: 'After calling fnd_user_pkg.CreatePendingUser');
456: end if;
457:
458: -- Find who is the requested_by_user_id. If it is null, then
459: -- we need to update the new user_id to the requested_by_user_id as well.

Line 497: -- fnd_user_pkg.activate_user_account.

493: -- Type : Private
494: -- Pre_reqs : None
495: -- Description : This API will ...
496: -- 1) Activiate the user account by calling
497: -- fnd_user_pkg.activate_user_account.
498: -- 2) Set the status code to "APPROVED" in
499: -- UMX_REG_REQUESTS table.
500: --
501: -- This API should be called from Self-Service Registration or

Line 526: p_username in FND_USER.USER_NAME%TYPE,

522: -- Description :
523: --
524: Procedure approve_username_reg_request (
525: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
526: p_username in FND_USER.USER_NAME%TYPE,
527: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
528: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
529: p_end_date in FND_USER.END_DATE%TYPE default null) is
530:

Line 527: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,

523: --
524: Procedure approve_username_reg_request (
525: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
526: p_username in FND_USER.USER_NAME%TYPE,
527: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
528: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
529: p_end_date in FND_USER.END_DATE%TYPE default null) is
530:
531: l_start_date fnd_user.start_date%type;

Line 528: p_start_date in FND_USER.START_DATE%TYPE default sysdate,

524: Procedure approve_username_reg_request (
525: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
526: p_username in FND_USER.USER_NAME%TYPE,
527: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
528: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
529: p_end_date in FND_USER.END_DATE%TYPE default null) is
530:
531: l_start_date fnd_user.start_date%type;
532:

Line 529: p_end_date in FND_USER.END_DATE%TYPE default null) is

525: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
526: p_username in FND_USER.USER_NAME%TYPE,
527: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
528: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
529: p_end_date in FND_USER.END_DATE%TYPE default null) is
530:
531: l_start_date fnd_user.start_date%type;
532:
533: begin

Line 531: l_start_date fnd_user.start_date%type;

527: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
528: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
529: p_end_date in FND_USER.END_DATE%TYPE default null) is
530:
531: l_start_date fnd_user.start_date%type;
532:
533: begin
534:
535: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 546: fnd_user_pkg.EnableUser (

542: ' | endDate: ' || p_end_date);
543: end if;
544:
545: -- Call FND's activate_user_account API to activate the user account.
546: fnd_user_pkg.EnableUser (
547: username => p_username,
548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:

Line 549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));

545: -- Call FND's activate_user_account API to activate the user account.
546: fnd_user_pkg.EnableUser (
547: username => p_username,
548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:
551: -- Need to update the Person Party's ID in the FND_USER table
552: fnd_user_pkg.UpdateUserParty (
553: x_user_name => p_username,

Line 551: -- Need to update the Person Party's ID in the FND_USER table

547: username => p_username,
548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:
551: -- Need to update the Person Party's ID in the FND_USER table
552: fnd_user_pkg.UpdateUserParty (
553: x_user_name => p_username,
554: x_owner => NULL,
555: x_person_party_id => p_person_party_id);

Line 552: fnd_user_pkg.UpdateUserParty (

548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:
551: -- Need to update the Person Party's ID in the FND_USER table
552: fnd_user_pkg.UpdateUserParty (
553: x_user_name => p_username,
554: x_owner => NULL,
555: x_person_party_id => p_person_party_id);
556:

Line 576: -- fnd_user_pkg.release_username API.

572: -- Type : Private
573: -- Pre_reqs : None
574: -- Description : This API will ...
575: -- 1) Release the username by calling
576: -- fnd_user_pkg.release_username API.
577: -- 2) Set the status code to "REJECT" or "CANCELLED" in
578: -- UMX_REG_REQUESTS table.
579: -- 3) Remove the REQUESTED_FOR_USER_ID
580: -- 4) If the REQUESTED_BY_USER_ID is the same as the

Line 603: p_username in FND_USER.USER_NAME%TYPE,

599: -- Description :
600: --
601: Procedure reject_cancel_username_reg_req (
602: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
603: p_username in FND_USER.USER_NAME%TYPE,
604: p_user_id in FND_USER.USER_ID%TYPE,
605: p_status_code in UMX_REG_REQUESTS.STATUS_CODE%TYPE) is
606:
607: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;

Line 604: p_user_id in FND_USER.USER_ID%TYPE,

600: --
601: Procedure reject_cancel_username_reg_req (
602: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
603: p_username in FND_USER.USER_NAME%TYPE,
604: p_user_id in FND_USER.USER_ID%TYPE,
605: p_status_code in UMX_REG_REQUESTS.STATUS_CODE%TYPE) is
606:
607: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;
608:

Line 625: 'Before calling fnd_user_pkg.RemovePendingUser');

621: ' | userId: ' || p_user_id ||
622: ' | statusCode: ' || p_status_code);
623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
624: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
625: 'Before calling fnd_user_pkg.RemovePendingUser');
626: end if;
627:
628: -- Call FND's release_username API to release/delete the username
629: fnd_user_pkg.RemovePendingUser (username => p_username);

Line 629: fnd_user_pkg.RemovePendingUser (username => p_username);

625: 'Before calling fnd_user_pkg.RemovePendingUser');
626: end if;
627:
628: -- Call FND's release_username API to release/delete the username
629: fnd_user_pkg.RemovePendingUser (username => p_username);
630:
631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
633: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',

Line 634: 'After calling fnd_user_pkg.RemovePendingUser');

630:
631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
633: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
634: 'After calling fnd_user_pkg.RemovePendingUser');
635: end if;
636:
637: -- Query the requested_by_user_id from UMX_reg_requests table
638: -- If the requested_by_user_id is equal to the requested_for_user_id,

Line 692: p_user_id in FND_USER.USER_ID%TYPE,

688: -- Description :
689: --
690: Procedure reject_username_reg_request (
691: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
692: p_user_id in FND_USER.USER_ID%TYPE,
693: p_username in FND_USER.USER_NAME%TYPE) is
694:
695: begin
696:

Line 693: p_username in FND_USER.USER_NAME%TYPE) is

689: --
690: Procedure reject_username_reg_request (
691: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
692: p_user_id in FND_USER.USER_ID%TYPE,
693: p_username in FND_USER.USER_NAME%TYPE) is
694:
695: begin
696:
697: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 744: p_user_id in FND_USER.USER_ID%TYPE,

740: -- Description :
741: --
742: Procedure cancel_username_reg_request (
743: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
744: p_user_id in FND_USER.USER_ID%TYPE,
745: p_username in FND_USER.USER_NAME%TYPE) is
746:
747: begin
748:

Line 745: p_username in FND_USER.USER_NAME%TYPE) is

741: --
742: Procedure cancel_username_reg_request (
743: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
744: p_user_id in FND_USER.USER_ID%TYPE,
745: p_username in FND_USER.USER_NAME%TYPE) is
746:
747: begin
748:
749: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 1097: p_requester_user_id in FND_USER.USER_ID%TYPE default null,

1093: -- x_justification
1094: -- Description: Justification
1095: --
1096: Procedure get_pend_acct_info (
1097: p_requester_user_id in FND_USER.USER_ID%TYPE default null,
1098: x_reg_request_id in out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1099: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1100: x_approver_name out NOCOPY varchar2,
1101: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

Line 1099: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,

1095: --
1096: Procedure get_pend_acct_info (
1097: p_requester_user_id in FND_USER.USER_ID%TYPE default null,
1098: x_reg_request_id in out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1099: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1100: x_approver_name out NOCOPY varchar2,
1101: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1102: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1103: x_active_from out NOCOPY varchar2,

Line 1101: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

1097: p_requester_user_id in FND_USER.USER_ID%TYPE default null,
1098: x_reg_request_id in out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1099: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1100: x_approver_name out NOCOPY varchar2,
1101: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1102: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1103: x_active_from out NOCOPY varchar2,
1104: x_active_to out NOCOPY varchar2,
1105: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is

Line 1110: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is

1106:
1107: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;
1108: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1109:
1110: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is
1111: select reg_request_id, status_code, ame_application_id,
1112: ame_transaction_type_id, requested_username, justification
1113: from umx_reg_requests
1114: where requested_for_user_id = p_user_id

Line 1122: cursor getUserName (l_user_id in fnd_user.user_id%type) is

1118: select status_code, ame_application_id, ame_transaction_type_id, justification
1119: from umx_reg_requests
1120: where reg_request_id = p_reg_req_id;
1121:
1122: cursor getUserName (l_user_id in fnd_user.user_id%type) is
1123: select user_name
1124: from fnd_user
1125: where user_id = l_user_id;
1126:

Line 1124: from fnd_user

1120: where reg_request_id = p_reg_req_id;
1121:
1122: cursor getUserName (l_user_id in fnd_user.user_id%type) is
1123: select user_name
1124: from fnd_user
1125: where user_id = l_user_id;
1126:
1127: begin
1128:

Line 1281: p_requester_user_id in FND_USER.USER_ID%TYPE,

1277: -- x_justification
1278: -- Description: Justification
1279: --
1280: Procedure get_pend_acct_info_with_userid (
1281: p_requester_user_id in FND_USER.USER_ID%TYPE,
1282: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1283: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1284: x_approver_name out NOCOPY varchar2,
1285: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

Line 1283: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,

1279: --
1280: Procedure get_pend_acct_info_with_userid (
1281: p_requester_user_id in FND_USER.USER_ID%TYPE,
1282: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1283: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1284: x_approver_name out NOCOPY varchar2,
1285: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1286: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1287: x_active_from out NOCOPY varchar2,

Line 1285: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

1281: p_requester_user_id in FND_USER.USER_ID%TYPE,
1282: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1283: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1284: x_approver_name out NOCOPY varchar2,
1285: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1286: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1287: x_active_from out NOCOPY varchar2,
1288: x_active_to out NOCOPY varchar2,
1289: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is

Line 1358: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

1354: --
1355: Procedure get_pend_acct_info_with_reqid (
1356: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1357: x_approver_name out NOCOPY varchar2,
1358: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1359: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1360: x_active_from out NOCOPY varchar2,
1361: x_active_to out NOCOPY varchar2,
1362: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is

Line 1365: l_requested_for_username FND_USER.USER_NAME%TYPE;

1361: x_active_to out NOCOPY varchar2,
1362: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is
1363:
1364: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1365: l_requested_for_username FND_USER.USER_NAME%TYPE;
1366:
1367: begin
1368:
1369: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 1515: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,

1511: -- x_errmsg: Error Message
1512: -- x_errstack: Error Stack
1513: --
1514: --
1515: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
1516: x_itemtype out nocopy wf_items.item_type%type,
1517: x_itemkey out nocopy wf_items.item_key%type,
1518: x_status out nocopy varchar2,
1519: x_result out nocopy varchar2,

Line 1525: cursor get_reg_req_id_with_user_id (l_user_id in fnd_user.user_id%type) is

1521: x_errname out nocopy varchar2,
1522: x_errmsg out nocopy varchar2,
1523: x_errstack out nocopy varchar2) IS
1524:
1525: cursor get_reg_req_id_with_user_id (l_user_id in fnd_user.user_id%type) is
1526: select reg_request_id
1527: from umx_reg_requests
1528: where requested_for_user_id = l_user_id;
1529:

Line 1652: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is

1648: --
1649: -- Output Parameter:
1650: -- It will return 'Y' if pending account has error and 'N' if otherwise.
1651: --
1652: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is
1653:
1654: l_itemtype wf_items.item_type%type;
1655: l_itemkey wf_items.item_key%type;
1656: l_status varchar2(8);