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_MAPPER dependencies on LDAP_ATTR

Line 206: procedure map_ldap_attr_list(

202: raise;
203: end map_entity_changes_rec;
204: --
205: -------------------------------------------------------------------------------
206: procedure map_ldap_attr_list(
207: p_entity_type in wf_attribute_cache.entity_type%type
208: , p_entity_key_value in wf_attribute_cache.entity_key_value%type
209: , p_ldap_key in out nocopy fnd_oid_util.ldap_key_type
210: , p_ldap_attr_list out nocopy ldap_attr_list

Line 210: , p_ldap_attr_list out nocopy ldap_attr_list

206: procedure map_ldap_attr_list(
207: p_entity_type in wf_attribute_cache.entity_type%type
208: , p_entity_key_value in wf_attribute_cache.entity_key_value%type
209: , p_ldap_key in out nocopy fnd_oid_util.ldap_key_type
210: , p_ldap_attr_list out nocopy ldap_attr_list
211: ) is
212:
213: cursor cur_attribute_cache is
214: select attribute_name

Line 230: l_ldap_attr ldap_attr;

226: l_module_source varchar2(256);
227: l_pwd varchar2(256);
228: l_index number;
229: l_attribute_value varchar2(4000);
230: l_ldap_attr ldap_attr;
231: l_start_date date;
232: l_end_date date;
233: l_username_changed boolean;
234: l_oid_nickname fnd_user.user_name%type;

Line 240: l_module_source := G_MODULE_SOURCE || 'map_ldap_attr_list: ';

236: l_new_fnd_username fnd_user.user_name%type;
237: l_nicknameattr varchar2(256);
238:
239: begin
240: l_module_source := G_MODULE_SOURCE || 'map_ldap_attr_list: ';
241:
242: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
243: then
244: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');

Line 250: p_ldap_attr_list := ldap_attr_list();

246: , 'p_entity_type = ' || p_entity_type ||
247: ', p_entity_key_value = ' || p_entity_key_value);
248: end if;
249:
250: p_ldap_attr_list := ldap_attr_list();
251: l_index := 1;
252: l_username_changed := false;
253: l_nicknameattr:= upper(fnd_oid_plug.getNickNameAttr(p_entity_key_value));
254: for l_rec in cur_attribute_cache

Line 309: l_ldap_attr := ldap_attr(

305: and l_pwd <> fnd_oid_util.G_INVALID
306: and l_pwd <> fnd_oid_util.G_EXTERNAL)
307: then
308: l_attribute_value := rawtohex(utl_raw.cast_to_raw(l_pwd));
309: l_ldap_attr := ldap_attr(
310: l_rec.attribute_name
311: , l_attribute_value
312: , null
313: , length(l_attribute_value)

Line 316: p_ldap_attr_list.extend;

312: , null
313: , length(l_attribute_value)
314: , wf_oid.ATTR_TYPE_ENCRYPTED_STRING
315: , l_rec.attr_mod_op);
316: p_ldap_attr_list.extend;
317: p_ldap_attr_list(l_index) := l_ldap_attr;
318: l_index := l_index + 1;
319: end if;
320:

Line 317: p_ldap_attr_list(l_index) := l_ldap_attr;

313: , length(l_attribute_value)
314: , wf_oid.ATTR_TYPE_ENCRYPTED_STRING
315: , l_rec.attr_mod_op);
316: p_ldap_attr_list.extend;
317: p_ldap_attr_list(l_index) := l_ldap_attr;
318: l_index := l_index + 1;
319: end if;
320:
321: else

Line 322: -- Fix bug 4231203: REMOVE NICKNAME/USER_NAME ATTRIBUTE FROM LDAP ATTRIBUTE LISTS

318: l_index := l_index + 1;
319: end if;
320:
321: else
322: -- Fix bug 4231203: REMOVE NICKNAME/USER_NAME ATTRIBUTE FROM LDAP ATTRIBUTE LISTS
323: -- Handle USER_NAME later
324:
325: if (l_rec.attribute_name <> l_nicknameattr
326: and l_rec.attribute_name <> 'USER_NAME') then

