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_REGISTRATION_UTIL dependencies on UMX_REG_REQUESTS

Line 209: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;

205: l_requested_for_user_id fnd_user.user_id%type;
206: l_user_name fnd_user.user_name%type;
207: l_user_role_start_date DATE;
208: l_user_role_expiration_date DATE;
209: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE;
210: l_regsvc_disp_name umx_reg_services_tl.display_name%type;
211:
212: cursor get_username_from_userid (p_user_id in number) is
213: select user_name

Line 294: UMX_REG_REQUESTS_PKG.UPDATE_ROW (X_REG_REQUEST_ID => to_number (item_key),

290: p_expiration_date => l_user_role_expiration_date,
291: p_raiseErrors => true,
292: p_assignmentReason => l_justification);
293:
294: UMX_REG_REQUESTS_PKG.UPDATE_ROW (X_REG_REQUEST_ID => to_number (item_key),
295: X_STATUS_CODE => 'APPROVED');
296: end if;
297: resultout := 'COMPLETE';
298: end if;

Line 465: UMX_REG_REQUESTS_PKG.update_row (

461: itemkey => item_key,
462: aname => 'NOTIFICATION_CONTEXT',
463: avalue => 'IDENTITY_VERIFICATION');
464: -- update the status in the reg table to VERIFYING
465: UMX_REG_REQUESTS_PKG.update_row (
466: X_REG_REQUEST_ID => item_key,
467: X_STATUS_CODE => 'VERIFYING');
468:
469: resultout := 'COMPLETE:REQUIRED';

Line 562: -- Wrapper around UMX_REG_REQUESTS_PVT.create_reg_srv_request

558:
559: -- Procedure
560: -- create_reg_request
561: -- Description
562: -- Wrapper around UMX_REG_REQUESTS_PVT.create_reg_srv_request
563: -- IN
564: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
565: -- itemkey - A string generated from the application object's primary key.
566: -- actid - The function activity (instance id).

Line 576: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;

572: p_activity_id in number,
573: p_command in varchar2,
574: p_resultout out NOCOPY varchar2) is
575:
576: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;
578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;

Line 577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;

573: p_command in varchar2,
574: p_resultout out NOCOPY varchar2) is
575:
576: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;
578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;

Line 578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;

574: p_resultout out NOCOPY varchar2) is
575:
576: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;
578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;

Line 579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;

575:
576: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;
578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;

Line 580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;

576: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;
578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;

Line 581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;

577: l_requested_for_user_id UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE ;
578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;

Line 582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;

578: l_requested_by_user_id UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE ;
579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;

Line 583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;

579: l_requested_for_party_id UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE ;
580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;

Line 584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;

580: l_requested_username UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE ;
581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;
588: l_requested_start_date DATE;

Line 585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;

581: l_wf_role_name UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE ;
582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;
588: l_requested_start_date DATE;
589: l_requested_end_date DATE;

Line 586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;

582: l_reg_service_code UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE ;
583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;
588: l_requested_start_date DATE;
589: l_requested_end_date DATE;
590:

Line 587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;

583: l_reg_service_type UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE;
584: l_ame_application_id UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE ;
585: l_ame_transaction_type_id UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE ;
586: l_request_status_code UMX_REG_REQUESTS.STATUS_CODE%TYPE;
587: l_justification UMX_REG_REQUESTS.JUSTIFICATION%TYPE ;
588: l_requested_start_date DATE;
589: l_requested_end_date DATE;
590:
591: l_event wf_event_t;

Line 688: UMX_REG_REQUESTS_PKG.insert_row (

684: itemkey => p_item_key,
685: aname => 'REQUESTED_END_DATE',
686: ignore_notfound => false));
687:
688: UMX_REG_REQUESTS_PKG.insert_row (
689: x_reg_request_id => l_reg_request_id ,
690: x_reg_service_type => l_reg_service_type,
691: x_status_code => l_request_status_code,
692: x_requested_by_user_id => l_requested_by_user_id,

Line 843: 'Before invoking UMX_REG_REQUESTS_PVT.reserve_username API.');

