Enable and Disable Users

DECLARE

   CURSOR cur1

   IS

      SELECT user_name

        FROM fnd_user

       WHERE user_name = 'GANDHI_DIVVELA';

BEGIN

   FOR i IN cur1

   LOOP

      apps.fnd_user_pkg.DisableUser (i.user_name);

      COMMIT;

   END LOOP;

END;

DECLARE

   CURSOR cur1

   IS

      SELECT user_name

        FROM fnd_user

       WHERE user_name = 'GANDHI_DIVVELA';

BEGIN

   FOR i IN cur1

   LOOP

      apps.fnd_user_pkg.EnableUser (i.user_name);

      COMMIT;

   END LOOP;

END;