[Home] [Help]
PACKAGE BODY: APPS.AMS_WEB_TRACK_PVT_W
Source
1 package body ams_web_track_pvt_w as
2 /* $Header: amswwtgb.pls 120.1 2005/06/27 05:43:44 appldev 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 rosetta_table_copy_in_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_VARCHAR2_TABLE_100
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_DATE_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_DATE_TABLE
31 , a9 JTF_NUMBER_TABLE
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_NUMBER_TABLE
34 , a12 JTF_VARCHAR2_TABLE_100
35 , a13 JTF_VARCHAR2_TABLE_200
36 , a14 JTF_VARCHAR2_TABLE_200
37 , a15 JTF_VARCHAR2_TABLE_200
38 , a16 JTF_VARCHAR2_TABLE_200
39 , a17 JTF_VARCHAR2_TABLE_200
40 , a18 JTF_VARCHAR2_TABLE_200
41 , a19 JTF_VARCHAR2_TABLE_200
42 , a20 JTF_VARCHAR2_TABLE_200
43 , a21 JTF_VARCHAR2_TABLE_200
44 , a22 JTF_VARCHAR2_TABLE_200
45 , a23 JTF_VARCHAR2_TABLE_200
46 , a24 JTF_VARCHAR2_TABLE_200
47 , a25 JTF_VARCHAR2_TABLE_200
48 , a26 JTF_VARCHAR2_TABLE_200
49 , a27 JTF_VARCHAR2_TABLE_200
50 ) as
51 ddindx binary_integer; indx binary_integer;
52 begin
53 if a0 is not null and a0.count > 0 then
54 if a0.count > 0 then
55 indx := a0.first;
56 ddindx := 1;
57 while true loop
58 t(ddindx).web_tracking_id := rosetta_g_miss_num_map(a0(indx));
59 t(ddindx).schedule_id := rosetta_g_miss_num_map(a1(indx));
60 t(ddindx).schedule_type := a2(indx);
61 t(ddindx).party_id := rosetta_g_miss_num_map(a3(indx));
62 t(ddindx).placement_id := rosetta_g_miss_num_map(a4(indx));
63 t(ddindx).content_item_id := rosetta_g_miss_num_map(a5(indx));
64 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a6(indx));
65 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a7(indx));
66 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a8(indx));
67 t(ddindx).created_by := rosetta_g_miss_num_map(a9(indx));
68 t(ddindx).last_update_login := rosetta_g_miss_num_map(a10(indx));
69 t(ddindx).object_version_number := rosetta_g_miss_num_map(a11(indx));
70 t(ddindx).attribute_category := a12(indx);
71 t(ddindx).attribute1 := a13(indx);
72 t(ddindx).attribute2 := a14(indx);
73 t(ddindx).attribute3 := a15(indx);
74 t(ddindx).attribute4 := a16(indx);
75 t(ddindx).attribute5 := a17(indx);
76 t(ddindx).attribute6 := a18(indx);
77 t(ddindx).attribute7 := a19(indx);
78 t(ddindx).attribute8 := a20(indx);
79 t(ddindx).attribute9 := a21(indx);
80 t(ddindx).attribute10 := a22(indx);
81 t(ddindx).attribute11 := a23(indx);
82 t(ddindx).attribute12 := a24(indx);
83 t(ddindx).attribute13 := a25(indx);
84 t(ddindx).attribute14 := a26(indx);
85 t(ddindx).attribute15 := a27(indx);
86 ddindx := ddindx+1;
87 if a0.last =indx
88 then exit;
89 end if;
90 indx := a0.next(indx);
91 end loop;
92 end if;
93 end if;
94 end rosetta_table_copy_in_p2;
95 procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
96 , a1 OUT NOCOPY JTF_NUMBER_TABLE
97 , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98 , a3 OUT NOCOPY JTF_NUMBER_TABLE
99 , a4 OUT NOCOPY JTF_NUMBER_TABLE
100 , a5 OUT NOCOPY JTF_NUMBER_TABLE
101 , a6 OUT NOCOPY JTF_DATE_TABLE
102 , a7 OUT NOCOPY JTF_NUMBER_TABLE
103 , a8 OUT NOCOPY JTF_DATE_TABLE
104 , a9 OUT NOCOPY JTF_NUMBER_TABLE
105 , a10 OUT NOCOPY JTF_NUMBER_TABLE
106 , a11 OUT NOCOPY JTF_NUMBER_TABLE
107 , a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
108 , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_200
109 , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
110 , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_200
111 , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_200
112 , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_200
113 , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_200
114 , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_200
115 , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_200
116 , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_200
117 , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_200
118 , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_200
119 , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_200
120 , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_200
121 , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_200
122 , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_200
123 ) as
124 ddindx binary_integer; indx binary_integer;
125 begin
126 if t is null or t.count = 0 then
127 a0 := JTF_NUMBER_TABLE();
128 a1 := JTF_NUMBER_TABLE();
129 a2 := JTF_VARCHAR2_TABLE_100();
130 a3 := JTF_NUMBER_TABLE();
131 a4 := JTF_NUMBER_TABLE();
132 a5 := JTF_NUMBER_TABLE();
133 a6 := JTF_DATE_TABLE();
134 a7 := JTF_NUMBER_TABLE();
135 a8 := JTF_DATE_TABLE();
136 a9 := JTF_NUMBER_TABLE();
137 a10 := JTF_NUMBER_TABLE();
138 a11 := JTF_NUMBER_TABLE();
139 a12 := JTF_VARCHAR2_TABLE_100();
140 a13 := JTF_VARCHAR2_TABLE_200();
141 a14 := JTF_VARCHAR2_TABLE_200();
142 a15 := JTF_VARCHAR2_TABLE_200();
143 a16 := JTF_VARCHAR2_TABLE_200();
144 a17 := JTF_VARCHAR2_TABLE_200();
145 a18 := JTF_VARCHAR2_TABLE_200();
146 a19 := JTF_VARCHAR2_TABLE_200();
147 a20 := JTF_VARCHAR2_TABLE_200();
148 a21 := JTF_VARCHAR2_TABLE_200();
149 a22 := JTF_VARCHAR2_TABLE_200();
150 a23 := JTF_VARCHAR2_TABLE_200();
151 a24 := JTF_VARCHAR2_TABLE_200();
152 a25 := JTF_VARCHAR2_TABLE_200();
153 a26 := JTF_VARCHAR2_TABLE_200();
154 a27 := JTF_VARCHAR2_TABLE_200();
155 else
156 a0 := JTF_NUMBER_TABLE();
157 a1 := JTF_NUMBER_TABLE();
158 a2 := JTF_VARCHAR2_TABLE_100();
159 a3 := JTF_NUMBER_TABLE();
160 a4 := JTF_NUMBER_TABLE();
161 a5 := JTF_NUMBER_TABLE();
162 a6 := JTF_DATE_TABLE();
163 a7 := JTF_NUMBER_TABLE();
164 a8 := JTF_DATE_TABLE();
165 a9 := JTF_NUMBER_TABLE();
166 a10 := JTF_NUMBER_TABLE();
167 a11 := JTF_NUMBER_TABLE();
168 a12 := JTF_VARCHAR2_TABLE_100();
169 a13 := JTF_VARCHAR2_TABLE_200();
170 a14 := JTF_VARCHAR2_TABLE_200();
171 a15 := JTF_VARCHAR2_TABLE_200();
172 a16 := JTF_VARCHAR2_TABLE_200();
173 a17 := JTF_VARCHAR2_TABLE_200();
174 a18 := JTF_VARCHAR2_TABLE_200();
175 a19 := JTF_VARCHAR2_TABLE_200();
176 a20 := JTF_VARCHAR2_TABLE_200();
177 a21 := JTF_VARCHAR2_TABLE_200();
178 a22 := JTF_VARCHAR2_TABLE_200();
179 a23 := JTF_VARCHAR2_TABLE_200();
180 a24 := JTF_VARCHAR2_TABLE_200();
181 a25 := JTF_VARCHAR2_TABLE_200();
182 a26 := JTF_VARCHAR2_TABLE_200();
183 a27 := JTF_VARCHAR2_TABLE_200();
184 if t.count > 0 then
185 a0.extend(t.count);
186 a1.extend(t.count);
187 a2.extend(t.count);
188 a3.extend(t.count);
189 a4.extend(t.count);
190 a5.extend(t.count);
191 a6.extend(t.count);
192 a7.extend(t.count);
193 a8.extend(t.count);
194 a9.extend(t.count);
195 a10.extend(t.count);
196 a11.extend(t.count);
197 a12.extend(t.count);
198 a13.extend(t.count);
199 a14.extend(t.count);
200 a15.extend(t.count);
201 a16.extend(t.count);
202 a17.extend(t.count);
203 a18.extend(t.count);
204 a19.extend(t.count);
205 a20.extend(t.count);
206 a21.extend(t.count);
207 a22.extend(t.count);
208 a23.extend(t.count);
209 a24.extend(t.count);
210 a25.extend(t.count);
211 a26.extend(t.count);
212 a27.extend(t.count);
213 ddindx := t.first;
214 indx := 1;
215 while true loop
216 a0(indx) := rosetta_g_miss_num_map(t(ddindx).web_tracking_id);
217 a1(indx) := rosetta_g_miss_num_map(t(ddindx).schedule_id);
218 a2(indx) := t(ddindx).schedule_type;
219 a3(indx) := rosetta_g_miss_num_map(t(ddindx).party_id);
220 a4(indx) := rosetta_g_miss_num_map(t(ddindx).placement_id);
221 a5(indx) := rosetta_g_miss_num_map(t(ddindx).content_item_id);
222 a6(indx) := t(ddindx).last_update_date;
223 a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
224 a8(indx) := t(ddindx).creation_date;
225 a9(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
226 a10(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
227 a11(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
228 a12(indx) := t(ddindx).attribute_category;
229 a13(indx) := t(ddindx).attribute1;
230 a14(indx) := t(ddindx).attribute2;
231 a15(indx) := t(ddindx).attribute3;
232 a16(indx) := t(ddindx).attribute4;
233 a17(indx) := t(ddindx).attribute5;
234 a18(indx) := t(ddindx).attribute6;
235 a19(indx) := t(ddindx).attribute7;
236 a20(indx) := t(ddindx).attribute8;
237 a21(indx) := t(ddindx).attribute9;
238 a22(indx) := t(ddindx).attribute10;
239 a23(indx) := t(ddindx).attribute11;
240 a24(indx) := t(ddindx).attribute12;
241 a25(indx) := t(ddindx).attribute13;
242 a26(indx) := t(ddindx).attribute14;
243 a27(indx) := t(ddindx).attribute15;
244 indx := indx+1;
245 if t.last =ddindx
246 then exit;
247 end if;
248 ddindx := t.next(ddindx);
249 end loop;
250 end if;
251 end if;
252 end rosetta_table_copy_out_p2;
253
254 procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE
255 , a1 JTF_NUMBER_TABLE
256 , a2 JTF_NUMBER_TABLE
257 , a3 JTF_VARCHAR2_TABLE_100
258 , a4 JTF_NUMBER_TABLE
259 , a5 JTF_NUMBER_TABLE
260 , a6 JTF_VARCHAR2_TABLE_100
261 , a7 JTF_DATE_TABLE
262 , a8 JTF_NUMBER_TABLE
263 , a9 JTF_DATE_TABLE
264 , a10 JTF_NUMBER_TABLE
265 , a11 JTF_NUMBER_TABLE
266 , a12 JTF_NUMBER_TABLE
267 , a13 JTF_VARCHAR2_TABLE_100
268 , a14 JTF_VARCHAR2_TABLE_200
269 , a15 JTF_VARCHAR2_TABLE_200
270 , a16 JTF_VARCHAR2_TABLE_200
271 , a17 JTF_VARCHAR2_TABLE_200
272 , a18 JTF_VARCHAR2_TABLE_200
273 , a19 JTF_VARCHAR2_TABLE_200
274 , a20 JTF_VARCHAR2_TABLE_200
275 , a21 JTF_VARCHAR2_TABLE_200
276 , a22 JTF_VARCHAR2_TABLE_200
277 , a23 JTF_VARCHAR2_TABLE_200
278 , a24 JTF_VARCHAR2_TABLE_200
279 , a25 JTF_VARCHAR2_TABLE_200
280 , a26 JTF_VARCHAR2_TABLE_200
281 , a27 JTF_VARCHAR2_TABLE_200
282 , a28 JTF_VARCHAR2_TABLE_200
283 ) as
284 ddindx binary_integer; indx binary_integer;
285 begin
286 if a0 is not null and a0.count > 0 then
287 if a0.count > 0 then
288 indx := a0.first;
289 ddindx := 1;
290 while true loop
291 t(ddindx).web_recomm_id := rosetta_g_miss_num_map(a0(indx));
292 t(ddindx).web_tracking_id := rosetta_g_miss_num_map(a1(indx));
293 t(ddindx).recomm_object_id := rosetta_g_miss_num_map(a2(indx));
294 t(ddindx).recomm_type := a3(indx);
295 t(ddindx).rule_id := rosetta_g_miss_num_map(a4(indx));
296 t(ddindx).offer_id := rosetta_g_miss_num_map(a5(indx));
297 t(ddindx).offer_src_code := a6(indx);
298 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a7(indx));
299 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a8(indx));
300 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a9(indx));
301 t(ddindx).created_by := rosetta_g_miss_num_map(a10(indx));
302 t(ddindx).last_update_login := rosetta_g_miss_num_map(a11(indx));
303 t(ddindx).object_version_number := rosetta_g_miss_num_map(a12(indx));
304 t(ddindx).attribute_category := a13(indx);
305 t(ddindx).attribute1 := a14(indx);
306 t(ddindx).attribute2 := a15(indx);
307 t(ddindx).attribute3 := a16(indx);
308 t(ddindx).attribute4 := a17(indx);
309 t(ddindx).attribute5 := a18(indx);
310 t(ddindx).attribute6 := a19(indx);
311 t(ddindx).attribute7 := a20(indx);
312 t(ddindx).attribute8 := a21(indx);
313 t(ddindx).attribute9 := a22(indx);
314 t(ddindx).attribute10 := a23(indx);
315 t(ddindx).attribute11 := a24(indx);
316 t(ddindx).attribute12 := a25(indx);
317 t(ddindx).attribute13 := a26(indx);
318 t(ddindx).attribute14 := a27(indx);
319 t(ddindx).attribute15 := a28(indx);
320 ddindx := ddindx+1;
321 if a0.last =indx
322 then exit;
323 end if;
324 indx := a0.next(indx);
325 end loop;
326 end if;
327 end if;
328 end rosetta_table_copy_in_p13;
329 procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
330 , a1 OUT NOCOPY JTF_NUMBER_TABLE
331 , a2 OUT NOCOPY JTF_NUMBER_TABLE
332 , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333 , a4 OUT NOCOPY JTF_NUMBER_TABLE
334 , a5 OUT NOCOPY JTF_NUMBER_TABLE
335 , a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
336 , a7 OUT NOCOPY JTF_DATE_TABLE
337 , a8 OUT NOCOPY JTF_NUMBER_TABLE
338 , a9 OUT NOCOPY JTF_DATE_TABLE
339 , a10 OUT NOCOPY JTF_NUMBER_TABLE
340 , a11 OUT NOCOPY JTF_NUMBER_TABLE
341 , a12 OUT NOCOPY JTF_NUMBER_TABLE
342 , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
343 , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_200
344 , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_200
345 , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_200
346 , a17 OUT NOCOPY JTF_VARCHAR2_TABLE_200
347 , a18 OUT NOCOPY JTF_VARCHAR2_TABLE_200
348 , a19 OUT NOCOPY JTF_VARCHAR2_TABLE_200
349 , a20 OUT NOCOPY JTF_VARCHAR2_TABLE_200
350 , a21 OUT NOCOPY JTF_VARCHAR2_TABLE_200
351 , a22 OUT NOCOPY JTF_VARCHAR2_TABLE_200
352 , a23 OUT NOCOPY JTF_VARCHAR2_TABLE_200
353 , a24 OUT NOCOPY JTF_VARCHAR2_TABLE_200
354 , a25 OUT NOCOPY JTF_VARCHAR2_TABLE_200
355 , a26 OUT NOCOPY JTF_VARCHAR2_TABLE_200
356 , a27 OUT NOCOPY JTF_VARCHAR2_TABLE_200
357 , a28 OUT NOCOPY JTF_VARCHAR2_TABLE_200
358 ) as
359 ddindx binary_integer; indx binary_integer;
360 begin
361 if t is null or t.count = 0 then
362 a0 := JTF_NUMBER_TABLE();
363 a1 := JTF_NUMBER_TABLE();
364 a2 := JTF_NUMBER_TABLE();
365 a3 := JTF_VARCHAR2_TABLE_100();
366 a4 := JTF_NUMBER_TABLE();
367 a5 := JTF_NUMBER_TABLE();
368 a6 := JTF_VARCHAR2_TABLE_100();
369 a7 := JTF_DATE_TABLE();
370 a8 := JTF_NUMBER_TABLE();
371 a9 := JTF_DATE_TABLE();
372 a10 := JTF_NUMBER_TABLE();
373 a11 := JTF_NUMBER_TABLE();
374 a12 := JTF_NUMBER_TABLE();
375 a13 := JTF_VARCHAR2_TABLE_100();
376 a14 := JTF_VARCHAR2_TABLE_200();
377 a15 := JTF_VARCHAR2_TABLE_200();
378 a16 := JTF_VARCHAR2_TABLE_200();
379 a17 := JTF_VARCHAR2_TABLE_200();
380 a18 := JTF_VARCHAR2_TABLE_200();
381 a19 := JTF_VARCHAR2_TABLE_200();
382 a20 := JTF_VARCHAR2_TABLE_200();
383 a21 := JTF_VARCHAR2_TABLE_200();
384 a22 := JTF_VARCHAR2_TABLE_200();
385 a23 := JTF_VARCHAR2_TABLE_200();
386 a24 := JTF_VARCHAR2_TABLE_200();
387 a25 := JTF_VARCHAR2_TABLE_200();
388 a26 := JTF_VARCHAR2_TABLE_200();
389 a27 := JTF_VARCHAR2_TABLE_200();
390 a28 := JTF_VARCHAR2_TABLE_200();
391 else
392 a0 := JTF_NUMBER_TABLE();
393 a1 := JTF_NUMBER_TABLE();
394 a2 := JTF_NUMBER_TABLE();
395 a3 := JTF_VARCHAR2_TABLE_100();
396 a4 := JTF_NUMBER_TABLE();
397 a5 := JTF_NUMBER_TABLE();
398 a6 := JTF_VARCHAR2_TABLE_100();
399 a7 := JTF_DATE_TABLE();
400 a8 := JTF_NUMBER_TABLE();
401 a9 := JTF_DATE_TABLE();
402 a10 := JTF_NUMBER_TABLE();
403 a11 := JTF_NUMBER_TABLE();
404 a12 := JTF_NUMBER_TABLE();
405 a13 := JTF_VARCHAR2_TABLE_100();
406 a14 := JTF_VARCHAR2_TABLE_200();
407 a15 := JTF_VARCHAR2_TABLE_200();
408 a16 := JTF_VARCHAR2_TABLE_200();
409 a17 := JTF_VARCHAR2_TABLE_200();
410 a18 := JTF_VARCHAR2_TABLE_200();
411 a19 := JTF_VARCHAR2_TABLE_200();
412 a20 := JTF_VARCHAR2_TABLE_200();
413 a21 := JTF_VARCHAR2_TABLE_200();
414 a22 := JTF_VARCHAR2_TABLE_200();
415 a23 := JTF_VARCHAR2_TABLE_200();
416 a24 := JTF_VARCHAR2_TABLE_200();
417 a25 := JTF_VARCHAR2_TABLE_200();
418 a26 := JTF_VARCHAR2_TABLE_200();
419 a27 := JTF_VARCHAR2_TABLE_200();
420 a28 := JTF_VARCHAR2_TABLE_200();
421 if t.count > 0 then
422 a0.extend(t.count);
423 a1.extend(t.count);
424 a2.extend(t.count);
425 a3.extend(t.count);
426 a4.extend(t.count);
427 a5.extend(t.count);
428 a6.extend(t.count);
429 a7.extend(t.count);
430 a8.extend(t.count);
431 a9.extend(t.count);
432 a10.extend(t.count);
433 a11.extend(t.count);
434 a12.extend(t.count);
435 a13.extend(t.count);
436 a14.extend(t.count);
437 a15.extend(t.count);
438 a16.extend(t.count);
439 a17.extend(t.count);
440 a18.extend(t.count);
441 a19.extend(t.count);
442 a20.extend(t.count);
443 a21.extend(t.count);
444 a22.extend(t.count);
445 a23.extend(t.count);
446 a24.extend(t.count);
447 a25.extend(t.count);
448 a26.extend(t.count);
449 a27.extend(t.count);
450 a28.extend(t.count);
451 ddindx := t.first;
452 indx := 1;
453 while true loop
454 a0(indx) := rosetta_g_miss_num_map(t(ddindx).web_recomm_id);
455 a1(indx) := rosetta_g_miss_num_map(t(ddindx).web_tracking_id);
456 a2(indx) := rosetta_g_miss_num_map(t(ddindx).recomm_object_id);
457 a3(indx) := t(ddindx).recomm_type;
458 a4(indx) := rosetta_g_miss_num_map(t(ddindx).rule_id);
459 a5(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
460 a6(indx) := t(ddindx).offer_src_code;
461 a7(indx) := t(ddindx).last_update_date;
462 a8(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
463 a9(indx) := t(ddindx).creation_date;
464 a10(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
465 a11(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
466 a12(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
467 a13(indx) := t(ddindx).attribute_category;
468 a14(indx) := t(ddindx).attribute1;
469 a15(indx) := t(ddindx).attribute2;
470 a16(indx) := t(ddindx).attribute3;
471 a17(indx) := t(ddindx).attribute4;
472 a18(indx) := t(ddindx).attribute5;
473 a19(indx) := t(ddindx).attribute6;
474 a20(indx) := t(ddindx).attribute7;
475 a21(indx) := t(ddindx).attribute8;
476 a22(indx) := t(ddindx).attribute9;
477 a23(indx) := t(ddindx).attribute10;
478 a24(indx) := t(ddindx).attribute11;
479 a25(indx) := t(ddindx).attribute12;
480 a26(indx) := t(ddindx).attribute13;
481 a27(indx) := t(ddindx).attribute14;
482 a28(indx) := t(ddindx).attribute15;
483 indx := indx+1;
484 if t.last =ddindx
485 then exit;
486 end if;
487 ddindx := t.next(ddindx);
488 end loop;
489 end if;
490 end if;
491 end rosetta_table_copy_out_p13;
492
493 procedure rosetta_table_copy_in_p23(t OUT NOCOPY ams_web_track_pvt.impr_obj_id_tbl_type, a0 JTF_NUMBER_TABLE
494 , a1 JTF_NUMBER_TABLE
495 ) as
496 ddindx binary_integer; indx binary_integer;
497 begin
498 if a0 is not null and a0.count > 0 then
499 if a0.count > 0 then
500 indx := a0.first;
501 ddindx := 1;
502 while true loop
503 t(ddindx).obj_id := rosetta_g_miss_num_map(a0(indx));
504 t(ddindx).impr_track_id := rosetta_g_miss_num_map(a1(indx));
505 ddindx := ddindx+1;
506 if a0.last =indx
507 then exit;
508 end if;
509 indx := a0.next(indx);
510 end loop;
511 end if;
512 end if;
513 end rosetta_table_copy_in_p23;
514 procedure rosetta_table_copy_out_p23(t ams_web_track_pvt.impr_obj_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
515 , a1 OUT NOCOPY JTF_NUMBER_TABLE
516 ) as
517 ddindx binary_integer; indx binary_integer;
518 begin
519 if t is null or t.count = 0 then
520 a0 := JTF_NUMBER_TABLE();
521 a1 := JTF_NUMBER_TABLE();
522 else
523 a0 := JTF_NUMBER_TABLE();
524 a1 := JTF_NUMBER_TABLE();
525 if t.count > 0 then
526 a0.extend(t.count);
527 a1.extend(t.count);
528 ddindx := t.first;
529 indx := 1;
530 while true loop
531 a0(indx) := rosetta_g_miss_num_map(t(ddindx).obj_id);
532 a1(indx) := rosetta_g_miss_num_map(t(ddindx).impr_track_id);
533 indx := indx+1;
534 if t.last =ddindx
535 then exit;
536 end if;
537 ddindx := t.next(ddindx);
538 end loop;
539 end if;
540 end if;
541 end rosetta_table_copy_out_p23;
542
543 procedure create_web_track(p_api_version_number NUMBER
544 , p_init_msg_list VARCHAR2
545 , p_commit VARCHAR2
546 , p_validation_level NUMBER
547 , x_return_status OUT NOCOPY VARCHAR2
548 , x_msg_count OUT NOCOPY NUMBER
549 , x_msg_data OUT NOCOPY VARCHAR2
550 , x_web_tracking_id OUT NOCOPY NUMBER
551 , p7_a0 NUMBER := 0-1962.0724
552 , p7_a1 NUMBER := 0-1962.0724
553 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
554 , p7_a3 NUMBER := 0-1962.0724
555 , p7_a4 NUMBER := 0-1962.0724
556 , p7_a5 NUMBER := 0-1962.0724
557 , p7_a6 DATE := fnd_api.g_miss_date
558 , p7_a7 NUMBER := 0-1962.0724
559 , p7_a8 DATE := fnd_api.g_miss_date
560 , p7_a9 NUMBER := 0-1962.0724
561 , p7_a10 NUMBER := 0-1962.0724
562 , p7_a11 NUMBER := 0-1962.0724
563 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
564 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
565 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
566 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
567 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
568 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
569 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
570 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
571 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
572 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
573 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
574 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
575 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
576 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
577 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
579 )
580 as
581 ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
582 ddindx binary_integer; indx binary_integer;
583 begin
584
585 -- copy data to the local IN or IN-OUT args, if any
586
587
588
589
590
591
592
593 ddp_web_track_rec.web_tracking_id := rosetta_g_miss_num_map(p7_a0);
594 ddp_web_track_rec.schedule_id := rosetta_g_miss_num_map(p7_a1);
595 ddp_web_track_rec.schedule_type := p7_a2;
596 ddp_web_track_rec.party_id := rosetta_g_miss_num_map(p7_a3);
597 ddp_web_track_rec.placement_id := rosetta_g_miss_num_map(p7_a4);
598 ddp_web_track_rec.content_item_id := rosetta_g_miss_num_map(p7_a5);
599 ddp_web_track_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a6);
600 ddp_web_track_rec.last_updated_by := rosetta_g_miss_num_map(p7_a7);
601 ddp_web_track_rec.creation_date := rosetta_g_miss_date_in_map(p7_a8);
602 ddp_web_track_rec.created_by := rosetta_g_miss_num_map(p7_a9);
603 ddp_web_track_rec.last_update_login := rosetta_g_miss_num_map(p7_a10);
604 ddp_web_track_rec.object_version_number := rosetta_g_miss_num_map(p7_a11);
605 ddp_web_track_rec.attribute_category := p7_a12;
606 ddp_web_track_rec.attribute1 := p7_a13;
607 ddp_web_track_rec.attribute2 := p7_a14;
608 ddp_web_track_rec.attribute3 := p7_a15;
609 ddp_web_track_rec.attribute4 := p7_a16;
610 ddp_web_track_rec.attribute5 := p7_a17;
611 ddp_web_track_rec.attribute6 := p7_a18;
612 ddp_web_track_rec.attribute7 := p7_a19;
613 ddp_web_track_rec.attribute8 := p7_a20;
614 ddp_web_track_rec.attribute9 := p7_a21;
615 ddp_web_track_rec.attribute10 := p7_a22;
616 ddp_web_track_rec.attribute11 := p7_a23;
617 ddp_web_track_rec.attribute12 := p7_a24;
618 ddp_web_track_rec.attribute13 := p7_a25;
619 ddp_web_track_rec.attribute14 := p7_a26;
620 ddp_web_track_rec.attribute15 := p7_a27;
621
622
623 -- here's the delegated call to the old PL/SQL routine
624 ams_web_track_pvt.create_web_track(p_api_version_number,
625 p_init_msg_list,
626 p_commit,
627 p_validation_level,
628 x_return_status,
629 x_msg_count,
630 x_msg_data,
631 ddp_web_track_rec,
632 x_web_tracking_id);
633
634 -- copy data back from the local OUT or IN-OUT args, if any
635
636
637
638
639
640
641
642
643 end;
644
645 procedure update_web_track(p_api_version_number NUMBER
646 , p_init_msg_list VARCHAR2
647 , p_commit VARCHAR2
648 , p_validation_level NUMBER
649 , x_return_status OUT NOCOPY VARCHAR2
650 , x_msg_count OUT NOCOPY NUMBER
651 , x_msg_data OUT NOCOPY VARCHAR2
652 , p7_a0 NUMBER := 0-1962.0724
653 , p7_a1 NUMBER := 0-1962.0724
654 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
655 , p7_a3 NUMBER := 0-1962.0724
656 , p7_a4 NUMBER := 0-1962.0724
657 , p7_a5 NUMBER := 0-1962.0724
658 , p7_a6 DATE := fnd_api.g_miss_date
659 , p7_a7 NUMBER := 0-1962.0724
660 , p7_a8 DATE := fnd_api.g_miss_date
661 , p7_a9 NUMBER := 0-1962.0724
662 , p7_a10 NUMBER := 0-1962.0724
663 , p7_a11 NUMBER := 0-1962.0724
664 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
665 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
666 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
667 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
668 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
669 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
670 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
671 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
672 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
673 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
674 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
675 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
676 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
677 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
678 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
680 )
681 as
682 ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
683 ddindx binary_integer; indx binary_integer;
684 begin
685
686 -- copy data to the local IN or IN-OUT args, if any
687
688
689
690
691
692
693
694 ddp_web_track_rec.web_tracking_id := rosetta_g_miss_num_map(p7_a0);
695 ddp_web_track_rec.schedule_id := rosetta_g_miss_num_map(p7_a1);
696 ddp_web_track_rec.schedule_type := p7_a2;
697 ddp_web_track_rec.party_id := rosetta_g_miss_num_map(p7_a3);
698 ddp_web_track_rec.placement_id := rosetta_g_miss_num_map(p7_a4);
699 ddp_web_track_rec.content_item_id := rosetta_g_miss_num_map(p7_a5);
700 ddp_web_track_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a6);
701 ddp_web_track_rec.last_updated_by := rosetta_g_miss_num_map(p7_a7);
702 ddp_web_track_rec.creation_date := rosetta_g_miss_date_in_map(p7_a8);
703 ddp_web_track_rec.created_by := rosetta_g_miss_num_map(p7_a9);
704 ddp_web_track_rec.last_update_login := rosetta_g_miss_num_map(p7_a10);
705 ddp_web_track_rec.object_version_number := rosetta_g_miss_num_map(p7_a11);
706 ddp_web_track_rec.attribute_category := p7_a12;
707 ddp_web_track_rec.attribute1 := p7_a13;
708 ddp_web_track_rec.attribute2 := p7_a14;
709 ddp_web_track_rec.attribute3 := p7_a15;
710 ddp_web_track_rec.attribute4 := p7_a16;
711 ddp_web_track_rec.attribute5 := p7_a17;
712 ddp_web_track_rec.attribute6 := p7_a18;
713 ddp_web_track_rec.attribute7 := p7_a19;
714 ddp_web_track_rec.attribute8 := p7_a20;
715 ddp_web_track_rec.attribute9 := p7_a21;
716 ddp_web_track_rec.attribute10 := p7_a22;
717 ddp_web_track_rec.attribute11 := p7_a23;
718 ddp_web_track_rec.attribute12 := p7_a24;
719 ddp_web_track_rec.attribute13 := p7_a25;
720 ddp_web_track_rec.attribute14 := p7_a26;
721 ddp_web_track_rec.attribute15 := p7_a27;
722
723 -- here's the delegated call to the old PL/SQL routine
724 ams_web_track_pvt.update_web_track(p_api_version_number,
725 p_init_msg_list,
726 p_commit,
727 p_validation_level,
728 x_return_status,
729 x_msg_count,
730 x_msg_data,
731 ddp_web_track_rec);
732
733 -- copy data back from the local OUT or IN-OUT args, if any
734
735
736
737
738
739
740
741 end;
742
743 procedure validate_web_track(p_api_version_number NUMBER
744 , p_init_msg_list VARCHAR2
745 , p_validation_level NUMBER
746 , p_validation_mode VARCHAR2
747 , x_return_status OUT NOCOPY VARCHAR2
748 , x_msg_count OUT NOCOPY NUMBER
749 , x_msg_data OUT NOCOPY VARCHAR2
750 , p3_a0 NUMBER := 0-1962.0724
751 , p3_a1 NUMBER := 0-1962.0724
752 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
753 , p3_a3 NUMBER := 0-1962.0724
754 , p3_a4 NUMBER := 0-1962.0724
755 , p3_a5 NUMBER := 0-1962.0724
756 , p3_a6 DATE := fnd_api.g_miss_date
757 , p3_a7 NUMBER := 0-1962.0724
758 , p3_a8 DATE := fnd_api.g_miss_date
759 , p3_a9 NUMBER := 0-1962.0724
760 , p3_a10 NUMBER := 0-1962.0724
761 , p3_a11 NUMBER := 0-1962.0724
762 , p3_a12 VARCHAR2 := fnd_api.g_miss_char
763 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
764 , p3_a14 VARCHAR2 := fnd_api.g_miss_char
765 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
766 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
767 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
768 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
769 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
770 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
771 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
772 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
773 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
774 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
775 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
776 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
778 )
779 as
780 ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
781 ddindx binary_integer; indx binary_integer;
782 begin
783
784 -- copy data to the local IN or IN-OUT args, if any
785
786
787
788 ddp_web_track_rec.web_tracking_id := rosetta_g_miss_num_map(p3_a0);
789 ddp_web_track_rec.schedule_id := rosetta_g_miss_num_map(p3_a1);
790 ddp_web_track_rec.schedule_type := p3_a2;
791 ddp_web_track_rec.party_id := rosetta_g_miss_num_map(p3_a3);
792 ddp_web_track_rec.placement_id := rosetta_g_miss_num_map(p3_a4);
793 ddp_web_track_rec.content_item_id := rosetta_g_miss_num_map(p3_a5);
794 ddp_web_track_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a6);
795 ddp_web_track_rec.last_updated_by := rosetta_g_miss_num_map(p3_a7);
796 ddp_web_track_rec.creation_date := rosetta_g_miss_date_in_map(p3_a8);
797 ddp_web_track_rec.created_by := rosetta_g_miss_num_map(p3_a9);
798 ddp_web_track_rec.last_update_login := rosetta_g_miss_num_map(p3_a10);
799 ddp_web_track_rec.object_version_number := rosetta_g_miss_num_map(p3_a11);
800 ddp_web_track_rec.attribute_category := p3_a12;
801 ddp_web_track_rec.attribute1 := p3_a13;
802 ddp_web_track_rec.attribute2 := p3_a14;
803 ddp_web_track_rec.attribute3 := p3_a15;
804 ddp_web_track_rec.attribute4 := p3_a16;
805 ddp_web_track_rec.attribute5 := p3_a17;
806 ddp_web_track_rec.attribute6 := p3_a18;
807 ddp_web_track_rec.attribute7 := p3_a19;
808 ddp_web_track_rec.attribute8 := p3_a20;
809 ddp_web_track_rec.attribute9 := p3_a21;
810 ddp_web_track_rec.attribute10 := p3_a22;
811 ddp_web_track_rec.attribute11 := p3_a23;
812 ddp_web_track_rec.attribute12 := p3_a24;
813 ddp_web_track_rec.attribute13 := p3_a25;
814 ddp_web_track_rec.attribute14 := p3_a26;
815 ddp_web_track_rec.attribute15 := p3_a27;
816
817
818
819
820
821 -- here's the delegated call to the old PL/SQL routine
822 ams_web_track_pvt.validate_web_track(p_api_version_number,
823 p_init_msg_list,
824 p_validation_level,
825 ddp_web_track_rec,
826 p_validation_mode,
827 x_return_status,
828 x_msg_count,
829 x_msg_data);
830
831 -- copy data back from the local OUT or IN-OUT args, if any
832
833
834
835
836
837
838
839 end;
840
841 procedure check_web_track_items(p_validation_mode VARCHAR2
842 , x_return_status OUT NOCOPY VARCHAR2
843 , p0_a0 NUMBER := 0-1962.0724
844 , p0_a1 NUMBER := 0-1962.0724
845 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
846 , p0_a3 NUMBER := 0-1962.0724
847 , p0_a4 NUMBER := 0-1962.0724
848 , p0_a5 NUMBER := 0-1962.0724
849 , p0_a6 DATE := fnd_api.g_miss_date
850 , p0_a7 NUMBER := 0-1962.0724
851 , p0_a8 DATE := fnd_api.g_miss_date
852 , p0_a9 NUMBER := 0-1962.0724
853 , p0_a10 NUMBER := 0-1962.0724
854 , p0_a11 NUMBER := 0-1962.0724
855 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
856 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
857 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
858 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
859 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
860 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
861 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
862 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
863 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
864 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
865 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
866 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
867 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
868 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
869 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
871 )
872 as
873 ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
874 ddindx binary_integer; indx binary_integer;
875 begin
876
877 -- copy data to the local IN or IN-OUT args, if any
878 ddp_web_track_rec.web_tracking_id := rosetta_g_miss_num_map(p0_a0);
879 ddp_web_track_rec.schedule_id := rosetta_g_miss_num_map(p0_a1);
880 ddp_web_track_rec.schedule_type := p0_a2;
881 ddp_web_track_rec.party_id := rosetta_g_miss_num_map(p0_a3);
882 ddp_web_track_rec.placement_id := rosetta_g_miss_num_map(p0_a4);
883 ddp_web_track_rec.content_item_id := rosetta_g_miss_num_map(p0_a5);
884 ddp_web_track_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a6);
885 ddp_web_track_rec.last_updated_by := rosetta_g_miss_num_map(p0_a7);
886 ddp_web_track_rec.creation_date := rosetta_g_miss_date_in_map(p0_a8);
887 ddp_web_track_rec.created_by := rosetta_g_miss_num_map(p0_a9);
888 ddp_web_track_rec.last_update_login := rosetta_g_miss_num_map(p0_a10);
889 ddp_web_track_rec.object_version_number := rosetta_g_miss_num_map(p0_a11);
890 ddp_web_track_rec.attribute_category := p0_a12;
891 ddp_web_track_rec.attribute1 := p0_a13;
892 ddp_web_track_rec.attribute2 := p0_a14;
893 ddp_web_track_rec.attribute3 := p0_a15;
894 ddp_web_track_rec.attribute4 := p0_a16;
895 ddp_web_track_rec.attribute5 := p0_a17;
896 ddp_web_track_rec.attribute6 := p0_a18;
897 ddp_web_track_rec.attribute7 := p0_a19;
898 ddp_web_track_rec.attribute8 := p0_a20;
899 ddp_web_track_rec.attribute9 := p0_a21;
900 ddp_web_track_rec.attribute10 := p0_a22;
901 ddp_web_track_rec.attribute11 := p0_a23;
902 ddp_web_track_rec.attribute12 := p0_a24;
903 ddp_web_track_rec.attribute13 := p0_a25;
904 ddp_web_track_rec.attribute14 := p0_a26;
905 ddp_web_track_rec.attribute15 := p0_a27;
906
907
908
909 -- here's the delegated call to the old PL/SQL routine
910 ams_web_track_pvt.check_web_track_items(ddp_web_track_rec,
911 p_validation_mode,
912 x_return_status);
913
914 -- copy data back from the local OUT or IN-OUT args, if any
915
916
917 end;
918
919 procedure validate_web_track_rec(p_api_version_number NUMBER
920 , p_init_msg_list VARCHAR2
921 , x_return_status OUT NOCOPY VARCHAR2
922 , x_msg_count OUT NOCOPY NUMBER
923 , x_msg_data OUT NOCOPY VARCHAR2
924 , p5_a0 NUMBER := 0-1962.0724
925 , p5_a1 NUMBER := 0-1962.0724
926 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
927 , p5_a3 NUMBER := 0-1962.0724
928 , p5_a4 NUMBER := 0-1962.0724
929 , p5_a5 NUMBER := 0-1962.0724
930 , p5_a6 DATE := fnd_api.g_miss_date
931 , p5_a7 NUMBER := 0-1962.0724
932 , p5_a8 DATE := fnd_api.g_miss_date
933 , p5_a9 NUMBER := 0-1962.0724
934 , p5_a10 NUMBER := 0-1962.0724
935 , p5_a11 NUMBER := 0-1962.0724
936 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
937 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
938 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
939 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
940 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
941 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
942 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
943 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
944 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
945 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
946 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
947 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
948 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
949 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
950 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
952 )
953 as
954 ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
955 ddindx binary_integer; indx binary_integer;
956 begin
957
958 -- copy data to the local IN or IN-OUT args, if any
959
960
961
962
963
964 ddp_web_track_rec.web_tracking_id := rosetta_g_miss_num_map(p5_a0);
965 ddp_web_track_rec.schedule_id := rosetta_g_miss_num_map(p5_a1);
966 ddp_web_track_rec.schedule_type := p5_a2;
967 ddp_web_track_rec.party_id := rosetta_g_miss_num_map(p5_a3);
968 ddp_web_track_rec.placement_id := rosetta_g_miss_num_map(p5_a4);
969 ddp_web_track_rec.content_item_id := rosetta_g_miss_num_map(p5_a5);
970 ddp_web_track_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a6);
971 ddp_web_track_rec.last_updated_by := rosetta_g_miss_num_map(p5_a7);
972 ddp_web_track_rec.creation_date := rosetta_g_miss_date_in_map(p5_a8);
973 ddp_web_track_rec.created_by := rosetta_g_miss_num_map(p5_a9);
974 ddp_web_track_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
975 ddp_web_track_rec.object_version_number := rosetta_g_miss_num_map(p5_a11);
976 ddp_web_track_rec.attribute_category := p5_a12;
977 ddp_web_track_rec.attribute1 := p5_a13;
978 ddp_web_track_rec.attribute2 := p5_a14;
979 ddp_web_track_rec.attribute3 := p5_a15;
980 ddp_web_track_rec.attribute4 := p5_a16;
981 ddp_web_track_rec.attribute5 := p5_a17;
982 ddp_web_track_rec.attribute6 := p5_a18;
983 ddp_web_track_rec.attribute7 := p5_a19;
984 ddp_web_track_rec.attribute8 := p5_a20;
985 ddp_web_track_rec.attribute9 := p5_a21;
986 ddp_web_track_rec.attribute10 := p5_a22;
987 ddp_web_track_rec.attribute11 := p5_a23;
988 ddp_web_track_rec.attribute12 := p5_a24;
989 ddp_web_track_rec.attribute13 := p5_a25;
990 ddp_web_track_rec.attribute14 := p5_a26;
991 ddp_web_track_rec.attribute15 := p5_a27;
992
993 -- here's the delegated call to the old PL/SQL routine
994 ams_web_track_pvt.validate_web_track_rec(p_api_version_number,
995 p_init_msg_list,
996 x_return_status,
997 x_msg_count,
998 x_msg_data,
999 ddp_web_track_rec);
1000
1001 -- copy data back from the local OUT or IN-OUT args, if any
1002
1003
1004
1005
1006
1007 end;
1008
1009 procedure create_web_recomms(p_api_version_number NUMBER
1010 , p_init_msg_list VARCHAR2
1011 , p_commit VARCHAR2
1012 , p_validation_level NUMBER
1013 , x_return_status OUT NOCOPY VARCHAR2
1014 , x_msg_count OUT NOCOPY NUMBER
1015 , x_msg_data OUT NOCOPY VARCHAR2
1016 , x_web_recomm_id OUT NOCOPY NUMBER
1017 , p7_a0 NUMBER := 0-1962.0724
1018 , p7_a1 NUMBER := 0-1962.0724
1019 , p7_a2 NUMBER := 0-1962.0724
1020 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1021 , p7_a4 NUMBER := 0-1962.0724
1022 , p7_a5 NUMBER := 0-1962.0724
1023 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1024 , p7_a7 DATE := fnd_api.g_miss_date
1025 , p7_a8 NUMBER := 0-1962.0724
1026 , p7_a9 DATE := fnd_api.g_miss_date
1027 , p7_a10 NUMBER := 0-1962.0724
1028 , p7_a11 NUMBER := 0-1962.0724
1029 , p7_a12 NUMBER := 0-1962.0724
1030 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1031 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1032 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1033 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1034 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1035 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1036 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1037 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1038 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1039 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1040 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1041 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1042 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1043 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1044 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1046 )
1047 as
1048 ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1049 ddindx binary_integer; indx binary_integer;
1050 begin
1051
1052 -- copy data to the local IN or IN-OUT args, if any
1053
1054
1055
1056
1057
1058
1059
1060 ddp_web_recomms_rec.web_recomm_id := rosetta_g_miss_num_map(p7_a0);
1061 ddp_web_recomms_rec.web_tracking_id := rosetta_g_miss_num_map(p7_a1);
1062 ddp_web_recomms_rec.recomm_object_id := rosetta_g_miss_num_map(p7_a2);
1063 ddp_web_recomms_rec.recomm_type := p7_a3;
1064 ddp_web_recomms_rec.rule_id := rosetta_g_miss_num_map(p7_a4);
1065 ddp_web_recomms_rec.offer_id := rosetta_g_miss_num_map(p7_a5);
1066 ddp_web_recomms_rec.offer_src_code := p7_a6;
1067 ddp_web_recomms_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);
1068 ddp_web_recomms_rec.last_updated_by := rosetta_g_miss_num_map(p7_a8);
1069 ddp_web_recomms_rec.creation_date := rosetta_g_miss_date_in_map(p7_a9);
1070 ddp_web_recomms_rec.created_by := rosetta_g_miss_num_map(p7_a10);
1071 ddp_web_recomms_rec.last_update_login := rosetta_g_miss_num_map(p7_a11);
1072 ddp_web_recomms_rec.object_version_number := rosetta_g_miss_num_map(p7_a12);
1073 ddp_web_recomms_rec.attribute_category := p7_a13;
1074 ddp_web_recomms_rec.attribute1 := p7_a14;
1075 ddp_web_recomms_rec.attribute2 := p7_a15;
1076 ddp_web_recomms_rec.attribute3 := p7_a16;
1077 ddp_web_recomms_rec.attribute4 := p7_a17;
1078 ddp_web_recomms_rec.attribute5 := p7_a18;
1079 ddp_web_recomms_rec.attribute6 := p7_a19;
1080 ddp_web_recomms_rec.attribute7 := p7_a20;
1081 ddp_web_recomms_rec.attribute8 := p7_a21;
1082 ddp_web_recomms_rec.attribute9 := p7_a22;
1083 ddp_web_recomms_rec.attribute10 := p7_a23;
1084 ddp_web_recomms_rec.attribute11 := p7_a24;
1085 ddp_web_recomms_rec.attribute12 := p7_a25;
1086 ddp_web_recomms_rec.attribute13 := p7_a26;
1087 ddp_web_recomms_rec.attribute14 := p7_a27;
1088 ddp_web_recomms_rec.attribute15 := p7_a28;
1089
1090
1091 -- here's the delegated call to the old PL/SQL routine
1092 ams_web_track_pvt.create_web_recomms(p_api_version_number,
1093 p_init_msg_list,
1094 p_commit,
1095 p_validation_level,
1096 x_return_status,
1097 x_msg_count,
1098 x_msg_data,
1099 ddp_web_recomms_rec,
1100 x_web_recomm_id);
1101
1102 -- copy data back from the local OUT or IN-OUT args, if any
1103
1104
1105
1106
1107
1108
1109
1110
1111 end;
1112
1113 procedure update_web_recomms(p_api_version_number NUMBER
1114 , p_init_msg_list VARCHAR2
1115 , p_commit VARCHAR2
1116 , p_validation_level NUMBER
1117 , x_return_status OUT NOCOPY VARCHAR2
1118 , x_msg_count OUT NOCOPY NUMBER
1119 , x_msg_data OUT NOCOPY VARCHAR2
1120 , p7_a0 NUMBER := 0-1962.0724
1121 , p7_a1 NUMBER := 0-1962.0724
1122 , p7_a2 NUMBER := 0-1962.0724
1123 , p7_a3 VARCHAR2 := fnd_api.g_miss_char
1124 , p7_a4 NUMBER := 0-1962.0724
1125 , p7_a5 NUMBER := 0-1962.0724
1126 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
1127 , p7_a7 DATE := fnd_api.g_miss_date
1128 , p7_a8 NUMBER := 0-1962.0724
1129 , p7_a9 DATE := fnd_api.g_miss_date
1130 , p7_a10 NUMBER := 0-1962.0724
1131 , p7_a11 NUMBER := 0-1962.0724
1132 , p7_a12 NUMBER := 0-1962.0724
1133 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
1134 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
1135 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
1136 , p7_a16 VARCHAR2 := fnd_api.g_miss_char
1137 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
1138 , p7_a18 VARCHAR2 := fnd_api.g_miss_char
1139 , p7_a19 VARCHAR2 := fnd_api.g_miss_char
1140 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
1141 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
1142 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
1143 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
1144 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
1145 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
1146 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
1147 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1149 )
1150 as
1151 ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1152 ddindx binary_integer; indx binary_integer;
1153 begin
1154
1155 -- copy data to the local IN or IN-OUT args, if any
1156
1157
1158
1159
1160
1161
1162
1163 ddp_web_recomms_rec.web_recomm_id := rosetta_g_miss_num_map(p7_a0);
1164 ddp_web_recomms_rec.web_tracking_id := rosetta_g_miss_num_map(p7_a1);
1165 ddp_web_recomms_rec.recomm_object_id := rosetta_g_miss_num_map(p7_a2);
1166 ddp_web_recomms_rec.recomm_type := p7_a3;
1167 ddp_web_recomms_rec.rule_id := rosetta_g_miss_num_map(p7_a4);
1168 ddp_web_recomms_rec.offer_id := rosetta_g_miss_num_map(p7_a5);
1169 ddp_web_recomms_rec.offer_src_code := p7_a6;
1170 ddp_web_recomms_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a7);
1171 ddp_web_recomms_rec.last_updated_by := rosetta_g_miss_num_map(p7_a8);
1172 ddp_web_recomms_rec.creation_date := rosetta_g_miss_date_in_map(p7_a9);
1173 ddp_web_recomms_rec.created_by := rosetta_g_miss_num_map(p7_a10);
1174 ddp_web_recomms_rec.last_update_login := rosetta_g_miss_num_map(p7_a11);
1175 ddp_web_recomms_rec.object_version_number := rosetta_g_miss_num_map(p7_a12);
1176 ddp_web_recomms_rec.attribute_category := p7_a13;
1177 ddp_web_recomms_rec.attribute1 := p7_a14;
1178 ddp_web_recomms_rec.attribute2 := p7_a15;
1179 ddp_web_recomms_rec.attribute3 := p7_a16;
1180 ddp_web_recomms_rec.attribute4 := p7_a17;
1181 ddp_web_recomms_rec.attribute5 := p7_a18;
1182 ddp_web_recomms_rec.attribute6 := p7_a19;
1183 ddp_web_recomms_rec.attribute7 := p7_a20;
1184 ddp_web_recomms_rec.attribute8 := p7_a21;
1185 ddp_web_recomms_rec.attribute9 := p7_a22;
1186 ddp_web_recomms_rec.attribute10 := p7_a23;
1187 ddp_web_recomms_rec.attribute11 := p7_a24;
1188 ddp_web_recomms_rec.attribute12 := p7_a25;
1189 ddp_web_recomms_rec.attribute13 := p7_a26;
1190 ddp_web_recomms_rec.attribute14 := p7_a27;
1191 ddp_web_recomms_rec.attribute15 := p7_a28;
1192
1193 -- here's the delegated call to the old PL/SQL routine
1194 ams_web_track_pvt.update_web_recomms(p_api_version_number,
1195 p_init_msg_list,
1196 p_commit,
1197 p_validation_level,
1198 x_return_status,
1199 x_msg_count,
1200 x_msg_data,
1201 ddp_web_recomms_rec);
1202
1203 -- copy data back from the local OUT or IN-OUT args, if any
1204
1205
1206
1207
1208
1209
1210
1211 end;
1212
1213 procedure validate_web_recomms(p_api_version_number NUMBER
1214 , p_init_msg_list VARCHAR2
1215 , p_validation_level NUMBER
1216 , p_validation_mode VARCHAR2
1217 , x_return_status OUT NOCOPY VARCHAR2
1218 , x_msg_count OUT NOCOPY NUMBER
1219 , x_msg_data OUT NOCOPY VARCHAR2
1220 , p3_a0 NUMBER := 0-1962.0724
1221 , p3_a1 NUMBER := 0-1962.0724
1222 , p3_a2 NUMBER := 0-1962.0724
1223 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
1224 , p3_a4 NUMBER := 0-1962.0724
1225 , p3_a5 NUMBER := 0-1962.0724
1226 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
1227 , p3_a7 DATE := fnd_api.g_miss_date
1228 , p3_a8 NUMBER := 0-1962.0724
1229 , p3_a9 DATE := fnd_api.g_miss_date
1230 , p3_a10 NUMBER := 0-1962.0724
1231 , p3_a11 NUMBER := 0-1962.0724
1232 , p3_a12 NUMBER := 0-1962.0724
1233 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
1234 , p3_a14 VARCHAR2 := fnd_api.g_miss_char
1235 , p3_a15 VARCHAR2 := fnd_api.g_miss_char
1236 , p3_a16 VARCHAR2 := fnd_api.g_miss_char
1237 , p3_a17 VARCHAR2 := fnd_api.g_miss_char
1238 , p3_a18 VARCHAR2 := fnd_api.g_miss_char
1239 , p3_a19 VARCHAR2 := fnd_api.g_miss_char
1240 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
1241 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
1242 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
1243 , p3_a23 VARCHAR2 := fnd_api.g_miss_char
1244 , p3_a24 VARCHAR2 := fnd_api.g_miss_char
1245 , p3_a25 VARCHAR2 := fnd_api.g_miss_char
1246 , p3_a26 VARCHAR2 := fnd_api.g_miss_char
1247 , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248 , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1249 )
1250 as
1251 ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1252 ddindx binary_integer; indx binary_integer;
1253 begin
1254
1255 -- copy data to the local IN or IN-OUT args, if any
1256
1257
1258
1259 ddp_web_recomms_rec.web_recomm_id := rosetta_g_miss_num_map(p3_a0);
1260 ddp_web_recomms_rec.web_tracking_id := rosetta_g_miss_num_map(p3_a1);
1261 ddp_web_recomms_rec.recomm_object_id := rosetta_g_miss_num_map(p3_a2);
1262 ddp_web_recomms_rec.recomm_type := p3_a3;
1263 ddp_web_recomms_rec.rule_id := rosetta_g_miss_num_map(p3_a4);
1264 ddp_web_recomms_rec.offer_id := rosetta_g_miss_num_map(p3_a5);
1265 ddp_web_recomms_rec.offer_src_code := p3_a6;
1266 ddp_web_recomms_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a7);
1267 ddp_web_recomms_rec.last_updated_by := rosetta_g_miss_num_map(p3_a8);
1268 ddp_web_recomms_rec.creation_date := rosetta_g_miss_date_in_map(p3_a9);
1269 ddp_web_recomms_rec.created_by := rosetta_g_miss_num_map(p3_a10);
1270 ddp_web_recomms_rec.last_update_login := rosetta_g_miss_num_map(p3_a11);
1271 ddp_web_recomms_rec.object_version_number := rosetta_g_miss_num_map(p3_a12);
1272 ddp_web_recomms_rec.attribute_category := p3_a13;
1273 ddp_web_recomms_rec.attribute1 := p3_a14;
1274 ddp_web_recomms_rec.attribute2 := p3_a15;
1275 ddp_web_recomms_rec.attribute3 := p3_a16;
1276 ddp_web_recomms_rec.attribute4 := p3_a17;
1277 ddp_web_recomms_rec.attribute5 := p3_a18;
1278 ddp_web_recomms_rec.attribute6 := p3_a19;
1279 ddp_web_recomms_rec.attribute7 := p3_a20;
1280 ddp_web_recomms_rec.attribute8 := p3_a21;
1281 ddp_web_recomms_rec.attribute9 := p3_a22;
1282 ddp_web_recomms_rec.attribute10 := p3_a23;
1283 ddp_web_recomms_rec.attribute11 := p3_a24;
1284 ddp_web_recomms_rec.attribute12 := p3_a25;
1285 ddp_web_recomms_rec.attribute13 := p3_a26;
1286 ddp_web_recomms_rec.attribute14 := p3_a27;
1287 ddp_web_recomms_rec.attribute15 := p3_a28;
1288
1289
1290
1291
1292
1293 -- here's the delegated call to the old PL/SQL routine
1294 ams_web_track_pvt.validate_web_recomms(p_api_version_number,
1295 p_init_msg_list,
1296 p_validation_level,
1297 ddp_web_recomms_rec,
1298 p_validation_mode,
1299 x_return_status,
1300 x_msg_count,
1301 x_msg_data);
1302
1303 -- copy data back from the local OUT or IN-OUT args, if any
1304
1305
1306
1307
1308
1309
1310
1311 end;
1312
1313 procedure check_web_recomms_items(p_validation_mode VARCHAR2
1314 , x_return_status OUT NOCOPY VARCHAR2
1315 , p0_a0 NUMBER := 0-1962.0724
1316 , p0_a1 NUMBER := 0-1962.0724
1317 , p0_a2 NUMBER := 0-1962.0724
1318 , p0_a3 VARCHAR2 := fnd_api.g_miss_char
1319 , p0_a4 NUMBER := 0-1962.0724
1320 , p0_a5 NUMBER := 0-1962.0724
1321 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
1322 , p0_a7 DATE := fnd_api.g_miss_date
1323 , p0_a8 NUMBER := 0-1962.0724
1324 , p0_a9 DATE := fnd_api.g_miss_date
1325 , p0_a10 NUMBER := 0-1962.0724
1326 , p0_a11 NUMBER := 0-1962.0724
1327 , p0_a12 NUMBER := 0-1962.0724
1328 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
1329 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1330 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1331 , p0_a16 VARCHAR2 := fnd_api.g_miss_char
1332 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1333 , p0_a18 VARCHAR2 := fnd_api.g_miss_char
1334 , p0_a19 VARCHAR2 := fnd_api.g_miss_char
1335 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1336 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1337 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1338 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1339 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1340 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1341 , p0_a26 VARCHAR2 := fnd_api.g_miss_char
1342 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1344 )
1345 as
1346 ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1347 ddindx binary_integer; indx binary_integer;
1348 begin
1349
1350 -- copy data to the local IN or IN-OUT args, if any
1351 ddp_web_recomms_rec.web_recomm_id := rosetta_g_miss_num_map(p0_a0);
1352 ddp_web_recomms_rec.web_tracking_id := rosetta_g_miss_num_map(p0_a1);
1353 ddp_web_recomms_rec.recomm_object_id := rosetta_g_miss_num_map(p0_a2);
1354 ddp_web_recomms_rec.recomm_type := p0_a3;
1355 ddp_web_recomms_rec.rule_id := rosetta_g_miss_num_map(p0_a4);
1356 ddp_web_recomms_rec.offer_id := rosetta_g_miss_num_map(p0_a5);
1357 ddp_web_recomms_rec.offer_src_code := p0_a6;
1358 ddp_web_recomms_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a7);
1359 ddp_web_recomms_rec.last_updated_by := rosetta_g_miss_num_map(p0_a8);
1360 ddp_web_recomms_rec.creation_date := rosetta_g_miss_date_in_map(p0_a9);
1361 ddp_web_recomms_rec.created_by := rosetta_g_miss_num_map(p0_a10);
1362 ddp_web_recomms_rec.last_update_login := rosetta_g_miss_num_map(p0_a11);
1363 ddp_web_recomms_rec.object_version_number := rosetta_g_miss_num_map(p0_a12);
1364 ddp_web_recomms_rec.attribute_category := p0_a13;
1365 ddp_web_recomms_rec.attribute1 := p0_a14;
1366 ddp_web_recomms_rec.attribute2 := p0_a15;
1367 ddp_web_recomms_rec.attribute3 := p0_a16;
1368 ddp_web_recomms_rec.attribute4 := p0_a17;
1369 ddp_web_recomms_rec.attribute5 := p0_a18;
1370 ddp_web_recomms_rec.attribute6 := p0_a19;
1371 ddp_web_recomms_rec.attribute7 := p0_a20;
1372 ddp_web_recomms_rec.attribute8 := p0_a21;
1373 ddp_web_recomms_rec.attribute9 := p0_a22;
1374 ddp_web_recomms_rec.attribute10 := p0_a23;
1375 ddp_web_recomms_rec.attribute11 := p0_a24;
1376 ddp_web_recomms_rec.attribute12 := p0_a25;
1377 ddp_web_recomms_rec.attribute13 := p0_a26;
1378 ddp_web_recomms_rec.attribute14 := p0_a27;
1379 ddp_web_recomms_rec.attribute15 := p0_a28;
1380
1381
1382
1383 -- here's the delegated call to the old PL/SQL routine
1384 ams_web_track_pvt.check_web_recomms_items(ddp_web_recomms_rec,
1385 p_validation_mode,
1386 x_return_status);
1387
1388 -- copy data back from the local OUT or IN-OUT args, if any
1389
1390
1391 end;
1392
1393 procedure validate_web_recomms_rec(p_api_version_number NUMBER
1394 , p_init_msg_list VARCHAR2
1395 , x_return_status OUT NOCOPY VARCHAR2
1396 , x_msg_count OUT NOCOPY NUMBER
1397 , x_msg_data OUT NOCOPY VARCHAR2
1398 , p5_a0 NUMBER := 0-1962.0724
1399 , p5_a1 NUMBER := 0-1962.0724
1400 , p5_a2 NUMBER := 0-1962.0724
1401 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1402 , p5_a4 NUMBER := 0-1962.0724
1403 , p5_a5 NUMBER := 0-1962.0724
1404 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1405 , p5_a7 DATE := fnd_api.g_miss_date
1406 , p5_a8 NUMBER := 0-1962.0724
1407 , p5_a9 DATE := fnd_api.g_miss_date
1408 , p5_a10 NUMBER := 0-1962.0724
1409 , p5_a11 NUMBER := 0-1962.0724
1410 , p5_a12 NUMBER := 0-1962.0724
1411 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1412 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1413 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1414 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1415 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1416 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1417 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1418 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1419 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1420 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1421 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1422 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1423 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1424 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1425 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1427 )
1428 as
1429 ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1430 ddindx binary_integer; indx binary_integer;
1431 begin
1432
1433 -- copy data to the local IN or IN-OUT args, if any
1434
1435
1436
1437
1438
1439 ddp_web_recomms_rec.web_recomm_id := rosetta_g_miss_num_map(p5_a0);
1440 ddp_web_recomms_rec.web_tracking_id := rosetta_g_miss_num_map(p5_a1);
1441 ddp_web_recomms_rec.recomm_object_id := rosetta_g_miss_num_map(p5_a2);
1442 ddp_web_recomms_rec.recomm_type := p5_a3;
1443 ddp_web_recomms_rec.rule_id := rosetta_g_miss_num_map(p5_a4);
1444 ddp_web_recomms_rec.offer_id := rosetta_g_miss_num_map(p5_a5);
1445 ddp_web_recomms_rec.offer_src_code := p5_a6;
1446 ddp_web_recomms_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a7);
1447 ddp_web_recomms_rec.last_updated_by := rosetta_g_miss_num_map(p5_a8);
1448 ddp_web_recomms_rec.creation_date := rosetta_g_miss_date_in_map(p5_a9);
1449 ddp_web_recomms_rec.created_by := rosetta_g_miss_num_map(p5_a10);
1450 ddp_web_recomms_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
1451 ddp_web_recomms_rec.object_version_number := rosetta_g_miss_num_map(p5_a12);
1452 ddp_web_recomms_rec.attribute_category := p5_a13;
1453 ddp_web_recomms_rec.attribute1 := p5_a14;
1454 ddp_web_recomms_rec.attribute2 := p5_a15;
1455 ddp_web_recomms_rec.attribute3 := p5_a16;
1456 ddp_web_recomms_rec.attribute4 := p5_a17;
1457 ddp_web_recomms_rec.attribute5 := p5_a18;
1458 ddp_web_recomms_rec.attribute6 := p5_a19;
1459 ddp_web_recomms_rec.attribute7 := p5_a20;
1460 ddp_web_recomms_rec.attribute8 := p5_a21;
1461 ddp_web_recomms_rec.attribute9 := p5_a22;
1462 ddp_web_recomms_rec.attribute10 := p5_a23;
1463 ddp_web_recomms_rec.attribute11 := p5_a24;
1464 ddp_web_recomms_rec.attribute12 := p5_a25;
1465 ddp_web_recomms_rec.attribute13 := p5_a26;
1466 ddp_web_recomms_rec.attribute14 := p5_a27;
1467 ddp_web_recomms_rec.attribute15 := p5_a28;
1468
1469 -- here's the delegated call to the old PL/SQL routine
1470 ams_web_track_pvt.validate_web_recomms_rec(p_api_version_number,
1471 p_init_msg_list,
1472 x_return_status,
1473 x_msg_count,
1474 x_msg_data,
1475 ddp_web_recomms_rec);
1476
1477 -- copy data back from the local OUT or IN-OUT args, if any
1478
1479
1480
1481
1482
1483 end;
1484
1485 procedure create_web_imp_track(p_api_version_number NUMBER
1486 , p_init_msg_list VARCHAR2
1487 , p_commit VARCHAR2
1488 , p_validation_level NUMBER
1489 , p5_a0 JTF_NUMBER_TABLE
1490 , p5_a1 JTF_NUMBER_TABLE
1491 , p5_a2 JTF_NUMBER_TABLE
1492 , p5_a3 JTF_VARCHAR2_TABLE_100
1493 , p5_a4 JTF_NUMBER_TABLE
1494 , p5_a5 JTF_NUMBER_TABLE
1495 , p5_a6 JTF_VARCHAR2_TABLE_100
1496 , p5_a7 JTF_DATE_TABLE
1497 , p5_a8 JTF_NUMBER_TABLE
1498 , p5_a9 JTF_DATE_TABLE
1499 , p5_a10 JTF_NUMBER_TABLE
1500 , p5_a11 JTF_NUMBER_TABLE
1501 , p5_a12 JTF_NUMBER_TABLE
1502 , p5_a13 JTF_VARCHAR2_TABLE_100
1503 , p5_a14 JTF_VARCHAR2_TABLE_200
1504 , p5_a15 JTF_VARCHAR2_TABLE_200
1505 , p5_a16 JTF_VARCHAR2_TABLE_200
1506 , p5_a17 JTF_VARCHAR2_TABLE_200
1507 , p5_a18 JTF_VARCHAR2_TABLE_200
1508 , p5_a19 JTF_VARCHAR2_TABLE_200
1509 , p5_a20 JTF_VARCHAR2_TABLE_200
1510 , p5_a21 JTF_VARCHAR2_TABLE_200
1511 , p5_a22 JTF_VARCHAR2_TABLE_200
1512 , p5_a23 JTF_VARCHAR2_TABLE_200
1513 , p5_a24 JTF_VARCHAR2_TABLE_200
1514 , p5_a25 JTF_VARCHAR2_TABLE_200
1515 , p5_a26 JTF_VARCHAR2_TABLE_200
1516 , p5_a27 JTF_VARCHAR2_TABLE_200
1517 , p5_a28 JTF_VARCHAR2_TABLE_200
1518 , p6_a0 OUT NOCOPY JTF_NUMBER_TABLE
1519 , p6_a1 OUT NOCOPY JTF_NUMBER_TABLE
1520 , x_return_status OUT NOCOPY VARCHAR2
1521 , x_msg_count OUT NOCOPY NUMBER
1522 , x_msg_data OUT NOCOPY VARCHAR2
1523 , p4_a0 NUMBER := 0-1962.0724
1524 , p4_a1 NUMBER := 0-1962.0724
1525 , p4_a2 VARCHAR2 := fnd_api.g_miss_char
1526 , p4_a3 NUMBER := 0-1962.0724
1527 , p4_a4 NUMBER := 0-1962.0724
1528 , p4_a5 NUMBER := 0-1962.0724
1529 , p4_a6 DATE := fnd_api.g_miss_date
1530 , p4_a7 NUMBER := 0-1962.0724
1531 , p4_a8 DATE := fnd_api.g_miss_date
1532 , p4_a9 NUMBER := 0-1962.0724
1533 , p4_a10 NUMBER := 0-1962.0724
1534 , p4_a11 NUMBER := 0-1962.0724
1535 , p4_a12 VARCHAR2 := fnd_api.g_miss_char
1536 , p4_a13 VARCHAR2 := fnd_api.g_miss_char
1537 , p4_a14 VARCHAR2 := fnd_api.g_miss_char
1538 , p4_a15 VARCHAR2 := fnd_api.g_miss_char
1539 , p4_a16 VARCHAR2 := fnd_api.g_miss_char
1540 , p4_a17 VARCHAR2 := fnd_api.g_miss_char
1541 , p4_a18 VARCHAR2 := fnd_api.g_miss_char
1542 , p4_a19 VARCHAR2 := fnd_api.g_miss_char
1543 , p4_a20 VARCHAR2 := fnd_api.g_miss_char
1544 , p4_a21 VARCHAR2 := fnd_api.g_miss_char
1545 , p4_a22 VARCHAR2 := fnd_api.g_miss_char
1546 , p4_a23 VARCHAR2 := fnd_api.g_miss_char
1547 , p4_a24 VARCHAR2 := fnd_api.g_miss_char
1548 , p4_a25 VARCHAR2 := fnd_api.g_miss_char
1549 , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550 , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551 )
1552 as
1553 ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
1554 ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;
1555 ddx_impr_obj_id_rec ams_web_track_pvt.impr_obj_id_tbl_type;
1556 ddindx binary_integer; indx binary_integer;
1557 begin
1558
1559 -- copy data to the local IN or IN-OUT args, if any
1560
1561
1562
1563
1564 ddp_web_track_rec.web_tracking_id := rosetta_g_miss_num_map(p4_a0);
1565 ddp_web_track_rec.schedule_id := rosetta_g_miss_num_map(p4_a1);
1566 ddp_web_track_rec.schedule_type := p4_a2;
1567 ddp_web_track_rec.party_id := rosetta_g_miss_num_map(p4_a3);
1568 ddp_web_track_rec.placement_id := rosetta_g_miss_num_map(p4_a4);
1569 ddp_web_track_rec.content_item_id := rosetta_g_miss_num_map(p4_a5);
1570 ddp_web_track_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a6);
1571 ddp_web_track_rec.last_updated_by := rosetta_g_miss_num_map(p4_a7);
1572 ddp_web_track_rec.creation_date := rosetta_g_miss_date_in_map(p4_a8);
1573 ddp_web_track_rec.created_by := rosetta_g_miss_num_map(p4_a9);
1574 ddp_web_track_rec.last_update_login := rosetta_g_miss_num_map(p4_a10);
1575 ddp_web_track_rec.object_version_number := rosetta_g_miss_num_map(p4_a11);
1576 ddp_web_track_rec.attribute_category := p4_a12;
1577 ddp_web_track_rec.attribute1 := p4_a13;
1578 ddp_web_track_rec.attribute2 := p4_a14;
1579 ddp_web_track_rec.attribute3 := p4_a15;
1580 ddp_web_track_rec.attribute4 := p4_a16;
1581 ddp_web_track_rec.attribute5 := p4_a17;
1582 ddp_web_track_rec.attribute6 := p4_a18;
1583 ddp_web_track_rec.attribute7 := p4_a19;
1584 ddp_web_track_rec.attribute8 := p4_a20;
1585 ddp_web_track_rec.attribute9 := p4_a21;
1586 ddp_web_track_rec.attribute10 := p4_a22;
1587 ddp_web_track_rec.attribute11 := p4_a23;
1588 ddp_web_track_rec.attribute12 := p4_a24;
1589 ddp_web_track_rec.attribute13 := p4_a25;
1590 ddp_web_track_rec.attribute14 := p4_a26;
1591 ddp_web_track_rec.attribute15 := p4_a27;
1592
1593 ams_web_track_pvt_w.rosetta_table_copy_in_p13(ddp_web_recomms_tbl, p5_a0
1594 , p5_a1
1595 , p5_a2
1596 , p5_a3
1597 , p5_a4
1598 , p5_a5
1599 , p5_a6
1600 , p5_a7
1601 , p5_a8
1602 , p5_a9
1603 , p5_a10
1604 , p5_a11
1605 , p5_a12
1606 , p5_a13
1607 , p5_a14
1608 , p5_a15
1609 , p5_a16
1610 , p5_a17
1611 , p5_a18
1612 , p5_a19
1613 , p5_a20
1614 , p5_a21
1615 , p5_a22
1616 , p5_a23
1617 , p5_a24
1618 , p5_a25
1619 , p5_a26
1620 , p5_a27
1621 , p5_a28
1622 );
1623
1624
1625
1626
1627
1628 -- here's the delegated call to the old PL/SQL routine
1629 ams_web_track_pvt.create_web_imp_track(p_api_version_number,
1630 p_init_msg_list,
1631 p_commit,
1632 p_validation_level,
1633 ddp_web_track_rec,
1634 ddp_web_recomms_tbl,
1635 ddx_impr_obj_id_rec,
1636 x_return_status,
1637 x_msg_count,
1638 x_msg_data);
1639
1640 -- copy data back from the local OUT or IN-OUT args, if any
1641
1642
1643
1644
1645
1646
1647 ams_web_track_pvt_w.rosetta_table_copy_out_p23(ddx_impr_obj_id_rec, p6_a0
1648 , p6_a1
1649 );
1650
1651
1652
1653 end;
1654
1655 end ams_web_track_pvt_w;