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_WEBASSIST_PVT SQL Statements

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

Line: 35


    CURSOR c0 IS SELECT 'X' FROM ast_assists
     WHERE assist_id = p_assist_rec.assist_id;

Line: 38


    CURSOR c1 IS SELECT 'X' FROM ast_web_assists
     WHERE web_assist_id = p_web_assist_rec.web_assist_id;

Line: 41


    CURSOR c2 IS SELECT 'X' FROM ast_web_searches
     WHERE search_id = p_web_search_rec.search_id;

Line: 44


    CURSOR c3 IS SELECT 'X' FROM ast_query_strings
     WHERE query_string_id = p_query_string_rec.query_string_id;

Line: 129


        INSERT INTO ast_assists(
          assist_id,
          object_version_number,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login,
          assistance_type,
          assist_location
        )
        VALUES(
           p_assist_rec.assist_id,
           p_assist_rec.object_version_number,
           p_assist_rec.last_update_date,
           p_assist_rec.last_updated_by,
           p_assist_rec.creation_date,
           p_assist_rec.created_by,
           p_assist_rec.last_update_login,
           p_assist_rec.assistance_type,
           p_assist_rec.location
          );

Line: 161


        INSERT INTO ast_web_assists(
          web_assist_id,
          assist_id,
          object_version_number,
          proxy_host,
          proxy_port,
          enabled_flag,
          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_web_assist_rec.web_assist_id,
           p_web_assist_rec.assist_id,
           p_web_assist_rec.object_version_number,
           p_web_assist_rec.proxy_host,
           p_web_assist_rec.proxy_port,
           p_web_assist_rec.enabled_flag,
           p_web_assist_rec.last_update_date,
           p_web_assist_rec.creation_date,
           p_web_assist_rec.created_by,
           p_web_assist_rec.last_updated_by,
           p_web_assist_rec.last_update_login,
           p_web_assist_rec.attribute_category,
           p_web_assist_rec.attribute1,
           p_web_assist_rec.attribute2,
           p_web_assist_rec.attribute3,
           p_web_assist_rec.attribute4,
           p_web_assist_rec.attribute5,
           p_web_assist_rec.attribute6,
           p_web_assist_rec.attribute7,
           p_web_assist_rec.attribute8,
           p_web_assist_rec.attribute9,
           p_web_assist_rec.attribute10,
           p_web_assist_rec.attribute11,
           p_web_assist_rec.attribute12,
           p_web_assist_rec.attribute13,
           p_web_assist_rec.attribute14,
           p_web_assist_rec.attribute15
          );

Line: 229


        INSERT INTO ast_web_searches(
           search_id,
           web_assist_id,
           object_version_number,
           enabled_flag,
           search_url ,
           cgi_server,
           next_page_ident,
           max_nbr_pages,
           last_update_date,
           creation_date,
           created_by,
           last_updated_by,
           last_update_login,
		 directory_assist_flag,  -- add by jypark 12/26/2000 for new requirement
           attribute_category,
           attribute1,
           attribute2,
           attribute3,
           attribute4,
           attribute5,
           attribute6,
           attribute7,
           attribute8,
           attribute9,
           attribute10,
           attribute11,
           attribute12,
           attribute13,
           attribute14,
           attribute15
          )
        VALUES(
           p_web_search_rec.search_id,
           p_web_search_rec.web_assist_id,
           p_web_search_rec.object_version_number,
           p_web_search_rec.enabled_flag,
           p_web_search_rec.search_url,
           p_web_search_rec.cgi_server,
           p_web_search_rec.next_page_ident,
           p_web_search_rec.max_nbr_pages,
           p_web_search_rec.last_update_date,
           p_web_search_rec.creation_date,
           p_web_search_rec.created_by,
           p_web_search_rec.last_updated_by,
           p_web_search_rec.last_update_login,
		 p_web_search_rec.directory_assist_flag,  -- add by jypark 12/26/2000 for new requirement
           p_web_search_rec.attribute_category,
           p_web_search_rec.attribute1,
           p_web_search_rec.attribute2,
           p_web_search_rec.attribute3,
           p_web_search_rec.attribute4,
           p_web_search_rec.attribute5,
           p_web_search_rec.attribute6,
           p_web_search_rec.attribute7,
           p_web_search_rec.attribute8,
           p_web_search_rec.attribute9,
           p_web_search_rec.attribute10,
           p_web_search_rec.attribute11,
           p_web_search_rec.attribute12,
           p_web_search_rec.attribute13,
           p_web_search_rec.attribute14,
           p_web_search_rec.attribute15
         );

