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.FND_LDAP_USER dependencies on FND_USER

Line 16: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

12: -- End of Package Globals
13: --
14: -------------------------------------------------------------------------------
15:
16: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
17: function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid raw) return pls_integer;
18: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
19: procedure ProcessLoadedLpadUserRecord (p_ldap_user IN OUT nocopy fnd_ldap_user.ldap_user_type ,realmDN in varchar2 ,dn_z in varchar2 );
20: --function CanSync ( p_user_id in pls_integer, p_user_name in varchar2 ) return boolean;

Line 18: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;

14: -------------------------------------------------------------------------------
15:
16: function delete_user_nodes(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
17: function delete_user_subscription(p_ldap_session in dbms_ldap.session, guid raw) return pls_integer;
18: function delete_uniquemember(p_ldap_session in dbms_ldap.session, p_orclguid in fnd_user.user_guid%type) return pls_integer;
19: procedure ProcessLoadedLpadUserRecord (p_ldap_user IN OUT nocopy fnd_ldap_user.ldap_user_type ,realmDN in varchar2 ,dn_z in varchar2 );
20: --function CanSync ( p_user_id in pls_integer, p_user_name in varchar2 ) return boolean;
21: function get_user_guid(p_ldap_session in dbms_ldap.session, p_user_name in varchar2, dn out nocopy varchar2) return raw ;
22: function isValueOf( u ldap_user_type, fld in varchar2, val in varchar2 ) return boolean;

Line 100: PROCEDURE delete_user(ldapSession in dbms_ldap.session, p_user_guid in fnd_user.user_guid%type ,

96: end translate_ldap_error;
97:
98: --
99: -------------------------------------------------------------------------------
100: PROCEDURE delete_user(ldapSession in dbms_ldap.session, p_user_guid in fnd_user.user_guid%type ,
101: x_result out nocopy pls_integer,
102: p_forced in boolean default false) is
103:
104:

Line 124: l_orclguid fnd_user.user_guid%type;

120: l_fnd_op pls_integer;
121: l_oid_op pls_integer;
122: sso_registration_failure exception;
123: -- l_apps_user_key_type fnd_oid_util.apps_user_key_type;
124: l_orclguid fnd_user.user_guid%type;
125: begin
126:
127: -- initializing
128: l_module_source := G_MODULE_SOURCE || 'delete_user: ';

Line 136: --scheruku :: Added logic to get orclguid from fnd_user

132: then
133: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
134: end if;
135:
136: --scheruku :: Added logic to get orclguid from fnd_user
137: -- l_apps_user_key_type := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
138: -- l_orclguid := l_apps_user_key_type.user_guid;
139: l_orclguid := p_user_guid;
140:

Line 137: -- l_apps_user_key_type := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);

133: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
134: end if;
135:
136: --scheruku :: Added logic to get orclguid from fnd_user
137: -- l_apps_user_key_type := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
138: -- l_orclguid := l_apps_user_key_type.user_guid;
139: l_orclguid := p_user_guid;
140:
141: if(l_orclguid IS NULL)

Line 146: 'NULL guid in FND_USER');

142: then
143: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
144: then
145: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
146: 'NULL guid in FND_USER');
147: end if;
148: x_result := fnd_ldap_util.G_FAILURE;
149: else
150: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 153: 'FND_USER GUID::'||l_orclguid);

149: else
150: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
151: then
152: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
153: 'FND_USER GUID::'||l_orclguid);
154: end if;
155: l_filter := 'orclguid='||l_orclguid;
156: --ldapSession := fnd_ldap_util.get_oid_session;
157: --searchNodes := fnd_ldap_util.get_search_nodes;

Line 225: end if;-- fnd_user guid null check if block ends here

221:
222: if (x_result = dbms_ldap.SUCCESS) then
223: x_result := fnd_ldap_util.G_SUCCESS;
224: end if;
225: end if;-- fnd_user guid null check if block ends here
226:
227: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
228: then
229: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End');

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

238: x_result := fnd_ldap_util.G_FAILURE;
239:
240: end delete_user;
241:
242: procedure delete_user(p_user_guid in fnd_user.user_guid%type ,
243: x_result out nocopy pls_integer,
244: p_forced in boolean ) is
245:
246: ldapSession dbms_ldap.session;

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

