APPS.CCT_CASCADE_DELETE_PUB SQL Statements

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

Line: 8

       delete_deleted_middlewares;

Line: 9

       delete_defunct_middlewares;

Line: 14

          raise_application_error(-20000, sqlerrm || '. Could not delete defunct deleted middlewares')  ;

Line: 19

  PROCEDURE delete_defunct_middlewares
   IS
    l_config_id cct_middlewares.middleware_id%type;

Line: 24

           select a.middleware_id
           from cct_middlewares a
           where f_deletedflag <> 'D'
           OR f_deletedflag is null
           and not exists
           (select server_group_id from ieo_svr_groups b where b.server_group_id = a.server_group_id );

Line: 44

            delete_middleware(p_middleware_id =>l_config_id);

Line: 52

          raise_application_error(-20000, sqlerrm || '. Could not delete defunct middlewares')  ;

Line: 56

PROCEDURE delete_deleted_middlewares
   IS
    l_config_id cct_middlewares.middleware_id%type;

Line: 61

           select distinct a.server_group_id
           from cct_middlewares a
           where f_deletedflag <> 'D'
           OR f_deletedflag is null
           and not exists
           (select server_group_id from ieo_svr_groups b where b.server_group_id = a.server_group_id );

Line: 68

        SAVEPOINT CCT_MIDDLEWARE_DELETED_DEL;

Line: 79

            delete_middleware(p_middleware_id =>l_config_id);

Line: 85

          rollback TO SAVEPOINT CCT_MIDDLEWARE_DELETED_DEL;

Line: 86

          raise_application_error(-20000, sqlerrm || '. Could not delete deleted middlewares')  ;

