[Home] [Help]
PACKAGE BODY: APPS.JTF_AMV_ATTACHMENT_PUB_W
Source
1 package body jtf_amv_attachment_pub_w as
2 /* $Header: jtfpatwb.pls 120.3 2005/09/13 11:10:04 vimohan 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 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure create_act_attachment(p_api_version NUMBER
26 , p_init_msg_list VARCHAR2
27 , p_commit VARCHAR2
28 , p_validation_level NUMBER
29 , x_return_status out nocopy VARCHAR2
30 , x_msg_count out nocopy NUMBER
31 , x_msg_data out nocopy VARCHAR2
32 , x_act_attachment_id out nocopy NUMBER
33 , p7_a0 NUMBER := 0-1962.0724
34 , p7_a1 DATE := fnd_api.g_miss_date
35 , p7_a2 NUMBER := 0-1962.0724
36 , p7_a3 DATE := fnd_api.g_miss_date
37 , p7_a4 NUMBER := 0-1962.0724
38 , p7_a5 NUMBER := 0-1962.0724
39 , p7_a6 NUMBER := 0-1962.0724
40 , p7_a7 NUMBER := 0-1962.0724
41 , p7_a8 NUMBER := 0-1962.0724
42 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
44 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
45 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
46 , p7_a13 NUMBER := 0-1962.0724
47 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
48 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
49 , p7_a16 NUMBER := 0-1962.0724
50 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
51 , p7_a18 NUMBER := 0-1962.0724
52 , p7_a19 NUMBER := 0-1962.0724
53 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
55 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
57 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a26 NUMBER := 0-1962.0724
60 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
63 , p7_a30 NUMBER := 0-1962.0724
64 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
65 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
66 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
67 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
68 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
69 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
70 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
71 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
72 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
73 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
74 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
75 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
76 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
77 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
78 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
79 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
80 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
81 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
82 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
83 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
84 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
85 )
86
87 as
88 ddp_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
89 ddindx binary_integer; indx binary_integer;
90 begin
91
92 -- copy data to the local IN or IN-OUT args, if any
93
94
95
96
97
98
99
100 ddp_act_attachment_rec.attachment_id := rosetta_g_miss_num_map(p7_a0);
101 ddp_act_attachment_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
102 ddp_act_attachment_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
103 ddp_act_attachment_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
104 ddp_act_attachment_rec.created_by := rosetta_g_miss_num_map(p7_a4);
105 ddp_act_attachment_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
106 ddp_act_attachment_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
107 ddp_act_attachment_rec.owner_user_id := rosetta_g_miss_num_map(p7_a7);
108 ddp_act_attachment_rec.attachment_used_by_id := rosetta_g_miss_num_map(p7_a8);
109 ddp_act_attachment_rec.attachment_used_by := p7_a9;
110 ddp_act_attachment_rec.version := p7_a10;
111 ddp_act_attachment_rec.enabled_flag := p7_a11;
112 ddp_act_attachment_rec.can_fulfill_electronic_flag := p7_a12;
113 ddp_act_attachment_rec.file_id := rosetta_g_miss_num_map(p7_a13);
114 ddp_act_attachment_rec.file_name := p7_a14;
115 ddp_act_attachment_rec.file_extension := p7_a15;
116 ddp_act_attachment_rec.document_id := rosetta_g_miss_num_map(p7_a16);
117 ddp_act_attachment_rec.keywords := p7_a17;
118 ddp_act_attachment_rec.display_width := rosetta_g_miss_num_map(p7_a18);
119 ddp_act_attachment_rec.display_height := rosetta_g_miss_num_map(p7_a19);
120 ddp_act_attachment_rec.display_location := p7_a20;
121 ddp_act_attachment_rec.link_to := p7_a21;
122 ddp_act_attachment_rec.link_url := p7_a22;
123 ddp_act_attachment_rec.send_for_preview_flag := p7_a23;
124 ddp_act_attachment_rec.attachment_type := p7_a24;
125 ddp_act_attachment_rec.language_code := p7_a25;
126 ddp_act_attachment_rec.application_id := rosetta_g_miss_num_map(p7_a26);
127 ddp_act_attachment_rec.description := p7_a27;
128 ddp_act_attachment_rec.default_style_sheet := p7_a28;
129 ddp_act_attachment_rec.display_url := p7_a29;
130 ddp_act_attachment_rec.display_rule_id := rosetta_g_miss_num_map(p7_a30);
131 ddp_act_attachment_rec.display_program := p7_a31;
132 ddp_act_attachment_rec.attribute_category := p7_a32;
133 ddp_act_attachment_rec.attribute1 := p7_a33;
134 ddp_act_attachment_rec.attribute2 := p7_a34;
135 ddp_act_attachment_rec.attribute3 := p7_a35;
136 ddp_act_attachment_rec.attribute4 := p7_a36;
137 ddp_act_attachment_rec.attribute5 := p7_a37;
138 ddp_act_attachment_rec.attribute6 := p7_a38;
139 ddp_act_attachment_rec.attribute7 := p7_a39;
140 ddp_act_attachment_rec.attribute8 := p7_a40;
141 ddp_act_attachment_rec.attribute9 := p7_a41;
142 ddp_act_attachment_rec.attribute10 := p7_a42;
143 ddp_act_attachment_rec.attribute11 := p7_a43;
144 ddp_act_attachment_rec.attribute12 := p7_a44;
145 ddp_act_attachment_rec.attribute13 := p7_a45;
146 ddp_act_attachment_rec.attribute14 := p7_a46;
147 ddp_act_attachment_rec.attribute15 := p7_a47;
148 ddp_act_attachment_rec.display_text := p7_a48;
149 ddp_act_attachment_rec.alternate_text := p7_a49;
150 ddp_act_attachment_rec.secured_flag := p7_a50;
151 ddp_act_attachment_rec.attachment_sub_type := p7_a51;
152
153
154 -- here's the delegated call to the old PL/SQL routine
155 jtf_amv_attachment_pub.create_act_attachment(p_api_version,
156 p_init_msg_list,
157 p_commit,
158 p_validation_level,
159 x_return_status,
160 x_msg_count,
161 x_msg_data,
162 ddp_act_attachment_rec,
163 x_act_attachment_id);
164
165 -- copy data back from the local variables to OUT or IN-OUT args, if any
166
167
168
169
170
171
172
173
174 end;
175
176 procedure update_act_attachment(p_api_version NUMBER
177 , p_init_msg_list VARCHAR2
178 , p_commit VARCHAR2
179 , p_validation_level NUMBER
180 , x_return_status out nocopy VARCHAR2
181 , x_msg_count out nocopy NUMBER
182 , x_msg_data out nocopy VARCHAR2
183 , p7_a0 NUMBER := 0-1962.0724
184 , p7_a1 DATE := fnd_api.g_miss_date
185 , p7_a2 NUMBER := 0-1962.0724
186 , p7_a3 DATE := fnd_api.g_miss_date
187 , p7_a4 NUMBER := 0-1962.0724
188 , p7_a5 NUMBER := 0-1962.0724
189 , p7_a6 NUMBER := 0-1962.0724
190 , p7_a7 NUMBER := 0-1962.0724
191 , p7_a8 NUMBER := 0-1962.0724
192 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
193 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
194 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
195 , p7_a12 VARCHAR2 := fnd_api.g_miss_char
196 , p7_a13 NUMBER := 0-1962.0724
197 , p7_a14 VARCHAR2 := fnd_api.g_miss_char
198 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
199 , p7_a16 NUMBER := 0-1962.0724
200 , p7_a17 VARCHAR2 := fnd_api.g_miss_char
201 , p7_a18 NUMBER := 0-1962.0724
202 , p7_a19 NUMBER := 0-1962.0724
203 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
204 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
205 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
206 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
207 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
208 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
209 , p7_a26 NUMBER := 0-1962.0724
210 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
211 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
212 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
213 , p7_a30 NUMBER := 0-1962.0724
214 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
215 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
216 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
217 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
218 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
219 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
220 , p7_a37 VARCHAR2 := fnd_api.g_miss_char
221 , p7_a38 VARCHAR2 := fnd_api.g_miss_char
222 , p7_a39 VARCHAR2 := fnd_api.g_miss_char
223 , p7_a40 VARCHAR2 := fnd_api.g_miss_char
224 , p7_a41 VARCHAR2 := fnd_api.g_miss_char
225 , p7_a42 VARCHAR2 := fnd_api.g_miss_char
226 , p7_a43 VARCHAR2 := fnd_api.g_miss_char
227 , p7_a44 VARCHAR2 := fnd_api.g_miss_char
228 , p7_a45 VARCHAR2 := fnd_api.g_miss_char
229 , p7_a46 VARCHAR2 := fnd_api.g_miss_char
230 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
231 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
232 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
233 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
234 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
235 )
236
237 as
238 ddp_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
239 ddindx binary_integer; indx binary_integer;
240 begin
241
242 -- copy data to the local IN or IN-OUT args, if any
243
244
245
246
247
248
249
250 ddp_act_attachment_rec.attachment_id := rosetta_g_miss_num_map(p7_a0);
251 ddp_act_attachment_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
252 ddp_act_attachment_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
253 ddp_act_attachment_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
254 ddp_act_attachment_rec.created_by := rosetta_g_miss_num_map(p7_a4);
255 ddp_act_attachment_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
256 ddp_act_attachment_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
257 ddp_act_attachment_rec.owner_user_id := rosetta_g_miss_num_map(p7_a7);
258 ddp_act_attachment_rec.attachment_used_by_id := rosetta_g_miss_num_map(p7_a8);
259 ddp_act_attachment_rec.attachment_used_by := p7_a9;
260 ddp_act_attachment_rec.version := p7_a10;
261 ddp_act_attachment_rec.enabled_flag := p7_a11;
262 ddp_act_attachment_rec.can_fulfill_electronic_flag := p7_a12;
263 ddp_act_attachment_rec.file_id := rosetta_g_miss_num_map(p7_a13);
264 ddp_act_attachment_rec.file_name := p7_a14;
265 ddp_act_attachment_rec.file_extension := p7_a15;
266 ddp_act_attachment_rec.document_id := rosetta_g_miss_num_map(p7_a16);
267 ddp_act_attachment_rec.keywords := p7_a17;
268 ddp_act_attachment_rec.display_width := rosetta_g_miss_num_map(p7_a18);
269 ddp_act_attachment_rec.display_height := rosetta_g_miss_num_map(p7_a19);
270 ddp_act_attachment_rec.display_location := p7_a20;
271 ddp_act_attachment_rec.link_to := p7_a21;
272 ddp_act_attachment_rec.link_url := p7_a22;
273 ddp_act_attachment_rec.send_for_preview_flag := p7_a23;
274 ddp_act_attachment_rec.attachment_type := p7_a24;
275 ddp_act_attachment_rec.language_code := p7_a25;
276 ddp_act_attachment_rec.application_id := rosetta_g_miss_num_map(p7_a26);
277 ddp_act_attachment_rec.description := p7_a27;
278 ddp_act_attachment_rec.default_style_sheet := p7_a28;
279 ddp_act_attachment_rec.display_url := p7_a29;
280 ddp_act_attachment_rec.display_rule_id := rosetta_g_miss_num_map(p7_a30);
281 ddp_act_attachment_rec.display_program := p7_a31;
282 ddp_act_attachment_rec.attribute_category := p7_a32;
283 ddp_act_attachment_rec.attribute1 := p7_a33;
284 ddp_act_attachment_rec.attribute2 := p7_a34;
285 ddp_act_attachment_rec.attribute3 := p7_a35;
286 ddp_act_attachment_rec.attribute4 := p7_a36;
287 ddp_act_attachment_rec.attribute5 := p7_a37;
288 ddp_act_attachment_rec.attribute6 := p7_a38;
289 ddp_act_attachment_rec.attribute7 := p7_a39;
290 ddp_act_attachment_rec.attribute8 := p7_a40;
291 ddp_act_attachment_rec.attribute9 := p7_a41;
292 ddp_act_attachment_rec.attribute10 := p7_a42;
293 ddp_act_attachment_rec.attribute11 := p7_a43;
294 ddp_act_attachment_rec.attribute12 := p7_a44;
295 ddp_act_attachment_rec.attribute13 := p7_a45;
296 ddp_act_attachment_rec.attribute14 := p7_a46;
297 ddp_act_attachment_rec.attribute15 := p7_a47;
298 ddp_act_attachment_rec.display_text := p7_a48;
299 ddp_act_attachment_rec.alternate_text := p7_a49;
300 ddp_act_attachment_rec.secured_flag := p7_a50;
301 ddp_act_attachment_rec.attachment_sub_type := p7_a51;
302
303 -- here's the delegated call to the old PL/SQL routine
304 jtf_amv_attachment_pub.update_act_attachment(p_api_version,
305 p_init_msg_list,
306 p_commit,
307 p_validation_level,
308 x_return_status,
309 x_msg_count,
310 x_msg_data,
311 ddp_act_attachment_rec);
312
313 -- copy data back from the local variables to OUT or IN-OUT args, if any
314
315
316
317
318
319
320
321 end;
322
323 procedure validate_act_attachment(p_api_version NUMBER
324 , p_init_msg_list VARCHAR2
325 , p_validation_level NUMBER
326 , x_return_status out nocopy VARCHAR2
327 , x_msg_count out nocopy NUMBER
328 , x_msg_data out nocopy VARCHAR2
329 , p6_a0 NUMBER := 0-1962.0724
330 , p6_a1 DATE := fnd_api.g_miss_date
331 , p6_a2 NUMBER := 0-1962.0724
332 , p6_a3 DATE := fnd_api.g_miss_date
333 , p6_a4 NUMBER := 0-1962.0724
334 , p6_a5 NUMBER := 0-1962.0724
335 , p6_a6 NUMBER := 0-1962.0724
336 , p6_a7 NUMBER := 0-1962.0724
337 , p6_a8 NUMBER := 0-1962.0724
338 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
339 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
340 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
341 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
342 , p6_a13 NUMBER := 0-1962.0724
343 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
344 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
345 , p6_a16 NUMBER := 0-1962.0724
346 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
347 , p6_a18 NUMBER := 0-1962.0724
348 , p6_a19 NUMBER := 0-1962.0724
349 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
350 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
351 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
352 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
353 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
354 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
355 , p6_a26 NUMBER := 0-1962.0724
356 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
357 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
358 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
359 , p6_a30 NUMBER := 0-1962.0724
360 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
361 , p6_a32 VARCHAR2 := fnd_api.g_miss_char
362 , p6_a33 VARCHAR2 := fnd_api.g_miss_char
363 , p6_a34 VARCHAR2 := fnd_api.g_miss_char
364 , p6_a35 VARCHAR2 := fnd_api.g_miss_char
365 , p6_a36 VARCHAR2 := fnd_api.g_miss_char
366 , p6_a37 VARCHAR2 := fnd_api.g_miss_char
367 , p6_a38 VARCHAR2 := fnd_api.g_miss_char
368 , p6_a39 VARCHAR2 := fnd_api.g_miss_char
369 , p6_a40 VARCHAR2 := fnd_api.g_miss_char
370 , p6_a41 VARCHAR2 := fnd_api.g_miss_char
371 , p6_a42 VARCHAR2 := fnd_api.g_miss_char
372 , p6_a43 VARCHAR2 := fnd_api.g_miss_char
373 , p6_a44 VARCHAR2 := fnd_api.g_miss_char
374 , p6_a45 VARCHAR2 := fnd_api.g_miss_char
375 , p6_a46 VARCHAR2 := fnd_api.g_miss_char
376 , p6_a47 VARCHAR2 := fnd_api.g_miss_char
377 , p6_a48 VARCHAR2 := fnd_api.g_miss_char
378 , p6_a49 VARCHAR2 := fnd_api.g_miss_char
379 , p6_a50 VARCHAR2 := fnd_api.g_miss_char
380 , p6_a51 VARCHAR2 := fnd_api.g_miss_char
381 )
382
383 as
384 ddp_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
385 ddindx binary_integer; indx binary_integer;
386 begin
387
388 -- copy data to the local IN or IN-OUT args, if any
389
390
391
392
393
394
395 ddp_act_attachment_rec.attachment_id := rosetta_g_miss_num_map(p6_a0);
396 ddp_act_attachment_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
397 ddp_act_attachment_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
398 ddp_act_attachment_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
399 ddp_act_attachment_rec.created_by := rosetta_g_miss_num_map(p6_a4);
400 ddp_act_attachment_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
401 ddp_act_attachment_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
402 ddp_act_attachment_rec.owner_user_id := rosetta_g_miss_num_map(p6_a7);
403 ddp_act_attachment_rec.attachment_used_by_id := rosetta_g_miss_num_map(p6_a8);
404 ddp_act_attachment_rec.attachment_used_by := p6_a9;
405 ddp_act_attachment_rec.version := p6_a10;
406 ddp_act_attachment_rec.enabled_flag := p6_a11;
407 ddp_act_attachment_rec.can_fulfill_electronic_flag := p6_a12;
408 ddp_act_attachment_rec.file_id := rosetta_g_miss_num_map(p6_a13);
409 ddp_act_attachment_rec.file_name := p6_a14;
410 ddp_act_attachment_rec.file_extension := p6_a15;
411 ddp_act_attachment_rec.document_id := rosetta_g_miss_num_map(p6_a16);
412 ddp_act_attachment_rec.keywords := p6_a17;
413 ddp_act_attachment_rec.display_width := rosetta_g_miss_num_map(p6_a18);
414 ddp_act_attachment_rec.display_height := rosetta_g_miss_num_map(p6_a19);
415 ddp_act_attachment_rec.display_location := p6_a20;
416 ddp_act_attachment_rec.link_to := p6_a21;
417 ddp_act_attachment_rec.link_url := p6_a22;
418 ddp_act_attachment_rec.send_for_preview_flag := p6_a23;
419 ddp_act_attachment_rec.attachment_type := p6_a24;
420 ddp_act_attachment_rec.language_code := p6_a25;
421 ddp_act_attachment_rec.application_id := rosetta_g_miss_num_map(p6_a26);
422 ddp_act_attachment_rec.description := p6_a27;
423 ddp_act_attachment_rec.default_style_sheet := p6_a28;
424 ddp_act_attachment_rec.display_url := p6_a29;
425 ddp_act_attachment_rec.display_rule_id := rosetta_g_miss_num_map(p6_a30);
426 ddp_act_attachment_rec.display_program := p6_a31;
427 ddp_act_attachment_rec.attribute_category := p6_a32;
428 ddp_act_attachment_rec.attribute1 := p6_a33;
429 ddp_act_attachment_rec.attribute2 := p6_a34;
430 ddp_act_attachment_rec.attribute3 := p6_a35;
431 ddp_act_attachment_rec.attribute4 := p6_a36;
432 ddp_act_attachment_rec.attribute5 := p6_a37;
433 ddp_act_attachment_rec.attribute6 := p6_a38;
434 ddp_act_attachment_rec.attribute7 := p6_a39;
435 ddp_act_attachment_rec.attribute8 := p6_a40;
436 ddp_act_attachment_rec.attribute9 := p6_a41;
437 ddp_act_attachment_rec.attribute10 := p6_a42;
438 ddp_act_attachment_rec.attribute11 := p6_a43;
439 ddp_act_attachment_rec.attribute12 := p6_a44;
440 ddp_act_attachment_rec.attribute13 := p6_a45;
441 ddp_act_attachment_rec.attribute14 := p6_a46;
442 ddp_act_attachment_rec.attribute15 := p6_a47;
443 ddp_act_attachment_rec.display_text := p6_a48;
444 ddp_act_attachment_rec.alternate_text := p6_a49;
445 ddp_act_attachment_rec.secured_flag := p6_a50;
446 ddp_act_attachment_rec.attachment_sub_type := p6_a51;
447
448 -- here's the delegated call to the old PL/SQL routine
449 jtf_amv_attachment_pub.validate_act_attachment(p_api_version,
450 p_init_msg_list,
451 p_validation_level,
452 x_return_status,
453 x_msg_count,
454 x_msg_data,
455 ddp_act_attachment_rec);
456
457 -- copy data back from the local variables to OUT or IN-OUT args, if any
458
459
460
461
462
463
464 end;
465
466 procedure check_act_attachment_items(p_validation_mode VARCHAR2
467 , x_return_status out nocopy VARCHAR2
468 , p0_a0 NUMBER := 0-1962.0724
469 , p0_a1 DATE := fnd_api.g_miss_date
470 , p0_a2 NUMBER := 0-1962.0724
471 , p0_a3 DATE := fnd_api.g_miss_date
472 , p0_a4 NUMBER := 0-1962.0724
473 , p0_a5 NUMBER := 0-1962.0724
474 , p0_a6 NUMBER := 0-1962.0724
475 , p0_a7 NUMBER := 0-1962.0724
476 , p0_a8 NUMBER := 0-1962.0724
477 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
478 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
479 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
480 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
481 , p0_a13 NUMBER := 0-1962.0724
482 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
483 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
484 , p0_a16 NUMBER := 0-1962.0724
485 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
486 , p0_a18 NUMBER := 0-1962.0724
487 , p0_a19 NUMBER := 0-1962.0724
488 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
489 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
490 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
491 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
492 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
493 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
494 , p0_a26 NUMBER := 0-1962.0724
495 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
496 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
497 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
498 , p0_a30 NUMBER := 0-1962.0724
499 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
500 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
501 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
502 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
503 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
504 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
505 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
506 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
507 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
508 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
509 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
510 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
511 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
512 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
513 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
514 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
515 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
516 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
517 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
518 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
519 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
520 )
521
522 as
523 ddp_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
524 ddindx binary_integer; indx binary_integer;
525 begin
526
527 -- copy data to the local IN or IN-OUT args, if any
528 ddp_act_attachment_rec.attachment_id := rosetta_g_miss_num_map(p0_a0);
529 ddp_act_attachment_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
530 ddp_act_attachment_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
531 ddp_act_attachment_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
532 ddp_act_attachment_rec.created_by := rosetta_g_miss_num_map(p0_a4);
533 ddp_act_attachment_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
534 ddp_act_attachment_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
535 ddp_act_attachment_rec.owner_user_id := rosetta_g_miss_num_map(p0_a7);
536 ddp_act_attachment_rec.attachment_used_by_id := rosetta_g_miss_num_map(p0_a8);
537 ddp_act_attachment_rec.attachment_used_by := p0_a9;
538 ddp_act_attachment_rec.version := p0_a10;
539 ddp_act_attachment_rec.enabled_flag := p0_a11;
540 ddp_act_attachment_rec.can_fulfill_electronic_flag := p0_a12;
541 ddp_act_attachment_rec.file_id := rosetta_g_miss_num_map(p0_a13);
542 ddp_act_attachment_rec.file_name := p0_a14;
543 ddp_act_attachment_rec.file_extension := p0_a15;
544 ddp_act_attachment_rec.document_id := rosetta_g_miss_num_map(p0_a16);
545 ddp_act_attachment_rec.keywords := p0_a17;
546 ddp_act_attachment_rec.display_width := rosetta_g_miss_num_map(p0_a18);
547 ddp_act_attachment_rec.display_height := rosetta_g_miss_num_map(p0_a19);
548 ddp_act_attachment_rec.display_location := p0_a20;
549 ddp_act_attachment_rec.link_to := p0_a21;
550 ddp_act_attachment_rec.link_url := p0_a22;
551 ddp_act_attachment_rec.send_for_preview_flag := p0_a23;
552 ddp_act_attachment_rec.attachment_type := p0_a24;
553 ddp_act_attachment_rec.language_code := p0_a25;
554 ddp_act_attachment_rec.application_id := rosetta_g_miss_num_map(p0_a26);
555 ddp_act_attachment_rec.description := p0_a27;
556 ddp_act_attachment_rec.default_style_sheet := p0_a28;
557 ddp_act_attachment_rec.display_url := p0_a29;
558 ddp_act_attachment_rec.display_rule_id := rosetta_g_miss_num_map(p0_a30);
559 ddp_act_attachment_rec.display_program := p0_a31;
560 ddp_act_attachment_rec.attribute_category := p0_a32;
561 ddp_act_attachment_rec.attribute1 := p0_a33;
562 ddp_act_attachment_rec.attribute2 := p0_a34;
563 ddp_act_attachment_rec.attribute3 := p0_a35;
564 ddp_act_attachment_rec.attribute4 := p0_a36;
565 ddp_act_attachment_rec.attribute5 := p0_a37;
566 ddp_act_attachment_rec.attribute6 := p0_a38;
567 ddp_act_attachment_rec.attribute7 := p0_a39;
568 ddp_act_attachment_rec.attribute8 := p0_a40;
569 ddp_act_attachment_rec.attribute9 := p0_a41;
570 ddp_act_attachment_rec.attribute10 := p0_a42;
571 ddp_act_attachment_rec.attribute11 := p0_a43;
572 ddp_act_attachment_rec.attribute12 := p0_a44;
573 ddp_act_attachment_rec.attribute13 := p0_a45;
574 ddp_act_attachment_rec.attribute14 := p0_a46;
575 ddp_act_attachment_rec.attribute15 := p0_a47;
576 ddp_act_attachment_rec.display_text := p0_a48;
577 ddp_act_attachment_rec.alternate_text := p0_a49;
578 ddp_act_attachment_rec.secured_flag := p0_a50;
579 ddp_act_attachment_rec.attachment_sub_type := p0_a51;
580
581
582
583 -- here's the delegated call to the old PL/SQL routine
584 jtf_amv_attachment_pub.check_act_attachment_items(ddp_act_attachment_rec,
585 p_validation_mode,
586 x_return_status);
587
588 -- copy data back from the local variables to OUT or IN-OUT args, if any
589
590
591 end;
592
593 procedure check_act_attachment_record(x_return_status out nocopy VARCHAR2
594 , p0_a0 NUMBER := 0-1962.0724
595 , p0_a1 DATE := fnd_api.g_miss_date
596 , p0_a2 NUMBER := 0-1962.0724
597 , p0_a3 DATE := fnd_api.g_miss_date
598 , p0_a4 NUMBER := 0-1962.0724
599 , p0_a5 NUMBER := 0-1962.0724
600 , p0_a6 NUMBER := 0-1962.0724
601 , p0_a7 NUMBER := 0-1962.0724
602 , p0_a8 NUMBER := 0-1962.0724
603 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
604 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
605 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
606 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
607 , p0_a13 NUMBER := 0-1962.0724
608 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
609 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
610 , p0_a16 NUMBER := 0-1962.0724
611 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
612 , p0_a18 NUMBER := 0-1962.0724
613 , p0_a19 NUMBER := 0-1962.0724
614 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
615 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
616 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
617 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
618 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
619 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
620 , p0_a26 NUMBER := 0-1962.0724
621 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
622 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
623 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
624 , p0_a30 NUMBER := 0-1962.0724
625 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
626 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
627 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
628 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
629 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
630 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
631 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
632 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
633 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
634 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
635 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
636 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
637 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
638 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
639 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
640 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
641 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
642 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
643 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
644 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
645 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
646 , p1_a0 NUMBER := 0-1962.0724
647 , p1_a1 DATE := fnd_api.g_miss_date
648 , p1_a2 NUMBER := 0-1962.0724
649 , p1_a3 DATE := fnd_api.g_miss_date
650 , p1_a4 NUMBER := 0-1962.0724
651 , p1_a5 NUMBER := 0-1962.0724
652 , p1_a6 NUMBER := 0-1962.0724
653 , p1_a7 NUMBER := 0-1962.0724
654 , p1_a8 NUMBER := 0-1962.0724
655 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
656 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
657 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
658 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
659 , p1_a13 NUMBER := 0-1962.0724
660 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
661 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
662 , p1_a16 NUMBER := 0-1962.0724
663 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
664 , p1_a18 NUMBER := 0-1962.0724
665 , p1_a19 NUMBER := 0-1962.0724
666 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
667 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
668 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
669 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
670 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
671 , p1_a25 VARCHAR2 := fnd_api.g_miss_char
672 , p1_a26 NUMBER := 0-1962.0724
673 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
674 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
675 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
676 , p1_a30 NUMBER := 0-1962.0724
677 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
678 , p1_a32 VARCHAR2 := fnd_api.g_miss_char
679 , p1_a33 VARCHAR2 := fnd_api.g_miss_char
680 , p1_a34 VARCHAR2 := fnd_api.g_miss_char
681 , p1_a35 VARCHAR2 := fnd_api.g_miss_char
682 , p1_a36 VARCHAR2 := fnd_api.g_miss_char
683 , p1_a37 VARCHAR2 := fnd_api.g_miss_char
684 , p1_a38 VARCHAR2 := fnd_api.g_miss_char
685 , p1_a39 VARCHAR2 := fnd_api.g_miss_char
686 , p1_a40 VARCHAR2 := fnd_api.g_miss_char
687 , p1_a41 VARCHAR2 := fnd_api.g_miss_char
688 , p1_a42 VARCHAR2 := fnd_api.g_miss_char
689 , p1_a43 VARCHAR2 := fnd_api.g_miss_char
690 , p1_a44 VARCHAR2 := fnd_api.g_miss_char
691 , p1_a45 VARCHAR2 := fnd_api.g_miss_char
692 , p1_a46 VARCHAR2 := fnd_api.g_miss_char
693 , p1_a47 VARCHAR2 := fnd_api.g_miss_char
694 , p1_a48 VARCHAR2 := fnd_api.g_miss_char
695 , p1_a49 VARCHAR2 := fnd_api.g_miss_char
696 , p1_a50 VARCHAR2 := fnd_api.g_miss_char
697 , p1_a51 VARCHAR2 := fnd_api.g_miss_char
698 )
699
700 as
701 ddp_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
702 ddp_complete_rec jtf_amv_attachment_pub.act_attachment_rec_type;
703 ddindx binary_integer; indx binary_integer;
704 begin
705
706 -- copy data to the local IN or IN-OUT args, if any
707 ddp_act_attachment_rec.attachment_id := rosetta_g_miss_num_map(p0_a0);
708 ddp_act_attachment_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
709 ddp_act_attachment_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
710 ddp_act_attachment_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
711 ddp_act_attachment_rec.created_by := rosetta_g_miss_num_map(p0_a4);
712 ddp_act_attachment_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
713 ddp_act_attachment_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
714 ddp_act_attachment_rec.owner_user_id := rosetta_g_miss_num_map(p0_a7);
715 ddp_act_attachment_rec.attachment_used_by_id := rosetta_g_miss_num_map(p0_a8);
716 ddp_act_attachment_rec.attachment_used_by := p0_a9;
717 ddp_act_attachment_rec.version := p0_a10;
718 ddp_act_attachment_rec.enabled_flag := p0_a11;
719 ddp_act_attachment_rec.can_fulfill_electronic_flag := p0_a12;
720 ddp_act_attachment_rec.file_id := rosetta_g_miss_num_map(p0_a13);
721 ddp_act_attachment_rec.file_name := p0_a14;
722 ddp_act_attachment_rec.file_extension := p0_a15;
723 ddp_act_attachment_rec.document_id := rosetta_g_miss_num_map(p0_a16);
724 ddp_act_attachment_rec.keywords := p0_a17;
725 ddp_act_attachment_rec.display_width := rosetta_g_miss_num_map(p0_a18);
726 ddp_act_attachment_rec.display_height := rosetta_g_miss_num_map(p0_a19);
727 ddp_act_attachment_rec.display_location := p0_a20;
728 ddp_act_attachment_rec.link_to := p0_a21;
729 ddp_act_attachment_rec.link_url := p0_a22;
730 ddp_act_attachment_rec.send_for_preview_flag := p0_a23;
731 ddp_act_attachment_rec.attachment_type := p0_a24;
732 ddp_act_attachment_rec.language_code := p0_a25;
733 ddp_act_attachment_rec.application_id := rosetta_g_miss_num_map(p0_a26);
734 ddp_act_attachment_rec.description := p0_a27;
735 ddp_act_attachment_rec.default_style_sheet := p0_a28;
736 ddp_act_attachment_rec.display_url := p0_a29;
737 ddp_act_attachment_rec.display_rule_id := rosetta_g_miss_num_map(p0_a30);
738 ddp_act_attachment_rec.display_program := p0_a31;
739 ddp_act_attachment_rec.attribute_category := p0_a32;
740 ddp_act_attachment_rec.attribute1 := p0_a33;
741 ddp_act_attachment_rec.attribute2 := p0_a34;
742 ddp_act_attachment_rec.attribute3 := p0_a35;
743 ddp_act_attachment_rec.attribute4 := p0_a36;
744 ddp_act_attachment_rec.attribute5 := p0_a37;
745 ddp_act_attachment_rec.attribute6 := p0_a38;
746 ddp_act_attachment_rec.attribute7 := p0_a39;
747 ddp_act_attachment_rec.attribute8 := p0_a40;
748 ddp_act_attachment_rec.attribute9 := p0_a41;
749 ddp_act_attachment_rec.attribute10 := p0_a42;
750 ddp_act_attachment_rec.attribute11 := p0_a43;
751 ddp_act_attachment_rec.attribute12 := p0_a44;
752 ddp_act_attachment_rec.attribute13 := p0_a45;
753 ddp_act_attachment_rec.attribute14 := p0_a46;
754 ddp_act_attachment_rec.attribute15 := p0_a47;
755 ddp_act_attachment_rec.display_text := p0_a48;
756 ddp_act_attachment_rec.alternate_text := p0_a49;
757 ddp_act_attachment_rec.secured_flag := p0_a50;
758 ddp_act_attachment_rec.attachment_sub_type := p0_a51;
759
760 ddp_complete_rec.attachment_id := rosetta_g_miss_num_map(p1_a0);
761 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
762 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
763 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
764 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
765 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
766 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
767 ddp_complete_rec.owner_user_id := rosetta_g_miss_num_map(p1_a7);
768 ddp_complete_rec.attachment_used_by_id := rosetta_g_miss_num_map(p1_a8);
769 ddp_complete_rec.attachment_used_by := p1_a9;
770 ddp_complete_rec.version := p1_a10;
771 ddp_complete_rec.enabled_flag := p1_a11;
772 ddp_complete_rec.can_fulfill_electronic_flag := p1_a12;
773 ddp_complete_rec.file_id := rosetta_g_miss_num_map(p1_a13);
774 ddp_complete_rec.file_name := p1_a14;
775 ddp_complete_rec.file_extension := p1_a15;
776 ddp_complete_rec.document_id := rosetta_g_miss_num_map(p1_a16);
777 ddp_complete_rec.keywords := p1_a17;
778 ddp_complete_rec.display_width := rosetta_g_miss_num_map(p1_a18);
779 ddp_complete_rec.display_height := rosetta_g_miss_num_map(p1_a19);
780 ddp_complete_rec.display_location := p1_a20;
781 ddp_complete_rec.link_to := p1_a21;
782 ddp_complete_rec.link_url := p1_a22;
783 ddp_complete_rec.send_for_preview_flag := p1_a23;
784 ddp_complete_rec.attachment_type := p1_a24;
785 ddp_complete_rec.language_code := p1_a25;
786 ddp_complete_rec.application_id := rosetta_g_miss_num_map(p1_a26);
787 ddp_complete_rec.description := p1_a27;
788 ddp_complete_rec.default_style_sheet := p1_a28;
789 ddp_complete_rec.display_url := p1_a29;
790 ddp_complete_rec.display_rule_id := rosetta_g_miss_num_map(p1_a30);
791 ddp_complete_rec.display_program := p1_a31;
792 ddp_complete_rec.attribute_category := p1_a32;
793 ddp_complete_rec.attribute1 := p1_a33;
794 ddp_complete_rec.attribute2 := p1_a34;
795 ddp_complete_rec.attribute3 := p1_a35;
796 ddp_complete_rec.attribute4 := p1_a36;
797 ddp_complete_rec.attribute5 := p1_a37;
798 ddp_complete_rec.attribute6 := p1_a38;
799 ddp_complete_rec.attribute7 := p1_a39;
800 ddp_complete_rec.attribute8 := p1_a40;
801 ddp_complete_rec.attribute9 := p1_a41;
802 ddp_complete_rec.attribute10 := p1_a42;
803 ddp_complete_rec.attribute11 := p1_a43;
804 ddp_complete_rec.attribute12 := p1_a44;
805 ddp_complete_rec.attribute13 := p1_a45;
806 ddp_complete_rec.attribute14 := p1_a46;
807 ddp_complete_rec.attribute15 := p1_a47;
808 ddp_complete_rec.display_text := p1_a48;
809 ddp_complete_rec.alternate_text := p1_a49;
810 ddp_complete_rec.secured_flag := p1_a50;
811 ddp_complete_rec.attachment_sub_type := p1_a51;
812
813
814 -- here's the delegated call to the old PL/SQL routine
815 jtf_amv_attachment_pub.check_act_attachment_record(ddp_act_attachment_rec,
816 ddp_complete_rec,
817 x_return_status);
818
819 -- copy data back from the local variables to OUT or IN-OUT args, if any
820
821
822 end;
823
824 procedure miss_act_attachment_rec(p0_a0 out nocopy NUMBER
825 , p0_a1 out nocopy DATE
826 , p0_a2 out nocopy NUMBER
827 , p0_a3 out nocopy DATE
828 , p0_a4 out nocopy NUMBER
829 , p0_a5 out nocopy NUMBER
830 , p0_a6 out nocopy NUMBER
831 , p0_a7 out nocopy NUMBER
832 , p0_a8 out nocopy NUMBER
833 , p0_a9 out nocopy VARCHAR2
834 , p0_a10 out nocopy VARCHAR2
835 , p0_a11 out nocopy VARCHAR2
836 , p0_a12 out nocopy VARCHAR2
837 , p0_a13 out nocopy NUMBER
838 , p0_a14 out nocopy VARCHAR2
839 , p0_a15 out nocopy VARCHAR2
840 , p0_a16 out nocopy NUMBER
841 , p0_a17 out nocopy VARCHAR2
842 , p0_a18 out nocopy NUMBER
843 , p0_a19 out nocopy NUMBER
844 , p0_a20 out nocopy VARCHAR2
845 , p0_a21 out nocopy VARCHAR2
846 , p0_a22 out nocopy VARCHAR2
847 , p0_a23 out nocopy VARCHAR2
848 , p0_a24 out nocopy VARCHAR2
849 , p0_a25 out nocopy VARCHAR2
850 , p0_a26 out nocopy NUMBER
851 , p0_a27 out nocopy VARCHAR2
852 , p0_a28 out nocopy VARCHAR2
853 , p0_a29 out nocopy VARCHAR2
854 , p0_a30 out nocopy NUMBER
855 , p0_a31 out nocopy VARCHAR2
856 , p0_a32 out nocopy VARCHAR2
857 , p0_a33 out nocopy VARCHAR2
858 , p0_a34 out nocopy VARCHAR2
859 , p0_a35 out nocopy VARCHAR2
860 , p0_a36 out nocopy VARCHAR2
861 , p0_a37 out nocopy VARCHAR2
862 , p0_a38 out nocopy VARCHAR2
863 , p0_a39 out nocopy VARCHAR2
864 , p0_a40 out nocopy VARCHAR2
865 , p0_a41 out nocopy VARCHAR2
866 , p0_a42 out nocopy VARCHAR2
867 , p0_a43 out nocopy VARCHAR2
868 , p0_a44 out nocopy VARCHAR2
869 , p0_a45 out nocopy VARCHAR2
870 , p0_a46 out nocopy VARCHAR2
871 , p0_a47 out nocopy VARCHAR2
872 , p0_a48 out nocopy VARCHAR2
873 , p0_a49 out nocopy VARCHAR2
874 , p0_a50 out nocopy VARCHAR2
875 , p0_a51 out nocopy VARCHAR2
876 )
877
878 as
879 ddx_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
880 ddindx binary_integer; indx binary_integer;
881 begin
882
883 -- copy data to the local IN or IN-OUT args, if any
884
885 -- here's the delegated call to the old PL/SQL routine
886 jtf_amv_attachment_pub.miss_act_attachment_rec(ddx_act_attachment_rec);
887
888 -- copy data back from the local variables to OUT or IN-OUT args, if any
889 p0_a0 := rosetta_g_miss_num_map(ddx_act_attachment_rec.attachment_id);
890 p0_a1 := ddx_act_attachment_rec.last_update_date;
891 p0_a2 := rosetta_g_miss_num_map(ddx_act_attachment_rec.last_updated_by);
892 p0_a3 := ddx_act_attachment_rec.creation_date;
893 p0_a4 := rosetta_g_miss_num_map(ddx_act_attachment_rec.created_by);
894 p0_a5 := rosetta_g_miss_num_map(ddx_act_attachment_rec.last_update_login);
895 p0_a6 := rosetta_g_miss_num_map(ddx_act_attachment_rec.object_version_number);
896 p0_a7 := rosetta_g_miss_num_map(ddx_act_attachment_rec.owner_user_id);
897 p0_a8 := rosetta_g_miss_num_map(ddx_act_attachment_rec.attachment_used_by_id);
898 p0_a9 := ddx_act_attachment_rec.attachment_used_by;
899 p0_a10 := ddx_act_attachment_rec.version;
900 p0_a11 := ddx_act_attachment_rec.enabled_flag;
901 p0_a12 := ddx_act_attachment_rec.can_fulfill_electronic_flag;
902 p0_a13 := rosetta_g_miss_num_map(ddx_act_attachment_rec.file_id);
903 p0_a14 := ddx_act_attachment_rec.file_name;
904 p0_a15 := ddx_act_attachment_rec.file_extension;
905 p0_a16 := rosetta_g_miss_num_map(ddx_act_attachment_rec.document_id);
906 p0_a17 := ddx_act_attachment_rec.keywords;
907 p0_a18 := rosetta_g_miss_num_map(ddx_act_attachment_rec.display_width);
908 p0_a19 := rosetta_g_miss_num_map(ddx_act_attachment_rec.display_height);
909 p0_a20 := ddx_act_attachment_rec.display_location;
910 p0_a21 := ddx_act_attachment_rec.link_to;
911 p0_a22 := ddx_act_attachment_rec.link_url;
912 p0_a23 := ddx_act_attachment_rec.send_for_preview_flag;
913 p0_a24 := ddx_act_attachment_rec.attachment_type;
914 p0_a25 := ddx_act_attachment_rec.language_code;
915 p0_a26 := rosetta_g_miss_num_map(ddx_act_attachment_rec.application_id);
916 p0_a27 := ddx_act_attachment_rec.description;
917 p0_a28 := ddx_act_attachment_rec.default_style_sheet;
918 p0_a29 := ddx_act_attachment_rec.display_url;
919 p0_a30 := rosetta_g_miss_num_map(ddx_act_attachment_rec.display_rule_id);
920 p0_a31 := ddx_act_attachment_rec.display_program;
921 p0_a32 := ddx_act_attachment_rec.attribute_category;
922 p0_a33 := ddx_act_attachment_rec.attribute1;
923 p0_a34 := ddx_act_attachment_rec.attribute2;
924 p0_a35 := ddx_act_attachment_rec.attribute3;
925 p0_a36 := ddx_act_attachment_rec.attribute4;
926 p0_a37 := ddx_act_attachment_rec.attribute5;
927 p0_a38 := ddx_act_attachment_rec.attribute6;
928 p0_a39 := ddx_act_attachment_rec.attribute7;
929 p0_a40 := ddx_act_attachment_rec.attribute8;
930 p0_a41 := ddx_act_attachment_rec.attribute9;
931 p0_a42 := ddx_act_attachment_rec.attribute10;
932 p0_a43 := ddx_act_attachment_rec.attribute11;
933 p0_a44 := ddx_act_attachment_rec.attribute12;
934 p0_a45 := ddx_act_attachment_rec.attribute13;
935 p0_a46 := ddx_act_attachment_rec.attribute14;
936 p0_a47 := ddx_act_attachment_rec.attribute15;
937 p0_a48 := ddx_act_attachment_rec.display_text;
938 p0_a49 := ddx_act_attachment_rec.alternate_text;
939 p0_a50 := ddx_act_attachment_rec.secured_flag;
940 p0_a51 := ddx_act_attachment_rec.attachment_sub_type;
941 end;
942
943 procedure complete_act_attachment_rec(p1_a0 out nocopy NUMBER
944 , p1_a1 out nocopy DATE
945 , p1_a2 out nocopy NUMBER
946 , p1_a3 out nocopy DATE
947 , p1_a4 out nocopy NUMBER
948 , p1_a5 out nocopy NUMBER
949 , p1_a6 out nocopy NUMBER
950 , p1_a7 out nocopy NUMBER
951 , p1_a8 out nocopy NUMBER
952 , p1_a9 out nocopy VARCHAR2
953 , p1_a10 out nocopy VARCHAR2
954 , p1_a11 out nocopy VARCHAR2
955 , p1_a12 out nocopy VARCHAR2
956 , p1_a13 out nocopy NUMBER
957 , p1_a14 out nocopy VARCHAR2
958 , p1_a15 out nocopy VARCHAR2
959 , p1_a16 out nocopy NUMBER
960 , p1_a17 out nocopy VARCHAR2
961 , p1_a18 out nocopy NUMBER
962 , p1_a19 out nocopy NUMBER
963 , p1_a20 out nocopy VARCHAR2
964 , p1_a21 out nocopy VARCHAR2
965 , p1_a22 out nocopy VARCHAR2
966 , p1_a23 out nocopy VARCHAR2
967 , p1_a24 out nocopy VARCHAR2
968 , p1_a25 out nocopy VARCHAR2
969 , p1_a26 out nocopy NUMBER
970 , p1_a27 out nocopy VARCHAR2
971 , p1_a28 out nocopy VARCHAR2
972 , p1_a29 out nocopy VARCHAR2
973 , p1_a30 out nocopy NUMBER
974 , p1_a31 out nocopy VARCHAR2
975 , p1_a32 out nocopy VARCHAR2
976 , p1_a33 out nocopy VARCHAR2
977 , p1_a34 out nocopy VARCHAR2
978 , p1_a35 out nocopy VARCHAR2
979 , p1_a36 out nocopy VARCHAR2
980 , p1_a37 out nocopy VARCHAR2
981 , p1_a38 out nocopy VARCHAR2
982 , p1_a39 out nocopy VARCHAR2
983 , p1_a40 out nocopy VARCHAR2
984 , p1_a41 out nocopy VARCHAR2
985 , p1_a42 out nocopy VARCHAR2
986 , p1_a43 out nocopy VARCHAR2
987 , p1_a44 out nocopy VARCHAR2
988 , p1_a45 out nocopy VARCHAR2
989 , p1_a46 out nocopy VARCHAR2
990 , p1_a47 out nocopy VARCHAR2
991 , p1_a48 out nocopy VARCHAR2
992 , p1_a49 out nocopy VARCHAR2
993 , p1_a50 out nocopy VARCHAR2
994 , p1_a51 out nocopy VARCHAR2
995 , p0_a0 NUMBER := 0-1962.0724
996 , p0_a1 DATE := fnd_api.g_miss_date
997 , p0_a2 NUMBER := 0-1962.0724
998 , p0_a3 DATE := fnd_api.g_miss_date
999 , p0_a4 NUMBER := 0-1962.0724
1000 , p0_a5 NUMBER := 0-1962.0724
1001 , p0_a6 NUMBER := 0-1962.0724
1002 , p0_a7 NUMBER := 0-1962.0724
1003 , p0_a8 NUMBER := 0-1962.0724
1004 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
1005 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
1006 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
1007 , p0_a12 VARCHAR2 := fnd_api.g_miss_char
1008 , p0_a13 NUMBER := 0-1962.0724
1009 , p0_a14 VARCHAR2 := fnd_api.g_miss_char
1010 , p0_a15 VARCHAR2 := fnd_api.g_miss_char
1011 , p0_a16 NUMBER := 0-1962.0724
1012 , p0_a17 VARCHAR2 := fnd_api.g_miss_char
1013 , p0_a18 NUMBER := 0-1962.0724
1014 , p0_a19 NUMBER := 0-1962.0724
1015 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1016 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
1017 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
1018 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
1019 , p0_a24 VARCHAR2 := fnd_api.g_miss_char
1020 , p0_a25 VARCHAR2 := fnd_api.g_miss_char
1021 , p0_a26 NUMBER := 0-1962.0724
1022 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1023 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1024 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
1025 , p0_a30 NUMBER := 0-1962.0724
1026 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
1027 , p0_a32 VARCHAR2 := fnd_api.g_miss_char
1028 , p0_a33 VARCHAR2 := fnd_api.g_miss_char
1029 , p0_a34 VARCHAR2 := fnd_api.g_miss_char
1030 , p0_a35 VARCHAR2 := fnd_api.g_miss_char
1031 , p0_a36 VARCHAR2 := fnd_api.g_miss_char
1032 , p0_a37 VARCHAR2 := fnd_api.g_miss_char
1033 , p0_a38 VARCHAR2 := fnd_api.g_miss_char
1034 , p0_a39 VARCHAR2 := fnd_api.g_miss_char
1035 , p0_a40 VARCHAR2 := fnd_api.g_miss_char
1036 , p0_a41 VARCHAR2 := fnd_api.g_miss_char
1037 , p0_a42 VARCHAR2 := fnd_api.g_miss_char
1038 , p0_a43 VARCHAR2 := fnd_api.g_miss_char
1039 , p0_a44 VARCHAR2 := fnd_api.g_miss_char
1040 , p0_a45 VARCHAR2 := fnd_api.g_miss_char
1041 , p0_a46 VARCHAR2 := fnd_api.g_miss_char
1042 , p0_a47 VARCHAR2 := fnd_api.g_miss_char
1043 , p0_a48 VARCHAR2 := fnd_api.g_miss_char
1044 , p0_a49 VARCHAR2 := fnd_api.g_miss_char
1045 , p0_a50 VARCHAR2 := fnd_api.g_miss_char
1046 , p0_a51 VARCHAR2 := fnd_api.g_miss_char
1047 )
1048
1049 as
1050 ddp_act_attachment_rec jtf_amv_attachment_pub.act_attachment_rec_type;
1051 ddx_complete_rec jtf_amv_attachment_pub.act_attachment_rec_type;
1052 ddindx binary_integer; indx binary_integer;
1053 begin
1054
1055 -- copy data to the local IN or IN-OUT args, if any
1056 ddp_act_attachment_rec.attachment_id := rosetta_g_miss_num_map(p0_a0);
1057 ddp_act_attachment_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
1058 ddp_act_attachment_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
1059 ddp_act_attachment_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
1060 ddp_act_attachment_rec.created_by := rosetta_g_miss_num_map(p0_a4);
1061 ddp_act_attachment_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
1062 ddp_act_attachment_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
1063 ddp_act_attachment_rec.owner_user_id := rosetta_g_miss_num_map(p0_a7);
1064 ddp_act_attachment_rec.attachment_used_by_id := rosetta_g_miss_num_map(p0_a8);
1065 ddp_act_attachment_rec.attachment_used_by := p0_a9;
1066 ddp_act_attachment_rec.version := p0_a10;
1067 ddp_act_attachment_rec.enabled_flag := p0_a11;
1068 ddp_act_attachment_rec.can_fulfill_electronic_flag := p0_a12;
1069 ddp_act_attachment_rec.file_id := rosetta_g_miss_num_map(p0_a13);
1070 ddp_act_attachment_rec.file_name := p0_a14;
1071 ddp_act_attachment_rec.file_extension := p0_a15;
1072 ddp_act_attachment_rec.document_id := rosetta_g_miss_num_map(p0_a16);
1073 ddp_act_attachment_rec.keywords := p0_a17;
1074 ddp_act_attachment_rec.display_width := rosetta_g_miss_num_map(p0_a18);
1075 ddp_act_attachment_rec.display_height := rosetta_g_miss_num_map(p0_a19);
1076 ddp_act_attachment_rec.display_location := p0_a20;
1077 ddp_act_attachment_rec.link_to := p0_a21;
1078 ddp_act_attachment_rec.link_url := p0_a22;
1079 ddp_act_attachment_rec.send_for_preview_flag := p0_a23;
1080 ddp_act_attachment_rec.attachment_type := p0_a24;
1081 ddp_act_attachment_rec.language_code := p0_a25;
1082 ddp_act_attachment_rec.application_id := rosetta_g_miss_num_map(p0_a26);
1083 ddp_act_attachment_rec.description := p0_a27;
1084 ddp_act_attachment_rec.default_style_sheet := p0_a28;
1085 ddp_act_attachment_rec.display_url := p0_a29;
1086 ddp_act_attachment_rec.display_rule_id := rosetta_g_miss_num_map(p0_a30);
1087 ddp_act_attachment_rec.display_program := p0_a31;
1088 ddp_act_attachment_rec.attribute_category := p0_a32;
1089 ddp_act_attachment_rec.attribute1 := p0_a33;
1090 ddp_act_attachment_rec.attribute2 := p0_a34;
1091 ddp_act_attachment_rec.attribute3 := p0_a35;
1092 ddp_act_attachment_rec.attribute4 := p0_a36;
1093 ddp_act_attachment_rec.attribute5 := p0_a37;
1094 ddp_act_attachment_rec.attribute6 := p0_a38;
1095 ddp_act_attachment_rec.attribute7 := p0_a39;
1096 ddp_act_attachment_rec.attribute8 := p0_a40;
1097 ddp_act_attachment_rec.attribute9 := p0_a41;
1098 ddp_act_attachment_rec.attribute10 := p0_a42;
1099 ddp_act_attachment_rec.attribute11 := p0_a43;
1100 ddp_act_attachment_rec.attribute12 := p0_a44;
1101 ddp_act_attachment_rec.attribute13 := p0_a45;
1102 ddp_act_attachment_rec.attribute14 := p0_a46;
1103 ddp_act_attachment_rec.attribute15 := p0_a47;
1104 ddp_act_attachment_rec.display_text := p0_a48;
1105 ddp_act_attachment_rec.alternate_text := p0_a49;
1106 ddp_act_attachment_rec.secured_flag := p0_a50;
1107 ddp_act_attachment_rec.attachment_sub_type := p0_a51;
1108
1109
1110 -- here's the delegated call to the old PL/SQL routine
1111 jtf_amv_attachment_pub.complete_act_attachment_rec(ddp_act_attachment_rec,
1112 ddx_complete_rec);
1113
1114 -- copy data back from the local variables to OUT or IN-OUT args, if any
1115
1116 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.attachment_id);
1117 p1_a1 := ddx_complete_rec.last_update_date;
1118 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
1119 p1_a3 := ddx_complete_rec.creation_date;
1120 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
1121 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
1122 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
1123 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.owner_user_id);
1124 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.attachment_used_by_id);
1125 p1_a9 := ddx_complete_rec.attachment_used_by;
1126 p1_a10 := ddx_complete_rec.version;
1127 p1_a11 := ddx_complete_rec.enabled_flag;
1128 p1_a12 := ddx_complete_rec.can_fulfill_electronic_flag;
1129 p1_a13 := rosetta_g_miss_num_map(ddx_complete_rec.file_id);
1130 p1_a14 := ddx_complete_rec.file_name;
1131 p1_a15 := ddx_complete_rec.file_extension;
1132 p1_a16 := rosetta_g_miss_num_map(ddx_complete_rec.document_id);
1133 p1_a17 := ddx_complete_rec.keywords;
1134 p1_a18 := rosetta_g_miss_num_map(ddx_complete_rec.display_width);
1135 p1_a19 := rosetta_g_miss_num_map(ddx_complete_rec.display_height);
1136 p1_a20 := ddx_complete_rec.display_location;
1137 p1_a21 := ddx_complete_rec.link_to;
1138 p1_a22 := ddx_complete_rec.link_url;
1139 p1_a23 := ddx_complete_rec.send_for_preview_flag;
1140 p1_a24 := ddx_complete_rec.attachment_type;
1141 p1_a25 := ddx_complete_rec.language_code;
1142 p1_a26 := rosetta_g_miss_num_map(ddx_complete_rec.application_id);
1143 p1_a27 := ddx_complete_rec.description;
1144 p1_a28 := ddx_complete_rec.default_style_sheet;
1145 p1_a29 := ddx_complete_rec.display_url;
1146 p1_a30 := rosetta_g_miss_num_map(ddx_complete_rec.display_rule_id);
1147 p1_a31 := ddx_complete_rec.display_program;
1148 p1_a32 := ddx_complete_rec.attribute_category;
1149 p1_a33 := ddx_complete_rec.attribute1;
1150 p1_a34 := ddx_complete_rec.attribute2;
1151 p1_a35 := ddx_complete_rec.attribute3;
1152 p1_a36 := ddx_complete_rec.attribute4;
1153 p1_a37 := ddx_complete_rec.attribute5;
1154 p1_a38 := ddx_complete_rec.attribute6;
1155 p1_a39 := ddx_complete_rec.attribute7;
1156 p1_a40 := ddx_complete_rec.attribute8;
1157 p1_a41 := ddx_complete_rec.attribute9;
1158 p1_a42 := ddx_complete_rec.attribute10;
1159 p1_a43 := ddx_complete_rec.attribute11;
1160 p1_a44 := ddx_complete_rec.attribute12;
1161 p1_a45 := ddx_complete_rec.attribute13;
1162 p1_a46 := ddx_complete_rec.attribute14;
1163 p1_a47 := ddx_complete_rec.attribute15;
1164 p1_a48 := ddx_complete_rec.display_text;
1165 p1_a49 := ddx_complete_rec.alternate_text;
1166 p1_a50 := ddx_complete_rec.secured_flag;
1167 p1_a51 := ddx_complete_rec.attachment_sub_type;
1168 end;
1169
1170 end jtf_amv_attachment_pub_w;