[Home] [Help]
PACKAGE: APPS.WSH_PICKING_BATCHES_PKG
Source
1 PACKAGE WSH_PICKING_BATCHES_PKG AUTHID CURRENT_USER as
2 /* $Header: WSHPRBTS.pls 120.3.12010000.2 2009/12/03 13:33:50 anvarshn 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 p_client_Id NUMBER DEFAULT NULL --Modified R12.1.1 LSP PROJECT
100 );
101
102 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
103 P_Batch_Id NUMBER,
104 P_Name VARCHAR2,
105 P_Backorders_Only_Flag VARCHAR2,
106 P_Document_Set_Id NUMBER,
107 P_Existing_Rsvs_Only_Flag VARCHAR2,
108 P_Shipment_Priority_Code VARCHAR2,
109 P_Ship_Method_Code VARCHAR2,
110 P_Customer_Id NUMBER,
111 P_Order_Header_Id NUMBER,
112 P_Ship_Set_Number NUMBER,
113 P_Inventory_Item_Id NUMBER,
114 P_Order_Type_Id NUMBER,
115 P_From_Requested_Date DATE,
116 P_To_Requested_Date DATE,
117 P_From_Scheduled_Ship_Date DATE,
118 P_To_Scheduled_Ship_Date DATE,
119 P_Ship_To_Location_Id NUMBER,
120 P_Ship_From_Location_Id NUMBER,
121 P_Trip_Id NUMBER,
122 P_Delivery_Id NUMBER,
123 P_Include_Planned_Lines VARCHAR2,
124 P_Pick_Grouping_Rule_Id NUMBER,
125 P_Pick_Sequence_Rule_Id NUMBER,
126 P_Autocreate_Delivery_Flag VARCHAR2,
127 P_Attribute_Category VARCHAR2,
128 P_Attribute1 VARCHAR2,
129 P_Attribute2 VARCHAR2,
130 P_Attribute3 VARCHAR2,
131 P_Attribute4 VARCHAR2,
132 P_Attribute5 VARCHAR2,
133 P_Attribute6 VARCHAR2,
134 P_Attribute7 VARCHAR2,
135 P_Attribute8 VARCHAR2,
136 P_Attribute9 VARCHAR2,
137 P_Attribute10 VARCHAR2,
138 P_Attribute11 VARCHAR2,
139 P_Attribute12 VARCHAR2,
140 P_Attribute13 VARCHAR2,
141 P_Attribute14 VARCHAR2,
142 P_Attribute15 VARCHAR2,
143 P_Autodetail_Pr_Flag VARCHAR2,
144 P_Carrier_Id NUMBER,
145 P_Trip_Stop_Id NUMBER,
146 P_Default_Stage_Subinventory VARCHAR2,
147 P_Default_Stage_Locator_Id NUMBER,
148 P_Pick_From_Subinventory VARCHAR2,
149 P_Pick_From_locator_Id NUMBER,
150 P_Auto_Pick_Confirm_Flag VARCHAR2,
151 P_Delivery_Detail_Id NUMBER,
152 P_Project_Id NUMBER,
153 P_Task_Id NUMBER,
154 P_Organization_Id NUMBER,
155 P_Ship_Confirm_Rule_Id NUMBER,
156 P_Autopack_Flag VARCHAR2,
157 P_Autopack_Level NUMBER,
158 P_Task_Planning_Flag VARCHAR2,
159 P_Dynamic_replenishment_Flag VARCHAR2 DEFAULT NULL, --bug# 6689448 (replenishment project)
160 P_Non_Picking_flag VARCHAR2 DEFAULT NULL,
161 p_regionID NUMBER,
162 p_zoneId NUMBER,
163 p_categoryID NUMBER,
164 p_categorySetID NUMBER,
165 p_acDelivCriteria VARCHAR2,
166 p_RelSubinventory VARCHAR2,
167 p_append_flag VARCHAR2,
168 p_task_priority NUMBER,
169 p_actual_departure_date DATE DEFAULT NULL,
170 p_allocation_method VARCHAR2, -- X-dock
171 p_crossdock_criteria_id NUMBER, -- X-dock
172 p_client_Id NUMBER DEFAULT NULL --Modified R12.1.1 LSP PROJECT
173 );
174
175
176
177 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
178 P_Batch_Id NUMBER,
179 P_Last_Update_Date DATE,
180 P_Last_Updated_By NUMBER,
181 P_Last_Update_Login NUMBER,
182 P_Name VARCHAR2,
183 P_Backorders_Only_Flag VARCHAR2,
184 P_Document_Set_Id NUMBER,
185 P_Existing_Rsvs_Only_Flag VARCHAR2,
186 P_Shipment_Priority_Code VARCHAR2,
187 P_Ship_Method_Code VARCHAR2,
188 P_Customer_Id NUMBER,
189 P_Order_Header_Id NUMBER,
190 P_Ship_Set_Number NUMBER,
191 P_Inventory_Item_Id NUMBER,
192 P_Order_Type_Id NUMBER,
193 P_From_Requested_Date DATE,
194 P_To_Requested_Date DATE,
195 P_From_Scheduled_Ship_Date DATE,
196 P_To_Scheduled_Ship_Date DATE,
197 P_Ship_To_Location_Id NUMBER,
198 P_Ship_From_Location_Id NUMBER,
199 P_Attribute_Category VARCHAR2,
200 P_Attribute1 VARCHAR2,
201 P_Attribute2 VARCHAR2,
202 P_Attribute3 VARCHAR2,
203 P_Attribute4 VARCHAR2,
204 P_Attribute5 VARCHAR2,
205 P_Attribute6 VARCHAR2,
206 P_Attribute7 VARCHAR2,
207 P_Attribute8 VARCHAR2,
208 P_Attribute9 VARCHAR2,
209 P_Attribute10 VARCHAR2,
210 P_Attribute11 VARCHAR2,
211 P_Attribute12 VARCHAR2,
212 P_Attribute13 VARCHAR2,
213 P_Attribute14 VARCHAR2,
214 P_Attribute15 VARCHAR2,
215 P_Autodetail_Pr_Flag VARCHAR2,
216 P_Carrier_Id NUMBER,
217 P_Trip_Stop_Id NUMBER,
218 P_Default_Stage_Subinventory VARCHAR2,
219 P_Default_Stage_Locator_Id NUMBER,
220 P_Pick_From_Subinventory VARCHAR2,
221 P_Pick_From_locator_Id NUMBER,
222 P_Auto_Pick_Confirm_Flag VARCHAR2,
223 P_Delivery_Detail_Id NUMBER,
224 P_Project_Id NUMBER,
225 P_Task_Id NUMBER,
226 P_Organization_Id NUMBER,
227 P_Ship_Confirm_Rule_Id NUMBER,
228 P_Autopack_Flag VARCHAR2,
229 P_Autopack_Level NUMBER,
230 P_Task_Planning_Flag VARCHAR2,
231 P_Dynamic_replenishment_Flag VARCHAR2 DEFAULT NULL, --bug# 6689448 (replenishment project)
232 P_Non_Picking_flag VARCHAR2 DEFAULT NULL,
233 p_regionID NUMBER,
234 p_zoneId NUMBER,
235 p_categoryID NUMBER,
236 p_categorySetID NUMBER,
237 p_acDelivCriteria VARCHAR2,
238 p_RelSubinventory VARCHAR2,
239 p_append_flag VARCHAR2,
240 p_task_priority NUMBER,
241 p_actual_departure_date DATE DEFAULT NULL,
242 p_allocation_method VARCHAR2, -- X-dock
243 p_crossdock_criteria_id NUMBER, -- X-dock
244 p_client_Id NUMBER DEFAULT NULL --Modified R12.1.1 LSP PROJECT
245 );
246
247
248 PROCEDURE Delete_Row(X_Rowid IN OUT NOCOPY VARCHAR2);
249
250
251 PROCEDURE Delete_And_Commit(X_Rowid IN OUT NOCOPY VARCHAR2);
252
253
254 PROCEDURE Commit_Work;
255
256 --
257 -- Bug # 2231365 : Defaulted the parameter p_log_level to 0
258 --
259 FUNCTION Submit_Release_Request(P_Batch_Id NUMBER,
260 P_Log_Level NUMBER DEFAULT 0,
261 P_Num_Workers NUMBER DEFAULT 1,
262 P_Commit VARCHAR2 DEFAULT NULL)
263 RETURN NUMBER;
264
265
266 PROCEDURE Get_Printer (p_report IN VARCHAR2,
267 x_report_printer OUT NOCOPY VARCHAR2,
268 p_default_report IN VARCHAR2 default 'OEXSHPIK');
269
270
271 END WSH_PICKING_BATCHES_PKG;