Rem
Rem $Header: blackout_post_creation.sql 11-jan-2008.09:36:25 smudumba Exp $
Rem
Rem blackout_post_creation.sql
Rem
Rem Copyright (c) 2007, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      blackout_post_creation.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    smudumba    12/27/07 - Created
Rem


BEGIN
    FOR c1 IN (SELECT * FROM mgmt_blackout_reason
               WHERE reason_id BETWEEN 1 AND 60)
    LOOP
        UPDATE mgmt_blackout_reason
          SET reason_nls_id = REPLACE(UPPER(TRANSLATE(TRIM(c1.reason),':/ ','___')),'__','_')||'_NLSID'
          WHERE c1.reason_id = reason_id;
    END LOOP;
END;
/

COMMIT;