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;