[Home] [Help]
14: create_dbi_startup is called from the main start up file.
15: --
16: MODIFIED (DD-MON-YYYY)
17: alogue 16-MAR-1999 - Removed GET_HOURS_WORKED.
18: alogue 11-JAN-1999 - Added GET_HOURS_WORKED to ff_functions.
19: R11.5 change whereby date contexts are passed
20: into routes as dates (and thus don't require
21: a to_date() on them).
22: alogue 20-MAY-1998 - Fix to ABSENCE_SUM_OF_ELEMENT_ENTRY_VALUES route
2270: -- The following function is used to call the PL/SQL function from
2271: -- formula to retrieve data from the User Defined Tables.
2272: --
2273: hr_utility.set_location ('pay_dbi_startup_pkg.create_dbi_startup', 100);
2274: select ff_functions_s.nextval
2275: into l_function_id
2276: from dual;
2277: --
2278: hr_utility.set_location ('pay_dbi_startup_pkg.create_dbi_startup', 101);
2280: -- insert the main formula:
2281: -- note: perform a normal insert (rather than using a select) to avoid
2282: -- oracle error ora-4091.
2283: --
2284: insert into ff_functions
2285: (function_id,
2286: business_group_id,
2287: legislation_code,
2288: class,