APPS.JTF_UM_USER_ADMIN_PVT dependencies on FND_USER

Line 21: * description: FND User ID to return the status code

17: * Description : Return the status code of a user.
18: * Parameters :
19: * input parameters
20: * p_userid
21: * description: FND User ID to return the status code
22: * required : Y
23: * output parameters
24: * status code
25: * description: The usertype status code of the user.

Line 60: * description: FND User name

56: * Description : Return the user id of a user.
57: * Parameters :
58: * input parameters
59: * p_username
60: * description: FND User name
61: * required : Y
62: * output parameters
63: * userid
64: * description: The userid of the provided username

Line 74: from fnd_user

70: l_userid number;
71:
72: cursor getUserIDCursor is
73: select user_id
74: from fnd_user
75: where user_name = p_username
76: and (nvl (end_date, sysdate + 1) > sysdate or
77: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;
78:

Line 105: * - call FND_USER_PKG.DisableUser API

101: * Pre_reqs : WF_DIRECTORY.CreateAdHocUser and
102: * WF_DIRECTORY.SetAdHocUserAttr
103: * Description : Inactive an user with these Scenarios
104: * 1. Usertype Request is PENDING
105: * - call FND_USER_PKG.DisableUser API
106: * - Kill the usertype WF
107: * - Set the usertype_reg table status to REJECTED
108: * - Find all the *PENDING* Enrollments, and REJECT these
109: * (believe we have a USERTYPE_REJECTED status or similar)

Line 114: * - call FND_USER_PKG.DisableUser API

110: * in the subscription_reg table
111: * - revoke the "PENDING_APPROVAL" responsibility
112: *
113: * 2. Usertype Request is UPGRADE_PENDING
114: * - call FND_USER_PKG.DisableUser API
115: * - Set the usertype_reg table status to REJECTED
116: * - Reject the old approval task
117: *
118: * 3. Usertype Request is APPROVED or UPGRADE

Line 119: * - call FND_USER_PKG.DisableUser API

115: * - Set the usertype_reg table status to REJECTED
116: * - Reject the old approval task
117: *
118: * 3. Usertype Request is APPROVED or UPGRADE
119: * - call FND_USER_PKG.DisableUser API
120: * - Do not set the usertype_reg table status (leave as APPROVED)
121: * - Find all the *PENDING* Enrollments, and REJECT these (REJECTED status)
122: * in the subscription_reg table
123: * - Do not change the status for any approved / rejected enrollments

Line 173: from fnd_user

169: and nvl (effective_end_date, sysdate + 1) > sysdate;
170:
171: cursor getPartyID is
172: select customer_id
173: from fnd_user
174: where user_id = l_userid
175: and (nvl (end_date, sysdate + 1) > sysdate OR
176: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;
177:

Line 347: FND_USER_PKG.DisableUser (p_username);

343:
344: END IF;
345:
346: -- End date the user with the FND_API
347: FND_USER_PKG.DisableUser (p_username);
348:
349: --
350: -- End of API body
351: --