249: ldapSession := fnd_ldap_util.c_get_oid_session(dummy);
250: delete_user(ldapSession,p_user_guid,x_result,p_forced);
251: fnd_ldap_util.c_unbind(ldapSession,dummy);
252: end delete_user;
253: procedure delete_user(p_user_guid in fnd_user.user_guid%type ,
254: x_result out nocopy pls_integer ) is
255:
256: ldapSession dbms_ldap.session;
257: dummy pls_integer;

Line 361: l_user_id fnd_user.user_id%type;

357: p_old_user_name in varchar2,
358: p_new_user_name in varchar2,
359: x_result out nocopy pls_integer) is
360: l_module_source VARCHAR2(256);
361: l_user_id fnd_user.user_id%type;
362: l_to_synch BOOLEAN;
363: ldap dbms_ldap.session;
364: flag pls_integer;
365: user_rec FND_LDAP_USER.ldap_user_type;

Line 399: -- this procedure asumes that name was already changed on FND_USER (not commit maybe)

395: x_result:=fnd_ldap_util.G_SUCCESS;
396: RETURN;
397: END IF;
398: -- look for the user_id.
399: -- this procedure asumes that name was already changed on FND_USER (not commit maybe)
400: BEGIN
401: SELECT user_id
402: INTO l_user_id
403: FROM FND_USER

Line 403: FROM FND_USER

399: -- this procedure asumes that name was already changed on FND_USER (not commit maybe)
400: BEGIN
401: SELECT user_id
402: INTO l_user_id
403: FROM FND_USER
404: WHERE user_guid=p_user_guid
405: AND user_name =p_old_user_name;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN

Line 438: x_fnd_user => x_fnd,

434: p_direction => FND_LDAP_WRAPPER.G_EBIZ_TO_OID,
435: p_entity => FND_LDAP_WRAPPER.G_IDENTITY,
436: p_operation => FND_LDAP_WRAPPER.G_MODIFY,
437: p_attribute => nna,
438: x_fnd_user => x_fnd,
439: x_oid => x_oid,
440: p_user_name => user_rec.user_name,
441: p_realm_dn => user_rec.realmDN);
442:

Line 555: -- If its SSO set the FND_USER password to external

