350: l_user_id := 1;
351: END IF;
352: --
353: SELECT Sysdate INTO l_sysdate FROM dual;
354: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
355: l_parent_db_object_id :=
356: fnd_number.canonical_to_number(x_parent_db_object_id);
357: l_context_parameter_id :=
358: fnd_number.canonical_to_number(x_context_parameter_id);
352: --
353: SELECT Sysdate INTO l_sysdate FROM dual;
354: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
355: l_parent_db_object_id :=
356: fnd_number.canonical_to_number(x_parent_db_object_id);
357: l_context_parameter_id :=
358: fnd_number.canonical_to_number(x_context_parameter_id);
359: wms_db_objects_pkg.update_row
360: (
354: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
355: l_parent_db_object_id :=
356: fnd_number.canonical_to_number(x_parent_db_object_id);
357: l_context_parameter_id :=
358: fnd_number.canonical_to_number(x_context_parameter_id);
359: wms_db_objects_pkg.update_row
360: (
361: x_db_object_id => l_db_object_id
362: ,x_last_updated_by => l_user_id