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 FND_USER

Line 83: from fnd_user

79: function check_admin_grants (l_requested_by_user_id in number) return boolean is
80:
81: cursor getUsername is
82: select user_name
83: from fnd_user
84: where user_id = l_requested_by_user_id
85: and nvl (start_date, SYSDATE) <= SYSDATE
86: and nvl (end_date, SYSDATE + 1) > SYSDATE ;
87:

Line 90: l_username FND_USER.USER_NAME%TYPE;

86: and nvl (end_date, SYSDATE + 1) > SYSDATE ;
87:
88: count int;
89: priv boolean;
90: l_username FND_USER.USER_NAME%TYPE;
91:
92: begin
93:
94:

Line 205: l_requested_for_user_id fnd_user.user_id%type;

201: command in varchar2,
202: resultout out NOCOPY varchar2) is
203:
204: l_wf_role_name wf_local_roles.name%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;

Line 206: l_user_name fnd_user.user_name%type;

202: resultout out NOCOPY varchar2) is
203:
204: l_wf_role_name wf_local_roles.name%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;

Line 214: from fnd_user

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
214: from fnd_user
215: where user_id = p_user_id;
216:
217: BEGIN
218:

Line 333: l_requested_by_user_id fnd_user.user_id%type;

329: l_ame_transaction_type_id AME_TRANSACTION_TYPES_V.TRANSACTION_TYPE_ID%TYPE;
330: l_ame_application_id AME_TRANSACTION_TYPES_V.FND_APPLICATION_ID%TYPE;
331: l_reg_svc_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;
332: l_reg_svc_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%TYPE;
333: l_requested_by_user_id fnd_user.user_id%type;
334: l_requested_for_user_id fnd_user.user_id%type;
335: l_rby_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
336: l_rfor_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
337: l_launch_workflow boolean := false;

Line 334: l_requested_for_user_id fnd_user.user_id%type;

330: l_ame_application_id AME_TRANSACTION_TYPES_V.FND_APPLICATION_ID%TYPE;
331: l_reg_svc_code UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE;
332: l_reg_svc_type UMX_REG_SERVICES_B.REG_SERVICE_TYPE%TYPE;
333: l_requested_by_user_id fnd_user.user_id%type;
334: l_requested_for_user_id fnd_user.user_id%type;
335: l_rby_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
336: l_rfor_userid_string WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
337: l_launch_workflow boolean := false;
338:

Line 507: l_username fnd_user.user_name%type;

503: resultout out NOCOPY varchar2) is
504:
505: l_message_tokens varchar2 (100);
506: l_missing_attribute boolean := false;
507: l_username fnd_user.user_name%type;
508:
509: BEGIN
510:
511: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 721: -- Wrapper around Fnd_user_pkg.create_username with status as pending

717:
718: -- Procedure
719: -- Reserve UserName
720: -- Description
721: -- Wrapper around Fnd_user_pkg.create_username with status as pending
722: -- IN
723: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
724: -- itemkey - A string generated from the application object's primary key.
725: -- actid - The function activity (instance id).

Line 735: l_username FND_USER.USER_NAME%TYPE;

731: p_activity_id in number,
732: p_command in varchar2,
733: p_resultout out NOCOPY varchar2) is
734:
735: l_username FND_USER.USER_NAME%TYPE;
736: l_person_party_id HZ_PARTIES.party_id%TYPE;
737: l_temp_party_id varchar2 (25);
738: l_password varchar2 (100);
739: l_expire_password varchar2 (25);

Line 742: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;

738: l_password varchar2 (100);
739: l_expire_password varchar2 (25);
740: l_user_id number;
741: l_temp_user_id varchar2 (25);
742: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
743: l_fax FND_USER.FAX%TYPE;
744: l_password_date DATE;
745: l_password_message VARCHAR2 (300);
746: l_return_status pls_integer;

Line 743: l_fax FND_USER.FAX%TYPE;

739: l_expire_password varchar2 (25);
740: l_user_id number;
741: l_temp_user_id varchar2 (25);
742: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
743: l_fax FND_USER.FAX%TYPE;
744: l_password_date DATE;
745: l_password_message VARCHAR2 (300);
746: l_return_status pls_integer;
747:

Line 809: 'Before invoking fnd_user_pkg.TestUserName API with username is ' || l_username);

