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_OID_SUBSCRIPTIONS dependencies on FND_OID_UTIL

Line 36: l_apps_username_key fnd_oid_util.apps_user_key_type;

32: , p_user_guid in fnd_user.user_guid%type
33: , x_user_id out nocopy fnd_user.user_id%type
34: ) is
35: l_module_source varchar2(256);
36: l_apps_username_key fnd_oid_util.apps_user_key_type;
37: l_apps_userguid_key fnd_oid_util.apps_user_key_type;
38: l_user_name fnd_user.user_name%type;
39: l_found boolean;
40: l_allow_sync varchar2(1);

Line 37: l_apps_userguid_key fnd_oid_util.apps_user_key_type;

33: , x_user_id out nocopy fnd_user.user_id%type
34: ) is
35: l_module_source varchar2(256);
36: l_apps_username_key fnd_oid_util.apps_user_key_type;
37: l_apps_userguid_key fnd_oid_util.apps_user_key_type;
38: l_user_name fnd_user.user_name%type;
39: l_found boolean;
40: l_allow_sync varchar2(1);
41: l_user_profiles fnd_oid_util.apps_sso_user_profiles_type;

Line 41: l_user_profiles fnd_oid_util.apps_sso_user_profiles_type;

37: l_apps_userguid_key fnd_oid_util.apps_user_key_type;
38: l_user_name fnd_user.user_name%type;
39: l_found boolean;
40: l_allow_sync varchar2(1);
41: l_user_profiles fnd_oid_util.apps_sso_user_profiles_type;
42: l_profile_defined boolean;
43: l_start_date date;
44: l_end_date date;
45: l_description fnd_user.description%type;

Line 65: l_apps_userguid_key := fnd_oid_util.get_fnd_user(p_user_guid => p_user_guid);

61: return;
62: end if;
63: --Check whether this guid already exists. Don't raise alerts because we receive echo
64: --from OID for each user that is created.
65: l_apps_userguid_key := fnd_oid_util.get_fnd_user(p_user_guid => p_user_guid);
66: -- Disable user in FND when user unsubscribed from the application in OID
67: if (p_event_type = wf_oid.SUBSCRIPTION_DELETE) then
68: update fnd_user set end_date= sysdate
69: where user_name = l_apps_userguid_key.user_name;

Line 81: l_apps_username_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);

77: return;
78: end if;
79: -- Check whether this user_name already exists. We won't link (update user_guid) here.
80: -- We let Auto Link profile or the linking page controls who is linked to whom.
81: l_apps_username_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
82: if (l_apps_username_key.user_id is not null) then
83: -- Is this user linked to someone else? Raise alert because it's a security threat.
84: if (l_apps_username_key.user_guid is not null and l_apps_username_key.user_guid <> p_user_guid) then
85: if(fnd_log.LEVEL_UNEXPECTED >=

Line 148: l_start_date := to_date(substr(p_start_date, 1, 14), fnd_oid_util.G_YYYYMMDDHH24MISS);

144:
145: if (p_start_date is null or p_start_date = '*UNKNOWN*') then
146: l_start_date := sysdate;
147: else
148: l_start_date := to_date(substr(p_start_date, 1, 14), fnd_oid_util.G_YYYYMMDDHH24MISS);
149: end if;
150:
151: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
152: then

Line 159: l_end_date := to_date(substr(p_end_date, 1, 14), fnd_oid_util.G_YYYYMMDDHH24MISS);

155:
156: if (p_end_date is null or p_end_date = '*UNKNOWN*') then
157: l_end_date := null;
158: else
159: l_end_date := to_date(substr(p_end_date, 1, 14), fnd_oid_util.G_YYYYMMDDHH24MISS);
160: end if;
161:
162: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
163: then

Line 261: , p_owner => fnd_oid_util.G_CUST

257: fnd_create_update(
258: p_event_type => p_event_type
259: , p_user_name => p_wf_event.GetEventKey
260: , p_user_guid => p_user_guid
261: , p_owner => fnd_oid_util.G_CUST
262: , p_unencrypted_password => null
263: , p_description => l_description
264: , p_email_address => l_email_address
265: , p_fax => l_fax

Line 329: fnd_oid_util.G_CHANGE_SOURCE);

325: l_event_key := p_event.GetEventKey;
326: l_event_name := WF_OID.IDENTITY_ADD;
327:
328: l_change_source := p_event.GetValueForParameter(
329: fnd_oid_util.G_CHANGE_SOURCE);
330:
331: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
332: then
333: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

Line 339: if (l_change_source = fnd_oid_util.G_OID) then

335: ', l_event_name = ' || l_event_name ||
336: ', l_change_source = ' || l_change_source);
337: end if;
338: --Change_source has to be OID
339: if (l_change_source = fnd_oid_util.G_OID) then
340: l_orcl_guid := p_event.GetValueForParameter(
341: fnd_oid_util.G_ORCLGUID);
342: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
343: then