551: -- if it returns failure put a FND_SSO_USER_EXIST on the errors tack
552: --
553: -- 2) Retreive its guid
554: -- 3) Loook at the APPS_SSO_LOCAL_LOGIN ( user=-1 level, which may or may not be site)
555: -- If its SSO set the FND_USER password to external
556: -- Any EXCEPTION will be logged and passed up
557:
558:
559: FUNCTION create_ldap_user (

Line 809: procedure decode_dates(p_user_name in varchar2, p_start_date in date, p_end_date in date, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type) is

805:
806: end create_user_subscription;
807: --
808: -------------------------------------------------------------------------------
809: procedure decode_dates(p_user_name in varchar2, p_start_date in date, p_end_date in date, x_orclisEnabled out nocopy varchar2, x_user_id out nocopy fnd_user.user_id%type) is
810:
811: -- bug 12925276 : to_date(null) is returned instead of null to indicate that current return type is date and hence make decode() function correctly.
812: -- Also see base bug 13654885 and bug 1124610
813: cursor fnd_dates is

Line 814: select user_id, decode(p_start_date, fnd_user_pkg.null_date, to_date(null),

810:
811: -- bug 12925276 : to_date(null) is returned instead of null to indicate that current return type is date and hence make decode() function correctly.
812: -- Also see base bug 13654885 and bug 1124610
813: cursor fnd_dates is
814: select user_id, decode(p_start_date, fnd_user_pkg.null_date, to_date(null),
815: null, start_date,
816: p_start_date) l_start_date,
817: decode(p_end_date, fnd_user_pkg.null_date, to_date(null),
818: null, end_date,

Line 817: decode(p_end_date, fnd_user_pkg.null_date, to_date(null),

813: cursor fnd_dates is
814: select user_id, decode(p_start_date, fnd_user_pkg.null_date, to_date(null),
815: null, start_date,
816: p_start_date) l_start_date,
817: decode(p_end_date, fnd_user_pkg.null_date, to_date(null),
818: null, end_date,
819: p_end_date) l_end_date
820: from fnd_user
821: where user_name = p_user_name;

Line 820: from fnd_user

816: p_start_date) l_start_date,
817: decode(p_end_date, fnd_user_pkg.null_date, to_date(null),
818: null, end_date,
819: p_end_date) l_end_date
820: from fnd_user
821: where user_name = p_user_name;
822:
823: l_rec fnd_dates%rowtype;
824: l_found boolean;

Line 825: l_user_id fnd_user.user_id%type;

821: where user_name = p_user_name;
822:
823: l_rec fnd_dates%rowtype;
824: l_found boolean;
825: l_user_id fnd_user.user_id%type;
826: l_start_date date;
827: l_end_date date;
828: l_module_source varchar2(256);
829: no_such_user_exp exception;

Line 886: p_orclguid in fnd_user.user_guid%type) return pls_integer is

882: --
883: --Added by scheruku for Nickname changes
884: -------------------------------------------------------------------------------
885: function delete_user_nodes(p_ldap_session in dbms_ldap.session,
886: p_orclguid in fnd_user.user_guid%type) return pls_integer is
887:
888: l_module_source varchar2(256);
889: usersNode varchar2(1000);
890: usersNodes dbms_ldap.string_collection;

Line 972: p_orclguid in fnd_user.user_guid%type) return pls_integer is

968: end delete_user_subscription;
969: --
970: -------------------------------------------------------------------------------
971: function delete_uniquemember(p_ldap_session in dbms_ldap.session,
972: p_orclguid in fnd_user.user_guid%type) return pls_integer is
973:
974: l_module_source varchar2(256);
975: subsNode varchar2(1000);
976: usersNode varchar2(1000);

Line 1035: l_user_id fnd_user.user_id%type;

1031:
1032: usertype fnd_ldap_util.ldap_user_type;
1033: l_module_source varchar2(256);
1034: no_such_user_exp exception;
1035: l_user_id fnd_user.user_id%type;
1036: l_local_login varchar2(30);
1037: l_allow_sync varchar2(1);
1038: l_profile_defined boolean;
1039: l_to_synch boolean;

Line 1223: ret fnd_user.user_guid%type;

1219:
1220: function get_user_guid( p_user_name in varchar2)
1221: return raw is
1222: l_ldap dbms_ldap.session;
1223: ret fnd_user.user_guid%type;
1224: dummy pls_integer;
1225: BEGIN
1226: l_ldap := fnd_ldap_util.c_get_oid_session(dummy);
1227: ret := get_user_guid(l_ldap,p_user_name);

Line 1256: l_orclguid fnd_user.user_guid%type;

1252:
1253: l_module_source varchar2(256);
1254: l_user_exists pls_integer;
1255: l_result pls_integer;
1256: l_orclguid fnd_user.user_guid%type;
1257: l_local_login varchar2(100);
1258: l_profile_defined boolean;
1259: l_nickname varchar2(256);
1260:

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

1449:
1450: end process_attributes;
1451: --
1452: -------------------------------------------------------------------------------
1453: procedure unlink_user(p_user_guid in fnd_user.user_guid%type,
1454: p_user_name in varchar2,
1455: x_result out nocopy pls_integer) is
1456:
1457: cursor linked_users is

Line 1459: from fnd_user

1455: x_result out nocopy pls_integer) is
1456:
1457: cursor linked_users is
1458: select user_name
1459: from fnd_user
1460: where user_guid = p_user_guid
1461: and user_name <> p_user_name;
1462:
1463: l_rec linked_users%rowtype;

Line 1491: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'No other FND users linked to this OID User');

1487: then
1488:
1489: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1490: then
1491: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'No other FND users linked to this OID User');
1492: end if;
1493: l_user_exists := user_exists_by_guid( p_user_guid);
1494:
1495: if (l_user_exists = fnd_ldap_util.G_SUCCESS) then

Line 1513: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Other FND users linked to this OID User');

1509: else
1510:
1511: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1512: then
1513: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Other FND users linked to this OID User');
1514: end if;
1515:
1516: x_result := fnd_ldap_util.G_FAILURE;
1517: fnd_message.set_name ('FND', 'FND_SSO_USER_MULT_LINKED');

Line 1566: l_user_id fnd_user.user_id%type;

1562: l_module_source varchar2(256);
1563: no_such_user_exp exception;
1564: l_nickname varchar2(256);
1565:
1566: l_user_id fnd_user.user_id%type;
1567: l_local_login varchar2(30);
1568: l_allow_sync varchar2(1);
1569: l_profile_defined boolean;
1570: l_to_synch boolean;

Line 1572: l_guid FND_USER.user_guid%type:= p_user_guid;

