[Home] [Help]
114: begin
115:
116: select security_group_key
117: into secgrpkey
118: from fnd_security_groups
119: where security_group_id = x_secgrp_id;
120:
121: select application_short_name
122: into appsname
882: where responsibility_key = X_RESP_KEY
883: and application_id = app_id;
884:
885: select security_group_id into sgroup_id
886: from fnd_security_groups
887: where security_group_key = X_SECURITY_GROUP;
888:
889: select decode(X_END_DATE,
890: fnd_load_util.null_value, null,
1108: if (secgrpkey is null) then
1109: begin
1110: select security_group_key
1111: into l_secgrpkey
1112: from fnd_security_groups
1113: where security_group_id = secgrpid;
1114: exception
1115: when no_data_found then
1116: return; /* Bad foreign key; we can't build a role. Return. */
1159: if (secgrpid <> 0) then
1160: begin
1161: select security_group_name
1162: into secgrp_name
1163: from fnd_security_groups_tl
1164: where security_group_id = secgrpid
1165: and language = (select language_code
1166: from fnd_languages
1167: where installed_flag = 'B');
1312: is
1313: cursor get_secgrp is
1314: select security_group_id,
1315: security_group_key
1316: from fnd_security_groups;
1317:
1318: begin
1319:
1320: if (check_secgrp_enabled(respid, appid) = 'N') then
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
1475: = resp.application_id
1658: is
1659: cursor get_secgrp is
1660: select security_group_id,
1661: security_group_key
1662: from fnd_security_groups;
1663:
1664: rolename varchar2(320);
1665: dummy number;
1666: