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_USER

Line 23: , p_user_name in fnd_user.user_name%type

19: ** Parameters :
20: */
21: procedure fnd_create_update(
22: p_event_type in varchar2
23: , p_user_name in fnd_user.user_name%type
24: , p_owner in varchar2
25: , p_unencrypted_password in varchar2
26: , p_description in fnd_user.description%type
27: , p_email_address in fnd_user.email_address%type

Line 26: , p_description in fnd_user.description%type

22: p_event_type in varchar2
23: , p_user_name in fnd_user.user_name%type
24: , p_owner in varchar2
25: , p_unencrypted_password in varchar2
26: , p_description in fnd_user.description%type
27: , p_email_address in fnd_user.email_address%type
28: , p_fax in fnd_user.fax%type
29: , p_start_date in varchar2
30: , p_end_date in varchar2

Line 27: , p_email_address in fnd_user.email_address%type

23: , p_user_name in fnd_user.user_name%type
24: , p_owner in varchar2
25: , p_unencrypted_password in varchar2
26: , p_description in fnd_user.description%type
27: , p_email_address in fnd_user.email_address%type
28: , p_fax in fnd_user.fax%type
29: , p_start_date in varchar2
30: , p_end_date in varchar2
31: , p_isenabled in varchar2

Line 28: , p_fax in fnd_user.fax%type

24: , p_owner in varchar2
25: , p_unencrypted_password in varchar2
26: , p_description in fnd_user.description%type
27: , p_email_address in fnd_user.email_address%type
28: , p_fax in fnd_user.fax%type
29: , p_start_date in varchar2
30: , p_end_date in varchar2
31: , p_isenabled in varchar2
32: , p_user_guid in fnd_user.user_guid%type

Line 32: , p_user_guid in fnd_user.user_guid%type

28: , p_fax in fnd_user.fax%type
29: , p_start_date in varchar2
30: , p_end_date in varchar2
31: , p_isenabled in varchar2
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;

Line 33: , x_user_id out nocopy fnd_user.user_id%type

29: , p_start_date in varchar2
30: , p_end_date in varchar2
31: , p_isenabled in varchar2
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;

Line 38: l_user_name fnd_user.user_name%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;
42: l_profile_defined boolean;

Line 45: l_description fnd_user.description%type;

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;
46: l_fax fnd_user.fax%type;
47: l_email_address fnd_user.email_address%type;
48:
49:

Line 46: l_fax fnd_user.fax%type;

42: l_profile_defined boolean;
43: l_start_date date;
44: l_end_date date;
45: l_description fnd_user.description%type;
46: l_fax fnd_user.fax%type;
47: l_email_address fnd_user.email_address%type;
48:
49:
50: begin

Line 47: l_email_address fnd_user.email_address%type;

43: l_start_date date;
44: l_end_date date;
45: l_description fnd_user.description%type;
46: l_fax fnd_user.fax%type;
47: l_email_address fnd_user.email_address%type;
48:
49:
50: begin
51: l_module_source := G_MODULE_SOURCE || 'fnd_create_update: ';

Line 59: || 'event is handled by fnd_user_pkg.user_change().');

55: end if;
56: if (p_event_type = wf_oid.IDENTITY_MODIFY) then
57: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
58: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'IDENTITY_MODIFY '
59: || 'event is handled by fnd_user_pkg.user_change().');
60: end if;
61: return;
62: end if;
63: --Check whether this guid already exists. Don't raise alerts because we receive echo

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 68: update fnd_user set end_date= sysdate

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;
70: end if;
71: if (l_apps_userguid_key.user_id is not null) then
72: if(fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then

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 107: 'User ' || p_user_name || ' will not be created in FND_USER, because ' ||

103: -- Don't create user if disabled in OID
104: if (p_isenabled = 'INACTIVE' or p_isenabled = 'DISABLED') then
105: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
106: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
107: 'User ' || p_user_name || ' will not be created in FND_USER, because ' ||
108: 'it''s Disabled in OID.');
109: end if;
110: return;
111: end if;

