89: sysdate
90: );
91:
92: -- Define the route parameter
93: insert into ff_route_parameters
94: (
95: route_parameter_id,
96: route_id,
97: data_type,
98: parameter_name,
99: sequence_no
100: )
101: select
102: ff_route_parameters_s.nextval,
103: ff_routes_s.currval,
104: 'N',
105: 'User Entity ID',
106: 1
191: sysdate
192: );
193:
194: -- Define the route parameter
195: insert into ff_route_parameters
196: (
197: route_parameter_id,
198: route_id,
199: data_type,
200: parameter_name,
201: sequence_no
202: )
203: select
204: ff_route_parameters_s.nextval,
205: ff_routes_s.currval,
206: 'N',
207: 'User Entity ID',
208: 1
309: sysdate
310: );
311:
312: -- Define the route parameter
313: insert into ff_route_parameters
314: (
315: route_parameter_id,
316: route_id,
317: data_type,
318: parameter_name,
319: sequence_no
320: )
321: select
322: ff_route_parameters_s.nextval,
323: ff_routes_s.currval,
324: 'N',
325: 'User Entity ID',
326: 1
513: -- Find the User Entity Route parameter that goes with the archive route
514: --
515: select route_parameter_id
516: into l_route_parameter_id
517: from ff_route_parameters
518: where parameter_name = 'User Entity ID'
519: and route_id = l_route_id;
520:
521: BEGIN
718: where user_entity_name = c_user_entity_name;
719: --
720: cursor get_route_parameter_id (c_route_id number) is
721: select route_parameter_id
722: from ff_route_parameters
723: where parameter_name = 'User Entity ID'
724: and route_id = c_route_id;
725: --
726: