544: begin
545:
546: select route_parameter_id
547: into l_dummy_id
548: from ff_route_parameter_values
549: where route_parameter_id = l_route_parameter_id
550: and user_entity_id = l_user_entity_seq;
551:
552: update ff_route_parameter_values
548: from ff_route_parameter_values
549: where route_parameter_id = l_route_parameter_id
550: and user_entity_id = l_user_entity_seq;
551:
552: update ff_route_parameter_values
553: set value = l_user_entity_seq
554: where route_parameter_id = l_route_parameter_id
555: and user_entity_id = l_user_entity_seq;
556:
557: exception when no_data_found then
558: --
559: -- route parameter does not exist so cause insert
560: --
561: insert into ff_route_parameter_values
562: (
563: route_parameter_id,
564: user_entity_id,
565: value,
634: 0, /* created_by */
635: sysdate /* creation_date */
636: );
637:
638: insert into ff_route_parameter_values
639: (
640: route_parameter_id,
641: user_entity_id,
642: value,
806: 0,
807: sysdate
808: );
809: --
810: insert into ff_route_parameter_values
811: (
812: route_parameter_id,
813: user_entity_id,
814: value,