Line 113: --This means neither user name nor guid exist in fnd_user

109: end if;
110: return;
111: end if;
112:
113: --This means neither user name nor guid exist in fnd_user
114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
115: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
116: 'User does not exist in FND_USER. About to create a new user...');
117: end if;

Line 116: 'User does not exist in FND_USER. About to create a new user...');

112:
113: --This means neither user name nor guid exist in fnd_user
114: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
115: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
116: 'User does not exist in FND_USER. About to create a new user...');
117: end if;
118: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
119: then
120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);

Line 124: -- we should not populate the fnd_user table with this, for fax and description.

120: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Start_date input: ' || p_start_date);
121: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date input: ' || p_end_date);
122: end if;
123: -- WF_ENTITY_MGR returns '*UNKNOWN*' string if the value was not found in attr_cache table
124: -- we should not populate the fnd_user table with this, for fax and description.
125:
126: -- Bug 5347086 - fnd_user_pkg does not check for UNKNOWN when creating the user. Doing it here
127: if (p_description in ('*UNKNOWN*','*NULL*')) then
128: l_description := null;

Line 126: -- Bug 5347086 - fnd_user_pkg does not check for UNKNOWN when creating the user. Doing it here

122: end if;
123: -- WF_ENTITY_MGR returns '*UNKNOWN*' string if the value was not found in attr_cache table
124: -- we should not populate the fnd_user table with this, for fax and description.
125:
126: -- Bug 5347086 - fnd_user_pkg does not check for UNKNOWN when creating the user. Doing it here
127: if (p_description in ('*UNKNOWN*','*NULL*')) then
128: l_description := null;
129: else
130: l_description := p_description;

Line 167: x_user_id := fnd_user_pkg.CreateUserId(

163: then
164: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'End_date output: ' || l_end_date);
165: end if;
166:
167: x_user_id := fnd_user_pkg.CreateUserId(
168: x_user_name => p_user_name
169: , x_owner => p_owner
170: , x_unencrypted_password => fnd_web_sec.EXTERNAL_PWD -- passowrd will be set to EXTERNAL
171: , x_description => l_description

Line 177: , x_change_source => fnd_user_pkg.change_source_oid

173: , x_start_date => l_start_date
174: , x_end_date => l_end_date
175: , x_fax => l_fax
176: , x_user_guid => p_user_guid
177: , x_change_source => fnd_user_pkg.change_source_oid
178: );
179:
180: -- API to set user profile value;
181: l_found := fnd_profile.save(x_name => 'APPS_SSO_LOCAL_LOGIN'

Line 208: , p_user_name in fnd_user.user_name%type

204:
205: procedure fnd_create_update(
206: p_wf_event in wf_event_t
207: , p_event_type in varchar2
208: , p_user_name in fnd_user.user_name%type
209: , p_user_guid in fnd_user.user_guid%type
210: , x_user_id out nocopy fnd_user.user_id%type
211: ) is
212:

Line 209: , p_user_guid in fnd_user.user_guid%type

205: procedure fnd_create_update(
206: p_wf_event in wf_event_t
207: , p_event_type in varchar2
208: , p_user_name in fnd_user.user_name%type
209: , p_user_guid in fnd_user.user_guid%type
210: , x_user_id out nocopy fnd_user.user_id%type
211: ) is
212:
213: l_module_source varchar2(256);

Line 210: , x_user_id out nocopy fnd_user.user_id%type

206: p_wf_event in wf_event_t
207: , p_event_type in varchar2
208: , p_user_name in fnd_user.user_name%type
209: , p_user_guid in fnd_user.user_guid%type
210: , x_user_id out nocopy fnd_user.user_id%type
211: ) is
212:
213: l_module_source varchar2(256);
214: l_description fnd_user.description%type;

Line 214: l_description fnd_user.description%type;

