DBA Data[Home] [Help]

APPS.FND_LDAP_WRAPPER dependencies on FND_USER

Line 58: ** Desc : This procedure takes a fnd_user username as input. It retrieves

54: -------------------------------------------------------------------------------
55: /*
56: ** Name : synch_user_from_LDAP
57: ** Type : Public, FND Internal
58: ** Desc : This procedure takes a fnd_user username as input. It retrieves
59: ** the user attributes from OID and tries to create a new TCA record. If
60: ** one already exists then it simply updates the existing record.
61: ** If application is not SSO enabled, it simply returns FND_LDAP_WRAPPER. G_SUCCESS
62: ** without updating or creating a record in TCA.

Line 72: procedure synch_user_from_LDAP(p_user_name in fnd_user.user_name%type

68: ** It retunrns FND_LDAP_WRAPPER.G_FAILURE if
69: ** - application is SSO enabled and TCA update/creation fails.
70: ** Notes :
71: */
72: procedure synch_user_from_LDAP(p_user_name in fnd_user.user_name%type
73: , p_result out nocopy pls_integer);
74: --
75: -------------------------------------------------------------------------------
76: /*

Line 86: ** user in OID so that caller of the API (FND_USER_PKG) can proceed.

82: *8 If the profile is enabled, it simply links the users and returns
83: ** G_SUCCESS with appropriate x_user_guid and x_password. If the
84: ** profile is disabled, it returns with G_FAILURE. If application is
85: ** not SSO enabled, it simply returns G_SUCCESS without creaing a
86: ** user in OID so that caller of the API (FND_USER_PKG) can proceed.
87: ** Pre-Reqs :
88: ** Parameters:
89: ** p_user_name: user name
90: ** p_password: unencrypted password

Line 133: ** fnd_user is now being rejected/released, *and* the OID user is

129: /*
130: ** Name : delete_user
131: ** Type : Public, FND Internal
132: ** Desc : If the OID user was created from the same instance where the
133: ** fnd_user is now being rejected/released, *and* the OID user is
134: ** still inactive, then we will delete it.If either of these
135: ** criteria is not fulfilled, we can't touch the OID user even if
136: ** we delete the pending FND_USER record.
137: ** If application is not SSO enabled, it simply returns G_SUCCESS

Line 136: ** we delete the pending FND_USER record.

132: ** Desc : If the OID user was created from the same instance where the
133: ** fnd_user is now being rejected/released, *and* the OID user is
134: ** still inactive, then we will delete it.If either of these
135: ** criteria is not fulfilled, we can't touch the OID user even if
136: ** we delete the pending FND_USER record.
137: ** If application is not SSO enabled, it simply returns G_SUCCESS
138: ** without deleting the user in OID
139: ** Pre-Reqs :
140: ** Parameters: p_user_name : user name to be deleted

Line 149: procedure delete_user(p_user_guid in fnd_user.user_guid%type,

145: ** FND_LDAP_WRAPPER.G_FAILURE if
146: ** - application is SSO enabled and user deletion fails
147: ** Notes :
148: */
149: procedure delete_user(p_user_guid in fnd_user.user_guid%type,
150: x_result out nocopy pls_integer);
151: --
152: -------------------------------------------------------------------------------
153: /*

Line 159: ** Pre-Reqs : User is already in FND_USER table

155: ** Type : Public, FND Internal
156: ** Desc : This function changes OID password for a user in OID.
157: ** If application is not SSO enabled, it simply returns
158: ** G_SUCCESS without changing password in OID
159: ** Pre-Reqs : User is already in FND_USER table
160: ** Parameters: p_user_guid: user GUID
161: ** p_user_name : user name
162: ** p_expire_password :
163: ** - fnd_ldap_wrapper.G_TRUE if

Line 208: ** Desc : This procedure gets the attribute of the OID user linked to FND_USER

204: -------------------------------------------------------------------------------
205: /*
206: ** Name : get_orcl_nickname
207: ** Type : Public, FND Internal
208: ** Desc : This procedure gets the attribute of the OID user linked to FND_USER
209: ** which is specified as the nickname attribute.
210: ** If the fnd user is not linked to OID user or if the application is not SSO enabled,
211: ** it returns null.
212: ** Pre-Reqs :

Line 210: ** If the fnd user is not linked to OID user or if the application is not SSO enabled,

206: ** Name : get_orcl_nickname
207: ** Type : Public, FND Internal
208: ** Desc : This procedure gets the attribute of the OID user linked to FND_USER
209: ** which is specified as the nickname attribute.
210: ** If the fnd user is not linked to OID user or if the application is not SSO enabled,
211: ** it returns null.
212: ** Pre-Reqs :
213: ** Parameters:
214: **

Line 217: function get_ldap_user_name(p_user_name in fnd_user.user_name%type) return varchar2;

213: ** Parameters:
214: **
215: ** Notes :
216: */
217: function get_ldap_user_name(p_user_name in fnd_user.user_name%type) return varchar2;
218: --
219: -------------------------------------------------------------------------------
220: /*
221: ** Name : get_orclappname

Line 260: ** Desc : This procedure unsubscribes the user in OID if there is no other FND user linked

256: -------------------------------------------------------------------------------
257: /*
258: ** Name : unlink_user
259: ** Type : Public, FND Internal
260: ** Desc : This procedure unsubscribes the user in OID if there is no other FND user linked
261: ** to the same OID user
262: ** If no user exists with the same name, it returns with G_FAILURE.
263: ** If application is not SSO enabled, it
264: ** simply returns G_SUCCESS without unlinking the user in OID

Line 278: procedure unlink_user(p_user_guid in fnd_user.user_guid%type,

274: ** FND_LDAP_WRAPPER.G_FAILURE if
275: ** - application is SSO enabled and user unlinking fails
276: ** Notes :
277: */
278: procedure unlink_user(p_user_guid in fnd_user.user_guid%type,
279: p_user_name in varchar2,
280: x_result out nocopy pls_integer);
281: --
282: -------------------------------------------------------------------------------

