APPS.PAY_ARCHIVE_UTILS dependencies on FF_ROUTE_PARAMETERS

Line 93: insert into ff_route_parameters

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,

Line 102: ff_route_parameters_s.nextval,

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

Line 195: insert into ff_route_parameters

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,

Line 204: ff_route_parameters_s.nextval,

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

Line 313: insert into ff_route_parameters

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,

Line 322: ff_route_parameters_s.nextval,

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

Line 517: from ff_route_parameters

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

Line 722: from ff_route_parameters

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: