DBA Data[Home] [Help]

APPS.AD_MO_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

    SELECT  'TRUE'
    FROM    sys.dual
    WHERE   EXISTS
      (SELECT  1
       FROM    dba_policies
       WHERE   object_owner = UPPER(xp_object_schema)
       AND     object_name  = UPPER(xp_object_name)
       AND     policy_name  = UPPER(xp_policy_name)
      );
Line: 146

                           'SELECT, INSERT, UPDATE, DELETE',
                           TRUE,
                           TRUE,
                           FALSE,
                           DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
Line: 159

                           'SELECT, INSERT, UPDATE, DELETE',
                           TRUE,
                           TRUE,
                           FALSE,
                           DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
Line: 172

                           'SELECT, INSERT, UPDATE, DELETE',
                           TRUE,
                           TRUE,
                           FALSE,
                           DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
Line: 184

                           'SELECT, INSERT, UPDATE, DELETE',
                           TRUE,
                           TRUE,
                           FALSE,
                           DBMS_RLS.SHARED_CONTEXT_SENSITIVE);