|
ACS3 Data Model |
||||||||||||
| |||||||||||||
| Name | Data Type | Default Value | In/Out |
|---|---|---|---|
| USERID | INTEGER(38.0) | IN | |
| LESSER_MORTAL_QUOTA | INTEGER(38.0) | IN | |
| HIGHER_MORTAL_QUOTA | INTEGER(38.0) | IN | |
| HIGHER_MORTAL_P | INTEGER(38.0) | IN | |
| DIR_REQUIREMENT | INTEGER(38.0) | IN |
| Source |
|---|
1: function hp_user_quota_left (userid IN integer, lesser_mortal_quota IN integer, higher_mortal_quota IN integer, higher_mortal_p IN integer, dir_requirement IN integer)
2: return integer
3: IS
4: return_value integer;
5: BEGIN
6: select (hp_user_quota_max(userid, lesser_mortal_quota, higher_mortal_quota, higher_mortal_p) - hp_user_quota_used(userid, dir_requirement))
7: into return_value
8: from dual;
9:
10: return return_value;
11: END;
|