eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AST_WEBSWITCH_PVT SQL Statements

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

Line: 32


    CURSOR c1 IS SELECT 'X' FROM  ast_cgi_switches
                 WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;

Line: 35


    CURSOR c2 IS SELECT 'X' FROM ast_switch_data
                 WHERE switch_data_id = p_switch_data_rec.switch_data_id;

Line: 111


INSERT INTO ast_cgi_switches(
                            cgi_switch_id,
                            query_string_id,
                            enabled_flag,
                            object_version_number,
                            switch_code,
                            switch_type,
                            is_required_yn,
                            sort_order,
                            data_separator,
                            last_update_date,
                            creation_date,
                            created_by,
                            last_updated_by,
                            last_update_login,
                            attribute_category,
                            attribute1,
                            attribute2,
                            attribute3,
                            attribute4,
                            attribute5,
                            attribute6,
                            attribute7,
                            attribute8,
                            attribute9,
                            attribute10,
                            attribute11,
                            attribute12,
                            attribute13,
                            attribute14,
                            attribute15
                            )
      VALUES (
           p_cgi_switch_rec.cgi_switch_id,
           p_cgi_switch_rec.query_string_id,
           p_cgi_switch_rec.enabled_flag,
           p_cgi_switch_rec.object_version_number,
           p_cgi_switch_rec.switch_code,
           p_cgi_switch_rec.switch_type,
           p_cgi_switch_rec.is_required_yn,
           p_cgi_switch_rec.sort_order,
           p_cgi_switch_rec.data_separator,
           p_cgi_switch_rec.last_update_date,
           p_cgi_switch_rec.creation_date,
           p_cgi_switch_rec.created_by,
           p_cgi_switch_rec.last_updated_by,
           p_cgi_switch_rec.last_update_login,
           p_cgi_switch_rec.attribute_category,
           p_cgi_switch_rec.attribute1,
           p_cgi_switch_rec.attribute2,
           p_cgi_switch_rec.attribute3,
           p_cgi_switch_rec.attribute4,
           p_cgi_switch_rec.attribute5,
           p_cgi_switch_rec.attribute6,
           p_cgi_switch_rec.attribute7,
           p_cgi_switch_rec.attribute8,
           p_cgi_switch_rec.attribute9,
           p_cgi_switch_rec.attribute10,
           p_cgi_switch_rec.attribute11,
           p_cgi_switch_rec.attribute12,
           p_cgi_switch_rec.attribute13,
           p_cgi_switch_rec.attribute14,
           p_cgi_switch_rec.attribute15
           );

Line: 181


      INSERT INTO ast_switch_data(
                           switch_data_id,
                           cgi_switch_id,
                           enabled_flag,
                           object_version_number,
                           first_name_yn,
                           last_name_yn,
                           address_yn,
                           city_yn,
                           state_yn,
                           zip_yn,
                           country_yn,
                           last_update_date,
                           creation_date,
                           created_by,
                           last_updated_by,
                           last_update_login,
                           attribute_category,
                           attribute1,
                           attribute2,
                           attribute3,
                           attribute4,
                           attribute5,
                           attribute6,
                           attribute7,
                           attribute8,
                           attribute9,
                           attribute10,
                           attribute11,
                           attribute12,
                           attribute13,
                           attribute14,
                           attribute15
                           )
      VALUES (
           p_switch_data_rec.switch_data_id,
           p_switch_data_rec.cgi_switch_id,
           p_switch_data_rec.enabled_flag,
           p_switch_data_rec.object_version_number,
           p_switch_data_rec.first_name_yn,
           p_switch_data_rec.last_name_yn,
           p_switch_data_rec.address_yn,
           p_switch_data_rec.city_yn,
           p_switch_data_rec.state_yn,
           p_switch_data_rec.zip_yn,
           p_switch_data_rec.country_yn,
           p_switch_data_rec.last_update_date,
           p_switch_data_rec.creation_date,
           p_switch_data_rec.created_by,
           p_switch_data_rec.last_updated_by,
           p_switch_data_rec.last_update_login,
           p_switch_data_rec.attribute_category,
           p_switch_data_rec.attribute1,
           p_switch_data_rec.attribute2,
           p_switch_data_rec.attribute3,
           p_switch_data_rec.attribute4,
           p_switch_data_rec.attribute5,
           p_switch_data_rec.attribute6,
           p_switch_data_rec.attribute7,
           p_switch_data_rec.attribute8,
           p_switch_data_rec.attribute9,
           p_switch_data_rec.attribute10,
           p_switch_data_rec.attribute11,
           p_switch_data_rec.attribute12,
           p_switch_data_rec.attribute13,
           p_switch_data_rec.attribute14,
           p_switch_data_rec.attribute15
           );

Line: 256


      FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');

