1 PACKAGE EGO_ITEM_PUB AS
2 /* $Header: EGOPITMS.pls 120.21.12010000.2 2008/11/26 22:07:16 akbharga ship $ */
3 /*#
4 * This package provides functionality for maintaining items, item
5 * revisions, etc.
6 *
7 * <B>Constants:</B> All constants that are unqualified belong to
8 * the package EGO_ITEM_PUB.
9 *
10 * <B>Standard parameters:</B> Several standard parameters are
11 * used throughout the APIs below:
12 * <ul>
13 * <li>p_api_version: A decimal number indicating major and minor
14 * revisions to the API (where major revisions change the portion
15 * of the number before the decimal and minor revisions change the
16 * portion of the number after the decimal). Pass 1.0 unless
17 * otherwise indicated in the API parameter list.</li>
18 * <li>p_init_msg_list: A one-character flag indicating whether
19 * to initialize the FND_MSG_PUB package's message stack at the
20 * beginning of API processing (which removes any messages that
21 * may exist on the stack from prior processing in the same session).
22 * Valid values are FND_API.G_TRUE and FND_API.G_FALSE.</li>
23 * <li>p_commit: A one-character flag indicating whether to commit
24 * work at the end of API processing. Valid values are
25 * FND_API.G_TRUE and FND_API.G_FALSE.</li>
26 * <li>x_return_status: A one-character code indicating whether
27 * any errors occurred during processing (in which case error
28 * messages will be present on the FND_MSG_PUB package's message
29 * stack). Valid values are FND_API.G_RET_STS_SUCCESS,
30 * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.</li>
31 * <li>x_msg_count: An integer indicating the number of messages
32 * on the FND_MSG_PUB package's message stack at the end of API
33 * processing. For information about how to retrieve messages
34 * from the message stack, refer to FND_MSG_PUB documentation.</li>
35 * <li>x_msg_data: A character string containing message text;
36 * will be nonempty only when x_msg_count is exactly 1. This is
37 * a convenience feature so that callers need not interact with
38 * the message stack when it contains only one message (as is
39 * commonly the case).</li>
40 * </ul>
41 *
42 * <B>G_MISS_* values:</B> In addition, four standard default values
43 * (EGO_ITEM_PUB.G_MISS_NUM, EGO_ITEM_PUB.G_MISS_CHAR,
44 * EGO_ITEM_PUB.G_MISS_DATE, and EGO_ITEM_PUB.G_MISS_Role_Grant_Tbl)
45 * are used throughout the APIs below. These default values are used
46 * to differentiate between a value not passed at all (represented
47 * by the G_MISS_* default value) and a value explicitly passed
48 * as NULL. This convention avoids unintentional nullification
49 * of values during update processing (because G_MISS_* values
50 * are never applied to the database; only explicit NULL values are).
51 *
52 * <B>Copy/Template behavior:</B> In several of the APIs, it is
53 * possible to specify both a template and an item to copy; in such
54 * cases, copied item attributes supersede template item attributes.
55 *
56 * @rep:product EGO
57 * @rep:scope public
58 * @rep:lifecycle active
59 * @rep:displayname Catalog Item Maintenance
60 * @rep:category BUSINESS_ENTITY EGO_ITEM
61 * @rep:businessevent oracle.apps.ego.item.postAttributeChange
62 */
63
64 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOPITMS.pls';
65 G_BO_Identifier CONSTANT VARCHAR2(30) := 'ITM';
66
67 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
68 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
69 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
70 G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
71
72 G_MISS_NUM CONSTANT NUMBER := 9.99E125;
73 G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
74 G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
75 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE; -- 'F'
76 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE; -- 'T'
77
78 G_TTYPE_CREATE CONSTANT VARCHAR2(20) := 'CREATE';
79 G_TTYPE_DELETE CONSTANT VARCHAR2(20) := 'DELETE';
80 G_TTYPE_UPDATE CONSTANT VARCHAR2(20) := 'UPDATE';
81 G_TTYPE_SYNC CONSTANT VARCHAR2(20) := 'SYNC';
82 G_TTYPE_PROMOTE CONSTANT VARCHAR2(20) := 'PROMOTE';
83 G_TTYPE_DEMOTE CONSTANT VARCHAR2(20) := 'DEMOTE';
84 G_TTYPE_CHANGE_STATUS CONSTANT VARCHAR2(20) := 'CHANGE_STATUS';
85
86 G_INTF_NULL_CHAR CONSTANT VARCHAR2(1) := '!';
87 -- 5346752 writing the complete number
88 -- G_INTF_NULL_NUM CONSTANT NUMBER := 9.99E125;
89 G_INTF_NULL_NUM CONSTANT NUMBER := 999000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000;
90 G_INTF_NULL_DATE CONSTANT DATE := TO_DATE('1','j');
91
92 G_INTF_DELETE_ALL CONSTANT NUMBER := 1;
93 G_INTF_DELETE_NONE CONSTANT NUMBER := 2;
94 G_INTF_DELETE_ERROR CONSTANT NUMBER := 3;
95 G_INTF_DELETE_SUCCESS CONSTANT NUMBER := 4;
96
97 G_INSTANCE_TYPE_SET CONSTANT VARCHAR2(10) := 'SET';
98 G_INSTANCE_TYPE_INSTANCE CONSTANT VARCHAR2(10) := 'INSTANCE';
99
100 G_USER_PARTY_TYPE CONSTANT VARCHAR2(10) := 'USER';
101 G_GROUP_PARTY_TYPE CONSTANT VARCHAR2(10) := 'GROUP';
102 G_COMPANY_PARTY_TYPE CONSTANT VARCHAR2(10) := 'COMPANY';
103 G_ALL_USERS_PARTY_TYPE CONSTANT VARCHAR2(10) := 'GLOBAL';
104
105 G_CONC_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := '0';
106 G_CONC_RET_STS_WARNING CONSTANT VARCHAR2(1) := '1';
107 G_CONC_RET_STS_ERROR CONSTANT VARCHAR2(1) := '2';
108
109 -- Item record table and table (public types).
110 TYPE Item_Rec_Type IS RECORD(
111 Transaction_Type VARCHAR2(30)
112 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
113 ,Language_Code VARCHAR2(4) := G_MISS_CHAR
114 -- Copy item from
115 ,Copy_Inventory_Item_Id NUMBER := G_MISS_NUM
116 ,Template_Id NUMBER := NULL
117 ,Template_Name VARCHAR2(30) := NULL
118 -- Item identifier
119 ,Inventory_Item_Id NUMBER := G_MISS_NUM
120 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
121 ,Segment1 VARCHAR2(40) := G_MISS_CHAR
122 ,Segment2 VARCHAR2(40) := G_MISS_CHAR
123 ,Segment3 VARCHAR2(40) := G_MISS_CHAR
124 ,Segment4 VARCHAR2(40) := G_MISS_CHAR
125 ,Segment5 VARCHAR2(40) := G_MISS_CHAR
126 ,Segment6 VARCHAR2(40) := G_MISS_CHAR
127 ,Segment7 VARCHAR2(40) := G_MISS_CHAR
128 ,Segment8 VARCHAR2(40) := G_MISS_CHAR
129 ,Segment9 VARCHAR2(40) := G_MISS_CHAR
130 ,Segment10 VARCHAR2(40) := G_MISS_CHAR
131 ,Segment11 VARCHAR2(40) := G_MISS_CHAR
132 ,Segment12 VARCHAR2(40) := G_MISS_CHAR
133 ,Segment13 VARCHAR2(40) := G_MISS_CHAR
134 ,Segment14 VARCHAR2(40) := G_MISS_CHAR
135 ,Segment15 VARCHAR2(40) := G_MISS_CHAR
136 ,Segment16 VARCHAR2(40) := G_MISS_CHAR
137 ,Segment17 VARCHAR2(40) := G_MISS_CHAR
138 ,Segment18 VARCHAR2(40) := G_MISS_CHAR
139 ,Segment19 VARCHAR2(40) := G_MISS_CHAR
140 ,Segment20 VARCHAR2(40) := G_MISS_CHAR
141 ,Summary_Flag VARCHAR2(1) := G_MISS_CHAR
142 ,Enabled_Flag VARCHAR2(1) := G_MISS_CHAR
143 ,Start_Date_Active DATE := G_MISS_DATE
144 ,End_Date_Active DATE := G_MISS_DATE
145 -- Organization
146 ,Organization_Id NUMBER := G_MISS_NUM
147 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
148 -- Item catalog group (user item type)
149 ,Item_Catalog_Group_Id NUMBER := G_MISS_NUM
150 ,Catalog_Status_Flag VARCHAR2(1) := G_MISS_CHAR
151 -- Lifecycle
152 ,Lifecycle_Id NUMBER := G_MISS_NUM
153 ,Current_Phase_Id NUMBER := G_MISS_NUM
154 -- Main attributes
155 ,Description VARCHAR2(240) := G_MISS_CHAR
156 ,Long_Description VARCHAR2(4000) := G_MISS_CHAR
157 ,Primary_Uom_Code VARCHAR2(3) := G_MISS_CHAR
158 ,ALLOWED_UNITS_LOOKUP_CODE NUMBER := G_MISS_NUM
159 ,INVENTORY_ITEM_STATUS_CODE VARCHAR2(10) := G_MISS_CHAR
160 ,DUAL_UOM_CONTROL NUMBER := G_MISS_NUM
161 ,SECONDARY_UOM_CODE VARCHAR2(3) := G_MISS_CHAR
162 ,DUAL_UOM_DEVIATION_HIGH NUMBER := G_MISS_NUM
163 ,DUAL_UOM_DEVIATION_LOW NUMBER := G_MISS_NUM
164 ,ITEM_TYPE VARCHAR2(30) := G_MISS_CHAR
165 -- Inventory
166 ,INVENTORY_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
167 ,STOCK_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
168 ,MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
169 ,REVISION_QTY_CONTROL_CODE NUMBER := G_MISS_NUM
170 ,LOT_CONTROL_CODE NUMBER := G_MISS_NUM
171 ,AUTO_LOT_ALPHA_PREFIX VARCHAR2(30) := G_MISS_CHAR
172 ,START_AUTO_LOT_NUMBER VARCHAR2(30) := G_MISS_CHAR
173 ,SERIAL_NUMBER_CONTROL_CODE NUMBER := G_MISS_NUM
174 ,AUTO_SERIAL_ALPHA_PREFIX VARCHAR2(30) := G_MISS_CHAR
175 ,START_AUTO_SERIAL_NUMBER VARCHAR2(30) := G_MISS_CHAR
176 ,SHELF_LIFE_CODE NUMBER := G_MISS_NUM
177 ,SHELF_LIFE_DAYS NUMBER := G_MISS_NUM
178 ,RESTRICT_SUBINVENTORIES_CODE NUMBER := G_MISS_NUM
179 ,LOCATION_CONTROL_CODE NUMBER := G_MISS_NUM
180 ,RESTRICT_LOCATORS_CODE NUMBER := G_MISS_NUM
181 ,RESERVABLE_TYPE NUMBER := G_MISS_NUM
182 ,CYCLE_COUNT_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
183 ,NEGATIVE_MEASUREMENT_ERROR NUMBER := G_MISS_NUM
184 ,POSITIVE_MEASUREMENT_ERROR NUMBER := G_MISS_NUM
185 ,CHECK_SHORTAGES_FLAG VARCHAR2(1) := G_MISS_CHAR
186 ,LOT_STATUS_ENABLED VARCHAR2(1) := G_MISS_CHAR
187 ,DEFAULT_LOT_STATUS_ID NUMBER := G_MISS_NUM
188 ,SERIAL_STATUS_ENABLED VARCHAR2(1) := G_MISS_CHAR
189 ,DEFAULT_SERIAL_STATUS_ID NUMBER := G_MISS_NUM
190 ,LOT_SPLIT_ENABLED VARCHAR2(1) := G_MISS_CHAR
191 ,LOT_MERGE_ENABLED VARCHAR2(1) := G_MISS_CHAR
192 ,LOT_TRANSLATE_ENABLED VARCHAR2(1) := G_MISS_CHAR
193 ,LOT_SUBSTITUTION_ENABLED VARCHAR2(1) := G_MISS_CHAR
194 ,BULK_PICKED_FLAG VARCHAR2(1) := G_MISS_CHAR
195 -- Bills of Material
196 ,BOM_ITEM_TYPE NUMBER := G_MISS_NUM
197 ,BOM_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
198 ,BASE_ITEM_ID NUMBER := G_MISS_NUM
199 ,ENG_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
200 ,ENGINEERING_ITEM_ID NUMBER := G_MISS_NUM
201 ,ENGINEERING_ECN_CODE VARCHAR2(50) := G_MISS_CHAR
202 ,ENGINEERING_DATE DATE := G_MISS_DATE
203 ,EFFECTIVITY_CONTROL NUMBER := G_MISS_NUM
204 ,CONFIG_MODEL_TYPE VARCHAR2(30) := G_MISS_CHAR
205 ,Product_Family_Item_Id NUMBER := G_MISS_NUM
206 ,AUTO_CREATED_CONFIG_FLAG VARCHAR2(1) := G_MISS_CHAR--3911562
207 -- Costing
208 ,COSTING_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
209 ,INVENTORY_ASSET_FLAG VARCHAR2(1) := G_MISS_CHAR
210 ,COST_OF_SALES_ACCOUNT NUMBER := G_MISS_NUM
211 ,DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2(1) := G_MISS_CHAR
212 ,STD_LOT_SIZE NUMBER := G_MISS_NUM
213 -- Enterprise Asset Management
214 ,EAM_ITEM_TYPE NUMBER := G_MISS_NUM
215 ,EAM_ACTIVITY_TYPE_CODE VARCHAR2(30) := G_MISS_CHAR
216 ,EAM_ACTIVITY_CAUSE_CODE VARCHAR2(30) := G_MISS_CHAR
217 ,EAM_ACTIVITY_SOURCE_CODE VARCHAR2(30) := G_MISS_CHAR
218 ,EAM_ACT_SHUTDOWN_STATUS VARCHAR2(30) := G_MISS_CHAR
219 ,EAM_ACT_NOTIFICATION_FLAG VARCHAR2(1) := G_MISS_CHAR
220 -- Purchasing
221 ,PURCHASING_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
222 ,PURCHASING_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
223 ,BUYER_ID NUMBER := G_MISS_NUM
224 ,MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2(1) := G_MISS_CHAR
225 ,PURCHASING_TAX_CODE VARCHAR2(50) := G_MISS_CHAR
226 ,TAXABLE_FLAG VARCHAR2(1) := G_MISS_CHAR
227 ,RECEIVE_CLOSE_TOLERANCE NUMBER := G_MISS_NUM
228 ,ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2(1) := G_MISS_CHAR
229 ,INSPECTION_REQUIRED_FLAG VARCHAR2(1) := G_MISS_CHAR
230 ,RECEIPT_REQUIRED_FLAG VARCHAR2(1) := G_MISS_CHAR
231 ,MARKET_PRICE NUMBER := G_MISS_NUM
232 ,UN_NUMBER_ID NUMBER := G_MISS_NUM
233 ,HAZARD_CLASS_ID NUMBER := G_MISS_NUM
234 ,RFQ_REQUIRED_FLAG VARCHAR2(1) := G_MISS_CHAR
235 ,LIST_PRICE_PER_UNIT NUMBER := G_MISS_NUM
236 ,PRICE_TOLERANCE_PERCENT NUMBER := G_MISS_NUM
237 ,ASSET_CATEGORY_ID NUMBER := G_MISS_NUM
238 ,ROUNDING_FACTOR NUMBER := G_MISS_NUM
239 ,UNIT_OF_ISSUE VARCHAR2(25) := G_MISS_CHAR
240 ,OUTSIDE_OPERATION_FLAG VARCHAR2(1) := G_MISS_CHAR
241 ,OUTSIDE_OPERATION_UOM_TYPE VARCHAR2(25) := G_MISS_CHAR
242 ,INVOICE_CLOSE_TOLERANCE NUMBER := G_MISS_NUM
243 ,ENCUMBRANCE_ACCOUNT NUMBER := G_MISS_NUM
244 ,EXPENSE_ACCOUNT NUMBER := G_MISS_NUM
245 ,QTY_RCV_EXCEPTION_CODE VARCHAR2(25) := G_MISS_CHAR
246 ,RECEIVING_ROUTING_ID NUMBER := G_MISS_NUM
247 ,QTY_RCV_TOLERANCE NUMBER := G_MISS_NUM
248 ,ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2(25) := G_MISS_CHAR
249 ,ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2(1) := G_MISS_CHAR
250 ,ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2(1) := G_MISS_CHAR
251 ,ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2(1) := G_MISS_CHAR
252 ,DAYS_EARLY_RECEIPT_ALLOWED NUMBER := G_MISS_NUM
253 ,DAYS_LATE_RECEIPT_ALLOWED NUMBER := G_MISS_NUM
254 ,RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2(25) := G_MISS_CHAR
255 -- Physical
256 ,WEIGHT_UOM_CODE VARCHAR2(3) := G_MISS_CHAR
257 ,UNIT_WEIGHT NUMBER := G_MISS_NUM
258 ,VOLUME_UOM_CODE VARCHAR2(3) := G_MISS_CHAR
259 ,UNIT_VOLUME NUMBER := G_MISS_NUM
260 ,CONTAINER_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
261 ,VEHICLE_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
262 ,MAXIMUM_LOAD_WEIGHT NUMBER := G_MISS_NUM
263 ,MINIMUM_FILL_PERCENT NUMBER := G_MISS_NUM
264 ,INTERNAL_VOLUME NUMBER := G_MISS_NUM
265 ,CONTAINER_TYPE_CODE VARCHAR2(30) := G_MISS_CHAR
266 ,COLLATERAL_FLAG VARCHAR2(1) := G_MISS_CHAR
267 ,EVENT_FLAG VARCHAR2(1) := G_MISS_CHAR
268 ,EQUIPMENT_TYPE NUMBER := G_MISS_NUM
269 ,ELECTRONIC_FLAG VARCHAR2(1) := G_MISS_CHAR
270 ,DOWNLOADABLE_FLAG VARCHAR2(1) := G_MISS_CHAR
271 ,INDIVISIBLE_FLAG VARCHAR2(1) := G_MISS_CHAR
272 ,DIMENSION_UOM_CODE VARCHAR2(3) := G_MISS_CHAR
276 --Planing
273 ,UNIT_LENGTH NUMBER := G_MISS_NUM
274 ,UNIT_WIDTH NUMBER := G_MISS_NUM
275 ,UNIT_HEIGHT NUMBER := G_MISS_NUM
277 ,INVENTORY_PLANNING_CODE NUMBER := G_MISS_NUM
278 ,PLANNER_CODE VARCHAR2(10) := G_MISS_CHAR
279 ,PLANNING_MAKE_BUY_CODE NUMBER := G_MISS_NUM
280 ,MIN_MINMAX_QUANTITY NUMBER := G_MISS_NUM
281 ,MAX_MINMAX_QUANTITY NUMBER := G_MISS_NUM
282 ,SAFETY_STOCK_BUCKET_DAYS NUMBER := G_MISS_NUM
283 ,CARRYING_COST NUMBER := G_MISS_NUM
284 ,ORDER_COST NUMBER := G_MISS_NUM
285 ,MRP_SAFETY_STOCK_PERCENT NUMBER := G_MISS_NUM
286 ,MRP_SAFETY_STOCK_CODE NUMBER := G_MISS_NUM
287 ,FIXED_ORDER_QUANTITY NUMBER := G_MISS_NUM
288 ,FIXED_DAYS_SUPPLY NUMBER := G_MISS_NUM
289 ,MINIMUM_ORDER_QUANTITY NUMBER := G_MISS_NUM
290 ,MAXIMUM_ORDER_QUANTITY NUMBER := G_MISS_NUM
291 ,FIXED_LOT_MULTIPLIER NUMBER := G_MISS_NUM
292 ,SOURCE_TYPE NUMBER := G_MISS_NUM
293 ,SOURCE_ORGANIZATION_ID NUMBER := G_MISS_NUM
294 ,SOURCE_SUBINVENTORY VARCHAR2(10) := G_MISS_CHAR
295 ,MRP_PLANNING_CODE NUMBER := G_MISS_NUM
296 ,ATO_FORECAST_CONTROL NUMBER := G_MISS_NUM
297 ,PLANNING_EXCEPTION_SET VARCHAR2(10) := G_MISS_CHAR
298 ,SHRINKAGE_RATE NUMBER := G_MISS_NUM
299 ,END_ASSEMBLY_PEGGING_FLAG VARCHAR2(1) := G_MISS_CHAR
300 ,ROUNDING_CONTROL_TYPE NUMBER := G_MISS_NUM
301 ,PLANNED_INV_POINT_FLAG VARCHAR2(1) := G_MISS_CHAR
302 ,CREATE_SUPPLY_FLAG VARCHAR2(1) := G_MISS_CHAR
303 ,ACCEPTABLE_EARLY_DAYS NUMBER := G_MISS_NUM
304 ,MRP_CALCULATE_ATP_FLAG VARCHAR2(1) := G_MISS_CHAR
305 ,AUTO_REDUCE_MPS NUMBER := G_MISS_NUM
306 ,REPETITIVE_PLANNING_FLAG VARCHAR2(1) := G_MISS_CHAR
307 ,OVERRUN_PERCENTAGE NUMBER := G_MISS_NUM
308 ,ACCEPTABLE_RATE_DECREASE NUMBER := G_MISS_NUM
309 ,ACCEPTABLE_RATE_INCREASE NUMBER := G_MISS_NUM
310 ,PLANNING_TIME_FENCE_CODE NUMBER := G_MISS_NUM
311 ,PLANNING_TIME_FENCE_DAYS NUMBER := G_MISS_NUM
312 ,DEMAND_TIME_FENCE_CODE NUMBER := G_MISS_NUM
313 ,DEMAND_TIME_FENCE_DAYS NUMBER := G_MISS_NUM
314 ,RELEASE_TIME_FENCE_CODE NUMBER := G_MISS_NUM
315 ,RELEASE_TIME_FENCE_DAYS NUMBER := G_MISS_NUM
316 ,SUBSTITUTION_WINDOW_CODE NUMBER := G_MISS_NUM
317 ,SUBSTITUTION_WINDOW_DAYS NUMBER := G_MISS_NUM
318 -- Lead Times
319 ,PREPROCESSING_LEAD_TIME NUMBER := G_MISS_NUM
320 ,FULL_LEAD_TIME NUMBER := G_MISS_NUM
321 ,POSTPROCESSING_LEAD_TIME NUMBER := G_MISS_NUM
322 ,FIXED_LEAD_TIME NUMBER := G_MISS_NUM
323 ,VARIABLE_LEAD_TIME NUMBER := G_MISS_NUM
324 ,CUM_MANUFACTURING_LEAD_TIME NUMBER := G_MISS_NUM
325 ,CUMULATIVE_TOTAL_LEAD_TIME NUMBER := G_MISS_NUM
326 ,LEAD_TIME_LOT_SIZE NUMBER := G_MISS_NUM
327 -- WIP
328 ,BUILD_IN_WIP_FLAG VARCHAR2(1) := G_MISS_CHAR
329 ,WIP_SUPPLY_TYPE NUMBER := G_MISS_NUM
330 ,WIP_SUPPLY_SUBINVENTORY VARCHAR2(10) := G_MISS_CHAR
331 ,WIP_SUPPLY_LOCATOR_ID NUMBER := G_MISS_NUM
332 ,OVERCOMPLETION_TOLERANCE_TYPE NUMBER := G_MISS_NUM
333 ,OVERCOMPLETION_TOLERANCE_VALUE NUMBER := G_MISS_NUM
334 ,INVENTORY_CARRY_PENALTY NUMBER := G_MISS_NUM
335 ,OPERATION_SLACK_PENALTY NUMBER := G_MISS_NUM
336 -- Order Management
337 ,CUSTOMER_ORDER_FLAG VARCHAR2(1) := G_MISS_CHAR
338 ,CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
339 ,INTERNAL_ORDER_FLAG VARCHAR2(1) := G_MISS_CHAR
340 ,INTERNAL_ORDER_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
341 ,SHIPPABLE_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
342 ,SO_TRANSACTIONS_FLAG VARCHAR2(1) := G_MISS_CHAR
343 ,PICKING_RULE_ID NUMBER := G_MISS_NUM
344 ,PICK_COMPONENTS_FLAG VARCHAR2(1) := G_MISS_CHAR
345 ,REPLENISH_TO_ORDER_FLAG VARCHAR2(1) := G_MISS_CHAR
346 ,ATP_FLAG VARCHAR2(1) := G_MISS_CHAR
347 ,ATP_COMPONENTS_FLAG VARCHAR2(1) := G_MISS_CHAR
348 ,ATP_RULE_ID NUMBER := G_MISS_NUM
349 ,SHIP_MODEL_COMPLETE_FLAG VARCHAR2(1) := G_MISS_CHAR
350 ,DEFAULT_SHIPPING_ORG NUMBER := G_MISS_NUM
351 ,DEFAULT_SO_SOURCE_TYPE VARCHAR2(30) := G_MISS_CHAR
352 ,RETURNABLE_FLAG VARCHAR2(1) := G_MISS_CHAR
353 ,RETURN_INSPECTION_REQUIREMENT NUMBER := G_MISS_NUM
354 ,OVER_SHIPMENT_TOLERANCE NUMBER := G_MISS_NUM
355 ,UNDER_SHIPMENT_TOLERANCE NUMBER := G_MISS_NUM
359 ,VOL_DISCOUNT_EXEMPT_FLAG VARCHAR2(1) := G_MISS_CHAR
356 ,OVER_RETURN_TOLERANCE NUMBER := G_MISS_NUM
357 ,UNDER_RETURN_TOLERANCE NUMBER := G_MISS_NUM
358 ,FINANCING_ALLOWED_FLAG VARCHAR2(1) := G_MISS_CHAR
360 ,COUPON_EXEMPT_FLAG VARCHAR2(1) := G_MISS_CHAR
361 ,INVOICEABLE_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
362 ,INVOICE_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
363 ,ACCOUNTING_RULE_ID NUMBER := G_MISS_NUM
364 ,INVOICING_RULE_ID NUMBER := G_MISS_NUM
365 ,TAX_CODE VARCHAR2(50) := G_MISS_CHAR
366 ,SALES_ACCOUNT NUMBER := G_MISS_NUM
367 ,PAYMENT_TERMS_ID NUMBER := G_MISS_NUM
368 -- Service
369 ,CONTRACT_ITEM_TYPE_CODE VARCHAR2(30) := G_MISS_CHAR
370 ,SERVICE_DURATION_PERIOD_CODE VARCHAR2(10) := G_MISS_CHAR
371 ,SERVICE_DURATION NUMBER := G_MISS_NUM
372 ,COVERAGE_SCHEDULE_ID NUMBER := G_MISS_NUM
373 ,SUBSCRIPTION_DEPEND_FLAG VARCHAR2(1) := G_MISS_CHAR
374 ,SERV_IMPORTANCE_LEVEL NUMBER := G_MISS_NUM
375 ,SERV_REQ_ENABLED_CODE VARCHAR2(30) := G_MISS_CHAR
376 ,COMMS_ACTIVATION_REQD_FLAG VARCHAR2(1) := G_MISS_CHAR
377 ,SERVICEABLE_PRODUCT_FLAG VARCHAR2(1) := G_MISS_CHAR
378 ,MATERIAL_BILLABLE_FLAG VARCHAR2(30) := G_MISS_CHAR
379 ,SERV_BILLING_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
380 ,DEFECT_TRACKING_ON_FLAG VARCHAR2(1) := G_MISS_CHAR
381 ,RECOVERED_PART_DISP_CODE VARCHAR2(30) := G_MISS_CHAR
382 ,COMMS_NL_TRACKABLE_FLAG VARCHAR2(1) := G_MISS_CHAR
383 ,ASSET_CREATION_CODE VARCHAR2(30) := G_MISS_CHAR
384 ,IB_ITEM_INSTANCE_CLASS VARCHAR2(30) := G_MISS_CHAR
385 ,SERVICE_STARTING_DELAY NUMBER := G_MISS_NUM
386 -- Web Option
387 ,WEB_STATUS VARCHAR2(30) := G_MISS_CHAR
388 ,ORDERABLE_ON_WEB_FLAG VARCHAR2(1) := G_MISS_CHAR
389 ,BACK_ORDERABLE_FLAG VARCHAR2(1) := G_MISS_CHAR
390 ,MINIMUM_LICENSE_QUANTITY NUMBER := G_MISS_NUM
391 -- Start: 26 new attributes
392 ,TRACKING_QUANTITY_IND VARCHAR2(30) := G_MISS_CHAR
393 ,ONT_PRICING_QTY_SOURCE VARCHAR2(30) := G_MISS_CHAR
394 ,SECONDARY_DEFAULT_IND VARCHAR2(30) := G_MISS_CHAR
395 ,OPTION_SPECIFIC_SOURCED NUMBER := G_MISS_NUM
396 ,VMI_MINIMUM_UNITS NUMBER := G_MISS_NUM
397 ,VMI_MINIMUM_DAYS NUMBER := G_MISS_NUM
398 ,VMI_MAXIMUM_UNITS NUMBER := G_MISS_NUM
399 ,VMI_MAXIMUM_DAYS NUMBER := G_MISS_NUM
400 ,VMI_FIXED_ORDER_QUANTITY NUMBER := G_MISS_NUM
401 ,SO_AUTHORIZATION_FLAG NUMBER := G_MISS_NUM
402 ,CONSIGNED_FLAG NUMBER := G_MISS_NUM
403 ,ASN_AUTOEXPIRE_FLAG NUMBER := G_MISS_NUM
404 ,VMI_FORECAST_TYPE NUMBER := G_MISS_NUM
405 ,FORECAST_HORIZON NUMBER := G_MISS_NUM
406 ,EXCLUDE_FROM_BUDGET_FLAG NUMBER := G_MISS_NUM
407 ,DAYS_TGT_INV_SUPPLY NUMBER := G_MISS_NUM
408 ,DAYS_TGT_INV_WINDOW NUMBER := G_MISS_NUM
409 ,DAYS_MAX_INV_SUPPLY NUMBER := G_MISS_NUM
410 ,DAYS_MAX_INV_WINDOW NUMBER := G_MISS_NUM
411 ,DRP_PLANNED_FLAG NUMBER := G_MISS_NUM
412 ,CRITICAL_COMPONENT_FLAG NUMBER := G_MISS_NUM
413 ,CONTINOUS_TRANSFER NUMBER := G_MISS_NUM
414 ,CONVERGENCE NUMBER := G_MISS_NUM
415 ,DIVERGENCE NUMBER := G_MISS_NUM
416 ,CONFIG_ORGS VARCHAR2(30) := G_MISS_CHAR
417 ,CONFIG_MATCH VARCHAR2(30) := G_MISS_CHAR
418 -- End : 26 new attributes
419 -- Descriptive flex
420 ,Attribute_Category VARCHAR2(30) := G_MISS_CHAR
421 ,Attribute1 VARCHAR2(240) := G_MISS_CHAR
422 ,Attribute2 VARCHAR2(240) := G_MISS_CHAR
423 ,Attribute3 VARCHAR2(240) := G_MISS_CHAR
424 ,Attribute4 VARCHAR2(240) := G_MISS_CHAR
425 ,Attribute5 VARCHAR2(240) := G_MISS_CHAR
426 ,Attribute6 VARCHAR2(240) := G_MISS_CHAR
427 ,Attribute7 VARCHAR2(240) := G_MISS_CHAR
428 ,Attribute8 VARCHAR2(240) := G_MISS_CHAR
429 ,Attribute9 VARCHAR2(240) := G_MISS_CHAR
430 ,Attribute10 VARCHAR2(240) := G_MISS_CHAR
431 ,Attribute11 VARCHAR2(240) := G_MISS_CHAR
432 ,Attribute12 VARCHAR2(240) := G_MISS_CHAR
433 ,Attribute13 VARCHAR2(240) := G_MISS_CHAR
434 ,Attribute14 VARCHAR2(240) := G_MISS_CHAR
435 ,Attribute15 VARCHAR2(240) := G_MISS_CHAR
436 ,Attribute16 VARCHAR2(240) := G_MISS_CHAR
437 ,Attribute17 VARCHAR2(240) := G_MISS_CHAR
441 ,Attribute21 VARCHAR2(240) := G_MISS_CHAR
438 ,Attribute18 VARCHAR2(240) := G_MISS_CHAR
439 ,Attribute19 VARCHAR2(240) := G_MISS_CHAR
440 ,Attribute20 VARCHAR2(240) := G_MISS_CHAR
442 ,Attribute22 VARCHAR2(240) := G_MISS_CHAR
443 ,Attribute23 VARCHAR2(240) := G_MISS_CHAR
444 ,Attribute24 VARCHAR2(240) := G_MISS_CHAR
445 ,Attribute25 VARCHAR2(240) := G_MISS_CHAR
446 ,Attribute26 VARCHAR2(240) := G_MISS_CHAR
447 ,Attribute27 VARCHAR2(240) := G_MISS_CHAR
448 ,Attribute28 VARCHAR2(240) := G_MISS_CHAR
449 ,Attribute29 VARCHAR2(240) := G_MISS_CHAR
450 ,Attribute30 VARCHAR2(240) := G_MISS_CHAR
451 -- Global Descriptive flex
452 ,Global_Attribute_Category VARCHAR2(30) := G_MISS_CHAR
453 ,Global_Attribute1 VARCHAR2(150) := G_MISS_CHAR
454 ,Global_Attribute2 VARCHAR2(150) := G_MISS_CHAR
455 ,Global_Attribute3 VARCHAR2(150) := G_MISS_CHAR
456 ,Global_Attribute4 VARCHAR2(150) := G_MISS_CHAR
457 ,Global_Attribute5 VARCHAR2(150) := G_MISS_CHAR
458 ,Global_Attribute6 VARCHAR2(150) := G_MISS_CHAR
459 ,Global_Attribute7 VARCHAR2(150) := G_MISS_CHAR
460 ,Global_Attribute8 VARCHAR2(150) := G_MISS_CHAR
461 ,Global_Attribute9 VARCHAR2(150) := G_MISS_CHAR
462 ,Global_Attribute10 VARCHAR2(150) := G_MISS_CHAR
463 ,Global_Attribute11 VARCHAR2(150) := G_MISS_CHAR
464 ,Global_Attribute12 VARCHAR2(150) := G_MISS_CHAR
465 ,Global_Attribute13 VARCHAR2(150) := G_MISS_CHAR
466 ,Global_Attribute14 VARCHAR2(150) := G_MISS_CHAR
467 ,Global_Attribute15 VARCHAR2(150) := G_MISS_CHAR
468 ,Global_Attribute16 VARCHAR2(150) := G_MISS_CHAR
469 ,Global_Attribute17 VARCHAR2(150) := G_MISS_CHAR
470 ,Global_Attribute18 VARCHAR2(150) := G_MISS_CHAR
471 ,Global_Attribute19 VARCHAR2(150) := G_MISS_CHAR
472 ,Global_Attribute20 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 ,process_item_record NUMBER := G_MISS_NUM
481 /* R12 Enhancements */
482 ,CAS_NUMBER VARCHAR2(30) := G_MISS_CHAR
483 ,CHILD_LOT_FLAG VARCHAR2(1) := G_MISS_CHAR
484 ,CHILD_LOT_PREFIX VARCHAR2(30) := G_MISS_CHAR
485 ,CHILD_LOT_STARTING_NUMBER NUMBER := G_MISS_NUM
486 ,CHILD_LOT_VALIDATION_FLAG VARCHAR2(1) := G_MISS_CHAR
487 ,COPY_LOT_ATTRIBUTE_FLAG VARCHAR2(1) := G_MISS_CHAR
488 ,DEFAULT_GRADE VARCHAR2(150):= G_MISS_CHAR
489 ,EXPIRATION_ACTION_CODE VARCHAR2(32) := G_MISS_CHAR
490 ,EXPIRATION_ACTION_INTERVAL NUMBER := G_MISS_NUM
491 ,GRADE_CONTROL_FLAG VARCHAR2(1) := G_MISS_CHAR
492 ,HAZARDOUS_MATERIAL_FLAG VARCHAR2(1) := G_MISS_CHAR
493 ,HOLD_DAYS NUMBER := G_MISS_NUM
494 ,LOT_DIVISIBLE_FLAG VARCHAR2(1) := G_MISS_CHAR
495 ,MATURITY_DAYS NUMBER := G_MISS_NUM
496 ,PARENT_CHILD_GENERATION_FLAG VARCHAR2(1) := G_MISS_CHAR
497 ,PROCESS_COSTING_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
498 ,PROCESS_EXECUTION_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
499 ,PROCESS_QUALITY_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
500 ,PROCESS_SUPPLY_LOCATOR_ID NUMBER := G_MISS_NUM
501 ,PROCESS_SUPPLY_SUBINVENTORY VARCHAR2(10) := G_MISS_CHAR
502 ,PROCESS_YIELD_LOCATOR_ID NUMBER := G_MISS_NUM
503 ,PROCESS_YIELD_SUBINVENTORY VARCHAR2(10) := G_MISS_CHAR
504 ,RECIPE_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
505 ,RETEST_INTERVAL NUMBER := G_MISS_NUM
506 ,CHARGE_PERIODICITY_CODE VARCHAR2(3) := G_MISS_CHAR
507 ,REPAIR_LEADTIME NUMBER := G_MISS_NUM
508 ,REPAIR_YIELD NUMBER := G_MISS_NUM
509 ,PREPOSITION_POINT VARCHAR2(1) := G_MISS_CHAR
510 ,REPAIR_PROGRAM NUMBER := G_MISS_NUM
511 ,SUBCONTRACTING_COMPONENT NUMBER := G_MISS_NUM
512 ,OUTSOURCED_ASSEMBLY NUMBER := G_MISS_NUM
513 --R12 C Attributes
514 ,GDSN_OUTBOUND_ENABLED_FLAG VARCHAR2(1) := G_MISS_CHAR
515 ,TRADE_ITEM_DESCRIPTOR VARCHAR2(35) := G_MISS_CHAR
516 ,STYLE_ITEM_FLAG VARCHAR2(1) := G_MISS_CHAR
517 ,STYLE_ITEM_ID NUMBER := G_MISS_NUM);
518
519 TYPE Item_Tbl_Type IS TABLE OF Item_Rec_Type INDEX BY BINARY_INTEGER;
520
521 -- Organization record and table (public types).
522
523 TYPE Org_Rec_Type IS RECORD(
524 Return_Status VARCHAR2(1) := G_MISS_CHAR
528 TYPE Org_Tbl_Type IS TABLE OF Org_Rec_Type INDEX BY BINARY_INTEGER;
525 ,Organization_Id NUMBER := G_MISS_NUM
526 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR);
527
529
530 -- Organization Assignment record and table (public types).
531
532 TYPE Item_Org_Assignment_Rec_Type IS RECORD(
533 Return_Status VARCHAR2(1) := G_MISS_CHAR
534 ,Inventory_Item_Id NUMBER := G_MISS_NUM
535 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
536 ,Organization_Id NUMBER := G_MISS_NUM
537 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
538 ,Primary_Uom_Code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := G_MISS_CHAR);
539
540 TYPE Item_Org_Assignment_Tbl_Type IS TABLE OF Item_Org_Assignment_Rec_Type INDEX BY BINARY_INTEGER;
541
542 -- Item Revision record and table (public types).
543
544 TYPE Item_Revision_Rec_Type IS RECORD(
545 Transaction_Type VARCHAR2(30) := G_MISS_CHAR
546 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
547 ,Language_Code VARCHAR2(4) := G_MISS_CHAR
548 -- Revision identifier
549 ,Inventory_Item_Id NUMBER := G_MISS_NUM
550 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
551 ,Organization_Id NUMBER := G_MISS_NUM
552 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
553 ,Revision_Id NUMBER := G_MISS_NUM
554 -- Attributes
555 ,Revision_Code VARCHAR2(3) := G_MISS_CHAR
556 ,Revision_Label VARCHAR2(80) := G_MISS_CHAR
557 ,Description VARCHAR2(240) := G_MISS_CHAR
558 ,Change_Notice VARCHAR2(10) := G_MISS_CHAR
559 ,Ecn_Initiation_Date DATE := G_MISS_DATE
560 ,Implementation_Date DATE := G_MISS_DATE
561 ,Effectivity_Date DATE := G_MISS_DATE
562 ,Revised_Item_Sequence_Id NUMBER := G_MISS_NUM
563 -- Lifecycle
564 ,Lifecycle_Id NUMBER := G_MISS_NUM
565 ,Current_Phase_Id NUMBER := G_MISS_NUM
566 -- 5208102: Supporting template for UDA's at revisions
567 ,template_id MTL_ITEM_TEMPLATES_B.TEMPLATE_ID%TYPE := G_MISS_NUM
568 ,template_name MTL_ITEM_TEMPLATES_TL.TEMPLATE_NAME%TYPE := G_MISS_CHAR
569
570 -- Descriptive flex
571 ,Attribute_Category VARCHAR2(30) := G_MISS_CHAR
572 ,Attribute1 VARCHAR2(150) := G_MISS_CHAR
573 ,Attribute2 VARCHAR2(150) := G_MISS_CHAR
574 ,Attribute3 VARCHAR2(150) := G_MISS_CHAR
575 ,Attribute4 VARCHAR2(150) := G_MISS_CHAR
576 ,Attribute5 VARCHAR2(150) := G_MISS_CHAR
577 ,Attribute6 VARCHAR2(150) := G_MISS_CHAR
578 ,Attribute7 VARCHAR2(150) := G_MISS_CHAR
579 ,Attribute8 VARCHAR2(150) := G_MISS_CHAR
580 ,Attribute9 VARCHAR2(150) := G_MISS_CHAR
581 ,Attribute10 VARCHAR2(150) := G_MISS_CHAR
582 ,Attribute11 VARCHAR2(150) := G_MISS_CHAR
583 ,Attribute12 VARCHAR2(150) := G_MISS_CHAR
584 ,Attribute13 VARCHAR2(150) := G_MISS_CHAR
585 ,Attribute14 VARCHAR2(150) := G_MISS_CHAR
586 ,Attribute15 VARCHAR2(150) := G_MISS_CHAR
587 -- Who
588 ,Object_Version_Number NUMBER := G_MISS_NUM
589 ,Creation_Date DATE := G_MISS_DATE
590 ,Created_By NUMBER := G_MISS_NUM
591 ,Last_Update_Date DATE := G_MISS_DATE
592 ,Last_Updated_By NUMBER := G_MISS_NUM
593 ,Last_Update_Login NUMBER := G_MISS_NUM);
594
595 TYPE Item_Revision_Tbl_Type IS TABLE OF Item_Revision_Rec_Type INDEX BY BINARY_INTEGER;
596
597 -- Category Assignment record and table (public types).
598
599 TYPE Category_Assignment_Rec_Type IS RECORD(
600 Transaction_Type VARCHAR2(30) := G_MISS_CHAR
601 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
602 -- Assignment key
603 ,Inventory_Item_Id NUMBER := G_MISS_NUM
604 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
605 ,Organization_Id NUMBER := G_MISS_NUM
606 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
607 ,Category_Set_Id NUMBER := G_MISS_NUM
608 ,Category_Set_Name VARCHAR2(30) := G_MISS_CHAR
609 -- Category identifier
610 ,Category_Id NUMBER := G_MISS_NUM
611 ,Category_Code VARCHAR2(2000) := G_MISS_CHAR
612 ,Segment1 VARCHAR2(40) := G_MISS_CHAR
613 ,Segment2 VARCHAR2(40) := G_MISS_CHAR
614 ,Segment3 VARCHAR2(40) := G_MISS_CHAR
615 ,Segment4 VARCHAR2(40) := G_MISS_CHAR
616 ,Segment5 VARCHAR2(40) := G_MISS_CHAR
620 ,Segment9 VARCHAR2(40) := G_MISS_CHAR
617 ,Segment6 VARCHAR2(40) := G_MISS_CHAR
618 ,Segment7 VARCHAR2(40) := G_MISS_CHAR
619 ,Segment8 VARCHAR2(40) := G_MISS_CHAR
621 ,Segment10 VARCHAR2(40) := G_MISS_CHAR
622 ,Segment11 VARCHAR2(40) := G_MISS_CHAR
623 ,Segment12 VARCHAR2(40) := G_MISS_CHAR
624 ,Segment13 VARCHAR2(40) := G_MISS_CHAR
625 ,Segment14 VARCHAR2(40) := G_MISS_CHAR
626 ,Segment15 VARCHAR2(40) := G_MISS_CHAR
627 ,Segment16 VARCHAR2(40) := G_MISS_CHAR
628 ,Segment17 VARCHAR2(40) := G_MISS_CHAR
629 ,Segment18 VARCHAR2(40) := G_MISS_CHAR
630 ,Segment19 VARCHAR2(40) := G_MISS_CHAR
631 ,Segment20 VARCHAR2(40) := G_MISS_CHAR);
632
633 TYPE Category_Assignment_Tbl_Type IS TABLE OF Category_Assignment_Rec_Type INDEX BY BINARY_INTEGER;
634
635 -- Role Grant record and table (public types).
636
637 TYPE Role_Grant_Rec_Type IS RECORD(
638 Transaction_Type VARCHAR2(30) := G_MISS_CHAR
639 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
640 ,Role_Id NUMBER := G_MISS_NUM
641 ,Role_Name VARCHAR2(30) := G_MISS_CHAR /* FND_MENUS.MENU_NAME%TYPE */
642 ,Grantee_Party_Type VARCHAR2(8) := G_MISS_CHAR /* User, Group, All Users */
643 ,Grantee_Party_Id NUMBER := G_MISS_NUM /* HZ_PARTIES.PARTY_ID%TYPE NUMBER(15) */
644 ,Grantee_Party_Name VARCHAR2(360) := G_MISS_CHAR /* HZ_PARTIES.PARTY_NAME%TYPE */
645 ,Start_Date DATE := G_MISS_DATE
646 ,End_Date DATE := G_MISS_DATE);
647
648 TYPE Role_Grant_Tbl_Type IS TABLE OF Role_Grant_Rec_Type INDEX BY BINARY_INTEGER;
649
650
651 --Variables representing missing values
652 G_MISS_Role_Grant_Tbl EGO_Item_PUB.Role_Grant_Tbl_Type;
653
654 -- dsakalle for UCCnet Attributes
655 -- IREP comments needs to be added
656 TYPE UCCnet_Attrs_Singl_Row_Rec_Typ IS RECORD(
657 TRANSACTION_TYPE VARCHAR2(30)
658 ,RETURN_STATUS VARCHAR2(1)
659 ,LANGUAGE_CODE VARCHAR2(4)
660 ,IS_TRADE_ITEM_A_CONSUMER_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_CONSUMER_UNIT%TYPE
661 ,IS_TRADE_ITEM_INFO_PRIVATE EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_INFO_PRIVATE%TYPE
662 ,GROSS_WEIGHT NUMBER
663 ,UOM_GROSS_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_GROSS_WEIGHT%TYPE
664 ,EFFECTIVE_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_DATE%TYPE
665 ,END_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.END_AVAILABILITY_DATE_TIME%TYPE
666 ,START_AVAILABILITY_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.START_AVAILABILITY_DATE_TIME%TYPE
667 ,BRAND_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_NAME%TYPE
668 ,IS_TRADE_ITEM_A_BASE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_BASE_UNIT%TYPE
669 ,IS_TRADE_ITEM_A_VARIABLE_UNIT EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_A_VARIABLE_UNIT%TYPE
670 ,IS_PACK_MARKED_WITH_EXP_DATE EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_EXP_DATE%TYPE
671 ,IS_PACK_MARKED_WITH_GREEN_DOT EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_GREEN_DOT%TYPE
672 ,IS_PACK_MARKED_WITH_INGRED EGO_ITEM_GTN_ATTRS_VL.IS_PACK_MARKED_WITH_INGRED%TYPE
673 ,IS_PACKAGE_MARKED_AS_REC EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_AS_REC%TYPE
674 ,IS_PACKAGE_MARKED_RET EGO_ITEM_GTN_ATTRS_VL.IS_PACKAGE_MARKED_RET%TYPE
675 ,STACKING_FACTOR NUMBER
676 ,STACKING_WEIGHT_MAXIMUM NUMBER
677 ,UOM_STACKING_WEIGHT_MAXIMUM EGO_ITEM_GTN_ATTRS_VL.UOM_STACKING_WEIGHT_MAXIMUM%TYPE
678 ,ORDERING_LEAD_TIME NUMBER
679 ,UOM_ORDERING_LEAD_TIME EGO_ITEM_GTN_ATTRS_VL.UOM_ORDERING_LEAD_TIME%TYPE
680 ,ORDER_QUANTITY_MAX NUMBER
681 ,ORDER_QUANTITY_MIN NUMBER
682 ,ORDER_QUANTITY_MULTIPLE NUMBER
683 ,ORDER_SIZING_FACTOR NUMBER
684 ,EFFECTIVE_START_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_START_DATE%TYPE
685 ,CATALOG_PRICE NUMBER
686 ,EFFECTIVE_END_DATE EGO_ITEM_GTN_ATTRS_VL.EFFECTIVE_END_DATE%TYPE
687 ,SUGGESTED_RETAIL_PRICE NUMBER
688 ,MATERIAL_SAFETY_DATA_SHEET_NO EGO_ITEM_GTN_ATTRS_VL.MATERIAL_SAFETY_DATA_SHEET_NO%TYPE
689 ,HAS_BATCH_NUMBER EGO_ITEM_GTN_ATTRS_VL.HAS_BATCH_NUMBER%TYPE
690 ,IS_NON_SOLD_TRADE_RET_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NON_SOLD_TRADE_RET_FLAG%TYPE
691 ,IS_TRADE_ITEM_MAR_REC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_MAR_REC_FLAG%TYPE
692 ,DIAMETER NUMBER
693 ,UOM_DIAMETER EGO_ITEM_GTN_ATTRS_VL.UOM_DIAMETER%TYPE
694 ,DRAINED_WEIGHT NUMBER
695 ,UOM_DRAINED_WEIGHT EGO_ITEM_GTN_ATTRS_VL.UOM_DRAINED_WEIGHT%TYPE
696 ,GENERIC_INGREDIENT EGO_ITEM_GTN_ATTRS_VL.GENERIC_INGREDIENT%TYPE
697 ,GENERIC_INGREDIENT_STRGTH NUMBER
698 ,UOM_GENERIC_INGREDIENT_STRGTH EGO_ITEM_GTN_ATTRS_VL.UOM_GENERIC_INGREDIENT_STRGTH%TYPE
699 ,INGREDIENT_STRENGTH EGO_ITEM_GTN_ATTRS_VL.INGREDIENT_STRENGTH%TYPE
700 ,IS_NET_CONTENT_DEC_FLAG EGO_ITEM_GTN_ATTRS_VL.IS_NET_CONTENT_DEC_FLAG%TYPE
704 ,UOM_PEG_HORIZONTAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_HORIZONTAL%TYPE
701 ,NET_CONTENT NUMBER
702 ,UOM_NET_CONTENT EGO_ITEM_GTN_ATTRS_VL.UOM_NET_CONTENT%TYPE
703 ,PEG_HORIZONTAL NUMBER
705 ,PEG_VERTICAL NUMBER
706 ,UOM_PEG_VERTICAL EGO_ITEM_GTN_ATTRS_VL.UOM_PEG_VERTICAL%TYPE
707 ,CONSUMER_AVAIL_DATE_TIME EGO_ITEM_GTN_ATTRS_VL.CONSUMER_AVAIL_DATE_TIME%TYPE
708 ,DEL_TO_DIST_CNTR_TEMP_MAX NUMBER
709 ,UOM_DEL_TO_DIST_CNTR_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MAX%TYPE
710 ,DEL_TO_DIST_CNTR_TEMP_MIN NUMBER
711 ,UOM_DEL_TO_DIST_CNTR_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DEL_TO_DIST_CNTR_TEMP_MIN%TYPE
712 ,DELIVERY_TO_MRKT_TEMP_MAX NUMBER
713 ,UOM_DELIVERY_TO_MRKT_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MAX%TYPE
714 ,DELIVERY_TO_MRKT_TEMP_MIN NUMBER
715 ,UOM_DELIVERY_TO_MRKT_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_DELIVERY_TO_MRKT_TEMP_MIN%TYPE
716 ,SUB_BRAND EGO_ITEM_GTN_ATTRS_VL.SUB_BRAND%TYPE
717 -- ,TRADE_ITEM_DESCRIPTOR EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_DESCRIPTOR%TYPE
718 ,EANUCC_CODE EGO_ITEM_GTN_ATTRS_VL.EANUCC_CODE%TYPE
719 ,EANUCC_TYPE EGO_ITEM_GTN_ATTRS_VL.EANUCC_TYPE%TYPE
720 ,RETAIL_PRICE_ON_TRADE_ITEM NUMBER
721 ,QUANTITY_OF_COMP_LAY_ITEM NUMBER
722 ,QUANITY_OF_ITEM_IN_LAYER NUMBER
723 ,QUANTITY_OF_ITEM_INNER_PACK NUMBER
724 ,QUANTITY_OF_INNER_PACK NUMBER
725 ,BRAND_OWNER_GLN EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_GLN%TYPE
726 ,BRAND_OWNER_NAME EGO_ITEM_GTN_ATTRS_VL.BRAND_OWNER_NAME%TYPE
727 ,STORAGE_HANDLING_TEMP_MAX NUMBER
728 ,UOM_STORAGE_HANDLING_TEMP_MAX EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MAX%TYPE
729 ,STORAGE_HANDLING_TEMP_MIN NUMBER
730 ,UOM_STORAGE_HANDLING_TEMP_MIN EGO_ITEM_GTN_ATTRS_VL.UOM_STORAGE_HANDLING_TEMP_MIN%TYPE
731 ,TRADE_ITEM_COUPON NUMBER
732 ,DEGREE_OF_ORIGINAL_WORT EGO_ITEM_GTN_ATTRS_VL.DEGREE_OF_ORIGINAL_WORT%TYPE
733 ,FAT_PERCENT_IN_DRY_MATTER NUMBER
734 ,PERCENT_OF_ALCOHOL_BY_VOL NUMBER
735 ,ISBN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISBN_NUMBER%TYPE
736 ,ISSN_NUMBER EGO_ITEM_GTN_ATTRS_VL.ISSN_NUMBER%TYPE
737 ,IS_INGREDIENT_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_INGREDIENT_IRRADIATED%TYPE
738 ,IS_RAW_MATERIAL_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_RAW_MATERIAL_IRRADIATED%TYPE
739 ,IS_TRADE_ITEM_GENETICALLY_MOD EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_GENETICALLY_MOD%TYPE
740 ,IS_TRADE_ITEM_IRRADIATED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_IRRADIATED%TYPE
741 ,SECURITY_TAG_LOCATION EGO_ITEM_GTN_ATTRS_VL.SECURITY_TAG_LOCATION%TYPE
742 ,URL_FOR_WARRANTY EGO_ITEM_GTN_ATTRS_VL.URL_FOR_WARRANTY%TYPE
743 ,NESTING_INCREMENT NUMBER
744 ,UOM_NESTING_INCREMENT EGO_ITEM_GTN_ATTRS_VL.UOM_NESTING_INCREMENT%TYPE
745 ,IS_TRADE_ITEM_RECALLED EGO_ITEM_GTN_ATTRS_VL.IS_TRADE_ITEM_RECALLED%TYPE
746 ,MODEL_NUMBER EGO_ITEM_GTN_ATTRS_VL.MODEL_NUMBER%TYPE
747 ,PIECES_PER_TRADE_ITEM NUMBER
748 ,UOM_PIECES_PER_TRADE_ITEM EGO_ITEM_GTN_ATTRS_VL.UOM_PIECES_PER_TRADE_ITEM%TYPE
749 ,DEPT_OF_TRNSPRT_DANG_GOODS_NUM EGO_ITEM_GTN_ATTRS_VL.DEPT_OF_TRNSPRT_DANG_GOODS_NUM%TYPE
750 ,RETURN_GOODS_POLICY EGO_ITEM_GTN_ATTRS_VL.RETURN_GOODS_POLICY%TYPE
751 ,IS_OUT_OF_BOX_PROVIDED EGO_ITEM_GTN_ATTRS_VL.IS_OUT_OF_BOX_PROVIDED%TYPE
752 ,INVOICE_NAME EGO_ITEM_GTN_ATTRS_VL.INVOICE_NAME%TYPE
753 ,DESCRIPTIVE_SIZE EGO_ITEM_GTN_ATTRS_VL.DESCRIPTIVE_SIZE%TYPE
754 ,FUNCTIONAL_NAME EGO_ITEM_GTN_ATTRS_VL.FUNCTIONAL_NAME%TYPE
755 ,TRADE_ITEM_FORM_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FORM_DESCRIPTION%TYPE
756 ,WARRANTY_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.WARRANTY_DESCRIPTION%TYPE
757 ,TRADE_ITEM_FINISH_DESCRIPTION EGO_ITEM_GTN_ATTRS_VL.TRADE_ITEM_FINISH_DESCRIPTION%TYPE
758 ,DESCRIPTION_SHORT EGO_ITEM_GTN_ATTRS_VL.DESCRIPTION_SHORT%TYPE
759 ,IS_BARCODE_SYMBOLOGY_DERIVABLE EGO_ITEM_GTN_ATTRS_VL.IS_BARCODE_SYMBOLOGY_DERIVABLE%TYPE
760 );
761
762 TYPE UCCnet_Attrs_Multi_Row_Rec_Typ IS RECORD(
763 EXTENSION_ID NUMBER
764 ,TRANSACTION_TYPE VARCHAR2(30)
765 ,RETURN_STATUS VARCHAR2(1)
766 ,LANGUAGE_CODE VARCHAR2(4)
770 ,COLOR_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_LIST_AGENCY%TYPE
767 ,MANUFACTURER_GLN EGO_ITM_GTN_MUL_ATTRS_VL.MANUFACTURER_GLN%TYPE
768 ,MANUFACTURER_ID NUMBER
769 ,BAR_CODE_TYPE EGO_ITM_GTN_MUL_ATTRS_VL.BAR_CODE_TYPE%TYPE
771 ,COLOR_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.COLOR_CODE_VALUE%TYPE
772 ,CLASS_OF_DANGEROUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.CLASS_OF_DANGEROUS_CODE%TYPE
773 ,DANGEROUS_GOODS_MARGIN_NUMBER EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_MARGIN_NUMBER%TYPE
774 ,DANGEROUS_GOODS_HAZARDOUS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_HAZARDOUS_CODE%TYPE
775 ,DANGEROUS_GOODS_PACK_GROUP EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_PACK_GROUP%TYPE
776 ,DANGEROUS_GOODS_REG_CODE EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_REG_CODE%TYPE
777 ,DANGEROUS_GOODS_SHIPPING_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_SHIPPING_NAME%TYPE
778 ,UNITED_NATIONS_DANG_GOODS_NO NUMBER
779 ,FLASH_POINT_TEMP NUMBER
780 ,UOM_FLASH_POINT_TEMP EGO_ITM_GTN_MUL_ATTRS_VL.UOM_FLASH_POINT_TEMP%TYPE
781 ,COUNTRY_OF_ORIGIN EGO_ITM_GTN_MUL_ATTRS_VL.COUNTRY_OF_ORIGIN%TYPE
782 ,HARMONIZED_TARIFF_SYS_ID_CODE NUMBER
783 ,SIZE_CODE_LIST_AGENCY EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_LIST_AGENCY%TYPE
784 ,SIZE_CODE_VALUE EGO_ITM_GTN_MUL_ATTRS_VL.SIZE_CODE_VALUE%TYPE
785 ,HANDLING_INSTRUCTIONS_CODE EGO_ITM_GTN_MUL_ATTRS_VL.HANDLING_INSTRUCTIONS_CODE%TYPE
786 ,DANGEROUS_GOODS_TECHNICAL_NAME EGO_ITM_GTN_MUL_ATTRS_VL.DANGEROUS_GOODS_TECHNICAL_NAME%TYPE
787 ,DELIVERY_METHOD_INDICATOR EGO_ITM_GTN_MUL_ATTRS_VL.DELIVERY_METHOD_INDICATOR%TYPE
788 );
789
790 TYPE UCCnet_Attrs_Multi_Row_Tbl_Typ IS TABLE OF UCCnet_Attrs_Multi_Row_Rec_Typ INDEX BY BINARY_INTEGER;
791
792 TYPE UCCnet_Extra_Attrs_Rec_Typ IS RECORD(
793 UNIT_WEIGHT NUMBER
794 );
795
796 -- IREP comments needs to be added
797 -- dsakalle for UCCnet Attributes -- end
798
799 /*#
800 * Use this API to create or update multiple items at once. The
801 * table type passed in p_role_grant_tbl is as follows:
802 *<code><pre>
803 TYPE Role_Grant_Tbl_Type IS TABLE OF Role_Grant_Rec_Type
804 INDEX BY BINARY_INTEGER;
805
806 TYPE Role_Grant_Rec_Type IS RECORD
807 (
808 Transaction_Type VARCHAR2(30) := G_MISS_CHAR
809 ,Return_Status VARCHAR2(1) := G_MISS_CHAR
810 ,Role_Id NUMBER := G_MISS_NUM
811 ,Role_Name VARCHAR2(30) := G_MISS_CHAR
812 ,Grantee_Party_Type VARCHAR2(8) := G_MISS_CHAR
813 ,Grantee_Party_Id NUMBER := G_MISS_NUM
814 ,Grantee_Party_Name VARCHAR2(360) := G_MISS_CHAR
815 ,Start_Date DATE := G_MISS_DATE
816 ,End_Date DATE := G_MISS_DATE
817 );
818 *</pre></code>
819 * @param p_api_version A decimal number indicating revisions to
820 * the API. Pass the number indicated in the package description
821 * above.
822 * @param p_init_msg_list A flag indicating whether to initialize
823 * the FND_MSG_PUB package's message stack. Refer to the package
824 * description above for more information about this parameter and
828 * for more information about this parameter and a list of valid
825 * a list of valid values.
826 * @param p_commit A flag indicating whether to commit work at the
827 * end of API processing. Refer to the package description above
829 * values.
830 * @param p_item_tbl Each record in this PL/SQL table contains 320
831 * fields representing all of the attribute values for one item
832 * to be created or updated and various record-specific settings
833 * (e.g., language, DML operation to perform for the record, etc.).
834 * For more information about the record fields, refer to the parameter
835 * documentation for the full parameter-list version of Process Item.
836 * @param x_item_tbl Contains records corresponding to those passed
837 * in p_item_tbl, except that the only populated fields for each
838 * record are Inventory_Item_Id, Organization_Id, Description,
839 * Long_Description, Item_Catalog_Group_Id, Primary_Uom_Code,
840 * Allowed_Units_Lookup_Code, Inventory_Item_Status_Code,
841 * Bom_Enabled_Flag, and Eng_Item_Flag.
842 * @param p_role_grant_tbl Each record in this PL/SQL table
843 * corresponds to one role grant to be created or updated; refer
844 * to API description for the record type declaration.
845 * @param x_return_status A code indicating whether any errors
846 * occurred during processing. Refer to the package description
847 * above for more information about this parameter and a list of
848 * valid values.
849 * @param x_msg_count An integer indicating the number of messages
850 * on the FND_MSG_PUB package's message stack at the end of API
851 * processing. Refer to the package description above for more
852 * information about this parameter.
853 * @rep:scope public
854 * @rep:lifecycle active
855 * @rep:displayname Process Items
856 */
857 PROCEDURE Process_Items(
858 p_api_version IN NUMBER
859 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
860 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
861 ,p_Item_Tbl IN EGO_Item_PUB.Item_Tbl_Type
862 ,x_Item_Tbl OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
863 ,p_Role_Grant_Tbl IN EGO_Item_PUB.Role_Grant_Tbl_Type DEFAULT EGO_Item_PUB.G_MISS_Role_Grant_Tbl
864 ,x_return_status OUT NOCOPY VARCHAR2
865 ,x_msg_count OUT NOCOPY NUMBER);
866
867
868 /*#
869 * A convenience wrapper to Process_Item: use this API to create
870 * or update an item by passing only the most important and/or
871 * commonly used item attributes. This version provides information
872 * about parameters unique to this wrapper; for more information about
873 * parameters and functionality, refer to the full parameter-list
874 * version of Process Item.
875 * @param p_New_Item_Number To update an existing item's Item
876 * Number (i.e., the concatenated segments), pass this value
877 * instead of passing each updated segment value individually.
878 * @param p_New_segment1 As an alternative to passing
879 * p_new_item_number above, you can pass each updated segment
880 * value (1 through 20) as its own parameter.
881 * @rep:comment ------------ INTERNAL COMMENTS -----------------
882 * there several params in this signature that aren't in the
883 longer signature and that aren't yet explained:
884 p_Organization_Code
885 p_Item_Catalog_Group_Id
886 p_Role_Id
887 p_Role_Name
888 p_Grantee_Party_Type
889 p_Grantee_Party_Id
890 p_Grantee_Party_Name
891 p_Grant_Start_Date
892 p_Grant_End_Date
893 We can always explain these if feedback indicates that we should
894 * @rep:comment ---------- END INTERNAL COMMENTS ---------------
895 * @rep:scope public
896 * @rep:lifecycle active
897 * @rep:displayname Process Item (convenience wrapper version)
898 */
899 PROCEDURE Process_Item(
900 p_api_version IN NUMBER
901 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
902 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
903 -- Transaction data
904 ,p_Transaction_Type IN VARCHAR2 DEFAULT G_MISS_CHAR
905 ,p_Language_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
906 -- Copy item from
907 ,p_Template_Id IN NUMBER DEFAULT NULL
908 ,p_Template_Name IN VARCHAR2 DEFAULT NULL
909 -- Item identifier
910 ,p_Inventory_Item_Id IN NUMBER DEFAULT G_MISS_NUM
911 ,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
912 ,p_Segment1 IN VARCHAR2 DEFAULT G_MISS_CHAR
913 ,p_Segment2 IN VARCHAR2 DEFAULT G_MISS_CHAR
914 ,p_Segment3 IN VARCHAR2 DEFAULT G_MISS_CHAR
915 ,p_Segment4 IN VARCHAR2 DEFAULT G_MISS_CHAR
916 ,p_Segment5 IN VARCHAR2 DEFAULT G_MISS_CHAR
917 ,p_Segment6 IN VARCHAR2 DEFAULT G_MISS_CHAR
918 ,p_Segment7 IN VARCHAR2 DEFAULT G_MISS_CHAR
919 ,p_Segment8 IN VARCHAR2 DEFAULT G_MISS_CHAR
920 ,p_Segment9 IN VARCHAR2 DEFAULT G_MISS_CHAR
921 ,p_Segment10 IN VARCHAR2 DEFAULT G_MISS_CHAR
922 ,p_Segment11 IN VARCHAR2 DEFAULT G_MISS_CHAR
923 ,p_Segment12 IN VARCHAR2 DEFAULT G_MISS_CHAR
924 ,p_Segment13 IN VARCHAR2 DEFAULT G_MISS_CHAR
925 ,p_Segment14 IN VARCHAR2 DEFAULT G_MISS_CHAR
926 ,p_Segment15 IN VARCHAR2 DEFAULT G_MISS_CHAR
930 ,p_Segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
927 ,p_Segment16 IN VARCHAR2 DEFAULT G_MISS_CHAR
928 ,p_Segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
929 ,p_Segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
931 ,p_Segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
932 ,p_Object_Version_Number IN NUMBER DEFAULT G_MISS_NUM
933 -- New Item segments Bug:2806390
934 ,p_New_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
935 ,p_New_Segment1 IN VARCHAR2 DEFAULT G_MISS_CHAR
936 ,p_New_Segment2 IN VARCHAR2 DEFAULT G_MISS_CHAR
937 ,p_New_Segment3 IN VARCHAR2 DEFAULT G_MISS_CHAR
938 ,p_New_Segment4 IN VARCHAR2 DEFAULT G_MISS_CHAR
939 ,p_New_Segment5 IN VARCHAR2 DEFAULT G_MISS_CHAR
940 ,p_New_Segment6 IN VARCHAR2 DEFAULT G_MISS_CHAR
941 ,p_New_Segment7 IN VARCHAR2 DEFAULT G_MISS_CHAR
942 ,p_New_Segment8 IN VARCHAR2 DEFAULT G_MISS_CHAR
943 ,p_New_Segment9 IN VARCHAR2 DEFAULT G_MISS_CHAR
944 ,p_New_Segment10 IN VARCHAR2 DEFAULT G_MISS_CHAR
945 ,p_New_Segment11 IN VARCHAR2 DEFAULT G_MISS_CHAR
946 ,p_New_Segment12 IN VARCHAR2 DEFAULT G_MISS_CHAR
947 ,p_New_Segment13 IN VARCHAR2 DEFAULT G_MISS_CHAR
948 ,p_New_Segment14 IN VARCHAR2 DEFAULT G_MISS_CHAR
949 ,p_New_Segment15 IN VARCHAR2 DEFAULT G_MISS_CHAR
950 ,p_New_Segment16 IN VARCHAR2 DEFAULT G_MISS_CHAR
951 ,p_New_Segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
952 ,p_New_Segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
953 ,p_New_Segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
954 ,p_New_Segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
955 -- Organization
956 ,p_Organization_Id IN NUMBER DEFAULT G_MISS_NUM
957 ,p_Organization_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
958 -- Item catalog group
959 ,p_Item_Catalog_Group_Id IN NUMBER DEFAULT G_MISS_NUM
960 ,p_Catalog_Status_Flag IN VARCHAR2 DEFAULT G_MISS_CHAR
961 -- Lifecycle
962 ,p_Lifecycle_Id IN NUMBER DEFAULT G_MISS_NUM
963 ,p_Current_Phase_Id IN NUMBER DEFAULT G_MISS_NUM
964 -- Main attributes
965 ,p_Description IN VARCHAR2 DEFAULT G_MISS_CHAR
966 ,p_Long_Description IN VARCHAR2 DEFAULT G_MISS_CHAR
967 ,p_Primary_Uom_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
968 ,p_Inventory_Item_Status_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
969 -- BOM/Eng
970 ,p_Bom_Enabled_Flag IN VARCHAR2 DEFAULT G_MISS_CHAR
971 ,p_Eng_Item_Flag IN VARCHAR2 DEFAULT G_MISS_CHAR
972 -- Role Grant
973 ,p_Role_Id IN NUMBER DEFAULT G_MISS_NUM
974 ,p_Role_Name IN VARCHAR2 DEFAULT G_MISS_CHAR
975 ,p_Grantee_Party_Type IN VARCHAR2 DEFAULT G_MISS_CHAR
976 ,p_Grantee_Party_Id IN NUMBER DEFAULT G_MISS_NUM
977 ,p_Grantee_Party_Name IN VARCHAR2 DEFAULT G_MISS_CHAR
978 ,p_Grant_Start_Date IN DATE DEFAULT G_MISS_DATE
979 ,p_Grant_End_Date IN DATE DEFAULT G_MISS_DATE
980 -- Returned item ID
981 ,x_Inventory_Item_Id OUT NOCOPY NUMBER
982 ,x_Organization_Id OUT NOCOPY NUMBER
983 ,x_return_status OUT NOCOPY VARCHAR2
984 ,x_msg_count OUT NOCOPY NUMBER);
985
986 /*#
987 * The full parameter-list version of Process_Item: use this API
988 * to create or update one item if you want to specify item attribute
989 * values that aren't exposed in the wrapper version of Process_Item,
990 * or to create or update an item revision.
991 * @param p_api_version A decimal number indicating revisions to
992 * the API. Pass the number indicated in the package description
993 * above.
994 * @param p_init_msg_list A flag indicating whether to initialize
995 * the FND_MSG_PUB package's message stack. Refer to the package
996 * description above for more information about this parameter and
997 * a list of valid values.
998 * @param p_commit A flag indicating whether to commit work at the
999 * end of API processing. Refer to the package description above
1000 * for more information about this parameter and a list of valid
1001 * values.
1002 * @param p_transaction_type Valid values are G_TTYPE_CREATE and
1003 * G_TTYPE_UPDATE.
1004 * @param p_Template_Id Either p_template_id or p_template_name may
1005 * be passed if applying a template.
1006 * @param p_inventory_item_id <B>DEPRECATED.</B> This parameter
1007 * should not be used.
1008 * @param p_organization_id Item's Organization ID.
1009 * @param p_master_organization_id Item's Master Organization ID.
1010 * @param p_description Main Attribute Group Attribute Group - Description.
1011 * @param x_Inventory_Item_Id Item ID of successfully created or
1012 * updated Item.
1013 * @param x_Organization_Id Organization ID of successfully created
1014 * or updated item.
1015 * @param p_apply_template Valid values are 'BASE_TEMPLATE', 'USER_TEMPLATE',
1016 * and 'ALL'. The values' meanings are:
1017 *<pre>
1018 BASE_TEMPLATE - Apply the template's item base attributes but not its user-defined attributes.
1022 * @param p_object_version_number <B>DEPRECATED.</B> This parameter should not be used.
1019 USER_TEMPLATE - Apply the template's user-defined attributes but not its item base attributes.
1020 ALL - Apply all of the template's attributes, both item base and user-defined.
1021 *</pre>
1023 * @param p_long_description Main Attribute Group - Long Description.
1024 * @param p_primary_uom_code Main Attribute Group - Primary Unit of Measure. E.g., 'EA' for 'Each' or 'FT' for 'Foot'.
1025 * @param p_primary_unit_of_measure <B>DEPRECATED.</B> This parameter should not be used.
1026 * @param p_item_type Main Attribute Group - User Item Type.
1027 * @param p_inventory_item_status_code Main Attribute Group - Item Status.
1028 * @param p_allowed_units_lookup_code Main Attribute Group - Conversions. Valid values are 1, 2, and 3.
1029 * @param p_item_catalog_group_id Item's Catalog group ID.
1030 * @param p_catalog_status_flag <B>DEPRECATED.</B> This parameter should not be used.
1031 * @param p_inventory_item_flag Inventory Attribute Group - Inventory Item. Valid values are 'Y' and 'N'.
1032 * @param p_stock_enabled_flag Inventory Attribute Group - Stockable. Valid values are 'Y' and 'N'.
1033 * @param p_mtl_transactions_enabled_fl Inventory Attribute Group - Transactable. Valid values are 'Y' and 'N'.
1034 * @param p_check_shortages_flag Inventory Attribute Group - Check Material Shortage. Valid values are 'Y' and 'N'.
1035 * @param p_revision_qty_control_code Inventory Attribute Group - Revision Control. Valid values are 1 and 2.
1036 * @param p_reservable_type Inventory Attribute Group - Inventory - Reservable. Valid values are 1 and 2.
1037 * @param p_shelf_life_code Inventory Attribute Group - Lot Expiration Control. Valid values are 1, 2, and 4.
1038 * @param p_shelf_life_days Inventory Attribute Group - Lot Expiration Shelf Life Days.
1039 * @param p_cycle_count_enabled_flag Inventory Attribute Group - Cycle Count Enabled - Cycle Count Enabled. Valid values are 'Y' and 'N'.
1040 * @param p_negative_measurement_error Inventory Attribute Group - Negative Measurement Error.
1041 * @param p_positive_measurement_error Inventory Attribute Group - Positive Measurement Error.
1042 * @param p_lot_control_code Inventory Attribute Group - Lot Control. Valid values are 1 and 2.
1043 * @param p_auto_lot_alpha_prefix Inventory Attribute Group - Lot Starting Prefix.
1044 * @param p_start_auto_lot_number Inventory Attribute Group - Lot Starting Number.
1045 * @param p_serial_number_control_code Inventory Attribute Group - Serial Generation. Valid values are 1, 2, 5, and 6.
1046 * @param p_auto_serial_alpha_prefix Inventory Attribute Group - Serial Starting Prefix.
1047 * @param p_start_auto_serial_number Inventory Attribute Group - Serial Starting Number.
1048 * @param p_location_control_code Inventory Attribute Group - Inventory - Locator Control. Valid values are 1, 2, and 3.
1049 * @param p_restrict_subinventories_cod Inventory Attribute Group - Inventory - Restrict Subinventories. Valid values are 1 and 2.
1050 * @param p_restrict_locators_code Inventory Attribute Group - Inventory - Restrict Locators. Valid values are 1 and 2.
1051 * @param p_bom_enabled_flag Bills of Material Attribute Group - BOM Allowed. Valid values are 'Y' and 'N'.
1052 * @param p_bom_item_type Bills of Material Attribute Group - BOM Item Type. Valid values are 1, 2, 3, 4, and 5.
1053 * @param p_base_item_id Bills of Material Attribute Group - Base Model.
1054 * @param p_effectivity_control Bills of Material Attribute Group - Effectivity Control. Valid values are 1 and 2.
1055 * @param p_eng_item_flag Bills of Material Attribute Group - Engineering Item. Valid values are 'Y' and 'N'.
1056 * @param p_engineering_ecn_code <B>DEPRECATED.</B> This parameter should not be used.
1057 * @param p_engineering_item_id <B>DEPRECATED.</B> This parameter should not be used.
1058 * @param p_engineering_date <B>DEPRECATED.</B> This parameter should not be used.
1059 * @param p_product_family_item_id <B>DEPRECATED.</B> This parameter should not be used.
1060 * @param p_auto_created_config_flag Bills of Material Attribute Group - Autocreated Configuration. Valid values are 'Y' and 'N'.
1061 * @param p_model_config_clause_name <B>DEPRECATED.</B> This parameter should not be used.
1062 * @param p_new_revision_code <B>DEPRECATED.</B> This parameter should not be used.
1063 * @param p_costing_enabled_flag Costing Attribute Group - Costing Enabled. Valid values are 'Y' and 'N'.
1064 * @param p_inventory_asset_flag Costing Attribute Group - Inventory Asset Value. Valid values are 'Y' and 'N'.
1065 * @param p_default_include_in_rollup_f Costing Attribute Group - Include In Rollup. Valid values are 'Y' and 'N'.
1066 * @param p_cost_of_sales_account Costing Attribute Group - Cost of Goods Sold Account.
1067 * @param p_std_lot_size Costing Attribute Group - Standard Lot Size.
1068 * @param p_purchasing_item_flag Purchasing Attribute Group - Purchased. Valid values are 'Y' and 'N'.
1069 * @param p_purchasing_enabled_flag Purchasing Attribute Group - Purchasable. Valid values are 'Y' and 'N'.
1070 * @param p_must_use_approved_vendor_fl Purchasing Attribute Group - Use Approved Supplier. Valid values are 'Y' and 'N'.
1071 * @param p_allow_item_desc_update_flag Purchasing Attribute Group - Allow Description Update. Valid values are 'Y' and 'N'.
1072 * @param p_rfq_required_flag Purchasing Attribute Group - RFQ Required. Valid values are 'Y' and 'N'.
1073 * @param p_outside_operation_flag Purchasing Attribute Group - Outside Processing Item. Valid values are 'Y' and 'N'.
1074 * @param p_outside_operation_uom_type Purchasing Attribute Group - Outside Processing Item - Unit Type. Valid values are ASSEMBLY and SOURCE.
1075 * @param p_taxable_flag Purchasing Attribute Group - Taxable. Valid values are 'Y' and 'N'.
1076 * @param p_purchasing_tax_code Purchasing Attribute Group - Tax Code.
1077 * @param p_receipt_required_flag Purchasing Attribute Group - Receipt Required. Valid values are 'Y' and 'N'.
1078 * @param p_inspection_required_flag Purchasing Attribute Group - Inspection Required. Valid values are 'Y' and 'N'.
1079 * @param p_buyer_id Purchasing Attribute Group - Default Buyer.
1083 * @param p_un_number_id Purchasing Attribute Group - UN Number.
1080 * @param p_unit_of_issue Purchasing Attribute Group - Unit of Issue.
1081 * @param p_receive_close_tolerance Purchasing Attribute Group - Receipt Close Tolerance Percentage.
1082 * @param p_invoice_close_tolerance Purchasing Attribute Group - Purchasing - Invoice Close Tolerance Percentage.
1084 * @param p_hazard_class_id Purchasing Attribute Group - Hazard Class.
1085 * @param p_list_price_per_unit Purchasing Attribute Group - List Price.
1086 * @param p_market_price Purchasing Attribute Group - Market Price.
1087 * @param p_price_tolerance_percent Purchasing Attribute Group - Price Tolerance Percentage.
1088 * @param p_rounding_factor Purchasing Attribute Group - Rounding Factor.
1089 * @param p_encumbrance_account Purchasing Attribute Group - Purchasing - Encumbrance Account.
1090 * @param p_expense_account Purchasing Attribute Group - Purchasing - Expense Account.
1091 * @param p_expense_billable_flag <B>DEPRECATED.</B> This parameter should not be used.
1092 * @param p_asset_category_id Purchasing Attribute Group - Asset Category.
1093 * @param p_receipt_days_exception_code Receiving Attribute Group - Receipt Date Controls - Action. Valid values are 'NONE', 'REJECT', and 'WARNING'.
1094 * @param p_days_early_receipt_allowed Receiving Attribute Group - Receipt Date Controls - Days Early.
1095 * @param p_days_late_receipt_allowed Receiving Attribute Group - Receipt Date Controls - Days Late.
1096 * @param p_allow_substitute_receipts_f Receiving Attribute Group - Allow Substitute Receipts. Valid values are 'Y' and 'N'.
1097 * @param p_allow_unordered_receipts_fl Receiving Attribute Group - Allow Unordered Receipts. Valid values are 'Y' and 'N'.
1098 * @param p_allow_express_delivery_flag Receiving Attribute Group - Allow Express Transactions . Valid values are 'Y' and 'N'.
1099 * @param p_qty_rcv_exception_code Receiving Attribute Group - Overreceipt Quantity Control - Action. Valid values are 'NONE', 'REJECT', and 'WARNING'.
1100 * @param p_qty_rcv_tolerance Receiving Attribute Group - Overreceipt Quantity Control - Tolerance Percentage.
1101 * @param p_receiving_routing_id Receiving Attribute Group - Receipt Routing. Valid values are 1, 2, and 3.
1102 * @param p_enforce_ship_to_location_c Receiving Attribute Group - Enforce Ship-To. Valid values are 'NONE', 'REJECT', and 'WARNING'.
1103 * @param p_weight_uom_code Physical Attributes Attribute Group - Unit of Measure.
1104 * @param p_unit_weight Physical Attributes Attribute Group - Unit Weight.
1105 * @param p_volume_uom_code Physical Attributes Attribute Group - Unit of Measure.
1106 * @param p_unit_volume Physical Attributes Attribute Group - Unit Volume.
1107 * @param p_container_item_flag Physical Attributes Attribute Group - Container. Valid values are 'NONE', 'REJECT', and 'WARNING'.
1108 * @param p_vehicle_item_flag Physical Attributes Attribute Group - Vehicle. Valid values are 'NONE', 'REJECT', and 'WARNING'.
1109 * @param p_container_type_code Physical Attributes Attribute Group - Container Type.
1110 * @param p_internal_volume Physical Attributes Attribute Group - Internal Volume.
1111 * @param p_maximum_load_weight Physical Attributes Attribute Group - Maximum Load Weight.
1112 * @param p_minimum_fill_percent Physical Attributes Attribute Group - Minimum Fill Percent.
1113 * @param p_inventory_planning_code General Planning Attribute Group - Inventory Planning Method. Valid values are 1, 2, 6, and 7.
1114 * @param p_planner_code General Planning Attribute Group - Planner.
1115 * @param p_planning_make_buy_code General Planning Attribute Group - Make or Buy. Valid values are 1 and 2.
1116 * @param p_min_minmax_quantity General Planning Attribute Group - Min-Max Quantity - Minimum.
1117 * @param p_max_minmax_quantity General Planning Attribute Group - Min-Max Quantity - Maximum.
1118 * @param p_minimum_order_quantity General Planning Attribute Group - Order Quantity - Minimum.
1119 * @param p_maximum_order_quantity General Planning Attribute Group - Order Quantity - Maximum.
1120 * @param p_order_cost General Planning Attribute Group - Cost - Order.
1121 * @param p_carrying_cost General Planning Attribute Group - Cost - Carrying Percentage.
1122 * @param p_source_type General Planning Attribute Group - Source - Type. Valid values are 1 and 2.
1123 * @param p_source_organization_id General Planning Attribute Group - Source - Organization.
1124 * @param p_source_subinventory General Planning Attribute Group - Source - Subinventory.
1125 * @param p_mrp_safety_stock_code General Planning Attribute Group - Safety Stock - Method. Valid values are 1 and 2.
1126 * @param p_safety_stock_bucket_days General Planning Attribute Group - Safety Stock - Bucket Days.
1127 * @param p_mrp_safety_stock_percent General Planning Attribute Group - Safety Stock - Percent.
1128 * @param p_fixed_order_quantity General Planning Attribute Group - Order Modifiers - Fixed Order Quantity.
1129 * @param p_fixed_days_supply General Planning Attribute Group - Order Modifiers - Fixed Days Supply.
1130 * @param p_fixed_lot_multiplier General Planning Attribute Group - Order Modifiers - Fixed Lot Multiplier.
1131 * @param p_mrp_planning_code MPS/MRP Planning Attribute Group - Planning Method. Valid values are 3, 4, 6, 7, 8, and 9.
1132 * @param p_ato_forecast_control MPS/MRP Planning Attribute Group - Forecast Control. Valid values are 1, 2, and 3.
1133 * @param p_planning_exception_set MPS/MRP Planning Attribute Group - Exception Set .
1134 * @param p_end_assembly_pegging_flag MPS/MRP Planning Attribute Group - Pegging. Valid values are A, B, Y, I, X, and N.
1135 * @param p_shrinkage_rate MPS/MRP Planning Attribute Group - Shrinkage Rate.
1136 * @param p_rounding_control_type MPS/MRP Planning Attribute Group - Round Order Quantities. Valid values are 1 and 2.
1137 * @param p_acceptable_early_days MPS/MRP Planning Attribute Group - Acceptable Early Days.
1138 * @param p_repetitive_planning_flag MPS/MRP Planning Attribute Group - Repetitive Planning - Repetitive Planning. Valid values are 'Y' and 'N'.
1139 * @param p_overrun_percentage MPS/MRP Planning Attribute Group - Repetitive Planning - Overrun Percentage.
1143 * @param p_auto_reduce_mps MPS/MRP Planning Attribute Group - MPS Planning - Reduce MPS. Valid values are 1, 2, 3, and 4.
1140 * @param p_acceptable_rate_increase MPS/MRP Planning Attribute Group - Repetitive Planning - Negative Acceptable Rate.
1141 * @param p_acceptable_rate_decrease MPS/MRP Planning Attribute Group - Repetitive Planning - Positive Acceptable Rate.
1142 * @param p_mrp_calculate_atp_flag MPS/MRP Planning Attribute Group - MPS Planning - Calculate ATP. Valid values are 'Y' and 'N'.
1144 * @param p_planning_time_fence_code MPS/MRP Planning Attribute Group - Planning Time Fence. Valid values are 1, 2, 3, and 4.
1145 * @param p_planning_time_fence_days MPS/MRP Planning Attribute Group - Planning Time Days.
1146 * @param p_demand_time_fence_code MPS/MRP Planning Attribute Group - Demand Time Fence. Valid values are 1, 2, 3, and 4.
1147 * @param p_demand_time_fence_days MPS/MRP Planning Attribute Group - Demand Time Days.
1148 * @param p_release_time_fence_code MPS/MRP Planning Attribute Group - Release Time Fence. Valid values are 1, 2, 3, 4, 5, and 6.
1149 * @param p_release_time_fence_days MPS/MRP Planning Attribute Group - Release Time Days.
1150 * @param p_preprocessing_lead_time Lead Times Attribute Group - Preprocessing.
1151 * @param p_full_lead_time Lead Times Attribute Group - Postprocessing.
1152 * @param p_postprocessing_lead_time Lead Times Attribute Group - Processing.
1153 * @param p_fixed_lead_time Lead Times Attribute Group - Fixed.
1154 * @param p_variable_lead_time Lead Times Attribute Group - Variable.
1155 * @param p_cum_manufacturing_lead_time Lead Times Attribute Group - Cumulative Manufacturing.
1156 * @param p_cumulative_total_lead_time Lead Times Attribute Group - Cumulative Total.
1157 * @param p_lead_time_lot_size Lead Times Attribute Group - Lead Time Lot Size.
1158 * @param p_build_in_wip_flag Work In Process - Build in WIP. Valid values are 'Y' and 'N'.
1159 * @param p_wip_supply_type Work In Process - Supply Type. Valid values are 1, 2, 3, 4, 5, and 6.
1160 * @param p_wip_supply_subinventory Work In Process - Supply Subinventory.
1161 * @param p_wip_supply_locator_id Work In Process - Supply Locator.
1162 * @param p_overcompletion_tolerance_ty Work In Process - Overcompletion Tolerance Type. Valid values are 1 and 2.
1163 * @param p_overcompletion_tolerance_va Work In Process - Overcompletion Tolerance Value.
1164 * @param p_customer_order_flag Order Management Attribute Group - Customer Ordered. Valid values are 'Y' and 'N'.
1165 * @param p_customer_order_enabled_flag Order Management Attribute Group - Customer Orders Enabled. Valid values are 'Y' and 'N'.
1166 * @param p_shippable_item_flag Order Management Attribute Group - Shippable. Valid values are 'Y' and 'N'.
1167 * @param p_internal_order_flag Order Management Attribute Group - Internal Ordered. Valid values are 'Y' and 'N'.
1168 * @param p_internal_order_enabled_flag Order Management Attribute Group - Internal Orders Enabled. Valid values are 'Y' and 'N'.
1169 * @param p_so_transactions_flag Order Management Attribute Group - OE Transactable. Valid values are 'Y' and 'N'.
1170 * @param p_pick_components_flag Order Management Attribute Group - Pick Components. Valid values are 'Y' and 'N'.
1171 * @param p_atp_flag Order Management Attribute Group - Check ATP. Valid values are 'Y', 'R', 'C', and 'N'.
1172 * @param p_replenish_to_order_flag Order Management Attribute Group - Assemble to Order. Valid values are 'Y' and 'N'.
1173 * @param p_atp_rule_id Order Management Attribute Group - ATP Rule.
1174 * @param p_atp_components_flag Order Management Attribute Group - ATP Components.
1175 * @param p_ship_model_complete_flag Order Management Attribute Group - Ship Model Complete.
1176 * @param p_picking_rule_id Order Management Attribute Group - Picking Rule.
1177 * @param p_collateral_flag Physical Attributes Attribute Group - Collateral Item. Valid values are 'NONE', 'REJECT', and 'WARNING'.
1178 * @param p_default_shipping_org Order Management Attribute Group - Default Shipping Organization.
1179 * @param p_returnable_flag Order Management Attribute Group - Returnable. Valid values are 'Y' and 'N'.
1180 * @param p_return_inspection_requireme Order Management Attribute Group - RMA Inspection Required. Valid values are 1 and 2.
1181 * @param p_over_shipment_tolerance Order Management Attribute Group - Tolerances - Over Shipment.
1182 * @param p_under_shipment_tolerance Order Management Attribute Group - Tolerances - Under Shipment.
1183 * @param p_over_return_tolerance Order Management Attribute Group - Tolerances - Over Return.
1184 * @param p_under_return_tolerance Order Management Attribute Group - Tolerances - Under Return.
1185 * @param p_invoiceable_item_flag Invoicing Attribute Group - Invoiceable Item. Valid values are 'Y' and 'N'.
1186 * @param p_invoice_enabled_flag Invoicing Attribute Group - Invoice Enabled. Valid values are 'Y' and 'N'.
1187 * @param p_accounting_rule_id Invoicing Attribute Group - Accounting Rule.
1188 * @param p_invoicing_rule_id Invoicing Attribute Group - Invoiceable Item.
1189 * @param p_tax_code Invoicing Attribute Group - Tax Code.
1190 * @param p_sales_account Invoicing Attribute Group - Sales Account.
1191 * @param p_payment_terms_id Invoicing Attribute Group - Payment Terms.
1192 * @param p_coverage_schedule_id Service Attribute Group - Service Contracts - Template.
1193 * @param p_service_duration Service Attribute Group - Service Contracts - Duration.
1194 * @param p_service_duration_period_cod Service Attribute Group - Service Contracts - Duration Period.
1195 * @param p_serviceable_product_flag Service Attribute Group - Enable Contract Coverage. Valid values are 'Y' and 'N'.
1196 * @param p_service_starting_delay Service Attribute Group - Service Contracts - Starting Delay (Days).
1197 * @param p_material_billable_flag Service Attribute Group - Debrief and Charges - Billing Type.
1198 * @param p_serviceable_component_flag <B>DEPRECATED.</B> This parameter should not be used.
1199 * @param p_preventive_maintenance_flag <B>DEPRECATED.</B> This parameter should not be used.
1200 * @param p_prorate_service_flag <B>DEPRECATED.</B> This parameter should not be used.
1204 * @param p_max_warranty_amount <B>DEPRECATED.</B> This parameter should not be used.
1201 * @param p_serviceable_item_class_id <B>DEPRECATED.</B> This parameter should not be used.
1202 * @param p_base_warranty_service_id <B>DEPRECATED.</B> This parameter should not be used.
1203 * @param p_warranty_vendor_id <B>DEPRECATED.</B> This parameter should not be used.
1205 * @param p_response_time_period_code <B>DEPRECATED.</B> This parameter should not be used.
1206 * @param p_response_time_value <B>DEPRECATED.</B> This parameter should not be used.
1207 * @param p_primary_specialist_id <B>DEPRECATED.</B> This parameter should not be used.
1208 * @param p_secondary_specialist_id <B>DEPRECATED.</B> This parameter should not be used.
1209 * @param p_wh_update_date <B>DEPRECATED.</B> This parameter should not be used.
1210 * @param p_equipment_type Physical Attributes Attribute Group - Equipment. Valid values are 1 and 2.
1211 * @param p_recovered_part_disp_code Service Attribute Group - Debrief and Charges - Recovered Part Disposition.
1212 * @param p_defect_tracking_on_flag Service Attribute Group - Enable Defect Tracking. Valid values are 'Y' and NULL.
1213 * @param p_event_flag Physical Attributes Attribute Group - Event. Valid values are 'Y' and NULL.
1214 * @param p_electronic_flag Physical Attributes Attribute Group - Electronic Format. Valid values are 'Y' and NULL.
1215 * @param p_downloadable_flag Physical Attributes Attribute Group - Downloadable. Valid values are 'Y' and NULL.
1216 * @param p_vol_discount_exempt_flag <B>DEPRECATED.</B> This parameter should not be used.
1217 * @param p_coupon_exempt_flag <B>DEPRECATED.</B> This parameter should not be used.
1218 * @param p_comms_nl_trackable_flag Service Attribute Group - Installed Base - Track in Installed Base. Valid values are 'Y' and NULL.
1219 * @param p_asset_creation_code Service Attribute Group - Installed Base - Create Fixed Asset. Valid values are 1 and 0.
1220 * @param p_comms_activation_reqd_flag <B>DEPRECATED.</B> This parameter should not be used.
1221 * @param p_orderable_on_web_flag Web Option Attribute Group - Orderable on the Web. Valid values are 'Y' and NULL.
1222 * @param p_back_orderable_flag Web Option Attribute Group - Back Orderable. Valid values are 'Y' and NULL.
1223 * @param p_web_status Web Option Attribute Group - Web Status.
1224 * @param p_indivisible_flag Physical Attributes Attribute Group - OM Indivisible. Valid values are 'Y' and NULL.
1225 * @param p_dimension_uom_code Physical Attributes Attribute Group - Unit of Measure.
1226 * @param p_unit_length Physical Attributes Attribute Group - Length.
1227 * @param p_unit_width Physical Attributes Attribute Group - Width.
1228 * @param p_unit_height Physical Attributes Attribute Group - Height.
1229 * @param p_bulk_picked_flag Inventory Attribute Group - Bulk Picked. Valid values are 'Y' and 'N'.
1230 * @param p_lot_status_enabled Inventory Attribute Group - Lot Status Enabled. Valid values are 'Y' and 'N'.
1231 * @param p_default_lot_status_id <B>DEPRECATED.</B> This parameter should not be used.
1232 * @param p_serial_status_enabled Inventory Attribute Group - Serial Status Enabled. Valid values are 'Y' and 'N'.
1233 * @param p_default_serial_status_id <B>DEPRECATED.</B> This parameter should not be used.
1234 * @param p_lot_split_enabled Inventory Attribute Group - Lot Split Enabled. Valid values are 'Y' and 'N'.
1235 * @param p_lot_merge_enabled Inventory Attribute Group - Lot Merge Enabled. Valid values are 'Y' and 'N'.
1236 * @param p_inventory_carry_penalty Work In Process - Inventory Carry.
1237 * @param p_operation_slack_penalty Work In Process - Operation Slack.
1238 * @param p_financing_allowed_flag Order Management Attribute Group - Financing Allowed. Valid values are 'Y' and NULL.
1239 * @param p_eam_item_type Asset Management Attribute Group - Asset Item Type. Valid values are 1, 2, and 3.
1240 * @param p_eam_activity_type_code Asset Management Attribute Group - Activity Type.
1241 * @param p_eam_activity_cause_code Asset Management Attribute Group - Activity Cause.
1242 * @param p_eam_act_notification_flag Asset Management Attribute Group - Activity Notification Required. Valid values are 'Y' and 'N'.
1243 * @param p_eam_act_shutdown_status Asset Management Attribute Group - Shutdown Type.
1244 * @param p_dual_uom_control <B>DEPRECATED.</B> This parameter should not be used.
1245 * @param p_secondary_uom_code Main Attribute Group - Secondary Unit of Measure.
1246 * @param p_dual_uom_deviation_high Main Attribute Group - Positive Deviation Factor.
1247 * @param p_dual_uom_deviation_low Main Attribute Group - Negative Deviation Factor.
1248 * @param p_contract_item_type_code Service Attribute Group - Service Contracts - Contract Item Type. Valid values are 'SERVICE', 'SUBSCRIPTION', 'USAGE', and 'WARRANTY'.
1249 * @param p_subscription_depend_flag <B>DEPRECATED.</B> This parameter should not be used.
1250 * @param p_serv_req_enabled_code Service Attribute Group - Service Request. Valid values are 'E', 'D', and 'I'.
1251 * @param p_serv_billing_enabled_flag Service Attribute Group - Debrief and Charges - Enable Service Billing. Valid values are 'Y' and 'N'.
1252 * @param p_serv_importance_level <B>DEPRECATED.</B> This parameter should not be used.
1253 * @param p_planned_inv_point_flag MPS/MRP Planning Attribute Group - Planned Inventory Point. Valid values are 'Y' and NULL.
1254 * @param p_lot_translate_enabled Inventory Attribute Group - Lot Translate Enabled. Valid values are 'Y' and 'N'.
1255 * @param p_default_so_source_type Order Management Attribute Group - Default SO Source Type.
1256 * @param p_create_supply_flag MPS/MRP Planning Attribute Group - Create Supply. Valid values are 'Y' and 'N'.
1257 * @param p_substitution_window_code MPS/MRP Planning Attribute Group - Substitution Window. Valid values are 1, 2, 3, and 4.
1258 * @param p_substitution_window_days MPS/MRP Planning Attribute Group - Substitution Days.
1259 * @param p_ib_item_instance_class Service Attribute Group - Installed Base - Instance Class.
1260 * @param p_config_model_type Bills of Material Attribute Group - Configurator Model Type.
1264 * @param p_approval_status <B>DEPRECATED.</B> This parameter should not be used.
1261 * @param p_lot_substitution_enabled Inventory Attribute Group - Lot Substitution Enabled. Valid values are 'Y' and NULL.
1262 * @param p_minimum_license_quantity Web Option Attribute Group - Minimum License Quantity.
1263 * @param p_eam_activity_source_code Asset Management Attribute Group - Activity Source.
1265 * @param p_tracking_quantity_ind Main Attribute Group - Tracking. Valid values are 'P' and 'D'.
1266 * @param p_ont_pricing_qty_source Main Attribute Group - Pricing. Valid values are 'P' and 'S'.
1267 * @param p_secondary_default_ind Main Attribute Group - Defaulting. Valid values are 'F', 'D', 'N', and NULL.
1268 * @param p_option_specific_sourced <B>DEPRECATED.</B> This parameter should not be used.
1269 * @param p_vmi_minimum_units General Planning Attribute Group - Replenishment Point - Minimum Order.
1270 * @param p_vmi_minimum_days General Planning Attribute Group - Replenishment Point - Minimum Days of Supply.
1271 * @param p_vmi_maximum_units General Planning Attribute Group - Order Quantity - Maximum Order.
1272 * @param p_vmi_maximum_days General Planning Attribute Group - Order Quantity - Maximum Days of Supply.
1273 * @param p_vmi_fixed_order_quantity General Planning Attribute Group - Order Quantity - Fixed Quantity.
1274 * @param p_so_authorization_flag General Planning Attribute Group - Release Authorization Required. Valid values are 1, 2, and NULL.
1275 * @param p_consigned_flag General Planning Attribute Group - Consigned. Valid values are 1 and 2.
1276 * @param p_asn_autoexpire_flag General Planning Attribute Group - Auto-expire ASN. Valid values are 1 and 2.
1277 * @param p_vmi_forecast_type General Planning Attribute Group - Average Daily Demand Calculation - Forecast Type.
1278 * @param p_forecast_horizon General Planning Attribute Group - Average Daily Demand Calculation - Window Days.
1279 * @param p_exclude_from_budget_flag MPS/MRP Planning Attribute Group - Exclude From Budget. Valid values are 1 and 2.
1280 * @param p_days_tgt_inv_supply MPS/MRP Planning Attribute Group - Distribution Planning - Target Inventory Days of Supply.
1281 * @param p_days_tgt_inv_window MPS/MRP Planning Attribute Group - Distribution Planning - Target Inventory Window.
1282 * @param p_days_max_inv_supply MPS/MRP Planning Attribute Group - Distribution Planning - Maximum Inventory Days of Supply.
1283 * @param p_days_max_inv_window MPS/MRP Planning Attribute Group - Distribution Planning - Maximum Inventory Window.
1284 * @param p_drp_planned_flag MPS/MRP Planning Attribute Group - Distribution Planning - DRP Planned. Valid values are 1 and 2.
1285 * @param p_critical_component_flag MPS/MRP Planning Attribute Group - Critical Component. Valid values are 1 and 2.
1286 * @param p_continous_transfer MPS/MRP Planning Attribute Group - Incremental Supply Pattern - Continuous Inter-Org Transfers.
1287 * @param p_convergence MPS/MRP Planning Attribute Group - Incremental Supply Pattern - Convergence Pattern.
1288 * @param p_divergence MPS/MRP Planning Attribute Group - Incremental Supply Pattern - Divergence Pattern.
1289 * @param p_config_orgs Bills of Material Attribute Group - Create Configured Item, BOM.
1290 * @param p_config_match Bills of Material Attribute Group - Match Configuration.
1291 * @param p_Item_Number Concatenated segments value. Either Item Number or Segments should be passed.
1292 * @param p_segment1 Segment1 of item name.
1293 * @param p_segment2 Segment2 of item name.
1294 * @param p_segment3 Segment3 of item name.
1295 * @param p_segment4 Segment4 of item name.
1296 * @param p_segment5 Segment5 of item name.
1297 * @param p_segment6 Segment6 of item name.
1298 * @param p_segment7 Segment7 of item name.
1299 * @param p_segment8 Segment8 of item name.
1300 * @param p_segment9 Segment9 of item name.
1301 * @param p_segment10 Segment10 of item name.
1302 * @param p_segment11 Segment11 of item name.
1303 * @param p_segment12 Segment12 of item name.
1304 * @param p_segment13 Segment13 of item name.
1305 * @param p_segment14 Segment14 of item name.
1306 * @param p_segment15 Segment15 of item name.
1307 * @param p_segment16 Segment16 of item name.
1308 * @param p_segment17 Segment17 of item name.
1309 * @param p_segment18 Segment18 of item name.
1310 * @param p_segment19 Segment19 of item name.
1311 * @param p_segment20 Segment20 of item name.
1312 * @param p_summary_flag <B>DEPRECATED.</B> This parameter should not be used.
1313 * @param p_enabled_flag <B>DEPRECATED.</B> This parameter should not be used.
1314 * @param p_start_date_active <B>DEPRECATED.</B> This parameter should not be used.
1315 * @param p_end_date_active <B>DEPRECATED.</B> This parameter should not be used.
1316 * @param p_attribute_category Descriptive Flexfield (DFF) Context Field.
1317 * @param p_attribute1 Descriptive Flexfield's Attribute1.
1318 * @param p_attribute2 Descriptive Flexfield's Attribute2.
1319 * @param p_attribute3 Descriptive Flexfield's Attribute3.
1320 * @param p_attribute4 Descriptive Flexfield's Attribute4.
1321 * @param p_attribute5 Descriptive Flexfield's Attribute5.
1322 * @param p_attribute6 Descriptive Flexfield's Attribute6.
1323 * @param p_attribute7 Descriptive Flexfield's Attribute7.
1324 * @param p_attribute8 Descriptive Flexfield's Attribute8.
1325 * @param p_attribute9 Descriptive Flexfield's Attribute9.
1326 * @param p_attribute10 Descriptive Flexfield's Attribute10.
1327 * @param p_attribute11 Descriptive Flexfield's Attribute11.
1328 * @param p_attribute12 Descriptive Flexfield's Attribute12.
1329 * @param p_attribute13 Descriptive Flexfield's Attribute13.
1330 * @param p_attribute14 Descriptive Flexfield's Attribute14.
1331 * @param p_attribute15 Descriptive Flexfield's Attribute15.
1332 * @param p_global_attribute_category Descriptive Flexfield (DFF) Context Field.
1333 * @param p_global_attribute1 Descriptive Flexfield's Global Attribute1.
1334 * @param p_global_attribute2 Descriptive Flexfield's Global Attribute2.
1335 * @param p_global_attribute3 Descriptive Flexfield's Global Attribute3.
1336 * @param p_global_attribute4 Descriptive Flexfield's Global Attribute4.
1340 * @param p_global_attribute8 Descriptive Flexfield's Global Attribute8.
1337 * @param p_global_attribute5 Descriptive Flexfield's Global Attribute5.
1338 * @param p_global_attribute6 Descriptive Flexfield's Global Attribute6.
1339 * @param p_global_attribute7 Descriptive Flexfield's Global Attribute7.
1341 * @param p_global_attribute9 Descriptive Flexfield's Global Attribute9.
1342 * @param p_global_attribute10 Descriptive Flexfield's Global Attribute10.
1343 * @param p_global_attribute11 Descriptive Flexfield's Global Attribute11.
1344 * @param p_global_attribute12 Descriptive Flexfield's Global Attribute12.
1345 * @param p_global_attribute13 Descriptive Flexfield's Global Attribute13.
1346 * @param p_global_attribute14 Descriptive Flexfield's Global Attribute14.
1347 * @param p_global_attribute15 Descriptive Flexfield's Global Attribute15.
1348 * @param p_global_attribute16 Descriptive Flexfield's Global Attribute16.
1349 * @param p_global_attribute17 Descriptive Flexfield's Global Attribute17.
1350 * @param p_global_attribute18 Descriptive Flexfield's Global Attribute18.
1351 * @param p_global_attribute19 Descriptive Flexfield's Global Attribute19.
1352 * @param p_global_attribute20 Descriptive Flexfield's Global Attribute20.
1353 * @param p_creation_date <B>DEPRECATED.</B> This parameter should not be used.
1354 * @param p_created_by <B>DEPRECATED.</B> This parameter should not be used.
1355 * @param p_last_update_date <B>DEPRECATED.</B> This parameter should not be used.
1356 * @param p_last_updated_by <B>DEPRECATED.</B> This parameter should not be used.
1357 * @param p_last_update_login <B>DEPRECATED.</B> This parameter should not be used.
1358 * @param p_request_id <B>DEPRECATED.</B> This parameter should not be used.
1359 * @param p_program_application_id <B>DEPRECATED.</B> This parameter should not be used.
1360 * @param p_program_id <B>DEPRECATED.</B> This parameter should not be used.
1361 * @param p_program_update_date <B>DEPRECATED.</B> This parameter should not be used.
1362 * @param p_lifecycle_id Item's Lifecycle.
1363 * @param p_current_phase_id Item's Lifecycle Phase.
1364 * @param p_revision_id <B>DEPRECATED.</B> This parameter should not be used.
1365 * @param p_revision_code Revision Code.
1366 * @param p_revision_label Revision Label.
1367 * @param p_revision_description Revision Description.
1368 * @param p_effectivity_Date Revision Effectivity Date.
1369 * @param p_rev_lifecycle_id Revision's Lifecycle.
1370 * @param p_rev_current_phase_id Revision's Lifecycle Phase.
1371 * @param p_rev_attribute_category Revision's Descriptive Flexfield (DFF) Context Field.
1372 * @param p_rev_attribute1 Revision Descriptive Flexfield's Attribute1.
1373 * @param p_rev_attribute2 Revision Descriptive Flexfield's Attribute2.
1374 * @param p_rev_attribute3 Revision Descriptive Flexfield's Attribute3.
1375 * @param p_rev_attribute4 Revision Descriptive Flexfield's Attribute4.
1376 * @param p_rev_attribute5 Revision Descriptive Flexfield's Attribute5.
1377 * @param p_rev_attribute6 Revision Descriptive Flexfield's Attribute6.
1378 * @param p_rev_attribute7 Revision Descriptive Flexfield's Attribute7.
1379 * @param p_rev_attribute8 Revision Descriptive Flexfield's Attribute8.
1380 * @param p_rev_attribute9 Revision Descriptive Flexfield's Attribute9.
1381 * @param p_rev_attribute10 Revision Descriptive Flexfield's Attribute10.
1382 * @param p_rev_attribute11 Revision Descriptive Flexfield's Attribute11.
1383 * @param p_rev_attribute12 Revision Descriptive Flexfield's Attribute12.
1384 * @param p_rev_attribute13 Revision Descriptive Flexfield's Attribute13.
1385 * @param p_rev_attribute14 Revision Descriptive Flexfield's Attribute14.
1386 * @param p_rev_attribute15 Revision Descriptive Flexfield's Attribute15.
1387 * @param x_return_status A code indicating whether any errors
1388 * occurred during processing. Refer to the package description
1389 * above for more information about this parameter and a list of
1390 * valid values.
1391 * @param x_msg_count An integer indicating the number of messages
1392 * on the FND_MSG_PUB package's message stack at the end of API
1393 * processing. Refer to the package description above for more
1394 * information about this parameter.
1395 * @param x_msg_data A character string containing message text.
1396 * Refer to the package description above for more information
1397 * about this parameter and a list of valid values.
1398 * @rep:scope public
1399 * @rep:lifecycle active
1400 * @rep:displayname Process Item
1401 */
1402 PROCEDURE Process_Item(
1403 p_api_version IN NUMBER
1404 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
1405 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
1406 -- Transaction data
1407 ,p_Transaction_Type IN VARCHAR2 DEFAULT G_MISS_CHAR
1408 ,p_Language_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
1409 -- Copy item from template
1410 ,p_Template_Id IN NUMBER DEFAULT NULL
1411 ,p_Template_Name IN VARCHAR2 DEFAULT NULL
1412 -- Copy item from another item
1413 ,p_copy_inventory_item_Id IN NUMBER DEFAULT G_MISS_NUM
1414 -- Base Attributes
1415 ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
1416 ,p_organization_id IN NUMBER DEFAULT G_MISS_NUM
1417 ,p_master_organization_id IN NUMBER DEFAULT G_MISS_NUM
1418 ,p_description IN VARCHAR2 DEFAULT G_MISS_CHAR
1419 ,p_long_description IN VARCHAR2 DEFAULT G_MISS_CHAR
1420 ,p_primary_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1421 ,p_primary_unit_of_measure IN VARCHAR2 DEFAULT G_MISS_CHAR
1422 ,p_item_type IN VARCHAR2 DEFAULT G_MISS_CHAR
1423 ,p_inventory_item_status_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1427 ,p_inventory_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1424 ,p_allowed_units_lookup_code IN NUMBER DEFAULT G_MISS_NUM
1425 ,p_item_catalog_group_id IN NUMBER DEFAULT G_MISS_NUM
1426 ,p_catalog_status_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1428 ,p_stock_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1429 ,p_mtl_transactions_enabled_fl IN VARCHAR2 DEFAULT G_MISS_CHAR
1430 ,p_check_shortages_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1431 ,p_revision_qty_control_code IN NUMBER DEFAULT G_MISS_NUM
1432 ,p_reservable_type IN NUMBER DEFAULT G_MISS_NUM
1433 ,p_shelf_life_code IN NUMBER DEFAULT G_MISS_NUM
1434 ,p_shelf_life_days IN NUMBER DEFAULT G_MISS_NUM
1435 ,p_cycle_count_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1436 ,p_negative_measurement_error IN NUMBER DEFAULT G_MISS_NUM
1437 ,p_positive_measurement_error IN NUMBER DEFAULT G_MISS_NUM
1438 ,p_lot_control_code IN NUMBER DEFAULT G_MISS_NUM
1439 ,p_auto_lot_alpha_prefix IN VARCHAR2 DEFAULT G_MISS_CHAR
1440 ,p_start_auto_lot_number IN VARCHAR2 DEFAULT G_MISS_CHAR
1441 ,p_serial_number_control_code IN NUMBER DEFAULT G_MISS_NUM
1442 ,p_auto_serial_alpha_prefix IN VARCHAR2 DEFAULT G_MISS_CHAR
1443 ,p_start_auto_serial_number IN VARCHAR2 DEFAULT G_MISS_CHAR
1444 ,p_location_control_code IN NUMBER DEFAULT G_MISS_NUM
1445 ,p_restrict_subinventories_cod IN NUMBER DEFAULT G_MISS_NUM
1446 ,p_restrict_locators_code IN NUMBER DEFAULT G_MISS_NUM
1447 ,p_bom_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1448 ,p_bom_item_type IN NUMBER DEFAULT G_MISS_NUM
1449 ,p_base_item_id IN NUMBER DEFAULT G_MISS_NUM
1450 ,p_effectivity_control IN NUMBER DEFAULT G_MISS_NUM
1451 ,p_eng_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1452 ,p_engineering_ecn_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1453 ,p_engineering_item_id IN NUMBER DEFAULT G_MISS_NUM
1454 ,p_engineering_date IN DATE DEFAULT G_MISS_DATE
1455 ,p_product_family_item_id IN NUMBER DEFAULT G_MISS_NUM
1456 ,p_auto_created_config_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1457 ,p_model_config_clause_name IN VARCHAR2 DEFAULT G_MISS_CHAR
1458 -- attribute not in the form
1459 ,p_new_revision_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1460 ,p_costing_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1461 ,p_inventory_asset_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1462 ,p_default_include_in_rollup_f IN VARCHAR2 DEFAULT G_MISS_CHAR
1463 ,p_cost_of_sales_account IN NUMBER DEFAULT G_MISS_NUM
1464 ,p_std_lot_size IN NUMBER DEFAULT G_MISS_NUM
1465 ,p_purchasing_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1466 ,p_purchasing_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1467 ,p_must_use_approved_vendor_fl IN VARCHAR2 DEFAULT G_MISS_CHAR
1468 ,p_allow_item_desc_update_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1469 ,p_rfq_required_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1470 ,p_outside_operation_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1471 ,p_outside_operation_uom_type IN VARCHAR2 DEFAULT G_MISS_CHAR
1472 ,p_taxable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1473 ,p_purchasing_tax_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1474 ,p_receipt_required_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1475 ,p_inspection_required_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1476 ,p_buyer_id IN NUMBER DEFAULT G_MISS_NUM
1477 ,p_unit_of_issue IN VARCHAR2 DEFAULT G_MISS_CHAR
1478 ,p_receive_close_tolerance IN NUMBER DEFAULT G_MISS_NUM
1479 ,p_invoice_close_tolerance IN NUMBER DEFAULT G_MISS_NUM
1480 ,p_un_number_id IN NUMBER DEFAULT G_MISS_NUM
1481 ,p_hazard_class_id IN NUMBER DEFAULT G_MISS_NUM
1482 ,p_list_price_per_unit IN NUMBER DEFAULT G_MISS_NUM
1483 ,p_market_price IN NUMBER DEFAULT G_MISS_NUM
1484 ,p_price_tolerance_percent IN NUMBER DEFAULT G_MISS_NUM
1485 ,p_rounding_factor IN NUMBER DEFAULT G_MISS_NUM
1486 ,p_encumbrance_account IN NUMBER DEFAULT G_MISS_NUM
1487 ,p_expense_account IN NUMBER DEFAULT G_MISS_NUM
1488 ,p_expense_billable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1489 ,p_asset_category_id IN NUMBER DEFAULT G_MISS_NUM
1490 ,p_receipt_days_exception_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1491 ,p_days_early_receipt_allowed IN NUMBER DEFAULT G_MISS_NUM
1492 ,p_days_late_receipt_allowed IN NUMBER DEFAULT G_MISS_NUM
1493 ,p_allow_substitute_receipts_f IN VARCHAR2 DEFAULT G_MISS_CHAR
1494 ,p_allow_unordered_receipts_fl IN VARCHAR2 DEFAULT G_MISS_CHAR
1495 ,p_allow_express_delivery_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1496 ,p_qty_rcv_exception_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1497 ,p_qty_rcv_tolerance IN NUMBER DEFAULT G_MISS_NUM
1498 ,p_receiving_routing_id IN NUMBER DEFAULT G_MISS_NUM
1499 ,p_enforce_ship_to_location_c IN VARCHAR2 DEFAULT G_MISS_CHAR
1500 ,p_weight_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1501 ,p_unit_weight IN NUMBER DEFAULT G_MISS_NUM
1505 ,p_vehicle_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1502 ,p_volume_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1503 ,p_unit_volume IN NUMBER DEFAULT G_MISS_NUM
1504 ,p_container_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1506 ,p_container_type_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1507 ,p_internal_volume IN NUMBER DEFAULT G_MISS_NUM
1508 ,p_maximum_load_weight IN NUMBER DEFAULT G_MISS_NUM
1509 ,p_minimum_fill_percent IN NUMBER DEFAULT G_MISS_NUM
1510 ,p_inventory_planning_code IN NUMBER DEFAULT G_MISS_NUM
1511 ,p_planner_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1512 ,p_planning_make_buy_code IN NUMBER DEFAULT G_MISS_NUM
1513 ,p_min_minmax_quantity IN NUMBER DEFAULT G_MISS_NUM
1514 ,p_max_minmax_quantity IN NUMBER DEFAULT G_MISS_NUM
1515 ,p_minimum_order_quantity IN NUMBER DEFAULT G_MISS_NUM
1516 ,p_maximum_order_quantity IN NUMBER DEFAULT G_MISS_NUM
1517 ,p_order_cost IN NUMBER DEFAULT G_MISS_NUM
1518 ,p_carrying_cost IN NUMBER DEFAULT G_MISS_NUM
1519 ,p_source_type IN NUMBER DEFAULT G_MISS_NUM
1520 ,p_source_organization_id IN NUMBER DEFAULT G_MISS_NUM
1521 ,p_source_subinventory IN VARCHAR2 DEFAULT G_MISS_CHAR
1522 ,p_mrp_safety_stock_code IN NUMBER DEFAULT G_MISS_NUM
1523 ,p_safety_stock_bucket_days IN NUMBER DEFAULT G_MISS_NUM
1524 ,p_mrp_safety_stock_percent IN NUMBER DEFAULT G_MISS_NUM
1525 ,p_fixed_order_quantity IN NUMBER DEFAULT G_MISS_NUM
1526 ,p_fixed_days_supply IN NUMBER DEFAULT G_MISS_NUM
1527 ,p_fixed_lot_multiplier IN NUMBER DEFAULT G_MISS_NUM
1528 ,p_mrp_planning_code IN NUMBER DEFAULT G_MISS_NUM
1529 ,p_ato_forecast_control IN NUMBER DEFAULT G_MISS_NUM
1530 ,p_planning_exception_set IN VARCHAR2 DEFAULT G_MISS_CHAR
1531 ,p_end_assembly_pegging_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1532 ,p_shrinkage_rate IN NUMBER DEFAULT G_MISS_NUM
1533 ,p_rounding_control_type IN NUMBER DEFAULT G_MISS_NUM
1534 ,p_acceptable_early_days IN NUMBER DEFAULT G_MISS_NUM
1535 ,p_repetitive_planning_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1536 ,p_overrun_percentage IN NUMBER DEFAULT G_MISS_NUM
1537 ,p_acceptable_rate_increase IN NUMBER DEFAULT G_MISS_NUM
1538 ,p_acceptable_rate_decrease IN NUMBER DEFAULT G_MISS_NUM
1539 ,p_mrp_calculate_atp_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1540 ,p_auto_reduce_mps IN NUMBER DEFAULT G_MISS_NUM
1541 ,p_planning_time_fence_code IN NUMBER DEFAULT G_MISS_NUM
1542 ,p_planning_time_fence_days IN NUMBER DEFAULT G_MISS_NUM
1543 ,p_demand_time_fence_code IN NUMBER DEFAULT G_MISS_NUM
1544 ,p_demand_time_fence_days IN NUMBER DEFAULT G_MISS_NUM
1545 ,p_release_time_fence_code IN NUMBER DEFAULT G_MISS_NUM
1546 ,p_release_time_fence_days IN NUMBER DEFAULT G_MISS_NUM
1547 ,p_preprocessing_lead_time IN NUMBER DEFAULT G_MISS_NUM
1548 ,p_full_lead_time IN NUMBER DEFAULT G_MISS_NUM
1549 ,p_postprocessing_lead_time IN NUMBER DEFAULT G_MISS_NUM
1550 ,p_fixed_lead_time IN NUMBER DEFAULT G_MISS_NUM
1551 ,p_variable_lead_time IN NUMBER DEFAULT G_MISS_NUM
1552 ,p_cum_manufacturing_lead_time IN NUMBER DEFAULT G_MISS_NUM
1553 ,p_cumulative_total_lead_time IN NUMBER DEFAULT G_MISS_NUM
1554 ,p_lead_time_lot_size IN NUMBER DEFAULT G_MISS_NUM
1555 ,p_build_in_wip_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1556 ,p_wip_supply_type IN NUMBER DEFAULT G_MISS_NUM
1557 ,p_wip_supply_subinventory IN VARCHAR2 DEFAULT G_MISS_CHAR
1558 ,p_wip_supply_locator_id IN NUMBER DEFAULT G_MISS_NUM
1559 ,p_overcompletion_tolerance_ty IN NUMBER DEFAULT G_MISS_NUM
1560 ,p_overcompletion_tolerance_va IN NUMBER DEFAULT G_MISS_NUM
1561 ,p_customer_order_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1562 ,p_customer_order_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1563 ,p_shippable_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1564 ,p_internal_order_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1565 ,p_internal_order_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1566 ,p_so_transactions_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1567 ,p_pick_components_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1568 ,p_atp_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1569 ,p_replenish_to_order_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1570 ,p_atp_rule_id IN NUMBER DEFAULT G_MISS_NUM
1571 ,p_atp_components_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1572 ,p_ship_model_complete_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1573 ,p_picking_rule_id IN NUMBER DEFAULT G_MISS_NUM
1574 ,p_collateral_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1575 ,p_default_shipping_org IN NUMBER DEFAULT G_MISS_NUM
1576 ,p_returnable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1577 ,p_return_inspection_requireme IN NUMBER DEFAULT G_MISS_NUM
1578 ,p_over_shipment_tolerance IN NUMBER DEFAULT G_MISS_NUM
1582 ,p_invoiceable_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1579 ,p_under_shipment_tolerance IN NUMBER DEFAULT G_MISS_NUM
1580 ,p_over_return_tolerance IN NUMBER DEFAULT G_MISS_NUM
1581 ,p_under_return_tolerance IN NUMBER DEFAULT G_MISS_NUM
1583 ,p_invoice_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1584 ,p_accounting_rule_id IN NUMBER DEFAULT G_MISS_NUM
1585 ,p_invoicing_rule_id IN NUMBER DEFAULT G_MISS_NUM
1586 ,p_tax_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1587 ,p_sales_account IN NUMBER DEFAULT G_MISS_NUM
1588 ,p_payment_terms_id IN NUMBER DEFAULT G_MISS_NUM
1589 ,p_coverage_schedule_id IN NUMBER DEFAULT G_MISS_NUM
1590 ,p_service_duration IN NUMBER DEFAULT G_MISS_NUM
1591 ,p_service_duration_period_cod IN VARCHAR2 DEFAULT G_MISS_CHAR
1592 ,p_serviceable_product_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1593 ,p_service_starting_delay IN NUMBER DEFAULT G_MISS_NUM
1594 ,p_material_billable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1595 ,p_serviceable_component_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1596 ,p_preventive_maintenance_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1597 ,p_prorate_service_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1598 -- Start attributes not in the form
1599 ,p_serviceable_item_class_id IN NUMBER DEFAULT G_MISS_NUM
1600 ,p_base_warranty_service_id IN NUMBER DEFAULT G_MISS_NUM
1601 ,p_warranty_vendor_id IN NUMBER DEFAULT G_MISS_NUM
1602 ,p_max_warranty_amount IN NUMBER DEFAULT G_MISS_NUM
1603 ,p_response_time_period_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1604 ,p_response_time_value IN NUMBER DEFAULT G_MISS_NUM
1605 ,p_primary_specialist_id IN NUMBER DEFAULT G_MISS_NUM
1606 ,p_secondary_specialist_id IN NUMBER DEFAULT G_MISS_NUM
1607 -- End attributes not in the form
1608 ,p_wh_update_date IN DATE DEFAULT G_MISS_DATE
1609 ,p_equipment_type IN NUMBER DEFAULT G_MISS_NUM
1610 ,p_recovered_part_disp_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1611 ,p_defect_tracking_on_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1612 ,p_event_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1613 ,p_electronic_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1614 ,p_downloadable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1615 ,p_vol_discount_exempt_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1616 ,p_coupon_exempt_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1617 ,p_comms_nl_trackable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1618 ,p_asset_creation_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1619 ,p_comms_activation_reqd_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1620 ,p_orderable_on_web_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1621 ,p_back_orderable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1622 ,p_web_status IN VARCHAR2 DEFAULT G_MISS_CHAR
1623 ,p_indivisible_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1624 ,p_dimension_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1625 ,p_unit_length IN NUMBER DEFAULT G_MISS_NUM
1626 ,p_unit_width IN NUMBER DEFAULT G_MISS_NUM
1627 ,p_unit_height IN NUMBER DEFAULT G_MISS_NUM
1628 ,p_bulk_picked_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1629 ,p_lot_status_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
1630 ,p_default_lot_status_id IN NUMBER DEFAULT G_MISS_NUM
1631 ,p_serial_status_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
1632 ,p_default_serial_status_id IN NUMBER DEFAULT G_MISS_NUM
1633 ,p_lot_split_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
1634 ,p_lot_merge_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
1635 ,p_inventory_carry_penalty IN NUMBER DEFAULT G_MISS_NUM
1636 ,p_operation_slack_penalty IN NUMBER DEFAULT G_MISS_NUM
1637 ,p_financing_allowed_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1638 ,p_eam_item_type IN NUMBER DEFAULT G_MISS_NUM
1639 ,p_eam_activity_type_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1640 ,p_eam_activity_cause_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1641 ,p_eam_act_notification_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1642 ,p_eam_act_shutdown_status IN VARCHAR2 DEFAULT G_MISS_CHAR
1643 ,p_dual_uom_control IN NUMBER DEFAULT G_MISS_NUM
1644 ,p_secondary_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1645 ,p_dual_uom_deviation_high IN NUMBER DEFAULT G_MISS_NUM
1646 ,p_dual_uom_deviation_low IN NUMBER DEFAULT G_MISS_NUM
1647 ,p_contract_item_type_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1648 ,p_subscription_depend_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1649 ,p_serv_req_enabled_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1650 ,p_serv_billing_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1651 ,p_serv_importance_level IN NUMBER DEFAULT G_MISS_NUM
1652 ,p_planned_inv_point_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1653 ,p_lot_translate_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
1654 ,p_default_so_source_type IN VARCHAR2 DEFAULT G_MISS_CHAR
1655 ,p_create_supply_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1659 ,p_config_model_type IN VARCHAR2 DEFAULT G_MISS_CHAR
1656 ,p_substitution_window_code IN NUMBER DEFAULT G_MISS_NUM
1657 ,p_substitution_window_days IN NUMBER DEFAULT G_MISS_NUM
1658 ,p_ib_item_instance_class IN VARCHAR2 DEFAULT G_MISS_CHAR
1660 ,p_lot_substitution_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
1661 ,p_minimum_license_quantity IN NUMBER DEFAULT G_MISS_NUM
1662 ,p_eam_activity_source_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1663 ,p_approval_status IN VARCHAR2 DEFAULT G_MISS_CHAR
1664 --Start: 26 new attributes
1665 ,p_tracking_quantity_ind IN VARCHAR2 DEFAULT G_MISS_CHAR
1666 ,p_ont_pricing_qty_source IN VARCHAR2 DEFAULT G_MISS_CHAR
1667 ,p_secondary_default_ind IN VARCHAR2 DEFAULT G_MISS_CHAR
1668 ,p_option_specific_sourced IN NUMBER DEFAULT G_MISS_NUM
1669 ,p_vmi_minimum_units IN NUMBER DEFAULT G_MISS_NUM
1670 ,p_vmi_minimum_days IN NUMBER DEFAULT G_MISS_NUM
1671 ,p_vmi_maximum_units IN NUMBER DEFAULT G_MISS_NUM
1672 ,p_vmi_maximum_days IN NUMBER DEFAULT G_MISS_NUM
1673 ,p_vmi_fixed_order_quantity IN NUMBER DEFAULT G_MISS_NUM
1674 ,p_so_authorization_flag IN NUMBER DEFAULT G_MISS_NUM
1675 ,p_consigned_flag IN NUMBER DEFAULT G_MISS_NUM
1676 ,p_asn_autoexpire_flag IN NUMBER DEFAULT G_MISS_NUM
1677 ,p_vmi_forecast_type IN NUMBER DEFAULT G_MISS_NUM
1678 ,p_forecast_horizon IN NUMBER DEFAULT G_MISS_NUM
1679 ,p_exclude_from_budget_flag IN NUMBER DEFAULT G_MISS_NUM
1680 ,p_days_tgt_inv_supply IN NUMBER DEFAULT G_MISS_NUM
1681 ,p_days_tgt_inv_window IN NUMBER DEFAULT G_MISS_NUM
1682 ,p_days_max_inv_supply IN NUMBER DEFAULT G_MISS_NUM
1683 ,p_days_max_inv_window IN NUMBER DEFAULT G_MISS_NUM
1684 ,p_drp_planned_flag IN NUMBER DEFAULT G_MISS_NUM
1685 ,p_critical_component_flag IN NUMBER DEFAULT G_MISS_NUM
1686 ,p_continous_transfer IN NUMBER DEFAULT G_MISS_NUM
1687 ,p_convergence IN NUMBER DEFAULT G_MISS_NUM
1688 ,p_divergence IN NUMBER DEFAULT G_MISS_NUM
1689 ,p_config_orgs IN VARCHAR2 DEFAULT G_MISS_CHAR
1690 ,p_config_match IN VARCHAR2 DEFAULT G_MISS_CHAR
1691 --End: 26 new attributes
1692 ,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
1693 ,p_segment1 IN VARCHAR2 DEFAULT G_MISS_CHAR
1694 ,p_segment2 IN VARCHAR2 DEFAULT G_MISS_CHAR
1695 ,p_segment3 IN VARCHAR2 DEFAULT G_MISS_CHAR
1696 ,p_segment4 IN VARCHAR2 DEFAULT G_MISS_CHAR
1697 ,p_segment5 IN VARCHAR2 DEFAULT G_MISS_CHAR
1698 ,p_segment6 IN VARCHAR2 DEFAULT G_MISS_CHAR
1699 ,p_segment7 IN VARCHAR2 DEFAULT G_MISS_CHAR
1700 ,p_segment8 IN VARCHAR2 DEFAULT G_MISS_CHAR
1701 ,p_segment9 IN VARCHAR2 DEFAULT G_MISS_CHAR
1702 ,p_segment10 IN VARCHAR2 DEFAULT G_MISS_CHAR
1703 ,p_segment11 IN VARCHAR2 DEFAULT G_MISS_CHAR
1704 ,p_segment12 IN VARCHAR2 DEFAULT G_MISS_CHAR
1705 ,p_segment13 IN VARCHAR2 DEFAULT G_MISS_CHAR
1706 ,p_segment14 IN VARCHAR2 DEFAULT G_MISS_CHAR
1707 ,p_segment15 IN VARCHAR2 DEFAULT G_MISS_CHAR
1708 ,p_segment16 IN VARCHAR2 DEFAULT G_MISS_CHAR
1709 ,p_segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1710 ,p_segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1711 ,p_segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1712 ,p_segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1713 ,p_summary_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1714 ,p_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
1715 ,p_start_date_active IN DATE DEFAULT G_MISS_DATE
1716 ,p_end_date_active IN DATE DEFAULT G_MISS_DATE
1717 ,p_attribute_category IN VARCHAR2 DEFAULT G_MISS_CHAR
1718 ,p_attribute1 IN VARCHAR2 DEFAULT G_MISS_CHAR
1719 ,p_attribute2 IN VARCHAR2 DEFAULT G_MISS_CHAR
1720 ,p_attribute3 IN VARCHAR2 DEFAULT G_MISS_CHAR
1721 ,p_attribute4 IN VARCHAR2 DEFAULT G_MISS_CHAR
1722 ,p_attribute5 IN VARCHAR2 DEFAULT G_MISS_CHAR
1723 ,p_attribute6 IN VARCHAR2 DEFAULT G_MISS_CHAR
1724 ,p_attribute7 IN VARCHAR2 DEFAULT G_MISS_CHAR
1725 ,p_attribute8 IN VARCHAR2 DEFAULT G_MISS_CHAR
1726 ,p_attribute9 IN VARCHAR2 DEFAULT G_MISS_CHAR
1727 ,p_attribute10 IN VARCHAR2 DEFAULT G_MISS_CHAR
1728 ,p_attribute11 IN VARCHAR2 DEFAULT G_MISS_CHAR
1729 ,p_attribute12 IN VARCHAR2 DEFAULT G_MISS_CHAR
1730 ,p_attribute13 IN VARCHAR2 DEFAULT G_MISS_CHAR
1731 ,p_attribute14 IN VARCHAR2 DEFAULT G_MISS_CHAR
1732 ,p_attribute15 IN VARCHAR2 DEFAULT G_MISS_CHAR
1736 ,p_attribute19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1733 ,p_attribute16 IN VARCHAR2 DEFAULT G_MISS_CHAR
1734 ,p_attribute17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1735 ,p_attribute18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1737 ,p_attribute20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1738 ,p_attribute21 IN VARCHAR2 DEFAULT G_MISS_CHAR
1739 ,p_attribute22 IN VARCHAR2 DEFAULT G_MISS_CHAR
1740 ,p_attribute23 IN VARCHAR2 DEFAULT G_MISS_CHAR
1741 ,p_attribute24 IN VARCHAR2 DEFAULT G_MISS_CHAR
1742 ,p_attribute25 IN VARCHAR2 DEFAULT G_MISS_CHAR
1743 ,p_attribute26 IN VARCHAR2 DEFAULT G_MISS_CHAR
1744 ,p_attribute27 IN VARCHAR2 DEFAULT G_MISS_CHAR
1745 ,p_attribute28 IN VARCHAR2 DEFAULT G_MISS_CHAR
1746 ,p_attribute29 IN VARCHAR2 DEFAULT G_MISS_CHAR
1747 ,p_attribute30 IN VARCHAR2 DEFAULT G_MISS_CHAR
1748 ,p_global_attribute_category IN VARCHAR2 DEFAULT G_MISS_CHAR
1749 ,p_global_attribute1 IN VARCHAR2 DEFAULT G_MISS_CHAR
1750 ,p_global_attribute2 IN VARCHAR2 DEFAULT G_MISS_CHAR
1751 ,p_global_attribute3 IN VARCHAR2 DEFAULT G_MISS_CHAR
1752 ,p_global_attribute4 IN VARCHAR2 DEFAULT G_MISS_CHAR
1753 ,p_global_attribute5 IN VARCHAR2 DEFAULT G_MISS_CHAR
1754 ,p_global_attribute6 IN VARCHAR2 DEFAULT G_MISS_CHAR
1755 ,p_global_attribute7 IN VARCHAR2 DEFAULT G_MISS_CHAR
1756 ,p_global_attribute8 IN VARCHAR2 DEFAULT G_MISS_CHAR
1757 ,p_global_attribute9 IN VARCHAR2 DEFAULT G_MISS_CHAR
1758 ,p_global_attribute10 IN VARCHAR2 DEFAULT G_MISS_CHAR
1759 ,p_global_attribute11 IN VARCHAR2 DEFAULT G_MISS_CHAR
1760 ,p_global_attribute12 IN VARCHAR2 DEFAULT G_MISS_CHAR
1761 ,p_global_attribute13 IN VARCHAR2 DEFAULT G_MISS_CHAR
1762 ,p_global_attribute14 IN VARCHAR2 DEFAULT G_MISS_CHAR
1763 ,p_global_attribute15 IN VARCHAR2 DEFAULT G_MISS_CHAR
1764 ,p_global_attribute16 IN VARCHAR2 DEFAULT G_MISS_CHAR
1765 ,p_global_attribute17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1766 ,p_global_attribute18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1767 ,p_global_attribute19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1768 ,p_global_attribute20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1769 ,p_creation_date IN DATE DEFAULT G_MISS_DATE
1770 ,p_created_by IN NUMBER DEFAULT G_MISS_NUM
1771 ,p_last_update_date IN DATE DEFAULT G_MISS_DATE
1772 ,p_last_updated_by IN NUMBER DEFAULT G_MISS_NUM
1773 ,p_last_update_login IN NUMBER DEFAULT G_MISS_NUM
1774 ,p_request_id IN NUMBER DEFAULT G_MISS_NUM
1775 ,p_program_application_id IN NUMBER DEFAULT G_MISS_NUM
1776 ,p_program_id IN NUMBER DEFAULT G_MISS_NUM
1777 ,p_program_update_date IN DATE DEFAULT G_MISS_DATE
1778 ,p_lifecycle_id IN NUMBER DEFAULT G_MISS_NUM
1779 ,p_current_phase_id IN NUMBER DEFAULT G_MISS_NUM
1780 -- Revision attribute parameter
1781 ,p_revision_id IN NUMBER DEFAULT G_MISS_NUM
1782 ,p_revision_code IN VARCHAR2 DEFAULT G_MISS_CHAR
1783 ,p_revision_label IN VARCHAR2 DEFAULT G_MISS_CHAR
1784 ,p_revision_description IN VARCHAR2 DEFAULT G_MISS_CHAR
1785 ,p_effectivity_Date IN DATE DEFAULT G_MISS_DATE
1786 ,p_rev_lifecycle_id IN NUMBER DEFAULT G_MISS_NUM
1787 ,p_rev_current_phase_id IN NUMBER DEFAULT G_MISS_NUM
1788 -- 5208102: Supporting template for UDA's at revisions
1789 ,p_rev_template_id IN NUMBER DEFAULT G_MISS_NUM
1790 ,p_rev_template_name IN VARCHAR2 DEFAULT G_MISS_CHAR
1791
1792 ,p_rev_attribute_category IN VARCHAR2 DEFAULT G_MISS_CHAR
1793 ,p_rev_attribute1 IN VARCHAR2 DEFAULT G_MISS_CHAR
1794 ,p_rev_attribute2 IN VARCHAR2 DEFAULT G_MISS_CHAR
1795 ,p_rev_attribute3 IN VARCHAR2 DEFAULT G_MISS_CHAR
1796 ,p_rev_attribute4 IN VARCHAR2 DEFAULT G_MISS_CHAR
1797 ,p_rev_attribute5 IN VARCHAR2 DEFAULT G_MISS_CHAR
1798 ,p_rev_attribute6 IN VARCHAR2 DEFAULT G_MISS_CHAR
1799 ,p_rev_attribute7 IN VARCHAR2 DEFAULT G_MISS_CHAR
1800 ,p_rev_attribute8 IN VARCHAR2 DEFAULT G_MISS_CHAR
1801 ,p_rev_attribute9 IN VARCHAR2 DEFAULT G_MISS_CHAR
1802 ,p_rev_attribute10 IN VARCHAR2 DEFAULT G_MISS_CHAR
1803 ,p_rev_attribute11 IN VARCHAR2 DEFAULT G_MISS_CHAR
1804 ,p_rev_attribute12 IN VARCHAR2 DEFAULT G_MISS_CHAR
1805 ,p_rev_attribute13 IN VARCHAR2 DEFAULT G_MISS_CHAR
1806 ,p_rev_attribute14 IN VARCHAR2 DEFAULT G_MISS_CHAR
1807 ,p_rev_attribute15 IN VARCHAR2 DEFAULT G_MISS_CHAR
1808 -- Returned item ID
1809 ,x_Inventory_Item_Id OUT NOCOPY NUMBER
1813 ,x_msg_data OUT NOCOPY VARCHAR2
1810 ,x_Organization_Id OUT NOCOPY NUMBER
1811 ,x_return_status OUT NOCOPY VARCHAR2
1812 ,x_msg_count OUT NOCOPY NUMBER
1814 ,p_apply_template IN VARCHAR2 DEFAULT 'ALL'
1815 ,p_object_version_number IN NUMBER DEFAULT G_MISS_NUM
1816 ,p_process_control IN VARCHAR2 DEFAULT NULL --Bug:3777954
1817 ,p_process_item IN NUMBER DEFAULT G_MISS_NUM
1818
1819 /* R12 Attributes */
1820 ,P_CAS_NUMBER IN VARCHAR2 DEFAULT G_MISS_CHAR
1821 ,P_CHILD_LOT_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1822 ,P_CHILD_LOT_PREFIX IN VARCHAR2 DEFAULT G_MISS_CHAR
1823 ,P_CHILD_LOT_STARTING_NUMBER IN NUMBER DEFAULT G_MISS_NUM
1824 ,P_CHILD_LOT_VALIDATION_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1825 ,P_COPY_LOT_ATTRIBUTE_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1826 ,P_DEFAULT_GRADE IN VARCHAR2 DEFAULT G_MISS_CHAR
1827 ,P_EXPIRATION_ACTION_CODE IN VARCHAR2 DEFAULT G_MISS_CHAR
1828 ,P_EXPIRATION_ACTION_INTERVAL IN NUMBER DEFAULT G_MISS_NUM
1829 ,P_GRADE_CONTROL_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1830 ,P_HAZARDOUS_MATERIAL_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1831 ,P_HOLD_DAYS IN NUMBER DEFAULT G_MISS_NUM
1832 ,P_LOT_DIVISIBLE_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1833 ,P_MATURITY_DAYS IN NUMBER DEFAULT G_MISS_NUM
1834 ,P_PARENT_CHILD_GENERATION_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1835 ,P_PROCESS_COSTING_ENABLED_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1836 ,P_PROCESS_EXECUTION_ENABLED_FL IN VARCHAR2 DEFAULT G_MISS_CHAR
1837 ,P_PROCESS_QUALITY_ENABLED_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1838 ,P_PROCESS_SUPPLY_LOCATOR_ID IN NUMBER DEFAULT G_MISS_NUM
1839 ,P_PROCESS_SUPPLY_SUBINVENTORY IN VARCHAR2 DEFAULT G_MISS_CHAR
1840 ,P_PROCESS_YIELD_LOCATOR_ID IN NUMBER DEFAULT G_MISS_NUM
1841 ,P_PROCESS_YIELD_SUBINVENTORY IN VARCHAR2 DEFAULT G_MISS_CHAR
1842 ,P_RECIPE_ENABLED_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1843 ,P_RETEST_INTERVAL IN NUMBER DEFAULT G_MISS_NUM
1844 ,P_CHARGE_PERIODICITY_CODE IN VARCHAR2 DEFAULT G_MISS_CHAR
1845 ,P_REPAIR_LEADTIME IN NUMBER DEFAULT G_MISS_NUM
1846 ,P_REPAIR_YIELD IN NUMBER DEFAULT G_MISS_NUM
1847 ,P_PREPOSITION_POINT IN VARCHAR2 DEFAULT G_MISS_CHAR
1848 ,P_REPAIR_PROGRAM IN NUMBER DEFAULT G_MISS_NUM
1849 ,P_SUBCONTRACTING_COMPONENT IN NUMBER DEFAULT G_MISS_NUM
1850 ,P_OUTSOURCED_ASSEMBLY IN NUMBER DEFAULT G_MISS_NUM
1851 -- R12 C Attributes
1852 ,P_GDSN_OUTBOUND_ENABLED_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1853 ,P_TRADE_ITEM_DESCRIPTOR IN VARCHAR2 DEFAULT G_MISS_CHAR
1854 ,P_STYLE_ITEM_FLAG IN VARCHAR2 DEFAULT G_MISS_CHAR
1855 ,P_STYLE_ITEM_ID IN NUMBER DEFAULT G_MISS_NUM);
1856
1857 /*#
1858 * Use this API to assign multiple items to organizations. The
1859 * table type passed in p_item_org_assignment_tbl is as follows:
1860 *<code><pre>
1861 TYPE Item_Org_Assignment_Tbl_Type IS TABLE OF Item_Org_Assignment_Rec_Type
1862 INDEX BY BINARY_INTEGER;
1863
1864 TYPE Item_Org_Assignment_Rec_Type IS RECORD
1865 (
1866 Return_Status VARCHAR2(1) := G_MISS_CHAR
1867 ,Inventory_Item_Id NUMBER := G_MISS_NUM
1868 ,Item_Number VARCHAR2(2000) := G_MISS_CHAR
1869 ,Organization_Id NUMBER := G_MISS_NUM
1870 ,Organization_Code VARCHAR2(3) := G_MISS_CHAR
1871 ,Primary_Uom_Code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE := G_MISS_CHAR
1872 );
1873 *</pre></code>
1874 * @param p_api_version A decimal number indicating revisions to
1875 * the API. Pass the number indicated in the package description
1876 * above.
1877 * @param p_init_msg_list A flag indicating whether to initialize
1878 * the FND_MSG_PUB package's message stack. Refer to the package
1879 * description above for more information about this parameter and
1880 * a list of valid values.
1881 * @param p_commit A flag indicating whether to commit work at the
1882 * end of API processing. Refer to the package description above
1883 * for more information about this parameter and a list of valid
1884 * values.
1885 * @param p_item_org_assignment_tbl Each record in this PL/SQL
1886 * table corresponds to one assignment of an item to an organization;
1887 * refer to API description for the record type declaration.
1888 * @param x_return_status A code indicating whether any errors
1889 * occurred during processing. Refer to the package description
1890 * above for more information about this parameter and a list of
1891 * valid values.
1892 * @param x_msg_count An integer indicating the number of messages
1893 * on the FND_MSG_PUB package's message stack at the end of API
1894 * processing. Refer to the package description above for more
1895 * information about this parameter.
1896 * @rep:scope public
1897 * @rep:lifecycle active
1898 * @rep:displayname Process Item Organization Assignments
1899 */
1900 PROCEDURE Process_Item_Org_Assignments(
1901 p_api_version IN NUMBER
1902 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
1903 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
1904 ,p_Item_Org_Assignment_Tbl IN EGO_Item_PUB.Item_Org_Assignment_Tbl_Type
1908 /*#
1905 ,x_return_status OUT NOCOPY VARCHAR2
1906 ,x_msg_count OUT NOCOPY NUMBER);
1907
1909 * Use this API to assign an item to an organization.
1910 * @param p_api_version A decimal number indicating revisions to
1911 * the API. Pass the number indicated in the package description
1912 * above.
1913 * @param p_init_msg_list A flag indicating whether to initialize
1914 * the FND_MSG_PUB package's message stack. Refer to the package
1915 * description above for more information about this parameter and
1916 * a list of valid values.
1917 * @param p_commit A flag indicating whether to commit work at the
1918 * end of API processing. Refer to the package description above
1919 * for more information about this parameter and a list of valid
1920 * values.
1921 * @param p_primary_uom_code E.g., 'EA' for 'Each' or 'FT' for 'Foot'.
1922 * @param x_return_status A code indicating whether any errors
1923 * occurred during processing. Refer to the package description
1924 * above for more information about this parameter and a list of
1925 * valid values.
1926 * @param x_msg_count An integer indicating the number of messages
1927 * on the FND_MSG_PUB package's message stack at the end of API
1928 * processing. Refer to the package description above for more
1929 * information about this parameter.
1930 * @rep:scope public
1931 * @rep:lifecycle active
1932 * @rep:displayname Assign Item to Organization
1933 */
1934 PROCEDURE Assign_Item_To_Org(
1935 p_api_version IN NUMBER
1936 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
1937 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
1938 ,p_Inventory_Item_Id IN NUMBER DEFAULT G_MISS_NUM
1939 ,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
1940 ,p_Organization_Id IN NUMBER DEFAULT G_MISS_NUM
1941 ,p_Organization_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
1942 ,p_Primary_Uom_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
1943 ,x_return_status OUT NOCOPY VARCHAR2
1944 ,x_msg_count OUT NOCOPY NUMBER);
1945
1946 PROCEDURE Update_Item_Number(
1947 p_Inventory_Item_Id IN NUMBER
1948 ,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
1949 ,p_Segment1 IN VARCHAR2 DEFAULT G_MISS_CHAR
1950 ,p_Segment2 IN VARCHAR2 DEFAULT G_MISS_CHAR
1951 ,p_Segment3 IN VARCHAR2 DEFAULT G_MISS_CHAR
1952 ,p_Segment4 IN VARCHAR2 DEFAULT G_MISS_CHAR
1953 ,p_Segment5 IN VARCHAR2 DEFAULT G_MISS_CHAR
1954 ,p_Segment6 IN VARCHAR2 DEFAULT G_MISS_CHAR
1955 ,p_Segment7 IN VARCHAR2 DEFAULT G_MISS_CHAR
1956 ,p_Segment8 IN VARCHAR2 DEFAULT G_MISS_CHAR
1957 ,p_Segment9 IN VARCHAR2 DEFAULT G_MISS_CHAR
1958 ,p_Segment10 IN VARCHAR2 DEFAULT G_MISS_CHAR
1959 ,p_Segment11 IN VARCHAR2 DEFAULT G_MISS_CHAR
1960 ,p_Segment12 IN VARCHAR2 DEFAULT G_MISS_CHAR
1961 ,p_Segment13 IN VARCHAR2 DEFAULT G_MISS_CHAR
1962 ,p_Segment14 IN VARCHAR2 DEFAULT G_MISS_CHAR
1963 ,p_Segment15 IN VARCHAR2 DEFAULT G_MISS_CHAR
1964 ,p_Segment16 IN VARCHAR2 DEFAULT G_MISS_CHAR
1965 ,p_Segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1966 ,p_Segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1967 ,p_Segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1968 ,p_Segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1969 ,p_New_Segment1 IN VARCHAR2 DEFAULT G_MISS_CHAR
1970 ,p_New_Segment2 IN VARCHAR2 DEFAULT G_MISS_CHAR
1971 ,p_New_Segment3 IN VARCHAR2 DEFAULT G_MISS_CHAR
1972 ,p_New_Segment4 IN VARCHAR2 DEFAULT G_MISS_CHAR
1973 ,p_New_Segment5 IN VARCHAR2 DEFAULT G_MISS_CHAR
1974 ,p_New_Segment6 IN VARCHAR2 DEFAULT G_MISS_CHAR
1975 ,p_New_Segment7 IN VARCHAR2 DEFAULT G_MISS_CHAR
1976 ,p_New_Segment8 IN VARCHAR2 DEFAULT G_MISS_CHAR
1977 ,p_New_Segment9 IN VARCHAR2 DEFAULT G_MISS_CHAR
1978 ,p_New_Segment10 IN VARCHAR2 DEFAULT G_MISS_CHAR
1979 ,p_New_Segment11 IN VARCHAR2 DEFAULT G_MISS_CHAR
1980 ,p_New_Segment12 IN VARCHAR2 DEFAULT G_MISS_CHAR
1981 ,p_New_Segment13 IN VARCHAR2 DEFAULT G_MISS_CHAR
1982 ,p_New_Segment14 IN VARCHAR2 DEFAULT G_MISS_CHAR
1983 ,p_New_Segment15 IN VARCHAR2 DEFAULT G_MISS_CHAR
1984 ,p_New_Segment16 IN VARCHAR2 DEFAULT G_MISS_CHAR
1985 ,p_New_Segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
1986 ,p_New_Segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
1987 ,p_New_Segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
1988 ,p_New_Segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
1989 ,x_Item_Tbl IN OUT NOCOPY EGO_Item_PUB.Item_Tbl_Type
1990 ,x_return_status OUT NOCOPY VARCHAR2);
1991
1992 PROCEDURE Seed_Item_Long_Desc_Attr_Group (
1993 p_inventory_item_id IN NUMBER
1994 ,p_organization_id IN NUMBER
1995 ,p_item_catalog_group_id IN NUMBER
1996 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
1997 ,x_return_status OUT NOCOPY VARCHAR2
1998 ,x_errorcode OUT NOCOPY NUMBER
2002 PROCEDURE Seed_Item_Long_Desc_In_Bulk (
1999 ,x_msg_count OUT NOCOPY NUMBER
2000 ,x_msg_data OUT NOCOPY VARCHAR2);
2001
2003 p_set_process_id IN NUMBER
2004 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2005 ,x_return_status OUT NOCOPY VARCHAR2
2006 ,x_msg_data OUT NOCOPY VARCHAR2);
2007
2008
2009 /*#
2010 * Use this API to insert, update, or delete one or more rows of
2011 * user-defined attributes data for one item. Note: This API is a
2012 * wrapper for an API in the EGO_USER_ATTRS_DATA_PUB package, which
2013 * uses the ERROR_HANDLER package; more information is available in
2014 * the EGO_USER_ATTRS_DATA_PUB and ERROR_HANDLER package specifications.
2015 * @param p_api_version A decimal number indicating revisions to
2016 * the API. Pass the number indicated in the package description
2017 * above.
2018 * @param p_attributes_row_table Contains row-level data and metadata
2019 * about each attribute group that is processed. See
2020 * EGO_USER_ATTRS_DATA_PUB for details.
2021 * @param p_attributes_data_table Contains data and metadata about each
2022 * attribute that is processed. Refer to EGO_USER_ATTRS_DATA_PUB
2023 * for details.
2024 * @param p_entity_id Used in error reporting; refer to ERROR_HANDLER
2025 * for details.
2026 * @param p_entity_index Used in error reporting; refer to ERROR_HANDLER
2027 * for details.
2028 * @param p_entity_code Used in error reporting; refer to ERROR_HANDLER
2029 * for details.
2030 * @param p_debug_level Used in debugging; refer to EGO_USER_ATTRS_DATA_PUB
2031 * for details.
2032 * @param p_init_error_handler Indicates whether to initialize
2033 * ERROR_HANDLER message stack (and open debug session, if applicable).
2034 * @param p_write_to_concurrent_log Indicates whether to log ERROR_HANDLER
2035 * messages to concurrent log (only applicable when called from concurrent
2036 * program and when p_log_errors is passed as FND_API.G_TRUE).
2037 * @param p_init_fnd_msg_list Indicates whether to initialize FND_MSG_PUB
2038 * message stack. Refer to the package description of the parameter
2039 * 'p_init_msg_list' above for more information about this parameter
2040 * and a list of valid values.
2041 * @param p_log_errors Indicates whether to write ERROR_HANDLER message
2042 * stack to MTL_INTERFACE_ERRORS, concurrent log (if applicable), and
2043 * debug file (if applicable); if FND_API.G_FALSE is passed, messages
2044 * will still be added to ERROR_HANDLER, but the message stack will not
2045 * be written to any destination.
2046 * @param p_add_errors_to_fnd_stack Indicates whether messages written
2047 * to ERROR_HANDLER message stack will also be written to FND_MSG_PUB
2048 * message stack.
2049 * @param p_commit A flag indicating whether to commit work at the
2050 * end of API processing. Refer to the package description above
2051 * for more information about this parameter and a list of valid
2052 * values.
2053 * @param x_failed_row_id_list Returns a comma-delimited list of
2054 * ROW_IDENTIFIERs indicating which attribute group rows failed to be
2055 * processed.
2056 * @param x_return_status A code indicating whether any errors
2057 * occurred during processing. Refer to the package description
2058 * above for more information about this parameter and a list of
2059 * valid values.
2060 * @param x_errorcode Reserved for future use.
2061 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
2062 * message stack upon completion of processing.
2063 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
2064 * message stack upon completion of processing, this parameter contains
2065 * that message.
2066 * @rep:scope public
2067 * @rep:lifecycle active
2068 * @rep:displayname Process User-Defined Attributes for Item
2069 * @rep:businessevent oracle.apps.ego.item.postAttributeChange
2070 */
2071 PROCEDURE Process_User_Attrs_For_Item (
2072 p_api_version IN NUMBER
2073 ,p_inventory_item_id IN NUMBER
2074 ,p_organization_id IN NUMBER
2075 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
2076 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
2077 ,p_entity_id IN NUMBER DEFAULT NULL
2078 ,p_entity_index IN NUMBER DEFAULT NULL
2079 ,p_entity_code IN VARCHAR2 DEFAULT NULL
2080 ,p_debug_level IN NUMBER DEFAULT 0
2081 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2082 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
2083 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2084 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
2085 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2086 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2087 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
2088 ,x_return_status OUT NOCOPY VARCHAR2
2089 ,x_errorcode OUT NOCOPY NUMBER
2090 ,x_msg_count OUT NOCOPY NUMBER
2091 ,x_msg_data OUT NOCOPY VARCHAR2);
2092
2093 /*#
2094 * Use this API to retrieve one or more rows of user-defined attributes
2095 * data for one item. Note: This API is a wrapper for an API in the
2096 * EGO_USER_ATTRS_DATA_PUB package, which uses the ERROR_HANDLER
2097 * package; more information is available in the EGO_USER_ATTRS_DATA_PUB
2101 * above.
2098 * and ERROR_HANDLER package specifications.
2099 * @param p_api_version A decimal number indicating revisions to
2100 * the API. Pass the number indicated in the package description
2102 * @param p_attr_group_request_table Contains a list of elements, each
2103 * of which identifies an attribute group whose data to retrieve. Refer
2104 * to EGO_USER_ATTRS_DATA_PUB for details about this data type and its
2105 * usage.
2106 * @param p_entity_id Used in error reporting; refer to ERROR_HANDLER
2107 * for details.
2108 * @param p_entity_index Used in error reporting; refer to ERROR_HANDLER
2109 * for details.
2110 * @param p_entity_code Used in error reporting; refer to ERROR_HANDLER
2111 * for details.
2112 * @param p_debug_level Used in debugging; refer to EGO_USER_ATTRS_DATA_PUB
2113 * for details.
2114 * @param p_init_error_handler Indicates whether to initialize
2115 * ERROR_HANDLER message stack (and open debug session, if applicable).
2116 * @param p_init_fnd_msg_list Indicates whether to initialize FND_MSG_PUB
2117 * message stack. Refer to the package description of the parameter
2118 * 'p_init_msg_list' above for more information about this parameter
2119 * and a list of valid values.
2120 * @param p_add_errors_to_fnd_stack Indicates whether messages written
2121 * to ERROR_HANDLER message stack will also be written to FND_MSG_PUB
2122 * message stack.
2123 * @param p_commit A flag indicating whether to commit work at the
2124 * end of API processing (but since this API currently performs no
2125 * DML operations, this parameter is reserved for future use).
2126 * for more information about this parameter and a list of valid
2127 * values.
2128 * @param x_attributes_row_table Contains row-level data and metadata
2129 * about each attribute group row that was requested for the specified
2130 * item. See EGO_USER_ATTRS_DATA_PUB for details.
2131 * @param x_attributes_data_table Contains data and metadata about each
2132 * attribute in each attribute group row that was requested for the
2133 * specified item. Refer to EGO_USER_ATTRS_DATA_PUB for details.
2134 * @param x_return_status A code indicating whether any errors
2135 * occurred during processing. Refer to the package description
2136 * above for more information about this parameter and a list of
2137 * valid values.
2138 * @param x_errorcode Reserved for future use.
2139 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
2140 * message stack upon completion of processing.
2141 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
2142 * message stack upon completion of processing, this parameter contains
2143 * that message.
2144 * @rep:scope public
2145 * @rep:lifecycle active
2146 * @rep:displayname Get User-Defined Attributes for Item
2147 */
2148 PROCEDURE Get_User_Attrs_For_Item (
2149 p_api_version IN NUMBER
2150 ,p_inventory_item_id IN NUMBER
2151 ,p_organization_id IN NUMBER
2152 ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
2153 ,p_entity_id IN NUMBER DEFAULT NULL
2154 ,p_entity_index IN NUMBER DEFAULT NULL
2155 ,p_entity_code IN VARCHAR2 DEFAULT NULL
2156 ,p_debug_level IN NUMBER DEFAULT 0
2157 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2158 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2159 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
2160 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2161 ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
2162 ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
2163 ,x_return_status OUT NOCOPY VARCHAR2
2164 ,x_errorcode OUT NOCOPY NUMBER
2165 ,x_msg_count OUT NOCOPY NUMBER
2166 ,x_msg_data OUT NOCOPY VARCHAR2);
2167
2168 PROCEDURE Update_Item_Approval_Status (
2169 p_inventory_item_id IN NUMBER
2170 ,p_organization_id IN NUMBER
2171 ,p_approval_status IN VARCHAR2
2172 ,p_nir_id IN NUMBER DEFAULT NULL
2173 ,p_commit IN VARCHAR2 DEFAULT G_FALSE);
2174
2175 Procedure Process_Item_Lifecycle(
2176 P_API_VERSION IN NUMBER,
2177 P_INIT_MSG_LIST IN VARCHAR2,
2178 P_INVENTORY_ITEM_ID IN NUMBER,
2179 P_ORGANIZATION_ID IN NUMBER,
2180 P_CATALOG_GROUP_ID IN NUMBER,
2181 P_LIFECYCLE_ID IN NUMBER,
2182 P_CURRENT_PHASE_ID IN NUMBER,
2183 P_ITEM_STATUS IN VARCHAR2,
2184 P_TRANSACTION_TYPE IN VARCHAR2,
2185 P_COMMIT IN VARCHAR2 DEFAULT G_FALSE,
2186 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2187 X_MSG_COUNT OUT NOCOPY NUMBER);
2188
2189 Procedure Create_Item_Lifecycle(
2190 P_API_VERSION IN NUMBER,
2191 P_INIT_MSG_LIST IN VARCHAR2,
2192 P_INVENTORY_ITEM_ID IN NUMBER,
2193 P_ORGANIZATION_ID IN NUMBER,
2197 P_COMMIT IN VARCHAR2 DEFAULT G_FALSE,
2194 P_LIFECYCLE_ID IN NUMBER,
2195 P_CURRENT_PHASE_ID IN NUMBER,
2196 P_ITEM_STATUS IN VARCHAR2,
2198 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2199 X_MSG_COUNT OUT NOCOPY NUMBER);
2200
2201 Procedure Update_Item_Lifecycle(
2202 P_API_VERSION IN NUMBER,
2203 P_INIT_MSG_LIST IN VARCHAR2,
2204 P_INVENTORY_ITEM_ID IN NUMBER,
2205 P_ORGANIZATION_ID IN NUMBER,
2206 P_CATALOG_GROUP_ID IN NUMBER,
2207 P_LIFECYCLE_ID IN NUMBER,
2208 P_CURRENT_PHASE_ID IN NUMBER,
2209 P_ITEM_STATUS IN VARCHAR2,
2210 P_COMMIT IN VARCHAR2 DEFAULT G_FALSE,
2211 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2212 X_MSG_COUNT OUT NOCOPY NUMBER);
2213
2214 Procedure Update_Item_Attr_Ext(
2215 P_API_VERSION IN NUMBER,
2216 P_INIT_MSG_LIST IN VARCHAR2,
2217 P_INVENTORY_ITEM_ID IN NUMBER,
2218 P_ITEM_CATALOG_GROUP_ID IN NUMBER,
2219 P_COMMIT IN VARCHAR2 DEFAULT G_FALSE,
2220 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2221 X_MSG_COUNT OUT NOCOPY NUMBER);
2222
2223 FUNCTION Get_Master_Organization_Id(
2224 P_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
2225
2226 FUNCTION Get_Item_Attr_Control_Level(
2227 P_ITEM_ATTRIBUTE IN VARCHAR2) RETURN NUMBER;
2228
2229 FUNCTION Get_Item_Count (
2230 p_catalog_group_id IN NUMBER,
2231 p_organization_id IN NUMBER) RETURN NUMBER;
2232
2233 FUNCTION Get_Category_Item_Count(
2234 P_CATEGORY_SET_ID IN NUMBER,
2235 p_CATEGORY_ID IN NUMBER,
2236 P_ORGANIZATION_ID IN NUMBER) RETURN NUMBER;
2237
2238 FUNCTION Get_Category_Hierarchy_Names(
2239 P_CATEGORY_SET_ID IN NUMBER,
2240 P_CATEGORY_ID IN NUMBER) RETURN VARCHAR2;
2241
2242 -- Added for bug 3781216
2243 PROCEDURE Apply_Templ_User_Attrs_To_Item (
2244 p_api_version IN NUMBER
2245 ,p_mode IN VARCHAR2
2246 ,p_item_id IN NUMBER
2247 ,p_organization_id IN NUMBER
2248 ,p_template_id IN NUMBER
2249 ,p_object_name IN VARCHAR2
2250 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
2251 ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
2252 ,x_return_status OUT NOCOPY VARCHAR2
2253 ,x_errorcode OUT NOCOPY NUMBER
2254 ,x_msg_count OUT NOCOPY NUMBER
2255 ,x_msg_data OUT NOCOPY VARCHAR2);
2256
2257 PROCEDURE SYNC_IM_INDEX;
2258
2259 /*#
2260 * Use this API to create, update, or delete one role grant either
2261 * on an item or on an existing instance set.
2262 * @param p_api_version A decimal number indicating revisions to
2263 * the API. Pass the number indicated in the package description
2264 * above.
2265 * @param p_commit A flag indicating whether to commit work at the
2266 * end of API processing. Refer to the package description above
2267 * for more information about this parameter and a list of valid
2268 * values.
2269 * @param p_init_msg_list A flag indicating whether to initialize
2270 * the FND_MSG_PUB package's message stack. Refer to the package
2271 * description above for more information about this parameter and
2272 * a list of valid values.
2273 * @param p_transaction_type Valid values are G_TTYPE_CREATE,
2274 * G_TTYPE_UPDATE, and G_TTYPE_DELETE.
2275 * @param p_instance_type Valid values are G_INSTANCE_TYPE_INSTANCE
2276 * and G_INSTANCE_TYPE_SET.
2277 * @param p_party_type Valid values are G_USER_PARTY_TYPE,
2278 * G_GROUP_PARTY_TYPE, G_COMPANY_PARTY_TYPE, and G_ALL_USERS_PARTY_TYPE.
2279 * @param x_grant_guid Unique identifier of the grant; primary key for FND_GRANTS.
2280 * @param x_return_status A code indicating whether any errors
2281 * occurred during processing. Refer to the package description
2282 * above for more information about this parameter and a list of
2283 * valid values.
2284 * @param x_msg_count An integer indicating the number of messages
2285 * on the FND_MSG_PUB package's message stack at the end of API
2286 * processing. Refer to the package description above for more
2287 * information about this parameter.
2288 * @param x_msg_data A character string containing message text.
2289 * Refer to the package description above for more information
2290 * about this parameter and a list of valid values.
2291 * @rep:scope public
2292 * @rep:lifecycle active
2293 * @rep:displayname Process Item Role
2294 */
2295 PROCEDURE Process_item_role
2296 (p_api_version IN NUMBER
2300 ,p_inventory_item_id IN NUMBER DEFAULT NULL
2297 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2298 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
2299 ,p_transaction_type IN VARCHAR2 DEFAULT G_TTYPE_CREATE
2301 ,p_item_number IN VARCHAR2 DEFAULT NULL
2302 ,p_organization_id IN NUMBER DEFAULT NULL
2303 ,p_organization_code IN VARCHAR2 DEFAULT NULL
2304 ,p_role_id IN NUMBER DEFAULT NULL
2305 ,p_role_name IN VARCHAR2 DEFAULT NULL
2306 ,p_instance_type IN VARCHAR2 DEFAULT G_INSTANCE_TYPE_INSTANCE
2307 ,p_instance_set_id IN NUMBER DEFAULT NULL
2308 ,p_instance_set_name IN VARCHAR2 DEFAULT NULL
2309 ,p_party_type IN VARCHAR2 DEFAULT G_USER_PARTY_TYPE
2310 ,p_party_id IN NUMBER DEFAULT NULL
2311 ,p_party_name IN VARCHAR2 DEFAULT NULL
2312 ,p_start_date IN DATE DEFAULT NULL
2313 ,p_end_date IN DATE DEFAULT NULL
2314 ,x_grant_guid IN OUT NOCOPY RAW
2315 ,x_return_status OUT NOCOPY VARCHAR2
2316 ,x_msg_count OUT NOCOPY NUMBER
2317 ,x_msg_data OUT NOCOPY VARCHAR2
2318 );
2319
2320 /*#
2321 * Use this API to either change the status of an item or promote/demote
2322 * the lifecycle of an item/item revision.
2323 * @param p_api_version A decimal number indicating revisions to
2324 * the API. Pass the number indicated in the package description
2325 * above.
2326 * @param p_commit A flag indicating whether to commit work at the
2327 * end of API processing. Refer to the package description above
2328 * for more information about this parameter and a list of valid
2329 * values.
2330 * @param p_init_msg_list A flag indicating whether to initialize
2331 * the FND_MSG_PUB package's message stack. Refer to the package
2332 * description above for more information about this parameter and
2333 * a list of valid values.
2334 * @param p_transaction_type Valid values are G_TTYPE_UPDATE and
2335 * G_TTYPE_DELETE to modify an existing pending change, G_TTYPE_PROMOTE
2336 * and G_TTYPE_DEMOTE to change the phase of an item/item revision, or
2337 * G_TTYPE_CHANGE_STATUS to change the item status.
2338 * @param p_revision Revison code.
2339 * @param p_implement_changes The API always creates a pending
2340 * phase/status change; in addition, it can also implement all
2341 * pending changes for this item whose effective date is prior
2342 * to SYSDATE. Valid values are G_TRUE and G_FALSE.
2343 * @param p_status Status to which the item should be changed.
2344 * @param p_effective_date Date on or after which the phase/status
2345 * change can be implemented.
2346 * @param p_phase_id Primary key of the phase to which item should
2347 * be changed.
2348 * @param x_return_status A code indicating whether any errors
2349 * occurred during processing. Refer to the package description
2350 * above for more information about this parameter and a list of
2351 * valid values.
2352 * @param x_msg_count An integer indicating the number of messages
2353 * on the FND_MSG_PUB package's message stack at the end of API
2354 * processing. Refer to the package description above for more
2355 * information about this parameter.
2356 * @param x_msg_data A character string containing message text.
2357 * Refer to the package description above for more information
2358 * about this parameter and a list of valid values.
2359 * @rep:scope public
2360 * @rep:lifecycle active
2361 * @rep:displayname Process Item Phase and Status
2362 */
2363 PROCEDURE Process_item_phase_and_status
2364 (p_api_version IN NUMBER
2365 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2366 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
2367 ,p_transaction_type IN VARCHAR2 DEFAULT G_TTYPE_PROMOTE
2368 ,p_inventory_item_id IN NUMBER DEFAULT NULL
2369 ,p_item_number IN VARCHAR2 DEFAULT NULL
2370 ,p_organization_id IN NUMBER DEFAULT NULL
2371 ,p_organization_code IN VARCHAR2 DEFAULT NULL
2372 ,p_revision_id IN NUMBER DEFAULT NULL
2373 ,p_revision IN VARCHAR2 DEFAULT NULL
2374 ,p_implement_changes IN VARCHAR2 DEFAULT G_TRUE
2375 ,p_status IN VARCHAR2 DEFAULT NULL
2376 ,p_effective_date IN DATE DEFAULT NULL
2377 ,p_lifecycle_id IN NUMBER DEFAULT NULL
2378 ,p_phase_id IN NUMBER DEFAULT NULL
2379 ,p_new_effective_date IN DATE DEFAULT NULL
2380 ,x_return_status OUT NOCOPY VARCHAR2
2381 ,x_msg_count OUT NOCOPY NUMBER
2382 ,x_msg_data OUT NOCOPY VARCHAR2
2383 );
2384
2385 /*#
2386 * Use this API to implement pending phase and/or status changes
2387 * for an item/item revision. The procedure implements all pending
2388 * changes for the item/item revision whose effective dates are prior
2389 * to SYSDATE.
2390 * @param p_api_version A decimal number indicating revisions to
2391 * the API. Pass the number indicated in the package description
2392 * above.
2393 * @param p_commit A flag indicating whether to commit work at the
2394 * end of API processing. Refer to the package description above
2395 * for more information about this parameter and a list of valid
2399 * description above for more information about this parameter and
2396 * values.
2397 * @param p_init_msg_list A flag indicating whether to initialize
2398 * the FND_MSG_PUB package's message stack. Refer to the package
2400 * a list of valid values.
2401 * @param p_revision Revison code.
2402 * @param x_return_status A code indicating whether any errors
2403 * occurred during processing. Refer to the package description
2404 * above for more information about this parameter and a list of
2405 * valid values.
2406 * @param x_msg_count An integer indicating the number of messages
2407 * on the FND_MSG_PUB package's message stack at the end of API
2408 * processing. Refer to the package description above for more
2409 * information about this parameter.
2410 * @param x_msg_data A character string containing message text.
2411 * Refer to the package description above for more information
2412 * about this parameter and a list of valid values.
2413 * @rep:scope public
2414 * @rep:lifecycle active
2415 * @rep:displayname Implement Item Pending Changes
2416 */
2417 PROCEDURE Implement_Item_Pending_Changes
2418 (p_api_version IN NUMBER
2419 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2420 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
2421 ,p_inventory_item_id IN NUMBER DEFAULT NULL
2422 ,p_item_number IN VARCHAR2 DEFAULT NULL
2423 ,p_organization_id IN NUMBER DEFAULT NULL
2424 ,p_organization_code IN VARCHAR2 DEFAULT NULL
2425 ,p_revision_id IN NUMBER DEFAULT NULL
2426 ,p_revision IN VARCHAR2 DEFAULT NULL
2427 ,x_return_status OUT NOCOPY VARCHAR2
2428 ,x_msg_count OUT NOCOPY NUMBER
2429 ,x_msg_data OUT NOCOPY VARCHAR2
2430 );
2431
2432 /*#
2433 * Use this API to create a new item revision or update an existing
2434 * item revision.
2435 * @param p_api_version A decimal number indicating revisions to
2436 * the API. Pass the number indicated in the package description
2437 * above.
2438 * @param p_init_msg_list A flag indicating whether to initialize
2439 * the FND_MSG_PUB package's message stack. Refer to the package
2440 * description above for more information about this parameter and
2441 * a list of valid values.
2442 * @param p_commit A flag indicating whether to commit work at the
2443 * end of API processing. Refer to the package description above
2444 * for more information about this parameter and a list of valid
2445 * values.
2446 * @param p_transaction_type Valid values are G_TTYPE_CREATE and
2447 * G_TTYPE_UPDATE.
2448 * @param p_item_number Either Item Number or Inventory Item ID
2449 * should be passed.
2450 * @p_Organization_Code Either Org Code or Organization ID should
2451 * be passed.
2452 * @param p_description The revision's description.
2453 * @param p_effectivity_date The revision's effectivity date.
2454 * @param p_lifecycle_id <B>DEPRECATED.</B> This parameter
2455 * should not be used.
2456 * @param p_current_phase_id The revision's lifecycle phase ID.
2457 * @param p_attribute_category The revision's Descriptive
2458 * Flexfield (DFF) Context Field.
2459 * @param p_attribute1 Revision Descriptive Flexfield's Attribute1.
2460 * @param p_attribute2 Revision Descriptive Flexfield's Attribute2.
2461 * @param p_attribute3 Revision Descriptive Flexfield's Attribute3.
2462 * @param p_attribute4 Revision Descriptive Flexfield's Attribute4.
2463 * @param p_attribute5 Revision Descriptive Flexfield's Attribute5.
2464 * @param p_attribute6 Revision Descriptive Flexfield's Attribute6.
2465 * @param p_attribute7 Revision Descriptive Flexfield's Attribute7.
2466 * @param p_attribute8 Revision Descriptive Flexfield's Attribute8.
2467 * @param p_attribute9 Revision Descriptive Flexfield's Attribute9.
2468 * @param p_attribute10 Revision Descriptive Flexfield's Attribute10.
2469 * @param p_attribute11 Revision Descriptive Flexfield's Attribute11.
2470 * @param p_attribute12 Revision Descriptive Flexfield's Attribute12.
2471 * @param p_attribute13 Revision Descriptive Flexfield's Attribute13.
2472 * @param p_attribute14 Revision Descriptive Flexfield's Attribute14.
2473 * @param p_attribute15 Revision Descriptive Flexfield's Attribute15.
2474 * @param x_return_status A code indicating whether any errors
2475 * occurred during processing. Refer to the package description
2476 * above for more information about this parameter and a list of
2477 * valid values.
2478 * @param x_msg_count An integer indicating the number of messages
2479 * on the FND_MSG_PUB package's message stack at the end of API
2480 * processing. Refer to the package description above for more
2481 * information about this parameter.
2482 * @param x_msg_data A character string containing message text.
2483 * Refer to the package description above for more information
2484 * about this parameter and a list of valid values.
2485 * @rep:scope public
2486 * @rep:lifecycle active
2487 * @rep:displayname Process Item Revision
2488 */
2489
2490 PROCEDURE Process_Item_Revision(
2491 p_api_version IN NUMBER
2492 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2493 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
2494 ,p_transaction_type IN VARCHAR2
2495 ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
2496 ,p_item_number IN VARCHAR2 DEFAULT G_MISS_CHAR
2497 ,p_organization_id IN NUMBER DEFAULT G_MISS_NUM
2498 ,p_Organization_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
2499 ,p_revision IN VARCHAR2
2500 ,p_description IN VARCHAR2 DEFAULT NULL
2504 ,p_lifecycle_id IN NUMBER DEFAULT G_MISS_NUM
2501 ,p_effectivity_date IN DATE
2502 ,p_revision_label IN VARCHAR2 DEFAULT G_MISS_CHAR
2503 ,p_revision_reason IN VARCHAR2 DEFAULT NULL
2505 ,p_current_phase_id IN NUMBER DEFAULT G_MISS_NUM
2506 -- 5208102: Supporting template for UDA's at revisions
2507 ,p_template_id IN NUMBER DEFAULT G_MISS_NUM
2508 ,p_template_name IN VARCHAR2 DEFAULT G_MISS_CHAR
2509
2510 ,p_attribute_category IN VARCHAR2 DEFAULT G_MISS_CHAR
2511 ,p_attribute1 IN VARCHAR2 DEFAULT G_MISS_CHAR
2512 ,p_attribute2 IN VARCHAR2 DEFAULT G_MISS_CHAR
2513 ,p_attribute3 IN VARCHAR2 DEFAULT G_MISS_CHAR
2514 ,p_attribute4 IN VARCHAR2 DEFAULT G_MISS_CHAR
2515 ,p_attribute5 IN VARCHAR2 DEFAULT G_MISS_CHAR
2516 ,p_attribute6 IN VARCHAR2 DEFAULT G_MISS_CHAR
2517 ,p_attribute7 IN VARCHAR2 DEFAULT G_MISS_CHAR
2518 ,p_attribute8 IN VARCHAR2 DEFAULT G_MISS_CHAR
2519 ,p_attribute9 IN VARCHAR2 DEFAULT G_MISS_CHAR
2520 ,p_attribute10 IN VARCHAR2 DEFAULT G_MISS_CHAR
2521 ,p_attribute11 IN VARCHAR2 DEFAULT G_MISS_CHAR
2522 ,p_attribute12 IN VARCHAR2 DEFAULT G_MISS_CHAR
2523 ,p_attribute13 IN VARCHAR2 DEFAULT G_MISS_CHAR
2524 ,p_attribute14 IN VARCHAR2 DEFAULT G_MISS_CHAR
2525 ,p_attribute15 IN VARCHAR2 DEFAULT G_MISS_CHAR
2526 ,x_Return_Status OUT NOCOPY VARCHAR2
2527 ,x_msg_count OUT NOCOPY NUMBER
2528 ,x_msg_data OUT NOCOPY VARCHAR2);
2529
2530 ------------------------ Process_item_descr_elements ---------------------
2531 /*#
2532 * Use this API to set the values of item catalog category descriptive
2533 * elements (if the calling user has permission to edit the item).
2534 * The table type passed in p_item_desc_element_table is as follows:
2535 *<code><pre>
2536 TYPE Item_Desc_Element_Table IS TABLE OF Item_Desc_Element
2537 INDEX BY BINARY_INTEGER;
2538
2539 TYPE Item_Desc_Element IS RECORD
2540 (
2541 ELEMENT_NAME VARCHAR2(30)
2542 ,ELEMENT_VALUE VARCHAR2(30)
2543 ,DESCRIPTION_DEFAULT VARCHAR2(1)
2544 );
2545 *</pre></code>
2546 * In this record, DESCRIPTION_DEFAULT indicates whether the element
2547 * value should be defaulted into the Item Description. Valid values
2548 * are 'Y' and 'N'.
2549 * @param p_api_version A decimal number indicating revisions to
2550 * the API. Pass the number indicated in the package description
2551 * above.
2552 * @param p_init_msg_list A flag indicating whether to initialize
2553 * the FND_MSG_PUB package's message stack. Refer to the package
2554 * description above for more information about this parameter and
2555 * a list of valid values.
2556 * @param p_commit_flag A flag indicating whether to commit work
2557 * at the end of API processing. Refer to the package description
2558 * of the parameter 'p_commit' above for more information about
2559 * this parameter and a list of valid values.
2560 * @param p_validation_level <B>DEPRECATED.</B> This parameter
2561 * should not be used.
2562 * @param p_inventory_item_id Item ID of the item to which these
2563 * descriptive element values apply.
2564 * @param p_item_number Item Number of the item to which these
2565 * descriptive element values apply.
2566 * @param p_item_desc_element_table Each record in this PL/SQL table
2567 * corresponds to one descriptive element to be created or updated;
2568 * refer to API description for the record type declaration.
2569 * @param x_generated_descr Returns the newly generated item
2570 * description, if DESCRIPTION_DEFAULT was passed as 'Y' for at least
2571 * one descriptive element passed in p_item_desc_element_table.
2572 * @param x_return_status A code indicating whether any errors
2573 * occurred during processing. Refer to the package description
2574 * above for more information about this parameter and a list of
2575 * valid values.
2576 * @param x_msg_count An integer indicating the number of messages
2577 * on the FND_MSG_PUB package's message stack at the end of API
2578 * processing. Refer to the package description above for more
2579 * information about this parameter.
2580 * @param x_msg_data A character string containing message text.
2581 * Refer to the package description above for more information
2582 * about this parameter and a list of valid values.
2583 * @rep:scope public
2584 * @rep:lifecycle active
2585 * @rep:displayname Process Item Descriptive Element Values
2586 */
2587
2588 PROCEDURE Process_item_descr_elements
2589 (
2590 p_api_version IN NUMBER
2591 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2592 , p_commit_flag IN VARCHAR2 DEFAULT fnd_api.g_FALSE
2593 , p_validation_level IN NUMBER DEFAULT INV_ITEM_CATALOG_ELEM_PUB.g_VALIDATE_ALL
2594 , p_inventory_item_id IN NUMBER DEFAULT -999
2595 , p_item_number IN VARCHAR2 DEFAULT NULL
2596 , p_item_desc_element_table IN INV_ITEM_CATALOG_ELEM_PUB.ITEM_DESC_ELEMENT_TABLE
2597 , x_generated_descr OUT NOCOPY VARCHAR2
2598 , x_return_status OUT NOCOPY VARCHAR2
2599 , x_msg_count OUT NOCOPY NUMBER
2600 , x_msg_data OUT NOCOPY VARCHAR2
2601 );
2602
2603
2604 ------------------------ Process_Item_Cat_Assignment ---------------------
2605 /*#
2609 * the API. Pass the number indicated in the package description
2606 * Use this API to assign/remove a catalog/category to/from an
2607 * item (if the calling user has permission to edit the item).
2608 * @param p_api_version A decimal number indicating revisions to
2610 * above.
2611 * @param p_init_msg_list A flag indicating whether to initialize
2612 * the FND_MSG_PUB package's message stack. Refer to the package
2613 * description above for more information about this parameter and
2614 * a list of valid values.
2615 * @param p_commit A flag indicating whether to commit work at the
2616 * end of API processing. Refer to the package description above
2617 * for more information about this parameter and a list of valid
2618 * values.
2619 * @param p_category_id Catalog/Category ID to be assigned/removed.
2620 * @param p_category_set_id Category Set/Catalog Category ID to
2621 * which Catalog/Category passed in p_category_id belongs.
2622 * @param p_transaction_type Valid values are G_TTYPE_CREATE and
2623 * G_TTYPE_DELETE.
2624 * @param x_return_status A code indicating whether any errors
2625 * occurred during processing. Refer to the package description
2626 * above for more information about this parameter and a list of
2627 * valid values.
2628 * @param x_errorcode Reserved for future use.
2629 * @param x_msg_count An integer indicating the number of messages
2630 * on the FND_MSG_PUB package's message stack at the end of API
2631 * processing. Refer to the package description above for more
2632 * information about this parameter.
2633 * @param x_msg_data A character string containing message text.
2634 * Refer to the package description above for more information
2635 * about this parameter and a list of valid values.
2636 * @rep:scope public
2637 * @rep:lifecycle active
2638 * @rep:displayname Process Item Category/Catalog Assignments
2639 */
2640 PROCEDURE Process_Item_Cat_Assignment
2641 (
2642 p_api_version IN NUMBER
2643 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2644 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2645 , p_category_id IN NUMBER
2646 , p_category_set_id IN NUMBER
2647 , p_inventory_item_id IN NUMBER
2648 , p_organization_id IN NUMBER
2649 , p_transaction_type IN VARCHAR2
2650 , x_return_status OUT NOCOPY VARCHAR2
2651 , x_errorcode OUT NOCOPY NUMBER
2652 , x_msg_count OUT NOCOPY NUMBER
2653 , x_msg_data OUT NOCOPY VARCHAR2
2654 );
2655
2656 /*#
2657 * Use this API to add/update/delete GDSN Attributes of an item
2658 * (if the calling user has permission to edit the item).
2659 * @param p_api_version A decimal number indicating revisions to
2660 * the API. Pass the number indicated in the package description
2661 * above.
2662 * @param p_commit A flag indicating whether to commit work at the
2663 * end of API processing. Refer to the package description above
2664 * for more information about this parameter and a list of valid
2665 * values.
2666 * @param p_inventory_item_id Item ID of the item to which these
2667 * GDSN Attribute values apply.
2668 * @param p_organization_id Organization ID of the Item to
2669 * be processed.
2670 * @param p_single_row_attrs_rec Record containing all single row
2671 * GDSN attributes. User must populate this record to process
2672 * GDSN single row attributes.
2673 * @param p_multi_row_attrs_table Table of Record containing all
2674 * multi row GDSN attributes. User must populate this table to process
2675 * GDSN multi row attributes.
2676 * @param p_entity_id Used in error reporting; refer to ERROR_HANDLER
2677 * for details.
2678 * @param p_entity_index Used in error reporting; refer to ERROR_HANDLER
2679 * for details.
2680 * @param p_entity_code Used in error reporting; refer to ERROR_HANDLER
2681 * for details.
2682 * @param p_init_error_handler Indicates whether to initialize
2683 * ERROR_HANDLER message stack (and open debug session, if applicable).
2684 * @param x_return_status A code indicating whether any errors
2685 * occurred during processing. Refer to the package description
2686 * above for more information about this parameter and a list of
2687 * valid values.
2688 * @param x_errorcode Reserved for future use.
2689 * @param x_msg_count An integer indicating the number of messages
2690 * on the FND_MSG_PUB package's message stack at the end of API
2691 * processing. Refer to the package description above for more
2692 * information about this parameter.
2693 * @param x_msg_data A character string containing message text.
2694 * Refer to the package description above for more information
2695 * about this parameter and a list of valid values.
2696 * @rep:scope public
2697 * @rep:lifecycle active
2698 * @rep:displayname Process GDSN Attributes For an Item.
2699 */
2700 PROCEDURE Process_UCCnet_Attrs_For_Item (
2701 p_api_version IN NUMBER
2702 ,p_inventory_item_id IN NUMBER
2703 ,p_organization_id IN NUMBER
2704 ,p_single_row_attrs_rec IN UCCnet_Attrs_Singl_Row_Rec_Typ
2705 ,p_multi_row_attrs_table IN UCCnet_Attrs_Multi_Row_Tbl_Typ
2706 ,p_entity_id IN NUMBER DEFAULT NULL
2707 ,p_entity_index IN NUMBER DEFAULT NULL
2708 ,p_entity_code IN VARCHAR2 DEFAULT NULL
2709 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
2710 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2714 ,x_msg_data OUT NOCOPY VARCHAR2);
2711 ,x_return_status OUT NOCOPY VARCHAR2
2712 ,x_errorcode OUT NOCOPY NUMBER
2713 ,x_msg_count OUT NOCOPY NUMBER
2715
2716 /*#
2717 * Use this API to validate required attributes for an item.
2718 * The API returns the list of required attributes having null values
2719 * for the item.
2720 * @param p_api_version A decimal number indicating revisions to
2721 * the API. Pass the number indicated in the package description
2722 * above.
2723 * @param p_inventory_item_id Item ID
2724 * @param p_organization_id Item organization ID.
2725 * @param p_revision_id Item revision ID
2726 * @param x_attributes_req_table Contains metadata about each
2727 * attribute in each attribute group row for an item being validated.
2728 * @param x_return_status A code indicating whether any errors
2729 * occurred during processing. Refer to the package description
2730 * above for more information about this parameter and a list of
2731 * valid values.
2732 * @param x_errorcode Reserved for future use.
2733 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
2734 * message stack upon completion of processing.
2735 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
2736 * message stack upon completion of processing, this parameter contains
2737 * that message.
2738 * @rep:scope public
2739 * @rep:lifecycle active
2740 * @rep:displayname Validate Required Attributes For Item
2741 */
2742 PROCEDURE Validate_Required_Attrs (
2743 p_api_version IN NUMBER
2744 ,p_inventory_item_id IN NUMBER
2745 ,p_organization_id IN NUMBER
2746 ,p_revision_id IN NUMBER DEFAULT NULL
2747 ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
2748 ,x_return_status OUT NOCOPY VARCHAR2
2749 ,x_errorcode OUT NOCOPY NUMBER
2750 ,x_msg_count OUT NOCOPY NUMBER
2751 ,x_msg_data OUT NOCOPY VARCHAR2
2752 );
2753
2754 /*#
2755 * <b>Import Workbench</b>
2756 * Call this API to complete the loading, via custom methods such as SQL script,
2757 * of data into the INV and EGO open interface tables for items and child entities.
2758 * This API prepares the newly loaded data for display in the Import Workbench
2759 * HTML UI. Note that this API only prepares the batch data for UI display and does
2760 * not attempt to import these records into production tables.
2761 * The API is reentrant: it can be called repeatedly for the same batch.
2762 *
2763 * @param p_api_version A decimal number indicating revisions to
2764 * the API. Pass the number indicated in the package description
2765 * above.
2766 * @param p_batch_id Import Batch ID. This parameter cannot be null.
2767 * @param x_return_status A code indicating whether any errors
2768 * occurred during processing. Refer to the package description
2769 * above for more information about this parameter and a list of
2770 * valid values.
2771 * @param x_errorcode Reserved for future use.
2772 * @param x_msg_count Indicates how many messages exist on ERROR_HANDLER
2773 * message stack upon completion of processing.
2774 * @param x_msg_data If exactly one message exists on ERROR_HANDLER
2775 * message stack upon completion of processing, this parameter contains
2776 * that message.
2777 * @rep:scope public
2778 * @rep:lifecycle active
2779 * @rep:displayname Prepare Batch Data For Import UI
2780 */
2781 PROCEDURE Prep_Batch_Data_For_Import_UI
2782 ( p_api_version IN NUMBER
2783 , p_batch_id IN NUMBER
2784 , x_return_status OUT NOCOPY VARCHAR2
2785 , x_errorcode OUT NOCOPY NUMBER
2786 , x_msg_count OUT NOCOPY NUMBER
2787 , x_msg_data OUT NOCOPY VARCHAR2
2788 );
2789
2790
2791 END EGO_ITEM_PUB;