[Home] [Help]
PACKAGE BODY: APPS.IEX_WEBDIR_PVT_W
Source
1 package body iex_webdir_pvt_w as
2 /* $Header: iexvaddb.pls 120.1 2005/07/06 15:09:18 schekuri noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
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 create_webassist(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , p7_a0 NUMBER := 0-1962.0724
30 , p7_a1 NUMBER := 0-1962.0724
31 , p7_a2 NUMBER := 0-1962.0724
32 , p7_a3 DATE := fnd_api.g_miss_date
33 , p7_a4 NUMBER := 0-1962.0724
34 , p7_a5 DATE := fnd_api.g_miss_date
35 , p7_a6 NUMBER := 0-1962.0724
36 , p7_a7 NUMBER := 0-1962.0724
37 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
38 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
39 , p8_a0 NUMBER := 0-1962.0724
40 , p8_a1 VARCHAR2 := fnd_api.g_miss_char
41 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
42 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
43 , p8_a4 NUMBER := 0-1962.0724
44 , p8_a5 DATE := fnd_api.g_miss_date
45 , p8_a6 DATE := fnd_api.g_miss_date
46 , p8_a7 NUMBER := 0-1962.0724
47 , p8_a8 NUMBER := 0-1962.0724
48 , p8_a9 NUMBER := 0-1962.0724
49 , p8_a10 NUMBER := 0-1962.0724
50 , p8_a11 NUMBER := 0-1962.0724
51 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
52 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
53 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
54 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
55 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
56 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
57 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
58 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
59 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
60 , p8_a21 VARCHAR2 := fnd_api.g_miss_char
61 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
62 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
63 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
64 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
65 , p8_a26 VARCHAR2 := fnd_api.g_miss_char
66 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
67 , p9_a0 NUMBER := 0-1962.0724
68 , p9_a1 VARCHAR2 := fnd_api.g_miss_char
69 , p9_a2 NUMBER := 0-1962.0724
70 , p9_a3 NUMBER := 0-1962.0724
71 , p9_a4 DATE := fnd_api.g_miss_date
72 , p9_a5 DATE := fnd_api.g_miss_date
73 , p9_a6 NUMBER := 0-1962.0724
74 , p9_a7 NUMBER := 0-1962.0724
75 , p9_a8 NUMBER := 0-1962.0724
76 , p9_a9 VARCHAR2 := fnd_api.g_miss_char
77 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
78 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
79 , p9_a12 NUMBER := 0-1962.0724
80 , p9_a13 NUMBER := 0-1962.0724
81 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
82 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
83 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
84 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
85 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
86 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
87 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
88 , p9_a21 VARCHAR2 := fnd_api.g_miss_char
89 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
90 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
91 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
92 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
93 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
94 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
95 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
96 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
97 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
98 , p10_a0 NUMBER := 0-1962.0724
99 , p10_a1 NUMBER := 0-1962.0724
100 , p10_a2 NUMBER := 0-1962.0724
101 , p10_a3 DATE := fnd_api.g_miss_date
102 , p10_a4 DATE := fnd_api.g_miss_date
103 , p10_a5 NUMBER := 0-1962.0724
104 , p10_a6 NUMBER := 0-1962.0724
105 , p10_a7 NUMBER := 0-1962.0724
106 , p10_a8 VARCHAR2 := fnd_api.g_miss_char
107 , p10_a9 VARCHAR2 := fnd_api.g_miss_char
108 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
109 , p10_a11 NUMBER := 0-1962.0724
110 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
111 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
112 , p10_a14 VARCHAR2 := fnd_api.g_miss_char
113 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
114 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
115 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
116 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
117 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
118 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
119 , p10_a21 VARCHAR2 := fnd_api.g_miss_char
120 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
121 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
122 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
123 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
124 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
125 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
126 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
127 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
128 )
129
130 as
131 ddp_assist_rec iex_webdir_pvt.assist_rec_type;
132 ddp_web_assist_rec iex_webdir_pvt.web_assist_rec_type;
133 ddp_web_search_rec iex_webdir_pvt.web_search_rec_type;
134 ddp_query_string_rec iex_webdir_pvt.query_string_rec_type;
135 ddindx binary_integer; indx binary_integer;
136 begin
137
138 -- copy data to the local IN or IN-OUT args, if any
139
140
141
142
143
144
145
146 ddp_assist_rec.assist_id := rosetta_g_miss_num_map(p7_a0);
147 ddp_assist_rec.program_id := rosetta_g_miss_num_map(p7_a1);
148 ddp_assist_rec.object_version_number := rosetta_g_miss_num_map(p7_a2);
149 ddp_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);
150 ddp_assist_rec.last_updated_by := rosetta_g_miss_num_map(p7_a4);
151 ddp_assist_rec.creation_date := rosetta_g_miss_date_in_map(p7_a5);
152 ddp_assist_rec.created_by := rosetta_g_miss_num_map(p7_a6);
153 ddp_assist_rec.last_update_login := rosetta_g_miss_num_map(p7_a7);
154 ddp_assist_rec.assistance_type := p7_a8;
155 ddp_assist_rec.location := p7_a9;
156
157 ddp_web_assist_rec.web_assist_id := rosetta_g_miss_num_map(p8_a0);
158 ddp_web_assist_rec.proxy_host := p8_a1;
159 ddp_web_assist_rec.proxy_port := p8_a2;
160 ddp_web_assist_rec.enabled_flag := p8_a3;
161 ddp_web_assist_rec.program_id := rosetta_g_miss_num_map(p8_a4);
162 ddp_web_assist_rec.creation_date := rosetta_g_miss_date_in_map(p8_a5);
163 ddp_web_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a6);
164 ddp_web_assist_rec.created_by := rosetta_g_miss_num_map(p8_a7);
165 ddp_web_assist_rec.last_updated_by := rosetta_g_miss_num_map(p8_a8);
166 ddp_web_assist_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);
167 ddp_web_assist_rec.assist_id := rosetta_g_miss_num_map(p8_a10);
168 ddp_web_assist_rec.object_version_number := rosetta_g_miss_num_map(p8_a11);
169 ddp_web_assist_rec.attribute_category := p8_a12;
170 ddp_web_assist_rec.attribute1 := p8_a13;
171 ddp_web_assist_rec.attribute2 := p8_a14;
172 ddp_web_assist_rec.attribute3 := p8_a15;
173 ddp_web_assist_rec.attribute4 := p8_a16;
174 ddp_web_assist_rec.attribute5 := p8_a17;
175 ddp_web_assist_rec.attribute6 := p8_a18;
176 ddp_web_assist_rec.attribute7 := p8_a19;
177 ddp_web_assist_rec.attribute8 := p8_a20;
178 ddp_web_assist_rec.attribute9 := p8_a21;
179 ddp_web_assist_rec.attribute10 := p8_a22;
180 ddp_web_assist_rec.attribute11 := p8_a23;
181 ddp_web_assist_rec.attribute12 := p8_a24;
182 ddp_web_assist_rec.attribute13 := p8_a25;
183 ddp_web_assist_rec.attribute14 := p8_a26;
184 ddp_web_assist_rec.attribute15 := p8_a27;
185
186 ddp_web_search_rec.search_id := rosetta_g_miss_num_map(p9_a0);
187 ddp_web_search_rec.enabled_flag := p9_a1;
188 ddp_web_search_rec.program_id := rosetta_g_miss_num_map(p9_a2);
189 ddp_web_search_rec.object_version_number := rosetta_g_miss_num_map(p9_a3);
190 ddp_web_search_rec.creation_date := rosetta_g_miss_date_in_map(p9_a4);
191 ddp_web_search_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a5);
192 ddp_web_search_rec.created_by := rosetta_g_miss_num_map(p9_a6);
193 ddp_web_search_rec.last_updated_by := rosetta_g_miss_num_map(p9_a7);
194 ddp_web_search_rec.last_update_login := rosetta_g_miss_num_map(p9_a8);
195 ddp_web_search_rec.search_url := p9_a9;
196 ddp_web_search_rec.cgi_server := p9_a10;
197 ddp_web_search_rec.next_page_ident := p9_a11;
198 ddp_web_search_rec.max_nbr_pages := rosetta_g_miss_num_map(p9_a12);
199 ddp_web_search_rec.web_assist_id := rosetta_g_miss_num_map(p9_a13);
200 ddp_web_search_rec.directory_assist_flag := p9_a14;
201 ddp_web_search_rec.attribute_category := p9_a15;
202 ddp_web_search_rec.attribute1 := p9_a16;
203 ddp_web_search_rec.attribute2 := p9_a17;
204 ddp_web_search_rec.attribute3 := p9_a18;
205 ddp_web_search_rec.attribute4 := p9_a19;
206 ddp_web_search_rec.attribute5 := p9_a20;
207 ddp_web_search_rec.attribute6 := p9_a21;
208 ddp_web_search_rec.attribute7 := p9_a22;
209 ddp_web_search_rec.attribute8 := p9_a23;
210 ddp_web_search_rec.attribute9 := p9_a24;
211 ddp_web_search_rec.attribute10 := p9_a25;
212 ddp_web_search_rec.attribute11 := p9_a26;
213 ddp_web_search_rec.attribute12 := p9_a27;
214 ddp_web_search_rec.attribute13 := p9_a28;
215 ddp_web_search_rec.attribute14 := p9_a29;
216 ddp_web_search_rec.attribute15 := p9_a30;
217
218 ddp_query_string_rec.query_string_id := rosetta_g_miss_num_map(p10_a0);
219 ddp_query_string_rec.program_id := rosetta_g_miss_num_map(p10_a1);
220 ddp_query_string_rec.object_version_number := rosetta_g_miss_num_map(p10_a2);
221 ddp_query_string_rec.creation_date := rosetta_g_miss_date_in_map(p10_a3);
222 ddp_query_string_rec.last_update_date := rosetta_g_miss_date_in_map(p10_a4);
223 ddp_query_string_rec.created_by := rosetta_g_miss_num_map(p10_a5);
224 ddp_query_string_rec.last_updated_by := rosetta_g_miss_num_map(p10_a6);
225 ddp_query_string_rec.last_update_login := rosetta_g_miss_num_map(p10_a7);
226 ddp_query_string_rec.switch_separator := p10_a8;
227 ddp_query_string_rec.url_separator := p10_a9;
228 ddp_query_string_rec.header_const := p10_a10;
229 ddp_query_string_rec.search_id := rosetta_g_miss_num_map(p10_a11);
230 ddp_query_string_rec.trailer_const := p10_a12;
231 ddp_query_string_rec.enabled_flag := p10_a13;
232 ddp_query_string_rec.attribute_category := p10_a14;
233 ddp_query_string_rec.attribute1 := p10_a15;
234 ddp_query_string_rec.attribute2 := p10_a16;
235 ddp_query_string_rec.attribute3 := p10_a17;
236 ddp_query_string_rec.attribute4 := p10_a18;
237 ddp_query_string_rec.attribute5 := p10_a19;
238 ddp_query_string_rec.attribute6 := p10_a20;
239 ddp_query_string_rec.attribute7 := p10_a21;
240 ddp_query_string_rec.attribute8 := p10_a22;
241 ddp_query_string_rec.attribute9 := p10_a23;
242 ddp_query_string_rec.attribute10 := p10_a24;
243 ddp_query_string_rec.attribute11 := p10_a25;
244 ddp_query_string_rec.attribute12 := p10_a26;
245 ddp_query_string_rec.attribute13 := p10_a27;
246 ddp_query_string_rec.attribute14 := p10_a28;
247 ddp_query_string_rec.attribute15 := p10_a29;
248
249 -- here's the delegated call to the old PL/SQL routine
250 iex_webdir_pvt.create_webassist(p_api_version,
251 p_init_msg_list,
252 p_commit,
253 p_validation_level,
254 x_return_status,
255 x_msg_count,
256 x_msg_data,
257 ddp_assist_rec,
258 ddp_web_assist_rec,
259 ddp_web_search_rec,
260 ddp_query_string_rec);
261
262 -- copy data back from the local variables to OUT or IN-OUT args, if any
263
264
265
266
267
268
269
270
271
272
273 end;
274
275 procedure update_webassist(p_api_version NUMBER
276 , p_init_msg_list VARCHAR2
277 , p_commit VARCHAR2
278 , p_validation_level NUMBER
279 , x_return_status out nocopy VARCHAR2
280 , x_msg_count out nocopy NUMBER
281 , x_msg_data out nocopy VARCHAR2
282 , p7_a0 NUMBER := 0-1962.0724
283 , p7_a1 NUMBER := 0-1962.0724
284 , p7_a2 NUMBER := 0-1962.0724
285 , p7_a3 DATE := fnd_api.g_miss_date
286 , p7_a4 NUMBER := 0-1962.0724
287 , p7_a5 DATE := fnd_api.g_miss_date
288 , p7_a6 NUMBER := 0-1962.0724
289 , p7_a7 NUMBER := 0-1962.0724
290 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
291 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
292 , p8_a0 NUMBER := 0-1962.0724
293 , p8_a1 VARCHAR2 := fnd_api.g_miss_char
294 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
295 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
296 , p8_a4 NUMBER := 0-1962.0724
297 , p8_a5 DATE := fnd_api.g_miss_date
298 , p8_a6 DATE := fnd_api.g_miss_date
299 , p8_a7 NUMBER := 0-1962.0724
300 , p8_a8 NUMBER := 0-1962.0724
301 , p8_a9 NUMBER := 0-1962.0724
302 , p8_a10 NUMBER := 0-1962.0724
303 , p8_a11 NUMBER := 0-1962.0724
304 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
305 , p8_a13 VARCHAR2 := fnd_api.g_miss_char
306 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
307 , p8_a15 VARCHAR2 := fnd_api.g_miss_char
308 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
309 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
310 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
311 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
312 , p8_a20 VARCHAR2 := fnd_api.g_miss_char
313 , p8_a21 VARCHAR2 := fnd_api.g_miss_char
314 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
315 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
316 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
317 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
318 , p8_a26 VARCHAR2 := fnd_api.g_miss_char
319 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
320 , p9_a0 NUMBER := 0-1962.0724
321 , p9_a1 VARCHAR2 := fnd_api.g_miss_char
322 , p9_a2 NUMBER := 0-1962.0724
323 , p9_a3 NUMBER := 0-1962.0724
324 , p9_a4 DATE := fnd_api.g_miss_date
325 , p9_a5 DATE := fnd_api.g_miss_date
326 , p9_a6 NUMBER := 0-1962.0724
327 , p9_a7 NUMBER := 0-1962.0724
328 , p9_a8 NUMBER := 0-1962.0724
329 , p9_a9 VARCHAR2 := fnd_api.g_miss_char
330 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
331 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
332 , p9_a12 NUMBER := 0-1962.0724
333 , p9_a13 NUMBER := 0-1962.0724
334 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
335 , p9_a15 VARCHAR2 := fnd_api.g_miss_char
336 , p9_a16 VARCHAR2 := fnd_api.g_miss_char
337 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
338 , p9_a18 VARCHAR2 := fnd_api.g_miss_char
339 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
340 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
341 , p9_a21 VARCHAR2 := fnd_api.g_miss_char
342 , p9_a22 VARCHAR2 := fnd_api.g_miss_char
343 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
344 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
345 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
346 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
347 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
348 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
349 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
350 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
351 , p10_a0 NUMBER := 0-1962.0724
352 , p10_a1 NUMBER := 0-1962.0724
353 , p10_a2 NUMBER := 0-1962.0724
354 , p10_a3 DATE := fnd_api.g_miss_date
355 , p10_a4 DATE := fnd_api.g_miss_date
356 , p10_a5 NUMBER := 0-1962.0724
357 , p10_a6 NUMBER := 0-1962.0724
358 , p10_a7 NUMBER := 0-1962.0724
359 , p10_a8 VARCHAR2 := fnd_api.g_miss_char
360 , p10_a9 VARCHAR2 := fnd_api.g_miss_char
361 , p10_a10 VARCHAR2 := fnd_api.g_miss_char
362 , p10_a11 NUMBER := 0-1962.0724
363 , p10_a12 VARCHAR2 := fnd_api.g_miss_char
364 , p10_a13 VARCHAR2 := fnd_api.g_miss_char
365 , p10_a14 VARCHAR2 := fnd_api.g_miss_char
366 , p10_a15 VARCHAR2 := fnd_api.g_miss_char
367 , p10_a16 VARCHAR2 := fnd_api.g_miss_char
368 , p10_a17 VARCHAR2 := fnd_api.g_miss_char
369 , p10_a18 VARCHAR2 := fnd_api.g_miss_char
370 , p10_a19 VARCHAR2 := fnd_api.g_miss_char
371 , p10_a20 VARCHAR2 := fnd_api.g_miss_char
372 , p10_a21 VARCHAR2 := fnd_api.g_miss_char
373 , p10_a22 VARCHAR2 := fnd_api.g_miss_char
374 , p10_a23 VARCHAR2 := fnd_api.g_miss_char
375 , p10_a24 VARCHAR2 := fnd_api.g_miss_char
376 , p10_a25 VARCHAR2 := fnd_api.g_miss_char
377 , p10_a26 VARCHAR2 := fnd_api.g_miss_char
378 , p10_a27 VARCHAR2 := fnd_api.g_miss_char
379 , p10_a28 VARCHAR2 := fnd_api.g_miss_char
380 , p10_a29 VARCHAR2 := fnd_api.g_miss_char
381 )
382
383 as
384 ddp_assist_rec iex_webdir_pvt.assist_rec_type;
385 ddp_web_assist_rec iex_webdir_pvt.web_assist_rec_type;
386 ddp_web_search_rec iex_webdir_pvt.web_search_rec_type;
387 ddp_query_string_rec iex_webdir_pvt.query_string_rec_type;
388 ddindx binary_integer; indx binary_integer;
389 begin
390
391 -- copy data to the local IN or IN-OUT args, if any
392
393
394
395
396
397
398
399 ddp_assist_rec.assist_id := rosetta_g_miss_num_map(p7_a0);
400 ddp_assist_rec.program_id := rosetta_g_miss_num_map(p7_a1);
401 ddp_assist_rec.object_version_number := rosetta_g_miss_num_map(p7_a2);
402 ddp_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a3);
403 ddp_assist_rec.last_updated_by := rosetta_g_miss_num_map(p7_a4);
404 ddp_assist_rec.creation_date := rosetta_g_miss_date_in_map(p7_a5);
405 ddp_assist_rec.created_by := rosetta_g_miss_num_map(p7_a6);
406 ddp_assist_rec.last_update_login := rosetta_g_miss_num_map(p7_a7);
407 ddp_assist_rec.assistance_type := p7_a8;
408 ddp_assist_rec.location := p7_a9;
409
410 ddp_web_assist_rec.web_assist_id := rosetta_g_miss_num_map(p8_a0);
411 ddp_web_assist_rec.proxy_host := p8_a1;
412 ddp_web_assist_rec.proxy_port := p8_a2;
413 ddp_web_assist_rec.enabled_flag := p8_a3;
414 ddp_web_assist_rec.program_id := rosetta_g_miss_num_map(p8_a4);
415 ddp_web_assist_rec.creation_date := rosetta_g_miss_date_in_map(p8_a5);
416 ddp_web_assist_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a6);
417 ddp_web_assist_rec.created_by := rosetta_g_miss_num_map(p8_a7);
418 ddp_web_assist_rec.last_updated_by := rosetta_g_miss_num_map(p8_a8);
419 ddp_web_assist_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);
420 ddp_web_assist_rec.assist_id := rosetta_g_miss_num_map(p8_a10);
421 ddp_web_assist_rec.object_version_number := rosetta_g_miss_num_map(p8_a11);
422 ddp_web_assist_rec.attribute_category := p8_a12;
423 ddp_web_assist_rec.attribute1 := p8_a13;
424 ddp_web_assist_rec.attribute2 := p8_a14;
425 ddp_web_assist_rec.attribute3 := p8_a15;
426 ddp_web_assist_rec.attribute4 := p8_a16;
427 ddp_web_assist_rec.attribute5 := p8_a17;
428 ddp_web_assist_rec.attribute6 := p8_a18;
429 ddp_web_assist_rec.attribute7 := p8_a19;
430 ddp_web_assist_rec.attribute8 := p8_a20;
431 ddp_web_assist_rec.attribute9 := p8_a21;
432 ddp_web_assist_rec.attribute10 := p8_a22;
433 ddp_web_assist_rec.attribute11 := p8_a23;
434 ddp_web_assist_rec.attribute12 := p8_a24;
435 ddp_web_assist_rec.attribute13 := p8_a25;
436 ddp_web_assist_rec.attribute14 := p8_a26;
437 ddp_web_assist_rec.attribute15 := p8_a27;
438
439 ddp_web_search_rec.search_id := rosetta_g_miss_num_map(p9_a0);
440 ddp_web_search_rec.enabled_flag := p9_a1;
441 ddp_web_search_rec.program_id := rosetta_g_miss_num_map(p9_a2);
442 ddp_web_search_rec.object_version_number := rosetta_g_miss_num_map(p9_a3);
443 ddp_web_search_rec.creation_date := rosetta_g_miss_date_in_map(p9_a4);
444 ddp_web_search_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a5);
445 ddp_web_search_rec.created_by := rosetta_g_miss_num_map(p9_a6);
446 ddp_web_search_rec.last_updated_by := rosetta_g_miss_num_map(p9_a7);
447 ddp_web_search_rec.last_update_login := rosetta_g_miss_num_map(p9_a8);
448 ddp_web_search_rec.search_url := p9_a9;
449 ddp_web_search_rec.cgi_server := p9_a10;
450 ddp_web_search_rec.next_page_ident := p9_a11;
451 ddp_web_search_rec.max_nbr_pages := rosetta_g_miss_num_map(p9_a12);
452 ddp_web_search_rec.web_assist_id := rosetta_g_miss_num_map(p9_a13);
453 ddp_web_search_rec.directory_assist_flag := p9_a14;
454 ddp_web_search_rec.attribute_category := p9_a15;
455 ddp_web_search_rec.attribute1 := p9_a16;
456 ddp_web_search_rec.attribute2 := p9_a17;
457 ddp_web_search_rec.attribute3 := p9_a18;
458 ddp_web_search_rec.attribute4 := p9_a19;
459 ddp_web_search_rec.attribute5 := p9_a20;
460 ddp_web_search_rec.attribute6 := p9_a21;
461 ddp_web_search_rec.attribute7 := p9_a22;
462 ddp_web_search_rec.attribute8 := p9_a23;
463 ddp_web_search_rec.attribute9 := p9_a24;
464 ddp_web_search_rec.attribute10 := p9_a25;
465 ddp_web_search_rec.attribute11 := p9_a26;
466 ddp_web_search_rec.attribute12 := p9_a27;
467 ddp_web_search_rec.attribute13 := p9_a28;
468 ddp_web_search_rec.attribute14 := p9_a29;
469 ddp_web_search_rec.attribute15 := p9_a30;
470
471 ddp_query_string_rec.query_string_id := rosetta_g_miss_num_map(p10_a0);
472 ddp_query_string_rec.program_id := rosetta_g_miss_num_map(p10_a1);
473 ddp_query_string_rec.object_version_number := rosetta_g_miss_num_map(p10_a2);
474 ddp_query_string_rec.creation_date := rosetta_g_miss_date_in_map(p10_a3);
475 ddp_query_string_rec.last_update_date := rosetta_g_miss_date_in_map(p10_a4);
476 ddp_query_string_rec.created_by := rosetta_g_miss_num_map(p10_a5);
477 ddp_query_string_rec.last_updated_by := rosetta_g_miss_num_map(p10_a6);
478 ddp_query_string_rec.last_update_login := rosetta_g_miss_num_map(p10_a7);
479 ddp_query_string_rec.switch_separator := p10_a8;
480 ddp_query_string_rec.url_separator := p10_a9;
481 ddp_query_string_rec.header_const := p10_a10;
482 ddp_query_string_rec.search_id := rosetta_g_miss_num_map(p10_a11);
483 ddp_query_string_rec.trailer_const := p10_a12;
484 ddp_query_string_rec.enabled_flag := p10_a13;
485 ddp_query_string_rec.attribute_category := p10_a14;
486 ddp_query_string_rec.attribute1 := p10_a15;
487 ddp_query_string_rec.attribute2 := p10_a16;
488 ddp_query_string_rec.attribute3 := p10_a17;
489 ddp_query_string_rec.attribute4 := p10_a18;
490 ddp_query_string_rec.attribute5 := p10_a19;
491 ddp_query_string_rec.attribute6 := p10_a20;
492 ddp_query_string_rec.attribute7 := p10_a21;
493 ddp_query_string_rec.attribute8 := p10_a22;
494 ddp_query_string_rec.attribute9 := p10_a23;
495 ddp_query_string_rec.attribute10 := p10_a24;
496 ddp_query_string_rec.attribute11 := p10_a25;
497 ddp_query_string_rec.attribute12 := p10_a26;
498 ddp_query_string_rec.attribute13 := p10_a27;
499 ddp_query_string_rec.attribute14 := p10_a28;
500 ddp_query_string_rec.attribute15 := p10_a29;
501
502 -- here's the delegated call to the old PL/SQL routine
503 iex_webdir_pvt.update_webassist(p_api_version,
504 p_init_msg_list,
505 p_commit,
506 p_validation_level,
507 x_return_status,
508 x_msg_count,
509 x_msg_data,
510 ddp_assist_rec,
511 ddp_web_assist_rec,
512 ddp_web_search_rec,
513 ddp_query_string_rec);
514
515 -- copy data back from the local variables to OUT or IN-OUT args, if any
516
517
518
519
520
521
522
523
524
525
526 end;
527
528 end iex_webdir_pvt_w;