APPS.FND_USER_RESP_GROUPS_API dependencies on FND_RESPONSIBILITY

Line 128: from fnd_responsibility

124: where application_id = x_resp_appl_id;
125:
126: select responsibility_key
127: into respkey
128: from fnd_responsibility
129: where application_id = x_resp_appl_id
130: and responsibility_id = x_resp_id;
131:
132: return Role_Name_from_Resp_name(respkey, appsname, secgrpkey);

Line 358: fnd_responsibility r

354: where exists
355: (select null
356: from fnd_user u,
357: fnd_user_resp_groups urg,
358: fnd_responsibility r
359: where u.user_id = p_user_id
360: and sysdate between u.start_date and nvl(u.end_date, sysdate)
361: and urg.user_id = u.user_id
362: and urg.responsibility_application_id = p_resp_appl_id

Line 590: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

586: wf_event.addparametertolist(p_name => 'FND_USER_ID',
587: p_value => Insert_Assignment.user_id,
588: p_parameterlist => l_parameters);
589:
590: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
591: p_value => Insert_Assignment.responsibility_id,
592: p_parameterlist => l_parameters);
593:
594: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

Line 598: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',

594: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',
595: p_value => appsname,
596: p_parameterlist => l_parameters);
597:
598: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',
599: p_value => Insert_Assignment.responsibility_application_id,
600: p_parameterlist => l_parameters);
601:
602: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.insert',

Line 821: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

817: wf_event.addparametertolist(p_name => 'FND_USER_ID',
818: p_value => Update_Assignment.user_id,
819: p_parameterlist => l_parameters);
820:
821: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
822: p_value => Update_Assignment.responsibility_id,
823: p_parameterlist => l_parameters);
824:
825: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

Line 829: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',

825: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',
826: p_value => appsname,
827: p_parameterlist => l_parameters);
828:
829: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_APPS_ID',
830: p_value => Update_Assignment.responsibility_application_id,
831: p_parameterlist => l_parameters);
832:
833: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.role.update',

Line 877: from fnd_responsibility

873: from fnd_application
874: where application_short_name = X_APP_SHORT_NAME;
875:
876: select responsibility_id into resp_id
877: from fnd_responsibility
878: where responsibility_key = X_RESP_KEY
879: and application_id = app_id;
880:
881: select security_group_id into sgroup_id

Line 1092: from fnd_responsibility

1088: if (respkey is null) then
1089: begin
1090: select responsibility_key
1091: into l_respkey
1092: from fnd_responsibility
1093: where responsibility_id = respid
1094: and application_id = appid;
1095: exception
1096: when no_data_found then

Line 1140: from fnd_responsibility_tl

1136: /* Get the responsibility name of base language for role display name */
1137: begin
1138: select responsibility_name, description
1139: into resp_name, descr
1140: from fnd_responsibility_tl
1141: where responsibility_id = respid
1142: and application_id = appid
1143: and language = (select language_code
1144: from fnd_languages

Line 1182: from fnd_responsibility

1178: created_by, creation_date,
1179: last_updated_by, last_update_date, last_update_login
1180: into my_start, my_exp, my_createdby, my_creationdate,
1181: my_lastupdatedby, my_lastupdatedate, my_lastupdatelogin
1182: from fnd_responsibility
1183: where responsibility_id = respid
1184: and application_id = appid;
1185: exception
1186: when no_data_found then

Line 1358: from fnd_responsibility;

1354: responsibility_id,
1355: responsibility_key,
1356: start_date,
1357: end_date
1358: from fnd_responsibility;
1359: begin
1360: for resprec in get_resp loop
1361: -- If secgrp is STANDARD, then create resp/secgrp role for all resps.
1362: -- Otherwise, only create roles for resps with security groups enabled.

Line 1396: from fnd_responsibility;

1392: responsibility_id,
1393: responsibility_key,
1394: start_date,
1395: end_date
1396: from fnd_responsibility;
1397: begin
1398:
1399: if (sync_all_flag = TRUE) then
1400: for resprec in get_resp loop

Line 1466: fnd_responsibility resp,

1462: furgo.last_update_login
1463: from fnd_user_resp_groups_old furgo,
1464: fnd_user fu,
1465: fnd_application app,
1466: fnd_responsibility resp,
1467: fnd_security_groups secgrp
1468: where furgo.user_id = fu.user_id
1469: and furgo.responsibility_id = resp.responsibility_id
1470: and furgo.responsibility_application_id