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.IEX_WEBDIR_PKG SQL Statements

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

Line: 34


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

Line: 37


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

Line: 40


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

Line: 75


        INSERT INTO IEX_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: 143


        INSERT INTO IEX_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: 216


        INSERT INTO IEX_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: 367


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

Line: 379


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

Line: 391


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

Line: 441


  PROCEDURE Update_WebAssist(
                      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_assist_rec IN assist_rec_type,
                      p_web_assist_rec IN web_assist_rec_type,
                      p_web_search_rec IN web_search_rec_type,
                      p_query_string_rec IN query_string_rec_type
                      )
  IS
    l_api_version            CONSTANT     NUMBER    :=  1.0;

Line: 456


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

Line: 467


    SAVEPOINT Update_WebAssist_PVT;

Line: 494


    UPDATE IEX_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: 519


    UPDATE IEX_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: 548


    UPDATE iex_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: 592


      ROLLBACK TO Update_WebAssist_PVT;

Line: 600


      ROLLBACK TO Update_WebAssist_PVT;

Line: 608


      ROLLBACK TO Update_WebAssist_PVT;

Line: 621


  PROCEDURE Delete_WebAssist(
                      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_assist_rec IN assist_rec_type,
                      p_web_assist_rec IN web_assist_rec_type,
                      p_web_search_rec IN web_search_rec_type,
                      p_query_string_rec IN query_string_rec_type
                      )
  IS
    l_api_version      CONSTANT     NUMBER    :=  1.0;

Line: 636


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

Line: 647


    SAVEPOINT Delete_WebAssist_PVT;

Line: 676


      DELETE FROM ast_query_strings
      WHERE query_string_id = p_query_string_rec.query_string_id;

Line: 681


      DELETE FROM IEX_WEB_searches
      WHERE search_id = p_web_search_rec.search_id;

Line: 686


      DELETE FROM IEX_WEB_assists
      WHERE web_assist_id = p_web_assist_rec.web_assist_id;

Line: 708


      ROLLBACK TO Delete_WebAssist_PVT;

Line: 713


      ROLLBACK TO Delete_WebAssist_PVT;

Line: 718


      ROLLBACK TO Delete_WebAssist_PVT;