APPS.CCT_ALTER_WEB_SCHEMA_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

   PROCEDURE update_null_object_versions IS
   BEGIN

	 SAVEPOINT CCTUPGCOL;

Line: 38

      UPDATE cct_middlewares
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 42

      UPDATE CCT_CLASSIFICATIONS
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 46

      UPDATE CCT_CLASSIFICATION_RULES
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 50

      UPDATE CCT_IVR_MAPS
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 54

      UPDATE CCT_LINES
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 58

      UPDATE CCT_MIDDLEWARE_PARAMS
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 62

      UPDATE CCT_MIDDLEWARE_VALUES
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 66

      UPDATE CCT_TELESET_TYPES
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 70

      UPDATE CCT_STATIC_ROUTES
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 74

      UPDATE CCT_ROUTE_PARAMS
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 78

      UPDATE CCT_ROUTES
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 82

      UPDATE CCT_TELESETS
	 SET object_version_number = 0
	 where object_version_number IS NULL;

Line: 89

        raise_application_error(-20000, sqlerrm || '.UPDATE COL VALUE, Could not add column')  ;

Line: 94

   PROCEDURE update_route_param_operator(schema_name  IN  VARCHAR2) is
     l_str varchar2(200):=  'ALTER TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS MODIFY ( OPERATION DEFAULT '''||'='||''' )';

Line: 104

        UPDATE CCT_ROUTE_PARAMS
	   SET operation = '='
	   where operation IS NULL;

Line: 114

        raise_application_error(-20000, sqlerrm || '.UPDATE_ROUTE_PARAM_OPERATOR COL VALUE, Could not modify')  ;

Line: 116

   END update_route_param_operator;