[Home] [Help]
43: l_exists varchar2(1);
44: l_route_id number;
45: --
46: cursor check_exists is
47: select route_id from ff_routes
48: where route_name = 'ARCHIVE_NUMBER_ROUTE';
49: --
50: BEGIN
51: --
61: l_text := 'ff_archive_items target
62: where target.user_entity_id = &U1
63: and target.context1 = &B1 /* context assignment action id */';
64: --
65: insert into ff_routes
66: (
67: route_id,
68: route_name,
69: user_defined_flag,
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;
145: l_exists varchar2(1);
146: l_route_id number;
147: --
148: cursor check_exists is
149: select route_id from ff_routes
150: where route_name = 'ARCHIVE_CHAR_ROUTE';
151: --
152: BEGIN
153: --
163: l_text := 'ff_archive_items target
164: where target.user_entity_id = &U1
165: and target.context1 = &B1 /* context assignment action id */';
166: --
167: insert into ff_routes
168: (
169: route_id,
170: route_name,
171: user_defined_flag,
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;
254: l_route_id number;
255: l_new_route_name varchar2(80);
256: --
257: cursor check_exists(c_route_name varchar2) is
258: select route_id from ff_routes
259: where route_name = c_route_name;
260: --
261: BEGIN
262: --
281: and fac.archive_item_id = target.archive_item_id
282: and ffc.context_id = fac.context_id
283: and fac.context = decode(ffc.data_type,''T'',&B2,to_char(&B2)) /*2nd context*/';
284: --
285: insert into ff_routes
286: (
287: route_id,
288: route_name,
289: user_defined_flag,
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;
502: BEGIN
503: --
504: select route_id
505: into l_route_id
506: from ff_routes where
507: route_name = p_archive_route_name;
508: --
509: END;
510: --
708: p_notfound_allowed_flag VARCHAR2 DEFAULT 'Y') IS
709: --
710: cursor get_valid_route (c_route_id number) is
711: select route_id
712: from ff_routes
713: where route_id = c_route_id;
714: --
715: cursor get_user_entity_id (c_user_entity_name varchar2) is
716: select user_entity_id