1 PACKAGE WIP_SCHEDULER AUTHID CURRENT_USER AS
2 /* $Header: wipschds.pls 115.7 2003/09/05 22:06:58 kbavadek ship $ */
3
4 /* EXPLODE_ROUTING
5
6 This package creates operations, operation_resources, and
7 operation_instructions for a job. It does not attempt
8 to schedule; instead it sets all operation and resource
9 start and end dates to the date parameters passed to this
10 routine.
11 */
12
13 PROCEDURE explode_routing(
14 X_Wip_Entity_Id NUMBER,
15 X_Organization_Id NUMBER,
16 X_Repetitive_Schedule_Id NUMBER,
17 X_Start_Date VARCHAR2,
18 X_Completion_Date VARCHAR2,
19 X_Routing_Seq NUMBER,
20 X_Routing_Rev_Date VARCHAR2,
21 X_Quantity NUMBER,
22 X_Created_By NUMBER,
23 X_Last_Update_Login NUMBER);
24
25 /* This procedure sets the Start and End dates for existing Operations
26 and Operation resources to the date parameters passed. It will
27 also change the date required of any components if necessary.
28
29 If the job is not being released or unreleased, and the quantity has
30 changed, it will make sure that
31 If no operations on the routing:
32 If the new quantity is less than what was in queue
33 of the first op give an error
34 Otherwise adjust quantity in queue by the difference
35 between old quantity and new quantity
36 If operations:
37 If the new quantity is less than quantity already
38 completed then give an error
39 If no error, set scheduled quantity to new quantity for all ops
40 */
41 PROCEDURE update_routing(
42 X_Wip_Entity_Id NUMBER,
43 X_load_type NUMBER,
44 X_Organization_Id NUMBER,
45 X_Repetitive_Schedule_Id NUMBER,
46 X_Start_Date VARCHAR2,
47 X_Completion_Date VARCHAR2,
48 X_Old_Status_Type NUMBER,
49 X_Status_Type NUMBER,
50 X_Old_Quantity NUMBER,
51 X_Quantity NUMBER,
52 X_Last_Updated_By NUMBER,
53 X_Last_Update_Login NUMBER,
54 X_Success_Flag OUT NOCOPY NUMBER);
55
56 END WIP_SCHEDULER;