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 478: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;

474: , p_event in out nocopy wf_event_t)
475: return varchar2 is
476:
477: l_module_source varchar2(256);
478: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;
479: l_event_name varchar2(256);
480: l_event_key varchar2(256);
481: l_change_source varchar2(256);
482: l_user_id number;

Line 496: fnd_oid_util.G_CHANGE_SOURCE);

492: l_event_key := p_event.GetEventKey;
493: l_event_name := WF_OID.SUBSCRIPTION_ADD;
494:
495: l_change_source := p_event.GetValueForParameter(
496: fnd_oid_util.G_CHANGE_SOURCE);
497:
498: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
499: then
500: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

502: ', l_event_name = ' || l_event_name ||
503: ', l_change_source = ' || l_change_source);
504: end if;
505:
506: if (l_change_source = fnd_oid_util.G_OID) then
507: l_orcl_guid := p_event.GetValueForParameter(
508: fnd_oid_util.G_ORCLGUID);
509: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
510: then

Line 508: fnd_oid_util.G_ORCLGUID);

504: end if;
505:
506: if (l_change_source = fnd_oid_util.G_OID) then
507: l_orcl_guid := p_event.GetValueForParameter(
508: fnd_oid_util.G_ORCLGUID);
509: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
510: then
511: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'User_guid is:'
512: || l_orcl_guid || ', user_name is ' || l_event_key);

Line 558: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;

554: , p_event in out nocopy wf_event_t)
555: return varchar2 is
556:
557: l_module_source varchar2(256);
558: l_sso_user_profiles fnd_oid_util.apps_sso_user_profiles_type;
559: l_event_name varchar2(256);
560: l_event_key varchar2(256);
561: l_change_source varchar2(256);
562: l_user_id number;

Line 577: fnd_oid_util.G_CHANGE_SOURCE);

573:
574: l_event_key := p_event.GetEventKey;
575: l_event_name := WF_OID.SUBSCRIPTION_DELETE;
576: l_change_source := p_event.GetValueForParameter(
577: fnd_oid_util.G_CHANGE_SOURCE);
578:
579: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
580: then
581: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

Line 589: if (l_change_source = fnd_oid_util.G_EBIZ)

585: end if;
586:
587: l_sso_user_profiles := fnd_ldap_mapper.map_sso_user_profiles(l_event_key);
588:
589: if (l_change_source = fnd_oid_util.G_EBIZ)
590: then
591: insert into wf_entity_changes(
592: entity_type, entity_key_value, flavor, change_date)
593: values(

Line 599: fnd_oid_util.G_ORCLGUID);

595:
596: else
597: --Rada, 01/31/2005
598: l_orcl_guid := p_event.GetValueForParameter(
599: fnd_oid_util.G_ORCLGUID);
600: /*fnd_create_update(
601: p_event_type => l_event_name
602: , p_user_name => p_event.GetEventKey
603: , p_user_guid => l_orcl_guid

Line 604: , p_owner => fnd_oid_util.G_CUST

600: /*fnd_create_update(
601: p_event_type => l_event_name
602: , p_user_name => p_event.GetEventKey
603: , p_user_guid => l_orcl_guid
604: , p_owner => fnd_oid_util.G_CUST
605: , p_unencrypted_password => null
606: , p_description => null
607: , p_email_address => null
608: , p_fax => null

Line 609: , p_start_date => fnd_oid_util.G_NULL

605: , p_unencrypted_password => null
606: , p_description => null
607: , p_email_address => null
608: , p_fax => null
609: , p_start_date => fnd_oid_util.G_NULL
610: , p_end_date => fnd_oid_util.G_NULL
611: , x_user_id => l_user_id);*/
612: fnd_create_update(
613: p_wf_event => p_event

Line 610: , p_end_date => fnd_oid_util.G_NULL

606: , p_description => null
607: , p_email_address => null
608: , p_fax => null
609: , p_start_date => fnd_oid_util.G_NULL
610: , p_end_date => fnd_oid_util.G_NULL
611: , x_user_id => l_user_id);*/
612: fnd_create_update(
613: p_wf_event => p_event
614: , p_event_type => wf_oid.SUBSCRIPTION_DELETE

Line 647: where entity_type = fnd_oid_util.G_USER

643: cursor cur_attribute_cache(p_user_name in wf_attribute_cache.entity_key_value%type) is
644: select attribute_name
645: , attribute_value
646: from wf_attribute_cache
647: where entity_type = fnd_oid_util.G_USER
648: and entity_key_value = p_user_name
649: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;
650:
651: l_module_source varchar2(256);

Line 649: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;

645: , attribute_value
646: from wf_attribute_cache
647: where entity_type = fnd_oid_util.G_USER
648: and entity_key_value = p_user_name
649: and attribute_name <> fnd_oid_util.G_CACHE_CHANGED;
650:
651: l_module_source varchar2(256);
652: l_user_name fnd_user.user_name%type;
653: l_result pls_integer;

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

763: val_z => l_apps_sso_link_truth_src,
764: defined_z => l_profile_defined);
765:
766:
767: if(l_apps_sso_link_truth_src is NULL or l_apps_sso_link_truth_src = fnd_oid_util.G_OID)
768: then
769: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
770: then
771: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

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

770: then
771: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,
772: ' OID is source of Truth during linking ');
773: end if;
774: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
775: p_result => l_result);
776:
777: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
778: then

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