Line: 302


        INSERT INTO ast_query_strings(
          query_string_id,
          search_id,
          object_version_number,
          switch_separator,
          url_separator,
          header_const,
          trailer_const,
          enabled_flag,
          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_query_string_rec.query_string_id,
           p_query_string_rec.search_id,
           p_query_string_rec.object_version_number,
           p_query_string_rec.switch_separator,
           p_query_string_rec.url_separator,
           p_query_string_rec.header_const,
           p_query_string_rec.trailer_const,
           p_query_string_rec.enabled_flag,
           p_query_string_rec.last_update_date,
           p_query_string_rec.creation_date,
           p_query_string_rec.created_by,
           p_query_string_rec.last_updated_by,
           p_query_string_rec.last_update_login,
           p_query_string_rec.attribute_category,
           p_query_string_rec.attribute1,
           p_query_string_rec.attribute2,
           p_query_string_rec.attribute3,
           p_query_string_rec.attribute4,
           p_query_string_rec.attribute5,
           p_query_string_rec.attribute6,
           p_query_string_rec.attribute7,
           p_query_string_rec.attribute8,
           p_query_string_rec.attribute9,
           p_query_string_rec.attribute10,
           p_query_string_rec.attribute11,
           p_query_string_rec.attribute12,
           p_query_string_rec.attribute13,
           p_query_string_rec.attribute14,
           p_query_string_rec.attribute15
         );

Line: 370


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

Line: 565


      CURSOR c1 IS SELECT 'X'
          FROM ast_assists
          WHERE assist_id = p_assist_rec.assist_id
          FOR UPDATE;

Line: 578


      CURSOR c1 IS SELECT 'X'
          FROM ast_web_assists
          WHERE web_assist_id = p_web_assist_rec.web_assist_id
          FOR UPDATE;

Line: 590


      CURSOR c1 IS SELECT 'X'
          FROM ast_web_searches
          WHERE search_id = p_web_search_rec.search_id
          FOR UPDATE;

Line: 602


      CURSOR c1 IS SELECT 'X'
          FROM ast_query_strings
          WHERE query_string_id = p_query_string_rec.query_string_id
          FOR UPDATE;

Line: 691


  PROCEDURE Update_WebAssist(
                      p_api_version IN NUMBER,
                      p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
                      p_commit IN VARCHAR2 := FND_API.G_FALSE,
                      p_validation_level IN NUMBER :=
                                            FND_API.G_VALID_LEVEL_FULL,
                      x_return_status OUT VARCHAR2,
                      x_msg_count OUT NUMBER,
                      x_msg_data OUT VARCHAR2,
                      p_assist_rec assist_rec_type,
                      p_web_assist_rec web_assist_rec_type,
                      p_web_search_rec web_search_rec_type,
                      p_query_string_rec query_string_rec_type
                      )
  IS
    l_api_version            CONSTANT     NUMBER    :=  1.0;

Line: 707


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

Line: 719


    SAVEPOINT Update_WebAssist_PVT;

Line: 745


            ast_WEBASSIST_CUHK.Update_WebAssist_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_assist_rec => l_assist_rec,
                       p_web_assist_rec => l_web_assist_rec,
                       p_web_search_rec => l_web_search_rec,
                       p_query_string_rec => l_query_string_rec
                      );