210: , x_user_id out nocopy fnd_user.user_id%type
211: ) is
212:
213: l_module_source varchar2(256);
214: l_description fnd_user.description%type;
215: l_email_address fnd_user.email_address%type;
216: l_fax fnd_user.fax%type;
217: l_user_id number;
218: l_start_date varchar2(4000);

Line 215: l_email_address fnd_user.email_address%type;

211: ) is
212:
213: l_module_source varchar2(256);
214: l_description fnd_user.description%type;
215: l_email_address fnd_user.email_address%type;
216: l_fax fnd_user.fax%type;
217: l_user_id number;
218: l_start_date varchar2(4000);
219: l_end_date varchar2(4000);

Line 216: l_fax fnd_user.fax%type;

212:
213: l_module_source varchar2(256);
214: l_description fnd_user.description%type;
215: l_email_address fnd_user.email_address%type;
216: l_fax fnd_user.fax%type;
217: l_user_id number;
218: l_start_date varchar2(4000);
219: l_end_date varchar2(4000);
220: l_isenabled varchar2(4000);

Line 314: l_orcl_guid fnd_user.user_guid%type;

310: l_event_name varchar2(256);
311: l_event_key varchar2(256);
312: l_change_source varchar2(256);
313: l_user_id number;
314: l_orcl_guid fnd_user.user_guid%type;
315:
316: begin
317: l_module_source := G_MODULE_SOURCE || 'identity_add: ';
318:

Line 375: l_orcl_guid fnd_user.user_guid%type;

371: return varchar2 is
372:
373: l_module_source varchar2(256);
374: l_user_id number;
375: l_orcl_guid fnd_user.user_guid%type;
376:
377: begin
378: l_module_source := G_MODULE_SOURCE || 'identity_modify: ';
379:

Line 384: --THIS SUBSCRIPTION IS NOT USED! fnd_user_pkg.user_change SUBSCRIPTION IS USED INSTEAD.

