495: sequence_no
496: from ff_route_context_usages
497: where route_id = l_template_route_id;
498: --
499: insert into ff_route_parameters(
500: ROUTE_PARAMETER_ID,
501: ROUTE_ID,
502: DATA_TYPE,
503: PARAMETER_NAME,
501: ROUTE_ID,
502: DATA_TYPE,
503: PARAMETER_NAME,
504: SEQUENCE_NO)
505: select ff_route_parameters_s.nextval,
506: p_route_id,
507: data_type,
508: parameter_name,
509: sequence_no
506: p_route_id,
507: data_type,
508: parameter_name,
509: sequence_no
510: from ff_route_parameters
511: where route_id = l_template_route_id;
512: end create_route;
513: -- ----------------------------------------------------------------------------
514: -- |------------------------< create_dimension_route >------------------------|