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 825: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',

821: wf_event.addparametertolist(p_name => 'FND_USER_ID',
822: p_value => Update_Assignment.user_id,
823: p_parameterlist => l_parameters);
824:
825: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
826: p_value => Update_Assignment.responsibility_id,
827: p_parameterlist => l_parameters);
828:
829: wf_event.addparametertolist(p_name => 'FND_APPS_SHORT_NAME',

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

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

Line 881: from fnd_responsibility

877: from fnd_application
878: where application_short_name = X_APP_SHORT_NAME;
879:
880: select responsibility_id into resp_id
881: from fnd_responsibility
882: where responsibility_key = X_RESP_KEY
883: and application_id = app_id;
884:
885: select security_group_id into sgroup_id

Line 1096: from fnd_responsibility

1092: if (respkey is null) then
1093: begin
1094: select responsibility_key
1095: into l_respkey
1096: from fnd_responsibility
1097: where responsibility_id = respid
1098: and application_id = appid;
1099: exception
1100: when no_data_found then

Line 1144: from fnd_responsibility_tl

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

Line 1186: from fnd_responsibility

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

Line 1362: from fnd_responsibility;

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

Line 1400: from fnd_responsibility;

1396: responsibility_id,
1397: responsibility_key,
1398: start_date,
1399: end_date
1400: from fnd_responsibility;
1401: begin
1402:
1403: if (sync_all_flag = TRUE) then
1404: for resprec in get_resp loop

Line 1470: fnd_responsibility resp,

1466: furgo.last_update_login
1467: from fnd_user_resp_groups_old furgo,
1468: fnd_user fu,
1469: fnd_application app,
1470: fnd_responsibility resp,
1471: fnd_security_groups secgrp
1472: where furgo.user_id = fu.user_id
1473: and furgo.responsibility_id = resp.responsibility_id
1474: and furgo.responsibility_application_id