[Home] [Help]
PACKAGE: APPS.WSH_DELIVERIES_PKG
Source
1 PACKAGE WSH_DELIVERIES_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHDELHS.pls 115.1 99/08/11 19:22:55 porting s $ */
3
4 -- The procedure update_row can possibly return 2 kinds of exceptions
5 -- 1. WSH_DEL_DUP_NAME : This the for the case that default delivery name
6 -- generated by wsh_external_custom.delivery_name
7 -- is duplicate in table wsh_deliveries
8 -- 2. WSH_DEL_NULL_NAME : This is for the case that default delivery name
9 -- generated by wsh_external_custom.delivery_name
10 -- is NULL.
11 PROCEDURE Update_Row(X_Rowid VARCHAR2,
12 X_Organization_Id NUMBER,
13 X_Delivery_Id NUMBER,
14 X_Name IN OUT VARCHAR2,
15 X_Source_Code VARCHAR2,
16 X_Planned_Departure_Id NUMBER,
17 X_Actual_Departure_Id NUMBER,
18 X_Status_Code VARCHAR2,
19 X_Loading_Order_Flag VARCHAR2,
20 X_Date_Closed DATE,
21 X_Report_Set_Id NUMBER,
22 X_Sequence_Number NUMBER,
23 X_Customer_Id NUMBER,
24 X_Ultimate_Ship_To_Id NUMBER,
25 X_Intermediate_Ship_To_Id NUMBER,
26 X_Pooled_Ship_To_Id NUMBER,
27 X_Waybill VARCHAR2,
28 X_Gross_Weight NUMBER,
29 X_Weight_Uom_Code VARCHAR2,
30 X_Volume NUMBER,
31 X_Volume_Uom_Code VARCHAR2,
32 X_Picked_By_Id NUMBER,
33 X_Packed_By_Id NUMBER,
34 X_Expected_Arrival_Date DATE,
35 X_Asn_Date_Sent DATE,
36 X_Asn_Seq_Number NUMBER,
37 X_Freight_Carrier_Code VARCHAR2,
38 X_Freight_Terms_Code VARCHAR2,
39 X_Currency_Code VARCHAR2,
40 X_Fob_Code VARCHAR2,
41 X_Attribute_Category VARCHAR2,
42 X_Attribute1 VARCHAR2,
43 X_Attribute2 VARCHAR2,
44 X_Attribute3 VARCHAR2,
45 X_Attribute4 VARCHAR2,
46 X_Attribute5 VARCHAR2,
47 X_Attribute6 VARCHAR2,
48 X_Attribute7 VARCHAR2,
49 X_Attribute8 VARCHAR2,
50 X_Attribute9 VARCHAR2,
51 X_Attribute10 VARCHAR2,
52 X_Attribute11 VARCHAR2,
53 X_Attribute12 VARCHAR2,
54 X_Attribute13 VARCHAR2,
55 X_Attribute14 VARCHAR2,
56 X_Attribute15 VARCHAR2,
57 X_Global_Attribute_Category VARCHAR2 default null,
58 X_Global_Attribute1 VARCHAR2 default null,
59 X_Global_Attribute2 VARCHAR2 default null,
60 X_Global_Attribute3 VARCHAR2 default null,
61 X_Global_Attribute4 VARCHAR2 default null,
62 X_Global_Attribute5 VARCHAR2 default null,
63 X_Global_Attribute6 VARCHAR2 default null,
64 X_Global_Attribute7 VARCHAR2 default null,
65 X_Global_Attribute8 VARCHAR2 default null,
66 X_Global_Attribute9 VARCHAR2 default null,
67 X_Global_Attribute10 VARCHAR2 default null,
68 X_Global_Attribute11 VARCHAR2 default null,
69 X_Global_Attribute12 VARCHAR2 default null,
70 X_Global_Attribute13 VARCHAR2 default null,
71 X_Global_Attribute14 VARCHAR2 default null,
72 X_Global_Attribute15 VARCHAR2 default null,
73 X_Global_Attribute16 VARCHAR2 default null,
74 X_Global_Attribute17 VARCHAR2 default null,
75 X_Global_Attribute18 VARCHAR2 default null,
76 X_Global_Attribute19 VARCHAR2 default null,
77 X_Global_Attribute20 VARCHAR2 default null,
78 X_Last_Update_Date DATE,
79 X_Last_Updated_By NUMBER,
80 X_Last_Update_Login NUMBER
81 );
82
83
84 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
85 X_Organization_Id NUMBER,
86 X_Delivery_Id NUMBER,
87 X_Name VARCHAR2,
88 X_Source_Code VARCHAR2,
89 X_Planned_Departure_Id NUMBER,
90 X_Actual_Departure_Id NUMBER,
91 X_Status_Code VARCHAR2,
92 X_Loading_Order_Flag VARCHAR2,
93 X_Date_Closed DATE,
94 X_Report_Set_Id NUMBER,
95 X_Sequence_Number NUMBER,
96 X_Customer_Id NUMBER,
97 X_Ultimate_Ship_To_Id NUMBER,
98 X_Intermediate_Ship_To_Id NUMBER,
99 X_Pooled_Ship_To_Id NUMBER,
100 X_Waybill VARCHAR2,
101 X_Gross_Weight NUMBER,
102 X_Weight_Uom_Code VARCHAR2,
103 X_Volume NUMBER,
104 X_Volume_Uom_Code VARCHAR2,
105 X_Picked_By_Id NUMBER,
106 X_Packed_By_Id NUMBER,
107 X_Expected_Arrival_Date DATE,
108 X_Asn_Date_Sent DATE,
109 X_Asn_Seq_Number NUMBER,
110 X_Freight_Carrier_Code VARCHAR2,
111 X_Freight_Terms_Code VARCHAR2,
112 X_Currency_Code VARCHAR2,
113 X_Fob_Code VARCHAR2,
114 X_Attribute_Category VARCHAR2,
115 X_Attribute1 VARCHAR2,
116 X_Attribute2 VARCHAR2,
117 X_Attribute3 VARCHAR2,
118 X_Attribute4 VARCHAR2,
119 X_Attribute5 VARCHAR2,
120 X_Attribute6 VARCHAR2,
121 X_Attribute7 VARCHAR2,
122 X_Attribute8 VARCHAR2,
123 X_Attribute9 VARCHAR2,
124 X_Attribute10 VARCHAR2,
125 X_Attribute11 VARCHAR2,
126 X_Attribute12 VARCHAR2,
127 X_Attribute13 VARCHAR2,
128 X_Attribute14 VARCHAR2,
129 X_Attribute15 VARCHAR2,
130 X_Global_Attribute_Category VARCHAR2 default null,
131 X_Global_Attribute1 VARCHAR2 default null,
132 X_Global_Attribute2 VARCHAR2 default null,
133 X_Global_Attribute3 VARCHAR2 default null,
134 X_Global_Attribute4 VARCHAR2 default null,
135 X_Global_Attribute5 VARCHAR2 default null,
136 X_Global_Attribute6 VARCHAR2 default null,
137 X_Global_Attribute7 VARCHAR2 default null,
138 X_Global_Attribute8 VARCHAR2 default null,
139 X_Global_Attribute9 VARCHAR2 default null,
140 X_Global_Attribute10 VARCHAR2 default null,
141 X_Global_Attribute11 VARCHAR2 default null,
142 X_Global_Attribute12 VARCHAR2 default null,
143 X_Global_Attribute13 VARCHAR2 default null,
144 X_Global_Attribute14 VARCHAR2 default null,
145 X_Global_Attribute15 VARCHAR2 default null,
146 X_Global_Attribute16 VARCHAR2 default null,
147 X_Global_Attribute17 VARCHAR2 default null,
148 X_Global_Attribute18 VARCHAR2 default null,
149 X_Global_Attribute19 VARCHAR2 default null,
150 X_Global_Attribute20 VARCHAR2 default null
151 );
152
153
154 PROCEDURE Update_Row_new(X_Rowid VARCHAR2,
155 X_Organization_Id NUMBER,
156 X_Delivery_Id NUMBER,
157 X_Name IN OUT VARCHAR2,
158 X_Source_Code VARCHAR2,
159 X_Planned_Departure_Id NUMBER,
160 X_Actual_Departure_Id NUMBER,
161 X_Status_Code VARCHAR2,
162 X_Loading_Order_Flag VARCHAR2,
163 X_Date_Closed DATE,
164 X_Report_Set_Id NUMBER,
165 X_Sequence_Number NUMBER,
166 X_Customer_Id NUMBER,
167 X_Ultimate_Ship_To_Id NUMBER,
168 X_Intermediate_Ship_To_Id NUMBER,
169 X_Pooled_Ship_To_Id NUMBER,
170 X_Waybill VARCHAR2,
171 X_Gross_Weight NUMBER,
172 X_Net_Weight NUMBER,
173 X_Weight_Uom_Code VARCHAR2,
174 X_Volume NUMBER,
175 X_Volume_Uom_Code VARCHAR2,
176 X_Picked_By_Id NUMBER,
177 X_Packed_By_Id NUMBER,
178 X_Expected_Arrival_Date DATE,
179 X_Asn_Date_Sent DATE,
180 X_Asn_Seq_Number NUMBER,
181 X_Freight_Carrier_Code VARCHAR2,
182 X_Freight_Terms_Code VARCHAR2,
183 X_Currency_Code VARCHAR2,
184 X_Fob_Code VARCHAR2,
185 X_Attribute_Category VARCHAR2,
186 X_Attribute1 VARCHAR2,
187 X_Attribute2 VARCHAR2,
188 X_Attribute3 VARCHAR2,
189 X_Attribute4 VARCHAR2,
190 X_Attribute5 VARCHAR2,
191 X_Attribute6 VARCHAR2,
192 X_Attribute7 VARCHAR2,
193 X_Attribute8 VARCHAR2,
194 X_Attribute9 VARCHAR2,
195 X_Attribute10 VARCHAR2,
196 X_Attribute11 VARCHAR2,
197 X_Attribute12 VARCHAR2,
198 X_Attribute13 VARCHAR2,
199 X_Attribute14 VARCHAR2,
200 X_Attribute15 VARCHAR2,
201 X_Global_Attribute_Category VARCHAR2 default null,
202 X_Global_Attribute1 VARCHAR2 default null,
203 X_Global_Attribute2 VARCHAR2 default null,
204 X_Global_Attribute3 VARCHAR2 default null,
205 X_Global_Attribute4 VARCHAR2 default null,
206 X_Global_Attribute5 VARCHAR2 default null,
207 X_Global_Attribute6 VARCHAR2 default null,
208 X_Global_Attribute7 VARCHAR2 default null,
209 X_Global_Attribute8 VARCHAR2 default null,
210 X_Global_Attribute9 VARCHAR2 default null,
211 X_Global_Attribute10 VARCHAR2 default null,
212 X_Global_Attribute11 VARCHAR2 default null,
213 X_Global_Attribute12 VARCHAR2 default null,
214 X_Global_Attribute13 VARCHAR2 default null,
215 X_Global_Attribute14 VARCHAR2 default null,
216 X_Global_Attribute15 VARCHAR2 default null,
217 X_Global_Attribute16 VARCHAR2 default null,
218 X_Global_Attribute17 VARCHAR2 default null,
219 X_Global_Attribute18 VARCHAR2 default null,
220 X_Global_Attribute19 VARCHAR2 default null,
221 X_Global_Attribute20 VARCHAR2 default null,
222 X_Last_Update_Date DATE,
223 X_Last_Updated_By NUMBER,
224 X_Last_Update_Login NUMBER
225 );
226
227
228 PROCEDURE Lock_Row_new(X_Rowid VARCHAR2,
229 X_Organization_Id NUMBER,
230 X_Delivery_Id NUMBER,
231 X_Name VARCHAR2,
232 X_Source_Code VARCHAR2,
233 X_Planned_Departure_Id NUMBER,
234 X_Actual_Departure_Id NUMBER,
235 X_Status_Code VARCHAR2,
236 X_Loading_Order_Flag VARCHAR2,
237 X_Date_Closed DATE,
238 X_Report_Set_Id NUMBER,
239 X_Sequence_Number NUMBER,
240 X_Customer_Id NUMBER,
241 X_Ultimate_Ship_To_Id NUMBER,
242 X_Intermediate_Ship_To_Id NUMBER,
243 X_Pooled_Ship_To_Id NUMBER,
244 X_Waybill VARCHAR2,
245 X_Gross_Weight NUMBER,
246 X_Net_Weight NUMBER,
247 X_Weight_Uom_Code VARCHAR2,
248 X_Volume NUMBER,
249 X_Volume_Uom_Code VARCHAR2,
250 X_Picked_By_Id NUMBER,
251 X_Packed_By_Id NUMBER,
252 X_Expected_Arrival_Date DATE,
253 X_Asn_Date_Sent DATE,
254 X_Asn_Seq_Number NUMBER,
255 X_Freight_Carrier_Code VARCHAR2,
256 X_Freight_Terms_Code VARCHAR2,
257 X_Currency_Code VARCHAR2,
258 X_Fob_Code VARCHAR2,
259 X_Attribute_Category VARCHAR2,
260 X_Attribute1 VARCHAR2,
261 X_Attribute2 VARCHAR2,
262 X_Attribute3 VARCHAR2,
263 X_Attribute4 VARCHAR2,
264 X_Attribute5 VARCHAR2,
265 X_Attribute6 VARCHAR2,
269 X_Attribute10 VARCHAR2,
266 X_Attribute7 VARCHAR2,
267 X_Attribute8 VARCHAR2,
268 X_Attribute9 VARCHAR2,
270 X_Attribute11 VARCHAR2,
271 X_Attribute12 VARCHAR2,
272 X_Attribute13 VARCHAR2,
273 X_Attribute14 VARCHAR2,
274 X_Attribute15 VARCHAR2,
275 X_Global_Attribute_Category VARCHAR2 default null,
276 X_Global_Attribute1 VARCHAR2 default null,
277 X_Global_Attribute2 VARCHAR2 default null,
278 X_Global_Attribute3 VARCHAR2 default null,
279 X_Global_Attribute4 VARCHAR2 default null,
280 X_Global_Attribute5 VARCHAR2 default null,
281 X_Global_Attribute6 VARCHAR2 default null,
282 X_Global_Attribute7 VARCHAR2 default null,
283 X_Global_Attribute8 VARCHAR2 default null,
284 X_Global_Attribute9 VARCHAR2 default null,
285 X_Global_Attribute10 VARCHAR2 default null,
286 X_Global_Attribute11 VARCHAR2 default null,
287 X_Global_Attribute12 VARCHAR2 default null,
288 X_Global_Attribute13 VARCHAR2 default null,
289 X_Global_Attribute14 VARCHAR2 default null,
290 X_Global_Attribute15 VARCHAR2 default null,
291 X_Global_Attribute16 VARCHAR2 default null,
292 X_Global_Attribute17 VARCHAR2 default null,
293 X_Global_Attribute18 VARCHAR2 default null,
294 X_Global_Attribute19 VARCHAR2 default null,
295 X_Global_Attribute20 VARCHAR2 default null
296 );
297
298
299 END WSH_DELIVERIES_PKG;
300