Line 341: fnd_oid_util.G_ORCLGUID);

337: end if;
338: --Change_source has to be OID
339: if (l_change_source = fnd_oid_util.G_OID) then
340: l_orcl_guid := p_event.GetValueForParameter(
341: fnd_oid_util.G_ORCLGUID);
342: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
343: then
344: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
345: || l_orcl_guid || ', user_name is ' || l_event_key);

Line 387: fnd_oid_util.G_ORCLGUID);

383: end if;
384: --THIS SUBSCRIPTION IS NOT USED! fnd_user_pkg.user_change SUBSCRIPTION IS USED INSTEAD.
385: --Rada, 01/31/2005
386: l_orcl_guid := p_event.GetValueForParameter(
387: fnd_oid_util.G_ORCLGUID);
388: fnd_create_update(
389: p_wf_event => p_event
390: , p_event_type => WF_OID.IDENTITY_MODIFY
391: , p_user_name => p_event.GetEventKey()

Line 466: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;

462: , p_event in out nocopy wf_event_t)
463: return varchar2 is
464:
465: l_module_source varchar2(256);
466: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;
467: l_event_name varchar2(256);
468: l_event_key varchar2(256);
469: l_change_source varchar2(256);
470: l_user_id number;

Line 484: fnd_oid_util.G_CHANGE_SOURCE);

480: l_event_key := p_event.GetEventKey;
481: l_event_name := WF_OID.SUBSCRIPTION_ADD;
482:
483: l_change_source := p_event.GetValueForParameter(
484: fnd_oid_util.G_CHANGE_SOURCE);
485:
486: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
487: then
488: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

Line 494: if (l_change_source = fnd_oid_util.G_OID) then

490: ', l_event_name = ' || l_event_name ||
491: ', l_change_source = ' || l_change_source);
492: end if;
493:
494: if (l_change_source = fnd_oid_util.G_OID) then
495: l_orcl_guid := p_event.GetValueForParameter(
496: fnd_oid_util.G_ORCLGUID);
497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
498: then

Line 496: fnd_oid_util.G_ORCLGUID);

492: end if;
493:
494: if (l_change_source = fnd_oid_util.G_OID) then
495: l_orcl_guid := p_event.GetValueForParameter(
496: fnd_oid_util.G_ORCLGUID);
497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
498: then
499: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
500: || l_orcl_guid || ', user_name is ' || l_event_key);

Line 546: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;

542: , p_event in out nocopy wf_event_t)
543: return varchar2 is
544:
545: l_module_source varchar2(256);
546: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;
547: l_event_name varchar2(256);
548: l_event_key varchar2(256);
549: l_change_source varchar2(256);
550: l_user_id number;

Line 565: fnd_oid_util.G_CHANGE_SOURCE);

561:
562: l_event_key := p_event.GetEventKey;
563: l_event_name := WF_OID.SUBSCRIPTION_DELETE;
564: l_change_source := p_event.GetValueForParameter(
565: fnd_oid_util.G_CHANGE_SOURCE);
566:
567: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
568: then
569: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

Line 577: if (l_change_source = fnd_oid_util.G_EBIZ)

573: end if;
574:
575: l_sso_user_profiles := fnd_ldap_mapper.map_sso_user_profiles(l_event_key);
576:
577: if (l_change_source = fnd_oid_util.G_EBIZ)
578: then
579: insert into wf_entity_changes(
580: entity_type, entity_key_value, flavor, change_date)
581: values(

Line 587: fnd_oid_util.G_ORCLGUID);

