426: l_user_id := 1;
427: END IF;
428: --
429: SELECT Sysdate INTO l_sysdate FROM dual;
430: l_strategy_id := fnd_number.canonical_to_number(x_strategy_id);
431: l_rule_id := fnd_number.canonical_to_number(x_rule_id );
432: l_sequence_number :=
433: fnd_number.canonical_to_number(x_sequence_number);
434: l_date_type_from :=
427: END IF;
428: --
429: SELECT Sysdate INTO l_sysdate FROM dual;
430: l_strategy_id := fnd_number.canonical_to_number(x_strategy_id);
431: l_rule_id := fnd_number.canonical_to_number(x_rule_id );
432: l_sequence_number :=
433: fnd_number.canonical_to_number(x_sequence_number);
434: l_date_type_from :=
435: fnd_number.canonical_to_number(x_date_type_from );
429: SELECT Sysdate INTO l_sysdate FROM dual;
430: l_strategy_id := fnd_number.canonical_to_number(x_strategy_id);
431: l_rule_id := fnd_number.canonical_to_number(x_rule_id );
432: l_sequence_number :=
433: fnd_number.canonical_to_number(x_sequence_number);
434: l_date_type_from :=
435: fnd_number.canonical_to_number(x_date_type_from );
436: l_date_type_to :=
437: fnd_number.canonical_to_number(x_date_type_to );
431: l_rule_id := fnd_number.canonical_to_number(x_rule_id );
432: l_sequence_number :=
433: fnd_number.canonical_to_number(x_sequence_number);
434: l_date_type_from :=
435: fnd_number.canonical_to_number(x_date_type_from );
436: l_date_type_to :=
437: fnd_number.canonical_to_number(x_date_type_to );
438:
439: wms_strategy_members_pkg.update_row
433: fnd_number.canonical_to_number(x_sequence_number);
434: l_date_type_from :=
435: fnd_number.canonical_to_number(x_date_type_from );
436: l_date_type_to :=
437: fnd_number.canonical_to_number(x_date_type_to );
438:
439: wms_strategy_members_pkg.update_row
440: (
441: x_rowid => NULL