APPS.FFDICT dependencies on FF_ROUTE_PARAMETERS

Line 2332: insert into ff_route_parameters

2328: );
2329: -- set error tracking information
2330: hr_utility.set_location('ffdict.create_global_dbitem',4);
2331: --
2332: insert into ff_route_parameters
2333: (route_parameter_id,
2334: route_id,
2335: data_type,
2336: parameter_name,

Line 2340: (ff_route_parameters_s.nextval,

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

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

Line 2359: from ff_route_parameters

2355: --
2356: -- Route exists so select parameter id (should only be one)
2357: select route_parameter_id
2358: into l_route_parameter_id
2359: from ff_route_parameters
2360: where route_id = l_route_id;
2361: end if;
2362: --
2363: -- set error tracking information