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 53: -- FND_USER table.

49: -- Function : is_username_available
50: -- Type : PRIVATE
51: -- Pre_reqs : None
52: -- Description : It will query if username is being used in
53: -- FND_USER table.
54: -- input parameters :
55: -- @param p_username
56: -- Description: username to perform the check
57: -- Required : Y

Line 64: p_username in FND_USER.USER_NAME%TYPE

60: -- true - username is available
61: -- false - username is not available
62: --
63: function is_username_available (
64: p_username in FND_USER.USER_NAME%TYPE
65: ) return boolean;
66:
67: --
68: -- Procedure : update_reg_request

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

128: -- Function : reserve_username
129: -- Type : Private
130: -- Pre_reqs : None
131: -- Description : This API will ...
132: -- 1) Call fnd_user_pkg.reserve_username API to reserve
133: -- the requested username.
134: -- 2) Update the UMX_REG_REQUESTS table with the
135: -- requested for username and requested by username
136: -- (if requested by is null).

Line 153: p_username in FND_USER.USER_NAME%TYPE,

149: -- successfully reserved or null if otherwise.
150: --
151: function reserve_username (
152: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
153: p_username in FND_USER.USER_NAME%TYPE,
154: p_owner in varchar2 default null,
155: p_unencrypted_password in varchar2,
156: p_session_number in number default 0,
157: p_last_logon_date in date default null,

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

159: p_password_date in date default null,
160: p_password_accesses_left in number default null,
161: p_password_lifespan_accesses in number default null,
162: p_password_lifespan_days in number default null,
163: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,
164: p_fax in varchar2 default null,
165: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
166: ) return fnd_user.user_id%type;
167:

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

161: p_password_lifespan_accesses in number default null,
162: p_password_lifespan_days in number default null,
163: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,
164: p_fax in varchar2 default null,
165: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
166: ) return fnd_user.user_id%type;
167:
168: --
169: -- Procedure : approve_username_reg_request

Line 166: ) return fnd_user.user_id%type;

162: p_password_lifespan_days in number default null,
163: p_email_address in FND_USER.EMAIL_ADDRESS%TYPE default null,
164: p_fax in varchar2 default null,
165: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE default null
166: ) return fnd_user.user_id%type;
167:
168: --
169: -- Procedure : approve_username_reg_request
170: -- Type : Private

Line 174: -- fnd_user_pkg.activate_user_account.

170: -- Type : Private
171: -- Pre_reqs : None
172: -- Description : This API will ...
173: -- 1) Activiate the user account by calling
174: -- fnd_user_pkg.activate_user_account.
175: -- 2) Set the status code to "APPROVED" in
176: -- UMX_REG_REQUESTS table.
177: --
178: -- This API should be called from Self-Service Registration or

Line 203: p_username in FND_USER.USER_NAME%TYPE,

199: -- Description :
200: --
201: Procedure approve_username_reg_request (
202: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
203: p_username in FND_USER.USER_NAME%TYPE,
204: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
205: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
206: p_end_date in FND_USER.END_DATE%TYPE default null
207: );

Line 204: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,

200: --
201: Procedure approve_username_reg_request (
202: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
203: p_username in FND_USER.USER_NAME%TYPE,
204: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
205: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
206: p_end_date in FND_USER.END_DATE%TYPE default null
207: );
208:

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

201: Procedure approve_username_reg_request (
202: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
203: p_username in FND_USER.USER_NAME%TYPE,
204: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
205: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
206: p_end_date in FND_USER.END_DATE%TYPE default null
207: );
208:
209: --

Line 206: p_end_date in FND_USER.END_DATE%TYPE default null

202: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
203: p_username in FND_USER.USER_NAME%TYPE,
204: p_person_party_id in FND_USER.PERSON_PARTY_ID%TYPE,
205: p_start_date in FND_USER.START_DATE%TYPE default sysdate,
206: p_end_date in FND_USER.END_DATE%TYPE default null
207: );
208:
209: --
210: -- Procedure : reject_username_reg_request

Line 234: p_user_id in FND_USER.USER_ID%TYPE,

230: -- Description :
231: --
232: Procedure reject_username_reg_request (
233: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
234: p_user_id in FND_USER.USER_ID%TYPE,
235: p_username in FND_USER.USER_NAME%TYPE
236: );
237:
238: --

Line 235: p_username in FND_USER.USER_NAME%TYPE

231: --
232: Procedure reject_username_reg_request (
233: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
234: p_user_id in FND_USER.USER_ID%TYPE,
235: p_username in FND_USER.USER_NAME%TYPE
236: );
237:
238: --
239: -- Procedure : cancel_username_reg_request

Line 263: p_user_id in FND_USER.USER_ID%TYPE,

259: -- Description :
260: --
261: Procedure cancel_username_reg_request (
262: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
263: p_user_id in FND_USER.USER_ID%TYPE,
264: p_username in FND_USER.USER_NAME%TYPE
265: );
266:
267: --

Line 264: p_username in FND_USER.USER_NAME%TYPE

260: --
261: Procedure cancel_username_reg_request (
262: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
263: p_user_id in FND_USER.USER_ID%TYPE,
264: p_username in FND_USER.USER_NAME%TYPE
265: );
266:
267: --
268: -- Procedure : approve_reg_request

Line 341: p_requester_user_id in FND_USER.USER_ID%TYPE,

337: -- x_justification
338: -- Description: Justification
339: --
340: Procedure get_pend_acct_info_with_userid (
341: p_requester_user_id in FND_USER.USER_ID%TYPE,
342: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
343: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
344: x_approver_name out NOCOPY varchar2,
345: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,

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

339: --
340: Procedure get_pend_acct_info_with_userid (
341: p_requester_user_id in FND_USER.USER_ID%TYPE,
342: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
343: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
344: x_approver_name out NOCOPY varchar2,
345: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
346: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
347: x_active_from out NOCOPY varchar2,

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

341: p_requester_user_id in FND_USER.USER_ID%TYPE,
342: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
343: x_requested_for_username out NOCOPY FND_USER.USER_NAME%TYPE,
344: x_approver_name out NOCOPY varchar2,
345: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
346: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
347: x_active_from out NOCOPY varchar2,
348: x_active_to out NOCOPY varchar2,
349: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE);

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

378: --
379: Procedure get_pend_acct_info_with_reqid (
380: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
381: x_approver_name out NOCOPY varchar2,
382: x_approver_email_address out NOCOPY FND_USER.EMAIL_ADDRESS%TYPE,
383: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,
384: x_active_from out NOCOPY varchar2,
385: x_active_to out NOCOPY varchar2,
386: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE);

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

434: -- x_errmsg: Error Message
435: -- x_errstack: Error Stack
436: --
437: --
438: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
439: x_itemtype out nocopy wf_items.item_type%type,
440: x_itemkey out nocopy wf_items.item_key%type,
441: x_status out nocopy varchar2,
442: x_result out nocopy varchar2,

Line 476: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2;

472: --
473: -- Output Parameter:
474: -- It will return 'Y' if pending account has error and 'N' if otherwise.
475: --
476: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2;
477:
478: -- Function
479: -- getNextApproverPvt
480: --