[Home] [Help]
PACKAGE: APPS.INV_ITEM_GRP
Source
1 PACKAGE INV_ITEM_GRP AUTHID CURRENT_USER AS
2 /* $Header: INVGITMS.pls 120.3.12010000.4 2010/01/07 08:27:50 snandana ship $ */
3
4 -- ------------------------------------------------------------
5 -- -------------- Global variables and constants --------------
6 -- ------------------------------------------------------------
7
8 g_MISS_CHAR VARCHAR2(1) := fnd_api.g_MISS_CHAR;
9 g_MISS_NUM NUMBER := fnd_api.g_MISS_NUM;
10 g_MISS_DATE DATE := fnd_api.g_MISS_DATE;
11
12 -- ------------------------------------------------------
13 -- -------------------- Global types --------------------
14 -- ------------------------------------------------------
15
16 TYPE Item_rec_type IS RECORD
17 (
18 ORGANIZATION_ID NUMBER := g_MISS_NUM
19 , ORGANIZATION_CODE VARCHAR2(3) := g_MISS_CHAR
20 , INVENTORY_ITEM_ID NUMBER := g_MISS_NUM
21 , ITEM_NUMBER VARCHAR2(2000) := g_MISS_CHAR
22 , SEGMENT1 VARCHAR2(40) := g_MISS_CHAR
23 , SEGMENT2 VARCHAR2(40) := g_MISS_CHAR
24 , SEGMENT3 VARCHAR2(40) := g_MISS_CHAR
25 , SEGMENT4 VARCHAR2(40) := g_MISS_CHAR
26 , SEGMENT5 VARCHAR2(40) := g_MISS_CHAR
27 , SEGMENT6 VARCHAR2(40) := g_MISS_CHAR
28 , SEGMENT7 VARCHAR2(40) := g_MISS_CHAR
29 , SEGMENT8 VARCHAR2(40) := g_MISS_CHAR
30 , SEGMENT9 VARCHAR2(40) := g_MISS_CHAR
31 , SEGMENT10 VARCHAR2(40) := g_MISS_CHAR
32 , SEGMENT11 VARCHAR2(40) := g_MISS_CHAR
33 , SEGMENT12 VARCHAR2(40) := g_MISS_CHAR
34 , SEGMENT13 VARCHAR2(40) := g_MISS_CHAR
35 , SEGMENT14 VARCHAR2(40) := g_MISS_CHAR
36 , SEGMENT15 VARCHAR2(40) := g_MISS_CHAR
37 , SEGMENT16 VARCHAR2(40) := g_MISS_CHAR
38 , SEGMENT17 VARCHAR2(40) := g_MISS_CHAR
39 , SEGMENT18 VARCHAR2(40) := g_MISS_CHAR
40 , SEGMENT19 VARCHAR2(40) := g_MISS_CHAR
41 , SEGMENT20 VARCHAR2(40) := g_MISS_CHAR
42 , SUMMARY_FLAG VARCHAR2(1) := g_MISS_CHAR
43 , ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
44 , START_DATE_ACTIVE DATE := g_MISS_DATE
45 , END_DATE_ACTIVE DATE := g_MISS_DATE
46 --
47 -- Main attributes
48 --
49 , DESCRIPTION VARCHAR2(240) := g_MISS_CHAR
50 , LONG_DESCRIPTION VARCHAR2(4000) := g_MISS_CHAR
51 , PRIMARY_UOM_CODE VARCHAR2(3) := g_MISS_CHAR
52 , PRIMARY_UNIT_OF_MEASURE VARCHAR2(25) := g_MISS_CHAR
53 , ITEM_TYPE VARCHAR2(30) := g_MISS_CHAR
54 , INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) := g_MISS_CHAR
55 , ALLOWED_UNITS_LOOKUP_CODE NUMBER := g_MISS_NUM
56 , ITEM_CATALOG_GROUP_ID NUMBER := g_MISS_NUM
57 , CATALOG_STATUS_FLAG VARCHAR2(1) := g_MISS_CHAR
58 , INVENTORY_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
59 , STOCK_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
60 , MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
61 , CHECK_SHORTAGES_FLAG VARCHAR2(1) := g_MISS_CHAR
62 , REVISION_QTY_CONTROL_CODE NUMBER := g_MISS_NUM
63 , RESERVABLE_TYPE NUMBER := g_MISS_NUM
64 , SHELF_LIFE_CODE NUMBER := g_MISS_NUM
65 , SHELF_LIFE_DAYS NUMBER := g_MISS_NUM
66 , CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
67 , NEGATIVE_MEASUREMENT_ERROR NUMBER := g_MISS_NUM
68 , POSITIVE_MEASUREMENT_ERROR NUMBER := g_MISS_NUM
69 , LOT_CONTROL_CODE NUMBER := g_MISS_NUM
70 , AUTO_LOT_ALPHA_PREFIX VARCHAR2(30) := g_MISS_CHAR
71 , START_AUTO_LOT_NUMBER VARCHAR2(30) := g_MISS_CHAR
72 , SERIAL_NUMBER_CONTROL_CODE NUMBER := g_MISS_NUM
73 , AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30) := g_MISS_CHAR
74 , START_AUTO_SERIAL_NUMBER VARCHAR2(30) := g_MISS_CHAR
75 , LOCATION_CONTROL_CODE NUMBER := g_MISS_NUM
76 , RESTRICT_SUBINVENTORIES_CODE NUMBER := g_MISS_NUM
77 , RESTRICT_LOCATORS_CODE NUMBER := g_MISS_NUM
78 , BOM_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
79 , BOM_ITEM_TYPE NUMBER := g_MISS_NUM
80 , BASE_ITEM_ID NUMBER := g_MISS_NUM
81 , EFFECTIVITY_CONTROL NUMBER := g_MISS_NUM
82 , ENG_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
83 , ENGINEERING_ECN_CODE VARCHAR2(50) := g_MISS_CHAR
84 , ENGINEERING_ITEM_ID NUMBER := g_MISS_NUM
85 , ENGINEERING_DATE DATE := g_MISS_DATE
86 , PRODUCT_FAMILY_ITEM_ID NUMBER := g_MISS_NUM
87 , AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) := g_MISS_CHAR
88 , MODEL_CONFIG_CLAUSE_NAME VARCHAR2(10) := g_MISS_CHAR
89 , COSTING_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
90 , INVENTORY_ASSET_FLAG VARCHAR2(1) := g_MISS_CHAR
91 , DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1) := g_MISS_CHAR
92 , COST_OF_SALES_ACCOUNT NUMBER := g_MISS_NUM
93 , STD_LOT_SIZE NUMBER := g_MISS_NUM
94 , PURCHASING_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
95 , PURCHASING_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
96 , MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1) := g_MISS_CHAR
97 , ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1) := g_MISS_CHAR
98 , RFQ_REQUIRED_FLAG VARCHAR2(1) := g_MISS_CHAR
99 , OUTSIDE_OPERATION_FLAG VARCHAR2(1) := g_MISS_CHAR
100 , OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25) := g_MISS_CHAR
101 , TAXABLE_FLAG VARCHAR2(1) := g_MISS_CHAR
102 , PURCHASING_TAX_CODE VARCHAR2(50) := g_MISS_CHAR
103 , RECEIPT_REQUIRED_FLAG VARCHAR2(1) := g_MISS_CHAR
104 , INSPECTION_REQUIRED_FLAG VARCHAR2(1) := g_MISS_CHAR
105 , BUYER_ID NUMBER := g_MISS_NUM
106 , UNIT_OF_ISSUE VARCHAR2(25) := g_MISS_CHAR
107 , RECEIVE_CLOSE_TOLERANCE NUMBER := g_MISS_NUM
108 , INVOICE_CLOSE_TOLERANCE NUMBER := g_MISS_NUM
109 , UN_NUMBER_ID NUMBER := g_MISS_NUM
110 , HAZARD_CLASS_ID NUMBER := g_MISS_NUM
111 , LIST_PRICE_PER_UNIT NUMBER := g_MISS_NUM
112 , MARKET_PRICE NUMBER := g_MISS_NUM
113 , PRICE_TOLERANCE_PERCENT NUMBER := g_MISS_NUM
114 , ROUNDING_FACTOR NUMBER := g_MISS_NUM
115 , ENCUMBRANCE_ACCOUNT NUMBER := g_MISS_NUM
116 , EXPENSE_ACCOUNT NUMBER := g_MISS_NUM
117 , ASSET_CATEGORY_ID NUMBER := g_MISS_NUM
118 , RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25) := g_MISS_CHAR
119 , DAYS_EARLY_RECEIPT_ALLOWED NUMBER := g_MISS_NUM
120 , DAYS_LATE_RECEIPT_ALLOWED NUMBER := g_MISS_NUM
121 , ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1) := g_MISS_CHAR
122 , ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1) := g_MISS_CHAR
123 , ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1) := g_MISS_CHAR
124 , QTY_RCV_EXCEPTION_CODE VARCHAR2(25) := g_MISS_CHAR
125 , QTY_RCV_TOLERANCE NUMBER := g_MISS_NUM
126 , RECEIVING_ROUTING_ID NUMBER := g_MISS_NUM
127 , ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25) := g_MISS_CHAR
128 , WEIGHT_UOM_CODE VARCHAR2(3) := g_MISS_CHAR
129 , UNIT_WEIGHT NUMBER := g_MISS_NUM
130 , VOLUME_UOM_CODE VARCHAR2(3) := g_MISS_CHAR
131 , UNIT_VOLUME NUMBER := g_MISS_NUM
132 , CONTAINER_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
133 , VEHICLE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
134 , CONTAINER_TYPE_CODE VARCHAR2(30) := g_MISS_CHAR
135 , INTERNAL_VOLUME NUMBER := g_MISS_NUM
136 , MAXIMUM_LOAD_WEIGHT NUMBER := g_MISS_NUM
137 , MINIMUM_FILL_PERCENT NUMBER := g_MISS_NUM
138 , INVENTORY_PLANNING_CODE NUMBER := g_MISS_NUM
139 , PLANNER_CODE VARCHAR2(10) := g_MISS_CHAR
140 , PLANNING_MAKE_BUY_CODE NUMBER := g_MISS_NUM
141 , MIN_MINMAX_QUANTITY NUMBER := g_MISS_NUM
142 , MAX_MINMAX_QUANTITY NUMBER := g_MISS_NUM
143 , MINIMUM_ORDER_QUANTITY NUMBER := g_MISS_NUM
144 , MAXIMUM_ORDER_QUANTITY NUMBER := g_MISS_NUM
145 , ORDER_COST NUMBER := g_MISS_NUM
146 , CARRYING_COST NUMBER := g_MISS_NUM
147 , SOURCE_TYPE NUMBER := g_MISS_NUM
148 , SOURCE_ORGANIZATION_ID NUMBER := g_MISS_NUM
149 , SOURCE_SUBINVENTORY VARCHAR2(10) := g_MISS_CHAR
150 , MRP_SAFETY_STOCK_CODE NUMBER := g_MISS_NUM
151 , SAFETY_STOCK_BUCKET_DAYS NUMBER := g_MISS_NUM
152 , MRP_SAFETY_STOCK_PERCENT NUMBER := g_MISS_NUM
153 , FIXED_ORDER_QUANTITY NUMBER := g_MISS_NUM
154 , FIXED_DAYS_SUPPLY NUMBER := g_MISS_NUM
155 , FIXED_LOT_MULTIPLIER NUMBER := g_MISS_NUM
156 , MRP_PLANNING_CODE NUMBER := g_MISS_NUM
157 , ATO_FORECAST_CONTROL NUMBER := g_MISS_NUM
158 , PLANNING_EXCEPTION_SET VARCHAR2(10) := g_MISS_CHAR
159 , END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1) := g_MISS_CHAR
160 , SHRINKAGE_RATE NUMBER := g_MISS_NUM
161 , ROUNDING_CONTROL_TYPE NUMBER := g_MISS_NUM
162 , ACCEPTABLE_EARLY_DAYS NUMBER := g_MISS_NUM
163 , REPETITIVE_PLANNING_FLAG VARCHAR2(1) := g_MISS_CHAR
164 , OVERRUN_PERCENTAGE NUMBER := g_MISS_NUM
165 , ACCEPTABLE_RATE_INCREASE NUMBER := g_MISS_NUM
166 , ACCEPTABLE_RATE_DECREASE NUMBER := g_MISS_NUM
167 , MRP_CALCULATE_ATP_FLAG VARCHAR2(1) := g_MISS_CHAR
168 , AUTO_REDUCE_MPS NUMBER := g_MISS_NUM
169 , PLANNING_TIME_FENCE_CODE NUMBER := g_MISS_NUM
170 , PLANNING_TIME_FENCE_DAYS NUMBER := g_MISS_NUM
171 , DEMAND_TIME_FENCE_CODE NUMBER := g_MISS_NUM
172 , DEMAND_TIME_FENCE_DAYS NUMBER := g_MISS_NUM
173 , RELEASE_TIME_FENCE_CODE NUMBER := g_MISS_NUM
174 , RELEASE_TIME_FENCE_DAYS NUMBER := g_MISS_NUM
175 , PREPROCESSING_LEAD_TIME NUMBER := g_MISS_NUM
176 , FULL_LEAD_TIME NUMBER := g_MISS_NUM
177 , POSTPROCESSING_LEAD_TIME NUMBER := g_MISS_NUM
178 , FIXED_LEAD_TIME NUMBER := g_MISS_NUM
179 , VARIABLE_LEAD_TIME NUMBER := g_MISS_NUM
180 , CUM_MANUFACTURING_LEAD_TIME NUMBER := g_MISS_NUM
181 , CUMULATIVE_TOTAL_LEAD_TIME NUMBER := g_MISS_NUM
182 , LEAD_TIME_LOT_SIZE NUMBER := g_MISS_NUM
183 , BUILD_IN_WIP_FLAG VARCHAR2(1) := g_MISS_CHAR
184 , WIP_SUPPLY_TYPE NUMBER := g_MISS_NUM
185 , WIP_SUPPLY_SUBINVENTORY VARCHAR2(10) := g_MISS_CHAR
186 , WIP_SUPPLY_LOCATOR_ID NUMBER := g_MISS_NUM
187 , OVERCOMPLETION_TOLERANCE_TYPE NUMBER := g_MISS_NUM
188 , OVERCOMPLETION_TOLERANCE_VALUE NUMBER := g_MISS_NUM
189 , CUSTOMER_ORDER_FLAG VARCHAR2(1) := g_MISS_CHAR
190 , CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
191 , SHIPPABLE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
192 , INTERNAL_ORDER_FLAG VARCHAR2(1) := g_MISS_CHAR
193 , INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
194 , SO_TRANSACTIONS_FLAG VARCHAR2(1) := g_MISS_CHAR
195 , PICK_COMPONENTS_FLAG VARCHAR2(1) := g_MISS_CHAR
196 , ATP_FLAG VARCHAR2(1) := g_MISS_CHAR
197 , REPLENISH_TO_ORDER_FLAG VARCHAR2(1) := g_MISS_CHAR
198 , ATP_RULE_ID NUMBER := g_MISS_NUM
199 , ATP_COMPONENTS_FLAG VARCHAR2(1) := g_MISS_CHAR
200 , SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1) := g_MISS_CHAR
201 , PICKING_RULE_ID NUMBER := g_MISS_NUM
202 , COLLATERAL_FLAG VARCHAR2(1) := g_MISS_CHAR
203 , DEFAULT_SHIPPING_ORG NUMBER := g_MISS_NUM
204 , RETURNABLE_FLAG VARCHAR2(1) := g_MISS_CHAR
205 , RETURN_INSPECTION_REQUIREMENT NUMBER := g_MISS_NUM
206 , OVER_SHIPMENT_TOLERANCE NUMBER := g_MISS_NUM
207 , UNDER_SHIPMENT_TOLERANCE NUMBER := g_MISS_NUM
208 , OVER_RETURN_TOLERANCE NUMBER := g_MISS_NUM
209 , UNDER_RETURN_TOLERANCE NUMBER := g_MISS_NUM
210 , INVOICEABLE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
211 , INVOICE_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
212 , ACCOUNTING_RULE_ID NUMBER := g_MISS_NUM
213 , INVOICING_RULE_ID NUMBER := g_MISS_NUM
214 , TAX_CODE VARCHAR2(50) := g_MISS_CHAR
215 , SALES_ACCOUNT NUMBER := g_MISS_NUM
216 , PAYMENT_TERMS_ID NUMBER := g_MISS_NUM
217 , COVERAGE_SCHEDULE_ID NUMBER := g_MISS_NUM
218 , SERVICE_DURATION NUMBER := g_MISS_NUM
219 , SERVICE_DURATION_PERIOD_CODE VARCHAR2(10) := g_MISS_CHAR
220 , SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) := g_MISS_CHAR
221 , SERVICE_STARTING_DELAY NUMBER := g_MISS_NUM
222 , MATERIAL_BILLABLE_FLAG VARCHAR2(30) := g_MISS_CHAR
223 , SERVICEABLE_COMPONENT_FLAG VARCHAR2(1) := g_MISS_CHAR
224 , PREVENTIVE_MAINTENANCE_FLAG VARCHAR2(1) := g_MISS_CHAR
225 , PRORATE_SERVICE_FLAG VARCHAR2(1) := g_MISS_CHAR
226 , WH_UPDATE_DATE DATE := g_MISS_DATE
227 , EQUIPMENT_TYPE NUMBER := g_MISS_NUM
228 , RECOVERED_PART_DISP_CODE VARCHAR2(30) := g_MISS_CHAR
229 , DEFECT_TRACKING_ON_FLAG VARCHAR2(1) := g_MISS_CHAR
230 , EVENT_FLAG VARCHAR2(1) := g_MISS_CHAR
231 , ELECTRONIC_FLAG VARCHAR2(1) := g_MISS_CHAR
232 , DOWNLOADABLE_FLAG VARCHAR2(1) := g_MISS_CHAR
233 , VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1) := g_MISS_CHAR
234 , COUPON_EXEMPT_FLAG VARCHAR2(1) := g_MISS_CHAR
235 , COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := g_MISS_CHAR
236 , ASSET_CREATION_CODE VARCHAR2(30) := g_MISS_CHAR
237 , COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1) := g_MISS_CHAR
238 , WEB_STATUS VARCHAR2(30) := g_MISS_CHAR
239 , ORDERABLE_ON_WEB_FLAG VARCHAR2(1) := g_MISS_CHAR
240 , BACK_ORDERABLE_FLAG VARCHAR2(1) := g_MISS_CHAR
241 , INDIVISIBLE_FLAG VARCHAR2(1) := g_MISS_CHAR
242 , DIMENSION_UOM_CODE VARCHAR2(3) := g_MISS_CHAR
243 , UNIT_LENGTH NUMBER := g_MISS_NUM
244 , UNIT_WIDTH NUMBER := g_MISS_NUM
245 , UNIT_HEIGHT NUMBER := g_MISS_NUM
246 , BULK_PICKED_FLAG VARCHAR2(1) := g_MISS_CHAR
247 , LOT_STATUS_ENABLED VARCHAR2(1) := g_MISS_CHAR
248 , DEFAULT_LOT_STATUS_ID NUMBER := g_MISS_NUM
249 , SERIAL_STATUS_ENABLED VARCHAR2(1) := g_MISS_CHAR
250 , DEFAULT_SERIAL_STATUS_ID NUMBER := g_MISS_NUM
254 , OPERATION_SLACK_PENALTY NUMBER := g_MISS_NUM
251 , LOT_SPLIT_ENABLED VARCHAR2(1) := g_MISS_CHAR
252 , LOT_MERGE_ENABLED VARCHAR2(1) := g_MISS_CHAR
253 , INVENTORY_CARRY_PENALTY NUMBER := g_MISS_NUM
255 , FINANCING_ALLOWED_FLAG VARCHAR2(1) := g_MISS_CHAR
256 , EAM_ITEM_TYPE NUMBER := g_MISS_NUM
257 , EAM_ACTIVITY_TYPE_CODE VARCHAR2(30) := g_MISS_CHAR
258 , EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30) := g_MISS_CHAR
259 , EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1) := g_MISS_CHAR
260 , EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30) := g_MISS_CHAR
261 , DUAL_UOM_CONTROL NUMBER := g_MISS_NUM
262 , SECONDARY_UOM_CODE VARCHAR2(3) := g_MISS_CHAR
263 , DUAL_UOM_DEVIATION_HIGH NUMBER := g_MISS_NUM
264 , DUAL_UOM_DEVIATION_LOW NUMBER := g_MISS_NUM
265 --
266 , SERVICE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
267 , VENDOR_WARRANTY_FLAG VARCHAR2(1) := g_MISS_CHAR
268 , USAGE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
269 --
270 , CONTRACT_ITEM_TYPE_CODE VARCHAR2(30) := g_MISS_CHAR
271 , SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1) := g_MISS_CHAR
272 --
273 , SERV_REQ_ENABLED_CODE VARCHAR2(30) := g_MISS_CHAR
274 , SERV_BILLING_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
275 , SERV_IMPORTANCE_LEVEL NUMBER := g_MISS_NUM
276 , PLANNED_INV_POINT_FLAG VARCHAR2(1) := g_MISS_CHAR
277 , LOT_TRANSLATE_ENABLED VARCHAR2(1) := g_MISS_CHAR
278 , DEFAULT_SO_SOURCE_TYPE VARCHAR2(30) := g_MISS_CHAR
279 , CREATE_SUPPLY_FLAG VARCHAR2(1) := g_MISS_CHAR
280 , SUBSTITUTION_WINDOW_CODE NUMBER := g_MISS_NUM
281 , SUBSTITUTION_WINDOW_DAYS NUMBER := g_MISS_NUM
282 --Added as part of 11.5.9
283 , LOT_SUBSTITUTION_ENABLED VARCHAR2(1) := g_MISS_CHAR
284 , MINIMUM_LICENSE_QUANTITY NUMBER := g_MISS_NUM
285 , EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30) := g_MISS_CHAR
286 , IB_ITEM_INSTANCE_CLASS VARCHAR2(30) := g_MISS_CHAR
287 , CONFIG_MODEL_TYPE VARCHAR2(30) := g_MISS_CHAR
288 --Added as part of 11.5.10
289 , TRACKING_QUANTITY_IND VARCHAR2(30) := g_MISS_CHAR
290 , ONT_PRICING_QTY_SOURCE VARCHAR2(30) := g_MISS_CHAR
291 , SECONDARY_DEFAULT_IND VARCHAR2(30) := g_MISS_CHAR
292 , CONFIG_ORGS VARCHAR2(30) := g_MISS_CHAR
293 , CONFIG_MATCH VARCHAR2(30) := g_MISS_CHAR
294 --
295 -- Descriptive flex
296 --
297 , ATTRIBUTE_CATEGORY VARCHAR2(30) := g_MISS_CHAR
298 , ATTRIBUTE1 VARCHAR2(240) := g_MISS_CHAR
299 , ATTRIBUTE2 VARCHAR2(240) := g_MISS_CHAR
300 , ATTRIBUTE3 VARCHAR2(240) := g_MISS_CHAR
301 , ATTRIBUTE4 VARCHAR2(240) := g_MISS_CHAR
302 , ATTRIBUTE5 VARCHAR2(240) := g_MISS_CHAR
303 , ATTRIBUTE6 VARCHAR2(240) := g_MISS_CHAR
304 , ATTRIBUTE7 VARCHAR2(240) := g_MISS_CHAR
305 , ATTRIBUTE8 VARCHAR2(240) := g_MISS_CHAR
306 , ATTRIBUTE9 VARCHAR2(240) := g_MISS_CHAR
307 , ATTRIBUTE10 VARCHAR2(240) := g_MISS_CHAR
308 , ATTRIBUTE11 VARCHAR2(240) := g_MISS_CHAR
309 , ATTRIBUTE12 VARCHAR2(240) := g_MISS_CHAR
310 , ATTRIBUTE13 VARCHAR2(240) := g_MISS_CHAR
311 , ATTRIBUTE14 VARCHAR2(240) := g_MISS_CHAR
312 , ATTRIBUTE15 VARCHAR2(240) := g_MISS_CHAR
313 /* Start Bug 3713912 */
314 , ATTRIBUTE16 VARCHAR2(240) := g_MISS_CHAR
315 , ATTRIBUTE17 VARCHAR2(240) := g_MISS_CHAR
316 , ATTRIBUTE18 VARCHAR2(240) := g_MISS_CHAR
317 , ATTRIBUTE19 VARCHAR2(240) := g_MISS_CHAR
318 , ATTRIBUTE20 VARCHAR2(240) := g_MISS_CHAR
319 , ATTRIBUTE21 VARCHAR2(240) := g_MISS_CHAR
320 , ATTRIBUTE22 VARCHAR2(240) := g_MISS_CHAR
321 , ATTRIBUTE23 VARCHAR2(240) := g_MISS_CHAR
322 , ATTRIBUTE24 VARCHAR2(240) := g_MISS_CHAR
323 , ATTRIBUTE25 VARCHAR2(240) := g_MISS_CHAR
324 , ATTRIBUTE26 VARCHAR2(240) := g_MISS_CHAR
325 , ATTRIBUTE27 VARCHAR2(240) := g_MISS_CHAR
326 , ATTRIBUTE28 VARCHAR2(240) := g_MISS_CHAR
327 , ATTRIBUTE29 VARCHAR2(240) := g_MISS_CHAR
328 , ATTRIBUTE30 VARCHAR2(240) := g_MISS_CHAR
329 /* End Bug 3713912 */
330 , GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(150) := g_MISS_CHAR
331 , GLOBAL_ATTRIBUTE1 VARCHAR2(150) := g_MISS_CHAR
332 , GLOBAL_ATTRIBUTE2 VARCHAR2(150) := g_MISS_CHAR
333 , GLOBAL_ATTRIBUTE3 VARCHAR2(150) := g_MISS_CHAR
334 , GLOBAL_ATTRIBUTE4 VARCHAR2(150) := g_MISS_CHAR
335 , GLOBAL_ATTRIBUTE5 VARCHAR2(150) := g_MISS_CHAR
336 , GLOBAL_ATTRIBUTE6 VARCHAR2(150) := g_MISS_CHAR
337 , GLOBAL_ATTRIBUTE7 VARCHAR2(150) := g_MISS_CHAR
338 , GLOBAL_ATTRIBUTE8 VARCHAR2(150) := g_MISS_CHAR
339 , GLOBAL_ATTRIBUTE9 VARCHAR2(150) := g_MISS_CHAR
340 , GLOBAL_ATTRIBUTE10 VARCHAR2(150) := g_MISS_CHAR
341 , GLOBAL_ATTRIBUTE11 VARCHAR2(150) := g_MISS_CHAR
342 , GLOBAL_ATTRIBUTE12 VARCHAR2(150) := g_MISS_CHAR
346 , GLOBAL_ATTRIBUTE16 VARCHAR2(150) := g_MISS_CHAR
343 , GLOBAL_ATTRIBUTE13 VARCHAR2(150) := g_MISS_CHAR
344 , GLOBAL_ATTRIBUTE14 VARCHAR2(150) := g_MISS_CHAR
345 , GLOBAL_ATTRIBUTE15 VARCHAR2(150) := g_MISS_CHAR
347 , GLOBAL_ATTRIBUTE17 VARCHAR2(150) := g_MISS_CHAR
348 , GLOBAL_ATTRIBUTE18 VARCHAR2(150) := g_MISS_CHAR
349 , GLOBAL_ATTRIBUTE19 VARCHAR2(150) := g_MISS_CHAR
350 , GLOBAL_ATTRIBUTE20 VARCHAR2(150) := g_MISS_CHAR
351 --
352 -- Lifecycle
353 --
354 , Lifecycle_Id NUMBER := g_MISS_NUM
355 , Current_Phase_Id NUMBER := g_MISS_NUM
356 --
357 -- Who
358 --
359 , CREATION_DATE DATE := g_MISS_DATE
360 , CREATED_BY NUMBER := g_MISS_NUM
361 , LAST_UPDATE_DATE DATE := g_MISS_DATE
362 , LAST_UPDATED_BY NUMBER := g_MISS_NUM
363 , LAST_UPDATE_LOGIN NUMBER := g_MISS_NUM
364 , REQUEST_ID NUMBER := g_MISS_NUM
365 , PROGRAM_APPLICATION_ID NUMBER := g_MISS_NUM
366 , PROGRAM_ID NUMBER := g_MISS_NUM
367 , PROGRAM_UPDATE_DATE DATE := g_MISS_DATE
368 , VMI_MINIMUM_UNITS NUMBER := g_MISS_NUM
369 , VMI_MINIMUM_DAYS NUMBER := g_MISS_NUM
370 , VMI_MAXIMUM_UNITS NUMBER := g_MISS_NUM
371 , VMI_MAXIMUM_DAYS NUMBER := g_MISS_NUM
372 , VMI_FIXED_ORDER_QUANTITY NUMBER := g_MISS_NUM
373 , SO_AUTHORIZATION_FLAG NUMBER := g_MISS_NUM
374 , CONSIGNED_FLAG NUMBER := g_MISS_NUM
375 , ASN_AUTOEXPIRE_FLAG NUMBER := g_MISS_NUM
376 , VMI_FORECAST_TYPE NUMBER := g_MISS_NUM
377 , FORECAST_HORIZON NUMBER := g_MISS_NUM
378 , EXCLUDE_FROM_BUDGET_FLAG NUMBER := g_MISS_NUM
379 , DAYS_TGT_INV_SUPPLY NUMBER := g_MISS_NUM
380 , DAYS_TGT_INV_WINDOW NUMBER := g_MISS_NUM
381 , DAYS_MAX_INV_SUPPLY NUMBER := g_MISS_NUM
382 , DAYS_MAX_INV_WINDOW NUMBER := g_MISS_NUM
383 , DRP_PLANNED_FLAG NUMBER := g_MISS_NUM
384 , CRITICAL_COMPONENT_FLAG NUMBER := g_MISS_NUM
385 , CONTINOUS_TRANSFER NUMBER := g_MISS_NUM
386 , CONVERGENCE NUMBER := g_MISS_NUM
387 , DIVERGENCE NUMBER := g_MISS_NUM
388 /* Start Bug 3713912 */
389 , LOT_DIVISIBLE_FLAG VARCHAR2(1) := g_MISS_CHAR
390 , GRADE_CONTROL_FLAG VARCHAR2(1) := g_MISS_CHAR
391 , DEFAULT_GRADE VARCHAR2(150) := g_MISS_CHAR
392 , CHILD_LOT_FLAG VARCHAR2(1) := g_MISS_CHAR
393 , PARENT_CHILD_GENERATION_FLAG VARCHAR2(1) := g_MISS_CHAR
394 , CHILD_LOT_PREFIX VARCHAR2(30) := g_MISS_CHAR
395 , CHILD_LOT_STARTING_NUMBER NUMBER := g_MISS_NUM
396 , CHILD_LOT_VALIDATION_FLAG VARCHAR2(1) := g_MISS_CHAR
397 , COPY_LOT_ATTRIBUTE_FLAG VARCHAR2(1) := g_MISS_CHAR
398 , RECIPE_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
399 , PROCESS_QUALITY_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
400 , PROCESS_EXECUTION_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
401 , PROCESS_COSTING_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
402 , PROCESS_SUPPLY_SUBINVENTORY VARCHAR2(10) := g_MISS_CHAR
403 , PROCESS_SUPPLY_LOCATOR_ID NUMBER := g_MISS_NUM
404 , PROCESS_YIELD_SUBINVENTORY VARCHAR2(10) := g_MISS_CHAR
405 , PROCESS_YIELD_LOCATOR_ID NUMBER := g_MISS_NUM
406 , HAZARDOUS_MATERIAL_FLAG VARCHAR2(1) := g_MISS_CHAR
407 , CAS_NUMBER VARCHAR2(30) := g_MISS_CHAR
408 , RETEST_INTERVAL NUMBER := g_MISS_NUM
409 , EXPIRATION_ACTION_INTERVAL NUMBER := g_MISS_NUM
410 /* Bug 9217515. Changing the length to 32 characters, to sync it up with the column length in mtl_system_items_b table. */
411 , EXPIRATION_ACTION_CODE VARCHAR2(32) := g_MISS_CHAR
412 , MATURITY_DAYS NUMBER := g_MISS_NUM
413 , HOLD_DAYS NUMBER := g_MISS_NUM
414 , PROCESS_ITEM_RECORD NUMBER := g_MISS_NUM
415 /* End Bug 3713912 */
416 /* R12 Enhancement */
417 , CHARGE_PERIODICITY_CODE VARCHAR2(3) := g_MISS_CHAR
418 , REPAIR_LEADTIME NUMBER := g_MISS_NUM
419 , REPAIR_YIELD NUMBER := g_MISS_NUM
420 , PREPOSITION_POINT VARCHAR2(1) := g_MISS_CHAR
421 , REPAIR_PROGRAM NUMBER := g_MISS_NUM
422 , SUBCONTRACTING_COMPONENT NUMBER := g_MISS_NUM
423 , OUTSOURCED_ASSEMBLY NUMBER := g_MISS_NUM
424 --R12 C Attributes
425 , GDSN_OUTBOUND_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
426 , TRADE_ITEM_DESCRIPTOR VARCHAR2(35) := g_MISS_CHAR
427 , STYLE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
428 , STYLE_ITEM_ID NUMBER := g_MISS_NUM
429 );
430
431 --Added revision record to create/update API
432 TYPE Item_Revision_Rec_Type IS RECORD(
433 Transaction_Type VARCHAR2(30) := G_MISS_CHAR
434 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
435 ,Language_Code VARCHAR2(4) := G_MISS_CHAR
436 -- Revision identifier
437 ,Inventory_Item_Id NUMBER := G_MISS_NUM
441 ,Revision_Id NUMBER := G_MISS_NUM
438 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
439 ,Organization_Id NUMBER := G_MISS_NUM
440 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
442 -- Attributes
443 ,Revision_Code VARCHAR2(3) := G_MISS_CHAR
444 ,Revision_Label VARCHAR2(80) := G_MISS_CHAR
445 ,Description VARCHAR2(240) := G_MISS_CHAR
446 ,Change_Notice VARCHAR2(10) := G_MISS_CHAR
447 ,Ecn_Initiation_Date DATE := G_MISS_DATE
448 ,Implementation_Date DATE := G_MISS_DATE
449 ,Effectivity_Date DATE := G_MISS_DATE
450 ,Revised_Item_Sequence_Id NUMBER := G_MISS_NUM
451 -- Lifecycle
452 ,Lifecycle_Id NUMBER := G_MISS_NUM
453 ,Current_Phase_Id NUMBER := G_MISS_NUM
454 -- Added for 5208102
455 ,template_id MTL_ITEM_TEMPLATES_B.TEMPLATE_ID%TYPE := G_MISS_NUM
456 ,template_name MTL_ITEM_TEMPLATES_TL.TEMPLATE_NAME%TYPE := G_MISS_CHAR
457 -- Descriptive flex
458 ,Attribute_Category VARCHAR2(30) := G_MISS_CHAR
459 ,Attribute1 VARCHAR2(150) := G_MISS_CHAR
460 ,Attribute2 VARCHAR2(150) := G_MISS_CHAR
461 ,Attribute3 VARCHAR2(150) := G_MISS_CHAR
462 ,Attribute4 VARCHAR2(150) := G_MISS_CHAR
463 ,Attribute5 VARCHAR2(150) := G_MISS_CHAR
464 ,Attribute6 VARCHAR2(150) := G_MISS_CHAR
465 ,Attribute7 VARCHAR2(150) := G_MISS_CHAR
466 ,Attribute8 VARCHAR2(150) := G_MISS_CHAR
467 ,Attribute9 VARCHAR2(150) := G_MISS_CHAR
468 ,Attribute10 VARCHAR2(150) := G_MISS_CHAR
469 ,Attribute11 VARCHAR2(150) := G_MISS_CHAR
470 ,Attribute12 VARCHAR2(150) := G_MISS_CHAR
471 ,Attribute13 VARCHAR2(150) := G_MISS_CHAR
472 ,Attribute14 VARCHAR2(150) := G_MISS_CHAR
473 ,Attribute15 VARCHAR2(150) := G_MISS_CHAR
474 -- Who
475 ,Object_Version_Number NUMBER := G_MISS_NUM
476 ,Creation_Date DATE := G_MISS_DATE
477 ,Created_By NUMBER := G_MISS_NUM
478 ,Last_Update_Date DATE := G_MISS_DATE
479 ,Last_Updated_By NUMBER := G_MISS_NUM
480 ,Last_Update_Login NUMBER := G_MISS_NUM);
481
482
483 TYPE Error_rec_type IS RECORD
484 (
485 TRANSACTION_ID NUMBER
486 , UNIQUE_ID NUMBER
487 , MESSAGE_NAME VARCHAR2(30)
488 , MESSAGE_TEXT VARCHAR2(2000)
489 , TABLE_NAME VARCHAR2(30)
490 , COLUMN_NAME VARCHAR2(32)
491 , ORGANIZATION_ID NUMBER
492 );
493
494 TYPE Error_tbl_type IS TABLE OF Error_rec_type
495 INDEX BY BINARY_INTEGER;
496
497 -- ----------------------------------------------------------------
498 -- ------------ Variables representing missing values -------------
499 -- ----------------------------------------------------------------
500
501 g_Miss_Item_rec INV_ITEM_GRP.Item_rec_type;
502 g_Miss_Revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
503
504 -- --------------------------------------------------------
505 -- ------------------- Procedure specs --------------------
506 -- --------------------------------------------------------
507
508 -- -------------------- Create_Item -------------------
509 PROCEDURE Create_Item
510 (
511 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
512 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
513 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
514 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
515 , x_return_status OUT NOCOPY VARCHAR2
516 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
517 , p_Template_Id IN NUMBER DEFAULT NULL
518 , p_Template_Name IN VARCHAR2 DEFAULT NULL
519 );
520
521 PROCEDURE Create_Item
522 (
523 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
524 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
525 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
526 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
527 , x_return_status OUT NOCOPY VARCHAR2
528 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
529 , p_Template_Id IN NUMBER DEFAULT NULL
530 , p_Template_Name IN VARCHAR2 DEFAULT NULL
531 , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
532 -- Bug 9092888 - changes
533 , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL
534 , p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
535 -- Bug 9092888 - changes
536
537 );
538
539 -- -------------------- Update_Item -------------------
540
544 , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
541 PROCEDURE Update_Item
542 (
543 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
545 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
546 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
547 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
548 , x_return_status OUT NOCOPY VARCHAR2
549 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
550 , p_Template_Id IN NUMBER DEFAULT NULL
551 , p_Template_Name IN VARCHAR2 DEFAULT NULL
552 );
553
554 PROCEDURE Update_Item
555 (
556 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
557 , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
558 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
559 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
560 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
561 , x_return_status OUT NOCOPY VARCHAR2
562 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
563 , p_Template_Id IN NUMBER DEFAULT NULL
564 , p_Template_Name IN VARCHAR2 DEFAULT NULL
565 , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
566 );
567
568 -- -------------------- Lock_Item --------------------
569
570 PROCEDURE Lock_Item
571 (
572 p_Item_ID IN NUMBER
573 , p_Org_ID IN NUMBER
574 , x_return_status OUT NOCOPY VARCHAR2
575 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
576 );
577
578 -- -------------------- Get_Item ---------------------
579
580 PROCEDURE Get_Item
581 (
582 p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
583 , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
584 , p_Org_ID IN NUMBER
585 , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
586 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
587 , x_return_status OUT NOCOPY VARCHAR2
588 , x_return_err OUT NOCOPY VARCHAR2
589 );
590
591 PROCEDURE Interface_Handler
592 ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
593 ,p_transaction_type IN VARCHAR2
594 ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
595 ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
596 ,p_Template_Id IN NUMBER
597 ,p_Template_Name IN VARCHAR2
598 ,x_batch_id OUT NOCOPY NUMBER
599 ,x_return_status OUT NOCOPY VARCHAR2
600 ,x_return_err OUT NOCOPY VARCHAR2
601 );
602
603 /*
604 -- ------------------- Get_Item_Number ------------------
605
606 PROCEDURE Get_Item_Number
607 (
608 p_Item_ID IN NUMBER
609 , p_Org_ID IN NUMBER
610 , x_Item_Number OUT NOCOPY VARCHAR2
611 , x_return_status OUT NOCOPY VARCHAR2
612 , x_return_err OUT NOCOPY VARCHAR2
613 );
614
615 -- ------------------- Check_Item_Number ------------------
616
617 PROCEDURE Check_Item_Number
618 (
619 p_Item_Number IN VARCHAR2
620 , p_Org_ID IN NUMBER
621 , x_return_status OUT NOCOPY VARCHAR2
622 , x_return_err OUT NOCOPY VARCHAR2
623 );
624
625 -- -------------------- Get_Item_ID --------------------
626
627 PROCEDURE Get_Item_ID
628 (
629 p_Item_Number IN VARCHAR2
630 , x_Item_ID OUT NOCOPY NUMBER
631 , x_Org_ID OUT NOCOPY NUMBER
632 , x_return_status OUT NOCOPY VARCHAR2
633 , x_return_err OUT NOCOPY VARCHAR2
634 );
635
636 */
637
638 END INV_ITEM_GRP;