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.CSI_SYSTEMS_PUB_W

Source


1 package csi_systems_pub_w AUTHID CURRENT_USER as
2   /* $Header: csipsyws.pls 120.10 2008/01/15 03:35:02 devijay ship $ */
3   procedure get_systems(p_api_version  NUMBER
4     , p_commit  VARCHAR2
5     , p_init_msg_list  VARCHAR2
6     , p_validation_level  NUMBER
7     , p_time_stamp  date
8     , p_active_systems_only  VARCHAR2
9     , p7_a0 out nocopy JTF_NUMBER_TABLE
10     , p7_a1 out nocopy JTF_NUMBER_TABLE
11     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
12     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
13     , p7_a4 out nocopy JTF_NUMBER_TABLE
14     , p7_a5 out nocopy JTF_NUMBER_TABLE
15     , p7_a6 out nocopy JTF_NUMBER_TABLE
16     , p7_a7 out nocopy JTF_NUMBER_TABLE
17     , p7_a8 out nocopy JTF_NUMBER_TABLE
18     , p7_a9 out nocopy JTF_NUMBER_TABLE
19     , p7_a10 out nocopy JTF_NUMBER_TABLE
20     , p7_a11 out nocopy JTF_NUMBER_TABLE
21     , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
22     , p7_a13 out nocopy JTF_NUMBER_TABLE
23     , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
24     , p7_a15 out nocopy JTF_DATE_TABLE
25     , p7_a16 out nocopy JTF_DATE_TABLE
26     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
27     , p7_a18 out nocopy JTF_VARCHAR2_TABLE_300
28     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
29     , p7_a20 out nocopy JTF_VARCHAR2_TABLE_300
30     , p7_a21 out nocopy JTF_VARCHAR2_TABLE_300
31     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_300
32     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
33     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_300
34     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_300
35     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_300
36     , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
37     , p7_a28 out nocopy JTF_VARCHAR2_TABLE_300
38     , p7_a29 out nocopy JTF_VARCHAR2_TABLE_300
39     , p7_a30 out nocopy JTF_VARCHAR2_TABLE_300
40     , p7_a31 out nocopy JTF_VARCHAR2_TABLE_300
41     , p7_a32 out nocopy JTF_VARCHAR2_TABLE_300
42     , p7_a33 out nocopy JTF_NUMBER_TABLE
43     , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
44     , p7_a35 out nocopy JTF_VARCHAR2_TABLE_300
45     , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
46     , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
47     , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
48     , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
49     , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
50     , p7_a41 out nocopy JTF_VARCHAR2_TABLE_100
51     , p7_a42 out nocopy JTF_VARCHAR2_TABLE_100
52     , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
53     , p7_a44 out nocopy JTF_NUMBER_TABLE
54     , p7_a45 out nocopy JTF_NUMBER_TABLE
55     , p7_a46 out nocopy JTF_NUMBER_TABLE
56     , p7_a47 out nocopy JTF_NUMBER_TABLE
57     , p7_a48 out nocopy JTF_DATE_TABLE
58     , x_return_status out nocopy  VARCHAR2
59     , x_msg_count out nocopy  NUMBER
60     , x_msg_data out nocopy  VARCHAR2
61     , p4_a0  NUMBER := 0-1962.0724
62     , p4_a1  VARCHAR2 := fnd_api.g_miss_char
63     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
64   );
65   procedure create_system(p_api_version  NUMBER
66     , p_commit  VARCHAR2
67     , p_init_msg_list  VARCHAR2
68     , p_validation_level  NUMBER
69     , p5_a0 in out nocopy  NUMBER
70     , p5_a1 in out nocopy  DATE
71     , p5_a2 in out nocopy  DATE
72     , p5_a3 in out nocopy  NUMBER
73     , p5_a4 in out nocopy  NUMBER
74     , p5_a5 in out nocopy  NUMBER
75     , p5_a6 in out nocopy  VARCHAR2
76     , p5_a7 in out nocopy  NUMBER
77     , p5_a8 in out nocopy  VARCHAR2
78     , p5_a9 in out nocopy  NUMBER
79     , p5_a10 in out nocopy  VARCHAR2
80     , p5_a11 in out nocopy  NUMBER
81     , p5_a12 in out nocopy  NUMBER
82     , p5_a13 in out nocopy  NUMBER
83     , p5_a14 in out nocopy  NUMBER
84     , p5_a15 in out nocopy  VARCHAR2
85     , p5_a16 in out nocopy  NUMBER
86     , p5_a17 in out nocopy  VARCHAR2
87     , p5_a18 in out nocopy  VARCHAR2
88     , p5_a19 in out nocopy  NUMBER
89     , p5_a20 in out nocopy  VARCHAR2
90     , p5_a21 in out nocopy  VARCHAR2
91     , p5_a22 in out nocopy  VARCHAR2
92     , p5_a23 in out nocopy  VARCHAR2
93     , p5_a24 in out nocopy  VARCHAR2
94     , p5_a25 in out nocopy  VARCHAR2
95     , p5_a26 in out nocopy  VARCHAR2
96     , p5_a27 in out nocopy  VARCHAR2
97     , p5_a28 in out nocopy  VARCHAR2
98     , p5_a29 in out nocopy  VARCHAR2
99     , p5_a30 in out nocopy  VARCHAR2
100     , p5_a31 in out nocopy  VARCHAR2
101     , p5_a32 in out nocopy  VARCHAR2
102     , p5_a33 in out nocopy  VARCHAR2
103     , p5_a34 in out nocopy  VARCHAR2
104     , p5_a35 in out nocopy  VARCHAR2
105     , p5_a36 in out nocopy  NUMBER
106     , p5_a37 in out nocopy  VARCHAR2
107     , p5_a38 in out nocopy  DATE
108     , p5_a39 in out nocopy  NUMBER
109     , x_system_id out nocopy  NUMBER
110     , x_return_status out nocopy  VARCHAR2
111     , x_msg_count out nocopy  NUMBER
112     , x_msg_data out nocopy  VARCHAR2
113     , p4_a0  NUMBER := 0-1962.0724
114     , p4_a1  NUMBER := 0-1962.0724
115     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
116     , p4_a3  VARCHAR2 := fnd_api.g_miss_char
117     , p4_a4  NUMBER := 0-1962.0724
118     , p4_a5  NUMBER := 0-1962.0724
119     , p4_a6  NUMBER := 0-1962.0724
120     , p4_a7  NUMBER := 0-1962.0724
121     , p4_a8  NUMBER := 0-1962.0724
122     , p4_a9  NUMBER := 0-1962.0724
123     , p4_a10  NUMBER := 0-1962.0724
124     , p4_a11  NUMBER := 0-1962.0724
125     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
126     , p4_a13  NUMBER := 0-1962.0724
127     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
128     , p4_a15  DATE := fnd_api.g_miss_date
129     , p4_a16  DATE := fnd_api.g_miss_date
130     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
131     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
132     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
133     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
134     , p4_a21  VARCHAR2 := fnd_api.g_miss_char
135     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
136     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
137     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
138     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
139     , p4_a26  VARCHAR2 := fnd_api.g_miss_char
140     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
141     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
142     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
143     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
144     , p4_a31  VARCHAR2 := fnd_api.g_miss_char
145     , p4_a32  VARCHAR2 := fnd_api.g_miss_char
146     , p4_a33  NUMBER := 0-1962.0724
147     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
148     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
149     , p4_a36  VARCHAR2 := fnd_api.g_miss_char
150     , p4_a37  VARCHAR2 := fnd_api.g_miss_char
151     , p4_a38  VARCHAR2 := fnd_api.g_miss_char
152     , p4_a39  VARCHAR2 := fnd_api.g_miss_char
153     , p4_a40  VARCHAR2 := fnd_api.g_miss_char
154     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
155     , p4_a42  VARCHAR2 := fnd_api.g_miss_char
156     , p4_a43  VARCHAR2 := fnd_api.g_miss_char
157     , p4_a44  NUMBER := 0-1962.0724
158     , p4_a45  NUMBER := 0-1962.0724
159     , p4_a46  NUMBER := 0-1962.0724
160     , p4_a47  NUMBER := 0-1962.0724
161     , p4_a48  DATE := fnd_api.g_miss_date
162   );
163   procedure update_system(p_api_version  NUMBER
164     , p_commit  VARCHAR2
165     , p_init_msg_list  VARCHAR2
166     , p_validation_level  NUMBER
167     , p5_a0 in out nocopy  NUMBER
168     , p5_a1 in out nocopy  DATE
169     , p5_a2 in out nocopy  DATE
170     , p5_a3 in out nocopy  NUMBER
171     , p5_a4 in out nocopy  NUMBER
172     , p5_a5 in out nocopy  NUMBER
173     , p5_a6 in out nocopy  VARCHAR2
174     , p5_a7 in out nocopy  NUMBER
175     , p5_a8 in out nocopy  VARCHAR2
176     , p5_a9 in out nocopy  NUMBER
177     , p5_a10 in out nocopy  VARCHAR2
178     , p5_a11 in out nocopy  NUMBER
179     , p5_a12 in out nocopy  NUMBER
180     , p5_a13 in out nocopy  NUMBER
181     , p5_a14 in out nocopy  NUMBER
182     , p5_a15 in out nocopy  VARCHAR2
183     , p5_a16 in out nocopy  NUMBER
184     , p5_a17 in out nocopy  VARCHAR2
185     , p5_a18 in out nocopy  VARCHAR2
186     , p5_a19 in out nocopy  NUMBER
187     , p5_a20 in out nocopy  VARCHAR2
188     , p5_a21 in out nocopy  VARCHAR2
189     , p5_a22 in out nocopy  VARCHAR2
190     , p5_a23 in out nocopy  VARCHAR2
191     , p5_a24 in out nocopy  VARCHAR2
192     , p5_a25 in out nocopy  VARCHAR2
193     , p5_a26 in out nocopy  VARCHAR2
194     , p5_a27 in out nocopy  VARCHAR2
195     , p5_a28 in out nocopy  VARCHAR2
196     , p5_a29 in out nocopy  VARCHAR2
197     , p5_a30 in out nocopy  VARCHAR2
198     , p5_a31 in out nocopy  VARCHAR2
199     , p5_a32 in out nocopy  VARCHAR2
200     , p5_a33 in out nocopy  VARCHAR2
201     , p5_a34 in out nocopy  VARCHAR2
202     , p5_a35 in out nocopy  VARCHAR2
203     , p5_a36 in out nocopy  NUMBER
204     , p5_a37 in out nocopy  VARCHAR2
205     , p5_a38 in out nocopy  DATE
206     , p5_a39 in out nocopy  NUMBER
207     , x_return_status out nocopy  VARCHAR2
208     , x_msg_count out nocopy  NUMBER
209     , x_msg_data out nocopy  VARCHAR2
210     , p4_a0  NUMBER := 0-1962.0724
211     , p4_a1  NUMBER := 0-1962.0724
212     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
213     , p4_a3  VARCHAR2 := fnd_api.g_miss_char
214     , p4_a4  NUMBER := 0-1962.0724
215     , p4_a5  NUMBER := 0-1962.0724
216     , p4_a6  NUMBER := 0-1962.0724
217     , p4_a7  NUMBER := 0-1962.0724
218     , p4_a8  NUMBER := 0-1962.0724
219     , p4_a9  NUMBER := 0-1962.0724
220     , p4_a10  NUMBER := 0-1962.0724
221     , p4_a11  NUMBER := 0-1962.0724
222     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
223     , p4_a13  NUMBER := 0-1962.0724
224     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
225     , p4_a15  DATE := fnd_api.g_miss_date
226     , p4_a16  DATE := fnd_api.g_miss_date
227     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
228     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
229     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
230     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
231     , p4_a21  VARCHAR2 := fnd_api.g_miss_char
232     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
233     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
234     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
235     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
236     , p4_a26  VARCHAR2 := fnd_api.g_miss_char
237     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
238     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
239     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
240     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
241     , p4_a31  VARCHAR2 := fnd_api.g_miss_char
242     , p4_a32  VARCHAR2 := fnd_api.g_miss_char
243     , p4_a33  NUMBER := 0-1962.0724
244     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
245     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
246     , p4_a36  VARCHAR2 := fnd_api.g_miss_char
247     , p4_a37  VARCHAR2 := fnd_api.g_miss_char
248     , p4_a38  VARCHAR2 := fnd_api.g_miss_char
249     , p4_a39  VARCHAR2 := fnd_api.g_miss_char
250     , p4_a40  VARCHAR2 := fnd_api.g_miss_char
251     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
252     , p4_a42  VARCHAR2 := fnd_api.g_miss_char
253     , p4_a43  VARCHAR2 := fnd_api.g_miss_char
254     , p4_a44  NUMBER := 0-1962.0724
255     , p4_a45  NUMBER := 0-1962.0724
256     , p4_a46  NUMBER := 0-1962.0724
257     , p4_a47  NUMBER := 0-1962.0724
258     , p4_a48  DATE := fnd_api.g_miss_date
259   );
260   procedure expire_system(p_api_version  NUMBER
261     , p_commit  VARCHAR2
262     , p_init_msg_list  VARCHAR2
263     , p_validation_level  NUMBER
264     , p5_a0 in out nocopy  NUMBER
265     , p5_a1 in out nocopy  DATE
266     , p5_a2 in out nocopy  DATE
267     , p5_a3 in out nocopy  NUMBER
268     , p5_a4 in out nocopy  NUMBER
269     , p5_a5 in out nocopy  NUMBER
270     , p5_a6 in out nocopy  VARCHAR2
271     , p5_a7 in out nocopy  NUMBER
272     , p5_a8 in out nocopy  VARCHAR2
273     , p5_a9 in out nocopy  NUMBER
274     , p5_a10 in out nocopy  VARCHAR2
275     , p5_a11 in out nocopy  NUMBER
276     , p5_a12 in out nocopy  NUMBER
277     , p5_a13 in out nocopy  NUMBER
278     , p5_a14 in out nocopy  NUMBER
279     , p5_a15 in out nocopy  VARCHAR2
280     , p5_a16 in out nocopy  NUMBER
281     , p5_a17 in out nocopy  VARCHAR2
282     , p5_a18 in out nocopy  VARCHAR2
283     , p5_a19 in out nocopy  NUMBER
284     , p5_a20 in out nocopy  VARCHAR2
285     , p5_a21 in out nocopy  VARCHAR2
286     , p5_a22 in out nocopy  VARCHAR2
287     , p5_a23 in out nocopy  VARCHAR2
288     , p5_a24 in out nocopy  VARCHAR2
289     , p5_a25 in out nocopy  VARCHAR2
290     , p5_a26 in out nocopy  VARCHAR2
291     , p5_a27 in out nocopy  VARCHAR2
292     , p5_a28 in out nocopy  VARCHAR2
293     , p5_a29 in out nocopy  VARCHAR2
294     , p5_a30 in out nocopy  VARCHAR2
295     , p5_a31 in out nocopy  VARCHAR2
296     , p5_a32 in out nocopy  VARCHAR2
297     , p5_a33 in out nocopy  VARCHAR2
298     , p5_a34 in out nocopy  VARCHAR2
299     , p5_a35 in out nocopy  VARCHAR2
300     , p5_a36 in out nocopy  NUMBER
301     , p5_a37 in out nocopy  VARCHAR2
302     , p5_a38 in out nocopy  DATE
303     , p5_a39 in out nocopy  NUMBER
304     , x_instance_id_lst out nocopy JTF_NUMBER_TABLE
305     , x_return_status out nocopy  VARCHAR2
306     , x_msg_count out nocopy  NUMBER
307     , x_msg_data out nocopy  VARCHAR2
308     , p4_a0  NUMBER := 0-1962.0724
309     , p4_a1  NUMBER := 0-1962.0724
310     , p4_a2  VARCHAR2 := fnd_api.g_miss_char
311     , p4_a3  VARCHAR2 := fnd_api.g_miss_char
312     , p4_a4  NUMBER := 0-1962.0724
313     , p4_a5  NUMBER := 0-1962.0724
314     , p4_a6  NUMBER := 0-1962.0724
315     , p4_a7  NUMBER := 0-1962.0724
316     , p4_a8  NUMBER := 0-1962.0724
317     , p4_a9  NUMBER := 0-1962.0724
318     , p4_a10  NUMBER := 0-1962.0724
319     , p4_a11  NUMBER := 0-1962.0724
320     , p4_a12  VARCHAR2 := fnd_api.g_miss_char
321     , p4_a13  NUMBER := 0-1962.0724
322     , p4_a14  VARCHAR2 := fnd_api.g_miss_char
323     , p4_a15  DATE := fnd_api.g_miss_date
324     , p4_a16  DATE := fnd_api.g_miss_date
325     , p4_a17  VARCHAR2 := fnd_api.g_miss_char
326     , p4_a18  VARCHAR2 := fnd_api.g_miss_char
327     , p4_a19  VARCHAR2 := fnd_api.g_miss_char
328     , p4_a20  VARCHAR2 := fnd_api.g_miss_char
329     , p4_a21  VARCHAR2 := fnd_api.g_miss_char
330     , p4_a22  VARCHAR2 := fnd_api.g_miss_char
331     , p4_a23  VARCHAR2 := fnd_api.g_miss_char
332     , p4_a24  VARCHAR2 := fnd_api.g_miss_char
333     , p4_a25  VARCHAR2 := fnd_api.g_miss_char
334     , p4_a26  VARCHAR2 := fnd_api.g_miss_char
335     , p4_a27  VARCHAR2 := fnd_api.g_miss_char
336     , p4_a28  VARCHAR2 := fnd_api.g_miss_char
337     , p4_a29  VARCHAR2 := fnd_api.g_miss_char
338     , p4_a30  VARCHAR2 := fnd_api.g_miss_char
339     , p4_a31  VARCHAR2 := fnd_api.g_miss_char
340     , p4_a32  VARCHAR2 := fnd_api.g_miss_char
341     , p4_a33  NUMBER := 0-1962.0724
342     , p4_a34  VARCHAR2 := fnd_api.g_miss_char
343     , p4_a35  VARCHAR2 := fnd_api.g_miss_char
344     , p4_a36  VARCHAR2 := fnd_api.g_miss_char
345     , p4_a37  VARCHAR2 := fnd_api.g_miss_char
346     , p4_a38  VARCHAR2 := fnd_api.g_miss_char
347     , p4_a39  VARCHAR2 := fnd_api.g_miss_char
348     , p4_a40  VARCHAR2 := fnd_api.g_miss_char
349     , p4_a41  VARCHAR2 := fnd_api.g_miss_char
350     , p4_a42  VARCHAR2 := fnd_api.g_miss_char
351     , p4_a43  VARCHAR2 := fnd_api.g_miss_char
352     , p4_a44  NUMBER := 0-1962.0724
353     , p4_a45  NUMBER := 0-1962.0724
354     , p4_a46  NUMBER := 0-1962.0724
355     , p4_a47  NUMBER := 0-1962.0724
356     , p4_a48  DATE := fnd_api.g_miss_date
357   );
358 end csi_systems_pub_w;