837: -- assign_default_resp(
838: -- p_user_name=>l_user_name
839: -- );
840:
841: fnd_oid_util.synch_user_from_LDAP_NO_AUTO(p_user_name => l_user_name,
842: p_result => l_result);
843: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
844: then
845: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,

Line 880: --need constants for these in FND_OID_UTIL

876: then
877: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
878: end if;
879: --RDESPOTO, 09/07/2004
880: --need constants for these in FND_OID_UTIL
881: l_event_id := p_event.GetValueForParameter('ENTITY_ID');
882: l_user_name:= p_event.GetValueForParameter('USER_NAME');
883: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
884:

Line 936: --need constants for these in FND_OID_UTIL

932: then
933: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Begin');
934: end if;
935: --RDESPOTO, 09/07/2004
936: --need constants for these in FND_OID_UTIL
937: l_event_id := p_event.GetValueForParameter('ENTITY_ID');
938: l_user_name:= p_event.GetValueForParameter('USER_NAME');
939: l_user_guid:= p_event.GetValueForParameter('ORCLGUID');
940:

Line 993: fnd_oid_util.G_CHANGE_SOURCE);

989: 'EBIZ is NOW capable of understanding IDENTITY_ADD.');
990: end if;
991: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
992: l_change_source := p_event.GetValueForParameter(
993: fnd_oid_util.G_CHANGE_SOURCE);
994: --Change_source has to be OID
995: if (l_change_source = fnd_oid_util.G_OID) then
996: hz_create_update(
997: p_wf_event => p_event

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

991: --RDESPOTO, Add IDENTITY_ADD, 11/09/2004
992: l_change_source := p_event.GetValueForParameter(
993: fnd_oid_util.G_CHANGE_SOURCE);
994: --Change_source has to be OID
995: if (l_change_source = fnd_oid_util.G_OID) then
996: hz_create_update(
997: p_wf_event => p_event
998: , p_event_type => wf_oid.IDENTITY_ADD
999: , p_return_status => l_return_status);

Line 1021: l_ldap_message fnd_oid_util.ldap_message_type;

1017: , p_event in out nocopy wf_event_t)
1018: return varchar2 is
1019:
1020: l_module_source varchar2(256);
1021: l_ldap_message fnd_oid_util.ldap_message_type;
1022: l_return_status varchar2(1);
1023: hz_failed_exp exception;
1024:
1025: begin

Line 1104: l_ldap_message fnd_oid_util.ldap_message_type;

1100: , p_event in out nocopy wf_event_t)
1101: return varchar2 is
1102:
1103: l_module_source varchar2(256);
1104: l_ldap_message fnd_oid_util.ldap_message_type;
1105: l_return_status varchar2(1);
1106: hz_failed_exp exception;
1107:
1108: begin

Line 1188: l_ldap_message fnd_oid_util.ldap_message_type;

1184: , p_return_status out nocopy varchar2
1185: ) is
1186:
1187: l_module_source varchar2(256);
1188: l_ldap_message fnd_oid_util.ldap_message_type;
1189: l_return_status varchar2(1);
1190: l_count number;
1191: l_event_key varchar2(256);
1192:

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

1199: end if;
1200:
1201: fnd_ldap_mapper.map_ldap_message(p_wf_event, p_event_type, l_ldap_message);
1202:
1203: if (fnd_oid_util.person_party_exists(p_wf_event.GetEventKey))
1204: then
1205: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1206: then
1207: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,

Line 1306: l_apps_user_key fnd_oid_util.apps_user_key_type;

1302: -------------------------------------------------------------------------------
1303: procedure assign_default_resp(p_user_name in varchar2) is
1304:
1305: l_module_source varchar2(256);
1306: l_apps_user_key fnd_oid_util.apps_user_key_type;
1307: l_found boolean := false;
1308:
1309: l_responsibility_id fnd_responsibility.responsibility_id%type;
1310: l_application_id fnd_responsibility.application_id%type;

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

1317: then
1318: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1319: end if;
1320:
1321: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => p_user_name);
1322:
1323: l_resp_key := 'PREFERENCES';
1324: get_resp_app_id(p_resp_key => l_resp_key
1325: , x_responsibility_id=>l_responsibility_id

Line 1374: l_apps_user_key fnd_oid_util.apps_user_key_type;

1370: l_module_source varchar2(256);
1371: l_event_name varchar2(256);
1372: l_event_key varchar2(256);
1373: l_change_source varchar2(256);
1374: l_apps_user_key fnd_oid_util.apps_user_key_type;
1375: l_found boolean := false;
1376:
1377: l_responsibility_id fnd_responsibility.responsibility_id%type;
1378: l_application_id fnd_responsibility.application_id%type;

Line 1392: fnd_oid_util.G_CHANGE_SOURCE);

1388:
1389: l_event_key := p_event.GetEventKey;
1390: l_event_name := WF_OID.SUBSCRIPTION_ADD;
1391: l_change_source := p_event.GetValueForParameter(
1392: fnd_oid_util.G_CHANGE_SOURCE);
1393:
1394: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1395: then
1396: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source

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

1398: ', l_event_name = ' || l_event_name ||
1399: ', l_change_source = ' || l_change_source);
1400: end if;
1401:
1402: l_apps_user_key := fnd_oid_util.get_fnd_user(p_user_name => l_event_key);
1403:
1404: l_resp_key := 'PREFERENCES';
1405: get_resp_app_id(p_resp_key => l_resp_key
1406: , x_responsibility_id=>l_responsibility_id