Line 327: l_ldap_attr := ldap_attr(

323: -- Handle USER_NAME later
324:
325: if (l_rec.attribute_name <> l_nicknameattr
326: and l_rec.attribute_name <> 'USER_NAME') then
327: l_ldap_attr := ldap_attr(
328: l_rec.attribute_name
329: , l_rec.attribute_value
330: , null
331: , length(l_rec.attribute_value)

Line 334: p_ldap_attr_list.extend;

330: , null
331: , length(l_rec.attribute_value)
332: , wf_oid.ATTR_TYPE_STRING
333: , l_rec.attr_mod_op);
334: p_ldap_attr_list.extend;
335: p_ldap_attr_list(l_index) := l_ldap_attr;
336: l_index := l_index + 1;
337: end if;
338:

Line 335: p_ldap_attr_list(l_index) := l_ldap_attr;

331: , length(l_rec.attribute_value)
332: , wf_oid.ATTR_TYPE_STRING
333: , l_rec.attr_mod_op);
334: p_ldap_attr_list.extend;
335: p_ldap_attr_list(l_index) := l_ldap_attr;
336: l_index := l_index + 1;
337: end if;
338:
339: -- if (l_rec.attribute_name = fnd_oid_util.G_ORCLACTIVESTARTDATE)

Line 356: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||

352:
353: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
354: then
355: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
356: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
357: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
358: end if;
359:
360: end loop;

Line 357: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

353: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
354: then
355: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
356: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
357: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
358: end if;
359:
360: end loop;
361:

Line 388: l_ldap_attr := ldap_attr(fnd_oid_util.G_ORCLISENABLED

384: end if;
385: p_ldap_key.orclisEnabled := fnd_oid_util.G_ENABLED;
386: end if;
387:
388: l_ldap_attr := ldap_attr(fnd_oid_util.G_ORCLISENABLED
389: , p_ldap_key.orclisEnabled
390: , null
391: , length(p_ldap_key.orclisEnabled), wf_oid.ATTR_TYPE_STRING
392: , WF_OID.MOD_REPLACE);

Line 393: p_ldap_attr_list.extend;

389: , p_ldap_key.orclisEnabled
390: , null
391: , length(p_ldap_key.orclisEnabled), wf_oid.ATTR_TYPE_STRING
392: , WF_OID.MOD_REPLACE);
393: p_ldap_attr_list.extend;
394: p_ldap_attr_list(l_index) := l_ldap_attr;
395: l_index := l_index + 1;
396:
397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 394: p_ldap_attr_list(l_index) := l_ldap_attr;

390: , null
391: , length(p_ldap_key.orclisEnabled), wf_oid.ATTR_TYPE_STRING
392: , WF_OID.MOD_REPLACE);
393: p_ldap_attr_list.extend;
394: p_ldap_attr_list(l_index) := l_ldap_attr;
395: l_index := l_index + 1;
396:
397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
398: then

Line 400: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||

396:
397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
398: then
399: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
400: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
401: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
402: end if;
403:
404:

Line 401: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

397: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
398: then
399: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
400: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
401: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
402: end if;
403:
404:
405: -- Is this really new user? Guid in cache may not be up-to-date.

Line 416: l_ldap_attr := ldap_attr(

412: -- This is a brand new user as far as we know
413: -- Sync SN and CN only if IDENTITY_ADD
414:
415: if (p_ldap_key.orclGUID is null) then
416: l_ldap_attr := ldap_attr(
417: fnd_oid_util.G_SN
418: , p_ldap_key.sn
419: , null
420: , length(p_ldap_key.sn)

Line 424: p_ldap_attr_list.extend;

420: , length(p_ldap_key.sn)
421: , wf_oid.ATTR_TYPE_STRING
422: , WF_OID.MOD_REPLACE);
423:
424: p_ldap_attr_list.extend;
425: p_ldap_attr_list(l_index) := l_ldap_attr;
426: l_index := l_index + 1;
427:
428: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 425: p_ldap_attr_list(l_index) := l_ldap_attr;

421: , wf_oid.ATTR_TYPE_STRING
422: , WF_OID.MOD_REPLACE);
423:
424: p_ldap_attr_list.extend;
425: p_ldap_attr_list(l_index) := l_ldap_attr;
426: l_index := l_index + 1;
427:
428: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
429: then

