APPS.PAY_CA_DBI_ROE dependencies on FF_ROUTES_S

Line 55: cursor cur_ff_routes_s is

51: cursor cur_route_exists is
52: select route_id from ff_routes
53: where route_name = p_route_name;
54:
55: cursor cur_ff_routes_s is
56: select ff_routes_s.nextval
57: from dual;
58:
59: l_route_id ff_routes.route_id%TYPE;

Line 56: select ff_routes_s.nextval

52: select route_id from ff_routes
53: where route_name = p_route_name;
54:
55: cursor cur_ff_routes_s is
56: select ff_routes_s.nextval
57: from dual;
58:
59: l_route_id ff_routes.route_id%TYPE;
60:

Line 72: open cur_ff_routes_s;

68: if cur_route_exists%notfound then
69:
70: close cur_route_exists;
71:
72: open cur_ff_routes_s;
73: fetch cur_ff_routes_s
74: into l_route_id;
75: close cur_ff_routes_s;
76:

Line 73: fetch cur_ff_routes_s

69:
70: close cur_route_exists;
71:
72: open cur_ff_routes_s;
73: fetch cur_ff_routes_s
74: into l_route_id;
75: close cur_ff_routes_s;
76:
77: insert into ff_routes

Line 75: close cur_ff_routes_s;

71:
72: open cur_ff_routes_s;
73: fetch cur_ff_routes_s
74: into l_route_id;
75: close cur_ff_routes_s;
76:
77: insert into ff_routes
78: (
79: route_id,