[Home] [Help]
PACKAGE: APPS.B_STD_OP_PKG
Source
1 PACKAGE B_STD_OP_PKG AUTHID CURRENT_USER as
2 /* $Header: BOMPISOS.pls 120.2.12010000.2 2008/11/13 09:57:12 sisankar ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Standard_Operation_Id IN OUT NOCOPY NUMBER,
7 X_Operation_Code VARCHAR2,
8 X_Operation_Type NUMBER,
9 X_Line_Id NUMBER DEFAULT NULL,
10 X_Sequence_Num NUMBER DEFAULT NULL,
11 X_Organization_Id NUMBER,
12 X_Department_Id NUMBER,
13 X_Last_Update_Date DATE,
14 X_Last_Updated_By NUMBER,
15 X_Creation_Date DATE,
16 X_Created_By NUMBER,
17 X_Last_Update_Login NUMBER DEFAULT NULL,
18 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
19 X_Count_Point_Type NUMBER DEFAULT NULL,
20 X_Operation_Description VARCHAR2 DEFAULT NULL,
21 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
22 X_Attribute_Category VARCHAR2 DEFAULT NULL,
23 X_Attribute1 VARCHAR2 DEFAULT NULL,
24 X_Attribute2 VARCHAR2 DEFAULT NULL,
25 X_Attribute3 VARCHAR2 DEFAULT NULL,
26 X_Attribute4 VARCHAR2 DEFAULT NULL,
27 X_Attribute5 VARCHAR2 DEFAULT NULL,
28 X_Attribute6 VARCHAR2 DEFAULT NULL,
29 X_Attribute7 VARCHAR2 DEFAULT NULL,
30 X_Attribute8 VARCHAR2 DEFAULT NULL,
31 X_Attribute9 VARCHAR2 DEFAULT NULL,
32 X_Attribute10 VARCHAR2 DEFAULT NULL,
33 X_Attribute11 VARCHAR2 DEFAULT NULL,
34 X_Attribute12 VARCHAR2 DEFAULT NULL,
35 X_Attribute13 VARCHAR2 DEFAULT NULL,
36 X_Attribute14 VARCHAR2 DEFAULT NULL,
37 X_Attribute15 VARCHAR2 DEFAULT NULL,
38 X_Backflush_Flag NUMBER DEFAULT NULL,
39 X_Wms_Task_Type NUMBER DEFAULT NULL,
40 X_Yield NUMBER DEFAULT NULL,
41 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
42 X_Shutdown_Type VARCHAR2 DEFAULT NULL
43 );
44
45 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
46 X_Standard_Operation_Id IN OUT NOCOPY NUMBER,
47 X_Operation_Code VARCHAR2,
48 X_Operation_Type NUMBER,
49 X_Line_Id NUMBER DEFAULT NULL,
50 X_Sequence_Num NUMBER DEFAULT NULL,
51 X_Organization_Id NUMBER,
52 X_Department_Id NUMBER,
53 X_Last_Update_Date DATE,
54 X_Last_Updated_By NUMBER,
55 X_Creation_Date DATE,
56 X_Created_By NUMBER,
57 X_Last_Update_Login NUMBER DEFAULT NULL,
58 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
59 X_Count_Point_Type NUMBER DEFAULT NULL,
60 X_Operation_Description VARCHAR2 DEFAULT NULL,
61 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
62 X_Attribute_Category VARCHAR2 DEFAULT NULL,
63 X_Attribute1 VARCHAR2 DEFAULT NULL,
64 X_Attribute2 VARCHAR2 DEFAULT NULL,
65 X_Attribute3 VARCHAR2 DEFAULT NULL,
66 X_Attribute4 VARCHAR2 DEFAULT NULL,
67 X_Attribute5 VARCHAR2 DEFAULT NULL,
68 X_Attribute6 VARCHAR2 DEFAULT NULL,
69 X_Attribute7 VARCHAR2 DEFAULT NULL,
70 X_Attribute8 VARCHAR2 DEFAULT NULL,
71 X_Attribute9 VARCHAR2 DEFAULT NULL,
72 X_Attribute10 VARCHAR2 DEFAULT NULL,
73 X_Attribute11 VARCHAR2 DEFAULT NULL,
74 X_Attribute12 VARCHAR2 DEFAULT NULL,
75 X_Attribute13 VARCHAR2 DEFAULT NULL,
76 X_Attribute14 VARCHAR2 DEFAULT NULL,
77 X_Attribute15 VARCHAR2 DEFAULT NULL,
78 X_Backflush_Flag NUMBER DEFAULT NULL,
79 X_Wms_Task_Type NUMBER DEFAULT NULL,
80 X_Yield NUMBER DEFAULT NULL,
81 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
82 X_Shutdown_Type VARCHAR2 DEFAULT NULL,
83 X_Default_SubInventory VARCHAR2,
84 X_Default_Locator_Id NUMBER,
85 X_Value_added VARCHAR2 DEFAULT NULL,
86 X_Critical_To_Quality VARCHAR2 DEFAULT NULL
87 );
88
89 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
90 X_Standard_Operation_Id IN OUT NOCOPY NUMBER,
91 X_Operation_Code VARCHAR2,
92 X_Operation_Type NUMBER,
93 X_Line_Id NUMBER DEFAULT NULL,
94 X_Sequence_Num NUMBER DEFAULT NULL,
95 X_Organization_Id NUMBER,
96 X_Department_Id NUMBER,
97 X_Last_Update_Date DATE,
98 X_Last_Updated_By NUMBER,
99 X_Creation_Date DATE,
100 X_Created_By NUMBER,
101 X_Last_Update_Login NUMBER DEFAULT NULL,
102 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
103 X_Count_Point_Type NUMBER DEFAULT NULL,
104 X_Operation_Description VARCHAR2 DEFAULT NULL,
105 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
106 X_Attribute_Category VARCHAR2 DEFAULT NULL,
107 X_Attribute1 VARCHAR2 DEFAULT NULL,
108 X_Attribute2 VARCHAR2 DEFAULT NULL,
109 X_Attribute3 VARCHAR2 DEFAULT NULL,
110 X_Attribute4 VARCHAR2 DEFAULT NULL,
111 X_Attribute5 VARCHAR2 DEFAULT NULL,
112 X_Attribute6 VARCHAR2 DEFAULT NULL,
113 X_Attribute7 VARCHAR2 DEFAULT NULL,
114 X_Attribute8 VARCHAR2 DEFAULT NULL,
115 X_Attribute9 VARCHAR2 DEFAULT NULL,
116 X_Attribute10 VARCHAR2 DEFAULT NULL,
117 X_Attribute11 VARCHAR2 DEFAULT NULL,
118 X_Attribute12 VARCHAR2 DEFAULT NULL,
119 X_Attribute13 VARCHAR2 DEFAULT NULL,
120 X_Attribute14 VARCHAR2 DEFAULT NULL,
121 X_Attribute15 VARCHAR2 DEFAULT NULL,
122 X_Backflush_Flag NUMBER DEFAULT NULL,
123 X_Wms_Task_Type NUMBER DEFAULT NULL,
124 X_Yield NUMBER DEFAULT NULL,
125 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
126 X_Shutdown_Type VARCHAR2 DEFAULT NULL,
127 X_Default_SubInventory VARCHAR2,
128 X_Default_Locator_Id NUMBER,
129 X_Value_added VARCHAR2 DEFAULT NULL,
130 X_Critical_To_Quality VARCHAR2 DEFAULT NULL,
131 --OSFM-MES:Following new arguments are added
132 X_LOWEST_ACCEPTABLE_YIELD NUMBER,
133 X_USE_ORG_SETTINGS NUMBER,
134 X_QUEUE_MANDATORY_FLAG NUMBER,
135 X_RUN_MANDATORY_FLAG NUMBER,
136 X_TO_MOVE_MANDATORY_FLAG NUMBER,
137 X_SHOW_NEXT_OP_BY_DEFAULT NUMBER,
138 X_SHOW_SCRAP_CODE NUMBER,
139 X_SHOW_LOT_ATTRIB NUMBER,
140 X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
141 X_CHECK_SKILL NUMBER DEFAULT NULL
142 );
143
144 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
145 X_Standard_Operation_Id NUMBER,
146 X_Operation_Code VARCHAR2,
147 X_Operation_Type NUMBER,
148 X_Line_Id NUMBER DEFAULT NULL,
149 X_Sequence_Num NUMBER DEFAULT NULL,
150 X_Organization_Id NUMBER,
151 X_Department_Id NUMBER,
152 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
153 X_Count_Point_Type NUMBER DEFAULT NULL,
154 X_Operation_Description VARCHAR2 DEFAULT NULL,
155 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
156 X_Attribute_Category VARCHAR2 DEFAULT NULL,
157 X_Attribute1 VARCHAR2 DEFAULT NULL,
158 X_Attribute2 VARCHAR2 DEFAULT NULL,
159 X_Attribute3 VARCHAR2 DEFAULT NULL,
160 X_Attribute4 VARCHAR2 DEFAULT NULL,
161 X_Attribute5 VARCHAR2 DEFAULT NULL,
162 X_Attribute6 VARCHAR2 DEFAULT NULL,
163 X_Attribute7 VARCHAR2 DEFAULT NULL,
164 X_Attribute8 VARCHAR2 DEFAULT NULL,
165 X_Attribute9 VARCHAR2 DEFAULT NULL,
166 X_Attribute10 VARCHAR2 DEFAULT NULL,
167 X_Attribute11 VARCHAR2 DEFAULT NULL,
168 X_Attribute12 VARCHAR2 DEFAULT NULL,
169 X_Attribute13 VARCHAR2 DEFAULT NULL,
170 X_Attribute14 VARCHAR2 DEFAULT NULL,
171 X_Attribute15 VARCHAR2 DEFAULT NULL,
172 X_Backflush_Flag NUMBER DEFAULT NULL,
173 X_Wms_Task_Type NUMBER DEFAULT NULL,
174 X_Yield NUMBER DEFAULT NULL,
175 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
176 X_Shutdown_Type VARCHAR2 DEFAULT NULL
177 );
178
179 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
180 X_Standard_Operation_Id NUMBER,
181 X_Operation_Code VARCHAR2,
182 X_Operation_Type NUMBER,
183 X_Line_Id NUMBER DEFAULT NULL,
184 X_Sequence_Num NUMBER DEFAULT NULL,
185 X_Organization_Id NUMBER,
186 X_Department_Id NUMBER,
187 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
188 X_Count_Point_Type NUMBER DEFAULT NULL,
189 X_Operation_Description VARCHAR2 DEFAULT NULL,
190 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
191 X_Attribute_Category VARCHAR2 DEFAULT NULL,
192 X_Attribute1 VARCHAR2 DEFAULT NULL,
193 X_Attribute2 VARCHAR2 DEFAULT NULL,
194 X_Attribute3 VARCHAR2 DEFAULT NULL,
195 X_Attribute4 VARCHAR2 DEFAULT NULL,
196 X_Attribute5 VARCHAR2 DEFAULT NULL,
197 X_Attribute6 VARCHAR2 DEFAULT NULL,
198 X_Attribute7 VARCHAR2 DEFAULT NULL,
199 X_Attribute8 VARCHAR2 DEFAULT NULL,
200 X_Attribute9 VARCHAR2 DEFAULT NULL,
201 X_Attribute10 VARCHAR2 DEFAULT NULL,
202 X_Attribute11 VARCHAR2 DEFAULT NULL,
203 X_Attribute12 VARCHAR2 DEFAULT NULL,
204 X_Attribute13 VARCHAR2 DEFAULT NULL,
205 X_Attribute14 VARCHAR2 DEFAULT NULL,
206 X_Attribute15 VARCHAR2 DEFAULT NULL,
207 X_Backflush_Flag NUMBER DEFAULT NULL,
208 X_Wms_Task_Type NUMBER DEFAULT NULL,
209 X_Yield NUMBER DEFAULT NULL,
210 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
211 X_Shutdown_Type VARCHAR2 DEFAULT NULL,
212 X_Default_SubInventory VARCHAR2,
213 X_Default_Locator_Id NUMBER,
214 X_Value_added VARCHAR2 DEFAULT NULL,
215 X_critical_To_Quality VARCHAR2 DEFAULT NULL
216 );
217
218 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
219 X_Standard_Operation_Id NUMBER,
220 X_Operation_Code VARCHAR2,
221 X_Operation_Type NUMBER,
222 X_Line_Id NUMBER DEFAULT NULL,
223 X_Sequence_Num NUMBER DEFAULT NULL,
224 X_Organization_Id NUMBER,
225 X_Department_Id NUMBER,
226 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
227 X_Count_Point_Type NUMBER DEFAULT NULL,
228 X_Operation_Description VARCHAR2 DEFAULT NULL,
229 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
230 X_Attribute_Category VARCHAR2 DEFAULT NULL,
231 X_Attribute1 VARCHAR2 DEFAULT NULL,
232 X_Attribute2 VARCHAR2 DEFAULT NULL,
233 X_Attribute3 VARCHAR2 DEFAULT NULL,
234 X_Attribute4 VARCHAR2 DEFAULT NULL,
235 X_Attribute5 VARCHAR2 DEFAULT NULL,
239 X_Attribute9 VARCHAR2 DEFAULT NULL,
236 X_Attribute6 VARCHAR2 DEFAULT NULL,
237 X_Attribute7 VARCHAR2 DEFAULT NULL,
238 X_Attribute8 VARCHAR2 DEFAULT NULL,
240 X_Attribute10 VARCHAR2 DEFAULT NULL,
241 X_Attribute11 VARCHAR2 DEFAULT NULL,
242 X_Attribute12 VARCHAR2 DEFAULT NULL,
243 X_Attribute13 VARCHAR2 DEFAULT NULL,
244 X_Attribute14 VARCHAR2 DEFAULT NULL,
245 X_Attribute15 VARCHAR2 DEFAULT NULL,
246 X_Backflush_Flag NUMBER DEFAULT NULL,
247 X_Wms_Task_Type NUMBER DEFAULT NULL,
248 X_Yield NUMBER DEFAULT NULL,
249 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
250 X_Shutdown_Type VARCHAR2 DEFAULT NULL,
251 X_Default_SubInventory VARCHAR2,
252 X_Default_Locator_Id NUMBER,
253 X_Value_added VARCHAR2 DEFAULT NULL,
254 X_critical_To_Quality VARCHAR2 DEFAULT NULL,
255 --OSFM-MES:Following new arguments are added
256 X_LOWEST_ACCEPTABLE_YIELD NUMBER,
257 X_USE_ORG_SETTINGS NUMBER,
258 X_QUEUE_MANDATORY_FLAG NUMBER,
259 X_RUN_MANDATORY_FLAG NUMBER,
260 X_TO_MOVE_MANDATORY_FLAG NUMBER,
261 X_SHOW_NEXT_OP_BY_DEFAULT NUMBER,
262 X_SHOW_SCRAP_CODE NUMBER,
263 X_SHOW_LOT_ATTRIB NUMBER,
264 X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
265 X_CHECK_SKILL NUMBER DEFAULT NULL
266 );
267
268
269 PROCEDURE Update_Row(X_Rowid VARCHAR2,
270 X_Standard_Operation_Id NUMBER,
271 X_Operation_Code VARCHAR2,
272 X_Operation_Type NUMBER,
273 X_Line_Id NUMBER DEFAULT NULL,
274 X_Sequence_Num NUMBER DEFAULT NULL,
275 X_Organization_Id NUMBER,
276 X_Department_Id NUMBER,
277 X_Last_Update_Date DATE,
278 X_Last_Updated_By NUMBER,
279 X_Last_Update_Login NUMBER DEFAULT NULL,
280 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
281 X_Count_Point_Type NUMBER DEFAULT NULL,
282 X_Operation_Description VARCHAR2 DEFAULT NULL,
283 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
284 X_Attribute_Category VARCHAR2 DEFAULT NULL,
285 X_Attribute1 VARCHAR2 DEFAULT NULL,
286 X_Attribute2 VARCHAR2 DEFAULT NULL,
287 X_Attribute3 VARCHAR2 DEFAULT NULL,
288 X_Attribute4 VARCHAR2 DEFAULT NULL,
289 X_Attribute5 VARCHAR2 DEFAULT NULL,
290 X_Attribute6 VARCHAR2 DEFAULT NULL,
291 X_Attribute7 VARCHAR2 DEFAULT NULL,
292 X_Attribute8 VARCHAR2 DEFAULT NULL,
293 X_Attribute9 VARCHAR2 DEFAULT NULL,
294 X_Attribute10 VARCHAR2 DEFAULT NULL,
295 X_Attribute11 VARCHAR2 DEFAULT NULL,
296 X_Attribute12 VARCHAR2 DEFAULT NULL,
297 X_Attribute13 VARCHAR2 DEFAULT NULL,
298 X_Attribute14 VARCHAR2 DEFAULT NULL,
299 X_Attribute15 VARCHAR2 DEFAULT NULL,
300 X_Backflush_Flag NUMBER DEFAULT NULL,
301 X_Wms_Task_Type NUMBER DEFAULT NULL,
302 X_Yield NUMBER DEFAULT NULL,
303 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
304 X_Shutdown_Type VARCHAR2 DEFAULT NULL
305 );
306
307 PROCEDURE Update_Row(X_Rowid VARCHAR2,
308 X_Standard_Operation_Id NUMBER,
309 X_Operation_Code VARCHAR2,
310 X_Operation_Type NUMBER,
311 X_Line_Id NUMBER DEFAULT NULL,
312 X_Sequence_Num NUMBER DEFAULT NULL,
313 X_Organization_Id NUMBER,
314 X_Department_Id NUMBER,
315 X_Last_Update_Date DATE,
316 X_Last_Updated_By NUMBER,
317 X_Last_Update_Login NUMBER DEFAULT NULL,
321 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
318 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
319 X_Count_Point_Type NUMBER DEFAULT NULL,
320 X_Operation_Description VARCHAR2 DEFAULT NULL,
322 X_Attribute_Category VARCHAR2 DEFAULT NULL,
323 X_Attribute1 VARCHAR2 DEFAULT NULL,
324 X_Attribute2 VARCHAR2 DEFAULT NULL,
325 X_Attribute3 VARCHAR2 DEFAULT NULL,
326 X_Attribute4 VARCHAR2 DEFAULT NULL,
327 X_Attribute5 VARCHAR2 DEFAULT NULL,
328 X_Attribute6 VARCHAR2 DEFAULT NULL,
329 X_Attribute7 VARCHAR2 DEFAULT NULL,
330 X_Attribute8 VARCHAR2 DEFAULT NULL,
331 X_Attribute9 VARCHAR2 DEFAULT NULL,
332 X_Attribute10 VARCHAR2 DEFAULT NULL,
333 X_Attribute11 VARCHAR2 DEFAULT NULL,
334 X_Attribute12 VARCHAR2 DEFAULT NULL,
335 X_Attribute13 VARCHAR2 DEFAULT NULL,
336 X_Attribute14 VARCHAR2 DEFAULT NULL,
337 X_Attribute15 VARCHAR2 DEFAULT NULL,
338 X_Backflush_Flag NUMBER DEFAULT NULL,
339 X_Wms_Task_Type NUMBER DEFAULT NULL,
340 X_Yield NUMBER DEFAULT NULL,
341 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
342 X_Shutdown_Type VARCHAR2 DEFAULT NULL,
343 X_Default_SubInventory VARCHAR2,
344 X_Default_Locator_Id NUMBER,
345 X_Value_added VARCHAR2 DEFAULT NULL,
346 X_critical_To_Quality VARCHAR2 DEFAULT NULL
347 );
348
349 PROCEDURE Update_Row(X_Rowid VARCHAR2,
350 X_Standard_Operation_Id NUMBER,
351 X_Operation_Code VARCHAR2,
352 X_Operation_Type NUMBER,
353 X_Line_Id NUMBER DEFAULT NULL,
354 X_Sequence_Num NUMBER DEFAULT NULL,
355 X_Organization_Id NUMBER,
356 X_Department_Id NUMBER,
357 X_Last_Update_Date DATE,
358 X_Last_Updated_By NUMBER,
359 X_Last_Update_Login NUMBER DEFAULT NULL,
360 X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
361 X_Count_Point_Type NUMBER DEFAULT NULL,
362 X_Operation_Description VARCHAR2 DEFAULT NULL,
363 X_Option_Dependent_Flag NUMBER DEFAULT NULL,
364 X_Attribute_Category VARCHAR2 DEFAULT NULL,
365 X_Attribute1 VARCHAR2 DEFAULT NULL,
366 X_Attribute2 VARCHAR2 DEFAULT NULL,
367 X_Attribute3 VARCHAR2 DEFAULT NULL,
368 X_Attribute4 VARCHAR2 DEFAULT NULL,
369 X_Attribute5 VARCHAR2 DEFAULT NULL,
370 X_Attribute6 VARCHAR2 DEFAULT NULL,
371 X_Attribute7 VARCHAR2 DEFAULT NULL,
372 X_Attribute8 VARCHAR2 DEFAULT NULL,
373 X_Attribute9 VARCHAR2 DEFAULT NULL,
374 X_Attribute10 VARCHAR2 DEFAULT NULL,
375 X_Attribute11 VARCHAR2 DEFAULT NULL,
376 X_Attribute12 VARCHAR2 DEFAULT NULL,
377 X_Attribute13 VARCHAR2 DEFAULT NULL,
378 X_Attribute14 VARCHAR2 DEFAULT NULL,
379 X_Attribute15 VARCHAR2 DEFAULT NULL,
380 X_Backflush_Flag NUMBER DEFAULT NULL,
381 X_Wms_Task_Type NUMBER DEFAULT NULL,
382 X_Yield NUMBER DEFAULT NULL,
383 X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
384 X_Shutdown_Type VARCHAR2 DEFAULT NULL,
385 X_Default_SubInventory VARCHAR2,
386 X_Default_Locator_Id NUMBER,
387 X_Value_added VARCHAR2 DEFAULT NULL,
388 X_critical_To_Quality VARCHAR2 DEFAULT NULL,
389 --OSFM-MES:Following new arguments are added
390 X_LOWEST_ACCEPTABLE_YIELD NUMBER,
391 X_USE_ORG_SETTINGS NUMBER,
392 X_QUEUE_MANDATORY_FLAG NUMBER,
393 X_RUN_MANDATORY_FLAG NUMBER,
394 X_TO_MOVE_MANDATORY_FLAG NUMBER,
395 X_SHOW_NEXT_OP_BY_DEFAULT NUMBER,
396 X_SHOW_SCRAP_CODE NUMBER,
400 );
397 X_SHOW_LOT_ATTRIB NUMBER,
398 X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
399 X_CHECK_SKILL NUMBER DEFAULT NULL
401
402
403 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
404 X_Standard_Operation_Id NUMBER);
405
406
407
408 PROCEDURE Check_Unique(X_Rowid VARCHAR2,
409 X_Organization_Id NUMBER,
410 X_Operation_Code VARCHAR2,
411 X_Line_Id NUMBER,
412 X_Operation_Type NUMBER);
413
414 PROCEDURE Check_Unique_Seq(X_Rowid VARCHAR2,
415 X_Organization_Id NUMBER,
416 X_Operation_Code VARCHAR2,
417 X_Line_Id NUMBER,
418 X_Operation_Type NUMBER,
419 X_Sequence_Num NUMBER);
420
421
422 PROCEDURE Check_References(X_Standard_Operation_Id NUMBER,
423 X_Operation_Code VARCHAR2);
424
425 PROCEDURE Delete_Details(X_Standard_Operation_Id NUMBER);
426
427 FUNCTION Check_Wms_exists(p_std_operation_id IN NUMBER) RETURN BOOLEAN; -- BUG 3986337
428
429 /*=====================================================================+
430 | PROCEDURE
431 | Check_Setup_Std_Op_Ref
432 |
433 | PURPOSE
434 | Deletion of Setup Standard Operations that are being referenced in
435 | Setup Changeovers should not be allowed.
436 | Added this Procedure for BUG 4256393
437 | ARGUMENTS
438 | IN
439 | P_Standard_Operation_Id
440 | P_Operation_Code
441 +=====================================================================*/
442 PROCEDURE Check_Setup_Std_Op_Ref( P_Standard_Operation_Id NUMBER,
443 P_Operation_Code VARCHAR2 ); -- BUG 4256393
444
445 END B_STD_OP_PKG;