APPS.PAY_ARCHIVE_UTILS dependencies on DUAL

Line 107: from dual;

103: ff_routes_s.currval,
104: 'N',
105: 'User Entity ID',
106: 1
107: from dual;
108: --
109: -- Define the route context usage after retrieving the context id.
110: --
111: l_assignment_action_context_id := get_context_id('ASSIGNMENT_ACTION_ID');

Line 123: from dual;

119: select
120: ff_routes_s.currval,
121: l_assignment_action_context_id,
122: 1
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;

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 209: from dual;

205: ff_routes_s.currval,
206: 'N',
207: 'User Entity ID',
208: 1
209: from dual;
210: --
211: -- Define the route context usage.
212: -- Get the context_id for the assignment_action context
213: --

Line 226: from dual;

222: select
223: ff_routes_s.currval,
224: l_assignment_action_context_id,
225: 1
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;

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 327: from dual;

323: ff_routes_s.currval,
324: 'N',
325: 'User Entity ID',
326: 1
327: from dual;
328: --
329: -- Define the first route context usage , based on the
330: -- Assignment_action_id
331: --

Line 344: from dual;

340: select
341: ff_routes_s.currval,
342: l_assignment_action_context_id,
343: 1
344: from dual;
345: --
346: -- Define second route context usage, based on the parameter.
347: --
348: l_second_context_id := get_context_id(p_second_context_name);

Line 360: from dual;

356: select
357: ff_routes_s.currval,
358: l_second_context_id,
359: 2
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;

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;

Line 599: select ff_user_entities_s.nextval into l_user_entity_seq from dual;

595: --
596: -- Archive DBI does not exist, so create the User Entity,
597: -- Route Parameter, and DBI.
598: --
599: select ff_user_entities_s.nextval into l_user_entity_seq from dual;
600:
601: insert into ff_user_entities
602: (
603: user_entity_id,

Line 773: select ff_user_entities_s.nextval into l_user_entity_id from dual;

769: -- Create a new User Entity and DBI, and Route Parameter Value.
770: --
771: BEGIN
772: --
773: select ff_user_entities_s.nextval into l_user_entity_id from dual;
774: --
775: insert into ff_user_entities
776: (
777: user_entity_id,