[Home] [Help]
PACKAGE BODY: APPS.AMS_TRIG_PVT_W
Source
1 package body ams_trig_pvt_w as
2 /* $Header: amswtrgb.pls 115.13 2003/07/03 14:25:28 cgoyal ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure create_trigger(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , x_trigger_id out nocopy NUMBER
30 , p7_a0 NUMBER := 0-1962.0724
31 , p7_a1 DATE := fnd_api.g_miss_date
32 , p7_a2 NUMBER := 0-1962.0724
33 , p7_a3 DATE := fnd_api.g_miss_date
34 , p7_a4 NUMBER := 0-1962.0724
35 , p7_a5 NUMBER := 0-1962.0724
36 , p7_a6 NUMBER := 0-1962.0724
37 , p7_a7 NUMBER := 0-1962.0724
38 , p7_a8 NUMBER := 0-1962.0724
39 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
40 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
41 , p7_a11 NUMBER := 0-1962.0724
42 , p7_a12 NUMBER := 0-1962.0724
43 , p7_a13 DATE := fnd_api.g_miss_date
44 , p7_a14 DATE := fnd_api.g_miss_date
45 , p7_a15 DATE := fnd_api.g_miss_date
46 , p7_a16 DATE := fnd_api.g_miss_date
47 , p7_a17 DATE := fnd_api.g_miss_date
48 , p7_a18 DATE := fnd_api.g_miss_date
49 , p7_a19 DATE := fnd_api.g_miss_date
50 , p7_a20 DATE := fnd_api.g_miss_date
51 , p7_a21 DATE := fnd_api.g_miss_date
52 , p7_a22 DATE := fnd_api.g_miss_date
53 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
54 , p7_a24 NUMBER := 0-1962.0724
55 , p7_a25 DATE := fnd_api.g_miss_date
56 , p7_a26 DATE := fnd_api.g_miss_date
57 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
58 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
59 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62 )
63
64 as
65 ddp_trig_rec ams_trig_pvt.trig_rec_type;
66 ddindx binary_integer; indx binary_integer;
67 begin
68
69 -- copy data to the local IN or IN-OUT args, if any
70
71
72
73
74
75
76
77 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p7_a0);
78 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
79 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
80 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
81 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p7_a4);
82 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
83 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
84 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p7_a7);
85 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p7_a8);
86 ddp_trig_rec.arc_trigger_created_for := p7_a9;
87 ddp_trig_rec.triggering_type := p7_a10;
88 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p7_a11);
89 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p7_a12);
90 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p7_a13);
91 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a14);
92 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p7_a15);
93 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p7_a16);
94 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p7_a17);
95 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p7_a18);
96 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a19);
97 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a20);
98 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a21);
99 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a22);
100 ddp_trig_rec.repeat_frequency_type := p7_a23;
101 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p7_a24);
102 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a25);
103 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a26);
104 ddp_trig_rec.metrics_refresh_type := p7_a27;
105 ddp_trig_rec.trigger_name := p7_a28;
106 ddp_trig_rec.description := p7_a29;
107 ddp_trig_rec.notify_flag := p7_a30;
108 ddp_trig_rec.execute_schedule_flag := p7_a31;
109
110
111 -- here's the delegated call to the old PL/SQL routine
112 ams_trig_pvt.create_trigger(p_api_version,
113 p_init_msg_list,
114 p_commit,
115 p_validation_level,
116 x_return_status,
117 x_msg_count,
118 x_msg_data,
119 ddp_trig_rec,
120 x_trigger_id);
121
122 -- copy data back from the local variables to OUT or IN-OUT args, if any
123
124
125
126
127
128
129
130
131 end;
132
133 procedure update_trigger(p_api_version NUMBER
134 , p_init_msg_list VARCHAR2
135 , p_commit VARCHAR2
136 , p_validation_level NUMBER
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 , p7_a0 NUMBER := 0-1962.0724
141 , p7_a1 DATE := fnd_api.g_miss_date
142 , p7_a2 NUMBER := 0-1962.0724
143 , p7_a3 DATE := fnd_api.g_miss_date
144 , p7_a4 NUMBER := 0-1962.0724
145 , p7_a5 NUMBER := 0-1962.0724
146 , p7_a6 NUMBER := 0-1962.0724
147 , p7_a7 NUMBER := 0-1962.0724
148 , p7_a8 NUMBER := 0-1962.0724
149 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
150 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
151 , p7_a11 NUMBER := 0-1962.0724
152 , p7_a12 NUMBER := 0-1962.0724
153 , p7_a13 DATE := fnd_api.g_miss_date
154 , p7_a14 DATE := fnd_api.g_miss_date
155 , p7_a15 DATE := fnd_api.g_miss_date
156 , p7_a16 DATE := fnd_api.g_miss_date
157 , p7_a17 DATE := fnd_api.g_miss_date
158 , p7_a18 DATE := fnd_api.g_miss_date
159 , p7_a19 DATE := fnd_api.g_miss_date
160 , p7_a20 DATE := fnd_api.g_miss_date
161 , p7_a21 DATE := fnd_api.g_miss_date
162 , p7_a22 DATE := fnd_api.g_miss_date
163 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
164 , p7_a24 NUMBER := 0-1962.0724
165 , p7_a25 DATE := fnd_api.g_miss_date
166 , p7_a26 DATE := fnd_api.g_miss_date
167 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
168 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
169 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
170 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
171 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
172 )
173
174 as
175 ddp_trig_rec ams_trig_pvt.trig_rec_type;
176 ddindx binary_integer; indx binary_integer;
177 begin
178
179 -- copy data to the local IN or IN-OUT args, if any
180
181
182
183
184
185
186
187 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p7_a0);
188 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
189 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
190 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
191 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p7_a4);
192 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
193 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
194 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p7_a7);
195 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p7_a8);
196 ddp_trig_rec.arc_trigger_created_for := p7_a9;
197 ddp_trig_rec.triggering_type := p7_a10;
198 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p7_a11);
199 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p7_a12);
200 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p7_a13);
201 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a14);
202 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p7_a15);
203 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p7_a16);
204 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p7_a17);
205 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p7_a18);
206 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a19);
207 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a20);
208 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a21);
209 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a22);
210 ddp_trig_rec.repeat_frequency_type := p7_a23;
211 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p7_a24);
212 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a25);
213 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a26);
214 ddp_trig_rec.metrics_refresh_type := p7_a27;
215 ddp_trig_rec.trigger_name := p7_a28;
216 ddp_trig_rec.description := p7_a29;
217 ddp_trig_rec.notify_flag := p7_a30;
218 ddp_trig_rec.execute_schedule_flag := p7_a31;
219
220 -- here's the delegated call to the old PL/SQL routine
221 ams_trig_pvt.update_trigger(p_api_version,
222 p_init_msg_list,
223 p_commit,
224 p_validation_level,
225 x_return_status,
226 x_msg_count,
227 x_msg_data,
228 ddp_trig_rec);
229
230 -- copy data back from the local variables to OUT or IN-OUT args, if any
231
232
233
234
235
236
237
238 end;
239
240 procedure validate_trigger(p_api_version NUMBER
241 , p_init_msg_list VARCHAR2
242 , p_validation_level NUMBER
243 , x_return_status out nocopy VARCHAR2
244 , x_msg_count out nocopy NUMBER
245 , x_msg_data out nocopy VARCHAR2
246 , p6_a0 NUMBER := 0-1962.0724
247 , p6_a1 DATE := fnd_api.g_miss_date
248 , p6_a2 NUMBER := 0-1962.0724
249 , p6_a3 DATE := fnd_api.g_miss_date
250 , p6_a4 NUMBER := 0-1962.0724
251 , p6_a5 NUMBER := 0-1962.0724
252 , p6_a6 NUMBER := 0-1962.0724
253 , p6_a7 NUMBER := 0-1962.0724
254 , p6_a8 NUMBER := 0-1962.0724
255 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
256 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
257 , p6_a11 NUMBER := 0-1962.0724
258 , p6_a12 NUMBER := 0-1962.0724
259 , p6_a13 DATE := fnd_api.g_miss_date
260 , p6_a14 DATE := fnd_api.g_miss_date
261 , p6_a15 DATE := fnd_api.g_miss_date
262 , p6_a16 DATE := fnd_api.g_miss_date
263 , p6_a17 DATE := fnd_api.g_miss_date
264 , p6_a18 DATE := fnd_api.g_miss_date
265 , p6_a19 DATE := fnd_api.g_miss_date
266 , p6_a20 DATE := fnd_api.g_miss_date
267 , p6_a21 DATE := fnd_api.g_miss_date
268 , p6_a22 DATE := fnd_api.g_miss_date
269 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
270 , p6_a24 NUMBER := 0-1962.0724
271 , p6_a25 DATE := fnd_api.g_miss_date
272 , p6_a26 DATE := fnd_api.g_miss_date
273 , p6_a27 VARCHAR2 := fnd_api.g_miss_char
274 , p6_a28 VARCHAR2 := fnd_api.g_miss_char
275 , p6_a29 VARCHAR2 := fnd_api.g_miss_char
276 , p6_a30 VARCHAR2 := fnd_api.g_miss_char
277 , p6_a31 VARCHAR2 := fnd_api.g_miss_char
278 )
279
280 as
281 ddp_trig_rec ams_trig_pvt.trig_rec_type;
282 ddindx binary_integer; indx binary_integer;
283 begin
284
285 -- copy data to the local IN or IN-OUT args, if any
286
287
288
289
290
291
292 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p6_a0);
293 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p6_a1);
294 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p6_a2);
295 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p6_a3);
296 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p6_a4);
297 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p6_a5);
298 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p6_a6);
299 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p6_a7);
300 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p6_a8);
301 ddp_trig_rec.arc_trigger_created_for := p6_a9;
302 ddp_trig_rec.triggering_type := p6_a10;
303 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p6_a11);
304 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p6_a12);
305 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p6_a13);
306 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p6_a14);
307 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p6_a15);
308 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p6_a16);
309 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p6_a17);
310 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p6_a18);
311 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p6_a19);
312 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p6_a20);
313 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p6_a21);
314 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p6_a22);
315 ddp_trig_rec.repeat_frequency_type := p6_a23;
316 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p6_a24);
317 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p6_a25);
318 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p6_a26);
319 ddp_trig_rec.metrics_refresh_type := p6_a27;
320 ddp_trig_rec.trigger_name := p6_a28;
321 ddp_trig_rec.description := p6_a29;
322 ddp_trig_rec.notify_flag := p6_a30;
323 ddp_trig_rec.execute_schedule_flag := p6_a31;
324
325 -- here's the delegated call to the old PL/SQL routine
326 ams_trig_pvt.validate_trigger(p_api_version,
327 p_init_msg_list,
328 p_validation_level,
329 x_return_status,
330 x_msg_count,
331 x_msg_data,
332 ddp_trig_rec);
333
334 -- copy data back from the local variables to OUT or IN-OUT args, if any
335
336
337
338
339
340
341 end;
342
343 procedure check_trig_items(p_validation_mode VARCHAR2
344 , x_return_status out nocopy VARCHAR2
345 , p0_a0 NUMBER := 0-1962.0724
346 , p0_a1 DATE := fnd_api.g_miss_date
347 , p0_a2 NUMBER := 0-1962.0724
348 , p0_a3 DATE := fnd_api.g_miss_date
349 , p0_a4 NUMBER := 0-1962.0724
350 , p0_a5 NUMBER := 0-1962.0724
351 , p0_a6 NUMBER := 0-1962.0724
352 , p0_a7 NUMBER := 0-1962.0724
353 , p0_a8 NUMBER := 0-1962.0724
354 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
355 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
356 , p0_a11 NUMBER := 0-1962.0724
357 , p0_a12 NUMBER := 0-1962.0724
358 , p0_a13 DATE := fnd_api.g_miss_date
359 , p0_a14 DATE := fnd_api.g_miss_date
360 , p0_a15 DATE := fnd_api.g_miss_date
361 , p0_a16 DATE := fnd_api.g_miss_date
362 , p0_a17 DATE := fnd_api.g_miss_date
363 , p0_a18 DATE := fnd_api.g_miss_date
364 , p0_a19 DATE := fnd_api.g_miss_date
365 , p0_a20 DATE := fnd_api.g_miss_date
366 , p0_a21 DATE := fnd_api.g_miss_date
367 , p0_a22 DATE := fnd_api.g_miss_date
368 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
369 , p0_a24 NUMBER := 0-1962.0724
370 , p0_a25 DATE := fnd_api.g_miss_date
371 , p0_a26 DATE := fnd_api.g_miss_date
372 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
373 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
374 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
375 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
376 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
377 )
378
379 as
380 ddp_trig_rec ams_trig_pvt.trig_rec_type;
381 ddindx binary_integer; indx binary_integer;
382 begin
383
384 -- copy data to the local IN or IN-OUT args, if any
385 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p0_a0);
386 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
387 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
388 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
389 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p0_a4);
390 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
391 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
392 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p0_a7);
393 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p0_a8);
394 ddp_trig_rec.arc_trigger_created_for := p0_a9;
395 ddp_trig_rec.triggering_type := p0_a10;
396 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
397 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p0_a12);
398 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p0_a13);
399 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a14);
400 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p0_a15);
401 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p0_a16);
402 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p0_a17);
403 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p0_a18);
404 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a19);
405 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a20);
406 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a21);
407 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a22);
408 ddp_trig_rec.repeat_frequency_type := p0_a23;
409 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p0_a24);
410 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a25);
411 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a26);
412 ddp_trig_rec.metrics_refresh_type := p0_a27;
413 ddp_trig_rec.trigger_name := p0_a28;
414 ddp_trig_rec.description := p0_a29;
415 ddp_trig_rec.notify_flag := p0_a30;
416 ddp_trig_rec.execute_schedule_flag := p0_a31;
417
418
419
420 -- here's the delegated call to the old PL/SQL routine
421 ams_trig_pvt.check_trig_items(ddp_trig_rec,
422 p_validation_mode,
423 x_return_status);
424
425 -- copy data back from the local variables to OUT or IN-OUT args, if any
426
427
428 end;
429
430 procedure check_trig_record(x_return_status out nocopy VARCHAR2
431 , p0_a0 NUMBER := 0-1962.0724
432 , p0_a1 DATE := fnd_api.g_miss_date
433 , p0_a2 NUMBER := 0-1962.0724
434 , p0_a3 DATE := fnd_api.g_miss_date
435 , p0_a4 NUMBER := 0-1962.0724
436 , p0_a5 NUMBER := 0-1962.0724
437 , p0_a6 NUMBER := 0-1962.0724
438 , p0_a7 NUMBER := 0-1962.0724
439 , p0_a8 NUMBER := 0-1962.0724
440 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
441 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
442 , p0_a11 NUMBER := 0-1962.0724
443 , p0_a12 NUMBER := 0-1962.0724
444 , p0_a13 DATE := fnd_api.g_miss_date
445 , p0_a14 DATE := fnd_api.g_miss_date
446 , p0_a15 DATE := fnd_api.g_miss_date
447 , p0_a16 DATE := fnd_api.g_miss_date
448 , p0_a17 DATE := fnd_api.g_miss_date
449 , p0_a18 DATE := fnd_api.g_miss_date
450 , p0_a19 DATE := fnd_api.g_miss_date
451 , p0_a20 DATE := fnd_api.g_miss_date
452 , p0_a21 DATE := fnd_api.g_miss_date
453 , p0_a22 DATE := fnd_api.g_miss_date
454 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
455 , p0_a24 NUMBER := 0-1962.0724
456 , p0_a25 DATE := fnd_api.g_miss_date
457 , p0_a26 DATE := fnd_api.g_miss_date
458 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
459 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
460 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
461 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
462 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
463 , p1_a0 NUMBER := 0-1962.0724
464 , p1_a1 DATE := fnd_api.g_miss_date
465 , p1_a2 NUMBER := 0-1962.0724
466 , p1_a3 DATE := fnd_api.g_miss_date
467 , p1_a4 NUMBER := 0-1962.0724
468 , p1_a5 NUMBER := 0-1962.0724
469 , p1_a6 NUMBER := 0-1962.0724
470 , p1_a7 NUMBER := 0-1962.0724
471 , p1_a8 NUMBER := 0-1962.0724
472 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
473 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
474 , p1_a11 NUMBER := 0-1962.0724
475 , p1_a12 NUMBER := 0-1962.0724
476 , p1_a13 DATE := fnd_api.g_miss_date
477 , p1_a14 DATE := fnd_api.g_miss_date
478 , p1_a15 DATE := fnd_api.g_miss_date
479 , p1_a16 DATE := fnd_api.g_miss_date
480 , p1_a17 DATE := fnd_api.g_miss_date
481 , p1_a18 DATE := fnd_api.g_miss_date
482 , p1_a19 DATE := fnd_api.g_miss_date
483 , p1_a20 DATE := fnd_api.g_miss_date
484 , p1_a21 DATE := fnd_api.g_miss_date
485 , p1_a22 DATE := fnd_api.g_miss_date
486 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
487 , p1_a24 NUMBER := 0-1962.0724
488 , p1_a25 DATE := fnd_api.g_miss_date
489 , p1_a26 DATE := fnd_api.g_miss_date
490 , p1_a27 VARCHAR2 := fnd_api.g_miss_char
491 , p1_a28 VARCHAR2 := fnd_api.g_miss_char
492 , p1_a29 VARCHAR2 := fnd_api.g_miss_char
493 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
494 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
495 )
496
497 as
498 ddp_trig_rec ams_trig_pvt.trig_rec_type;
499 ddp_complete_rec ams_trig_pvt.trig_rec_type;
500 ddindx binary_integer; indx binary_integer;
501 begin
502
503 -- copy data to the local IN or IN-OUT args, if any
504 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p0_a0);
505 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
506 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
507 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
508 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p0_a4);
509 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
510 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
511 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p0_a7);
512 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p0_a8);
513 ddp_trig_rec.arc_trigger_created_for := p0_a9;
514 ddp_trig_rec.triggering_type := p0_a10;
515 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
516 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p0_a12);
517 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p0_a13);
518 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a14);
519 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p0_a15);
520 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p0_a16);
521 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p0_a17);
522 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p0_a18);
523 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a19);
524 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a20);
525 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a21);
526 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a22);
527 ddp_trig_rec.repeat_frequency_type := p0_a23;
528 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p0_a24);
529 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a25);
530 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a26);
531 ddp_trig_rec.metrics_refresh_type := p0_a27;
532 ddp_trig_rec.trigger_name := p0_a28;
533 ddp_trig_rec.description := p0_a29;
534 ddp_trig_rec.notify_flag := p0_a30;
535 ddp_trig_rec.execute_schedule_flag := p0_a31;
536
537 ddp_complete_rec.trigger_id := rosetta_g_miss_num_map(p1_a0);
538 ddp_complete_rec.last_update_date := rosetta_g_miss_date_in_map(p1_a1);
539 ddp_complete_rec.last_updated_by := rosetta_g_miss_num_map(p1_a2);
540 ddp_complete_rec.creation_date := rosetta_g_miss_date_in_map(p1_a3);
541 ddp_complete_rec.created_by := rosetta_g_miss_num_map(p1_a4);
542 ddp_complete_rec.last_update_login := rosetta_g_miss_num_map(p1_a5);
543 ddp_complete_rec.object_version_number := rosetta_g_miss_num_map(p1_a6);
544 ddp_complete_rec.process_id := rosetta_g_miss_num_map(p1_a7);
545 ddp_complete_rec.trigger_created_for_id := rosetta_g_miss_num_map(p1_a8);
546 ddp_complete_rec.arc_trigger_created_for := p1_a9;
547 ddp_complete_rec.triggering_type := p1_a10;
548 ddp_complete_rec.view_application_id := rosetta_g_miss_num_map(p1_a11);
549 ddp_complete_rec.timezone_id := rosetta_g_miss_num_map(p1_a12);
550 ddp_complete_rec.user_start_date_time := rosetta_g_miss_date_in_map(p1_a13);
551 ddp_complete_rec.start_date_time := rosetta_g_miss_date_in_map(p1_a14);
552 ddp_complete_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p1_a15);
553 ddp_complete_rec.last_run_date_time := rosetta_g_miss_date_in_map(p1_a16);
554 ddp_complete_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p1_a17);
555 ddp_complete_rec.next_run_date_time := rosetta_g_miss_date_in_map(p1_a18);
556 ddp_complete_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p1_a19);
557 ddp_complete_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p1_a20);
558 ddp_complete_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p1_a21);
559 ddp_complete_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p1_a22);
560 ddp_complete_rec.repeat_frequency_type := p1_a23;
561 ddp_complete_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p1_a24);
562 ddp_complete_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p1_a25);
563 ddp_complete_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p1_a26);
564 ddp_complete_rec.metrics_refresh_type := p1_a27;
565 ddp_complete_rec.trigger_name := p1_a28;
566 ddp_complete_rec.description := p1_a29;
567 ddp_complete_rec.notify_flag := p1_a30;
568 ddp_complete_rec.execute_schedule_flag := p1_a31;
569
570
571 -- here's the delegated call to the old PL/SQL routine
572 ams_trig_pvt.check_trig_record(ddp_trig_rec,
573 ddp_complete_rec,
574 x_return_status);
575
576 -- copy data back from the local variables to OUT or IN-OUT args, if any
577
578
579 end;
580
581 procedure check_trig_req_items(x_return_status out nocopy VARCHAR2
582 , p0_a0 NUMBER := 0-1962.0724
583 , p0_a1 DATE := fnd_api.g_miss_date
584 , p0_a2 NUMBER := 0-1962.0724
585 , p0_a3 DATE := fnd_api.g_miss_date
586 , p0_a4 NUMBER := 0-1962.0724
587 , p0_a5 NUMBER := 0-1962.0724
588 , p0_a6 NUMBER := 0-1962.0724
589 , p0_a7 NUMBER := 0-1962.0724
590 , p0_a8 NUMBER := 0-1962.0724
591 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
592 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
593 , p0_a11 NUMBER := 0-1962.0724
594 , p0_a12 NUMBER := 0-1962.0724
595 , p0_a13 DATE := fnd_api.g_miss_date
596 , p0_a14 DATE := fnd_api.g_miss_date
597 , p0_a15 DATE := fnd_api.g_miss_date
598 , p0_a16 DATE := fnd_api.g_miss_date
599 , p0_a17 DATE := fnd_api.g_miss_date
600 , p0_a18 DATE := fnd_api.g_miss_date
601 , p0_a19 DATE := fnd_api.g_miss_date
602 , p0_a20 DATE := fnd_api.g_miss_date
603 , p0_a21 DATE := fnd_api.g_miss_date
604 , p0_a22 DATE := fnd_api.g_miss_date
605 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
606 , p0_a24 NUMBER := 0-1962.0724
607 , p0_a25 DATE := fnd_api.g_miss_date
608 , p0_a26 DATE := fnd_api.g_miss_date
609 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
610 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
611 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
612 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
613 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
614 )
615
616 as
617 ddp_trig_rec ams_trig_pvt.trig_rec_type;
618 ddindx binary_integer; indx binary_integer;
619 begin
620
621 -- copy data to the local IN or IN-OUT args, if any
622 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p0_a0);
623 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
624 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
625 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
626 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p0_a4);
627 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
628 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
629 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p0_a7);
630 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p0_a8);
631 ddp_trig_rec.arc_trigger_created_for := p0_a9;
632 ddp_trig_rec.triggering_type := p0_a10;
633 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
634 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p0_a12);
635 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p0_a13);
636 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a14);
637 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p0_a15);
638 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p0_a16);
639 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p0_a17);
640 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p0_a18);
641 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a19);
642 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a20);
643 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a21);
644 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a22);
645 ddp_trig_rec.repeat_frequency_type := p0_a23;
646 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p0_a24);
647 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a25);
648 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a26);
649 ddp_trig_rec.metrics_refresh_type := p0_a27;
650 ddp_trig_rec.trigger_name := p0_a28;
651 ddp_trig_rec.description := p0_a29;
652 ddp_trig_rec.notify_flag := p0_a30;
653 ddp_trig_rec.execute_schedule_flag := p0_a31;
654
655
656 -- here's the delegated call to the old PL/SQL routine
657 ams_trig_pvt.check_trig_req_items(ddp_trig_rec,
658 x_return_status);
659
660 -- copy data back from the local variables to OUT or IN-OUT args, if any
661
662 end;
663
664 procedure init_trig_rec(p0_a0 out nocopy NUMBER
665 , p0_a1 out nocopy DATE
666 , p0_a2 out nocopy NUMBER
667 , p0_a3 out nocopy DATE
668 , p0_a4 out nocopy NUMBER
669 , p0_a5 out nocopy NUMBER
670 , p0_a6 out nocopy NUMBER
671 , p0_a7 out nocopy NUMBER
672 , p0_a8 out nocopy NUMBER
673 , p0_a9 out nocopy VARCHAR2
674 , p0_a10 out nocopy VARCHAR2
675 , p0_a11 out nocopy NUMBER
676 , p0_a12 out nocopy NUMBER
677 , p0_a13 out nocopy DATE
678 , p0_a14 out nocopy DATE
679 , p0_a15 out nocopy DATE
680 , p0_a16 out nocopy DATE
681 , p0_a17 out nocopy DATE
682 , p0_a18 out nocopy DATE
683 , p0_a19 out nocopy DATE
684 , p0_a20 out nocopy DATE
685 , p0_a21 out nocopy DATE
686 , p0_a22 out nocopy DATE
687 , p0_a23 out nocopy VARCHAR2
688 , p0_a24 out nocopy NUMBER
689 , p0_a25 out nocopy DATE
690 , p0_a26 out nocopy DATE
691 , p0_a27 out nocopy VARCHAR2
692 , p0_a28 out nocopy VARCHAR2
693 , p0_a29 out nocopy VARCHAR2
694 , p0_a30 out nocopy VARCHAR2
695 , p0_a31 out nocopy VARCHAR2
696 )
697
698 as
699 ddx_trig_rec ams_trig_pvt.trig_rec_type;
700 ddindx binary_integer; indx binary_integer;
701 begin
702
703 -- copy data to the local IN or IN-OUT args, if any
704
705 -- here's the delegated call to the old PL/SQL routine
706 ams_trig_pvt.init_trig_rec(ddx_trig_rec);
707
708 -- copy data back from the local variables to OUT or IN-OUT args, if any
709 p0_a0 := rosetta_g_miss_num_map(ddx_trig_rec.trigger_id);
710 p0_a1 := ddx_trig_rec.last_update_date;
711 p0_a2 := rosetta_g_miss_num_map(ddx_trig_rec.last_updated_by);
712 p0_a3 := ddx_trig_rec.creation_date;
713 p0_a4 := rosetta_g_miss_num_map(ddx_trig_rec.created_by);
714 p0_a5 := rosetta_g_miss_num_map(ddx_trig_rec.last_update_login);
715 p0_a6 := rosetta_g_miss_num_map(ddx_trig_rec.object_version_number);
716 p0_a7 := rosetta_g_miss_num_map(ddx_trig_rec.process_id);
717 p0_a8 := rosetta_g_miss_num_map(ddx_trig_rec.trigger_created_for_id);
718 p0_a9 := ddx_trig_rec.arc_trigger_created_for;
719 p0_a10 := ddx_trig_rec.triggering_type;
720 p0_a11 := rosetta_g_miss_num_map(ddx_trig_rec.view_application_id);
721 p0_a12 := rosetta_g_miss_num_map(ddx_trig_rec.timezone_id);
722 p0_a13 := ddx_trig_rec.user_start_date_time;
723 p0_a14 := ddx_trig_rec.start_date_time;
724 p0_a15 := ddx_trig_rec.user_last_run_date_time;
725 p0_a16 := ddx_trig_rec.last_run_date_time;
726 p0_a17 := ddx_trig_rec.user_next_run_date_time;
727 p0_a18 := ddx_trig_rec.next_run_date_time;
728 p0_a19 := ddx_trig_rec.user_repeat_daily_start_time;
729 p0_a20 := ddx_trig_rec.repeat_daily_start_time;
730 p0_a21 := ddx_trig_rec.user_repeat_daily_end_time;
731 p0_a22 := ddx_trig_rec.repeat_daily_end_time;
732 p0_a23 := ddx_trig_rec.repeat_frequency_type;
733 p0_a24 := rosetta_g_miss_num_map(ddx_trig_rec.repeat_every_x_frequency);
734 p0_a25 := ddx_trig_rec.user_repeat_stop_date_time;
735 p0_a26 := ddx_trig_rec.repeat_stop_date_time;
736 p0_a27 := ddx_trig_rec.metrics_refresh_type;
737 p0_a28 := ddx_trig_rec.trigger_name;
738 p0_a29 := ddx_trig_rec.description;
739 p0_a30 := ddx_trig_rec.notify_flag;
740 p0_a31 := ddx_trig_rec.execute_schedule_flag;
741 end;
742
743 procedure complete_trig_rec(p1_a0 out nocopy NUMBER
744 , p1_a1 out nocopy DATE
745 , p1_a2 out nocopy NUMBER
746 , p1_a3 out nocopy DATE
747 , p1_a4 out nocopy NUMBER
748 , p1_a5 out nocopy NUMBER
749 , p1_a6 out nocopy NUMBER
750 , p1_a7 out nocopy NUMBER
751 , p1_a8 out nocopy NUMBER
752 , p1_a9 out nocopy VARCHAR2
753 , p1_a10 out nocopy VARCHAR2
754 , p1_a11 out nocopy NUMBER
755 , p1_a12 out nocopy NUMBER
756 , p1_a13 out nocopy DATE
757 , p1_a14 out nocopy DATE
758 , p1_a15 out nocopy DATE
759 , p1_a16 out nocopy DATE
760 , p1_a17 out nocopy DATE
761 , p1_a18 out nocopy DATE
762 , p1_a19 out nocopy DATE
763 , p1_a20 out nocopy DATE
764 , p1_a21 out nocopy DATE
765 , p1_a22 out nocopy DATE
766 , p1_a23 out nocopy VARCHAR2
767 , p1_a24 out nocopy NUMBER
768 , p1_a25 out nocopy DATE
769 , p1_a26 out nocopy DATE
770 , p1_a27 out nocopy VARCHAR2
771 , p1_a28 out nocopy VARCHAR2
772 , p1_a29 out nocopy VARCHAR2
773 , p1_a30 out nocopy VARCHAR2
774 , p1_a31 out nocopy VARCHAR2
775 , p0_a0 NUMBER := 0-1962.0724
776 , p0_a1 DATE := fnd_api.g_miss_date
777 , p0_a2 NUMBER := 0-1962.0724
778 , p0_a3 DATE := fnd_api.g_miss_date
779 , p0_a4 NUMBER := 0-1962.0724
780 , p0_a5 NUMBER := 0-1962.0724
781 , p0_a6 NUMBER := 0-1962.0724
782 , p0_a7 NUMBER := 0-1962.0724
783 , p0_a8 NUMBER := 0-1962.0724
784 , p0_a9 VARCHAR2 := fnd_api.g_miss_char
785 , p0_a10 VARCHAR2 := fnd_api.g_miss_char
786 , p0_a11 NUMBER := 0-1962.0724
787 , p0_a12 NUMBER := 0-1962.0724
788 , p0_a13 DATE := fnd_api.g_miss_date
789 , p0_a14 DATE := fnd_api.g_miss_date
790 , p0_a15 DATE := fnd_api.g_miss_date
791 , p0_a16 DATE := fnd_api.g_miss_date
792 , p0_a17 DATE := fnd_api.g_miss_date
793 , p0_a18 DATE := fnd_api.g_miss_date
794 , p0_a19 DATE := fnd_api.g_miss_date
795 , p0_a20 DATE := fnd_api.g_miss_date
796 , p0_a21 DATE := fnd_api.g_miss_date
797 , p0_a22 DATE := fnd_api.g_miss_date
798 , p0_a23 VARCHAR2 := fnd_api.g_miss_char
799 , p0_a24 NUMBER := 0-1962.0724
800 , p0_a25 DATE := fnd_api.g_miss_date
801 , p0_a26 DATE := fnd_api.g_miss_date
802 , p0_a27 VARCHAR2 := fnd_api.g_miss_char
803 , p0_a28 VARCHAR2 := fnd_api.g_miss_char
804 , p0_a29 VARCHAR2 := fnd_api.g_miss_char
805 , p0_a30 VARCHAR2 := fnd_api.g_miss_char
806 , p0_a31 VARCHAR2 := fnd_api.g_miss_char
807 )
808
809 as
810 ddp_trig_rec ams_trig_pvt.trig_rec_type;
811 ddx_complete_rec ams_trig_pvt.trig_rec_type;
812 ddindx binary_integer; indx binary_integer;
813 begin
814
815 -- copy data to the local IN or IN-OUT args, if any
816 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p0_a0);
817 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p0_a1);
818 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p0_a2);
819 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p0_a3);
820 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p0_a4);
821 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p0_a5);
822 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p0_a6);
823 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p0_a7);
824 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p0_a8);
825 ddp_trig_rec.arc_trigger_created_for := p0_a9;
826 ddp_trig_rec.triggering_type := p0_a10;
827 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p0_a11);
828 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p0_a12);
829 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p0_a13);
830 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p0_a14);
831 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p0_a15);
832 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p0_a16);
833 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p0_a17);
834 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p0_a18);
835 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a19);
836 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p0_a20);
837 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a21);
838 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p0_a22);
839 ddp_trig_rec.repeat_frequency_type := p0_a23;
840 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p0_a24);
841 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a25);
842 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p0_a26);
843 ddp_trig_rec.metrics_refresh_type := p0_a27;
844 ddp_trig_rec.trigger_name := p0_a28;
845 ddp_trig_rec.description := p0_a29;
846 ddp_trig_rec.notify_flag := p0_a30;
847 ddp_trig_rec.execute_schedule_flag := p0_a31;
848
849
850 -- here's the delegated call to the old PL/SQL routine
851 ams_trig_pvt.complete_trig_rec(ddp_trig_rec,
852 ddx_complete_rec);
853
854 -- copy data back from the local variables to OUT or IN-OUT args, if any
855
856 p1_a0 := rosetta_g_miss_num_map(ddx_complete_rec.trigger_id);
857 p1_a1 := ddx_complete_rec.last_update_date;
858 p1_a2 := rosetta_g_miss_num_map(ddx_complete_rec.last_updated_by);
859 p1_a3 := ddx_complete_rec.creation_date;
860 p1_a4 := rosetta_g_miss_num_map(ddx_complete_rec.created_by);
861 p1_a5 := rosetta_g_miss_num_map(ddx_complete_rec.last_update_login);
862 p1_a6 := rosetta_g_miss_num_map(ddx_complete_rec.object_version_number);
863 p1_a7 := rosetta_g_miss_num_map(ddx_complete_rec.process_id);
864 p1_a8 := rosetta_g_miss_num_map(ddx_complete_rec.trigger_created_for_id);
865 p1_a9 := ddx_complete_rec.arc_trigger_created_for;
866 p1_a10 := ddx_complete_rec.triggering_type;
867 p1_a11 := rosetta_g_miss_num_map(ddx_complete_rec.view_application_id);
868 p1_a12 := rosetta_g_miss_num_map(ddx_complete_rec.timezone_id);
869 p1_a13 := ddx_complete_rec.user_start_date_time;
870 p1_a14 := ddx_complete_rec.start_date_time;
871 p1_a15 := ddx_complete_rec.user_last_run_date_time;
872 p1_a16 := ddx_complete_rec.last_run_date_time;
873 p1_a17 := ddx_complete_rec.user_next_run_date_time;
874 p1_a18 := ddx_complete_rec.next_run_date_time;
875 p1_a19 := ddx_complete_rec.user_repeat_daily_start_time;
876 p1_a20 := ddx_complete_rec.repeat_daily_start_time;
877 p1_a21 := ddx_complete_rec.user_repeat_daily_end_time;
878 p1_a22 := ddx_complete_rec.repeat_daily_end_time;
879 p1_a23 := ddx_complete_rec.repeat_frequency_type;
880 p1_a24 := rosetta_g_miss_num_map(ddx_complete_rec.repeat_every_x_frequency);
881 p1_a25 := ddx_complete_rec.user_repeat_stop_date_time;
882 p1_a26 := ddx_complete_rec.repeat_stop_date_time;
883 p1_a27 := ddx_complete_rec.metrics_refresh_type;
884 p1_a28 := ddx_complete_rec.trigger_name;
885 p1_a29 := ddx_complete_rec.description;
886 p1_a30 := ddx_complete_rec.notify_flag;
887 p1_a31 := ddx_complete_rec.execute_schedule_flag;
888 end;
889
890 end ams_trig_pvt_w;