1 PACKAGE EGO_UI_ITEM_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGOITUIS.pls 115.14 2004/06/07 00:12:02 absinha noship $ */
3
4 G_FILE_NAME CONSTANT VARCHAR2(12) := 'EGOITUIS.pls';
5
6 -- =============================================================================
7 -- Global variables and cursors
8 -- =============================================================================
9
10 G_BO_Identifier CONSTANT VARCHAR2(30) := 'EGO_ITEM';
11
12 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
13 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
14 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
15
16 --G_MISS_NUM CONSTANT NUMBER := 9.99E125;
17 --G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
18 --G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
19 G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
20 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
21 G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
22 G_FALSE CONSTANT VARCHAR2(10) := FND_API.G_FALSE; -- 'F'
23
24 -- =============================================================================
25 -- Global types
26 -- =============================================================================
27
28
29
30 -- =============================================================================
31 -- Public Procedures
32 -- =============================================================================
33
34 -- -----------------------------------------------------------------------------
35 -- API Name: Update_Item_Lifecycle
36 --
37 -- Type: Public
38 --
39 -- Description:
40 -- Update Item Lifecycle and Lifecycle Phase.
41 --
42 -- Version: Current version 1.0
43 -- -----------------------------------------------------------------------------
44
45 Procedure Process_Item_Lifecycle(
46 P_API_VERSION IN NUMBER,
47 P_INIT_MSG_LIST IN VARCHAR2,
48 P_COMMIT IN VARCHAR2,
49 P_INVENTORY_ITEM_ID IN NUMBER,
50 P_ORGANIZATION_ID IN NUMBER,
51 P_CATALOG_GROUP_ID IN NUMBER,
52 P_LIFECYCLE_ID IN NUMBER,
53 P_CURRENT_PHASE_ID IN NUMBER,
54 P_ITEM_STATUS IN VARCHAR2,
55 P_TRANSACTION_TYPE IN VARCHAR2,
56 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
57 X_MSG_COUNT OUT NOCOPY NUMBER
58 );
59
60 Procedure Create_Item_Lifecycle(
61 P_API_VERSION IN NUMBER,
62 P_INIT_MSG_LIST IN VARCHAR2,
63 P_COMMIT IN VARCHAR2,
64 P_INVENTORY_ITEM_ID IN NUMBER,
65 P_ORGANIZATION_ID IN NUMBER,
66 P_LIFECYCLE_ID IN NUMBER,
67 P_CURRENT_PHASE_ID IN NUMBER,
68 P_ITEM_STATUS IN VARCHAR2,
69 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
70 X_MSG_COUNT OUT NOCOPY NUMBER
71 );
72
73 Procedure Update_Item_Lifecycle(
74 P_API_VERSION IN NUMBER,
75 P_INIT_MSG_LIST IN VARCHAR2,
76 P_COMMIT IN VARCHAR2,
77 P_INVENTORY_ITEM_ID IN NUMBER,
78 P_ORGANIZATION_ID IN NUMBER,
79 P_CATALOG_GROUP_ID IN NUMBER,
80 P_LIFECYCLE_ID IN NUMBER,
81 P_CURRENT_PHASE_ID IN NUMBER,
82 P_ITEM_STATUS IN VARCHAR2,
83 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
84 X_MSG_COUNT OUT NOCOPY NUMBER
85 );
86
87 -- -----------------------------------------------------------------------------
88 -- API Name: Update_Item_Attr_Ext
89 --
90 -- Type: Public
91 --
92 -- Description:
93 -- Update Item Catalog Group Id
94 --
95 -- Version: Current version 1.0
96 -- -----------------------------------------------------------------------------
97
98 Procedure Update_Item_Attr_Ext(
99 P_API_VERSION IN NUMBER,
100 P_INIT_MSG_LIST IN VARCHAR2,
101 P_COMMIT IN VARCHAR2,
102 P_INVENTORY_ITEM_ID IN NUMBER,
103 P_ITEM_CATALOG_GROUP_ID IN NUMBER,
104 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
105 X_MSG_COUNT OUT NOCOPY NUMBER
106 );
107
108 /******************************************************************
109 ** Procedure: Get_Master_Organization_Id (unexposed)
110 ********************************************************************/
111 FUNCTION Get_Master_Organization_Id(
112 P_ORGANIZATION_ID IN NUMBER
113 ) RETURN NUMBER;
114
115 /******************************************************************
116 ** Procedure: Get_Item_Attr_Control_Level (unexposed)
117 ********************************************************************/
118 FUNCTION Get_Item_Attr_Control_Level(
119 P_ITEM_ATTRIBUTE IN VARCHAR2
120 ) RETURN NUMBER;
121
122 -- -----------------------------------------------------------------------------
123 -- API Name: Set_Debug_Parameters
124 --
125 -- Type:
126 --
127 -- Description:
128 -- Error file for Developer Debug messages.
129 --
130 -- Version: Current version 1.0
131 -- -----------------------------------------------------------------------------
132
133 /******************************************************************
134 ** Procedure: Set_Debug_Parameters (unexposed)
135 ** Purpose: Will take input as the debug parameters and check if
136 ** a debug session needs to be eastablished. If yes, the it will
137 ** open a debug session file and all developer messages will be
138 ** logged into a debug error file. File name will be the parameter
139 ** debug_file_name_<session_id>
140 ********************************************************************/
141 Procedure Set_Debug_Parameters(
142 P_debug_flag IN VARCHAR2
143 , P_output_dir IN VARCHAR2
144 , P_debug_filename IN VARCHAR2
145 );
146
147
148 -- ----------------------------------------------------------------
149 -- API Name: Process_Item
150 -- Type: Public
151 -- Version: Current version 1.0
152 --
153 -- Function: Process (CREATE/UPDATE) one item using IOI
154 -- Notes:
155 --
156 -- History:
157 -- 23-SEP-2003 Sridhar Rajaparthi Creation (bug 3143834)
158 -- ----------------------------------------------------------------
159 PROCEDURE Process_Item
160 (
161 p_api_version IN NUMBER
162 ,p_init_msg_list IN VARCHAR2 DEFAULT G_FALSE
163 ,p_commit IN VARCHAR2 DEFAULT G_FALSE
164 -- Transaction data
165 ,p_Transaction_Type IN VARCHAR2 DEFAULT G_MISS_CHAR
166 ,p_Language_Code IN VARCHAR2 DEFAULT G_MISS_CHAR
167 -- Copy item from template
168 ,p_Template_Id IN NUMBER DEFAULT NULL
169 ,p_Template_Name IN VARCHAR2 DEFAULT NULL
170 -- Copy item from another item
171 ,p_copy_inventory_item_Id IN NUMBER DEFAULT G_MISS_NUM
172 -- Base Attributes
173 ,p_inventory_item_id IN NUMBER DEFAULT G_MISS_NUM
174 ,p_organization_id IN NUMBER DEFAULT G_MISS_NUM
175 ,p_master_organization_id IN NUMBER DEFAULT G_MISS_NUM
176 ,p_description IN VARCHAR2 DEFAULT G_MISS_CHAR
177 ,p_long_description IN VARCHAR2 DEFAULT G_MISS_CHAR
178 ,p_primary_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
179 ,p_primary_unit_of_measure IN VARCHAR2 DEFAULT G_MISS_CHAR
180 ,p_item_type IN VARCHAR2 DEFAULT G_MISS_CHAR
181 ,p_inventory_item_status_code IN VARCHAR2 DEFAULT G_MISS_CHAR
182 ,p_allowed_units_lookup_code IN NUMBER DEFAULT G_MISS_NUM
183 ,p_item_catalog_group_id IN NUMBER DEFAULT G_MISS_NUM
184 ,p_catalog_status_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
185 ,p_inventory_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
186 ,p_stock_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
187 ,p_mtl_transactions_enabled_fl IN VARCHAR2 DEFAULT G_MISS_CHAR
188 ,p_check_shortages_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
189 ,p_revision_qty_control_code IN NUMBER DEFAULT G_MISS_NUM
190 ,p_reservable_type IN NUMBER DEFAULT G_MISS_NUM
191 ,p_shelf_life_code IN NUMBER DEFAULT G_MISS_NUM
192 ,p_shelf_life_days IN NUMBER DEFAULT G_MISS_NUM
193 ,p_cycle_count_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
194 ,p_negative_measurement_error IN NUMBER DEFAULT G_MISS_NUM
195 ,p_positive_measurement_error IN NUMBER DEFAULT G_MISS_NUM
196 ,p_lot_control_code IN NUMBER DEFAULT G_MISS_NUM
197 ,p_auto_lot_alpha_prefix IN VARCHAR2 DEFAULT G_MISS_CHAR
198 ,p_start_auto_lot_number IN VARCHAR2 DEFAULT G_MISS_CHAR
199 ,p_serial_number_control_code IN NUMBER DEFAULT G_MISS_NUM
200 ,p_auto_serial_alpha_prefix IN VARCHAR2 DEFAULT G_MISS_CHAR
201 ,p_start_auto_serial_number IN VARCHAR2 DEFAULT G_MISS_CHAR
202 ,p_location_control_code IN NUMBER DEFAULT G_MISS_NUM
203 ,p_restrict_subinventories_cod IN NUMBER DEFAULT G_MISS_NUM
204 ,p_restrict_locators_code IN NUMBER DEFAULT G_MISS_NUM
205 ,p_bom_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
206 ,p_bom_item_type IN NUMBER DEFAULT G_MISS_NUM
207 ,p_base_item_id IN NUMBER DEFAULT G_MISS_NUM
208 ,p_effectivity_control IN NUMBER DEFAULT G_MISS_NUM
209 ,p_eng_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
210 ,p_engineering_ecn_code IN VARCHAR2 DEFAULT G_MISS_CHAR
211 ,p_engineering_item_id IN NUMBER DEFAULT G_MISS_NUM
212 ,p_engineering_date IN DATE DEFAULT G_MISS_DATE
213 ,p_product_family_item_id IN NUMBER DEFAULT G_MISS_NUM
214 ,p_auto_created_config_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
215 ,p_model_config_clause_name IN VARCHAR2 DEFAULT G_MISS_CHAR
216 -- attribute not in the form
217 ,p_new_revision_code IN VARCHAR2 DEFAULT G_MISS_CHAR
218 ,p_costing_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
219 ,p_inventory_asset_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
220 ,p_default_include_in_rollup_f IN VARCHAR2 DEFAULT G_MISS_CHAR
221 ,p_cost_of_sales_account IN NUMBER DEFAULT G_MISS_NUM
222 ,p_std_lot_size IN NUMBER DEFAULT G_MISS_NUM
223 ,p_purchasing_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
224 ,p_purchasing_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
225 ,p_must_use_approved_vendor_fl IN VARCHAR2 DEFAULT G_MISS_CHAR
226 ,p_allow_item_desc_update_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
227 ,p_rfq_required_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
228 ,p_outside_operation_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
229 ,p_outside_operation_uom_type IN VARCHAR2 DEFAULT G_MISS_CHAR
230 ,p_taxable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
231 ,p_purchasing_tax_code IN VARCHAR2 DEFAULT G_MISS_CHAR
232 ,p_receipt_required_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
233 ,p_inspection_required_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
234 ,p_buyer_id IN NUMBER DEFAULT G_MISS_NUM
235 ,p_unit_of_issue IN VARCHAR2 DEFAULT G_MISS_CHAR
236 ,p_receive_close_tolerance IN NUMBER DEFAULT G_MISS_NUM
237 ,p_invoice_close_tolerance IN NUMBER DEFAULT G_MISS_NUM
238 ,p_un_number_id IN NUMBER DEFAULT G_MISS_NUM
239 ,p_hazard_class_id IN NUMBER DEFAULT G_MISS_NUM
240 ,p_list_price_per_unit IN NUMBER DEFAULT G_MISS_NUM
241 ,p_market_price IN NUMBER DEFAULT G_MISS_NUM
242 ,p_price_tolerance_percent IN NUMBER DEFAULT G_MISS_NUM
243 ,p_rounding_factor IN NUMBER DEFAULT G_MISS_NUM
244 ,p_encumbrance_account IN NUMBER DEFAULT G_MISS_NUM
245 ,p_expense_account IN NUMBER DEFAULT G_MISS_NUM
246 ,p_expense_billable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
247 ,p_asset_category_id IN NUMBER DEFAULT G_MISS_NUM
248 ,p_receipt_days_exception_code IN VARCHAR2 DEFAULT G_MISS_CHAR
249 ,p_days_early_receipt_allowed IN NUMBER DEFAULT G_MISS_NUM
250 ,p_days_late_receipt_allowed IN NUMBER DEFAULT G_MISS_NUM
251 ,p_allow_substitute_receipts_f IN VARCHAR2 DEFAULT G_MISS_CHAR
252 ,p_allow_unordered_receipts_fl IN VARCHAR2 DEFAULT G_MISS_CHAR
253 ,p_allow_express_delivery_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
254 ,p_qty_rcv_exception_code IN VARCHAR2 DEFAULT G_MISS_CHAR
255 ,p_qty_rcv_tolerance IN NUMBER DEFAULT G_MISS_NUM
256 ,p_receiving_routing_id IN NUMBER DEFAULT G_MISS_NUM
257 ,p_enforce_ship_to_location_c IN VARCHAR2 DEFAULT G_MISS_CHAR
258 ,p_weight_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
259 ,p_unit_weight IN NUMBER DEFAULT G_MISS_NUM
260 ,p_volume_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
261 ,p_unit_volume IN NUMBER DEFAULT G_MISS_NUM
262 ,p_container_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
263 ,p_vehicle_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
264 ,p_container_type_code IN VARCHAR2 DEFAULT G_MISS_CHAR
265 ,p_internal_volume IN NUMBER DEFAULT G_MISS_NUM
266 ,p_maximum_load_weight IN NUMBER DEFAULT G_MISS_NUM
267 ,p_minimum_fill_percent IN NUMBER DEFAULT G_MISS_NUM
268 ,p_inventory_planning_code IN NUMBER DEFAULT G_MISS_NUM
269 ,p_planner_code IN VARCHAR2 DEFAULT G_MISS_CHAR
270 ,p_planning_make_buy_code IN NUMBER DEFAULT G_MISS_NUM
271 ,p_min_minmax_quantity IN NUMBER DEFAULT G_MISS_NUM
272 ,p_max_minmax_quantity IN NUMBER DEFAULT G_MISS_NUM
273 ,p_minimum_order_quantity IN NUMBER DEFAULT G_MISS_NUM
274 ,p_maximum_order_quantity IN NUMBER DEFAULT G_MISS_NUM
275 ,p_order_cost IN NUMBER DEFAULT G_MISS_NUM
276 ,p_carrying_cost IN NUMBER DEFAULT G_MISS_NUM
277 ,p_source_type IN NUMBER DEFAULT G_MISS_NUM
278 ,p_source_organization_id IN NUMBER DEFAULT G_MISS_NUM
279 ,p_source_subinventory IN VARCHAR2 DEFAULT G_MISS_CHAR
280 ,p_mrp_safety_stock_code IN NUMBER DEFAULT G_MISS_NUM
281 ,p_safety_stock_bucket_days IN NUMBER DEFAULT G_MISS_NUM
282 ,p_mrp_safety_stock_percent IN NUMBER DEFAULT G_MISS_NUM
283 ,p_fixed_order_quantity IN NUMBER DEFAULT G_MISS_NUM
284 ,p_fixed_days_supply IN NUMBER DEFAULT G_MISS_NUM
285 ,p_fixed_lot_multiplier IN NUMBER DEFAULT G_MISS_NUM
286 ,p_mrp_planning_code IN NUMBER DEFAULT G_MISS_NUM
287 ,p_ato_forecast_control IN NUMBER DEFAULT G_MISS_NUM
288 ,p_planning_exception_set IN VARCHAR2 DEFAULT G_MISS_CHAR
289 ,p_end_assembly_pegging_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
290 ,p_shrinkage_rate IN NUMBER DEFAULT G_MISS_NUM
291 ,p_rounding_control_type IN NUMBER DEFAULT G_MISS_NUM
292 ,p_acceptable_early_days IN NUMBER DEFAULT G_MISS_NUM
293 ,p_repetitive_planning_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
294 ,p_overrun_percentage IN NUMBER DEFAULT G_MISS_NUM
295 ,p_acceptable_rate_increase IN NUMBER DEFAULT G_MISS_NUM
296 ,p_acceptable_rate_decrease IN NUMBER DEFAULT G_MISS_NUM
297 ,p_mrp_calculate_atp_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
298 ,p_auto_reduce_mps IN NUMBER DEFAULT G_MISS_NUM
299 ,p_planning_time_fence_code IN NUMBER DEFAULT G_MISS_NUM
300 ,p_planning_time_fence_days IN NUMBER DEFAULT G_MISS_NUM
301 ,p_demand_time_fence_code IN NUMBER DEFAULT G_MISS_NUM
302 ,p_demand_time_fence_days IN NUMBER DEFAULT G_MISS_NUM
306 ,p_full_lead_time IN NUMBER DEFAULT G_MISS_NUM
303 ,p_release_time_fence_code IN NUMBER DEFAULT G_MISS_NUM
304 ,p_release_time_fence_days IN NUMBER DEFAULT G_MISS_NUM
305 ,p_preprocessing_lead_time IN NUMBER DEFAULT G_MISS_NUM
307 ,p_postprocessing_lead_time IN NUMBER DEFAULT G_MISS_NUM
308 ,p_fixed_lead_time IN NUMBER DEFAULT G_MISS_NUM
309 ,p_variable_lead_time IN NUMBER DEFAULT G_MISS_NUM
310 ,p_cum_manufacturing_lead_time IN NUMBER DEFAULT G_MISS_NUM
311 ,p_cumulative_total_lead_time IN NUMBER DEFAULT G_MISS_NUM
312 ,p_lead_time_lot_size IN NUMBER DEFAULT G_MISS_NUM
313 ,p_build_in_wip_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
314 ,p_wip_supply_type IN NUMBER DEFAULT G_MISS_NUM
315 ,p_wip_supply_subinventory IN VARCHAR2 DEFAULT G_MISS_CHAR
316 ,p_wip_supply_locator_id IN NUMBER DEFAULT G_MISS_NUM
317 ,p_overcompletion_tolerance_ty IN NUMBER DEFAULT G_MISS_NUM
318 ,p_overcompletion_tolerance_va IN NUMBER DEFAULT G_MISS_NUM
319 ,p_customer_order_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
320 ,p_customer_order_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
321 ,p_shippable_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
322 ,p_internal_order_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
323 ,p_internal_order_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
324 ,p_so_transactions_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
325 ,p_pick_components_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
326 ,p_atp_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
327 ,p_replenish_to_order_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
328 ,p_atp_rule_id IN NUMBER DEFAULT G_MISS_NUM
329 ,p_atp_components_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
330 ,p_ship_model_complete_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
331 ,p_picking_rule_id IN NUMBER DEFAULT G_MISS_NUM
332 ,p_collateral_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
333 ,p_default_shipping_org IN NUMBER DEFAULT G_MISS_NUM
334 ,p_returnable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
335 ,p_return_inspection_requireme IN NUMBER DEFAULT G_MISS_NUM
336 ,p_over_shipment_tolerance IN NUMBER DEFAULT G_MISS_NUM
337 ,p_under_shipment_tolerance IN NUMBER DEFAULT G_MISS_NUM
338 ,p_over_return_tolerance IN NUMBER DEFAULT G_MISS_NUM
339 ,p_under_return_tolerance IN NUMBER DEFAULT G_MISS_NUM
340 ,p_invoiceable_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
341 ,p_invoice_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
342 ,p_accounting_rule_id IN NUMBER DEFAULT G_MISS_NUM
343 ,p_invoicing_rule_id IN NUMBER DEFAULT G_MISS_NUM
344 ,p_tax_code IN VARCHAR2 DEFAULT G_MISS_CHAR
345 ,p_sales_account IN NUMBER DEFAULT G_MISS_NUM
346 ,p_payment_terms_id IN NUMBER DEFAULT G_MISS_NUM
347 ,p_coverage_schedule_id IN NUMBER DEFAULT G_MISS_NUM
348 ,p_service_duration IN NUMBER DEFAULT G_MISS_NUM
349 ,p_service_duration_period_cod IN VARCHAR2 DEFAULT G_MISS_CHAR
350 ,p_serviceable_product_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
351 ,p_service_starting_delay IN NUMBER DEFAULT G_MISS_NUM
352 ,p_material_billable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
353 ,p_serviceable_component_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
354 ,p_preventive_maintenance_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
355 ,p_prorate_service_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
356 -- attribute not in the form
357 ,p_serviceable_item_class_id IN NUMBER DEFAULT G_MISS_NUM
358 -- attribute not in the form
359 ,p_base_warranty_service_id IN NUMBER DEFAULT G_MISS_NUM
360 -- attribute not in the form
361 ,p_warranty_vendor_id IN NUMBER DEFAULT G_MISS_NUM
362 -- attribute not in the form
363 ,p_max_warranty_amount IN NUMBER DEFAULT G_MISS_NUM
364 -- attribute not in the form
365 ,p_response_time_period_code IN VARCHAR2 DEFAULT G_MISS_CHAR
366 -- attribute not in the form
367 ,p_response_time_value IN NUMBER DEFAULT G_MISS_NUM
368 -- attribute not in the form
369 ,p_primary_specialist_id IN NUMBER DEFAULT G_MISS_NUM
370 -- attribute not in the form
371 ,p_secondary_specialist_id IN NUMBER DEFAULT G_MISS_NUM
372 ,p_wh_update_date IN DATE DEFAULT G_MISS_DATE
373 ,p_equipment_type IN NUMBER DEFAULT G_MISS_NUM
374 ,p_recovered_part_disp_code IN VARCHAR2 DEFAULT G_MISS_CHAR
375 ,p_defect_tracking_on_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
376 ,p_event_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
377 ,p_electronic_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
378 ,p_downloadable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
379 ,p_vol_discount_exempt_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
380 ,p_coupon_exempt_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
381 ,p_comms_nl_trackable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
382 ,p_asset_creation_code IN VARCHAR2 DEFAULT G_MISS_CHAR
383 ,p_comms_activation_reqd_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
384 ,p_orderable_on_web_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
388 ,p_dimension_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
385 ,p_back_orderable_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
386 ,p_web_status IN VARCHAR2 DEFAULT G_MISS_CHAR
387 ,p_indivisible_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
389 ,p_unit_length IN NUMBER DEFAULT G_MISS_NUM
390 ,p_unit_width IN NUMBER DEFAULT G_MISS_NUM
391 ,p_unit_height IN NUMBER DEFAULT G_MISS_NUM
392 ,p_bulk_picked_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
393 ,p_lot_status_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
394 ,p_default_lot_status_id IN NUMBER DEFAULT G_MISS_NUM
395 ,p_serial_status_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
396 ,p_default_serial_status_id IN NUMBER DEFAULT G_MISS_NUM
397 ,p_lot_split_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
398 ,p_lot_merge_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
399 ,p_inventory_carry_penalty IN NUMBER DEFAULT G_MISS_NUM
400 ,p_operation_slack_penalty IN NUMBER DEFAULT G_MISS_NUM
401 ,p_financing_allowed_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
402 ,p_eam_item_type IN NUMBER DEFAULT G_MISS_NUM
403 ,p_eam_activity_type_code IN VARCHAR2 DEFAULT G_MISS_CHAR
404 ,p_eam_activity_cause_code IN VARCHAR2 DEFAULT G_MISS_CHAR
405 ,p_eam_act_notification_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
406 ,p_eam_act_shutdown_status IN VARCHAR2 DEFAULT G_MISS_CHAR
407 ,p_dual_uom_control IN NUMBER DEFAULT G_MISS_NUM
408 ,p_secondary_uom_code IN VARCHAR2 DEFAULT G_MISS_CHAR
409 ,p_dual_uom_deviation_high IN NUMBER DEFAULT G_MISS_NUM
410 ,p_dual_uom_deviation_low IN NUMBER DEFAULT G_MISS_NUM
411 -- derived attributes
412 --,p_service_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
413 --,p_vendor_warranty_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
414 --,p_usage_item_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
415 ,p_contract_item_type_code IN VARCHAR2 DEFAULT G_MISS_CHAR
416 ,p_subscription_depend_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
417 ,p_serv_req_enabled_code IN VARCHAR2 DEFAULT G_MISS_CHAR
418 ,p_serv_billing_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
419 ,p_serv_importance_level IN NUMBER DEFAULT G_MISS_NUM
420 ,p_planned_inv_point_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
421 ,p_lot_translate_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
422 ,p_default_so_source_type IN VARCHAR2 DEFAULT G_MISS_CHAR
423 ,p_create_supply_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
424 ,p_substitution_window_code IN NUMBER DEFAULT G_MISS_NUM
425 ,p_substitution_window_days IN NUMBER DEFAULT G_MISS_NUM
426 ,p_ib_item_instance_class IN VARCHAR2 DEFAULT G_MISS_CHAR
427 ,p_config_model_type IN VARCHAR2 DEFAULT G_MISS_CHAR
428 --added for 11.5.9 enh
429 ,p_lot_substitution_enabled IN VARCHAR2 DEFAULT G_MISS_CHAR
430 ,p_minimum_license_quantity IN NUMBER DEFAULT G_MISS_NUM
431 ,p_eam_activity_source_code IN VARCHAR2 DEFAULT G_MISS_CHAR
432 --added for 11.5.10 enh
433 ,p_tracking_quantity_ind IN VARCHAR2 DEFAULT G_MISS_CHAR
434 ,p_ont_pricing_qty_source IN VARCHAR2 DEFAULT G_MISS_CHAR
435 ,p_secondary_default_ind IN VARCHAR2 DEFAULT G_MISS_CHAR
436 ,p_option_specific_sourced IN NUMBER DEFAULT G_MISS_NUM
437 ,p_approval_status IN VARCHAR2 DEFAULT G_MISS_CHAR
438 --
439 ,p_Item_Number IN VARCHAR2 DEFAULT G_MISS_CHAR
440 ,p_segment1 IN VARCHAR2 DEFAULT G_MISS_CHAR
441 ,p_segment2 IN VARCHAR2 DEFAULT G_MISS_CHAR
442 ,p_segment3 IN VARCHAR2 DEFAULT G_MISS_CHAR
443 ,p_segment4 IN VARCHAR2 DEFAULT G_MISS_CHAR
444 ,p_segment5 IN VARCHAR2 DEFAULT G_MISS_CHAR
445 ,p_segment6 IN VARCHAR2 DEFAULT G_MISS_CHAR
446 ,p_segment7 IN VARCHAR2 DEFAULT G_MISS_CHAR
447 ,p_segment8 IN VARCHAR2 DEFAULT G_MISS_CHAR
448 ,p_segment9 IN VARCHAR2 DEFAULT G_MISS_CHAR
449 ,p_segment10 IN VARCHAR2 DEFAULT G_MISS_CHAR
450 ,p_segment11 IN VARCHAR2 DEFAULT G_MISS_CHAR
451 ,p_segment12 IN VARCHAR2 DEFAULT G_MISS_CHAR
455 ,p_segment16 IN VARCHAR2 DEFAULT G_MISS_CHAR
452 ,p_segment13 IN VARCHAR2 DEFAULT G_MISS_CHAR
453 ,p_segment14 IN VARCHAR2 DEFAULT G_MISS_CHAR
454 ,p_segment15 IN VARCHAR2 DEFAULT G_MISS_CHAR
456 ,p_segment17 IN VARCHAR2 DEFAULT G_MISS_CHAR
457 ,p_segment18 IN VARCHAR2 DEFAULT G_MISS_CHAR
458 ,p_segment19 IN VARCHAR2 DEFAULT G_MISS_CHAR
459 ,p_segment20 IN VARCHAR2 DEFAULT G_MISS_CHAR
463 ,p_end_date_active IN DATE DEFAULT G_MISS_DATE
460 ,p_summary_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
461 ,p_enabled_flag IN VARCHAR2 DEFAULT G_MISS_CHAR
462 ,p_start_date_active IN DATE DEFAULT G_MISS_DATE
464 ,p_attribute_category IN VARCHAR2 DEFAULT G_MISS_CHAR
465 ,p_attribute1 IN VARCHAR2 DEFAULT G_MISS_CHAR
466 ,p_attribute2 IN VARCHAR2 DEFAULT G_MISS_CHAR
467 ,p_attribute3 IN VARCHAR2 DEFAULT G_MISS_CHAR
468 ,p_attribute4 IN VARCHAR2 DEFAULT G_MISS_CHAR
469 ,p_attribute5 IN VARCHAR2 DEFAULT G_MISS_CHAR
470 ,p_attribute6 IN VARCHAR2 DEFAULT G_MISS_CHAR
471 ,p_attribute7 IN VARCHAR2 DEFAULT G_MISS_CHAR
472 ,p_attribute8 IN VARCHAR2 DEFAULT G_MISS_CHAR
473 ,p_attribute9 IN VARCHAR2 DEFAULT G_MISS_CHAR
474 ,p_attribute10 IN VARCHAR2 DEFAULT G_MISS_CHAR
475 ,p_attribute11 IN VARCHAR2 DEFAULT G_MISS_CHAR
476 ,p_attribute12 IN VARCHAR2 DEFAULT G_MISS_CHAR
477 ,p_attribute13 IN VARCHAR2 DEFAULT G_MISS_CHAR
481 ,p_global_attribute1 IN VARCHAR2 DEFAULT G_MISS_CHAR
478 ,p_attribute14 IN VARCHAR2 DEFAULT G_MISS_CHAR
479 ,p_attribute15 IN VARCHAR2 DEFAULT G_MISS_CHAR
480 ,p_global_attribute_category IN VARCHAR2 DEFAULT G_MISS_CHAR
482 ,p_global_attribute2 IN VARCHAR2 DEFAULT G_MISS_CHAR
483 ,p_global_attribute3 IN VARCHAR2 DEFAULT G_MISS_CHAR
484 ,p_global_attribute4 IN VARCHAR2 DEFAULT G_MISS_CHAR
485 ,p_global_attribute5 IN VARCHAR2 DEFAULT G_MISS_CHAR
486 ,p_global_attribute6 IN VARCHAR2 DEFAULT G_MISS_CHAR
487 ,p_global_attribute7 IN VARCHAR2 DEFAULT G_MISS_CHAR
488 ,p_global_attribute8 IN VARCHAR2 DEFAULT G_MISS_CHAR
489 ,p_global_attribute9 IN VARCHAR2 DEFAULT G_MISS_CHAR
490 ,p_global_attribute10 IN VARCHAR2 DEFAULT G_MISS_CHAR
491 ,p_creation_date IN DATE DEFAULT G_MISS_DATE
492 ,p_created_by IN NUMBER DEFAULT G_MISS_NUM
493 ,p_last_update_date IN DATE DEFAULT G_MISS_DATE
494 ,p_last_updated_by IN NUMBER DEFAULT G_MISS_NUM
495 ,p_last_update_login IN NUMBER DEFAULT G_MISS_NUM
496 ,p_request_id IN NUMBER DEFAULT G_MISS_NUM
497 ,p_program_application_id IN NUMBER DEFAULT G_MISS_NUM
498 ,p_program_id IN NUMBER DEFAULT G_MISS_NUM
499 ,p_program_update_date IN DATE DEFAULT G_MISS_DATE
500 ,p_lifecycle_id IN NUMBER DEFAULT G_MISS_NUM
501 ,p_current_phase_id IN NUMBER DEFAULT G_MISS_NUM
502 -- Returned item id
503 ,x_Inventory_Item_Id OUT NOCOPY NUMBER
504 ,x_Organization_Id OUT NOCOPY NUMBER
505 ,x_return_status OUT NOCOPY VARCHAR2
506 ,x_msg_count OUT NOCOPY NUMBER
507 ,x_msg_data OUT NOCOPY VARCHAR2
508 );
509
510
511 -- -----------------------------------------------------------------------------
512 -- API Name: Process_Item
513 --
514 -- Type:
515 --
516 -- Description:
517 -- Process (UPDATE) one item. To be used from PLM UI only
518 --
519 -- Version: Current version 1.0
520 -- History:
521 -- 20-JAN-2002 Sridhar R Removed the default to FND_API values
522 -- in the procedure process_item
523 -- -----------------------------------------------------------------------------
524 PROCEDURE Process_Item
525 (
526 p_api_version IN NUMBER
527 , p_init_msg_list IN VARCHAR2
528 , p_commit IN VARCHAR2
529 -- Transaction data
530 , p_Transaction_Type IN VARCHAR2
531 , p_Language_Code IN VARCHAR2
532 -- Organization
533 , p_Organization_Id IN NUMBER
534 , p_Organization_Code IN VARCHAR2
535 -- Item catalog group
536 , p_Item_Catalog_Group_Id IN NUMBER
537 , p_Catalog_Status_Flag IN VARCHAR2
538 -- Copy item from
539 , p_Template_Id IN NUMBER
540 , p_Template_Name IN VARCHAR2
541 -- Item identifier
542 , p_Inventory_Item_Id IN NUMBER
543 , p_Item_Number IN VARCHAR2
544 , p_Segment1 IN VARCHAR2
545 , p_Segment2 IN VARCHAR2
546 , p_Segment3 IN VARCHAR2
547 , p_Segment4 IN VARCHAR2
548 , p_Segment5 IN VARCHAR2
549 , p_Segment6 IN VARCHAR2
550 , p_Segment7 IN VARCHAR2
551 , p_Segment8 IN VARCHAR2
552 , p_Segment9 IN VARCHAR2
553 , p_Segment10 IN VARCHAR2
554 , p_Segment11 IN VARCHAR2
555 , p_Segment12 IN VARCHAR2
556 , p_Segment13 IN VARCHAR2
557 , p_Segment14 IN VARCHAR2
558 , p_Segment15 IN VARCHAR2
559 , p_Segment16 IN VARCHAR2
560 , p_Segment17 IN VARCHAR2
561 , p_Segment18 IN VARCHAR2
562 , p_Segment19 IN VARCHAR2
563 , p_Segment20 IN VARCHAR2
564 , p_Object_Version_Number IN NUMBER
565 -- Lifecycle
566 , p_Lifecycle_Id IN NUMBER
567 , p_Current_Phase_Id IN NUMBER
568 -- Main attributes
569 , p_Description IN VARCHAR2
570 , p_Long_Description IN VARCHAR2
571 , p_Primary_Uom_Code IN VARCHAR2
572 , p_Inventory_Item_Status_Code IN VARCHAR2
573 -- BoM/Eng
574 , p_Bom_Enabled_Flag IN VARCHAR2
575 , p_Eng_Item_Flag IN VARCHAR2
576 -- Role Grant
577 , p_Role_Id IN NUMBER
578 , p_Role_Name IN VARCHAR2
579 , p_Grantee_Party_Type IN VARCHAR2
580 , p_Grantee_Party_Id IN NUMBER
581 , p_Grantee_Party_Name IN VARCHAR2
582 , p_Grant_Start_Date IN DATE
583 , p_Grant_End_Date IN DATE
584 -- Returned item id
585 , x_Inventory_Item_Id OUT NOCOPY NUMBER
586 , x_Organization_Id OUT NOCOPY NUMBER
587 --
588 , x_return_status OUT NOCOPY VARCHAR2
589 , x_msg_count OUT NOCOPY NUMBER
590 );
591
592 -- -----------------------------------------------------------------------------
593 -- API Name: Get_Item_Count
594 --
595 -- Type:
596 --
597 -- Description:
598 -- Returns the Item Count for a particular organization and
599 -- a catalog group
600 --
601 -- Version: Current version 1.0
602 -- History:
603 -- 04-MAR-2003 Aswin Sampathkumaran Created
604 --
605 -- -----------------------------------------------------------------------------
606
607 FUNCTION Get_Item_Count (
608 p_catalog_group_id IN NUMBER,
609 p_organization_id IN NUMBER,
610 p_item_type IN VARCHAR2 DEFAULT NULL
611 ) RETURN NUMBER;
612
613 FUNCTION Get_Category_Item_Count(
614 P_CATEGORY_SET_ID IN NUMBER,
615 p_CATEGORY_ID IN NUMBER,
616 P_ORGANIZATION_ID IN NUMBER,
617 P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
618 )
619 RETURN NUMBER;
620
621 FUNCTION Get_Category_Hierarchy_Names(
622 P_CATEGORY_SET_ID IN NUMBER,
623 P_CATEGORY_ID IN NUMBER
624 )
625 RETURN VARCHAR2;
626
627
628 END EGO_UI_ITEM_PUB;