Line 431: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||

427:
428: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
429: then
430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
431: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
432: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
433: end if;
434: l_ldap_attr := ldap_attr(
435: fnd_oid_util.G_CN

Line 432: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

428: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
429: then
430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
431: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
432: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
433: end if;
434: l_ldap_attr := ldap_attr(
435: fnd_oid_util.G_CN
436: , p_ldap_key.cn

Line 434: l_ldap_attr := ldap_attr(

430: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
431: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
432: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
433: end if;
434: l_ldap_attr := ldap_attr(
435: fnd_oid_util.G_CN
436: , p_ldap_key.cn
437: , null
438: , length(p_ldap_key.cn)

Line 441: p_ldap_attr_list.extend;

437: , null
438: , length(p_ldap_key.cn)
439: , wf_oid.ATTR_TYPE_STRING
440: , WF_OID.MOD_REPLACE);
441: p_ldap_attr_list.extend;
442: p_ldap_attr_list(l_index) := l_ldap_attr;
443: l_index := l_index + 1;
444: --Add USER_NAME if new user
445: l_ldap_attr := ldap_attr(

Line 442: p_ldap_attr_list(l_index) := l_ldap_attr;

438: , length(p_ldap_key.cn)
439: , wf_oid.ATTR_TYPE_STRING
440: , WF_OID.MOD_REPLACE);
441: p_ldap_attr_list.extend;
442: p_ldap_attr_list(l_index) := l_ldap_attr;
443: l_index := l_index + 1;
444: --Add USER_NAME if new user
445: l_ldap_attr := ldap_attr(
446: 'USER_NAME'

Line 445: l_ldap_attr := ldap_attr(

441: p_ldap_attr_list.extend;
442: p_ldap_attr_list(l_index) := l_ldap_attr;
443: l_index := l_index + 1;
444: --Add USER_NAME if new user
445: l_ldap_attr := ldap_attr(
446: 'USER_NAME'
447: , p_ldap_key.cn
448: , null
449: , length(p_ldap_key.cn)

Line 452: p_ldap_attr_list.extend;

448: , null
449: , length(p_ldap_key.cn)
450: , wf_oid.ATTR_TYPE_STRING
451: , WF_OID.MOD_REPLACE);
452: p_ldap_attr_list.extend;
453: p_ldap_attr_list(l_index) := l_ldap_attr;
454: l_index := l_index + 1;
455:
456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 453: p_ldap_attr_list(l_index) := l_ldap_attr;

449: , length(p_ldap_key.cn)
450: , wf_oid.ATTR_TYPE_STRING
451: , WF_OID.MOD_REPLACE);
452: p_ldap_attr_list.extend;
453: p_ldap_attr_list(l_index) := l_ldap_attr;
454: l_index := l_index + 1;
455:
456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
457: then

Line 459: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||

455:
456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
457: then
458: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
459: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
460: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
461: end if;
462: else
463: l_oid_nickname := upper(fnd_oid_util.get_oid_nickname(p_ldap_key.orclGUID));

Line 460: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));

456: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
457: then
458: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
459: , 'l_ldap_attr(' || (l_index - 1) || ') = ' ||
460: fnd_oid_util.get_ldap_attr_str(l_ldap_attr));
461: end if;
462: else
463: l_oid_nickname := upper(fnd_oid_util.get_oid_nickname(p_ldap_key.orclGUID));
464: if l_username_changed and l_oid_nickname = l_old_fnd_username then

Line 467: l_ldap_attr := ldap_attr(

463: l_oid_nickname := upper(fnd_oid_util.get_oid_nickname(p_ldap_key.orclGUID));
464: if l_username_changed and l_oid_nickname = l_old_fnd_username then
465: -- Fixed bug 4309356:
466: --Change USER_NAME - but only if old fnd and OID user names are the same
467: l_ldap_attr := ldap_attr(
468: 'USER_NAME'
469: , l_new_fnd_username
470: , null
471: , length(l_new_fnd_username)

Line 474: p_ldap_attr_list.extend;

470: , null
471: , length(l_new_fnd_username)
472: , wf_oid.ATTR_TYPE_STRING
473: , WF_OID.MOD_REPLACE);
474: p_ldap_attr_list.extend;
475: p_ldap_attr_list(l_index) := l_ldap_attr;
476: l_index := l_index + 1;
477: end if;
478: end if;

Line 475: p_ldap_attr_list(l_index) := l_ldap_attr;

471: , length(l_new_fnd_username)
472: , wf_oid.ATTR_TYPE_STRING
473: , WF_OID.MOD_REPLACE);
474: p_ldap_attr_list.extend;
475: p_ldap_attr_list(l_index) := l_ldap_attr;
476: l_index := l_index + 1;
477: end if;
478: end if;
479:

Line 493: end map_ldap_attr_list;

489: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
490: end if;
491:
492: raise;
493: end map_ldap_attr_list;
494: --
495: -------------------------------------------------------------------------------
496: procedure map_ldap_message(
497: p_wf_event in wf_event_t

Line 664: , p_ldap_attr_list in ldap_attr_list

660: --
661: -------------------------------------------------------------------------------
662: procedure map_ldap_message(
663: p_user_name in fnd_user.user_name%type
664: , p_ldap_attr_list in ldap_attr_list
665: , p_ldap_message in out nocopy fnd_oid_util.ldap_message_type
666: ) is
667:
668: l_module_source varchar2(256);

Line 678: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)

674: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
675: end if;
676:
677: p_ldap_message.object_name := p_user_name;
678: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
679: then
680: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
681: loop
682: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 680: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last

676:
677: p_ldap_message.object_name := p_user_name;
678: if (p_ldap_attr_list is not null AND p_ldap_attr_list.count > 0)
679: then
680: for j in p_ldap_attr_list.first .. p_ldap_attr_list.last
681: loop
682: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
683: then
684: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source

Line 685: , 'p_ldap_attr_list(' || j || ') = ' ||

681: loop
682: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
683: then
684: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
685: , 'p_ldap_attr_list(' || j || ') = ' ||
686: fnd_oid_util.get_ldap_attr_str(p_ldap_attr_list(j)));
687: end if;
688:
689:

