APPS.IEM_SUGG_DOC_RANK_PVT SQL Statements

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

Line: 13

         		p_LAST_UPDATED_BY  IN  NUMBER ,
          	p_LAST_UPDATE_DATE  IN  DATE,
          	p_LAST_UPDATE_LOGIN  IN  NUMBER ,
		     x_return_status	OUT NOCOPY VARCHAR2,
  		 	x_msg_count	      OUT	NOCOPY NUMBER,
	  	  	x_msg_data	OUT	NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='create_item';

Line: 26

	select * from (select document_id,document_title,kb_repository_name from iem_kb_results
	where message_id=p_message_id and classification_id=l_class_id order by to_number(score) desc)
	where rownum<=5;

Line: 30

	select document_id,document_title,kb_repository_name from iem_kb_results
	where message_id=p_message_id and
	(document_id,document_title,kb_repository_name) not in
	(
	select * from (select document_id,document_title,kb_repository_name from iem_kb_results
	where message_id=p_message_id and classification_id=l_class_id order by to_number(score) desc)
	where rownum<=5);

Line: 49

 select *  into l_class_id
 from (select classification_id from iem_email_classifications
 where message_id=p_message_id order by score desc)
 where rownum=1;

Line: 56

	select IEM_SUGG_DOC_DTLS_S1.nextval into l_sugg_id
	from dual;

Line: 58

INSERT INTO IEM_SUGG_DOC_DTLS
  (DOC_SUGG_ID		,
   OUTBOUND_MSG_STATS_ID  ,
   KB_DOC_ID	,
   KB_DOC_RANK	,
   KB_DOC_TITLE,
   REPOSITORY,
   CREATED_BY,
 CREATION_DATE,
 LAST_UPDATED_BY,
 LAST_UPDATE_DATE,
 LAST_UPDATE_LOGIN)
VALUES
(l_sugg_id,
p_outbound_msg_stats_id,
v1.document_id,
l_rank,
v1.document_title,
v1.kb_repository_name,
decode(p_CREATED_BY,null,-1,p_CREATED_BY),
sysdate,
decode(p_LAST_UPDATED_BY,null,-1,p_LAST_UPDATED_BY),
sysdate,
decode(p_LAST_UPDATE_LOGIN,null,-1,p_LAST_UPDATE_LOGIN));

Line: 86

	select IEM_SUGG_DOC_DTLS_S1.nextval into l_sugg_id
	from dual;

Line: 88

INSERT INTO IEM_SUGG_DOC_DTLS
  (DOC_SUGG_ID		,
   OUTBOUND_MSG_STATS_ID  ,
   KB_DOC_ID	,
   KB_DOC_RANK	,
   KB_DOC_TITLE,
   REPOSITORY,
   CREATED_BY,
 CREATION_DATE,
 LAST_UPDATED_BY,
 LAST_UPDATE_DATE,
 LAST_UPDATE_LOGIN)
VALUES
(l_sugg_id,
p_outbound_msg_stats_id,
v2.document_id,
l_rank,
v2.document_title,
v2.kb_repository_name,
decode(p_CREATED_BY,null,-1,p_CREATED_BY),
sysdate,
decode(p_LAST_UPDATED_BY,null,-1,p_LAST_UPDATED_BY),
sysdate,
decode(p_LAST_UPDATE_LOGIN,null,-1,p_LAST_UPDATE_LOGIN));