APPS.PAY_MX_ARCHIVE_DBI_PKG dependencies on FF_ROUTE_PARAMETER_VALUES

Line 266: FROM ff_route_parameter_values

262: BEGIN
263:
264: SELECT route_parameter_id
265: INTO l_dummy_id
266: FROM ff_route_parameter_values
267: WHERE route_parameter_id = l_route_parameter_id
268: AND user_entity_id = l_user_entity_seq;
269:
270: UPDATE ff_route_parameter_values

Line 270: UPDATE ff_route_parameter_values

266: FROM ff_route_parameter_values
267: WHERE route_parameter_id = l_route_parameter_id
268: AND user_entity_id = l_user_entity_seq;
269:
270: UPDATE ff_route_parameter_values
271: SET value = l_user_entity_seq
272: WHERE route_parameter_id = l_route_parameter_id
273: AND user_entity_id = l_user_entity_seq;
274:

Line 277: INSERT INTO ff_route_parameter_values

273: AND user_entity_id = l_user_entity_seq;
274:
275: EXCEPTION WHEN NO_DATA_FOUND THEN
276:
277: INSERT INTO ff_route_parameter_values
278: (
279: route_parameter_id,
280: user_entity_id,
281: value,

Line 354: INSERT INTO ff_route_parameter_values

350: 0, -- created_by
351: SYSDATE -- creation_date
352: );
353:
354: INSERT INTO ff_route_parameter_values
355: (
356: route_parameter_id,
357: user_entity_id,
358: value,