4: --
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 RETURN (NVL(p_value, 1) <> hr_api.g_number); END val_changed;
9: --
10: FUNCTION val_changed(p_value IN VARCHAR2) RETURN BOOLEAN IS
11: BEGIN RETURN (NVL(p_value, 'a') <> hr_api.g_varchar2); END val_changed;
12: --
7: FUNCTION val_changed(p_value IN NUMBER) RETURN BOOLEAN IS
8: BEGIN RETURN (NVL(p_value, 1) <> hr_api.g_number); END val_changed;
9: --
10: FUNCTION val_changed(p_value IN VARCHAR2) RETURN BOOLEAN IS
11: BEGIN RETURN (NVL(p_value, 'a') <> hr_api.g_varchar2); END val_changed;
12: --
13: FUNCTION val_changed(p_value IN DATE) RETURN BOOLEAN IS
14: BEGIN RETURN (NVL(p_value, sysdate) <> hr_api.g_date); END val_changed;
15: --
10: FUNCTION val_changed(p_value IN VARCHAR2) RETURN BOOLEAN IS
11: BEGIN RETURN (NVL(p_value, 'a') <> hr_api.g_varchar2); END val_changed;
12: --
13: FUNCTION val_changed(p_value IN DATE) RETURN BOOLEAN IS
14: BEGIN RETURN (NVL(p_value, sysdate) <> hr_api.g_date); END val_changed;
15: --
16: --
17: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
18: -- Assignment checks.