[Home] [Help]
PACKAGE: APPS.INV_ITEM_GRP
Source
1 PACKAGE INV_ITEM_GRP AS
2 /* $Header: INVGITMS.pls 120.3.12010000.2 2008/11/26 22:00:07 akbharga 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
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
254 , OPERATION_SLACK_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 --
276 , PLANNED_INV_POINT_FLAG VARCHAR2(1) := g_MISS_CHAR
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
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
343 , GLOBAL_ATTRIBUTE13 VARCHAR2(150) := g_MISS_CHAR
344 , GLOBAL_ATTRIBUTE14 VARCHAR2(150) := g_MISS_CHAR
345 , GLOBAL_ATTRIBUTE15 VARCHAR2(150) := g_MISS_CHAR
346 , GLOBAL_ATTRIBUTE16 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
371 , VMI_MAXIMUM_DAYS NUMBER := g_MISS_NUM
368 , VMI_MINIMUM_UNITS NUMBER := g_MISS_NUM
369 , VMI_MINIMUM_DAYS NUMBER := g_MISS_NUM
370 , VMI_MAXIMUM_UNITS 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 , EXPIRATION_ACTION_CODE VARCHAR2(4) := g_MISS_CHAR
411 , MATURITY_DAYS NUMBER := g_MISS_NUM
412 , HOLD_DAYS NUMBER := g_MISS_NUM
413 , PROCESS_ITEM_RECORD NUMBER := g_MISS_NUM
414 /* End Bug 3713912 */
415 /* R12 Enhancement */
416 , CHARGE_PERIODICITY_CODE VARCHAR2(3) := g_MISS_CHAR
417 , REPAIR_LEADTIME NUMBER := g_MISS_NUM
418 , REPAIR_YIELD NUMBER := g_MISS_NUM
419 , PREPOSITION_POINT VARCHAR2(1) := g_MISS_CHAR
420 , REPAIR_PROGRAM NUMBER := g_MISS_NUM
421 , SUBCONTRACTING_COMPONENT NUMBER := g_MISS_NUM
422 , OUTSOURCED_ASSEMBLY NUMBER := g_MISS_NUM
423 --R12 C Attributes
424 , GDSN_OUTBOUND_ENABLED_FLAG VARCHAR2(1) := g_MISS_CHAR
425 , TRADE_ITEM_DESCRIPTOR VARCHAR2(35) := g_MISS_CHAR
426 , STYLE_ITEM_FLAG VARCHAR2(1) := g_MISS_CHAR
427 , STYLE_ITEM_ID NUMBER := g_MISS_NUM
428 );
429
430 --Added revision record to create/update API
431 TYPE Item_Revision_Rec_Type IS RECORD(
432 Transaction_Type VARCHAR2(30) := G_MISS_CHAR
433 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
434 ,Language_Code VARCHAR2(4) := G_MISS_CHAR
435 -- Revision identifier
436 ,Inventory_Item_Id NUMBER := G_MISS_NUM
437 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
438 ,Organization_Id NUMBER := G_MISS_NUM
439 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
440 ,Revision_Id NUMBER := G_MISS_NUM
441 -- Attributes
442 ,Revision_Code VARCHAR2(3) := G_MISS_CHAR
443 ,Revision_Label VARCHAR2(80) := G_MISS_CHAR
444 ,Description VARCHAR2(240) := G_MISS_CHAR
445 ,Change_Notice VARCHAR2(10) := G_MISS_CHAR
446 ,Ecn_Initiation_Date DATE := G_MISS_DATE
447 ,Implementation_Date DATE := G_MISS_DATE
448 ,Effectivity_Date DATE := G_MISS_DATE
449 ,Revised_Item_Sequence_Id NUMBER := G_MISS_NUM
450 -- Lifecycle
451 ,Lifecycle_Id NUMBER := G_MISS_NUM
452 ,Current_Phase_Id NUMBER := G_MISS_NUM
453 -- Added for 5208102
454 ,template_id MTL_ITEM_TEMPLATES_B.TEMPLATE_ID%TYPE := G_MISS_NUM
455 ,template_name MTL_ITEM_TEMPLATES_TL.TEMPLATE_NAME%TYPE := G_MISS_CHAR
456 -- Descriptive flex
457 ,Attribute_Category VARCHAR2(30) := G_MISS_CHAR
458 ,Attribute1 VARCHAR2(150) := G_MISS_CHAR
459 ,Attribute2 VARCHAR2(150) := G_MISS_CHAR
463 ,Attribute6 VARCHAR2(150) := G_MISS_CHAR
460 ,Attribute3 VARCHAR2(150) := G_MISS_CHAR
461 ,Attribute4 VARCHAR2(150) := G_MISS_CHAR
462 ,Attribute5 VARCHAR2(150) := G_MISS_CHAR
464 ,Attribute7 VARCHAR2(150) := G_MISS_CHAR
465 ,Attribute8 VARCHAR2(150) := G_MISS_CHAR
466 ,Attribute9 VARCHAR2(150) := G_MISS_CHAR
467 ,Attribute10 VARCHAR2(150) := G_MISS_CHAR
468 ,Attribute11 VARCHAR2(150) := G_MISS_CHAR
469 ,Attribute12 VARCHAR2(150) := G_MISS_CHAR
470 ,Attribute13 VARCHAR2(150) := G_MISS_CHAR
471 ,Attribute14 VARCHAR2(150) := G_MISS_CHAR
472 ,Attribute15 VARCHAR2(150) := G_MISS_CHAR
473 -- Who
474 ,Object_Version_Number NUMBER := G_MISS_NUM
475 ,Creation_Date DATE := G_MISS_DATE
476 ,Created_By NUMBER := G_MISS_NUM
477 ,Last_Update_Date DATE := G_MISS_DATE
478 ,Last_Updated_By NUMBER := G_MISS_NUM
479 ,Last_Update_Login NUMBER := G_MISS_NUM);
480
481
482 TYPE Error_rec_type IS RECORD
483 (
484 TRANSACTION_ID NUMBER
485 , UNIQUE_ID NUMBER
486 , MESSAGE_NAME VARCHAR2(30)
487 , MESSAGE_TEXT VARCHAR2(2000)
488 , TABLE_NAME VARCHAR2(30)
489 , COLUMN_NAME VARCHAR2(32)
490 , ORGANIZATION_ID NUMBER
491 );
492
493 TYPE Error_tbl_type IS TABLE OF Error_rec_type
494 INDEX BY BINARY_INTEGER;
495
496 -- ----------------------------------------------------------------
497 -- ------------ Variables representing missing values -------------
498 -- ----------------------------------------------------------------
499
500 g_Miss_Item_rec INV_ITEM_GRP.Item_rec_type;
501 g_Miss_Revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
502
503 -- --------------------------------------------------------
504 -- ------------------- Procedure specs --------------------
505 -- --------------------------------------------------------
506
507 -- -------------------- Create_Item -------------------
508 PROCEDURE Create_Item
509 (
510 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
511 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
512 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
513 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
514 , x_return_status OUT NOCOPY VARCHAR2
515 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
516 , p_Template_Id IN NUMBER DEFAULT NULL
517 , p_Template_Name IN VARCHAR2 DEFAULT NULL
518 );
519
520 PROCEDURE Create_Item
521 (
522 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
523 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
524 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
525 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
526 , x_return_status OUT NOCOPY VARCHAR2
527 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
528 , p_Template_Id IN NUMBER DEFAULT NULL
529 , p_Template_Name IN VARCHAR2 DEFAULT NULL
530 , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
531 );
532
533 -- -------------------- Update_Item -------------------
534
535 PROCEDURE Update_Item
536 (
537 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
538 , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
539 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
540 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
541 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
542 , x_return_status OUT NOCOPY VARCHAR2
543 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
544 , p_Template_Id IN NUMBER DEFAULT NULL
545 , p_Template_Name IN VARCHAR2 DEFAULT NULL
546 );
547
548 PROCEDURE Update_Item
549 (
550 p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
551 , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
552 , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
553 , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
554 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
555 , x_return_status OUT NOCOPY VARCHAR2
556 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
557 , p_Template_Id IN NUMBER DEFAULT NULL
558 , p_Template_Name IN VARCHAR2 DEFAULT NULL
559 , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
560 );
561
562 -- -------------------- Lock_Item --------------------
563
564 PROCEDURE Lock_Item
565 (
566 p_Item_ID IN NUMBER
567 , p_Org_ID IN NUMBER
568 , x_return_status OUT NOCOPY VARCHAR2
569 , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
570 );
571
572 -- -------------------- Get_Item ---------------------
573
574 PROCEDURE Get_Item
575 (
576 p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
577 , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
578 , p_Org_ID IN NUMBER
579 , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
580 , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
581 , x_return_status OUT NOCOPY VARCHAR2
582 , x_return_err OUT NOCOPY VARCHAR2
583 );
584
585 PROCEDURE Interface_Handler
586 ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
587 ,p_transaction_type IN VARCHAR2
588 ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
589 ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
590 ,p_Template_Id IN NUMBER
591 ,p_Template_Name IN VARCHAR2
592 ,x_batch_id OUT NOCOPY NUMBER
593 ,x_return_status OUT NOCOPY VARCHAR2
594 ,x_return_err OUT NOCOPY VARCHAR2
595 );
596
597 /*
598 -- ------------------- Get_Item_Number ------------------
599
600 PROCEDURE Get_Item_Number
601 (
602 p_Item_ID IN NUMBER
603 , p_Org_ID IN NUMBER
604 , x_Item_Number OUT NOCOPY VARCHAR2
605 , x_return_status OUT NOCOPY VARCHAR2
606 , x_return_err OUT NOCOPY VARCHAR2
607 );
608
609 -- ------------------- Check_Item_Number ------------------
610
611 PROCEDURE Check_Item_Number
612 (
613 p_Item_Number IN VARCHAR2
614 , p_Org_ID IN NUMBER
615 , x_return_status OUT NOCOPY VARCHAR2
616 , x_return_err OUT NOCOPY VARCHAR2
617 );
618
619 -- -------------------- Get_Item_ID --------------------
620
621 PROCEDURE Get_Item_ID
622 (
623 p_Item_Number IN VARCHAR2
624 , x_Item_ID OUT NOCOPY NUMBER
625 , x_Org_ID OUT NOCOPY NUMBER
626 , x_return_status OUT NOCOPY VARCHAR2
627 , x_return_err OUT NOCOPY VARCHAR2
628 );
629
630 */
631
632 END INV_ITEM_GRP;