|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Data Type | Default Value | In/Out |
|---|---|---|---|
| EXPIRATION_DATE | DATE | IN |
| Source |
|---|
1: function expired_p(expiration_date in date) return varchar
2: is
3: begin
4: IF expiration_date is null THEN
5: return 'f';
6: ELSIF expiration_date >= sysdate THEN
7: return 'f';
8: ELSE
9: return 't';
10: END IF;
11: end;
|