| | | | | | | |
|
|
DROP PROCEDURE IF EXISTS `sAddEmailNotification`
sAddEmailNotification
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sAddPayment`
sAddPayment
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sAddRefundPayment`
sAddRefundPayment
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sAddRegistration`
sAddRegistration
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sAddSchedule`
sAddSchedule
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sAddSettingValue`
sAddSettingValue
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sAuthenticateUser`
sAuthenticateUser
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sCheckParticipantExists`
sCheckParticipantExists
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sConfirmParticipant`
sConfirmParticipant
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sEncryptPassword`
sEncryptPassword
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetAvailableProgramSchedules`
sGetAvailableProgramSchedules
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetConfirmedRegistrationsPendingPayment`
sGetConfirmedRegistrationsPendingPayment
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetEmail`
sGetEmail
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetKPIChartDetails`
sGetKPIChartDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetKPIPaymentDetails`
sGetKPIPaymentDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetKPIRegistrationDetails`
sGetKPIRegistrationDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetLastReceiptNumber`
sGetLastReceiptNumber
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetParticipantDetails`
sGetParticipantDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetParticipantRegistrationDetails`
sGetParticipantRegistrationDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetPaymentOption`
sGetPaymentOption
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetPaymentType`
sGetPaymentType
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetProgramSchedule`
sGetProgramSchedule
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetProgramScheduleDetails`
sGetProgramScheduleDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetScheduleParticipantDetail`
sGetScheduleParticipantDetail
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetSettingValue`
sGetSettingValue
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetStatebyStateId`
sGetStatebyStateId
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetViewPaymentDetails`
sGetViewPaymentDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetViewScheduleDetails`
sGetViewScheduleDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sGetZipcodebyCityId`
sGetZipcodebyCityId
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateParticipantDetails`
sUpdateParticipantDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateProgramScheduleStatusToCompleted`
sUpdateProgramScheduleStatusToCompleted
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateReceiptNumber`
sUpdateReceiptNumber
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateScheduleDetails`
sUpdateScheduleDetails
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateScheduleForParticipant`
sUpdateScheduleForParticipant
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateScheduleStatus`
sUpdateScheduleStatus
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateSettingValue`
sUpdateSettingValue
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sUpdateTransaction`
sUpdateTransaction
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sValidateAddress`
sValidateAddress
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|
|
|
DROP PROCEDURE IF EXISTS `sValidateZipCode`
sValidateZipCode
|
PROCEDURE
|
|
Edit
|
Execute
|
Export
|
Drop
|