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

INSERT INTO F1_IWS_SVC_OPER_L(IN_SVC_NAME,OPERATION_NAME,LANGUAGE_CD,DESCR,DESCRLONG,OWNER_FLG,VERSION) (SELECT O.IN_SVC_NAME,O.OPERATION_NAME,BOL.LANGUAGE_CD,BOL.DESCR,BOL.DESCRLONG,O.OWNER_FLG,1 FROM F1_IWS_SVC_OPER O, F1_IWS_SVC S, F1_BUS_OBJ_L BOL WHERE S.IN_SVC_NAME=O.IN_SVC_NAME AND S.WEB_SVC_CLASS_FLG='F1RT' AND O.SCHEMA_NAME=BOL.BUS_OBJ_CD AND NOT EXISTS (SELECT 1 FROM F1_IWS_SVC_OPER_L L WHERE L.IN_SVC_NAME=O.IN_SVC_NAME AND L.OPERATION_NAME=O.OPERATION_NAME AND L.LANGUAGE_CD = BOL.LANGUAGE_CD) AND O.SCHEMA_TYPE_FLG='F1BO')
/
INSERT INTO F1_IWS_SVC_OPER_L(IN_SVC_NAME,OPERATION_NAME,LANGUAGE_CD,DESCR,DESCRLONG,OWNER_FLG,VERSION) (SELECT O.IN_SVC_NAME,O.OPERATION_NAME,SL.LANGUAGE_CD, SUBSTR(SL.DESCR254,1,60),SL.DESCR4000,O.OWNER_FLG,1 FROM F1_IWS_SVC_OPER O,F1_IWS_SVC S,CI_SCR_L SL WHERE S.IN_SVC_NAME=O.IN_SVC_NAME AND S.WEB_SVC_CLASS_FLG='F1RT' AND O.SCHEMA_NAME=SL.SCR_CD AND NOT EXISTS (SELECT 1 FROM F1_IWS_SVC_OPER_L L WHERE L.IN_SVC_NAME=O.IN_SVC_NAME AND L.OPERATION_NAME=O.OPERATION_NAME AND L.LANGUAGE_CD = SL.LANGUAGE_CD) AND O.SCHEMA_TYPE_FLG='F1SC')
/
INSERT INTO F1_IWS_SVC_OPER_L(IN_SVC_NAME,OPERATION_NAME,LANGUAGE_CD,DESCR,DESCRLONG,OWNER_FLG,VERSION) (SELECT O.IN_SVC_NAME,O.OPERATION_NAME,BSL.LANGUAGE_CD,BSL.DESCR,BSL.DESCRLONG,O.OWNER_FLG,1 FROM F1_IWS_SVC_OPER O,F1_IWS_SVC S,F1_BUS_SVC_L BSL WHERE S.IN_SVC_NAME=O.IN_SVC_NAME AND S.WEB_SVC_CLASS_FLG='F1RT' AND O.SCHEMA_NAME=BSL.BUS_SVC_CD AND NOT EXISTS (SELECT 1 FROM F1_IWS_SVC_OPER_L L WHERE L.IN_SVC_NAME=O.IN_SVC_NAME AND L.OPERATION_NAME=O.OPERATION_NAME AND L.LANGUAGE_CD = BSL.LANGUAGE_CD) AND O.SCHEMA_TYPE_FLG='F1BS')
/
INSERT INTO F1_IWS_SVC_OPER_L(IN_SVC_NAME,OPERATION_NAME,LANGUAGE_CD,DESCR,DESCRLONG,OWNER_FLG,VERSION) (SELECT O.IN_SVC_NAME, O.OPERATION_NAME, SL.LANGUAGE_CD, ' ', ' ', O.OWNER_FLG, 1 FROM F1_IWS_SVC_OPER O, F1_IWS_SVC S, F1_IWS_SVC_L SL WHERE S.IN_SVC_NAME=O.IN_SVC_NAME AND S.WEB_SVC_CLASS_FLG='F1SP' AND S.IN_SVC_NAME=SL.IN_SVC_NAME AND NOT EXISTS (SELECT 1 FROM F1_IWS_SVC_OPER_L L WHERE L.IN_SVC_NAME=O.IN_SVC_NAME AND L.OPERATION_NAME=O.OPERATION_NAME AND L.LANGUAGE_CD = SL.LANGUAGE_CD))
/