REM +=======================================================================+
REM |    Copyright (c) 1992 Oracle Corporation, Redwood Shores, CA, USA     |
REM |                         All rights reserved.                          |
REM +=======================================================================+
REM | FILENAME
REM |   wfnlena.sql
REM | USAGE
REM |   sqlplus <wfuser/pwd> @wflena <language_code> <enabled_flag (Y/N)>
REM | DESCRIPTION
REM |   Enable/disable an installed language.
REM | NOTES
REM |   This script is for STANDALONE Workflow only.  For Apps installs,
REM |   the wf_languages view should point to fnd_languages for data..
REM +=======================================================================+
REM $Header: wfnlena.sql 26.2 2001/11/05 20:09:57 ctilley ship $
REM
REM dbdrv: none

WHENEVER SQLERROR EXIT FAILURE ROLLBACK

define code=&1
define enabled=&2

update WF_LOCAL_LANGUAGES set
  INSTALLED_FLAG = upper('&enabled')
where CODE = upper('&code');

commit;
exit;