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

__EXIT__

__ENDIF__


INSERT INTO CI_WFM ( WFM_NAME, VERSION, EXT_SYS_TYP_FLG) SELECT 'F1_DBCONINFO', 1, 'F1DB' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM 
CI_WFM WHERE WFM_NAME = 'F1_DBCONINFO' AND EXT_SYS_TYP_FLG = 'F1DB')
/

UPDATE CI_WFM SET EXT_SYS_TYP_FLG = 'F1DB' WHERE WFM_NAME = 'F1_DBCONINFO'
/

INSERT INTO CI_WFM_L ( WFM_NAME, LANGUAGE_CD,VERSION, DESCR) SELECT 'F1_DBCONINFO', 'ENG', 1, 'Database Connection Information' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CI_WFM_L WHERE WFM_NAME = 'F1_DBCONINFO' AND LANGUAGE_CD = 'ENG')
/

UPDATE CI_WFM_L SET DESCR = 'Database Connection Information' WHERE WFM_NAME = 'F1_DBCONINFO' and language_cd = 'ENG'
/

INSERT INTO CI_WFM_OPT ( WFM_NAME, SEQ_NUM, VERSION, WFM_OPT_VAL,EXT_OPT_TYPE ) SELECT 'F1_DBCONINFO', 1, 1, ' ', 'F1DP' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CI_WFM_OPT WHERE WFM_NAME = 'F1_DBCONINFO' AND EXT_OPT_TYPE = 'F1DP' AND SEQ_NUM = 1)
/

INSERT INTO CI_WFM_OPT ( WFM_NAME, SEQ_NUM, VERSION, WFM_OPT_VAL,EXT_OPT_TYPE ) SELECT 'F1_DBCONINFO', 1, 1, ' ', 'F1DU' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CI_WFM_OPT WHERE WFM_NAME = 'F1_DBCONINFO' AND EXT_OPT_TYPE = 'F1DU' AND SEQ_NUM = 1)
/
