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

Source


1 package xdp_interfaces_pub_w as
2   /* $Header: XDPINPWS.pls 120.1 2005/06/22 07:14:34 appldev ship $ */
3   procedure process_order(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     , p7_a0  VARCHAR2
11     , p7_a1  VARCHAR2
12     , p7_a2  DATE
13     , p7_a3  NUMBER
14     , p7_a4  DATE
15     , p7_a5  DATE
16     , p7_a6  VARCHAR2
17     , p7_a7  VARCHAR2
18     , p7_a8  VARCHAR2
19     , p7_a9  NUMBER
20     , p7_a10  NUMBER
21     , p7_a11  VARCHAR2
22     , p7_a12  NUMBER
23     , p7_a13  NUMBER
24     , p7_a14  VARCHAR2
25     , p7_a15  VARCHAR2
26     , p7_a16  VARCHAR2
27     , p7_a17  DATE
28     , p7_a18  DATE
29     , p7_a19  NUMBER
30     , p7_a20  NUMBER
31     , p7_a21  NUMBER
32     , p7_a22  VARCHAR2
33     , p7_a23  VARCHAR2
34     , p7_a24  VARCHAR2
35     , p7_a25  VARCHAR2
36     , p7_a26  NUMBER
37     , p8_a0 JTF_VARCHAR2_TABLE_100
38     , p8_a1 JTF_VARCHAR2_TABLE_4000
39     , p9_a0 JTF_NUMBER_TABLE
40     , p9_a1 JTF_VARCHAR2_TABLE_100
41     , p9_a2 JTF_VARCHAR2_TABLE_100
42     , p9_a3 JTF_VARCHAR2_TABLE_100
43     , p9_a4 JTF_VARCHAR2_TABLE_100
44     , p9_a5 JTF_DATE_TABLE
45     , p9_a6 JTF_VARCHAR2_TABLE_100
46     , p9_a7 JTF_NUMBER_TABLE
47     , p9_a8 JTF_NUMBER_TABLE
48     , p9_a9 JTF_NUMBER_TABLE
49     , p9_a10 JTF_NUMBER_TABLE
50     , p9_a11 JTF_DATE_TABLE
51     , p9_a12 JTF_DATE_TABLE
52     , p9_a13 JTF_VARCHAR2_TABLE_100
53     , p9_a14 JTF_DATE_TABLE
54     , p9_a15 JTF_NUMBER_TABLE
55     , p9_a16 JTF_NUMBER_TABLE
56     , p9_a17 JTF_NUMBER_TABLE
57     , p9_a18 JTF_VARCHAR2_TABLE_100
58     , p9_a19 JTF_NUMBER_TABLE
59     , p9_a20 JTF_VARCHAR2_TABLE_100
60     , p9_a21 JTF_NUMBER_TABLE
61     , p9_a22 JTF_NUMBER_TABLE
62     , p10_a0 JTF_NUMBER_TABLE
63     , p10_a1 JTF_VARCHAR2_TABLE_100
64     , p10_a2 JTF_VARCHAR2_TABLE_4000
65     , p10_a3 JTF_VARCHAR2_TABLE_4000
66     , x_sdp_order_id OUT NOCOPY  NUMBER
67   );
68   procedure process_order(p_api_version  NUMBER
69     , p_init_msg_list  VARCHAR2
70     , p_commit  VARCHAR2
71     , p_validation_level  NUMBER
72     , x_return_status OUT NOCOPY  VARCHAR2
73     , x_msg_count OUT NOCOPY  NUMBER
74     , x_msg_data OUT NOCOPY  VARCHAR2
75     , x_error_code OUT NOCOPY  VARCHAR2
76     , p8_a0  VARCHAR2
77     , p8_a1  VARCHAR2
78     , p8_a2  DATE
79     , p8_a3  NUMBER
80     , p8_a4  VARCHAR2
81     , p8_a5  VARCHAR2
82     , p8_a6  VARCHAR2
83     , p8_a7  NUMBER
84     , p8_a8  DATE
85     , p8_a9  DATE
86     , p8_a10  VARCHAR2
87     , p8_a11  VARCHAR2
88     , p8_a12  NUMBER
89     , p8_a13  NUMBER
90     , p8_a14  NUMBER
91     , p8_a15  NUMBER
92     , p8_a16  VARCHAR2
93     , p8_a17  VARCHAR2
94     , p8_a18  VARCHAR2
95     , p8_a19  NUMBER
96     , p8_a20  VARCHAR2
97     , p8_a21  VARCHAR2
98     , p8_a22  VARCHAR2
99     , p8_a23  DATE
100     , p8_a24  DATE
101     , p8_a25  NUMBER
102     , p8_a26  VARCHAR2
103     , p8_a27  VARCHAR2
104     , p8_a28  VARCHAR2
105     , p8_a29  VARCHAR2
106     , p8_a30  VARCHAR2
107     , p8_a31  VARCHAR2
108     , p8_a32  VARCHAR2
109     , p8_a33  VARCHAR2
110     , p8_a34  VARCHAR2
111     , p8_a35  VARCHAR2
112     , p8_a36  VARCHAR2
113     , p8_a37  VARCHAR2
114     , p8_a38  VARCHAR2
115     , p8_a39  VARCHAR2
116     , p8_a40  VARCHAR2
117     , p8_a41  VARCHAR2
118     , p8_a42  VARCHAR2
119     , p8_a43  VARCHAR2
120     , p8_a44  VARCHAR2
121     , p8_a45  VARCHAR2
122     , p8_a46  VARCHAR2
123     , p8_a47  VARCHAR2
124     , p8_a48  VARCHAR2
125     , p9_a0 JTF_VARCHAR2_TABLE_100
126     , p9_a1 JTF_VARCHAR2_TABLE_4000
127     , p10_a0 JTF_NUMBER_TABLE
128     , p10_a1 JTF_VARCHAR2_TABLE_100
129     , p10_a2 JTF_NUMBER_TABLE
130     , p10_a3 JTF_VARCHAR2_TABLE_100
131     , p10_a4 JTF_VARCHAR2_TABLE_100
132     , p10_a5 JTF_VARCHAR2_TABLE_100
133     , p10_a6 JTF_VARCHAR2_TABLE_100
134     , p10_a7 JTF_NUMBER_TABLE
135     , p10_a8 JTF_NUMBER_TABLE
136     , p10_a9 JTF_VARCHAR2_TABLE_100
137     , p10_a10 JTF_NUMBER_TABLE
138     , p10_a11 JTF_DATE_TABLE
139     , p10_a12 JTF_VARCHAR2_TABLE_100
140     , p10_a13 JTF_VARCHAR2_TABLE_100
141     , p10_a14 JTF_NUMBER_TABLE
142     , p10_a15 JTF_NUMBER_TABLE
143     , p10_a16 JTF_NUMBER_TABLE
144     , p10_a17 JTF_NUMBER_TABLE
145     , p10_a18 JTF_DATE_TABLE
146     , p10_a19 JTF_VARCHAR2_TABLE_100
147     , p10_a20 JTF_DATE_TABLE
148     , p10_a21 JTF_NUMBER_TABLE
149     , p10_a22 JTF_NUMBER_TABLE
150     , p10_a23 JTF_NUMBER_TABLE
151     , p10_a24 JTF_NUMBER_TABLE
152     , p10_a25 JTF_VARCHAR2_TABLE_100
153     , p10_a26 JTF_DATE_TABLE
154     , p10_a27 JTF_DATE_TABLE
155     , p10_a28 JTF_NUMBER_TABLE
156     , p10_a29 JTF_VARCHAR2_TABLE_100
157     , p10_a30 JTF_VARCHAR2_TABLE_100
158     , p10_a31 JTF_VARCHAR2_TABLE_300
159     , p10_a32 JTF_VARCHAR2_TABLE_300
160     , p10_a33 JTF_VARCHAR2_TABLE_300
161     , p10_a34 JTF_VARCHAR2_TABLE_300
162     , p10_a35 JTF_VARCHAR2_TABLE_300
163     , p10_a36 JTF_VARCHAR2_TABLE_300
164     , p10_a37 JTF_VARCHAR2_TABLE_300
165     , p10_a38 JTF_VARCHAR2_TABLE_300
166     , p10_a39 JTF_VARCHAR2_TABLE_300
167     , p10_a40 JTF_VARCHAR2_TABLE_300
168     , p10_a41 JTF_VARCHAR2_TABLE_300
169     , p10_a42 JTF_VARCHAR2_TABLE_300
170     , p10_a43 JTF_VARCHAR2_TABLE_300
171     , p10_a44 JTF_VARCHAR2_TABLE_300
172     , p10_a45 JTF_VARCHAR2_TABLE_300
173     , p10_a46 JTF_VARCHAR2_TABLE_300
174     , p10_a47 JTF_VARCHAR2_TABLE_300
175     , p10_a48 JTF_VARCHAR2_TABLE_300
176     , p10_a49 JTF_VARCHAR2_TABLE_300
177     , p10_a50 JTF_VARCHAR2_TABLE_300
178     , p11_a0 JTF_NUMBER_TABLE
179     , p11_a1 JTF_VARCHAR2_TABLE_100
180     , p11_a2 JTF_VARCHAR2_TABLE_4000
181     , p11_a3 JTF_VARCHAR2_TABLE_4000
182     , x_order_id OUT NOCOPY  NUMBER
183   );
184   procedure get_order_details(p_api_version  NUMBER
185     , p_init_msg_list  VARCHAR2
186     , p_commit  VARCHAR2
187     , p_validation_level  NUMBER
188     , x_return_status OUT NOCOPY  VARCHAR2
189     , x_msg_count OUT NOCOPY  NUMBER
190     , x_msg_data OUT NOCOPY  VARCHAR2
191     , x_error_code OUT NOCOPY  VARCHAR2
192     , p_order_number  VARCHAR2
193     , p_order_version  VARCHAR2
194     , p_order_id  NUMBER
195     , p11_a0 OUT NOCOPY  VARCHAR2
196     , p11_a1 OUT NOCOPY  VARCHAR2
197     , p11_a2 OUT NOCOPY  DATE
198     , p11_a3 OUT NOCOPY  NUMBER
199     , p11_a4 OUT NOCOPY  VARCHAR2
200     , p11_a5 OUT NOCOPY  VARCHAR2
201     , p11_a6 OUT NOCOPY  VARCHAR2
202     , p11_a7 OUT NOCOPY  NUMBER
203     , p11_a8 OUT NOCOPY  DATE
204     , p11_a9 OUT NOCOPY  DATE
205     , p11_a10 OUT NOCOPY  VARCHAR2
206     , p11_a11 OUT NOCOPY  VARCHAR2
207     , p11_a12 OUT NOCOPY  NUMBER
208     , p11_a13 OUT NOCOPY  NUMBER
209     , p11_a14 OUT NOCOPY  NUMBER
210     , p11_a15 OUT NOCOPY  NUMBER
211     , p11_a16 OUT NOCOPY  VARCHAR2
212     , p11_a17 OUT NOCOPY  VARCHAR2
213     , p11_a18 OUT NOCOPY  VARCHAR2
214     , p11_a19 OUT NOCOPY  NUMBER
215     , p11_a20 OUT NOCOPY  VARCHAR2
216     , p11_a21 OUT NOCOPY  VARCHAR2
217     , p11_a22 OUT NOCOPY  VARCHAR2
218     , p11_a23 OUT NOCOPY  DATE
219     , p11_a24 OUT NOCOPY  DATE
220     , p11_a25 OUT NOCOPY  NUMBER
221     , p11_a26 OUT NOCOPY  VARCHAR2
222     , p11_a27 OUT NOCOPY  VARCHAR2
223     , p11_a28 OUT NOCOPY  VARCHAR2
224     , p11_a29 OUT NOCOPY  VARCHAR2
225     , p11_a30 OUT NOCOPY  VARCHAR2
226     , p11_a31 OUT NOCOPY  VARCHAR2
227     , p11_a32 OUT NOCOPY  VARCHAR2
228     , p11_a33 OUT NOCOPY  VARCHAR2
229     , p11_a34 OUT NOCOPY  VARCHAR2
230     , p11_a35 OUT NOCOPY  VARCHAR2
231     , p11_a36 OUT NOCOPY  VARCHAR2
232     , p11_a37 OUT NOCOPY  VARCHAR2
233     , p11_a38 OUT NOCOPY  VARCHAR2
234     , p11_a39 OUT NOCOPY  VARCHAR2
235     , p11_a40 OUT NOCOPY  VARCHAR2
236     , p11_a41 OUT NOCOPY  VARCHAR2
237     , p11_a42 OUT NOCOPY  VARCHAR2
238     , p11_a43 OUT NOCOPY  VARCHAR2
239     , p11_a44 OUT NOCOPY  VARCHAR2
240     , p11_a45 OUT NOCOPY  VARCHAR2
241     , p11_a46 OUT NOCOPY  VARCHAR2
242     , p11_a47 OUT NOCOPY  VARCHAR2
243     , p11_a48 OUT NOCOPY  VARCHAR2
244     , p12_a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
245     , p12_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
246     , p13_a0 OUT NOCOPY JTF_NUMBER_TABLE
247     , p13_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
248     , p13_a2 OUT NOCOPY JTF_NUMBER_TABLE
249     , p13_a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
250     , p13_a4 OUT NOCOPY JTF_VARCHAR2_TABLE_100
251     , p13_a5 OUT NOCOPY JTF_VARCHAR2_TABLE_100
252     , p13_a6 OUT NOCOPY JTF_VARCHAR2_TABLE_100
253     , p13_a7 OUT NOCOPY JTF_NUMBER_TABLE
254     , p13_a8 OUT NOCOPY JTF_NUMBER_TABLE
255     , p13_a9 OUT NOCOPY JTF_VARCHAR2_TABLE_100
256     , p13_a10 OUT NOCOPY JTF_NUMBER_TABLE
257     , p13_a11 OUT NOCOPY JTF_DATE_TABLE
258     , p13_a12 OUT NOCOPY JTF_VARCHAR2_TABLE_100
259     , p13_a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
260     , p13_a14 OUT NOCOPY JTF_NUMBER_TABLE
261     , p13_a15 OUT NOCOPY JTF_NUMBER_TABLE
262     , p13_a16 OUT NOCOPY JTF_NUMBER_TABLE
263     , p13_a17 OUT NOCOPY JTF_NUMBER_TABLE
264     , p13_a18 OUT NOCOPY JTF_DATE_TABLE
265     , p13_a19 OUT NOCOPY JTF_VARCHAR2_TABLE_100
266     , p13_a20 OUT NOCOPY JTF_DATE_TABLE
267     , p13_a21 OUT NOCOPY JTF_NUMBER_TABLE
268     , p13_a22 OUT NOCOPY JTF_NUMBER_TABLE
269     , p13_a23 OUT NOCOPY JTF_NUMBER_TABLE
270     , p13_a24 OUT NOCOPY JTF_NUMBER_TABLE
271     , p13_a25 OUT NOCOPY JTF_VARCHAR2_TABLE_100
272     , p13_a26 OUT NOCOPY JTF_DATE_TABLE
273     , p13_a27 OUT NOCOPY JTF_DATE_TABLE
274     , p13_a28 OUT NOCOPY JTF_NUMBER_TABLE
275     , p13_a29 OUT NOCOPY JTF_VARCHAR2_TABLE_100
276     , p13_a30 OUT NOCOPY JTF_VARCHAR2_TABLE_100
277     , p13_a31 OUT NOCOPY JTF_VARCHAR2_TABLE_300
278     , p13_a32 OUT NOCOPY JTF_VARCHAR2_TABLE_300
279     , p13_a33 OUT NOCOPY JTF_VARCHAR2_TABLE_300
280     , p13_a34 OUT NOCOPY JTF_VARCHAR2_TABLE_300
281     , p13_a35 OUT NOCOPY JTF_VARCHAR2_TABLE_300
282     , p13_a36 OUT NOCOPY JTF_VARCHAR2_TABLE_300
283     , p13_a37 OUT NOCOPY JTF_VARCHAR2_TABLE_300
284     , p13_a38 OUT NOCOPY JTF_VARCHAR2_TABLE_300
285     , p13_a39 OUT NOCOPY JTF_VARCHAR2_TABLE_300
286     , p13_a40 OUT NOCOPY JTF_VARCHAR2_TABLE_300
287     , p13_a41 OUT NOCOPY JTF_VARCHAR2_TABLE_300
288     , p13_a42 OUT NOCOPY JTF_VARCHAR2_TABLE_300
289     , p13_a43 OUT NOCOPY JTF_VARCHAR2_TABLE_300
290     , p13_a44 OUT NOCOPY JTF_VARCHAR2_TABLE_300
291     , p13_a45 OUT NOCOPY JTF_VARCHAR2_TABLE_300
292     , p13_a46 OUT NOCOPY JTF_VARCHAR2_TABLE_300
293     , p13_a47 OUT NOCOPY JTF_VARCHAR2_TABLE_300
294     , p13_a48 OUT NOCOPY JTF_VARCHAR2_TABLE_300
295     , p13_a49 OUT NOCOPY JTF_VARCHAR2_TABLE_300
296     , p13_a50 OUT NOCOPY JTF_VARCHAR2_TABLE_300
297     , p14_a0 OUT NOCOPY JTF_NUMBER_TABLE
298     , p14_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
299     , p14_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
300     , p14_a3 OUT NOCOPY JTF_VARCHAR2_TABLE_4000
301   );
302   procedure get_order_status(p_api_version  NUMBER
303     , p_init_msg_list  VARCHAR2
304     , p_commit  VARCHAR2
305     , p_validation_level  NUMBER
306     , x_return_status OUT NOCOPY  VARCHAR2
307     , x_msg_count OUT NOCOPY  NUMBER
308     , x_msg_data OUT NOCOPY  VARCHAR2
309     , x_error_code OUT NOCOPY  VARCHAR2
310     , p_order_number  VARCHAR2
311     , p_order_version  VARCHAR2
312     , p_order_id  NUMBER
313     , p11_a0 OUT NOCOPY  NUMBER
314     , p11_a1 OUT NOCOPY  VARCHAR2
315     , p11_a2 OUT NOCOPY  VARCHAR2
316     , p11_a3 OUT NOCOPY  VARCHAR2
317     , p11_a4 OUT NOCOPY  VARCHAR2
318     , p11_a5 OUT NOCOPY  VARCHAR2
319     , p11_a6 OUT NOCOPY  DATE
320     , p11_a7 OUT NOCOPY  DATE
321   );
322 
323   procedure process_order(
324     p_api_version  VARCHAR2
325     , p_init_msg_list  VARCHAR2
326     , p_commit  VARCHAR2
327     , p_validation_level  VARCHAR2
328     , x_return_status OUT NOCOPY  VARCHAR2
329     , x_msg_count OUT NOCOPY  VARCHAR2
330     , x_msg_data OUT NOCOPY  VARCHAR2
331     , x_error_code OUT NOCOPY  NUMBER
332     , p_order_header in VARCHAR2
333     , p_order_line in VARCHAR2
334     , p_order_params in VARCHAR2
335     , p_order_line_params in VARCHAR2
336     , x_order_id OUT NOCOPY  NUMBER
337   );
338 
339  PROCEDURE GET_CLOBS(
340     x_line OUT NOCOPY CLOB,
341     x_order_param OUT NOCOPY CLOB,
342     x_line_param OUT NOCOPY CLOB
343  );
344 
345  PROCEDURE PROCESS_ORDER(
346     p_api_version  VARCHAR2
347     , p_init_msg_list  VARCHAR2
348     , p_commit  VARCHAR2
349     , p_validation_level  VARCHAR2
350     , x_return_status OUT NOCOPY  VARCHAR2
351     , x_msg_count OUT NOCOPY  VARCHAR2
352     , x_msg_data OUT NOCOPY  VARCHAR2
353     , x_error_code OUT NOCOPY  NUMBER
354     , p_order_header in VARCHAR2
355     , p_order_line in CLOB
356     , p_order_params in CLOB
357     , p_order_line_params in CLOB
358     , x_order_id OUT NOCOPY  NUMBER
359   );
360 
361 end xdp_interfaces_pub_w;