4: PROCEDURE UPDATE_DATE IS
5: l_count number;
6: BEGIN
7:
8: SELECT count(1) INTO l_count from BIS_SYSTEM_DATE;
9:
10: IF (l_count = 0) THEN /* INSERT DATE */
11:
12: INSERT INTO BIS_SYSTEM_DATE(current_date_id)
8: SELECT count(1) INTO l_count from BIS_SYSTEM_DATE;
9:
10: IF (l_count = 0) THEN /* INSERT DATE */
11:
12: INSERT INTO BIS_SYSTEM_DATE(current_date_id)
13: values (trunc(sysdate));
14:
15: ELSIF (l_count = 1) THEN /* Exists, update if needed */
16:
13: values (trunc(sysdate));
14:
15: ELSIF (l_count = 1) THEN /* Exists, update if needed */
16:
17: UPDATE BIS_SYSTEM_DATE
18: set current_date_id = trunc(sysdate)
19: WHERE trunc(sysdate) <> trunc(current_date_id);
20:
21: END IF;