eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_MATERIAL_STATUSES_PKG dependencies on FND_NUMBER

Line 539: where status_id = fnd_number.canonical_to_number(x_status_id)

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:

Line 602: l_status_id := fnd_number.canonical_to_number(x_status_id);

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);

Line 603: l_zone_control := fnd_number.canonical_to_number(x_zone_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);

Line 604: l_locator_control := fnd_number.canonical_to_number(x_locator_control);

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);

Line 605: l_lot_control := fnd_number.canonical_to_number(x_lot_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

Line 606: l_serial_control := fnd_number.canonical_to_number(x_serial_control);

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);

Line 607: l_enabled_flag := fnd_number.canonical_to_number(x_enabled_flag);

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);

Line 608: l_lpn_control := fnd_number.canonical_to_number(x_lpn_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);
612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);

Line 610: l_inventory_atp_code := fnd_number.canonical_to_number(x_inventory_atp_code);

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

Line 611: l_reservable_type := fnd_number.canonical_to_number(x_reservable_type);

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

Line 612: l_availability_type := fnd_number.canonical_to_number(x_availability_type);

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:

Line 614: l_onhand_control := fnd_number.canonical_to_number(x_onhand_control); --Onhand Material Status Control Bug #6633612

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: (