APPS.DOM_WS_INTERFACE_PUB SQL Statements

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

Line: 53

    SELECT profile_option_value INTO l_profile_option_value FROM fnd_profile_option_values WHERE profile_option_id =
    (select profile_option_id FROM fnd_profile_options WHERE profile_option_name = 'EGO_ENABLE_PLM')
    AND LEVEL_ID =10001 AND LEVEL_VALUE=0;

Line: 58

      SELECT Count(*) INTO l_count FROM dom_repositories WHERE protocol = 'WEBSERVICES';

Line: 63

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

    SELECT DomRepositories.ID NODE_ID,
				  DomRepositories.NAME REPOS_NAME,
				  DomRepositories.DESCRIPTION NODE_DESCRIPTION,
				  DomRepositories.SHORT_NAME	,
				  DomRepositories.DAV_URL ,
				  DomRepositories.SERVICE_URL,
				  DomRepositories.PROTOCOL,
				  DomRepositories.SEQUENCE,
				  DomRepositories.CERTIFICATE_PATH
    FROM DOM_REPOSITORIES_VL DomRepositories,
			    FND_LOOKUP_VALUES_VL lkp
    WHERE lkp.lookup_type='DOM_REPOSITORY_PROTOCOLS'
		    AND lkp.lookup_code = DomRepositories.PROTOCOL
		    AND DomRepositories.ID <>0
    ORDER BY id,DomRepositories.SEQUENCE;

Line: 321

	SELECT USER_NAME FROM fnd_user WHERE person_party_id = p_member_id;

Line: 341

    SELECT GROUP_NAME INTO l_group_name FROM EGO_GROUPS_V WHERE GROUP_ID = p_group_id;

Line: 349

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

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

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

Line: 414

END Update_Files_Document_Status;