DBA Data[Home] [Help]

APPS.FND_USER_RESP_GROUPS_API dependencies on STANDARD

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

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

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

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

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

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

Line 1327: secgrpkey=> 'STANDARD',

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

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

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

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

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

Line 1676: secgrpkey=> 'STANDARD',

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