[Home] [Help]
PACKAGE: APPS.WSH_PICKING_BATCHES_PKG
Source
1 PACKAGE WSH_PICKING_BATCHES_PKG as
2 /* $Header: WSHPRBTS.pls 120.3 2007/12/21 14:19:23 mvudugul ship $ */
3
4 -- Bug 3266659: Added P_Ship_Set_Smc_Flag for the pick release public API
5
6 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
7 X_Batch_Id IN OUT NOCOPY NUMBER,
8 P_Creation_Date DATE,
9 P_Created_By NUMBER,
10 P_Last_Update_Date DATE,
11 P_Last_Updated_By NUMBER,
12 P_Last_Update_Login NUMBER,
13 -- Bug 3266659 : Batch name prefix
14 p_batch_name_prefix VARCHAR2 DEFAULT NULL,
15 X_Name IN OUT NOCOPY VARCHAR2,
16 P_Backorders_Only_Flag VARCHAR2,
17 P_Document_Set_Id NUMBER,
18 P_Existing_Rsvs_Only_Flag VARCHAR2,
19 P_Shipment_Priority_Code VARCHAR2,
20 P_Ship_Method_Code VARCHAR2,
21 P_Customer_Id NUMBER,
22 P_Order_Header_Id NUMBER,
23 P_Ship_Set_Number NUMBER,
24 P_Inventory_Item_Id NUMBER,
25 P_Order_Type_Id NUMBER,
26 P_From_Requested_Date DATE,
27 P_To_Requested_Date DATE,
28 P_From_Scheduled_Ship_Date DATE,
29 P_To_Scheduled_Ship_Date DATE,
30 P_Ship_To_Location_Id NUMBER,
31 P_Ship_From_Location_Id NUMBER,
32 P_Trip_Id NUMBER,
33 P_Delivery_Id NUMBER,
34 P_Include_Planned_Lines VARCHAR2,
35 P_Pick_Grouping_Rule_Id NUMBER,
36 P_Pick_Sequence_Rule_Id NUMBER,
37 P_Autocreate_Delivery_Flag VARCHAR2,
38 P_Attribute_Category VARCHAR2,
39 P_Attribute1 VARCHAR2,
40 P_Attribute2 VARCHAR2,
41 P_Attribute3 VARCHAR2,
42 P_Attribute4 VARCHAR2,
43 P_Attribute5 VARCHAR2,
44 P_Attribute6 VARCHAR2,
45 P_Attribute7 VARCHAR2,
46 P_Attribute8 VARCHAR2,
47 P_Attribute9 VARCHAR2,
48 P_Attribute10 VARCHAR2,
49 P_Attribute11 VARCHAR2,
50 P_Attribute12 VARCHAR2,
51 P_Attribute13 VARCHAR2,
52 P_Attribute14 VARCHAR2,
53 P_Attribute15 VARCHAR2,
54 P_Autodetail_Pr_Flag VARCHAR2,
55 P_Carrier_Id NUMBER,
56 P_Trip_Stop_Id NUMBER,
57 P_Default_Stage_Subinventory VARCHAR2,
58 P_Default_Stage_Locator_Id NUMBER,
59 P_Pick_From_Subinventory VARCHAR2,
60 P_Pick_From_locator_Id NUMBER,
61 P_Auto_Pick_Confirm_Flag VARCHAR2,
62 P_Delivery_Detail_Id NUMBER,
63 P_Project_Id NUMBER,
64 P_Task_Id NUMBER,
65 P_Organization_Id NUMBER,
66 P_Ship_Confirm_Rule_Id NUMBER,
67 P_Autopack_Flag VARCHAR2,
68 P_Autopack_Level NUMBER,
69 P_Task_Planning_Flag VARCHAR2,
70 P_Dynamic_replenishment_Flag VARCHAR2 DEFAULT NULL, --bug# 6689448 (replenishment project)
71 P_Non_Picking_flag VARCHAR2 DEFAULT NULL,
72 p_regionID NUMBER,
73 p_zoneId NUMBER,
74 p_categoryID NUMBER,
75 p_categorySetID NUMBER,
76 p_acDelivCriteria VARCHAR2,
77 p_RelSubinventory VARCHAR2,
78 p_append_flag VARCHAR2,
79 p_task_priority NUMBER,
80 P_Ship_Set_Smc_Flag VARCHAR2 DEFAULT NULL, --- Added for pick release Public API
81 p_actual_departure_date DATE DEFAULT NULL,
82 p_allocation_method VARCHAR2, -- X-dock
83 p_crossdock_criteria_id NUMBER, -- X-dock
84 -- bug 5117876, following 14 attributes are added
85 p_Delivery_Name_Lo VARCHAR2 DEFAULT NULL,
86 p_Delivery_Name_Hi VARCHAR2 DEFAULT NULL,
87 p_Bol_Number_Lo VARCHAR2 DEFAULT NULL,
88 p_Bol_Number_Hi VARCHAR2 DEFAULT NULL,
89 p_Intmed_Ship_To_Loc_Id NUMBER DEFAULT NULL,
90 p_Pooled_Ship_To_Loc_Id NUMBER DEFAULT NULL,
91 p_Fob_Code VARCHAR2 DEFAULT NULL,
92 p_Freight_Terms_Code VARCHAR2 DEFAULT NULL,
93 p_Pickup_Date_Lo DATE DEFAULT NULL,
94 p_Pickup_Date_Hi DATE DEFAULT NULL,
95 p_Dropoff_Date_Lo DATE DEFAULT NULL,
96 p_Dropoff_Date_Hi DATE DEFAULT NULL,
97 p_Planned_Flag VARCHAR2 DEFAULT NULL,
98 p_Selected_Batch_Id NUMBER DEFAULT NULL
99 );
100
101 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
102 P_Batch_Id NUMBER,
103 P_Name VARCHAR2,
104 P_Backorders_Only_Flag VARCHAR2,
105 P_Document_Set_Id NUMBER,
106 P_Existing_Rsvs_Only_Flag VARCHAR2,
107 P_Shipment_Priority_Code VARCHAR2,
108 P_Ship_Method_Code VARCHAR2,
109 P_Customer_Id NUMBER,
110 P_Order_Header_Id NUMBER,
111 P_Ship_Set_Number NUMBER,
112 P_Inventory_Item_Id NUMBER,
113 P_Order_Type_Id NUMBER,
114 P_From_Requested_Date DATE,
115 P_To_Requested_Date DATE,
116 P_From_Scheduled_Ship_Date DATE,
117 P_To_Scheduled_Ship_Date DATE,
118 P_Ship_To_Location_Id NUMBER,
119 P_Ship_From_Location_Id NUMBER,
120 P_Trip_Id NUMBER,
121 P_Delivery_Id NUMBER,
122 P_Include_Planned_Lines VARCHAR2,
123 P_Pick_Grouping_Rule_Id NUMBER,
124 P_Pick_Sequence_Rule_Id NUMBER,
125 P_Autocreate_Delivery_Flag VARCHAR2,
126 P_Attribute_Category VARCHAR2,
127 P_Attribute1 VARCHAR2,
128 P_Attribute2 VARCHAR2,
129 P_Attribute3 VARCHAR2,
130 P_Attribute4 VARCHAR2,
131 P_Attribute5 VARCHAR2,
132 P_Attribute6 VARCHAR2,
133 P_Attribute7 VARCHAR2,
134 P_Attribute8 VARCHAR2,
135 P_Attribute9 VARCHAR2,
136 P_Attribute10 VARCHAR2,
137 P_Attribute11 VARCHAR2,
138 P_Attribute12 VARCHAR2,
139 P_Attribute13 VARCHAR2,
140 P_Attribute14 VARCHAR2,
141 P_Attribute15 VARCHAR2,
142 P_Autodetail_Pr_Flag VARCHAR2,
143 P_Carrier_Id NUMBER,
144 P_Trip_Stop_Id NUMBER,
145 P_Default_Stage_Subinventory VARCHAR2,
146 P_Default_Stage_Locator_Id NUMBER,
147 P_Pick_From_Subinventory VARCHAR2,
148 P_Pick_From_locator_Id NUMBER,
149 P_Auto_Pick_Confirm_Flag VARCHAR2,
150 P_Delivery_Detail_Id NUMBER,
151 P_Project_Id NUMBER,
152 P_Task_Id NUMBER,
153 P_Organization_Id NUMBER,
154 P_Ship_Confirm_Rule_Id NUMBER,
155 P_Autopack_Flag VARCHAR2,
156 P_Autopack_Level NUMBER,
157 P_Task_Planning_Flag VARCHAR2,
158 P_Dynamic_replenishment_Flag VARCHAR2 DEFAULT NULL, --bug# 6689448 (replenishment project)
159 P_Non_Picking_flag VARCHAR2 DEFAULT NULL,
160 p_regionID NUMBER,
161 p_zoneId NUMBER,
162 p_categoryID NUMBER,
163 p_categorySetID NUMBER,
164 p_acDelivCriteria VARCHAR2,
165 p_RelSubinventory VARCHAR2,
166 p_append_flag VARCHAR2,
167 p_task_priority NUMBER,
168 p_actual_departure_date DATE DEFAULT NULL,
169 p_allocation_method VARCHAR2, -- X-dock
170 p_crossdock_criteria_id NUMBER -- X-dock
171 );
172
173
174
175 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
176 P_Batch_Id NUMBER,
177 P_Last_Update_Date DATE,
178 P_Last_Updated_By NUMBER,
179 P_Last_Update_Login NUMBER,
180 P_Name VARCHAR2,
181 P_Backorders_Only_Flag VARCHAR2,
182 P_Document_Set_Id NUMBER,
183 P_Existing_Rsvs_Only_Flag VARCHAR2,
184 P_Shipment_Priority_Code VARCHAR2,
185 P_Ship_Method_Code VARCHAR2,
186 P_Customer_Id NUMBER,
187 P_Order_Header_Id NUMBER,
188 P_Ship_Set_Number NUMBER,
189 P_Inventory_Item_Id NUMBER,
190 P_Order_Type_Id NUMBER,
191 P_From_Requested_Date DATE,
192 P_To_Requested_Date DATE,
193 P_From_Scheduled_Ship_Date DATE,
194 P_To_Scheduled_Ship_Date DATE,
195 P_Ship_To_Location_Id NUMBER,
196 P_Ship_From_Location_Id NUMBER,
197 P_Attribute_Category VARCHAR2,
198 P_Attribute1 VARCHAR2,
199 P_Attribute2 VARCHAR2,
200 P_Attribute3 VARCHAR2,
201 P_Attribute4 VARCHAR2,
202 P_Attribute5 VARCHAR2,
203 P_Attribute6 VARCHAR2,
204 P_Attribute7 VARCHAR2,
205 P_Attribute8 VARCHAR2,
206 P_Attribute9 VARCHAR2,
207 P_Attribute10 VARCHAR2,
208 P_Attribute11 VARCHAR2,
209 P_Attribute12 VARCHAR2,
210 P_Attribute13 VARCHAR2,
211 P_Attribute14 VARCHAR2,
212 P_Attribute15 VARCHAR2,
213 P_Autodetail_Pr_Flag VARCHAR2,
214 P_Carrier_Id NUMBER,
215 P_Trip_Stop_Id NUMBER,
216 P_Default_Stage_Subinventory VARCHAR2,
217 P_Default_Stage_Locator_Id NUMBER,
218 P_Pick_From_Subinventory VARCHAR2,
219 P_Pick_From_locator_Id NUMBER,
220 P_Auto_Pick_Confirm_Flag VARCHAR2,
221 P_Delivery_Detail_Id NUMBER,
222 P_Project_Id NUMBER,
223 P_Task_Id NUMBER,
224 P_Organization_Id NUMBER,
225 P_Ship_Confirm_Rule_Id NUMBER,
226 P_Autopack_Flag VARCHAR2,
227 P_Autopack_Level NUMBER,
228 P_Task_Planning_Flag VARCHAR2,
229 P_Dynamic_replenishment_Flag VARCHAR2 DEFAULT NULL, --bug# 6689448 (replenishment project)
230 P_Non_Picking_flag VARCHAR2 DEFAULT NULL,
231 p_regionID NUMBER,
232 p_zoneId NUMBER,
233 p_categoryID NUMBER,
234 p_categorySetID NUMBER,
235 p_acDelivCriteria VARCHAR2,
236 p_RelSubinventory VARCHAR2,
237 p_append_flag VARCHAR2,
238 p_task_priority NUMBER,
239 p_actual_departure_date DATE DEFAULT NULL,
240 p_allocation_method VARCHAR2, -- X-dock
241 p_crossdock_criteria_id NUMBER -- X-dock
242 );
243
244
245 PROCEDURE Delete_Row(X_Rowid IN OUT NOCOPY VARCHAR2);
246
247
248 PROCEDURE Delete_And_Commit(X_Rowid IN OUT NOCOPY VARCHAR2);
249
250
251 PROCEDURE Commit_Work;
252
253 --
254 -- Bug # 2231365 : Defaulted the parameter p_log_level to 0
255 --
256 FUNCTION Submit_Release_Request(P_Batch_Id NUMBER,
257 P_Log_Level NUMBER DEFAULT 0,
258 P_Num_Workers NUMBER DEFAULT 1,
259 P_Commit VARCHAR2 DEFAULT NULL)
260 RETURN NUMBER;
261
262
263 PROCEDURE Get_Printer (p_report IN VARCHAR2,
264 x_report_printer OUT NOCOPY VARCHAR2,
265 p_default_report IN VARCHAR2 default 'OEXSHPIK');
266
267
268 END WSH_PICKING_BATCHES_PKG;