pears.MasterRosterCopyShift [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.MasterRosterCopyShift ======
<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>
create procedure "pears"."MasterRosterCopyShift"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "pSourceShiftID" char(20),in "pTargetShiftID" char(20),in "pTargetRosterID" char(20),
  in "pNextDate" date,in "pTimeFrom" time,in "pTimeTo" time,in "pFinalDate" date,in "pChangeLogID" char(20) ) 
begin
  insert into "MasterRosterShift"( "MasterRosterShiftID","MasterRosterID","Description","NextDate","FinalDate","EssentialSkill","EssentialSkillGradeID","EssentialSkillChoiceList",
    "TimeFrom","TimeTo","Moveable","Minutes","BreakMinutes","ReferenceRequired","ClientMustConfirm","TempMustConfirm","TempShiftTypeID","AnalysisCode","RecoveryHours",
    "TempShiftTemplateID","ClientNote","MasterRosterChangeLogID" ) 
    select "pTargetShiftID","pTargetRosterID","Description","pNextDate","pFinalDate","EssentialSkill","EssentialSkillGradeID","EssentialSkillChoiceList",
      "pTimeFrom","pTimeTo","Moveable","Minutes","BreakMinutes","ReferenceRequired","ClientMustConfirm","TempMustConfirm","TempShiftTypeID","AnalysisCode","RecoveryHours",
      "TempShiftTemplateID","ClientNote","pChangeLogID" from "MasterRosterShift" where "MasterRosterShiftID" = "pSourceShiftID"
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."MasterRosterCopyShift" IS 
{create procedure MasterRosterCopyShift 

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

( in pSourceShiftID char(20),in pTargetShiftID char(20),in pTargetRosterID char(20),
  in pNextDate date,in pTimeFrom time,in pTimeTo time,in pFinalDate date,in pChangeLogID char(20) ) 
begin
  insert into MasterRosterShift( MasterRosterShiftID,MasterRosterID,Description,NextDate,FinalDate,EssentialSkill,EssentialSkillGradeID,EssentialSkillChoiceList,
    TimeFrom,TimeTo,Moveable,Minutes,BreakMinutes,ReferenceRequired,ClientMustConfirm,TempMustConfirm,TempShiftTypeID,AnalysisCode,RecoveryHours,
    TempShiftTemplateID,ClientNote,MasterRosterChangeLogID ) 
    select pTargetShiftID,pTargetRosterID,Description,pNextDate,pFinalDate,EssentialSkill,EssentialSkillGradeID,EssentialSkillChoiceList,
      pTimeFrom,pTimeTo,Moveable,Minutes,BreakMinutes,ReferenceRequired,ClientMustConfirm,TempMustConfirm,TempShiftTypeID,AnalysisCode,RecoveryHours,
      TempShiftTemplateID,ClientNote,pChangeLogID from MasterRosterShift where MasterRosterShiftID = pSourceShiftID
end
}
</code>