2331: );
2332: -- set error tracking information
2333: hr_utility.set_location('ffdict.create_global_dbitem',4);
2334: --
2335: insert into ff_route_parameters
2336: (route_parameter_id,
2337: route_id,
2338: data_type,
2339: parameter_name,
2339: parameter_name,
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: );
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
2358: --
2359: -- Route exists so select parameter id (should only be one)
2360: select route_parameter_id
2361: into l_route_parameter_id
2362: from ff_route_parameters
2363: where route_id = l_route_id;
2364: end if;
2365: --
2366: -- set error tracking information