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