[Home] [Help]
PACKAGE: APPS.WIP_OPERATIONS_PKG
Source
1 PACKAGE WIP_OPERATIONS_PKG AS
2 /* $Header: wipopers.pls 120.0.12010000.2 2008/11/13 15:01:14 sisankar ship $ */
3
4 /*=====================================================================+
5 | PROCEDURE
6 | ADD
7 |
8 | PURPOSE
9 | Add an operation to the routing
10 |
11 | ARGUMENTS
12 | IN
13 | p_org_id Organization ID
14 | p_wip_entity_id WIP entity ID
15 | p_operation_seq_num Sequence of operation to be added
16 | p_operation_id Standard operation ID to be added (may be NULL)
17 | p_department_id Department ID associated with the new operation
18 |
19 | EXCEPTIONS
20 | Calls FND_MESSAGE.RAISE_ERROR upon detection of error.
21 |
22 | NOTES
23 |
24 +=====================================================================*/
25 procedure add(
26 p_org_id in number,
27 p_wip_entity_id in number,
28 p_operation_seq_num in number,
29 p_operation_id in number,
30 p_department_id in number);
31
32 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
33 X_Wip_Entity_Id NUMBER,
34 X_Operation_Seq_Num NUMBER,
35 X_Organization_Id NUMBER,
36 X_Repetitive_Schedule_Id NUMBER,
37 X_Last_Update_Date DATE,
38 X_Last_Updated_By NUMBER,
39 X_Creation_Date DATE,
40 X_Created_By NUMBER,
41 X_Last_Update_Login NUMBER,
42 X_Operation_Sequence_Id NUMBER,
43 X_Standard_Operation_Id NUMBER,
44 X_Department_Id NUMBER,
45 X_Description VARCHAR2,
46 X_Scheduled_Quantity NUMBER,
47 X_Quantity_In_Queue NUMBER,
48 X_Quantity_Running NUMBER,
49 X_Quantity_Waiting_To_Move NUMBER,
50 X_Quantity_Rejected NUMBER,
51 X_Quantity_Scrapped NUMBER,
52 X_Quantity_Completed NUMBER,
53 X_First_Unit_Start_Date DATE,
54 X_First_Unit_Completion_Date DATE,
55 X_Last_Unit_Start_Date DATE,
56 X_Last_Unit_Completion_Date DATE,
57 X_Previous_Operation_Seq_Num NUMBER,
58 X_Next_Operation_Seq_Num NUMBER,
59 X_Count_Point_Type NUMBER,
60 X_Backflush_Flag NUMBER,
61 X_Minimum_Transfer_Quantity NUMBER,
62 X_Date_Last_Moved DATE,
63 /*3118918*/ X_Progress_percentage NUMBER,
64 X_Attribute_Category VARCHAR2,
65 X_Attribute1 VARCHAR2,
66 X_Attribute2 VARCHAR2,
67 X_Attribute3 VARCHAR2,
68 X_Attribute4 VARCHAR2,
69 X_Attribute5 VARCHAR2,
70 X_Attribute6 VARCHAR2,
71 X_Attribute7 VARCHAR2,
72 X_Attribute8 VARCHAR2,
73 X_Attribute9 VARCHAR2,
74 X_Attribute10 VARCHAR2,
75 X_Attribute11 VARCHAR2,
76 X_Attribute12 VARCHAR2,
77 X_Attribute13 VARCHAR2,
78 X_Attribute14 VARCHAR2,
79 X_Attribute15 VARCHAR2,
80 X_CHECK_SKILL NUMBER DEFAULT NULL
81 );
82
83 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
84 X_Wip_Entity_Id NUMBER,
85 X_Operation_Seq_Num NUMBER,
86 X_Organization_Id NUMBER,
87 X_Repetitive_Schedule_Id NUMBER,
88 X_Operation_Sequence_Id NUMBER,
89 X_Standard_Operation_Id NUMBER,
90 X_Department_Id NUMBER,
91 X_Description VARCHAR2,
92 X_Scheduled_Quantity NUMBER,
93 X_Quantity_In_Queue NUMBER,
94 X_Quantity_Running NUMBER,
95 X_Quantity_Waiting_To_Move NUMBER,
96 X_Quantity_Rejected NUMBER,
97 X_Quantity_Scrapped NUMBER,
98 X_Quantity_Completed NUMBER,
99 X_First_Unit_Start_Date DATE,
100 X_First_Unit_Completion_Date DATE,
101 X_Last_Unit_Start_Date DATE,
102 X_Last_Unit_Completion_Date DATE,
103 X_Count_Point_Type NUMBER,
104 X_Backflush_Flag NUMBER,
105 X_Minimum_Transfer_Quantity NUMBER,
106 X_Date_Last_Moved DATE,
107 /*3118918*/ X_Progress_percentage NUMBER,
108 X_Attribute_Category VARCHAR2,
109 X_Attribute1 VARCHAR2,
110 X_Attribute2 VARCHAR2,
111 X_Attribute3 VARCHAR2,
112 X_Attribute4 VARCHAR2,
113 X_Attribute5 VARCHAR2,
114 X_Attribute6 VARCHAR2,
115 X_Attribute7 VARCHAR2,
116 X_Attribute8 VARCHAR2,
117 X_Attribute9 VARCHAR2,
118 X_Attribute10 VARCHAR2,
119 X_Attribute11 VARCHAR2,
120 X_Attribute12 VARCHAR2,
121 X_Attribute13 VARCHAR2,
122 X_Attribute14 VARCHAR2,
123 X_Attribute15 VARCHAR2,
124 X_CHECK_SKILL NUMBER DEFAULT NULL
125 );
126
127 PROCEDURE Update_Row(X_Rowid VARCHAR2,
128 X_Wip_Entity_Id NUMBER,
129 X_Operation_Seq_Num NUMBER,
130 X_Organization_Id NUMBER,
131 X_Repetitive_Schedule_Id NUMBER,
132 X_Last_Update_Date DATE,
133 X_Last_Updated_By NUMBER,
134 X_Last_Update_Login NUMBER,
135 X_Operation_Sequence_Id NUMBER,
136 X_Standard_Operation_Id NUMBER,
137 X_Department_Id NUMBER,
138 X_Description VARCHAR2,
139 X_Scheduled_Quantity NUMBER,
140 X_Quantity_In_Queue NUMBER,
141 X_Quantity_Running NUMBER,
142 X_Quantity_Waiting_To_Move NUMBER,
143 X_Quantity_Rejected NUMBER,
144 X_Quantity_Scrapped NUMBER,
145 X_Quantity_Completed NUMBER,
146 X_First_Unit_Start_Date DATE,
147 X_First_Unit_Completion_Date DATE,
148 X_Last_Unit_Start_Date DATE,
149 X_Last_Unit_Completion_Date DATE,
150 X_Count_Point_Type NUMBER,
151 X_Backflush_Flag NUMBER,
152 X_Minimum_Transfer_Quantity NUMBER,
153 X_Date_Last_Moved DATE,
154 /*3118918*/ X_Progress_percentage NUMBER,
155 X_Attribute_Category VARCHAR2,
156 X_Attribute1 VARCHAR2,
157 X_Attribute2 VARCHAR2,
158 X_Attribute3 VARCHAR2,
159 X_Attribute4 VARCHAR2,
160 X_Attribute5 VARCHAR2,
161 X_Attribute6 VARCHAR2,
162 X_Attribute7 VARCHAR2,
163 X_Attribute8 VARCHAR2,
164 X_Attribute9 VARCHAR2,
165 X_Attribute10 VARCHAR2,
166 X_Attribute11 VARCHAR2,
167 X_Attribute12 VARCHAR2,
168 X_Attribute13 VARCHAR2,
169 X_Attribute14 VARCHAR2,
170 X_Attribute15 VARCHAR2,
171 X_CHECK_SKILL NUMBER DEFAULT NULL
172 );
173
174 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
175
176
177 -- the following provides backward compatibility for EAM under 11.5.10
178
179 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
180 X_Wip_Entity_Id NUMBER,
181 X_Operation_Seq_Num NUMBER,
182 X_Organization_Id NUMBER,
183 X_Repetitive_Schedule_Id NUMBER,
184 X_Last_Update_Date DATE,
185 X_Last_Updated_By NUMBER,
186 X_Creation_Date DATE,
187 X_Created_By NUMBER,
188 X_Last_Update_Login NUMBER,
189 X_Operation_Sequence_Id NUMBER,
190 X_Standard_Operation_Id NUMBER,
191 X_Department_Id NUMBER,
192 X_Description VARCHAR2,
193 X_Scheduled_Quantity NUMBER,
194 X_Quantity_In_Queue NUMBER,
195 X_Quantity_Running NUMBER,
196 X_Quantity_Waiting_To_Move NUMBER,
197 X_Quantity_Rejected NUMBER,
198 X_Quantity_Scrapped NUMBER,
199 X_Quantity_Completed NUMBER,
200 X_First_Unit_Start_Date DATE,
201 X_First_Unit_Completion_Date DATE,
202 X_Last_Unit_Start_Date DATE,
203 X_Last_Unit_Completion_Date DATE,
204 X_Previous_Operation_Seq_Num NUMBER,
205 X_Next_Operation_Seq_Num NUMBER,
206 X_Count_Point_Type NUMBER,
207 X_Backflush_Flag NUMBER,
208 X_Minimum_Transfer_Quantity NUMBER,
209 X_Date_Last_Moved DATE,
210 X_Attribute_Category VARCHAR2,
211 X_Attribute1 VARCHAR2,
212 X_Attribute2 VARCHAR2,
213 X_Attribute3 VARCHAR2,
214 X_Attribute4 VARCHAR2,
215 X_Attribute5 VARCHAR2,
216 X_Attribute6 VARCHAR2,
217 X_Attribute7 VARCHAR2,
218 X_Attribute8 VARCHAR2,
219 X_Attribute9 VARCHAR2,
220 X_Attribute10 VARCHAR2,
221 X_Attribute11 VARCHAR2,
222 X_Attribute12 VARCHAR2,
223 X_Attribute13 VARCHAR2,
224 X_Attribute14 VARCHAR2,
225 X_Attribute15 VARCHAR2
226 );
227
228 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
229 X_Wip_Entity_Id NUMBER,
230 X_Operation_Seq_Num NUMBER,
231 X_Organization_Id NUMBER,
232 X_Repetitive_Schedule_Id NUMBER,
233 X_Operation_Sequence_Id NUMBER,
234 X_Standard_Operation_Id NUMBER,
235 X_Department_Id NUMBER,
236 X_Description VARCHAR2,
237 X_Scheduled_Quantity NUMBER,
238 X_Quantity_In_Queue NUMBER,
239 X_Quantity_Running NUMBER,
240 X_Quantity_Waiting_To_Move NUMBER,
241 X_Quantity_Rejected NUMBER,
242 X_Quantity_Scrapped NUMBER,
243 X_Quantity_Completed NUMBER,
244 X_First_Unit_Start_Date DATE,
245 X_First_Unit_Completion_Date DATE,
246 X_Last_Unit_Start_Date DATE,
247 X_Last_Unit_Completion_Date DATE,
248 X_Count_Point_Type NUMBER,
249 X_Backflush_Flag NUMBER,
250 X_Minimum_Transfer_Quantity NUMBER,
251 X_Date_Last_Moved DATE,
252 X_Attribute_Category VARCHAR2,
253 X_Attribute1 VARCHAR2,
254 X_Attribute2 VARCHAR2,
255 X_Attribute3 VARCHAR2,
256 X_Attribute4 VARCHAR2,
257 X_Attribute5 VARCHAR2,
258 X_Attribute6 VARCHAR2,
259 X_Attribute7 VARCHAR2,
260 X_Attribute8 VARCHAR2,
261 X_Attribute9 VARCHAR2,
262 X_Attribute10 VARCHAR2,
263 X_Attribute11 VARCHAR2,
264 X_Attribute12 VARCHAR2,
265 X_Attribute13 VARCHAR2,
266 X_Attribute14 VARCHAR2,
267 X_Attribute15 VARCHAR2
268 );
269
270 PROCEDURE Update_Row(X_Rowid VARCHAR2,
271 X_Wip_Entity_Id NUMBER,
272 X_Operation_Seq_Num NUMBER,
273 X_Organization_Id NUMBER,
274 X_Repetitive_Schedule_Id NUMBER,
275 X_Last_Update_Date DATE,
276 X_Last_Updated_By NUMBER,
277 X_Last_Update_Login NUMBER,
278 X_Operation_Sequence_Id NUMBER,
279 X_Standard_Operation_Id NUMBER,
280 X_Department_Id NUMBER,
281 X_Description VARCHAR2,
282 X_Scheduled_Quantity NUMBER,
283 X_Quantity_In_Queue NUMBER,
284 X_Quantity_Running NUMBER,
285 X_Quantity_Waiting_To_Move NUMBER,
286 X_Quantity_Rejected NUMBER,
287 X_Quantity_Scrapped NUMBER,
288 X_Quantity_Completed NUMBER,
289 X_First_Unit_Start_Date DATE,
290 X_First_Unit_Completion_Date DATE,
291 X_Last_Unit_Start_Date DATE,
292 X_Last_Unit_Completion_Date DATE,
293 X_Count_Point_Type NUMBER,
294 X_Backflush_Flag NUMBER,
295 X_Minimum_Transfer_Quantity NUMBER,
296 X_Date_Last_Moved DATE,
297 X_Attribute_Category VARCHAR2,
298 X_Attribute1 VARCHAR2,
299 X_Attribute2 VARCHAR2,
300 X_Attribute3 VARCHAR2,
301 X_Attribute4 VARCHAR2,
302 X_Attribute5 VARCHAR2,
303 X_Attribute6 VARCHAR2,
304 X_Attribute7 VARCHAR2,
305 X_Attribute8 VARCHAR2,
306 X_Attribute9 VARCHAR2,
307 X_Attribute10 VARCHAR2,
308 X_Attribute11 VARCHAR2,
309 X_Attribute12 VARCHAR2,
310 X_Attribute13 VARCHAR2,
311 X_Attribute14 VARCHAR2,
312 X_Attribute15 VARCHAR2
313 );
314
315
316 END WIP_OPERATIONS_PKG;