452: ,p_level => C_LEVEL_EVENT
453: ,p_module => l_log_module);
454: END IF;
455:
456: dbms_rls.drop_grouped_policy
457: (object_schema => l_object_owner
458: ,object_name => l_object_name
459: ,policy_group => l_appl_short_name
460: ,policy_name => l_array_policy_name(i));
466: ,p_level => C_LEVEL_EVENT
467: ,p_module => l_log_module);
468: END IF;
469:
470: dbms_rls.delete_policy_group
471: (object_schema => l_object_owner
472: ,object_name => l_object_name
473: ,policy_group => l_appl_short_name);
474: END IF;
480: ,p_level => C_LEVEL_EVENT
481: ,p_module => l_log_module);
482: END IF;
483:
484: dbms_rls.create_policy_group
485: (object_schema => l_object_owner
486: ,object_name => l_object_name
487: ,policy_group => l_appl_short_name);
488: ELSE
507: ,p_level => C_LEVEL_EVENT
508: ,p_module => l_log_module);
509: END IF;
510:
511: dbms_rls.drop_grouped_policy
512: (object_schema => l_object_owner
513: ,object_name => 'XLA_TRANSACTION_ENTITIES'
514: ,policy_group => l_appl_short_name
515: ,policy_name => l_array_policy_name(i));
522: ,p_level => C_LEVEL_EVENT
523: ,p_module => l_log_module);
524: END IF;
525:
526: dbms_rls.add_grouped_policy
527: (object_schema => l_object_owner
528: ,object_name => 'XLA_TRANSACTION_ENTITIES'
529: ,policy_group => l_appl_short_name
530: ,policy_name => l_appl_short_name||'_SECURITY_POLICY'
527: (object_schema => l_object_owner
528: ,object_name => 'XLA_TRANSACTION_ENTITIES'
529: ,policy_group => l_appl_short_name
530: ,policy_name => l_appl_short_name||'_SECURITY_POLICY'
531: ,policy_type => dbms_rls.SHARED_CONTEXT_SENSITIVE
532: ,function_schema => l_object_owner
533: ,policy_function => p_security_function_name
534: ,statement_types => 'UPDATE, SELECT, DELETE'
535: ,update_check => FALSE