805: -- Check if the username is available
806: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
807: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
808: 'fnd.plsql.UMXUTILB.reserveusername',
809: 'Before invoking fnd_user_pkg.TestUserName API with username is ' || l_username);
810: end if;
811:
812: l_return_status := fnd_user_pkg.TestUserName (x_user_name => l_username);
813:

Line 812: l_return_status := fnd_user_pkg.TestUserName (x_user_name => l_username);

808: 'fnd.plsql.UMXUTILB.reserveusername',
809: 'Before invoking fnd_user_pkg.TestUserName API with username is ' || l_username);
810: end if;
811:
812: l_return_status := fnd_user_pkg.TestUserName (x_user_name => l_username);
813:
814: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
816: 'fnd.plsql.UMXUTILB.reserveusername',

Line 817: 'After invoking fnd_user_pkg.TestUserName API with return status is ' || l_return_status);

813:
814: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
815: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
816: 'fnd.plsql.UMXUTILB.reserveusername',
817: 'After invoking fnd_user_pkg.TestUserName API with return status is ' || l_return_status);
818: end if;
819:
820: if ((l_return_status = fnd_user_pkg.USER_INVALID_NAME) or
821: (l_return_status = fnd_user_pkg.USER_EXISTS_IN_FND) or

Line 820: if ((l_return_status = fnd_user_pkg.USER_INVALID_NAME) or

816: 'fnd.plsql.UMXUTILB.reserveusername',
817: 'After invoking fnd_user_pkg.TestUserName API with return status is ' || l_return_status);
818: end if;
819:
820: if ((l_return_status = fnd_user_pkg.USER_INVALID_NAME) or
821: (l_return_status = fnd_user_pkg.USER_EXISTS_IN_FND) or
822: (l_return_status = fnd_user_pkg.USER_EXISTS_NO_LINK_ALLOWED)) then
823: -- There is problem with the username. Throw error
824: raise_application_error ('-20000', fnd_message.get);

Line 821: (l_return_status = fnd_user_pkg.USER_EXISTS_IN_FND) or

817: 'After invoking fnd_user_pkg.TestUserName API with return status is ' || l_return_status);
818: end if;
819:
820: if ((l_return_status = fnd_user_pkg.USER_INVALID_NAME) or
821: (l_return_status = fnd_user_pkg.USER_EXISTS_IN_FND) or
822: (l_return_status = fnd_user_pkg.USER_EXISTS_NO_LINK_ALLOWED)) then
823: -- There is problem with the username. Throw error
824: raise_application_error ('-20000', fnd_message.get);
825: else

Line 822: (l_return_status = fnd_user_pkg.USER_EXISTS_NO_LINK_ALLOWED)) then

818: end if;
819:
820: if ((l_return_status = fnd_user_pkg.USER_INVALID_NAME) or
821: (l_return_status = fnd_user_pkg.USER_EXISTS_IN_FND) or
822: (l_return_status = fnd_user_pkg.USER_EXISTS_NO_LINK_ALLOWED)) then
823: -- There is problem with the username. Throw error
824: raise_application_error ('-20000', fnd_message.get);
825: else
826: add_param_to_event (p_item_type, p_item_key, 'TESTUSERNAME_RET_STATUS', l_return_status);

Line 829: if (l_return_status = fnd_user_pkg.user_synched) then

825: else
826: add_param_to_event (p_item_type, p_item_key, 'TESTUSERNAME_RET_STATUS', l_return_status);
827: end if;
828:
829: if (l_return_status = fnd_user_pkg.user_synched) then
830: -- Because the account will be synched, we no longer needs to keep
831: -- the user password in apps. Password will be managed "EXTERNALLY".
832: l_password := null;
833: wf_engine.setitemattrtext (itemtype => p_item_type,

Line 892: -- Wrapper around Fnd_user_pkg.update_username with status as approved

888:
889: -- Procedure
890: -- activate_userName
891: -- Description
892: -- Wrapper around Fnd_user_pkg.update_username with status as approved
893: -- IN
894: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
895: -- itemkey - A string generated from the application object's primary key.
896: -- actid - The function activity (instance id).

Line 906: l_user_name fnd_user.user_name%type;

902: p_activity_id in number,
903: p_command in varchar2,
904: p_resultout out NOCOPY varchar2) is
905: l_person_party_id VARCHAR2 (30);
906: l_user_name fnd_user.user_name%type;
907: l_start_date DATE;
908: l_end_date DATE;
909: BEGIN
910:

