1 PACKAGE CCT_MEDIA_QUEUE_PUB AUTHID CURRENT_USER AS
2 /* $Header: cctpmqs.pls 115.3 2002/12/06 01:06:42 svinamda noship $*/
3
4 -- Start of comments
5 -- API name : UPDATE_DEQUEUE_COUNT
6 -- Type : Public
7 -- Function : Init media dequeue counts for all media types
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_TRUE
15 -- p_media_type IN NUMBER Required
16 -- p_dequeue_count IN NUMBER Required
17 -- OUT : x_return_status OUT VARCHAR2(1)
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2(2000)
20 -- .
21 -- .
22 -- Version : Current version 1.0
23 -- Initial version 1.0
24 --
25 -- Notes : svinamda 22 MAR 2001 Created
26 --
27 -- End of comments
28
29
30 PROCEDURE UPDATE_DEQUEUE_COUNT
31 ( p_api_version IN NUMBER ,
32 p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE ,
33 p_commit IN VARCHAR2 Default FND_API.G_FALSE,
34 p_root_svr_group_id IN NUMBER,
35 p_media_type IN NUMBER,
36 p_dequeue_count IN NUMBER,
37 x_return_status OUT NOCOPY VARCHAR2 ,
38 x_msg_count OUT NOCOPY NUMBER ,
39 x_msg_data OUT NOCOPY VARCHAR2
40 );
41
42
43 PROCEDURE GET_MEDIA_QUEUE_DETAILS
44 (
45 p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE ,
47 p_commit IN VARCHAR2 Default FND_API.G_FALSE ,
48 p_media_item_id IN NUMBER , -- Required
49 p_server_group_name IN VARCHAR2, -- Required
50 x_abs_pos_media_type OUT NOCOPY NUMBER, -- absolute position of media item in the media type queue
51 x_relative_pos_media_type OUT NOCOPY NUMBER, -- absolute position by media type / no of agents logged in for media type
52 x_abs_pos_all_media_types OUT NOCOPY NUMBER, -- absolute position of media item for all media types
53 x_relative_pos_all_media_types OUT NOCOPY NUMBER, -- absolute position of all media types / total # of agents logged in
54 x_return_status OUT NOCOPY VARCHAR2 ,
55 x_msg_count OUT NOCOPY NUMBER ,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59
60
61 END CCT_MEDIA_QUEUE_PUB;