297: l_user_id := 1;
298: END IF;
299: --
300: SELECT Sysdate INTO l_sysdate FROM dual;
301: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
302: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
303: l_consistency_id :=
304: fnd_number.canonical_to_number(x_consistency_id );
305:
298: END IF;
299: --
300: SELECT Sysdate INTO l_sysdate FROM dual;
301: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
302: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
303: l_consistency_id :=
304: fnd_number.canonical_to_number(x_consistency_id );
305:
306: wms_rule_consistencies_pkg.update_row
300: SELECT Sysdate INTO l_sysdate FROM dual;
301: l_rule_id := fnd_number.canonical_to_number(x_rule_id);
302: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id );
303: l_consistency_id :=
304: fnd_number.canonical_to_number(x_consistency_id );
305:
306: wms_rule_consistencies_pkg.update_row
307: (
308: x_consistency_id => l_consistency_id