1568: l_allow_sync varchar2(1);
1569: l_profile_defined boolean;
1570: l_to_synch boolean;
1571:
1572: l_guid FND_USER.user_guid%type:= p_user_guid;
1573: ldap dbms_ldap.session;
1574: flag pls_integer;
1575: dn varchar2(4000);
1576: realm varchar2(4000);

Line 1596: select user_id into l_user_id from fnd_user

1592:
1593:
1594: -- figure out the user_id
1595: BEGIN
1596: select user_id into l_user_id from fnd_user
1597: where user_name=p_user_name and user_guid=p_user_guid;
1598: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1599: then
1600: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user_id:'||l_user_id);

Line 1750: Unless the old is known, and that is not possible because already was changed on FND_USER...

1746: END IF;
1747: x_result := fnd_ldap_util.G_SUCCESS;
1748: /*
1749: CANNOT CHANGE USERNAME
1750: Unless the old is known, and that is not possible because already was changed on FND_USER...
1751: IF (x_result=FND_LDAP_UTIl.G_SUCCESS AND p_user_name is not null and isValueOf(ldap_user,ldap_user.nickname_att_name, p_user_name) ) THEN
1752: change_user_name(p_user_guid,ldap_user.user_name,p_user_name,x_name_change);
1753: x_result :=x_name_change;
1754: END IF;

Line 2080: l_user_name fnd_user.user_name%type;

2076:
2077: result pls_integer;
2078: retval pls_integer;
2079: l_user_guid raw(256);
2080: l_user_name fnd_user.user_name%type;
2081: l_enabled boolean;
2082: l_ldap_attr_list ldap_attr_list;
2083: ldapSession dbms_ldap.session;
2084: l_retval pls_integer;

Line 2116: select user_guid into l_user_guid from fnd_user where user_name=p_user_name;

2112: end if;
2113:
2114: -- Find the DN of the linked guid
2115: begin
2116: select user_guid into l_user_guid from fnd_user where user_name=p_user_name;
2117: if (l_user_guid is null ) then
2118: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2119: then
2120: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);

Line 2120: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);

2116: select user_guid into l_user_guid from fnd_user where user_name=p_user_name;
2117: if (l_user_guid is null ) then
2118: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2119: then
2120: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);
2121: end if;
2122: fnd_message.set_name('FND','FND_SSO_NOT_LINKED');
2123: return fnd_ldap_util.G_FAILURE;
2124: end if;

Line 2346: function get_username_from_guid(p_guid in fnd_user.user_guid%type)

2342: END IF;
2343: return ret;
2344: END get_user_name_from_data;
2345:
2346: function get_username_from_guid(p_guid in fnd_user.user_guid%type)
2347: return varchar2
2348: is
2349: ldapSession dbms_ldap.session;
2350: flag pls_integer;

Line 2548: FUNCTION new_Ldap_user( user_name in FND_USER.USER_NAME%TYPE) return ldap_user_type

2544: end if;
2545: raise;
2546: END SearchUser;
2547:
2548: FUNCTION new_Ldap_user( user_name in FND_USER.USER_NAME%TYPE) return ldap_user_type
2549: is
2550: ret ldap_user_type := getEmptyLU();
2551: BEGIN
2552: ret.user_name := user_name;

Line 2554: from FND_USER WHERE

2550: ret ldap_user_type := getEmptyLU();
2551: BEGIN
2552: ret.user_name := user_name;
2553: select user_id,user_name,user_guid into ret.user_id,ret.user_name, ret.user_guid
2554: from FND_USER WHERE
2555: FND_USER.USER_NAME= ret.user_name;
2556: return ret;
2557: EXCEPTION WHEN NO_DATA_FOUND then
2558: ret.user_id:=null;

Line 2555: FND_USER.USER_NAME= ret.user_name;

2551: BEGIN
2552: ret.user_name := user_name;
2553: select user_id,user_name,user_guid into ret.user_id,ret.user_name, ret.user_guid
2554: from FND_USER WHERE
2555: FND_USER.USER_NAME= ret.user_name;
2556: return ret;
2557: EXCEPTION WHEN NO_DATA_FOUND then
2558: ret.user_id:=null;
2559: ret.user_guid:=null;

Line 2686: select 'Y' into l_user_linked from fnd_user

2682: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'User guid found...check if already linked to an EBS user');
2683: END IF;
2684:
2685: begin
2686: select 'Y' into l_user_linked from fnd_user
2687: where user_guid = l_user_guid
2688: and rownum = 1;
2689:
2690: IF (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2964: user_name fnd_user.user_name%type;

2960: l_password VARCHAR2(256);
2961: l_enabled VARCHAR2(30);
2962: l_du_result pls_integer;
2963: l_cp_result pls_integer;
2964: user_name fnd_user.user_name%type;
2965: l_disabled_usr boolean;
2966: l_oid_user_exists varchar2(1) := 'N';
2967:
2968:

Line 3405: l_user_id FND_USER.user_ID%TYPE := p_user_id;

3401: l_local_login varchar2(30);
3402: l_profile_defined boolean;
3403: l_to_synch boolean := false;
3404: l_allow_sync varchar2(1);
3405: l_user_id FND_USER.user_ID%TYPE := p_user_id;
3406: l_user_name FND_USER.user_name%TYPE := p_user_name;
3407: l_module_source varchar2(200) := G_MODULE_SOURCE || 'CanSync:['||p_user_id||']';
3408: BEGIN
3409: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)then

Line 3406: l_user_name FND_USER.user_name%TYPE := p_user_name;

3402: l_profile_defined boolean;
3403: l_to_synch boolean := false;
3404: l_allow_sync varchar2(1);
3405: l_user_id FND_USER.user_ID%TYPE := p_user_id;
3406: l_user_name FND_USER.user_name%TYPE := p_user_name;
3407: l_module_source varchar2(200) := G_MODULE_SOURCE || 'CanSync:['||p_user_id||']';
3408: BEGIN
3409: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)then
3410: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'BEGIN '||p_user_name||' userid:'||p_user_id);

Line 3419: select user_id into l_user_id from FND_USER where user_name =l_user_name;

3415: end if;
3416: return false;
3417: ELSIF (l_user_id is null) THEN
3418: BEGIN
3419: select user_id into l_user_id from FND_USER where user_name =l_user_name;
3420: EXCEPTION WHEN OTHERS THEN
3421: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)then
3422: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'END->False, user not found ');
3423: end if;

Line 3428: select user_name into l_user_name from FND_USER where user_id =l_user_id;

3424: return false;
3425: END;
3426: ELSIF (l_user_name is null) THEN
3427: BEGIN
3428: select user_name into l_user_name from FND_USER where user_id =l_user_id;
3429: EXCEPTION WHEN OTHERS THEN
3430: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)then
3431: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,'END->False, user not found ');
3432: end if;

Line 3640: -- case 2: several values, let's lookup on FND_USER to see if there is a match

3636: IF (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
3637: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module, 'user_name(unique nna in record):'||p_ldap_user.user_name);
3638: END IF;
3639: ELSE
3640: -- case 2: several values, let's lookup on FND_USER to see if there is a match
3641: i := p_ldap_user.user_data(p_ldap_user.NickName_ATT_NAME).first;
3642: p_ldap_user.user_id:= null;
3643: IF (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
3644: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module, ' several nna , lookinf for a best match');

Line 3657: select user_id into p_ldap_user.user_id from fnd_user where

3653: IF (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
3654: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module, ' testing nna:'||l_v);
3655: END IF;
3656:
3657: select user_id into p_ldap_user.user_id from fnd_user where
3658: user_name=l_v and user_guid=p_ldap_user.user_guid;
3659:
3660: IF (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
3661: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module, ' there it is user_uid:'||p_ldap_user.user_id);

Line 3713: x_fnd_user => x_fnd,

3709: p_direction => FND_LDAP_WRAPPER.G_EBIZ_TO_OID,
3710: p_entity => FND_LDAP_WRAPPER.G_IDENTITY,
3711: p_operation => FND_LDAP_WRAPPER.G_ADD,
3712: p_attribute => vAttr,
3713: x_fnd_user => x_fnd,
3714: x_oid => x_oid,
3715: p_user_name => user_name,
3716: p_realm_dn => realm);
3717: return x_oid=FND_LDAP_WRAPPER.G_SUCCESS;

Line 3735: x_fnd_user => x_fnd,

3731: p_direction => FND_LDAP_WRAPPER.G_EBIZ_TO_OID,
3732: p_entity => FND_LDAP_WRAPPER.G_IDENTITY,
3733: p_operation => FND_LDAP_WRAPPER.G_MODIFY,
3734: p_attribute => vAttr,
3735: x_fnd_user => x_fnd,
3736: x_oid => x_oid,
3737: p_user_name => user_name,
3738: p_realm_dn => realm);
3739: return x_oid=FND_LDAP_WRAPPER.G_SUCCESS;