[Home] [Help]
PACKAGE BODY: APPS.AS_SALES_LEADS_PUB_W
Source
1 package body as_sales_leads_pub_w as
2 /* $Header: asxwslmb.pls 115.14 2003/09/18 22:44:07 ckapoor 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 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p3(t out nocopy as_sales_leads_pub.sales_lead_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_DATE_TABLE
24 , a2 JTF_NUMBER_TABLE
25 , a3 JTF_DATE_TABLE
26 , a4 JTF_NUMBER_TABLE
27 , a5 JTF_NUMBER_TABLE
28 , a6 JTF_NUMBER_TABLE
29 , a7 JTF_NUMBER_TABLE
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_DATE_TABLE
32 , a10 JTF_VARCHAR2_TABLE_100
33 , a11 JTF_VARCHAR2_TABLE_100
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_NUMBER_TABLE
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_VARCHAR2_TABLE_300
39 , a17 JTF_VARCHAR2_TABLE_100
40 , a18 JTF_VARCHAR2_TABLE_100
41 , a19 JTF_NUMBER_TABLE
42 , a20 JTF_VARCHAR2_TABLE_100
43 , a21 JTF_VARCHAR2_TABLE_100
44 , a22 JTF_VARCHAR2_TABLE_100
45 , a23 JTF_NUMBER_TABLE
46 , a24 JTF_VARCHAR2_TABLE_100
47 , a25 JTF_VARCHAR2_TABLE_100
48 , a26 JTF_VARCHAR2_TABLE_2000
49 , a27 JTF_VARCHAR2_TABLE_100
50 , a28 JTF_VARCHAR2_TABLE_200
51 , a29 JTF_VARCHAR2_TABLE_200
52 , a30 JTF_VARCHAR2_TABLE_200
53 , a31 JTF_VARCHAR2_TABLE_200
54 , a32 JTF_VARCHAR2_TABLE_200
55 , a33 JTF_VARCHAR2_TABLE_200
56 , a34 JTF_VARCHAR2_TABLE_200
57 , a35 JTF_VARCHAR2_TABLE_200
58 , a36 JTF_VARCHAR2_TABLE_200
59 , a37 JTF_VARCHAR2_TABLE_200
60 , a38 JTF_VARCHAR2_TABLE_200
61 , a39 JTF_VARCHAR2_TABLE_200
62 , a40 JTF_VARCHAR2_TABLE_200
63 , a41 JTF_VARCHAR2_TABLE_200
64 , a42 JTF_VARCHAR2_TABLE_200
65 , a43 JTF_NUMBER_TABLE
66 , a44 JTF_NUMBER_TABLE
67 , a45 JTF_NUMBER_TABLE
68 , a46 JTF_DATE_TABLE
69 , a47 JTF_VARCHAR2_TABLE_100
70 , a48 JTF_VARCHAR2_TABLE_100
71 , a49 JTF_VARCHAR2_TABLE_100
72 , a50 JTF_NUMBER_TABLE
73 , a51 JTF_NUMBER_TABLE
74 , a52 JTF_VARCHAR2_TABLE_100
75 , a53 JTF_VARCHAR2_TABLE_100
76 , a54 JTF_VARCHAR2_TABLE_100
77 , a55 JTF_VARCHAR2_TABLE_100
78 , a56 JTF_VARCHAR2_TABLE_100
79 , a57 JTF_NUMBER_TABLE
80 , a58 JTF_NUMBER_TABLE
81 , a59 JTF_NUMBER_TABLE
82 , a60 JTF_VARCHAR2_TABLE_100
83 , a61 JTF_VARCHAR2_TABLE_100
84 , a62 JTF_VARCHAR2_TABLE_100
85 , a63 JTF_VARCHAR2_TABLE_100
86 , a64 JTF_VARCHAR2_TABLE_100
87 , a65 JTF_VARCHAR2_TABLE_100
88 , a66 JTF_VARCHAR2_TABLE_100
89 , a67 JTF_VARCHAR2_TABLE_100
90 , a68 JTF_NUMBER_TABLE
91 , a69 JTF_NUMBER_TABLE
92 , a70 JTF_NUMBER_TABLE
93 , a71 JTF_NUMBER_TABLE
94 , a72 JTF_VARCHAR2_TABLE_100
95 , a73 JTF_VARCHAR2_TABLE_100
96 , a74 JTF_VARCHAR2_TABLE_100
97 , a75 JTF_VARCHAR2_TABLE_100
98 , a76 JTF_NUMBER_TABLE
99 , a77 JTF_NUMBER_TABLE
100 , a78 JTF_NUMBER_TABLE
101 , a79 JTF_DATE_TABLE
102 , a80 JTF_VARCHAR2_TABLE_100
103 , a81 JTF_VARCHAR2_TABLE_100
104 , a82 JTF_NUMBER_TABLE
105 , a83 JTF_DATE_TABLE
106 , a84 JTF_DATE_TABLE
107 , a85 JTF_VARCHAR2_TABLE_100
108 , a86 JTF_NUMBER_TABLE
109 , a87 JTF_NUMBER_TABLE
110 , a88 JTF_NUMBER_TABLE
111 , a89 JTF_VARCHAR2_TABLE_100
112 , a90 JTF_VARCHAR2_TABLE_100
113 , a91 JTF_NUMBER_TABLE
114 , a92 JTF_NUMBER_TABLE
115 ) as
116 ddindx binary_integer; indx binary_integer;
117 begin
118 if a0 is not null and a0.count > 0 then
119 if a0.count > 0 then
120 indx := a0.first;
121 ddindx := 1;
122 while true loop
123 t(ddindx).sales_lead_id := rosetta_g_miss_num_map(a0(indx));
124 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));
125 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
126 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a3(indx));
127 t(ddindx).created_by := rosetta_g_miss_num_map(a4(indx));
128 t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
129 t(ddindx).request_id := rosetta_g_miss_num_map(a6(indx));
130 t(ddindx).program_application_id := rosetta_g_miss_num_map(a7(indx));
131 t(ddindx).program_id := rosetta_g_miss_num_map(a8(indx));
132 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));
133 t(ddindx).lead_number := a10(indx);
134 t(ddindx).status_code := a11(indx);
135 t(ddindx).customer_id := rosetta_g_miss_num_map(a12(indx));
136 t(ddindx).address_id := rosetta_g_miss_num_map(a13(indx));
137 t(ddindx).source_promotion_id := rosetta_g_miss_num_map(a14(indx));
138 t(ddindx).initiating_contact_id := rosetta_g_miss_num_map(a15(indx));
139 t(ddindx).orig_system_reference := a16(indx);
140 t(ddindx).contact_role_code := a17(indx);
141 t(ddindx).channel_code := a18(indx);
142 t(ddindx).budget_amount := rosetta_g_miss_num_map(a19(indx));
143 t(ddindx).currency_code := a20(indx);
144 t(ddindx).decision_timeframe_code := a21(indx);
145 t(ddindx).close_reason := a22(indx);
146 t(ddindx).lead_rank_id := rosetta_g_miss_num_map(a23(indx));
147 t(ddindx).lead_rank_code := a24(indx);
148 t(ddindx).parent_project := a25(indx);
149 t(ddindx).description := a26(indx);
150 t(ddindx).attribute_category := a27(indx);
151 t(ddindx).attribute1 := a28(indx);
152 t(ddindx).attribute2 := a29(indx);
153 t(ddindx).attribute3 := a30(indx);
154 t(ddindx).attribute4 := a31(indx);
155 t(ddindx).attribute5 := a32(indx);
156 t(ddindx).attribute6 := a33(indx);
157 t(ddindx).attribute7 := a34(indx);
158 t(ddindx).attribute8 := a35(indx);
159 t(ddindx).attribute9 := a36(indx);
160 t(ddindx).attribute10 := a37(indx);
161 t(ddindx).attribute11 := a38(indx);
162 t(ddindx).attribute12 := a39(indx);
163 t(ddindx).attribute13 := a40(indx);
164 t(ddindx).attribute14 := a41(indx);
165 t(ddindx).attribute15 := a42(indx);
166 t(ddindx).assign_to_person_id := rosetta_g_miss_num_map(a43(indx));
167 t(ddindx).assign_to_salesforce_id := rosetta_g_miss_num_map(a44(indx));
168 t(ddindx).assign_sales_group_id := rosetta_g_miss_num_map(a45(indx));
169 t(ddindx).assign_date := rosetta_g_miss_date_in_map(a46(indx));
170 t(ddindx).budget_status_code := a47(indx);
171 t(ddindx).accept_flag := a48(indx);
172 t(ddindx).vehicle_response_code := a49(indx);
173 t(ddindx).total_score := rosetta_g_miss_num_map(a50(indx));
174 t(ddindx).scorecard_id := rosetta_g_miss_num_map(a51(indx));
175 t(ddindx).keep_flag := a52(indx);
176 t(ddindx).urgent_flag := a53(indx);
177 t(ddindx).import_flag := a54(indx);
178 t(ddindx).reject_reason_code := a55(indx);
179 t(ddindx).deleted_flag := a56(indx);
180 t(ddindx).offer_id := rosetta_g_miss_num_map(a57(indx));
181 t(ddindx).incumbent_partner_party_id := rosetta_g_miss_num_map(a58(indx));
182 t(ddindx).incumbent_partner_resource_id := rosetta_g_miss_num_map(a59(indx));
183 t(ddindx).prm_exec_sponsor_flag := a60(indx);
184 t(ddindx).prm_prj_lead_in_place_flag := a61(indx);
185 t(ddindx).prm_sales_lead_type := a62(indx);
186 t(ddindx).prm_ind_classification_code := a63(indx);
187 t(ddindx).qualified_flag := a64(indx);
188 t(ddindx).orig_system_code := a65(indx);
189 t(ddindx).prm_assignment_type := a66(indx);
190 t(ddindx).auto_assignment_type := a67(indx);
191 t(ddindx).primary_contact_party_id := rosetta_g_miss_num_map(a68(indx));
192 t(ddindx).primary_cnt_person_party_id := rosetta_g_miss_num_map(a69(indx));
193 t(ddindx).primary_contact_phone_id := rosetta_g_miss_num_map(a70(indx));
194 t(ddindx).referred_by := rosetta_g_miss_num_map(a71(indx));
195 t(ddindx).referral_type := a72(indx);
196 t(ddindx).referral_status := a73(indx);
197 t(ddindx).ref_decline_reason := a74(indx);
198 t(ddindx).ref_comm_ltr_status := a75(indx);
199 t(ddindx).ref_order_number := rosetta_g_miss_num_map(a76(indx));
200 t(ddindx).ref_order_amt := rosetta_g_miss_num_map(a77(indx));
201 t(ddindx).ref_comm_amt := rosetta_g_miss_num_map(a78(indx));
202 t(ddindx).lead_date := rosetta_g_miss_date_in_map(a79(indx));
203 t(ddindx).source_system := a80(indx);
204 t(ddindx).country := a81(indx);
205 t(ddindx).total_amount := rosetta_g_miss_num_map(a82(indx));
206 t(ddindx).expiration_date := rosetta_g_miss_date_in_map(a83(indx));
207 t(ddindx).lead_engine_run_date := rosetta_g_miss_date_in_map(a84(indx));
208 t(ddindx).lead_rank_ind := a85(indx);
209 t(ddindx).current_reroutes := rosetta_g_miss_num_map(a86(indx));
210 t(ddindx).marketing_score := rosetta_g_miss_num_map(a87(indx));
211 t(ddindx).interaction_score := rosetta_g_miss_num_map(a88(indx));
212 t(ddindx).source_primary_reference := a89(indx);
213 t(ddindx).source_secondary_reference := a90(indx);
214 t(ddindx).sales_methodology_id := rosetta_g_miss_num_map(a91(indx));
215 t(ddindx).sales_stage_id := rosetta_g_miss_num_map(a92(indx));
216 ddindx := ddindx+1;
217 if a0.last =indx
218 then exit;
219 end if;
220 indx := a0.next(indx);
221 end loop;
222 end if;
223 end if;
224 end rosetta_table_copy_in_p3;
225 procedure rosetta_table_copy_out_p3(t as_sales_leads_pub.sales_lead_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
226 , a1 out nocopy JTF_DATE_TABLE
227 , a2 out nocopy JTF_NUMBER_TABLE
228 , a3 out nocopy JTF_DATE_TABLE
229 , a4 out nocopy JTF_NUMBER_TABLE
230 , a5 out nocopy JTF_NUMBER_TABLE
231 , a6 out nocopy JTF_NUMBER_TABLE
232 , a7 out nocopy JTF_NUMBER_TABLE
233 , a8 out nocopy JTF_NUMBER_TABLE
234 , a9 out nocopy JTF_DATE_TABLE
235 , a10 out nocopy JTF_VARCHAR2_TABLE_100
236 , a11 out nocopy JTF_VARCHAR2_TABLE_100
237 , a12 out nocopy JTF_NUMBER_TABLE
238 , a13 out nocopy JTF_NUMBER_TABLE
239 , a14 out nocopy JTF_NUMBER_TABLE
240 , a15 out nocopy JTF_NUMBER_TABLE
241 , a16 out nocopy JTF_VARCHAR2_TABLE_300
242 , a17 out nocopy JTF_VARCHAR2_TABLE_100
243 , a18 out nocopy JTF_VARCHAR2_TABLE_100
244 , a19 out nocopy JTF_NUMBER_TABLE
245 , a20 out nocopy JTF_VARCHAR2_TABLE_100
246 , a21 out nocopy JTF_VARCHAR2_TABLE_100
247 , a22 out nocopy JTF_VARCHAR2_TABLE_100
248 , a23 out nocopy JTF_NUMBER_TABLE
249 , a24 out nocopy JTF_VARCHAR2_TABLE_100
250 , a25 out nocopy JTF_VARCHAR2_TABLE_100
251 , a26 out nocopy JTF_VARCHAR2_TABLE_2000
252 , a27 out nocopy JTF_VARCHAR2_TABLE_100
253 , a28 out nocopy JTF_VARCHAR2_TABLE_200
254 , a29 out nocopy JTF_VARCHAR2_TABLE_200
255 , a30 out nocopy JTF_VARCHAR2_TABLE_200
256 , a31 out nocopy JTF_VARCHAR2_TABLE_200
257 , a32 out nocopy JTF_VARCHAR2_TABLE_200
258 , a33 out nocopy JTF_VARCHAR2_TABLE_200
259 , a34 out nocopy JTF_VARCHAR2_TABLE_200
260 , a35 out nocopy JTF_VARCHAR2_TABLE_200
261 , a36 out nocopy JTF_VARCHAR2_TABLE_200
262 , a37 out nocopy JTF_VARCHAR2_TABLE_200
263 , a38 out nocopy JTF_VARCHAR2_TABLE_200
264 , a39 out nocopy JTF_VARCHAR2_TABLE_200
265 , a40 out nocopy JTF_VARCHAR2_TABLE_200
266 , a41 out nocopy JTF_VARCHAR2_TABLE_200
267 , a42 out nocopy JTF_VARCHAR2_TABLE_200
268 , a43 out nocopy JTF_NUMBER_TABLE
269 , a44 out nocopy JTF_NUMBER_TABLE
270 , a45 out nocopy JTF_NUMBER_TABLE
271 , a46 out nocopy JTF_DATE_TABLE
272 , a47 out nocopy JTF_VARCHAR2_TABLE_100
273 , a48 out nocopy JTF_VARCHAR2_TABLE_100
274 , a49 out nocopy JTF_VARCHAR2_TABLE_100
275 , a50 out nocopy JTF_NUMBER_TABLE
276 , a51 out nocopy JTF_NUMBER_TABLE
277 , a52 out nocopy JTF_VARCHAR2_TABLE_100
278 , a53 out nocopy JTF_VARCHAR2_TABLE_100
279 , a54 out nocopy JTF_VARCHAR2_TABLE_100
280 , a55 out nocopy JTF_VARCHAR2_TABLE_100
281 , a56 out nocopy JTF_VARCHAR2_TABLE_100
282 , a57 out nocopy JTF_NUMBER_TABLE
283 , a58 out nocopy JTF_NUMBER_TABLE
284 , a59 out nocopy JTF_NUMBER_TABLE
285 , a60 out nocopy JTF_VARCHAR2_TABLE_100
286 , a61 out nocopy JTF_VARCHAR2_TABLE_100
287 , a62 out nocopy JTF_VARCHAR2_TABLE_100
288 , a63 out nocopy JTF_VARCHAR2_TABLE_100
289 , a64 out nocopy JTF_VARCHAR2_TABLE_100
290 , a65 out nocopy JTF_VARCHAR2_TABLE_100
291 , a66 out nocopy JTF_VARCHAR2_TABLE_100
292 , a67 out nocopy JTF_VARCHAR2_TABLE_100
293 , a68 out nocopy JTF_NUMBER_TABLE
294 , a69 out nocopy JTF_NUMBER_TABLE
295 , a70 out nocopy JTF_NUMBER_TABLE
296 , a71 out nocopy JTF_NUMBER_TABLE
297 , a72 out nocopy JTF_VARCHAR2_TABLE_100
298 , a73 out nocopy JTF_VARCHAR2_TABLE_100
299 , a74 out nocopy JTF_VARCHAR2_TABLE_100
300 , a75 out nocopy JTF_VARCHAR2_TABLE_100
301 , a76 out nocopy JTF_NUMBER_TABLE
302 , a77 out nocopy JTF_NUMBER_TABLE
303 , a78 out nocopy JTF_NUMBER_TABLE
304 , a79 out nocopy JTF_DATE_TABLE
305 , a80 out nocopy JTF_VARCHAR2_TABLE_100
306 , a81 out nocopy JTF_VARCHAR2_TABLE_100
307 , a82 out nocopy JTF_NUMBER_TABLE
308 , a83 out nocopy JTF_DATE_TABLE
309 , a84 out nocopy JTF_DATE_TABLE
310 , a85 out nocopy JTF_VARCHAR2_TABLE_100
311 , a86 out nocopy JTF_NUMBER_TABLE
312 , a87 out nocopy JTF_NUMBER_TABLE
313 , a88 out nocopy JTF_NUMBER_TABLE
314 , a89 out nocopy JTF_VARCHAR2_TABLE_100
315 , a90 out nocopy JTF_VARCHAR2_TABLE_100
316 , a91 out nocopy JTF_NUMBER_TABLE
317 , a92 out nocopy JTF_NUMBER_TABLE
318 ) as
319 ddindx binary_integer; indx binary_integer;
320 begin
321 if t is null or t.count = 0 then
322 a0 := JTF_NUMBER_TABLE();
323 a1 := JTF_DATE_TABLE();
324 a2 := JTF_NUMBER_TABLE();
325 a3 := JTF_DATE_TABLE();
326 a4 := JTF_NUMBER_TABLE();
327 a5 := JTF_NUMBER_TABLE();
328 a6 := JTF_NUMBER_TABLE();
329 a7 := JTF_NUMBER_TABLE();
330 a8 := JTF_NUMBER_TABLE();
331 a9 := JTF_DATE_TABLE();
332 a10 := JTF_VARCHAR2_TABLE_100();
333 a11 := JTF_VARCHAR2_TABLE_100();
334 a12 := JTF_NUMBER_TABLE();
335 a13 := JTF_NUMBER_TABLE();
336 a14 := JTF_NUMBER_TABLE();
337 a15 := JTF_NUMBER_TABLE();
338 a16 := JTF_VARCHAR2_TABLE_300();
339 a17 := JTF_VARCHAR2_TABLE_100();
340 a18 := JTF_VARCHAR2_TABLE_100();
341 a19 := JTF_NUMBER_TABLE();
342 a20 := JTF_VARCHAR2_TABLE_100();
343 a21 := JTF_VARCHAR2_TABLE_100();
344 a22 := JTF_VARCHAR2_TABLE_100();
345 a23 := JTF_NUMBER_TABLE();
346 a24 := JTF_VARCHAR2_TABLE_100();
347 a25 := JTF_VARCHAR2_TABLE_100();
348 a26 := JTF_VARCHAR2_TABLE_2000();
352 a30 := JTF_VARCHAR2_TABLE_200();
349 a27 := JTF_VARCHAR2_TABLE_100();
350 a28 := JTF_VARCHAR2_TABLE_200();
351 a29 := JTF_VARCHAR2_TABLE_200();
353 a31 := JTF_VARCHAR2_TABLE_200();
354 a32 := JTF_VARCHAR2_TABLE_200();
355 a33 := JTF_VARCHAR2_TABLE_200();
356 a34 := JTF_VARCHAR2_TABLE_200();
357 a35 := JTF_VARCHAR2_TABLE_200();
358 a36 := JTF_VARCHAR2_TABLE_200();
359 a37 := JTF_VARCHAR2_TABLE_200();
360 a38 := JTF_VARCHAR2_TABLE_200();
361 a39 := JTF_VARCHAR2_TABLE_200();
362 a40 := JTF_VARCHAR2_TABLE_200();
363 a41 := JTF_VARCHAR2_TABLE_200();
364 a42 := JTF_VARCHAR2_TABLE_200();
365 a43 := JTF_NUMBER_TABLE();
366 a44 := JTF_NUMBER_TABLE();
367 a45 := JTF_NUMBER_TABLE();
368 a46 := JTF_DATE_TABLE();
369 a47 := JTF_VARCHAR2_TABLE_100();
370 a48 := JTF_VARCHAR2_TABLE_100();
371 a49 := JTF_VARCHAR2_TABLE_100();
372 a50 := JTF_NUMBER_TABLE();
373 a51 := JTF_NUMBER_TABLE();
374 a52 := JTF_VARCHAR2_TABLE_100();
375 a53 := JTF_VARCHAR2_TABLE_100();
376 a54 := JTF_VARCHAR2_TABLE_100();
377 a55 := JTF_VARCHAR2_TABLE_100();
378 a56 := JTF_VARCHAR2_TABLE_100();
379 a57 := JTF_NUMBER_TABLE();
380 a58 := JTF_NUMBER_TABLE();
381 a59 := JTF_NUMBER_TABLE();
382 a60 := JTF_VARCHAR2_TABLE_100();
383 a61 := JTF_VARCHAR2_TABLE_100();
384 a62 := JTF_VARCHAR2_TABLE_100();
385 a63 := JTF_VARCHAR2_TABLE_100();
386 a64 := JTF_VARCHAR2_TABLE_100();
387 a65 := JTF_VARCHAR2_TABLE_100();
388 a66 := JTF_VARCHAR2_TABLE_100();
389 a67 := JTF_VARCHAR2_TABLE_100();
390 a68 := JTF_NUMBER_TABLE();
391 a69 := JTF_NUMBER_TABLE();
392 a70 := JTF_NUMBER_TABLE();
393 a71 := JTF_NUMBER_TABLE();
394 a72 := JTF_VARCHAR2_TABLE_100();
395 a73 := JTF_VARCHAR2_TABLE_100();
396 a74 := JTF_VARCHAR2_TABLE_100();
397 a75 := JTF_VARCHAR2_TABLE_100();
398 a76 := JTF_NUMBER_TABLE();
399 a77 := JTF_NUMBER_TABLE();
400 a78 := JTF_NUMBER_TABLE();
401 a79 := JTF_DATE_TABLE();
402 a80 := JTF_VARCHAR2_TABLE_100();
403 a81 := JTF_VARCHAR2_TABLE_100();
404 a82 := JTF_NUMBER_TABLE();
405 a83 := JTF_DATE_TABLE();
406 a84 := JTF_DATE_TABLE();
407 a85 := JTF_VARCHAR2_TABLE_100();
408 a86 := JTF_NUMBER_TABLE();
409 a87 := JTF_NUMBER_TABLE();
410 a88 := JTF_NUMBER_TABLE();
411 a89 := JTF_VARCHAR2_TABLE_100();
412 a90 := JTF_VARCHAR2_TABLE_100();
413 a91 := JTF_NUMBER_TABLE();
414 a92 := JTF_NUMBER_TABLE();
415 else
416 a0 := JTF_NUMBER_TABLE();
417 a1 := JTF_DATE_TABLE();
418 a2 := JTF_NUMBER_TABLE();
419 a3 := JTF_DATE_TABLE();
420 a4 := JTF_NUMBER_TABLE();
421 a5 := JTF_NUMBER_TABLE();
422 a6 := JTF_NUMBER_TABLE();
423 a7 := JTF_NUMBER_TABLE();
424 a8 := JTF_NUMBER_TABLE();
425 a9 := JTF_DATE_TABLE();
426 a10 := JTF_VARCHAR2_TABLE_100();
427 a11 := JTF_VARCHAR2_TABLE_100();
428 a12 := JTF_NUMBER_TABLE();
429 a13 := JTF_NUMBER_TABLE();
430 a14 := JTF_NUMBER_TABLE();
431 a15 := JTF_NUMBER_TABLE();
432 a16 := JTF_VARCHAR2_TABLE_300();
433 a17 := JTF_VARCHAR2_TABLE_100();
434 a18 := JTF_VARCHAR2_TABLE_100();
435 a19 := JTF_NUMBER_TABLE();
436 a20 := JTF_VARCHAR2_TABLE_100();
437 a21 := JTF_VARCHAR2_TABLE_100();
438 a22 := JTF_VARCHAR2_TABLE_100();
439 a23 := JTF_NUMBER_TABLE();
440 a24 := JTF_VARCHAR2_TABLE_100();
441 a25 := JTF_VARCHAR2_TABLE_100();
442 a26 := JTF_VARCHAR2_TABLE_2000();
443 a27 := JTF_VARCHAR2_TABLE_100();
444 a28 := JTF_VARCHAR2_TABLE_200();
445 a29 := JTF_VARCHAR2_TABLE_200();
446 a30 := JTF_VARCHAR2_TABLE_200();
447 a31 := JTF_VARCHAR2_TABLE_200();
448 a32 := JTF_VARCHAR2_TABLE_200();
449 a33 := JTF_VARCHAR2_TABLE_200();
450 a34 := JTF_VARCHAR2_TABLE_200();
451 a35 := JTF_VARCHAR2_TABLE_200();
452 a36 := JTF_VARCHAR2_TABLE_200();
453 a37 := JTF_VARCHAR2_TABLE_200();
454 a38 := JTF_VARCHAR2_TABLE_200();
455 a39 := JTF_VARCHAR2_TABLE_200();
456 a40 := JTF_VARCHAR2_TABLE_200();
457 a41 := JTF_VARCHAR2_TABLE_200();
458 a42 := JTF_VARCHAR2_TABLE_200();
459 a43 := JTF_NUMBER_TABLE();
460 a44 := JTF_NUMBER_TABLE();
461 a45 := JTF_NUMBER_TABLE();
462 a46 := JTF_DATE_TABLE();
463 a47 := JTF_VARCHAR2_TABLE_100();
464 a48 := JTF_VARCHAR2_TABLE_100();
465 a49 := JTF_VARCHAR2_TABLE_100();
466 a50 := JTF_NUMBER_TABLE();
467 a51 := JTF_NUMBER_TABLE();
468 a52 := JTF_VARCHAR2_TABLE_100();
469 a53 := JTF_VARCHAR2_TABLE_100();
470 a54 := JTF_VARCHAR2_TABLE_100();
471 a55 := JTF_VARCHAR2_TABLE_100();
472 a56 := JTF_VARCHAR2_TABLE_100();
473 a57 := JTF_NUMBER_TABLE();
474 a58 := JTF_NUMBER_TABLE();
475 a59 := JTF_NUMBER_TABLE();
476 a60 := JTF_VARCHAR2_TABLE_100();
477 a61 := JTF_VARCHAR2_TABLE_100();
478 a62 := JTF_VARCHAR2_TABLE_100();
482 a66 := JTF_VARCHAR2_TABLE_100();
479 a63 := JTF_VARCHAR2_TABLE_100();
480 a64 := JTF_VARCHAR2_TABLE_100();
481 a65 := JTF_VARCHAR2_TABLE_100();
483 a67 := JTF_VARCHAR2_TABLE_100();
484 a68 := JTF_NUMBER_TABLE();
485 a69 := JTF_NUMBER_TABLE();
486 a70 := JTF_NUMBER_TABLE();
487 a71 := JTF_NUMBER_TABLE();
488 a72 := JTF_VARCHAR2_TABLE_100();
489 a73 := JTF_VARCHAR2_TABLE_100();
490 a74 := JTF_VARCHAR2_TABLE_100();
491 a75 := JTF_VARCHAR2_TABLE_100();
492 a76 := JTF_NUMBER_TABLE();
493 a77 := JTF_NUMBER_TABLE();
494 a78 := JTF_NUMBER_TABLE();
495 a79 := JTF_DATE_TABLE();
496 a80 := JTF_VARCHAR2_TABLE_100();
497 a81 := JTF_VARCHAR2_TABLE_100();
498 a82 := JTF_NUMBER_TABLE();
499 a83 := JTF_DATE_TABLE();
500 a84 := JTF_DATE_TABLE();
501 a85 := JTF_VARCHAR2_TABLE_100();
502 a86 := JTF_NUMBER_TABLE();
503 a87 := JTF_NUMBER_TABLE();
504 a88 := JTF_NUMBER_TABLE();
505 a89 := JTF_VARCHAR2_TABLE_100();
506 a90 := JTF_VARCHAR2_TABLE_100();
507 a91 := JTF_NUMBER_TABLE();
508 a92 := JTF_NUMBER_TABLE();
509 if t.count > 0 then
510 a0.extend(t.count);
511 a1.extend(t.count);
512 a2.extend(t.count);
513 a3.extend(t.count);
514 a4.extend(t.count);
515 a5.extend(t.count);
516 a6.extend(t.count);
517 a7.extend(t.count);
518 a8.extend(t.count);
519 a9.extend(t.count);
520 a10.extend(t.count);
521 a11.extend(t.count);
522 a12.extend(t.count);
523 a13.extend(t.count);
524 a14.extend(t.count);
525 a15.extend(t.count);
526 a16.extend(t.count);
527 a17.extend(t.count);
528 a18.extend(t.count);
529 a19.extend(t.count);
530 a20.extend(t.count);
531 a21.extend(t.count);
532 a22.extend(t.count);
533 a23.extend(t.count);
534 a24.extend(t.count);
535 a25.extend(t.count);
536 a26.extend(t.count);
537 a27.extend(t.count);
538 a28.extend(t.count);
539 a29.extend(t.count);
540 a30.extend(t.count);
541 a31.extend(t.count);
542 a32.extend(t.count);
543 a33.extend(t.count);
544 a34.extend(t.count);
545 a35.extend(t.count);
546 a36.extend(t.count);
547 a37.extend(t.count);
548 a38.extend(t.count);
549 a39.extend(t.count);
550 a40.extend(t.count);
551 a41.extend(t.count);
552 a42.extend(t.count);
553 a43.extend(t.count);
554 a44.extend(t.count);
555 a45.extend(t.count);
556 a46.extend(t.count);
557 a47.extend(t.count);
558 a48.extend(t.count);
559 a49.extend(t.count);
560 a50.extend(t.count);
561 a51.extend(t.count);
562 a52.extend(t.count);
563 a53.extend(t.count);
564 a54.extend(t.count);
565 a55.extend(t.count);
566 a56.extend(t.count);
567 a57.extend(t.count);
568 a58.extend(t.count);
569 a59.extend(t.count);
570 a60.extend(t.count);
571 a61.extend(t.count);
572 a62.extend(t.count);
573 a63.extend(t.count);
574 a64.extend(t.count);
575 a65.extend(t.count);
576 a66.extend(t.count);
577 a67.extend(t.count);
578 a68.extend(t.count);
579 a69.extend(t.count);
580 a70.extend(t.count);
581 a71.extend(t.count);
582 a72.extend(t.count);
583 a73.extend(t.count);
584 a74.extend(t.count);
585 a75.extend(t.count);
586 a76.extend(t.count);
587 a77.extend(t.count);
588 a78.extend(t.count);
589 a79.extend(t.count);
590 a80.extend(t.count);
591 a81.extend(t.count);
592 a82.extend(t.count);
593 a83.extend(t.count);
594 a84.extend(t.count);
595 a85.extend(t.count);
596 a86.extend(t.count);
597 a87.extend(t.count);
598 a88.extend(t.count);
599 a89.extend(t.count);
600 a90.extend(t.count);
601 a91.extend(t.count);
602 a92.extend(t.count);
603 ddindx := t.first;
604 indx := 1;
605 while true loop
606 a0(indx) := rosetta_g_miss_num_map(t(ddindx).sales_lead_id);
607 a1(indx) := t(ddindx).last_update_date;
608 a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
609 a3(indx) := t(ddindx).creation_date;
610 a4(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
611 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
612 a6(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
613 a7(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
614 a8(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
615 a9(indx) := t(ddindx).program_update_date;
619 a13(indx) := rosetta_g_miss_num_map(t(ddindx).address_id);
616 a10(indx) := t(ddindx).lead_number;
617 a11(indx) := t(ddindx).status_code;
618 a12(indx) := rosetta_g_miss_num_map(t(ddindx).customer_id);
620 a14(indx) := rosetta_g_miss_num_map(t(ddindx).source_promotion_id);
621 a15(indx) := rosetta_g_miss_num_map(t(ddindx).initiating_contact_id);
622 a16(indx) := t(ddindx).orig_system_reference;
623 a17(indx) := t(ddindx).contact_role_code;
624 a18(indx) := t(ddindx).channel_code;
625 a19(indx) := rosetta_g_miss_num_map(t(ddindx).budget_amount);
626 a20(indx) := t(ddindx).currency_code;
627 a21(indx) := t(ddindx).decision_timeframe_code;
628 a22(indx) := t(ddindx).close_reason;
629 a23(indx) := rosetta_g_miss_num_map(t(ddindx).lead_rank_id);
630 a24(indx) := t(ddindx).lead_rank_code;
631 a25(indx) := t(ddindx).parent_project;
632 a26(indx) := t(ddindx).description;
633 a27(indx) := t(ddindx).attribute_category;
634 a28(indx) := t(ddindx).attribute1;
635 a29(indx) := t(ddindx).attribute2;
636 a30(indx) := t(ddindx).attribute3;
637 a31(indx) := t(ddindx).attribute4;
638 a32(indx) := t(ddindx).attribute5;
639 a33(indx) := t(ddindx).attribute6;
640 a34(indx) := t(ddindx).attribute7;
641 a35(indx) := t(ddindx).attribute8;
642 a36(indx) := t(ddindx).attribute9;
643 a37(indx) := t(ddindx).attribute10;
644 a38(indx) := t(ddindx).attribute11;
645 a39(indx) := t(ddindx).attribute12;
646 a40(indx) := t(ddindx).attribute13;
647 a41(indx) := t(ddindx).attribute14;
648 a42(indx) := t(ddindx).attribute15;
649 a43(indx) := rosetta_g_miss_num_map(t(ddindx).assign_to_person_id);
650 a44(indx) := rosetta_g_miss_num_map(t(ddindx).assign_to_salesforce_id);
651 a45(indx) := rosetta_g_miss_num_map(t(ddindx).assign_sales_group_id);
652 a46(indx) := t(ddindx).assign_date;
653 a47(indx) := t(ddindx).budget_status_code;
654 a48(indx) := t(ddindx).accept_flag;
655 a49(indx) := t(ddindx).vehicle_response_code;
656 a50(indx) := rosetta_g_miss_num_map(t(ddindx).total_score);
657 a51(indx) := rosetta_g_miss_num_map(t(ddindx).scorecard_id);
658 a52(indx) := t(ddindx).keep_flag;
659 a53(indx) := t(ddindx).urgent_flag;
660 a54(indx) := t(ddindx).import_flag;
661 a55(indx) := t(ddindx).reject_reason_code;
662 a56(indx) := t(ddindx).deleted_flag;
663 a57(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
664 a58(indx) := rosetta_g_miss_num_map(t(ddindx).incumbent_partner_party_id);
665 a59(indx) := rosetta_g_miss_num_map(t(ddindx).incumbent_partner_resource_id);
666 a60(indx) := t(ddindx).prm_exec_sponsor_flag;
667 a61(indx) := t(ddindx).prm_prj_lead_in_place_flag;
668 a62(indx) := t(ddindx).prm_sales_lead_type;
669 a63(indx) := t(ddindx).prm_ind_classification_code;
670 a64(indx) := t(ddindx).qualified_flag;
671 a65(indx) := t(ddindx).orig_system_code;
672 a66(indx) := t(ddindx).prm_assignment_type;
673 a67(indx) := t(ddindx).auto_assignment_type;
674 a68(indx) := rosetta_g_miss_num_map(t(ddindx).primary_contact_party_id);
675 a69(indx) := rosetta_g_miss_num_map(t(ddindx).primary_cnt_person_party_id);
676 a70(indx) := rosetta_g_miss_num_map(t(ddindx).primary_contact_phone_id);
677 a71(indx) := rosetta_g_miss_num_map(t(ddindx).referred_by);
678 a72(indx) := t(ddindx).referral_type;
679 a73(indx) := t(ddindx).referral_status;
680 a74(indx) := t(ddindx).ref_decline_reason;
681 a75(indx) := t(ddindx).ref_comm_ltr_status;
682 a76(indx) := rosetta_g_miss_num_map(t(ddindx).ref_order_number);
683 a77(indx) := rosetta_g_miss_num_map(t(ddindx).ref_order_amt);
684 a78(indx) := rosetta_g_miss_num_map(t(ddindx).ref_comm_amt);
685 a79(indx) := t(ddindx).lead_date;
686 a80(indx) := t(ddindx).source_system;
687 a81(indx) := t(ddindx).country;
688 a82(indx) := rosetta_g_miss_num_map(t(ddindx).total_amount);
689 a83(indx) := t(ddindx).expiration_date;
690 a84(indx) := t(ddindx).lead_engine_run_date;
691 a85(indx) := t(ddindx).lead_rank_ind;
692 a86(indx) := rosetta_g_miss_num_map(t(ddindx).current_reroutes);
693 a87(indx) := rosetta_g_miss_num_map(t(ddindx).marketing_score);
694 a88(indx) := rosetta_g_miss_num_map(t(ddindx).interaction_score);
695 a89(indx) := t(ddindx).source_primary_reference;
696 a90(indx) := t(ddindx).source_secondary_reference;
697 a91(indx) := rosetta_g_miss_num_map(t(ddindx).sales_methodology_id);
698 a92(indx) := rosetta_g_miss_num_map(t(ddindx).sales_stage_id);
699 indx := indx+1;
700 if t.last =ddindx
701 then exit;
702 end if;
703 ddindx := t.next(ddindx);
704 end loop;
705 end if;
706 end if;
707 end rosetta_table_copy_out_p3;
708
709 procedure rosetta_table_copy_in_p7(t out nocopy as_sales_leads_pub.sales_lead_line_tbl_type, a0 JTF_NUMBER_TABLE
710 , a1 JTF_DATE_TABLE
711 , a2 JTF_NUMBER_TABLE
712 , a3 JTF_DATE_TABLE
713 , a4 JTF_NUMBER_TABLE
714 , a5 JTF_NUMBER_TABLE
715 , a6 JTF_NUMBER_TABLE
716 , a7 JTF_NUMBER_TABLE
717 , a8 JTF_NUMBER_TABLE
721 , a12 JTF_NUMBER_TABLE
718 , a9 JTF_DATE_TABLE
719 , a10 JTF_NUMBER_TABLE
720 , a11 JTF_VARCHAR2_TABLE_100
722 , a13 JTF_NUMBER_TABLE
723 , a14 JTF_NUMBER_TABLE
724 , a15 JTF_NUMBER_TABLE
725 , a16 JTF_VARCHAR2_TABLE_100
726 , a17 JTF_NUMBER_TABLE
727 , a18 JTF_NUMBER_TABLE
728 , a19 JTF_NUMBER_TABLE
729 , a20 JTF_VARCHAR2_TABLE_100
730 , a21 JTF_VARCHAR2_TABLE_200
731 , a22 JTF_VARCHAR2_TABLE_200
732 , a23 JTF_VARCHAR2_TABLE_200
733 , a24 JTF_VARCHAR2_TABLE_200
734 , a25 JTF_VARCHAR2_TABLE_200
735 , a26 JTF_VARCHAR2_TABLE_200
736 , a27 JTF_VARCHAR2_TABLE_200
737 , a28 JTF_VARCHAR2_TABLE_200
738 , a29 JTF_VARCHAR2_TABLE_200
739 , a30 JTF_VARCHAR2_TABLE_200
740 , a31 JTF_VARCHAR2_TABLE_200
741 , a32 JTF_VARCHAR2_TABLE_200
742 , a33 JTF_VARCHAR2_TABLE_200
743 , a34 JTF_VARCHAR2_TABLE_200
744 , a35 JTF_VARCHAR2_TABLE_200
745 , a36 JTF_NUMBER_TABLE
746 ) as
747 ddindx binary_integer; indx binary_integer;
748 begin
749 if a0 is not null and a0.count > 0 then
750 if a0.count > 0 then
751 indx := a0.first;
752 ddindx := 1;
753 while true loop
754 t(ddindx).sales_lead_line_id := rosetta_g_miss_num_map(a0(indx));
755 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a1(indx));
756 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a2(indx));
757 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a3(indx));
758 t(ddindx).created_by := rosetta_g_miss_num_map(a4(indx));
759 t(ddindx).last_update_login := rosetta_g_miss_num_map(a5(indx));
760 t(ddindx).request_id := rosetta_g_miss_num_map(a6(indx));
761 t(ddindx).program_application_id := rosetta_g_miss_num_map(a7(indx));
762 t(ddindx).program_id := rosetta_g_miss_num_map(a8(indx));
763 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a9(indx));
764 t(ddindx).sales_lead_id := rosetta_g_miss_num_map(a10(indx));
765 t(ddindx).status_code := a11(indx);
766 t(ddindx).category_id := rosetta_g_miss_num_map(a12(indx));
767 t(ddindx).category_set_id := rosetta_g_miss_num_map(a13(indx));
768 t(ddindx).inventory_item_id := rosetta_g_miss_num_map(a14(indx));
769 t(ddindx).organization_id := rosetta_g_miss_num_map(a15(indx));
770 t(ddindx).uom_code := a16(indx);
771 t(ddindx).quantity := rosetta_g_miss_num_map(a17(indx));
772 t(ddindx).budget_amount := rosetta_g_miss_num_map(a18(indx));
773 t(ddindx).source_promotion_id := rosetta_g_miss_num_map(a19(indx));
774 t(ddindx).attribute_category := a20(indx);
775 t(ddindx).attribute1 := a21(indx);
776 t(ddindx).attribute2 := a22(indx);
777 t(ddindx).attribute3 := a23(indx);
778 t(ddindx).attribute4 := a24(indx);
779 t(ddindx).attribute5 := a25(indx);
780 t(ddindx).attribute6 := a26(indx);
781 t(ddindx).attribute7 := a27(indx);
782 t(ddindx).attribute8 := a28(indx);
783 t(ddindx).attribute9 := a29(indx);
784 t(ddindx).attribute10 := a30(indx);
785 t(ddindx).attribute11 := a31(indx);
786 t(ddindx).attribute12 := a32(indx);
787 t(ddindx).attribute13 := a33(indx);
788 t(ddindx).attribute14 := a34(indx);
789 t(ddindx).attribute15 := a35(indx);
790 t(ddindx).offer_id := rosetta_g_miss_num_map(a36(indx));
791 ddindx := ddindx+1;
792 if a0.last =indx
793 then exit;
794 end if;
795 indx := a0.next(indx);
796 end loop;
797 end if;
798 end if;
799 end rosetta_table_copy_in_p7;
800 procedure rosetta_table_copy_out_p7(t as_sales_leads_pub.sales_lead_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
801 , a1 out nocopy JTF_DATE_TABLE
802 , a2 out nocopy JTF_NUMBER_TABLE
803 , a3 out nocopy JTF_DATE_TABLE
804 , a4 out nocopy JTF_NUMBER_TABLE
805 , a5 out nocopy JTF_NUMBER_TABLE
806 , a6 out nocopy JTF_NUMBER_TABLE
807 , a7 out nocopy JTF_NUMBER_TABLE
808 , a8 out nocopy JTF_NUMBER_TABLE
809 , a9 out nocopy JTF_DATE_TABLE
810 , a10 out nocopy JTF_NUMBER_TABLE
811 , a11 out nocopy JTF_VARCHAR2_TABLE_100
812 , a12 out nocopy JTF_NUMBER_TABLE
813 , a13 out nocopy JTF_NUMBER_TABLE
814 , a14 out nocopy JTF_NUMBER_TABLE
815 , a15 out nocopy JTF_NUMBER_TABLE
816 , a16 out nocopy JTF_VARCHAR2_TABLE_100
817 , a17 out nocopy JTF_NUMBER_TABLE
818 , a18 out nocopy JTF_NUMBER_TABLE
819 , a19 out nocopy JTF_NUMBER_TABLE
820 , a20 out nocopy JTF_VARCHAR2_TABLE_100
821 , a21 out nocopy JTF_VARCHAR2_TABLE_200
822 , a22 out nocopy JTF_VARCHAR2_TABLE_200
823 , a23 out nocopy JTF_VARCHAR2_TABLE_200
824 , a24 out nocopy JTF_VARCHAR2_TABLE_200
825 , a25 out nocopy JTF_VARCHAR2_TABLE_200
826 , a26 out nocopy JTF_VARCHAR2_TABLE_200
827 , a27 out nocopy JTF_VARCHAR2_TABLE_200
828 , a28 out nocopy JTF_VARCHAR2_TABLE_200
829 , a29 out nocopy JTF_VARCHAR2_TABLE_200
830 , a30 out nocopy JTF_VARCHAR2_TABLE_200
831 , a31 out nocopy JTF_VARCHAR2_TABLE_200
832 , a32 out nocopy JTF_VARCHAR2_TABLE_200
836 , a36 out nocopy JTF_NUMBER_TABLE
833 , a33 out nocopy JTF_VARCHAR2_TABLE_200
834 , a34 out nocopy JTF_VARCHAR2_TABLE_200
835 , a35 out nocopy JTF_VARCHAR2_TABLE_200
837 ) as
838 ddindx binary_integer; indx binary_integer;
839 begin
840 if t is null or t.count = 0 then
841 a0 := JTF_NUMBER_TABLE();
842 a1 := JTF_DATE_TABLE();
843 a2 := JTF_NUMBER_TABLE();
844 a3 := JTF_DATE_TABLE();
845 a4 := JTF_NUMBER_TABLE();
846 a5 := JTF_NUMBER_TABLE();
847 a6 := JTF_NUMBER_TABLE();
848 a7 := JTF_NUMBER_TABLE();
849 a8 := JTF_NUMBER_TABLE();
850 a9 := JTF_DATE_TABLE();
851 a10 := JTF_NUMBER_TABLE();
852 a11 := JTF_VARCHAR2_TABLE_100();
853 a12 := JTF_NUMBER_TABLE();
854 a13 := JTF_NUMBER_TABLE();
855 a14 := JTF_NUMBER_TABLE();
856 a15 := JTF_NUMBER_TABLE();
857 a16 := JTF_VARCHAR2_TABLE_100();
858 a17 := JTF_NUMBER_TABLE();
859 a18 := JTF_NUMBER_TABLE();
860 a19 := JTF_NUMBER_TABLE();
861 a20 := JTF_VARCHAR2_TABLE_100();
862 a21 := JTF_VARCHAR2_TABLE_200();
863 a22 := JTF_VARCHAR2_TABLE_200();
864 a23 := JTF_VARCHAR2_TABLE_200();
865 a24 := JTF_VARCHAR2_TABLE_200();
866 a25 := JTF_VARCHAR2_TABLE_200();
867 a26 := JTF_VARCHAR2_TABLE_200();
868 a27 := JTF_VARCHAR2_TABLE_200();
869 a28 := JTF_VARCHAR2_TABLE_200();
870 a29 := JTF_VARCHAR2_TABLE_200();
871 a30 := JTF_VARCHAR2_TABLE_200();
872 a31 := JTF_VARCHAR2_TABLE_200();
873 a32 := JTF_VARCHAR2_TABLE_200();
874 a33 := JTF_VARCHAR2_TABLE_200();
875 a34 := JTF_VARCHAR2_TABLE_200();
876 a35 := JTF_VARCHAR2_TABLE_200();
877 a36 := JTF_NUMBER_TABLE();
878 else
879 a0 := JTF_NUMBER_TABLE();
880 a1 := JTF_DATE_TABLE();
881 a2 := JTF_NUMBER_TABLE();
882 a3 := JTF_DATE_TABLE();
883 a4 := JTF_NUMBER_TABLE();
884 a5 := JTF_NUMBER_TABLE();
885 a6 := JTF_NUMBER_TABLE();
886 a7 := JTF_NUMBER_TABLE();
887 a8 := JTF_NUMBER_TABLE();
888 a9 := JTF_DATE_TABLE();
889 a10 := JTF_NUMBER_TABLE();
890 a11 := JTF_VARCHAR2_TABLE_100();
891 a12 := JTF_NUMBER_TABLE();
892 a13 := JTF_NUMBER_TABLE();
893 a14 := JTF_NUMBER_TABLE();
894 a15 := JTF_NUMBER_TABLE();
895 a16 := JTF_VARCHAR2_TABLE_100();
896 a17 := JTF_NUMBER_TABLE();
897 a18 := JTF_NUMBER_TABLE();
898 a19 := JTF_NUMBER_TABLE();
899 a20 := JTF_VARCHAR2_TABLE_100();
900 a21 := JTF_VARCHAR2_TABLE_200();
901 a22 := JTF_VARCHAR2_TABLE_200();
902 a23 := JTF_VARCHAR2_TABLE_200();
903 a24 := JTF_VARCHAR2_TABLE_200();
904 a25 := JTF_VARCHAR2_TABLE_200();
905 a26 := JTF_VARCHAR2_TABLE_200();
906 a27 := JTF_VARCHAR2_TABLE_200();
907 a28 := JTF_VARCHAR2_TABLE_200();
908 a29 := JTF_VARCHAR2_TABLE_200();
909 a30 := JTF_VARCHAR2_TABLE_200();
910 a31 := JTF_VARCHAR2_TABLE_200();
911 a32 := JTF_VARCHAR2_TABLE_200();
912 a33 := JTF_VARCHAR2_TABLE_200();
913 a34 := JTF_VARCHAR2_TABLE_200();
914 a35 := JTF_VARCHAR2_TABLE_200();
915 a36 := JTF_NUMBER_TABLE();
916 if t.count > 0 then
917 a0.extend(t.count);
918 a1.extend(t.count);
919 a2.extend(t.count);
920 a3.extend(t.count);
921 a4.extend(t.count);
922 a5.extend(t.count);
923 a6.extend(t.count);
924 a7.extend(t.count);
925 a8.extend(t.count);
926 a9.extend(t.count);
927 a10.extend(t.count);
928 a11.extend(t.count);
929 a12.extend(t.count);
930 a13.extend(t.count);
931 a14.extend(t.count);
932 a15.extend(t.count);
933 a16.extend(t.count);
934 a17.extend(t.count);
935 a18.extend(t.count);
936 a19.extend(t.count);
937 a20.extend(t.count);
938 a21.extend(t.count);
939 a22.extend(t.count);
940 a23.extend(t.count);
941 a24.extend(t.count);
942 a25.extend(t.count);
943 a26.extend(t.count);
944 a27.extend(t.count);
945 a28.extend(t.count);
946 a29.extend(t.count);
947 a30.extend(t.count);
948 a31.extend(t.count);
949 a32.extend(t.count);
950 a33.extend(t.count);
951 a34.extend(t.count);
952 a35.extend(t.count);
953 a36.extend(t.count);
954 ddindx := t.first;
955 indx := 1;
956 while true loop
957 a0(indx) := rosetta_g_miss_num_map(t(ddindx).sales_lead_line_id);
958 a1(indx) := t(ddindx).last_update_date;
959 a2(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
960 a3(indx) := t(ddindx).creation_date;
961 a4(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
962 a5(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
963 a6(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
964 a7(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
965 a8(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
966 a9(indx) := t(ddindx).program_update_date;
970 a13(indx) := rosetta_g_miss_num_map(t(ddindx).category_set_id);
967 a10(indx) := rosetta_g_miss_num_map(t(ddindx).sales_lead_id);
968 a11(indx) := t(ddindx).status_code;
969 a12(indx) := rosetta_g_miss_num_map(t(ddindx).category_id);
971 a14(indx) := rosetta_g_miss_num_map(t(ddindx).inventory_item_id);
972 a15(indx) := rosetta_g_miss_num_map(t(ddindx).organization_id);
973 a16(indx) := t(ddindx).uom_code;
974 a17(indx) := rosetta_g_miss_num_map(t(ddindx).quantity);
975 a18(indx) := rosetta_g_miss_num_map(t(ddindx).budget_amount);
976 a19(indx) := rosetta_g_miss_num_map(t(ddindx).source_promotion_id);
977 a20(indx) := t(ddindx).attribute_category;
978 a21(indx) := t(ddindx).attribute1;
979 a22(indx) := t(ddindx).attribute2;
980 a23(indx) := t(ddindx).attribute3;
981 a24(indx) := t(ddindx).attribute4;
982 a25(indx) := t(ddindx).attribute5;
983 a26(indx) := t(ddindx).attribute6;
984 a27(indx) := t(ddindx).attribute7;
985 a28(indx) := t(ddindx).attribute8;
986 a29(indx) := t(ddindx).attribute9;
987 a30(indx) := t(ddindx).attribute10;
988 a31(indx) := t(ddindx).attribute11;
989 a32(indx) := t(ddindx).attribute12;
990 a33(indx) := t(ddindx).attribute13;
991 a34(indx) := t(ddindx).attribute14;
992 a35(indx) := t(ddindx).attribute15;
993 a36(indx) := rosetta_g_miss_num_map(t(ddindx).offer_id);
994 indx := indx+1;
995 if t.last =ddindx
996 then exit;
997 end if;
998 ddindx := t.next(ddindx);
999 end loop;
1000 end if;
1001 end if;
1002 end rosetta_table_copy_out_p7;
1003
1004 procedure rosetta_table_copy_in_p10(t out nocopy as_sales_leads_pub.sales_lead_line_out_tbl_type, a0 JTF_NUMBER_TABLE
1005 , a1 JTF_VARCHAR2_TABLE_100
1006 ) as
1007 ddindx binary_integer; indx binary_integer;
1008 begin
1009 if a0 is not null and a0.count > 0 then
1010 if a0.count > 0 then
1011 indx := a0.first;
1012 ddindx := 1;
1013 while true loop
1014 t(ddindx).sales_lead_line_id := rosetta_g_miss_num_map(a0(indx));
1015 t(ddindx).return_status := a1(indx);
1016 ddindx := ddindx+1;
1017 if a0.last =indx
1018 then exit;
1019 end if;
1020 indx := a0.next(indx);
1021 end loop;
1022 end if;
1023 end if;
1024 end rosetta_table_copy_in_p10;
1025 procedure rosetta_table_copy_out_p10(t as_sales_leads_pub.sales_lead_line_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1026 , a1 out nocopy JTF_VARCHAR2_TABLE_100
1027 ) as
1028 ddindx binary_integer; indx binary_integer;
1029 begin
1030 if t is null or t.count = 0 then
1031 a0 := JTF_NUMBER_TABLE();
1032 a1 := JTF_VARCHAR2_TABLE_100();
1033 else
1034 a0 := JTF_NUMBER_TABLE();
1035 a1 := JTF_VARCHAR2_TABLE_100();
1036 if t.count > 0 then
1037 a0.extend(t.count);
1038 a1.extend(t.count);
1039 ddindx := t.first;
1040 indx := 1;
1041 while true loop
1042 a0(indx) := rosetta_g_miss_num_map(t(ddindx).sales_lead_line_id);
1043 a1(indx) := t(ddindx).return_status;
1044 indx := indx+1;
1045 if t.last =ddindx
1046 then exit;
1047 end if;
1048 ddindx := t.next(ddindx);
1049 end loop;
1050 end if;
1051 end if;
1052 end rosetta_table_copy_out_p10;
1053
1054 procedure rosetta_table_copy_in_p13(t out nocopy as_sales_leads_pub.sales_lead_contact_tbl_type, a0 JTF_NUMBER_TABLE
1055 , a1 JTF_NUMBER_TABLE
1056 , a2 JTF_NUMBER_TABLE
1057 , a3 JTF_DATE_TABLE
1058 , a4 JTF_NUMBER_TABLE
1059 , a5 JTF_DATE_TABLE
1060 , a6 JTF_NUMBER_TABLE
1061 , a7 JTF_NUMBER_TABLE
1062 , a8 JTF_NUMBER_TABLE
1063 , a9 JTF_NUMBER_TABLE
1064 , a10 JTF_NUMBER_TABLE
1065 , a11 JTF_DATE_TABLE
1066 , a12 JTF_VARCHAR2_TABLE_100
1067 , a13 JTF_VARCHAR2_TABLE_100
1068 , a14 JTF_NUMBER_TABLE
1069 , a15 JTF_NUMBER_TABLE
1070 , a16 JTF_NUMBER_TABLE
1071 , a17 JTF_VARCHAR2_TABLE_100
1072 , a18 JTF_VARCHAR2_TABLE_100
1073 , a19 JTF_VARCHAR2_TABLE_100
1074 , a20 JTF_VARCHAR2_TABLE_200
1075 , a21 JTF_VARCHAR2_TABLE_200
1076 , a22 JTF_VARCHAR2_TABLE_200
1077 , a23 JTF_VARCHAR2_TABLE_200
1078 , a24 JTF_VARCHAR2_TABLE_200
1079 , a25 JTF_VARCHAR2_TABLE_200
1080 , a26 JTF_VARCHAR2_TABLE_200
1081 , a27 JTF_VARCHAR2_TABLE_200
1082 , a28 JTF_VARCHAR2_TABLE_200
1083 , a29 JTF_VARCHAR2_TABLE_200
1084 , a30 JTF_VARCHAR2_TABLE_200
1085 , a31 JTF_VARCHAR2_TABLE_200
1086 , a32 JTF_VARCHAR2_TABLE_200
1087 , a33 JTF_VARCHAR2_TABLE_200
1088 , a34 JTF_VARCHAR2_TABLE_200
1089 , a35 JTF_NUMBER_TABLE
1090 ) as
1091 ddindx binary_integer; indx binary_integer;
1092 begin
1093 if a0 is not null and a0.count > 0 then
1094 if a0.count > 0 then
1095 indx := a0.first;
1096 ddindx := 1;
1097 while true loop
1098 t(ddindx).lead_contact_id := rosetta_g_miss_num_map(a0(indx));
1099 t(ddindx).sales_lead_id := rosetta_g_miss_num_map(a1(indx));
1103 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a5(indx));
1100 t(ddindx).contact_id := rosetta_g_miss_num_map(a2(indx));
1101 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a3(indx));
1102 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a4(indx));
1104 t(ddindx).created_by := rosetta_g_miss_num_map(a6(indx));
1105 t(ddindx).last_update_login := rosetta_g_miss_num_map(a7(indx));
1106 t(ddindx).request_id := rosetta_g_miss_num_map(a8(indx));
1107 t(ddindx).program_application_id := rosetta_g_miss_num_map(a9(indx));
1108 t(ddindx).program_id := rosetta_g_miss_num_map(a10(indx));
1109 t(ddindx).program_update_date := rosetta_g_miss_date_in_map(a11(indx));
1110 t(ddindx).enabled_flag := a12(indx);
1111 t(ddindx).rank := a13(indx);
1112 t(ddindx).customer_id := rosetta_g_miss_num_map(a14(indx));
1113 t(ddindx).address_id := rosetta_g_miss_num_map(a15(indx));
1114 t(ddindx).phone_id := rosetta_g_miss_num_map(a16(indx));
1115 t(ddindx).contact_role_code := a17(indx);
1116 t(ddindx).primary_contact_flag := a18(indx);
1117 t(ddindx).attribute_category := a19(indx);
1118 t(ddindx).attribute1 := a20(indx);
1119 t(ddindx).attribute2 := a21(indx);
1120 t(ddindx).attribute3 := a22(indx);
1121 t(ddindx).attribute4 := a23(indx);
1122 t(ddindx).attribute5 := a24(indx);
1123 t(ddindx).attribute6 := a25(indx);
1124 t(ddindx).attribute7 := a26(indx);
1125 t(ddindx).attribute8 := a27(indx);
1126 t(ddindx).attribute9 := a28(indx);
1127 t(ddindx).attribute10 := a29(indx);
1128 t(ddindx).attribute11 := a30(indx);
1129 t(ddindx).attribute12 := a31(indx);
1130 t(ddindx).attribute13 := a32(indx);
1131 t(ddindx).attribute14 := a33(indx);
1132 t(ddindx).attribute15 := a34(indx);
1133 t(ddindx).contact_party_id := rosetta_g_miss_num_map(a35(indx));
1134 ddindx := ddindx+1;
1135 if a0.last =indx
1136 then exit;
1137 end if;
1138 indx := a0.next(indx);
1139 end loop;
1140 end if;
1141 end if;
1142 end rosetta_table_copy_in_p13;
1143 procedure rosetta_table_copy_out_p13(t as_sales_leads_pub.sales_lead_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1144 , a1 out nocopy JTF_NUMBER_TABLE
1145 , a2 out nocopy JTF_NUMBER_TABLE
1146 , a3 out nocopy JTF_DATE_TABLE
1147 , a4 out nocopy JTF_NUMBER_TABLE
1148 , a5 out nocopy JTF_DATE_TABLE
1149 , a6 out nocopy JTF_NUMBER_TABLE
1150 , a7 out nocopy JTF_NUMBER_TABLE
1151 , a8 out nocopy JTF_NUMBER_TABLE
1152 , a9 out nocopy JTF_NUMBER_TABLE
1153 , a10 out nocopy JTF_NUMBER_TABLE
1154 , a11 out nocopy JTF_DATE_TABLE
1155 , a12 out nocopy JTF_VARCHAR2_TABLE_100
1156 , a13 out nocopy JTF_VARCHAR2_TABLE_100
1157 , a14 out nocopy JTF_NUMBER_TABLE
1158 , a15 out nocopy JTF_NUMBER_TABLE
1159 , a16 out nocopy JTF_NUMBER_TABLE
1160 , a17 out nocopy JTF_VARCHAR2_TABLE_100
1161 , a18 out nocopy JTF_VARCHAR2_TABLE_100
1162 , a19 out nocopy JTF_VARCHAR2_TABLE_100
1163 , a20 out nocopy JTF_VARCHAR2_TABLE_200
1164 , a21 out nocopy JTF_VARCHAR2_TABLE_200
1165 , a22 out nocopy JTF_VARCHAR2_TABLE_200
1166 , a23 out nocopy JTF_VARCHAR2_TABLE_200
1167 , a24 out nocopy JTF_VARCHAR2_TABLE_200
1168 , a25 out nocopy JTF_VARCHAR2_TABLE_200
1169 , a26 out nocopy JTF_VARCHAR2_TABLE_200
1170 , a27 out nocopy JTF_VARCHAR2_TABLE_200
1171 , a28 out nocopy JTF_VARCHAR2_TABLE_200
1172 , a29 out nocopy JTF_VARCHAR2_TABLE_200
1173 , a30 out nocopy JTF_VARCHAR2_TABLE_200
1174 , a31 out nocopy JTF_VARCHAR2_TABLE_200
1175 , a32 out nocopy JTF_VARCHAR2_TABLE_200
1176 , a33 out nocopy JTF_VARCHAR2_TABLE_200
1177 , a34 out nocopy JTF_VARCHAR2_TABLE_200
1178 , a35 out nocopy JTF_NUMBER_TABLE
1179 ) as
1180 ddindx binary_integer; indx binary_integer;
1181 begin
1182 if t is null or t.count = 0 then
1183 a0 := JTF_NUMBER_TABLE();
1184 a1 := JTF_NUMBER_TABLE();
1185 a2 := JTF_NUMBER_TABLE();
1186 a3 := JTF_DATE_TABLE();
1187 a4 := JTF_NUMBER_TABLE();
1188 a5 := JTF_DATE_TABLE();
1189 a6 := JTF_NUMBER_TABLE();
1190 a7 := JTF_NUMBER_TABLE();
1191 a8 := JTF_NUMBER_TABLE();
1192 a9 := JTF_NUMBER_TABLE();
1193 a10 := JTF_NUMBER_TABLE();
1194 a11 := JTF_DATE_TABLE();
1195 a12 := JTF_VARCHAR2_TABLE_100();
1196 a13 := JTF_VARCHAR2_TABLE_100();
1197 a14 := JTF_NUMBER_TABLE();
1198 a15 := JTF_NUMBER_TABLE();
1199 a16 := JTF_NUMBER_TABLE();
1200 a17 := JTF_VARCHAR2_TABLE_100();
1201 a18 := JTF_VARCHAR2_TABLE_100();
1202 a19 := JTF_VARCHAR2_TABLE_100();
1203 a20 := JTF_VARCHAR2_TABLE_200();
1204 a21 := JTF_VARCHAR2_TABLE_200();
1205 a22 := JTF_VARCHAR2_TABLE_200();
1206 a23 := JTF_VARCHAR2_TABLE_200();
1207 a24 := JTF_VARCHAR2_TABLE_200();
1208 a25 := JTF_VARCHAR2_TABLE_200();
1209 a26 := JTF_VARCHAR2_TABLE_200();
1210 a27 := JTF_VARCHAR2_TABLE_200();
1211 a28 := JTF_VARCHAR2_TABLE_200();
1212 a29 := JTF_VARCHAR2_TABLE_200();
1213 a30 := JTF_VARCHAR2_TABLE_200();
1214 a31 := JTF_VARCHAR2_TABLE_200();
1215 a32 := JTF_VARCHAR2_TABLE_200();
1216 a33 := JTF_VARCHAR2_TABLE_200();
1220 a0 := JTF_NUMBER_TABLE();
1217 a34 := JTF_VARCHAR2_TABLE_200();
1218 a35 := JTF_NUMBER_TABLE();
1219 else
1221 a1 := JTF_NUMBER_TABLE();
1222 a2 := JTF_NUMBER_TABLE();
1223 a3 := JTF_DATE_TABLE();
1224 a4 := JTF_NUMBER_TABLE();
1225 a5 := JTF_DATE_TABLE();
1226 a6 := JTF_NUMBER_TABLE();
1227 a7 := JTF_NUMBER_TABLE();
1228 a8 := JTF_NUMBER_TABLE();
1229 a9 := JTF_NUMBER_TABLE();
1230 a10 := JTF_NUMBER_TABLE();
1231 a11 := JTF_DATE_TABLE();
1232 a12 := JTF_VARCHAR2_TABLE_100();
1233 a13 := JTF_VARCHAR2_TABLE_100();
1234 a14 := JTF_NUMBER_TABLE();
1235 a15 := JTF_NUMBER_TABLE();
1236 a16 := JTF_NUMBER_TABLE();
1237 a17 := JTF_VARCHAR2_TABLE_100();
1238 a18 := JTF_VARCHAR2_TABLE_100();
1239 a19 := JTF_VARCHAR2_TABLE_100();
1240 a20 := JTF_VARCHAR2_TABLE_200();
1241 a21 := JTF_VARCHAR2_TABLE_200();
1242 a22 := JTF_VARCHAR2_TABLE_200();
1243 a23 := JTF_VARCHAR2_TABLE_200();
1244 a24 := JTF_VARCHAR2_TABLE_200();
1245 a25 := JTF_VARCHAR2_TABLE_200();
1246 a26 := JTF_VARCHAR2_TABLE_200();
1247 a27 := JTF_VARCHAR2_TABLE_200();
1248 a28 := JTF_VARCHAR2_TABLE_200();
1249 a29 := JTF_VARCHAR2_TABLE_200();
1250 a30 := JTF_VARCHAR2_TABLE_200();
1251 a31 := JTF_VARCHAR2_TABLE_200();
1252 a32 := JTF_VARCHAR2_TABLE_200();
1253 a33 := JTF_VARCHAR2_TABLE_200();
1254 a34 := JTF_VARCHAR2_TABLE_200();
1255 a35 := JTF_NUMBER_TABLE();
1256 if t.count > 0 then
1257 a0.extend(t.count);
1258 a1.extend(t.count);
1259 a2.extend(t.count);
1260 a3.extend(t.count);
1261 a4.extend(t.count);
1262 a5.extend(t.count);
1263 a6.extend(t.count);
1264 a7.extend(t.count);
1265 a8.extend(t.count);
1266 a9.extend(t.count);
1267 a10.extend(t.count);
1268 a11.extend(t.count);
1269 a12.extend(t.count);
1270 a13.extend(t.count);
1271 a14.extend(t.count);
1272 a15.extend(t.count);
1273 a16.extend(t.count);
1274 a17.extend(t.count);
1275 a18.extend(t.count);
1276 a19.extend(t.count);
1277 a20.extend(t.count);
1278 a21.extend(t.count);
1279 a22.extend(t.count);
1280 a23.extend(t.count);
1281 a24.extend(t.count);
1282 a25.extend(t.count);
1283 a26.extend(t.count);
1284 a27.extend(t.count);
1285 a28.extend(t.count);
1286 a29.extend(t.count);
1287 a30.extend(t.count);
1288 a31.extend(t.count);
1289 a32.extend(t.count);
1290 a33.extend(t.count);
1291 a34.extend(t.count);
1292 a35.extend(t.count);
1293 ddindx := t.first;
1294 indx := 1;
1295 while true loop
1296 a0(indx) := rosetta_g_miss_num_map(t(ddindx).lead_contact_id);
1297 a1(indx) := rosetta_g_miss_num_map(t(ddindx).sales_lead_id);
1298 a2(indx) := rosetta_g_miss_num_map(t(ddindx).contact_id);
1299 a3(indx) := t(ddindx).last_update_date;
1300 a4(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
1301 a5(indx) := t(ddindx).creation_date;
1302 a6(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
1303 a7(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
1304 a8(indx) := rosetta_g_miss_num_map(t(ddindx).request_id);
1305 a9(indx) := rosetta_g_miss_num_map(t(ddindx).program_application_id);
1306 a10(indx) := rosetta_g_miss_num_map(t(ddindx).program_id);
1307 a11(indx) := t(ddindx).program_update_date;
1308 a12(indx) := t(ddindx).enabled_flag;
1309 a13(indx) := t(ddindx).rank;
1310 a14(indx) := rosetta_g_miss_num_map(t(ddindx).customer_id);
1311 a15(indx) := rosetta_g_miss_num_map(t(ddindx).address_id);
1312 a16(indx) := rosetta_g_miss_num_map(t(ddindx).phone_id);
1313 a17(indx) := t(ddindx).contact_role_code;
1314 a18(indx) := t(ddindx).primary_contact_flag;
1315 a19(indx) := t(ddindx).attribute_category;
1316 a20(indx) := t(ddindx).attribute1;
1317 a21(indx) := t(ddindx).attribute2;
1318 a22(indx) := t(ddindx).attribute3;
1319 a23(indx) := t(ddindx).attribute4;
1320 a24(indx) := t(ddindx).attribute5;
1321 a25(indx) := t(ddindx).attribute6;
1322 a26(indx) := t(ddindx).attribute7;
1323 a27(indx) := t(ddindx).attribute8;
1324 a28(indx) := t(ddindx).attribute9;
1325 a29(indx) := t(ddindx).attribute10;
1326 a30(indx) := t(ddindx).attribute11;
1327 a31(indx) := t(ddindx).attribute12;
1328 a32(indx) := t(ddindx).attribute13;
1329 a33(indx) := t(ddindx).attribute14;
1330 a34(indx) := t(ddindx).attribute15;
1331 a35(indx) := rosetta_g_miss_num_map(t(ddindx).contact_party_id);
1332 indx := indx+1;
1333 if t.last =ddindx
1334 then exit;
1335 end if;
1336 ddindx := t.next(ddindx);
1337 end loop;
1338 end if;
1339 end if;
1340 end rosetta_table_copy_out_p13;
1341
1345 ddindx binary_integer; indx binary_integer;
1342 procedure rosetta_table_copy_in_p16(t out nocopy as_sales_leads_pub.sales_lead_cnt_out_tbl_type, a0 JTF_NUMBER_TABLE
1343 , a1 JTF_VARCHAR2_TABLE_100
1344 ) as
1346 begin
1347 if a0 is not null and a0.count > 0 then
1348 if a0.count > 0 then
1349 indx := a0.first;
1350 ddindx := 1;
1351 while true loop
1352 t(ddindx).lead_contact_id := rosetta_g_miss_num_map(a0(indx));
1353 t(ddindx).return_status := a1(indx);
1354 ddindx := ddindx+1;
1355 if a0.last =indx
1356 then exit;
1357 end if;
1358 indx := a0.next(indx);
1359 end loop;
1360 end if;
1361 end if;
1362 end rosetta_table_copy_in_p16;
1363 procedure rosetta_table_copy_out_p16(t as_sales_leads_pub.sales_lead_cnt_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1364 , a1 out nocopy JTF_VARCHAR2_TABLE_100
1365 ) as
1366 ddindx binary_integer; indx binary_integer;
1367 begin
1368 if t is null or t.count = 0 then
1369 a0 := JTF_NUMBER_TABLE();
1370 a1 := JTF_VARCHAR2_TABLE_100();
1371 else
1372 a0 := JTF_NUMBER_TABLE();
1373 a1 := JTF_VARCHAR2_TABLE_100();
1374 if t.count > 0 then
1375 a0.extend(t.count);
1376 a1.extend(t.count);
1377 ddindx := t.first;
1378 indx := 1;
1379 while true loop
1380 a0(indx) := rosetta_g_miss_num_map(t(ddindx).lead_contact_id);
1381 a1(indx) := t(ddindx).return_status;
1382 indx := indx+1;
1383 if t.last =ddindx
1384 then exit;
1385 end if;
1386 ddindx := t.next(ddindx);
1387 end loop;
1388 end if;
1389 end if;
1390 end rosetta_table_copy_out_p16;
1391
1392 procedure rosetta_table_copy_in_p19(t out nocopy as_sales_leads_pub.assign_id_tbl_type, a0 JTF_NUMBER_TABLE
1393 , a1 JTF_NUMBER_TABLE
1394 ) as
1395 ddindx binary_integer; indx binary_integer;
1396 begin
1397 if a0 is not null and a0.count > 0 then
1398 if a0.count > 0 then
1399 indx := a0.first;
1400 ddindx := 1;
1401 while true loop
1402 t(ddindx).resource_id := rosetta_g_miss_num_map(a0(indx));
1403 t(ddindx).sales_group_id := rosetta_g_miss_num_map(a1(indx));
1404 ddindx := ddindx+1;
1405 if a0.last =indx
1406 then exit;
1407 end if;
1408 indx := a0.next(indx);
1409 end loop;
1410 end if;
1411 end if;
1412 end rosetta_table_copy_in_p19;
1413 procedure rosetta_table_copy_out_p19(t as_sales_leads_pub.assign_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1414 , a1 out nocopy JTF_NUMBER_TABLE
1415 ) as
1416 ddindx binary_integer; indx binary_integer;
1417 begin
1418 if t is null or t.count = 0 then
1419 a0 := JTF_NUMBER_TABLE();
1420 a1 := JTF_NUMBER_TABLE();
1421 else
1422 a0 := JTF_NUMBER_TABLE();
1423 a1 := JTF_NUMBER_TABLE();
1424 if t.count > 0 then
1425 a0.extend(t.count);
1426 a1.extend(t.count);
1427 ddindx := t.first;
1428 indx := 1;
1429 while true loop
1430 a0(indx) := rosetta_g_miss_num_map(t(ddindx).resource_id);
1431 a1(indx) := rosetta_g_miss_num_map(t(ddindx).sales_group_id);
1432 indx := indx+1;
1433 if t.last =ddindx
1434 then exit;
1435 end if;
1436 ddindx := t.next(ddindx);
1437 end loop;
1438 end if;
1439 end if;
1440 end rosetta_table_copy_out_p19;
1441
1442 procedure create_sales_lead(p_api_version_number NUMBER
1443 , p_init_msg_list VARCHAR2
1444 , p_commit VARCHAR2
1445 , p_validation_level NUMBER
1446 , p_check_access_flag VARCHAR2
1447 , p_admin_flag VARCHAR2
1448 , p_admin_group_id NUMBER
1449 , p_identity_salesforce_id NUMBER
1450 , p8_a0 JTF_VARCHAR2_TABLE_100
1451 , p8_a1 JTF_VARCHAR2_TABLE_300
1452 , p10_a0 JTF_NUMBER_TABLE
1453 , p10_a1 JTF_DATE_TABLE
1454 , p10_a2 JTF_NUMBER_TABLE
1455 , p10_a3 JTF_DATE_TABLE
1456 , p10_a4 JTF_NUMBER_TABLE
1457 , p10_a5 JTF_NUMBER_TABLE
1458 , p10_a6 JTF_NUMBER_TABLE
1459 , p10_a7 JTF_NUMBER_TABLE
1460 , p10_a8 JTF_NUMBER_TABLE
1461 , p10_a9 JTF_DATE_TABLE
1462 , p10_a10 JTF_NUMBER_TABLE
1463 , p10_a11 JTF_VARCHAR2_TABLE_100
1464 , p10_a12 JTF_NUMBER_TABLE
1465 , p10_a13 JTF_NUMBER_TABLE
1466 , p10_a14 JTF_NUMBER_TABLE
1467 , p10_a15 JTF_NUMBER_TABLE
1468 , p10_a16 JTF_VARCHAR2_TABLE_100
1469 , p10_a17 JTF_NUMBER_TABLE
1470 , p10_a18 JTF_NUMBER_TABLE
1471 , p10_a19 JTF_NUMBER_TABLE
1472 , p10_a20 JTF_VARCHAR2_TABLE_100
1473 , p10_a21 JTF_VARCHAR2_TABLE_200
1474 , p10_a22 JTF_VARCHAR2_TABLE_200
1475 , p10_a23 JTF_VARCHAR2_TABLE_200
1476 , p10_a24 JTF_VARCHAR2_TABLE_200
1477 , p10_a25 JTF_VARCHAR2_TABLE_200
1478 , p10_a26 JTF_VARCHAR2_TABLE_200
1479 , p10_a27 JTF_VARCHAR2_TABLE_200
1480 , p10_a28 JTF_VARCHAR2_TABLE_200
1481 , p10_a29 JTF_VARCHAR2_TABLE_200
1482 , p10_a30 JTF_VARCHAR2_TABLE_200
1483 , p10_a31 JTF_VARCHAR2_TABLE_200
1484 , p10_a32 JTF_VARCHAR2_TABLE_200
1488 , p10_a36 JTF_NUMBER_TABLE
1485 , p10_a33 JTF_VARCHAR2_TABLE_200
1486 , p10_a34 JTF_VARCHAR2_TABLE_200
1487 , p10_a35 JTF_VARCHAR2_TABLE_200
1489 , p11_a0 JTF_NUMBER_TABLE
1490 , p11_a1 JTF_NUMBER_TABLE
1491 , p11_a2 JTF_NUMBER_TABLE
1492 , p11_a3 JTF_DATE_TABLE
1493 , p11_a4 JTF_NUMBER_TABLE
1494 , p11_a5 JTF_DATE_TABLE
1495 , p11_a6 JTF_NUMBER_TABLE
1496 , p11_a7 JTF_NUMBER_TABLE
1497 , p11_a8 JTF_NUMBER_TABLE
1498 , p11_a9 JTF_NUMBER_TABLE
1499 , p11_a10 JTF_NUMBER_TABLE
1500 , p11_a11 JTF_DATE_TABLE
1501 , p11_a12 JTF_VARCHAR2_TABLE_100
1502 , p11_a13 JTF_VARCHAR2_TABLE_100
1503 , p11_a14 JTF_NUMBER_TABLE
1504 , p11_a15 JTF_NUMBER_TABLE
1505 , p11_a16 JTF_NUMBER_TABLE
1506 , p11_a17 JTF_VARCHAR2_TABLE_100
1507 , p11_a18 JTF_VARCHAR2_TABLE_100
1508 , p11_a19 JTF_VARCHAR2_TABLE_100
1509 , p11_a20 JTF_VARCHAR2_TABLE_200
1510 , p11_a21 JTF_VARCHAR2_TABLE_200
1511 , p11_a22 JTF_VARCHAR2_TABLE_200
1512 , p11_a23 JTF_VARCHAR2_TABLE_200
1513 , p11_a24 JTF_VARCHAR2_TABLE_200
1514 , p11_a25 JTF_VARCHAR2_TABLE_200
1515 , p11_a26 JTF_VARCHAR2_TABLE_200
1516 , p11_a27 JTF_VARCHAR2_TABLE_200
1517 , p11_a28 JTF_VARCHAR2_TABLE_200
1518 , p11_a29 JTF_VARCHAR2_TABLE_200
1519 , p11_a30 JTF_VARCHAR2_TABLE_200
1520 , p11_a31 JTF_VARCHAR2_TABLE_200
1521 , p11_a32 JTF_VARCHAR2_TABLE_200
1522 , p11_a33 JTF_VARCHAR2_TABLE_200
1523 , p11_a34 JTF_VARCHAR2_TABLE_200
1524 , p11_a35 JTF_NUMBER_TABLE
1525 , x_sales_lead_id out nocopy NUMBER
1526 , p13_a0 out nocopy JTF_NUMBER_TABLE
1527 , p13_a1 out nocopy JTF_VARCHAR2_TABLE_100
1528 , p14_a0 out nocopy JTF_NUMBER_TABLE
1529 , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
1530 , x_return_status out nocopy VARCHAR2
1531 , x_msg_count out nocopy NUMBER
1532 , x_msg_data out nocopy VARCHAR2
1533 , p9_a0 NUMBER := 0-1962.0724
1534 , p9_a1 DATE := fnd_api.g_miss_date
1535 , p9_a2 NUMBER := 0-1962.0724
1536 , p9_a3 DATE := fnd_api.g_miss_date
1537 , p9_a4 NUMBER := 0-1962.0724
1538 , p9_a5 NUMBER := 0-1962.0724
1539 , p9_a6 NUMBER := 0-1962.0724
1540 , p9_a7 NUMBER := 0-1962.0724
1541 , p9_a8 NUMBER := 0-1962.0724
1542 , p9_a9 DATE := fnd_api.g_miss_date
1543 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
1544 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
1545 , p9_a12 NUMBER := 0-1962.0724
1546 , p9_a13 NUMBER := 0-1962.0724
1547 , p9_a14 NUMBER := 0-1962.0724
1548 , p9_a15 NUMBER := 0-1962.0724
1549 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
1550 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
1551 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
1552 , p9_a19 NUMBER := 0-1962.0724
1553 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
1554 , p9_a21 VARCHAR2 := fnd_api.g_miss_char
1555 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
1556 , p9_a23 NUMBER := 0-1962.0724
1557 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
1558 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
1559 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
1560 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
1561 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
1562 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
1563 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
1564 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
1565 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
1566 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
1567 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
1568 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
1569 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
1570 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
1571 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
1572 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
1573 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
1574 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
1575 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
1576 , p9_a43 NUMBER := 0-1962.0724
1577 , p9_a44 NUMBER := 0-1962.0724
1578 , p9_a45 NUMBER := 0-1962.0724
1579 , p9_a46 DATE := fnd_api.g_miss_date
1580 , p9_a47 VARCHAR2 := fnd_api.g_miss_char
1581 , p9_a48 VARCHAR2 := fnd_api.g_miss_char
1582 , p9_a49 VARCHAR2 := fnd_api.g_miss_char
1583 , p9_a50 NUMBER := 0-1962.0724
1584 , p9_a51 NUMBER := 0-1962.0724
1585 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
1586 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
1587 , p9_a54 VARCHAR2 := fnd_api.g_miss_char
1588 , p9_a55 VARCHAR2 := fnd_api.g_miss_char
1589 , p9_a56 VARCHAR2 := fnd_api.g_miss_char
1590 , p9_a57 NUMBER := 0-1962.0724
1591 , p9_a58 NUMBER := 0-1962.0724
1592 , p9_a59 NUMBER := 0-1962.0724
1593 , p9_a60 VARCHAR2 := fnd_api.g_miss_char
1594 , p9_a61 VARCHAR2 := fnd_api.g_miss_char
1595 , p9_a62 VARCHAR2 := fnd_api.g_miss_char
1596 , p9_a63 VARCHAR2 := fnd_api.g_miss_char
1597 , p9_a64 VARCHAR2 := fnd_api.g_miss_char
1598 , p9_a65 VARCHAR2 := fnd_api.g_miss_char
1599 , p9_a66 VARCHAR2 := fnd_api.g_miss_char
1600 , p9_a67 VARCHAR2 := fnd_api.g_miss_char
1601 , p9_a68 NUMBER := 0-1962.0724
1602 , p9_a69 NUMBER := 0-1962.0724
1603 , p9_a70 NUMBER := 0-1962.0724
1604 , p9_a71 NUMBER := 0-1962.0724
1605 , p9_a72 VARCHAR2 := fnd_api.g_miss_char
1606 , p9_a73 VARCHAR2 := fnd_api.g_miss_char
1607 , p9_a74 VARCHAR2 := fnd_api.g_miss_char
1611 , p9_a78 NUMBER := 0-1962.0724
1608 , p9_a75 VARCHAR2 := fnd_api.g_miss_char
1609 , p9_a76 NUMBER := 0-1962.0724
1610 , p9_a77 NUMBER := 0-1962.0724
1612 , p9_a79 DATE := fnd_api.g_miss_date
1613 , p9_a80 VARCHAR2 := fnd_api.g_miss_char
1614 , p9_a81 VARCHAR2 := fnd_api.g_miss_char
1615 , p9_a82 NUMBER := 0-1962.0724
1616 , p9_a83 DATE := fnd_api.g_miss_date
1617 , p9_a84 DATE := fnd_api.g_miss_date
1618 , p9_a85 VARCHAR2 := fnd_api.g_miss_char
1619 , p9_a86 NUMBER := 0-1962.0724
1620 , p9_a87 NUMBER := 0-1962.0724
1621 , p9_a88 NUMBER := 0-1962.0724
1622 , p9_a89 VARCHAR2 := fnd_api.g_miss_char
1623 , p9_a90 VARCHAR2 := fnd_api.g_miss_char
1624 , p9_a91 NUMBER := 0-1962.0724
1625 , p9_a92 NUMBER := 0-1962.0724
1626 )
1627
1628 as
1629 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1630 ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1631 ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1632 ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1633 ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1634 ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1635 ddindx binary_integer; indx binary_integer;
1636 begin
1637
1638 -- copy data to the local IN or IN-OUT args, if any
1639
1640
1641
1642
1643
1644
1645
1646
1647 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
1648 , p8_a1
1649 );
1650
1651 ddp_sales_lead_rec.sales_lead_id := rosetta_g_miss_num_map(p9_a0);
1652 ddp_sales_lead_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
1653 ddp_sales_lead_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
1654 ddp_sales_lead_rec.creation_date := rosetta_g_miss_date_in_map(p9_a3);
1655 ddp_sales_lead_rec.created_by := rosetta_g_miss_num_map(p9_a4);
1656 ddp_sales_lead_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
1657 ddp_sales_lead_rec.request_id := rosetta_g_miss_num_map(p9_a6);
1658 ddp_sales_lead_rec.program_application_id := rosetta_g_miss_num_map(p9_a7);
1659 ddp_sales_lead_rec.program_id := rosetta_g_miss_num_map(p9_a8);
1660 ddp_sales_lead_rec.program_update_date := rosetta_g_miss_date_in_map(p9_a9);
1661 ddp_sales_lead_rec.lead_number := p9_a10;
1662 ddp_sales_lead_rec.status_code := p9_a11;
1663 ddp_sales_lead_rec.customer_id := rosetta_g_miss_num_map(p9_a12);
1664 ddp_sales_lead_rec.address_id := rosetta_g_miss_num_map(p9_a13);
1665 ddp_sales_lead_rec.source_promotion_id := rosetta_g_miss_num_map(p9_a14);
1666 ddp_sales_lead_rec.initiating_contact_id := rosetta_g_miss_num_map(p9_a15);
1667 ddp_sales_lead_rec.orig_system_reference := p9_a16;
1668 ddp_sales_lead_rec.contact_role_code := p9_a17;
1669 ddp_sales_lead_rec.channel_code := p9_a18;
1670 ddp_sales_lead_rec.budget_amount := rosetta_g_miss_num_map(p9_a19);
1671 ddp_sales_lead_rec.currency_code := p9_a20;
1672 ddp_sales_lead_rec.decision_timeframe_code := p9_a21;
1673 ddp_sales_lead_rec.close_reason := p9_a22;
1674 ddp_sales_lead_rec.lead_rank_id := rosetta_g_miss_num_map(p9_a23);
1675 ddp_sales_lead_rec.lead_rank_code := p9_a24;
1676 ddp_sales_lead_rec.parent_project := p9_a25;
1677 ddp_sales_lead_rec.description := p9_a26;
1678 ddp_sales_lead_rec.attribute_category := p9_a27;
1679 ddp_sales_lead_rec.attribute1 := p9_a28;
1680 ddp_sales_lead_rec.attribute2 := p9_a29;
1681 ddp_sales_lead_rec.attribute3 := p9_a30;
1682 ddp_sales_lead_rec.attribute4 := p9_a31;
1683 ddp_sales_lead_rec.attribute5 := p9_a32;
1684 ddp_sales_lead_rec.attribute6 := p9_a33;
1685 ddp_sales_lead_rec.attribute7 := p9_a34;
1686 ddp_sales_lead_rec.attribute8 := p9_a35;
1687 ddp_sales_lead_rec.attribute9 := p9_a36;
1688 ddp_sales_lead_rec.attribute10 := p9_a37;
1689 ddp_sales_lead_rec.attribute11 := p9_a38;
1690 ddp_sales_lead_rec.attribute12 := p9_a39;
1691 ddp_sales_lead_rec.attribute13 := p9_a40;
1692 ddp_sales_lead_rec.attribute14 := p9_a41;
1693 ddp_sales_lead_rec.attribute15 := p9_a42;
1694 ddp_sales_lead_rec.assign_to_person_id := rosetta_g_miss_num_map(p9_a43);
1695 ddp_sales_lead_rec.assign_to_salesforce_id := rosetta_g_miss_num_map(p9_a44);
1696 ddp_sales_lead_rec.assign_sales_group_id := rosetta_g_miss_num_map(p9_a45);
1697 ddp_sales_lead_rec.assign_date := rosetta_g_miss_date_in_map(p9_a46);
1698 ddp_sales_lead_rec.budget_status_code := p9_a47;
1699 ddp_sales_lead_rec.accept_flag := p9_a48;
1700 ddp_sales_lead_rec.vehicle_response_code := p9_a49;
1701 ddp_sales_lead_rec.total_score := rosetta_g_miss_num_map(p9_a50);
1702 ddp_sales_lead_rec.scorecard_id := rosetta_g_miss_num_map(p9_a51);
1703 ddp_sales_lead_rec.keep_flag := p9_a52;
1704 ddp_sales_lead_rec.urgent_flag := p9_a53;
1705 ddp_sales_lead_rec.import_flag := p9_a54;
1706 ddp_sales_lead_rec.reject_reason_code := p9_a55;
1707 ddp_sales_lead_rec.deleted_flag := p9_a56;
1708 ddp_sales_lead_rec.offer_id := rosetta_g_miss_num_map(p9_a57);
1709 ddp_sales_lead_rec.incumbent_partner_party_id := rosetta_g_miss_num_map(p9_a58);
1710 ddp_sales_lead_rec.incumbent_partner_resource_id := rosetta_g_miss_num_map(p9_a59);
1711 ddp_sales_lead_rec.prm_exec_sponsor_flag := p9_a60;
1712 ddp_sales_lead_rec.prm_prj_lead_in_place_flag := p9_a61;
1713 ddp_sales_lead_rec.prm_sales_lead_type := p9_a62;
1714 ddp_sales_lead_rec.prm_ind_classification_code := p9_a63;
1718 ddp_sales_lead_rec.auto_assignment_type := p9_a67;
1715 ddp_sales_lead_rec.qualified_flag := p9_a64;
1716 ddp_sales_lead_rec.orig_system_code := p9_a65;
1717 ddp_sales_lead_rec.prm_assignment_type := p9_a66;
1719 ddp_sales_lead_rec.primary_contact_party_id := rosetta_g_miss_num_map(p9_a68);
1720 ddp_sales_lead_rec.primary_cnt_person_party_id := rosetta_g_miss_num_map(p9_a69);
1721 ddp_sales_lead_rec.primary_contact_phone_id := rosetta_g_miss_num_map(p9_a70);
1722 ddp_sales_lead_rec.referred_by := rosetta_g_miss_num_map(p9_a71);
1723 ddp_sales_lead_rec.referral_type := p9_a72;
1724 ddp_sales_lead_rec.referral_status := p9_a73;
1725 ddp_sales_lead_rec.ref_decline_reason := p9_a74;
1726 ddp_sales_lead_rec.ref_comm_ltr_status := p9_a75;
1727 ddp_sales_lead_rec.ref_order_number := rosetta_g_miss_num_map(p9_a76);
1728 ddp_sales_lead_rec.ref_order_amt := rosetta_g_miss_num_map(p9_a77);
1729 ddp_sales_lead_rec.ref_comm_amt := rosetta_g_miss_num_map(p9_a78);
1730 ddp_sales_lead_rec.lead_date := rosetta_g_miss_date_in_map(p9_a79);
1731 ddp_sales_lead_rec.source_system := p9_a80;
1732 ddp_sales_lead_rec.country := p9_a81;
1733 ddp_sales_lead_rec.total_amount := rosetta_g_miss_num_map(p9_a82);
1734 ddp_sales_lead_rec.expiration_date := rosetta_g_miss_date_in_map(p9_a83);
1735 ddp_sales_lead_rec.lead_engine_run_date := rosetta_g_miss_date_in_map(p9_a84);
1736 ddp_sales_lead_rec.lead_rank_ind := p9_a85;
1737 ddp_sales_lead_rec.current_reroutes := rosetta_g_miss_num_map(p9_a86);
1738 ddp_sales_lead_rec.marketing_score := rosetta_g_miss_num_map(p9_a87);
1739 ddp_sales_lead_rec.interaction_score := rosetta_g_miss_num_map(p9_a88);
1740 ddp_sales_lead_rec.source_primary_reference := p9_a89;
1741 ddp_sales_lead_rec.source_secondary_reference := p9_a90;
1742 ddp_sales_lead_rec.sales_methodology_id := rosetta_g_miss_num_map(p9_a91);
1743 ddp_sales_lead_rec.sales_stage_id := rosetta_g_miss_num_map(p9_a92);
1744
1745 as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p10_a0
1746 , p10_a1
1747 , p10_a2
1748 , p10_a3
1749 , p10_a4
1750 , p10_a5
1751 , p10_a6
1752 , p10_a7
1753 , p10_a8
1754 , p10_a9
1755 , p10_a10
1756 , p10_a11
1757 , p10_a12
1758 , p10_a13
1759 , p10_a14
1760 , p10_a15
1761 , p10_a16
1762 , p10_a17
1763 , p10_a18
1764 , p10_a19
1765 , p10_a20
1766 , p10_a21
1767 , p10_a22
1768 , p10_a23
1769 , p10_a24
1770 , p10_a25
1771 , p10_a26
1772 , p10_a27
1773 , p10_a28
1774 , p10_a29
1775 , p10_a30
1776 , p10_a31
1777 , p10_a32
1778 , p10_a33
1779 , p10_a34
1780 , p10_a35
1781 , p10_a36
1782 );
1783
1784 as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p11_a0
1785 , p11_a1
1786 , p11_a2
1787 , p11_a3
1788 , p11_a4
1789 , p11_a5
1790 , p11_a6
1791 , p11_a7
1792 , p11_a8
1793 , p11_a9
1794 , p11_a10
1795 , p11_a11
1796 , p11_a12
1797 , p11_a13
1798 , p11_a14
1799 , p11_a15
1800 , p11_a16
1801 , p11_a17
1802 , p11_a18
1803 , p11_a19
1804 , p11_a20
1805 , p11_a21
1806 , p11_a22
1807 , p11_a23
1808 , p11_a24
1809 , p11_a25
1810 , p11_a26
1811 , p11_a27
1812 , p11_a28
1813 , p11_a29
1814 , p11_a30
1815 , p11_a31
1816 , p11_a32
1817 , p11_a33
1818 , p11_a34
1819 , p11_a35
1820 );
1821
1822
1823
1824
1825
1826
1827
1828 -- here's the delegated call to the old PL/SQL routine
1829 as_sales_leads_pub.create_sales_lead(p_api_version_number,
1830 p_init_msg_list,
1831 p_commit,
1832 p_validation_level,
1833 p_check_access_flag,
1834 p_admin_flag,
1835 p_admin_group_id,
1836 p_identity_salesforce_id,
1837 ddp_sales_lead_profile_tbl,
1838 ddp_sales_lead_rec,
1839 ddp_sales_lead_line_tbl,
1840 ddp_sales_lead_contact_tbl,
1841 x_sales_lead_id,
1842 ddx_sales_lead_line_out_tbl,
1843 ddx_sales_lead_cnt_out_tbl,
1844 x_return_status,
1845 x_msg_count,
1846 x_msg_data);
1847
1848 -- copy data back from the local variables to OUT or IN-OUT args, if any
1849
1850
1851
1852
1853
1854
1855
1856
1857
1858
1859
1860
1861
1862 as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p13_a0
1863 , p13_a1
1864 );
1865
1866 as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p14_a0
1867 , p14_a1
1868 );
1869
1870
1871
1872 end;
1873
1874 procedure update_sales_lead(p_api_version_number NUMBER
1875 , p_init_msg_list VARCHAR2
1876 , p_commit VARCHAR2
1877 , p_validation_level NUMBER
1881 , p_identity_salesforce_id NUMBER
1878 , p_check_access_flag VARCHAR2
1879 , p_admin_flag VARCHAR2
1880 , p_admin_group_id NUMBER
1882 , p8_a0 JTF_VARCHAR2_TABLE_100
1883 , p8_a1 JTF_VARCHAR2_TABLE_300
1884 , x_return_status out nocopy VARCHAR2
1885 , x_msg_count out nocopy NUMBER
1886 , x_msg_data out nocopy VARCHAR2
1887 , p9_a0 NUMBER := 0-1962.0724
1888 , p9_a1 DATE := fnd_api.g_miss_date
1889 , p9_a2 NUMBER := 0-1962.0724
1890 , p9_a3 DATE := fnd_api.g_miss_date
1891 , p9_a4 NUMBER := 0-1962.0724
1892 , p9_a5 NUMBER := 0-1962.0724
1893 , p9_a6 NUMBER := 0-1962.0724
1894 , p9_a7 NUMBER := 0-1962.0724
1895 , p9_a8 NUMBER := 0-1962.0724
1896 , p9_a9 DATE := fnd_api.g_miss_date
1897 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
1898 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
1899 , p9_a12 NUMBER := 0-1962.0724
1900 , p9_a13 NUMBER := 0-1962.0724
1901 , p9_a14 NUMBER := 0-1962.0724
1902 , p9_a15 NUMBER := 0-1962.0724
1903 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
1904 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
1905 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
1906 , p9_a19 NUMBER := 0-1962.0724
1907 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
1908 , p9_a21 VARCHAR2 := fnd_api.g_miss_char
1909 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
1910 , p9_a23 NUMBER := 0-1962.0724
1911 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
1912 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
1913 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
1914 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
1915 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
1916 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
1917 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
1918 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
1919 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
1920 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
1921 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
1922 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
1923 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
1924 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
1925 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
1926 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
1927 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
1928 , p9_a41 VARCHAR2 := fnd_api.g_miss_char
1929 , p9_a42 VARCHAR2 := fnd_api.g_miss_char
1930 , p9_a43 NUMBER := 0-1962.0724
1931 , p9_a44 NUMBER := 0-1962.0724
1932 , p9_a45 NUMBER := 0-1962.0724
1933 , p9_a46 DATE := fnd_api.g_miss_date
1934 , p9_a47 VARCHAR2 := fnd_api.g_miss_char
1935 , p9_a48 VARCHAR2 := fnd_api.g_miss_char
1936 , p9_a49 VARCHAR2 := fnd_api.g_miss_char
1937 , p9_a50 NUMBER := 0-1962.0724
1938 , p9_a51 NUMBER := 0-1962.0724
1939 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
1940 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
1941 , p9_a54 VARCHAR2 := fnd_api.g_miss_char
1942 , p9_a55 VARCHAR2 := fnd_api.g_miss_char
1943 , p9_a56 VARCHAR2 := fnd_api.g_miss_char
1944 , p9_a57 NUMBER := 0-1962.0724
1945 , p9_a58 NUMBER := 0-1962.0724
1946 , p9_a59 NUMBER := 0-1962.0724
1947 , p9_a60 VARCHAR2 := fnd_api.g_miss_char
1948 , p9_a61 VARCHAR2 := fnd_api.g_miss_char
1949 , p9_a62 VARCHAR2 := fnd_api.g_miss_char
1950 , p9_a63 VARCHAR2 := fnd_api.g_miss_char
1951 , p9_a64 VARCHAR2 := fnd_api.g_miss_char
1952 , p9_a65 VARCHAR2 := fnd_api.g_miss_char
1953 , p9_a66 VARCHAR2 := fnd_api.g_miss_char
1954 , p9_a67 VARCHAR2 := fnd_api.g_miss_char
1955 , p9_a68 NUMBER := 0-1962.0724
1956 , p9_a69 NUMBER := 0-1962.0724
1957 , p9_a70 NUMBER := 0-1962.0724
1958 , p9_a71 NUMBER := 0-1962.0724
1959 , p9_a72 VARCHAR2 := fnd_api.g_miss_char
1960 , p9_a73 VARCHAR2 := fnd_api.g_miss_char
1961 , p9_a74 VARCHAR2 := fnd_api.g_miss_char
1962 , p9_a75 VARCHAR2 := fnd_api.g_miss_char
1963 , p9_a76 NUMBER := 0-1962.0724
1964 , p9_a77 NUMBER := 0-1962.0724
1965 , p9_a78 NUMBER := 0-1962.0724
1966 , p9_a79 DATE := fnd_api.g_miss_date
1967 , p9_a80 VARCHAR2 := fnd_api.g_miss_char
1968 , p9_a81 VARCHAR2 := fnd_api.g_miss_char
1969 , p9_a82 NUMBER := 0-1962.0724
1970 , p9_a83 DATE := fnd_api.g_miss_date
1971 , p9_a84 DATE := fnd_api.g_miss_date
1972 , p9_a85 VARCHAR2 := fnd_api.g_miss_char
1973 , p9_a86 NUMBER := 0-1962.0724
1974 , p9_a87 NUMBER := 0-1962.0724
1975 , p9_a88 NUMBER := 0-1962.0724
1976 , p9_a89 VARCHAR2 := fnd_api.g_miss_char
1977 , p9_a90 VARCHAR2 := fnd_api.g_miss_char
1978 , p9_a91 NUMBER := 0-1962.0724
1979 , p9_a92 NUMBER := 0-1962.0724
1980 )
1981
1982 as
1983 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1984 ddp_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1985 ddindx binary_integer; indx binary_integer;
1986 begin
1987
1988 -- copy data to the local IN or IN-OUT args, if any
1989
1990
1991
1992
1993
1994
1995
1996
1997 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
1998 , p8_a1
1999 );
2000
2001 ddp_sales_lead_rec.sales_lead_id := rosetta_g_miss_num_map(p9_a0);
2002 ddp_sales_lead_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
2003 ddp_sales_lead_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
2004 ddp_sales_lead_rec.creation_date := rosetta_g_miss_date_in_map(p9_a3);
2008 ddp_sales_lead_rec.program_application_id := rosetta_g_miss_num_map(p9_a7);
2005 ddp_sales_lead_rec.created_by := rosetta_g_miss_num_map(p9_a4);
2006 ddp_sales_lead_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
2007 ddp_sales_lead_rec.request_id := rosetta_g_miss_num_map(p9_a6);
2009 ddp_sales_lead_rec.program_id := rosetta_g_miss_num_map(p9_a8);
2010 ddp_sales_lead_rec.program_update_date := rosetta_g_miss_date_in_map(p9_a9);
2011 ddp_sales_lead_rec.lead_number := p9_a10;
2012 ddp_sales_lead_rec.status_code := p9_a11;
2013 ddp_sales_lead_rec.customer_id := rosetta_g_miss_num_map(p9_a12);
2014 ddp_sales_lead_rec.address_id := rosetta_g_miss_num_map(p9_a13);
2015 ddp_sales_lead_rec.source_promotion_id := rosetta_g_miss_num_map(p9_a14);
2016 ddp_sales_lead_rec.initiating_contact_id := rosetta_g_miss_num_map(p9_a15);
2017 ddp_sales_lead_rec.orig_system_reference := p9_a16;
2018 ddp_sales_lead_rec.contact_role_code := p9_a17;
2019 ddp_sales_lead_rec.channel_code := p9_a18;
2020 ddp_sales_lead_rec.budget_amount := rosetta_g_miss_num_map(p9_a19);
2021 ddp_sales_lead_rec.currency_code := p9_a20;
2022 ddp_sales_lead_rec.decision_timeframe_code := p9_a21;
2023 ddp_sales_lead_rec.close_reason := p9_a22;
2024 ddp_sales_lead_rec.lead_rank_id := rosetta_g_miss_num_map(p9_a23);
2025 ddp_sales_lead_rec.lead_rank_code := p9_a24;
2026 ddp_sales_lead_rec.parent_project := p9_a25;
2027 ddp_sales_lead_rec.description := p9_a26;
2028 ddp_sales_lead_rec.attribute_category := p9_a27;
2029 ddp_sales_lead_rec.attribute1 := p9_a28;
2030 ddp_sales_lead_rec.attribute2 := p9_a29;
2031 ddp_sales_lead_rec.attribute3 := p9_a30;
2032 ddp_sales_lead_rec.attribute4 := p9_a31;
2033 ddp_sales_lead_rec.attribute5 := p9_a32;
2034 ddp_sales_lead_rec.attribute6 := p9_a33;
2035 ddp_sales_lead_rec.attribute7 := p9_a34;
2036 ddp_sales_lead_rec.attribute8 := p9_a35;
2037 ddp_sales_lead_rec.attribute9 := p9_a36;
2038 ddp_sales_lead_rec.attribute10 := p9_a37;
2039 ddp_sales_lead_rec.attribute11 := p9_a38;
2040 ddp_sales_lead_rec.attribute12 := p9_a39;
2041 ddp_sales_lead_rec.attribute13 := p9_a40;
2042 ddp_sales_lead_rec.attribute14 := p9_a41;
2043 ddp_sales_lead_rec.attribute15 := p9_a42;
2044 ddp_sales_lead_rec.assign_to_person_id := rosetta_g_miss_num_map(p9_a43);
2045 ddp_sales_lead_rec.assign_to_salesforce_id := rosetta_g_miss_num_map(p9_a44);
2046 ddp_sales_lead_rec.assign_sales_group_id := rosetta_g_miss_num_map(p9_a45);
2047 ddp_sales_lead_rec.assign_date := rosetta_g_miss_date_in_map(p9_a46);
2048 ddp_sales_lead_rec.budget_status_code := p9_a47;
2049 ddp_sales_lead_rec.accept_flag := p9_a48;
2050 ddp_sales_lead_rec.vehicle_response_code := p9_a49;
2051 ddp_sales_lead_rec.total_score := rosetta_g_miss_num_map(p9_a50);
2052 ddp_sales_lead_rec.scorecard_id := rosetta_g_miss_num_map(p9_a51);
2053 ddp_sales_lead_rec.keep_flag := p9_a52;
2054 ddp_sales_lead_rec.urgent_flag := p9_a53;
2055 ddp_sales_lead_rec.import_flag := p9_a54;
2056 ddp_sales_lead_rec.reject_reason_code := p9_a55;
2057 ddp_sales_lead_rec.deleted_flag := p9_a56;
2058 ddp_sales_lead_rec.offer_id := rosetta_g_miss_num_map(p9_a57);
2059 ddp_sales_lead_rec.incumbent_partner_party_id := rosetta_g_miss_num_map(p9_a58);
2060 ddp_sales_lead_rec.incumbent_partner_resource_id := rosetta_g_miss_num_map(p9_a59);
2061 ddp_sales_lead_rec.prm_exec_sponsor_flag := p9_a60;
2062 ddp_sales_lead_rec.prm_prj_lead_in_place_flag := p9_a61;
2063 ddp_sales_lead_rec.prm_sales_lead_type := p9_a62;
2064 ddp_sales_lead_rec.prm_ind_classification_code := p9_a63;
2065 ddp_sales_lead_rec.qualified_flag := p9_a64;
2066 ddp_sales_lead_rec.orig_system_code := p9_a65;
2067 ddp_sales_lead_rec.prm_assignment_type := p9_a66;
2068 ddp_sales_lead_rec.auto_assignment_type := p9_a67;
2069 ddp_sales_lead_rec.primary_contact_party_id := rosetta_g_miss_num_map(p9_a68);
2070 ddp_sales_lead_rec.primary_cnt_person_party_id := rosetta_g_miss_num_map(p9_a69);
2071 ddp_sales_lead_rec.primary_contact_phone_id := rosetta_g_miss_num_map(p9_a70);
2072 ddp_sales_lead_rec.referred_by := rosetta_g_miss_num_map(p9_a71);
2073 ddp_sales_lead_rec.referral_type := p9_a72;
2074 ddp_sales_lead_rec.referral_status := p9_a73;
2075 ddp_sales_lead_rec.ref_decline_reason := p9_a74;
2076 ddp_sales_lead_rec.ref_comm_ltr_status := p9_a75;
2077 ddp_sales_lead_rec.ref_order_number := rosetta_g_miss_num_map(p9_a76);
2078 ddp_sales_lead_rec.ref_order_amt := rosetta_g_miss_num_map(p9_a77);
2079 ddp_sales_lead_rec.ref_comm_amt := rosetta_g_miss_num_map(p9_a78);
2080 ddp_sales_lead_rec.lead_date := rosetta_g_miss_date_in_map(p9_a79);
2081 ddp_sales_lead_rec.source_system := p9_a80;
2082 ddp_sales_lead_rec.country := p9_a81;
2083 ddp_sales_lead_rec.total_amount := rosetta_g_miss_num_map(p9_a82);
2084 ddp_sales_lead_rec.expiration_date := rosetta_g_miss_date_in_map(p9_a83);
2085 ddp_sales_lead_rec.lead_engine_run_date := rosetta_g_miss_date_in_map(p9_a84);
2086 ddp_sales_lead_rec.lead_rank_ind := p9_a85;
2087 ddp_sales_lead_rec.current_reroutes := rosetta_g_miss_num_map(p9_a86);
2088 ddp_sales_lead_rec.marketing_score := rosetta_g_miss_num_map(p9_a87);
2089 ddp_sales_lead_rec.interaction_score := rosetta_g_miss_num_map(p9_a88);
2090 ddp_sales_lead_rec.source_primary_reference := p9_a89;
2091 ddp_sales_lead_rec.source_secondary_reference := p9_a90;
2092 ddp_sales_lead_rec.sales_methodology_id := rosetta_g_miss_num_map(p9_a91);
2093 ddp_sales_lead_rec.sales_stage_id := rosetta_g_miss_num_map(p9_a92);
2094
2095
2096
2097
2098 -- here's the delegated call to the old PL/SQL routine
2102 p_validation_level,
2099 as_sales_leads_pub.update_sales_lead(p_api_version_number,
2100 p_init_msg_list,
2101 p_commit,
2103 p_check_access_flag,
2104 p_admin_flag,
2105 p_admin_group_id,
2106 p_identity_salesforce_id,
2107 ddp_sales_lead_profile_tbl,
2108 ddp_sales_lead_rec,
2109 x_return_status,
2110 x_msg_count,
2111 x_msg_data);
2112
2113 -- copy data back from the local variables to OUT or IN-OUT args, if any
2114
2115
2116
2117
2118
2119
2120
2121
2122
2123
2124
2125
2126 end;
2127
2128 procedure create_sales_lead_lines(p_api_version_number NUMBER
2129 , p_init_msg_list VARCHAR2
2130 , p_commit VARCHAR2
2131 , p_validation_level NUMBER
2132 , p_check_access_flag VARCHAR2
2133 , p_admin_flag VARCHAR2
2134 , p_admin_group_id NUMBER
2135 , p_identity_salesforce_id NUMBER
2136 , p8_a0 JTF_VARCHAR2_TABLE_100
2137 , p8_a1 JTF_VARCHAR2_TABLE_300
2138 , p9_a0 JTF_NUMBER_TABLE
2139 , p9_a1 JTF_DATE_TABLE
2140 , p9_a2 JTF_NUMBER_TABLE
2141 , p9_a3 JTF_DATE_TABLE
2142 , p9_a4 JTF_NUMBER_TABLE
2143 , p9_a5 JTF_NUMBER_TABLE
2144 , p9_a6 JTF_NUMBER_TABLE
2145 , p9_a7 JTF_NUMBER_TABLE
2146 , p9_a8 JTF_NUMBER_TABLE
2147 , p9_a9 JTF_DATE_TABLE
2148 , p9_a10 JTF_NUMBER_TABLE
2149 , p9_a11 JTF_VARCHAR2_TABLE_100
2150 , p9_a12 JTF_NUMBER_TABLE
2151 , p9_a13 JTF_NUMBER_TABLE
2152 , p9_a14 JTF_NUMBER_TABLE
2153 , p9_a15 JTF_NUMBER_TABLE
2154 , p9_a16 JTF_VARCHAR2_TABLE_100
2155 , p9_a17 JTF_NUMBER_TABLE
2156 , p9_a18 JTF_NUMBER_TABLE
2157 , p9_a19 JTF_NUMBER_TABLE
2158 , p9_a20 JTF_VARCHAR2_TABLE_100
2159 , p9_a21 JTF_VARCHAR2_TABLE_200
2160 , p9_a22 JTF_VARCHAR2_TABLE_200
2161 , p9_a23 JTF_VARCHAR2_TABLE_200
2162 , p9_a24 JTF_VARCHAR2_TABLE_200
2163 , p9_a25 JTF_VARCHAR2_TABLE_200
2164 , p9_a26 JTF_VARCHAR2_TABLE_200
2165 , p9_a27 JTF_VARCHAR2_TABLE_200
2166 , p9_a28 JTF_VARCHAR2_TABLE_200
2167 , p9_a29 JTF_VARCHAR2_TABLE_200
2168 , p9_a30 JTF_VARCHAR2_TABLE_200
2169 , p9_a31 JTF_VARCHAR2_TABLE_200
2170 , p9_a32 JTF_VARCHAR2_TABLE_200
2171 , p9_a33 JTF_VARCHAR2_TABLE_200
2172 , p9_a34 JTF_VARCHAR2_TABLE_200
2173 , p9_a35 JTF_VARCHAR2_TABLE_200
2174 , p9_a36 JTF_NUMBER_TABLE
2175 , p_sales_lead_id NUMBER
2176 , p11_a0 out nocopy JTF_NUMBER_TABLE
2177 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
2178 , x_return_status out nocopy VARCHAR2
2179 , x_msg_count out nocopy NUMBER
2180 , x_msg_data out nocopy VARCHAR2
2181 )
2182
2183 as
2184 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2185 ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2186 ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2187 ddindx binary_integer; indx binary_integer;
2188 begin
2189
2190 -- copy data to the local IN or IN-OUT args, if any
2191
2192
2193
2194
2195
2196
2197
2198
2199 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2200 , p8_a1
2201 );
2202
2203 as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0
2204 , p9_a1
2205 , p9_a2
2206 , p9_a3
2207 , p9_a4
2208 , p9_a5
2209 , p9_a6
2210 , p9_a7
2211 , p9_a8
2212 , p9_a9
2213 , p9_a10
2214 , p9_a11
2215 , p9_a12
2216 , p9_a13
2217 , p9_a14
2218 , p9_a15
2219 , p9_a16
2220 , p9_a17
2221 , p9_a18
2222 , p9_a19
2223 , p9_a20
2224 , p9_a21
2225 , p9_a22
2226 , p9_a23
2227 , p9_a24
2228 , p9_a25
2229 , p9_a26
2230 , p9_a27
2231 , p9_a28
2232 , p9_a29
2233 , p9_a30
2234 , p9_a31
2235 , p9_a32
2236 , p9_a33
2237 , p9_a34
2238 , p9_a35
2239 , p9_a36
2240 );
2241
2242
2243
2244
2245
2246
2247 -- here's the delegated call to the old PL/SQL routine
2248 as_sales_leads_pub.create_sales_lead_lines(p_api_version_number,
2249 p_init_msg_list,
2250 p_commit,
2251 p_validation_level,
2252 p_check_access_flag,
2253 p_admin_flag,
2254 p_admin_group_id,
2255 p_identity_salesforce_id,
2256 ddp_sales_lead_profile_tbl,
2257 ddp_sales_lead_line_tbl,
2258 p_sales_lead_id,
2259 ddx_sales_lead_line_out_tbl,
2260 x_return_status,
2261 x_msg_count,
2262 x_msg_data);
2263
2264 -- copy data back from the local variables to OUT or IN-OUT args, if any
2265
2266
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276 as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p11_a0
2277 , p11_a1
2278 );
2279
2283
2280
2281
2282 end;
2284 procedure update_sales_lead_lines(p_api_version_number NUMBER
2285 , p_init_msg_list VARCHAR2
2286 , p_commit VARCHAR2
2287 , p_validation_level NUMBER
2288 , p_check_access_flag VARCHAR2
2289 , p_admin_flag VARCHAR2
2290 , p_admin_group_id NUMBER
2291 , p_identity_salesforce_id NUMBER
2292 , p8_a0 JTF_VARCHAR2_TABLE_100
2293 , p8_a1 JTF_VARCHAR2_TABLE_300
2294 , p9_a0 JTF_NUMBER_TABLE
2295 , p9_a1 JTF_DATE_TABLE
2296 , p9_a2 JTF_NUMBER_TABLE
2297 , p9_a3 JTF_DATE_TABLE
2298 , p9_a4 JTF_NUMBER_TABLE
2299 , p9_a5 JTF_NUMBER_TABLE
2300 , p9_a6 JTF_NUMBER_TABLE
2301 , p9_a7 JTF_NUMBER_TABLE
2302 , p9_a8 JTF_NUMBER_TABLE
2303 , p9_a9 JTF_DATE_TABLE
2304 , p9_a10 JTF_NUMBER_TABLE
2305 , p9_a11 JTF_VARCHAR2_TABLE_100
2306 , p9_a12 JTF_NUMBER_TABLE
2307 , p9_a13 JTF_NUMBER_TABLE
2308 , p9_a14 JTF_NUMBER_TABLE
2309 , p9_a15 JTF_NUMBER_TABLE
2310 , p9_a16 JTF_VARCHAR2_TABLE_100
2311 , p9_a17 JTF_NUMBER_TABLE
2312 , p9_a18 JTF_NUMBER_TABLE
2313 , p9_a19 JTF_NUMBER_TABLE
2314 , p9_a20 JTF_VARCHAR2_TABLE_100
2315 , p9_a21 JTF_VARCHAR2_TABLE_200
2316 , p9_a22 JTF_VARCHAR2_TABLE_200
2317 , p9_a23 JTF_VARCHAR2_TABLE_200
2318 , p9_a24 JTF_VARCHAR2_TABLE_200
2319 , p9_a25 JTF_VARCHAR2_TABLE_200
2320 , p9_a26 JTF_VARCHAR2_TABLE_200
2321 , p9_a27 JTF_VARCHAR2_TABLE_200
2322 , p9_a28 JTF_VARCHAR2_TABLE_200
2323 , p9_a29 JTF_VARCHAR2_TABLE_200
2324 , p9_a30 JTF_VARCHAR2_TABLE_200
2325 , p9_a31 JTF_VARCHAR2_TABLE_200
2326 , p9_a32 JTF_VARCHAR2_TABLE_200
2327 , p9_a33 JTF_VARCHAR2_TABLE_200
2328 , p9_a34 JTF_VARCHAR2_TABLE_200
2329 , p9_a35 JTF_VARCHAR2_TABLE_200
2330 , p9_a36 JTF_NUMBER_TABLE
2331 , p10_a0 out nocopy JTF_NUMBER_TABLE
2332 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
2333 , x_return_status out nocopy VARCHAR2
2334 , x_msg_count out nocopy NUMBER
2335 , x_msg_data out nocopy VARCHAR2
2336 )
2337
2338 as
2339 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2340 ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2341 ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2342 ddindx binary_integer; indx binary_integer;
2343 begin
2344
2345 -- copy data to the local IN or IN-OUT args, if any
2346
2347
2348
2349
2350
2351
2352
2353
2354 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2355 , p8_a1
2356 );
2357
2358 as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0
2359 , p9_a1
2360 , p9_a2
2361 , p9_a3
2362 , p9_a4
2363 , p9_a5
2364 , p9_a6
2365 , p9_a7
2366 , p9_a8
2367 , p9_a9
2368 , p9_a10
2369 , p9_a11
2370 , p9_a12
2371 , p9_a13
2372 , p9_a14
2373 , p9_a15
2374 , p9_a16
2375 , p9_a17
2376 , p9_a18
2377 , p9_a19
2378 , p9_a20
2379 , p9_a21
2380 , p9_a22
2381 , p9_a23
2382 , p9_a24
2383 , p9_a25
2384 , p9_a26
2385 , p9_a27
2386 , p9_a28
2387 , p9_a29
2388 , p9_a30
2389 , p9_a31
2390 , p9_a32
2391 , p9_a33
2392 , p9_a34
2393 , p9_a35
2394 , p9_a36
2395 );
2396
2397
2398
2399
2400
2401 -- here's the delegated call to the old PL/SQL routine
2402 as_sales_leads_pub.update_sales_lead_lines(p_api_version_number,
2403 p_init_msg_list,
2404 p_commit,
2405 p_validation_level,
2406 p_check_access_flag,
2407 p_admin_flag,
2408 p_admin_group_id,
2409 p_identity_salesforce_id,
2410 ddp_sales_lead_profile_tbl,
2411 ddp_sales_lead_line_tbl,
2412 ddx_sales_lead_line_out_tbl,
2413 x_return_status,
2414 x_msg_count,
2415 x_msg_data);
2416
2417 -- copy data back from the local variables to OUT or IN-OUT args, if any
2418
2419
2420
2421
2422
2423
2424
2425
2426
2427
2428 as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p10_a0
2429 , p10_a1
2430 );
2431
2432
2433
2434 end;
2435
2436 procedure delete_sales_lead_lines(p_api_version_number NUMBER
2437 , p_init_msg_list VARCHAR2
2438 , p_commit VARCHAR2
2439 , p_validation_level NUMBER
2440 , p_check_access_flag VARCHAR2
2441 , p_admin_flag VARCHAR2
2442 , p_admin_group_id NUMBER
2443 , p_identity_salesforce_id NUMBER
2444 , p8_a0 JTF_VARCHAR2_TABLE_100
2445 , p8_a1 JTF_VARCHAR2_TABLE_300
2446 , p9_a0 JTF_NUMBER_TABLE
2447 , p9_a1 JTF_DATE_TABLE
2448 , p9_a2 JTF_NUMBER_TABLE
2449 , p9_a3 JTF_DATE_TABLE
2450 , p9_a4 JTF_NUMBER_TABLE
2451 , p9_a5 JTF_NUMBER_TABLE
2452 , p9_a6 JTF_NUMBER_TABLE
2453 , p9_a7 JTF_NUMBER_TABLE
2454 , p9_a8 JTF_NUMBER_TABLE
2455 , p9_a9 JTF_DATE_TABLE
2456 , p9_a10 JTF_NUMBER_TABLE
2457 , p9_a11 JTF_VARCHAR2_TABLE_100
2458 , p9_a12 JTF_NUMBER_TABLE
2459 , p9_a13 JTF_NUMBER_TABLE
2460 , p9_a14 JTF_NUMBER_TABLE
2461 , p9_a15 JTF_NUMBER_TABLE
2462 , p9_a16 JTF_VARCHAR2_TABLE_100
2463 , p9_a17 JTF_NUMBER_TABLE
2464 , p9_a18 JTF_NUMBER_TABLE
2465 , p9_a19 JTF_NUMBER_TABLE
2466 , p9_a20 JTF_VARCHAR2_TABLE_100
2467 , p9_a21 JTF_VARCHAR2_TABLE_200
2468 , p9_a22 JTF_VARCHAR2_TABLE_200
2469 , p9_a23 JTF_VARCHAR2_TABLE_200
2470 , p9_a24 JTF_VARCHAR2_TABLE_200
2471 , p9_a25 JTF_VARCHAR2_TABLE_200
2472 , p9_a26 JTF_VARCHAR2_TABLE_200
2473 , p9_a27 JTF_VARCHAR2_TABLE_200
2474 , p9_a28 JTF_VARCHAR2_TABLE_200
2475 , p9_a29 JTF_VARCHAR2_TABLE_200
2476 , p9_a30 JTF_VARCHAR2_TABLE_200
2477 , p9_a31 JTF_VARCHAR2_TABLE_200
2478 , p9_a32 JTF_VARCHAR2_TABLE_200
2479 , p9_a33 JTF_VARCHAR2_TABLE_200
2480 , p9_a34 JTF_VARCHAR2_TABLE_200
2481 , p9_a35 JTF_VARCHAR2_TABLE_200
2482 , p9_a36 JTF_NUMBER_TABLE
2483 , p10_a0 out nocopy JTF_NUMBER_TABLE
2484 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
2485 , x_return_status out nocopy VARCHAR2
2486 , x_msg_count out nocopy NUMBER
2487 , x_msg_data out nocopy VARCHAR2
2488 )
2489
2490 as
2491 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2492 ddp_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
2493 ddx_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
2494 ddindx binary_integer; indx binary_integer;
2495 begin
2496
2497 -- copy data to the local IN or IN-OUT args, if any
2498
2499
2500
2501
2502
2503
2504
2505
2506 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2507 , p8_a1
2508 );
2509
2510 as_sales_leads_pub_w.rosetta_table_copy_in_p7(ddp_sales_lead_line_tbl, p9_a0
2511 , p9_a1
2512 , p9_a2
2513 , p9_a3
2514 , p9_a4
2515 , p9_a5
2516 , p9_a6
2517 , p9_a7
2518 , p9_a8
2519 , p9_a9
2520 , p9_a10
2521 , p9_a11
2522 , p9_a12
2523 , p9_a13
2524 , p9_a14
2525 , p9_a15
2526 , p9_a16
2527 , p9_a17
2528 , p9_a18
2529 , p9_a19
2530 , p9_a20
2531 , p9_a21
2532 , p9_a22
2533 , p9_a23
2534 , p9_a24
2535 , p9_a25
2536 , p9_a26
2537 , p9_a27
2538 , p9_a28
2539 , p9_a29
2540 , p9_a30
2541 , p9_a31
2542 , p9_a32
2543 , p9_a33
2544 , p9_a34
2545 , p9_a35
2546 , p9_a36
2547 );
2548
2549
2550
2551
2552
2553 -- here's the delegated call to the old PL/SQL routine
2554 as_sales_leads_pub.delete_sales_lead_lines(p_api_version_number,
2555 p_init_msg_list,
2556 p_commit,
2557 p_validation_level,
2558 p_check_access_flag,
2559 p_admin_flag,
2560 p_admin_group_id,
2561 p_identity_salesforce_id,
2562 ddp_sales_lead_profile_tbl,
2563 ddp_sales_lead_line_tbl,
2564 ddx_sales_lead_line_out_tbl,
2565 x_return_status,
2566 x_msg_count,
2567 x_msg_data);
2568
2569 -- copy data back from the local variables to OUT or IN-OUT args, if any
2570
2571
2572
2573
2574
2575
2576
2577
2578
2579
2580 as_sales_leads_pub_w.rosetta_table_copy_out_p10(ddx_sales_lead_line_out_tbl, p10_a0
2581 , p10_a1
2582 );
2583
2584
2585
2586 end;
2587
2588 procedure create_sales_lead_contacts(p_api_version_number NUMBER
2589 , p_init_msg_list VARCHAR2
2590 , p_commit VARCHAR2
2591 , p_validation_level NUMBER
2592 , p_check_access_flag VARCHAR2
2593 , p_admin_flag VARCHAR2
2594 , p_admin_group_id NUMBER
2595 , p_identity_salesforce_id NUMBER
2596 , p8_a0 JTF_VARCHAR2_TABLE_100
2597 , p8_a1 JTF_VARCHAR2_TABLE_300
2598 , p9_a0 JTF_NUMBER_TABLE
2599 , p9_a1 JTF_NUMBER_TABLE
2600 , p9_a2 JTF_NUMBER_TABLE
2601 , p9_a3 JTF_DATE_TABLE
2602 , p9_a4 JTF_NUMBER_TABLE
2603 , p9_a5 JTF_DATE_TABLE
2604 , p9_a6 JTF_NUMBER_TABLE
2605 , p9_a7 JTF_NUMBER_TABLE
2609 , p9_a11 JTF_DATE_TABLE
2606 , p9_a8 JTF_NUMBER_TABLE
2607 , p9_a9 JTF_NUMBER_TABLE
2608 , p9_a10 JTF_NUMBER_TABLE
2610 , p9_a12 JTF_VARCHAR2_TABLE_100
2611 , p9_a13 JTF_VARCHAR2_TABLE_100
2612 , p9_a14 JTF_NUMBER_TABLE
2613 , p9_a15 JTF_NUMBER_TABLE
2614 , p9_a16 JTF_NUMBER_TABLE
2615 , p9_a17 JTF_VARCHAR2_TABLE_100
2616 , p9_a18 JTF_VARCHAR2_TABLE_100
2617 , p9_a19 JTF_VARCHAR2_TABLE_100
2618 , p9_a20 JTF_VARCHAR2_TABLE_200
2619 , p9_a21 JTF_VARCHAR2_TABLE_200
2620 , p9_a22 JTF_VARCHAR2_TABLE_200
2621 , p9_a23 JTF_VARCHAR2_TABLE_200
2622 , p9_a24 JTF_VARCHAR2_TABLE_200
2623 , p9_a25 JTF_VARCHAR2_TABLE_200
2624 , p9_a26 JTF_VARCHAR2_TABLE_200
2625 , p9_a27 JTF_VARCHAR2_TABLE_200
2626 , p9_a28 JTF_VARCHAR2_TABLE_200
2627 , p9_a29 JTF_VARCHAR2_TABLE_200
2628 , p9_a30 JTF_VARCHAR2_TABLE_200
2629 , p9_a31 JTF_VARCHAR2_TABLE_200
2630 , p9_a32 JTF_VARCHAR2_TABLE_200
2631 , p9_a33 JTF_VARCHAR2_TABLE_200
2632 , p9_a34 JTF_VARCHAR2_TABLE_200
2633 , p9_a35 JTF_NUMBER_TABLE
2634 , p_sales_lead_id NUMBER
2635 , p11_a0 out nocopy JTF_NUMBER_TABLE
2636 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
2637 , x_return_status out nocopy VARCHAR2
2638 , x_msg_count out nocopy NUMBER
2639 , x_msg_data out nocopy VARCHAR2
2640 )
2641
2642 as
2643 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2644 ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2645 ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2646 ddindx binary_integer; indx binary_integer;
2647 begin
2648
2649 -- copy data to the local IN or IN-OUT args, if any
2650
2651
2652
2653
2654
2655
2656
2657
2658 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2659 , p8_a1
2660 );
2661
2662 as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0
2663 , p9_a1
2664 , p9_a2
2665 , p9_a3
2666 , p9_a4
2667 , p9_a5
2668 , p9_a6
2669 , p9_a7
2670 , p9_a8
2671 , p9_a9
2672 , p9_a10
2673 , p9_a11
2674 , p9_a12
2675 , p9_a13
2676 , p9_a14
2677 , p9_a15
2678 , p9_a16
2679 , p9_a17
2680 , p9_a18
2681 , p9_a19
2682 , p9_a20
2683 , p9_a21
2684 , p9_a22
2685 , p9_a23
2686 , p9_a24
2687 , p9_a25
2688 , p9_a26
2689 , p9_a27
2690 , p9_a28
2691 , p9_a29
2692 , p9_a30
2693 , p9_a31
2694 , p9_a32
2695 , p9_a33
2696 , p9_a34
2697 , p9_a35
2698 );
2699
2700
2701
2702
2703
2704
2705 -- here's the delegated call to the old PL/SQL routine
2706 as_sales_leads_pub.create_sales_lead_contacts(p_api_version_number,
2707 p_init_msg_list,
2708 p_commit,
2712 p_admin_group_id,
2709 p_validation_level,
2710 p_check_access_flag,
2711 p_admin_flag,
2713 p_identity_salesforce_id,
2714 ddp_sales_lead_profile_tbl,
2715 ddp_sales_lead_contact_tbl,
2716 p_sales_lead_id,
2717 ddx_sales_lead_cnt_out_tbl,
2718 x_return_status,
2719 x_msg_count,
2720 x_msg_data);
2721
2722 -- copy data back from the local variables to OUT or IN-OUT args, if any
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734 as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p11_a0
2735 , p11_a1
2736 );
2737
2738
2739
2740 end;
2741
2742 procedure update_sales_lead_contacts(p_api_version_number NUMBER
2743 , p_init_msg_list VARCHAR2
2744 , p_commit VARCHAR2
2745 , p_validation_level NUMBER
2746 , p_check_access_flag VARCHAR2
2747 , p_admin_flag VARCHAR2
2748 , p_admin_group_id NUMBER
2749 , p_identity_salesforce_id NUMBER
2750 , p8_a0 JTF_VARCHAR2_TABLE_100
2751 , p8_a1 JTF_VARCHAR2_TABLE_300
2752 , p9_a0 JTF_NUMBER_TABLE
2753 , p9_a1 JTF_NUMBER_TABLE
2754 , p9_a2 JTF_NUMBER_TABLE
2755 , p9_a3 JTF_DATE_TABLE
2756 , p9_a4 JTF_NUMBER_TABLE
2757 , p9_a5 JTF_DATE_TABLE
2758 , p9_a6 JTF_NUMBER_TABLE
2759 , p9_a7 JTF_NUMBER_TABLE
2760 , p9_a8 JTF_NUMBER_TABLE
2761 , p9_a9 JTF_NUMBER_TABLE
2762 , p9_a10 JTF_NUMBER_TABLE
2763 , p9_a11 JTF_DATE_TABLE
2764 , p9_a12 JTF_VARCHAR2_TABLE_100
2765 , p9_a13 JTF_VARCHAR2_TABLE_100
2766 , p9_a14 JTF_NUMBER_TABLE
2767 , p9_a15 JTF_NUMBER_TABLE
2768 , p9_a16 JTF_NUMBER_TABLE
2769 , p9_a17 JTF_VARCHAR2_TABLE_100
2770 , p9_a18 JTF_VARCHAR2_TABLE_100
2771 , p9_a19 JTF_VARCHAR2_TABLE_100
2772 , p9_a20 JTF_VARCHAR2_TABLE_200
2773 , p9_a21 JTF_VARCHAR2_TABLE_200
2774 , p9_a22 JTF_VARCHAR2_TABLE_200
2775 , p9_a23 JTF_VARCHAR2_TABLE_200
2776 , p9_a24 JTF_VARCHAR2_TABLE_200
2777 , p9_a25 JTF_VARCHAR2_TABLE_200
2778 , p9_a26 JTF_VARCHAR2_TABLE_200
2779 , p9_a27 JTF_VARCHAR2_TABLE_200
2780 , p9_a28 JTF_VARCHAR2_TABLE_200
2781 , p9_a29 JTF_VARCHAR2_TABLE_200
2782 , p9_a30 JTF_VARCHAR2_TABLE_200
2783 , p9_a31 JTF_VARCHAR2_TABLE_200
2784 , p9_a32 JTF_VARCHAR2_TABLE_200
2785 , p9_a33 JTF_VARCHAR2_TABLE_200
2786 , p9_a34 JTF_VARCHAR2_TABLE_200
2787 , p9_a35 JTF_NUMBER_TABLE
2788 , p10_a0 out nocopy JTF_NUMBER_TABLE
2789 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
2790 , x_return_status out nocopy VARCHAR2
2791 , x_msg_count out nocopy NUMBER
2792 , x_msg_data out nocopy VARCHAR2
2793 )
2794
2795 as
2796 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2797 ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2798 ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2799 ddindx binary_integer; indx binary_integer;
2800 begin
2801
2802 -- copy data to the local IN or IN-OUT args, if any
2803
2804
2805
2806
2807
2808
2809
2810
2811 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2812 , p8_a1
2813 );
2814
2815 as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0
2816 , p9_a1
2817 , p9_a2
2818 , p9_a3
2819 , p9_a4
2820 , p9_a5
2821 , p9_a6
2822 , p9_a7
2823 , p9_a8
2824 , p9_a9
2825 , p9_a10
2826 , p9_a11
2827 , p9_a12
2828 , p9_a13
2829 , p9_a14
2830 , p9_a15
2831 , p9_a16
2832 , p9_a17
2833 , p9_a18
2834 , p9_a19
2835 , p9_a20
2836 , p9_a21
2837 , p9_a22
2838 , p9_a23
2839 , p9_a24
2840 , p9_a25
2841 , p9_a26
2842 , p9_a27
2843 , p9_a28
2844 , p9_a29
2845 , p9_a30
2846 , p9_a31
2847 , p9_a32
2848 , p9_a33
2849 , p9_a34
2850 , p9_a35
2851 );
2852
2853
2854
2855
2856
2857 -- here's the delegated call to the old PL/SQL routine
2858 as_sales_leads_pub.update_sales_lead_contacts(p_api_version_number,
2859 p_init_msg_list,
2860 p_commit,
2861 p_validation_level,
2862 p_check_access_flag,
2863 p_admin_flag,
2864 p_admin_group_id,
2865 p_identity_salesforce_id,
2866 ddp_sales_lead_profile_tbl,
2867 ddp_sales_lead_contact_tbl,
2868 ddx_sales_lead_cnt_out_tbl,
2869 x_return_status,
2870 x_msg_count,
2871 x_msg_data);
2872
2873 -- copy data back from the local variables to OUT or IN-OUT args, if any
2874
2875
2876
2877
2878
2879
2880
2881
2882
2883
2884 as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p10_a0
2885 , p10_a1
2886 );
2887
2888
2889
2890 end;
2891
2892 procedure delete_sales_lead_contacts(p_api_version_number NUMBER
2893 , p_init_msg_list VARCHAR2
2894 , p_commit VARCHAR2
2895 , p_validation_level NUMBER
2896 , p_check_access_flag VARCHAR2
2897 , p_admin_flag VARCHAR2
2898 , p_admin_group_id NUMBER
2899 , p_identity_salesforce_id NUMBER
2900 , p8_a0 JTF_VARCHAR2_TABLE_100
2901 , p8_a1 JTF_VARCHAR2_TABLE_300
2902 , p9_a0 JTF_NUMBER_TABLE
2903 , p9_a1 JTF_NUMBER_TABLE
2904 , p9_a2 JTF_NUMBER_TABLE
2905 , p9_a3 JTF_DATE_TABLE
2906 , p9_a4 JTF_NUMBER_TABLE
2907 , p9_a5 JTF_DATE_TABLE
2908 , p9_a6 JTF_NUMBER_TABLE
2909 , p9_a7 JTF_NUMBER_TABLE
2910 , p9_a8 JTF_NUMBER_TABLE
2911 , p9_a9 JTF_NUMBER_TABLE
2912 , p9_a10 JTF_NUMBER_TABLE
2913 , p9_a11 JTF_DATE_TABLE
2914 , p9_a12 JTF_VARCHAR2_TABLE_100
2915 , p9_a13 JTF_VARCHAR2_TABLE_100
2916 , p9_a14 JTF_NUMBER_TABLE
2917 , p9_a15 JTF_NUMBER_TABLE
2918 , p9_a16 JTF_NUMBER_TABLE
2919 , p9_a17 JTF_VARCHAR2_TABLE_100
2920 , p9_a18 JTF_VARCHAR2_TABLE_100
2921 , p9_a19 JTF_VARCHAR2_TABLE_100
2922 , p9_a20 JTF_VARCHAR2_TABLE_200
2923 , p9_a21 JTF_VARCHAR2_TABLE_200
2924 , p9_a22 JTF_VARCHAR2_TABLE_200
2925 , p9_a23 JTF_VARCHAR2_TABLE_200
2926 , p9_a24 JTF_VARCHAR2_TABLE_200
2927 , p9_a25 JTF_VARCHAR2_TABLE_200
2928 , p9_a26 JTF_VARCHAR2_TABLE_200
2929 , p9_a27 JTF_VARCHAR2_TABLE_200
2930 , p9_a28 JTF_VARCHAR2_TABLE_200
2931 , p9_a29 JTF_VARCHAR2_TABLE_200
2932 , p9_a30 JTF_VARCHAR2_TABLE_200
2933 , p9_a31 JTF_VARCHAR2_TABLE_200
2934 , p9_a32 JTF_VARCHAR2_TABLE_200
2935 , p9_a33 JTF_VARCHAR2_TABLE_200
2936 , p9_a34 JTF_VARCHAR2_TABLE_200
2937 , p9_a35 JTF_NUMBER_TABLE
2938 , p10_a0 out nocopy JTF_NUMBER_TABLE
2939 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
2940 , x_return_status out nocopy VARCHAR2
2941 , x_msg_count out nocopy NUMBER
2945 as
2942 , x_msg_data out nocopy VARCHAR2
2943 )
2944
2946 ddp_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
2947 ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
2948 ddx_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
2949 ddindx binary_integer; indx binary_integer;
2950 begin
2951
2952 -- copy data to the local IN or IN-OUT args, if any
2953
2954
2955
2956
2957
2958
2959
2960
2961 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_sales_lead_profile_tbl, p8_a0
2962 , p8_a1
2963 );
2964
2965 as_sales_leads_pub_w.rosetta_table_copy_in_p13(ddp_sales_lead_contact_tbl, p9_a0
2966 , p9_a1
2967 , p9_a2
2968 , p9_a3
2969 , p9_a4
2970 , p9_a5
2971 , p9_a6
2972 , p9_a7
2973 , p9_a8
2974 , p9_a9
2975 , p9_a10
2976 , p9_a11
2977 , p9_a12
2978 , p9_a13
2979 , p9_a14
2980 , p9_a15
2981 , p9_a16
2982 , p9_a17
2983 , p9_a18
2984 , p9_a19
2985 , p9_a20
2986 , p9_a21
2987 , p9_a22
2988 , p9_a23
2989 , p9_a24
2990 , p9_a25
2991 , p9_a26
2992 , p9_a27
2993 , p9_a28
2994 , p9_a29
2995 , p9_a30
2996 , p9_a31
2997 , p9_a32
2998 , p9_a33
2999 , p9_a34
3000 , p9_a35
3001 );
3002
3003
3004
3005
3006
3010 p_commit,
3007 -- here's the delegated call to the old PL/SQL routine
3008 as_sales_leads_pub.delete_sales_lead_contacts(p_api_version_number,
3009 p_init_msg_list,
3011 p_validation_level,
3012 p_check_access_flag,
3013 p_admin_flag,
3014 p_admin_group_id,
3015 p_identity_salesforce_id,
3016 ddp_sales_lead_profile_tbl,
3017 ddp_sales_lead_contact_tbl,
3018 ddx_sales_lead_cnt_out_tbl,
3019 x_return_status,
3020 x_msg_count,
3021 x_msg_data);
3022
3023 -- copy data back from the local variables to OUT or IN-OUT args, if any
3024
3025
3026
3027
3028
3029
3030
3031
3032
3033
3034 as_sales_leads_pub_w.rosetta_table_copy_out_p16(ddx_sales_lead_cnt_out_tbl, p10_a0
3035 , p10_a1
3036 );
3037
3038
3039
3040 end;
3041
3042 end as_sales_leads_pub_w;