DBA Data[Home] [Help]

PACKAGE: APPS.IEM_SPV_ACTIONS_PVT

Source


1 package IEM_SPV_ACTIONS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvspas.pls 115.2 2003/07/25 00:57:28 chtang noship $*/
3 
4 
5 PROCEDURE delete_queue_msg (p_api_version_number    	IN   NUMBER,
6  		  	      p_init_msg_list  		IN   VARCHAR2 :=NULL,
7 		    	      p_commit	    		IN   VARCHAR2 := NULL,
8 			      p_message_id 		in  number,
9 			      p_reason_id		in  number,
10 			      x_return_status		OUT NOCOPY	VARCHAR2,
11   		  	      x_msg_count	      	OUT NOCOPY	  NUMBER,
12 	  	  	      x_msg_data		OUT NOCOPY	VARCHAR2);
13 
14 PROCEDURE delete_queue_msg_batch (p_api_version_number  IN   NUMBER,
15  		  	      p_init_msg_list  		IN   VARCHAR2 := NULL,
16 		    	      p_commit	    		IN   VARCHAR2 := NULL,
17 			      p_message_ids_tbl 	IN  jtf_varchar2_Table_100,
18 			      p_reason_id		IN	number,
19 			      x_moved_message_count 	OUT	NOCOPY	NUMBER,
20 			      x_return_status		OUT	NOCOPY  VARCHAR2,
21   		  	      x_msg_count	      	OUT	NOCOPY   NUMBER,
22 	  	  	      x_msg_data		OUT	NOCOPY 	VARCHAR2);
23 
24 end IEM_SPV_ACTIONS_PVT;