Line 686: fnd_oid_util.get_ldap_attr_str(p_ldap_attr_list(j)));

682: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
683: then
684: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source
685: , 'p_ldap_attr_list(' || j || ') = ' ||
686: fnd_oid_util.get_ldap_attr_str(p_ldap_attr_list(j)));
687: end if;
688:
689:
690: if (upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.sn)

Line 690: if (upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.sn)

686: fnd_oid_util.get_ldap_attr_str(p_ldap_attr_list(j)));
687: end if;
688:
689:
690: if (upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.sn)
691: then
692: p_ldap_message.sn := p_ldap_attr_list(j).attr_value;
693:
694: if (p_ldap_message.sn in ('*UNKNOWN*','*NULL*')) then

Line 692: p_ldap_message.sn := p_ldap_attr_list(j).attr_value;

688:
689:
690: if (upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.sn)
691: then
692: p_ldap_message.sn := p_ldap_attr_list(j).attr_value;
693:
694: if (p_ldap_message.sn in ('*UNKNOWN*','*NULL*')) then
695: p_ldap_message.sn := null;
696: end if;

Line 699: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.cn)

695: p_ldap_message.sn := null;
696: end if;
697:
698:
699: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.cn)
700: then
701: p_ldap_message.cn := p_ldap_attr_list(j).attr_value;
702: if (p_ldap_message.cn in ('*UNKNOWN*','*NULL*')) then
703: p_ldap_message.cn := null;

