pears.MasterRosterCopyShift

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
}