APPS.FND_OID_PLUG dependencies on FND_USER

Line 177: function get_username_from_guid(p_user_guid IN fnd_user.user_guid%type ) return varchar2;

173:
174: /*
175: * FOWARD declarations
176: */
177: function get_username_from_guid(p_user_guid IN fnd_user.user_guid%type ) return varchar2;
178:
179:
180:
181:

Line 1140: * 1- If the user exists in FND_USER and has a GUID return get_realm_from_guid

1136: * Except when you rally want the realm for an EXISTING user.
1137: * Preffer getRealmDNNewUser for new users
1138: *
1139: * CALCULATION steps
1140: * 1- If the user exists in FND_USER and has a GUID return get_realm_from_guid
1141: * If guid is incorrec raise an error
1142: * 2- IF user does not exist in FND_USER user FND_LDAP_USER.Search(username,ouy guid)
1143: * This function can be costly, but worst. It is possible on multiples realms
1144: * to have NON-UNIQUE usernames (non-wide uniqeu attributes, or differet nna ).

Line 1142: * 2- IF user does not exist in FND_USER user FND_LDAP_USER.Search(username,ouy guid)

1138: *
1139: * CALCULATION steps
1140: * 1- If the user exists in FND_USER and has a GUID return get_realm_from_guid
1141: * If guid is incorrec raise an error
1142: * 2- IF user does not exist in FND_USER user FND_LDAP_USER.Search(username,ouy guid)
1143: * This function can be costly, but worst. It is possible on multiples realms
1144: * to have NON-UNIQUE usernames (non-wide uniqeu attributes, or differet nna ).
1145: * In that case ANY of those will be returned.
1146: *

Line 1152: l_guid FND_USER.user_guid%type;

1148:
1149: function getRealmDN(username varchar2) return varchar2 AS
1150: result varchar2(4000);
1151: l_module_source varchar2(1000) ;
1152: l_guid FND_USER.user_guid%type;
1153: user_rec FND_LDAP_USER.ldap_user_type;
1154: BEGIN
1155: validateVersion;
1156:

Line 1166: select user_guid into l_guid from FND_USER

1162: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin '||username);
1163: end if;
1164:
1165: BEGIN
1166: select user_guid into l_guid from FND_USER
1167: where user_name=username;
1168: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1169: then
1170: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Found on FND_USER guid: '||NVL(l_guid,'**NULL*'));

Line 1170: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Found on FND_USER guid: '||NVL(l_guid,'**NULL*'));

1166: select user_guid into l_guid from FND_USER
1167: where user_name=username;
1168: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1169: then
1170: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Found on FND_USER guid: '||NVL(l_guid,'**NULL*'));
1171: end if;
1172:
1173: EXCEPTION WHEN NO_DATA_FOUND THEN
1174: l_guid:=null;

Line 1681: function get_username_from_guid(p_user_guid IN fnd_user.user_guid%type ) return varchar2

1677:
1678: end get_realm_from_user_dn;
1679:
1680:
1681: function get_username_from_guid(p_user_guid IN fnd_user.user_guid%type ) return varchar2
1682: is
1683: ldap dbms_ldap.session;
1684: dummy pls_integer;
1685: user_dn varchar2(4000);