APPS.PAY_CA_DBI_ROE dependencies on FF_ROUTE_PARAMETERS

Line 213: select route_parameter_id from ff_route_parameters

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

Line 218: select ff_route_parameters_s.nextval

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

Line 221: l_route_parameter_id ff_route_parameters.route_parameter_id%TYPE;

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

Line 243: insert into ff_route_parameters

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