[Home] [Help]
PACKAGE BODY: APPS.AMS_TRIGGER_PVT_W
Source
1 package body ams_trigger_pvt_w as
2 /* $Header: amswtgrb.pls 115.12 2003/07/03 14:25:38 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_check_id out nocopy NUMBER
30 , x_trigger_action_id out nocopy NUMBER
31 , x_trigger_id out nocopy NUMBER
32 , p7_a0 NUMBER := 0-1962.0724
33 , p7_a1 DATE := fnd_api.g_miss_date
34 , p7_a2 NUMBER := 0-1962.0724
35 , p7_a3 DATE := fnd_api.g_miss_date
36 , p7_a4 NUMBER := 0-1962.0724
37 , p7_a5 NUMBER := 0-1962.0724
38 , p7_a6 NUMBER := 0-1962.0724
39 , p7_a7 NUMBER := 0-1962.0724
40 , p7_a8 NUMBER := 0-1962.0724
41 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
42 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
43 , p7_a11 NUMBER := 0-1962.0724
44 , p7_a12 NUMBER := 0-1962.0724
45 , p7_a13 DATE := fnd_api.g_miss_date
46 , p7_a14 DATE := fnd_api.g_miss_date
47 , p7_a15 DATE := fnd_api.g_miss_date
48 , p7_a16 DATE := fnd_api.g_miss_date
49 , p7_a17 DATE := fnd_api.g_miss_date
50 , p7_a18 DATE := fnd_api.g_miss_date
51 , p7_a19 DATE := fnd_api.g_miss_date
52 , p7_a20 DATE := fnd_api.g_miss_date
53 , p7_a21 DATE := fnd_api.g_miss_date
54 , p7_a22 DATE := fnd_api.g_miss_date
55 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
56 , p7_a24 NUMBER := 0-1962.0724
57 , p7_a25 DATE := fnd_api.g_miss_date
58 , p7_a26 DATE := fnd_api.g_miss_date
59 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
60 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
61 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
62 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
63 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
64 , p8_a0 NUMBER := 0-1962.0724
65 , p8_a1 DATE := fnd_api.g_miss_date
66 , p8_a2 NUMBER := 0-1962.0724
67 , p8_a3 DATE := fnd_api.g_miss_date
68 , p8_a4 NUMBER := 0-1962.0724
69 , p8_a5 NUMBER := 0-1962.0724
70 , p8_a6 NUMBER := 0-1962.0724
71 , p8_a7 NUMBER := 0-1962.0724
72 , p8_a8 NUMBER := 0-1962.0724
73 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
74 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
75 , p8_a11 NUMBER := 0-1962.0724
76 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
77 , p8_a13 NUMBER := 0-1962.0724
78 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
79 , p8_a15 NUMBER := 0-1962.0724
80 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
81 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
82 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
83 , p8_a19 NUMBER := 0-1962.0724
84 , p8_a20 NUMBER := 0-1962.0724
85 , p8_a21 NUMBER := 0-1962.0724
86 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
87 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
88 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
89 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
90 , p8_a26 NUMBER := 0-1962.0724
91 , p8_a27 NUMBER := 0-1962.0724
92 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
93 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
94 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
95 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
96 , p9_a0 NUMBER := 0-1962.0724
97 , p9_a1 DATE := fnd_api.g_miss_date
98 , p9_a2 NUMBER := 0-1962.0724
99 , p9_a3 DATE := fnd_api.g_miss_date
100 , p9_a4 NUMBER := 0-1962.0724
101 , p9_a5 NUMBER := 0-1962.0724
102 , p9_a6 NUMBER := 0-1962.0724
103 , p9_a7 NUMBER := 0-1962.0724
104 , p9_a8 NUMBER := 0-1962.0724
105 , p9_a9 NUMBER := 0-1962.0724
106 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
107 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
108 , p9_a12 VARCHAR2 := fnd_api.g_miss_char
109 , p9_a13 NUMBER := 0-1962.0724
110 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
111 , p9_a15 NUMBER := 0-1962.0724
112 , p9_a16 NUMBER := 0-1962.0724
113 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
114 , p9_a18 NUMBER := 0-1962.0724
115 , p9_a19 NUMBER := 0-1962.0724
116 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
117 , p9_a21 VARCHAR2 := fnd_api.g_miss_char
118 , p9_a22 NUMBER := 0-1962.0724
119 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
120 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
121 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
122 , p9_a26 NUMBER := 0-1962.0724
123 )
124
125 as
126 ddp_trig_rec ams_trig_pvt.trig_rec_type;
127 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
128 ddp_thldact_rec ams_thldact_pvt.thldact_rec_type;
129 ddindx binary_integer; indx binary_integer;
130 begin
131
132 -- copy data to the local IN or IN-OUT args, if any
133
134
135
136
137
138
139
140 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p7_a0);
141 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
142 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
143 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
144 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p7_a4);
145 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
146 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
147 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p7_a7);
148 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p7_a8);
149 ddp_trig_rec.arc_trigger_created_for := p7_a9;
150 ddp_trig_rec.triggering_type := p7_a10;
151 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p7_a11);
152 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p7_a12);
153 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p7_a13);
154 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a14);
155 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p7_a15);
156 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p7_a16);
157 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p7_a17);
158 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p7_a18);
159 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a19);
160 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a20);
161 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a21);
162 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a22);
163 ddp_trig_rec.repeat_frequency_type := p7_a23;
164 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p7_a24);
165 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a25);
166 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a26);
167 ddp_trig_rec.metrics_refresh_type := p7_a27;
168 ddp_trig_rec.trigger_name := p7_a28;
169 ddp_trig_rec.description := p7_a29;
170 ddp_trig_rec.notify_flag := p7_a30;
171 ddp_trig_rec.execute_schedule_flag := p7_a31;
172
173 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p8_a0);
174 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a1);
175 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p8_a2);
176 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p8_a3);
177 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p8_a4);
178 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p8_a5);
179 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p8_a6);
180 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p8_a7);
181 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p8_a8);
182 ddp_thldchk_rec.chk1_type := p8_a9;
183 ddp_thldchk_rec.chk1_arc_source_code_from := p8_a10;
184 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p8_a11);
185 ddp_thldchk_rec.chk1_source_code := p8_a12;
186 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p8_a13);
187 ddp_thldchk_rec.chk1_source_code_metric_type := p8_a14;
188 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p8_a15);
189 ddp_thldchk_rec.chk1_workbook_name := p8_a16;
190 ddp_thldchk_rec.chk1_to_chk2_operator_type := p8_a17;
191 ddp_thldchk_rec.chk2_type := p8_a18;
192 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p8_a19);
193 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p8_a20);
194 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p8_a21);
195 ddp_thldchk_rec.chk2_uom_code := p8_a22;
196 ddp_thldchk_rec.chk2_currency_code := p8_a23;
197 ddp_thldchk_rec.chk2_source_code := p8_a24;
198 ddp_thldchk_rec.chk2_arc_source_code_from := p8_a25;
199 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p8_a26);
200 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p8_a27);
201 ddp_thldchk_rec.chk2_source_code_metric_type := p8_a28;
202 ddp_thldchk_rec.chk2_workbook_name := p8_a29;
203 ddp_thldchk_rec.chk2_workbook_owner := p8_a30;
204 ddp_thldchk_rec.chk2_worksheet_name := p8_a31;
205
206 ddp_thldact_rec.trigger_action_id := rosetta_g_miss_num_map(p9_a0);
207 ddp_thldact_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
208 ddp_thldact_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
209 ddp_thldact_rec.creation_date := rosetta_g_miss_date_in_map(p9_a3);
210 ddp_thldact_rec.created_by := rosetta_g_miss_num_map(p9_a4);
211 ddp_thldact_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
212 ddp_thldact_rec.object_version_number := rosetta_g_miss_num_map(p9_a6);
213 ddp_thldact_rec.process_id := rosetta_g_miss_num_map(p9_a7);
214 ddp_thldact_rec.trigger_id := rosetta_g_miss_num_map(p9_a8);
215 ddp_thldact_rec.order_number := rosetta_g_miss_num_map(p9_a9);
216 ddp_thldact_rec.notify_flag := p9_a10;
217 ddp_thldact_rec.generate_list_flag := p9_a11;
218 ddp_thldact_rec.action_need_approval_flag := p9_a12;
219 ddp_thldact_rec.action_approver_user_id := rosetta_g_miss_num_map(p9_a13);
220 ddp_thldact_rec.execute_action_type := p9_a14;
221 ddp_thldact_rec.list_header_id := rosetta_g_miss_num_map(p9_a15);
222 ddp_thldact_rec.list_connected_to_id := rosetta_g_miss_num_map(p9_a16);
223 ddp_thldact_rec.arc_list_connected_to := p9_a17;
224 ddp_thldact_rec.deliverable_id := rosetta_g_miss_num_map(p9_a18);
225 ddp_thldact_rec.activity_offer_id := rosetta_g_miss_num_map(p9_a19);
226 ddp_thldact_rec.dscript_name := p9_a20;
227 ddp_thldact_rec.program_to_call := p9_a21;
228 ddp_thldact_rec.cover_letter_id := rosetta_g_miss_num_map(p9_a22);
229 ddp_thldact_rec.mail_subject := p9_a23;
230 ddp_thldact_rec.mail_sender_name := p9_a24;
231 ddp_thldact_rec.from_fax_no := p9_a25;
232 ddp_thldact_rec.action_for_id := rosetta_g_miss_num_map(p9_a26);
233
234
235
236
237 -- here's the delegated call to the old PL/SQL routine
238 ams_trigger_pvt.create_trigger(p_api_version,
239 p_init_msg_list,
240 p_commit,
241 p_validation_level,
242 x_return_status,
243 x_msg_count,
244 x_msg_data,
245 ddp_trig_rec,
246 ddp_thldchk_rec,
247 ddp_thldact_rec,
248 x_trigger_check_id,
249 x_trigger_action_id,
250 x_trigger_id);
251
252 -- copy data back from the local variables to OUT or IN-OUT args, if any
253
254
255
256
257
258
259
260
261
262
263
264
265 end;
266
267 procedure update_trigger(p_api_version NUMBER
268 , p_init_msg_list VARCHAR2
269 , p_commit VARCHAR2
270 , p_validation_level NUMBER
271 , x_return_status out nocopy VARCHAR2
272 , x_msg_count out nocopy NUMBER
273 , x_msg_data out nocopy VARCHAR2
274 , p7_a0 NUMBER := 0-1962.0724
275 , p7_a1 DATE := fnd_api.g_miss_date
276 , p7_a2 NUMBER := 0-1962.0724
277 , p7_a3 DATE := fnd_api.g_miss_date
278 , p7_a4 NUMBER := 0-1962.0724
279 , p7_a5 NUMBER := 0-1962.0724
280 , p7_a6 NUMBER := 0-1962.0724
281 , p7_a7 NUMBER := 0-1962.0724
282 , p7_a8 NUMBER := 0-1962.0724
283 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
284 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
285 , p7_a11 NUMBER := 0-1962.0724
286 , p7_a12 NUMBER := 0-1962.0724
287 , p7_a13 DATE := fnd_api.g_miss_date
288 , p7_a14 DATE := fnd_api.g_miss_date
289 , p7_a15 DATE := fnd_api.g_miss_date
290 , p7_a16 DATE := fnd_api.g_miss_date
291 , p7_a17 DATE := fnd_api.g_miss_date
292 , p7_a18 DATE := fnd_api.g_miss_date
293 , p7_a19 DATE := fnd_api.g_miss_date
294 , p7_a20 DATE := fnd_api.g_miss_date
295 , p7_a21 DATE := fnd_api.g_miss_date
296 , p7_a22 DATE := fnd_api.g_miss_date
297 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
298 , p7_a24 NUMBER := 0-1962.0724
299 , p7_a25 DATE := fnd_api.g_miss_date
300 , p7_a26 DATE := fnd_api.g_miss_date
301 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
302 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
303 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
304 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
305 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
306 , p8_a0 NUMBER := 0-1962.0724
307 , p8_a1 DATE := fnd_api.g_miss_date
308 , p8_a2 NUMBER := 0-1962.0724
309 , p8_a3 DATE := fnd_api.g_miss_date
310 , p8_a4 NUMBER := 0-1962.0724
311 , p8_a5 NUMBER := 0-1962.0724
312 , p8_a6 NUMBER := 0-1962.0724
313 , p8_a7 NUMBER := 0-1962.0724
314 , p8_a8 NUMBER := 0-1962.0724
315 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
316 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
317 , p8_a11 NUMBER := 0-1962.0724
318 , p8_a12 VARCHAR2 := fnd_api.g_miss_char
319 , p8_a13 NUMBER := 0-1962.0724
320 , p8_a14 VARCHAR2 := fnd_api.g_miss_char
321 , p8_a15 NUMBER := 0-1962.0724
322 , p8_a16 VARCHAR2 := fnd_api.g_miss_char
323 , p8_a17 VARCHAR2 := fnd_api.g_miss_char
324 , p8_a18 VARCHAR2 := fnd_api.g_miss_char
325 , p8_a19 NUMBER := 0-1962.0724
326 , p8_a20 NUMBER := 0-1962.0724
327 , p8_a21 NUMBER := 0-1962.0724
328 , p8_a22 VARCHAR2 := fnd_api.g_miss_char
329 , p8_a23 VARCHAR2 := fnd_api.g_miss_char
330 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
331 , p8_a25 VARCHAR2 := fnd_api.g_miss_char
332 , p8_a26 NUMBER := 0-1962.0724
333 , p8_a27 NUMBER := 0-1962.0724
334 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
335 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
336 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
337 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
338 , p9_a0 NUMBER := 0-1962.0724
339 , p9_a1 DATE := fnd_api.g_miss_date
340 , p9_a2 NUMBER := 0-1962.0724
341 , p9_a3 DATE := fnd_api.g_miss_date
342 , p9_a4 NUMBER := 0-1962.0724
343 , p9_a5 NUMBER := 0-1962.0724
344 , p9_a6 NUMBER := 0-1962.0724
345 , p9_a7 NUMBER := 0-1962.0724
346 , p9_a8 NUMBER := 0-1962.0724
347 , p9_a9 NUMBER := 0-1962.0724
348 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
349 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
350 , p9_a12 VARCHAR2 := fnd_api.g_miss_char
351 , p9_a13 NUMBER := 0-1962.0724
352 , p9_a14 VARCHAR2 := fnd_api.g_miss_char
353 , p9_a15 NUMBER := 0-1962.0724
354 , p9_a16 NUMBER := 0-1962.0724
355 , p9_a17 VARCHAR2 := fnd_api.g_miss_char
356 , p9_a18 NUMBER := 0-1962.0724
357 , p9_a19 NUMBER := 0-1962.0724
358 , p9_a20 VARCHAR2 := fnd_api.g_miss_char
359 , p9_a21 VARCHAR2 := fnd_api.g_miss_char
360 , p9_a22 NUMBER := 0-1962.0724
361 , p9_a23 VARCHAR2 := fnd_api.g_miss_char
362 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
363 , p9_a25 VARCHAR2 := fnd_api.g_miss_char
364 , p9_a26 NUMBER := 0-1962.0724
365 )
366
367 as
368 ddp_trig_rec ams_trig_pvt.trig_rec_type;
369 ddp_thldchk_rec ams_thldchk_pvt.thldchk_rec_type;
370 ddp_thldact_rec ams_thldact_pvt.thldact_rec_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
381
382 ddp_trig_rec.trigger_id := rosetta_g_miss_num_map(p7_a0);
383 ddp_trig_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a1);
384 ddp_trig_rec.last_updated_by := rosetta_g_miss_num_map(p7_a2);
385 ddp_trig_rec.creation_date := rosetta_g_miss_date_in_map(p7_a3);
386 ddp_trig_rec.created_by := rosetta_g_miss_num_map(p7_a4);
387 ddp_trig_rec.last_update_login := rosetta_g_miss_num_map(p7_a5);
388 ddp_trig_rec.object_version_number := rosetta_g_miss_num_map(p7_a6);
389 ddp_trig_rec.process_id := rosetta_g_miss_num_map(p7_a7);
390 ddp_trig_rec.trigger_created_for_id := rosetta_g_miss_num_map(p7_a8);
391 ddp_trig_rec.arc_trigger_created_for := p7_a9;
392 ddp_trig_rec.triggering_type := p7_a10;
393 ddp_trig_rec.view_application_id := rosetta_g_miss_num_map(p7_a11);
394 ddp_trig_rec.timezone_id := rosetta_g_miss_num_map(p7_a12);
395 ddp_trig_rec.user_start_date_time := rosetta_g_miss_date_in_map(p7_a13);
396 ddp_trig_rec.start_date_time := rosetta_g_miss_date_in_map(p7_a14);
397 ddp_trig_rec.user_last_run_date_time := rosetta_g_miss_date_in_map(p7_a15);
398 ddp_trig_rec.last_run_date_time := rosetta_g_miss_date_in_map(p7_a16);
399 ddp_trig_rec.user_next_run_date_time := rosetta_g_miss_date_in_map(p7_a17);
400 ddp_trig_rec.next_run_date_time := rosetta_g_miss_date_in_map(p7_a18);
401 ddp_trig_rec.user_repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a19);
402 ddp_trig_rec.repeat_daily_start_time := rosetta_g_miss_date_in_map(p7_a20);
403 ddp_trig_rec.user_repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a21);
404 ddp_trig_rec.repeat_daily_end_time := rosetta_g_miss_date_in_map(p7_a22);
405 ddp_trig_rec.repeat_frequency_type := p7_a23;
406 ddp_trig_rec.repeat_every_x_frequency := rosetta_g_miss_num_map(p7_a24);
407 ddp_trig_rec.user_repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a25);
408 ddp_trig_rec.repeat_stop_date_time := rosetta_g_miss_date_in_map(p7_a26);
409 ddp_trig_rec.metrics_refresh_type := p7_a27;
410 ddp_trig_rec.trigger_name := p7_a28;
411 ddp_trig_rec.description := p7_a29;
412 ddp_trig_rec.notify_flag := p7_a30;
413 ddp_trig_rec.execute_schedule_flag := p7_a31;
414
415 ddp_thldchk_rec.trigger_check_id := rosetta_g_miss_num_map(p8_a0);
416 ddp_thldchk_rec.last_update_date := rosetta_g_miss_date_in_map(p8_a1);
417 ddp_thldchk_rec.last_updated_by := rosetta_g_miss_num_map(p8_a2);
418 ddp_thldchk_rec.creation_date := rosetta_g_miss_date_in_map(p8_a3);
419 ddp_thldchk_rec.created_by := rosetta_g_miss_num_map(p8_a4);
420 ddp_thldchk_rec.last_update_login := rosetta_g_miss_num_map(p8_a5);
421 ddp_thldchk_rec.object_version_number := rosetta_g_miss_num_map(p8_a6);
422 ddp_thldchk_rec.trigger_id := rosetta_g_miss_num_map(p8_a7);
423 ddp_thldchk_rec.order_number := rosetta_g_miss_num_map(p8_a8);
424 ddp_thldchk_rec.chk1_type := p8_a9;
425 ddp_thldchk_rec.chk1_arc_source_code_from := p8_a10;
426 ddp_thldchk_rec.chk1_act_object_id := rosetta_g_miss_num_map(p8_a11);
427 ddp_thldchk_rec.chk1_source_code := p8_a12;
428 ddp_thldchk_rec.chk1_source_code_metric_id := rosetta_g_miss_num_map(p8_a13);
429 ddp_thldchk_rec.chk1_source_code_metric_type := p8_a14;
430 ddp_thldchk_rec.chk1_workbook_owner := rosetta_g_miss_num_map(p8_a15);
431 ddp_thldchk_rec.chk1_workbook_name := p8_a16;
432 ddp_thldchk_rec.chk1_to_chk2_operator_type := p8_a17;
433 ddp_thldchk_rec.chk2_type := p8_a18;
434 ddp_thldchk_rec.chk2_value := rosetta_g_miss_num_map(p8_a19);
435 ddp_thldchk_rec.chk2_low_value := rosetta_g_miss_num_map(p8_a20);
436 ddp_thldchk_rec.chk2_high_value := rosetta_g_miss_num_map(p8_a21);
437 ddp_thldchk_rec.chk2_uom_code := p8_a22;
438 ddp_thldchk_rec.chk2_currency_code := p8_a23;
439 ddp_thldchk_rec.chk2_source_code := p8_a24;
440 ddp_thldchk_rec.chk2_arc_source_code_from := p8_a25;
441 ddp_thldchk_rec.chk2_act_object_id := rosetta_g_miss_num_map(p8_a26);
442 ddp_thldchk_rec.chk2_source_code_metric_id := rosetta_g_miss_num_map(p8_a27);
443 ddp_thldchk_rec.chk2_source_code_metric_type := p8_a28;
444 ddp_thldchk_rec.chk2_workbook_name := p8_a29;
445 ddp_thldchk_rec.chk2_workbook_owner := p8_a30;
446 ddp_thldchk_rec.chk2_worksheet_name := p8_a31;
447
448 ddp_thldact_rec.trigger_action_id := rosetta_g_miss_num_map(p9_a0);
449 ddp_thldact_rec.last_update_date := rosetta_g_miss_date_in_map(p9_a1);
450 ddp_thldact_rec.last_updated_by := rosetta_g_miss_num_map(p9_a2);
451 ddp_thldact_rec.creation_date := rosetta_g_miss_date_in_map(p9_a3);
452 ddp_thldact_rec.created_by := rosetta_g_miss_num_map(p9_a4);
453 ddp_thldact_rec.last_update_login := rosetta_g_miss_num_map(p9_a5);
454 ddp_thldact_rec.object_version_number := rosetta_g_miss_num_map(p9_a6);
455 ddp_thldact_rec.process_id := rosetta_g_miss_num_map(p9_a7);
456 ddp_thldact_rec.trigger_id := rosetta_g_miss_num_map(p9_a8);
457 ddp_thldact_rec.order_number := rosetta_g_miss_num_map(p9_a9);
458 ddp_thldact_rec.notify_flag := p9_a10;
459 ddp_thldact_rec.generate_list_flag := p9_a11;
460 ddp_thldact_rec.action_need_approval_flag := p9_a12;
461 ddp_thldact_rec.action_approver_user_id := rosetta_g_miss_num_map(p9_a13);
462 ddp_thldact_rec.execute_action_type := p9_a14;
463 ddp_thldact_rec.list_header_id := rosetta_g_miss_num_map(p9_a15);
464 ddp_thldact_rec.list_connected_to_id := rosetta_g_miss_num_map(p9_a16);
465 ddp_thldact_rec.arc_list_connected_to := p9_a17;
466 ddp_thldact_rec.deliverable_id := rosetta_g_miss_num_map(p9_a18);
467 ddp_thldact_rec.activity_offer_id := rosetta_g_miss_num_map(p9_a19);
468 ddp_thldact_rec.dscript_name := p9_a20;
469 ddp_thldact_rec.program_to_call := p9_a21;
470 ddp_thldact_rec.cover_letter_id := rosetta_g_miss_num_map(p9_a22);
471 ddp_thldact_rec.mail_subject := p9_a23;
472 ddp_thldact_rec.mail_sender_name := p9_a24;
473 ddp_thldact_rec.from_fax_no := p9_a25;
474 ddp_thldact_rec.action_for_id := rosetta_g_miss_num_map(p9_a26);
475
476 -- here's the delegated call to the old PL/SQL routine
477 ams_trigger_pvt.update_trigger(p_api_version,
478 p_init_msg_list,
479 p_commit,
480 p_validation_level,
481 x_return_status,
482 x_msg_count,
483 x_msg_data,
484 ddp_trig_rec,
485 ddp_thldchk_rec,
486 ddp_thldact_rec);
487
488 -- copy data back from the local variables to OUT or IN-OUT args, if any
489
490
491
492
493
494
495
496
497
498 end;
499
500 end ams_trigger_pvt_w;