[Home] [Help]
PACKAGE: APPS.AMS_CAMPAIGN_PUB_W
Source
1 package ams_campaign_pub_w AUTHID CURRENT_USER as
2 /* $Header: amswcpns.pls 115.12 2002/12/02 20:31:38 dbiswas ship $ */
3 procedure create_campaign(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_camp_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 NUMBER := 0-1962.0724
19 , p7_a8 NUMBER := 0-1962.0724
20 , p7_a9 NUMBER := 0-1962.0724
21 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22 , p7_a11 DATE := fnd_api.g_miss_date
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 NUMBER := 0-1962.0724
36 , p7_a25 NUMBER := 0-1962.0724
37 , p7_a26 NUMBER := 0-1962.0724
38 , p7_a27 NUMBER := 0-1962.0724
39 , p7_a28 NUMBER := 0-1962.0724
40 , p7_a29 NUMBER := 0-1962.0724
41 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a35 NUMBER := 0-1962.0724
47 , p7_a36 NUMBER := 0-1962.0724
48 , p7_a37 DATE := fnd_api.g_miss_date
49 , p7_a38 DATE := fnd_api.g_miss_date
50 , p7_a39 DATE := fnd_api.g_miss_date
51 , p7_a40 DATE := fnd_api.g_miss_date
52 , p7_a41 DATE := fnd_api.g_miss_date
53 , p7_a42 DATE := fnd_api.g_miss_date
54 , p7_a43 DATE := fnd_api.g_miss_date
55 , p7_a44 DATE := fnd_api.g_miss_date
56 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a48 NUMBER := 0-1962.0724
60 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a51 NUMBER := 0-1962.0724
63 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
64 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
67 , p7_a56 NUMBER := 0-1962.0724
68 , p7_a57 NUMBER := 0-1962.0724
69 , p7_a58 NUMBER := 0-1962.0724
70 , p7_a59 NUMBER := 0-1962.0724
71 , p7_a60 NUMBER := 0-1962.0724
72 , p7_a61 NUMBER := 0-1962.0724
73 , p7_a62 NUMBER := 0-1962.0724
74 , p7_a63 NUMBER := 0-1962.0724
75 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
79 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
82 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
87 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
88 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
89 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
90 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
91 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
92 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
93 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
94 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a85 NUMBER := 0-1962.0724
97 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
98 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
99 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
100 , p7_a89 NUMBER := 0-1962.0724
101 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a92 NUMBER := 0-1962.0724
104 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a94 NUMBER := 0-1962.0724
106 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
107 , p7_a96 NUMBER := 0-1962.0724
108 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
110 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
112 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
113 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
114 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
115 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
116 , p7_a105 VARCHAR2 := fnd_api.g_miss_char
117 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
118 , p7_a107 VARCHAR2 := fnd_api.g_miss_char
119 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
120 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
121 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
122 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
123 , p7_a112 VARCHAR2 := fnd_api.g_miss_char
124 );
125 procedure update_campaign(p_api_version NUMBER
126 , p_init_msg_list VARCHAR2
127 , p_commit VARCHAR2
128 , p_validation_level NUMBER
129 , x_return_status OUT NOCOPY VARCHAR2
130 , x_msg_count OUT NOCOPY NUMBER
131 , x_msg_data OUT NOCOPY VARCHAR2
132 , p7_a0 NUMBER := 0-1962.0724
133 , p7_a1 DATE := fnd_api.g_miss_date
134 , p7_a2 NUMBER := 0-1962.0724
135 , p7_a3 DATE := fnd_api.g_miss_date
136 , p7_a4 NUMBER := 0-1962.0724
137 , p7_a5 NUMBER := 0-1962.0724
138 , p7_a6 NUMBER := 0-1962.0724
139 , p7_a7 NUMBER := 0-1962.0724
140 , p7_a8 NUMBER := 0-1962.0724
141 , p7_a9 NUMBER := 0-1962.0724
142 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
143 , p7_a11 DATE := fnd_api.g_miss_date
144 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
145 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
146 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
147 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
148 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
149 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
153 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
154 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
155 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a24 NUMBER := 0-1962.0724
157 , p7_a25 NUMBER := 0-1962.0724
158 , p7_a26 NUMBER := 0-1962.0724
159 , p7_a27 NUMBER := 0-1962.0724
160 , p7_a28 NUMBER := 0-1962.0724
161 , p7_a29 NUMBER := 0-1962.0724
162 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
163 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
165 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
166 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
167 , p7_a35 NUMBER := 0-1962.0724
168 , p7_a36 NUMBER := 0-1962.0724
169 , p7_a37 DATE := fnd_api.g_miss_date
170 , p7_a38 DATE := fnd_api.g_miss_date
171 , p7_a39 DATE := fnd_api.g_miss_date
172 , p7_a40 DATE := fnd_api.g_miss_date
173 , p7_a41 DATE := fnd_api.g_miss_date
174 , p7_a42 DATE := fnd_api.g_miss_date
175 , p7_a43 DATE := fnd_api.g_miss_date
176 , p7_a44 DATE := fnd_api.g_miss_date
177 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
178 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
179 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
180 , p7_a48 NUMBER := 0-1962.0724
181 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
182 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
183 , p7_a51 NUMBER := 0-1962.0724
184 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
185 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
186 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
187 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
188 , p7_a56 NUMBER := 0-1962.0724
189 , p7_a57 NUMBER := 0-1962.0724
190 , p7_a58 NUMBER := 0-1962.0724
191 , p7_a59 NUMBER := 0-1962.0724
192 , p7_a60 NUMBER := 0-1962.0724
193 , p7_a61 NUMBER := 0-1962.0724
194 , p7_a62 NUMBER := 0-1962.0724
195 , p7_a63 NUMBER := 0-1962.0724
196 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
197 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
198 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
199 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
200 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
201 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
202 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
203 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
204 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
205 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
206 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
207 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
208 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
209 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
210 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
211 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
212 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
213 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
214 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
215 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
216 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
217 , p7_a85 NUMBER := 0-1962.0724
218 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
219 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
220 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
221 , p7_a89 NUMBER := 0-1962.0724
222 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
223 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
224 , p7_a92 NUMBER := 0-1962.0724
225 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
226 , p7_a94 NUMBER := 0-1962.0724
227 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
228 , p7_a96 NUMBER := 0-1962.0724
229 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
230 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
231 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
232 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
233 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
234 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
235 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
236 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
237 , p7_a105 VARCHAR2 := fnd_api.g_miss_char
238 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
239 , p7_a107 VARCHAR2 := fnd_api.g_miss_char
240 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
241 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
242 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
243 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
244 , p7_a112 VARCHAR2 := fnd_api.g_miss_char
245 );
246 procedure validate_campaign(p_api_version NUMBER
247 , p_init_msg_list VARCHAR2
248 , p_validation_level NUMBER
249 , x_return_status OUT NOCOPY VARCHAR2
250 , x_msg_count OUT NOCOPY NUMBER
251 , x_msg_data OUT NOCOPY VARCHAR2
252 , p6_a0 NUMBER := 0-1962.0724
253 , p6_a1 DATE := fnd_api.g_miss_date
254 , p6_a2 NUMBER := 0-1962.0724
255 , p6_a3 DATE := fnd_api.g_miss_date
256 , p6_a4 NUMBER := 0-1962.0724
257 , p6_a5 NUMBER := 0-1962.0724
258 , p6_a6 NUMBER := 0-1962.0724
259 , p6_a7 NUMBER := 0-1962.0724
260 , p6_a8 NUMBER := 0-1962.0724
261 , p6_a9 NUMBER := 0-1962.0724
262 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
263 , p6_a11 DATE := fnd_api.g_miss_date
264 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
265 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
266 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
267 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
268 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
269 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
270 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
271 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
272 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
273 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
274 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
275 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
276 , p6_a24 NUMBER := 0-1962.0724
277 , p6_a25 NUMBER := 0-1962.0724
278 , p6_a26 NUMBER := 0-1962.0724
279 , p6_a27 NUMBER := 0-1962.0724
280 , p6_a28 NUMBER := 0-1962.0724
281 , p6_a29 NUMBER := 0-1962.0724
282 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
283 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
284 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
285 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
286 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
287 , p6_a35 NUMBER := 0-1962.0724
288 , p6_a36 NUMBER := 0-1962.0724
289 , p6_a37 DATE := fnd_api.g_miss_date
290 , p6_a38 DATE := fnd_api.g_miss_date
291 , p6_a39 DATE := fnd_api.g_miss_date
292 , p6_a40 DATE := fnd_api.g_miss_date
293 , p6_a41 DATE := fnd_api.g_miss_date
294 , p6_a42 DATE := fnd_api.g_miss_date
295 , p6_a43 DATE := fnd_api.g_miss_date
296 , p6_a44 DATE := fnd_api.g_miss_date
297 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
298 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
299 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
300 , p6_a48 NUMBER := 0-1962.0724
301 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
302 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
303 , p6_a51 NUMBER := 0-1962.0724
304 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
305 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
306 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
307 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
308 , p6_a56 NUMBER := 0-1962.0724
309 , p6_a57 NUMBER := 0-1962.0724
310 , p6_a58 NUMBER := 0-1962.0724
311 , p6_a59 NUMBER := 0-1962.0724
312 , p6_a60 NUMBER := 0-1962.0724
313 , p6_a61 NUMBER := 0-1962.0724
314 , p6_a62 NUMBER := 0-1962.0724
315 , p6_a63 NUMBER := 0-1962.0724
316 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
317 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
318 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
319 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
320 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
321 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
322 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
323 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
324 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
325 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
326 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
327 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
328 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
329 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
330 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
331 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
332 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
333 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
334 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
335 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
336 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
337 , p6_a85 NUMBER := 0-1962.0724
338 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
339 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
340 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
341 , p6_a89 NUMBER := 0-1962.0724
342 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
343 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
344 , p6_a92 NUMBER := 0-1962.0724
345 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
346 , p6_a94 NUMBER := 0-1962.0724
347 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
348 , p6_a96 NUMBER := 0-1962.0724
349 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
350 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
351 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
352 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
353 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
354 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
355 , p6_a103 VARCHAR2 := fnd_api.g_miss_char
356 , p6_a104 VARCHAR2 := fnd_api.g_miss_char
357 , p6_a105 VARCHAR2 := fnd_api.g_miss_char
358 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
359 , p6_a107 VARCHAR2 := fnd_api.g_miss_char
360 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
361 , p6_a109 VARCHAR2 := fnd_api.g_miss_char
362 , p6_a110 VARCHAR2 := fnd_api.g_miss_char
363 , p6_a111 VARCHAR2 := fnd_api.g_miss_char
364 , p6_a112 VARCHAR2 := fnd_api.g_miss_char
365 );
366 end ams_campaign_pub_w;