====== pears.SoftWizardController ======
<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"."SoftWizardController" IS 
{create function SoftWizardController( 
  in "pWizardID" char(20),in "pPageID" char(50),in "pItem" char(20) ) 
returns char(250)
deterministic
begin
  declare "rv" char(250);
  case "pWizardID"
  when 'DEFAULT' then
    case "pItem"
    when 'nextPageID' then
      case "pPageID"
      when null then
        set "rv" = 'pageText_registration_tos'
      when 'pageText_registration_tos' then
        set "rv" = 'EmailCheck'
      when 'EmailCheck' then
        set "rv" = 'Details'
      when 'Details' then
        set "rv" = ':Division'
      when 'Division' then
        set "rv" = ':Department'
      when 'Department' then
        set "rv" = ':Terms'
      when 'Terms' then
        set "rv"=':BANKDETAILS'
      when 'BANKDETAILS' then
        set "rv" = 'Quest_P'
      when 'Quest_P' then
        set "rv" = ':Quest_A$'
      when 'Quest_A$' then
        set "rv" = ':VIDEO'
      when 'VIDEO' then
        set "rv" = ':REFERENCES'
      when 'REFERENCES' then
        set "rv" = ':CVANDPHOTO'
      when 'CVANDPHOTO' then
        set "rv" = ':DOCUMENTS'
      when 'DOCUMENTS' then
        set "rv" = ':pageText_registration_complete:'
      end case
    when 'pageCaption' then
      case "pPageID"
      when 'pageText_registration_tos' then
        set "rv" = 'Please read carefully...'
      when 'EmailCheck' then
        set "rv" = 'Email check...'
      when 'Details' then
        set "rv" = 'Please enter your details...'
      when 'Quest_A$' then
        set "rv" = 'Please supply the following information'
      when 'Quest_P' then
        set "rv" = 'Please supply the following information'
      end case
    when 'pageFooter' then
      case "pPageID"
      when 'pageText_registration_tos' then
        set "rv" = '!I accept the terms and conditions'
      end case
    when 'pageNumber' then
      case "pPageID"
      when 'pageText_registration_tos' then
        set "rv" = 0 /* Don't display progress yet */
      when 'EmailCheck' then
        set "rv" = 1
      when 'Details' then
        set "rv" = 2
      when 'Division' then
        set "rv" = 3
      when 'Department' then
        set "rv" = 4
      when 'Terms' then
        set "rv" = 5
      when 'BANKDETAILS' then
        set "rv" = 6
      when 'Quest_P' then
        set "rv" = 7
      when 'Quest_A$' then
        set "rv" = 8
      when 'VIDEO' then
        set "rv" = 9
      when 'REFERENCES' then
        set "rv" = 10
      when 'CVandPHOTO' then
        set "rv" = 11
      when 'DOCUMENTS' then
        set "rv" = 12
      when 'pageText_registration_complete' then
        set "rv" = 13
      end case
    when 'totalPageCount' then
      set "rv" = 13
    end case
  end case;
  return "rv"
end
}
</code>