APPS.PAY_CA_DATABASE_ITEMS_PKG dependencies on FF_ROUTE_PARAMETERS

Line 222: INSERT INTO ff_route_parameters

218: -- Insert any route parameters
219: --
220: IF p_param_name1 is not null THEN
221: --
222: INSERT INTO ff_route_parameters
223: (route_parameter_id,
224: route_id,
225: sequence_no,
226: parameter_name,

Line 229: (ff_route_parameters_s.nextval,

225: sequence_no,
226: parameter_name,
227: data_type)
228: VALUES
229: (ff_route_parameters_s.nextval,
230: l_route_id,
231: 1,
232: p_param_name1,
233: p_param_type1);

Line 242: INSERT INTO ff_route_parameters

238: END IF;
239: --
240: IF p_param_name2 is not null THEN
241: --
242: INSERT INTO ff_route_parameters
243: (route_parameter_id,
244: route_id,
245: sequence_no,
246: parameter_name,

Line 249: (ff_route_parameters_s.nextval,

245: sequence_no,
246: parameter_name,
247: data_type)
248: VALUES
249: (ff_route_parameters_s.nextval,
250: l_route_id,
251: 1,
252: p_param_name2,
253: p_param_type2);

Line 321: FROM ff_route_parameters

317: value)
318: SELECT route_parameter_id,
319: l_user_entity_id,
320: p_param_value1
321: FROM ff_route_parameters
322: where route_id = l_route_id
323: and sequence_no = 1;
324: --
325: END IF;

Line 336: FROM ff_route_parameters

332: value)
333: SELECT route_parameter_id,
334: l_user_entity_id,
335: p_param_value2
336: FROM ff_route_parameters
337: where route_id = l_route_id
338: and sequence_no = 2;
339: --
340: END IF;