[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
878: where responsibility_key = X_RESP_KEY
879: and application_id = app_id;
880:
881: select security_group_id into sgroup_id
882: from fnd_security_groups
883: where security_group_key = X_SECURITY_GROUP;
884:
885: select decode(X_END_DATE,
886: fnd_load_util.null_value, null,
1104: if (secgrpkey is null) then
1105: begin
1106: select security_group_key
1107: into l_secgrpkey
1108: from fnd_security_groups
1109: where security_group_id = secgrpid;
1110: exception
1111: when no_data_found then
1112: return; /* Bad foreign key; we can't build a role. Return. */
1155: if (secgrpid <> 0) then
1156: begin
1157: select security_group_name
1158: into secgrp_name
1159: from fnd_security_groups_tl
1160: where security_group_id = secgrpid
1161: and language = (select language_code
1162: from fnd_languages
1163: where installed_flag = 'B');
1308: is
1309: cursor get_secgrp is
1310: select security_group_id,
1311: security_group_key
1312: from fnd_security_groups;
1313:
1314: begin
1315:
1316: if (check_secgrp_enabled(respid, appid) = 'N') then
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
1471: = resp.application_id
1654: is
1655: cursor get_secgrp is
1656: select security_group_id,
1657: security_group_key
1658: from fnd_security_groups;
1659:
1660: rolename varchar2(320);
1661: dummy number;
1662: