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: eid fnd_user.employee_id%type;

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: eid fnd_user.employee_id%type;
533: pid per_people_f.person_id%type;

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: eid fnd_user.employee_id%type;
533: pid per_people_f.person_id%type;
534: oid hz_parties.orig_system_reference%type;
535: uid fnd_user.user_id%type;

Line 532: eid fnd_user.employee_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: eid fnd_user.employee_id%type;
533: pid per_people_f.person_id%type;
534: oid hz_parties.orig_system_reference%type;
535: uid fnd_user.user_id%type;
536:

Line 535: uid fnd_user.user_id%type;

531: l_start_date fnd_user.start_date%type;
532: eid fnd_user.employee_id%type;
533: pid per_people_f.person_id%type;
534: oid hz_parties.orig_system_reference%type;
535: uid fnd_user.user_id%type;
536:
537: begin
538:
539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 550: fnd_user_pkg.EnableUser (

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

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

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

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

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

Line 556: fnd_user_pkg.UpdateUserParty (

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

Line 566: FROM FND_USER

562: -- begin changes for hrms future employee and security attributes
563: BEGIN
564: SELECT user_id
565: INTO uid
566: FROM FND_USER
567: WHERE USER_NAME = UPPER(p_username) ;
568:
569: EXCEPTION
570: WHEN NO_DATA_FOUND THEN

Line 588: FROM FND_USER

584: IF(oid LIKE 'PER%') THEN
585: BEGIN
586: SELECT EMPLOYEE_ID
587: INTO eid
588: FROM FND_USER
589: WHERE USER_NAME = UPPER(p_username) ;
590:
591: EXCEPTION
592: WHEN NO_DATA_FOUND THEN

Line 597: -- return the first person_id from HRMS , this would be used to populate FND_USER

593: eid := NULL;
594: END;
595: -- for future users employee id wont be populated even if orig system ref is PER%
596: IF(EID IS NULL ) THEN
597: -- return the first person_id from HRMS , this would be used to populate FND_USER
598: BEGIN
599: SELECT person_id
600: INTO pid
601: FROM per_people_f

Line 612: fnd_user_pkg.UpdateUser (x_user_name =>p_username, x_owner => NULL , x_employee_id =>pid);

608: END;
609: -- Changes for employee security attributes ( For HRMS Employee) + for future employee bug#7460262
610: -- calling UpdateUser would populate default security attributes, but for this customer one-off we
611: -- are explicitily inserting them. The insert commands should be removed for next releases
612: fnd_user_pkg.UpdateUser (x_user_name =>p_username, x_owner => NULL , x_employee_id =>pid);
613: eid :=pid;
614: END IF;
615: -- Changes for employee security attributes ( For HRMS Employee)
616: -- populate both the default security attributes with employee_id as value.

Line 724: -- fnd_user_pkg.release_username API.

720: -- Type : Private
721: -- Pre_reqs : None
722: -- Description : This API will ...
723: -- 1) Release the username by calling
724: -- fnd_user_pkg.release_username API.
725: -- 2) Set the status code to "REJECT" or "CANCELLED" in
726: -- UMX_REG_REQUESTS table.
727: -- 3) Remove the REQUESTED_FOR_USER_ID
728: -- 4) If the REQUESTED_BY_USER_ID is the same as the

Line 751: p_username in FND_USER.USER_NAME%TYPE,

747: -- Description :
748: --
749: Procedure reject_cancel_username_reg_req (
750: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
751: p_username in FND_USER.USER_NAME%TYPE,
752: p_user_id in FND_USER.USER_ID%TYPE,
753: p_status_code in UMX_REG_REQUESTS.STATUS_CODE%TYPE) is
754:
755: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;

Line 752: p_user_id in FND_USER.USER_ID%TYPE,

748: --
749: Procedure reject_cancel_username_reg_req (
750: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
751: p_username in FND_USER.USER_NAME%TYPE,
752: p_user_id in FND_USER.USER_ID%TYPE,
753: p_status_code in UMX_REG_REQUESTS.STATUS_CODE%TYPE) is
754:
755: l_requested_by_user_id umx_reg_requests.requested_by_user_id%type;
756:

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

769: ' | userId: ' || p_user_id ||
770: ' | statusCode: ' || p_status_code);
771: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
772: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
773: 'Before calling fnd_user_pkg.RemovePendingUser');
774: end if;
775:
776: -- Call FND's release_username API to release/delete the username
777: fnd_user_pkg.RemovePendingUser (username => p_username);

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

773: 'Before calling fnd_user_pkg.RemovePendingUser');
774: end if;
775:
776: -- Call FND's release_username API to release/delete the username
777: fnd_user_pkg.RemovePendingUser (username => p_username);
778:
779: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
781: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',

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

778:
779: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
781: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
782: 'After calling fnd_user_pkg.RemovePendingUser');
783: end if;
784:
785: -- Query the requested_by_user_id from UMX_reg_requests table
786: -- If the requested_by_user_id is equal to the requested_for_user_id,

Line 840: p_user_id in FND_USER.USER_ID%TYPE,

836: -- Description :
837: --
838: Procedure reject_username_reg_request (
839: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
840: p_user_id in FND_USER.USER_ID%TYPE,
841: p_username in FND_USER.USER_NAME%TYPE) is
842:
843: begin
844:

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