Line 701: p_ldap_message.cn := p_ldap_attr_list(j).attr_value;

697:
698:
699: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.cn)
700: then
701: p_ldap_message.cn := p_ldap_attr_list(j).attr_value;
702: if (p_ldap_message.cn in ('*UNKNOWN*','*NULL*')) then
703: p_ldap_message.cn := null;
704: end if;
705:

Line 706: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.telephoneNumber)

702: if (p_ldap_message.cn in ('*UNKNOWN*','*NULL*')) then
703: p_ldap_message.cn := null;
704: end if;
705:
706: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.telephoneNumber)
707: then
708: p_ldap_message.telephoneNumber := p_ldap_attr_list(j).attr_value;
709: if (p_ldap_message.telephoneNumber in ('*UNKNOWN*','*NULL*')) then
710: p_ldap_message.telephoneNumber := null;

Line 708: p_ldap_message.telephoneNumber := p_ldap_attr_list(j).attr_value;

704: end if;
705:
706: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.telephoneNumber)
707: then
708: p_ldap_message.telephoneNumber := p_ldap_attr_list(j).attr_value;
709: if (p_ldap_message.telephoneNumber in ('*UNKNOWN*','*NULL*')) then
710: p_ldap_message.telephoneNumber := null;
711: end if;
712:

Line 713: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.street)

709: if (p_ldap_message.telephoneNumber in ('*UNKNOWN*','*NULL*')) then
710: p_ldap_message.telephoneNumber := null;
711: end if;
712:
713: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.street)
714: then
715: p_ldap_message.street := p_ldap_attr_list(j).attr_value;
716: if (p_ldap_message.street in ('*UNKNOWN*','*NULL*')) then
717: p_ldap_message.street := null;

Line 715: p_ldap_message.street := p_ldap_attr_list(j).attr_value;

711: end if;
712:
713: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.street)
714: then
715: p_ldap_message.street := p_ldap_attr_list(j).attr_value;
716: if (p_ldap_message.street in ('*UNKNOWN*','*NULL*')) then
717: p_ldap_message.street := null;
718: end if;
719:

Line 720: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.postalCode)

716: if (p_ldap_message.street in ('*UNKNOWN*','*NULL*')) then
717: p_ldap_message.street := null;
718: end if;
719:
720: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.postalCode)
721: then
722: p_ldap_message.postalCode := p_ldap_attr_list(j).attr_value;
723: if (p_ldap_message.postalCode in ('*UNKNOWN*','*NULL*')) then
724: p_ldap_message.postalCode := null;

Line 722: p_ldap_message.postalCode := p_ldap_attr_list(j).attr_value;

718: end if;
719:
720: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.postalCode)
721: then
722: p_ldap_message.postalCode := p_ldap_attr_list(j).attr_value;
723: if (p_ldap_message.postalCode in ('*UNKNOWN*','*NULL*')) then
724: p_ldap_message.postalCode := null;
725: end if;
726:

Line 727: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.physicalDeliveryOfficeName)

723: if (p_ldap_message.postalCode in ('*UNKNOWN*','*NULL*')) then
724: p_ldap_message.postalCode := null;
725: end if;
726:
727: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.physicalDeliveryOfficeName)
728: then
729: p_ldap_message.physicalDeliveryOfficeName := p_ldap_attr_list(j).attr_value;
730: if (p_ldap_message.physicalDeliveryOfficeName in ('*UNKNOWN*','*NULL*')) then
731: p_ldap_message.physicalDeliveryOfficeName := null;

Line 729: p_ldap_message.physicalDeliveryOfficeName := p_ldap_attr_list(j).attr_value;

725: end if;
726:
727: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.physicalDeliveryOfficeName)
728: then
729: p_ldap_message.physicalDeliveryOfficeName := p_ldap_attr_list(j).attr_value;
730: if (p_ldap_message.physicalDeliveryOfficeName in ('*UNKNOWN*','*NULL*')) then
731: p_ldap_message.physicalDeliveryOfficeName := null;
732: end if;
733:

