APPS.IEX_WEBSWITCH_PVT SQL Statements

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

Line: 37

    CURSOR c_cgi_switch IS SELECT CGI_SWITCH_ID
                FROM IEX_CGI_SWITCHES
                WHERE QUERY_STRING_ID =l_cgi_switch_rec.QUERY_STRING_ID
                AND SWITCH_CODE = l_cgi_switch_rec.SWITCH_CODE;

Line: 41

    CURSOR c_switch_data IS SELECT IEX_SWITCH_DATA_S.NEXTVAL
               FROM SYS.DUAL;

Line: 74

    l_cgi_switch_rec.last_update_date := sysdate;

Line: 77

    l_cgi_switch_rec.last_updated_by := g_user_id;

Line: 78

    l_cgi_switch_rec.last_update_login := g_login_id;

Line: 105

    l_switch_data_rec.last_update_date := sysdate;

Line: 108

    l_switch_data_rec.last_updated_by := g_user_id;

Line: 109

    l_switch_data_rec.last_update_login := g_login_id;

Line: 136

        CURSOR c_cgi_switch_seq IS SELECT IEX_CGI_SWITCHES_S.NEXTVAL
                   FROM SYS.DUAL;

Line: 219

  PROCEDURE Update_WebSwitch(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2,
                      p_commit                   IN VARCHAR2,
                      p_validation_level         IN NUMBER,
                      x_return_status            OUT NOCOPY VARCHAR2,
                      x_msg_count                OUT NOCOPY NUMBER,
                      x_msg_data                 OUT NOCOPY VARCHAR2,
                      p_cgi_switch_rec           IN cgi_switch_rec_type,
                      p_switch_data_rec          IN switch_data_rec_type
                      )
  AS
    l_api_version                CONSTANT         NUMBER            :=  1.0;

Line: 232

    l_api_name                CONSTANT         VARCHAR2(30)     :=  'Update_WebSwitch';

Line: 242

    SAVEPOINT     Update_WebSwitch_PVT;

Line: 277

    l_cgi_switch_rec.last_update_date := sysdate;

Line: 280

    l_cgi_switch_rec.last_updated_by := g_user_id;

Line: 281

    l_cgi_switch_rec.last_update_login := g_login_id;

Line: 310

    l_switch_data_rec.last_update_date := sysdate;

Line: 313

    l_switch_data_rec.last_updated_by := g_user_id;

Line: 314

    l_switch_data_rec.last_update_login := g_login_id;

Line: 333

    IEX_WEBSWITCH_PKG.Update_WebSwitch(
          p_api_version => p_api_version,
          p_init_msg_list => p_init_msg_list,
          p_commit => p_commit,
          p_validation_level => p_validation_level,
          x_return_status => l_return_status,
          x_msg_count => l_msg_count,
          x_msg_data => l_msg_data,
          p_cgi_switch_rec => l_cgi_switch_rec,
          p_switch_data_rec => l_switch_data_rec
          );

Line: 365

      ROLLBACK TO Update_WebSwitch_PVT;

Line: 373

      ROLLBACK TO Update_WebSwitch_PVT;

Line: 381

      ROLLBACK TO Update_WebSwitch_PVT;