Line: 765


           ast_WEBASSIST_VUHK.Update_WebAssist_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_assist_rec => l_assist_rec,
                         p_web_assist_rec => l_web_assist_rec,
                         p_web_search_rec => l_web_search_rec,
                         p_query_string_rec => l_query_string_rec
                         );

Line: 787


    UPDATE ast_web_assists
    SET
      proxy_host = p_web_assist_rec.proxy_host,
      proxy_port = p_web_assist_rec.proxy_port,
      last_update_date = p_web_assist_rec.last_update_date,
      last_updated_by = p_web_assist_rec.last_updated_by,
      last_update_login = p_web_assist_rec.last_update_login,
      attribute_category = p_web_assist_rec.attribute_category,
      attribute1 = p_web_assist_rec.attribute1,
      attribute2 = p_web_assist_rec.attribute2,
      attribute3 = p_web_assist_rec.attribute3,
      attribute4 = p_web_assist_rec.attribute4,
      attribute5 = p_web_assist_rec.attribute5,
      attribute6 = p_web_assist_rec.attribute6,
      attribute7 = p_web_assist_rec.attribute7,
      attribute8 = p_web_assist_rec.attribute8,
      attribute9 = p_web_assist_rec.attribute9,
      attribute10 = p_web_assist_rec.attribute10,
      attribute11 = p_web_assist_rec.attribute11,
      attribute12 = p_web_assist_rec.attribute12,
      attribute13 = p_web_assist_rec.attribute13,
      attribute14 = p_web_assist_rec.attribute14,
      attribute15 = p_web_assist_rec.attribute15
    WHERE web_assist_id = p_web_assist_rec.web_assist_id;

Line: 812


    UPDATE ast_web_searches
    SET
      enabled_flag = p_web_search_rec.enabled_flag,
      search_url  = p_web_search_rec.search_url,
      cgi_server = p_web_search_rec.cgi_server,
      next_page_ident = p_web_search_rec.next_page_ident,
      max_nbr_pages = p_web_search_rec.max_nbr_pages,
      last_update_date = p_web_search_rec.last_update_date,
      last_updated_by = p_web_search_rec.last_updated_by,
      last_update_login = p_web_search_rec.last_update_login,
	 directory_assist_flag = p_web_search_rec.directory_assist_flag, -- add by jypakr 12/26/2000 for new requirement
      attribute_category = p_web_search_rec.attribute_category,
      attribute1 = p_web_search_rec.attribute1,
      attribute2 = p_web_search_rec.attribute2,
      attribute3 = p_web_search_rec.attribute3,
      attribute4 = p_web_search_rec.attribute4,
      attribute5 = p_web_search_rec.attribute5,
      attribute6 = p_web_search_rec.attribute6,
      attribute7 = p_web_search_rec.attribute7,
      attribute8 = p_web_search_rec.attribute8,
      attribute9 = p_web_search_rec.attribute9,
      attribute10 = p_web_search_rec.attribute10,
      attribute11 = p_web_search_rec.attribute11,
      attribute12 = p_web_search_rec.attribute12,
      attribute13 = p_web_search_rec.attribute13,
      attribute14 = p_web_search_rec.attribute14,
      attribute15 = p_web_search_rec.attribute15
    WHERE search_id = p_web_search_rec.search_id;

Line: 841


    UPDATE ast_query_strings
    SET
      switch_separator = p_query_string_rec.switch_separator,
      url_separator = p_query_string_rec.url_separator,
      header_const = p_query_string_rec.header_const,
      trailer_const = p_query_string_rec.trailer_const,
      last_update_date = p_query_string_rec.last_update_date,
      last_updated_by = p_query_string_rec.last_updated_by,
      last_update_login = p_query_string_rec.last_update_login,
      attribute_category = p_query_string_rec.attribute_category,
      attribute1 = p_query_string_rec.attribute1,
      attribute2 = p_query_string_rec.attribute2,
      attribute3 = p_query_string_rec.attribute3,
      attribute4 = p_query_string_rec.attribute4,
      attribute5 = p_query_string_rec.attribute5,
      attribute6 = p_query_string_rec.attribute6,
      attribute7 = p_query_string_rec.attribute7,
      attribute8 = p_query_string_rec.attribute8,
      attribute9 = p_query_string_rec.attribute9,
      attribute10 = p_query_string_rec.attribute10,
      attribute11 = p_query_string_rec.attribute11,
      attribute12 = p_query_string_rec.attribute12,
      attribute13 = p_query_string_rec.attribute13,
      attribute14 = p_query_string_rec.attribute14,
      attribute15 = p_query_string_rec.attribute15
    WHERE query_string_id = p_query_string_rec.query_string_id;

