DBA Data[Home] [Help]

APPS.WMS_PARAMETERS_PKG dependencies on FND_NUMBER

Line 594: WHERE parameter_id = fnd_number.canonical_to_number(x_parameter_id)

590: last_update_date = Sysdate,
591: last_updated_by = Decode(x_owner, 'SEED', 1, 0),
592: last_update_login = 0,
593: source_lang = userenv('LANG')
594: WHERE parameter_id = fnd_number.canonical_to_number(x_parameter_id)
595: AND userenv('LANG') IN (language, source_lang);
596: END translate_row;
597:
598: PROCEDURE load_row

Line 663: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);

659: l_user_id := 1;
660: END IF;
661: --
662: SELECT Sysdate INTO l_sysdate FROM dual;
663: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
664: l_object_id := fnd_number.canonical_to_number(x_object_id);
665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);

Line 664: l_object_id := fnd_number.canonical_to_number(x_object_id);

660: END IF;
661: --
662: SELECT Sysdate INTO l_sysdate FROM dual;
663: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
664: l_object_id := fnd_number.canonical_to_number(x_object_id);
665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);

Line 665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);

661: --
662: SELECT Sysdate INTO l_sysdate FROM dual;
663: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
664: l_object_id := fnd_number.canonical_to_number(x_object_id);
665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);
669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);

Line 666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);

662: SELECT Sysdate INTO l_sysdate FROM dual;
663: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
664: l_object_id := fnd_number.canonical_to_number(x_object_id);
665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);
669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);
670: l_flexfield_application_id :=

Line 667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);

663: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
664: l_object_id := fnd_number.canonical_to_number(x_object_id);
665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);
669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);
670: l_flexfield_application_id :=
671: fnd_number.canonical_to_number(x_flexfield_application_id);

Line 668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);

664: l_object_id := fnd_number.canonical_to_number(x_object_id);
665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);
669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);
670: l_flexfield_application_id :=
671: fnd_number.canonical_to_number(x_flexfield_application_id);
672: wms_parameters_pkg.update_row

Line 669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);

665: l_db_object_ref_type_code := fnd_number.canonical_to_number(x_db_object_ref_type_code);
666: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);
669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);
670: l_flexfield_application_id :=
671: fnd_number.canonical_to_number(x_flexfield_application_id);
672: wms_parameters_pkg.update_row
673: (

Line 671: fnd_number.canonical_to_number(x_flexfield_application_id);

667: l_db_object_reference_id := fnd_number.canonical_to_number(x_db_object_reference_id);
668: l_parameter_type_code := fnd_number.canonical_to_number(x_parameter_type_code);
669: l_data_type_code := fnd_number.canonical_to_number(x_data_type_code);
670: l_flexfield_application_id :=
671: fnd_number.canonical_to_number(x_flexfield_application_id);
672: wms_parameters_pkg.update_row
673: (
674: x_parameter_id => l_parameter_id
675: ,x_object_id => l_object_id