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