[Home] [Help]
PACKAGE BODY: APPS.MTL_PARAMETERS_PKG
Source
1 PACKAGE BODY mtl_parameters_pkg AS
2 /* $Header: INVSDOOB.pls 120.6.12010000.3 2008/10/13 08:18:53 vssrivat ship $ */
3 PROCEDURE insert_row(
4 x_rowid IN OUT NOCOPY VARCHAR2
5 , x_organization_id NUMBER
6 , x_last_update_date DATE
7 , x_last_updated_by NUMBER
8 , x_creation_date DATE
9 , x_created_by NUMBER
10 , x_last_update_login NUMBER
11 , x_organization_code VARCHAR2
12 , x_master_organization_id NUMBER
13 , x_primary_cost_method NUMBER
14 , x_cost_organization_id NUMBER
15 , x_default_material_cost_id NUMBER
16 , x_default_matl_ovhd_cost_id NUMBER
17 , x_calendar_exception_set_id NUMBER
18 , x_calendar_code VARCHAR2
19 , x_general_ledger_update_code NUMBER
20 , x_default_atp_rule_id NUMBER
21 , x_default_picking_rule_id NUMBER
22 , x_default_locator_order_value NUMBER
23 , x_default_subinv_order_value NUMBER
24 , x_negative_inv_receipt_code NUMBER
25 , x_stock_locator_control_code NUMBER
26 , x_material_account NUMBER
27 , x_material_overhead_account NUMBER
28 , x_matl_ovhd_absorption_acct NUMBER
29 , x_resource_account NUMBER
30 , x_purchase_price_var_account NUMBER
31 , x_ap_accrual_account NUMBER
32 , x_overhead_account NUMBER
33 , x_outside_processing_account NUMBER
34 , x_intransit_inv_account NUMBER
35 , x_interorg_receivables_account NUMBER
36 , x_interorg_price_var_account NUMBER
37 , x_interorg_payables_account NUMBER
38 , x_cost_of_sales_account NUMBER
39 , x_encumbrance_account NUMBER
40 , x_interorg_transfer_cr_account NUMBER
41 , x_matl_interorg_transfer_code NUMBER
42 , x_interorg_trnsfr_charge_perc NUMBER
43 , x_source_organization_id NUMBER
44 , x_source_subinventory VARCHAR2
45 , x_source_type NUMBER
46 , x_serial_number_type NUMBER
47 , x_auto_serial_alpha_prefix VARCHAR2
48 , x_start_auto_serial_number VARCHAR2
49 , x_auto_lot_alpha_prefix VARCHAR2
50 , x_lot_number_uniqueness NUMBER
51 , x_lot_number_generation NUMBER
52 , x_lot_number_zero_padding NUMBER
53 , x_lot_number_length NUMBER
54 , x_starting_revision VARCHAR2
55 , x_attribute_category VARCHAR2
56 , x_attribute1 VARCHAR2
57 , x_attribute2 VARCHAR2
58 , x_attribute3 VARCHAR2
59 , x_attribute4 VARCHAR2
60 , x_attribute5 VARCHAR2
61 , x_attribute6 VARCHAR2
62 , x_attribute7 VARCHAR2
63 , x_attribute8 VARCHAR2
64 , x_attribute9 VARCHAR2
65 , x_attribute10 VARCHAR2
66 , x_attribute11 VARCHAR2
67 , x_attribute12 VARCHAR2
68 , x_attribute13 VARCHAR2
69 , x_attribute14 VARCHAR2
70 , x_attribute15 VARCHAR2
71 , x_global_attribute_category VARCHAR2
72 , x_global_attribute1 VARCHAR2
73 , x_global_attribute2 VARCHAR2
74 , x_global_attribute3 VARCHAR2
75 , x_global_attribute4 VARCHAR2
76 , x_global_attribute5 VARCHAR2
77 , x_global_attribute6 VARCHAR2
78 , x_global_attribute7 VARCHAR2
79 , x_global_attribute8 VARCHAR2
80 , x_global_attribute9 VARCHAR2
81 , x_global_attribute10 VARCHAR2
82 , x_global_attribute11 VARCHAR2
83 , x_global_attribute12 VARCHAR2
84 , x_global_attribute13 VARCHAR2
85 , x_global_attribute14 VARCHAR2
86 , x_global_attribute15 VARCHAR2
87 , x_global_attribute16 VARCHAR2
88 , x_global_attribute17 VARCHAR2
89 , x_global_attribute18 VARCHAR2
90 , x_global_attribute19 VARCHAR2
91 , x_global_attribute20 VARCHAR2
92 , x_default_demand_class VARCHAR2
93 , x_encumbrance_reversal_flag NUMBER
94 , x_maintain_fifo_qty_stack_type NUMBER
95 , x_invoice_price_var_account NUMBER
96 , x_average_cost_var_account NUMBER
97 -- For Bug 7440217 Variance Account for LCM
98 , x_lcm_var_account NUMBER
99 -- End for Bug 7440217
100 , x_sales_account NUMBER
101 , x_expense_account NUMBER
102 , x_serial_number_generation NUMBER
103 , x_project_reference_enabled NUMBER
104 , x_pm_cost_collection_enabled NUMBER
105 , x_project_control_level NUMBER
106 , x_avg_rates_cost_type_id NUMBER
107 , x_txn_approval_timeout_period NUMBER
108 , x_borrpay_matl_var_account NUMBER
109 , x_borrpay_moh_var_account NUMBER
110 , x_borrpay_res_var_account NUMBER
111 , x_borrpay_osp_var_account NUMBER
112 , x_borrpay_ovh_var_account NUMBER
113 , x_org_max_weight NUMBER
114 , x_org_max_volume NUMBER
115 , x_org_max_weight_uom_code VARCHAR2
116 , x_org_max_volume_uom_code VARCHAR2
117 , x_mo_source_required NUMBER
118 , x_mo_pick_confirm_required NUMBER
119 , x_mo_approval_timeout_action NUMBER
120 , x_project_cost_account NUMBER
121 , x_process_enabled_flag VARCHAR2
122 , x_process_orgn_code VARCHAR2
123 , x_default_cost_group_id NUMBER
124 , x_lpn_prefix VARCHAR2
125 , x_lpn_suffix VARCHAR2
126 , x_lpn_starting_number NUMBER
127 , x_wms_enabled_flag VARCHAR2
128 -- For Bug 7440217 LCM Enabled Flag
129 , x_lcm_enabled_flag VARCHAR2
130 -- End for Bug 7440217
131 , x_qa_skipping_insp_flag VARCHAR2
132 , x_eam_enabled_flag VARCHAR2
133 , x_maint_organization_id NUMBER
134 , x_pregen_putaway_tasks_flag NUMBER
135 , x_regeneration_interval NUMBER
136 , x_timezone_id NUMBER
137 , x_default_wms_picking_rule_id NUMBER
138 , x_default_put_away_rule_id NUMBER
139 , x_default_carton_rule_id NUMBER
140 , x_default_cyc_count_header_id NUMBER
141 , x_crossdock_flag NUMBER
142 , x_cartonization_flag NUMBER
143 , x_allocate_serial_flag VARCHAR2
144 , x_default_pick_task_type_id NUMBER
145 , x_default_repl_task_type_id NUMBER
146 , x_default_cc_task_type_id NUMBER
147 , x_default_putaway_task_type_id NUMBER
148 , x_cost_cutoff_date DATE
149 , x_skip_task_waiting_minutes NUMBER
150 , x_prioritize_wip_jobs NUMBER
151 , x_default_xdock_subinventory VARCHAR2
152 , x_default_xdock_locator_id NUMBER
153 , x_distri_organization_flag VARCHAR2
154 , x_carrier_manifesting_flag VARCHAR2
155 , x_distribution_account_id NUMBER
156 , x_direct_shipping_allowed VARCHAR2
157 , x_default_moxfer_task_type_id NUMBER
158 , x_default_moissue_task_type_id NUMBER
159 , x_max_clusters_allowed NUMBER
160 , x_default_pick_op_plan_id NUMBER
161 , x_consigned_flag VARCHAR2
162 , x_cartonize_sales_orders VARCHAR2
163 , x_cartonize_manufacturing VARCHAR2
164 , x_total_lpn_length NUMBER
165 , x_ucc_128_suffix_flag VARCHAR2
166 , x_defer_logical_transactions NUMBER
167 , x_wip_overpick_enabled VARCHAR2 --OVPK
168 , x_ovpk_transfer_orders_enabled VARCHAR2 --OVPK
169 , x_auto_del_alloc_flag VARCHAR2 --ER3969328: CI project
170 , X_RFID_VERIF_PCNT_THRESHOLD NUMBER --11.5.10+ RFID compliance
171 , x_parent_child_generation_flag VARCHAR2
172 , x_child_lot_zero_padding_flag VARCHAR2
173 , x_child_lot_alpha_prefix VARCHAR2
174 , x_child_lot_number_length NUMBER
175 , x_child_lot_validation_flag VARCHAR2
176 , x_copy_lot_attribute_flag VARCHAR2
177 , x_create_lot_uom_conversion NUMBER DEFAULT NULL -- NSINHA
178 , x_allow_different_status NUMBER DEFAULT NULL -- NSINHA
179 , x_rules_override_lot_reserve VARCHAR2 DEFAULT NULL -- NSINHA
180 , x_wcs_enabled VARCHAR2 --MHP
181 , x_trading_partner_org_flag VARCHAR2 DEFAULT NULL
182 , x_deferred_cogs_account NUMBER DEFAULT NULL
183 , x_default_crossdok_criteria_id NUMBER DEFAULT NULL
184 , x_enforce_locator_alis_uq_flag VARCHAR2 DEFAULT NULL
185 , x_epc_generation_enabled_flag VARCHAR2 DEFAULT NULL
186 , x_company_prefix VARCHAR2 DEFAULT NULL
187 , x_company_prefix_index VARCHAR2 DEFAULT NULL
188 , x_commercial_gov_entity_number VARCHAR2 DEFAULT NULL
189 , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
190 , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
191 ) IS
192 CURSOR c IS
193 SELECT ROWID
194 FROM mtl_parameters
195 WHERE organization_id = x_organization_id;
196 BEGIN
197 INSERT INTO mtl_parameters
198 (
199 organization_id
200 , last_update_date
201 , last_updated_by
202 , creation_date
203 , created_by
204 , last_update_login
205 , organization_code
206 , master_organization_id
207 , primary_cost_method
208 , cost_organization_id
209 , default_material_cost_id
210 , default_matl_ovhd_cost_id
211 , calendar_exception_set_id
212 , calendar_code
213 , general_ledger_update_code
214 , default_atp_rule_id
215 , default_picking_rule_id
216 , default_locator_order_value
217 , default_subinv_order_value
218 , negative_inv_receipt_code
219 , stock_locator_control_code
220 , material_account
221 , material_overhead_account
222 , matl_ovhd_absorption_acct
223 , resource_account
224 , purchase_price_var_account
225 , ap_accrual_account
226 , overhead_account
227 , outside_processing_account
231 , interorg_payables_account
228 , intransit_inv_account
229 , interorg_receivables_account
230 , interorg_price_var_account
232 , cost_of_sales_account
233 , encumbrance_account
234 , interorg_transfer_cr_account
235 , matl_interorg_transfer_code
236 , interorg_trnsfr_charge_percent
237 , source_organization_id
238 , source_subinventory
239 , source_type
240 , serial_number_type
241 , auto_serial_alpha_prefix
242 , start_auto_serial_number
243 , auto_lot_alpha_prefix
244 , lot_number_uniqueness
245 , lot_number_generation
246 , lot_number_zero_padding
247 , lot_number_length
248 , starting_revision
249 , attribute_category
250 , attribute1
251 , attribute2
252 , attribute3
253 , attribute4
254 , attribute5
255 , attribute6
256 , attribute7
257 , attribute8
258 , attribute9
259 , attribute10
260 , attribute11
261 , attribute12
262 , attribute13
263 , attribute14
264 , attribute15
265 , global_attribute_category
266 , global_attribute1
267 , global_attribute2
268 , global_attribute3
269 , global_attribute4
270 , global_attribute5
271 , global_attribute6
272 , global_attribute7
273 , global_attribute8
274 , global_attribute9
275 , global_attribute10
276 , global_attribute11
277 , global_attribute12
278 , global_attribute13
279 , global_attribute14
280 , global_attribute15
281 , global_attribute16
282 , global_attribute17
283 , global_attribute18
284 , global_attribute19
285 , global_attribute20
286 , default_demand_class
287 , encumbrance_reversal_flag
288 , maintain_fifo_qty_stack_type
289 , invoice_price_var_account
290 , average_cost_var_account
291 -- For Bug 7440217 LCM Variance Account
292 , lcm_var_account
293 -- End for Bug 7440217
294 , sales_account
295 , expense_account
296 , serial_number_generation
297 , project_reference_enabled
298 , pm_cost_collection_enabled
299 , project_control_level
300 , avg_rates_cost_type_id
301 , txn_approval_timeout_period
302 , borrpay_matl_var_account
303 , borrpay_moh_var_account
304 , borrpay_res_var_account
305 , borrpay_osp_var_account
306 , borrpay_ovh_var_account
307 , org_max_weight
308 , org_max_volume
309 , org_max_weight_uom_code
310 , org_max_volume_uom_code
311 , mo_source_required
312 , mo_pick_confirm_required
313 , mo_approval_timeout_action
314 , project_cost_account
315 , process_enabled_flag
316 , process_orgn_code
317 , default_cost_group_id
318 , lpn_prefix
319 , lpn_suffix
320 , lpn_starting_number
321 , wms_enabled_flag
322 -- For Bug 7440217 LCM ENabled Flag
323 , lcm_enabled_flag
324 -- End for Bug 7440217
325 , qa_skipping_insp_flag
326 , eam_enabled_flag
327 , maint_organization_id
328 , pregen_putaway_tasks_flag
329 , regeneration_interval
330 , timezone_id
331 , default_wms_picking_rule_id
332 , default_put_away_rule_id
333 , default_carton_rule_id
334 , default_cyc_count_header_id
335 , crossdock_flag
336 , cartonization_flag
337 , allocate_serial_flag
338 , default_pick_task_type_id
339 , default_repl_task_type_id
340 , default_cc_task_type_id
341 , default_putaway_task_type_id
342 , cost_cutoff_date
343 , skip_task_waiting_minutes
344 , prioritize_wip_jobs
345 , default_crossdock_subinventory
346 , default_crossdock_locator_id
347 , distributed_organization_flag
348 , carrier_manifesting_flag
349 , distribution_account_id
350 , direct_shipping_allowed
351 , default_moxfer_task_type_id
352 , default_moissue_task_type_id
353 , max_clusters_allowed
354 , default_pick_op_plan_id
355 --, consigned_flag /*Bug 4347477*/
356 , cartonize_sales_orders
357 , cartonize_manufacturing
358 , total_lpn_length
362 , ovpk_transfer_orders_enabled --OVPK
359 , ucc_128_suffix_flag
360 , defer_logical_transactions
361 , wip_overpick_enabled --OVPK
363 , auto_del_alloc_flag --ER3969328: CI project
364 , RFID_VERIF_PCNT_THRESHOLD --11.5.10+ RFID Compliance
365 , parent_child_generation_flag
366 , child_lot_zero_padding_flag
367 , child_lot_alpha_prefix
368 , child_lot_number_length
369 , child_lot_validation_flag
370 , copy_lot_attribute_flag
371 , create_lot_uom_conversion -- NSINHA
372 , allow_different_status -- NSINHA
373 , rules_override_lot_reservation -- NSINHA
374 , wcs_enabled --MHP
375 , trading_partner_org_flag
376 , deferred_cogs_account
377 , default_crossdock_criteria_id
378 , enforce_locator_alis_unq_flag
379 , epc_generation_enabled_flag
380 , company_prefix
381 , company_prefix_index
382 , commercial_govt_entity_number
383 , labor_management_enabled_flag
384 , default_status_id -- Added for # 6633612
385 )
386 VALUES (
387 x_organization_id
388 , x_last_update_date
389 , x_last_updated_by
390 , x_creation_date
391 , x_created_by
392 , x_last_update_login
393 , x_organization_code
394 , x_master_organization_id
395 , x_primary_cost_method
396 , x_cost_organization_id
397 , x_default_material_cost_id
398 , x_default_matl_ovhd_cost_id
399 , x_calendar_exception_set_id
400 , x_calendar_code
401 , x_general_ledger_update_code
402 , x_default_atp_rule_id
403 , x_default_picking_rule_id
404 , x_default_locator_order_value
405 , x_default_subinv_order_value
406 , x_negative_inv_receipt_code
407 , x_stock_locator_control_code
408 , x_material_account
409 , x_material_overhead_account
410 , x_matl_ovhd_absorption_acct
411 , x_resource_account
412 , x_purchase_price_var_account
413 , x_ap_accrual_account
414 , x_overhead_account
415 , x_outside_processing_account
416 , x_intransit_inv_account
417 , x_interorg_receivables_account
418 , x_interorg_price_var_account
419 , x_interorg_payables_account
420 , x_cost_of_sales_account
421 , x_encumbrance_account
422 , x_interorg_transfer_cr_account
423 , x_matl_interorg_transfer_code
424 , x_interorg_trnsfr_charge_perc
425 , x_source_organization_id
426 , x_source_subinventory
427 , x_source_type
428 , x_serial_number_type
429 , x_auto_serial_alpha_prefix
430 , x_start_auto_serial_number
431 , x_auto_lot_alpha_prefix
432 , x_lot_number_uniqueness
433 , x_lot_number_generation
434 , x_lot_number_zero_padding
435 , x_lot_number_length
436 , x_starting_revision
437 , x_attribute_category
438 , x_attribute1
439 , x_attribute2
440 , x_attribute3
441 , x_attribute4
442 , x_attribute5
443 , x_attribute6
444 , x_attribute7
445 , x_attribute8
446 , x_attribute9
447 , x_attribute10
448 , x_attribute11
449 , x_attribute12
450 , x_attribute13
451 , x_attribute14
452 , x_attribute15
453 , x_global_attribute_category
454 , x_global_attribute1
455 , x_global_attribute2
456 , x_global_attribute3
457 , x_global_attribute4
458 , x_global_attribute5
459 , x_global_attribute6
460 , x_global_attribute7
461 , x_global_attribute8
462 , x_global_attribute9
463 , x_global_attribute10
464 , x_global_attribute11
465 , x_global_attribute12
466 , x_global_attribute13
467 , x_global_attribute14
468 , x_global_attribute15
469 , x_global_attribute16
470 , x_global_attribute17
471 , x_global_attribute18
472 , x_global_attribute19
473 , x_global_attribute20
474 , x_default_demand_class
475 , x_encumbrance_reversal_flag
476 , x_maintain_fifo_qty_stack_type
477 , x_invoice_price_var_account
478 , x_average_cost_var_account
479 -- For Bug 7440217 LCM Variance Account
480 , x_lcm_var_account
481 -- End for Bug 7440217
482 , x_sales_account
483 , x_expense_account
487 , x_project_control_level
484 , x_serial_number_generation
485 , x_project_reference_enabled
486 , x_pm_cost_collection_enabled
488 , x_avg_rates_cost_type_id
489 , x_txn_approval_timeout_period
490 , x_borrpay_matl_var_account
491 , x_borrpay_moh_var_account
492 , x_borrpay_res_var_account
493 , x_borrpay_osp_var_account
494 , x_borrpay_ovh_var_account
495 , x_org_max_weight
496 , x_org_max_volume
497 , x_org_max_weight_uom_code
498 , x_org_max_volume_uom_code
499 , x_mo_source_required
500 , NVL(x_mo_pick_confirm_required,'2')
501 , x_mo_approval_timeout_action
502 , x_project_cost_account
503 , x_process_enabled_flag
504 , x_process_orgn_code
505 , x_default_cost_group_id
506 , x_lpn_prefix
507 , x_lpn_suffix
508 , x_lpn_starting_number
509 , NVL(x_wms_enabled_flag, 'N')
510 -- For Bug 7440217 LCM Enabled Flag
511 , NVL(x_lcm_enabled_flag, 'N')
512 -- End for Bug 7440217
513 , NVL(x_qa_skipping_insp_flag, 'N')
514 , NVL(x_eam_enabled_flag, 'N')
515 , x_maint_organization_id
516 , x_pregen_putaway_tasks_flag
517 , x_regeneration_interval
518 , x_timezone_id
519 , x_default_wms_picking_rule_id
520 , x_default_put_away_rule_id
521 , x_default_carton_rule_id
522 , x_default_cyc_count_header_id
523 , x_crossdock_flag
524 , x_cartonization_flag
525 , x_allocate_serial_flag
526 , x_default_pick_task_type_id
527 , x_default_repl_task_type_id
528 , x_default_cc_task_type_id
529 , x_default_putaway_task_type_id
530 , x_cost_cutoff_date
531 , x_skip_task_waiting_minutes
532 , x_prioritize_wip_jobs
533 , x_default_xdock_subinventory
534 , x_default_xdock_locator_id
535 , x_distri_organization_flag
536 , x_carrier_manifesting_flag
537 , x_distribution_account_id
538 , x_direct_shipping_allowed
539 , x_default_moxfer_task_type_id
540 , x_default_moissue_task_type_id
541 , x_max_clusters_allowed
542 , x_default_pick_op_plan_id
543 --, x_consigned_flag /*Bug #4347477*/
544 , x_cartonize_sales_orders
545 , x_cartonize_manufacturing
546 , x_total_lpn_length
547 , x_ucc_128_suffix_flag
548 , x_defer_logical_transactions
549 , NVL(x_wip_overpick_enabled,'N') --OVPK
550 , NVL(x_ovpk_transfer_orders_enabled,'Y') --OVPK
551 , x_auto_del_alloc_flag --ER3969328: CI project
552 , X_RFID_VERIF_PCNT_THRESHOLD -- 11.5.10+ RFID Compliance
553 , x_parent_child_generation_flag
554 , x_child_lot_zero_padding_flag
555 , x_child_lot_alpha_prefix
556 , x_child_lot_number_length
557 , x_child_lot_validation_flag
558 , x_copy_lot_attribute_flag
559 , x_create_lot_uom_conversion -- NSINHA
560 , x_allow_different_status -- NSINHA
561 , x_rules_override_lot_reserve -- NSINHA
562 , x_wcs_enabled --MHP
563 , x_trading_partner_org_flag
564 , x_deferred_cogs_account
565 , x_default_crossdok_criteria_id
566 , x_enforce_locator_alis_uq_flag
567 , x_epc_generation_enabled_flag
568 , x_company_prefix
569 , x_company_prefix_index
570 , x_commercial_gov_entity_number
571 , x_lbr_management_enabled_flag
572 , x_default_status_id -- Added for # 6633612
573 );
574
575 OPEN c;
576 FETCH c INTO x_rowid;
577
578 IF (c%NOTFOUND) THEN
579 CLOSE c;
580 RAISE NO_DATA_FOUND;
581 END IF;
582
583 CLOSE c;
584 END insert_row;
585
586 PROCEDURE lock_row(
587 x_rowid VARCHAR2
588 , x_organization_id NUMBER
589 , x_organization_code VARCHAR2
590 , x_master_organization_id NUMBER
591 , x_primary_cost_method NUMBER
592 , x_cost_organization_id NUMBER
593 , x_default_material_cost_id NUMBER
594 , x_default_matl_ovhd_cost_id NUMBER
595 , x_calendar_exception_set_id NUMBER
596 , x_calendar_code VARCHAR2
597 , x_general_ledger_update_code NUMBER
598 , x_default_atp_rule_id NUMBER
599 , x_default_picking_rule_id NUMBER
600 , x_default_locator_order_value NUMBER
601 , x_default_subinv_order_value NUMBER
602 , x_negative_inv_receipt_code NUMBER
603 , x_stock_locator_control_code NUMBER
604 , x_material_account NUMBER
605 , x_material_overhead_account NUMBER
609 , x_ap_accrual_account NUMBER
606 , x_matl_ovhd_absorption_acct NUMBER
607 , x_resource_account NUMBER
608 , x_purchase_price_var_account NUMBER
610 , x_overhead_account NUMBER
611 , x_outside_processing_account NUMBER
612 , x_intransit_inv_account NUMBER
613 , x_interorg_receivables_account NUMBER
614 , x_interorg_price_var_account NUMBER
615 , x_interorg_payables_account NUMBER
616 , x_cost_of_sales_account NUMBER
617 , x_encumbrance_account NUMBER
618 , x_interorg_transfer_cr_account NUMBER
619 , x_matl_interorg_transfer_code NUMBER
620 , x_interorg_trnsfr_charge_perc NUMBER
621 , x_source_organization_id NUMBER
622 , x_source_subinventory VARCHAR2
623 , x_source_type NUMBER
624 , x_serial_number_type NUMBER
625 , x_auto_serial_alpha_prefix VARCHAR2
626 , x_start_auto_serial_number VARCHAR2
627 , x_auto_lot_alpha_prefix VARCHAR2
628 , x_lot_number_uniqueness NUMBER
629 , x_lot_number_generation NUMBER
630 , x_lot_number_zero_padding NUMBER
631 , x_lot_number_length NUMBER
632 , x_starting_revision VARCHAR2
633 , x_attribute_category VARCHAR2
634 , x_attribute1 VARCHAR2
635 , x_attribute2 VARCHAR2
636 , x_attribute3 VARCHAR2
637 , x_attribute4 VARCHAR2
638 , x_attribute5 VARCHAR2
639 , x_attribute6 VARCHAR2
640 , x_attribute7 VARCHAR2
641 , x_attribute8 VARCHAR2
642 , x_attribute9 VARCHAR2
643 , x_attribute10 VARCHAR2
644 , x_attribute11 VARCHAR2
645 , x_attribute12 VARCHAR2
646 , x_attribute13 VARCHAR2
647 , x_attribute14 VARCHAR2
648 , x_attribute15 VARCHAR2
649 , x_global_attribute_category VARCHAR2
650 , x_global_attribute1 VARCHAR2
651 , x_global_attribute2 VARCHAR2
652 , x_global_attribute3 VARCHAR2
653 , x_global_attribute4 VARCHAR2
654 , x_global_attribute5 VARCHAR2
655 , x_global_attribute6 VARCHAR2
656 , x_global_attribute7 VARCHAR2
657 , x_global_attribute8 VARCHAR2
658 , x_global_attribute9 VARCHAR2
659 , x_global_attribute10 VARCHAR2
660 , x_global_attribute11 VARCHAR2
661 , x_global_attribute12 VARCHAR2
662 , x_global_attribute13 VARCHAR2
663 , x_global_attribute14 VARCHAR2
664 , x_global_attribute15 VARCHAR2
665 , x_global_attribute16 VARCHAR2
666 , x_global_attribute17 VARCHAR2
667 , x_global_attribute18 VARCHAR2
668 , x_global_attribute19 VARCHAR2
669 , x_global_attribute20 VARCHAR2
670 , x_default_demand_class VARCHAR2
671 , x_encumbrance_reversal_flag NUMBER
672 , x_maintain_fifo_qty_stack_type NUMBER
673 , x_invoice_price_var_account NUMBER
674 , x_average_cost_var_account NUMBER
675 -- For Bug 7440217 for Varinace Account
676 , x_lcm_var_account NUMBER
677 -- End for Bug 7440217
678 , x_sales_account NUMBER
679 , x_expense_account NUMBER
680 , x_serial_number_generation NUMBER
681 , x_project_reference_enabled NUMBER
682 , x_pm_cost_collection_enabled NUMBER
683 , x_project_control_level NUMBER
684 , x_avg_rates_cost_type_id NUMBER
685 , x_txn_approval_timeout_period NUMBER
686 , x_borrpay_matl_var_account NUMBER
687 , x_borrpay_moh_var_account NUMBER
688 , x_borrpay_res_var_account NUMBER
689 , x_borrpay_osp_var_account NUMBER
690 , x_borrpay_ovh_var_account NUMBER
691 , x_org_max_weight NUMBER
692 , x_org_max_volume NUMBER
693 , x_org_max_weight_uom_code VARCHAR2
694 , x_org_max_volume_uom_code VARCHAR2
695 , x_mo_source_required NUMBER
696 , x_mo_pick_confirm_required NUMBER
697 , x_mo_approval_timeout_action NUMBER
698 , x_project_cost_account NUMBER
699 , x_process_enabled_flag VARCHAR2
700 , x_process_orgn_code VARCHAR2
701 , x_default_cost_group_id NUMBER
702 , x_lpn_prefix VARCHAR2
703 , x_lpn_suffix VARCHAR2
704 , x_lpn_starting_number NUMBER
705 , x_wms_enabled_flag VARCHAR2
706 -- For Bug 7440217 for LCM Enabled Flag
707 , x_lcm_enabled_flag VARCHAR2
708 -- End for Bug 7440217
709 , x_qa_skipping_insp_flag VARCHAR2
710 , x_eam_enabled_flag VARCHAR2
711 , x_maint_organization_id NUMBER
712 , x_pregen_putaway_tasks_flag NUMBER
713 , x_regeneration_interval NUMBER
714 , x_timezone_id NUMBER
715 , x_default_wms_picking_rule_id NUMBER
716 , x_default_put_away_rule_id NUMBER
717 , x_default_carton_rule_id NUMBER
718 , x_default_cyc_count_header_id NUMBER
719 , x_crossdock_flag NUMBER
720 , x_cartonization_flag NUMBER
721 , x_allocate_serial_flag VARCHAR2
722 , x_default_pick_task_type_id NUMBER
723 , x_default_repl_task_type_id NUMBER
724 , x_default_cc_task_type_id NUMBER
725 , x_default_putaway_task_type_id NUMBER
729 , x_default_xdock_subinventory VARCHAR2
726 , x_cost_cutoff_date DATE
727 , x_skip_task_waiting_minutes NUMBER
728 , x_prioritize_wip_jobs NUMBER
730 , x_default_xdock_locator_id NUMBER
731 , x_distri_organization_flag VARCHAR2
732 , x_carrier_manifesting_flag VARCHAR2
733 , x_distribution_account_id NUMBER
734 , x_direct_shipping_allowed VARCHAR2
735 , x_default_moxfer_task_type_id NUMBER
736 , x_default_moissue_task_type_id NUMBER
737 , x_max_clusters_allowed NUMBER
738 , x_default_pick_op_plan_id NUMBER
739 , x_consigned_flag VARCHAR2
740 , x_cartonize_sales_orders VARCHAR2
741 , x_cartonize_manufacturing VARCHAR2
742 , x_total_lpn_length NUMBER
743 , x_ucc_128_suffix_flag VARCHAR2
744 , x_defer_logical_transactions NUMBER
745 , x_wip_overpick_enabled VARCHAR2 --OVPK
746 , x_ovpk_transfer_orders_enabled VARCHAR2 --OVPK
747 , x_auto_del_alloc_flag VARCHAR2 --ER3969328: CI project
748 , X_RFID_VERIF_PCNT_THRESHOLD NUMBER -- 11.5.10+ RFID Compliance
749 , x_parent_child_generation_flag VARCHAR2
750 , x_child_lot_zero_padding_flag VARCHAR2
751 , x_child_lot_alpha_prefix VARCHAR2
752 , x_child_lot_number_length NUMBER
753 , x_child_lot_validation_flag VARCHAR2
754 , x_copy_lot_attribute_flag VARCHAR2
755 , x_create_lot_uom_conversion NUMBER DEFAULT NULL -- NSINHA
756 , x_allow_different_status NUMBER DEFAULT NULL -- NSINHA
757 , x_rules_override_lot_reserve VARCHAR2 DEFAULT NULL -- NSINHA
758 , x_wcs_enabled VARCHAR2 --MHP
759 , x_trading_partner_org_flag VARCHAR2 DEFAULT NULL
760 , x_deferred_cogs_account NUMBER DEFAULT NULL
761 , x_default_crossdok_criteria_id NUMBER DEFAULT NULL
762 , x_enforce_locator_alis_uq_flag VARCHAR2 DEFAULT NULL
763 , x_epc_generation_enabled_flag VARCHAR2 DEFAULT NULL
764 , x_company_prefix VARCHAR2 DEFAULT NULL
765 , x_company_prefix_index VARCHAR2 DEFAULT NULL
766 , x_commercial_gov_entity_number VARCHAR2 DEFAULT NULL
767 , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
768 , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
769 ) IS
770 CURSOR c IS
771 SELECT *
772 FROM mtl_parameters
773 WHERE ROWID = x_rowid
774 FOR UPDATE OF organization_id NOWAIT;
775
776 recinfo c%ROWTYPE;
777 record_changed EXCEPTION;
778 BEGIN
779 OPEN c;
780 FETCH c INTO recinfo;
781
782 IF (c%NOTFOUND) THEN
783 CLOSE c;
784 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
785 app_exception.raise_exception;
786 END IF;
787
788 CLOSE c;
789
790 IF NOT(
791 (recinfo.organization_id = x_organization_id)
792 AND((recinfo.organization_code = x_organization_code)
793 OR((recinfo.organization_code IS NULL)
794 AND(x_organization_code IS NULL)))
795 AND(recinfo.master_organization_id = x_master_organization_id)
796 AND(recinfo.primary_cost_method = x_primary_cost_method)
797 AND(recinfo.cost_organization_id = x_cost_organization_id)
798 AND(
799 (recinfo.default_material_cost_id = x_default_material_cost_id)
800 OR((recinfo.default_material_cost_id IS NULL)
801 AND(x_default_material_cost_id IS NULL))
802 )
803 AND(
804 (recinfo.default_matl_ovhd_cost_id = x_default_matl_ovhd_cost_id)
805 OR((recinfo.default_matl_ovhd_cost_id IS NULL)
806 AND(x_default_matl_ovhd_cost_id IS NULL))
807 )
808 AND(
809 (recinfo.calendar_exception_set_id = x_calendar_exception_set_id)
810 OR((recinfo.calendar_exception_set_id IS NULL)
811 AND(x_calendar_exception_set_id IS NULL))
812 )
813 AND((recinfo.calendar_code = x_calendar_code)
814 OR((recinfo.calendar_code IS NULL)
815 AND(x_calendar_code IS NULL)))
816 AND(recinfo.general_ledger_update_code = x_general_ledger_update_code)
817 AND(
818 (recinfo.default_atp_rule_id = x_default_atp_rule_id)
819 OR((recinfo.default_atp_rule_id IS NULL)
820 AND(x_default_atp_rule_id IS NULL))
821 )
822 AND(
823 (recinfo.default_picking_rule_id = x_default_picking_rule_id)
824 OR((recinfo.default_picking_rule_id IS NULL)
825 AND(x_default_picking_rule_id IS NULL))
826 )
827 AND(
828 (recinfo.default_locator_order_value = x_default_locator_order_value)
829 OR((recinfo.default_locator_order_value IS NULL)
830 AND(x_default_locator_order_value IS NULL))
831 )
832 AND(
833 (recinfo.default_subinv_order_value = x_default_subinv_order_value)
834 OR((recinfo.default_subinv_order_value IS NULL)
835 AND(x_default_subinv_order_value IS NULL))
836 )
837 AND(recinfo.negative_inv_receipt_code = x_negative_inv_receipt_code)
838 AND(recinfo.stock_locator_control_code = x_stock_locator_control_code)
842 AND(
839 AND((recinfo.material_account = x_material_account)
840 OR((recinfo.material_account IS NULL)
841 AND(x_material_account IS NULL)))
843 (recinfo.material_overhead_account = x_material_overhead_account)
844 OR((recinfo.material_overhead_account IS NULL)
845 AND(x_material_overhead_account IS NULL))
846 )
847 AND(
848 (recinfo.matl_ovhd_absorption_acct = x_matl_ovhd_absorption_acct)
849 OR((recinfo.matl_ovhd_absorption_acct IS NULL)
850 AND(x_matl_ovhd_absorption_acct IS NULL))
851 )
852 AND((recinfo.resource_account = x_resource_account)
853 OR((recinfo.resource_account IS NULL)
854 AND(x_resource_account IS NULL)))
855 AND(
856 (recinfo.purchase_price_var_account = x_purchase_price_var_account)
857 OR((recinfo.purchase_price_var_account IS NULL)
858 AND(x_purchase_price_var_account IS NULL))
859 )
860 AND(
861 (recinfo.ap_accrual_account = x_ap_accrual_account)
862 OR((recinfo.ap_accrual_account IS NULL)
863 AND(x_ap_accrual_account IS NULL))
864 )
865 AND((recinfo.overhead_account = x_overhead_account)
866 OR((recinfo.overhead_account IS NULL)
867 AND(x_overhead_account IS NULL)))
868 AND(
869 (recinfo.outside_processing_account = x_outside_processing_account)
870 OR((recinfo.outside_processing_account IS NULL)
871 AND(x_outside_processing_account IS NULL))
872 )
873 AND(
874 (recinfo.intransit_inv_account = x_intransit_inv_account)
875 OR((recinfo.intransit_inv_account IS NULL)
876 AND(x_intransit_inv_account IS NULL))
877 )
878 AND(
879 (recinfo.interorg_receivables_account = x_interorg_receivables_account)
880 OR((recinfo.interorg_receivables_account IS NULL)
881 AND(x_interorg_receivables_account IS NULL))
882 )
883 AND(
884 (recinfo.interorg_price_var_account = x_interorg_price_var_account)
885 OR((recinfo.interorg_price_var_account IS NULL)
886 AND(x_interorg_price_var_account IS NULL))
887 )
888 AND(
889 (recinfo.interorg_payables_account = x_interorg_payables_account)
890 OR((recinfo.interorg_payables_account IS NULL)
891 AND(x_interorg_payables_account IS NULL))
892 )
893 AND(
894 (recinfo.cost_of_sales_account = x_cost_of_sales_account)
895 OR((recinfo.cost_of_sales_account IS NULL)
896 AND(x_cost_of_sales_account IS NULL))
897 )
898 AND(
899 (recinfo.encumbrance_account = x_encumbrance_account)
900 OR((recinfo.encumbrance_account IS NULL)
901 AND(x_encumbrance_account IS NULL))
902 )
903 AND(
904 (recinfo.interorg_transfer_cr_account = x_interorg_transfer_cr_account)
905 OR((recinfo.interorg_transfer_cr_account IS NULL)
906 AND(x_interorg_transfer_cr_account IS NULL))
907 )
908 AND(recinfo.matl_interorg_transfer_code = x_matl_interorg_transfer_code)
909 AND(
910 (recinfo.interorg_trnsfr_charge_percent = x_interorg_trnsfr_charge_perc)
911 OR((recinfo.interorg_trnsfr_charge_percent IS NULL)
912 AND(x_interorg_trnsfr_charge_perc IS NULL))
913 )
914 AND(
915 (recinfo.source_organization_id = x_source_organization_id)
916 OR((recinfo.source_organization_id IS NULL)
917 AND(x_source_organization_id IS NULL))
918 )
919 AND(
920 (recinfo.source_subinventory = x_source_subinventory)
921 OR((recinfo.source_subinventory IS NULL)
922 AND(x_source_subinventory IS NULL))
923 )
924 AND((recinfo.source_type = x_source_type)
925 OR((recinfo.source_type IS NULL)
926 AND(x_source_type IS NULL)))
927 AND(
928 (recinfo.serial_number_type = x_serial_number_type)
929 OR((recinfo.serial_number_type IS NULL)
930 AND(x_serial_number_type IS NULL))
931 )
932 AND(
933 (recinfo.auto_serial_alpha_prefix = x_auto_serial_alpha_prefix)
934 OR((recinfo.auto_serial_alpha_prefix IS NULL)
935 AND(x_auto_serial_alpha_prefix IS NULL))
936 )
937 AND(
938 (recinfo.start_auto_serial_number = x_start_auto_serial_number)
939 OR((recinfo.start_auto_serial_number IS NULL)
940 AND(x_start_auto_serial_number IS NULL))
941 )
942 AND(
943 (recinfo.auto_lot_alpha_prefix = x_auto_lot_alpha_prefix)
944 OR((recinfo.auto_lot_alpha_prefix IS NULL)
945 AND(x_auto_lot_alpha_prefix IS NULL))
946 )
947 AND(recinfo.lot_number_uniqueness = x_lot_number_uniqueness)
948 AND(recinfo.lot_number_generation = x_lot_number_generation)
952 AND(x_lot_number_zero_padding IS NULL))
949 AND(
950 (recinfo.lot_number_zero_padding = x_lot_number_zero_padding)
951 OR((recinfo.lot_number_zero_padding IS NULL)
953 )
954 AND((recinfo.lot_number_length = x_lot_number_length)
955 OR((recinfo.lot_number_length IS NULL)
956 AND(x_lot_number_length IS NULL)))
957 AND(recinfo.starting_revision = x_starting_revision)
958 AND(
959 (recinfo.project_cost_account = x_project_cost_account)
960 OR((recinfo.project_cost_account IS NULL)
961 AND(x_project_cost_account IS NULL))
962 )
963 AND(
964 (recinfo.process_enabled_flag = x_process_enabled_flag)
965 OR((recinfo.process_enabled_flag IS NULL)
966 AND(x_process_enabled_flag IS NULL))
967 )
968 AND((recinfo.process_orgn_code = x_process_orgn_code)
969 OR((recinfo.process_orgn_code IS NULL)
970 AND(x_process_orgn_code IS NULL)))
971 AND(
972 (recinfo.default_cost_group_id = x_default_cost_group_id)
973 OR((recinfo.default_cost_group_id IS NULL)
974 AND(x_default_cost_group_id IS NULL))
975 )
976 AND((recinfo.lpn_prefix = x_lpn_prefix)
977 OR((recinfo.lpn_prefix IS NULL)
978 AND(x_lpn_prefix IS NULL)))
979 AND((recinfo.lpn_suffix = x_lpn_suffix)
980 OR((recinfo.lpn_suffix IS NULL)
981 AND(x_lpn_suffix IS NULL)))
982 AND(
983 (recinfo.lpn_starting_number = x_lpn_starting_number)
984 OR((recinfo.lpn_starting_number IS NULL)
985 AND(x_lpn_starting_number IS NULL))
986 )
987 AND((recinfo.wms_enabled_flag = x_wms_enabled_flag)
988 OR((recinfo.wms_enabled_flag IS NULL)
989 AND(x_wms_enabled_flag IS NULL))
990 )
991 -- For Bug 7440217
992 AND((recinfo.lcm_enabled_flag = x_lcm_enabled_flag)
993 OR((recinfo.lcm_enabled_flag IS NULL)
994 AND(x_lcm_enabled_flag IS NULL))
995 )
996 -- End for Bug 7440217
997 AND(
998 (recinfo.qa_skipping_insp_flag = x_qa_skipping_insp_flag)
999 OR((recinfo.qa_skipping_insp_flag IS NULL)
1000 AND(x_qa_skipping_insp_flag IS NULL))
1001 )
1002 AND((recinfo.eam_enabled_flag = x_eam_enabled_flag)
1003 OR((recinfo.eam_enabled_flag IS NULL)
1004 AND(x_eam_enabled_flag IS NULL)))
1005 AND(
1006 (recinfo.maint_organization_id = x_maint_organization_id)
1007 OR((recinfo.maint_organization_id IS NULL)
1008 AND(x_maint_organization_id IS NULL))
1009 )
1010 AND((recinfo.crossdock_flag = x_crossdock_flag)
1011 OR((recinfo.crossdock_flag IS NULL)
1012 AND(x_crossdock_flag IS NULL)))
1013 AND(
1014 (recinfo.cartonization_flag = x_cartonization_flag)
1015 OR((recinfo.cartonization_flag IS NULL)
1016 AND(x_cartonization_flag IS NULL))
1017 )
1018 AND(
1019 (recinfo.allocate_serial_flag = x_allocate_serial_flag)
1020 OR((recinfo.allocate_serial_flag IS NULL)
1021 AND(x_allocate_serial_flag IS NULL))
1022 )
1023 ) THEN
1024 RAISE record_changed;
1025 END IF;
1026
1027 -- Bug: 4188383.
1028 -- Rearranged the closing parenthesis of NOT condition below, to cover all the conditions specified in the IF statement.
1029 IF NOT(
1030 ((recinfo.attribute_category = x_attribute_category)
1031 OR((recinfo.attribute_category IS NULL)
1032 AND(x_attribute_category IS NULL)))
1033 AND((recinfo.attribute1 = x_attribute1)
1034 OR((recinfo.attribute1 IS NULL)
1035 AND(x_attribute1 IS NULL)))
1036 AND((recinfo.attribute2 = x_attribute2)
1037 OR((recinfo.attribute2 IS NULL)
1038 AND(x_attribute2 IS NULL)))
1039 AND((recinfo.attribute3 = x_attribute3)
1040 OR((recinfo.attribute3 IS NULL)
1041 AND(x_attribute3 IS NULL)))
1042 AND((recinfo.attribute4 = x_attribute4)
1043 OR((recinfo.attribute4 IS NULL)
1044 AND(x_attribute4 IS NULL)))
1045 AND((recinfo.attribute5 = x_attribute5)
1046 OR((recinfo.attribute5 IS NULL)
1047 AND(x_attribute5 IS NULL)))
1048 AND((recinfo.attribute6 = x_attribute6)
1049 OR((recinfo.attribute6 IS NULL)
1050 AND(x_attribute6 IS NULL)))
1051 AND((recinfo.attribute7 = x_attribute7)
1052 OR((recinfo.attribute7 IS NULL)
1053 AND(x_attribute7 IS NULL)))
1054 AND((recinfo.attribute8 = x_attribute8)
1055 OR((recinfo.attribute8 IS NULL)
1056 AND(x_attribute8 IS NULL)))
1057 AND((recinfo.attribute9 = x_attribute9)
1058 OR((recinfo.attribute9 IS NULL)
1059 AND(x_attribute9 IS NULL)))
1060 AND((recinfo.attribute10 = x_attribute10)
1061 OR((recinfo.attribute10 IS NULL)
1065 AND(x_attribute11 IS NULL)))
1062 AND(x_attribute10 IS NULL)))
1063 AND((recinfo.attribute11 = x_attribute11)
1064 OR((recinfo.attribute11 IS NULL)
1066 AND((recinfo.attribute12 = x_attribute12)
1067 OR((recinfo.attribute12 IS NULL)
1068 AND(x_attribute12 IS NULL)))
1069 AND((recinfo.attribute13 = x_attribute13)
1070 OR((recinfo.attribute13 IS NULL)
1071 AND(x_attribute13 IS NULL)))
1072 AND((recinfo.attribute14 = x_attribute14)
1073 OR((recinfo.attribute14 IS NULL)
1074 AND(x_attribute14 IS NULL)))
1075 AND((recinfo.attribute15 = x_attribute15)
1076 OR((recinfo.attribute15 IS NULL)
1077 AND(x_attribute15 IS NULL)))
1078 AND(
1079 (recinfo.global_attribute_category = x_global_attribute_category)
1080 OR((recinfo.global_attribute_category IS NULL)
1081 AND(x_global_attribute_category IS NULL))
1082 )
1083 AND((recinfo.global_attribute1 = x_global_attribute1)
1084 OR((recinfo.global_attribute1 IS NULL)
1085 AND(x_global_attribute1 IS NULL)))
1086 AND((recinfo.global_attribute2 = x_global_attribute2)
1087 OR((recinfo.global_attribute2 IS NULL)
1088 AND(x_global_attribute2 IS NULL)))
1089 AND((recinfo.global_attribute3 = x_global_attribute3)
1090 OR((recinfo.global_attribute3 IS NULL)
1091 AND(x_global_attribute3 IS NULL)))
1092 AND((recinfo.global_attribute4 = x_global_attribute4)
1093 OR((recinfo.global_attribute4 IS NULL)
1094 AND(x_global_attribute4 IS NULL)))
1095 AND((recinfo.global_attribute5 = x_global_attribute5)
1096 OR((recinfo.global_attribute5 IS NULL)
1097 AND(x_global_attribute5 IS NULL)))
1098 AND((recinfo.global_attribute6 = x_global_attribute6)
1099 OR((recinfo.global_attribute6 IS NULL)
1100 AND(x_global_attribute6 IS NULL)))
1101 AND((recinfo.global_attribute7 = x_global_attribute7)
1102 OR((recinfo.global_attribute7 IS NULL)
1103 AND(x_global_attribute7 IS NULL)))
1104 AND((recinfo.global_attribute8 = x_global_attribute8)
1105 OR((recinfo.global_attribute8 IS NULL)
1106 AND(x_global_attribute8 IS NULL)))
1107 AND((recinfo.global_attribute9 = x_global_attribute9)
1108 OR((recinfo.global_attribute9 IS NULL)
1109 AND(x_global_attribute9 IS NULL)))
1110 AND(
1111 (recinfo.global_attribute10 = x_global_attribute10)
1112 OR((recinfo.global_attribute10 IS NULL)
1113 AND(x_global_attribute10 IS NULL))
1114 )
1115 AND(
1116 (recinfo.global_attribute11 = x_global_attribute11)
1117 OR((recinfo.global_attribute11 IS NULL)
1118 AND(x_global_attribute11 IS NULL))
1119 )
1120 AND(
1121 (recinfo.global_attribute12 = x_global_attribute12)
1122 OR((recinfo.global_attribute12 IS NULL)
1123 AND(x_global_attribute12 IS NULL))
1124 )
1125 AND(
1126 (recinfo.global_attribute13 = x_global_attribute13)
1127 OR((recinfo.global_attribute13 IS NULL)
1128 AND(x_global_attribute13 IS NULL))
1129 )
1130 AND(
1131 (recinfo.global_attribute14 = x_global_attribute14)
1132 OR((recinfo.global_attribute14 IS NULL)
1133 AND(x_global_attribute14 IS NULL))
1134 )
1135 AND(
1136 (recinfo.global_attribute15 = x_global_attribute15)
1137 OR((recinfo.global_attribute15 IS NULL)
1138 AND(x_global_attribute15 IS NULL))
1139 )
1140 AND(
1141 (recinfo.global_attribute16 = x_global_attribute16)
1142 OR((recinfo.global_attribute16 IS NULL)
1143 AND(x_global_attribute16 IS NULL))
1144 )
1145 AND(
1146 (recinfo.global_attribute17 = x_global_attribute17)
1147 OR((recinfo.global_attribute17 IS NULL)
1148 AND(x_global_attribute17 IS NULL))
1149 )
1150 AND(
1151 (recinfo.global_attribute18 = x_global_attribute18)
1152 OR((recinfo.global_attribute18 IS NULL)
1153 AND(x_global_attribute18 IS NULL))
1154 )
1155 AND(
1156 (recinfo.global_attribute19 = x_global_attribute19)
1157 OR((recinfo.global_attribute19 IS NULL)
1158 AND(x_global_attribute19 IS NULL))
1159 )
1160 AND(
1161 (recinfo.global_attribute20 = x_global_attribute20)
1162 OR((recinfo.global_attribute20 IS NULL)
1163 AND(x_global_attribute20 IS NULL))
1164 )
1165 AND(
1166 (recinfo.default_demand_class = x_default_demand_class)
1167 OR((recinfo.default_demand_class IS NULL)
1168 AND(x_default_demand_class IS NULL))
1169 )
1170 AND(
1171 (recinfo.encumbrance_reversal_flag = x_encumbrance_reversal_flag)
1175 AND(
1172 OR((recinfo.encumbrance_reversal_flag IS NULL)
1173 AND(x_encumbrance_reversal_flag IS NULL))
1174 )
1176 (recinfo.maintain_fifo_qty_stack_type = x_maintain_fifo_qty_stack_type)
1177 OR((recinfo.maintain_fifo_qty_stack_type IS NULL)
1178 AND(x_maintain_fifo_qty_stack_type IS NULL))
1179 )
1180 AND(
1181 (recinfo.invoice_price_var_account = x_invoice_price_var_account)
1182 OR((recinfo.invoice_price_var_account IS NULL)
1183 AND(x_invoice_price_var_account IS NULL))
1184 )
1185 AND(
1186 (recinfo.average_cost_var_account = x_average_cost_var_account)
1187 OR((recinfo.average_cost_var_account IS NULL)
1188 AND(x_average_cost_var_account IS NULL))
1189 )
1190 -- For Bug 7440217
1191 AND(
1192 (recinfo.lcm_var_account = x_lcm_var_account)
1193 OR((recinfo.lcm_var_account IS NULL)
1194 AND(x_lcm_var_account IS NULL))
1195 )
1196 -- End for Bug 7440217
1197 AND((recinfo.sales_account = x_sales_account)
1198 OR((recinfo.sales_account IS NULL)
1199 AND(x_sales_account IS NULL)))
1200 AND((recinfo.expense_account = x_expense_account)
1201 OR((recinfo.expense_account IS NULL)
1202 AND(x_expense_account IS NULL)))
1203 AND(
1204 (recinfo.serial_number_generation = x_serial_number_generation)
1205 OR((recinfo.serial_number_generation IS NULL)
1206 AND(x_serial_number_generation IS NULL))
1207 )
1208 AND(
1209 (recinfo.project_reference_enabled = x_project_reference_enabled)
1210 OR((recinfo.project_reference_enabled IS NULL)
1211 AND(x_project_reference_enabled IS NULL))
1212 )
1213 AND(
1214 (recinfo.pm_cost_collection_enabled = x_pm_cost_collection_enabled)
1215 OR((recinfo.pm_cost_collection_enabled IS NULL)
1216 AND(x_pm_cost_collection_enabled IS NULL))
1217 )
1218 AND(
1219 (recinfo.project_control_level = x_project_control_level)
1220 OR((recinfo.project_control_level IS NULL)
1221 AND(x_project_control_level IS NULL))
1222 )
1223 AND(recinfo.avg_rates_cost_type_id = x_avg_rates_cost_type_id)
1224 AND(recinfo.txn_approval_timeout_period = x_txn_approval_timeout_period)
1225 AND(NVL(recinfo.borrpay_matl_var_account, -1) = NVL(x_borrpay_matl_var_account, -1))
1226 AND(NVL(recinfo.borrpay_moh_var_account, -1) = NVL(x_borrpay_moh_var_account, -1))
1227 AND(NVL(recinfo.borrpay_res_var_account, -1) = NVL(x_borrpay_res_var_account, -1))
1228 AND(NVL(recinfo.borrpay_osp_var_account, -1) = NVL(x_borrpay_osp_var_account, -1))
1229 AND(NVL(recinfo.borrpay_ovh_var_account, -1) = NVL(x_borrpay_ovh_var_account, -1))
1230 AND(NVL(recinfo.org_max_weight, -1) = NVL(x_org_max_weight, -1))
1231 AND(NVL(recinfo.org_max_volume, -1) = NVL(x_org_max_volume, -1))
1232 AND(NVL(recinfo.org_max_weight_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_weight_uom_code, fnd_api.g_miss_char))
1233 AND(NVL(recinfo.org_max_volume_uom_code, fnd_api.g_miss_char) = NVL(x_org_max_volume_uom_code, fnd_api.g_miss_char))
1234 AND(NVL(recinfo.mo_source_required, -1) = NVL(x_mo_source_required, -1))
1235 AND(NVL(recinfo.mo_pick_confirm_required, -1) = NVL(x_mo_pick_confirm_required, -1))
1236 AND(NVL(recinfo.mo_approval_timeout_action, -1) = NVL(x_mo_approval_timeout_action, -1))
1237 --)
1238 --Bug #4188383
1239 --This was where the closing parantheses of the NOT condition was placed.
1240 --Commented it out and placed the closing parantheses to include all of the following conditions also
1241 AND(
1242 (recinfo.pregen_putaway_tasks_flag = x_pregen_putaway_tasks_flag)
1243 OR((recinfo.pregen_putaway_tasks_flag IS NULL)
1244 AND(x_pregen_putaway_tasks_flag IS NULL))
1245 )
1246 AND(
1247 (recinfo.regeneration_interval = x_regeneration_interval)
1248 OR((recinfo.regeneration_interval IS NULL)
1249 AND(x_regeneration_interval IS NULL))
1250 )
1251 AND((recinfo.timezone_id = x_timezone_id)
1252 OR((recinfo.timezone_id IS NULL)
1253 AND(x_timezone_id IS NULL)))
1254 AND(
1255 (recinfo.default_wms_picking_rule_id = x_default_wms_picking_rule_id)
1256 OR((recinfo.default_wms_picking_rule_id IS NULL)
1257 AND(x_default_wms_picking_rule_id IS NULL))
1258 )
1259 AND(
1260 (recinfo.default_put_away_rule_id = x_default_put_away_rule_id)
1261 OR((recinfo.default_put_away_rule_id IS NULL)
1262 AND(x_default_put_away_rule_id IS NULL))
1263 )
1264 AND(
1265 (recinfo.default_carton_rule_id = x_default_carton_rule_id)
1266 OR((recinfo.default_carton_rule_id IS NULL)
1267 AND(x_default_carton_rule_id IS NULL))
1268 )
1269 AND(
1270 (recinfo.default_cyc_count_header_id = x_default_cyc_count_header_id)
1271 OR((recinfo.default_cyc_count_header_id IS NULL)
1272 AND(x_default_cyc_count_header_id IS NULL))
1273 )
1277 AND((recinfo.cartonization_flag = x_cartonization_flag)
1274 AND((recinfo.crossdock_flag = x_crossdock_flag)
1275 OR((recinfo.crossdock_flag IS NULL)
1276 AND(x_crossdock_flag IS NULL)))
1278 OR((recinfo.cartonization_flag IS NULL)
1279 AND(x_cartonization_flag IS NULL)))
1280 AND(
1281 (recinfo.default_pick_task_type_id = x_default_pick_task_type_id)
1282 OR((recinfo.default_pick_task_type_id IS NULL)
1283 AND(x_default_pick_task_type_id IS NULL))
1284 )
1285 AND(
1286 (recinfo.default_repl_task_type_id = x_default_repl_task_type_id)
1287 OR((recinfo.default_repl_task_type_id IS NULL)
1288 AND(x_default_repl_task_type_id IS NULL))
1289 )
1290 AND(
1291 (recinfo.default_cc_task_type_id = x_default_cc_task_type_id)
1292 OR((recinfo.default_cc_task_type_id IS NULL)
1293 AND(x_default_cc_task_type_id IS NULL))
1294 )
1295 AND(
1296 (recinfo.default_putaway_task_type_id = x_default_putaway_task_type_id)
1297 OR((recinfo.default_putaway_task_type_id IS NULL)
1298 AND(x_default_putaway_task_type_id IS NULL))
1299 )
1300 AND((recinfo.cost_cutoff_date = x_cost_cutoff_date)
1301 OR((recinfo.cost_cutoff_date IS NULL)
1302 AND(x_cost_cutoff_date IS NULL)))
1303 AND(
1304 (recinfo.skip_task_waiting_minutes = x_skip_task_waiting_minutes)
1305 OR((recinfo.skip_task_waiting_minutes IS NULL)
1306 AND(x_skip_task_waiting_minutes IS NULL))
1307 )
1308 AND(
1309 (recinfo.default_crossdock_subinventory = x_default_xdock_subinventory)
1310 OR((recinfo.default_crossdock_subinventory IS NULL)
1311 AND(x_default_xdock_subinventory IS NULL))
1312 )
1313 AND(
1314 (recinfo.prioritize_wip_jobs = x_prioritize_wip_jobs)
1315 OR((recinfo.prioritize_wip_jobs IS NULL)
1316 AND(x_prioritize_wip_jobs IS NULL))
1317 )
1318 AND(
1319 (recinfo.default_crossdock_locator_id = x_default_xdock_locator_id)
1320 OR((recinfo.default_crossdock_locator_id IS NULL)
1321 AND(x_default_xdock_locator_id IS NULL))
1322 )
1323 AND(
1324 (recinfo.distributed_organization_flag = x_distri_organization_flag)
1325 OR((recinfo.distributed_organization_flag IS NULL)
1326 AND(x_distri_organization_flag IS NULL))
1327 )
1328 AND(
1329 (recinfo.carrier_manifesting_flag = x_carrier_manifesting_flag)
1330 OR((recinfo.carrier_manifesting_flag IS NULL)
1331 AND(x_carrier_manifesting_flag IS NULL))
1332 )
1333 AND(
1334 (recinfo.distribution_account_id = x_distribution_account_id)
1335 OR((recinfo.distribution_account_id IS NULL)
1336 AND(x_distribution_account_id IS NULL))
1337 )
1338 AND(
1339 (recinfo.direct_shipping_allowed = x_direct_shipping_allowed)
1340 OR((recinfo.direct_shipping_allowed IS NULL)
1341 AND(x_direct_shipping_allowed IS NULL))
1342 )
1343 AND(
1344 (recinfo.default_moxfer_task_type_id = x_default_moxfer_task_type_id)
1345 OR((recinfo.default_moxfer_task_type_id IS NULL)
1346 AND(x_default_moxfer_task_type_id IS NULL))
1347 )
1348 AND(
1349 (recinfo.default_moissue_task_type_id = x_default_moissue_task_type_id)
1350 OR((recinfo.default_moissue_task_type_id IS NULL)
1351 AND(x_default_moissue_task_type_id IS NULL))
1352 )
1353 AND(NVL(recinfo.max_clusters_allowed, -1) = NVL(x_max_clusters_allowed, -1))
1354 AND(NVL(recinfo.default_pick_op_plan_id, -1) = NVL(x_default_pick_op_plan_id, -1))
1355 --AND(NVL(recinfo.consigned_flag, -1) = NVL(x_consigned_flag, -1)) /*Bug 4347477*/
1356 AND(NVL(recinfo.cartonize_sales_orders, -1) = NVL(x_cartonize_sales_orders, -1))
1357 AND(NVL(recinfo.cartonize_manufacturing, -1) = NVL(x_cartonize_manufacturing, -1))
1358 AND(NVL(recinfo.total_lpn_length, -1) = NVL(x_total_lpn_length, -1))
1359 AND(NVL(recinfo.ucc_128_suffix_flag, -1) = NVL(x_ucc_128_suffix_flag, -1))
1360 AND(NVL(recinfo.defer_logical_transactions, -1) = NVL(x_defer_logical_transactions, -1))
1361 AND(NVL(recinfo.wip_overpick_enabled, -1) = NVL(x_wip_overpick_enabled, -1)) --OVPK
1362 AND(NVL(recinfo.ovpk_transfer_orders_enabled, -1) = NVL(x_ovpk_transfer_orders_enabled, -1)) --OVPK
1363 --ER3969328: CI project
1364 AND (
1365 (recinfo.auto_del_alloc_flag = x_auto_del_alloc_flag)
1366 OR((recinfo.auto_del_alloc_flag IS NULL)
1367 AND(x_auto_del_alloc_flag IS NULL))
1368 )
1369 -- Bug 4188383.
1370 -- Rearranged the parenthesis of auto_del_alloc_flag above to cover the conditions
1371 -- of auto_del_alloc_flag only; earlier it was covering RFID_VERIF_PCNT_THRESHOLD and WCS_ENABLED fields also.
1372 -- Changed the code for clarity in reading.
1373 AND(NVL(recinfo.RFID_VERIF_PCNT_THRESHOLD, -1) = NVL(x_RFID_VERIF_PCNT_THRESHOLD, -1))
1374 AND(
1375 (recinfo.parent_child_generation_flag = x_parent_child_generation_flag)
1376 OR(
1377 (recinfo.parent_child_generation_flag IS NULL)
1378 AND(x_parent_child_generation_flag IS NULL)
1379 )
1380 )
1384 AND(x_child_lot_zero_padding_flag IS NULL))
1381 AND(
1382 (recinfo.child_lot_zero_padding_flag = x_child_lot_zero_padding_flag)
1383 OR((recinfo.child_lot_zero_padding_flag IS NULL)
1385 )
1386 AND(
1387 (recinfo.child_lot_alpha_prefix = x_child_lot_alpha_prefix)
1388 OR((recinfo.child_lot_alpha_prefix IS NULL)
1389 AND(x_child_lot_alpha_prefix IS NULL))
1390 )
1391 AND(
1392 (recinfo.child_lot_number_length = x_child_lot_number_length)
1393 OR((recinfo.child_lot_number_length IS NULL)
1394 AND(x_child_lot_number_length IS NULL))
1395 )
1396 AND(
1397 (recinfo.child_lot_validation_flag = x_child_lot_validation_flag)
1398 OR((recinfo.child_lot_validation_flag IS NULL)
1399 AND(x_child_lot_validation_flag IS NULL))
1400 )
1401 AND(
1402 (recinfo.copy_lot_attribute_flag = x_copy_lot_attribute_flag)
1403 OR((recinfo.copy_lot_attribute_flag IS NULL)
1404 AND(x_copy_lot_attribute_flag IS NULL))
1405 )
1406 --INVCONV nsinha
1407 -- NSINHA 9/15/2004 START: Added as part of convergence
1408 AND(
1409 (recinfo.create_lot_uom_conversion = x_create_lot_uom_conversion)
1410 OR((recinfo.create_lot_uom_conversion IS NULL)
1411 AND(x_create_lot_uom_conversion IS NULL))
1412 )
1413 AND(
1414 (recinfo.allow_different_status = x_allow_different_status)
1415 OR((recinfo.allow_different_status IS NULL)
1416 AND(x_allow_different_status IS NULL))
1417 )
1418 -- Added the below for # 6633612
1419 AND(
1420 (recinfo.default_status_id = x_default_status_id)
1421 OR((recinfo.default_status_id IS NULL)
1422 AND(x_default_status_id IS NULL))
1423 )
1424
1425 AND(
1426 (recinfo.rules_override_lot_reservation = x_rules_override_lot_reserve)
1427 OR((recinfo.rules_override_lot_reservation IS NULL)
1428 AND(x_rules_override_lot_reserve IS NULL))
1429 )
1430 -- NSINHA 9/15/2004 END: Added as part of convergence
1431 -- END INVCONV nsinha
1432 AND(NVL(recinfo.wcs_enabled, -1) = NVL(x_wcs_enabled, -1)) --MHP
1433 AND((recinfo.trading_partner_org_flag = x_trading_partner_org_flag)
1434 OR((recinfo.trading_partner_org_flag IS NULL) AND(x_trading_partner_org_flag IS NULL)))
1435 AND((recinfo.deferred_cogs_account = x_deferred_cogs_account)
1436 OR((recinfo.deferred_cogs_account IS NULL) AND(x_deferred_cogs_account IS NULL)))
1437 AND((recinfo.default_crossdock_criteria_id = x_default_crossdok_criteria_id)
1438 OR((recinfo.default_crossdock_criteria_id IS NULL) AND(x_default_crossdok_criteria_id IS NULL)))
1439 AND((recinfo.enforce_locator_alis_unq_flag = x_enforce_locator_alis_uq_flag)
1440 OR((recinfo.enforce_locator_alis_unq_flag IS NULL) AND(x_enforce_locator_alis_uq_flag IS NULL)))
1441 AND((recinfo.epc_generation_enabled_flag = x_epc_generation_enabled_flag)
1442 OR((recinfo.epc_generation_enabled_flag IS NULL) AND(x_epc_generation_enabled_flag IS NULL)))
1443 AND((recinfo.company_prefix = x_company_prefix)
1444 OR((recinfo.company_prefix IS NULL) AND(x_company_prefix IS NULL)))
1445 AND((recinfo.company_prefix_index = x_company_prefix_index)
1446 OR((recinfo.company_prefix_index IS NULL) AND(x_company_prefix_index IS NULL)))
1447 AND((recinfo.commercial_govt_entity_number = x_commercial_gov_entity_number)
1448 OR((recinfo.commercial_govt_entity_number IS NULL) AND(x_commercial_gov_entity_number IS NULL)))
1449 AND((recinfo.labor_management_enabled_flag = x_lbr_management_enabled_flag)
1450 OR((recinfo.labor_management_enabled_flag IS NULL) AND(x_lbr_management_enabled_flag IS NULL)))
1451 )--Bug #4188383 Placed the closing parantheses of the NOT condition here to include all the conditions above.
1452 THEN
1453 RAISE record_changed;
1454 END IF;
1455 EXCEPTION
1456 WHEN record_changed THEN
1457 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1458 app_exception.raise_exception;
1459 WHEN OTHERS THEN
1460 RAISE;
1461 END lock_row;
1462
1463 PROCEDURE update_row(
1464 x_rowid VARCHAR2
1465 , x_organization_id NUMBER
1466 , x_last_update_date DATE
1467 , x_last_updated_by NUMBER
1468 , x_last_update_login NUMBER
1469 , x_organization_code VARCHAR2
1470 , x_master_organization_id NUMBER
1471 , x_primary_cost_method NUMBER
1472 , x_cost_organization_id NUMBER
1473 , x_default_material_cost_id NUMBER
1474 , x_default_matl_ovhd_cost_id NUMBER
1475 , x_calendar_exception_set_id NUMBER
1476 , x_calendar_code VARCHAR2
1477 , x_general_ledger_update_code NUMBER
1478 , x_default_atp_rule_id NUMBER
1479 , x_default_picking_rule_id NUMBER
1480 , x_default_locator_order_value NUMBER
1481 , x_default_subinv_order_value NUMBER
1482 , x_negative_inv_receipt_code NUMBER
1483 , x_stock_locator_control_code NUMBER
1484 , x_material_account NUMBER
1485 , x_material_overhead_account NUMBER
1486 , x_matl_ovhd_absorption_acct NUMBER
1487 , x_resource_account NUMBER
1488 , x_purchase_price_var_account NUMBER
1492 , x_intransit_inv_account NUMBER
1489 , x_ap_accrual_account NUMBER
1490 , x_overhead_account NUMBER
1491 , x_outside_processing_account NUMBER
1493 , x_interorg_receivables_account NUMBER
1494 , x_interorg_price_var_account NUMBER
1495 , x_interorg_payables_account NUMBER
1496 , x_cost_of_sales_account NUMBER
1497 , x_encumbrance_account NUMBER
1498 , x_interorg_transfer_cr_account NUMBER
1499 , x_matl_interorg_transfer_code NUMBER
1500 , x_interorg_trnsfr_charge_perc NUMBER
1501 , x_source_organization_id NUMBER
1502 , x_source_subinventory VARCHAR2
1503 , x_source_type NUMBER
1504 , x_serial_number_type NUMBER
1505 , x_auto_serial_alpha_prefix VARCHAR2
1506 , x_start_auto_serial_number VARCHAR2
1507 , x_auto_lot_alpha_prefix VARCHAR2
1508 , x_lot_number_uniqueness NUMBER
1509 , x_lot_number_generation NUMBER
1510 , x_lot_number_zero_padding NUMBER
1511 , x_lot_number_length NUMBER
1512 , x_starting_revision VARCHAR2
1513 , x_attribute_category VARCHAR2
1514 , x_attribute1 VARCHAR2
1515 , x_attribute2 VARCHAR2
1516 , x_attribute3 VARCHAR2
1517 , x_attribute4 VARCHAR2
1518 , x_attribute5 VARCHAR2
1519 , x_attribute6 VARCHAR2
1520 , x_attribute7 VARCHAR2
1521 , x_attribute8 VARCHAR2
1522 , x_attribute9 VARCHAR2
1523 , x_attribute10 VARCHAR2
1524 , x_attribute11 VARCHAR2
1525 , x_attribute12 VARCHAR2
1526 , x_attribute13 VARCHAR2
1527 , x_attribute14 VARCHAR2
1528 , x_attribute15 VARCHAR2
1529 , x_global_attribute_category VARCHAR2
1530 , x_global_attribute1 VARCHAR2
1531 , x_global_attribute2 VARCHAR2
1532 , x_global_attribute3 VARCHAR2
1533 , x_global_attribute4 VARCHAR2
1534 , x_global_attribute5 VARCHAR2
1535 , x_global_attribute6 VARCHAR2
1536 , x_global_attribute7 VARCHAR2
1537 , x_global_attribute8 VARCHAR2
1538 , x_global_attribute9 VARCHAR2
1539 , x_global_attribute10 VARCHAR2
1540 , x_global_attribute11 VARCHAR2
1541 , x_global_attribute12 VARCHAR2
1542 , x_global_attribute13 VARCHAR2
1543 , x_global_attribute14 VARCHAR2
1544 , x_global_attribute15 VARCHAR2
1545 , x_global_attribute16 VARCHAR2
1546 , x_global_attribute17 VARCHAR2
1547 , x_global_attribute18 VARCHAR2
1548 , x_global_attribute19 VARCHAR2
1549 , x_global_attribute20 VARCHAR2
1550 , x_default_demand_class VARCHAR2
1551 , x_encumbrance_reversal_flag NUMBER
1552 , x_maintain_fifo_qty_stack_type NUMBER
1553 , x_invoice_price_var_account NUMBER
1554 , x_average_cost_var_account NUMBER
1555 -- For Bug 7440217
1556 , x_lcm_var_account NUMBER
1557 -- End for Bug 7440217
1558 , x_sales_account NUMBER
1559 , x_expense_account NUMBER
1560 , x_serial_number_generation NUMBER
1561 , x_project_reference_enabled NUMBER
1562 , x_pm_cost_collection_enabled NUMBER
1563 , x_project_control_level NUMBER
1564 , x_avg_rates_cost_type_id NUMBER
1565 , x_txn_approval_timeout_period NUMBER
1566 , x_borrpay_matl_var_account NUMBER
1567 , x_borrpay_moh_var_account NUMBER
1568 , x_borrpay_res_var_account NUMBER
1569 , x_borrpay_osp_var_account NUMBER
1570 , x_borrpay_ovh_var_account NUMBER
1571 , x_org_max_weight NUMBER
1572 , x_org_max_volume NUMBER
1573 , x_org_max_weight_uom_code VARCHAR2
1574 , x_org_max_volume_uom_code VARCHAR2
1575 , x_mo_source_required NUMBER
1576 , x_mo_pick_confirm_required NUMBER
1577 , x_mo_approval_timeout_action NUMBER
1578 , x_project_cost_account NUMBER
1579 , x_process_enabled_flag VARCHAR2
1580 , x_process_orgn_code VARCHAR2
1581 , x_default_cost_group_id NUMBER
1582 , x_lpn_prefix VARCHAR2
1583 , x_lpn_suffix VARCHAR2
1584 , x_lpn_starting_number NUMBER
1585 , x_wms_enabled_flag VARCHAR2
1586 -- For Bug 7440217
1587 , x_lcm_enabled_flag VARCHAR2
1588 -- End for Bug 7440217
1589 , x_qa_skipping_insp_flag VARCHAR2
1590 , x_eam_enabled_flag VARCHAR2
1591 , x_maint_organization_id NUMBER
1592 , x_pregen_putaway_tasks_flag NUMBER
1593 , x_regeneration_interval NUMBER
1594 , x_timezone_id NUMBER
1595 , x_default_wms_picking_rule_id NUMBER
1596 , x_default_put_away_rule_id NUMBER
1597 , x_default_carton_rule_id NUMBER
1598 , x_default_cyc_count_header_id NUMBER
1599 , x_crossdock_flag NUMBER
1600 , x_cartonization_flag NUMBER
1601 , x_allocate_serial_flag VARCHAR2
1602 , x_default_pick_task_type_id NUMBER
1603 , x_default_repl_task_type_id NUMBER
1604 , x_default_cc_task_type_id NUMBER
1605 , x_default_putaway_task_type_id NUMBER
1606 , x_cost_cutoff_date DATE
1610 , x_default_xdock_locator_id NUMBER
1607 , x_skip_task_waiting_minutes NUMBER
1608 , x_prioritize_wip_jobs NUMBER
1609 , x_default_xdock_subinventory VARCHAR2
1611 , x_distri_organization_flag VARCHAR2
1612 , x_carrier_manifesting_flag VARCHAR2
1613 , x_distribution_account_id NUMBER
1614 , x_direct_shipping_allowed VARCHAR2
1615 , x_default_moxfer_task_type_id NUMBER
1616 , x_default_moissue_task_type_id NUMBER
1617 , x_max_clusters_allowed NUMBER
1618 , x_default_pick_op_plan_id NUMBER
1619 , x_consigned_flag VARCHAR2
1620 , x_cartonize_sales_orders VARCHAR2
1621 , x_cartonize_manufacturing VARCHAR2
1622 , x_total_lpn_length NUMBER
1623 , x_ucc_128_suffix_flag VARCHAR2
1624 , x_defer_logical_transactions NUMBER
1625 , x_wip_overpick_enabled VARCHAR2 --OVPK
1626 , x_ovpk_transfer_orders_enabled VARCHAR2 --OVPK
1627 , x_auto_del_alloc_flag VARCHAR2 --ER3969328: CI project
1628 , X_RFID_VERIF_PCNT_THRESHOLD NUMBER -- 11.5.10+ RFID Compliance
1629 , x_parent_child_generation_flag VARCHAR2 DEFAULT NULL
1630 , x_child_lot_zero_padding_flag VARCHAR2 DEFAULT NULL
1631 , x_child_lot_alpha_prefix VARCHAR2 DEFAULT NULL
1632 , x_child_lot_number_length NUMBER DEFAULT NULL
1633 , x_child_lot_validation_flag VARCHAR2 DEFAULT NULL
1634 , x_copy_lot_attribute_flag VARCHAR2 DEFAULT NULL
1635 , x_create_lot_uom_conversion NUMBER DEFAULT NULL -- NSINHA
1636 , x_allow_different_status NUMBER DEFAULT NULL -- NSINHA
1637 , x_rules_override_lot_reserve VARCHAR2 DEFAULT NULL -- NSINHA
1638 , x_wcs_enabled VARCHAR2 --MHP
1639 , x_trading_partner_org_flag VARCHAR2 DEFAULT NULL
1640 , x_deferred_cogs_account NUMBER DEFAULT NULL
1641 , x_default_crossdok_criteria_id NUMBER DEFAULT NULL
1642 , x_enforce_locator_alis_uq_flag VARCHAR2 DEFAULT NULL
1643 , x_epc_generation_enabled_flag VARCHAR2 DEFAULT NULL
1644 , x_company_prefix VARCHAR2 DEFAULT NULL
1645 , x_company_prefix_index VARCHAR2 DEFAULT NULL
1646 , x_commercial_gov_entity_number VARCHAR2 DEFAULT NULL
1647 , x_lbr_management_enabled_flag VARCHAR2 DEFAULT NULL
1648 , x_default_status_id NUMBER DEFAULT NULL -- Added for # 6633612
1649 ) IS
1650 BEGIN
1651 UPDATE mtl_parameters
1652 SET organization_id = x_organization_id
1653 , last_update_date = x_last_update_date
1654 , last_updated_by = x_last_updated_by
1655 , last_update_login = x_last_update_login
1656 , organization_code = x_organization_code
1657 , master_organization_id = x_master_organization_id
1658 , primary_cost_method = x_primary_cost_method
1659 , cost_organization_id = x_cost_organization_id
1660 , default_material_cost_id = x_default_material_cost_id
1661 , default_matl_ovhd_cost_id = x_default_matl_ovhd_cost_id
1662 , calendar_exception_set_id = x_calendar_exception_set_id
1663 , calendar_code = x_calendar_code
1664 , general_ledger_update_code = x_general_ledger_update_code
1665 , default_atp_rule_id = x_default_atp_rule_id
1666 , default_picking_rule_id = x_default_picking_rule_id
1667 , default_locator_order_value = x_default_locator_order_value
1668 , default_subinv_order_value = x_default_subinv_order_value
1669 , negative_inv_receipt_code = x_negative_inv_receipt_code
1670 , stock_locator_control_code = x_stock_locator_control_code
1671 , material_account = x_material_account
1672 , material_overhead_account = x_material_overhead_account
1673 , matl_ovhd_absorption_acct = x_matl_ovhd_absorption_acct
1674 , resource_account = x_resource_account
1675 , purchase_price_var_account = x_purchase_price_var_account
1676 , ap_accrual_account = x_ap_accrual_account
1677 , overhead_account = x_overhead_account
1678 , outside_processing_account = x_outside_processing_account
1679 , intransit_inv_account = x_intransit_inv_account
1680 , interorg_receivables_account = x_interorg_receivables_account
1681 , interorg_price_var_account = x_interorg_price_var_account
1682 , interorg_payables_account = x_interorg_payables_account
1683 , cost_of_sales_account = x_cost_of_sales_account
1684 , encumbrance_account = x_encumbrance_account
1685 , interorg_transfer_cr_account = x_interorg_transfer_cr_account
1686 , matl_interorg_transfer_code = x_matl_interorg_transfer_code
1687 , interorg_trnsfr_charge_percent = x_interorg_trnsfr_charge_perc
1688 , source_organization_id = x_source_organization_id
1689 , source_subinventory = x_source_subinventory
1690 , source_type = x_source_type
1691 , serial_number_type = x_serial_number_type
1692 , auto_serial_alpha_prefix = x_auto_serial_alpha_prefix
1693 , start_auto_serial_number = x_start_auto_serial_number
1694 , auto_lot_alpha_prefix = x_auto_lot_alpha_prefix
1695 , lot_number_uniqueness = x_lot_number_uniqueness
1696 , lot_number_generation = x_lot_number_generation
1697 , lot_number_zero_padding = x_lot_number_zero_padding
1698 , lot_number_length = x_lot_number_length
1699 , starting_revision = x_starting_revision
1700 , attribute_category = x_attribute_category
1701 , attribute1 = x_attribute1
1702 , attribute2 = x_attribute2
1703 , attribute3 = x_attribute3
1707 , attribute7 = x_attribute7
1704 , attribute4 = x_attribute4
1705 , attribute5 = x_attribute5
1706 , attribute6 = x_attribute6
1708 , attribute8 = x_attribute8
1709 , attribute9 = x_attribute9
1710 , attribute10 = x_attribute10
1711 , attribute11 = x_attribute11
1712 , attribute12 = x_attribute12
1713 , attribute13 = x_attribute13
1714 , attribute14 = x_attribute14
1715 , attribute15 = x_attribute15
1716 , global_attribute_category = x_global_attribute_category
1717 , global_attribute1 = x_global_attribute1
1718 , global_attribute2 = x_global_attribute2
1719 , global_attribute3 = x_global_attribute3
1720 , global_attribute4 = x_global_attribute4
1721 , global_attribute5 = x_global_attribute5
1722 , global_attribute6 = x_global_attribute6
1723 , global_attribute7 = x_global_attribute7
1724 , global_attribute8 = x_global_attribute8
1725 , global_attribute9 = x_global_attribute9
1726 , global_attribute10 = x_global_attribute10
1727 , global_attribute11 = x_global_attribute11
1728 , global_attribute12 = x_global_attribute12
1729 , global_attribute13 = x_global_attribute13
1730 , global_attribute14 = x_global_attribute14
1731 , global_attribute15 = x_global_attribute15
1732 , global_attribute16 = x_global_attribute16
1733 , global_attribute17 = x_global_attribute17
1734 , global_attribute18 = x_global_attribute18
1735 , global_attribute19 = x_global_attribute19
1736 , global_attribute20 = x_global_attribute20
1737 , default_demand_class = x_default_demand_class
1738 , encumbrance_reversal_flag = x_encumbrance_reversal_flag
1739 , maintain_fifo_qty_stack_type = x_maintain_fifo_qty_stack_type
1740 , invoice_price_var_account = x_invoice_price_var_account
1741 , average_cost_var_account = x_average_cost_var_account
1742 -- For Bug 7440217
1743 , lcm_var_account = x_lcm_var_account
1744 -- End for Bug 7440217
1745 , sales_account = x_sales_account
1746 , expense_account = x_expense_account
1747 , serial_number_generation = x_serial_number_generation
1748 , project_reference_enabled = x_project_reference_enabled
1749 , pm_cost_collection_enabled = x_pm_cost_collection_enabled
1750 , project_control_level = x_project_control_level
1751 , avg_rates_cost_type_id = x_avg_rates_cost_type_id
1752 , txn_approval_timeout_period = x_txn_approval_timeout_period
1753 , borrpay_matl_var_account = x_borrpay_matl_var_account
1754 , borrpay_moh_var_account = x_borrpay_moh_var_account
1755 , borrpay_res_var_account = x_borrpay_res_var_account
1756 , borrpay_osp_var_account = x_borrpay_osp_var_account
1757 , borrpay_ovh_var_account = x_borrpay_ovh_var_account
1758 , org_max_weight = x_org_max_weight
1759 , org_max_volume = x_org_max_volume
1760 , org_max_weight_uom_code = x_org_max_weight_uom_code
1761 , org_max_volume_uom_code = x_org_max_volume_uom_code
1762 , mo_source_required = x_mo_source_required
1763 , mo_pick_confirm_required = NVL(x_mo_pick_confirm_required,'2')
1764 , mo_approval_timeout_action = x_mo_approval_timeout_action
1765 , project_cost_account = x_project_cost_account
1766 , process_enabled_flag = x_process_enabled_flag
1767 , process_orgn_code = x_process_orgn_code
1768 , default_cost_group_id = x_default_cost_group_id
1769 , lpn_prefix = x_lpn_prefix
1770 , lpn_suffix = x_lpn_suffix
1771 , lpn_starting_number = x_lpn_starting_number
1772 , wms_enabled_flag = NVL(x_wms_enabled_flag, 'N')
1773 -- For Bug 7440217
1774 , lcm_enabled_flag = NVL(x_lcm_enabled_flag, 'N')
1775 -- End for Bug 7440217
1776 , qa_skipping_insp_flag = NVL(x_qa_skipping_insp_flag, 'N')
1777 , eam_enabled_flag = NVL(x_eam_enabled_flag, 'N')
1778 , maint_organization_id = x_maint_organization_id
1779 , pregen_putaway_tasks_flag = x_pregen_putaway_tasks_flag
1780 , regeneration_interval = x_regeneration_interval
1781 , timezone_id = x_timezone_id
1782 , default_wms_picking_rule_id = x_default_wms_picking_rule_id
1783 , default_put_away_rule_id = x_default_put_away_rule_id
1784 , default_carton_rule_id = x_default_carton_rule_id
1785 , default_cyc_count_header_id = x_default_cyc_count_header_id
1786 , crossdock_flag = x_crossdock_flag
1787 , cartonization_flag = x_cartonization_flag
1788 , allocate_serial_flag = x_allocate_serial_flag
1789 , default_pick_task_type_id = x_default_pick_task_type_id
1790 , default_repl_task_type_id = x_default_repl_task_type_id
1791 , default_cc_task_type_id = x_default_cc_task_type_id
1792 , default_putaway_task_type_id = x_default_putaway_task_type_id
1793 , cost_cutoff_date = x_cost_cutoff_date
1794 , skip_task_waiting_minutes = x_skip_task_waiting_minutes
1795 , prioritize_wip_jobs = x_prioritize_wip_jobs
1796 , default_crossdock_subinventory = x_default_xdock_subinventory
1797 , default_crossdock_locator_id = x_default_xdock_locator_id
1798 , distributed_organization_flag = x_distri_organization_flag
1799 , carrier_manifesting_flag = x_carrier_manifesting_flag
1800 , distribution_account_id = x_distribution_account_id
1804 , max_clusters_allowed = x_max_clusters_allowed
1801 , direct_shipping_allowed = x_direct_shipping_allowed
1802 , default_moxfer_task_type_id = x_default_moxfer_task_type_id
1803 , default_moissue_task_type_id = x_default_moissue_task_type_id
1805 , default_pick_op_plan_id = x_default_pick_op_plan_id
1806 --, consigned_flag = x_consigned_flag /*Bug 4347477*/
1807 , cartonize_sales_orders = x_cartonize_sales_orders
1808 , cartonize_manufacturing = x_cartonize_manufacturing
1809 , total_lpn_length = x_total_lpn_length
1810 , ucc_128_suffix_flag = x_ucc_128_suffix_flag
1811 , defer_logical_transactions = x_defer_logical_transactions
1812 , wip_overpick_enabled = NVL(x_wip_overpick_enabled,'N') --OVPK
1813 , ovpk_transfer_orders_enabled = NVL(x_ovpk_transfer_orders_enabled,'Y') --OVPK
1814 , auto_del_alloc_flag = x_auto_del_alloc_flag --ER3969328: CI project
1815 , rfid_verif_pcnt_threshold = X_Rfid_verif_pcnt_threshold --11.5.10+ RFID Compliance
1816 , parent_child_generation_flag = x_parent_child_generation_flag
1817 , child_lot_zero_padding_flag = x_child_lot_zero_padding_flag
1818 , child_lot_alpha_prefix = x_child_lot_alpha_prefix
1819 , child_lot_number_length = x_child_lot_number_length
1820 , child_lot_validation_flag = x_child_lot_validation_flag
1821 , copy_lot_attribute_flag = x_copy_lot_attribute_flag
1822 , create_lot_uom_conversion = x_create_lot_uom_conversion -- NSINHA
1823 , allow_different_status = x_allow_different_status -- NSINHA
1824 , rules_override_lot_reservation = x_rules_override_lot_reserve -- NSINHA
1825 , wcs_enabled = x_wcs_enabled --MHP
1826 , trading_partner_org_flag = x_trading_partner_org_flag
1827 , deferred_cogs_account = x_deferred_cogs_account
1828 , default_crossdock_criteria_id = x_default_crossdok_criteria_id
1829 , enforce_locator_alis_unq_flag = x_enforce_locator_alis_uq_flag
1830 , epc_generation_enabled_flag = x_epc_generation_enabled_flag
1831 , company_prefix = x_company_prefix
1832 , company_prefix_index = x_company_prefix_index
1833 , commercial_govt_entity_number = x_commercial_gov_entity_number
1834 , labor_management_enabled_flag = x_lbr_management_enabled_flag
1835 , default_status_id = x_default_status_id -- Added for # 6633612
1836 WHERE ROWID = x_rowid;
1837
1838 IF (SQL%NOTFOUND) THEN
1839 RAISE NO_DATA_FOUND;
1840 END IF;
1841 END update_row;
1842
1843 PROCEDURE delete_row(x_rowid VARCHAR2) IS
1844 BEGIN
1845 DELETE FROM mtl_parameters
1846 WHERE ROWID = x_rowid;
1847
1848 IF (SQL%NOTFOUND) THEN
1849 RAISE NO_DATA_FOUND;
1850 END IF;
1851 END delete_row;
1852
1853 PROCEDURE upd_sub_accts_with_org_accts(
1854 x_return_status OUT NOCOPY VARCHAR2
1855 , x_msg_count OUT NOCOPY NUMBER
1856 , x_msg_data OUT NOCOPY VARCHAR2
1857 , p_default_cost_group_id IN NUMBER
1858 , p_material_account IN NUMBER
1859 , p_material_overhead_account IN NUMBER
1860 , p_resource_account IN NUMBER
1861 , p_overhead_account IN NUMBER
1862 , p_outside_processing_account IN NUMBER
1863 , p_expense_account IN NUMBER
1864 , p_encumbrance_account IN NUMBER
1865 , p_organization_id IN NUMBER
1866 ) IS
1867 TYPE table_of_rowids IS TABLE OF ROWID
1868 INDEX BY BINARY_INTEGER;
1869
1870 ROWS table_of_rowids;
1871 resource_busy EXCEPTION;
1872 PRAGMA EXCEPTION_INIT(resource_busy, -00054);
1873 j NUMBER := NULL;
1874 BEGIN
1875 x_return_status := fnd_api.g_ret_sts_success;
1876
1877 SELECT ROWID
1878 BULK COLLECT INTO ROWS
1879 FROM mtl_secondary_inventories
1880 WHERE organization_id = p_organization_id
1881 FOR UPDATE NOWAIT;
1882
1883 --Bug 2164055 fix
1884
1888 -- No Subinventories to update
1885 IF ((ROWS IS NULL)
1886 OR(ROWS.COUNT = 0)) THEN
1887 NULL;
1889 ELSE
1890 FORALL j IN ROWS.FIRST .. ROWS.LAST
1891 UPDATE mtl_secondary_inventories
1892 SET default_cost_group_id = p_default_cost_group_id
1893 , material_account = p_material_account
1894 , material_overhead_account = p_material_overhead_account
1895 , resource_account = p_resource_account
1896 , overhead_account = p_overhead_account
1897 , outside_processing_account = p_outside_processing_account
1898 --expense_account = p_Expense_Account,
1899 --encumbrance_account = p_Encumbrance_Account
1900 WHERE ROWID = ROWS(j);
1901 END IF;
1902
1903 x_return_status := fnd_api.g_ret_sts_success;
1904 EXCEPTION
1905 WHEN resource_busy THEN
1906 x_return_status := fnd_api.g_ret_sts_error;
1907 fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1908 WHEN NO_DATA_FOUND THEN
1909 x_return_status := fnd_api.g_ret_sts_success;
1910 fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1911 WHEN fnd_api.g_exc_error THEN
1912 x_return_status := fnd_api.g_ret_sts_error;
1913 fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1914 WHEN fnd_api.g_exc_unexpected_error THEN
1915 x_return_status := fnd_api.g_ret_sts_unexp_error;
1916 fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1917 WHEN OTHERS THEN
1918 x_return_status := fnd_api.g_ret_sts_unexp_error;
1919
1920 IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1921 fnd_msg_pub.add_exc_msg(g_pkg_name, 'MTL_PARAMETERS_PKG');
1922 END IF;
1923 END upd_sub_accts_with_org_accts;
1924
1925 FUNCTION get_miss_num
1926 RETURN NUMBER IS
1927 BEGIN
1928 RETURN fnd_api.g_miss_num;
1929 END;
1930
1931 PROCEDURE default_pjm_rule_setup(
1932 x_return_status OUT NOCOPY VARCHAR2
1933 , x_msg_count OUT NOCOPY NUMBER
1934 , x_msg_data OUT NOCOPY VARCHAR2
1935 , p_organization_id IN NUMBER
1936 ) IS
1937 strgy_assn_exist VARCHAR2(1) := 'N';
1938 l_stg_assignment_id NUMBER;
1939 --l_row_id ROWID;
1940 BEGIN
1941 x_return_status := fnd_api.g_ret_sts_success;
1942
1943 -- Added by grao on 02 Dec, 2002 for the new Strrategy Assignment Matrix
1944 --
1945 BEGIN
1946 SELECT 'Y'
1947 INTO strgy_assn_exist
1948 FROM DUAL
1949 WHERE EXISTS(SELECT from_organization_id
1950 FROM wms_selection_criteria_txn
1951 WHERE from_organization_id = p_organization_id
1952 AND return_type_code = 'S'
1953 AND return_type_id = 8
1954 AND rule_type_code = 2);
1955 EXCEPTION
1956 WHEN NO_DATA_FOUND THEN
1957 strgy_assn_exist := 'N';
1958 END;
1959
1960 IF strgy_assn_exist = 'Y' THEN
1961 RETURN;
1962 END IF;
1963
1964 SELECT wms_selection_criteria_txn_s.NEXTVAL
1965 INTO l_stg_assignment_id
1966 FROM DUAL;
1967
1968 wms_strategy_upgrade_pvt.insert_row(
1969 x_stg_assignment_id => l_stg_assignment_id
1970 , x_sequence_number => 10
1971 , x_rule_type_code => 2
1972 , x_return_type_code => 'S'
1973 , x_return_type_id => 8
1974 , x_enabled_flag => 1
1975 , x_date_type_code => 11
1976 , x_date_type_from => NULL
1977 , x_date_type_to => NULL
1978 , x_date_type_lookup_type => NULL
1979 , x_effective_from => NULL
1980 , x_effective_to => NULL
1981 , x_from_organization_id => p_organization_id
1982 , x_from_subinventory_name => NULL
1983 , x_to_organization_id => NULL
1984 , x_to_subinventory_name => NULL
1985 , x_customer_id => NULL
1986 , x_freight_code => NULL
1987 , x_inventory_item_id => NULL
1988 , x_item_type => NULL
1989 , x_assignment_group_id => NULL
1990 , x_abc_class_id => NULL
1991 , x_category_set_id => NULL
1992 , x_category_id => NULL
1993 , x_order_type_id => NULL
1994 , x_vendor_id => NULL
1995 , x_project_id => NULL
1996 , x_task_id => NULL
1997 , x_user_id => NULL
1998 , x_transaction_action_id => NULL
1999 , x_reason_id => NULL
2000 , x_transaction_source_type_id => NULL
2001 , x_transaction_type_id => NULL
2002 , x_uom_code => NULL
2003 , x_uom_class => NULL
2004 , x_last_updated_by => fnd_global.user_id
2005 , x_last_update_date => SYSDATE
2006 , x_created_by => fnd_global.user_id
2007 , x_creation_date => SYSDATE
2008 , x_last_update_login => fnd_global.login_id
2009 );
2010 --- End of new code
2011
2012 EXCEPTION
2013 WHEN fnd_api.g_exc_error THEN
2014 x_return_status := fnd_api.g_ret_sts_error;
2015 WHEN fnd_api.g_exc_unexpected_error THEN
2016 x_return_status := fnd_api.g_ret_sts_unexp_error;
2017 WHEN OTHERS THEN
2018 x_return_status := fnd_api.g_ret_sts_unexp_error;
2019 END default_pjm_rule_setup;
2020
2021 FUNCTION g_ret_sts_success
2022 RETURN VARCHAR2 IS
2023 BEGIN
2024 RETURN fnd_api.g_ret_sts_success;
2025 END;
2026 END mtl_parameters_pkg;