NCDS_Procedure/CALCRECORD.sql

DROP PROCEDURE IF EXISTS `CALCRECORD`;
delimiter ;;
CREATE PROCEDURE `CALCRECORD`(IN `PID` INT, IN `PEVENT` VARCHAR ( 255 ), IN `PCPID` INT, IN `PNOW` DATETIME)
BEGIN
	INSERT INTO AR_BS_BONUS_103_CALC_EVENT ( ID, EVENT, CREATION_TIME, CALC_PERIOD_ID )
	VALUES
		( PID, PEVENT, NOW(), PCPID );

END
;;