APPS.AD_MO_UTIL_PKG SQL Statements

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

Line: 44

    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: 73

  SELECT editions_enabled
  INTO   l_edition_enabled
  FROM   dba_users
  WHERE  username=upper(p_apps_user_name);

Line: 115

       SELECT count(1)
       INTO   l_exist
       FROM   dba_editioning_views
       WHERE  view_name=l_evname
       AND    owner=upper(p_prod_schema_name);

Line: 177

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

Line: 190

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

Line: 203

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

Line: 215

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