eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SR_SECURITY_UTIL dependencies on DBMS_RLS

Line 201: dbms_rls.enable_policy(

197: l_api_name_full VARCHAR2(40) := g_pkg_name || '.ENABLE_SR_POLICIES';
198: BEGIN
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: dbms_rls.enable_policy(
202: object_schema => 'APPS',
203: object_name => 'CS_INCIDENTS_B_SEC',
204: policy_name => 'CS_SR_SEC_SR_ACCESS',
205: enable => TRUE );

Line 207: dbms_rls.enable_policy(

203: object_name => 'CS_INCIDENTS_B_SEC',
204: policy_name => 'CS_SR_SEC_SR_ACCESS',
205: enable => TRUE );
206:
207: dbms_rls.enable_policy(
208: object_schema => 'APPS',
209: object_name => 'CS_SR_TYPES_SELECT_SEC',
210: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS',
211: enable => TRUE );

Line 213: dbms_rls.enable_policy(

209: object_name => 'CS_SR_TYPES_SELECT_SEC',
210: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS',
211: enable => TRUE );
212:
213: dbms_rls.enable_policy(
214: object_schema => 'APPS',
215: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
216: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS',
217: enable => TRUE );

Line 219: dbms_rls.enable_policy(

215: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
216: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS',
217: enable => TRUE );
218:
219: dbms_rls.enable_policy(
220: object_schema => 'APPS',
221: object_name => 'CS_SR_ACCESS_RESP_SEC',
222: policy_name => 'CS_SR_SEC_RESP_ACCESS',
223: enable => TRUE );

Line 243: dbms_rls.enable_policy(

239: l_api_name_full VARCHAR2(40) := g_pkg_name || '.DISABLE_SR_POLICIES';
240: BEGIN
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: dbms_rls.enable_policy(
244: object_schema => 'APPS',
245: object_name => 'CS_INCIDENTS_B_SEC',
246: policy_name => 'CS_SR_SEC_SR_ACCESS',
247: enable => FALSE );

Line 249: dbms_rls.enable_policy(

245: object_name => 'CS_INCIDENTS_B_SEC',
246: policy_name => 'CS_SR_SEC_SR_ACCESS',
247: enable => FALSE );
248:
249: dbms_rls.enable_policy(
250: object_schema => 'APPS',
251: object_name => 'CS_SR_TYPES_SELECT_SEC',
252: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS',
253: enable => FALSE );

Line 255: dbms_rls.enable_policy(

251: object_name => 'CS_SR_TYPES_SELECT_SEC',
252: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS',
253: enable => FALSE );
254:
255: dbms_rls.enable_policy(
256: object_schema => 'APPS',
257: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
258: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS',
259: enable => FALSE );

Line 261: dbms_rls.enable_policy(

257: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
258: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS',
259: enable => FALSE );
260:
261: dbms_rls.enable_policy(
262: object_schema => 'APPS',
263: object_name => 'CS_SR_ACCESS_RESP_SEC',
264: policy_name => 'CS_SR_SEC_RESP_ACCESS',
265: enable => FALSE );

Line 614: DBMS_RLS.drop_policy

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
615: (object_schema => 'APPS',
616: object_name => 'CS_INCIDENTS_B_SEC',
617: policy_name => 'CS_SR_SEC_SR_ACCESS');
618:

Line 620: DBMS_RLS.drop_policy

616: object_name => 'CS_INCIDENTS_B_SEC',
617: policy_name => 'CS_SR_SEC_SR_ACCESS');
618:
619: -- Drop the VPD policy associated with CS_SR_TYPES_SELECT_SEC object
620: DBMS_RLS.drop_policy
621: (object_schema => 'APPS',
622: object_name => 'CS_SR_TYPES_SELECT_SEC',
623: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS');
624:

Line 626: DBMS_RLS.drop_policy

622: object_name => 'CS_SR_TYPES_SELECT_SEC',
623: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS');
624:
625: -- Drop the VPD policy associated with CS_JTF_RS_RESOURCE_EXTNS_SEC object
626: DBMS_RLS.drop_policy
627: (object_schema => 'APPS',
628: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
629: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS');
630:

Line 632: DBMS_RLS.drop_policy

628: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
629: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS');
630:
631: -- Drop the VPD policy associated with CS_SR_ACCESS_RESP_SEC object
632: DBMS_RLS.drop_policy
633: (object_schema => 'APPS',
634: object_name => 'CS_SR_ACCESS_RESP_SEC',
635: policy_name => 'CS_SR_SEC_RESP_ACCESS');
636:

Line 640: DBMS_RLS.add_policy

636:
637: -- re create service owned VPD policies as static VPD policies
638:
639: -- Create the VPD policy associated with CS_INCIDENTS_B_SEC object
640: DBMS_RLS.add_policy
641: (object_schema => 'APPS',
642: object_name => 'CS_INCIDENTS_B_SEC',
643: policy_name => 'CS_SR_SEC_SR_ACCESS',
644: function_schema => 'APPS',

Line 651: DBMS_RLS.add_policy

647: static_policy => FALSE,
648: long_predicate => TRUE );
649:
650: -- Create the VPD policy associated with CS_SR_TYPES_SELECT_SEC object
651: DBMS_RLS.add_policy
652: (object_schema => 'APPS',
653: object_name => 'CS_SR_TYPES_SELECT_SEC',
654: policy_name => 'CS_SR_SEC_SRTYPE_ACCESS',
655: function_schema => 'APPS',

Line 662: DBMS_RLS.add_policy

658: static_policy => FALSE,
659: long_predicate => TRUE );
660:
661: -- Create the VPD policy associated with CS_JTF_RS_RESOURCE_EXTNS_SEC object
662: DBMS_RLS.add_policy
663: (object_schema => 'APPS',
664: object_name => 'CS_JTF_RS_RESOURCE_EXTNS_SEC',
665: policy_name => 'CS_SR_JTF_RESOURCE_ACCESS',
666: function_schema => 'APPS',

Line 673: DBMS_RLS.add_policy

669: static_policy => FALSE,
670: long_predicate => TRUE );
671:
672: -- Create the VPD policy associated with CS_SR_ACCESS_RESP_SEC object
673: DBMS_RLS.add_policy
674: (object_schema => 'APPS',
675: object_name => 'CS_SR_ACCESS_RESP_SEC',
676: policy_name => 'CS_SR_SEC_RESP_ACCESS',
677: function_schema => 'APPS',