Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

HP_USER_QUOTA_LEFT_CHECK_ADMIN

Arguments:

NameData TypeDefault ValueIn/Out
USERIDINTEGER(38.0) IN
LESSER_MORTAL_QUOTAINTEGER(38.0) IN
HIGHER_MORTAL_QUOTAINTEGER(38.0) IN
DIR_REQUIREMENTINTEGER(38.0) IN

Returns:

INTEGER(38.0)

Source

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;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002