|
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 | |
| DIR_REQUIREMENT | INTEGER(38.0) | IN |
| Source |
|---|
1: function hp_user_quota_left_check_admin (userid IN integer, lesser_mortal_quota IN integer, higher_mortal_quota IN integer, dir_requirement IN integer)
2: return integer
3: IS
4: return_value integer;
5: BEGIN
6: select (hp_user_quota_max_check_admin(userid, lesser_mortal_quota, higher_mortal_quota) - hp_user_quota_used(userid, dir_requirement))
7: into return_value
8: from dual;
9:
10: return return_value;
11: END;
|