DBA Data[Home] [Help]

PACKAGE: APPS.CCT_UTIL_PUB

Source


1 PACKAGE CCT_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: cctpus.pls 115.7 2002/12/06 01:06:45 svinamda noship $*/
3 
4 -- Start of comments
5 --	API name 	: GET_MIDDLEWARE_ID
6 --	Type		: Public
7 --	Function	: Return middleware id for a specific agent id.
8 --	Pre-reqs	: None.
9 --	Parameters	:
10 --	IN		:	p_api_version	IN NUMBER	Required
11 --				p_init_msg_list	IN VARCHAR2 	Optional
12 --					Default = FND_API.G_FALSE
13 --				p_commit	IN VARCHAR2	Optional
14 --					Default = FND_API.G_FALSE
15 -- 				p_agent_id	IN NUMBER Required
16 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
17 --				x_msg_count	OUT	NUMBER
18 --				x_msg_data	OUT	VARCHAR2(2000)
19 --				x_middleware_id OUT NUMBER
20 --				x_middleware_config_name OUT VARCHAR2
21 --	Version	: Current version	1.0
22 --		  Initial version 	1.0
23 --
24 --	Notes		: svinamda  FEB 25 2001 Created
25 --
26 -- End of comments
27 
28 
29 PROCEDURE GET_MIDDLEWARE_ID
30 ( 	p_api_version           IN	NUMBER				,
31   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
32 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE,
33 	p_agent_id IN NUMBER,
34 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
35 	x_msg_count		OUT NOCOPY	NUMBER				,
36 	x_msg_data		OUT NOCOPY	VARCHAR2			,
37 	x_middleware_id OUT NOCOPY NUMBER
38 );
39 
40 
41 
42 
43 PROCEDURE CLOSE_MILCS
44 ( 	p_api_version           IN	NUMBER				,
45   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
46 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE,
47 	p_milcs_type_id IN NUMBER,
48     p_media_item_id IN NUMBER,
49     p_end_date_time IN DATE Default sysdate,
50 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
51 	x_msg_count		OUT NOCOPY	NUMBER				,
52 	x_msg_data		OUT NOCOPY	VARCHAR2
53 );
54 
55 
56 -- return value = 0 => media item can be closed.
57 -- return value = 1 => media item cannot be closed.
58 
59 PROCEDURE CAN_CLOSE_MEDIA_ITEM
60 (
61  	p_api_version           IN	NUMBER				,
62   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
63 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE,
64     p_media_item_id IN NUMBER,
65     x_can_close_media_item OUT NOCOPY NUMBER ,
66 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
67 	x_msg_count		OUT NOCOPY	NUMBER				,
68 	x_msg_data		OUT NOCOPY	VARCHAR2
69 );
70 
71 END CCT_UTIL_PUB;