837: --
838: Procedure reject_username_reg_request (
839: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
840: p_user_id in FND_USER.USER_ID%TYPE,
841: p_username in FND_USER.USER_NAME%TYPE) is
842:
843: begin
844:
845: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

Line 892: p_user_id in FND_USER.USER_ID%TYPE,

888: -- Description :
889: --
890: Procedure cancel_username_reg_request (
891: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
892: p_user_id in FND_USER.USER_ID%TYPE,
893: p_username in FND_USER.USER_NAME%TYPE) is
894:
895: begin
896:

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

889: --
890: Procedure cancel_username_reg_request (
891: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
892: p_user_id in FND_USER.USER_ID%TYPE,
893: p_username in FND_USER.USER_NAME%TYPE) is
894:
895: begin
896:
897: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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

1241: -- x_justification
1242: -- Description: Justification
1243: --
1244: Procedure get_pend_acct_info (
1245: p_requester_user_id in FND_USER.USER_ID%TYPE default null,
1246: x_reg_request_id in out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1247: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1248: x_approver_name out NOCOPY varchar2,
1249: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

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

1243: --
1244: Procedure get_pend_acct_info (
1245: p_requester_user_id in FND_USER.USER_ID%TYPE default null,
1246: x_reg_request_id in out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1247: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1248: x_approver_name out NOCOPY varchar2,
1249: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1250: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1251: x_active_from out NOCOPY varchar2,

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

1245: p_requester_user_id in FND_USER.USER_ID%TYPE default null,
1246: x_reg_request_id in out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1247: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1248: x_approver_name out NOCOPY varchar2,
1249: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1250: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1251: x_active_from out NOCOPY varchar2,
1252: x_active_to out NOCOPY varchar2,
1253: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is

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

1254:
1255: l_application_id AME_CALLING_APPS.FND_APPLICATION_ID%TYPE;
1256: l_transaction_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1257:
1258: cursor get_reg_req_info_from_userid (p_user_id in FND_USER.USER_ID%TYPE) is
1259: select reg_request_id, status_code, ame_application_id,
1260: ame_transaction_type_id, requested_username, justification
1261: from umx_reg_requests
1262: where requested_for_user_id = p_user_id

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

1266: select status_code, ame_application_id, ame_transaction_type_id, justification
1267: from umx_reg_requests
1268: where reg_request_id = p_reg_req_id;
1269:
1270: cursor getUserName (l_user_id in fnd_user.user_id%type) is
1271: select user_name
1272: from fnd_user
1273: where user_id = l_user_id;
1274:

Line 1272: from fnd_user

1268: where reg_request_id = p_reg_req_id;
1269:
1270: cursor getUserName (l_user_id in fnd_user.user_id%type) is
1271: select user_name
1272: from fnd_user
1273: where user_id = l_user_id;
1274:
1275: begin
1276:

Line 1429: p_requester_user_id in FND_USER.USER_ID%TYPE,

1425: -- x_justification
1426: -- Description: Justification
1427: --
1428: Procedure get_pend_acct_info_with_userid (
1429: p_requester_user_id in FND_USER.USER_ID%TYPE,
1430: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1431: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1432: x_approver_name out NOCOPY varchar2,
1433: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

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

1427: --
1428: Procedure get_pend_acct_info_with_userid (
1429: p_requester_user_id in FND_USER.USER_ID%TYPE,
1430: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1431: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1432: x_approver_name out NOCOPY varchar2,
1433: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1434: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1435: x_active_from out NOCOPY varchar2,

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

1429: p_requester_user_id in FND_USER.USER_ID%TYPE,
1430: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1431: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
1432: x_approver_name out NOCOPY varchar2,
1433: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1434: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1435: x_active_from out NOCOPY varchar2,
1436: x_active_to out NOCOPY varchar2,
1437: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is

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

1502: --
1503: Procedure get_pend_acct_info_with_reqid (
1504: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
1505: x_approver_name out NOCOPY varchar2,
1506: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
1507: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
1508: x_active_from out NOCOPY varchar2,
1509: x_active_to out NOCOPY varchar2,
1510: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is

Line 1513: l_requested_for_username FND_USER.USER_NAME%TYPE;

1509: x_active_to out NOCOPY varchar2,
1510: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE) is
1511:
1512: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1513: l_requested_for_username FND_USER.USER_NAME%TYPE;
1514:
1515: begin
1516:
1517: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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

1659: -- x_errmsg: Error Message
1660: -- x_errstack: Error Stack
1661: --
1662: --
1663: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
1664: x_itemtype out nocopy wf_items.item_type%type,
1665: x_itemkey out nocopy wf_items.item_key%type,
1666: x_status out nocopy varchar2,
1667: x_result out nocopy varchar2,

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

1669: x_errname out nocopy varchar2,
1670: x_errmsg out nocopy varchar2,
1671: x_errstack out nocopy varchar2) IS
1672:
1673: cursor get_reg_req_id_with_user_id (l_user_id in fnd_user.user_id%type) is
1674: select reg_request_id
1675: from umx_reg_requests
1676: where requested_for_user_id = l_user_id;
1677:

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

1796: --
1797: -- Output Parameter:
1798: -- It will return 'Y' if pending account has error and 'N' if otherwise.
1799: --
1800: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is
1801:
1802: l_itemtype wf_items.item_type%type;
1803: l_itemkey wf_items.item_key%type;
1804: l_status varchar2(8);