Line 734: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.st)

730: if (p_ldap_message.physicalDeliveryOfficeName in ('*UNKNOWN*','*NULL*')) then
731: p_ldap_message.physicalDeliveryOfficeName := null;
732: end if;
733:
734: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.st)
735: then
736: p_ldap_message.st := p_ldap_attr_list(j).attr_value;
737: if (p_ldap_message.st in ('*UNKNOWN*','*NULL*')) then
738: p_ldap_message.st := null;

Line 736: p_ldap_message.st := p_ldap_attr_list(j).attr_value;

732: end if;
733:
734: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.st)
735: then
736: p_ldap_message.st := p_ldap_attr_list(j).attr_value;
737: if (p_ldap_message.st in ('*UNKNOWN*','*NULL*')) then
738: p_ldap_message.st := null;
739: end if;
740:

Line 741: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.l)

737: if (p_ldap_message.st in ('*UNKNOWN*','*NULL*')) then
738: p_ldap_message.st := null;
739: end if;
740:
741: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.l)
742: then
743: p_ldap_message.l := p_ldap_attr_list(j).attr_value;
744: if (p_ldap_message.l in ('*UNKNOWN*','*NULL*')) then
745: p_ldap_message.l := null;

Line 743: p_ldap_message.l := p_ldap_attr_list(j).attr_value;

739: end if;
740:
741: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.l)
742: then
743: p_ldap_message.l := p_ldap_attr_list(j).attr_value;
744: if (p_ldap_message.l in ('*UNKNOWN*','*NULL*')) then
745: p_ldap_message.l := null;
746: end if;
747:

Line 748: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.displayName)

744: if (p_ldap_message.l in ('*UNKNOWN*','*NULL*')) then
745: p_ldap_message.l := null;
746: end if;
747:
748: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.displayName)
749: then
750: p_ldap_message.displayName := p_ldap_attr_list(j).attr_value;
751: if (p_ldap_message.displayName in ('*UNKNOWN*','*NULL*')) then
752: p_ldap_message.displayName := null;

Line 750: p_ldap_message.displayName := p_ldap_attr_list(j).attr_value;

746: end if;
747:
748: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.displayName)
749: then
750: p_ldap_message.displayName := p_ldap_attr_list(j).attr_value;
751: if (p_ldap_message.displayName in ('*UNKNOWN*','*NULL*')) then
752: p_ldap_message.displayName := null;
753: end if;
754:

Line 755: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.givenName)

751: if (p_ldap_message.displayName in ('*UNKNOWN*','*NULL*')) then
752: p_ldap_message.displayName := null;
753: end if;
754:
755: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.givenName)
756: then
757: p_ldap_message.givenName := p_ldap_attr_list(j).attr_value;
758: if (p_ldap_message.givenName in ('*UNKNOWN*','*NULL*')) then
759: p_ldap_message.givenName := null;

Line 757: p_ldap_message.givenName := p_ldap_attr_list(j).attr_value;

753: end if;
754:
755: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.givenName)
756: then
757: p_ldap_message.givenName := p_ldap_attr_list(j).attr_value;
758: if (p_ldap_message.givenName in ('*UNKNOWN*','*NULL*')) then
759: p_ldap_message.givenName := null;
760: end if;
761:

Line 762: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.homePhone)

758: if (p_ldap_message.givenName in ('*UNKNOWN*','*NULL*')) then
759: p_ldap_message.givenName := null;
760: end if;
761:
762: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.homePhone)
763: then
764: p_ldap_message.homePhone := p_ldap_attr_list(j).attr_value;
765: if (p_ldap_message.homePhone in ('*UNKNOWN*','*NULL*')) then
766: p_ldap_message.homePhone := null;

Line 764: p_ldap_message.homePhone := p_ldap_attr_list(j).attr_value;

760: end if;
761:
762: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.homePhone)
763: then
764: p_ldap_message.homePhone := p_ldap_attr_list(j).attr_value;
765: if (p_ldap_message.homePhone in ('*UNKNOWN*','*NULL*')) then
766: p_ldap_message.homePhone := null;
767: end if;
768:

