pears.PersonUnavailabilityTimesheet [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.PersonUnavailabilityTimesheet ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."PersonUnavailabilityTimesheet" IS 
{create function PersonUnavailabilityTimesheet 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in pid char(20),in WorM char(1),in pPeriod integer,in dfrom date,in dto date)
returns char(200)
begin
  declare ua char(100);
  select personunavailability(pid,'T',dfrom,dto) into ua;
  if ua = '' then
    if exists(select tempprovtimesheetid from tempprovtimesheet where personid = pid and periodlength = worm and period = pperiod) then
      set ua='Provisional Timesheets Entered'
    end if
  end if;
  return(ua)
end
}
</code>