[Home] [Help]
Skip to content
PACKAGE: APPS.MTL_SECONDARY_INVENTORIES_PKG
Source
1 PACKAGE mtl_secondary_inventories_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVSDSUS.pls 120.4 2011/12/21 06:29:04 skommine ship $ */
3 FUNCTION check_unique(x_rowid IN OUT nocopy VARCHAR2, x_secondary_inventory_name VARCHAR2, x_organization_id NUMBER)
4 RETURN NUMBER;
5
6 PROCEDURE commit_row;
7
8 PROCEDURE rollback_row;
9
10 /* WMS Enhancements
11 Accomodated Status_ID, Default_Loc_Status_ID, Default_Cost_Group_ID
12 and LPN_Controlled_Flag in the following procedure. */
13 PROCEDURE insert_row(
14 x_rowid IN OUT nocopy VARCHAR2
15 , x_secondary_inventory_name VARCHAR2
16 , x_organization_id NUMBER
17 , x_last_update_date DATE
18 , x_last_updated_by NUMBER
19 , x_creation_date DATE
20 , x_created_by NUMBER
21 , x_last_update_login NUMBER
22 , x_description VARCHAR2
23 , x_disable_date DATE
24 , x_inventory_atp_code NUMBER
25 , x_availability_type NUMBER
26 , x_reservable_type NUMBER
27 , x_locator_type NUMBER
28 , x_picking_order NUMBER
29 , x_dropping_order NUMBER
30 , x_material_account NUMBER
31 , x_material_overhead_account NUMBER
32 , x_resource_account NUMBER
33 , x_overhead_account NUMBER
34 , x_outside_processing_account NUMBER
35 , x_quantity_tracked NUMBER
36 , x_asset_inventory NUMBER
37 , x_source_type NUMBER
38 , x_source_subinventory VARCHAR2
39 , x_source_organization_id NUMBER
40 , x_requisition_approval_type NUMBER
41 , x_expense_account NUMBER
42 , x_encumbrance_account NUMBER
43 , x_attribute_category VARCHAR2
44 , x_attribute1 VARCHAR2
45 , x_attribute2 VARCHAR2
46 , x_attribute3 VARCHAR2
47 , x_attribute4 VARCHAR2
48 , x_attribute5 VARCHAR2
49 , x_attribute6 VARCHAR2
50 , x_attribute7 VARCHAR2
51 , x_attribute8 VARCHAR2
52 , x_attribute9 VARCHAR2
53 , x_attribute10 VARCHAR2
54 , x_attribute11 VARCHAR2
55 , x_attribute12 VARCHAR2
56 , x_attribute13 VARCHAR2
57 , x_attribute14 VARCHAR2
58 , x_attribute15 VARCHAR2
59 , x_preprocessing_lead_time NUMBER
60 , x_processing_lead_time NUMBER
61 , x_postprocessing_lead_time NUMBER
62 , x_demand_class VARCHAR2
63 , x_project_id NUMBER
64 , x_task_id NUMBER
65 , x_subinventory_usage NUMBER
66 , x_notify_list_id NUMBER
67 , x_depreciable_flag NUMBER
68 , x_location_id NUMBER
69 , x_status_id NUMBER
70 , x_default_loc_status_id NUMBER
71 , x_lpn_controlled_flag NUMBER
72 , x_default_cost_group_id NUMBER
73 /* As per bug 1584641 */
74 -- , X_pick_methodology NUMBER
75 , x_pick_uom_code VARCHAR2
76 , x_cartonization_flag NUMBER
77 , x_planning_level NUMBER DEFAULT 2
78 , x_default_count_type_code NUMBER DEFAULT 2
79 , x_subinventory_type NUMBER DEFAULT 1--RCVLOCATORSSUPPORT
80 , x_enable_bulk_pick VARCHAR2 DEFAULT 'N'
81 , x_enable_locator_alias VARCHAR2 DEFAULT 'N'
82 , x_enforce_alias_uniqueness VARCHAR2 DEFAULT 'N'
83 , x_enable_opp_cyc_count_flag VARCHAR2 DEFAULT 'N' -- Added for Opp Cyc Counting bug#9248808
84 , x_opp_cyc_count_header_id NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
85 , x_opp_cyc_count_quantity NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
86 , x_opp_cyc_count_days NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
87 );
88
89 /* WMS Enhancements
90 Accomodated Status_ID, Default_Loc_Status_ID, Default_Cost_Group_ID
91 and LPN_Controlled_Flag in the following procedure. */
92 PROCEDURE lock_row(
93 x_rowid VARCHAR2
94 , x_secondary_inventory_name VARCHAR2
95 , x_organization_id NUMBER
96 , x_description VARCHAR2
97 , x_disable_date DATE
98 , x_inventory_atp_code NUMBER
99 , x_availability_type NUMBER
100 , x_reservable_type NUMBER
101 , x_locator_type NUMBER
102 , x_picking_order NUMBER
103 , x_dropping_order NUMBER
104 , x_material_account NUMBER
105 , x_material_overhead_account NUMBER
106 , x_resource_account NUMBER
107 , x_overhead_account NUMBER
108 , x_outside_processing_account NUMBER
109 , x_quantity_tracked NUMBER
110 , x_asset_inventory NUMBER
111 , x_source_type NUMBER
112 , x_source_subinventory VARCHAR2
113 , x_source_organization_id NUMBER
114 , x_requisition_approval_type NUMBER
115 , x_expense_account NUMBER
116 , x_encumbrance_account NUMBER
117 , x_attribute_category VARCHAR2
118 , x_attribute1 VARCHAR2
119 , x_attribute2 VARCHAR2
120 , x_attribute3 VARCHAR2
121 , x_attribute4 VARCHAR2
122 , x_attribute5 VARCHAR2
123 , x_attribute6 VARCHAR2
124 , x_attribute7 VARCHAR2
125 , x_attribute8 VARCHAR2
126 , x_attribute9 VARCHAR2
127 , x_attribute10 VARCHAR2
128 , x_attribute11 VARCHAR2
129 , x_attribute12 VARCHAR2
130 , x_attribute13 VARCHAR2
131 , x_attribute14 VARCHAR2
132 , x_attribute15 VARCHAR2
133 , x_preprocessing_lead_time NUMBER
134 , x_processing_lead_time NUMBER
135 , x_postprocessing_lead_time NUMBER
136 , x_demand_class VARCHAR2
137 , x_project_id NUMBER
138 , x_task_id NUMBER
139 , x_subinventory_usage NUMBER
140 , x_notify_list_id NUMBER
141 , x_depreciable_flag NUMBER
142 , x_location_id NUMBER
143 , x_status_id NUMBER
144 , x_default_loc_status_id NUMBER
145 , x_lpn_controlled_flag NUMBER
146 , x_default_cost_group_id NUMBER
147 /* As per bug 1584641 */
148 -- , X_pick_methodology NUMBER
149 , x_pick_uom_code VARCHAR2
150 , x_cartonization_flag NUMBER
151 , x_planning_level NUMBER DEFAULT 2
152 , x_default_count_type_code NUMBER DEFAULT 2
153 , x_subinventory_type NUMBER DEFAULT 1 --RCVLOCATORSSUPPORT
154 , x_enable_bulk_pick VARCHAR2 DEFAULT 'N'
155 , x_enable_locator_alias VARCHAR2 DEFAULT 'N'
156 , x_enforce_alias_uniqueness VARCHAR2 DEFAULT 'N'
157 , x_enable_opp_cyc_count_flag VARCHAR2 DEFAULT 'N' -- Added for Opp Cyc Counting bug#9248808
158 , x_opp_cyc_count_header_id NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
159 , x_opp_cyc_count_quantity NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
160 , x_opp_cyc_count_days NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
161 );
162
163 /* WMS Enhancements
164 Accomodated Status_ID, Default_Loc_Status_ID, Default_Cost_Group_ID
165 and LPN_Controlled_Flag in the following procedure. */
166 PROCEDURE update_row(
167 x_rowid VARCHAR2
168 , x_secondary_inventory_name VARCHAR2
169 , x_organization_id NUMBER
170 , x_last_update_date DATE
171 , x_last_updated_by NUMBER
172 , x_last_update_login NUMBER
173 , x_description VARCHAR2
174 , x_disable_date DATE
175 , x_inventory_atp_code NUMBER
176 , x_availability_type NUMBER
177 , x_reservable_type NUMBER
178 , x_locator_type NUMBER
179 , x_picking_order NUMBER
180 , x_dropping_order NUMBER
181 , x_material_account NUMBER
182 , x_material_overhead_account NUMBER
183 , x_resource_account NUMBER
184 , x_overhead_account NUMBER
185 , x_outside_processing_account NUMBER
186 , x_quantity_tracked NUMBER
187 , x_asset_inventory NUMBER
188 , x_source_type NUMBER
189 , x_source_subinventory VARCHAR2
190 , x_source_organization_id NUMBER
191 , x_requisition_approval_type NUMBER
192 , x_expense_account NUMBER
193 , x_encumbrance_account NUMBER
194 , x_attribute_category VARCHAR2
195 , x_attribute1 VARCHAR2
196 , x_attribute2 VARCHAR2
197 , x_attribute3 VARCHAR2
198 , x_attribute4 VARCHAR2
199 , x_attribute5 VARCHAR2
200 , x_attribute6 VARCHAR2
201 , x_attribute7 VARCHAR2
202 , x_attribute8 VARCHAR2
203 , x_attribute9 VARCHAR2
204 , x_attribute10 VARCHAR2
205 , x_attribute11 VARCHAR2
206 , x_attribute12 VARCHAR2
207 , x_attribute13 VARCHAR2
208 , x_attribute14 VARCHAR2
209 , x_attribute15 VARCHAR2
210 , x_preprocessing_lead_time NUMBER
211 , x_processing_lead_time NUMBER
212 , x_postprocessing_lead_time NUMBER
213 , x_demand_class VARCHAR2
214 , x_project_id NUMBER
215 , x_task_id NUMBER
216 , x_subinventory_usage NUMBER
217 , x_notify_list_id NUMBER
218 , x_depreciable_flag NUMBER
219 , x_location_id NUMBER
220 , x_status_id NUMBER
221 , x_default_loc_status_id NUMBER
222 , x_lpn_controlled_flag NUMBER
223 , x_default_cost_group_id NUMBER
224 /* As per bug 1584641 */
225 --, pick_methodology NUMBER
226 , x_pick_uom_code VARCHAR2
227 , x_cartonization_flag NUMBER
228 , x_planning_level NUMBER DEFAULT 2
229 , x_default_count_type_code NUMBER DEFAULT 2
230 , x_subinventory_type NUMBER DEFAULT 1 --RCVLOCATORSSUPPORT
231 , x_enable_bulk_pick VARCHAR2 DEFAULT 'N'
232 , x_enable_locator_alias VARCHAR2 DEFAULT 'N'
233 , x_enforce_alias_uniqueness VARCHAR2 DEFAULT 'N'
234 , x_enable_opp_cyc_count_flag VARCHAR2 DEFAULT 'N' -- Added for Opp Cyc Counting bug#9248808
235 , x_opp_cyc_count_header_id NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
236 , x_opp_cyc_count_quantity NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
237 , x_opp_cyc_count_days NUMBER DEFAULT NULL -- Added for Opp Cyc Counting bug#9248808
238 );
239
240 PROCEDURE delete_row(x_rowid VARCHAR2);
241
242 /* WMS Material Status Enhancements
243 This procedure caters to the maintenance of the Material Status
244 Hisotry. */
245 PROCEDURE status_history(
246 x_organization_id NUMBER
247 , x_inventory_item_id NUMBER
248 , x_lot_number VARCHAR2
249 , x_serial_number VARCHAR2
250 , x_update_method NUMBER
251 , x_status_id NUMBER
252 , x_zone_code VARCHAR2
253 , x_locator_id NUMBER
254 , x_creation_date DATE
255 , x_created_by NUMBER
256 , x_last_updated_by NUMBER
257 , x_last_update_date DATE
258 , x_last_update_login NUMBER
259 , x_initial_status_flag VARCHAR2 DEFAULT NULL
260 , x_from_mobile_apps_flag VARCHAR2 DEFAULT NULL
261 , x_pending_status NUMBER DEFAULT 0 --ERES Deferred
262 );
263
264 --Bug# 1695432 added col X_Initial_Status_Flag,X_From_Mobile_Apps_Flag
265
266 FUNCTION get_miss_num
267 RETURN NUMBER;
268 END mtl_secondary_inventories_pkg;