[Home] [Help]
PACKAGE: APPS.MTL_PARAMETERS_PKG
Source
1 PACKAGE mtl_parameters_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVSDOOS.pls 120.9.12020000.3 2013/01/30 15:06:28 avrose ship $ */
3 g_pkg_name CONSTANT VARCHAR2(30) := 'MTL_PARAMETERS_PKG';
4
5 PROCEDURE insert_row(
6 x_rowid IN OUT NOCOPY VARCHAR2
7 , x_organization_id NUMBER
8 , x_last_update_date DATE
9 , x_last_updated_by NUMBER
10 , x_creation_date DATE
11 , x_created_by NUMBER
12 , x_last_update_login NUMBER
13 , x_organization_code VARCHAR2
14 , x_master_organization_id NUMBER
15 , x_primary_cost_method NUMBER
16 , x_cost_organization_id NUMBER
17 , x_default_material_cost_id NUMBER
18 , x_default_matl_ovhd_cost_id NUMBER
19 , x_calendar_exception_set_id NUMBER
20 , x_calendar_code VARCHAR2
21 , x_general_ledger_update_code NUMBER
22 , x_default_atp_rule_id NUMBER
23 , x_default_picking_rule_id NUMBER
24 , x_default_locator_order_value NUMBER
25 , x_default_subinv_order_value NUMBER
26 , x_negative_inv_receipt_code NUMBER
27 , x_stock_locator_control_code NUMBER
28 , x_material_account NUMBER
29 , x_material_overhead_account NUMBER
30 , x_matl_ovhd_absorption_acct NUMBER
31 , x_resource_account NUMBER
32 , x_purchase_price_var_account NUMBER
33 , x_ap_accrual_account NUMBER
34 , x_overhead_account NUMBER
35 , x_outside_processing_account NUMBER
36 , x_intransit_inv_account NUMBER
37 , x_interorg_receivables_account NUMBER
38 , x_interorg_price_var_account NUMBER
39 , x_interorg_payables_account NUMBER
40 , x_cost_of_sales_account NUMBER
41 , x_encumbrance_account NUMBER
42 , x_interorg_transfer_cr_account NUMBER
43 , x_matl_interorg_transfer_code NUMBER
44 , x_interorg_trnsfr_charge_perc NUMBER
45 , x_source_organization_id NUMBER
46 , x_source_subinventory VARCHAR2
47 , x_source_type NUMBER
48 , x_serial_number_type NUMBER
49 , x_auto_serial_alpha_prefix VARCHAR2
50 , x_start_auto_serial_number VARCHAR2
51 , x_auto_lot_alpha_prefix VARCHAR2
52 , x_lot_number_uniqueness NUMBER
53 , x_lot_number_generation NUMBER
54 , x_lot_number_zero_padding NUMBER
55 , x_lot_number_length NUMBER
56 , x_starting_revision VARCHAR2
57 , x_attribute_category VARCHAR2
58 , x_attribute1 VARCHAR2
59 , x_attribute2 VARCHAR2
60 , x_attribute3 VARCHAR2
61 , x_attribute4 VARCHAR2
62 , x_attribute5 VARCHAR2
63 , x_attribute6 VARCHAR2
64 , x_attribute7 VARCHAR2
65 , x_attribute8 VARCHAR2
66 , x_attribute9 VARCHAR2
67 , x_attribute10 VARCHAR2
68 , x_attribute11 VARCHAR2
69 , x_attribute12 VARCHAR2
70 , x_attribute13 VARCHAR2
71 , x_attribute14 VARCHAR2
72 , x_attribute15 VARCHAR2
73 , x_global_attribute_category VARCHAR2
74 , x_global_attribute1 VARCHAR2
75 , x_global_attribute2 VARCHAR2
76 , x_global_attribute3 VARCHAR2
77 , x_global_attribute4 VARCHAR2
78 , x_global_attribute5 VARCHAR2
79 , x_global_attribute6 VARCHAR2
80 , x_global_attribute7 VARCHAR2
81 , x_global_attribute8 VARCHAR2
82 , x_global_attribute9 VARCHAR2
83 , x_global_attribute10 VARCHAR2
84 , x_global_attribute11 VARCHAR2
85 , x_global_attribute12 VARCHAR2
86 , x_global_attribute13 VARCHAR2
87 , x_global_attribute14 VARCHAR2
88 , x_global_attribute15 VARCHAR2
89 , x_global_attribute16 VARCHAR2
90 , x_global_attribute17 VARCHAR2
91 , x_global_attribute18 VARCHAR2
92 , x_global_attribute19 VARCHAR2
93 , x_global_attribute20 VARCHAR2
94 , x_default_demand_class VARCHAR2
95 , x_encumbrance_reversal_flag NUMBER
96 , x_maintain_fifo_qty_stack_type NUMBER
97 , x_invoice_price_var_account NUMBER
98 , x_average_cost_var_account NUMBER
99 -- For Bug 7440217
100 , x_lcm_var_account NUMBER
101 -- End for Bug 7440217
102 , x_cat_wt_account NUMBER -- MUOM Fulfillment Project
103 , x_sales_account NUMBER
104 , x_expense_account NUMBER
105 , x_serial_number_generation NUMBER
106 , x_project_reference_enabled NUMBER
107 , x_pm_cost_collection_enabled NUMBER
108 , x_project_control_level NUMBER
109 , x_avg_rates_cost_type_id NUMBER
110 , x_txn_approval_timeout_period NUMBER
111 , x_borrpay_matl_var_account NUMBER
112 , x_borrpay_moh_var_account NUMBER
113 , x_borrpay_res_var_account NUMBER
114 , x_borrpay_osp_var_account NUMBER
115 , x_borrpay_ovh_var_account NUMBER
116 , x_org_max_weight NUMBER
117 , x_org_max_volume NUMBER
118 , x_org_max_weight_uom_code VARCHAR2
119 , x_org_max_volume_uom_code VARCHAR2
120 , x_mo_source_required NUMBER
121 , x_mo_pick_confirm_required NUMBER
122 , x_mo_approval_timeout_action NUMBER
123 , x_project_cost_account NUMBER
124 , x_process_enabled_flag VARCHAR2
125 , x_process_orgn_code VARCHAR2
126 , x_default_cost_group_id NUMBER
127 , x_lpn_prefix VARCHAR2
128 , x_lpn_suffix VARCHAR2
129 , x_lpn_starting_number NUMBER
130 , x_wms_enabled_flag VARCHAR2
131 -- For Bug 7440217
132 , x_lcm_enabled_flag VARCHAR2
133 -- End for Bug 7440217
134 , x_qa_skipping_insp_flag VARCHAR2
135 , x_eam_enabled_flag VARCHAR2
136 , x_maint_organization_id NUMBER
137 , x_pregen_putaway_tasks_flag NUMBER
138 , x_regeneration_interval NUMBER
139 , x_timezone_id NUMBER
140 , x_default_wms_picking_rule_id NUMBER
141 , x_default_put_away_rule_id NUMBER
142 , x_default_carton_rule_id NUMBER
143 , x_default_cyc_count_header_id NUMBER
144 , x_crossdock_flag NUMBER
145 , x_cartonization_flag NUMBER
146 , x_allocate_serial_flag VARCHAR2
147 , X_ALLOCATE_LOT_FLAG varchar2 --FlexiLotAlloc
148 , x_default_pick_task_type_id NUMBER
149 , x_default_repl_task_type_id NUMBER
150 , x_default_cc_task_type_id NUMBER
151 , x_default_putaway_task_type_id NUMBER
152 , x_cost_cutoff_date DATE
153 , x_skip_task_waiting_minutes NUMBER
154 , x_prioritize_wip_jobs NUMBER
155 , x_default_xdock_subinventory VARCHAR2
156 , x_default_xdock_locator_id NUMBER
157 , x_distri_organization_flag VARCHAR2
158 , x_carrier_manifesting_flag VARCHAR2
159 , x_distribution_account_id NUMBER
160 , x_direct_shipping_allowed VARCHAR2
161 , x_default_moxfer_task_type_id NUMBER
162 , x_default_moissue_task_type_id NUMBER
163 , x_max_clusters_allowed NUMBER DEFAULT NULL
164 , x_default_pick_op_plan_id NUMBER DEFAULT 1
165 , x_consigned_flag VARCHAR2 DEFAULT NULL
166 , x_cartonize_sales_orders VARCHAR2 DEFAULT 'Y'
167 , x_cartonize_manufacturing VARCHAR2 DEFAULT 'N'
168 , x_total_lpn_length NUMBER DEFAULT NULL
169 , x_ucc_128_suffix_flag VARCHAR2 DEFAULT NULL
170 , x_defer_logical_transactions NUMBER DEFAULT 2
171 , x_wip_overpick_enabled VARCHAR2 DEFAULT 'N' --OVPK
172 , x_ovpk_transfer_orders_enabled VARCHAR2 DEFAULT 'Y' --OVPK
173 , x_auto_del_alloc_flag VARCHAR2 --ER3969328: CI project
174 , X_RFID_VERIF_PCNT_THRESHOLD NUMBER -- 11.5.10+ RFID Compliance
175 , x_parent_child_generation_flag VARCHAR2 DEFAULT NULL
176 , x_child_lot_zero_padding_flag VARCHAR2 DEFAULT NULL
177 , x_child_lot_alpha_prefix VARCHAR2 DEFAULT NULL
178 , x_child_lot_number_length NUMBER DEFAULT NULL
179 , x_child_lot_validation_flag VARCHAR2 DEFAULT NULL
180 , x_copy_lot_attribute_flag VARCHAR2 DEFAULT NULL
181 , x_create_lot_uom_conversion NUMBER DEFAULT NULL -- NSINHA
182 , x_allow_different_status NUMBER DEFAULT NULL -- NSINHA
183 , x_rules_override_lot_reserve VARCHAR2 DEFAULT NULL -- NSINHA
184 , x_wcs_enabled VARCHAR2 DEFAULT 'N' -- MHP
185 , x_trading_partner_org_flag VARCHAR2 DEFAULT NULL
186 , x_deferred_cogs_account NUMBER DEFAULT NULL
187 , x_default_crossdok_criteria_id NUMBER DEFAULT NULL
188 , x_enforce_locator_alis_uq_flag VARCHAR2 DEFAULT NULL
189 , x_epc_generation_enabled_flag VARCHAR2 DEFAULT NULL
190 , x_company_prefix VARCHAR2 DEFAULT NULL
191 , x_company_prefix_index VARCHAR2 DEFAULT NULL
192 , x_commercial_gov_entity_number VARCHAR2 DEFAULT NULL
193 , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
194 , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
195 , x_opsm_enabled_flag VARCHAR2 -- Added for OPSM by
196 );
197
198 PROCEDURE lock_row(
199 x_rowid VARCHAR2
200 , x_organization_id NUMBER
201 , x_organization_code VARCHAR2
202 , x_master_organization_id NUMBER
203 , x_primary_cost_method NUMBER
204 , x_cost_organization_id NUMBER
205 , x_default_material_cost_id NUMBER
206 , x_default_matl_ovhd_cost_id NUMBER
207 , x_calendar_exception_set_id NUMBER
208 , x_calendar_code VARCHAR2
209 , x_general_ledger_update_code NUMBER
210 , x_default_atp_rule_id NUMBER
211 , x_default_picking_rule_id NUMBER
212 , x_default_locator_order_value NUMBER
213 , x_default_subinv_order_value NUMBER
214 , x_negative_inv_receipt_code NUMBER
215 , x_stock_locator_control_code NUMBER
216 , x_material_account NUMBER
217 , x_material_overhead_account NUMBER
218 , x_matl_ovhd_absorption_acct NUMBER
219 , x_resource_account NUMBER
220 , x_purchase_price_var_account NUMBER
221 , x_ap_accrual_account NUMBER
222 , x_overhead_account NUMBER
223 , x_outside_processing_account NUMBER
224 , x_intransit_inv_account NUMBER
225 , x_interorg_receivables_account NUMBER
226 , x_interorg_price_var_account NUMBER
227 , x_interorg_payables_account NUMBER
228 , x_cost_of_sales_account NUMBER
229 , x_encumbrance_account NUMBER
230 , x_interorg_transfer_cr_account NUMBER
231 , x_matl_interorg_transfer_code NUMBER
232 , x_interorg_trnsfr_charge_perc NUMBER
233 , x_source_organization_id NUMBER
234 , x_source_subinventory VARCHAR2
235 , x_source_type NUMBER
236 , x_serial_number_type NUMBER
237 , x_auto_serial_alpha_prefix VARCHAR2
238 , x_start_auto_serial_number VARCHAR2
239 , x_auto_lot_alpha_prefix VARCHAR2
240 , x_lot_number_uniqueness NUMBER
241 , x_lot_number_generation NUMBER
242 , x_lot_number_zero_padding NUMBER
243 , x_lot_number_length NUMBER
244 , x_starting_revision VARCHAR2
245 , x_attribute_category VARCHAR2
246 , x_attribute1 VARCHAR2
247 , x_attribute2 VARCHAR2
248 , x_attribute3 VARCHAR2
249 , x_attribute4 VARCHAR2
250 , x_attribute5 VARCHAR2
251 , x_attribute6 VARCHAR2
252 , x_attribute7 VARCHAR2
253 , x_attribute8 VARCHAR2
254 , x_attribute9 VARCHAR2
255 , x_attribute10 VARCHAR2
256 , x_attribute11 VARCHAR2
257 , x_attribute12 VARCHAR2
258 , x_attribute13 VARCHAR2
259 , x_attribute14 VARCHAR2
260 , x_attribute15 VARCHAR2
261 , x_global_attribute_category VARCHAR2
262 , x_global_attribute1 VARCHAR2
263 , x_global_attribute2 VARCHAR2
264 , x_global_attribute3 VARCHAR2
265 , x_global_attribute4 VARCHAR2
266 , x_global_attribute5 VARCHAR2
267 , x_global_attribute6 VARCHAR2
268 , x_global_attribute7 VARCHAR2
269 , x_global_attribute8 VARCHAR2
270 , x_global_attribute9 VARCHAR2
271 , x_global_attribute10 VARCHAR2
272 , x_global_attribute11 VARCHAR2
273 , x_global_attribute12 VARCHAR2
274 , x_global_attribute13 VARCHAR2
275 , x_global_attribute14 VARCHAR2
276 , x_global_attribute15 VARCHAR2
277 , x_global_attribute16 VARCHAR2
278 , x_global_attribute17 VARCHAR2
279 , x_global_attribute18 VARCHAR2
280 , x_global_attribute19 VARCHAR2
281 , x_global_attribute20 VARCHAR2
282 , x_default_demand_class VARCHAR2
283 , x_encumbrance_reversal_flag NUMBER
284 , x_maintain_fifo_qty_stack_type NUMBER
285 , x_invoice_price_var_account NUMBER
286 , x_average_cost_var_account NUMBER
287 -- For Bug 7440217
288 , x_lcm_var_account NUMBER
289 -- End for Bug 7440217
290 , x_cat_wt_account NUMBER -- MUOM Fulfillment Project
291 , x_sales_account NUMBER
292 , x_expense_account NUMBER
293 , x_serial_number_generation NUMBER
294 , x_project_reference_enabled NUMBER
295 , x_pm_cost_collection_enabled NUMBER
296 , x_project_control_level NUMBER
297 , x_avg_rates_cost_type_id NUMBER
298 , x_txn_approval_timeout_period NUMBER
299 , x_borrpay_matl_var_account NUMBER
300 , x_borrpay_moh_var_account NUMBER
301 , x_borrpay_res_var_account NUMBER
302 , x_borrpay_osp_var_account NUMBER
303 , x_borrpay_ovh_var_account NUMBER
304 , x_org_max_weight NUMBER
305 , x_org_max_volume NUMBER
306 , x_org_max_weight_uom_code VARCHAR2
307 , x_org_max_volume_uom_code VARCHAR2
308 , x_mo_source_required NUMBER
309 , x_mo_pick_confirm_required NUMBER
310 , x_mo_approval_timeout_action NUMBER
311 , x_project_cost_account NUMBER
312 , x_process_enabled_flag VARCHAR2
313 , x_process_orgn_code VARCHAR2
314 , x_default_cost_group_id NUMBER
315 , x_lpn_prefix VARCHAR2
316 , x_lpn_suffix VARCHAR2
317 , x_lpn_starting_number NUMBER
318 , x_wms_enabled_flag VARCHAR2
319 -- For Bug 7440217
320 , x_lcm_enabled_flag VARCHAR2
321 -- End for Bug 7440217
322 , x_qa_skipping_insp_flag VARCHAR2
323 , x_eam_enabled_flag VARCHAR2
324 , x_maint_organization_id NUMBER
325 , x_pregen_putaway_tasks_flag NUMBER
329 , x_default_put_away_rule_id NUMBER
326 , x_regeneration_interval NUMBER
327 , x_timezone_id NUMBER
328 , x_default_wms_picking_rule_id NUMBER
330 , x_default_carton_rule_id NUMBER
331 , x_default_cyc_count_header_id NUMBER
332 , x_crossdock_flag NUMBER
333 , x_cartonization_flag NUMBER
334 , x_allocate_serial_flag VARCHAR2
335 , X_ALLOCATE_LOT_FLAG varchar2 --FlexiLotAlloc
336 , x_default_pick_task_type_id NUMBER
337 , x_default_repl_task_type_id NUMBER
338 , x_default_cc_task_type_id NUMBER
339 , x_default_putaway_task_type_id NUMBER
340 , x_cost_cutoff_date DATE
341 , x_skip_task_waiting_minutes NUMBER
342 , x_prioritize_wip_jobs NUMBER
343 , x_default_xdock_subinventory VARCHAR2
344 , x_default_xdock_locator_id NUMBER
345 , x_distri_organization_flag VARCHAR2
346 , x_carrier_manifesting_flag VARCHAR2
347 , x_distribution_account_id NUMBER
348 , x_direct_shipping_allowed VARCHAR2
349 , x_default_moxfer_task_type_id NUMBER
350 , x_default_moissue_task_type_id NUMBER
351 , x_max_clusters_allowed NUMBER DEFAULT NULL
352 , x_default_pick_op_plan_id NUMBER DEFAULT 1
353 , x_consigned_flag VARCHAR2 DEFAULT NULL
354 , x_cartonize_sales_orders VARCHAR2 DEFAULT 'Y'
355 , x_cartonize_manufacturing VARCHAR2 DEFAULT 'N'
356 , x_total_lpn_length NUMBER DEFAULT NULL
357 , x_ucc_128_suffix_flag VARCHAR2 DEFAULT NULL
358 , x_defer_logical_transactions NUMBER DEFAULT 2
359 , x_wip_overpick_enabled VARCHAR2 DEFAULT 'N' --OVPK
360 , x_ovpk_transfer_orders_enabled VARCHAR2 DEFAULT 'Y' --OVPK
361 , x_auto_del_alloc_flag VARCHAR2 --ER3969328: CI project
362 , X_RFID_VERIF_PCNT_THRESHOLD NUMBER -- 11.5.10+ RFID Compliance
363 , x_parent_child_generation_flag VARCHAR2 DEFAULT NULL
364 , x_child_lot_zero_padding_flag VARCHAR2 DEFAULT NULL
365 , x_child_lot_alpha_prefix VARCHAR2 DEFAULT NULL
366 , x_child_lot_number_length NUMBER DEFAULT NULL
367 , x_child_lot_validation_flag VARCHAR2 DEFAULT NULL
368 , x_copy_lot_attribute_flag VARCHAR2 DEFAULT NULL
369 , x_create_lot_uom_conversion NUMBER DEFAULT NULL -- NSINHA
370 , x_allow_different_status NUMBER DEFAULT NULL -- NSINHA
371 , x_rules_override_lot_reserve VARCHAR2 DEFAULT NULL -- NSINHA
372 , x_wcs_enabled VARCHAR2 DEFAULT 'N' -- MHP
373 , x_trading_partner_org_flag VARCHAR2 DEFAULT NULL
374 , x_deferred_cogs_account NUMBER DEFAULT NULL
375 , x_default_crossdok_criteria_id NUMBER DEFAULT NULL
376 , x_enforce_locator_alis_uq_flag VARCHAR2 DEFAULT NULL
377 , x_epc_generation_enabled_flag VARCHAR2 DEFAULT NULL
378 , x_company_prefix VARCHAR2 DEFAULT NULL
379 , x_company_prefix_index VARCHAR2 DEFAULT NULL
380 , x_commercial_gov_entity_number VARCHAR2 DEFAULT NULL
381 , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
382 , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
383 , x_opsm_enabled_flag VARCHAR2 -- Added for OPSM by
384 );
385
386 PROCEDURE update_row(
387 x_rowid VARCHAR2
388 , x_organization_id NUMBER
389 , x_last_update_date DATE
390 , x_last_updated_by NUMBER
391 , x_last_update_login NUMBER
392 , x_organization_code VARCHAR2
393 , x_master_organization_id NUMBER
394 , x_primary_cost_method NUMBER
395 , x_cost_organization_id NUMBER
396 , x_default_material_cost_id NUMBER
397 , x_default_matl_ovhd_cost_id NUMBER
398 , x_calendar_exception_set_id NUMBER
399 , x_calendar_code VARCHAR2
400 , x_general_ledger_update_code NUMBER
401 , x_default_atp_rule_id NUMBER
402 , x_default_picking_rule_id NUMBER
403 , x_default_locator_order_value NUMBER
404 , x_default_subinv_order_value NUMBER
405 , x_negative_inv_receipt_code NUMBER
406 , x_stock_locator_control_code NUMBER
407 , x_material_account NUMBER
408 , x_material_overhead_account NUMBER
409 , x_matl_ovhd_absorption_acct NUMBER
410 , x_resource_account NUMBER
411 , x_purchase_price_var_account NUMBER
412 , x_ap_accrual_account NUMBER
413 , x_overhead_account NUMBER
414 , x_outside_processing_account NUMBER
415 , x_intransit_inv_account NUMBER
416 , x_interorg_receivables_account NUMBER
417 , x_interorg_price_var_account NUMBER
418 , x_interorg_payables_account NUMBER
419 , x_cost_of_sales_account NUMBER
420 , x_encumbrance_account NUMBER
421 , x_interorg_transfer_cr_account NUMBER
422 , x_matl_interorg_transfer_code NUMBER
423 , x_interorg_trnsfr_charge_perc NUMBER
424 , x_source_organization_id NUMBER
425 , x_source_subinventory VARCHAR2
426 , x_source_type NUMBER
427 , x_serial_number_type NUMBER
428 , x_auto_serial_alpha_prefix VARCHAR2
429 , x_start_auto_serial_number VARCHAR2
430 , x_auto_lot_alpha_prefix VARCHAR2
431 , x_lot_number_uniqueness NUMBER
432 , x_lot_number_generation NUMBER
433 , x_lot_number_zero_padding NUMBER
434 , x_lot_number_length NUMBER
435 , x_starting_revision VARCHAR2
436 , x_attribute_category VARCHAR2
437 , x_attribute1 VARCHAR2
438 , x_attribute2 VARCHAR2
439 , x_attribute3 VARCHAR2
443 , x_attribute7 VARCHAR2
440 , x_attribute4 VARCHAR2
441 , x_attribute5 VARCHAR2
442 , x_attribute6 VARCHAR2
444 , x_attribute8 VARCHAR2
445 , x_attribute9 VARCHAR2
446 , x_attribute10 VARCHAR2
447 , x_attribute11 VARCHAR2
448 , x_attribute12 VARCHAR2
449 , x_attribute13 VARCHAR2
450 , x_attribute14 VARCHAR2
451 , x_attribute15 VARCHAR2
452 , x_global_attribute_category VARCHAR2
453 , x_global_attribute1 VARCHAR2
454 , x_global_attribute2 VARCHAR2
455 , x_global_attribute3 VARCHAR2
456 , x_global_attribute4 VARCHAR2
457 , x_global_attribute5 VARCHAR2
458 , x_global_attribute6 VARCHAR2
459 , x_global_attribute7 VARCHAR2
460 , x_global_attribute8 VARCHAR2
461 , x_global_attribute9 VARCHAR2
462 , x_global_attribute10 VARCHAR2
463 , x_global_attribute11 VARCHAR2
464 , x_global_attribute12 VARCHAR2
465 , x_global_attribute13 VARCHAR2
466 , x_global_attribute14 VARCHAR2
467 , x_global_attribute15 VARCHAR2
468 , x_global_attribute16 VARCHAR2
469 , x_global_attribute17 VARCHAR2
470 , x_global_attribute18 VARCHAR2
471 , x_global_attribute19 VARCHAR2
472 , x_global_attribute20 VARCHAR2
473 , x_default_demand_class VARCHAR2
474 , x_encumbrance_reversal_flag NUMBER
475 , x_maintain_fifo_qty_stack_type NUMBER
476 , x_invoice_price_var_account NUMBER
477 , x_average_cost_var_account NUMBER
478 -- For Bug 7440217
479 , x_lcm_var_account NUMBER
480 -- End for Bug 7440217
481 , x_cat_wt_account NUMBER -- MUOM Fulfillment Project
482 , x_sales_account NUMBER
483 , x_expense_account NUMBER
484 , x_serial_number_generation NUMBER
485 , x_project_reference_enabled NUMBER
486 , x_pm_cost_collection_enabled NUMBER
487 , x_project_control_level NUMBER
488 , x_avg_rates_cost_type_id NUMBER
489 , x_txn_approval_timeout_period NUMBER
490 , x_borrpay_matl_var_account NUMBER
491 , x_borrpay_moh_var_account NUMBER
492 , x_borrpay_res_var_account NUMBER
493 , x_borrpay_osp_var_account NUMBER
494 , x_borrpay_ovh_var_account NUMBER
495 , x_org_max_weight NUMBER
496 , x_org_max_volume NUMBER
497 , x_org_max_weight_uom_code VARCHAR2
498 , x_org_max_volume_uom_code VARCHAR2
499 , x_mo_source_required NUMBER
500 , x_mo_pick_confirm_required NUMBER
501 , x_mo_approval_timeout_action NUMBER
502 , x_project_cost_account NUMBER
503 , x_process_enabled_flag VARCHAR2
504 , x_process_orgn_code VARCHAR2
505 , x_default_cost_group_id NUMBER
506 , x_lpn_prefix VARCHAR2
507 , x_lpn_suffix VARCHAR2
508 , x_lpn_starting_number NUMBER
509 , x_wms_enabled_flag VARCHAR2
510 -- For Bug 7440217
511 , x_lcm_enabled_flag VARCHAR2
512 -- End for Bug 7440217
513 , x_qa_skipping_insp_flag VARCHAR2
514 , x_eam_enabled_flag VARCHAR2
515 , x_maint_organization_id NUMBER
516 , x_pregen_putaway_tasks_flag NUMBER
517 , x_regeneration_interval NUMBER
518 , x_timezone_id NUMBER
519 , x_default_wms_picking_rule_id NUMBER
520 , x_default_put_away_rule_id NUMBER
521 , x_default_carton_rule_id NUMBER
522 , x_default_cyc_count_header_id NUMBER
523 , x_crossdock_flag NUMBER
524 , x_cartonization_flag NUMBER
525 , x_allocate_serial_flag VARCHAR2
526 , X_ALLOCATE_LOT_FLAG varchar2 --FlexiLotAlloc
527 , x_default_pick_task_type_id NUMBER
528 , x_default_repl_task_type_id NUMBER
529 , x_default_cc_task_type_id NUMBER
530 , x_default_putaway_task_type_id NUMBER
531 , x_cost_cutoff_date DATE
532 , x_skip_task_waiting_minutes NUMBER
533 , x_prioritize_wip_jobs NUMBER
534 , x_default_xdock_subinventory VARCHAR2
535 , x_default_xdock_locator_id NUMBER
536 , x_distri_organization_flag VARCHAR2
537 , x_carrier_manifesting_flag VARCHAR2
538 , x_distribution_account_id NUMBER
539 , x_direct_shipping_allowed VARCHAR2
540 , x_default_moxfer_task_type_id NUMBER
541 , x_default_moissue_task_type_id NUMBER
542 , x_max_clusters_allowed NUMBER DEFAULT NULL
543 , x_default_pick_op_plan_id NUMBER DEFAULT 1
544 , x_consigned_flag VARCHAR2 DEFAULT NULL
545 , x_cartonize_sales_orders VARCHAR2 DEFAULT 'Y'
546 , x_cartonize_manufacturing VARCHAR2 DEFAULT 'N'
547 , x_total_lpn_length NUMBER DEFAULT NULL
548 , x_ucc_128_suffix_flag VARCHAR2 DEFAULT NULL
549 , x_defer_logical_transactions NUMBER DEFAULT 2
550 , x_wip_overpick_enabled VARCHAR2 DEFAULT 'N' --OVPK
551 , x_ovpk_transfer_orders_enabled VARCHAR2 DEFAULT 'Y' --OVPK
552 , x_auto_del_alloc_flag VARCHAR2 --ER3969328: CI project
553 , X_RFID_VERIF_PCNT_THRESHOLD NUMBER -- 11.5.10+ RFID Compliance
554 , x_parent_child_generation_flag VARCHAR2 DEFAULT NULL
555 , x_child_lot_zero_padding_flag VARCHAR2 DEFAULT NULL
556 , x_child_lot_alpha_prefix VARCHAR2 DEFAULT NULL
557 , x_child_lot_number_length NUMBER DEFAULT NULL
558 , x_child_lot_validation_flag VARCHAR2 DEFAULT NULL
559 , x_copy_lot_attribute_flag VARCHAR2 DEFAULT NULL
563 , x_wcs_enabled VARCHAR2 DEFAULT 'N' --MHP
560 , x_create_lot_uom_conversion NUMBER DEFAULT NULL -- NSINHA
561 , x_allow_different_status NUMBER DEFAULT NULL -- NSINHA
562 , x_rules_override_lot_reserve VARCHAR2 DEFAULT NULL -- NSINHA
564 , x_trading_partner_org_flag VARCHAR2 DEFAULT NULL
565 , x_deferred_cogs_account NUMBER DEFAULT NULL
566 , x_default_crossdok_criteria_id NUMBER DEFAULT NULL
567 , x_enforce_locator_alis_uq_flag VARCHAR2 DEFAULT NULL
568 , x_epc_generation_enabled_flag VARCHAR2 DEFAULT NULL
569 , x_company_prefix VARCHAR2 DEFAULT NULL
570 , x_company_prefix_index VARCHAR2 DEFAULT NULL
571 , x_commercial_gov_entity_number VARCHAR2 DEFAULT NULL
572 , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
573 , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
574 , x_opsm_enabled_flag VARCHAR2 -- Added for OPSM by
575 );
576
577 PROCEDURE delete_row(x_rowid VARCHAR2);
578
579 PROCEDURE upd_sub_accts_with_org_accts(
580 x_return_status OUT NOCOPY VARCHAR2
581 , x_msg_count OUT NOCOPY NUMBER
582 , x_msg_data OUT NOCOPY VARCHAR2
583 , p_default_cost_group_id IN NUMBER
584 , p_material_account IN NUMBER
585 , p_material_overhead_account IN NUMBER
586 , p_resource_account IN NUMBER
587 , p_overhead_account IN NUMBER
588 , p_outside_processing_account IN NUMBER
589 , p_expense_account IN NUMBER
590 , p_encumbrance_account IN NUMBER
591 , p_organization_id IN NUMBER
592 );
593
594 FUNCTION get_miss_num
595 RETURN NUMBER;
596
597 PROCEDURE default_pjm_rule_setup(
598 x_return_status OUT NOCOPY VARCHAR2
599 , x_msg_count OUT NOCOPY NUMBER
600 , x_msg_data OUT NOCOPY VARCHAR2
601 , p_organization_id IN NUMBER
602 );
603
604 FUNCTION g_ret_sts_success
605 RETURN VARCHAR2;
606 END mtl_parameters_pkg;