Line 976: -- Wrapper around Fnd_user_pkg.delete_username with status as cancelled

972:
973: -- Procedure
974: -- release_userName
975: -- Description
976: -- Wrapper around Fnd_user_pkg.delete_username with status as cancelled
977: -- IN
978: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
979: -- itemkey - A string generated from the application object's primary key.
980: -- actid - The function activity (instance id).

Line 990: l_username FND_USER.user_name%type;

986: p_activity_id in number,
987: p_command in varchar2,
988: p_resultout out NOCOPY varchar2) is
989:
990: l_username FND_USER.user_name%type;
991: l_userid FND_USER.user_id%type;
992:
993: BEGIN
994:

Line 991: l_userid FND_USER.user_id%type;

987: p_command in varchar2,
988: p_resultout out NOCOPY varchar2) is
989:
990: l_username FND_USER.user_name%type;
991: l_userid FND_USER.user_id%type;
992:
993: BEGIN
994:
995: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1411: l_person_party_id fnd_user.person_party_id%type;

1407:
1408: l_event wf_event_t;
1409: l_parameter_list wf_parameter_list_t;
1410: l_event_key number;
1411: l_person_party_id fnd_user.person_party_id%type;
1412: BEGIN
1413:
1414: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 1520: l_user_name fnd_user.user_name%type;

1516: activity_id in number,
1517: command in varchar2,
1518: resultout out NOCOPY varchar2) is
1519:
1520: l_user_name fnd_user.user_name%type;
1521: l_email_address fnd_user.email_address%type;
1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 1521: l_email_address fnd_user.email_address%type;

1517: command in varchar2,
1518: resultout out NOCOPY varchar2) is
1519:
1520: l_user_name fnd_user.user_name%type;
1521: l_email_address fnd_user.email_address%type;
1522: l_person_first_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1523: l_person_last_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1524: l_person_middle_name WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;
1525: l_prefix WF_ACTIVITY_ATTRIBUTES.text_default%TYPE;

Line 1687: from fnd_user

1683:
1684: if (l_requested_for_user_id is not null) then
1685:
1686: select user_name into l_user_name
1687: from fnd_user
1688: where user_id = l_requested_for_user_id;
1689:
1690: l_ad_hoc_role := l_user_name;
1691:

Line 1819: -- Wrapper around Fnd_user_pkg.delete_username with status as cancelled

1815:
1816: -- Procedure
1817: -- cancel_username
1818: -- Description
1819: -- Wrapper around Fnd_user_pkg.delete_username with status as cancelled
1820: -- this is for failed identity verification
1821: -- IN
1822: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1823: -- itemkey - A string generated from the application object's primary key.

Line 1834: l_username FND_USER.user_name%type;

1830: p_item_key in varchar2,
1831: p_activity_id in number,
1832: p_command in varchar2,
1833: p_resultout out NOCOPY varchar2) is
1834: l_username FND_USER.user_name%type;
1835: l_userid FND_USER.user_id%type;
1836: Begin
1837:
1838: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1835: l_userid FND_USER.user_id%type;

1831: p_activity_id in number,
1832: p_command in varchar2,
1833: p_resultout out NOCOPY varchar2) is
1834: l_username FND_USER.user_name%type;
1835: l_userid FND_USER.user_id%type;
1836: Begin
1837:
1838: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1839: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 1889: l_userid FND_USER.user_id%type;

1885: p_item_key in varchar2,
1886: p_activity_id in number,
1887: p_command in varchar2,
1888: p_resultout out NOCOPY varchar2) is
1889: l_userid FND_USER.user_id%type;
1890: Begin
1891:
1892: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1893: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 2051: l_suggested_username FND_USER.USER_NAME%TYPE;

2047: command in varchar2,
2048: resultout out NOCOPY varchar2) is
2049:
2050: l_person_party_id HZ_PARTIES.PARTY_ID%TYPE ;
2051: l_suggested_username FND_USER.USER_NAME%TYPE;
2052:
2053: BEGIN
2054:
2055: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2117: l_username FND_USER.USER_NAME%TYPE;

2113: activity_id in number,
2114: command in varchar2,
2115: resultout out NOCOPY varchar2) is
2116:
2117: l_username FND_USER.USER_NAME%TYPE;
2118: BEGIN
2119:
2120: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2121: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,