APPS.IEX_WEBDIR_PVT SQL Statements

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

Line: 46

	 SELECT WEB_ASSIST_ID
	 FROM IEX_WEB_ASSISTS
	 WHERE PROXY_HOST = l_web_assist_rec.proxy_host
	 AND PROXY_PORT = l_web_assist_rec.proxy_port;

Line: 52

	 SELECT SEARCH_ID
	 FROM IEX_WEB_SEARCHES
	 WHERE SEARCH_URL = l_web_search_rec.search_url
	 AND CGI_SERVER = l_web_search_rec.cgi_server;

Line: 58

	 SELECT IEX_QUERY_STRINGS_S.NEXTVAL
      FROM SYS.DUAL;

Line: 80

    l_assist_rec.last_update_date := sysdate;

Line: 83

    l_assist_rec.last_updated_by := l_user_id;

Line: 84

    l_assist_rec.last_update_login := l_login_id;

Line: 90

    l_web_assist_rec.last_update_date := sysdate;

Line: 93

    l_web_assist_rec.last_updated_by := l_user_id;

Line: 94

    l_web_assist_rec.last_update_login := l_login_id;

Line: 102

    l_web_search_rec.last_update_date := sysdate;

Line: 105

    l_web_search_rec.last_updated_by := l_user_id;

Line: 106

    l_web_search_rec.last_update_login := l_login_id;

Line: 116

    l_query_string_rec.last_update_date := sysdate;

Line: 119

    l_query_string_rec.last_updated_by := l_user_id;

Line: 120

    l_query_string_rec.last_update_login := l_login_id;

Line: 132

		  SELECT IEX_WEB_ASSISTS_S.NEXTVAL
	      FROM SYS.DUAL;

Line: 153

	     SELECT IEX_WEB_SEARCHES_S.NEXTVAL
	     FROM SYS.DUAL;

Line: 223

  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: 253

    SAVEPOINT Update_WebAssist_PVT;

Line: 271

    l_assist_rec.last_update_date := sysdate;

Line: 272

    l_assist_rec.last_updated_by := l_user_id;

Line: 273

    l_assist_rec.last_update_login := l_login_id;

Line: 283

    l_web_assist_rec.last_update_date := sysdate;

Line: 284

    l_web_assist_rec.last_updated_by := l_user_id;

Line: 285

    l_web_assist_rec.last_update_login := l_login_id;

Line: 297

    l_web_search_rec.last_update_date := sysdate;

Line: 298

    l_web_search_rec.last_updated_by := l_user_id;

Line: 299

    l_web_search_rec.last_update_login := l_login_id;

Line: 313

    l_query_string_rec.last_update_date := sysdate;

Line: 314

    l_query_string_rec.last_updated_by := l_user_id;

Line: 315

    l_query_string_rec.last_update_login := l_login_id;

Line: 324

    IEX_WEBDIR_PKG.Update_WebAssist(
 	P_API_VERSION => l_api_version,
     P_INIT_MSG_LIST => p_init_msg_list,
 	P_COMMIT => p_commit,
 	P_VALIDATION_LEVEL => p_validation_level,
 	X_RETURN_STATUS => x_return_status,
 	X_MSG_COUNT => x_msg_count,
 	X_MSG_DATA => x_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: 344

      ROLLBACK TO Update_WebAssist_PVT;

Line: 349

      ROLLBACK TO Update_WebAssist_PVT;

Line: 354

      ROLLBACK TO Update_WebAssist_PVT;

Line: 362

 END Update_WebAssist;