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 UMX_REG_REQUESTS

Line 1: PACKAGE UMX_REG_REQUESTS_PVT AS

1: PACKAGE UMX_REG_REQUESTS_PVT AS
2: /* $Header: UMXVRRSS.pls 120.2 2006/09/11 18:35:53 kching noship $ */
3:
4: --
5: -- RECORD: REG_REQUEST_TYPE

Line 30: REG_REQUEST_ID UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

26: -- WF_EVENT_NAME : The event name of the notification event
27: -- EMAIL_VERIFICATION_FLAG : Flag for email verfication
28: --
29: TYPE REG_REQUEST_TYPE IS RECORD (
30: REG_REQUEST_ID UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,
32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,

Line 31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,

27: -- EMAIL_VERIFICATION_FLAG : Flag for email verfication
28: --
29: TYPE REG_REQUEST_TYPE IS RECORD (
30: REG_REQUEST_ID UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,
32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,
35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,

Line 32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,

28: --
29: TYPE REG_REQUEST_TYPE IS RECORD (
30: REG_REQUEST_ID UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,
32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,
35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,
36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,

Line 33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,

29: TYPE REG_REQUEST_TYPE IS RECORD (
30: REG_REQUEST_ID UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,
32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,
35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,
36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,
37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,

Line 34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,

30: REG_REQUEST_ID UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,
31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,
32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,
35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,
36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,
37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,
38: REQUESTED_END_DATE DATE DEFAULT NULL,

Line 35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,

31: REG_SERVICE_TYPE UMX_REG_REQUESTS.REG_SERVICE_TYPE%TYPE,
32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,
35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,
36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,
37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,
38: REQUESTED_END_DATE DATE DEFAULT NULL,
39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,

Line 36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,

32: STATUS_CODE UMX_REG_REQUESTS.STATUS_CODE%TYPE,
33: REQUESTED_BY_USERID UMX_REG_REQUESTS.REQUESTED_BY_USER_ID%TYPE DEFAULT NULL,
34: REQUESTED_FOR_USER_ID UMX_REG_REQUESTS.REQUESTED_FOR_USER_ID%TYPE DEFAULT NULL,
35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,
36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,
37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,
38: REQUESTED_END_DATE DATE DEFAULT NULL,
39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,
40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,

Line 39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,

35: REQUESTED_FOR_PARTY_ID UMX_REG_REQUESTS.REQUESTED_FOR_PARTY_ID%TYPE DEFAULT NULL,
36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,
37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,
38: REQUESTED_END_DATE DATE DEFAULT NULL,
39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,
40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,
41: AME_APPLICATION_ID UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE DEFAULT NULL,
42: AME_TRANSACTION_TYPE_ID UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE DEFAULT NULL,
43: JUSTIFICATION UMX_REG_REQUESTS.JUSTIFICATION%TYPE DEFAULT NULL,

Line 40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,

36: REQUESTED_USERNAME UMX_REG_REQUESTS.REQUESTED_USERNAME%TYPE DEFAULT NULL,
37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,
38: REQUESTED_END_DATE DATE DEFAULT NULL,
39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,
40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,
41: AME_APPLICATION_ID UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE DEFAULT NULL,
42: AME_TRANSACTION_TYPE_ID UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE DEFAULT NULL,
43: JUSTIFICATION UMX_REG_REQUESTS.JUSTIFICATION%TYPE DEFAULT NULL,
44: WF_EVENT_NAME WF_EVENTS.NAME%TYPE DEFAULT NULL,

Line 41: AME_APPLICATION_ID UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE DEFAULT NULL,

37: REQUESTED_START_DATE DATE DEFAULT SYSDATE,
38: REQUESTED_END_DATE DATE DEFAULT NULL,
39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,
40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,
41: AME_APPLICATION_ID UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE DEFAULT NULL,
42: AME_TRANSACTION_TYPE_ID UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE DEFAULT NULL,
43: JUSTIFICATION UMX_REG_REQUESTS.JUSTIFICATION%TYPE DEFAULT NULL,
44: WF_EVENT_NAME WF_EVENTS.NAME%TYPE DEFAULT NULL,
45: EMAIL_VERIFICATION_FLAG UMX_REG_SERVICES_B.EMAIL_VERIFICATION_FLAG%TYPE DEFAULT 'N'

Line 42: AME_TRANSACTION_TYPE_ID UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE DEFAULT NULL,

38: REQUESTED_END_DATE DATE DEFAULT NULL,
39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,
40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,
41: AME_APPLICATION_ID UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE DEFAULT NULL,
42: AME_TRANSACTION_TYPE_ID UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE DEFAULT NULL,
43: JUSTIFICATION UMX_REG_REQUESTS.JUSTIFICATION%TYPE DEFAULT NULL,
44: WF_EVENT_NAME WF_EVENTS.NAME%TYPE DEFAULT NULL,
45: EMAIL_VERIFICATION_FLAG UMX_REG_SERVICES_B.EMAIL_VERIFICATION_FLAG%TYPE DEFAULT 'N'
46: );

Line 43: JUSTIFICATION UMX_REG_REQUESTS.JUSTIFICATION%TYPE DEFAULT NULL,

39: WF_ROLE_NAME UMX_REG_REQUESTS.WF_ROLE_NAME%TYPE DEFAULT NULL,
40: REG_SERVICE_CODE UMX_REG_REQUESTS.REG_SERVICE_CODE%TYPE DEFAULT NULL,
41: AME_APPLICATION_ID UMX_REG_REQUESTS.AME_APPLICATION_ID%TYPE DEFAULT NULL,
42: AME_TRANSACTION_TYPE_ID UMX_REG_REQUESTS.AME_TRANSACTION_TYPE_ID%TYPE DEFAULT NULL,
43: JUSTIFICATION UMX_REG_REQUESTS.JUSTIFICATION%TYPE DEFAULT NULL,
44: WF_EVENT_NAME WF_EVENTS.NAME%TYPE DEFAULT NULL,
45: EMAIL_VERIFICATION_FLAG UMX_REG_SERVICES_B.EMAIL_VERIFICATION_FLAG%TYPE DEFAULT 'N'
46: );
47:

Line 72: -- into the UMX_REG_REQUESTS table.

68: -- Procedure : update_reg_request
69: -- Type : Private
70: -- Pre_reqs : None
71: -- Description : This API will create a registration request
72: -- into the UMX_REG_REQUESTS table.
73: -- Before registration request can be inserted into
74: -- UMX_REG_REQUESTS table, this API will check to see
75: -- if the requester already have a valid association to
76: -- this access role in wf_local_user_role. This API will

Line 74: -- UMX_REG_REQUESTS table, this API will check to see

70: -- Pre_reqs : None
71: -- Description : This API will create a registration request
72: -- into the UMX_REG_REQUESTS table.
73: -- Before registration request can be inserted into
74: -- UMX_REG_REQUESTS table, this API will check to see
75: -- if the requester already have a valid association to
76: -- this access role in wf_local_user_role. This API will
77: -- return null if there is a valid access role.
78: -- Input Parameters (Mandatory):

Line 102: -- into the UMX_REG_REQUESTS table.

98: -- Procedure : delete_reg_request
99: -- Type : Private
100: -- Pre_reqs : None
101: -- Description : This API will delete a registration request
102: -- into the UMX_REG_REQUESTS table.
103: -- Before registration request can be inserted into
104: -- UMX_REG_REQUESTS table, this API will check to see
105: -- if the requester already have a valid association to
106: -- this access role in wf_local_user_role. This API will

Line 104: -- UMX_REG_REQUESTS table, this API will check to see

100: -- Pre_reqs : None
101: -- Description : This API will delete a registration request
102: -- into the UMX_REG_REQUESTS table.
103: -- Before registration request can be inserted into
104: -- UMX_REG_REQUESTS table, this API will check to see
105: -- if the requester already have a valid association to
106: -- this access role in wf_local_user_role. This API will
107: -- return null if there is a valid access role.
108: -- Input Parameters (Mandatory):

Line 124: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE

120: -- Output Parameters:
121: -- x_reg_request_id: Registration Request ID
122: --
123: procedure delete_reg_request (
124: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
125: );
126:
127: --
128: -- Function : reserve_username

Line 134: -- 2) Update the UMX_REG_REQUESTS table with the

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).
137: --
138: -- This API should be called when user requests a user

