APPS.XLA_SECURITY_PKG SQL Statements

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

Line: 184

       SELECT fap.application_short_name
             ,xsv.security_function_name
         INTO l_appl_short_name
             ,l_policy_function
         FROM xla_subledgers_fvl     xsv
             ,fnd_application        fap
        WHERE xsv.application_id = p_application_id
          AND fap.application_id = xsv.application_id;

Line: 207

     SELECT nvl(mpi.status, 'N')
       INTO l_access_ctrl_enabled
       FROM fnd_mo_product_init mpi
      WHERE mpi.application_short_name = l_appl_short_name;

Line: 328

      SELECT fav.application_name
        INTO l_appl_name
        FROM fnd_application_vl        fav
       WHERE fav.application_id = p_application_id;

Line: 397

   SELECT fap.application_short_name, USER
    INTO l_appl_short_name, l_object_owner
    FROM fnd_application    fap
   WHERE fap.application_id = p_application_id;

Line: 409

   SELECT COUNT(policy_group)
     INTO l_group_count
     FROM dba_policy_groups
    WHERE object_owner = l_object_owner
      AND object_name  = l_object_name
      AND policy_group = l_appl_short_name;

Line: 434

         SELECT policy_name BULK COLLECT
           INTO l_array_policy_name
           FROM dba_policies
          WHERE object_owner = l_object_owner
            AND object_name  = l_object_name
            AND policy_group = l_appl_short_name;

Line: 470

         dbms_rls.delete_policy_group
            (object_schema         => l_object_owner
            ,object_name           => l_object_name
            ,policy_group          => l_appl_short_name);

Line: 489

         SELECT policy_name BULK COLLECT
           INTO l_array_policy_name
           FROM dba_policies
          WHERE object_owner = l_object_owner
            AND object_name  = l_object_name
            AND policy_group = l_appl_short_name;

Line: 534

         ,statement_types       => 'UPDATE, SELECT, DELETE'
         ,update_check          => FALSE
         ,enable                => TRUE);