5: -- Service functions to return TRUE if the value passed has been changed.
6: --
7: FUNCTION val_changed(p_value IN NUMBER) RETURN BOOLEAN IS
8: BEGIN
9: RETURN (p_value IS NULL OR p_value <> hr_api.g_number);
10: END val_changed;
11: --
12: FUNCTION val_changed(p_value IN VARCHAR2) RETURN BOOLEAN IS
13: BEGIN
10: END val_changed;
11: --
12: FUNCTION val_changed(p_value IN VARCHAR2) RETURN BOOLEAN IS
13: BEGIN
14: RETURN (p_value IS NULL OR p_value <> hr_api.g_varchar2);
15: END val_changed;
16: --
17: FUNCTION val_changed(p_value IN DATE) RETURN BOOLEAN IS
18: BEGIN
15: END val_changed;
16: --
17: FUNCTION val_changed(p_value IN DATE) RETURN BOOLEAN IS
18: BEGIN
19: RETURN (p_value IS NULL OR p_value <> hr_api.g_date);
20: END val_changed;
21: --
22: --
23: -- Contract type: