535: last_update_date = sysdate,
536: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
537: last_update_login = 0,
538: source_lang = userenv('LANG')
539: where status_id = fnd_number.canonical_to_number(x_status_id)
540: and userenv('LANG') IN (language, source_lang);
541: END translate_row;
542:
543:
598: l_user_id := 1;
599: END IF;
600:
601: SELECT SYSDATE INTO l_sysdate FROM dual;
602: l_status_id := fnd_number.canonical_to_number(x_status_id);
603: l_zone_control := fnd_number.canonical_to_number(x_zone_control);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
599: END IF;
600:
601: SELECT SYSDATE INTO l_sysdate FROM dual;
602: l_status_id := fnd_number.canonical_to_number(x_status_id);
603: l_zone_control := fnd_number.canonical_to_number(x_zone_control);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
600:
601: SELECT SYSDATE INTO l_sysdate FROM dual;
602: l_status_id := fnd_number.canonical_to_number(x_status_id);
603: l_zone_control := fnd_number.canonical_to_number(x_zone_control);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
601: SELECT SYSDATE INTO l_sysdate FROM dual;
602: l_status_id := fnd_number.canonical_to_number(x_status_id);
603: l_zone_control := fnd_number.canonical_to_number(x_zone_control);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
602: l_status_id := fnd_number.canonical_to_number(x_status_id);
603: l_zone_control := fnd_number.canonical_to_number(x_zone_control);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
603: l_zone_control := fnd_number.canonical_to_number(x_zone_control);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);
604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);
605: l_lot_control := fnd_number.canonical_to_number(x_lot_control);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);
612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);
606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);
612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);
613:
614: l_onhand_control := fnd_number.canonical_to_number(x_onhand_control); --Onhand Material Status Control Bug #6633612
607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);
612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);
613:
614: l_onhand_control := fnd_number.canonical_to_number(x_onhand_control); --Onhand Material Status Control Bug #6633612
615: --END INVCONV kkillams
608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_control);
609: --INVCONV kkillams
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);
612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);
613:
614: l_onhand_control := fnd_number.canonical_to_number(x_onhand_control); --Onhand Material Status Control Bug #6633612
615: --END INVCONV kkillams
616:
610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);
611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);
612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);
613:
614: l_onhand_control := fnd_number.canonical_to_number(x_onhand_control); --Onhand Material Status Control Bug #6633612
615: --END INVCONV kkillams
616:
617: MTL_MATERIAL_STATUSES_PKG.update_row
618: (