Line 152: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

148: -- Description : It will either return the user ID if the username is
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,

Line 176: -- UMX_REG_REQUESTS table.

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
179: -- Admin Creation.
180: -- Input Parameters :

Line 202: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

198: -- None
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

Line 233: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

229: -- None
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:

Line 262: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

258: -- None
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:

Line 272: -- the Reg Request in UMX_REG_REQUESTS table.

268: -- Procedure : approve_reg_request
269: -- Type : Private
270: -- Pre_reqs : None
271: -- Description : This API will approve_reject_reg_request to approve
272: -- the Reg Request in UMX_REG_REQUESTS table.
273: --
274: -- This API should be called from ART or SMART.
275: -- Input Parameters :
276: -- @param p_reg_request_id

Line 284: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE

280: -- None
281: -- Description :
282: --
283: Procedure approve_reg_request (
284: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
285: );
286:
287: --
288: -- Procedure : reject_reg_request

Line 292: -- the Reg Request in UMX_REG_REQUESTS table.

288: -- Procedure : reject_reg_request
289: -- Type : Private
290: -- Pre_reqs : None
291: -- Description : This API will approve_reject_reg_request to reject
292: -- the Reg Request in UMX_REG_REQUESTS table.
293: --
294: -- This API should be called from ART or SMART.
295: -- Input Parameters :
296: -- @param p_reg_request_id

Line 304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE

300: -- None
301: -- Description :
302: --
303: Procedure reject_reg_request (
304: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
305: );
306:
307: --
308: -- Procedure : get_pend_acct_info_with_userid

Line 342: x_reg_request_id out NOCOPY UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

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,
346: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,

Line 346: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%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);
350:

Line 349: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE);

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);
350:
351: --
352: -- Procedure : get_pend_acct_info_with_reqid
353: -- Type : Private

Line 380: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE,

376: -- x_justification
377: -- Description: Justification
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,

Line 383: x_status_code out NOCOPY UMX_REG_REQUESTS.STATUS_CODE%TYPE,

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);
387:

Line 386: x_justification out NOCOPY UMX_REG_REQUESTS.JUSTIFICATION%TYPE);

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);
387:
388: --
389: -- Procedure : get_error_wf_info
390: -- Type : Private

Line 461: function is_pend_request_error (p_reg_request_id in umx_reg_requests.reg_request_id%type) return varchar2;

457: --
458: -- Output Parameter:
459: -- It will return 'Y' if pending account has error and 'N' if otherwise.
460: --
461: function is_pend_request_error (p_reg_request_id in umx_reg_requests.reg_request_id%type) return varchar2;
462:
463: --
464: -- Function : is_pend_account_error
465: -- Type : Private

Line 491: END UMX_REG_REQUESTS_PVT;

487: -- l_next_approver - result of the process based on which the next step is followed
488: function getNextApproverPvt (p_ame_application_id in varchar2,
489: p_ame_transaction_type_id in varchar2,
490: p_reg_request_id in varchar2) return ame_util.approverRecord2;
491: END UMX_REG_REQUESTS_PVT;