APPS.CS_SR_SECURITY_UTIL dependencies on STANDARD

Line 314: -- enabled and is set to Standard, the following where predicate will be

310:
311: l_incident_type_id NUMBER;
312:
313: -- cursor that queries from the service JTF secure view. If security is
314: -- enabled and is set to Standard, the following where predicate will be
315: -- appended to the cursor select
316: -- OR EXISTS
317: -- ( SELECT '1'
318: -- from fnd_user_resp_groups ur,

Line 476: -- enabled and is set to Standard, the following where predicate will be

472:
473: l_incident_type_id NUMBER;
474:
475: -- cursor that queries from the service JTF secure view. If security is
476: -- enabled and is set to Standard, the following where predicate will be
477: -- appended to the cursor select
478: -- OR EXISTS
479: -- ( SELECT '1'
480: -- from fnd_user_resp_groups ur,

Line 588: ELSIF p_security_setting = 'BSTANDARD' THEN

584: The proccedure is to alter the service owned database VPD policies.
585: Logic
586: IF p_security_setting = 'ANONE' THEN
587: Disable the existing service VPD policies
588: ELSIF p_security_setting = 'BSTANDARD' THEN
589: Drop the existing Service VPD policies
590: Create the service VPD policies as 'Static' policies
591: ELSIF p_security_setting = 'CCUSTOM' THEN
592: Drop the existing Service VPD policies

Line 610: ELSIF (p_security_setting = 'BSTANDARD') OR (p_security_setting = 'CCUSTOM') THEN

606:
607: IF p_security_setting = 'ANONE' THEN
608: DISABLE_SR_POLICIES(x_return_status => x_return_status);
609:
610: ELSIF (p_security_setting = 'BSTANDARD') OR (p_security_setting = 'CCUSTOM') THEN
611: -- Drop the service owned VPD policies
612: -- Drop the VPD policy associated with CS_INCIDENTS_B_SEC object
613:
614: DBMS_RLS.drop_policy