340: l_user_id := 1;
341: END IF;
342: --
343: SELECT Sysdate INTO l_sysdate FROM dual;
344: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
345: l_type_code :=
346: fnd_number.canonical_to_number(x_type_code);
347: l_sequence_number :=
348: fnd_number.canonical_to_number(x_sequence_number);
342: --
343: SELECT Sysdate INTO l_sysdate FROM dual;
344: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
345: l_type_code :=
346: fnd_number.canonical_to_number(x_type_code);
347: l_sequence_number :=
348: fnd_number.canonical_to_number(x_sequence_number);
349: l_parameter_id :=
350: fnd_number.canonical_to_number(x_parameter_id);
344: l_db_object_id := fnd_number.canonical_to_number(x_db_object_id);
345: l_type_code :=
346: fnd_number.canonical_to_number(x_type_code);
347: l_sequence_number :=
348: fnd_number.canonical_to_number(x_sequence_number);
349: l_parameter_id :=
350: fnd_number.canonical_to_number(x_parameter_id);
351: l_parent_parameter_id :=
352: fnd_number.canonical_to_number(x_parent_parameter_id);
346: fnd_number.canonical_to_number(x_type_code);
347: l_sequence_number :=
348: fnd_number.canonical_to_number(x_sequence_number);
349: l_parameter_id :=
350: fnd_number.canonical_to_number(x_parameter_id);
351: l_parent_parameter_id :=
352: fnd_number.canonical_to_number(x_parent_parameter_id);
353: wms_db_object_joins_pkg.update_row
354: (
348: fnd_number.canonical_to_number(x_sequence_number);
349: l_parameter_id :=
350: fnd_number.canonical_to_number(x_parameter_id);
351: l_parent_parameter_id :=
352: fnd_number.canonical_to_number(x_parent_parameter_id);
353: wms_db_object_joins_pkg.update_row
354: (
355: x_db_object_id => l_db_object_id
356: ,x_type_code => l_type_code