260: -- Insert any route parameters
261: --
262: IF p_param_name1 is not null THEN
263: --
264: INSERT INTO ff_route_parameters
265: (route_parameter_id,
266: route_id,
267: sequence_no,
268: parameter_name,
267: sequence_no,
268: parameter_name,
269: data_type)
270: VALUES
271: (ff_route_parameters_s.nextval,
272: l_route_id,
273: 1,
274: p_param_name1,
275: p_param_type1);
277: END IF;
278: --
279: IF p_param_name2 is not null THEN
280: --
281: INSERT INTO ff_route_parameters
282: (route_parameter_id,
283: route_id,
284: sequence_no,
285: parameter_name,
284: sequence_no,
285: parameter_name,
286: data_type)
287: VALUES
288: (ff_route_parameters_s.nextval,
289: l_route_id,
290: 2,
291: p_param_name2,
292: p_param_type2);
294: END IF;
295: --
296: IF p_param_name3 is not null THEN
297: --
298: INSERT INTO ff_route_parameters
299: (route_parameter_id,
300: route_id,
301: sequence_no,
302: parameter_name,
301: sequence_no,
302: parameter_name,
303: data_type)
304: VALUES
305: (ff_route_parameters_s.nextval,
306: l_route_id,
307: 3,
308: p_param_name3,
309: p_param_type3);
353: value)
354: SELECT route_parameter_id,
355: l_user_entity_id,
356: p_param_value1
357: FROM ff_route_parameters
358: where route_id = l_route_id
359: and sequence_no = 1;
360: --
361: END IF;
368: value)
369: SELECT route_parameter_id,
370: l_user_entity_id,
371: p_param_value2
372: FROM ff_route_parameters
373: where route_id = l_route_id
374: and sequence_no = 2;
375: --
376: END IF;
384: value)
385: SELECT route_parameter_id,
386: l_user_entity_id,
387: p_param_value3
388: FROM ff_route_parameters
389: where route_id = l_route_id
390: and sequence_no = 3;
391: --
392: END IF;