[Home] [Help]
PACKAGE: APPS.MTL_SECONDARY_INVENTORIES_PKG
Source
1 PACKAGE mtl_secondary_inventories_pkg AS
2 /* $Header: INVSDSUS.pls 120.2 2005/06/28 10:21:30 appldev 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 );
84
85 /* WMS Enhancements
86 Accomodated Status_ID, Default_Loc_Status_ID, Default_Cost_Group_ID
87 and LPN_Controlled_Flag in the following procedure. */
88 PROCEDURE lock_row(
89 x_rowid VARCHAR2
90 , x_secondary_inventory_name VARCHAR2
91 , x_organization_id NUMBER
92 , x_description VARCHAR2
93 , x_disable_date DATE
94 , x_inventory_atp_code NUMBER
95 , x_availability_type NUMBER
96 , x_reservable_type NUMBER
97 , x_locator_type NUMBER
98 , x_picking_order NUMBER
99 , x_dropping_order NUMBER
100 , x_material_account NUMBER
101 , x_material_overhead_account NUMBER
102 , x_resource_account NUMBER
103 , x_overhead_account NUMBER
104 , x_outside_processing_account NUMBER
105 , x_quantity_tracked NUMBER
106 , x_asset_inventory NUMBER
107 , x_source_type NUMBER
108 , x_source_subinventory VARCHAR2
109 , x_source_organization_id NUMBER
110 , x_requisition_approval_type NUMBER
111 , x_expense_account NUMBER
112 , x_encumbrance_account NUMBER
113 , x_attribute_category VARCHAR2
114 , x_attribute1 VARCHAR2
115 , x_attribute2 VARCHAR2
116 , x_attribute3 VARCHAR2
117 , x_attribute4 VARCHAR2
118 , x_attribute5 VARCHAR2
119 , x_attribute6 VARCHAR2
120 , x_attribute7 VARCHAR2
121 , x_attribute8 VARCHAR2
122 , x_attribute9 VARCHAR2
123 , x_attribute10 VARCHAR2
124 , x_attribute11 VARCHAR2
125 , x_attribute12 VARCHAR2
126 , x_attribute13 VARCHAR2
127 , x_attribute14 VARCHAR2
128 , x_attribute15 VARCHAR2
129 , x_preprocessing_lead_time NUMBER
130 , x_processing_lead_time NUMBER
131 , x_postprocessing_lead_time NUMBER
132 , x_demand_class VARCHAR2
133 , x_project_id NUMBER
134 , x_task_id NUMBER
135 , x_subinventory_usage NUMBER
136 , x_notify_list_id NUMBER
137 , x_depreciable_flag NUMBER
138 , x_location_id NUMBER
139 , x_status_id NUMBER
140 , x_default_loc_status_id NUMBER
141 , x_lpn_controlled_flag NUMBER
142 , x_default_cost_group_id NUMBER
143 /* As per bug 1584641 */
144 -- , X_pick_methodology NUMBER
145 , x_pick_uom_code VARCHAR2
146 , x_cartonization_flag NUMBER
147 , x_planning_level NUMBER DEFAULT 2
148 , x_default_count_type_code NUMBER DEFAULT 2
149 , x_subinventory_type NUMBER DEFAULT 1 --RCVLOCATORSSUPPORT
150 , x_enable_bulk_pick VARCHAR2 DEFAULT 'N'
151 , x_enable_locator_alias VARCHAR2 DEFAULT 'N'
152 , x_enforce_alias_uniqueness VARCHAR2 DEFAULT 'N'
153 );
154
155 /* WMS Enhancements
156 Accomodated Status_ID, Default_Loc_Status_ID, Default_Cost_Group_ID
157 and LPN_Controlled_Flag in the following procedure. */
158 PROCEDURE update_row(
159 x_rowid VARCHAR2
160 , x_secondary_inventory_name VARCHAR2
161 , x_organization_id NUMBER
162 , x_last_update_date DATE
163 , x_last_updated_by NUMBER
164 , x_last_update_login NUMBER
165 , x_description VARCHAR2
166 , x_disable_date DATE
167 , x_inventory_atp_code NUMBER
168 , x_availability_type NUMBER
169 , x_reservable_type NUMBER
170 , x_locator_type NUMBER
171 , x_picking_order NUMBER
172 , x_dropping_order NUMBER
173 , x_material_account NUMBER
174 , x_material_overhead_account NUMBER
175 , x_resource_account NUMBER
176 , x_overhead_account NUMBER
177 , x_outside_processing_account NUMBER
178 , x_quantity_tracked NUMBER
179 , x_asset_inventory NUMBER
180 , x_source_type NUMBER
181 , x_source_subinventory VARCHAR2
182 , x_source_organization_id NUMBER
183 , x_requisition_approval_type NUMBER
184 , x_expense_account NUMBER
185 , x_encumbrance_account NUMBER
186 , x_attribute_category VARCHAR2
187 , x_attribute1 VARCHAR2
188 , x_attribute2 VARCHAR2
189 , x_attribute3 VARCHAR2
190 , x_attribute4 VARCHAR2
191 , x_attribute5 VARCHAR2
192 , x_attribute6 VARCHAR2
193 , x_attribute7 VARCHAR2
194 , x_attribute8 VARCHAR2
195 , x_attribute9 VARCHAR2
196 , x_attribute10 VARCHAR2
197 , x_attribute11 VARCHAR2
198 , x_attribute12 VARCHAR2
199 , x_attribute13 VARCHAR2
200 , x_attribute14 VARCHAR2
201 , x_attribute15 VARCHAR2
202 , x_preprocessing_lead_time NUMBER
203 , x_processing_lead_time NUMBER
204 , x_postprocessing_lead_time NUMBER
205 , x_demand_class VARCHAR2
206 , x_project_id NUMBER
207 , x_task_id NUMBER
208 , x_subinventory_usage NUMBER
209 , x_notify_list_id NUMBER
210 , x_depreciable_flag NUMBER
211 , x_location_id NUMBER
212 , x_status_id NUMBER
213 , x_default_loc_status_id NUMBER
214 , x_lpn_controlled_flag NUMBER
215 , x_default_cost_group_id NUMBER
216 /* As per bug 1584641 */
217 --, pick_methodology NUMBER
218 , x_pick_uom_code VARCHAR2
219 , x_cartonization_flag NUMBER
220 , x_planning_level NUMBER DEFAULT 2
221 , x_default_count_type_code NUMBER DEFAULT 2
222 , x_subinventory_type NUMBER DEFAULT 1 --RCVLOCATORSSUPPORT
223 , x_enable_bulk_pick VARCHAR2 DEFAULT 'N'
224 , x_enable_locator_alias VARCHAR2 DEFAULT 'N'
225 , x_enforce_alias_uniqueness VARCHAR2 DEFAULT 'N'
226 );
227
228 PROCEDURE delete_row(x_rowid VARCHAR2);
229
230 /* WMS Material Status Enhancements
231 This procedure caters to the maintenance of the Material Status
232 Hisotry. */
233 PROCEDURE status_history(
234 x_organization_id NUMBER
235 , x_inventory_item_id NUMBER
236 , x_lot_number VARCHAR2
237 , x_serial_number VARCHAR2
238 , x_update_method NUMBER
239 , x_status_id NUMBER
240 , x_zone_code VARCHAR2
241 , x_locator_id NUMBER
242 , x_creation_date DATE
243 , x_created_by NUMBER
244 , x_last_updated_by NUMBER
245 , x_last_update_date DATE
246 , x_last_update_login NUMBER
247 , x_initial_status_flag VARCHAR2 DEFAULT NULL
248 , x_from_mobile_apps_flag VARCHAR2 DEFAULT NULL
249 );
250
251 --Bug# 1695432 added col X_Initial_Status_Flag,X_From_Mobile_Apps_Flag
252
253 FUNCTION get_miss_num
254 RETURN NUMBER;
255 END mtl_secondary_inventories_pkg;