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