583:
584: else
585: --Rada, 01/31/2005
586: l_orcl_guid := p_event.GetValueForParameter(
587: fnd_oid_util.G_ORCLGUID);
588: /*fnd_create_update(
589: p_event_type => l_event_name
590: , p_user_name => p_event.GetEventKey
591: , p_user_guid => l_orcl_guid

Line 592: , p_owner => fnd_oid_util.G_CUST

588: /*fnd_create_update(
589: p_event_type => l_event_name
590: , p_user_name => p_event.GetEventKey
591: , p_user_guid => l_orcl_guid
592: , p_owner => fnd_oid_util.G_CUST
593: , p_unencrypted_password => null
594: , p_description => null
595: , p_email_address => null
596: , p_fax => null

Line 597: , p_start_date => fnd_oid_util.G_NULL

593: , p_unencrypted_password => null
594: , p_description => null
595: , p_email_address => null
596: , p_fax => null
597: , p_start_date => fnd_oid_util.G_NULL
598: , p_end_date => fnd_oid_util.G_NULL
599: , x_user_id => l_user_id);*/
600: fnd_create_update(
601: p_wf_event => p_event

Line 598: , p_end_date => fnd_oid_util.G_NULL

594: , p_description => null
595: , p_email_address => null
596: , p_fax => null
597: , p_start_date => fnd_oid_util.G_NULL
598: , p_end_date => fnd_oid_util.G_NULL
599: , x_user_id => l_user_id);*/
600: fnd_create_update(
601: p_wf_event => p_event
602: , p_event_type => wf_oid.SUBSCRIPTION_DELETE

Line 635: where entity_type = fnd_oid_util.G_USER

631: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is
632: select attribute_name
633: , attribute_value
634: from wf_attribute_cache
635: where entity_type = fnd_oid_util.G_USER
636: and entity_key_value = p_user_name
637: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;
638:
639: l_module_source varchar2(256);

Line 637: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;

633: , attribute_value
634: from wf_attribute_cache
635: where entity_type = fnd_oid_util.G_USER
636: and entity_key_value = p_user_name
637: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;
638:
639: l_module_source varchar2(256);
640: l_user_name fnd_user.user_name%type;
641: l_result pls_integer;

Line 755: if(l_apps_sso_link_truth_src is NULL or l_apps_sso_link_truth_src = fnd_oid_util.G_OID)

751: val_z => l_apps_sso_link_truth_src,
752: defined_z => l_profile_defined);
753:
754:
755: if(l_apps_sso_link_truth_src is NULL or l_apps_sso_link_truth_src = fnd_oid_util.G_OID)
756: then
757: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
758: then
759: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 762: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,

758: then
759: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
760: ' OID is source of Truth during linking ');
761: end if;
762: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
763: p_result => l_result);
764:
765: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
766: then

Line 829: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,

825: -- assign_default_resp(
826: -- p_user_name=>l_user_name
827: -- );
828:
829: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
830: p_result => l_result);
831: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
832: then
833: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 868: --need constants for these in FND_OID_UTIL

864: then
865: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
866: end if;
867: --RDESPOTO, 09/07/2004
868: --need constants for these in FND_OID_UTIL
869: l_event_id := p_event.GetValueForParameter('ENTITY_ID');
870: l_user_name:= p_event.GetValueForParameter('USER_NAME');
871: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
872:

Line 924: --need constants for these in FND_OID_UTIL

920: then
921: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
922: end if;
923: --RDESPOTO, 09/07/2004
924: --need constants for these in FND_OID_UTIL
925: l_event_id := p_event.GetValueForParameter('ENTITY_ID');
926: l_user_name:= p_event.GetValueForParameter('USER_NAME');
927: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
928:

Line 981: fnd_oid_util.G_CHANGE_SOURCE);

