APPS.PAY_ARCHIVE_UTILS dependencies on FF_ROUTES_S

Line 80: ff_routes_s.nextval,

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,

Line 103: ff_routes_s.currval,

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;

Line 120: ff_routes_s.currval,

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: --

Line 127: select ff_routes_s.currval into l_route_id from dual;

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;

Line 182: ff_routes_s.nextval,

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,

Line 205: ff_routes_s.currval,

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;

Line 223: ff_routes_s.currval,

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: --

Line 230: select ff_routes_s.currval into l_route_id from dual;

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;

Line 300: ff_routes_s.nextval,

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,

Line 323: ff_routes_s.currval,

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;

Line 341: ff_routes_s.currval,

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: --

Line 357: ff_routes_s.currval,

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: --

Line 364: select ff_routes_s.currval into l_route_id from dual;

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;