PACKAGE: APPS.CCT_QDE_PUB

Source

1 PACKAGE CCT_QDE_PUB AUTHID CURRENT_USER AS
2 /* $Header: cctpqdes.pls 115.3 2003/10/02 23:24:24 svinamda noship $*/
3 
4 
5 PROCEDURE RECEIVE_ITEM
6 (
7     p_api_version       IN	NUMBER,
8   	p_init_msg_list		IN	VARCHAR2 ,
9 	p_commit	    	IN  VARCHAR2,
10     p_app_id            IN  NUMBER,
11     p_item_id           IN  NUMBER,
12     p_item_type		    IN	NUMBER,
13     p_classification    IN  VARCHAR2,
14     p_kvp               IN  cct_keyvalue_varr,
15     p_delay             IN NUMBER,
16 	x_return_status		OUT NOCOPY	VARCHAR2 ,
17     x_msg_count		OUT NOCOPY	NUMBER	,
18 	x_msg_data		OUT NOCOPY	VARCHAR2
19 );
20 
21 
22 PROCEDURE UPDATE_ROUTE_RESULT
23 (
24     p_api_version           	IN	NUMBER,
25   	p_init_msg_list			IN	VARCHAR2,
26 	p_commit	    	IN  VARCHAR2,
27   	p_item_id 		IN 	NUMBER,
28     p_item_type              IN NUMBER,
29     p_classification        IN VARCHAR2,
30     p_route_result          IN VARCHAR2,
31     p_is_route_to_all     IN VARCHAR2,
32     p_is_reroute         IN VARCHAR2,
33     p_kvp               IN  cct_keyvalue_varr,
34  	x_return_status		OUT NOCOPY	VARCHAR2,
35 	x_msg_count		OUT NOCOPY	NUMBER,
36     x_msg_data		OUT NOCOPY	VARCHAR2
37 );
38 
39 PROCEDURE GET_NEXT_ITEM
40 (
41     p_api_version   IN	NUMBER,
42   	p_init_msg_list	IN	VARCHAR2,
43 	p_commit	    IN  VARCHAR2,
44   	p_agent_id 		IN 	NUMBER,
45     p_item_type    IN NUMBER,
46     p_classification IN VARCHAR2,
47  	x_return_status	OUT NOCOPY	VARCHAR2,
48 	x_msg_count		OUT NOCOPY	NUMBER,
49     x_msg_data		OUT NOCOPY	VARCHAR2,
50     x_app_id        OUT NOCOPY NUMBER,
51     x_item_id OUT NOCOPY NUMBER,
52     x_item_type	OUT NOCOPY	NUMBER,
53     x_classification OUT NOCOPY  VARCHAR2,
54     x_kvp     OUT NOCOPY cct_keyvalue_varr
55 );
56 
57 PROCEDURE UPDATE_AGENT_QUEUES
58 (
59     p_api_version   IN	NUMBER,
60   	p_init_msg_list	IN	VARCHAR2,
61 	p_commit	    IN  VARCHAR2,
62   	p_agent_id 		IN 	NUMBER,
63     p_item_type    IN NUMBER,
64  	x_return_status	OUT NOCOPY	VARCHAR2,
65 	x_msg_count		OUT NOCOPY	NUMBER,
66     x_msg_data		OUT NOCOPY	VARCHAR2
67 );
68 
69 
70 PROCEDURE GET_AGENT_INDEX
71 (
72     p_api_version   IN	NUMBER,
73   	p_init_msg_list	IN	VARCHAR2,
74 	p_commit	    IN  VARCHAR2,
75   	p_agent_id 		IN 	NUMBER,
76  	x_return_status	OUT NOCOPY	VARCHAR2,
77 	x_msg_count		OUT NOCOPY	NUMBER,
78     x_msg_data		OUT NOCOPY	VARCHAR2,
79     x_agent_index   OUT NOCOPY NUMBER,
80     x_raw_agent_index OUT NOCOPY RAW
81 );
82 
83 
84 FUNCTION UPDATE_CLASSIFICATION_COUNT
85 (
86 	p_commit	    IN  VARCHAR2,
87   	p_agent_id 		IN 	NUMBER,
88     p_item_type    IN NUMBER,
89     p_classification IN VARCHAR2,
90     p_count         IN NUMBER
91 )
92 RETURN NUMBER;
93 
94 FUNCTION IS_BIT_SET (agent_id IN RAW, route_result IN RAW) RETURN NUMBER ;
95 
96 
97 END CCT_QDE_PUB;