APPS.BEN_US_DATABASE_ITEMS_PKG dependencies on FF_ROUTE_PARAMETERS

Line 264: INSERT INTO ff_route_parameters

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,

Line 271: (ff_route_parameters_s.nextval,

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);

Line 281: INSERT INTO ff_route_parameters

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,

Line 288: (ff_route_parameters_s.nextval,

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);

Line 298: INSERT INTO ff_route_parameters

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,

Line 305: (ff_route_parameters_s.nextval,

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);

Line 357: FROM ff_route_parameters

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;

Line 372: FROM ff_route_parameters

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;

Line 388: FROM ff_route_parameters

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;