[Home] [Help]
PACKAGE: APPS.WIP_WORK_ORDER_PUB
Source
1 PACKAGE WIP_Work_Order_PUB AUTHID CURRENT_USER AS
2 /* $Header: WIPPWORS.pls 120.1 2005/06/13 09:27:20 appldev $ */
3
4 -- Wip_Entities record type
5
6 TYPE Wip_Entities_Rec_Type IS RECORD
7 ( created_by NUMBER
8 , creation_date DATE
9 , description VARCHAR2(240)
10 , entity_type NUMBER
11 , last_updated_by NUMBER
12 , last_update_date DATE
13 , last_update_login NUMBER
14 , organization_id NUMBER
15 , primary_item_id NUMBER
16 , program_application_id NUMBER
17 , program_id NUMBER
18 , program_update_date DATE
19 , request_id NUMBER
20 , wip_entity_id NUMBER
21 , wip_entity_name VARCHAR2(240)
22 , return_status VARCHAR2(1)
23 , db_flag VARCHAR2(1)
24 , action VARCHAR2(30)
25 );
26
27 TYPE Wip_Entities_Tbl_Type IS TABLE OF Wip_Entities_Rec_Type
28 INDEX BY BINARY_INTEGER;
29
30 -- Wip_Entities value record type
31
32 TYPE Wip_Entities_Val_Rec_Type IS RECORD
33 ( organization VARCHAR2(240)
34 , primary_item VARCHAR2(240)
35 , wip_entity VARCHAR2(240)
36 );
37
38 TYPE Wip_Entities_Val_Tbl_Type IS TABLE OF Wip_Entities_Val_Rec_Type
39 INDEX BY BINARY_INTEGER;
40
41 -- Flowschedule record type
42
43 TYPE Flowschedule_Rec_Type IS RECORD
44 ( alternate_bom_designator VARCHAR2(10)
45 , alternate_rout_designator VARCHAR2(10)
46 , attribute1 VARCHAR2(150)
47 , attribute10 VARCHAR2(150)
48 , attribute11 VARCHAR2(150)
49 , attribute12 VARCHAR2(150)
50 , attribute13 VARCHAR2(150)
51 , attribute14 VARCHAR2(150)
52 , attribute15 VARCHAR2(150)
53 , attribute2 VARCHAR2(150)
54 , attribute3 VARCHAR2(150)
55 , attribute4 VARCHAR2(150)
56 , attribute5 VARCHAR2(150)
57 , attribute6 VARCHAR2(150)
58 , attribute7 VARCHAR2(150)
59 , attribute8 VARCHAR2(150)
60 , attribute9 VARCHAR2(150)
61 , attribute_category VARCHAR2(30)
62 , bom_revision VARCHAR2(3)
63 , bom_revision_date DATE
64 , build_sequence NUMBER
65 , class_code VARCHAR2(10)
66 , completion_locator_id NUMBER
67 , completion_subinventory VARCHAR2(10)
68 , created_by NUMBER
69 , creation_date DATE
70 , date_closed DATE
71 , demand_class VARCHAR2(30)
72 , demand_source_delivery VARCHAR2(30)
73 , demand_source_header_id NUMBER
74 , demand_source_line VARCHAR2(30)
75 , demand_source_type NUMBER
76 , kanban_card_id NUMBER
77 , last_updated_by NUMBER
78 , last_update_date DATE
79 , last_update_login NUMBER
80 , line_id NUMBER
81 , material_account NUMBER
82 , material_overhead_account NUMBER
83 , material_variance_account NUMBER
84 , mps_net_quantity NUMBER
85 , mps_scheduled_cpl_date DATE
86 , organization_id NUMBER
87 , osp_account NUMBER
88 , osp_variance_account NUMBER
89 , overhead_account NUMBER
90 , overhead_variance_account NUMBER
91 , planned_quantity NUMBER
92 , primary_item_id NUMBER
93 , program_application_id NUMBER
94 , program_id NUMBER
95 , program_update_date DATE
96 , project_id NUMBER
97 , quantity_completed NUMBER
98 , request_id NUMBER
99 , resource_account NUMBER
100 , resource_variance_account NUMBER
101 , routing_revision VARCHAR2(3)
102 , routing_revision_date DATE
103 , scheduled_completion_date DATE
104 , scheduled_flag NUMBER
105 , scheduled_start_date DATE
106 , schedule_group_id NUMBER
107 , schedule_number VARCHAR2(30)
108 , status NUMBER
109 , std_cost_adj_account NUMBER
110 , task_id NUMBER
111 , wip_entity_id NUMBER
112 , return_status VARCHAR2(1)
113 , db_flag VARCHAR2(1)
114 , action VARCHAR2(30)
115 , Wip_Entities_index NUMBER
116 );
117
118 TYPE Flowschedule_Tbl_Type IS TABLE OF Flowschedule_Rec_Type
119 INDEX BY BINARY_INTEGER;
120
121 -- Flowschedule value record type
122
123 TYPE Flowschedule_Val_Rec_Type IS RECORD
124 ( class VARCHAR2(240)
125 , completion_locator VARCHAR2(240)
126 , demand_source_header VARCHAR2(240)
127 , kanban_card VARCHAR2(240)
128 , line VARCHAR2(240)
129 , organization VARCHAR2(240)
130 , primary_item VARCHAR2(240)
131 , project VARCHAR2(240)
132 , scheduled VARCHAR2(240)
133 , schedule_group VARCHAR2(240)
134 , task VARCHAR2(240)
135 , wip_entity VARCHAR2(240)
136 );
137
138 TYPE Flowschedule_Val_Tbl_Type IS TABLE OF Flowschedule_Val_Rec_Type
139 INDEX BY BINARY_INTEGER;
140
141 -- Discretejob record type
142
143 /* ER 4378835: Increased length of lot_number from 30 to 80 to support OPM Lot-model changes */
144 TYPE Discretejob_Rec_Type IS RECORD
145 ( alternate_bom_designator VARCHAR2(10)
146 , alternate_rout_designator VARCHAR2(10)
147 , attribute1 VARCHAR2(150)
148 , attribute10 VARCHAR2(150)
149 , attribute11 VARCHAR2(150)
150 , attribute12 VARCHAR2(150)
151 , attribute13 VARCHAR2(150)
152 , attribute14 VARCHAR2(150)
153 , attribute15 VARCHAR2(150)
154 , attribute2 VARCHAR2(150)
155 , attribute3 VARCHAR2(150)
156 , attribute4 VARCHAR2(150)
157 , attribute5 VARCHAR2(150)
158 , attribute6 VARCHAR2(150)
159 , attribute7 VARCHAR2(150)
160 , attribute8 VARCHAR2(150)
161 , attribute9 VARCHAR2(150)
162 , attribute_category VARCHAR2(30)
163 , bom_reference_id NUMBER
164 , bom_revision VARCHAR2(3)
165 , bom_revision_date DATE
166 , build_sequence NUMBER
167 , class_code VARCHAR2(10)
168 , common_bom_sequence_id NUMBER
169 , common_rout_sequence_id NUMBER
170 , completion_locator_id NUMBER
171 , completion_subinventory VARCHAR2(10)
172 , created_by NUMBER
173 , creation_date DATE
174 , date_closed DATE
175 , date_completed DATE
176 , date_released DATE
177 , demand_class VARCHAR2(30)
178 , description VARCHAR2(240)
179 , firm_planned_flag NUMBER
180 , job_type NUMBER
181 , kanban_card_id NUMBER
182 , last_updated_by NUMBER
183 , last_update_date DATE
184 , last_update_login NUMBER
185 , line_id NUMBER
186 , lot_number VARCHAR2(80)
187 , material_account NUMBER
188 , material_overhead_account NUMBER
189 , material_variance_account NUMBER
190 , mps_net_quantity NUMBER
191 , mps_scheduled_cpl_date DATE
192 , net_quantity NUMBER
193 , organization_id NUMBER
194 , osp_account NUMBER
195 , osp_variance_account NUMBER
196 , overcpl_tolerance_type NUMBER
197 , overcpl_tolerance_value NUMBER
198 , overhead_account NUMBER
199 , overhead_variance_account NUMBER
200 , primary_item_id NUMBER
201 , program_application_id NUMBER
202 , program_id NUMBER
203 , program_update_date DATE
204 , project_costed NUMBER
205 , project_id NUMBER
206 , quantity_completed NUMBER
207 , quantity_scrapped NUMBER
208 , request_id NUMBER
209 , resource_account NUMBER
210 , resource_variance_account NUMBER
211 , routing_reference_id NUMBER
212 , routing_revision VARCHAR2(3)
213 , routing_revision_date DATE
214 , scheduled_completion_date DATE
215 , scheduled_start_date DATE
216 , schedule_group_id NUMBER
217 , source_code VARCHAR2(30)
218 , source_line_id NUMBER
219 , start_quantity NUMBER
220 , status_type NUMBER
221 , std_cost_adj_account NUMBER
222 , task_id NUMBER
223 , wip_entity_id NUMBER
224 , wip_supply_type NUMBER
225 , return_status VARCHAR2(1)
226 , db_flag VARCHAR2(1)
227 , action VARCHAR2(30)
228 , Wip_Entities_index NUMBER
229 );
230
231 TYPE Discretejob_Tbl_Type IS TABLE OF Discretejob_Rec_Type
232 INDEX BY BINARY_INTEGER;
233
234 -- Discretejob value record type
235
236 TYPE Discretejob_Val_Rec_Type IS RECORD
237 ( bom_reference VARCHAR2(240)
238 , class VARCHAR2(240)
239 , common_bom_sequence VARCHAR2(240)
240 , common_rout_sequence VARCHAR2(240)
241 , completion_locator VARCHAR2(240)
242 , firm_planned VARCHAR2(240)
243 , kanban_card VARCHAR2(240)
244 , line VARCHAR2(240)
245 , organization VARCHAR2(240)
246 , primary_item VARCHAR2(240)
247 , project VARCHAR2(240)
248 , routing_reference VARCHAR2(240)
249 , schedule_group VARCHAR2(240)
250 , source VARCHAR2(240)
251 , source_line VARCHAR2(240)
252 , task VARCHAR2(240)
253 , wip_entity VARCHAR2(240)
254 );
255
256 TYPE Discretejob_Val_Tbl_Type IS TABLE OF Discretejob_Val_Rec_Type
257 INDEX BY BINARY_INTEGER;
258
259 -- Repschedule record type
260
261 TYPE Repschedule_Rec_Type IS RECORD
262 ( alternate_bom_designator VARCHAR2(10)
263 , alternate_rout_designator VARCHAR2(10)
264 , attribute1 VARCHAR2(150)
265 , attribute10 VARCHAR2(150)
266 , attribute11 VARCHAR2(150)
267 , attribute12 VARCHAR2(150)
268 , attribute13 VARCHAR2(150)
269 , attribute14 VARCHAR2(150)
270 , attribute15 VARCHAR2(150)
271 , attribute2 VARCHAR2(150)
272 , attribute3 VARCHAR2(150)
273 , attribute4 VARCHAR2(150)
274 , attribute5 VARCHAR2(150)
275 , attribute6 VARCHAR2(150)
276 , attribute7 VARCHAR2(150)
277 , attribute8 VARCHAR2(150)
278 , attribute9 VARCHAR2(150)
279 , attribute_category VARCHAR2(30)
280 , bom_revision VARCHAR2(3)
281 , bom_revision_date DATE
282 , common_bom_sequence_id NUMBER
283 , common_rout_sequence_id NUMBER
284 , created_by NUMBER
285 , creation_date DATE
286 , daily_production_rate NUMBER
287 , date_closed DATE
288 , date_released DATE
289 , demand_class VARCHAR2(30)
290 , description VARCHAR2(240)
291 , firm_planned_flag NUMBER
292 , first_unit_cpl_date DATE
293 , first_unit_start_date DATE
294 , last_unit_cpl_date DATE
295 , last_unit_start_date DATE
296 , last_updated_by NUMBER
297 , last_update_date DATE
298 , last_update_login NUMBER
299 , line_id NUMBER
300 , material_account NUMBER
301 , material_overhead_account NUMBER
302 , material_variance_account NUMBER
303 , organization_id NUMBER
304 , osp_account NUMBER
305 , osp_variance_account NUMBER
306 , overhead_account NUMBER
307 , overhead_variance_account NUMBER
308 , processing_work_days NUMBER
309 , program_application_id NUMBER
310 , program_id NUMBER
311 , program_update_date DATE
312 , quantity_completed NUMBER
313 , repetitive_schedule_id NUMBER
314 , request_id NUMBER
315 , resource_account NUMBER
316 , resource_variance_account NUMBER
317 , routing_revision VARCHAR2(3)
318 , routing_revision_date DATE
319 , status_type NUMBER
320 , wip_entity_id NUMBER
321 , kanban_card_id NUMBER
322 , return_status VARCHAR2(1)
323 , db_flag VARCHAR2(1)
324 , action VARCHAR2(30)
325 , Wip_Entities_index NUMBER
326 , primary_item_id NUMBER
327 );
328
329 TYPE Repschedule_Tbl_Type IS TABLE OF Repschedule_Rec_Type
330 INDEX BY BINARY_INTEGER;
331
332 -- Repschedule value record type
333
334 TYPE Repschedule_Val_Rec_Type IS RECORD
335 ( common_bom_sequence VARCHAR2(240)
336 , common_rout_sequence VARCHAR2(240)
337 , firm_planned VARCHAR2(240)
338 , line VARCHAR2(240)
339 , organization VARCHAR2(240)
340 , repetitive_schedule VARCHAR2(240)
341 , wip_entity VARCHAR2(240)
342 );
343
344 TYPE Repschedule_Val_Tbl_Type IS TABLE OF Repschedule_Val_Rec_Type
345 INDEX BY BINARY_INTEGER;
346
347 -- Variables representing missing records and tables
348
349 G_MISS_WIP_ENTITIES_REC Wip_Entities_Rec_Type;
350 G_MISS_WIP_ENTITIES_VAL_REC Wip_Entities_Val_Rec_Type;
351 G_MISS_WIP_ENTITIES_TBL Wip_Entities_Tbl_Type;
352 G_MISS_WIP_ENTITIES_VAL_TBL Wip_Entities_Val_Tbl_Type;
353 G_MISS_FLOWSCHEDULE_REC Flowschedule_Rec_Type;
354 G_MISS_FLOWSCHEDULE_VAL_REC Flowschedule_Val_Rec_Type;
355 G_MISS_FLOWSCHEDULE_TBL Flowschedule_Tbl_Type;
356 G_MISS_FLOWSCHEDULE_VAL_TBL Flowschedule_Val_Tbl_Type;
357 G_MISS_DISCRETEJOB_REC Discretejob_Rec_Type;
358 G_MISS_DISCRETEJOB_VAL_REC Discretejob_Val_Rec_Type;
359 G_MISS_DISCRETEJOB_TBL Discretejob_Tbl_Type;
360 G_MISS_DISCRETEJOB_VAL_TBL Discretejob_Val_Tbl_Type;
361 G_MISS_REPSCHEDULE_REC Repschedule_Rec_Type;
362 G_MISS_REPSCHEDULE_VAL_REC Repschedule_Val_Rec_Type;
363 G_MISS_REPSCHEDULE_TBL Repschedule_Tbl_Type;
364 G_MISS_REPSCHEDULE_VAL_TBL Repschedule_Val_Tbl_Type;
365
366
367 -- Start of Comments
368 -- API name Get_Work_Order
369 -- Type Public
370 -- Function
371 --
372 -- Pre-reqs
373 --
374 -- Parameters
375 --
376 -- Version Current version = 1.0
377 -- Initial version = 1.0
378 --
379 -- Notes
380 --
381 -- End of Comments
382
383 PROCEDURE Get_Work_Order
384 ( p_api_version_number IN NUMBER
385 , p_init_msg_list IN VARCHAR2
386 , p_return_values IN VARCHAR2
387 , x_return_status OUT NOCOPY VARCHAR2
388 , x_msg_count OUT NOCOPY NUMBER
389 , x_msg_data OUT NOCOPY VARCHAR2
390 , p_wip_entity_id IN NUMBER
391 , x_Wip_Entities_tbl OUT NOCOPY Wip_Entities_Tbl_Type
392 , x_Wip_Entities_val_tbl OUT NOCOPY Wip_Entities_Val_Tbl_Type
393 , x_FlowSchedule_tbl OUT NOCOPY Flowschedule_Tbl_Type
394 , x_FlowSchedule_val_tbl OUT NOCOPY Flowschedule_Val_Tbl_Type
395 , x_DiscreteJob_tbl OUT NOCOPY Discretejob_Tbl_Type
396 , x_DiscreteJob_val_tbl OUT NOCOPY Discretejob_Val_Tbl_Type
397 , x_RepSchedule_tbl OUT NOCOPY Repschedule_Tbl_Type
398 , x_RepSchedule_val_tbl OUT NOCOPY Repschedule_Val_Tbl_Type
399 );
400
401 END WIP_Work_Order_PUB;