APPS.CCT_MIGRATE_MW SQL Statements

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

Line: 10

       select middleware_id into l_mw_id from cct_middlewares
       where middleware_type_id= p_mw1_id
       and config_name=p_name
       and nvl(f_deletedflag,'Y') <> 'D';

Line: 19

       update cct_middlewares set middleware_type_id=p_mw2_id
       where middleware_type_id=p_mw1_id
       and config_name=p_name;

Line: 23

       update cct_middlewares set middleware_type_id=p_mw2_id
       where middleware_type_id=p_mw1_id;

Line: 27

     delete_params(p_mw1_id,p_mw2_id,l_mw_id);

Line: 28

     update_params(p_mw1_id,p_mw2_id,l_mw_id);

Line: 32

       delete cct_middleware_types
	     where middleware_type_id=p_mw1_id;

Line: 37

procedure delete_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
IS
BEGIN
 SAVEPOINT CCT_MIDDLEWARE_DELETE_SAV;

Line: 43

   delete from cct_middleware_values where nvl(f_deletedflag,'Y') <> 'D'
   and middleware_param_id IN
   (
   select mw.middleware_param_id
   from cct_middleware_params mw
   where middleware_type_id=p_mw1_id and nvl(mw.f_deletedflag,'Y') <> 'D'

   minus

   select mw1.middleware_param_id
         from cct_middleware_params mw1, cct_middleware_params mw2
         where mw1.middleware_type_id=p_mw1_id and mw2.middleware_type_id=p_mw2_id
         and mw1.name=mw2.name
         and nvl(mw1.f_deletedflag,'Y') <> 'D'
   ) ;

Line: 59

   delete from cct_middleware_values where middleware_id=p_mw_id and  nvl(f_deletedflag,'Y') <> 'D'
   and middleware_param_id IN
   (
   select mw.middleware_param_id
   from cct_middleware_params mw
   where middleware_type_id=p_mw1_id and nvl(mw.f_deletedflag,'Y') <> 'D'

   minus

   select mw1.middleware_param_id
         from cct_middleware_params mw1, cct_middleware_params mw2
         where mw1.middleware_type_id=p_mw1_id and mw2.middleware_type_id=p_mw2_id
         and mw1.name=mw2.name
         and nvl(mw1.f_deletedflag,'Y') <> 'D'

   ) ;

Line: 78

          rollback TO SAVEPOINT CCT_MIDDLEWARE_DELETE_SAV;

Line: 79

          raise_application_error(-20011, sqlerrm || 'Could not delete middlewares')  ;

Line: 82

procedure update_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
IS
    l_mw1_param_id cct_middleware_params.middleware_param_id%type;

Line: 88

           select mw1.middleware_param_id, mw2.middleware_param_id
           from cct_middleware_params mw1, cct_middleware_params mw2
           where mw1.middleware_type_id=p_mw1_id and mw2.middleware_type_id=p_mw2_id
             and mw1.name=mw2.name
             and nvl(mw1.f_deletedflag,'Y') <> 'D';

Line: 94

        SAVEPOINT CCT_MIDDLEWARE_UPDATE_SAV;

Line: 102

            update cct_middleware_values Set middleware_param_id = l_mw2_param_id
            where middleware_param_id = l_mw1_param_id  and nvl(f_deletedflag,'Y') <> 'D' ;

Line: 105

            update cct_middleware_values Set middleware_param_id = l_mw2_param_id
            where middleware_id=p_mw_id and middleware_param_id = l_mw1_param_id
                   and nvl(f_deletedflag,'Y') <> 'D' ;

Line: 113

          rollback TO SAVEPOINT CCT_MIDDLEWARE_UPDATE_SAV;

Line: 114

          raise_application_error(-20012, sqlerrm || 'Could not update middlewares')  ;

Line: 117

procedure update_agent_params(p_mw1_id IN NUMBER,p_mw2_id IN NUMBER, p_mw_id IN NUMBER )
IS
    l_mw1_param_id jtf_rs_resource_values.resource_param_id%type;

Line: 123

           select mw1.resource_param_id, mw2.resource_param_id
           from jtf_rs_resource_params mw1, jtf_rs_resource_params mw2
           where mw1.param_type=p_mw1_id and mw2.param_type=p_mw2_id
             and mw1.name=mw2.name;

Line: 128

        SAVEPOINT CCT_MIDDLEWARE_UPDATE_AGT_SAV;

Line: 136

            update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id
            where resource_param_id = l_mw1_param_id  ;

Line: 139

            update jtf_rs_resource_values Set resource_param_id = l_mw2_param_id
            where value_type=p_mw_id and resource_param_id = l_mw1_param_id      ;

Line: 146

          rollback TO SAVEPOINT CCT_MIDDLEWARE_UPDATE_AGT_SAV;

Line: 147

          raise_application_error(-20012, sqlerrm || 'Could not update agent paras')  ;