APPS.BIS_COLLECTION_UTILITIES dependencies on BIS_SYSTEM_DATE

Line 8: SELECT count(1) INTO l_count from BIS_SYSTEM_DATE;

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)

Line 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:

Line 17: UPDATE BIS_SYSTEM_DATE

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;