380: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
381: then
382: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
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(

Line 452: * EBIZ -> Linking of an FND_USER to OID user

448: -------------------------------------------------------------------------------
449: /**
450: * This subscription handles the following events:
451: * OID -> User subscribing to an EBIZ instance
452: * EBIZ -> Linking of an FND_USER to OID user
453: * In both instances a SUBSCRIPTION_ADD event is raised. The change_source
454: * attribute is however different as below:
455: * OID -> change_source attribute is OID
456: * EBIZ -> change_source attribute is EBIZ

Line 457: * Please make sure that the change_source is indeed EBIZ and not FND_USER

453: * In both instances a SUBSCRIPTION_ADD event is raised. The change_source
454: * attribute is however different as below:
455: * OID -> change_source attribute is OID
456: * EBIZ -> change_source attribute is EBIZ
457: * Please make sure that the change_source is indeed EBIZ and not FND_USER
458: * when the event is raised by EBIZ.
459: */
460: function subscription_add(
461: p_subscription_guid in raw

Line 471: l_orcl_guid fnd_user.user_guid%type;

467: l_event_name varchar2(256);
468: l_event_key varchar2(256);
469: l_change_source varchar2(256);
470: l_user_id number;
471: l_orcl_guid fnd_user.user_guid%type;
472:
473: begin
474: l_module_source := G_MODULE_SOURCE || 'subscription_add: ';
475:

Line 532: * EBIZ -> Uninking of an FND_USER with the OID user

528: -------------------------------------------------------------------------------
529: /**
530: * This subscription handles the following events:
531: * OID -> User unsubscribing to an EBIZ instance
532: * EBIZ -> Uninking of an FND_USER with the OID user
533: * In both instances a SUBSCRIPTION_DELETE event is raises. The change_source
534: * attribute is however different as below:
535: * OID -> change_source attribute is OID
536: * EBIZ -> change_source attribute is EBIZ

Line 537: * Please make sure that the change_source is indeed EBIZ and not FND_USER

533: * In both instances a SUBSCRIPTION_DELETE event is raises. The change_source
534: * attribute is however different as below:
535: * OID -> change_source attribute is OID
536: * EBIZ -> change_source attribute is EBIZ
537: * Please make sure that the change_source is indeed EBIZ and not FND_USER
538: * when the event is raised by EBIZ.
539: */
540: function subscription_delete(
541: p_subscription_guid in raw

Line 551: l_orcl_guid fnd_user.user_guid%type;

547: l_event_name varchar2(256);
548: l_event_key varchar2(256);
549: l_change_source varchar2(256);
550: l_user_id number;
551: l_orcl_guid fnd_user.user_guid%type;
552:
553:
554: begin
555: l_module_source := G_MODULE_SOURCE || 'subscription_delete: ';

Line 640: l_user_name fnd_user.user_name%type;

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;
642:
643: l_old_user_guid fnd_user.user_guid%type;
644: l_user_guid fnd_user.user_guid%type;

Line 643: l_old_user_guid fnd_user.user_guid%type;

639: l_module_source varchar2(256);
640: l_user_name fnd_user.user_name%type;
641: l_result pls_integer;
642:
643: l_old_user_guid fnd_user.user_guid%type;
644: l_user_guid fnd_user.user_guid%type;
645: l_user_guid_changed boolean;
646:
647: l_old_person_party_id fnd_user.person_party_id%type;

Line 644: l_user_guid fnd_user.user_guid%type;

640: l_user_name fnd_user.user_name%type;
641: l_result pls_integer;
642:
643: l_old_user_guid fnd_user.user_guid%type;
644: l_user_guid fnd_user.user_guid%type;
645: l_user_guid_changed boolean;
646:
647: l_old_person_party_id fnd_user.person_party_id%type;
648: l_person_party_id fnd_user.person_party_id%type;

Line 647: l_old_person_party_id fnd_user.person_party_id%type;

643: l_old_user_guid fnd_user.user_guid%type;
644: l_user_guid fnd_user.user_guid%type;
645: l_user_guid_changed boolean;
646:
647: l_old_person_party_id fnd_user.person_party_id%type;
648: l_person_party_id fnd_user.person_party_id%type;
649: l_person_party_id_changed boolean;
650: l_apps_sso_link_truth_src varchar2(5);
651: l_profile_defined boolean;

Line 648: l_person_party_id fnd_user.person_party_id%type;

644: l_user_guid fnd_user.user_guid%type;
645: l_user_guid_changed boolean;
646:
647: l_old_person_party_id fnd_user.person_party_id%type;
648: l_person_party_id fnd_user.person_party_id%type;
649: l_person_party_id_changed boolean;
650: l_apps_sso_link_truth_src varchar2(5);
651: l_profile_defined boolean;
652: begin

Line 804: l_user_name fnd_user.user_name%type;

800: , p_event in out nocopy wf_event_t)
801: return varchar2 is
802:
803: l_module_source varchar2(256);
804: l_user_name fnd_user.user_name%type;
805: l_user_guid fnd_user.user_guid%type;
806: l_result pls_integer;
807:
808: begin

Line 805: l_user_guid fnd_user.user_guid%type;

801: return varchar2 is
802:
803: l_module_source varchar2(256);
804: l_user_name fnd_user.user_name%type;
805: l_user_guid fnd_user.user_guid%type;
806: l_result pls_integer;
807:
808: begin
809: l_module_source := G_MODULE_SOURCE || ' on_demand_user_create: ';

Line 857: l_user_name fnd_user.user_name%type;

853: return varchar2 is
854:
855: l_module_source varchar2(256);
856: l_event_id wf_entity_changes.entity_id%type;
857: l_user_name fnd_user.user_name%type;
858: l_user_guid fnd_user.user_guid%type;
859:
860: begin
861: l_module_source := G_MODULE_SOURCE || 'event_error: ';

Line 858: l_user_guid fnd_user.user_guid%type;

854:
855: l_module_source varchar2(256);
856: l_event_id wf_entity_changes.entity_id%type;
857: l_user_name fnd_user.user_name%type;
858: l_user_guid fnd_user.user_guid%type;
859:
860: begin
861: l_module_source := G_MODULE_SOURCE || 'event_error: ';
862:

Line 913: l_user_name fnd_user.user_name%type;

909: return varchar2 is
910:
911: l_module_source varchar2(256);
912: l_event_id wf_entity_changes.entity_id%type;
913: l_user_name fnd_user.user_name%type;
914: l_user_guid fnd_user.user_guid%type;
915:
916: begin
917: l_module_source := G_MODULE_SOURCE || 'event_resend: ';

Line 914: l_user_guid fnd_user.user_guid%type;

910:
911: l_module_source varchar2(256);
912: l_event_id wf_entity_changes.entity_id%type;
913: l_user_name fnd_user.user_name%type;
914: l_user_guid fnd_user.user_guid%type;
915:
916: begin
917: l_module_source := G_MODULE_SOURCE || 'event_resend: ';
918:

Line 1196: 'Person Party exists in FND_USER');

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,
1196: 'Person Party exists in FND_USER');
1197: end if;
1198: fnd_oid_users.hz_update(
1199: p_ldap_message => l_ldap_message
1200: , x_return_status => p_return_status);

