76: creation_date
77: )
78: values
79: (
80: ff_routes_s.nextval,
81: 'ARCHIVE_NUMBER_ROUTE',
82: 'N',
83: 'Generic number archive route',
84: l_text,
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
107: from dual;
116: context_id,
117: sequence_no
118: )
119: select
120: ff_routes_s.currval,
121: l_assignment_action_context_id,
122: 1
123: from dual;
124: --
123: from dual;
124: --
125: -- set the route_id to be returned
126: --
127: select ff_routes_s.currval into l_route_id from dual;
128: --
129: END IF;
130: --
131: RETURN l_route_id;
178: creation_date
179: )
180: values
181: (
182: ff_routes_s.nextval,
183: 'ARCHIVE_CHAR_ROUTE',
184: 'N',
185: 'Generic character archive route',
186: l_text,
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
209: from dual;
219: context_id,
220: sequence_no
221: )
222: select
223: ff_routes_s.currval,
224: l_assignment_action_context_id,
225: 1
226: from dual;
227: --
226: from dual;
227: --
228: -- set the route_id to be returned
229: --
230: select ff_routes_s.currval into l_route_id from dual;
231: --
232: END IF;
233: --
234: RETURN l_route_id;
296: creation_date
297: )
298: values
299: (
300: ff_routes_s.nextval,
301: l_new_route_name,
302: 'N',
303: 'Two Context Generic archive route',
304: l_text,
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
327: from dual;
337: context_id,
338: sequence_no
339: )
340: select
341: ff_routes_s.currval,
342: l_assignment_action_context_id,
343: 1
344: from dual;
345: --
353: context_id,
354: sequence_no
355: )
356: select
357: ff_routes_s.currval,
358: l_second_context_id,
359: 2
360: from dual;
361: --
360: from dual;
361: --
362: -- Set the route ID to be returned
363: --
364: select ff_routes_s.currval into l_route_id from dual;
365: --
366: END IF;
367: --
368: RETURN l_route_id;