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

ACS3 Data Model

Arguments Source

POLL_IS_ACTIVE_P

Arguments:

NameData TypeDefault ValueIn/Out
START_DATEDATE IN
END_DATEDATE IN

Returns:

CHAR

Source

Source
     1: function poll_is_active_p (start_date in date,
     2: 					     end_date in date)
     3: return char
     4: as
     5:     result char;
     6: begin
     7:     result := 't';
     8: 
     9:     if (trunc(start_date) > trunc(sysdate)) then
    10:         result := 'f';
    11:     end if;
    12: 
    13:     if (trunc(end_date) < trunc(sysdate)) then
    14:         result := 'f';
    15:     end if;
    16: 
    17:     return result;
    18: 
    19: end poll_is_active_p;
    20: 


Generated by OraSchemaDoc, (c) Aram Kananov, 2002