__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
 WHERE SCRIPT_FILE_NAME = 'FW4302_apData2.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__

__EXIT__

__ENDIF__

__IF_EXISTS__

SELECT 1
  FROM CI_INSTALL_PROD
 WHERE INSTALL_OPT_ID = '11111'
   AND OWNER_FLG = 'F1'
/
__ELSE__

__EXIT__

__ENDIF__

UPDATE F1_MIGR_PLAN SET OWNER_FLG = 'CM' WHERE MIGR_PLAN_CD = 'F1-Language'
/
UPDATE F1_MIGR_PLAN_L SET OWNER_FLG = 'CM', DESCRLONG = 'This migration plan remains for upgrade purposes but is not recommended for use.  Regions should establish new languages using the procedures documented in online help.  New languages should not be introduced by copying via CMA.' WHERE MIGR_PLAN_CD = 'F1-Language' AND LANGUAGE_CD = 'ENG'
/
UPDATE F1_MIGR_PLAN_INSTR SET OWNER_FLG = 'CM' WHERE MIGR_PLAN_CD = 'F1-Language'
/
UPDATE F1_MIGR_PLAN_INSTR_L SET OWNER_FLG = 'CM' WHERE MIGR_PLAN_CD = 'F1-Language' AND LANGUAGE_CD = 'ENG'
/
UPDATE F1_MIGR_REQ SET OWNER_FLG = 'CM' WHERE MIGR_REQ_CD = 'F1-Languages'
/
UPDATE F1_MIGR_REQ_L SET OWNER_FLG = 'CM', DESCRLONG = 'This migration request remains for upgrade purposes but is not recommended for use.  Regions should establish new languages using the procedures documented in online help.  New languages should not be introduced by copying via CMA.' WHERE MIGR_REQ_CD = 'F1-Languages' AND LANGUAGE_CD = 'ENG'
/
UPDATE F1_MIGR_REQ_INSTR SET OWNER_FLG = 'CM' WHERE MIGR_REQ_CD = 'F1-Languages'
/
UPDATE F1_MIGR_REQ_INSTR_L SET OWNER_FLG = 'CM' WHERE MIGR_REQ_CD = 'F1-Languages' AND LANGUAGE_CD = 'ENG'
/