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

__EXIT__

__ENDIF__


__IF_EXISTS__
SELECT 1
  FROM USER_TABLES
WHERE TABLE_NAME = 'F1_INSTALLATION'
/
__ELSE__

__EXIT__

__ENDIF__

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXADPP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXAIEP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXAIIP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXCLSP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXCONP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXENHP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXFRMP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXGRPP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXJDBP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXJMSP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXJSVP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXRCVP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXRTTP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXSVXP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXTPCP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXXSCP' AND OWNER_FLG = 'F1'
/

UPDATE SC_USR_GRP_PROF SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXXUPP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXADPP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXAIEP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXAIIP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXCLSP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXCONP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXENHP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXFRMP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXGRPP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXJDBP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXJMSP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXJSVP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXRCVP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXRTTP' AND OWNER_FLG = 'F1'

/
UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXSVXP' AND OWNER_FLG = 'F1'

/
UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXTPCP' AND OWNER_FLG = 'F1'

/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXXSCP' AND OWNER_FLG = 'F1'
/

UPDATE SC_ACCESS_CNTL SET OWNER_FLG = 'CM' WHERE USR_GRP_ID = 'ALL_SERVICES' AND APP_SVC_ID = 'CILXXUPP' AND OWNER_FLG = 'F1'
/