977: 'EBIZ is NOW capable of understanding IDENTITY_ADD.');
978: end if;
979: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
980: l_change_source := p_event.GetValueForParameter(
981: fnd_oid_util.G_CHANGE_SOURCE);
982: --Change_source has to be OID
983: if (l_change_source = fnd_oid_util.G_OID) then
984: hz_create_update(
985: p_wf_event => p_event

Line 983: if (l_change_source = fnd_oid_util.G_OID) then

979: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
980: l_change_source := p_event.GetValueForParameter(
981: fnd_oid_util.G_CHANGE_SOURCE);
982: --Change_source has to be OID
983: if (l_change_source = fnd_oid_util.G_OID) then
984: hz_create_update(
985: p_wf_event => p_event
986: , p_event_type => wf_oid.IDENTITY_ADD
987: , p_return_status => l_return_status);

Line 1009: l_ldap_message fnd_oid_util.ldap_message_type;

1005: , p_event in out nocopy wf_event_t)
1006: return varchar2 is
1007:
1008: l_module_source varchar2(256);
1009: l_ldap_message fnd_oid_util.ldap_message_type;
1010: l_return_status varchar2(1);
1011: hz_failed_exp exception;
1012:
1013: begin

Line 1092: l_ldap_message fnd_oid_util.ldap_message_type;

1088: , p_event in out nocopy wf_event_t)
1089: return varchar2 is
1090:
1091: l_module_source varchar2(256);
1092: l_ldap_message fnd_oid_util.ldap_message_type;
1093: l_return_status varchar2(1);
1094: hz_failed_exp exception;
1095:
1096: begin

Line 1176: l_ldap_message fnd_oid_util.ldap_message_type;

1172: , p_return_status out nocopy varchar2
1173: ) is
1174:
1175: l_module_source varchar2(256);
1176: l_ldap_message fnd_oid_util.ldap_message_type;
1177: l_return_status varchar2(1);
1178: l_count number;
1179: l_event_key varchar2(256);
1180:

Line 1191: if (fnd_oid_util.person_party_exists(p_wf_event.GetEventKey))

1187: end if;
1188:
1189: fnd_ldap_mapper.map_ldap_message(p_wf_event, p_event_type, l_ldap_message);
1190:
1191: if (fnd_oid_util.person_party_exists(p_wf_event.GetEventKey))
1192: then
1193: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1194: then
1195: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

Line 1294: l_apps_user_key fnd_oid_util.apps_user_key_type;

1290: -------------------------------------------------------------------------------
1291: procedure assign_default_resp(p_user_name in varchar2) is
1292:
1293: l_module_source varchar2(256);
1294: l_apps_user_key fnd_oid_util.apps_user_key_type;
1295: l_found boolean := false;
1296:
1297: l_responsibility_id fnd_responsibility.responsibility_id%type;
1298: l_application_id fnd_responsibility.application_id%type;

Line 1309: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);

1305: then
1306: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1307: end if;
1308:
1309: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
1310:
1311: l_resp_key := 'PREFERENCES';
1312: get_resp_app_id(p_resp_key => l_resp_key
1313: , x_responsibility_id=>l_responsibility_id

Line 1362: l_apps_user_key fnd_oid_util.apps_user_key_type;

1358: l_module_source varchar2(256);
1359: l_event_name varchar2(256);
1360: l_event_key varchar2(256);
1361: l_change_source varchar2(256);
1362: l_apps_user_key fnd_oid_util.apps_user_key_type;
1363: l_found boolean := false;
1364:
1365: l_responsibility_id fnd_responsibility.responsibility_id%type;
1366: l_application_id fnd_responsibility.application_id%type;

Line 1380: fnd_oid_util.G_CHANGE_SOURCE);

1376:
1377: l_event_key := p_event.GetEventKey;
1378: l_event_name := WF_OID.SUBSCRIPTION_ADD;
1379: l_change_source := p_event.GetValueForParameter(
1380: fnd_oid_util.G_CHANGE_SOURCE);
1381:
1382: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1383: then
1384: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

Line 1390: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_event_key);

1386: ', l_event_name = ' || l_event_name ||
1387: ', l_change_source = ' || l_change_source);
1388: end if;
1389:
1390: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_event_key);
1391:
1392: l_resp_key := 'PREFERENCES';
1393: get_resp_app_id(p_resp_key => l_resp_key
1394: , x_responsibility_id=>l_responsibility_id