APPS.IEM_ARCH_REQUESTS_PVT SQL Statements

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

Line: 18

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

INSERT INTO IEM_ARCH_REQUESTS
(REQUEST_ID,
 ARCH_CRITERIA,
 EMAIL_ACCOUNT_ID,
 FOLDER_NAME,
 ARCH_FOLDER_ID,
 ARCH_COUNT,
 STATUS,
 REQUEST_TYPE,
 CREATED_BY,
 CREATION_DATE,
 LAST_UPDATED_BY,
 LAST_UPDATE_DATE,
 LAST_UPDATE_LOGIN)
VALUES
(p_request_id,
p_arch_criteria,
p_email_account_id,
p_folder_name,
p_arch_folder_id,
p_arch_count,
'S',
p_request,
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: 105

PROCEDURE update_item(p_api_version_number    IN   NUMBER,
 		  	      p_init_msg_list  IN   VARCHAR2 ,
		    	      p_commit	    IN   VARCHAR2 ,
				 p_request_id	in number,
				 p_arch_folder_id	in number,
				 p_arch_count	in number,
				 p_arch_size	in number,
				 p_status		in varchar2,
				 p_comment	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):='update_item';

Line: 131

	update iem_arch_requests
	set arch_count=decode(p_arch_count,null,arch_count,p_arch_count),
	arch_size=decode(p_arch_size,null,arch_size,p_arch_size),
	status=p_status,
	arch_comment=decode(p_comment,null,arch_comment,p_comment)
    where request_id=p_request_id and arch_folder_id=p_arch_folder_id;

Line: 175

 END	update_item;