[Home] [Help]
PACKAGE BODY: APPS.OKL_SETUPOVDTEMPLATES_PVT_W
Source
1 package body okl_setupovdtemplates_pvt_w as
2 /* $Header: OKLESVTB.pls 115.2 2002/12/24 04:05:26 sgorantl 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 get_rec(x_return_status out nocopy VARCHAR2
23 , x_no_data_found out nocopy number
24 , p3_a0 out nocopy NUMBER
25 , p3_a1 out nocopy NUMBER
26 , p3_a2 out nocopy NUMBER
27 , p3_a3 out nocopy NUMBER
28 , p3_a4 out nocopy NUMBER
29 , p3_a5 out nocopy NUMBER
30 , p3_a6 out nocopy DATE
31 , p3_a7 out nocopy NUMBER
32 , p3_a8 out nocopy DATE
33 , p3_a9 out nocopy NUMBER
34 , p0_a0 NUMBER := 0-1962.0724
35 , p0_a1 NUMBER := 0-1962.0724
36 , p0_a2 NUMBER := 0-1962.0724
37 , p0_a3 NUMBER := 0-1962.0724
38 , p0_a4 NUMBER := 0-1962.0724
39 , p0_a5 NUMBER := 0-1962.0724
40 , p0_a6 DATE := fnd_api.g_miss_date
41 , p0_a7 NUMBER := 0-1962.0724
42 , p0_a8 DATE := fnd_api.g_miss_date
43 , p0_a9 NUMBER := 0-1962.0724
44 )
45
46 as
47 ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
48 ddx_no_data_found boolean;
49 ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
50 ddindx binary_integer; indx binary_integer;
51 begin
52
53 -- copy data to the local IN or IN-OUT args, if any
54 ddp_ovtv_rec.id := rosetta_g_miss_num_map(p0_a0);
55 ddp_ovtv_rec.object_version_number := rosetta_g_miss_num_map(p0_a1);
56 ddp_ovtv_rec.ovd_id := rosetta_g_miss_num_map(p0_a2);
57 ddp_ovtv_rec.rul_id := rosetta_g_miss_num_map(p0_a3);
58 ddp_ovtv_rec.sequence_number := rosetta_g_miss_num_map(p0_a4);
59 ddp_ovtv_rec.created_by := rosetta_g_miss_num_map(p0_a5);
60 ddp_ovtv_rec.creation_date := rosetta_g_miss_date_in_map(p0_a6);
61 ddp_ovtv_rec.last_updated_by := rosetta_g_miss_num_map(p0_a7);
62 ddp_ovtv_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a8);
63 ddp_ovtv_rec.last_update_login := rosetta_g_miss_num_map(p0_a9);
64
65
66
67
68 -- here's the delegated call to the old PL/SQL routine
69 okl_setupovdtemplates_pvt.get_rec(ddp_ovtv_rec,
70 x_return_status,
71 ddx_no_data_found,
72 ddx_ovtv_rec);
73
74 -- copy data back from the local variables to OUT or IN-OUT args, if any
75
76
77 if ddx_no_data_found is null
78 then x_no_data_found := null;
79 elsif ddx_no_data_found
80 then x_no_data_found := 1;
81 else x_no_data_found := 0;
82 end if;
83
84 p3_a0 := rosetta_g_miss_num_map(ddx_ovtv_rec.id);
85 p3_a1 := rosetta_g_miss_num_map(ddx_ovtv_rec.object_version_number);
86 p3_a2 := rosetta_g_miss_num_map(ddx_ovtv_rec.ovd_id);
87 p3_a3 := rosetta_g_miss_num_map(ddx_ovtv_rec.rul_id);
88 p3_a4 := rosetta_g_miss_num_map(ddx_ovtv_rec.sequence_number);
89 p3_a5 := rosetta_g_miss_num_map(ddx_ovtv_rec.created_by);
90 p3_a6 := ddx_ovtv_rec.creation_date;
91 p3_a7 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_updated_by);
92 p3_a8 := ddx_ovtv_rec.last_update_date;
93 p3_a9 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_update_login);
94 end;
95
96 procedure insert_ovdtemplates(p_api_version NUMBER
97 , p_init_msg_list VARCHAR2
98 , x_return_status out nocopy VARCHAR2
99 , x_msg_count out nocopy NUMBER
100 , x_msg_data out nocopy VARCHAR2
101 , p9_a0 out nocopy NUMBER
102 , p9_a1 out nocopy NUMBER
103 , p9_a2 out nocopy NUMBER
104 , p9_a3 out nocopy NUMBER
105 , p9_a4 out nocopy NUMBER
106 , p9_a5 out nocopy NUMBER
107 , p9_a6 out nocopy DATE
108 , p9_a7 out nocopy NUMBER
109 , p9_a8 out nocopy DATE
110 , p9_a9 out nocopy NUMBER
111 , p5_a0 NUMBER := 0-1962.0724
112 , p5_a1 NUMBER := 0-1962.0724
113 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
114 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
115 , p5_a4 DATE := fnd_api.g_miss_date
116 , p5_a5 DATE := fnd_api.g_miss_date
117 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
118 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
119 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
120 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
121 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
122 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
123 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
124 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
125 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
126 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
127 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
128 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
129 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
130 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
131 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
132 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
133 , p5_a22 NUMBER := 0-1962.0724
134 , p5_a23 DATE := fnd_api.g_miss_date
135 , p5_a24 NUMBER := 0-1962.0724
136 , p5_a25 DATE := fnd_api.g_miss_date
137 , p5_a26 NUMBER := 0-1962.0724
138 , p6_a0 NUMBER := 0-1962.0724
139 , p6_a1 NUMBER := 0-1962.0724
140 , p6_a2 NUMBER := 0-1962.0724
141 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
142 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
143 , p6_a5 DATE := fnd_api.g_miss_date
144 , p6_a6 DATE := fnd_api.g_miss_date
145 , p6_a7 NUMBER := 0-1962.0724
146 , p6_a8 DATE := fnd_api.g_miss_date
147 , p6_a9 NUMBER := 0-1962.0724
148 , p6_a10 DATE := fnd_api.g_miss_date
149 , p6_a11 NUMBER := 0-1962.0724
150 , p7_a0 NUMBER := 0-1962.0724
151 , p7_a1 VARCHAR2 := fnd_api.g_miss_char
152 , p7_a2 NUMBER := 0-1962.0724
153 , p7_a3 NUMBER := 0-1962.0724
154 , p7_a4 NUMBER := 0-1962.0724
155 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
156 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
157 , p7_a7 NUMBER := 0-1962.0724
158 , p7_a8 NUMBER := 0-1962.0724
159 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
160 , p7_a10 NUMBER := 0-1962.0724
161 , p7_a11 DATE := fnd_api.g_miss_date
162 , p7_a12 NUMBER := 0-1962.0724
163 , p7_a13 DATE := fnd_api.g_miss_date
164 , p7_a14 NUMBER := 0-1962.0724
165 , p8_a0 NUMBER := 0-1962.0724
166 , p8_a1 NUMBER := 0-1962.0724
167 , p8_a2 NUMBER := 0-1962.0724
168 , p8_a3 NUMBER := 0-1962.0724
169 , p8_a4 NUMBER := 0-1962.0724
170 , p8_a5 NUMBER := 0-1962.0724
171 , p8_a6 DATE := fnd_api.g_miss_date
172 , p8_a7 NUMBER := 0-1962.0724
173 , p8_a8 DATE := fnd_api.g_miss_date
174 , p8_a9 NUMBER := 0-1962.0724
175 )
176
177 as
178 ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
179 ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
180 ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
181 ddp_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
182 ddx_ovtv_rec okl_setupovdtemplates_pvt.ovtv_rec_type;
183 ddindx binary_integer; indx binary_integer;
184 begin
185
186 -- copy data to the local IN or IN-OUT args, if any
187
188
189
190
191
192 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
193 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
194 ddp_optv_rec.name := p5_a2;
195 ddp_optv_rec.description := p5_a3;
196 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
197 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
198 ddp_optv_rec.attribute_category := p5_a6;
199 ddp_optv_rec.attribute1 := p5_a7;
200 ddp_optv_rec.attribute2 := p5_a8;
201 ddp_optv_rec.attribute3 := p5_a9;
202 ddp_optv_rec.attribute4 := p5_a10;
203 ddp_optv_rec.attribute5 := p5_a11;
204 ddp_optv_rec.attribute6 := p5_a12;
205 ddp_optv_rec.attribute7 := p5_a13;
206 ddp_optv_rec.attribute8 := p5_a14;
207 ddp_optv_rec.attribute9 := p5_a15;
208 ddp_optv_rec.attribute10 := p5_a16;
209 ddp_optv_rec.attribute11 := p5_a17;
210 ddp_optv_rec.attribute12 := p5_a18;
211 ddp_optv_rec.attribute13 := p5_a19;
212 ddp_optv_rec.attribute14 := p5_a20;
213 ddp_optv_rec.attribute15 := p5_a21;
214 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
215 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
216 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
217 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
218 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
219
220 ddp_ovev_rec.id := rosetta_g_miss_num_map(p6_a0);
221 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p6_a1);
222 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p6_a2);
223 ddp_ovev_rec.value := p6_a3;
224 ddp_ovev_rec.description := p6_a4;
225 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p6_a5);
226 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p6_a6);
227 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p6_a7);
228 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p6_a8);
229 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a9);
230 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a10);
231 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
232
233 ddp_ovdv_rec.id := rosetta_g_miss_num_map(p7_a0);
234 ddp_ovdv_rec.context_intent := p7_a1;
235 ddp_ovdv_rec.object_version_number := rosetta_g_miss_num_map(p7_a2);
236 ddp_ovdv_rec.orl_id := rosetta_g_miss_num_map(p7_a3);
237 ddp_ovdv_rec.ove_id := rosetta_g_miss_num_map(p7_a4);
238 ddp_ovdv_rec.individual_instructions := p7_a5;
239 ddp_ovdv_rec.copy_or_enter_flag := p7_a6;
240 ddp_ovdv_rec.context_org := rosetta_g_miss_num_map(p7_a7);
241 ddp_ovdv_rec.context_inv_org := rosetta_g_miss_num_map(p7_a8);
242 ddp_ovdv_rec.context_asset_book := p7_a9;
243 ddp_ovdv_rec.created_by := rosetta_g_miss_num_map(p7_a10);
244 ddp_ovdv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a11);
245 ddp_ovdv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a12);
246 ddp_ovdv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a13);
247 ddp_ovdv_rec.last_update_login := rosetta_g_miss_num_map(p7_a14);
248
249 ddp_ovtv_rec.id := rosetta_g_miss_num_map(p8_a0);
250 ddp_ovtv_rec.object_version_number := rosetta_g_miss_num_map(p8_a1);
251 ddp_ovtv_rec.ovd_id := rosetta_g_miss_num_map(p8_a2);
252 ddp_ovtv_rec.rul_id := rosetta_g_miss_num_map(p8_a3);
253 ddp_ovtv_rec.sequence_number := rosetta_g_miss_num_map(p8_a4);
254 ddp_ovtv_rec.created_by := rosetta_g_miss_num_map(p8_a5);
255 ddp_ovtv_rec.creation_date := rosetta_g_miss_date_in_map(p8_a6);
256 ddp_ovtv_rec.last_updated_by := rosetta_g_miss_num_map(p8_a7);
257 ddp_ovtv_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a8);
258 ddp_ovtv_rec.last_update_login := rosetta_g_miss_num_map(p8_a9);
259
260
261 -- here's the delegated call to the old PL/SQL routine
262 okl_setupovdtemplates_pvt.insert_ovdtemplates(p_api_version,
263 p_init_msg_list,
264 x_return_status,
265 x_msg_count,
266 x_msg_data,
267 ddp_optv_rec,
268 ddp_ovev_rec,
269 ddp_ovdv_rec,
270 ddp_ovtv_rec,
271 ddx_ovtv_rec);
272
273 -- copy data back from the local variables to OUT or IN-OUT args, if any
274
275
276
277
278
279
280
281
282
283 p9_a0 := rosetta_g_miss_num_map(ddx_ovtv_rec.id);
284 p9_a1 := rosetta_g_miss_num_map(ddx_ovtv_rec.object_version_number);
285 p9_a2 := rosetta_g_miss_num_map(ddx_ovtv_rec.ovd_id);
286 p9_a3 := rosetta_g_miss_num_map(ddx_ovtv_rec.rul_id);
287 p9_a4 := rosetta_g_miss_num_map(ddx_ovtv_rec.sequence_number);
288 p9_a5 := rosetta_g_miss_num_map(ddx_ovtv_rec.created_by);
289 p9_a6 := ddx_ovtv_rec.creation_date;
290 p9_a7 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_updated_by);
291 p9_a8 := ddx_ovtv_rec.last_update_date;
292 p9_a9 := rosetta_g_miss_num_map(ddx_ovtv_rec.last_update_login);
293 end;
294
295 procedure delete_ovdtemplates(p_api_version NUMBER
296 , p_init_msg_list VARCHAR2
297 , x_return_status out nocopy VARCHAR2
298 , x_msg_count out nocopy NUMBER
299 , x_msg_data out nocopy VARCHAR2
300 , p8_a0 JTF_NUMBER_TABLE
301 , p8_a1 JTF_NUMBER_TABLE
302 , p8_a2 JTF_NUMBER_TABLE
303 , p8_a3 JTF_NUMBER_TABLE
304 , p8_a4 JTF_NUMBER_TABLE
305 , p8_a5 JTF_NUMBER_TABLE
306 , p8_a6 JTF_DATE_TABLE
307 , p8_a7 JTF_NUMBER_TABLE
308 , p8_a8 JTF_DATE_TABLE
309 , p8_a9 JTF_NUMBER_TABLE
310 , p5_a0 NUMBER := 0-1962.0724
311 , p5_a1 NUMBER := 0-1962.0724
312 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
313 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
314 , p5_a4 DATE := fnd_api.g_miss_date
315 , p5_a5 DATE := fnd_api.g_miss_date
316 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
317 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
318 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
319 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
320 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
321 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
322 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
323 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
324 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
325 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
326 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
327 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
328 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
329 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
330 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
331 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a22 NUMBER := 0-1962.0724
333 , p5_a23 DATE := fnd_api.g_miss_date
334 , p5_a24 NUMBER := 0-1962.0724
335 , p5_a25 DATE := fnd_api.g_miss_date
336 , p5_a26 NUMBER := 0-1962.0724
337 , p6_a0 NUMBER := 0-1962.0724
338 , p6_a1 NUMBER := 0-1962.0724
339 , p6_a2 NUMBER := 0-1962.0724
340 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
341 , p6_a4 VARCHAR2 := fnd_api.g_miss_char
342 , p6_a5 DATE := fnd_api.g_miss_date
343 , p6_a6 DATE := fnd_api.g_miss_date
344 , p6_a7 NUMBER := 0-1962.0724
345 , p6_a8 DATE := fnd_api.g_miss_date
346 , p6_a9 NUMBER := 0-1962.0724
347 , p6_a10 DATE := fnd_api.g_miss_date
348 , p6_a11 NUMBER := 0-1962.0724
349 , p7_a0 NUMBER := 0-1962.0724
350 , p7_a1 VARCHAR2 := fnd_api.g_miss_char
351 , p7_a2 NUMBER := 0-1962.0724
352 , p7_a3 NUMBER := 0-1962.0724
353 , p7_a4 NUMBER := 0-1962.0724
354 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
355 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
356 , p7_a7 NUMBER := 0-1962.0724
357 , p7_a8 NUMBER := 0-1962.0724
358 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
359 , p7_a10 NUMBER := 0-1962.0724
360 , p7_a11 DATE := fnd_api.g_miss_date
361 , p7_a12 NUMBER := 0-1962.0724
362 , p7_a13 DATE := fnd_api.g_miss_date
363 , p7_a14 NUMBER := 0-1962.0724
364 )
365
366 as
367 ddp_optv_rec okl_setupovdtemplates_pvt.optv_rec_type;
368 ddp_ovev_rec okl_setupovdtemplates_pvt.ovev_rec_type;
369 ddp_ovdv_rec okl_setupovdtemplates_pvt.ovdv_rec_type;
370 ddp_ovtv_tbl okl_setupovdtemplates_pvt.ovtv_tbl_type;
371 ddindx binary_integer; indx binary_integer;
372 begin
373
374 -- copy data to the local IN or IN-OUT args, if any
375
376
377
378
379
380 ddp_optv_rec.id := rosetta_g_miss_num_map(p5_a0);
381 ddp_optv_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
382 ddp_optv_rec.name := p5_a2;
383 ddp_optv_rec.description := p5_a3;
384 ddp_optv_rec.from_date := rosetta_g_miss_date_in_map(p5_a4);
385 ddp_optv_rec.to_date := rosetta_g_miss_date_in_map(p5_a5);
386 ddp_optv_rec.attribute_category := p5_a6;
387 ddp_optv_rec.attribute1 := p5_a7;
388 ddp_optv_rec.attribute2 := p5_a8;
389 ddp_optv_rec.attribute3 := p5_a9;
390 ddp_optv_rec.attribute4 := p5_a10;
391 ddp_optv_rec.attribute5 := p5_a11;
392 ddp_optv_rec.attribute6 := p5_a12;
393 ddp_optv_rec.attribute7 := p5_a13;
394 ddp_optv_rec.attribute8 := p5_a14;
395 ddp_optv_rec.attribute9 := p5_a15;
396 ddp_optv_rec.attribute10 := p5_a16;
397 ddp_optv_rec.attribute11 := p5_a17;
398 ddp_optv_rec.attribute12 := p5_a18;
399 ddp_optv_rec.attribute13 := p5_a19;
400 ddp_optv_rec.attribute14 := p5_a20;
401 ddp_optv_rec.attribute15 := p5_a21;
402 ddp_optv_rec.created_by := rosetta_g_miss_num_map(p5_a22);
403 ddp_optv_rec.creation_date := rosetta_g_miss_date_in_map(p5_a23);
404 ddp_optv_rec.last_updated_by := rosetta_g_miss_num_map(p5_a24);
405 ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
406 ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
407
408 ddp_ovev_rec.id := rosetta_g_miss_num_map(p6_a0);
409 ddp_ovev_rec.object_version_number := rosetta_g_miss_num_map(p6_a1);
410 ddp_ovev_rec.opt_id := rosetta_g_miss_num_map(p6_a2);
411 ddp_ovev_rec.value := p6_a3;
412 ddp_ovev_rec.description := p6_a4;
413 ddp_ovev_rec.from_date := rosetta_g_miss_date_in_map(p6_a5);
414 ddp_ovev_rec.to_date := rosetta_g_miss_date_in_map(p6_a6);
415 ddp_ovev_rec.created_by := rosetta_g_miss_num_map(p6_a7);
416 ddp_ovev_rec.creation_date := rosetta_g_miss_date_in_map(p6_a8);
417 ddp_ovev_rec.last_updated_by := rosetta_g_miss_num_map(p6_a9);
418 ddp_ovev_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a10);
419 ddp_ovev_rec.last_update_login := rosetta_g_miss_num_map(p6_a11);
420
421 ddp_ovdv_rec.id := rosetta_g_miss_num_map(p7_a0);
422 ddp_ovdv_rec.context_intent := p7_a1;
423 ddp_ovdv_rec.object_version_number := rosetta_g_miss_num_map(p7_a2);
424 ddp_ovdv_rec.orl_id := rosetta_g_miss_num_map(p7_a3);
425 ddp_ovdv_rec.ove_id := rosetta_g_miss_num_map(p7_a4);
426 ddp_ovdv_rec.individual_instructions := p7_a5;
427 ddp_ovdv_rec.copy_or_enter_flag := p7_a6;
428 ddp_ovdv_rec.context_org := rosetta_g_miss_num_map(p7_a7);
429 ddp_ovdv_rec.context_inv_org := rosetta_g_miss_num_map(p7_a8);
430 ddp_ovdv_rec.context_asset_book := p7_a9;
431 ddp_ovdv_rec.created_by := rosetta_g_miss_num_map(p7_a10);
432 ddp_ovdv_rec.creation_date := rosetta_g_miss_date_in_map(p7_a11);
433 ddp_ovdv_rec.last_updated_by := rosetta_g_miss_num_map(p7_a12);
434 ddp_ovdv_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a13);
435 ddp_ovdv_rec.last_update_login := rosetta_g_miss_num_map(p7_a14);
436
437 okl_ovt_pvt_w.rosetta_table_copy_in_p5(ddp_ovtv_tbl, p8_a0
438 , p8_a1
439 , p8_a2
440 , p8_a3
441 , p8_a4
442 , p8_a5
443 , p8_a6
444 , p8_a7
445 , p8_a8
446 , p8_a9
447 );
448
449 -- here's the delegated call to the old PL/SQL routine
450 okl_setupovdtemplates_pvt.delete_ovdtemplates(p_api_version,
451 p_init_msg_list,
452 x_return_status,
453 x_msg_count,
454 x_msg_data,
455 ddp_optv_rec,
456 ddp_ovev_rec,
457 ddp_ovdv_rec,
458 ddp_ovtv_tbl);
459
460 -- copy data back from the local variables to OUT or IN-OUT args, if any
461
462
463
464
465
466
467
468
469 end;
470
471 end okl_setupovdtemplates_pvt_w;