|
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; |