|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Data Type | Default Value | In/Out |
|---|---|---|---|
| START_DATE | DATE | IN | |
| END_DATE | DATE | IN |
| Source |
|---|
1: function poll_is_active_p (start_date in date,
2: end_date in date)
3: return char
4: as
5: result char;
6: begin
7: result := 't';
8:
9: if (trunc(start_date) > trunc(sysdate)) then
10: result := 'f';
11: end if;
12:
13: if (trunc(end_date) < trunc(sysdate)) then
14: result := 'f';
15: end if;
16:
17: return result;
18:
19: end poll_is_active_p;
20:
|