Line 769: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.mail)

765: if (p_ldap_message.homePhone in ('*UNKNOWN*','*NULL*')) then
766: p_ldap_message.homePhone := null;
767: end if;
768:
769: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.mail)
770: then
771: p_ldap_message.mail := p_ldap_attr_list(j).attr_value;
772: if (p_ldap_message.mail in ('*UNKNOWN*','*NULL*')) then
773: p_ldap_message.mail := null;

Line 771: p_ldap_message.mail := p_ldap_attr_list(j).attr_value;

767: end if;
768:
769: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.mail)
770: then
771: p_ldap_message.mail := p_ldap_attr_list(j).attr_value;
772: if (p_ldap_message.mail in ('*UNKNOWN*','*NULL*')) then
773: p_ldap_message.mail := null;
774: end if;
775:

Line 776: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.c)

772: if (p_ldap_message.mail in ('*UNKNOWN*','*NULL*')) then
773: p_ldap_message.mail := null;
774: end if;
775:
776: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.c)
777: then
778: p_ldap_message.c := p_ldap_attr_list(j).attr_value;
779: if (p_ldap_message.c in ('*UNKNOWN*','*NULL*')) then
780: p_ldap_message.c := null;

Line 778: p_ldap_message.c := p_ldap_attr_list(j).attr_value;

774: end if;
775:
776: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.c)
777: then
778: p_ldap_message.c := p_ldap_attr_list(j).attr_value;
779: if (p_ldap_message.c in ('*UNKNOWN*','*NULL*')) then
780: p_ldap_message.c := null;
781: end if;
782:

Line 783: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.facsimileTelephoneNumber)

779: if (p_ldap_message.c in ('*UNKNOWN*','*NULL*')) then
780: p_ldap_message.c := null;
781: end if;
782:
783: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.facsimileTelephoneNumber)
784: then
785: p_ldap_message.facsimileTelephoneNumber := p_ldap_attr_list(j).attr_value;
786: if (p_ldap_message.facsimileTelephoneNumber in ('*UNKNOWN*','*NULL*')) then
787: p_ldap_message.facsimileTelephoneNumber := null;

Line 785: p_ldap_message.facsimileTelephoneNumber := p_ldap_attr_list(j).attr_value;

781: end if;
782:
783: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.facsimileTelephoneNumber)
784: then
785: p_ldap_message.facsimileTelephoneNumber := p_ldap_attr_list(j).attr_value;
786: if (p_ldap_message.facsimileTelephoneNumber in ('*UNKNOWN*','*NULL*')) then
787: p_ldap_message.facsimileTelephoneNumber := null;
788: end if;
789:

Line 790: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.description)

786: if (p_ldap_message.facsimileTelephoneNumber in ('*UNKNOWN*','*NULL*')) then
787: p_ldap_message.facsimileTelephoneNumber := null;
788: end if;
789:
790: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.description)
791: then
792: p_ldap_message.description := p_ldap_attr_list(j).attr_value;
793: if (p_ldap_message.description in ('*UNKNOWN*','*NULL*')) then
794: p_ldap_message.description := null;

Line 792: p_ldap_message.description := p_ldap_attr_list(j).attr_value;

788: end if;
789:
790: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.description)
791: then
792: p_ldap_message.description := p_ldap_attr_list(j).attr_value;
793: if (p_ldap_message.description in ('*UNKNOWN*','*NULL*')) then
794: p_ldap_message.description := null;
795: end if;
796:

Line 797: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclisEnabled)

793: if (p_ldap_message.description in ('*UNKNOWN*','*NULL*')) then
794: p_ldap_message.description := null;
795: end if;
796:
797: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclisEnabled)
798: then
799: p_ldap_message.orclisEnabled := p_ldap_attr_list(j).attr_value;
800:
801: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveStartDate)

Line 799: p_ldap_message.orclisEnabled := p_ldap_attr_list(j).attr_value;