Line: 359


  PROCEDURE Update_WebSwitch(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_commit                   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_validation_level         IN NUMBER DEFAULT
                                                    FND_API.G_VALID_LEVEL_FULL,
                      x_return_status            OUT VARCHAR2,
                      x_msg_count                OUT NUMBER,
                      x_msg_data                 OUT 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: 373


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

Line: 383


    SAVEPOINT     Update_WebSwitch_PVT;

Line: 408


          ast_WEBSWITCH_CUHK.Update_WebSwitch_PRE(
                              p_api_version => l_api_version,
                              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: 426


          ast_WEBSWITCH_VUHK.Update_WebSwitch_PRE(
                              p_api_version => l_api_version,
                              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: 446


    UPDATE ast_cgi_switches
    SET
      switch_code = p_cgi_switch_rec.switch_code,
      switch_type = p_cgi_switch_rec.switch_type,
      enabled_flag = p_cgi_switch_rec.enabled_flag,
      is_required_yn = p_cgi_switch_rec.is_required_yn,
      sort_order = p_cgi_switch_rec.sort_order,
      data_separator = p_cgi_switch_rec.data_separator,
      last_update_date = p_cgi_switch_rec.last_update_date,
      last_updated_by = p_cgi_switch_rec.last_updated_by,
      last_update_login = p_cgi_switch_rec.last_update_login,
      attribute_category = p_cgi_switch_rec.attribute_category,
      attribute1 = p_cgi_switch_rec.attribute1,
      attribute2 = p_cgi_switch_rec.attribute2,
      attribute3 = p_cgi_switch_rec.attribute3,
      attribute4 = p_cgi_switch_rec.attribute4,
      attribute5 = p_cgi_switch_rec.attribute5,
      attribute6 = p_cgi_switch_rec.attribute6,
      attribute7 = p_cgi_switch_rec.attribute7,
      attribute8 = p_cgi_switch_rec.attribute8,
      attribute9 = p_cgi_switch_rec.attribute9,
      attribute10 = p_cgi_switch_rec.attribute10,
      attribute11 = p_cgi_switch_rec.attribute11,
      attribute12 = p_cgi_switch_rec.attribute12,
      attribute13 = p_cgi_switch_rec.attribute13,
      attribute14 = p_cgi_switch_rec.attribute14,
      attribute15 = p_cgi_switch_rec.attribute15
    WHERE query_string_id = p_cgi_switch_rec.query_string_id
    AND cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;

Line: 476


    UPDATE ast_switch_data
    SET
      first_name_yn = p_switch_data_rec.first_name_yn,
      last_name_yn = p_switch_data_rec.last_name_yn,
      address_yn = p_switch_data_rec.address_yn,
      city_yn = p_switch_data_rec.city_yn,
      state_yn = p_switch_data_rec.state_yn,
      zip_yn = p_switch_data_rec.zip_yn,
      country_yn = p_switch_data_rec.country_yn,
      enabled_flag = p_switch_data_rec.enabled_flag,
      last_update_date = p_switch_data_rec.last_update_date,
      last_updated_by = p_switch_data_rec.last_updated_by,
      last_update_login = p_switch_data_rec.last_update_login,
      attribute_category = p_switch_data_rec.attribute_category,
      attribute1 = p_switch_data_rec.attribute1,
      attribute2 = p_switch_data_rec.attribute2,
      attribute3 = p_switch_data_rec.attribute3,
      attribute4 = p_switch_data_rec.attribute4,
      attribute5 = p_switch_data_rec.attribute5,
      attribute6 = p_switch_data_rec.attribute6,
      attribute7 = p_switch_data_rec.attribute7,
      attribute8 = p_switch_data_rec.attribute8,
      attribute9 = p_switch_data_rec.attribute9,
      attribute10 = p_switch_data_rec.attribute10,
      attribute11 = p_switch_data_rec.attribute11,
      attribute12 = p_switch_data_rec.attribute12,
      attribute13 = p_switch_data_rec.attribute13,
      attribute14 = p_switch_data_rec.attribute14,
      attribute15 = p_switch_data_rec.attribute15
    WHERE cgi_switch_id = p_switch_data_rec.cgi_switch_id
    AND switch_data_id = p_switch_data_rec.switch_data_id;

Line: 512


      FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');

Line: 532


          ast_WEBSWITCH_VUHK.Update_WebSwitch_Post(
                              p_api_version => l_api_version,
                              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: 549


          ast_WEBSWITCH_CUHK.Update_WebSwitch_Post(
                              p_api_version => l_api_version,
                              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: 587


      ROLLBACK TO Update_WebSwitch_PVT;

Line: 595


      ROLLBACK TO Update_WebSwitch_PVT;

Line: 603


      ROLLBACK TO Update_WebSwitch_PVT;

Line: 702


         CURSOR c1 IS SELECT 'X'
                   FROM ast_cgi_switches
                   WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id
                   FOR UPDATE;

Line: 714


         CURSOR c1 IS SELECT 'X'
                   FROM ast_switch_data
                   WHERE switch_data_id = p_switch_data_rec.switch_data_id
                   FOR UPDATE;

Line: 728


      FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');

Line: 834


  PROCEDURE Delete_WebSwitch(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_commit                   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_validation_level         IN NUMBER DEFAULT
                                                    FND_API.G_VALID_LEVEL_FULL,
                      x_return_status            OUT VARCHAR2,
                      x_msg_count                OUT NUMBER,
                      x_msg_data                 OUT 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: 848


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

Line: 859


    SAVEPOINT     Delete_WebSwitch_PUB;

Line: 883


          ast_WEBSWITCH_CUHK.Delete_WebSwitch_PRE(
                              p_api_version => l_api_version,
                              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: 901


          ast_WEBSWITCH_VUHK.Delete_WebSwitch_PRE(
                              p_api_version => l_api_version,
                              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: 920


      DELETE FROM ast_switch_data
      WHERE switch_data_id = p_switch_data_rec.switch_data_id;

Line: 926


      DELETE FROM ast_cgi_switches
      WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;

Line: 934


      FND_MESSAGE.Set_Name('ast', 'API_ROWS_UPDATED');

Line: 953


          ast_WEBSWITCH_VUHK.Delete_WebSwitch_POST(
                              p_api_version => l_api_version,
                              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: 970


          ast_WEBSWITCH_CUHK.Delete_WebSwitch_POST (
                              p_api_version => l_api_version,
                              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: 1008


      ROLLBACK TO Delete_WebSwitch_PUB;

Line: 1016


      ROLLBACK TO Delete_WebSwitch_PUB;

Line: 1024


      ROLLBACK TO Delete_WebSwitch_PUB;