2479: -- then it will not be inserted or updated.
2480: --------------------------------------------------------------------------
2481: FUNCTION create_retro_definitions
2482: (p_legislation_code in varchar2
2483: ,p_short_name in pay_retro_definitions.short_name%TYPE
2484: ,p_definition_name in pay_retro_definitions.definition_name%TYPE)
2485: RETURN NUMBER
2486: IS
2487: --
2495: AND legislation_code = p_legislation_code;
2496: --
2497: CURSOR csr_get_defn_id
2498: IS
2499: SELECT pay_retro_definitions_s.nextval
2500: FROM dual;
2501: --
2502: BEGIN
2503: --