Line: 872


                          ast_WEBASSIST_VUHK.Update_WebAssist_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_assist_rec => l_assist_rec,
                             p_web_assist_rec => l_web_assist_rec,
                             p_web_search_rec => l_web_search_rec,
                             p_query_string_rec => l_query_string_rec
                                                                          );

Line: 891


                          ast_WEBASSIST_CUHK.Update_WebAssist_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_assist_rec => l_assist_rec,
                            p_web_assist_rec => l_web_assist_rec,
                            p_web_search_rec => l_web_search_rec,
                            p_query_string_rec => l_query_string_rec);

Line: 923


      ROLLBACK TO Update_WebAssist_PVT;

Line: 931


      ROLLBACK TO Update_WebAssist_PVT;

Line: 939


      ROLLBACK TO Update_WebAssist_PVT;

Line: 952


  PROCEDURE Delete_WebAssist(
                      p_api_version IN NUMBER,
                      p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
                      p_commit IN VARCHAR2 := FND_API.G_FALSE,
                      p_validation_level IN NUMBER :=
                                            FND_API.G_VALID_LEVEL_FULL,
                      x_return_status OUT VARCHAR2,
                      x_msg_count OUT NUMBER,
                      x_msg_data OUT VARCHAR2,
                      p_assist_rec assist_rec_type,
                      p_web_assist_rec web_assist_rec_type,
                      p_web_search_rec web_search_rec_type,
                      p_query_string_rec query_string_rec_type
                      )
  IS
    l_api_version      CONSTANT     NUMBER    :=  1.0;

Line: 968


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

Line: 980


    SAVEPOINT Delete_WebAssist_PVT;

Line: 1007


      ast_WEBASSIST_CUHK.Delete_WebAssist_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_assist_rec => l_assist_rec,
        p_web_assist_rec => l_web_assist_rec,
        p_web_search_rec => l_web_search_rec,
        p_query_string_rec => l_query_string_rec
        );

Line: 1027


      ast_WEBASSIST_VUHK.Delete_WebAssist_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_assist_rec => l_assist_rec,
        p_web_assist_rec => l_web_assist_rec,
        p_web_search_rec => l_web_search_rec,
        p_query_string_rec => l_query_string_rec
       );

Line: 1049


      DELETE FROM ast_query_strings
      WHERE query_string_id = p_query_string_rec.query_string_id;

Line: 1054


      DELETE FROM ast_web_searches
      WHERE search_id = p_web_search_rec.search_id;

Line: 1059


      DELETE FROM ast_web_assists
      WHERE web_assist_id = p_web_assist_rec.web_assist_id;

Line: 1072


      ast_WEBASSIST_VUHK.Delete_WebAssist_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_assist_rec => l_assist_rec,
        p_web_assist_rec => l_web_assist_rec,
        p_web_search_rec => l_web_search_rec,
        p_query_string_rec => l_query_string_rec);

Line: 1090


      ast_WEBASSIST_CUHK.Delete_WebAssist_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_assist_rec => l_assist_rec,
        p_web_assist_rec => l_web_assist_rec,
        p_web_search_rec => l_web_search_rec,
        p_query_string_rec => l_query_string_rec);

Line: 1116


      ROLLBACK TO Delete_WebAssist_PVT;

Line: 1121


      ROLLBACK TO Delete_WebAssist_PVT;

Line: 1126


      ROLLBACK TO Delete_WebAssist_PVT;