[Home] [Help]
PACKAGE BODY: APPS.AMS_CAMPAIGN_PUB_W
Source
1 package body ams_campaign_pub_w as
2 /* $Header: amswcpnb.pls 115.12 2002/12/02 20:31:34 dbiswas ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_campaign(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_count OUT NOCOPY NUMBER
28 , x_msg_data OUT NOCOPY VARCHAR2
29 , x_camp_id OUT NOCOPY NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 DATE := fnd_api.g_miss_date
32 , p7_a2 NUMBER := 0-1962.0724
33 , p7_a3 DATE := fnd_api.g_miss_date
34 , p7_a4 NUMBER := 0-1962.0724
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 NUMBER := 0-1962.0724
38 , p7_a8 NUMBER := 0-1962.0724
39 , p7_a9 NUMBER := 0-1962.0724
40 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a11 DATE := fnd_api.g_miss_date
42 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
47 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
50 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 NUMBER := 0-1962.0724
55 , p7_a25 NUMBER := 0-1962.0724
56 , p7_a26 NUMBER := 0-1962.0724
57 , p7_a27 NUMBER := 0-1962.0724
58 , p7_a28 NUMBER := 0-1962.0724
59 , p7_a29 NUMBER := 0-1962.0724
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
63 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
64 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a35 NUMBER := 0-1962.0724
66 , p7_a36 NUMBER := 0-1962.0724
67 , p7_a37 DATE := fnd_api.g_miss_date
68 , p7_a38 DATE := fnd_api.g_miss_date
69 , p7_a39 DATE := fnd_api.g_miss_date
70 , p7_a40 DATE := fnd_api.g_miss_date
71 , p7_a41 DATE := fnd_api.g_miss_date
72 , p7_a42 DATE := fnd_api.g_miss_date
73 , p7_a43 DATE := fnd_api.g_miss_date
74 , p7_a44 DATE := fnd_api.g_miss_date
75 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a48 NUMBER := 0-1962.0724
79 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a51 NUMBER := 0-1962.0724
82 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86 , p7_a56 NUMBER := 0-1962.0724
87 , p7_a57 NUMBER := 0-1962.0724
88 , p7_a58 NUMBER := 0-1962.0724
89 , p7_a59 NUMBER := 0-1962.0724
90 , p7_a60 NUMBER := 0-1962.0724
91 , p7_a61 NUMBER := 0-1962.0724
92 , p7_a62 NUMBER := 0-1962.0724
93 , p7_a63 NUMBER := 0-1962.0724
94 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
106 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
107 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
110 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
112 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
113 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
114 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
115 , p7_a85 NUMBER := 0-1962.0724
116 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
117 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
118 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
119 , p7_a89 NUMBER := 0-1962.0724
120 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
121 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
122 , p7_a92 NUMBER := 0-1962.0724
123 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
124 , p7_a94 NUMBER := 0-1962.0724
125 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
126 , p7_a96 NUMBER := 0-1962.0724
127 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
128 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
129 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
130 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
131 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
132 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
133 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
134 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
135 , p7_a105 VARCHAR2 := fnd_api.g_miss_char
136 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
137 , p7_a107 VARCHAR2 := fnd_api.g_miss_char
138 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
139 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
140 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
141 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
142 , p7_a112 VARCHAR2 := fnd_api.g_miss_char
143 )
144 as
145 ddp_camp_rec ams_campaign_pvt.camp_rec_type;
146 ddindx binary_integer; indx binary_integer;
147 begin
148
149 -- copy data to the local IN or IN-OUT args, if any
150
151
152
153
154
155
156
157 ddp_camp_rec.campaign_id := rosetta_g_miss_num_map(p7_a0);
158 ddp_camp_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
159 ddp_camp_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
160 ddp_camp_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
161 ddp_camp_rec.created_by := rosetta_g_miss_num_map(p7_a4);
162 ddp_camp_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
163 ddp_camp_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
164 ddp_camp_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a7);
165 ddp_camp_rec.owner_user_id := rosetta_g_miss_num_map(p7_a8);
166 ddp_camp_rec.user_status_id := rosetta_g_miss_num_map(p7_a9);
167 ddp_camp_rec.status_code := p7_a10;
168 ddp_camp_rec.status_date := rosetta_g_miss_date_in_map(p7_a11);
169 ddp_camp_rec.active_flag := p7_a12;
170 ddp_camp_rec.private_flag := p7_a13;
171 ddp_camp_rec.partner_flag := p7_a14;
172 ddp_camp_rec.template_flag := p7_a15;
173 ddp_camp_rec.cascade_source_code_flag := p7_a16;
174 ddp_camp_rec.inherit_attributes_flag := p7_a17;
175 ddp_camp_rec.source_code := p7_a18;
176 ddp_camp_rec.rollup_type := p7_a19;
177 ddp_camp_rec.campaign_type := p7_a20;
178 ddp_camp_rec.media_type_code := p7_a21;
179 ddp_camp_rec.priority := p7_a22;
180 ddp_camp_rec.fund_source_type := p7_a23;
181 ddp_camp_rec.fund_source_id := rosetta_g_miss_num_map(p7_a24);
182 ddp_camp_rec.parent_campaign_id := rosetta_g_miss_num_map(p7_a25);
183 ddp_camp_rec.application_id := rosetta_g_miss_num_map(p7_a26);
184 ddp_camp_rec.qp_list_header_id := rosetta_g_miss_num_map(p7_a27);
185 ddp_camp_rec.media_id := rosetta_g_miss_num_map(p7_a28);
186 ddp_camp_rec.channel_id := rosetta_g_miss_num_map(p7_a29);
187 ddp_camp_rec.event_type := p7_a30;
188 ddp_camp_rec.arc_channel_from := p7_a31;
189 ddp_camp_rec.dscript_name := p7_a32;
190 ddp_camp_rec.transaction_currency_code := p7_a33;
191 ddp_camp_rec.functional_currency_code := p7_a34;
192 ddp_camp_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a35);
193 ddp_camp_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a36);
194 ddp_camp_rec.forecasted_plan_start_date := rosetta_g_miss_date_in_map(p7_a37);
195 ddp_camp_rec.forecasted_plan_end_date := rosetta_g_miss_date_in_map(p7_a38);
196 ddp_camp_rec.forecasted_exec_start_date := rosetta_g_miss_date_in_map(p7_a39);
197 ddp_camp_rec.forecasted_exec_end_date := rosetta_g_miss_date_in_map(p7_a40);
198 ddp_camp_rec.actual_plan_start_date := rosetta_g_miss_date_in_map(p7_a41);
199 ddp_camp_rec.actual_plan_end_date := rosetta_g_miss_date_in_map(p7_a42);
200 ddp_camp_rec.actual_exec_start_date := rosetta_g_miss_date_in_map(p7_a43);
201 ddp_camp_rec.actual_exec_end_date := rosetta_g_miss_date_in_map(p7_a44);
202 ddp_camp_rec.inbound_url := p7_a45;
203 ddp_camp_rec.inbound_email_id := p7_a46;
204 ddp_camp_rec.inbound_phone_no := p7_a47;
205 ddp_camp_rec.duration := rosetta_g_miss_num_map(p7_a48);
206 ddp_camp_rec.duration_uom_code := p7_a49;
207 ddp_camp_rec.ff_priority := p7_a50;
208 ddp_camp_rec.ff_override_cover_letter := rosetta_g_miss_num_map(p7_a51);
209 ddp_camp_rec.ff_shipping_method := p7_a52;
210 ddp_camp_rec.ff_carrier := p7_a53;
211 ddp_camp_rec.content_source := p7_a54;
212 ddp_camp_rec.cc_call_strategy := p7_a55;
213 ddp_camp_rec.cc_manager_user_id := rosetta_g_miss_num_map(p7_a56);
214 ddp_camp_rec.forecasted_revenue := rosetta_g_miss_num_map(p7_a57);
215 ddp_camp_rec.actual_revenue := rosetta_g_miss_num_map(p7_a58);
216 ddp_camp_rec.forecasted_cost := rosetta_g_miss_num_map(p7_a59);
217 ddp_camp_rec.actual_cost := rosetta_g_miss_num_map(p7_a60);
218 ddp_camp_rec.forecasted_response := rosetta_g_miss_num_map(p7_a61);
219 ddp_camp_rec.actual_response := rosetta_g_miss_num_map(p7_a62);
220 ddp_camp_rec.target_response := rosetta_g_miss_num_map(p7_a63);
221 ddp_camp_rec.country_code := p7_a64;
222 ddp_camp_rec.language_code := p7_a65;
223 ddp_camp_rec.attribute_category := p7_a66;
224 ddp_camp_rec.attribute1 := p7_a67;
225 ddp_camp_rec.attribute2 := p7_a68;
226 ddp_camp_rec.attribute3 := p7_a69;
227 ddp_camp_rec.attribute4 := p7_a70;
228 ddp_camp_rec.attribute5 := p7_a71;
229 ddp_camp_rec.attribute6 := p7_a72;
230 ddp_camp_rec.attribute7 := p7_a73;
231 ddp_camp_rec.attribute8 := p7_a74;
232 ddp_camp_rec.attribute9 := p7_a75;
233 ddp_camp_rec.attribute10 := p7_a76;
234 ddp_camp_rec.attribute11 := p7_a77;
235 ddp_camp_rec.attribute12 := p7_a78;
236 ddp_camp_rec.attribute13 := p7_a79;
237 ddp_camp_rec.attribute14 := p7_a80;
238 ddp_camp_rec.attribute15 := p7_a81;
239 ddp_camp_rec.campaign_name := p7_a82;
240 ddp_camp_rec.campaign_theme := p7_a83;
241 ddp_camp_rec.description := p7_a84;
242 ddp_camp_rec.version_no := rosetta_g_miss_num_map(p7_a85);
243 ddp_camp_rec.campaign_calendar := p7_a86;
244 ddp_camp_rec.start_period_name := p7_a87;
245 ddp_camp_rec.end_period_name := p7_a88;
246 ddp_camp_rec.city_id := rosetta_g_miss_num_map(p7_a89);
247 ddp_camp_rec.global_flag := p7_a90;
248 ddp_camp_rec.show_campaign_flag := p7_a91;
249 ddp_camp_rec.business_unit_id := rosetta_g_miss_num_map(p7_a92);
250 ddp_camp_rec.accounts_closed_flag := p7_a93;
251 ddp_camp_rec.task_id := rosetta_g_miss_num_map(p7_a94);
252 ddp_camp_rec.related_event_from := p7_a95;
253 ddp_camp_rec.related_event_id := rosetta_g_miss_num_map(p7_a96);
254 ddp_camp_rec.program_attribute_category := p7_a97;
255 ddp_camp_rec.program_attribute1 := p7_a98;
256 ddp_camp_rec.program_attribute2 := p7_a99;
257 ddp_camp_rec.program_attribute3 := p7_a100;
258 ddp_camp_rec.program_attribute4 := p7_a101;
259 ddp_camp_rec.program_attribute5 := p7_a102;
260 ddp_camp_rec.program_attribute6 := p7_a103;
261 ddp_camp_rec.program_attribute7 := p7_a104;
262 ddp_camp_rec.program_attribute8 := p7_a105;
263 ddp_camp_rec.program_attribute9 := p7_a106;
264 ddp_camp_rec.program_attribute10 := p7_a107;
265 ddp_camp_rec.program_attribute11 := p7_a108;
266 ddp_camp_rec.program_attribute12 := p7_a109;
267 ddp_camp_rec.program_attribute13 := p7_a110;
268 ddp_camp_rec.program_attribute14 := p7_a111;
269 ddp_camp_rec.program_attribute15 := p7_a112;
270
271
272 -- here's the delegated call to the old PL/SQL routine
273 ams_campaign_pub.create_campaign(p_api_version,
274 p_init_msg_list,
275 p_commit,
276 p_validation_level,
277 x_return_status,
278 x_msg_count,
279 x_msg_data,
280 ddp_camp_rec,
281 x_camp_id);
282
283 -- copy data back from the local OUT or IN-OUT args, if any
284
285
286
287
288
289
290
291
292 end;
293
294 procedure update_campaign(p_api_version NUMBER
295 , p_init_msg_list VARCHAR2
296 , p_commit VARCHAR2
297 , p_validation_level NUMBER
298 , x_return_status OUT NOCOPY VARCHAR2
299 , x_msg_count OUT NOCOPY NUMBER
300 , x_msg_data OUT NOCOPY VARCHAR2
301 , p7_a0 NUMBER := 0-1962.0724
302 , p7_a1 DATE := fnd_api.g_miss_date
303 , p7_a2 NUMBER := 0-1962.0724
304 , p7_a3 DATE := fnd_api.g_miss_date
305 , p7_a4 NUMBER := 0-1962.0724
306 , p7_a5 NUMBER := 0-1962.0724
307 , p7_a6 NUMBER := 0-1962.0724
308 , p7_a7 NUMBER := 0-1962.0724
309 , p7_a8 NUMBER := 0-1962.0724
310 , p7_a9 NUMBER := 0-1962.0724
311 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
312 , p7_a11 DATE := fnd_api.g_miss_date
313 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
314 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
315 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
316 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
317 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
318 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
319 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
320 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
321 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
322 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
323 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
324 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
325 , p7_a24 NUMBER := 0-1962.0724
326 , p7_a25 NUMBER := 0-1962.0724
327 , p7_a26 NUMBER := 0-1962.0724
328 , p7_a27 NUMBER := 0-1962.0724
329 , p7_a28 NUMBER := 0-1962.0724
330 , p7_a29 NUMBER := 0-1962.0724
331 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
332 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
333 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
334 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
335 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
336 , p7_a35 NUMBER := 0-1962.0724
337 , p7_a36 NUMBER := 0-1962.0724
338 , p7_a37 DATE := fnd_api.g_miss_date
339 , p7_a38 DATE := fnd_api.g_miss_date
340 , p7_a39 DATE := fnd_api.g_miss_date
341 , p7_a40 DATE := fnd_api.g_miss_date
342 , p7_a41 DATE := fnd_api.g_miss_date
343 , p7_a42 DATE := fnd_api.g_miss_date
344 , p7_a43 DATE := fnd_api.g_miss_date
345 , p7_a44 DATE := fnd_api.g_miss_date
346 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
347 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
348 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
349 , p7_a48 NUMBER := 0-1962.0724
350 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
351 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
352 , p7_a51 NUMBER := 0-1962.0724
353 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
354 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
356 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
357 , p7_a56 NUMBER := 0-1962.0724
358 , p7_a57 NUMBER := 0-1962.0724
359 , p7_a58 NUMBER := 0-1962.0724
360 , p7_a59 NUMBER := 0-1962.0724
361 , p7_a60 NUMBER := 0-1962.0724
362 , p7_a61 NUMBER := 0-1962.0724
363 , p7_a62 NUMBER := 0-1962.0724
364 , p7_a63 NUMBER := 0-1962.0724
365 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
366 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
367 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
368 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
369 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
370 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
371 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
372 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
373 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
374 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
375 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
376 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
377 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
378 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
379 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
380 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
381 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
382 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
383 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
384 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
385 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
386 , p7_a85 NUMBER := 0-1962.0724
387 , p7_a86 VARCHAR2 := fnd_api.g_miss_char
388 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
389 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
390 , p7_a89 NUMBER := 0-1962.0724
391 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
392 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
393 , p7_a92 NUMBER := 0-1962.0724
394 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
395 , p7_a94 NUMBER := 0-1962.0724
396 , p7_a95 VARCHAR2 := fnd_api.g_miss_char
397 , p7_a96 NUMBER := 0-1962.0724
398 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
399 , p7_a98 VARCHAR2 := fnd_api.g_miss_char
400 , p7_a99 VARCHAR2 := fnd_api.g_miss_char
401 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
402 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
403 , p7_a102 VARCHAR2 := fnd_api.g_miss_char
404 , p7_a103 VARCHAR2 := fnd_api.g_miss_char
405 , p7_a104 VARCHAR2 := fnd_api.g_miss_char
406 , p7_a105 VARCHAR2 := fnd_api.g_miss_char
407 , p7_a106 VARCHAR2 := fnd_api.g_miss_char
408 , p7_a107 VARCHAR2 := fnd_api.g_miss_char
409 , p7_a108 VARCHAR2 := fnd_api.g_miss_char
410 , p7_a109 VARCHAR2 := fnd_api.g_miss_char
411 , p7_a110 VARCHAR2 := fnd_api.g_miss_char
412 , p7_a111 VARCHAR2 := fnd_api.g_miss_char
413 , p7_a112 VARCHAR2 := fnd_api.g_miss_char
414 )
415 as
416 ddp_camp_rec ams_campaign_pvt.camp_rec_type;
417 ddindx binary_integer; indx binary_integer;
418 begin
419
420 -- copy data to the local IN or IN-OUT args, if any
421
422
423
424
425
426
427
428 ddp_camp_rec.campaign_id := rosetta_g_miss_num_map(p7_a0);
429 ddp_camp_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
430 ddp_camp_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
431 ddp_camp_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
432 ddp_camp_rec.created_by := rosetta_g_miss_num_map(p7_a4);
433 ddp_camp_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
434 ddp_camp_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
435 ddp_camp_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a7);
436 ddp_camp_rec.owner_user_id := rosetta_g_miss_num_map(p7_a8);
437 ddp_camp_rec.user_status_id := rosetta_g_miss_num_map(p7_a9);
438 ddp_camp_rec.status_code := p7_a10;
439 ddp_camp_rec.status_date := rosetta_g_miss_date_in_map(p7_a11);
440 ddp_camp_rec.active_flag := p7_a12;
441 ddp_camp_rec.private_flag := p7_a13;
442 ddp_camp_rec.partner_flag := p7_a14;
443 ddp_camp_rec.template_flag := p7_a15;
444 ddp_camp_rec.cascade_source_code_flag := p7_a16;
445 ddp_camp_rec.inherit_attributes_flag := p7_a17;
446 ddp_camp_rec.source_code := p7_a18;
447 ddp_camp_rec.rollup_type := p7_a19;
448 ddp_camp_rec.campaign_type := p7_a20;
449 ddp_camp_rec.media_type_code := p7_a21;
450 ddp_camp_rec.priority := p7_a22;
451 ddp_camp_rec.fund_source_type := p7_a23;
452 ddp_camp_rec.fund_source_id := rosetta_g_miss_num_map(p7_a24);
453 ddp_camp_rec.parent_campaign_id := rosetta_g_miss_num_map(p7_a25);
454 ddp_camp_rec.application_id := rosetta_g_miss_num_map(p7_a26);
455 ddp_camp_rec.qp_list_header_id := rosetta_g_miss_num_map(p7_a27);
456 ddp_camp_rec.media_id := rosetta_g_miss_num_map(p7_a28);
457 ddp_camp_rec.channel_id := rosetta_g_miss_num_map(p7_a29);
458 ddp_camp_rec.event_type := p7_a30;
459 ddp_camp_rec.arc_channel_from := p7_a31;
460 ddp_camp_rec.dscript_name := p7_a32;
461 ddp_camp_rec.transaction_currency_code := p7_a33;
462 ddp_camp_rec.functional_currency_code := p7_a34;
463 ddp_camp_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a35);
464 ddp_camp_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a36);
465 ddp_camp_rec.forecasted_plan_start_date := rosetta_g_miss_date_in_map(p7_a37);
466 ddp_camp_rec.forecasted_plan_end_date := rosetta_g_miss_date_in_map(p7_a38);
467 ddp_camp_rec.forecasted_exec_start_date := rosetta_g_miss_date_in_map(p7_a39);
468 ddp_camp_rec.forecasted_exec_end_date := rosetta_g_miss_date_in_map(p7_a40);
469 ddp_camp_rec.actual_plan_start_date := rosetta_g_miss_date_in_map(p7_a41);
470 ddp_camp_rec.actual_plan_end_date := rosetta_g_miss_date_in_map(p7_a42);
471 ddp_camp_rec.actual_exec_start_date := rosetta_g_miss_date_in_map(p7_a43);
472 ddp_camp_rec.actual_exec_end_date := rosetta_g_miss_date_in_map(p7_a44);
473 ddp_camp_rec.inbound_url := p7_a45;
474 ddp_camp_rec.inbound_email_id := p7_a46;
475 ddp_camp_rec.inbound_phone_no := p7_a47;
476 ddp_camp_rec.duration := rosetta_g_miss_num_map(p7_a48);
477 ddp_camp_rec.duration_uom_code := p7_a49;
478 ddp_camp_rec.ff_priority := p7_a50;
479 ddp_camp_rec.ff_override_cover_letter := rosetta_g_miss_num_map(p7_a51);
480 ddp_camp_rec.ff_shipping_method := p7_a52;
481 ddp_camp_rec.ff_carrier := p7_a53;
482 ddp_camp_rec.content_source := p7_a54;
483 ddp_camp_rec.cc_call_strategy := p7_a55;
484 ddp_camp_rec.cc_manager_user_id := rosetta_g_miss_num_map(p7_a56);
485 ddp_camp_rec.forecasted_revenue := rosetta_g_miss_num_map(p7_a57);
486 ddp_camp_rec.actual_revenue := rosetta_g_miss_num_map(p7_a58);
487 ddp_camp_rec.forecasted_cost := rosetta_g_miss_num_map(p7_a59);
488 ddp_camp_rec.actual_cost := rosetta_g_miss_num_map(p7_a60);
489 ddp_camp_rec.forecasted_response := rosetta_g_miss_num_map(p7_a61);
490 ddp_camp_rec.actual_response := rosetta_g_miss_num_map(p7_a62);
491 ddp_camp_rec.target_response := rosetta_g_miss_num_map(p7_a63);
492 ddp_camp_rec.country_code := p7_a64;
493 ddp_camp_rec.language_code := p7_a65;
494 ddp_camp_rec.attribute_category := p7_a66;
495 ddp_camp_rec.attribute1 := p7_a67;
496 ddp_camp_rec.attribute2 := p7_a68;
497 ddp_camp_rec.attribute3 := p7_a69;
498 ddp_camp_rec.attribute4 := p7_a70;
499 ddp_camp_rec.attribute5 := p7_a71;
500 ddp_camp_rec.attribute6 := p7_a72;
501 ddp_camp_rec.attribute7 := p7_a73;
502 ddp_camp_rec.attribute8 := p7_a74;
503 ddp_camp_rec.attribute9 := p7_a75;
504 ddp_camp_rec.attribute10 := p7_a76;
505 ddp_camp_rec.attribute11 := p7_a77;
506 ddp_camp_rec.attribute12 := p7_a78;
507 ddp_camp_rec.attribute13 := p7_a79;
508 ddp_camp_rec.attribute14 := p7_a80;
509 ddp_camp_rec.attribute15 := p7_a81;
510 ddp_camp_rec.campaign_name := p7_a82;
511 ddp_camp_rec.campaign_theme := p7_a83;
512 ddp_camp_rec.description := p7_a84;
513 ddp_camp_rec.version_no := rosetta_g_miss_num_map(p7_a85);
514 ddp_camp_rec.campaign_calendar := p7_a86;
515 ddp_camp_rec.start_period_name := p7_a87;
516 ddp_camp_rec.end_period_name := p7_a88;
517 ddp_camp_rec.city_id := rosetta_g_miss_num_map(p7_a89);
518 ddp_camp_rec.global_flag := p7_a90;
519 ddp_camp_rec.show_campaign_flag := p7_a91;
520 ddp_camp_rec.business_unit_id := rosetta_g_miss_num_map(p7_a92);
521 ddp_camp_rec.accounts_closed_flag := p7_a93;
522 ddp_camp_rec.task_id := rosetta_g_miss_num_map(p7_a94);
523 ddp_camp_rec.related_event_from := p7_a95;
524 ddp_camp_rec.related_event_id := rosetta_g_miss_num_map(p7_a96);
525 ddp_camp_rec.program_attribute_category := p7_a97;
526 ddp_camp_rec.program_attribute1 := p7_a98;
527 ddp_camp_rec.program_attribute2 := p7_a99;
528 ddp_camp_rec.program_attribute3 := p7_a100;
529 ddp_camp_rec.program_attribute4 := p7_a101;
530 ddp_camp_rec.program_attribute5 := p7_a102;
531 ddp_camp_rec.program_attribute6 := p7_a103;
532 ddp_camp_rec.program_attribute7 := p7_a104;
533 ddp_camp_rec.program_attribute8 := p7_a105;
534 ddp_camp_rec.program_attribute9 := p7_a106;
535 ddp_camp_rec.program_attribute10 := p7_a107;
536 ddp_camp_rec.program_attribute11 := p7_a108;
537 ddp_camp_rec.program_attribute12 := p7_a109;
538 ddp_camp_rec.program_attribute13 := p7_a110;
539 ddp_camp_rec.program_attribute14 := p7_a111;
540 ddp_camp_rec.program_attribute15 := p7_a112;
541
542 -- here's the delegated call to the old PL/SQL routine
543 ams_campaign_pub.update_campaign(p_api_version,
544 p_init_msg_list,
545 p_commit,
546 p_validation_level,
547 x_return_status,
548 x_msg_count,
549 x_msg_data,
550 ddp_camp_rec);
551
552 -- copy data back from the local OUT or IN-OUT args, if any
553
554
555
556
557
558
559
560 end;
561
562 procedure validate_campaign(p_api_version NUMBER
563 , p_init_msg_list VARCHAR2
564 , p_validation_level NUMBER
565 , x_return_status OUT NOCOPY VARCHAR2
566 , x_msg_count OUT NOCOPY NUMBER
567 , x_msg_data OUT NOCOPY VARCHAR2
568 , p6_a0 NUMBER := 0-1962.0724
569 , p6_a1 DATE := fnd_api.g_miss_date
570 , p6_a2 NUMBER := 0-1962.0724
571 , p6_a3 DATE := fnd_api.g_miss_date
572 , p6_a4 NUMBER := 0-1962.0724
573 , p6_a5 NUMBER := 0-1962.0724
574 , p6_a6 NUMBER := 0-1962.0724
575 , p6_a7 NUMBER := 0-1962.0724
576 , p6_a8 NUMBER := 0-1962.0724
577 , p6_a9 NUMBER := 0-1962.0724
578 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
579 , p6_a11 DATE := fnd_api.g_miss_date
580 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
581 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
582 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
583 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
584 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
585 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
586 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
587 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
588 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
589 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
590 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
591 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
592 , p6_a24 NUMBER := 0-1962.0724
593 , p6_a25 NUMBER := 0-1962.0724
594 , p6_a26 NUMBER := 0-1962.0724
595 , p6_a27 NUMBER := 0-1962.0724
596 , p6_a28 NUMBER := 0-1962.0724
597 , p6_a29 NUMBER := 0-1962.0724
598 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
599 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
600 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
601 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
602 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
603 , p6_a35 NUMBER := 0-1962.0724
604 , p6_a36 NUMBER := 0-1962.0724
605 , p6_a37 DATE := fnd_api.g_miss_date
606 , p6_a38 DATE := fnd_api.g_miss_date
607 , p6_a39 DATE := fnd_api.g_miss_date
608 , p6_a40 DATE := fnd_api.g_miss_date
609 , p6_a41 DATE := fnd_api.g_miss_date
610 , p6_a42 DATE := fnd_api.g_miss_date
611 , p6_a43 DATE := fnd_api.g_miss_date
612 , p6_a44 DATE := fnd_api.g_miss_date
613 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
614 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
615 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
616 , p6_a48 NUMBER := 0-1962.0724
617 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
618 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
619 , p6_a51 NUMBER := 0-1962.0724
620 , p6_a52 VARCHAR2 := fnd_api.g_miss_char
621 , p6_a53 VARCHAR2 := fnd_api.g_miss_char
622 , p6_a54 VARCHAR2 := fnd_api.g_miss_char
623 , p6_a55 VARCHAR2 := fnd_api.g_miss_char
624 , p6_a56 NUMBER := 0-1962.0724
625 , p6_a57 NUMBER := 0-1962.0724
626 , p6_a58 NUMBER := 0-1962.0724
627 , p6_a59 NUMBER := 0-1962.0724
628 , p6_a60 NUMBER := 0-1962.0724
629 , p6_a61 NUMBER := 0-1962.0724
630 , p6_a62 NUMBER := 0-1962.0724
631 , p6_a63 NUMBER := 0-1962.0724
632 , p6_a64 VARCHAR2 := fnd_api.g_miss_char
633 , p6_a65 VARCHAR2 := fnd_api.g_miss_char
634 , p6_a66 VARCHAR2 := fnd_api.g_miss_char
635 , p6_a67 VARCHAR2 := fnd_api.g_miss_char
636 , p6_a68 VARCHAR2 := fnd_api.g_miss_char
637 , p6_a69 VARCHAR2 := fnd_api.g_miss_char
638 , p6_a70 VARCHAR2 := fnd_api.g_miss_char
639 , p6_a71 VARCHAR2 := fnd_api.g_miss_char
640 , p6_a72 VARCHAR2 := fnd_api.g_miss_char
641 , p6_a73 VARCHAR2 := fnd_api.g_miss_char
642 , p6_a74 VARCHAR2 := fnd_api.g_miss_char
643 , p6_a75 VARCHAR2 := fnd_api.g_miss_char
644 , p6_a76 VARCHAR2 := fnd_api.g_miss_char
645 , p6_a77 VARCHAR2 := fnd_api.g_miss_char
646 , p6_a78 VARCHAR2 := fnd_api.g_miss_char
647 , p6_a79 VARCHAR2 := fnd_api.g_miss_char
648 , p6_a80 VARCHAR2 := fnd_api.g_miss_char
649 , p6_a81 VARCHAR2 := fnd_api.g_miss_char
650 , p6_a82 VARCHAR2 := fnd_api.g_miss_char
651 , p6_a83 VARCHAR2 := fnd_api.g_miss_char
652 , p6_a84 VARCHAR2 := fnd_api.g_miss_char
653 , p6_a85 NUMBER := 0-1962.0724
654 , p6_a86 VARCHAR2 := fnd_api.g_miss_char
655 , p6_a87 VARCHAR2 := fnd_api.g_miss_char
656 , p6_a88 VARCHAR2 := fnd_api.g_miss_char
657 , p6_a89 NUMBER := 0-1962.0724
658 , p6_a90 VARCHAR2 := fnd_api.g_miss_char
659 , p6_a91 VARCHAR2 := fnd_api.g_miss_char
660 , p6_a92 NUMBER := 0-1962.0724
661 , p6_a93 VARCHAR2 := fnd_api.g_miss_char
662 , p6_a94 NUMBER := 0-1962.0724
663 , p6_a95 VARCHAR2 := fnd_api.g_miss_char
664 , p6_a96 NUMBER := 0-1962.0724
665 , p6_a97 VARCHAR2 := fnd_api.g_miss_char
666 , p6_a98 VARCHAR2 := fnd_api.g_miss_char
667 , p6_a99 VARCHAR2 := fnd_api.g_miss_char
668 , p6_a100 VARCHAR2 := fnd_api.g_miss_char
669 , p6_a101 VARCHAR2 := fnd_api.g_miss_char
670 , p6_a102 VARCHAR2 := fnd_api.g_miss_char
671 , p6_a103 VARCHAR2 := fnd_api.g_miss_char
672 , p6_a104 VARCHAR2 := fnd_api.g_miss_char
673 , p6_a105 VARCHAR2 := fnd_api.g_miss_char
674 , p6_a106 VARCHAR2 := fnd_api.g_miss_char
675 , p6_a107 VARCHAR2 := fnd_api.g_miss_char
676 , p6_a108 VARCHAR2 := fnd_api.g_miss_char
677 , p6_a109 VARCHAR2 := fnd_api.g_miss_char
678 , p6_a110 VARCHAR2 := fnd_api.g_miss_char
679 , p6_a111 VARCHAR2 := fnd_api.g_miss_char
680 , p6_a112 VARCHAR2 := fnd_api.g_miss_char
681 )
682 as
683 ddp_camp_rec ams_campaign_pvt.camp_rec_type;
684 ddindx binary_integer; indx binary_integer;
685 begin
686
687 -- copy data to the local IN or IN-OUT args, if any
688
689
690
691
692
693
694 ddp_camp_rec.campaign_id := rosetta_g_miss_num_map(p6_a0);
695 ddp_camp_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
696 ddp_camp_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
697 ddp_camp_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
698 ddp_camp_rec.created_by := rosetta_g_miss_num_map(p6_a4);
699 ddp_camp_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
700 ddp_camp_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
701 ddp_camp_rec.custom_setup_id := rosetta_g_miss_num_map(p6_a7);
702 ddp_camp_rec.owner_user_id := rosetta_g_miss_num_map(p6_a8);
703 ddp_camp_rec.user_status_id := rosetta_g_miss_num_map(p6_a9);
704 ddp_camp_rec.status_code := p6_a10;
705 ddp_camp_rec.status_date := rosetta_g_miss_date_in_map(p6_a11);
706 ddp_camp_rec.active_flag := p6_a12;
707 ddp_camp_rec.private_flag := p6_a13;
708 ddp_camp_rec.partner_flag := p6_a14;
709 ddp_camp_rec.template_flag := p6_a15;
710 ddp_camp_rec.cascade_source_code_flag := p6_a16;
711 ddp_camp_rec.inherit_attributes_flag := p6_a17;
712 ddp_camp_rec.source_code := p6_a18;
713 ddp_camp_rec.rollup_type := p6_a19;
714 ddp_camp_rec.campaign_type := p6_a20;
715 ddp_camp_rec.media_type_code := p6_a21;
716 ddp_camp_rec.priority := p6_a22;
717 ddp_camp_rec.fund_source_type := p6_a23;
718 ddp_camp_rec.fund_source_id := rosetta_g_miss_num_map(p6_a24);
719 ddp_camp_rec.parent_campaign_id := rosetta_g_miss_num_map(p6_a25);
720 ddp_camp_rec.application_id := rosetta_g_miss_num_map(p6_a26);
721 ddp_camp_rec.qp_list_header_id := rosetta_g_miss_num_map(p6_a27);
722 ddp_camp_rec.media_id := rosetta_g_miss_num_map(p6_a28);
723 ddp_camp_rec.channel_id := rosetta_g_miss_num_map(p6_a29);
724 ddp_camp_rec.event_type := p6_a30;
725 ddp_camp_rec.arc_channel_from := p6_a31;
726 ddp_camp_rec.dscript_name := p6_a32;
727 ddp_camp_rec.transaction_currency_code := p6_a33;
728 ddp_camp_rec.functional_currency_code := p6_a34;
729 ddp_camp_rec.budget_amount_tc := rosetta_g_miss_num_map(p6_a35);
730 ddp_camp_rec.budget_amount_fc := rosetta_g_miss_num_map(p6_a36);
731 ddp_camp_rec.forecasted_plan_start_date := rosetta_g_miss_date_in_map(p6_a37);
732 ddp_camp_rec.forecasted_plan_end_date := rosetta_g_miss_date_in_map(p6_a38);
733 ddp_camp_rec.forecasted_exec_start_date := rosetta_g_miss_date_in_map(p6_a39);
734 ddp_camp_rec.forecasted_exec_end_date := rosetta_g_miss_date_in_map(p6_a40);
735 ddp_camp_rec.actual_plan_start_date := rosetta_g_miss_date_in_map(p6_a41);
736 ddp_camp_rec.actual_plan_end_date := rosetta_g_miss_date_in_map(p6_a42);
737 ddp_camp_rec.actual_exec_start_date := rosetta_g_miss_date_in_map(p6_a43);
738 ddp_camp_rec.actual_exec_end_date := rosetta_g_miss_date_in_map(p6_a44);
739 ddp_camp_rec.inbound_url := p6_a45;
740 ddp_camp_rec.inbound_email_id := p6_a46;
741 ddp_camp_rec.inbound_phone_no := p6_a47;
742 ddp_camp_rec.duration := rosetta_g_miss_num_map(p6_a48);
743 ddp_camp_rec.duration_uom_code := p6_a49;
744 ddp_camp_rec.ff_priority := p6_a50;
745 ddp_camp_rec.ff_override_cover_letter := rosetta_g_miss_num_map(p6_a51);
746 ddp_camp_rec.ff_shipping_method := p6_a52;
747 ddp_camp_rec.ff_carrier := p6_a53;
748 ddp_camp_rec.content_source := p6_a54;
749 ddp_camp_rec.cc_call_strategy := p6_a55;
750 ddp_camp_rec.cc_manager_user_id := rosetta_g_miss_num_map(p6_a56);
751 ddp_camp_rec.forecasted_revenue := rosetta_g_miss_num_map(p6_a57);
752 ddp_camp_rec.actual_revenue := rosetta_g_miss_num_map(p6_a58);
753 ddp_camp_rec.forecasted_cost := rosetta_g_miss_num_map(p6_a59);
754 ddp_camp_rec.actual_cost := rosetta_g_miss_num_map(p6_a60);
755 ddp_camp_rec.forecasted_response := rosetta_g_miss_num_map(p6_a61);
756 ddp_camp_rec.actual_response := rosetta_g_miss_num_map(p6_a62);
757 ddp_camp_rec.target_response := rosetta_g_miss_num_map(p6_a63);
758 ddp_camp_rec.country_code := p6_a64;
759 ddp_camp_rec.language_code := p6_a65;
760 ddp_camp_rec.attribute_category := p6_a66;
761 ddp_camp_rec.attribute1 := p6_a67;
762 ddp_camp_rec.attribute2 := p6_a68;
763 ddp_camp_rec.attribute3 := p6_a69;
764 ddp_camp_rec.attribute4 := p6_a70;
765 ddp_camp_rec.attribute5 := p6_a71;
766 ddp_camp_rec.attribute6 := p6_a72;
767 ddp_camp_rec.attribute7 := p6_a73;
768 ddp_camp_rec.attribute8 := p6_a74;
769 ddp_camp_rec.attribute9 := p6_a75;
770 ddp_camp_rec.attribute10 := p6_a76;
771 ddp_camp_rec.attribute11 := p6_a77;
772 ddp_camp_rec.attribute12 := p6_a78;
773 ddp_camp_rec.attribute13 := p6_a79;
774 ddp_camp_rec.attribute14 := p6_a80;
775 ddp_camp_rec.attribute15 := p6_a81;
776 ddp_camp_rec.campaign_name := p6_a82;
777 ddp_camp_rec.campaign_theme := p6_a83;
778 ddp_camp_rec.description := p6_a84;
779 ddp_camp_rec.version_no := rosetta_g_miss_num_map(p6_a85);
780 ddp_camp_rec.campaign_calendar := p6_a86;
781 ddp_camp_rec.start_period_name := p6_a87;
782 ddp_camp_rec.end_period_name := p6_a88;
783 ddp_camp_rec.city_id := rosetta_g_miss_num_map(p6_a89);
784 ddp_camp_rec.global_flag := p6_a90;
785 ddp_camp_rec.show_campaign_flag := p6_a91;
786 ddp_camp_rec.business_unit_id := rosetta_g_miss_num_map(p6_a92);
787 ddp_camp_rec.accounts_closed_flag := p6_a93;
788 ddp_camp_rec.task_id := rosetta_g_miss_num_map(p6_a94);
789 ddp_camp_rec.related_event_from := p6_a95;
790 ddp_camp_rec.related_event_id := rosetta_g_miss_num_map(p6_a96);
791 ddp_camp_rec.program_attribute_category := p6_a97;
792 ddp_camp_rec.program_attribute1 := p6_a98;
793 ddp_camp_rec.program_attribute2 := p6_a99;
794 ddp_camp_rec.program_attribute3 := p6_a100;
795 ddp_camp_rec.program_attribute4 := p6_a101;
796 ddp_camp_rec.program_attribute5 := p6_a102;
797 ddp_camp_rec.program_attribute6 := p6_a103;
798 ddp_camp_rec.program_attribute7 := p6_a104;
799 ddp_camp_rec.program_attribute8 := p6_a105;
800 ddp_camp_rec.program_attribute9 := p6_a106;
801 ddp_camp_rec.program_attribute10 := p6_a107;
802 ddp_camp_rec.program_attribute11 := p6_a108;
803 ddp_camp_rec.program_attribute12 := p6_a109;
804 ddp_camp_rec.program_attribute13 := p6_a110;
805 ddp_camp_rec.program_attribute14 := p6_a111;
806 ddp_camp_rec.program_attribute15 := p6_a112;
807
808 -- here's the delegated call to the old PL/SQL routine
809 ams_campaign_pub.validate_campaign(p_api_version,
810 p_init_msg_list,
811 p_validation_level,
812 x_return_status,
813 x_msg_count,
814 x_msg_data,
815 ddp_camp_rec);
816
817 -- copy data back from the local OUT or IN-OUT args, if any
818
819
820
821
822
823
824 end;
825
826 end ams_campaign_pub_w;