APPS.IEM_KNOWLEDGEBASE_PUB SQL Statements

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

Line: 23

	SELECT 	DOCUMENT_ID,
			SCORE,
			KB_REPOSITORY_NAME,
			KB_CATEGORY_NAME,
			DOCUMENT_TITLE,
			URL,
			DOC_LAST_MODIFIED_DATE
	FROM IEM_KB_RESULTS
	WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
	AND   (MESSAGE_ID = p_MESSAGE_ID)
	AND classification_id = p_CLASSIFICATION_ID;

Line: 116

	SELECT
		display_name,
		is_repository,
		kb_category_id,
		kb_parent_category_id,
		category_order
	FROM IEM_KB_CATEGORIES
	WHERE LEVEL=p_LEVEL
	CONNECT BY PRIOR kb_category_id=kb_parent_category_id
	START WITH kb_category_id= p_cat_id;

Line: 127

		SELECT kb_category_id FROM IEM_EMAIL_CATEGORY_MAPS
		WHERE EMAIL_ACCOUNT_ID=p_EMAIL_ACCOUNT_ID;

Line: 160

	x_KB_Cat_tbl.Delete;

Line: 219

PROCEDURE Delete_ResultsCache ( p_api_version_number    IN   NUMBER,
 		  	      p_init_msg_list  IN   VARCHAR2 ,
		    	      p_commit	    IN   VARCHAR2 ,
			      p_EMAIL_ACCOUNT_ID  IN NUMBER,
                     p_MESSAGE_ID  IN VARCHAR2,
			      x_return_status OUT NOCOPY VARCHAR2,
  		  	      x_msg_count	      OUT NOCOPY    NUMBER,
	  	  	      x_msg_data OUT NOCOPY VARCHAR2) IS
	l_api_name        		VARCHAR2(255):='Delete_ResultsCache';

Line: 232

SAVEPOINT		Delete_ResultsCache_PUB;

Line: 248

   DELETE FROM IEM_KB_RESULTS
   WHERE email_account_id=p_email_account_id
   and message_id=p_message_id;

Line: 251

   DELETE FROM IEM_email_classifications
   WHERE email_account_id=p_email_account_id
   and message_id=p_message_id;

Line: 266

	ROLLBACK TO Delete_Resultscache_PUB;

Line: 273

	ROLLBACK TO Delete_Resultscache_PUB;

Line: 280

	ROLLBACK TO Delete_Resultscache_PUB;

Line: 294

END Delete_ResultsCache ;

Line: 316

	SELECT 	DOCUMENT_ID,
			SCORE,
			KB_REPOSITORY_NAME,
			KB_CATEGORY_NAME,
			DOCUMENT_TITLE,
			URL,
			DOC_LAST_MODIFIED_DATE
	FROM IEM_KB_RESULTS
	WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
	AND   (MESSAGE_ID = p_MESSAGE_ID)
	AND classification_id = p_CLASSIFICATION_ID;

Line: 424

	SELECT 	a.DOCUMENT_ID,(select count(*) from iem_doc_usage_stats where kb_doc_id=a.document_id) rank,
			a.SCORE,
			a.KB_REPOSITORY_NAME,
			a.KB_CATEGORY_NAME,
			a.DOCUMENT_TITLE,
			a.URL,
			a.DOC_LAST_MODIFIED_DATE
	FROM IEM_KB_RESULTS a
	WHERE (a.EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
	AND   (a.MESSAGE_ID = p_MESSAGE_ID)
	AND a.classification_id = p_CLASSIFICATION_ID
	order by 2 desc,1 desc;

Line: 436

cursor c1 is select parameter1, parameter2 from iem_actions a, iem_action_dtls b
where a.emailproc_id=l_rule_id and a.action_id=b.action_id ;

Line: 457

   select count(*) into l_doc_count
   from iem_kb_results
   WHERE EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID
   AND   MESSAGE_ID = p_MESSAGE_ID
   AND classification_id = p_CLASSIFICATION_ID;

Line: 464

		select rule_id
		into l_rule_id
		from iem_rt_proc_emails where message_id=p_message_id;

Line: 468

		select action into l_action from
		iem_actions where emailproc_id=l_rule_id;

Line: 574

	SELECT 	DOCUMENT_ID,
			SCORE,
			KB_REPOSITORY_NAME,
			KB_CATEGORY_NAME,
			DOCUMENT_TITLE,
			URL,
			DOC_LAST_MODIFIED_DATE
	FROM IEM_KB_RESULTS
	WHERE (EMAIL_ACCOUNT_ID = p_EMAIL_ACCOUNT_ID)
	AND   (MESSAGE_ID = p_MESSAGE_ID)
	order by score desc;