__IF_EXISTS__
SELECT 1
  FROM CI_UT_INSTL_DTL
WHERE SCRIPT_FILE_NAME = 'FW44031_POSTDATA_UGBUPD-8397.SQL'
   AND END_DTTM IS NOT NULL
/
__THEN__
__EXIT__
__ENDIF__

INSERT INTO CI_BATCH_CTRL_P(BATCH_CD,SEQ_NUM,BATCH_PARM_NAME,BATCH_PARM_VAL,REQUIRED_SW,OWNER_FLG,TEXT_SECURITY_FLG) SELECT CBC.BATCH_CD, 130, 'overrideSqlTimeout', '10800', 'N', CBC.OWNER_FLG, '    ' FROM CI_BATCH_CTRL CBC WHERE CBC.PROGRAM_NAME = 'com.splwg.base.domain.conversion.batch.GenericInsertProcess' AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P CBCP WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBCP.BATCH_PARM_NAME = 'overrideSqlTimeout') AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P CBCP WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBCP.SEQ_NUM = 130)
/
INSERT INTO CI_BATCH_CTRL_P_L(BATCH_CD,SEQ_NUM,LANGUAGE_CD,DESCR50,OWNER_FLG,DESCRLONG) SELECT CBCP.BATCH_CD, CBCP.SEQ_NUM, 'ENG', 'Override SQL Timeout', CBCP.OWNER_FLG, 'Timeout in seconds for the SQL statements performed by this batch program. This batch program makes use of SQL with long run times. Set to a relatively high number to avoid timing out.' FROM CI_BATCH_CTRL_P CBCP, CI_BATCH_CTRL CBC WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBC.PROGRAM_NAME = 'com.splwg.base.domain.conversion.batch.GenericInsertProcess' AND CBCP.BATCH_PARM_NAME = 'overrideSqlTimeout' AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P_L CBCPL WHERE CBCPL.BATCH_CD = CBCP.BATCH_CD AND CBCPL.SEQ_NUM = CBCP.SEQ_NUM AND CBCPL.LANGUAGE_CD = 'ENG')
/
INSERT INTO CI_BATCH_CTRL_P(BATCH_CD,SEQ_NUM,BATCH_PARM_NAME,BATCH_PARM_VAL,REQUIRED_SW,OWNER_FLG,TEXT_SECURITY_FLG) SELECT CBC.BATCH_CD, 160, 'overrideSqlTimeout', '10800', 'N', CBC.OWNER_FLG, '    ' FROM CI_BATCH_CTRL CBC WHERE CBC.PROGRAM_NAME = 'com.splwg.base.domain.conversion.batch.AssignProductionKeysProcess' AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P CBCP WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBCP.BATCH_PARM_NAME = 'overrideSqlTimeout') AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P CBCP WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBCP.SEQ_NUM = 160)
/
INSERT INTO CI_BATCH_CTRL_P_L(BATCH_CD,SEQ_NUM,LANGUAGE_CD,DESCR50,OWNER_FLG,DESCRLONG) SELECT CBCP.BATCH_CD, CBCP.SEQ_NUM, 'ENG', 'Override SQL Timeout', CBCP.OWNER_FLG, 'Timeout in seconds for the SQL statements performed by this batch program. This batch program makes use of SQL with long run times. Set to a relatively high number to avoid timing out.' FROM CI_BATCH_CTRL_P CBCP, CI_BATCH_CTRL CBC WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBC.PROGRAM_NAME = 'com.splwg.base.domain.conversion.batch.AssignProductionKeysProcess' AND CBCP.BATCH_PARM_NAME = 'overrideSqlTimeout' AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P_L CBCPL WHERE CBCPL.BATCH_CD = CBCP.BATCH_CD AND CBCPL.SEQ_NUM = CBCP.SEQ_NUM AND CBCPL.LANGUAGE_CD = 'ENG')
/
INSERT INTO CI_BATCH_CTRL_P(BATCH_CD,SEQ_NUM,BATCH_PARM_NAME,BATCH_PARM_VAL,REQUIRED_SW,OWNER_FLG,TEXT_SECURITY_FLG) SELECT CBC.BATCH_CD, 130, 'overrideSqlTimeout', '10800', 'N', CBC.OWNER_FLG, '    ' FROM CI_BATCH_CTRL CBC WHERE CBC.PROGRAM_NAME = 'com.splwg.base.domain.conversion.batch.CopyRecordsToStagingProcess' AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P CBCP WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBCP.BATCH_PARM_NAME = 'overrideSqlTimeout') AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P CBCP WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBCP.SEQ_NUM = 130)
/
INSERT INTO CI_BATCH_CTRL_P_L(BATCH_CD,SEQ_NUM,LANGUAGE_CD,DESCR50,OWNER_FLG,DESCRLONG) SELECT CBCP.BATCH_CD, CBCP.SEQ_NUM, 'ENG', 'Override SQL Timeout', CBCP.OWNER_FLG, 'Timeout in seconds for the SQL statements performed by this batch program. This batch program makes use of SQL with long run times. Set to a relatively high number to avoid timing out.' FROM CI_BATCH_CTRL_P CBCP, CI_BATCH_CTRL CBC WHERE CBCP.BATCH_CD = CBC.BATCH_CD AND CBC.PROGRAM_NAME = 'com.splwg.base.domain.conversion.batch.CopyRecordsToStagingProcess' AND CBCP.BATCH_PARM_NAME = 'overrideSqlTimeout' AND NOT EXISTS (SELECT 1 FROM CI_BATCH_CTRL_P_L CBCPL WHERE CBCPL.BATCH_CD = CBCP.BATCH_CD AND CBCPL.SEQ_NUM = CBCP.SEQ_NUM AND CBCPL.LANGUAGE_CD = 'ENG')
/