839:
840: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
841: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
842: 'fnd.plsql.UMXUTILB.reserveusername',
843: 'Before invoking UMX_REG_REQUESTS_PVT.reserve_username API.');
844: end if;
845:
846: l_user_id := UMX_REG_REQUESTS_PVT.reserve_username (
847: p_reg_request_id => p_item_key, -- item key is regid

Line 846: l_user_id := UMX_REG_REQUESTS_PVT.reserve_username (

842: 'fnd.plsql.UMXUTILB.reserveusername',
843: 'Before invoking UMX_REG_REQUESTS_PVT.reserve_username API.');
844: end if;
845:
846: l_user_id := UMX_REG_REQUESTS_PVT.reserve_username (
847: p_reg_request_id => p_item_key, -- item key is regid
848: p_username => l_username,
849: p_owner => NULL,
850: p_unencrypted_password => l_password,

Line 943: umx_reg_requests_pvt.approve_username_reg_request (

939: ignore_notfound => false));
940: if (l_person_party_id is not null) then
941: -- call new fnd apis when provided
942: -- change all the dates appropriately and check how to get the format
943: umx_reg_requests_pvt.approve_username_reg_request (
944: p_reg_request_id => to_number (p_item_key),
945: p_username => l_user_name,
946: p_person_party_id => to_number (l_person_party_id),
947: p_start_date => l_start_date,

Line 1013: umx_reg_requests_pvt.reject_username_reg_request (

1009: aname => 'REQUESTED_FOR_USER_ID',
1010: ignore_notfound => false);
1011:
1012:
1013: umx_reg_requests_pvt.reject_username_reg_request (
1014: p_reg_request_id => p_item_key,
1015: p_user_id => l_userid,
1016: p_username => l_username);
1017:

Line 1074: select UMX_REG_REQUESTS_S.nextval into l_temp_event_key from dual;

1070:
1071: if (l_event_type = 'GENERIC') then
1072: select UMX_EVENTS_S.nextval into l_temp_event_key from dual;
1073: else
1074: select UMX_REG_REQUESTS_S.nextval into l_temp_event_key from dual;
1075: end if;
1076:
1077: l_event_key := to_char (l_temp_event_key);
1078: wf_engine.setitemattrtext (itemtype => p_item_type,

Line 1246: -- Wrapper around UMX_REG_REQUESTS_PVT.update_reg

1242: end set_event_object;
1243:
1244: -- update_reg_request
1245: -- Description
1246: -- Wrapper around UMX_REG_REQUESTS_PVT.update_reg
1247: -- IN
1248: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1249: -- itemkey - A string generated from the application object's primary key.
1250: -- actid - The function activity (instance id).

Line 1263: from UMX_REG_REQUESTS

1259:
1260: CURSOR getRegRequest (p_reg_request_id in number) is
1261:
1262: select STATUS_CODE
1263: from UMX_REG_REQUESTS
1264: where REG_REQUEST_ID = p_reg_request_id;
1265:
1266: l_reg_request umx_reg_requests_pvt.reg_request_type;
1267: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;

Line 1266: l_reg_request umx_reg_requests_pvt.reg_request_type;

1262: select STATUS_CODE
1263: from UMX_REG_REQUESTS
1264: where REG_REQUEST_ID = p_reg_request_id;
1265:
1266: l_reg_request umx_reg_requests_pvt.reg_request_type;
1267: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1268: l_status_code UMX_REG_REQUESTS.status_code%TYPE;
1269:
1270: l_event wf_event_t;

Line 1267: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;

1263: from UMX_REG_REQUESTS
1264: where REG_REQUEST_ID = p_reg_request_id;
1265:
1266: l_reg_request umx_reg_requests_pvt.reg_request_type;
1267: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1268: l_status_code UMX_REG_REQUESTS.status_code%TYPE;
1269:
1270: l_event wf_event_t;
1271:

Line 1268: l_status_code UMX_REG_REQUESTS.status_code%TYPE;

1264: where REG_REQUEST_ID = p_reg_request_id;
1265:
1266: l_reg_request umx_reg_requests_pvt.reg_request_type;
1267: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1268: l_status_code UMX_REG_REQUESTS.status_code%TYPE;
1269:
1270: l_event wf_event_t;
1271:
1272: BEGIN

Line 1383: UMX_REG_REQUESTS_PVT.update_reg_request (p_reg_request => l_reg_request);

1379: -- We need to update the status code to Pending
1380: l_reg_request.status_code := 'PENDING';
1381: end if;
1382: --update the reg request with latest details
1383: UMX_REG_REQUESTS_PVT.update_reg_request (p_reg_request => l_reg_request);
1384:
1385:
1386: p_resultout := 'COMPLETE';
1387: end if;

Line 1806: umx_reg_requests_pvt.reject_reg_request

1802: 'fnd.plsql.UMXUTILB.rejectrequest.begin',
1803: 'itemkey: '||p_item_key);
1804: end if;
1805:
1806: umx_reg_requests_pvt.reject_reg_request
1807: (p_reg_request_id => to_number (p_item_key));
1808:
1809: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1810: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 1856: umx_reg_requests_pvt.cancel_username_reg_request (

1852: aname => 'REQUESTED_FOR_USER_ID',
1853: ignore_notfound => false);
1854:
1855:
1856: umx_reg_requests_pvt.cancel_username_reg_request (
1857: p_reg_request_id => p_item_key,
1858: p_user_id => l_userid,
1859: p_username => l_username);
1860:

Line 1906: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => to_number (p_item_key),

1902: aname => 'REQUESTED_FOR_USER_ID',
1903: ignore_notfound => false);
1904:
1905: -- set the status from verifying to pending
1906: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => to_number (p_item_key),
1907: X_STATUS_CODE => 'PENDING');
1908:
1909: end if;
1910: