eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CCT_AQ_PUB

Source


1 PACKAGE CCT_AQ_PUB AUTHID CURRENT_USER AS
2 /* $Header: cctpaqs.pls 115.29 2003/03/14 20:00:57 svinamda noship $*/
3 
4 G_ABANDON_MEDIA 	CONSTANT VARCHAR2(40) := 'AbandonMedia';
5 G_TIMEOUT        	CONSTANT VARCHAR2(8) := 'TIMEOUT';
6 
7 
8 G_BASIC_SDK_GROUP_NAME CONSTANT VARCHAR2(30) := 'BASIC_SDK';
9 G_KEY_COUNTRY_CODE CONSTANT VARCHAR2(30) := 'CountryCode';
10 G_KEY_AREA_CODE CONSTANT VARCHAR2(30) := 'AreaCode';
11 G_KEY_PHONE_NUMBER CONSTANT VARCHAR2(30) := 'PhoneNumber';
12 --G_KEY_LSERVER_GROUP_NAME CONSTANT VARCHAR2(30) := 'occtServerGroupName';
13 G_KEY_MEETING_URL CONSTANT VARCHAR2(30) := 'occtURL';
14 G_KEY_WITH_CALLBACK CONSTANT VARCHAR2(30) := 'occtWithCallback';
15 G_KEY_MEDIA_ITEM_ID CONSTANT VARCHAR2(30) := 'occtMediaItemID';
16 G_KEY_LOCAL_SERVER_GROUP_NAME CONSTANT VARCHAR2(30) := 'occtLocalServerGroupName';
17 G_KEY_LOCAL_SERVER_GROUP_ID CONSTANT VARCHAR2(30) := 'occtLocalServerGroupId';
18 G_KEY_SUPER_SERVER_GROUP_NAME CONSTANT VARCHAR2(30) := 'occtSuperServerGroupName';
19 G_KEY_SUPER_SERVER_GROUP_ID CONSTANT VARCHAR2(30) := 'occtSuperServerGroupId';
20 
21 
22 FUNCTION IS_SERVER_UP (l_server_id IN NUMBER) RETURN NUMBER ;
23 
24 -- Start of comments
25 --	API name 	: ENQUEUE_ITEM
26 --	Type		: Public
27 --	Function	: Enqueue an item into the database.
28 --	Pre-reqs	: None.
29 --	Parameters	:
30 --	IN		:	p_api_version	IN NUMBER	Required
31 --				p_init_msg_list	IN VARCHAR2 	Optional
32 --					Default = FND_API.G_FALSE
33 --				p_commit	IN VARCHAR2	Optional
34 --					Default = FND_API.G_FALSE
35 --  				p_server_group_name	IN VARCHAR2 Required
36 --  				p_app_id		IN NUMBER Optional
37 --  				p_xml_data1		IN VARCHAR2 Required
38 --				p_media_type		IN VARCHAR2 Required
39 --					Default = FND_API.G_MISS_NUM;
40 
41 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
42 --				x_msg_count	OUT	NUMBER
43 --				x_msg_data	OUT	VARCHAR2(2000)
44 --				.
45 --				.
46 --	Version	: Current version	1.0
47 --		  Initial version 	1.0
48 --
49 --	Notes		: svinamda 22 MAR 2001 Created
50 --
51 -- End of comments
52 
53 
54 PROCEDURE ENQUEUE_ITEM
55 ( 	p_api_version           IN	NUMBER				,
56   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
57 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE	,
58 	p_server_group_name	IN 	VARCHAR2,
59 	p_app_id		IN   	NUMBER Default -1,
60  	p_xml_data1		IN   	VARCHAR2 ,
61 	p_media_type		IN	NUMBER,
62     p_delay         IN NUMBER Default -1,
63 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
64 	x_msg_count		OUT NOCOPY	NUMBER				,
65 	x_msg_data		OUT NOCOPY	VARCHAR2
66 );
67 
68 
69 -- Start of comments
70 --	API name 	: DEQUEUE_ITEM
71 --	Type		: Public
72 --	Function	: Dequeue an item from the database.
73 --	Pre-reqs	: None.
74 --	Parameters	:
75 --	IN		:	p_api_version	IN NUMBER	Required
76 --				p_init_msg_list	IN VARCHAR2 	Optional
77 --					Default = FND_API.G_FALSE
78 --				p_commit	IN VARCHAR2	Optional
79 --					Default = FND_API.G_FALSE
80 --
81 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
82 --				x_msg_count	OUT	NUMBER
83 --				x_msg_data	OUT	VARCHAR2(2000)
84 --				p_server_group_name	OUT VARCHAR2 Required
85 --  				p_xml_data1		OUT VARCHAR2 Required
86 --
87 --	Version	: Current version	1.0
88 --		  Initial version 	1.0
89 --
90 --	Notes		: svinamda 22 MAR 2001 Created
91 --
92 -- End of comments
93 
94 PROCEDURE DEQUEUE_ITEM
95 ( 	p_api_version           IN	NUMBER				,
96   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
97 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE	,
98 	p_server_group_id IN NUMBER ,
99 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
100 	x_msg_count		OUT NOCOPY	NUMBER				,
101 	x_msg_data		OUT NOCOPY	VARCHAR2			,
102 	x_server_group_name	OUT NOCOPY 	VARCHAR2 ,
103  	x_xml_data1		OUT NOCOPY   	VARCHAR2
104 );
105 
106 
107 
108 -- Start of comments
109 --	API name 	: ENQUEUE_WEB_CALLBACK_ITEM
110 --	Type		: Public
111 --	Function	: Enqueue a web callback item into the database.
112 --	Pre-reqs	: None.
113 --	Parameters	:
114 --	IN		:	p_api_version	IN NUMBER	Required
115 --				p_init_msg_list	IN VARCHAR2 	Optional
116 --					Default = FND_API.G_FALSE
117 --				p_commit	IN VARCHAR2	Optional
118 --					Default = FND_API.G_FALSE
119 --  				p_server_group_name	IN VARCHAR2 Required
120 --  				p_app_id		IN NUMBER Optional
121 --				p_country_code		IN NUMBER Required
122 --				p_area_code		IN NUMBER Required
123 --				p_phone_number		IN NUMBER Required
124 --				p_delay			IN VARCHAR2 Optional
125 --				p_key1			IN VARCHAR2 Optional
126 --				p_value1		IN VARCHAR2 Optional
127 --				p_key2			IN VARCHAR2 Optional
128 --				p_value2		IN VARCHAR2 Optional
129 --				p_key3			IN VARCHAR2 Optional
130 --				p_value3		IN VARCHAR2 Optional
131 --				p_key4 			IN VARCHAR2 Optional
132 -- 				p_value4		IN VARCHAR2 Optional
133 --				p_key5			IN VARCHAR2 Optional
134 --				p_value5		IN VARCHAR2 Optional
135 --				p_key6			IN VARCHAR2 Optional
136 --				p_value6		IN VARCHAR2 Optional
137 --				p_key7			IN VARCHAR2 Optional
138 --				p_value7		IN VARCHAR2 Optional
139 --				p_key8 			IN VARCHAR2 Optional
140 -- 				p_value8		IN VARCHAR2 Optional
141 --				p_key9			IN VARCHAR2 Optional
142 --				p_value9		IN VARCHAR2 Optional
143 --				p_key10			IN VARCHAR2 Optional
144 --				p_value10		IN VARCHAR2 Optional
145 
146 --
147 --
148 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
149 --				x_msg_count	OUT	NUMBER
150 --				x_msg_data	OUT	VARCHAR2(2000)
151 --				.
152 --				.
153 --	Version	: Current version	1.0
154 --		  Initial version 	1.0
155 --
156 --	Notes		: svinamda 06 APR 2001 Created
157 --
158 -- End of comments
159 
160 
161 PROCEDURE ENQUEUE_WEB_CALLBACK_ITEM
162 ( 	p_api_version           IN	NUMBER				,
163   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
164 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE	,
165 	p_server_group_name	IN 	VARCHAR2,
166 	p_app_id		IN   	NUMBER Default -1,
167 	p_country_code		IN	NUMBER,
168 	p_area_code		IN	NUMBER,
169 	p_phone_number		IN	NUMBER,
170 	p_delay			IN 	NUMBER Default -1,
171 	p_key1			IN 	VARCHAR2 Default null,
172 	p_value1		IN 	VARCHAR2 Default null,
173 	p_key2			IN 	VARCHAR2 Default null,
174 	p_value2		IN 	VARCHAR2 Default null,
175 	p_key3			IN 	VARCHAR2 Default null,
176 	p_value3		IN 	VARCHAR2 Default null,
177 	p_key4 			IN 	VARCHAR2 Default null,
178 	p_value4		IN 	VARCHAR2 Default null,
179 	p_key5			IN 	VARCHAR2 Default null,
180 	p_value5		IN 	VARCHAR2 Default null,
181 	p_key6			IN 	VARCHAR2 Default null,
182 	p_value6		IN 	VARCHAR2 Default null,
183 	p_key7			IN 	VARCHAR2 Default null,
184 	p_value7		IN 	VARCHAR2 Default null,
185 	p_key8 			IN 	VARCHAR2 Default null,
186 	p_value8		IN 	VARCHAR2 Default null,
187 	p_key9			IN 	VARCHAR2 Default null,
188 	p_value9		IN 	VARCHAR2 Default null,
189 	p_key10			IN 	VARCHAR2 Default null,
190 	p_value10		IN 	VARCHAR2 Default null,
191 	x_return_status		OUT NOCOPY	VARCHAR2,
192 	x_msg_count		OUT NOCOPY	NUMBER,
193 	x_msg_data		OUT NOCOPY	VARCHAR2
194 );
195 
196 
197 -- Start of comments
198 --	API name 	: GET_ROOT_GROUP_NAME
199 --	Type		: Public
200 --	Function	: Returns the root server group name.
201 --	Pre-reqs	: None.
202 --	Parameters	:
203 --	IN		:	p_api_version	IN NUMBER	Required
204 --				p_init_msg_list	IN VARCHAR2 	Optional
205 --					Default = FND_API.G_FALSE
206 --  				p_server_group_name	IN VARCHAR2 Required
207 --
208 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
209 --				x_msg_count	OUT	NUMBER
210 --				x_msg_data	OUT	VARCHAR2(2000)
211 --				x_root_server_group_name OUT VARCHAR2(256)
212 --				.
213 --				.
214 --	Version	: Current version	1.0
215 --		  Initial version 	1.0
216 --
217 --	Notes		: svinamda 06 APR 2001 Created
218 --
219 -- End of comments
220 
221 
222 PROCEDURE GET_ROOT_GROUP_NAME
223 ( 	p_api_version           	IN	NUMBER,
224   	p_init_msg_list			IN	VARCHAR2 Default FND_API.G_FALSE,
225   	p_server_group_name 		IN 	VARCHAR2,
226  	x_return_status		OUT NOCOPY	VARCHAR2		  	,
227 	x_msg_count		OUT NOCOPY	NUMBER				,
228 	x_msg_data		OUT NOCOPY	VARCHAR2			,
229 	x_root_server_group_name	OUT NOCOPY	VARCHAR2
230 );
231 
232 
233 -- Start of comments
234 --	API name 	: ENQUEUE_WEB_COLLABORATION_ITEM
235 --	Type		: Public
236 --	Function	: Enqueue a web collaboration item into the database.
237 --	Pre-reqs	: None.
238 --	Parameters	:
239 
240 
241 
242 --	IN		:	p_api_version	IN NUMBER	Required
243 --				p_init_msg_list	IN VARCHAR2 	Optional, Default = FND_API.G_FALSE
244 --				p_commit	IN VARCHAR2	Optional, Default = FND_API.G_FALSE
245 --  			p_server_group_name	IN VARCHAR2 Required
246 --              p_server_group_id  IN  NUMBER Default null
247 --  			p_app_id		IN NUMBER Default = -1
248 --              p_meeting_URL IN  VARCHAR2
249 --              p_with_callback IN  VARCHAR2 Default  FND_API.G_TRUE
250 --              p_ih_media_item_id IN NUMBER  Default -1
251 --				p_country_code		IN NUMBER Optional
252 --				p_area_code		IN NUMBER Optional
253 --				p_phone_number		IN NUMBER Required
254 --				p_key1			IN VARCHAR2 Optional
255 --				p_value1		IN VARCHAR2 Optional
256 --				p_key2			IN VARCHAR2 Optional
257 --				p_value2		IN VARCHAR2 Optional
258 --				p_key3			IN VARCHAR2 Optional
259 --				p_value3		IN VARCHAR2 Optional
260 --				p_key4 			IN VARCHAR2 Optional
261 -- 				p_value4		IN VARCHAR2 Optional
262 --				p_key5			IN VARCHAR2 Optional
263 --				p_value5		IN VARCHAR2 Optional
264 --				p_key6			IN VARCHAR2 Optional
265 --				p_value6		IN VARCHAR2 Optional
266 --				p_key7			IN VARCHAR2 Optional
267 --				p_value7		IN VARCHAR2 Optional
268 --				p_key8 			IN VARCHAR2 Optional
269 -- 				p_value8		IN VARCHAR2 Optional
270 --				p_key9			IN VARCHAR2 Optional
271 --				p_value9		IN VARCHAR2 Optional
272 --				p_key10			IN VARCHAR2 Optional
273 --				p_value10		IN VARCHAR2 Optional
274 
275 --
276 --
277 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
278 --				x_msg_count	OUT	NUMBER
279 --				x_msg_data	OUT	VARCHAR2(2000)
280 --				.
281 --				.
282 --	Version	: Current version	1.0
283 --		  Initial version 	1.0
284 --
285 --	Notes		: svinamda 14 SEPT 2001 Created
286 --
287 -- End of comments
288 
289 
290 
291 PROCEDURE ENQUEUE_WEB_COLLAB_ITEM
292 (
293     p_api_version IN NUMBER  ,
294     p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE ,
295     p_commit IN   VARCHAR2 Default FND_API.G_FALSE  ,
296     p_server_group_id  IN  NUMBER Default null ,
297     p_server_group_name  IN  VARCHAR2 Default null ,
298     p_app_id IN NUMBER Default -1,
299     p_meeting_URL IN  VARCHAR2 ,
300     p_with_callback IN  VARCHAR2 Default FND_API.G_TRUE ,
301     p_ih_media_item_id IN NUMBER  Default -1   ,
302     p_country_code IN NUMBER Default null ,
303     p_area_code  IN NUMBER Default null ,
304     p_phone_number IN NUMBER Default null,
305     p_key1  IN  VARCHAR2 Default null ,
306     p_value1 IN  VARCHAR2 Default null ,
307     p_key2 IN  VARCHAR2 Default null ,
308     p_value2 IN  VARCHAR2 Default null,
309     p_key3 IN  VARCHAR2 Default null ,
310     p_value3 IN  VARCHAR2 Default null,
311     p_key4 IN  VARCHAR2 Default null ,
312     p_value4 IN  VARCHAR2 Default null,
313     p_key5 IN  VARCHAR2 Default null ,
314     p_value5 IN  VARCHAR2 Default null,
315     p_key6 IN  VARCHAR2 Default null ,
316     p_value6 IN  VARCHAR2 Default null,
317     p_key7 IN  VARCHAR2 Default null ,
318     p_value7 IN  VARCHAR2 Default null,
319     p_key8 IN  VARCHAR2 Default null ,
320     p_value8 IN  VARCHAR2 Default null,
321     p_key9 IN  VARCHAR2 Default null ,
322     p_value9 IN  VARCHAR2 Default null,
323     p_key10 IN  VARCHAR2 Default null ,
324     p_value10 IN  VARCHAR2 Default null,
325     x_return_status OUT NOCOPY VARCHAR2 ,
326     x_msg_count OUT NOCOPY NUMBER ,
327     x_msg_data  OUT NOCOPY VARCHAR2
328 );
329 
330 
331 
332 
333 
334 -- Start of comments
335 --	API name 	: ABANDON_MEDIA
336 --	Type		: Public
337 --	Function	: Cancel a media item request if it has not already been processed.
338 --	Pre-reqs	: None.
339 --	Parameters	:
340 --	IN		:	p_api_version	IN NUMBER	Required
341 --				p_init_msg_list	IN VARCHAR2 	Optional
342 --					Default = FND_API.G_FALSE
343 --				p_commit	IN VARCHAR2	Optional
344 --					Default = FND_API.G_FALSE
345 --  				p_server_group_name	IN VARCHAR2 Required
346 --  				p_app_id		IN NUMBER Optional
347 --  				p_media_item_id		IN VARCHAR2 Required
348 
349 --	OUT		:	x_return_status	OUT	VARCHAR2(1)
350 --				x_msg_count	OUT	NUMBER
351 --				x_msg_data	OUT	VARCHAR2(2000)
352 --				.
353 --				.
354 --	Version	: Current version	1.0
355 --		  Initial version 	1.0
356 --
357 --	Notes		: svinamda 22 MAY 2002 Created
358 --
359 -- End of comments
360 
361 
362 PROCEDURE ABANDON_MEDIA
363 ( 	p_api_version           IN	NUMBER				,
364   	p_init_msg_list		IN	VARCHAR2 Default FND_API.G_FALSE	,
365 	p_commit	    	IN  	VARCHAR2 Default FND_API.G_FALSE	,
366 	p_server_group_name	IN 	VARCHAR2,
367 	p_app_id		IN   	NUMBER Default -1,
368     p_media_item_id IN NUMBER ,  -- Required
369 	x_return_status		OUT NOCOPY	VARCHAR2		  	,
370 	x_msg_count		OUT NOCOPY	NUMBER				,
371 	x_msg_data		OUT NOCOPY	VARCHAR2
372 );
373 
374 
375 END CCT_AQ_PUB;