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_THLDCHK_PVT_W

Source


1 package ams_thldchk_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswthcs.pls 115.1 2003/07/03 14:25:02 cgoyal noship $ */
3   procedure create_thldchk(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_check_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  VARCHAR2 := fnd_api.g_miss_char
24     , p7_a13  NUMBER := 0-1962.0724
25     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
26     , p7_a15  NUMBER := 0-1962.0724
27     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
28     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
29     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
30     , p7_a19  NUMBER := 0-1962.0724
31     , p7_a20  NUMBER := 0-1962.0724
32     , p7_a21  NUMBER := 0-1962.0724
33     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
34     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
35     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
36     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
37     , p7_a26  NUMBER := 0-1962.0724
38     , p7_a27  NUMBER := 0-1962.0724
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_thldchk(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  VARCHAR2 := fnd_api.g_miss_char
64     , p7_a13  NUMBER := 0-1962.0724
65     , p7_a14  VARCHAR2 := fnd_api.g_miss_char
66     , p7_a15  NUMBER := 0-1962.0724
67     , p7_a16  VARCHAR2 := fnd_api.g_miss_char
68     , p7_a17  VARCHAR2 := fnd_api.g_miss_char
69     , p7_a18  VARCHAR2 := fnd_api.g_miss_char
70     , p7_a19  NUMBER := 0-1962.0724
71     , p7_a20  NUMBER := 0-1962.0724
72     , p7_a21  NUMBER := 0-1962.0724
73     , p7_a22  VARCHAR2 := fnd_api.g_miss_char
74     , p7_a23  VARCHAR2 := fnd_api.g_miss_char
75     , p7_a24  VARCHAR2 := fnd_api.g_miss_char
76     , p7_a25  VARCHAR2 := fnd_api.g_miss_char
77     , p7_a26  NUMBER := 0-1962.0724
78     , p7_a27  NUMBER := 0-1962.0724
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_thldchk(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  VARCHAR2 := fnd_api.g_miss_char
103     , p6_a13  NUMBER := 0-1962.0724
104     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
105     , p6_a15  NUMBER := 0-1962.0724
106     , p6_a16  VARCHAR2 := fnd_api.g_miss_char
107     , p6_a17  VARCHAR2 := fnd_api.g_miss_char
108     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
109     , p6_a19  NUMBER := 0-1962.0724
110     , p6_a20  NUMBER := 0-1962.0724
111     , p6_a21  NUMBER := 0-1962.0724
112     , p6_a22  VARCHAR2 := fnd_api.g_miss_char
113     , p6_a23  VARCHAR2 := fnd_api.g_miss_char
114     , p6_a24  VARCHAR2 := fnd_api.g_miss_char
115     , p6_a25  VARCHAR2 := fnd_api.g_miss_char
116     , p6_a26  NUMBER := 0-1962.0724
117     , p6_a27  NUMBER := 0-1962.0724
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_thldchk_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  VARCHAR2 := fnd_api.g_miss_char
138     , p0_a13  NUMBER := 0-1962.0724
139     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
140     , p0_a15  NUMBER := 0-1962.0724
141     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
142     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
143     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
144     , p0_a19  NUMBER := 0-1962.0724
145     , p0_a20  NUMBER := 0-1962.0724
146     , p0_a21  NUMBER := 0-1962.0724
147     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
148     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
149     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
150     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
151     , p0_a26  NUMBER := 0-1962.0724
152     , p0_a27  NUMBER := 0-1962.0724
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_thldchk_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  VARCHAR2 := fnd_api.g_miss_char
172     , p0_a13  NUMBER := 0-1962.0724
173     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
174     , p0_a15  NUMBER := 0-1962.0724
175     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
176     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
177     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
178     , p0_a19  NUMBER := 0-1962.0724
179     , p0_a20  NUMBER := 0-1962.0724
180     , p0_a21  NUMBER := 0-1962.0724
181     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
182     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
183     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
184     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
185     , p0_a26  NUMBER := 0-1962.0724
186     , p0_a27  NUMBER := 0-1962.0724
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  VARCHAR2 := fnd_api.g_miss_char
204     , p1_a13  NUMBER := 0-1962.0724
205     , p1_a14  VARCHAR2 := fnd_api.g_miss_char
206     , p1_a15  NUMBER := 0-1962.0724
207     , p1_a16  VARCHAR2 := fnd_api.g_miss_char
208     , p1_a17  VARCHAR2 := fnd_api.g_miss_char
209     , p1_a18  VARCHAR2 := fnd_api.g_miss_char
210     , p1_a19  NUMBER := 0-1962.0724
211     , p1_a20  NUMBER := 0-1962.0724
212     , p1_a21  NUMBER := 0-1962.0724
213     , p1_a22  VARCHAR2 := fnd_api.g_miss_char
214     , p1_a23  VARCHAR2 := fnd_api.g_miss_char
215     , p1_a24  VARCHAR2 := fnd_api.g_miss_char
216     , p1_a25  VARCHAR2 := fnd_api.g_miss_char
217     , p1_a26  NUMBER := 0-1962.0724
218     , p1_a27  NUMBER := 0-1962.0724
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 init_thldchk_rec(p0_a0 out nocopy  NUMBER
225     , p0_a1 out nocopy  DATE
226     , p0_a2 out nocopy  NUMBER
227     , p0_a3 out nocopy  DATE
228     , p0_a4 out nocopy  NUMBER
229     , p0_a5 out nocopy  NUMBER
230     , p0_a6 out nocopy  NUMBER
231     , p0_a7 out nocopy  NUMBER
232     , p0_a8 out nocopy  NUMBER
233     , p0_a9 out nocopy  VARCHAR2
234     , p0_a10 out nocopy  VARCHAR2
235     , p0_a11 out nocopy  NUMBER
236     , p0_a12 out nocopy  VARCHAR2
237     , p0_a13 out nocopy  NUMBER
238     , p0_a14 out nocopy  VARCHAR2
239     , p0_a15 out nocopy  NUMBER
240     , p0_a16 out nocopy  VARCHAR2
241     , p0_a17 out nocopy  VARCHAR2
242     , p0_a18 out nocopy  VARCHAR2
243     , p0_a19 out nocopy  NUMBER
244     , p0_a20 out nocopy  NUMBER
245     , p0_a21 out nocopy  NUMBER
246     , p0_a22 out nocopy  VARCHAR2
247     , p0_a23 out nocopy  VARCHAR2
248     , p0_a24 out nocopy  VARCHAR2
249     , p0_a25 out nocopy  VARCHAR2
250     , p0_a26 out nocopy  NUMBER
251     , p0_a27 out nocopy  NUMBER
252     , p0_a28 out nocopy  VARCHAR2
253     , p0_a29 out nocopy  VARCHAR2
254     , p0_a30 out nocopy  VARCHAR2
255     , p0_a31 out nocopy  VARCHAR2
256   );
257   procedure complete_thldchk_rec(p1_a0 out nocopy  NUMBER
258     , p1_a1 out nocopy  DATE
259     , p1_a2 out nocopy  NUMBER
260     , p1_a3 out nocopy  DATE
261     , p1_a4 out nocopy  NUMBER
262     , p1_a5 out nocopy  NUMBER
263     , p1_a6 out nocopy  NUMBER
264     , p1_a7 out nocopy  NUMBER
265     , p1_a8 out nocopy  NUMBER
266     , p1_a9 out nocopy  VARCHAR2
267     , p1_a10 out nocopy  VARCHAR2
268     , p1_a11 out nocopy  NUMBER
269     , p1_a12 out nocopy  VARCHAR2
270     , p1_a13 out nocopy  NUMBER
271     , p1_a14 out nocopy  VARCHAR2
272     , p1_a15 out nocopy  NUMBER
273     , p1_a16 out nocopy  VARCHAR2
274     , p1_a17 out nocopy  VARCHAR2
275     , p1_a18 out nocopy  VARCHAR2
276     , p1_a19 out nocopy  NUMBER
277     , p1_a20 out nocopy  NUMBER
278     , p1_a21 out nocopy  NUMBER
279     , p1_a22 out nocopy  VARCHAR2
280     , p1_a23 out nocopy  VARCHAR2
281     , p1_a24 out nocopy  VARCHAR2
282     , p1_a25 out nocopy  VARCHAR2
283     , p1_a26 out nocopy  NUMBER
284     , p1_a27 out nocopy  NUMBER
285     , p1_a28 out nocopy  VARCHAR2
286     , p1_a29 out nocopy  VARCHAR2
287     , p1_a30 out nocopy  VARCHAR2
288     , p1_a31 out nocopy  VARCHAR2
289     , p0_a0  NUMBER := 0-1962.0724
290     , p0_a1  DATE := fnd_api.g_miss_date
291     , p0_a2  NUMBER := 0-1962.0724
292     , p0_a3  DATE := fnd_api.g_miss_date
293     , p0_a4  NUMBER := 0-1962.0724
294     , p0_a5  NUMBER := 0-1962.0724
295     , p0_a6  NUMBER := 0-1962.0724
299     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
296     , p0_a7  NUMBER := 0-1962.0724
297     , p0_a8  NUMBER := 0-1962.0724
298     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
300     , p0_a11  NUMBER := 0-1962.0724
301     , p0_a12  VARCHAR2 := fnd_api.g_miss_char
302     , p0_a13  NUMBER := 0-1962.0724
303     , p0_a14  VARCHAR2 := fnd_api.g_miss_char
304     , p0_a15  NUMBER := 0-1962.0724
305     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
306     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
307     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
308     , p0_a19  NUMBER := 0-1962.0724
309     , p0_a20  NUMBER := 0-1962.0724
310     , p0_a21  NUMBER := 0-1962.0724
311     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
312     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
313     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
314     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
315     , p0_a26  NUMBER := 0-1962.0724
316     , p0_a27  NUMBER := 0-1962.0724
317     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
318     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
319     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
320     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
321   );
322 end ams_thldchk_pvt_w;