1 PACKAGE WMS_OP_PLAN_DETAILS_PKG AS
2 /* $Header: WMSOPLDS.pls 120.0 2005/05/24 18:20:06 appldev noship $ */
3 --
4 PROCEDURE INSERT_ROW (
5 x_rowid IN OUT nocopy VARCHAR2
6 ,x_operation_plan_detail_id IN NUMBER
7 ,x_last_updated_by IN NUMBER
8 ,x_last_update_date IN DATE
9 ,x_created_by IN NUMBER
10 ,x_creation_date IN DATE
11 ,x_last_update_login IN NUMBER
12 ,x_operation_plan_id IN NUMBER
13 ,x_operation_type IN NUMBER
14 ,x_operation_sequence IN NUMBER
15 ,x_bulk_pick_type IN NUMBER
16 ,x_drop_lpn_option IN NUMBER
17 ,x_wait_for_group_completion IN VARCHAR2
18 ,x_system_dispatched IN VARCHAR2
19 ,x_op_segment_completed IN VARCHAR2
20 ,x_zone_selection_criteria IN NUMBER
21 ,x_pre_specified_zone_id IN NUMBER
22 ,x_zone_selection_api_id IN NUMBER
23 ,x_sub_selection_criteria IN NUMBER
24 ,x_pre_specified_sub_code IN VARCHAR2
25 ,x_sub_selection_api_id IN NUMBER
26 ,x_loc_selection_criteria IN NUMBER
27 ,x_pre_specified_loc_id IN NUMBER
28 ,x_loc_selection_api_id IN NUMBER
29 ,x_activity_segment IN NUMBER
30 ,x_attribute_category IN VARCHAR2
31 ,x_attribute1 IN VARCHAR2
32 ,x_attribute2 IN VARCHAR2
33 ,x_attribute3 IN VARCHAR2
34 ,x_attribute4 IN VARCHAR2
35 ,x_attribute5 IN VARCHAR2
36 ,x_attribute6 IN VARCHAR2
37 ,x_attribute7 IN VARCHAR2
38 ,x_attribute8 IN VARCHAR2
39 ,x_attribute9 IN VARCHAR2
40 ,x_attribute10 IN VARCHAR2
41 ,x_attribute11 IN VARCHAR2
42 ,x_attribute12 IN VARCHAR2
43 ,x_attribute13 IN VARCHAR2
44 ,x_attribute14 IN VARCHAR2
45 ,x_attribute15 IN VARCHAR2
46 --,x_task_mode IN NUMBER (out of scope for patchset 'J')
47 --,x_operation_method IN NUMBER (out of scope for patchset 'J')
48 ,x_lpn_selection_criteria IN NUMBER
49 ,x_lpn_selection_api_id IN NUMBER
50 --,x_catch_secondary_qty IN NUMBER (out of scope for patchset 'J')
51 ,x_loc_mtrl_grp_rule_id IN NUMBER
52 ,x_lpn_mtrl_grp_rule_id IN NUMBER
53 ,x_organization_id IN NUMBER
54 ,x_is_in_inventory IN VARCHAR2
55 ,x_subsequent_op_plan_id IN NUMBER
56 ,x_consolidation_method_id IN NUMBER
57 );
58
59 --
60 PROCEDURE UPDATE_ROW (
61 x_operation_plan_detail_id IN NUMBER
62 ,x_last_updated_by IN NUMBER
63 ,x_last_update_date IN DATE
64 ,x_last_update_login IN NUMBER
65 ,x_operation_plan_id IN NUMBER
66 ,x_operation_type IN NUMBER
67 ,x_operation_sequence IN NUMBER
68 ,x_bulk_pick_type IN NUMBER
69 ,x_drop_lpn_option IN NUMBER
70 ,x_wait_for_group_completion IN VARCHAR2
71 ,x_system_dispatched IN VARCHAR2
72 ,x_op_segment_completed IN VARCHAR2
73 ,x_zone_selection_criteria IN NUMBER
74 ,x_pre_specified_zone_id IN NUMBER
75 ,x_zone_selection_api_id IN NUMBER
76 ,x_sub_selection_criteria IN NUMBER
77 ,x_pre_specified_sub_code IN VARCHAR2
78 ,x_sub_selection_api_id IN NUMBER
79 ,x_loc_selection_criteria IN NUMBER
80 ,x_pre_specified_loc_id IN NUMBER
81 ,x_loc_selection_api_id IN NUMBER
82 ,x_activity_segment IN NUMBER
83 ,x_attribute_category IN VARCHAR2
84 ,x_attribute1 IN VARCHAR2
85 ,x_attribute2 IN VARCHAR2
86 ,x_attribute3 IN VARCHAR2
87 ,x_attribute4 IN VARCHAR2
88 ,x_attribute5 IN VARCHAR2
89 ,x_attribute6 IN VARCHAR2
90 ,x_attribute7 IN VARCHAR2
91 ,x_attribute8 IN VARCHAR2
92 ,x_attribute9 IN VARCHAR2
93 ,x_attribute10 IN VARCHAR2
94 ,x_attribute11 IN VARCHAR2
95 ,x_attribute12 IN VARCHAR2
96 ,x_attribute13 IN VARCHAR2
97 ,x_attribute14 IN VARCHAR2
98 ,x_attribute15 IN VARCHAR2
99 --,x_task_mode IN NUMBER (out of scope for patchset 'J')
100 --,x_operation_method IN NUMBER (out of scope for patchset 'J')
101 ,x_lpn_selection_criteria IN NUMBER
102 ,x_lpn_selection_api_id IN NUMBER
103 --,x_catch_secondary_qty IN NUMBER (out of scope for patchset 'J')
104 ,x_loc_mtrl_grp_rule_id IN NUMBER
105 ,x_lpn_mtrl_grp_rule_id IN NUMBER
106 ,x_organization_id IN NUMBER
107 ,x_is_in_inventory IN VARCHAR2
108 ,x_subsequent_op_plan_id IN NUMBER
109 ,x_consolidation_method_id IN NUMBER
110 );
111
112 --
113 PROCEDURE LOAD_ROW (
114 x_operation_plan_detail_id IN NUMBER
115 ,x_owner IN VARCHAR2
116 ,x_last_update_date IN VARCHAR2
117 ,x_operation_plan_id IN NUMBER
118 ,x_operation_type IN NUMBER
119 ,x_operation_sequence IN NUMBER
120 ,x_bulk_pick_type IN NUMBER
121 ,x_drop_lpn_option IN NUMBER
122 ,x_wait_for_group_completion IN VARCHAR2
123 ,x_system_dispatched IN VARCHAR2
124 ,x_op_segment_completed IN VARCHAR2
125 ,x_zone_selection_criteria IN NUMBER
126 ,x_pre_specified_zone_id IN NUMBER
127 ,x_zone_selection_api_id IN NUMBER
128 ,x_sub_selection_criteria IN NUMBER
129 ,x_pre_specified_sub_code IN VARCHAR2
130 ,x_sub_selection_api_id IN NUMBER
131 ,x_loc_selection_criteria IN NUMBER
132 ,x_pre_specified_loc_id IN NUMBER
133 ,x_loc_selection_api_id IN NUMBER
134 ,x_activity_segment IN NUMBER
135 ,x_attribute_category IN VARCHAR2
136 ,x_attribute1 IN VARCHAR2
137 ,x_attribute2 IN VARCHAR2
138 ,x_attribute3 IN VARCHAR2
139 ,x_attribute4 IN VARCHAR2
140 ,x_attribute5 IN VARCHAR2
141 ,x_attribute6 IN VARCHAR2
142 ,x_attribute7 IN VARCHAR2
143 ,x_attribute8 IN VARCHAR2
144 ,x_attribute9 IN VARCHAR2
145 ,x_attribute10 IN VARCHAR2
146 ,x_attribute11 IN VARCHAR2
147 ,x_attribute12 IN VARCHAR2
148 ,x_attribute13 IN VARCHAR2
149 ,x_attribute14 IN VARCHAR2
150 ,x_attribute15 IN VARCHAR2
151 --,x_task_mode IN NUMBER (out of scope for patchset 'J')
152 --,x_operation_method IN NUMBER (out of scope for patchset 'J')
153 ,x_lpn_selection_criteria IN NUMBER
154 ,x_lpn_selection_api_id IN NUMBER
155 --,x_catch_secondary_qty IN NUMBER (out of scope for patchset 'J')
156 ,x_loc_mtrl_grp_rule_id IN NUMBER
157 ,x_lpn_mtrl_grp_rule_id IN NUMBER
158 ,x_organization_id IN NUMBER
159 ,x_is_in_inventory IN VARCHAR2
160 ,x_subsequent_op_plan_id IN NUMBER
161 ,x_consolidation_method_id IN NUMBER
162 );
163
164 --
165 PROCEDURE LOCK_ROW (
166 x_operation_plan_detail_id IN NUMBER
167 ,x_operation_plan_id IN NUMBER
168 ,x_operation_type IN NUMBER
169 ,x_operation_sequence IN NUMBER
170 ,x_bulk_pick_type IN NUMBER
171 ,x_drop_lpn_option IN NUMBER
172 ,x_wait_for_group_completion IN VARCHAR2
173 ,x_system_dispatched IN VARCHAR2
174 ,x_op_segment_completed IN VARCHAR2
175 ,x_zone_selection_criteria IN NUMBER
176 ,x_pre_specified_zone_id IN NUMBER
177 ,x_zone_selection_api_id IN NUMBER
178 ,x_sub_selection_criteria IN NUMBER
179 ,x_pre_specified_sub_code IN VARCHAR2
180 ,x_sub_selection_api_id IN NUMBER
181 ,x_loc_selection_criteria IN NUMBER
182 ,x_pre_specified_loc_id IN NUMBER
183 ,x_loc_selection_api_id IN NUMBER
184 ,x_activity_segment IN NUMBER
185 ,x_attribute_category IN VARCHAR2
186 ,x_attribute1 IN VARCHAR2
187 ,x_attribute2 IN VARCHAR2
188 ,x_attribute3 IN VARCHAR2
189 ,x_attribute4 IN VARCHAR2
190 ,x_attribute5 IN VARCHAR2
191 ,x_attribute6 IN VARCHAR2
192 ,x_attribute7 IN VARCHAR2
193 ,x_attribute8 IN VARCHAR2
194 ,x_attribute9 IN VARCHAR2
195 ,x_attribute10 IN VARCHAR2
196 ,x_attribute11 IN VARCHAR2
197 ,x_attribute12 IN VARCHAR2
198 ,x_attribute13 IN VARCHAR2
199 ,x_attribute14 IN VARCHAR2
200 ,x_attribute15 IN VARCHAR2
201 --,x_task_mode IN NUMBER (out of scope for patchset 'J')
202 --,x_operation_method IN NUMBER (out of scope for patchset 'J')
203 ,x_lpn_selection_criteria IN NUMBER
204 ,x_lpn_selection_api_id IN NUMBER
205 --,x_catch_secondary_qty IN NUMBER (out of scope for patchset 'J')
206 ,x_loc_mtrl_grp_rule_id IN NUMBER
207 ,x_lpn_mtrl_grp_rule_id IN NUMBER
208 ,x_organization_id IN NUMBER
209 ,x_is_in_inventory IN VARCHAR2
210 ,x_subsequent_op_plan_id IN NUMBER
211 ,x_consolidation_method_id IN NUMBER
212 );
213
214
215
216 -- added by Grace Xiao 07/28/03
217 PROCEDURE delete_row (
218 x_operation_plan_detail_id IN NUMBER
219 );
220
221
222
223
224 --
225 END WMS_OP_PLAN_DETAILS_PKG;