eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AMS_TRIG_PVT_W

Source


1 package ams_trig_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswtrgs.pls 115.13 2003/07/03 14:25:18 cgoyal ship $ */
3   procedure create_trigger(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p_commit  VARCHAR2
6     , p_validation_level  NUMBER
7     , x_return_status out nocopy  VARCHAR2
8     , x_msg_count out nocopy  NUMBER
9     , x_msg_data out nocopy  VARCHAR2
10     , x_trigger_id out nocopy  NUMBER
11     , p7_a0  NUMBER := 0-1962.0724
12     , p7_a1  DATE := fnd_api.g_miss_date
13     , p7_a2  NUMBER := 0-1962.0724
14     , p7_a3  DATE := fnd_api.g_miss_date
15     , p7_a4  NUMBER := 0-1962.0724
16     , p7_a5  NUMBER := 0-1962.0724
17     , p7_a6  NUMBER := 0-1962.0724
18     , p7_a7  NUMBER := 0-1962.0724
19     , p7_a8  NUMBER := 0-1962.0724
20     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
21     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
22     , p7_a11  NUMBER := 0-1962.0724
23     , p7_a12  NUMBER := 0-1962.0724
24     , p7_a13  DATE := fnd_api.g_miss_date
25     , p7_a14  DATE := fnd_api.g_miss_date
26     , p7_a15  DATE := fnd_api.g_miss_date
27     , p7_a16  DATE := fnd_api.g_miss_date
28     , p7_a17  DATE := fnd_api.g_miss_date
29     , p7_a18  DATE := fnd_api.g_miss_date
30     , p7_a19  DATE := fnd_api.g_miss_date
31     , p7_a20  DATE := fnd_api.g_miss_date
32     , p7_a21  DATE := fnd_api.g_miss_date
33     , p7_a22  DATE := fnd_api.g_miss_date
34     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
35     , p7_a24  NUMBER := 0-1962.0724
36     , p7_a25  DATE := fnd_api.g_miss_date
37     , p7_a26  DATE := fnd_api.g_miss_date
38     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
39     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
40     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
41     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
42     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
43   );
44   procedure update_trigger(p_api_version  NUMBER
45     , p_init_msg_list  VARCHAR2
46     , p_commit  VARCHAR2
47     , p_validation_level  NUMBER
48     , x_return_status out nocopy  VARCHAR2
49     , x_msg_count out nocopy  NUMBER
50     , x_msg_data out nocopy  VARCHAR2
51     , p7_a0  NUMBER := 0-1962.0724
52     , p7_a1  DATE := fnd_api.g_miss_date
53     , p7_a2  NUMBER := 0-1962.0724
54     , p7_a3  DATE := fnd_api.g_miss_date
55     , p7_a4  NUMBER := 0-1962.0724
56     , p7_a5  NUMBER := 0-1962.0724
57     , p7_a6  NUMBER := 0-1962.0724
58     , p7_a7  NUMBER := 0-1962.0724
59     , p7_a8  NUMBER := 0-1962.0724
60     , p7_a9  VARCHAR2 := fnd_api.g_miss_char
61     , p7_a10  VARCHAR2 := fnd_api.g_miss_char
62     , p7_a11  NUMBER := 0-1962.0724
63     , p7_a12  NUMBER := 0-1962.0724
64     , p7_a13  DATE := fnd_api.g_miss_date
65     , p7_a14  DATE := fnd_api.g_miss_date
66     , p7_a15  DATE := fnd_api.g_miss_date
67     , p7_a16  DATE := fnd_api.g_miss_date
68     , p7_a17  DATE := fnd_api.g_miss_date
69     , p7_a18  DATE := fnd_api.g_miss_date
70     , p7_a19  DATE := fnd_api.g_miss_date
71     , p7_a20  DATE := fnd_api.g_miss_date
72     , p7_a21  DATE := fnd_api.g_miss_date
73     , p7_a22  DATE := fnd_api.g_miss_date
74     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a24  NUMBER := 0-1962.0724
76     , p7_a25  DATE := fnd_api.g_miss_date
77     , p7_a26  DATE := fnd_api.g_miss_date
78     , p7_a27  VARCHAR2 := fnd_api.g_miss_char
79     , p7_a28  VARCHAR2 := fnd_api.g_miss_char
80     , p7_a29  VARCHAR2 := fnd_api.g_miss_char
81     , p7_a30  VARCHAR2 := fnd_api.g_miss_char
82     , p7_a31  VARCHAR2 := fnd_api.g_miss_char
83   );
84   procedure validate_trigger(p_api_version  NUMBER
85     , p_init_msg_list  VARCHAR2
86     , p_validation_level  NUMBER
87     , x_return_status out nocopy  VARCHAR2
88     , x_msg_count out nocopy  NUMBER
89     , x_msg_data out nocopy  VARCHAR2
90     , p6_a0  NUMBER := 0-1962.0724
91     , p6_a1  DATE := fnd_api.g_miss_date
92     , p6_a2  NUMBER := 0-1962.0724
93     , p6_a3  DATE := fnd_api.g_miss_date
94     , p6_a4  NUMBER := 0-1962.0724
95     , p6_a5  NUMBER := 0-1962.0724
96     , p6_a6  NUMBER := 0-1962.0724
97     , p6_a7  NUMBER := 0-1962.0724
98     , p6_a8  NUMBER := 0-1962.0724
99     , p6_a9  VARCHAR2 := fnd_api.g_miss_char
100     , p6_a10  VARCHAR2 := fnd_api.g_miss_char
101     , p6_a11  NUMBER := 0-1962.0724
102     , p6_a12  NUMBER := 0-1962.0724
103     , p6_a13  DATE := fnd_api.g_miss_date
104     , p6_a14  DATE := fnd_api.g_miss_date
105     , p6_a15  DATE := fnd_api.g_miss_date
106     , p6_a16  DATE := fnd_api.g_miss_date
107     , p6_a17  DATE := fnd_api.g_miss_date
108     , p6_a18  DATE := fnd_api.g_miss_date
109     , p6_a19  DATE := fnd_api.g_miss_date
110     , p6_a20  DATE := fnd_api.g_miss_date
111     , p6_a21  DATE := fnd_api.g_miss_date
112     , p6_a22  DATE := fnd_api.g_miss_date
113     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
114     , p6_a24  NUMBER := 0-1962.0724
115     , p6_a25  DATE := fnd_api.g_miss_date
116     , p6_a26  DATE := fnd_api.g_miss_date
117     , p6_a27  VARCHAR2 := fnd_api.g_miss_char
118     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
119     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
120     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
121     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
122   );
123   procedure check_trig_items(p_validation_mode  VARCHAR2
124     , x_return_status out nocopy  VARCHAR2
125     , p0_a0  NUMBER := 0-1962.0724
126     , p0_a1  DATE := fnd_api.g_miss_date
127     , p0_a2  NUMBER := 0-1962.0724
128     , p0_a3  DATE := fnd_api.g_miss_date
129     , p0_a4  NUMBER := 0-1962.0724
130     , p0_a5  NUMBER := 0-1962.0724
131     , p0_a6  NUMBER := 0-1962.0724
132     , p0_a7  NUMBER := 0-1962.0724
133     , p0_a8  NUMBER := 0-1962.0724
134     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
135     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
136     , p0_a11  NUMBER := 0-1962.0724
137     , p0_a12  NUMBER := 0-1962.0724
138     , p0_a13  DATE := fnd_api.g_miss_date
139     , p0_a14  DATE := fnd_api.g_miss_date
140     , p0_a15  DATE := fnd_api.g_miss_date
141     , p0_a16  DATE := fnd_api.g_miss_date
142     , p0_a17  DATE := fnd_api.g_miss_date
143     , p0_a18  DATE := fnd_api.g_miss_date
144     , p0_a19  DATE := fnd_api.g_miss_date
145     , p0_a20  DATE := fnd_api.g_miss_date
146     , p0_a21  DATE := fnd_api.g_miss_date
147     , p0_a22  DATE := fnd_api.g_miss_date
148     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
149     , p0_a24  NUMBER := 0-1962.0724
150     , p0_a25  DATE := fnd_api.g_miss_date
151     , p0_a26  DATE := fnd_api.g_miss_date
152     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
153     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
154     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
155     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
156     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
157   );
158   procedure check_trig_record(x_return_status out nocopy  VARCHAR2
159     , p0_a0  NUMBER := 0-1962.0724
160     , p0_a1  DATE := fnd_api.g_miss_date
161     , p0_a2  NUMBER := 0-1962.0724
162     , p0_a3  DATE := fnd_api.g_miss_date
163     , p0_a4  NUMBER := 0-1962.0724
164     , p0_a5  NUMBER := 0-1962.0724
165     , p0_a6  NUMBER := 0-1962.0724
166     , p0_a7  NUMBER := 0-1962.0724
167     , p0_a8  NUMBER := 0-1962.0724
168     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
169     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
170     , p0_a11  NUMBER := 0-1962.0724
171     , p0_a12  NUMBER := 0-1962.0724
172     , p0_a13  DATE := fnd_api.g_miss_date
173     , p0_a14  DATE := fnd_api.g_miss_date
174     , p0_a15  DATE := fnd_api.g_miss_date
175     , p0_a16  DATE := fnd_api.g_miss_date
176     , p0_a17  DATE := fnd_api.g_miss_date
177     , p0_a18  DATE := fnd_api.g_miss_date
178     , p0_a19  DATE := fnd_api.g_miss_date
179     , p0_a20  DATE := fnd_api.g_miss_date
180     , p0_a21  DATE := fnd_api.g_miss_date
181     , p0_a22  DATE := fnd_api.g_miss_date
182     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
183     , p0_a24  NUMBER := 0-1962.0724
184     , p0_a25  DATE := fnd_api.g_miss_date
185     , p0_a26  DATE := fnd_api.g_miss_date
186     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
187     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
188     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
189     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
190     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
191     , p1_a0  NUMBER := 0-1962.0724
192     , p1_a1  DATE := fnd_api.g_miss_date
193     , p1_a2  NUMBER := 0-1962.0724
194     , p1_a3  DATE := fnd_api.g_miss_date
195     , p1_a4  NUMBER := 0-1962.0724
196     , p1_a5  NUMBER := 0-1962.0724
197     , p1_a6  NUMBER := 0-1962.0724
198     , p1_a7  NUMBER := 0-1962.0724
199     , p1_a8  NUMBER := 0-1962.0724
200     , p1_a9  VARCHAR2 := fnd_api.g_miss_char
201     , p1_a10  VARCHAR2 := fnd_api.g_miss_char
202     , p1_a11  NUMBER := 0-1962.0724
203     , p1_a12  NUMBER := 0-1962.0724
204     , p1_a13  DATE := fnd_api.g_miss_date
205     , p1_a14  DATE := fnd_api.g_miss_date
206     , p1_a15  DATE := fnd_api.g_miss_date
207     , p1_a16  DATE := fnd_api.g_miss_date
208     , p1_a17  DATE := fnd_api.g_miss_date
209     , p1_a18  DATE := fnd_api.g_miss_date
210     , p1_a19  DATE := fnd_api.g_miss_date
211     , p1_a20  DATE := fnd_api.g_miss_date
212     , p1_a21  DATE := fnd_api.g_miss_date
213     , p1_a22  DATE := fnd_api.g_miss_date
214     , p1_a23  VARCHAR2 := fnd_api.g_miss_char
215     , p1_a24  NUMBER := 0-1962.0724
216     , p1_a25  DATE := fnd_api.g_miss_date
217     , p1_a26  DATE := fnd_api.g_miss_date
218     , p1_a27  VARCHAR2 := fnd_api.g_miss_char
219     , p1_a28  VARCHAR2 := fnd_api.g_miss_char
220     , p1_a29  VARCHAR2 := fnd_api.g_miss_char
221     , p1_a30  VARCHAR2 := fnd_api.g_miss_char
222     , p1_a31  VARCHAR2 := fnd_api.g_miss_char
223   );
224   procedure check_trig_req_items(x_return_status out nocopy  VARCHAR2
225     , p0_a0  NUMBER := 0-1962.0724
226     , p0_a1  DATE := fnd_api.g_miss_date
227     , p0_a2  NUMBER := 0-1962.0724
228     , p0_a3  DATE := fnd_api.g_miss_date
229     , p0_a4  NUMBER := 0-1962.0724
230     , p0_a5  NUMBER := 0-1962.0724
231     , p0_a6  NUMBER := 0-1962.0724
232     , p0_a7  NUMBER := 0-1962.0724
233     , p0_a8  NUMBER := 0-1962.0724
234     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
235     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
236     , p0_a11  NUMBER := 0-1962.0724
237     , p0_a12  NUMBER := 0-1962.0724
238     , p0_a13  DATE := fnd_api.g_miss_date
239     , p0_a14  DATE := fnd_api.g_miss_date
240     , p0_a15  DATE := fnd_api.g_miss_date
241     , p0_a16  DATE := fnd_api.g_miss_date
242     , p0_a17  DATE := fnd_api.g_miss_date
243     , p0_a18  DATE := fnd_api.g_miss_date
244     , p0_a19  DATE := fnd_api.g_miss_date
245     , p0_a20  DATE := fnd_api.g_miss_date
246     , p0_a21  DATE := fnd_api.g_miss_date
247     , p0_a22  DATE := fnd_api.g_miss_date
248     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
249     , p0_a24  NUMBER := 0-1962.0724
250     , p0_a25  DATE := fnd_api.g_miss_date
251     , p0_a26  DATE := fnd_api.g_miss_date
252     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
253     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
254     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
255     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
256     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
257   );
258   procedure init_trig_rec(p0_a0 out nocopy  NUMBER
259     , p0_a1 out nocopy  DATE
260     , p0_a2 out nocopy  NUMBER
261     , p0_a3 out nocopy  DATE
262     , p0_a4 out nocopy  NUMBER
263     , p0_a5 out nocopy  NUMBER
264     , p0_a6 out nocopy  NUMBER
265     , p0_a7 out nocopy  NUMBER
266     , p0_a8 out nocopy  NUMBER
267     , p0_a9 out nocopy  VARCHAR2
268     , p0_a10 out nocopy  VARCHAR2
269     , p0_a11 out nocopy  NUMBER
270     , p0_a12 out nocopy  NUMBER
271     , p0_a13 out nocopy  DATE
272     , p0_a14 out nocopy  DATE
273     , p0_a15 out nocopy  DATE
274     , p0_a16 out nocopy  DATE
275     , p0_a17 out nocopy  DATE
276     , p0_a18 out nocopy  DATE
277     , p0_a19 out nocopy  DATE
278     , p0_a20 out nocopy  DATE
279     , p0_a21 out nocopy  DATE
280     , p0_a22 out nocopy  DATE
281     , p0_a23 out nocopy  VARCHAR2
282     , p0_a24 out nocopy  NUMBER
283     , p0_a25 out nocopy  DATE
284     , p0_a26 out nocopy  DATE
285     , p0_a27 out nocopy  VARCHAR2
286     , p0_a28 out nocopy  VARCHAR2
287     , p0_a29 out nocopy  VARCHAR2
288     , p0_a30 out nocopy  VARCHAR2
289     , p0_a31 out nocopy  VARCHAR2
290   );
291   procedure complete_trig_rec(p1_a0 out nocopy  NUMBER
292     , p1_a1 out nocopy  DATE
293     , p1_a2 out nocopy  NUMBER
294     , p1_a3 out nocopy  DATE
295     , p1_a4 out nocopy  NUMBER
296     , p1_a5 out nocopy  NUMBER
297     , p1_a6 out nocopy  NUMBER
298     , p1_a7 out nocopy  NUMBER
299     , p1_a8 out nocopy  NUMBER
300     , p1_a9 out nocopy  VARCHAR2
301     , p1_a10 out nocopy  VARCHAR2
302     , p1_a11 out nocopy  NUMBER
303     , p1_a12 out nocopy  NUMBER
304     , p1_a13 out nocopy  DATE
305     , p1_a14 out nocopy  DATE
306     , p1_a15 out nocopy  DATE
307     , p1_a16 out nocopy  DATE
308     , p1_a17 out nocopy  DATE
309     , p1_a18 out nocopy  DATE
310     , p1_a19 out nocopy  DATE
311     , p1_a20 out nocopy  DATE
312     , p1_a21 out nocopy  DATE
313     , p1_a22 out nocopy  DATE
314     , p1_a23 out nocopy  VARCHAR2
315     , p1_a24 out nocopy  NUMBER
316     , p1_a25 out nocopy  DATE
317     , p1_a26 out nocopy  DATE
318     , p1_a27 out nocopy  VARCHAR2
319     , p1_a28 out nocopy  VARCHAR2
320     , p1_a29 out nocopy  VARCHAR2
321     , p1_a30 out nocopy  VARCHAR2
322     , p1_a31 out nocopy  VARCHAR2
323     , p0_a0  NUMBER := 0-1962.0724
324     , p0_a1  DATE := fnd_api.g_miss_date
325     , p0_a2  NUMBER := 0-1962.0724
326     , p0_a3  DATE := fnd_api.g_miss_date
327     , p0_a4  NUMBER := 0-1962.0724
328     , p0_a5  NUMBER := 0-1962.0724
329     , p0_a6  NUMBER := 0-1962.0724
333     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
330     , p0_a7  NUMBER := 0-1962.0724
331     , p0_a8  NUMBER := 0-1962.0724
332     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
334     , p0_a11  NUMBER := 0-1962.0724
335     , p0_a12  NUMBER := 0-1962.0724
336     , p0_a13  DATE := fnd_api.g_miss_date
337     , p0_a14  DATE := fnd_api.g_miss_date
338     , p0_a15  DATE := fnd_api.g_miss_date
339     , p0_a16  DATE := fnd_api.g_miss_date
340     , p0_a17  DATE := fnd_api.g_miss_date
341     , p0_a18  DATE := fnd_api.g_miss_date
342     , p0_a19  DATE := fnd_api.g_miss_date
343     , p0_a20  DATE := fnd_api.g_miss_date
344     , p0_a21  DATE := fnd_api.g_miss_date
345     , p0_a22  DATE := fnd_api.g_miss_date
346     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
347     , p0_a24  NUMBER := 0-1962.0724
348     , p0_a25  DATE := fnd_api.g_miss_date
349     , p0_a26  DATE := fnd_api.g_miss_date
350     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
351     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
352     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
353     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
354     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
355   );
356 end ams_trig_pvt_w;