1 PACKAGE MRP_WFS_Form_Flow_Schedule AUTHID CURRENT_USER AS
2 /* $Header: MRPFSCNS.pls 115.15 2003/05/12 11:38:37 soroy ship $ */
3
4 -- Procedure : Default_Attributes
5 --
6 /*
7 Enhancement : 2665434
8 Description : Changed the usage of the record type from old record type
9 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
10 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
11 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
12 */
13
14 PROCEDURE Default_Attributes
15 ( x_return_status OUT NOCOPY VARCHAR2
16 , x_msg_count OUT NOCOPY NUMBER
17 , x_msg_data OUT NOCOPY VARCHAR2
18 , x_alternate_bom_designator OUT NOCOPY VARCHAR2
19 , x_alternate_routing_desig OUT NOCOPY VARCHAR2
20 , x_attribute1 OUT NOCOPY VARCHAR2
21 , x_attribute10 OUT NOCOPY VARCHAR2
22 , x_attribute11 OUT NOCOPY VARCHAR2
23 , x_attribute12 OUT NOCOPY VARCHAR2
24 , x_attribute13 OUT NOCOPY VARCHAR2
25 , x_attribute14 OUT NOCOPY VARCHAR2
26 , x_attribute15 OUT NOCOPY VARCHAR2
27 , x_attribute2 OUT NOCOPY VARCHAR2
28 , x_attribute3 OUT NOCOPY VARCHAR2
29 , x_attribute4 OUT NOCOPY VARCHAR2
30 , x_attribute5 OUT NOCOPY VARCHAR2
31 , x_attribute6 OUT NOCOPY VARCHAR2
32 , x_attribute7 OUT NOCOPY VARCHAR2
33 , x_attribute8 OUT NOCOPY VARCHAR2
34 , x_attribute9 OUT NOCOPY VARCHAR2
35 , x_attribute_category OUT NOCOPY VARCHAR2
36 , x_bom_revision OUT NOCOPY VARCHAR2
37 , x_bom_revision_date OUT NOCOPY DATE
38 , x_build_sequence OUT NOCOPY NUMBER
39 , x_class_code OUT NOCOPY VARCHAR2
40 , x_completion_locator_id OUT NOCOPY NUMBER
41 , x_completion_subinventory OUT NOCOPY VARCHAR2
42 , x_date_closed OUT NOCOPY DATE
43 , x_demand_class OUT NOCOPY VARCHAR2
44 , x_demand_source_delivery OUT NOCOPY VARCHAR2
45 , x_demand_source_header_id OUT NOCOPY NUMBER
46 , x_demand_source_line OUT NOCOPY VARCHAR2
47 , x_demand_source_type OUT NOCOPY NUMBER
48 , x_line_id OUT NOCOPY NUMBER
49 , x_material_account OUT NOCOPY NUMBER
50 , x_material_overhead_account OUT NOCOPY NUMBER
51 , x_material_variance_account OUT NOCOPY NUMBER
52 , x_mps_net_quantity OUT NOCOPY NUMBER
53 , x_mps_scheduled_comp_date OUT NOCOPY DATE
54 , x_organization_id OUT NOCOPY NUMBER
55 , x_outside_processing_acct OUT NOCOPY NUMBER
56 , x_outside_proc_var_acct OUT NOCOPY NUMBER
57 , x_overhead_account OUT NOCOPY NUMBER
58 , x_overhead_variance_account OUT NOCOPY NUMBER
59 , x_planned_quantity OUT NOCOPY NUMBER
60 , x_primary_item_id OUT NOCOPY NUMBER
61 , x_project_id OUT NOCOPY NUMBER
62 , x_quantity_completed OUT NOCOPY NUMBER
63 , x_resource_account OUT NOCOPY NUMBER
64 , x_resource_variance_account OUT NOCOPY NUMBER
65 , x_routing_revision OUT NOCOPY VARCHAR2
66 , x_routing_revision_date OUT NOCOPY DATE
67 , x_scheduled_completion_date OUT NOCOPY DATE
68 , x_scheduled_flag OUT NOCOPY NUMBER
69 , x_scheduled_start_date OUT NOCOPY DATE
70 , x_schedule_group_id OUT NOCOPY NUMBER
71 , x_schedule_number OUT NOCOPY VARCHAR2
72 , x_status OUT NOCOPY NUMBER
73 , x_std_cost_adjustment_acct OUT NOCOPY NUMBER
74 , x_task_id OUT NOCOPY NUMBER
75 , x_wip_entity_id OUT NOCOPY NUMBER
76 , x_completion_locator OUT NOCOPY VARCHAR2
77 , x_line OUT NOCOPY VARCHAR2
78 , x_organization OUT NOCOPY VARCHAR2
79 , x_primary_item OUT NOCOPY VARCHAR2
80 , x_project OUT NOCOPY VARCHAR2
81 , x_schedule_group OUT NOCOPY VARCHAR2
82 , x_task OUT NOCOPY VARCHAR2
83 , x_wip_entity OUT NOCOPY VARCHAR2
84 , x_end_item_unit_number OUT NOCOPY VARCHAR2
85 , x_quantity_scrapped OUT NOCOPY NUMBER
86 );
87
88 -- Procedure : Change_Attribute
89 --
90 /*
91 Enhancement : 2665434
92 Description : Changed the usage of the record type from old record type
93 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
94 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
95 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
96 */
97
98 PROCEDURE Change_Attribute
99 ( x_return_status OUT NOCOPY VARCHAR2
100 , x_msg_count OUT NOCOPY NUMBER
101 , x_msg_data OUT NOCOPY VARCHAR2
102 , p_wip_entity_id IN NUMBER
103 , p_attr_id IN NUMBER
104 , p_attr_value IN VARCHAR2
105 , p_attribute1 IN VARCHAR2
106 , p_attribute10 IN VARCHAR2
107 , p_attribute11 IN VARCHAR2
108 , p_attribute12 IN VARCHAR2
109 , p_attribute13 IN VARCHAR2
110 , p_attribute14 IN VARCHAR2
111 , p_attribute15 IN VARCHAR2
112 , p_attribute2 IN VARCHAR2
113 , p_attribute3 IN VARCHAR2
114 , p_attribute4 IN VARCHAR2
115 , p_attribute5 IN VARCHAR2
116 , p_attribute6 IN VARCHAR2
117 , p_attribute7 IN VARCHAR2
118 , p_attribute8 IN VARCHAR2
119 , p_attribute9 IN VARCHAR2
120 , p_attribute_category IN VARCHAR2
121 , x_alternate_bom_designator OUT NOCOPY VARCHAR2
122 , x_alternate_routing_desig OUT NOCOPY VARCHAR2
123 , x_attribute1 OUT NOCOPY VARCHAR2
124 , x_attribute10 OUT NOCOPY VARCHAR2
125 , x_attribute11 OUT NOCOPY VARCHAR2
126 , x_attribute12 OUT NOCOPY VARCHAR2
127 , x_attribute13 OUT NOCOPY VARCHAR2
128 , x_attribute14 OUT NOCOPY VARCHAR2
129 , x_attribute15 OUT NOCOPY VARCHAR2
130 , x_attribute2 OUT NOCOPY VARCHAR2
131 , x_attribute3 OUT NOCOPY VARCHAR2
132 , x_attribute4 OUT NOCOPY VARCHAR2
133 , x_attribute5 OUT NOCOPY VARCHAR2
134 , x_attribute6 OUT NOCOPY VARCHAR2
135 , x_attribute7 OUT NOCOPY VARCHAR2
136 , x_attribute8 OUT NOCOPY VARCHAR2
137 , x_attribute9 OUT NOCOPY VARCHAR2
138 , x_attribute_category OUT NOCOPY VARCHAR2
139 , x_bom_revision OUT NOCOPY VARCHAR2
140 , x_bom_revision_date OUT NOCOPY DATE
141 , x_build_sequence OUT NOCOPY NUMBER
142 , x_class_code OUT NOCOPY VARCHAR2
143 , x_completion_locator_id OUT NOCOPY NUMBER
144 , x_completion_subinventory OUT NOCOPY VARCHAR2
145 , x_date_closed OUT NOCOPY DATE
146 , x_demand_class OUT NOCOPY VARCHAR2
147 , x_demand_source_delivery OUT NOCOPY VARCHAR2
148 , x_demand_source_header_id OUT NOCOPY NUMBER
149 , x_demand_source_line OUT NOCOPY VARCHAR2
150 , x_demand_source_type OUT NOCOPY NUMBER
151 , x_line_id OUT NOCOPY NUMBER
152 , x_material_account OUT NOCOPY NUMBER
153 , x_material_overhead_account OUT NOCOPY NUMBER
154 , x_material_variance_account OUT NOCOPY NUMBER
155 , x_mps_net_quantity OUT NOCOPY NUMBER
156 , x_mps_scheduled_comp_date OUT NOCOPY DATE
157 , x_organization_id OUT NOCOPY NUMBER
158 , x_outside_processing_acct OUT NOCOPY NUMBER
159 , x_outside_proc_var_acct OUT NOCOPY NUMBER
160 , x_overhead_account OUT NOCOPY NUMBER
161 , x_overhead_variance_account OUT NOCOPY NUMBER
162 , x_planned_quantity OUT NOCOPY NUMBER
163 , x_primary_item_id OUT NOCOPY NUMBER
164 , x_project_id OUT NOCOPY NUMBER
165 , x_quantity_completed OUT NOCOPY NUMBER
166 , x_request_id OUT NOCOPY NUMBER
167 , x_resource_account OUT NOCOPY NUMBER
168 , x_resource_variance_account OUT NOCOPY NUMBER
169 , x_routing_revision OUT NOCOPY VARCHAR2
170 , x_routing_revision_date OUT NOCOPY DATE
171 , x_scheduled_completion_date OUT NOCOPY DATE
172 , x_scheduled_flag OUT NOCOPY NUMBER
173 , x_scheduled_start_date OUT NOCOPY DATE
174 , x_schedule_group_id OUT NOCOPY NUMBER
175 , x_schedule_number OUT NOCOPY VARCHAR2
176 , x_status OUT NOCOPY NUMBER
177 , x_std_cost_adjustment_acct OUT NOCOPY NUMBER
178 , x_task_id OUT NOCOPY NUMBER
179 , x_wip_entity_id OUT NOCOPY NUMBER
180 , x_completion_locator OUT NOCOPY VARCHAR2
181 , x_line OUT NOCOPY VARCHAR2
182 , x_organization OUT NOCOPY VARCHAR2
183 , x_primary_item OUT NOCOPY VARCHAR2
184 , x_project OUT NOCOPY VARCHAR2
185 , x_schedule_group OUT NOCOPY VARCHAR2
186 , x_task OUT NOCOPY VARCHAR2
187 , x_wip_entity OUT NOCOPY VARCHAR2
188 , x_end_item_unit_number OUT NOCOPY VARCHAR2
189 , x_quantity_scrapped OUT NOCOPY NUMBER
190 );
191
192 -- Procedure Validate_And_Write
193 --
194 /*
195 Enhancement : 2665434
196 Description : Changed the usage of the record type from old record type
197 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
198 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
199 */
200
201 PROCEDURE Validate_And_Write
202 ( x_return_status OUT NOCOPY VARCHAR2
203 , x_msg_count OUT NOCOPY NUMBER
204 , x_msg_data OUT NOCOPY VARCHAR2
205 , p_wip_entity_id IN NUMBER
206 , x_creation_date OUT NOCOPY DATE
207 , x_created_by OUT NOCOPY NUMBER
208 , x_last_update_date OUT NOCOPY DATE
209 , x_last_updated_by OUT NOCOPY NUMBER
210 , x_last_update_login OUT NOCOPY NUMBER
211 );
212
213 -- Procedure Delete_Row
214 --
215 /*
216 Enhancement : 2665434
217 Description : Changed the usage of the record type from old record type
218 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
219 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
220 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
221 */
222
223 PROCEDURE Delete_Row
224 ( x_return_status OUT NOCOPY VARCHAR2
225 , x_msg_count OUT NOCOPY NUMBER
226 , x_msg_data OUT NOCOPY VARCHAR2
227 , p_wip_entity_id IN NUMBER
228 );
229
230 -- Procedure Process_Entity
231 --
232 /*
233 Enhancement : 2665434
234 Description : Changed the usage of the record type from old record type
235 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
236 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
237 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
238 */
239
240 PROCEDURE Process_Entity
241 ( x_return_status OUT NOCOPY VARCHAR2
242 , x_msg_count OUT NOCOPY NUMBER
243 , x_msg_data OUT NOCOPY VARCHAR2
244 );
245
246 -- Procedure Process_Object
247 --
248
249 /*
250 Enhancement : 2665434
251 Description : Changed the usage of the record type from old record type
252 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
253 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
254 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
255 */
256
257 PROCEDURE Process_Object
258 ( x_return_status OUT NOCOPY VARCHAR2
259 , x_msg_count OUT NOCOPY NUMBER
260 , x_msg_data OUT NOCOPY VARCHAR2
261 );
262
263 -- Procedure lock_Row
264 --
265 /*
266 Enhancement : 2665434
267 Description : Changed the usage of the record type from old record type
268 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
269 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type)
270 */
271 PROCEDURE Lock_Row
272 ( x_return_status OUT NOCOPY VARCHAR2
273 , x_msg_count OUT NOCOPY NUMBER
274 , x_msg_data OUT NOCOPY VARCHAR2
275 , p_alternate_bom_designator IN VARCHAR2
276 , p_alternate_routing_desig IN VARCHAR2
277 , p_attribute1 IN VARCHAR2
278 , p_attribute10 IN VARCHAR2
279 , p_attribute11 IN VARCHAR2
280 , p_attribute12 IN VARCHAR2
281 , p_attribute13 IN VARCHAR2
282 , p_attribute14 IN VARCHAR2
283 , p_attribute15 IN VARCHAR2
284 , p_attribute2 IN VARCHAR2
285 , p_attribute3 IN VARCHAR2
286 , p_attribute4 IN VARCHAR2
287 , p_attribute5 IN VARCHAR2
288 , p_attribute6 IN VARCHAR2
289 , p_attribute7 IN VARCHAR2
293 , p_bom_revision IN VARCHAR2
290 , p_attribute8 IN VARCHAR2
291 , p_attribute9 IN VARCHAR2
292 , p_attribute_category IN VARCHAR2
294 , p_bom_revision_date IN DATE
295 , p_build_sequence IN NUMBER
296 , p_class_code IN VARCHAR2
297 , p_completion_locator_id IN NUMBER
298 , p_completion_subinventory IN VARCHAR2
299 , p_created_by IN NUMBER
300 , p_creation_date IN DATE
301 , p_date_closed IN DATE
302 , p_demand_class IN VARCHAR2
303 , p_demand_source_delivery IN VARCHAR2
304 , p_demand_source_header_id IN NUMBER
305 , p_demand_source_line IN VARCHAR2
306 , p_demand_source_type IN NUMBER
307 , p_last_updated_by IN NUMBER
308 , p_last_update_date IN DATE
309 , p_last_update_login IN NUMBER
310 , p_line_id IN NUMBER
311 , p_material_account IN NUMBER
312 , p_material_overhead_account IN NUMBER
313 , p_material_variance_account IN NUMBER
314 , p_mps_net_quantity IN NUMBER
315 , p_mps_scheduled_comp_date IN DATE
316 , p_organization_id IN NUMBER
317 , p_outside_processing_acct IN NUMBER
318 , p_outside_proc_var_acct IN NUMBER
319 , p_overhead_account IN NUMBER
320 , p_overhead_variance_account IN NUMBER
321 , p_planned_quantity IN NUMBER
322 , p_primary_item_id IN NUMBER
323 , p_program_application_id IN NUMBER
324 , p_program_id IN NUMBER
325 , p_program_update_date IN DATE
326 , p_project_id IN NUMBER
327 , p_quantity_completed IN NUMBER
328 , p_request_id IN NUMBER
329 , p_resource_account IN NUMBER
330 , p_resource_variance_account IN NUMBER
331 , p_routing_revision IN VARCHAR2
332 , p_routing_revision_date IN DATE
333 , p_scheduled_completion_date IN DATE
334 , p_scheduled_flag IN NUMBER
335 , p_scheduled_start_date IN DATE
336 , p_schedule_group_id IN NUMBER
337 , p_schedule_number IN VARCHAR2
338 , p_status IN NUMBER
339 , p_std_cost_adjustment_acct IN NUMBER
340 , p_task_id IN NUMBER
341 , p_wip_entity_id IN NUMBER
342 , p_end_item_unit_number IN VARCHAR2
343 , p_quantity_scrapped IN NUMBER
344 );
345
346 /*
347 Enhancement : 2665434
348 Description : Changed the usage of the record type from old record type
349 (MRP_FLow_Schedule_PUB.Flow_Schedule_Rec_Type) to new record type
350 (MRP_FLow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type).Also added local variables to make it
351 compatible with the call to (MRP_FLow_Schedule_PVT.Process_Flow_Schedule)
352 */
353 PROCEDURE Create_Flow_Schedule
354 ( x_return_status OUT NOCOPY VARCHAR2
355 , x_msg_count OUT NOCOPY NUMBER
356 , x_msg_data OUT NOCOPY VARCHAR2
357 , p_alternate_bom_designator IN VARCHAR2
358 , p_alternate_routing_desig IN VARCHAR2
359 , p_attribute1 IN VARCHAR2
360 , p_attribute10 IN VARCHAR2
361 , p_attribute11 IN VARCHAR2
362 , p_attribute12 IN VARCHAR2
363 , p_attribute13 IN VARCHAR2
364 , p_attribute14 IN VARCHAR2
365 , p_attribute15 IN VARCHAR2
366 , p_attribute2 IN VARCHAR2
367 , p_attribute3 IN VARCHAR2
368 , p_attribute4 IN VARCHAR2
369 , p_attribute5 IN VARCHAR2
370 , p_attribute6 IN VARCHAR2
371 , p_attribute7 IN VARCHAR2
372 , p_attribute8 IN VARCHAR2
373 , p_attribute9 IN VARCHAR2
374 , p_attribute_category IN VARCHAR2
375 , p_bom_revision IN VARCHAR2
376 , p_bom_revision_date IN DATE
377 , p_build_sequence IN NUMBER
378 , p_class_code IN VARCHAR2
379 , p_completion_locator_id IN NUMBER
380 , p_completion_subinventory IN VARCHAR2
381 , p_created_by IN NUMBER
382 , p_creation_date IN DATE
383 , p_date_closed IN DATE
384 , p_demand_class IN VARCHAR2
385 , p_demand_source_delivery IN VARCHAR2
386 , p_demand_source_header_id IN NUMBER
387 , p_demand_source_line IN VARCHAR2
388 , p_demand_source_type IN NUMBER
389 , p_last_updated_by IN NUMBER
390 , p_last_update_date IN DATE
391 , p_last_update_login IN NUMBER
392 , p_line_id IN NUMBER
393 , p_material_account IN NUMBER
394 , p_material_overhead_account IN NUMBER
395 , p_material_variance_account IN NUMBER
396 , p_mps_net_quantity IN NUMBER
397 , p_mps_scheduled_comp_date IN DATE
398 , p_organization_id IN NUMBER
399 , p_outside_processing_acct IN NUMBER
400 , p_outside_proc_var_acct IN NUMBER
401 , p_overhead_account IN NUMBER
402 , p_overhead_variance_account IN NUMBER
403 , p_planned_quantity IN NUMBER
404 , p_primary_item_id IN NUMBER
405 , p_program_application_id IN NUMBER
406 , p_program_id IN NUMBER
407 , p_program_update_date IN DATE
408 , p_project_id IN NUMBER
409 , p_quantity_completed IN NUMBER
410 , p_request_id IN NUMBER
411 , p_resource_account IN NUMBER
412 , p_resource_variance_account IN NUMBER
413 , p_routing_revision IN VARCHAR2
414 , p_routing_revision_date IN DATE
415 , p_scheduled_completion_date IN DATE
416 , p_scheduled_flag IN NUMBER
417 , p_scheduled_start_date IN DATE
418 , p_schedule_group_id IN NUMBER
419 , p_schedule_number IN VARCHAR2
420 , p_status IN NUMBER
421 , p_std_cost_adjustment_acct IN NUMBER
422 , p_task_id IN NUMBER
423 , p_wip_entity_id IN NUMBER
424 , p_end_item_unit_number IN VARCHAR2
425 , p_quantity_scrapped IN NUMBER
426 , x_wip_entity_id OUT NOCOPY NUMBER
427 );
428
429 PROCEDURE get_default_dff (
430 x_return_status OUT NOCOPY varchar2,
431 p_attribute1 IN OUT NOCOPY varchar2,
432 p_attribute2 IN OUT NOCOPY varchar2,
433 p_attribute3 IN OUT NOCOPY varchar2,
434 p_attribute4 IN OUT NOCOPY varchar2,
435 p_attribute5 IN OUT NOCOPY varchar2,
436 p_attribute6 IN OUT NOCOPY varchar2,
437 p_attribute7 IN OUT NOCOPY varchar2,
438 p_attribute8 IN OUT NOCOPY varchar2,
439 p_attribute9 IN OUT NOCOPY varchar2,
440 p_attribute10 IN OUT NOCOPY varchar2,
441 p_attribute11 IN OUT NOCOPY varchar2,
442 p_attribute12 IN OUT NOCOPY varchar2,
443 p_attribute13 IN OUT NOCOPY varchar2,
444 p_attribute14 IN OUT NOCOPY varchar2,
445 p_attribute15 IN OUT NOCOPY varchar2
446
447 );
448
449 /*
450 Enhancement : 2665434
451 Reversed the logic.Passing NULL instead of G_MISS when we call Create_Flow_Schedule.
452 */
453
454 /*Bug 2906442 - added parameter p_primary_routing as part of porting
455 FP-H BUTLER issue (2859310) to I */
456 PROCEDURE Create_Raw_Flow_Schedules
457 ( x_return_status OUT NOCOPY VARCHAR2
458 , x_msg_count OUT NOCOPY NUMBER
459 , x_msg_data OUT NOCOPY VARCHAR2
460 , x_created_count IN OUT NOCOPY NUMBER
461 , x_lock_count IN OUT NOCOPY NUMBER
462 , p_organization_id IN NUMBER
463 , p_line_id IN NUMBER
464 , p_unscheduled_order_type IN NUMBER
465 , p_demand_start_date IN DATE
466 , p_demand_end_date IN DATE
467 , p_schedule_group_id IN NUMBER
468 , p_schedule_rule_id IN NUMBER
469 , p_rule_user_defined IN NUMBER
470 , p_primary_routing IN NUMBER
471 );
472
473
474 END MRP_WFS_Form_Flow_Schedule;