[Home] [Help]
PACKAGE BODY: APPS.AMS_CAMP_SCHEDULE_PUB_W
Source
1 package body ams_camp_schedule_pub_w as
2 /* $Header: amswschb.pls 120.1 2005/09/08 22:12 dbiswas noship $ */
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 AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6 AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7 AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8
9 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
10 function rosetta_g_miss_date_in_map(d date) return date as
11 begin
12 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure rosetta_table_copy_in_p3(t out nocopy ams_camp_schedule_pub.schedule_tbl_type, a0 JTF_NUMBER_TABLE
26 , a1 JTF_DATE_TABLE
27 , a2 JTF_NUMBER_TABLE
28 , a3 JTF_DATE_TABLE
29 , a4 JTF_NUMBER_TABLE
30 , a5 JTF_NUMBER_TABLE
31 , a6 JTF_NUMBER_TABLE
32 , a7 JTF_NUMBER_TABLE
33 , a8 JTF_NUMBER_TABLE
34 , a9 JTF_VARCHAR2_TABLE_100
35 , a10 JTF_DATE_TABLE
36 , a11 JTF_VARCHAR2_TABLE_100
37 , a12 JTF_VARCHAR2_TABLE_100
38 , a13 JTF_DATE_TABLE
39 , a14 JTF_DATE_TABLE
40 , a15 JTF_NUMBER_TABLE
41 , a16 JTF_VARCHAR2_TABLE_100
42 , a17 JTF_NUMBER_TABLE
43 , a18 JTF_VARCHAR2_TABLE_100
44 , a19 JTF_NUMBER_TABLE
45 , a20 JTF_NUMBER_TABLE
46 , a21 JTF_VARCHAR2_TABLE_100
47 , a22 JTF_NUMBER_TABLE
48 , a23 JTF_NUMBER_TABLE
49 , a24 JTF_NUMBER_TABLE
50 , a25 JTF_NUMBER_TABLE
51 , a26 JTF_VARCHAR2_TABLE_100
52 , a27 JTF_NUMBER_TABLE
53 , a28 JTF_VARCHAR2_TABLE_200
54 , a29 JTF_VARCHAR2_TABLE_200
55 , a30 JTF_VARCHAR2_TABLE_300
56 , a31 JTF_VARCHAR2_TABLE_100
57 , a32 JTF_VARCHAR2_TABLE_100
58 , a33 JTF_NUMBER_TABLE
59 , a34 JTF_VARCHAR2_TABLE_100
60 , a35 JTF_NUMBER_TABLE
61 , a36 JTF_VARCHAR2_TABLE_100
62 , a37 JTF_VARCHAR2_TABLE_100
63 , a38 JTF_VARCHAR2_TABLE_100
64 , a39 JTF_VARCHAR2_TABLE_100
65 , a40 JTF_VARCHAR2_TABLE_300
66 , a41 JTF_VARCHAR2_TABLE_100
67 , a42 JTF_VARCHAR2_TABLE_100
68 , a43 JTF_NUMBER_TABLE
69 , a44 JTF_NUMBER_TABLE
70 , a45 JTF_VARCHAR2_TABLE_100
71 , a46 JTF_NUMBER_TABLE
72 , a47 JTF_VARCHAR2_TABLE_100
73 , a48 JTF_NUMBER_TABLE
74 , a49 JTF_VARCHAR2_TABLE_100
75 , a50 JTF_VARCHAR2_TABLE_200
76 , a51 JTF_VARCHAR2_TABLE_200
77 , a52 JTF_VARCHAR2_TABLE_200
78 , a53 JTF_VARCHAR2_TABLE_300
79 , a54 JTF_VARCHAR2_TABLE_200
80 , a55 JTF_VARCHAR2_TABLE_200
81 , a56 JTF_VARCHAR2_TABLE_200
82 , a57 JTF_VARCHAR2_TABLE_200
83 , a58 JTF_VARCHAR2_TABLE_200
84 , a59 JTF_VARCHAR2_TABLE_200
85 , a60 JTF_VARCHAR2_TABLE_200
86 , a61 JTF_VARCHAR2_TABLE_200
87 , a62 JTF_VARCHAR2_TABLE_200
88 , a63 JTF_VARCHAR2_TABLE_200
89 , a64 JTF_VARCHAR2_TABLE_200
90 , a65 JTF_VARCHAR2_TABLE_300
91 , a66 JTF_VARCHAR2_TABLE_200
92 , a67 JTF_VARCHAR2_TABLE_200
93 , a68 JTF_VARCHAR2_TABLE_200
94 , a69 JTF_VARCHAR2_TABLE_200
95 , a70 JTF_VARCHAR2_TABLE_200
96 , a71 JTF_VARCHAR2_TABLE_200
97 , a72 JTF_VARCHAR2_TABLE_200
98 , a73 JTF_VARCHAR2_TABLE_200
99 , a74 JTF_VARCHAR2_TABLE_200
100 , a75 JTF_VARCHAR2_TABLE_200
101 , a76 JTF_VARCHAR2_TABLE_200
102 , a77 JTF_VARCHAR2_TABLE_200
103 , a78 JTF_VARCHAR2_TABLE_200
104 , a79 JTF_VARCHAR2_TABLE_200
105 , a80 JTF_VARCHAR2_TABLE_200
106 , a81 JTF_VARCHAR2_TABLE_200
107 , a82 JTF_VARCHAR2_TABLE_4000
108 , a83 JTF_VARCHAR2_TABLE_100
109 , a84 JTF_VARCHAR2_TABLE_100
110 , a85 JTF_NUMBER_TABLE
111 , a86 JTF_NUMBER_TABLE
112 , a87 JTF_VARCHAR2_TABLE_100
113 , a88 JTF_VARCHAR2_TABLE_100
114 , a89 JTF_VARCHAR2_TABLE_300
115 , a90 JTF_VARCHAR2_TABLE_4000
116 , a91 JTF_VARCHAR2_TABLE_4000
117 , a92 JTF_VARCHAR2_TABLE_100
118 , a93 JTF_VARCHAR2_TABLE_100
119 , a94 JTF_NUMBER_TABLE
120 , a95 JTF_NUMBER_TABLE
121 , a96 JTF_VARCHAR2_TABLE_100
122 , a97 JTF_VARCHAR2_TABLE_100
123 , a98 JTF_DATE_TABLE
124 , a99 JTF_NUMBER_TABLE
125 , a100 JTF_VARCHAR2_TABLE_300
126 , a101 JTF_VARCHAR2_TABLE_100
127 ) as
128 ddindx binary_integer; indx binary_integer;
129 begin
130 if a0 is not null and a0.count > 0 then
131 if a0.count > 0 then
132 indx := a0.first;
133 ddindx := 1;
134 while true loop
135 t(ddindx).schedule_id := rosetta_g_miss_num_map(a0(indx));
136 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));
137 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
138 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a3(indx));
139 t(ddindx).created_by := rosetta_g_miss_num_map(a4(indx));
140 t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
141 t(ddindx).object_version_number := rosetta_g_miss_num_map(a6(indx));
142 t(ddindx).campaign_id := rosetta_g_miss_num_map(a7(indx));
143 t(ddindx).user_status_id := rosetta_g_miss_num_map(a8(indx));
144 t(ddindx).status_code := a9(indx);
145 t(ddindx).status_date := rosetta_g_miss_date_in_map(a10(indx));
146 t(ddindx).source_code := a11(indx);
147 t(ddindx).use_parent_code_flag := a12(indx);
148 t(ddindx).start_date_time := rosetta_g_miss_date_in_map(a13(indx));
149 t(ddindx).end_date_time := rosetta_g_miss_date_in_map(a14(indx));
150 t(ddindx).timezone_id := rosetta_g_miss_num_map(a15(indx));
151 t(ddindx).activity_type_code := a16(indx);
152 t(ddindx).activity_id := rosetta_g_miss_num_map(a17(indx));
153 t(ddindx).arc_marketing_medium_from := a18(indx);
154 t(ddindx).marketing_medium_id := rosetta_g_miss_num_map(a19(indx));
155 t(ddindx).custom_setup_id := rosetta_g_miss_num_map(a20(indx));
156 t(ddindx).triggerable_flag := a21(indx);
157 t(ddindx).trigger_id := rosetta_g_miss_num_map(a22(indx));
158 t(ddindx).notify_user_id := rosetta_g_miss_num_map(a23(indx));
159 t(ddindx).approver_user_id := rosetta_g_miss_num_map(a24(indx));
160 t(ddindx).owner_user_id := rosetta_g_miss_num_map(a25(indx));
161 t(ddindx).active_flag := a26(indx);
162 t(ddindx).cover_letter_id := rosetta_g_miss_num_map(a27(indx));
163 t(ddindx).reply_to_mail := a28(indx);
164 t(ddindx).mail_sender_name := a29(indx);
165 t(ddindx).mail_subject := a30(indx);
166 t(ddindx).from_fax_no := a31(indx);
167 t(ddindx).accounts_closed_flag := a32(indx);
168 t(ddindx).org_id := rosetta_g_miss_num_map(a33(indx));
169 t(ddindx).objective_code := a34(indx);
170 t(ddindx).country_id := rosetta_g_miss_num_map(a35(indx));
171 t(ddindx).campaign_calendar := a36(indx);
172 t(ddindx).start_period_name := a37(indx);
173 t(ddindx).end_period_name := a38(indx);
174 t(ddindx).priority := a39(indx);
175 t(ddindx).workflow_item_key := a40(indx);
176 t(ddindx).transaction_currency_code := a41(indx);
177 t(ddindx).functional_currency_code := a42(indx);
178 t(ddindx).budget_amount_tc := rosetta_g_miss_num_map(a43(indx));
179 t(ddindx).budget_amount_fc := rosetta_g_miss_num_map(a44(indx));
180 t(ddindx).language_code := a45(indx);
181 t(ddindx).task_id := rosetta_g_miss_num_map(a46(indx));
182 t(ddindx).related_event_from := a47(indx);
183 t(ddindx).related_event_id := rosetta_g_miss_num_map(a48(indx));
184 t(ddindx).attribute_category := a49(indx);
185 t(ddindx).attribute1 := a50(indx);
186 t(ddindx).attribute2 := a51(indx);
187 t(ddindx).attribute3 := a52(indx);
188 t(ddindx).attribute4 := a53(indx);
189 t(ddindx).attribute5 := a54(indx);
190 t(ddindx).attribute6 := a55(indx);
191 t(ddindx).attribute7 := a56(indx);
192 t(ddindx).attribute8 := a57(indx);
193 t(ddindx).attribute9 := a58(indx);
194 t(ddindx).attribute10 := a59(indx);
195 t(ddindx).attribute11 := a60(indx);
196 t(ddindx).attribute12 := a61(indx);
197 t(ddindx).attribute13 := a62(indx);
198 t(ddindx).attribute14 := a63(indx);
199 t(ddindx).attribute15 := a64(indx);
200 t(ddindx).activity_attribute_category := a65(indx);
201 t(ddindx).activity_attribute1 := a66(indx);
202 t(ddindx).activity_attribute2 := a67(indx);
203 t(ddindx).activity_attribute3 := a68(indx);
204 t(ddindx).activity_attribute4 := a69(indx);
205 t(ddindx).activity_attribute5 := a70(indx);
206 t(ddindx).activity_attribute6 := a71(indx);
207 t(ddindx).activity_attribute7 := a72(indx);
208 t(ddindx).activity_attribute8 := a73(indx);
209 t(ddindx).activity_attribute9 := a74(indx);
210 t(ddindx).activity_attribute10 := a75(indx);
211 t(ddindx).activity_attribute11 := a76(indx);
212 t(ddindx).activity_attribute12 := a77(indx);
213 t(ddindx).activity_attribute13 := a78(indx);
214 t(ddindx).activity_attribute14 := a79(indx);
215 t(ddindx).activity_attribute15 := a80(indx);
216 t(ddindx).schedule_name := a81(indx);
217 t(ddindx).description := a82(indx);
218 t(ddindx).related_source_code := a83(indx);
219 t(ddindx).related_source_object := a84(indx);
220 t(ddindx).related_source_id := rosetta_g_miss_num_map(a85(indx));
221 t(ddindx).query_id := rosetta_g_miss_num_map(a86(indx));
222 t(ddindx).include_content_flag := a87(indx);
223 t(ddindx).content_type := a88(indx);
224 t(ddindx).test_email_address := a89(indx);
225 t(ddindx).greeting_text := a90(indx);
226 t(ddindx).footer_text := a91(indx);
227 t(ddindx).trig_repeat_flag := a92(indx);
228 t(ddindx).tgrp_exclude_prev_flag := a93(indx);
229 t(ddindx).orig_csch_id := rosetta_g_miss_num_map(a94(indx));
230 t(ddindx).cover_letter_version := rosetta_g_miss_num_map(a95(indx));
231 t(ddindx).usage := a96(indx);
232 t(ddindx).purpose := a97(indx);
233 t(ddindx).last_activation_date := rosetta_g_miss_date_in_map(a98(indx));
234 t(ddindx).sales_methodology_id := rosetta_g_miss_num_map(a99(indx));
235 t(ddindx).printer_address := a100(indx);
236 t(ddindx).notify_on_activation_flag := a101(indx);
237 ddindx := ddindx+1;
238 if a0.last =indx
239 then exit;
240 end if;
241 indx := a0.next(indx);
242 end loop;
243 end if;
244 end if;
245 end rosetta_table_copy_in_p3;
246 procedure rosetta_table_copy_out_p3(t ams_camp_schedule_pub.schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
247 , a1 out nocopy JTF_DATE_TABLE
248 , a2 out nocopy JTF_NUMBER_TABLE
249 , a3 out nocopy JTF_DATE_TABLE
250 , a4 out nocopy JTF_NUMBER_TABLE
251 , a5 out nocopy JTF_NUMBER_TABLE
252 , a6 out nocopy JTF_NUMBER_TABLE
253 , a7 out nocopy JTF_NUMBER_TABLE
254 , a8 out nocopy JTF_NUMBER_TABLE
255 , a9 out nocopy JTF_VARCHAR2_TABLE_100
256 , a10 out nocopy JTF_DATE_TABLE
257 , a11 out nocopy JTF_VARCHAR2_TABLE_100
258 , a12 out nocopy JTF_VARCHAR2_TABLE_100
259 , a13 out nocopy JTF_DATE_TABLE
260 , a14 out nocopy JTF_DATE_TABLE
261 , a15 out nocopy JTF_NUMBER_TABLE
262 , a16 out nocopy JTF_VARCHAR2_TABLE_100
263 , a17 out nocopy JTF_NUMBER_TABLE
264 , a18 out nocopy JTF_VARCHAR2_TABLE_100
265 , a19 out nocopy JTF_NUMBER_TABLE
266 , a20 out nocopy JTF_NUMBER_TABLE
267 , a21 out nocopy JTF_VARCHAR2_TABLE_100
268 , a22 out nocopy JTF_NUMBER_TABLE
269 , a23 out nocopy JTF_NUMBER_TABLE
270 , a24 out nocopy JTF_NUMBER_TABLE
271 , a25 out nocopy JTF_NUMBER_TABLE
272 , a26 out nocopy JTF_VARCHAR2_TABLE_100
273 , a27 out nocopy JTF_NUMBER_TABLE
274 , a28 out nocopy JTF_VARCHAR2_TABLE_200
275 , a29 out nocopy JTF_VARCHAR2_TABLE_200
276 , a30 out nocopy JTF_VARCHAR2_TABLE_300
277 , a31 out nocopy JTF_VARCHAR2_TABLE_100
278 , a32 out nocopy JTF_VARCHAR2_TABLE_100
279 , a33 out nocopy JTF_NUMBER_TABLE
280 , a34 out nocopy JTF_VARCHAR2_TABLE_100
281 , a35 out nocopy JTF_NUMBER_TABLE
282 , a36 out nocopy JTF_VARCHAR2_TABLE_100
283 , a37 out nocopy JTF_VARCHAR2_TABLE_100
284 , a38 out nocopy JTF_VARCHAR2_TABLE_100
285 , a39 out nocopy JTF_VARCHAR2_TABLE_100
286 , a40 out nocopy JTF_VARCHAR2_TABLE_300
287 , a41 out nocopy JTF_VARCHAR2_TABLE_100
288 , a42 out nocopy JTF_VARCHAR2_TABLE_100
289 , a43 out nocopy JTF_NUMBER_TABLE
290 , a44 out nocopy JTF_NUMBER_TABLE
291 , a45 out nocopy JTF_VARCHAR2_TABLE_100
292 , a46 out nocopy JTF_NUMBER_TABLE
293 , a47 out nocopy JTF_VARCHAR2_TABLE_100
294 , a48 out nocopy JTF_NUMBER_TABLE
295 , a49 out nocopy JTF_VARCHAR2_TABLE_100
296 , a50 out nocopy JTF_VARCHAR2_TABLE_200
297 , a51 out nocopy JTF_VARCHAR2_TABLE_200
298 , a52 out nocopy JTF_VARCHAR2_TABLE_200
299 , a53 out nocopy JTF_VARCHAR2_TABLE_300
300 , a54 out nocopy JTF_VARCHAR2_TABLE_200
301 , a55 out nocopy JTF_VARCHAR2_TABLE_200
302 , a56 out nocopy JTF_VARCHAR2_TABLE_200
303 , a57 out nocopy JTF_VARCHAR2_TABLE_200
304 , a58 out nocopy JTF_VARCHAR2_TABLE_200
305 , a59 out nocopy JTF_VARCHAR2_TABLE_200
306 , a60 out nocopy JTF_VARCHAR2_TABLE_200
307 , a61 out nocopy JTF_VARCHAR2_TABLE_200
308 , a62 out nocopy JTF_VARCHAR2_TABLE_200
309 , a63 out nocopy JTF_VARCHAR2_TABLE_200
310 , a64 out nocopy JTF_VARCHAR2_TABLE_200
311 , a65 out nocopy JTF_VARCHAR2_TABLE_300
312 , a66 out nocopy JTF_VARCHAR2_TABLE_200
313 , a67 out nocopy JTF_VARCHAR2_TABLE_200
314 , a68 out nocopy JTF_VARCHAR2_TABLE_200
315 , a69 out nocopy JTF_VARCHAR2_TABLE_200
316 , a70 out nocopy JTF_VARCHAR2_TABLE_200
317 , a71 out nocopy JTF_VARCHAR2_TABLE_200
318 , a72 out nocopy JTF_VARCHAR2_TABLE_200
319 , a73 out nocopy JTF_VARCHAR2_TABLE_200
320 , a74 out nocopy JTF_VARCHAR2_TABLE_200
321 , a75 out nocopy JTF_VARCHAR2_TABLE_200
322 , a76 out nocopy JTF_VARCHAR2_TABLE_200
323 , a77 out nocopy JTF_VARCHAR2_TABLE_200
324 , a78 out nocopy JTF_VARCHAR2_TABLE_200
325 , a79 out nocopy JTF_VARCHAR2_TABLE_200
326 , a80 out nocopy JTF_VARCHAR2_TABLE_200
327 , a81 out nocopy JTF_VARCHAR2_TABLE_200
328 , a82 out nocopy JTF_VARCHAR2_TABLE_4000
329 , a83 out nocopy JTF_VARCHAR2_TABLE_100
330 , a84 out nocopy JTF_VARCHAR2_TABLE_100
331 , a85 out nocopy JTF_NUMBER_TABLE
332 , a86 out nocopy JTF_NUMBER_TABLE
333 , a87 out nocopy JTF_VARCHAR2_TABLE_100
334 , a88 out nocopy JTF_VARCHAR2_TABLE_100
335 , a89 out nocopy JTF_VARCHAR2_TABLE_300
336 , a90 out nocopy JTF_VARCHAR2_TABLE_4000
337 , a91 out nocopy JTF_VARCHAR2_TABLE_4000
338 , a92 out nocopy JTF_VARCHAR2_TABLE_100
339 , a93 out nocopy JTF_VARCHAR2_TABLE_100
340 , a94 out nocopy JTF_NUMBER_TABLE
341 , a95 out nocopy JTF_NUMBER_TABLE
342 , a96 out nocopy JTF_VARCHAR2_TABLE_100
343 , a97 out nocopy JTF_VARCHAR2_TABLE_100
344 , a98 out nocopy JTF_DATE_TABLE
345 , a99 out nocopy JTF_NUMBER_TABLE
346 , a100 out nocopy JTF_VARCHAR2_TABLE_300
347 , a101 out nocopy JTF_VARCHAR2_TABLE_100
348 ) as
349 ddindx binary_integer; indx binary_integer;
350 begin
351 if t is null or t.count = 0 then
352 a0 := JTF_NUMBER_TABLE();
353 a1 := JTF_DATE_TABLE();
354 a2 := JTF_NUMBER_TABLE();
355 a3 := JTF_DATE_TABLE();
356 a4 := JTF_NUMBER_TABLE();
357 a5 := JTF_NUMBER_TABLE();
358 a6 := JTF_NUMBER_TABLE();
359 a7 := JTF_NUMBER_TABLE();
360 a8 := JTF_NUMBER_TABLE();
361 a9 := JTF_VARCHAR2_TABLE_100();
362 a10 := JTF_DATE_TABLE();
363 a11 := JTF_VARCHAR2_TABLE_100();
364 a12 := JTF_VARCHAR2_TABLE_100();
365 a13 := JTF_DATE_TABLE();
366 a14 := JTF_DATE_TABLE();
367 a15 := JTF_NUMBER_TABLE();
368 a16 := JTF_VARCHAR2_TABLE_100();
369 a17 := JTF_NUMBER_TABLE();
370 a18 := JTF_VARCHAR2_TABLE_100();
371 a19 := JTF_NUMBER_TABLE();
372 a20 := JTF_NUMBER_TABLE();
373 a21 := JTF_VARCHAR2_TABLE_100();
374 a22 := JTF_NUMBER_TABLE();
375 a23 := JTF_NUMBER_TABLE();
376 a24 := JTF_NUMBER_TABLE();
377 a25 := JTF_NUMBER_TABLE();
378 a26 := JTF_VARCHAR2_TABLE_100();
379 a27 := JTF_NUMBER_TABLE();
380 a28 := JTF_VARCHAR2_TABLE_200();
381 a29 := JTF_VARCHAR2_TABLE_200();
382 a30 := JTF_VARCHAR2_TABLE_300();
383 a31 := JTF_VARCHAR2_TABLE_100();
384 a32 := JTF_VARCHAR2_TABLE_100();
385 a33 := JTF_NUMBER_TABLE();
386 a34 := JTF_VARCHAR2_TABLE_100();
387 a35 := JTF_NUMBER_TABLE();
388 a36 := JTF_VARCHAR2_TABLE_100();
389 a37 := JTF_VARCHAR2_TABLE_100();
390 a38 := JTF_VARCHAR2_TABLE_100();
391 a39 := JTF_VARCHAR2_TABLE_100();
392 a40 := JTF_VARCHAR2_TABLE_300();
393 a41 := JTF_VARCHAR2_TABLE_100();
394 a42 := JTF_VARCHAR2_TABLE_100();
395 a43 := JTF_NUMBER_TABLE();
396 a44 := JTF_NUMBER_TABLE();
397 a45 := JTF_VARCHAR2_TABLE_100();
398 a46 := JTF_NUMBER_TABLE();
399 a47 := JTF_VARCHAR2_TABLE_100();
400 a48 := JTF_NUMBER_TABLE();
401 a49 := JTF_VARCHAR2_TABLE_100();
402 a50 := JTF_VARCHAR2_TABLE_200();
403 a51 := JTF_VARCHAR2_TABLE_200();
404 a52 := JTF_VARCHAR2_TABLE_200();
405 a53 := JTF_VARCHAR2_TABLE_300();
406 a54 := JTF_VARCHAR2_TABLE_200();
407 a55 := JTF_VARCHAR2_TABLE_200();
408 a56 := JTF_VARCHAR2_TABLE_200();
409 a57 := JTF_VARCHAR2_TABLE_200();
410 a58 := JTF_VARCHAR2_TABLE_200();
411 a59 := JTF_VARCHAR2_TABLE_200();
412 a60 := JTF_VARCHAR2_TABLE_200();
413 a61 := JTF_VARCHAR2_TABLE_200();
414 a62 := JTF_VARCHAR2_TABLE_200();
415 a63 := JTF_VARCHAR2_TABLE_200();
416 a64 := JTF_VARCHAR2_TABLE_200();
417 a65 := JTF_VARCHAR2_TABLE_300();
418 a66 := JTF_VARCHAR2_TABLE_200();
419 a67 := JTF_VARCHAR2_TABLE_200();
420 a68 := JTF_VARCHAR2_TABLE_200();
421 a69 := JTF_VARCHAR2_TABLE_200();
422 a70 := JTF_VARCHAR2_TABLE_200();
423 a71 := JTF_VARCHAR2_TABLE_200();
424 a72 := JTF_VARCHAR2_TABLE_200();
425 a73 := JTF_VARCHAR2_TABLE_200();
429 a77 := JTF_VARCHAR2_TABLE_200();
426 a74 := JTF_VARCHAR2_TABLE_200();
427 a75 := JTF_VARCHAR2_TABLE_200();
428 a76 := JTF_VARCHAR2_TABLE_200();
430 a78 := JTF_VARCHAR2_TABLE_200();
431 a79 := JTF_VARCHAR2_TABLE_200();
432 a80 := JTF_VARCHAR2_TABLE_200();
433 a81 := JTF_VARCHAR2_TABLE_200();
434 a82 := JTF_VARCHAR2_TABLE_4000();
435 a83 := JTF_VARCHAR2_TABLE_100();
436 a84 := JTF_VARCHAR2_TABLE_100();
437 a85 := JTF_NUMBER_TABLE();
438 a86 := JTF_NUMBER_TABLE();
439 a87 := JTF_VARCHAR2_TABLE_100();
440 a88 := JTF_VARCHAR2_TABLE_100();
441 a89 := JTF_VARCHAR2_TABLE_300();
442 a90 := JTF_VARCHAR2_TABLE_4000();
443 a91 := JTF_VARCHAR2_TABLE_4000();
444 a92 := JTF_VARCHAR2_TABLE_100();
445 a93 := JTF_VARCHAR2_TABLE_100();
446 a94 := JTF_NUMBER_TABLE();
447 a95 := JTF_NUMBER_TABLE();
448 a96 := JTF_VARCHAR2_TABLE_100();
449 a97 := JTF_VARCHAR2_TABLE_100();
450 a98 := JTF_DATE_TABLE();
451 a99 := JTF_NUMBER_TABLE();
452 a100 := JTF_VARCHAR2_TABLE_300();
453 a101 := JTF_VARCHAR2_TABLE_100();
454 else
455 a0 := JTF_NUMBER_TABLE();
456 a1 := JTF_DATE_TABLE();
457 a2 := JTF_NUMBER_TABLE();
458 a3 := JTF_DATE_TABLE();
459 a4 := JTF_NUMBER_TABLE();
460 a5 := JTF_NUMBER_TABLE();
461 a6 := JTF_NUMBER_TABLE();
462 a7 := JTF_NUMBER_TABLE();
463 a8 := JTF_NUMBER_TABLE();
464 a9 := JTF_VARCHAR2_TABLE_100();
465 a10 := JTF_DATE_TABLE();
466 a11 := JTF_VARCHAR2_TABLE_100();
467 a12 := JTF_VARCHAR2_TABLE_100();
468 a13 := JTF_DATE_TABLE();
469 a14 := JTF_DATE_TABLE();
470 a15 := JTF_NUMBER_TABLE();
471 a16 := JTF_VARCHAR2_TABLE_100();
472 a17 := JTF_NUMBER_TABLE();
473 a18 := JTF_VARCHAR2_TABLE_100();
474 a19 := JTF_NUMBER_TABLE();
475 a20 := JTF_NUMBER_TABLE();
476 a21 := JTF_VARCHAR2_TABLE_100();
477 a22 := JTF_NUMBER_TABLE();
478 a23 := JTF_NUMBER_TABLE();
479 a24 := JTF_NUMBER_TABLE();
480 a25 := JTF_NUMBER_TABLE();
481 a26 := JTF_VARCHAR2_TABLE_100();
482 a27 := JTF_NUMBER_TABLE();
483 a28 := JTF_VARCHAR2_TABLE_200();
484 a29 := JTF_VARCHAR2_TABLE_200();
485 a30 := JTF_VARCHAR2_TABLE_300();
486 a31 := JTF_VARCHAR2_TABLE_100();
487 a32 := JTF_VARCHAR2_TABLE_100();
488 a33 := JTF_NUMBER_TABLE();
489 a34 := JTF_VARCHAR2_TABLE_100();
490 a35 := JTF_NUMBER_TABLE();
491 a36 := JTF_VARCHAR2_TABLE_100();
492 a37 := JTF_VARCHAR2_TABLE_100();
493 a38 := JTF_VARCHAR2_TABLE_100();
494 a39 := JTF_VARCHAR2_TABLE_100();
495 a40 := JTF_VARCHAR2_TABLE_300();
496 a41 := JTF_VARCHAR2_TABLE_100();
497 a42 := JTF_VARCHAR2_TABLE_100();
498 a43 := JTF_NUMBER_TABLE();
499 a44 := JTF_NUMBER_TABLE();
500 a45 := JTF_VARCHAR2_TABLE_100();
501 a46 := JTF_NUMBER_TABLE();
502 a47 := JTF_VARCHAR2_TABLE_100();
503 a48 := JTF_NUMBER_TABLE();
504 a49 := JTF_VARCHAR2_TABLE_100();
505 a50 := JTF_VARCHAR2_TABLE_200();
506 a51 := JTF_VARCHAR2_TABLE_200();
507 a52 := JTF_VARCHAR2_TABLE_200();
508 a53 := JTF_VARCHAR2_TABLE_300();
509 a54 := JTF_VARCHAR2_TABLE_200();
510 a55 := JTF_VARCHAR2_TABLE_200();
511 a56 := JTF_VARCHAR2_TABLE_200();
512 a57 := JTF_VARCHAR2_TABLE_200();
513 a58 := JTF_VARCHAR2_TABLE_200();
514 a59 := JTF_VARCHAR2_TABLE_200();
515 a60 := JTF_VARCHAR2_TABLE_200();
516 a61 := JTF_VARCHAR2_TABLE_200();
517 a62 := JTF_VARCHAR2_TABLE_200();
518 a63 := JTF_VARCHAR2_TABLE_200();
519 a64 := JTF_VARCHAR2_TABLE_200();
520 a65 := JTF_VARCHAR2_TABLE_300();
521 a66 := JTF_VARCHAR2_TABLE_200();
522 a67 := JTF_VARCHAR2_TABLE_200();
523 a68 := JTF_VARCHAR2_TABLE_200();
524 a69 := JTF_VARCHAR2_TABLE_200();
525 a70 := JTF_VARCHAR2_TABLE_200();
526 a71 := JTF_VARCHAR2_TABLE_200();
527 a72 := JTF_VARCHAR2_TABLE_200();
528 a73 := JTF_VARCHAR2_TABLE_200();
529 a74 := JTF_VARCHAR2_TABLE_200();
530 a75 := JTF_VARCHAR2_TABLE_200();
531 a76 := JTF_VARCHAR2_TABLE_200();
532 a77 := JTF_VARCHAR2_TABLE_200();
533 a78 := JTF_VARCHAR2_TABLE_200();
534 a79 := JTF_VARCHAR2_TABLE_200();
535 a80 := JTF_VARCHAR2_TABLE_200();
536 a81 := JTF_VARCHAR2_TABLE_200();
537 a82 := JTF_VARCHAR2_TABLE_4000();
538 a83 := JTF_VARCHAR2_TABLE_100();
539 a84 := JTF_VARCHAR2_TABLE_100();
540 a85 := JTF_NUMBER_TABLE();
541 a86 := JTF_NUMBER_TABLE();
542 a87 := JTF_VARCHAR2_TABLE_100();
543 a88 := JTF_VARCHAR2_TABLE_100();
544 a89 := JTF_VARCHAR2_TABLE_300();
545 a90 := JTF_VARCHAR2_TABLE_4000();
546 a91 := JTF_VARCHAR2_TABLE_4000();
547 a92 := JTF_VARCHAR2_TABLE_100();
548 a93 := JTF_VARCHAR2_TABLE_100();
549 a94 := JTF_NUMBER_TABLE();
550 a95 := JTF_NUMBER_TABLE();
551 a96 := JTF_VARCHAR2_TABLE_100();
552 a97 := JTF_VARCHAR2_TABLE_100();
553 a98 := JTF_DATE_TABLE();
554 a99 := JTF_NUMBER_TABLE();
555 a100 := JTF_VARCHAR2_TABLE_300();
556 a101 := JTF_VARCHAR2_TABLE_100();
557 if t.count > 0 then
558 a0.extend(t.count);
562 a4.extend(t.count);
559 a1.extend(t.count);
560 a2.extend(t.count);
561 a3.extend(t.count);
563 a5.extend(t.count);
564 a6.extend(t.count);
565 a7.extend(t.count);
566 a8.extend(t.count);
567 a9.extend(t.count);
568 a10.extend(t.count);
569 a11.extend(t.count);
570 a12.extend(t.count);
571 a13.extend(t.count);
572 a14.extend(t.count);
573 a15.extend(t.count);
574 a16.extend(t.count);
575 a17.extend(t.count);
576 a18.extend(t.count);
577 a19.extend(t.count);
578 a20.extend(t.count);
579 a21.extend(t.count);
580 a22.extend(t.count);
581 a23.extend(t.count);
582 a24.extend(t.count);
583 a25.extend(t.count);
584 a26.extend(t.count);
585 a27.extend(t.count);
586 a28.extend(t.count);
587 a29.extend(t.count);
588 a30.extend(t.count);
589 a31.extend(t.count);
590 a32.extend(t.count);
591 a33.extend(t.count);
592 a34.extend(t.count);
593 a35.extend(t.count);
594 a36.extend(t.count);
595 a37.extend(t.count);
596 a38.extend(t.count);
597 a39.extend(t.count);
598 a40.extend(t.count);
599 a41.extend(t.count);
600 a42.extend(t.count);
601 a43.extend(t.count);
602 a44.extend(t.count);
603 a45.extend(t.count);
604 a46.extend(t.count);
605 a47.extend(t.count);
606 a48.extend(t.count);
607 a49.extend(t.count);
608 a50.extend(t.count);
609 a51.extend(t.count);
610 a52.extend(t.count);
611 a53.extend(t.count);
612 a54.extend(t.count);
613 a55.extend(t.count);
614 a56.extend(t.count);
615 a57.extend(t.count);
616 a58.extend(t.count);
617 a59.extend(t.count);
618 a60.extend(t.count);
619 a61.extend(t.count);
620 a62.extend(t.count);
621 a63.extend(t.count);
622 a64.extend(t.count);
623 a65.extend(t.count);
624 a66.extend(t.count);
625 a67.extend(t.count);
626 a68.extend(t.count);
627 a69.extend(t.count);
628 a70.extend(t.count);
629 a71.extend(t.count);
630 a72.extend(t.count);
631 a73.extend(t.count);
632 a74.extend(t.count);
633 a75.extend(t.count);
634 a76.extend(t.count);
635 a77.extend(t.count);
636 a78.extend(t.count);
637 a79.extend(t.count);
638 a80.extend(t.count);
639 a81.extend(t.count);
640 a82.extend(t.count);
641 a83.extend(t.count);
642 a84.extend(t.count);
643 a85.extend(t.count);
644 a86.extend(t.count);
645 a87.extend(t.count);
646 a88.extend(t.count);
647 a89.extend(t.count);
648 a90.extend(t.count);
649 a91.extend(t.count);
650 a92.extend(t.count);
651 a93.extend(t.count);
652 a94.extend(t.count);
653 a95.extend(t.count);
654 a96.extend(t.count);
655 a97.extend(t.count);
656 a98.extend(t.count);
657 a99.extend(t.count);
658 a100.extend(t.count);
659 a101.extend(t.count);
660 ddindx := t.first;
661 indx := 1;
662 while true loop
663 a0(indx) := rosetta_g_miss_num_map(t(ddindx).schedule_id);
664 a1(indx) := t(ddindx).last_update_date;
665 a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
666 a3(indx) := t(ddindx).creation_date;
667 a4(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
668 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
669 a6(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
670 a7(indx) := rosetta_g_miss_num_map(t(ddindx).campaign_id);
671 a8(indx) := rosetta_g_miss_num_map(t(ddindx).user_status_id);
672 a9(indx) := t(ddindx).status_code;
673 a10(indx) := t(ddindx).status_date;
674 a11(indx) := t(ddindx).source_code;
675 a12(indx) := t(ddindx).use_parent_code_flag;
676 a13(indx) := t(ddindx).start_date_time;
677 a14(indx) := t(ddindx).end_date_time;
678 a15(indx) := rosetta_g_miss_num_map(t(ddindx).timezone_id);
679 a16(indx) := t(ddindx).activity_type_code;
680 a17(indx) := rosetta_g_miss_num_map(t(ddindx).activity_id);
681 a18(indx) := t(ddindx).arc_marketing_medium_from;
682 a19(indx) := rosetta_g_miss_num_map(t(ddindx).marketing_medium_id);
683 a20(indx) := rosetta_g_miss_num_map(t(ddindx).custom_setup_id);
684 a21(indx) := t(ddindx).triggerable_flag;
685 a22(indx) := rosetta_g_miss_num_map(t(ddindx).trigger_id);
686 a23(indx) := rosetta_g_miss_num_map(t(ddindx).notify_user_id);
687 a24(indx) := rosetta_g_miss_num_map(t(ddindx).approver_user_id);
688 a25(indx) := rosetta_g_miss_num_map(t(ddindx).owner_user_id);
689 a26(indx) := t(ddindx).active_flag;
690 a27(indx) := rosetta_g_miss_num_map(t(ddindx).cover_letter_id);
691 a28(indx) := t(ddindx).reply_to_mail;
695 a32(indx) := t(ddindx).accounts_closed_flag;
692 a29(indx) := t(ddindx).mail_sender_name;
693 a30(indx) := t(ddindx).mail_subject;
694 a31(indx) := t(ddindx).from_fax_no;
696 a33(indx) := rosetta_g_miss_num_map(t(ddindx).org_id);
697 a34(indx) := t(ddindx).objective_code;
698 a35(indx) := rosetta_g_miss_num_map(t(ddindx).country_id);
699 a36(indx) := t(ddindx).campaign_calendar;
700 a37(indx) := t(ddindx).start_period_name;
701 a38(indx) := t(ddindx).end_period_name;
702 a39(indx) := t(ddindx).priority;
703 a40(indx) := t(ddindx).workflow_item_key;
704 a41(indx) := t(ddindx).transaction_currency_code;
705 a42(indx) := t(ddindx).functional_currency_code;
706 a43(indx) := rosetta_g_miss_num_map(t(ddindx).budget_amount_tc);
707 a44(indx) := rosetta_g_miss_num_map(t(ddindx).budget_amount_fc);
708 a45(indx) := t(ddindx).language_code;
709 a46(indx) := rosetta_g_miss_num_map(t(ddindx).task_id);
710 a47(indx) := t(ddindx).related_event_from;
711 a48(indx) := rosetta_g_miss_num_map(t(ddindx).related_event_id);
712 a49(indx) := t(ddindx).attribute_category;
713 a50(indx) := t(ddindx).attribute1;
714 a51(indx) := t(ddindx).attribute2;
715 a52(indx) := t(ddindx).attribute3;
716 a53(indx) := t(ddindx).attribute4;
717 a54(indx) := t(ddindx).attribute5;
718 a55(indx) := t(ddindx).attribute6;
719 a56(indx) := t(ddindx).attribute7;
720 a57(indx) := t(ddindx).attribute8;
721 a58(indx) := t(ddindx).attribute9;
722 a59(indx) := t(ddindx).attribute10;
723 a60(indx) := t(ddindx).attribute11;
724 a61(indx) := t(ddindx).attribute12;
725 a62(indx) := t(ddindx).attribute13;
726 a63(indx) := t(ddindx).attribute14;
727 a64(indx) := t(ddindx).attribute15;
728 a65(indx) := t(ddindx).activity_attribute_category;
729 a66(indx) := t(ddindx).activity_attribute1;
730 a67(indx) := t(ddindx).activity_attribute2;
731 a68(indx) := t(ddindx).activity_attribute3;
732 a69(indx) := t(ddindx).activity_attribute4;
733 a70(indx) := t(ddindx).activity_attribute5;
734 a71(indx) := t(ddindx).activity_attribute6;
735 a72(indx) := t(ddindx).activity_attribute7;
736 a73(indx) := t(ddindx).activity_attribute8;
737 a74(indx) := t(ddindx).activity_attribute9;
738 a75(indx) := t(ddindx).activity_attribute10;
739 a76(indx) := t(ddindx).activity_attribute11;
740 a77(indx) := t(ddindx).activity_attribute12;
741 a78(indx) := t(ddindx).activity_attribute13;
742 a79(indx) := t(ddindx).activity_attribute14;
743 a80(indx) := t(ddindx).activity_attribute15;
744 a81(indx) := t(ddindx).schedule_name;
745 a82(indx) := t(ddindx).description;
746 a83(indx) := t(ddindx).related_source_code;
747 a84(indx) := t(ddindx).related_source_object;
748 a85(indx) := rosetta_g_miss_num_map(t(ddindx).related_source_id);
749 a86(indx) := rosetta_g_miss_num_map(t(ddindx).query_id);
750 a87(indx) := t(ddindx).include_content_flag;
751 a88(indx) := t(ddindx).content_type;
752 a89(indx) := t(ddindx).test_email_address;
753 a90(indx) := t(ddindx).greeting_text;
754 a91(indx) := t(ddindx).footer_text;
755 a92(indx) := t(ddindx).trig_repeat_flag;
756 a93(indx) := t(ddindx).tgrp_exclude_prev_flag;
757 a94(indx) := rosetta_g_miss_num_map(t(ddindx).orig_csch_id);
758 a95(indx) := rosetta_g_miss_num_map(t(ddindx).cover_letter_version);
759 a96(indx) := t(ddindx).usage;
760 a97(indx) := t(ddindx).purpose;
761 a98(indx) := t(ddindx).last_activation_date;
762 a99(indx) := rosetta_g_miss_num_map(t(ddindx).sales_methodology_id);
763 a100(indx) := t(ddindx).printer_address;
764 a101(indx) := t(ddindx).notify_on_activation_flag;
765 indx := indx+1;
766 if t.last =ddindx
767 then exit;
768 end if;
769 ddindx := t.next(ddindx);
770 end loop;
771 end if;
772 end if;
773 end rosetta_table_copy_out_p3;
774
775 procedure create_camp_schedule(p_api_version_number NUMBER
776 , p_init_msg_list VARCHAR2
777 , p_commit VARCHAR2
778 , p_validation_level NUMBER
779 , x_return_status out nocopy VARCHAR2
780 , x_msg_count out nocopy NUMBER
781 , x_msg_data out nocopy VARCHAR2
782 , x_schedule_id out nocopy NUMBER
783 , p7_a0 NUMBER := 0-1962.0724
784 , p7_a1 DATE := fnd_api.g_miss_date
785 , p7_a2 NUMBER := 0-1962.0724
786 , p7_a3 DATE := fnd_api.g_miss_date
787 , p7_a4 NUMBER := 0-1962.0724
788 , p7_a5 NUMBER := 0-1962.0724
789 , p7_a6 NUMBER := 0-1962.0724
790 , p7_a7 NUMBER := 0-1962.0724
791 , p7_a8 NUMBER := 0-1962.0724
792 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
793 , p7_a10 DATE := fnd_api.g_miss_date
794 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
795 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
796 , p7_a13 DATE := fnd_api.g_miss_date
797 , p7_a14 DATE := fnd_api.g_miss_date
798 , p7_a15 NUMBER := 0-1962.0724
799 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
800 , p7_a17 NUMBER := 0-1962.0724
801 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
805 , p7_a22 NUMBER := 0-1962.0724
802 , p7_a19 NUMBER := 0-1962.0724
803 , p7_a20 NUMBER := 0-1962.0724
804 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
806 , p7_a23 NUMBER := 0-1962.0724
807 , p7_a24 NUMBER := 0-1962.0724
808 , p7_a25 NUMBER := 0-1962.0724
809 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
810 , p7_a27 NUMBER := 0-1962.0724
811 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
812 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
813 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
814 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
815 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
816 , p7_a33 NUMBER := 0-1962.0724
817 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
818 , p7_a35 NUMBER := 0-1962.0724
819 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
820 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
821 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
822 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
823 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
824 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
825 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
826 , p7_a43 NUMBER := 0-1962.0724
827 , p7_a44 NUMBER := 0-1962.0724
828 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
829 , p7_a46 NUMBER := 0-1962.0724
830 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
831 , p7_a48 NUMBER := 0-1962.0724
832 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
833 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
834 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
835 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
836 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
837 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
838 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
839 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
840 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
841 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
842 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
843 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
844 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
845 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
846 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
847 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
848 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
849 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
850 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
851 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
852 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
853 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
854 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
855 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
856 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
857 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
858 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
859 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
860 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
861 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
862 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
863 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
864 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
865 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
866 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
867 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
868 , p7_a85 NUMBER := 0-1962.0724
869 , p7_a86 NUMBER := 0-1962.0724
870 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
871 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
872 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
873 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
874 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
875 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
876 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
877 , p7_a94 NUMBER := 0-1962.0724
878 , p7_a95 NUMBER := 0-1962.0724
879 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
880 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
881 , p7_a98 DATE := fnd_api.g_miss_date
882 , p7_a99 NUMBER := 0-1962.0724
883 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
884 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
885 )
886
887 as
888 ddp_schedule_rec ams_camp_schedule_pub.schedule_rec_type;
889 ddindx binary_integer; indx binary_integer;
890 begin
891
892 -- copy data to the local IN or IN-OUT args, if any
893
894
895
896
897
898
899
900 ddp_schedule_rec.schedule_id := rosetta_g_miss_num_map(p7_a0);
901 ddp_schedule_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
902 ddp_schedule_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
903 ddp_schedule_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
904 ddp_schedule_rec.created_by := rosetta_g_miss_num_map(p7_a4);
905 ddp_schedule_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
906 ddp_schedule_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
907 ddp_schedule_rec.campaign_id := rosetta_g_miss_num_map(p7_a7);
908 ddp_schedule_rec.user_status_id := rosetta_g_miss_num_map(p7_a8);
909 ddp_schedule_rec.status_code := p7_a9;
910 ddp_schedule_rec.status_date := rosetta_g_miss_date_in_map(p7_a10);
911 ddp_schedule_rec.source_code := p7_a11;
912 ddp_schedule_rec.use_parent_code_flag := p7_a12;
913 ddp_schedule_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a13);
914 ddp_schedule_rec.end_date_time := rosetta_g_miss_date_in_map(p7_a14);
915 ddp_schedule_rec.timezone_id := rosetta_g_miss_num_map(p7_a15);
916 ddp_schedule_rec.activity_type_code := p7_a16;
917 ddp_schedule_rec.activity_id := rosetta_g_miss_num_map(p7_a17);
918 ddp_schedule_rec.arc_marketing_medium_from := p7_a18;
922 ddp_schedule_rec.trigger_id := rosetta_g_miss_num_map(p7_a22);
919 ddp_schedule_rec.marketing_medium_id := rosetta_g_miss_num_map(p7_a19);
920 ddp_schedule_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a20);
921 ddp_schedule_rec.triggerable_flag := p7_a21;
923 ddp_schedule_rec.notify_user_id := rosetta_g_miss_num_map(p7_a23);
924 ddp_schedule_rec.approver_user_id := rosetta_g_miss_num_map(p7_a24);
925 ddp_schedule_rec.owner_user_id := rosetta_g_miss_num_map(p7_a25);
926 ddp_schedule_rec.active_flag := p7_a26;
927 ddp_schedule_rec.cover_letter_id := rosetta_g_miss_num_map(p7_a27);
928 ddp_schedule_rec.reply_to_mail := p7_a28;
929 ddp_schedule_rec.mail_sender_name := p7_a29;
930 ddp_schedule_rec.mail_subject := p7_a30;
931 ddp_schedule_rec.from_fax_no := p7_a31;
932 ddp_schedule_rec.accounts_closed_flag := p7_a32;
933 ddp_schedule_rec.org_id := rosetta_g_miss_num_map(p7_a33);
934 ddp_schedule_rec.objective_code := p7_a34;
935 ddp_schedule_rec.country_id := rosetta_g_miss_num_map(p7_a35);
936 ddp_schedule_rec.campaign_calendar := p7_a36;
937 ddp_schedule_rec.start_period_name := p7_a37;
938 ddp_schedule_rec.end_period_name := p7_a38;
939 ddp_schedule_rec.priority := p7_a39;
940 ddp_schedule_rec.workflow_item_key := p7_a40;
941 ddp_schedule_rec.transaction_currency_code := p7_a41;
942 ddp_schedule_rec.functional_currency_code := p7_a42;
943 ddp_schedule_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a43);
944 ddp_schedule_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a44);
945 ddp_schedule_rec.language_code := p7_a45;
946 ddp_schedule_rec.task_id := rosetta_g_miss_num_map(p7_a46);
947 ddp_schedule_rec.related_event_from := p7_a47;
948 ddp_schedule_rec.related_event_id := rosetta_g_miss_num_map(p7_a48);
949 ddp_schedule_rec.attribute_category := p7_a49;
950 ddp_schedule_rec.attribute1 := p7_a50;
951 ddp_schedule_rec.attribute2 := p7_a51;
952 ddp_schedule_rec.attribute3 := p7_a52;
953 ddp_schedule_rec.attribute4 := p7_a53;
954 ddp_schedule_rec.attribute5 := p7_a54;
955 ddp_schedule_rec.attribute6 := p7_a55;
956 ddp_schedule_rec.attribute7 := p7_a56;
957 ddp_schedule_rec.attribute8 := p7_a57;
958 ddp_schedule_rec.attribute9 := p7_a58;
959 ddp_schedule_rec.attribute10 := p7_a59;
960 ddp_schedule_rec.attribute11 := p7_a60;
961 ddp_schedule_rec.attribute12 := p7_a61;
962 ddp_schedule_rec.attribute13 := p7_a62;
963 ddp_schedule_rec.attribute14 := p7_a63;
964 ddp_schedule_rec.attribute15 := p7_a64;
965 ddp_schedule_rec.activity_attribute_category := p7_a65;
966 ddp_schedule_rec.activity_attribute1 := p7_a66;
967 ddp_schedule_rec.activity_attribute2 := p7_a67;
968 ddp_schedule_rec.activity_attribute3 := p7_a68;
969 ddp_schedule_rec.activity_attribute4 := p7_a69;
970 ddp_schedule_rec.activity_attribute5 := p7_a70;
971 ddp_schedule_rec.activity_attribute6 := p7_a71;
972 ddp_schedule_rec.activity_attribute7 := p7_a72;
973 ddp_schedule_rec.activity_attribute8 := p7_a73;
974 ddp_schedule_rec.activity_attribute9 := p7_a74;
975 ddp_schedule_rec.activity_attribute10 := p7_a75;
976 ddp_schedule_rec.activity_attribute11 := p7_a76;
977 ddp_schedule_rec.activity_attribute12 := p7_a77;
978 ddp_schedule_rec.activity_attribute13 := p7_a78;
979 ddp_schedule_rec.activity_attribute14 := p7_a79;
980 ddp_schedule_rec.activity_attribute15 := p7_a80;
981 ddp_schedule_rec.schedule_name := p7_a81;
982 ddp_schedule_rec.description := p7_a82;
983 ddp_schedule_rec.related_source_code := p7_a83;
984 ddp_schedule_rec.related_source_object := p7_a84;
985 ddp_schedule_rec.related_source_id := rosetta_g_miss_num_map(p7_a85);
986 ddp_schedule_rec.query_id := rosetta_g_miss_num_map(p7_a86);
987 ddp_schedule_rec.include_content_flag := p7_a87;
988 ddp_schedule_rec.content_type := p7_a88;
989 ddp_schedule_rec.test_email_address := p7_a89;
990 ddp_schedule_rec.greeting_text := p7_a90;
991 ddp_schedule_rec.footer_text := p7_a91;
992 ddp_schedule_rec.trig_repeat_flag := p7_a92;
993 ddp_schedule_rec.tgrp_exclude_prev_flag := p7_a93;
994 ddp_schedule_rec.orig_csch_id := rosetta_g_miss_num_map(p7_a94);
995 ddp_schedule_rec.cover_letter_version := rosetta_g_miss_num_map(p7_a95);
996 ddp_schedule_rec.usage := p7_a96;
997 ddp_schedule_rec.purpose := p7_a97;
998 ddp_schedule_rec.last_activation_date := rosetta_g_miss_date_in_map(p7_a98);
999 ddp_schedule_rec.sales_methodology_id := rosetta_g_miss_num_map(p7_a99);
1000 ddp_schedule_rec.printer_address := p7_a100;
1001 ddp_schedule_rec.notify_on_activation_flag := p7_a101;
1002
1003
1004 -- here's the delegated call to the old PL/SQL routine
1005 ams_camp_schedule_pub.create_camp_schedule(p_api_version_number,
1006 p_init_msg_list,
1007 p_commit,
1008 p_validation_level,
1009 x_return_status,
1010 x_msg_count,
1011 x_msg_data,
1012 ddp_schedule_rec,
1013 x_schedule_id);
1014
1015 -- copy data back from the local variables to OUT or IN-OUT args, if any
1016
1017
1018
1019
1020
1021
1022
1023
1024 end;
1025
1026 procedure update_camp_schedule(p_api_version_number NUMBER
1027 , p_init_msg_list VARCHAR2
1028 , p_commit VARCHAR2
1029 , p_validation_level NUMBER
1030 , x_return_status out nocopy VARCHAR2
1031 , x_msg_count out nocopy NUMBER
1032 , x_msg_data out nocopy VARCHAR2
1036 , p7_a2 NUMBER := 0-1962.0724
1033 , x_object_version_number out nocopy NUMBER
1034 , p7_a0 NUMBER := 0-1962.0724
1035 , p7_a1 DATE := fnd_api.g_miss_date
1037 , p7_a3 DATE := fnd_api.g_miss_date
1038 , p7_a4 NUMBER := 0-1962.0724
1039 , p7_a5 NUMBER := 0-1962.0724
1040 , p7_a6 NUMBER := 0-1962.0724
1041 , p7_a7 NUMBER := 0-1962.0724
1042 , p7_a8 NUMBER := 0-1962.0724
1043 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
1044 , p7_a10 DATE := fnd_api.g_miss_date
1045 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
1046 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
1047 , p7_a13 DATE := fnd_api.g_miss_date
1048 , p7_a14 DATE := fnd_api.g_miss_date
1049 , p7_a15 NUMBER := 0-1962.0724
1050 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1051 , p7_a17 NUMBER := 0-1962.0724
1052 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1053 , p7_a19 NUMBER := 0-1962.0724
1054 , p7_a20 NUMBER := 0-1962.0724
1055 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1056 , p7_a22 NUMBER := 0-1962.0724
1057 , p7_a23 NUMBER := 0-1962.0724
1058 , p7_a24 NUMBER := 0-1962.0724
1059 , p7_a25 NUMBER := 0-1962.0724
1060 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1061 , p7_a27 NUMBER := 0-1962.0724
1062 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1063 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
1064 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
1065 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
1066 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
1067 , p7_a33 NUMBER := 0-1962.0724
1068 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
1069 , p7_a35 NUMBER := 0-1962.0724
1070 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
1071 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
1072 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
1073 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
1074 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
1075 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
1076 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
1077 , p7_a43 NUMBER := 0-1962.0724
1078 , p7_a44 NUMBER := 0-1962.0724
1079 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
1080 , p7_a46 NUMBER := 0-1962.0724
1081 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
1082 , p7_a48 NUMBER := 0-1962.0724
1083 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
1084 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
1085 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
1086 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
1087 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
1088 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
1089 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
1090 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
1091 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
1092 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
1093 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
1094 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
1095 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
1096 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
1097 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
1098 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
1099 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
1100 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
1101 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
1102 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
1103 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
1104 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
1105 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
1106 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
1107 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
1108 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
1109 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
1110 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
1111 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
1112 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
1113 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
1114 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
1115 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
1116 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
1117 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
1118 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
1119 , p7_a85 NUMBER := 0-1962.0724
1120 , p7_a86 NUMBER := 0-1962.0724
1121 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
1122 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
1123 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
1124 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
1125 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
1126 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
1127 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
1128 , p7_a94 NUMBER := 0-1962.0724
1129 , p7_a95 NUMBER := 0-1962.0724
1130 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
1131 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
1132 , p7_a98 DATE := fnd_api.g_miss_date
1133 , p7_a99 NUMBER := 0-1962.0724
1134 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
1135 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
1136 )
1137
1138 as
1139 ddp_schedule_rec ams_camp_schedule_pub.schedule_rec_type;
1140 ddindx binary_integer; indx binary_integer;
1141 begin
1142
1143 -- copy data to the local IN or IN-OUT args, if any
1144
1145
1146
1147
1148
1149
1150
1151 ddp_schedule_rec.schedule_id := rosetta_g_miss_num_map(p7_a0);
1152 ddp_schedule_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
1153 ddp_schedule_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
1157 ddp_schedule_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
1154 ddp_schedule_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
1155 ddp_schedule_rec.created_by := rosetta_g_miss_num_map(p7_a4);
1156 ddp_schedule_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
1158 ddp_schedule_rec.campaign_id := rosetta_g_miss_num_map(p7_a7);
1159 ddp_schedule_rec.user_status_id := rosetta_g_miss_num_map(p7_a8);
1160 ddp_schedule_rec.status_code := p7_a9;
1161 ddp_schedule_rec.status_date := rosetta_g_miss_date_in_map(p7_a10);
1162 ddp_schedule_rec.source_code := p7_a11;
1163 ddp_schedule_rec.use_parent_code_flag := p7_a12;
1164 ddp_schedule_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a13);
1165 ddp_schedule_rec.end_date_time := rosetta_g_miss_date_in_map(p7_a14);
1166 ddp_schedule_rec.timezone_id := rosetta_g_miss_num_map(p7_a15);
1167 ddp_schedule_rec.activity_type_code := p7_a16;
1168 ddp_schedule_rec.activity_id := rosetta_g_miss_num_map(p7_a17);
1169 ddp_schedule_rec.arc_marketing_medium_from := p7_a18;
1170 ddp_schedule_rec.marketing_medium_id := rosetta_g_miss_num_map(p7_a19);
1171 ddp_schedule_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a20);
1172 ddp_schedule_rec.triggerable_flag := p7_a21;
1173 ddp_schedule_rec.trigger_id := rosetta_g_miss_num_map(p7_a22);
1174 ddp_schedule_rec.notify_user_id := rosetta_g_miss_num_map(p7_a23);
1175 ddp_schedule_rec.approver_user_id := rosetta_g_miss_num_map(p7_a24);
1176 ddp_schedule_rec.owner_user_id := rosetta_g_miss_num_map(p7_a25);
1177 ddp_schedule_rec.active_flag := p7_a26;
1178 ddp_schedule_rec.cover_letter_id := rosetta_g_miss_num_map(p7_a27);
1179 ddp_schedule_rec.reply_to_mail := p7_a28;
1180 ddp_schedule_rec.mail_sender_name := p7_a29;
1181 ddp_schedule_rec.mail_subject := p7_a30;
1182 ddp_schedule_rec.from_fax_no := p7_a31;
1183 ddp_schedule_rec.accounts_closed_flag := p7_a32;
1184 ddp_schedule_rec.org_id := rosetta_g_miss_num_map(p7_a33);
1185 ddp_schedule_rec.objective_code := p7_a34;
1186 ddp_schedule_rec.country_id := rosetta_g_miss_num_map(p7_a35);
1187 ddp_schedule_rec.campaign_calendar := p7_a36;
1188 ddp_schedule_rec.start_period_name := p7_a37;
1189 ddp_schedule_rec.end_period_name := p7_a38;
1190 ddp_schedule_rec.priority := p7_a39;
1191 ddp_schedule_rec.workflow_item_key := p7_a40;
1192 ddp_schedule_rec.transaction_currency_code := p7_a41;
1193 ddp_schedule_rec.functional_currency_code := p7_a42;
1194 ddp_schedule_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a43);
1195 ddp_schedule_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a44);
1196 ddp_schedule_rec.language_code := p7_a45;
1197 ddp_schedule_rec.task_id := rosetta_g_miss_num_map(p7_a46);
1198 ddp_schedule_rec.related_event_from := p7_a47;
1199 ddp_schedule_rec.related_event_id := rosetta_g_miss_num_map(p7_a48);
1200 ddp_schedule_rec.attribute_category := p7_a49;
1201 ddp_schedule_rec.attribute1 := p7_a50;
1202 ddp_schedule_rec.attribute2 := p7_a51;
1203 ddp_schedule_rec.attribute3 := p7_a52;
1204 ddp_schedule_rec.attribute4 := p7_a53;
1205 ddp_schedule_rec.attribute5 := p7_a54;
1206 ddp_schedule_rec.attribute6 := p7_a55;
1207 ddp_schedule_rec.attribute7 := p7_a56;
1208 ddp_schedule_rec.attribute8 := p7_a57;
1209 ddp_schedule_rec.attribute9 := p7_a58;
1210 ddp_schedule_rec.attribute10 := p7_a59;
1211 ddp_schedule_rec.attribute11 := p7_a60;
1212 ddp_schedule_rec.attribute12 := p7_a61;
1213 ddp_schedule_rec.attribute13 := p7_a62;
1214 ddp_schedule_rec.attribute14 := p7_a63;
1215 ddp_schedule_rec.attribute15 := p7_a64;
1216 ddp_schedule_rec.activity_attribute_category := p7_a65;
1217 ddp_schedule_rec.activity_attribute1 := p7_a66;
1218 ddp_schedule_rec.activity_attribute2 := p7_a67;
1219 ddp_schedule_rec.activity_attribute3 := p7_a68;
1220 ddp_schedule_rec.activity_attribute4 := p7_a69;
1221 ddp_schedule_rec.activity_attribute5 := p7_a70;
1222 ddp_schedule_rec.activity_attribute6 := p7_a71;
1223 ddp_schedule_rec.activity_attribute7 := p7_a72;
1224 ddp_schedule_rec.activity_attribute8 := p7_a73;
1225 ddp_schedule_rec.activity_attribute9 := p7_a74;
1226 ddp_schedule_rec.activity_attribute10 := p7_a75;
1227 ddp_schedule_rec.activity_attribute11 := p7_a76;
1228 ddp_schedule_rec.activity_attribute12 := p7_a77;
1229 ddp_schedule_rec.activity_attribute13 := p7_a78;
1230 ddp_schedule_rec.activity_attribute14 := p7_a79;
1231 ddp_schedule_rec.activity_attribute15 := p7_a80;
1232 ddp_schedule_rec.schedule_name := p7_a81;
1233 ddp_schedule_rec.description := p7_a82;
1234 ddp_schedule_rec.related_source_code := p7_a83;
1235 ddp_schedule_rec.related_source_object := p7_a84;
1236 ddp_schedule_rec.related_source_id := rosetta_g_miss_num_map(p7_a85);
1237 ddp_schedule_rec.query_id := rosetta_g_miss_num_map(p7_a86);
1238 ddp_schedule_rec.include_content_flag := p7_a87;
1239 ddp_schedule_rec.content_type := p7_a88;
1240 ddp_schedule_rec.test_email_address := p7_a89;
1241 ddp_schedule_rec.greeting_text := p7_a90;
1242 ddp_schedule_rec.footer_text := p7_a91;
1243 ddp_schedule_rec.trig_repeat_flag := p7_a92;
1244 ddp_schedule_rec.tgrp_exclude_prev_flag := p7_a93;
1245 ddp_schedule_rec.orig_csch_id := rosetta_g_miss_num_map(p7_a94);
1246 ddp_schedule_rec.cover_letter_version := rosetta_g_miss_num_map(p7_a95);
1247 ddp_schedule_rec.usage := p7_a96;
1248 ddp_schedule_rec.purpose := p7_a97;
1249 ddp_schedule_rec.last_activation_date := rosetta_g_miss_date_in_map(p7_a98);
1253
1250 ddp_schedule_rec.sales_methodology_id := rosetta_g_miss_num_map(p7_a99);
1251 ddp_schedule_rec.printer_address := p7_a100;
1252 ddp_schedule_rec.notify_on_activation_flag := p7_a101;
1254
1255 -- here's the delegated call to the old PL/SQL routine
1256 ams_camp_schedule_pub.update_camp_schedule(p_api_version_number,
1257 p_init_msg_list,
1258 p_commit,
1259 p_validation_level,
1260 x_return_status,
1261 x_msg_count,
1262 x_msg_data,
1263 ddp_schedule_rec,
1264 x_object_version_number);
1265
1266 -- copy data back from the local variables to OUT or IN-OUT args, if any
1267
1268
1269
1270
1271
1272
1273
1274
1275 end;
1276
1277 procedure validate_camp_schedule(p_api_version NUMBER
1278 , p_init_msg_list VARCHAR2
1279 , p_validation_level NUMBER
1280 , x_return_status out nocopy VARCHAR2
1281 , x_msg_count out nocopy NUMBER
1282 , x_msg_data out nocopy VARCHAR2
1283 , p_validation_mode VARCHAR2
1284 , p7_a0 NUMBER := 0-1962.0724
1285 , p7_a1 DATE := fnd_api.g_miss_date
1286 , p7_a2 NUMBER := 0-1962.0724
1287 , p7_a3 DATE := fnd_api.g_miss_date
1288 , p7_a4 NUMBER := 0-1962.0724
1289 , p7_a5 NUMBER := 0-1962.0724
1290 , p7_a6 NUMBER := 0-1962.0724
1291 , p7_a7 NUMBER := 0-1962.0724
1292 , p7_a8 NUMBER := 0-1962.0724
1293 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
1294 , p7_a10 DATE := fnd_api.g_miss_date
1295 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
1296 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
1297 , p7_a13 DATE := fnd_api.g_miss_date
1298 , p7_a14 DATE := fnd_api.g_miss_date
1299 , p7_a15 NUMBER := 0-1962.0724
1300 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1301 , p7_a17 NUMBER := 0-1962.0724
1302 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1303 , p7_a19 NUMBER := 0-1962.0724
1304 , p7_a20 NUMBER := 0-1962.0724
1305 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1306 , p7_a22 NUMBER := 0-1962.0724
1307 , p7_a23 NUMBER := 0-1962.0724
1308 , p7_a24 NUMBER := 0-1962.0724
1309 , p7_a25 NUMBER := 0-1962.0724
1310 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1311 , p7_a27 NUMBER := 0-1962.0724
1312 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1313 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
1314 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
1315 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
1316 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
1317 , p7_a33 NUMBER := 0-1962.0724
1318 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
1319 , p7_a35 NUMBER := 0-1962.0724
1320 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
1321 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
1322 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
1323 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
1324 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
1325 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
1326 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
1327 , p7_a43 NUMBER := 0-1962.0724
1328 , p7_a44 NUMBER := 0-1962.0724
1329 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
1330 , p7_a46 NUMBER := 0-1962.0724
1331 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
1332 , p7_a48 NUMBER := 0-1962.0724
1333 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
1334 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
1335 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
1336 , p7_a52 VARCHAR2 := fnd_api.g_miss_char
1337 , p7_a53 VARCHAR2 := fnd_api.g_miss_char
1338 , p7_a54 VARCHAR2 := fnd_api.g_miss_char
1339 , p7_a55 VARCHAR2 := fnd_api.g_miss_char
1340 , p7_a56 VARCHAR2 := fnd_api.g_miss_char
1341 , p7_a57 VARCHAR2 := fnd_api.g_miss_char
1342 , p7_a58 VARCHAR2 := fnd_api.g_miss_char
1343 , p7_a59 VARCHAR2 := fnd_api.g_miss_char
1344 , p7_a60 VARCHAR2 := fnd_api.g_miss_char
1345 , p7_a61 VARCHAR2 := fnd_api.g_miss_char
1346 , p7_a62 VARCHAR2 := fnd_api.g_miss_char
1347 , p7_a63 VARCHAR2 := fnd_api.g_miss_char
1348 , p7_a64 VARCHAR2 := fnd_api.g_miss_char
1349 , p7_a65 VARCHAR2 := fnd_api.g_miss_char
1350 , p7_a66 VARCHAR2 := fnd_api.g_miss_char
1351 , p7_a67 VARCHAR2 := fnd_api.g_miss_char
1352 , p7_a68 VARCHAR2 := fnd_api.g_miss_char
1353 , p7_a69 VARCHAR2 := fnd_api.g_miss_char
1354 , p7_a70 VARCHAR2 := fnd_api.g_miss_char
1355 , p7_a71 VARCHAR2 := fnd_api.g_miss_char
1356 , p7_a72 VARCHAR2 := fnd_api.g_miss_char
1357 , p7_a73 VARCHAR2 := fnd_api.g_miss_char
1358 , p7_a74 VARCHAR2 := fnd_api.g_miss_char
1359 , p7_a75 VARCHAR2 := fnd_api.g_miss_char
1360 , p7_a76 VARCHAR2 := fnd_api.g_miss_char
1361 , p7_a77 VARCHAR2 := fnd_api.g_miss_char
1362 , p7_a78 VARCHAR2 := fnd_api.g_miss_char
1363 , p7_a79 VARCHAR2 := fnd_api.g_miss_char
1364 , p7_a80 VARCHAR2 := fnd_api.g_miss_char
1365 , p7_a81 VARCHAR2 := fnd_api.g_miss_char
1366 , p7_a82 VARCHAR2 := fnd_api.g_miss_char
1367 , p7_a83 VARCHAR2 := fnd_api.g_miss_char
1368 , p7_a84 VARCHAR2 := fnd_api.g_miss_char
1369 , p7_a85 NUMBER := 0-1962.0724
1370 , p7_a86 NUMBER := 0-1962.0724
1371 , p7_a87 VARCHAR2 := fnd_api.g_miss_char
1372 , p7_a88 VARCHAR2 := fnd_api.g_miss_char
1373 , p7_a89 VARCHAR2 := fnd_api.g_miss_char
1374 , p7_a90 VARCHAR2 := fnd_api.g_miss_char
1375 , p7_a91 VARCHAR2 := fnd_api.g_miss_char
1376 , p7_a92 VARCHAR2 := fnd_api.g_miss_char
1380 , p7_a96 VARCHAR2 := fnd_api.g_miss_char
1377 , p7_a93 VARCHAR2 := fnd_api.g_miss_char
1378 , p7_a94 NUMBER := 0-1962.0724
1379 , p7_a95 NUMBER := 0-1962.0724
1381 , p7_a97 VARCHAR2 := fnd_api.g_miss_char
1382 , p7_a98 DATE := fnd_api.g_miss_date
1383 , p7_a99 NUMBER := 0-1962.0724
1384 , p7_a100 VARCHAR2 := fnd_api.g_miss_char
1385 , p7_a101 VARCHAR2 := fnd_api.g_miss_char
1386 )
1387
1388 as
1389 ddp_schedule_rec ams_camp_schedule_pub.schedule_rec_type;
1390 ddindx binary_integer; indx binary_integer;
1391 begin
1392
1393 -- copy data to the local IN or IN-OUT args, if any
1394
1395
1396
1397
1398
1399
1400
1401 ddp_schedule_rec.schedule_id := rosetta_g_miss_num_map(p7_a0);
1402 ddp_schedule_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
1403 ddp_schedule_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
1404 ddp_schedule_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
1405 ddp_schedule_rec.created_by := rosetta_g_miss_num_map(p7_a4);
1406 ddp_schedule_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
1407 ddp_schedule_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
1408 ddp_schedule_rec.campaign_id := rosetta_g_miss_num_map(p7_a7);
1409 ddp_schedule_rec.user_status_id := rosetta_g_miss_num_map(p7_a8);
1410 ddp_schedule_rec.status_code := p7_a9;
1411 ddp_schedule_rec.status_date := rosetta_g_miss_date_in_map(p7_a10);
1412 ddp_schedule_rec.source_code := p7_a11;
1413 ddp_schedule_rec.use_parent_code_flag := p7_a12;
1414 ddp_schedule_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a13);
1415 ddp_schedule_rec.end_date_time := rosetta_g_miss_date_in_map(p7_a14);
1416 ddp_schedule_rec.timezone_id := rosetta_g_miss_num_map(p7_a15);
1417 ddp_schedule_rec.activity_type_code := p7_a16;
1418 ddp_schedule_rec.activity_id := rosetta_g_miss_num_map(p7_a17);
1419 ddp_schedule_rec.arc_marketing_medium_from := p7_a18;
1420 ddp_schedule_rec.marketing_medium_id := rosetta_g_miss_num_map(p7_a19);
1421 ddp_schedule_rec.custom_setup_id := rosetta_g_miss_num_map(p7_a20);
1422 ddp_schedule_rec.triggerable_flag := p7_a21;
1423 ddp_schedule_rec.trigger_id := rosetta_g_miss_num_map(p7_a22);
1424 ddp_schedule_rec.notify_user_id := rosetta_g_miss_num_map(p7_a23);
1425 ddp_schedule_rec.approver_user_id := rosetta_g_miss_num_map(p7_a24);
1426 ddp_schedule_rec.owner_user_id := rosetta_g_miss_num_map(p7_a25);
1427 ddp_schedule_rec.active_flag := p7_a26;
1428 ddp_schedule_rec.cover_letter_id := rosetta_g_miss_num_map(p7_a27);
1429 ddp_schedule_rec.reply_to_mail := p7_a28;
1430 ddp_schedule_rec.mail_sender_name := p7_a29;
1431 ddp_schedule_rec.mail_subject := p7_a30;
1432 ddp_schedule_rec.from_fax_no := p7_a31;
1433 ddp_schedule_rec.accounts_closed_flag := p7_a32;
1434 ddp_schedule_rec.org_id := rosetta_g_miss_num_map(p7_a33);
1435 ddp_schedule_rec.objective_code := p7_a34;
1436 ddp_schedule_rec.country_id := rosetta_g_miss_num_map(p7_a35);
1437 ddp_schedule_rec.campaign_calendar := p7_a36;
1438 ddp_schedule_rec.start_period_name := p7_a37;
1439 ddp_schedule_rec.end_period_name := p7_a38;
1440 ddp_schedule_rec.priority := p7_a39;
1441 ddp_schedule_rec.workflow_item_key := p7_a40;
1442 ddp_schedule_rec.transaction_currency_code := p7_a41;
1443 ddp_schedule_rec.functional_currency_code := p7_a42;
1444 ddp_schedule_rec.budget_amount_tc := rosetta_g_miss_num_map(p7_a43);
1445 ddp_schedule_rec.budget_amount_fc := rosetta_g_miss_num_map(p7_a44);
1446 ddp_schedule_rec.language_code := p7_a45;
1447 ddp_schedule_rec.task_id := rosetta_g_miss_num_map(p7_a46);
1448 ddp_schedule_rec.related_event_from := p7_a47;
1449 ddp_schedule_rec.related_event_id := rosetta_g_miss_num_map(p7_a48);
1450 ddp_schedule_rec.attribute_category := p7_a49;
1451 ddp_schedule_rec.attribute1 := p7_a50;
1452 ddp_schedule_rec.attribute2 := p7_a51;
1453 ddp_schedule_rec.attribute3 := p7_a52;
1454 ddp_schedule_rec.attribute4 := p7_a53;
1455 ddp_schedule_rec.attribute5 := p7_a54;
1456 ddp_schedule_rec.attribute6 := p7_a55;
1457 ddp_schedule_rec.attribute7 := p7_a56;
1458 ddp_schedule_rec.attribute8 := p7_a57;
1459 ddp_schedule_rec.attribute9 := p7_a58;
1460 ddp_schedule_rec.attribute10 := p7_a59;
1461 ddp_schedule_rec.attribute11 := p7_a60;
1462 ddp_schedule_rec.attribute12 := p7_a61;
1463 ddp_schedule_rec.attribute13 := p7_a62;
1464 ddp_schedule_rec.attribute14 := p7_a63;
1465 ddp_schedule_rec.attribute15 := p7_a64;
1466 ddp_schedule_rec.activity_attribute_category := p7_a65;
1467 ddp_schedule_rec.activity_attribute1 := p7_a66;
1468 ddp_schedule_rec.activity_attribute2 := p7_a67;
1469 ddp_schedule_rec.activity_attribute3 := p7_a68;
1470 ddp_schedule_rec.activity_attribute4 := p7_a69;
1471 ddp_schedule_rec.activity_attribute5 := p7_a70;
1472 ddp_schedule_rec.activity_attribute6 := p7_a71;
1473 ddp_schedule_rec.activity_attribute7 := p7_a72;
1474 ddp_schedule_rec.activity_attribute8 := p7_a73;
1475 ddp_schedule_rec.activity_attribute9 := p7_a74;
1476 ddp_schedule_rec.activity_attribute10 := p7_a75;
1477 ddp_schedule_rec.activity_attribute11 := p7_a76;
1478 ddp_schedule_rec.activity_attribute12 := p7_a77;
1479 ddp_schedule_rec.activity_attribute13 := p7_a78;
1480 ddp_schedule_rec.activity_attribute14 := p7_a79;
1481 ddp_schedule_rec.activity_attribute15 := p7_a80;
1482 ddp_schedule_rec.schedule_name := p7_a81;
1483 ddp_schedule_rec.description := p7_a82;
1484 ddp_schedule_rec.related_source_code := p7_a83;
1488 ddp_schedule_rec.include_content_flag := p7_a87;
1485 ddp_schedule_rec.related_source_object := p7_a84;
1486 ddp_schedule_rec.related_source_id := rosetta_g_miss_num_map(p7_a85);
1487 ddp_schedule_rec.query_id := rosetta_g_miss_num_map(p7_a86);
1489 ddp_schedule_rec.content_type := p7_a88;
1490 ddp_schedule_rec.test_email_address := p7_a89;
1491 ddp_schedule_rec.greeting_text := p7_a90;
1492 ddp_schedule_rec.footer_text := p7_a91;
1493 ddp_schedule_rec.trig_repeat_flag := p7_a92;
1494 ddp_schedule_rec.tgrp_exclude_prev_flag := p7_a93;
1495 ddp_schedule_rec.orig_csch_id := rosetta_g_miss_num_map(p7_a94);
1496 ddp_schedule_rec.cover_letter_version := rosetta_g_miss_num_map(p7_a95);
1497 ddp_schedule_rec.usage := p7_a96;
1498 ddp_schedule_rec.purpose := p7_a97;
1499 ddp_schedule_rec.last_activation_date := rosetta_g_miss_date_in_map(p7_a98);
1500 ddp_schedule_rec.sales_methodology_id := rosetta_g_miss_num_map(p7_a99);
1501 ddp_schedule_rec.printer_address := p7_a100;
1502 ddp_schedule_rec.notify_on_activation_flag := p7_a101;
1503
1504 -- here's the delegated call to the old PL/SQL routine
1505 ams_camp_schedule_pub.validate_camp_schedule(p_api_version,
1506 p_init_msg_list,
1507 p_validation_level,
1508 x_return_status,
1509 x_msg_count,
1510 x_msg_data,
1511 p_validation_mode,
1512 ddp_schedule_rec);
1513
1514 -- copy data back from the local variables to OUT or IN-OUT args, if any
1515
1516
1517
1518
1519
1520
1521
1522 end;
1523
1524 procedure copy_camp_schedule(p_api_version NUMBER
1525 , p_init_msg_list VARCHAR2
1526 , p_commit VARCHAR2
1527 , p_validation_level NUMBER
1528 , x_return_status out nocopy VARCHAR2
1529 , x_msg_count out nocopy NUMBER
1530 , x_msg_data out nocopy VARCHAR2
1531 , p_source_object_id NUMBER
1532 , p_attributes_table JTF_VARCHAR2_TABLE_100
1533 , p9_a0 JTF_VARCHAR2_TABLE_100
1534 , p9_a1 JTF_VARCHAR2_TABLE_4000
1535 , x_new_object_id out nocopy NUMBER
1536 , x_custom_setup_id out nocopy NUMBER
1537 )
1538
1539 as
1540 ddp_attributes_table ams_cpyutility_pvt.copy_attributes_table_type;
1541 ddp_copy_columns_table ams_cpyutility_pvt.copy_columns_table_type;
1542 ddindx binary_integer; indx binary_integer;
1543 begin
1544
1545 -- copy data to the local IN or IN-OUT args, if any
1546
1547
1548
1549
1550
1551
1552
1553
1554 ams_cpyutility_pvt_w.rosetta_table_copy_in_p0(ddp_attributes_table, p_attributes_table);
1555
1556 ams_cpyutility_pvt_w.rosetta_table_copy_in_p2(ddp_copy_columns_table, p9_a0
1557 , p9_a1
1558 );
1559
1560
1561
1562 -- here's the delegated call to the old PL/SQL routine
1563 ams_camp_schedule_pub.copy_camp_schedule(p_api_version,
1564 p_init_msg_list,
1565 p_commit,
1566 p_validation_level,
1567 x_return_status,
1568 x_msg_count,
1569 x_msg_data,
1570 p_source_object_id,
1571 ddp_attributes_table,
1572 ddp_copy_columns_table,
1573 x_new_object_id,
1574 x_custom_setup_id);
1575
1576 -- copy data back from the local variables to OUT or IN-OUT args, if any
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588 end;
1589
1590 end ams_camp_schedule_pub_w;