APPS.PAY_CA_DBI_ROE dependencies on FF_ROUTE_PARAMETERS

Line 215: select route_parameter_id from ff_route_parameters

211: ) return number is
212: begin
213: declare
214: cursor cur_route_parameter_exists is
215: select route_parameter_id from ff_route_parameters
216: where route_id= p_route_id
217: and parameter_name = p_parameter_name;
218:
219: cursor cur_route_parameters is

Line 220: select ff_route_parameters_s.nextval

216: where route_id= p_route_id
217: and parameter_name = p_parameter_name;
218:
219: cursor cur_route_parameters is
220: select ff_route_parameters_s.nextval
221: from dual;
222:
223: l_route_parameter_id ff_route_parameters.route_parameter_id%TYPE;
224: begin

Line 223: l_route_parameter_id ff_route_parameters.route_parameter_id%TYPE;

219: cursor cur_route_parameters is
220: select ff_route_parameters_s.nextval
221: from dual;
222:
223: l_route_parameter_id ff_route_parameters.route_parameter_id%TYPE;
224: begin
225:
226: open cur_route_parameter_exists;
227: fetch cur_route_parameter_exists

Line 245: insert into ff_route_parameters

241: into l_route_parameter_id;
242:
243: close cur_route_parameters;
244:
245: insert into ff_route_parameters
246: (route_parameter_id,
247: route_id,
248: data_type,
249: parameter_name,