APPS.FFDICT dependencies on FF_ROUTES

Line 2299: from ff_routes

2295: -- Get route id for globals route. If not exists, create new one.
2296: begin
2297: select route_id
2298: into l_route_id
2299: from ff_routes
2300: where route_name = 'FF_GLOBALS';
2301: exception
2302: when no_data_found then
2303: l_route_id := null;

Line 2310: insert into ff_routes

2306: if l_route_id is null then
2307: -- set error tracking information
2308: hr_utility.set_location('ffdict.create_global_dbitem',3);
2309: --
2310: insert into ff_routes
2311: (route_id,
2312: route_name,
2313: user_defined_flag,
2314: description,

Line 2321: ff_routes_s.nextval,

2317: creation_date
2318: )
2319: values
2320: (
2321: ff_routes_s.nextval,
2322: 'FF_GLOBALS',
2323: 'N',
2324: 'Route for globals',
2325: 'ff_globals where global_id = &U1',

Line 2341: ff_routes_s.currval,

2337: sequence_no
2338: )
2339: values
2340: (ff_route_parameters_s.nextval,
2341: ff_routes_s.currval,
2342: 'T',
2343: 'GLOBAL_ID',
2344: 1
2345: );

Line 2349: select ff_routes_s.currval, ff_route_parameters_s.currval

2345: );
2346: -- set error tracking information
2347: hr_utility.set_location('ffdict.create_global_dbitem',5);
2348: --
2349: select ff_routes_s.currval, ff_route_parameters_s.currval
2350: into l_route_id, l_route_parameter_id
2351: from sys.dual;
2352: else
2353: -- set error tracking information