Line: 89

    PROCEDURE delete_middleware
    ( p_server_group_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS
    l_config_id cct_middlewares.middleware_id%type;

Line: 96

       select middleware_id
       from cct_middlewares
       where server_group_id = p_server_group_id;

Line: 114

            delete_middleware(p_middleware_id =>l_config_id);

Line: 126

          raise_application_error(-20000, sqlerrm || '. Could not delete teleset')  ;

Line: 130

    PROCEDURE delete_middleware
    ( p_middleware_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS

   CURSOR csr_jtf_rs_resource_values
   is
   select resource_param_value_id, value_type, object_version_number
   from jtf_rs_resource_values
   where value_type = to_char(p_middleware_id);

Line: 154

       delete_teleset(p_middleware_id => p_middleware_id);

Line: 155

       delete_ivr(p_middleware_id => p_middleware_id);

Line: 156

       delete_multisite(p_middleware_id => p_middleware_id);

Line: 157

       delete_route_point(p_middleware_id => p_middleware_id);

Line: 159

       delete cct_middleware_values
       where middleware_id = p_middleware_id;

Line: 170

            jtf_rs_resource_values_pub.delete_rs_resource_values
           (
                 p_api_version             => 1
                 ,p_commit                 => fnd_api.g_true
                 ,p_resource_param_value_id => l_param_value_id
                 ,p_object_version_number => l_obj_ver
                 ,x_return_status => l_return_status
                 ,x_msg_count => l_msg_count
                 ,x_msg_data => l_msg_data
           );

Line: 204

       delete cct_middlewares
       where middleware_id = p_middleware_id;

Line: 213

          raise_application_error(-20000, sqlerrm || '. Could not delete middleware for middleware'||p_middleware_id)  ;

Line: 218

   PROCEDURE delete_teleset
    ( p_middleware_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS
   BEGIN
      IF p_middleware_id is not null
      then
        SAVEPOINT CCT_TELESET_DEL;

Line: 227

        delete cct_lines
        where teleset_id in (select  teleset_id
                      from cct_telesets
                      where middleware_id = p_middleware_id);

Line: 232

       delete cct_telesets
       where middleware_id = p_middleware_id;

Line: 241

          raise_application_error(-20000, sqlerrm || '. Could not delete teleset')  ;

Line: 246

  /* Delete IVR values
  */
   --Tested
   PROCEDURE delete_ivr
    ( p_middleware_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS
   BEGIN
      IF p_middleware_id is not null
      then
        SAVEPOINT CCT_IVR_DEL;

Line: 258

        delete cct_ivr_maps
        where mw_route_point_id in (select mw_route_point_id
                      from cct_mw_route_points
                      where middleware_id = p_middleware_id);

Line: 269

          raise_application_error(-20000, sqlerrm || '. Could not delete IVR')  ;

Line: 272

   PROCEDURE delete_ivr
    ( p_route_point_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS
   BEGIN
      IF p_route_point_id is not null
      then
        SAVEPOINT CCT_IVR_RP_DEL;

Line: 281

        delete cct_ivr_maps
        where mw_route_point_id = p_route_point_id;

Line: 290

          raise_application_error(-20000, sqlerrm || '. Could not delete IVR')  ;

Line: 294

   PROCEDURE delete_multisite
    ( p_middleware_id IN NUMBER
     , p_commit_flag IN VARCHAR2)
   IS
     l_config_id cct_multisite_configs.multisite_config_id%type;

Line: 300

       select multisite_config_id
       from cct_multisite_configs
       where from_middleware_id = p_middleware_id
       or to_middleware_id =  p_middleware_id;

Line: 318

            delete_multisite_paths(p_multisite_config_id =>l_config_id);

Line: 320

            delete cct_multisite_values
            where  multisite_config_id = l_config_id;

Line: 326

        delete cct_multisite_configs
        where from_middleware_id = p_middleware_id
        or to_middleware_id = p_middleware_id;

Line: 336

          raise_application_error(-20000, sqlerrm || '. Could not delete multisite')  ;

Line: 340

   PROCEDURE delete_multisite_paths
    ( p_multisite_config_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS
   BEGIN
      IF p_multisite_config_id is not null
      then
        SAVEPOINT CCT_MULTISITE_PATHS_DEL;

Line: 349

        delete cct_multisite_path_values
        where multisite_path_id IN(select multisite_path_id
                           from cct_multisite_paths
                           where multisite_config_id = p_multisite_config_id);

Line: 354

        delete cct_multisite_paths
        where multisite_config_id = p_multisite_config_id;

Line: 363

          raise_application_error(-20000, sqlerrm || '. Could not delete multisite paths')  ;

Line: 366

 PROCEDURE delete_route_point
    ( p_middleware_id IN NUMBER
     , p_commit_flag IN VARCHAR2)
   IS
     l_id cct_mw_route_points.mw_route_point_id%type;

Line: 372

       select mw_route_point_id
       from cct_mw_route_points
       where middleware_id = p_middleware_id;

Line: 390

            delete_multisite_paths(p_mw_route_point_id =>l_id);

Line: 391

            delete_ivr(p_route_point_id=>l_id);

Line: 392

            delete cct_mw_route_point_values
            where  mw_route_point_id = l_id;

Line: 397

        delete cct_mw_route_points
        where middleware_id = p_middleware_id;

Line: 407

          raise_application_error(-20000, sqlerrm || '. Could not delete Route Points')  ;

Line: 412

PROCEDURE delete_multisite_paths
    ( p_mw_route_point_id IN NUMBER
      , p_commit_flag IN VARCHAR2)
   IS
   BEGIN
      IF p_mw_route_point_id is not null
      then
        SAVEPOINT CCT_MULTISITE_PATHS_RP_DEL;

Line: 421

        delete cct_multisite_path_values
        where multisite_path_id IN(select multisite_path_id
                           from cct_multisite_paths
                           where mw_route_point_id = p_mw_route_point_id);

Line: 426

        delete cct_multisite_paths
        where mw_route_point_id = p_mw_route_point_id;

Line: 435

          raise_application_error(-20000, sqlerrm || '. Could not delete multisite paths')  ;