[Home] [Help]
PACKAGE: APPS.AHL_OSP_SHIPMENT_PUB_W
Source
1 package ahl_osp_shipment_pub_w as
2 /* $Header: AHLWOSHS.pls 120.1 2007/07/30 10:44:18 mpothuku ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_osp_shipment_pub.sernum_change_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 );
15 procedure rosetta_table_copy_out_p1(t ahl_osp_shipment_pub.sernum_change_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16 , a1 out nocopy JTF_VARCHAR2_TABLE_100
17 , a2 out nocopy JTF_VARCHAR2_TABLE_100
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
19 , a4 out nocopy JTF_NUMBER_TABLE
20 , a5 out nocopy JTF_NUMBER_TABLE
21 , a6 out nocopy JTF_VARCHAR2_TABLE_100
22 , a7 out nocopy JTF_VARCHAR2_TABLE_100
23 , a8 out nocopy JTF_VARCHAR2_TABLE_100
24 , a9 out nocopy JTF_VARCHAR2_TABLE_100
25 , a10 out nocopy JTF_VARCHAR2_TABLE_100
26 );
27
28 procedure rosetta_table_copy_in_p4(t out nocopy ahl_osp_shipment_pub.ship_line_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_NUMBER_TABLE
31 , a3 JTF_VARCHAR2_TABLE_300
32 , a4 JTF_NUMBER_TABLE
33 , a5 JTF_VARCHAR2_TABLE_300
34 , a6 JTF_VARCHAR2_TABLE_100
35 , a7 JTF_NUMBER_TABLE
36 , a8 JTF_VARCHAR2_TABLE_300
37 , a9 JTF_NUMBER_TABLE
38 , a10 JTF_VARCHAR2_TABLE_300
39 , a11 JTF_VARCHAR2_TABLE_100
40 , a12 JTF_NUMBER_TABLE
41 , a13 JTF_NUMBER_TABLE
42 , a14 JTF_VARCHAR2_TABLE_300
43 , a15 JTF_VARCHAR2_TABLE_100
44 , a16 JTF_VARCHAR2_TABLE_100
45 , a17 JTF_NUMBER_TABLE
46 , a18 JTF_VARCHAR2_TABLE_100
47 , a19 JTF_NUMBER_TABLE
48 , a20 JTF_NUMBER_TABLE
49 , a21 JTF_VARCHAR2_TABLE_100
50 , a22 JTF_VARCHAR2_TABLE_100
51 , a23 JTF_VARCHAR2_TABLE_300
52 , a24 JTF_DATE_TABLE
53 , a25 JTF_VARCHAR2_TABLE_2000
54 , a26 JTF_VARCHAR2_TABLE_300
55 , a27 JTF_NUMBER_TABLE
56 , a28 JTF_VARCHAR2_TABLE_300
57 , a29 JTF_VARCHAR2_TABLE_100
58 , a30 JTF_VARCHAR2_TABLE_300
59 , a31 JTF_VARCHAR2_TABLE_100
60 , a32 JTF_VARCHAR2_TABLE_300
61 , a33 JTF_VARCHAR2_TABLE_100
62 , a34 JTF_VARCHAR2_TABLE_100
63 , a35 JTF_VARCHAR2_TABLE_300
64 , a36 JTF_VARCHAR2_TABLE_100
65 , a37 JTF_VARCHAR2_TABLE_300
66 , a38 JTF_VARCHAR2_TABLE_100
67 , a39 JTF_NUMBER_TABLE
68 , a40 JTF_VARCHAR2_TABLE_100
69 , a41 JTF_NUMBER_TABLE
70 , a42 JTF_VARCHAR2_TABLE_100
71 , a43 JTF_NUMBER_TABLE
72 , a44 JTF_VARCHAR2_TABLE_100
73 );
74 procedure rosetta_table_copy_out_p4(t ahl_osp_shipment_pub.ship_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75 , a1 out nocopy JTF_NUMBER_TABLE
76 , a2 out nocopy JTF_NUMBER_TABLE
77 , a3 out nocopy JTF_VARCHAR2_TABLE_300
78 , a4 out nocopy JTF_NUMBER_TABLE
79 , a5 out nocopy JTF_VARCHAR2_TABLE_300
80 , a6 out nocopy JTF_VARCHAR2_TABLE_100
81 , a7 out nocopy JTF_NUMBER_TABLE
82 , a8 out nocopy JTF_VARCHAR2_TABLE_300
83 , a9 out nocopy JTF_NUMBER_TABLE
84 , a10 out nocopy JTF_VARCHAR2_TABLE_300
85 , a11 out nocopy JTF_VARCHAR2_TABLE_100
86 , a12 out nocopy JTF_NUMBER_TABLE
87 , a13 out nocopy JTF_NUMBER_TABLE
88 , a14 out nocopy JTF_VARCHAR2_TABLE_300
89 , a15 out nocopy JTF_VARCHAR2_TABLE_100
90 , a16 out nocopy JTF_VARCHAR2_TABLE_100
91 , a17 out nocopy JTF_NUMBER_TABLE
92 , a18 out nocopy JTF_VARCHAR2_TABLE_100
93 , a19 out nocopy JTF_NUMBER_TABLE
94 , a20 out nocopy JTF_NUMBER_TABLE
95 , a21 out nocopy JTF_VARCHAR2_TABLE_100
96 , a22 out nocopy JTF_VARCHAR2_TABLE_100
97 , a23 out nocopy JTF_VARCHAR2_TABLE_300
98 , a24 out nocopy JTF_DATE_TABLE
99 , a25 out nocopy JTF_VARCHAR2_TABLE_2000
100 , a26 out nocopy JTF_VARCHAR2_TABLE_300
101 , a27 out nocopy JTF_NUMBER_TABLE
102 , a28 out nocopy JTF_VARCHAR2_TABLE_300
103 , a29 out nocopy JTF_VARCHAR2_TABLE_100
104 , a30 out nocopy JTF_VARCHAR2_TABLE_300
105 , a31 out nocopy JTF_VARCHAR2_TABLE_100
106 , a32 out nocopy JTF_VARCHAR2_TABLE_300
107 , a33 out nocopy JTF_VARCHAR2_TABLE_100
108 , a34 out nocopy JTF_VARCHAR2_TABLE_100
109 , a35 out nocopy JTF_VARCHAR2_TABLE_300
110 , a36 out nocopy JTF_VARCHAR2_TABLE_100
111 , a37 out nocopy JTF_VARCHAR2_TABLE_300
112 , a38 out nocopy JTF_VARCHAR2_TABLE_100
113 , a39 out nocopy JTF_NUMBER_TABLE
114 , a40 out nocopy JTF_VARCHAR2_TABLE_100
115 , a41 out nocopy JTF_NUMBER_TABLE
116 , a42 out nocopy JTF_VARCHAR2_TABLE_100
117 , a43 out nocopy JTF_NUMBER_TABLE
118 , a44 out nocopy JTF_VARCHAR2_TABLE_100
119 );
120
121 procedure rosetta_table_copy_in_p5(t out nocopy ahl_osp_shipment_pub.ship_id_tbl_type, a0 JTF_NUMBER_TABLE);
122 procedure rosetta_table_copy_out_p5(t ahl_osp_shipment_pub.ship_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
123
124 procedure process_order(p_api_version NUMBER
125 , p_init_msg_list VARCHAR2
126 , p_commit VARCHAR2
127 , p_validation_level NUMBER
128 , p_module_type VARCHAR2
129 , p5_a0 in out nocopy NUMBER
130 , p5_a1 in out nocopy NUMBER
131 , p5_a2 in out nocopy VARCHAR2
132 , p5_a3 in out nocopy VARCHAR2
133 , p5_a4 in out nocopy VARCHAR2
134 , p5_a5 in out nocopy VARCHAR2
135 , p5_a6 in out nocopy NUMBER
136 , p5_a7 in out nocopy VARCHAR2
137 , p5_a8 in out nocopy NUMBER
138 , p5_a9 in out nocopy VARCHAR2
139 , p5_a10 in out nocopy NUMBER
140 , p5_a11 in out nocopy VARCHAR2
141 , p5_a12 in out nocopy NUMBER
142 , p5_a13 in out nocopy VARCHAR2
143 , p5_a14 in out nocopy NUMBER
144 , p5_a15 in out nocopy VARCHAR2
145 , p5_a16 in out nocopy VARCHAR2
146 , p5_a17 in out nocopy VARCHAR2
147 , p5_a18 in out nocopy VARCHAR2
148 , p5_a19 in out nocopy VARCHAR2
149 , p5_a20 in out nocopy VARCHAR2
150 , p5_a21 in out nocopy VARCHAR2
151 , p5_a22 in out nocopy VARCHAR2
152 , p5_a23 in out nocopy VARCHAR2
153 , p5_a24 in out nocopy VARCHAR2
154 , p5_a25 in out nocopy NUMBER
155 , p5_a26 in out nocopy VARCHAR2
156 , p5_a27 in out nocopy NUMBER
157 , p5_a28 in out nocopy VARCHAR2
158 , p5_a29 in out nocopy VARCHAR2
159 , p5_a30 in out nocopy VARCHAR2
160 , p5_a31 in out nocopy VARCHAR2
161 , p5_a32 in out nocopy VARCHAR2
162 , p5_a33 in out nocopy VARCHAR2
163 , p5_a34 in out nocopy VARCHAR2
164 , p5_a35 in out nocopy VARCHAR2
165 , p6_a0 in out nocopy JTF_NUMBER_TABLE
166 , p6_a1 in out nocopy JTF_NUMBER_TABLE
167 , p6_a2 in out nocopy JTF_NUMBER_TABLE
168 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_300
169 , p6_a4 in out nocopy JTF_NUMBER_TABLE
170 , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
171 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
172 , p6_a7 in out nocopy JTF_NUMBER_TABLE
173 , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_300
174 , p6_a9 in out nocopy JTF_NUMBER_TABLE
175 , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
176 , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_100
177 , p6_a12 in out nocopy JTF_NUMBER_TABLE
178 , p6_a13 in out nocopy JTF_NUMBER_TABLE
179 , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_300
180 , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_100
181 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
182 , p6_a17 in out nocopy JTF_NUMBER_TABLE
183 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
184 , p6_a19 in out nocopy JTF_NUMBER_TABLE
185 , p6_a20 in out nocopy JTF_NUMBER_TABLE
186 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_100
187 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_100
188 , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_300
189 , p6_a24 in out nocopy JTF_DATE_TABLE
190 , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_2000
191 , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_300
192 , p6_a27 in out nocopy JTF_NUMBER_TABLE
193 , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_300
194 , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_100
195 , p6_a30 in out nocopy JTF_VARCHAR2_TABLE_300
196 , p6_a31 in out nocopy JTF_VARCHAR2_TABLE_100
197 , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_300
198 , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
199 , p6_a34 in out nocopy JTF_VARCHAR2_TABLE_100
200 , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_300
201 , p6_a36 in out nocopy JTF_VARCHAR2_TABLE_100
202 , p6_a37 in out nocopy JTF_VARCHAR2_TABLE_300
203 , p6_a38 in out nocopy JTF_VARCHAR2_TABLE_100
204 , p6_a39 in out nocopy JTF_NUMBER_TABLE
205 , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_100
206 , p6_a41 in out nocopy JTF_NUMBER_TABLE
207 , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_100
208 , p6_a43 in out nocopy JTF_NUMBER_TABLE
209 , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
210 , x_return_status out nocopy VARCHAR2
211 , x_msg_count out nocopy NUMBER
212 , x_msg_data out nocopy VARCHAR2
213 );
214 procedure book_order(p_api_version NUMBER
215 , p_init_msg_list VARCHAR2
216 , p_commit VARCHAR2
217 , p_validation_level NUMBER
218 , p_oe_header_tbl JTF_NUMBER_TABLE
219 , x_return_status out nocopy VARCHAR2
220 , x_msg_count out nocopy NUMBER
221 , x_msg_data out nocopy VARCHAR2
222 );
223 procedure delete_cancel_order(p_api_version NUMBER
224 , p_init_msg_list VARCHAR2
225 , p_commit VARCHAR2
226 , p_validation_level NUMBER
227 , p_oe_header_id NUMBER
228 , p_oe_lines_tbl JTF_NUMBER_TABLE
229 , p_cancel_flag VARCHAR2
230 , x_return_status out nocopy VARCHAR2
231 , x_msg_count out nocopy NUMBER
232 , x_msg_data out nocopy VARCHAR2
233 );
234 procedure process_osp_serialnum_change(p_api_version NUMBER
235 , p_init_msg_list VARCHAR2
236 , p_commit VARCHAR2
237 , p_validation_level NUMBER
238 , p_module_type VARCHAR2
239 , p5_a0 VARCHAR2
240 , p5_a1 VARCHAR2
241 , p5_a2 VARCHAR2
242 , p5_a3 VARCHAR2
243 , p5_a4 NUMBER
244 , p5_a5 NUMBER
245 , p5_a6 VARCHAR2
246 , p5_a7 VARCHAR2
247 , p5_a8 VARCHAR2
248 , p5_a9 VARCHAR2
249 , p5_a10 VARCHAR2
250 , x_return_status out nocopy VARCHAR2
251 , x_msg_count out nocopy NUMBER
252 , x_msg_data out nocopy VARCHAR2
253 );
254 end ahl_osp_shipment_pub_w;