APPS.BEN_US_DATABASE_ITEMS_PKG dependencies on FF_ROUTES

Line 84: FROM ff_routes

80: BEGIN
81: --
82: SELECT route_id
83: INTO l_route_id
84: FROM ff_routes
85: WHERE route_name = upper(p_route_name);
86: --
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: --

Line 91: INSERT INTO ff_routes

87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: --
89: -- Create the route, context usages, and parameters
90: --
91: INSERT INTO ff_routes
92: (route_id,
93: route_name,
94: user_defined_flag,
95: description,

Line 103: (ff_routes_s.nextval,

99: last_update_login,
100: created_by,
101: creation_date)
102: VALUES
103: (ff_routes_s.nextval,
104: upper(p_route_name),
105: 'N',
106: p_route_description,
107: p_route_text,

Line 114: SELECT ff_routes_s.currval

110: 0,
111: 0,
112: sysdate);
113: --
114: SELECT ff_routes_s.currval
115: INTO l_route_id
116: FROM dual;
117: --
118: -- Insert any context usages