APPS.FFDICT dependencies on FF_ROUTES

Line 2302: from ff_routes

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

Line 2313: insert into ff_routes

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

Line 2324: ff_routes_s.nextval,

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

Line 2344: ff_routes_s.currval,

2340: sequence_no
2341: )
2342: values
2343: (ff_route_parameters_s.nextval,
2344: ff_routes_s.currval,
2345: 'T',
2346: 'GLOBAL_ID',
2347: 1
2348: );

Line 2352: select ff_routes_s.currval, ff_route_parameters_s.currval

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