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

ACS3 Data Model

Arguments Source

HP_USER_QUOTA_LEFT

Arguments:

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

Returns:

INTEGER(38.0)

Source

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;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002