APPS.PAY_CA_DBI_ROE dependencies on FF_ROUTES_S

Line 53: cursor cur_ff_routes_s is

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

Line 54: select ff_routes_s.nextval

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

Line 70: open cur_ff_routes_s;

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

Line 71: fetch cur_ff_routes_s

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

Line 73: close cur_ff_routes_s;

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