795: end if;
796:
797: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclisEnabled)
798: then
799: p_ldap_message.orclisEnabled := p_ldap_attr_list(j).attr_value;
800:
801: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveStartDate)
802: then
803: p_ldap_message.orclActiveStartDate := p_ldap_attr_list(j).attr_value;

Line 801: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveStartDate)

797: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclisEnabled)
798: then
799: p_ldap_message.orclisEnabled := p_ldap_attr_list(j).attr_value;
800:
801: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveStartDate)
802: then
803: p_ldap_message.orclActiveStartDate := p_ldap_attr_list(j).attr_value;
804:
805: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveEndDate)

Line 803: p_ldap_message.orclActiveStartDate := p_ldap_attr_list(j).attr_value;

799: p_ldap_message.orclisEnabled := p_ldap_attr_list(j).attr_value;
800:
801: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveStartDate)
802: then
803: p_ldap_message.orclActiveStartDate := p_ldap_attr_list(j).attr_value;
804:
805: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveEndDate)
806: then
807: p_ldap_message.orclActiveEndDate := p_ldap_attr_list(j).attr_value;

Line 805: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveEndDate)

801: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveStartDate)
802: then
803: p_ldap_message.orclActiveStartDate := p_ldap_attr_list(j).attr_value;
804:
805: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveEndDate)
806: then
807: p_ldap_message.orclActiveEndDate := p_ldap_attr_list(j).attr_value;
808: else
809:

Line 807: p_ldap_message.orclActiveEndDate := p_ldap_attr_list(j).attr_value;

803: p_ldap_message.orclActiveStartDate := p_ldap_attr_list(j).attr_value;
804:
805: elsif(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclActiveEndDate)
806: then
807: p_ldap_message.orclActiveEndDate := p_ldap_attr_list(j).attr_value;
808: else
809:
810: if(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclGUID)
811: then

Line 810: if(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclGUID)

806: then
807: p_ldap_message.orclActiveEndDate := p_ldap_attr_list(j).attr_value;
808: else
809:
810: if(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclGUID)
811: then
812: p_ldap_message.orclGUID := p_ldap_attr_list(j).attr_value;
813: end if;
814: end if;

Line 812: p_ldap_message.orclGUID := p_ldap_attr_list(j).attr_value;

808: else
809:
810: if(upper(p_ldap_attr_list(j).attr_name)= fnd_oid_util.G_LDAP_MESSAGE_ATTR.orclGUID)
811: then
812: p_ldap_message.orclGUID := p_ldap_attr_list(j).attr_value;
813: end if;
814: end if;
815: end loop;
816: end if;

Line 838: , p_ldap_attr_list in ldap_attr_list

834: -------------------------------------------------------------------------------
835: procedure map_oid_event(
836: p_ldap_key in fnd_oid_util.ldap_key_type
837: , p_entity_changes_rec in fnd_oid_util.wf_entity_changes_rec_type
838: , p_ldap_attr_list in ldap_attr_list
839: , p_event out nocopy ldap_event
840: ) is
841:
842: l_module_source varchar2(256);

Line 865: , attr_list => p_ldap_attr_list);

861: , object_type => p_entity_changes_rec.flavor
862: , object_guid => null
863: , object_dn => null
864: , profile_id => fnd_oid_util.G_NOT_FOR_IMPORT
865: , attr_list => p_ldap_attr_list);
866: elsif (p_entity_changes_rec.entity_type = wf_oid.SUBSCRIPTION_ADD)
867: then
868: p_event := ldap_event(
869: event_type => wf_oid.SUBSCRIPTION_ADD

Line 892: , attr_list => p_ldap_attr_list);

888: , object_type => p_entity_changes_rec.flavor
889: , object_guid => p_ldap_key.orclGUID
890: , object_dn => null
891: , profile_id => fnd_oid_util.G_NOT_FOR_IMPORT
892: , attr_list => p_ldap_attr_list);
893:
894: elsif (p_entity_changes_rec.entity_type = wf_oid.SUBSCRIPTION_DELETE)
895: then
896: p_event := ldap_event(