166: -- Insert any route parameters
167: --
168: IF p_param_name1 is not null THEN
169: --
170: INSERT INTO ff_route_parameters
171: (route_parameter_id,
172: route_id,
173: sequence_no,
174: parameter_name,
173: sequence_no,
174: parameter_name,
175: data_type)
176: VALUES
177: (ff_route_parameters_s.nextval,
178: l_route_id,
179: 1,
180: p_param_name1,
181: p_param_type1);
183: END IF;
184: --
185: IF p_param_name2 is not null THEN
186: --
187: INSERT INTO ff_route_parameters
188: (route_parameter_id,
189: route_id,
190: sequence_no,
191: parameter_name,
190: sequence_no,
191: parameter_name,
192: data_type)
193: VALUES
194: (ff_route_parameters_s.nextval,
195: l_route_id,
196: 1,
197: p_param_name2,
198: p_param_type2);
242: value)
243: SELECT route_parameter_id,
244: l_user_entity_id,
245: p_param_value1
246: FROM ff_route_parameters
247: where route_id = l_route_id
248: and sequence_no = 1;
249: --
250: END IF;
257: value)
258: SELECT route_parameter_id,
259: l_user_entity_id,
260: p_param_value2
261: FROM ff_route_parameters
262: where route_id = l_route_id
263: and sequence_no = 2;
264: --
265: END IF;