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
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);
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);
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);
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 :=
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);
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
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: (
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