Line 290: ** Pre-Reqs : User is already in FND_USER table

286: ** Desc : This procedure updates a user in OID for the application it is
287: ** invoked from. If the user doesn't exist, it
288: ** returns with G_FAILURE. If application is not SSO enabled, it
289: ** simply returns G_SUCCESS without doing anything.
290: ** Pre-Reqs : User is already in FND_USER table
291: ** Parameters:
292: ** p_user_guid: user GUID
293: ** p_user_name: user name
294: ** p_password: unencrypted password

Line 364: ** x_fnd_user fnd_ldap_wrapper.G_SUCCESS if FND operations is allowed else fnd_ldap_wrapper.G_FAILURE

360: ** p_user_id This represents the user_id of the user whose password is being changed.
361: ** If none provided use Site level profile
362: ** x_attribute The attribute on which operation is being performed. If not passed then
363: ** result will be positive even if a single attribute is allowed.
364: ** x_fnd_user fnd_ldap_wrapper.G_SUCCESS if FND operations is allowed else fnd_ldap_wrapper.G_FAILURE
365: ** x_oid fnd_ldap_wrapper.G_SUCCESS if OID operations is allowed else fnd_ldap_wrapper.G_FAILURE
366: **
367: ** Notes :
368: */

Line 375: x_fnd_user out nocopy pls_integer,

371: p_operation in pls_integer,
372: p_user_name in varchar2 default NULL,
373: p_user_id in number default NULL,
374: x_attribute in out nocopy varchar2,
375: x_fnd_user out nocopy pls_integer,
376: x_oid out nocopy pls_integer);
377: --
378: -------------------------------------------------------------------------------
379: /*

Line 383: x_fnd_user out nocopy pls_integer,

379: /*
380: To do
381: */
382: procedure is_operation_allowed(p_realm in varchar2, p_operation in pls_integer,
383: x_fnd_user out nocopy pls_integer,
384: x_oid out nocopy pls_integer);
385: --
386: -------------------------------------------------------------------------------
387: /*

Line 452: ** FND_USER and sets the profiles APPS_SSO_LOCAL_LOGIN and

448: * ** Pre-Reqs :
449: * ** Parameters:
450: * **
451: * ** Notes : API unlinks the EBS user by removing the user_guid from
452: ** FND_USER and sets the profiles APPS_SSO_LOCAL_LOGIN and
453: ** APPS_SSO_LDAP_SYNC accordingly
454: * ** But this may change in the future.
455: * */
456: procedure unlink_ebiz_user(p_user_name in varchar2);