[Home] [Help]
PACKAGE: APPS.AMS_MEDIA_PVT_W
Source
1 package ams_media_pvt_w AUTHID CURRENT_USER as
2 /* $Header: amswmeds.pls 115.13 2002/12/30 05:39:25 cgoyal ship $ */
3 procedure create_media(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status OUT NOCOPY VARCHAR2
8 , x_msg_count OUT NOCOPY NUMBER
9 , x_msg_data OUT NOCOPY VARCHAR2
10 , x_media_id OUT NOCOPY NUMBER
11 , p7_a0 NUMBER := 0-1962.0724
12 , p7_a1 DATE := fnd_api.g_miss_date
13 , p7_a2 NUMBER := 0-1962.0724
14 , p7_a3 DATE := fnd_api.g_miss_date
15 , p7_a4 NUMBER := 0-1962.0724
16 , p7_a5 NUMBER := 0-1962.0724
17 , p7_a6 NUMBER := 0-1962.0724
18 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
24 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
25 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
27 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
29 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
30 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
31 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
32 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
33 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
34 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
35 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
36 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
37 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
38 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
39 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
40 );
41 procedure update_media(p_api_version NUMBER
42 , p_init_msg_list VARCHAR2
43 , p_commit VARCHAR2
44 , p_validation_level NUMBER
45 , x_return_status OUT NOCOPY VARCHAR2
46 , x_msg_count OUT NOCOPY NUMBER
47 , x_msg_data OUT NOCOPY VARCHAR2
48 , p7_a0 NUMBER := 0-1962.0724
49 , p7_a1 DATE := fnd_api.g_miss_date
50 , p7_a2 NUMBER := 0-1962.0724
51 , p7_a3 DATE := fnd_api.g_miss_date
52 , p7_a4 NUMBER := 0-1962.0724
53 , p7_a5 NUMBER := 0-1962.0724
54 , p7_a6 NUMBER := 0-1962.0724
55 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
63 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
64 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
67 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
68 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
69 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
70 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
71 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
72 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
73 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
74 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
75 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
77 );
78 procedure validate_media(p_api_version NUMBER
79 , p_init_msg_list VARCHAR2
80 , p_commit VARCHAR2
81 , p_validation_level NUMBER
82 , x_return_status OUT NOCOPY VARCHAR2
83 , x_msg_count OUT NOCOPY NUMBER
84 , x_msg_data OUT NOCOPY VARCHAR2
85 , p7_a0 NUMBER := 0-1962.0724
86 , p7_a1 DATE := fnd_api.g_miss_date
87 , p7_a2 NUMBER := 0-1962.0724
88 , p7_a3 DATE := fnd_api.g_miss_date
89 , p7_a4 NUMBER := 0-1962.0724
90 , p7_a5 NUMBER := 0-1962.0724
91 , p7_a6 NUMBER := 0-1962.0724
92 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
93 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
97 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
98 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
99 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
100 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
101 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
104 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
106 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
107 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
108 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
110 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
112 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
113 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
114 );
115 procedure check_media_items(p_validation_mode VARCHAR2
116 , x_return_status OUT NOCOPY VARCHAR2
117 , p0_a0 NUMBER := 0-1962.0724
118 , p0_a1 DATE := fnd_api.g_miss_date
119 , p0_a2 NUMBER := 0-1962.0724
120 , p0_a3 DATE := fnd_api.g_miss_date
121 , p0_a4 NUMBER := 0-1962.0724
122 , p0_a5 NUMBER := 0-1962.0724
123 , p0_a6 NUMBER := 0-1962.0724
124 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
125 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
126 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
127 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
128 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
129 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
130 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
131 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
132 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
133 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
134 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
135 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
136 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
137 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
138 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
139 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
140 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
141 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
142 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
143 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
144 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
145 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
146 );
147 procedure check_media_record(x_return_status OUT NOCOPY VARCHAR2
148 , p0_a0 NUMBER := 0-1962.0724
149 , p0_a1 DATE := fnd_api.g_miss_date
150 , p0_a2 NUMBER := 0-1962.0724
151 , p0_a3 DATE := fnd_api.g_miss_date
152 , p0_a4 NUMBER := 0-1962.0724
153 , p0_a5 NUMBER := 0-1962.0724
154 , p0_a6 NUMBER := 0-1962.0724
155 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
156 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
157 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
158 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
159 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
160 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
161 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
162 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
163 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
164 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
165 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
166 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
167 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
168 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
169 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
170 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
171 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
172 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
173 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
174 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
175 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
176 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
177 , p1_a0 NUMBER := 0-1962.0724
178 , p1_a1 DATE := fnd_api.g_miss_date
179 , p1_a2 NUMBER := 0-1962.0724
180 , p1_a3 DATE := fnd_api.g_miss_date
181 , p1_a4 NUMBER := 0-1962.0724
182 , p1_a5 NUMBER := 0-1962.0724
183 , p1_a6 NUMBER := 0-1962.0724
184 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
185 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
186 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
187 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
188 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
189 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
190 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
191 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
192 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
193 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
194 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
195 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
196 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
197 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
198 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
199 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
200 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
201 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
202 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
203 , p1_a26 VARCHAR2 := fnd_api.g_miss_char
204 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
205 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
206 );
207 procedure init_media_rec(p0_a0 OUT NOCOPY NUMBER
208 , p0_a1 OUT NOCOPY DATE
209 , p0_a2 OUT NOCOPY NUMBER
210 , p0_a3 OUT NOCOPY DATE
211 , p0_a4 OUT NOCOPY NUMBER
212 , p0_a5 OUT NOCOPY NUMBER
213 , p0_a6 OUT NOCOPY NUMBER
214 , p0_a7 OUT NOCOPY VARCHAR2
215 , p0_a8 OUT NOCOPY VARCHAR2
216 , p0_a9 OUT NOCOPY VARCHAR2
217 , p0_a10 OUT NOCOPY VARCHAR2
218 , p0_a11 OUT NOCOPY VARCHAR2
219 , p0_a12 OUT NOCOPY VARCHAR2
220 , p0_a13 OUT NOCOPY VARCHAR2
221 , p0_a14 OUT NOCOPY VARCHAR2
222 , p0_a15 OUT NOCOPY VARCHAR2
223 , p0_a16 OUT NOCOPY VARCHAR2
224 , p0_a17 OUT NOCOPY VARCHAR2
225 , p0_a18 OUT NOCOPY VARCHAR2
226 , p0_a19 OUT NOCOPY VARCHAR2
227 , p0_a20 OUT NOCOPY VARCHAR2
228 , p0_a21 OUT NOCOPY VARCHAR2
229 , p0_a22 OUT NOCOPY VARCHAR2
230 , p0_a23 OUT NOCOPY VARCHAR2
231 , p0_a24 OUT NOCOPY VARCHAR2
232 , p0_a25 OUT NOCOPY VARCHAR2
233 , p0_a26 OUT NOCOPY VARCHAR2
234 , p0_a27 OUT NOCOPY VARCHAR2
235 , p0_a28 OUT NOCOPY VARCHAR2
236 );
237 procedure complete_media_rec(p1_a0 OUT NOCOPY NUMBER
238 , p1_a1 OUT NOCOPY DATE
239 , p1_a2 OUT NOCOPY NUMBER
240 , p1_a3 OUT NOCOPY DATE
241 , p1_a4 OUT NOCOPY NUMBER
242 , p1_a5 OUT NOCOPY NUMBER
243 , p1_a6 OUT NOCOPY NUMBER
244 , p1_a7 OUT NOCOPY VARCHAR2
245 , p1_a8 OUT NOCOPY VARCHAR2
246 , p1_a9 OUT NOCOPY VARCHAR2
247 , p1_a10 OUT NOCOPY VARCHAR2
248 , p1_a11 OUT NOCOPY VARCHAR2
249 , p1_a12 OUT NOCOPY VARCHAR2
250 , p1_a13 OUT NOCOPY VARCHAR2
251 , p1_a14 OUT NOCOPY VARCHAR2
252 , p1_a15 OUT NOCOPY VARCHAR2
253 , p1_a16 OUT NOCOPY VARCHAR2
254 , p1_a17 OUT NOCOPY VARCHAR2
255 , p1_a18 OUT NOCOPY VARCHAR2
256 , p1_a19 OUT NOCOPY VARCHAR2
257 , p1_a20 OUT NOCOPY VARCHAR2
258 , p1_a21 OUT NOCOPY VARCHAR2
259 , p1_a22 OUT NOCOPY VARCHAR2
260 , p1_a23 OUT NOCOPY VARCHAR2
261 , p1_a24 OUT NOCOPY VARCHAR2
262 , p1_a25 OUT NOCOPY VARCHAR2
263 , p1_a26 OUT NOCOPY VARCHAR2
264 , p1_a27 OUT NOCOPY VARCHAR2
265 , p1_a28 OUT NOCOPY VARCHAR2
266 , p0_a0 NUMBER := 0-1962.0724
267 , p0_a1 DATE := fnd_api.g_miss_date
268 , p0_a2 NUMBER := 0-1962.0724
269 , p0_a3 DATE := fnd_api.g_miss_date
270 , p0_a4 NUMBER := 0-1962.0724
271 , p0_a5 NUMBER := 0-1962.0724
272 , p0_a6 NUMBER := 0-1962.0724
273 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
274 , p0_a8 VARCHAR2 := fnd_api.g_miss_char
275 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
276 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
277 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
278 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
279 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
280 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
281 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
282 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
283 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
284 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
285 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
286 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
287 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
288 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
289 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
290 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
291 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
292 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
293 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
294 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
295 );
296 procedure create_mediachannel(p_api_version NUMBER
297 , p_init_msg_list VARCHAR2
298 , p_commit VARCHAR2
299 , p_validation_level NUMBER
300 , x_return_status OUT NOCOPY VARCHAR2
301 , x_msg_count OUT NOCOPY NUMBER
302 , x_msg_data OUT NOCOPY VARCHAR2
303 , x_mediachl_id OUT NOCOPY NUMBER
304 , p7_a0 NUMBER := 0-1962.0724
305 , p7_a1 DATE := fnd_api.g_miss_date
306 , p7_a2 NUMBER := 0-1962.0724
307 , p7_a3 DATE := fnd_api.g_miss_date
308 , p7_a4 NUMBER := 0-1962.0724
309 , p7_a5 NUMBER := 0-1962.0724
310 , p7_a6 NUMBER := 0-1962.0724
311 , p7_a7 NUMBER := 0-1962.0724
312 , p7_a8 NUMBER := 0-1962.0724
316 procedure update_mediachannel(p_api_version NUMBER
313 , p7_a9 DATE := fnd_api.g_miss_date
314 , p7_a10 DATE := fnd_api.g_miss_date
315 );
317 , p_init_msg_list VARCHAR2
318 , p_commit VARCHAR2
319 , p_validation_level NUMBER
320 , x_return_status OUT NOCOPY VARCHAR2
321 , x_msg_count OUT NOCOPY NUMBER
322 , x_msg_data OUT NOCOPY VARCHAR2
323 , p7_a0 NUMBER := 0-1962.0724
324 , p7_a1 DATE := fnd_api.g_miss_date
325 , p7_a2 NUMBER := 0-1962.0724
326 , p7_a3 DATE := fnd_api.g_miss_date
327 , p7_a4 NUMBER := 0-1962.0724
328 , p7_a5 NUMBER := 0-1962.0724
329 , p7_a6 NUMBER := 0-1962.0724
330 , p7_a7 NUMBER := 0-1962.0724
331 , p7_a8 NUMBER := 0-1962.0724
332 , p7_a9 DATE := fnd_api.g_miss_date
333 , p7_a10 DATE := fnd_api.g_miss_date
334 );
335 procedure validate_mediachannel(p_api_version NUMBER
336 , p_init_msg_list VARCHAR2
337 , p_commit VARCHAR2
338 , p_validation_level NUMBER
339 , x_return_status OUT NOCOPY VARCHAR2
340 , x_msg_count OUT NOCOPY NUMBER
341 , x_msg_data OUT NOCOPY VARCHAR2
342 , p7_a0 NUMBER := 0-1962.0724
343 , p7_a1 DATE := fnd_api.g_miss_date
344 , p7_a2 NUMBER := 0-1962.0724
345 , p7_a3 DATE := fnd_api.g_miss_date
346 , p7_a4 NUMBER := 0-1962.0724
347 , p7_a5 NUMBER := 0-1962.0724
348 , p7_a6 NUMBER := 0-1962.0724
349 , p7_a7 NUMBER := 0-1962.0724
350 , p7_a8 NUMBER := 0-1962.0724
351 , p7_a9 DATE := fnd_api.g_miss_date
352 , p7_a10 DATE := fnd_api.g_miss_date
353 );
354 procedure check_mediachannel_items(p_validation_mode VARCHAR2
355 , x_return_status OUT NOCOPY VARCHAR2
356 , p0_a0 NUMBER := 0-1962.0724
357 , p0_a1 DATE := fnd_api.g_miss_date
358 , p0_a2 NUMBER := 0-1962.0724
359 , p0_a3 DATE := fnd_api.g_miss_date
360 , p0_a4 NUMBER := 0-1962.0724
361 , p0_a5 NUMBER := 0-1962.0724
362 , p0_a6 NUMBER := 0-1962.0724
363 , p0_a7 NUMBER := 0-1962.0724
364 , p0_a8 NUMBER := 0-1962.0724
365 , p0_a9 DATE := fnd_api.g_miss_date
366 , p0_a10 DATE := fnd_api.g_miss_date
367 );
368 procedure check_mediachannel_record(x_return_status OUT NOCOPY VARCHAR2
369 , p0_a0 NUMBER := 0-1962.0724
370 , p0_a1 DATE := fnd_api.g_miss_date
371 , p0_a2 NUMBER := 0-1962.0724
372 , p0_a3 DATE := fnd_api.g_miss_date
373 , p0_a4 NUMBER := 0-1962.0724
374 , p0_a5 NUMBER := 0-1962.0724
375 , p0_a6 NUMBER := 0-1962.0724
376 , p0_a7 NUMBER := 0-1962.0724
377 , p0_a8 NUMBER := 0-1962.0724
378 , p0_a9 DATE := fnd_api.g_miss_date
379 , p0_a10 DATE := fnd_api.g_miss_date
380 , p1_a0 NUMBER := 0-1962.0724
381 , p1_a1 DATE := fnd_api.g_miss_date
382 , p1_a2 NUMBER := 0-1962.0724
383 , p1_a3 DATE := fnd_api.g_miss_date
384 , p1_a4 NUMBER := 0-1962.0724
385 , p1_a5 NUMBER := 0-1962.0724
386 , p1_a6 NUMBER := 0-1962.0724
387 , p1_a7 NUMBER := 0-1962.0724
388 , p1_a8 NUMBER := 0-1962.0724
389 , p1_a9 DATE := fnd_api.g_miss_date
390 , p1_a10 DATE := fnd_api.g_miss_date
391 );
392 procedure init_mediachannel_rec(p0_a0 OUT NOCOPY NUMBER
393 , p0_a1 OUT NOCOPY DATE
394 , p0_a2 OUT NOCOPY NUMBER
395 , p0_a3 OUT NOCOPY DATE
396 , p0_a4 OUT NOCOPY NUMBER
397 , p0_a5 OUT NOCOPY NUMBER
398 , p0_a6 OUT NOCOPY NUMBER
399 , p0_a7 OUT NOCOPY NUMBER
400 , p0_a8 OUT NOCOPY NUMBER
401 , p0_a9 OUT NOCOPY DATE
402 , p0_a10 OUT NOCOPY DATE
403 );
404 procedure complete_mediachannel_rec(p1_a0 OUT NOCOPY NUMBER
405 , p1_a1 OUT NOCOPY DATE
406 , p1_a2 OUT NOCOPY NUMBER
407 , p1_a3 OUT NOCOPY DATE
408 , p1_a4 OUT NOCOPY NUMBER
409 , p1_a5 OUT NOCOPY NUMBER
410 , p1_a6 OUT NOCOPY NUMBER
411 , p1_a7 OUT NOCOPY NUMBER
412 , p1_a8 OUT NOCOPY NUMBER
413 , p1_a9 OUT NOCOPY DATE
414 , p1_a10 OUT NOCOPY DATE
415 , p0_a0 NUMBER := 0-1962.0724
416 , p0_a1 DATE := fnd_api.g_miss_date
417 , p0_a2 NUMBER := 0-1962.0724
418 , p0_a3 DATE := fnd_api.g_miss_date
419 , p0_a4 NUMBER := 0-1962.0724
420 , p0_a5 NUMBER := 0-1962.0724
421 , p0_a6 NUMBER := 0-1962.0724
422 , p0_a7 NUMBER := 0-1962.0724
423 , p0_a8 NUMBER := 0-1962.0724
424 , p0_a9 DATE := fnd_api.g_miss_date
425 , p0_a10 DATE := fnd_api.g_miss_date
426 );
427 end ams_media_pvt_w;