[Home] [Help]
PACKAGE BODY: APPS.PV_GE_NOTIF_RULES_PVT_W
Source
1 package body pv_ge_notif_rules_pvt_w as
2 /* $Header: pvxwgnrb.pls 115.2 2002/11/21 08:55:26 anubhavk ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure rosetta_table_copy_in_p2(t out nocopy pv_ge_notif_rules_pvt.ge_notif_rules_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_NUMBER_TABLE
24 , a2 JTF_VARCHAR2_TABLE_100
25 , a3 JTF_NUMBER_TABLE
26 , a4 JTF_VARCHAR2_TABLE_100
27 , a5 JTF_VARCHAR2_TABLE_100
28 , a6 JTF_VARCHAR2_TABLE_100
29 , a7 JTF_VARCHAR2_TABLE_100
30 , a8 JTF_NUMBER_TABLE
31 , a9 JTF_VARCHAR2_TABLE_100
32 , a10 JTF_NUMBER_TABLE
33 , a11 JTF_VARCHAR2_TABLE_100
34 , a12 JTF_NUMBER_TABLE
35 , a13 JTF_VARCHAR2_TABLE_100
36 , a14 JTF_NUMBER_TABLE
37 , a15 JTF_NUMBER_TABLE
38 , a16 JTF_DATE_TABLE
39 , a17 JTF_NUMBER_TABLE
40 , a18 JTF_DATE_TABLE
41 , a19 JTF_NUMBER_TABLE
42 , a20 JTF_VARCHAR2_TABLE_4000
43 , a21 JTF_VARCHAR2_TABLE_4000
44 , a22 JTF_VARCHAR2_TABLE_4000
45 ) as
46 ddindx binary_integer; indx binary_integer;
47 begin
48 if a0 is not null and a0.count > 0 then
49 if a0.count > 0 then
50 indx := a0.first;
51 ddindx := 1;
52 while true loop
53 t(ddindx).notif_rule_id := rosetta_g_miss_num_map(a0(indx));
54 t(ddindx).object_version_number := rosetta_g_miss_num_map(a1(indx));
55 t(ddindx).arc_notif_for_entity_code := a2(indx);
56 t(ddindx).notif_for_entity_id := rosetta_g_miss_num_map(a3(indx));
57 t(ddindx).wf_item_type_code := a4(indx);
58 t(ddindx).notif_type_code := a5(indx);
59 t(ddindx).active_flag := a6(indx);
60 t(ddindx).repeat_freq_unit := a7(indx);
61 t(ddindx).repeat_freq_value := rosetta_g_miss_num_map(a8(indx));
62 t(ddindx).send_notif_before_unit := a9(indx);
63 t(ddindx).send_notif_before_value := rosetta_g_miss_num_map(a10(indx));
64 t(ddindx).send_notif_after_unit := a11(indx);
65 t(ddindx).send_notif_after_value := rosetta_g_miss_num_map(a12(indx));
66 t(ddindx).repeat_until_unit := a13(indx);
67 t(ddindx).repeat_until_value := rosetta_g_miss_num_map(a14(indx));
68 t(ddindx).created_by := rosetta_g_miss_num_map(a15(indx));
69 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a16(indx));
70 t(ddindx).last_updated_by := rosetta_g_miss_num_map(a17(indx));
71 t(ddindx).last_update_date := rosetta_g_miss_date_in_map(a18(indx));
72 t(ddindx).last_update_login := rosetta_g_miss_num_map(a19(indx));
73 t(ddindx).notif_name := a20(indx);
74 t(ddindx).notif_content := a21(indx);
75 t(ddindx).notif_desc := a22(indx);
76 ddindx := ddindx+1;
77 if a0.last =indx
78 then exit;
79 end if;
80 indx := a0.next(indx);
81 end loop;
82 end if;
83 end if;
84 end rosetta_table_copy_in_p2;
85 procedure rosetta_table_copy_out_p2(t pv_ge_notif_rules_pvt.ge_notif_rules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86 , a1 out nocopy JTF_NUMBER_TABLE
87 , a2 out nocopy JTF_VARCHAR2_TABLE_100
88 , a3 out nocopy JTF_NUMBER_TABLE
89 , a4 out nocopy JTF_VARCHAR2_TABLE_100
90 , a5 out nocopy JTF_VARCHAR2_TABLE_100
91 , a6 out nocopy JTF_VARCHAR2_TABLE_100
92 , a7 out nocopy JTF_VARCHAR2_TABLE_100
93 , a8 out nocopy JTF_NUMBER_TABLE
94 , a9 out nocopy JTF_VARCHAR2_TABLE_100
95 , a10 out nocopy JTF_NUMBER_TABLE
96 , a11 out nocopy JTF_VARCHAR2_TABLE_100
97 , a12 out nocopy JTF_NUMBER_TABLE
98 , a13 out nocopy JTF_VARCHAR2_TABLE_100
99 , a14 out nocopy JTF_NUMBER_TABLE
100 , a15 out nocopy JTF_NUMBER_TABLE
101 , a16 out nocopy JTF_DATE_TABLE
102 , a17 out nocopy JTF_NUMBER_TABLE
103 , a18 out nocopy JTF_DATE_TABLE
104 , a19 out nocopy JTF_NUMBER_TABLE
105 , a20 out nocopy JTF_VARCHAR2_TABLE_4000
106 , a21 out nocopy JTF_VARCHAR2_TABLE_4000
107 , a22 out nocopy JTF_VARCHAR2_TABLE_4000
108 ) as
109 ddindx binary_integer; indx binary_integer;
110 begin
111 if t is null or t.count = 0 then
112 a0 := JTF_NUMBER_TABLE();
113 a1 := JTF_NUMBER_TABLE();
114 a2 := JTF_VARCHAR2_TABLE_100();
115 a3 := JTF_NUMBER_TABLE();
116 a4 := JTF_VARCHAR2_TABLE_100();
117 a5 := JTF_VARCHAR2_TABLE_100();
118 a6 := JTF_VARCHAR2_TABLE_100();
119 a7 := JTF_VARCHAR2_TABLE_100();
120 a8 := JTF_NUMBER_TABLE();
121 a9 := JTF_VARCHAR2_TABLE_100();
122 a10 := JTF_NUMBER_TABLE();
123 a11 := JTF_VARCHAR2_TABLE_100();
124 a12 := JTF_NUMBER_TABLE();
125 a13 := JTF_VARCHAR2_TABLE_100();
126 a14 := JTF_NUMBER_TABLE();
127 a15 := JTF_NUMBER_TABLE();
128 a16 := JTF_DATE_TABLE();
129 a17 := JTF_NUMBER_TABLE();
130 a18 := JTF_DATE_TABLE();
131 a19 := JTF_NUMBER_TABLE();
132 a20 := JTF_VARCHAR2_TABLE_4000();
133 a21 := JTF_VARCHAR2_TABLE_4000();
134 a22 := JTF_VARCHAR2_TABLE_4000();
135 else
136 a0 := JTF_NUMBER_TABLE();
137 a1 := JTF_NUMBER_TABLE();
138 a2 := JTF_VARCHAR2_TABLE_100();
139 a3 := JTF_NUMBER_TABLE();
140 a4 := JTF_VARCHAR2_TABLE_100();
141 a5 := JTF_VARCHAR2_TABLE_100();
142 a6 := JTF_VARCHAR2_TABLE_100();
143 a7 := JTF_VARCHAR2_TABLE_100();
144 a8 := JTF_NUMBER_TABLE();
145 a9 := JTF_VARCHAR2_TABLE_100();
146 a10 := JTF_NUMBER_TABLE();
147 a11 := JTF_VARCHAR2_TABLE_100();
148 a12 := JTF_NUMBER_TABLE();
149 a13 := JTF_VARCHAR2_TABLE_100();
150 a14 := JTF_NUMBER_TABLE();
151 a15 := JTF_NUMBER_TABLE();
152 a16 := JTF_DATE_TABLE();
153 a17 := JTF_NUMBER_TABLE();
154 a18 := JTF_DATE_TABLE();
155 a19 := JTF_NUMBER_TABLE();
156 a20 := JTF_VARCHAR2_TABLE_4000();
157 a21 := JTF_VARCHAR2_TABLE_4000();
158 a22 := JTF_VARCHAR2_TABLE_4000();
159 if t.count > 0 then
160 a0.extend(t.count);
161 a1.extend(t.count);
162 a2.extend(t.count);
163 a3.extend(t.count);
164 a4.extend(t.count);
165 a5.extend(t.count);
166 a6.extend(t.count);
167 a7.extend(t.count);
168 a8.extend(t.count);
169 a9.extend(t.count);
170 a10.extend(t.count);
171 a11.extend(t.count);
172 a12.extend(t.count);
173 a13.extend(t.count);
174 a14.extend(t.count);
175 a15.extend(t.count);
176 a16.extend(t.count);
177 a17.extend(t.count);
178 a18.extend(t.count);
179 a19.extend(t.count);
180 a20.extend(t.count);
181 a21.extend(t.count);
182 a22.extend(t.count);
183 ddindx := t.first;
184 indx := 1;
185 while true loop
186 a0(indx) := rosetta_g_miss_num_map(t(ddindx).notif_rule_id);
187 a1(indx) := rosetta_g_miss_num_map(t(ddindx).object_version_number);
188 a2(indx) := t(ddindx).arc_notif_for_entity_code;
189 a3(indx) := rosetta_g_miss_num_map(t(ddindx).notif_for_entity_id);
190 a4(indx) := t(ddindx).wf_item_type_code;
191 a5(indx) := t(ddindx).notif_type_code;
192 a6(indx) := t(ddindx).active_flag;
193 a7(indx) := t(ddindx).repeat_freq_unit;
194 a8(indx) := rosetta_g_miss_num_map(t(ddindx).repeat_freq_value);
195 a9(indx) := t(ddindx).send_notif_before_unit;
196 a10(indx) := rosetta_g_miss_num_map(t(ddindx).send_notif_before_value);
197 a11(indx) := t(ddindx).send_notif_after_unit;
198 a12(indx) := rosetta_g_miss_num_map(t(ddindx).send_notif_after_value);
199 a13(indx) := t(ddindx).repeat_until_unit;
200 a14(indx) := rosetta_g_miss_num_map(t(ddindx).repeat_until_value);
201 a15(indx) := rosetta_g_miss_num_map(t(ddindx).created_by);
202 a16(indx) := t(ddindx).creation_date;
203 a17(indx) := rosetta_g_miss_num_map(t(ddindx).last_updated_by);
204 a18(indx) := t(ddindx).last_update_date;
205 a19(indx) := rosetta_g_miss_num_map(t(ddindx).last_update_login);
206 a20(indx) := t(ddindx).notif_name;
207 a21(indx) := t(ddindx).notif_content;
208 a22(indx) := t(ddindx).notif_desc;
209 indx := indx+1;
210 if t.last =ddindx
211 then exit;
212 end if;
213 ddindx := t.next(ddindx);
214 end loop;
215 end if;
216 end if;
217 end rosetta_table_copy_out_p2;
218
219 procedure create_ge_notif_rules(p_api_version_number NUMBER
220 , p_init_msg_list VARCHAR2
221 , p_commit VARCHAR2
222 , p_validation_level NUMBER
223 , x_return_status out nocopy VARCHAR2
224 , x_msg_count out nocopy NUMBER
225 , x_msg_data out nocopy VARCHAR2
226 , x_notif_rule_id out nocopy NUMBER
227 , p7_a0 NUMBER := 0-1962.0724
228 , p7_a1 NUMBER := 0-1962.0724
229 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
230 , p7_a3 NUMBER := 0-1962.0724
231 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
232 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
234 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235 , p7_a8 NUMBER := 0-1962.0724
236 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237 , p7_a10 NUMBER := 0-1962.0724
238 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239 , p7_a12 NUMBER := 0-1962.0724
240 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241 , p7_a14 NUMBER := 0-1962.0724
242 , p7_a15 NUMBER := 0-1962.0724
243 , p7_a16 DATE := fnd_api.g_miss_date
244 , p7_a17 NUMBER := 0-1962.0724
245 , p7_a18 DATE := fnd_api.g_miss_date
246 , p7_a19 NUMBER := 0-1962.0724
247 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
249 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250 )
251
252 as
253 ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;
254 ddindx binary_integer; indx binary_integer;
255 begin
256
257 -- copy data to the local IN or IN-OUT args, if any
258
259
260
261
262
263
264
265 ddp_ge_notif_rules_rec.notif_rule_id := rosetta_g_miss_num_map(p7_a0);
266 ddp_ge_notif_rules_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
267 ddp_ge_notif_rules_rec.arc_notif_for_entity_code := p7_a2;
268 ddp_ge_notif_rules_rec.notif_for_entity_id := rosetta_g_miss_num_map(p7_a3);
269 ddp_ge_notif_rules_rec.wf_item_type_code := p7_a4;
270 ddp_ge_notif_rules_rec.notif_type_code := p7_a5;
271 ddp_ge_notif_rules_rec.active_flag := p7_a6;
272 ddp_ge_notif_rules_rec.repeat_freq_unit := p7_a7;
273 ddp_ge_notif_rules_rec.repeat_freq_value := rosetta_g_miss_num_map(p7_a8);
274 ddp_ge_notif_rules_rec.send_notif_before_unit := p7_a9;
275 ddp_ge_notif_rules_rec.send_notif_before_value := rosetta_g_miss_num_map(p7_a10);
276 ddp_ge_notif_rules_rec.send_notif_after_unit := p7_a11;
277 ddp_ge_notif_rules_rec.send_notif_after_value := rosetta_g_miss_num_map(p7_a12);
278 ddp_ge_notif_rules_rec.repeat_until_unit := p7_a13;
279 ddp_ge_notif_rules_rec.repeat_until_value := rosetta_g_miss_num_map(p7_a14);
280 ddp_ge_notif_rules_rec.created_by := rosetta_g_miss_num_map(p7_a15);
281 ddp_ge_notif_rules_rec.creation_date := rosetta_g_miss_date_in_map(p7_a16);
282 ddp_ge_notif_rules_rec.last_updated_by := rosetta_g_miss_num_map(p7_a17);
283 ddp_ge_notif_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a18);
284 ddp_ge_notif_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a19);
285 ddp_ge_notif_rules_rec.notif_name := p7_a20;
286 ddp_ge_notif_rules_rec.notif_content := p7_a21;
287 ddp_ge_notif_rules_rec.notif_desc := p7_a22;
288
289
290 -- here's the delegated call to the old PL/SQL routine
291 pv_ge_notif_rules_pvt.create_ge_notif_rules(p_api_version_number,
292 p_init_msg_list,
293 p_commit,
294 p_validation_level,
295 x_return_status,
296 x_msg_count,
297 x_msg_data,
298 ddp_ge_notif_rules_rec,
299 x_notif_rule_id);
300
301 -- copy data back from the local variables to OUT or IN-OUT args, if any
302
303
304
305
306
307
308
309
310 end;
311
312 procedure update_ge_notif_rules(p_api_version_number NUMBER
313 , p_init_msg_list VARCHAR2
314 , p_commit VARCHAR2
315 , p_validation_level NUMBER
316 , x_return_status out nocopy VARCHAR2
317 , x_msg_count out nocopy NUMBER
318 , x_msg_data out nocopy VARCHAR2
319 , p7_a0 NUMBER := 0-1962.0724
320 , p7_a1 NUMBER := 0-1962.0724
321 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
322 , p7_a3 NUMBER := 0-1962.0724
323 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
324 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
326 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327 , p7_a8 NUMBER := 0-1962.0724
328 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
329 , p7_a10 NUMBER := 0-1962.0724
330 , p7_a11 VARCHAR2 := fnd_api.g_miss_char
331 , p7_a12 NUMBER := 0-1962.0724
332 , p7_a13 VARCHAR2 := fnd_api.g_miss_char
333 , p7_a14 NUMBER := 0-1962.0724
334 , p7_a15 NUMBER := 0-1962.0724
335 , p7_a16 DATE := fnd_api.g_miss_date
336 , p7_a17 NUMBER := 0-1962.0724
337 , p7_a18 DATE := fnd_api.g_miss_date
338 , p7_a19 NUMBER := 0-1962.0724
339 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
340 , p7_a21 VARCHAR2 := fnd_api.g_miss_char
341 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
342 )
343
344 as
345 ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;
346 ddindx binary_integer; indx binary_integer;
347 begin
348
349 -- copy data to the local IN or IN-OUT args, if any
350
351
352
353
354
355
356
357 ddp_ge_notif_rules_rec.notif_rule_id := rosetta_g_miss_num_map(p7_a0);
358 ddp_ge_notif_rules_rec.object_version_number := rosetta_g_miss_num_map(p7_a1);
359 ddp_ge_notif_rules_rec.arc_notif_for_entity_code := p7_a2;
360 ddp_ge_notif_rules_rec.notif_for_entity_id := rosetta_g_miss_num_map(p7_a3);
361 ddp_ge_notif_rules_rec.wf_item_type_code := p7_a4;
362 ddp_ge_notif_rules_rec.notif_type_code := p7_a5;
363 ddp_ge_notif_rules_rec.active_flag := p7_a6;
364 ddp_ge_notif_rules_rec.repeat_freq_unit := p7_a7;
365 ddp_ge_notif_rules_rec.repeat_freq_value := rosetta_g_miss_num_map(p7_a8);
366 ddp_ge_notif_rules_rec.send_notif_before_unit := p7_a9;
367 ddp_ge_notif_rules_rec.send_notif_before_value := rosetta_g_miss_num_map(p7_a10);
368 ddp_ge_notif_rules_rec.send_notif_after_unit := p7_a11;
369 ddp_ge_notif_rules_rec.send_notif_after_value := rosetta_g_miss_num_map(p7_a12);
370 ddp_ge_notif_rules_rec.repeat_until_unit := p7_a13;
371 ddp_ge_notif_rules_rec.repeat_until_value := rosetta_g_miss_num_map(p7_a14);
372 ddp_ge_notif_rules_rec.created_by := rosetta_g_miss_num_map(p7_a15);
373 ddp_ge_notif_rules_rec.creation_date := rosetta_g_miss_date_in_map(p7_a16);
374 ddp_ge_notif_rules_rec.last_updated_by := rosetta_g_miss_num_map(p7_a17);
375 ddp_ge_notif_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a18);
376 ddp_ge_notif_rules_rec.last_update_login := rosetta_g_miss_num_map(p7_a19);
377 ddp_ge_notif_rules_rec.notif_name := p7_a20;
378 ddp_ge_notif_rules_rec.notif_content := p7_a21;
379 ddp_ge_notif_rules_rec.notif_desc := p7_a22;
380
381 -- here's the delegated call to the old PL/SQL routine
382 pv_ge_notif_rules_pvt.update_ge_notif_rules(p_api_version_number,
383 p_init_msg_list,
384 p_commit,
385 p_validation_level,
386 x_return_status,
387 x_msg_count,
388 x_msg_data,
389 ddp_ge_notif_rules_rec);
390
391 -- copy data back from the local variables to OUT or IN-OUT args, if any
392
393
394
395
396
397
398
399 end;
400
401 procedure validate_ge_notif_rules(p_api_version_number NUMBER
402 , p_init_msg_list VARCHAR2
403 , p_validation_level NUMBER
404 , p_validation_mode VARCHAR2
405 , x_return_status out nocopy VARCHAR2
406 , x_msg_count out nocopy NUMBER
407 , x_msg_data out nocopy VARCHAR2
408 , p3_a0 NUMBER := 0-1962.0724
409 , p3_a1 NUMBER := 0-1962.0724
410 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
411 , p3_a3 NUMBER := 0-1962.0724
412 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
413 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
415 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416 , p3_a8 NUMBER := 0-1962.0724
417 , p3_a9 VARCHAR2 := fnd_api.g_miss_char
418 , p3_a10 NUMBER := 0-1962.0724
419 , p3_a11 VARCHAR2 := fnd_api.g_miss_char
420 , p3_a12 NUMBER := 0-1962.0724
421 , p3_a13 VARCHAR2 := fnd_api.g_miss_char
422 , p3_a14 NUMBER := 0-1962.0724
423 , p3_a15 NUMBER := 0-1962.0724
424 , p3_a16 DATE := fnd_api.g_miss_date
425 , p3_a17 NUMBER := 0-1962.0724
426 , p3_a18 DATE := fnd_api.g_miss_date
427 , p3_a19 NUMBER := 0-1962.0724
428 , p3_a20 VARCHAR2 := fnd_api.g_miss_char
429 , p3_a21 VARCHAR2 := fnd_api.g_miss_char
430 , p3_a22 VARCHAR2 := fnd_api.g_miss_char
431 )
432
433 as
434 ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;
435 ddindx binary_integer; indx binary_integer;
436 begin
437
438 -- copy data to the local IN or IN-OUT args, if any
439
440
441
442 ddp_ge_notif_rules_rec.notif_rule_id := rosetta_g_miss_num_map(p3_a0);
443 ddp_ge_notif_rules_rec.object_version_number := rosetta_g_miss_num_map(p3_a1);
444 ddp_ge_notif_rules_rec.arc_notif_for_entity_code := p3_a2;
445 ddp_ge_notif_rules_rec.notif_for_entity_id := rosetta_g_miss_num_map(p3_a3);
446 ddp_ge_notif_rules_rec.wf_item_type_code := p3_a4;
447 ddp_ge_notif_rules_rec.notif_type_code := p3_a5;
448 ddp_ge_notif_rules_rec.active_flag := p3_a6;
449 ddp_ge_notif_rules_rec.repeat_freq_unit := p3_a7;
450 ddp_ge_notif_rules_rec.repeat_freq_value := rosetta_g_miss_num_map(p3_a8);
451 ddp_ge_notif_rules_rec.send_notif_before_unit := p3_a9;
452 ddp_ge_notif_rules_rec.send_notif_before_value := rosetta_g_miss_num_map(p3_a10);
453 ddp_ge_notif_rules_rec.send_notif_after_unit := p3_a11;
454 ddp_ge_notif_rules_rec.send_notif_after_value := rosetta_g_miss_num_map(p3_a12);
455 ddp_ge_notif_rules_rec.repeat_until_unit := p3_a13;
456 ddp_ge_notif_rules_rec.repeat_until_value := rosetta_g_miss_num_map(p3_a14);
457 ddp_ge_notif_rules_rec.created_by := rosetta_g_miss_num_map(p3_a15);
458 ddp_ge_notif_rules_rec.creation_date := rosetta_g_miss_date_in_map(p3_a16);
459 ddp_ge_notif_rules_rec.last_updated_by := rosetta_g_miss_num_map(p3_a17);
460 ddp_ge_notif_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p3_a18);
461 ddp_ge_notif_rules_rec.last_update_login := rosetta_g_miss_num_map(p3_a19);
462 ddp_ge_notif_rules_rec.notif_name := p3_a20;
463 ddp_ge_notif_rules_rec.notif_content := p3_a21;
464 ddp_ge_notif_rules_rec.notif_desc := p3_a22;
465
466
467
468
469
470 -- here's the delegated call to the old PL/SQL routine
471 pv_ge_notif_rules_pvt.validate_ge_notif_rules(p_api_version_number,
472 p_init_msg_list,
473 p_validation_level,
474 ddp_ge_notif_rules_rec,
475 p_validation_mode,
476 x_return_status,
477 x_msg_count,
478 x_msg_data);
479
480 -- copy data back from the local variables to OUT or IN-OUT args, if any
481
482
483
484
485
486
487
488 end;
489
490 procedure check_ge_notif_rules_items(p_validation_mode VARCHAR2
491 , x_return_status out nocopy VARCHAR2
492 , p0_a0 NUMBER := 0-1962.0724
493 , p0_a1 NUMBER := 0-1962.0724
494 , p0_a2 VARCHAR2 := fnd_api.g_miss_char
495 , p0_a3 NUMBER := 0-1962.0724
496 , p0_a4 VARCHAR2 := fnd_api.g_miss_char
497 , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498 , p0_a6 VARCHAR2 := fnd_api.g_miss_char
499 , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500 , p0_a8 NUMBER := 0-1962.0724
501 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
502 , p0_a10 NUMBER := 0-1962.0724
503 , p0_a11 VARCHAR2 := fnd_api.g_miss_char
504 , p0_a12 NUMBER := 0-1962.0724
505 , p0_a13 VARCHAR2 := fnd_api.g_miss_char
506 , p0_a14 NUMBER := 0-1962.0724
507 , p0_a15 NUMBER := 0-1962.0724
508 , p0_a16 DATE := fnd_api.g_miss_date
509 , p0_a17 NUMBER := 0-1962.0724
510 , p0_a18 DATE := fnd_api.g_miss_date
511 , p0_a19 NUMBER := 0-1962.0724
512 , p0_a20 VARCHAR2 := fnd_api.g_miss_char
513 , p0_a21 VARCHAR2 := fnd_api.g_miss_char
514 , p0_a22 VARCHAR2 := fnd_api.g_miss_char
515 )
516
517 as
518 ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;
519 ddindx binary_integer; indx binary_integer;
520 begin
521
522 -- copy data to the local IN or IN-OUT args, if any
523 ddp_ge_notif_rules_rec.notif_rule_id := rosetta_g_miss_num_map(p0_a0);
524 ddp_ge_notif_rules_rec.object_version_number := rosetta_g_miss_num_map(p0_a1);
525 ddp_ge_notif_rules_rec.arc_notif_for_entity_code := p0_a2;
526 ddp_ge_notif_rules_rec.notif_for_entity_id := rosetta_g_miss_num_map(p0_a3);
527 ddp_ge_notif_rules_rec.wf_item_type_code := p0_a4;
528 ddp_ge_notif_rules_rec.notif_type_code := p0_a5;
529 ddp_ge_notif_rules_rec.active_flag := p0_a6;
530 ddp_ge_notif_rules_rec.repeat_freq_unit := p0_a7;
531 ddp_ge_notif_rules_rec.repeat_freq_value := rosetta_g_miss_num_map(p0_a8);
532 ddp_ge_notif_rules_rec.send_notif_before_unit := p0_a9;
533 ddp_ge_notif_rules_rec.send_notif_before_value := rosetta_g_miss_num_map(p0_a10);
534 ddp_ge_notif_rules_rec.send_notif_after_unit := p0_a11;
535 ddp_ge_notif_rules_rec.send_notif_after_value := rosetta_g_miss_num_map(p0_a12);
536 ddp_ge_notif_rules_rec.repeat_until_unit := p0_a13;
537 ddp_ge_notif_rules_rec.repeat_until_value := rosetta_g_miss_num_map(p0_a14);
538 ddp_ge_notif_rules_rec.created_by := rosetta_g_miss_num_map(p0_a15);
539 ddp_ge_notif_rules_rec.creation_date := rosetta_g_miss_date_in_map(p0_a16);
540 ddp_ge_notif_rules_rec.last_updated_by := rosetta_g_miss_num_map(p0_a17);
541 ddp_ge_notif_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a18);
542 ddp_ge_notif_rules_rec.last_update_login := rosetta_g_miss_num_map(p0_a19);
543 ddp_ge_notif_rules_rec.notif_name := p0_a20;
544 ddp_ge_notif_rules_rec.notif_content := p0_a21;
545 ddp_ge_notif_rules_rec.notif_desc := p0_a22;
546
547
548
549 -- here's the delegated call to the old PL/SQL routine
550 pv_ge_notif_rules_pvt.check_ge_notif_rules_items(ddp_ge_notif_rules_rec,
551 p_validation_mode,
552 x_return_status);
553
554 -- copy data back from the local variables to OUT or IN-OUT args, if any
555
556
557 end;
558
559 procedure validate_ge_notif_rules_rec(p_api_version_number NUMBER
560 , p_init_msg_list VARCHAR2
561 , x_return_status out nocopy VARCHAR2
562 , x_msg_count out nocopy NUMBER
563 , x_msg_data out nocopy VARCHAR2
564 , p5_a0 NUMBER := 0-1962.0724
565 , p5_a1 NUMBER := 0-1962.0724
566 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
567 , p5_a3 NUMBER := 0-1962.0724
568 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
571 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572 , p5_a8 NUMBER := 0-1962.0724
573 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
574 , p5_a10 NUMBER := 0-1962.0724
575 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
576 , p5_a12 NUMBER := 0-1962.0724
577 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
578 , p5_a14 NUMBER := 0-1962.0724
579 , p5_a15 NUMBER := 0-1962.0724
580 , p5_a16 DATE := fnd_api.g_miss_date
581 , p5_a17 NUMBER := 0-1962.0724
582 , p5_a18 DATE := fnd_api.g_miss_date
583 , p5_a19 NUMBER := 0-1962.0724
584 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
585 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
586 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
587 )
588
589 as
590 ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;
591 ddindx binary_integer; indx binary_integer;
592 begin
593
594 -- copy data to the local IN or IN-OUT args, if any
595
596
597
598
599
600 ddp_ge_notif_rules_rec.notif_rule_id := rosetta_g_miss_num_map(p5_a0);
601 ddp_ge_notif_rules_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
602 ddp_ge_notif_rules_rec.arc_notif_for_entity_code := p5_a2;
603 ddp_ge_notif_rules_rec.notif_for_entity_id := rosetta_g_miss_num_map(p5_a3);
604 ddp_ge_notif_rules_rec.wf_item_type_code := p5_a4;
605 ddp_ge_notif_rules_rec.notif_type_code := p5_a5;
606 ddp_ge_notif_rules_rec.active_flag := p5_a6;
607 ddp_ge_notif_rules_rec.repeat_freq_unit := p5_a7;
608 ddp_ge_notif_rules_rec.repeat_freq_value := rosetta_g_miss_num_map(p5_a8);
609 ddp_ge_notif_rules_rec.send_notif_before_unit := p5_a9;
610 ddp_ge_notif_rules_rec.send_notif_before_value := rosetta_g_miss_num_map(p5_a10);
611 ddp_ge_notif_rules_rec.send_notif_after_unit := p5_a11;
612 ddp_ge_notif_rules_rec.send_notif_after_value := rosetta_g_miss_num_map(p5_a12);
613 ddp_ge_notif_rules_rec.repeat_until_unit := p5_a13;
614 ddp_ge_notif_rules_rec.repeat_until_value := rosetta_g_miss_num_map(p5_a14);
615 ddp_ge_notif_rules_rec.created_by := rosetta_g_miss_num_map(p5_a15);
616 ddp_ge_notif_rules_rec.creation_date := rosetta_g_miss_date_in_map(p5_a16);
617 ddp_ge_notif_rules_rec.last_updated_by := rosetta_g_miss_num_map(p5_a17);
618 ddp_ge_notif_rules_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a18);
619 ddp_ge_notif_rules_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
620 ddp_ge_notif_rules_rec.notif_name := p5_a20;
621 ddp_ge_notif_rules_rec.notif_content := p5_a21;
622 ddp_ge_notif_rules_rec.notif_desc := p5_a22;
623
624 -- here's the delegated call to the old PL/SQL routine
625 pv_ge_notif_rules_pvt.validate_ge_notif_rules_rec(p_api_version_number,
626 p_init_msg_list,
627 x_return_status,
628 x_msg_count,
629 x_msg_data,
630 ddp_ge_notif_rules_rec);
631
632 -- copy data back from the local variables to OUT or IN-OUT args, if any
633
634
635
636
637
638 end;
639
640 end pv_ge_notif_rules_pvt_w;