1 PACKAGE WIP_OPERATIONS_INFO AUTHID CURRENT_USER AS
2 /* $Header: wipopins.pls 115.8 2002/11/29 14:56:55 rmahidha ship $ */
3
4 /*=====================================================================+
5 | PROCEDURE
6 | DERIVE_INFO
7 |
8 | PURPOSE
9 | Derives information given job/schedule IDs and operation sequence
10 |
11 | ARGUMENTS
12 | IN
13 | p_org_id Organization ID
14 | p_wip_entity_id WIP entity ID
15 | p_first_schedule_id ID of first open schedule
16 | p_operation_seq_num Operation sequence number of the routing
17 | OUT
18 | p_operation_code Operation code associated with the given sequence
19 | p_department_id Department ID of the department
20 | p_department_code Department code of the operation
21 | p_prev_op_seq_num The given operation's previous operation sequence
22 | p_next_op_seq_num The given operation's next operation sequence
23 | p_operation_exists Flag whether the operation exists in the routing
24 |
25 | EXCEPTIONS
26 |
27 | NOTES
28 | p_prev_op_seq_num and p_next_op_seq_num are still set even if the
29 | operation does not exist in the routing. These values are useful
30 | when adding an operation on the fly.
31 |
32 +=====================================================================*/
33 procedure derive_info(
34 p_org_id in number,
35 p_wip_entity_id in number,
36 p_first_schedule_id in number,
37 p_operation_seq_num in number,
38 p_operation_code out nocopy varchar2,
39 p_department_id out nocopy number,
40 p_department_code out nocopy varchar2,
41 p_prev_op_seq_num out nocopy number,
42 p_next_op_seq_num out nocopy number,
43 p_operation_exists out nocopy boolean);
44
45 /*=====================================================================+
46 | PROCEDURE
47 | LAST_OPERATION
48 |
49 | PURPOSE
50 | Derives last operation information given job/schedule IDs
51 |
52 | ARGUMENTS
53 | IN
54 | p_org_id Organization ID
55 | p_wip_entity_id WIP entity ID
56 | p_line_id ID of the line of the schedule
57 | p_first_schedule_id ID of first open schedule
58 | OUT
59 | p_last_op_seq Max operation sequence number of the routing
60 | p_last_op_code Operation code associated with the last op seq
61 | p_last_dept_id Department ID of the department
62 | p_last_dept_code Department code of the operation
63 | p_last_op_move_quantity Quantity waiting to move as the last op seq
64 | p_last_op_min_transfer_qty Min transfer quantity of last operation
65 | p_last_move_allowed Indicates moves allowed out nocopy of last op
66 |
67 | EXCEPTIONS
68 |
69 | NOTES
70 | If the job/schedule does not have a routing, p_last_op_seq = -1.
71 | All other output arguments will be set to NULL.
72 |
73 +=====================================================================*/
74 procedure last_operation(
75 p_org_id in number,
76 p_wip_entity_id in number,
77 p_line_id in number,
78 p_first_schedule_id in number,
79 p_last_op_seq out nocopy number,
80 p_last_op_code out nocopy varchar2,
81 p_last_dept_id out nocopy number,
82 p_last_dept_code out nocopy varchar2,
83 p_last_op_move_quantity out nocopy number,
84 p_last_op_min_transfer_qty out nocopy number,
85 p_last_move_allowed out nocopy number);
86
87 /*=====================================================================+
88 | PROCEDURE
89 | FIRST_OPERATION
90 |
91 | PURPOSE
92 | Derives first operation information given job/schedule IDs
93 |
94 | ARGUMENTS
95 | IN
96 | p_org_id Organization ID
97 | p_wip_entity_id WIP entity ID
98 | p_line_id ID of the line of the schedule
99 | p_first_schedule_id ID of first open schedule
100 | OUT
101 | p_first_op_seq Max operation sequence number of the routing
102 | p_first_op_code Operation code associated with the first op seq
103 | p_first_dept_id Department ID of the department
104 | p_first_dept_code Department code of the operation
105 | p_first_op_min_transfer_qty Min transfer quantity of first operation
106 |
107 | EXCEPTIONS
108 |
109 | NOTES
110 | If the job/schedule does not have a routing, p_first_op_seq = -1.
111 | All other output arguments will be set to NULL.
112 |
113 +=====================================================================*/
114 procedure first_operation
115 (
116 p_org_id in number,
117 p_wip_entity_id in number,
118 p_line_id in number,
119 p_first_schedule_id in number,
120 p_first_op_seq out nocopy number,
121 p_first_op_code out nocopy varchar2,
122 p_first_dept_id out nocopy number,
123 p_first_dept_code out nocopy varchar2);
124
125 END WIP_OPERATIONS_INFO;