APPS.DOM_WS_INTERFACE_PUB SQL Statements

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

Line: 48

	  SELECT profile_option_value INTO proxy
	  FROM fnd_profile_option_values vl ,  FND_PROFILE_OPTIONS pr
		WHERE vl.profile_option_id = pr.profile_option_id
		AND pr.PROFILE_OPTION_NAME = 'WEB_PROXY_HOST';

Line: 246

	SELECT USER_NAME FROM fnd_user WHERE person_party_id = p_member_id;

Line: 266

    SELECT GROUP_NAME INTO l_group_name FROM EGO_GROUPS_V WHERE GROUP_ID = p_group_id;

Line: 274

	    SELECT us.user_name INTO l_logged_in
	    FROM hz_parties hz, fnd_user us
	    WHERE hz.created_by =   us.USER_ID
	    AND party_id = p_group_id;

Line: 298

procedure Update_Files_Document_Status (
   p_api_version	      IN	NUMBER,
   p_service_url        IN	VARCHAR2,
   p_document_id      	IN	NUMBER,
   p_status           	IN	VARCHAR2,
   p_login_user_name    IN	VARCHAR2,
   x_return_status	    OUT	NOCOPY VARCHAR2,
   x_msg_count		      OUT	NOCOPY NUMBER,
   x_msg_data		        OUT	NOCOPY VARCHAR2
   )
   IS

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

Line: 330

    l_param_query_string:='opName=updateDocStatus&docId='||p_document_id||'&status='||p_status||'&serviceUrl='||p_service_Url||'&loggedInUser='||p_login_user_name;

Line: 339

END Update_Files_Document_Status;