DBA Data[Home] [Help]

APPS.FND_USER_RESP_GROUPS_API dependencies on STANDARD

Line 1154: /* Don't need the name for STANDARD, so skip the select */

1150: descr := NULL;
1151: end;
1152:
1153: /* Get the security group name of base language for role display name */
1154: /* Don't need the name for STANDARD, so skip the select */
1155: if (secgrpid <> 0) then
1156: begin
1157: select security_group_name
1158: into secgrp_name

Line 1196: if(secgrpkey = 'STANDARD') then

1192: -- attribute values.
1193: wf_parameters := NULL;
1194: wf_event.AddParameterToList('USER_NAME',
1195: role_name , wf_parameters);
1196: if(secgrpkey = 'STANDARD') then
1197: role_display_name := resp_name;
1198: else
1199: role_display_name := resp_name||':'||secgrp_name;
1200: end if;

Line 1318: -- only create a role for the STANDARD sec grp.

1314: begin
1315:
1316: if (check_secgrp_enabled(respid, appid) = 'N') then
1317: -- Security Groups not enabled for this resp,
1318: -- only create a role for the STANDARD sec grp.
1319: sync_roles_one_resp_secgrp( respid=> respid,
1320: appid=> appid,
1321: respkey=> respkey,
1322: secgrpid=> 0,

Line 1323: secgrpkey=> 'STANDARD',

1319: sync_roles_one_resp_secgrp( respid=> respid,
1320: appid=> appid,
1321: respkey=> respkey,
1322: secgrpid=> 0,
1323: secgrpkey=> 'STANDARD',
1324: startdate=> startdate,
1325: enddate=> enddate);
1326: else
1327: -- Security Groups are enabled, create one role for

Line 1361: -- If secgrp is STANDARD, then create resp/secgrp role for all resps.

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.
1363: if ((secgrpid = 0) or
1364: (check_secgrp_enabled(resprec.responsibility_id,
1365: resprec.application_id) = 'Y'))

Line 1667: -- only create a role for the STANDARD sec grp.

1663: begin
1664:
1665: if (check_secgrp_enabled(respid, appid) = 'N') then
1666: -- Security Groups not enabled for this resp,
1667: -- only create a role for the STANDARD sec grp.
1668: sync_roles_one_resp_secgrp( respid=> respid,
1669: appid=> appid,
1670: respkey=> respkey,
1671: secgrpid=> 0,

Line 1672: secgrpkey=> 'STANDARD',

1668: sync_roles_one_resp_secgrp( respid=> respid,
1669: appid=> appid,
1670: respkey=> respkey,
1671: secgrpid=> 0,
1672: secgrpkey=> 'STANDARD',
1673: startdate=> startdate,
1674: enddate=> enddate);
1675: else
1676: -- Security Groups are enabled, create one role for