Line 1204: from fnd_user

1200: , x_return_status => p_return_status);
1201: else
1202: l_event_key := p_wf_event.GetEventKey;
1203: select count(*) into l_count
1204: from fnd_user
1205: where user_name = l_event_key
1206: and user_guid is not null;
1207:
1208: if (l_count > 0) then

Line 1212: 'Person Party does NOT exist in FND_USER, creating a new TCA entry');

1208: if (l_count > 0) then
1209: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1210: then
1211: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1212: 'Person Party does NOT exist in FND_USER, creating a new TCA entry');
1213: end if;
1214: fnd_oid_users.hz_create(
1215: p_ldap_message => l_ldap_message
1216: , x_return_status => p_return_status);

Line 1221: 'FND User is not linked to OID user, therefore not creating TCA party');

1217: else
1218: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1219: then
1220: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source,
1221: 'FND User is not linked to OID user, therefore not creating TCA party');
1222: end if;
1223: end if;
1224:
1225: end if;

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 1317: l_found := fnd_user_resp_groups_api.assignment_exists(

1313: , x_responsibility_id=>l_responsibility_id
1314: , x_application_id=>l_application_id
1315: );
1316:
1317: l_found := fnd_user_resp_groups_api.assignment_exists(
1318: user_id => l_apps_user_key.user_id
1319: , responsibility_id => l_responsibility_id
1320: , responsibility_application_id => l_application_id
1321: , security_group_id => null);

Line 1325: fnd_user_resp_groups_api.insert_assignment(

1321: , security_group_id => null);
1322:
1323: if (not l_found)
1324: then
1325: fnd_user_resp_groups_api.insert_assignment(
1326: user_id => l_apps_user_key.user_id
1327: , responsibility_id => l_responsibility_id
1328: , responsibility_application_id => l_application_id
1329: , security_group_id => null

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

Line 1402: l_found := fnd_user_resp_groups_api.assignment_exists(

1398:
1399: /* check whether the user is already assigned the responsibility */
1400:
1401:
1402: l_found := fnd_user_resp_groups_api.assignment_exists(
1403: user_id => l_apps_user_key.user_id
1404: , responsibility_id => l_responsibility_id
1405: , responsibility_application_id => l_application_id
1406: , security_group_id => null);

Line 1412: fnd_user_resp_groups_api.insert_assignment(

1408: /* If user is not assigned the responsibility,assign the default responsibility */
1409:
1410: if (not l_found)
1411: then
1412: fnd_user_resp_groups_api.insert_assignment(
1413: user_id => l_apps_user_key.user_id
1414: , responsibility_id => l_responsibility_id
1415: , responsibility_application_id => l_application_id
1416: , security_group_id => null