CREATE DEFINER = 'cargoport'@'%' 
PROCEDURE `sum_pcp`(
        IN `p_cargo_status` ENUM('export','import','domestic'),
        IN `p_cargo_group_id` INTEGER(11) UNSIGNED,
        IN `p_cargo_zone_id` INTEGER(11) UNSIGNED,
        IN `p_year` INTEGER(11),
        IN `p_month` INTEGER(11),
        IN `p_cooperated` ENUM('coop','all'),
        OUT `p_sum_prr` DECIMAL(11,2),
        OUT `p_sum_other` DECIMAL(11,2),
        OUT `p_sum_teo` DECIMAL(11,2),
        OUT `p_sum_fares` DECIMAL(11,2),
        OUT `p_sum_storage` DECIMAL(11,2),
        OUT `p_sum_total` DECIMAL(11,2)
    )
    NOT DETERMINISTIC
    READS SQL DATA
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
      SELECT p_sum_prr = SUM(pcp.sum_planned_prr),
     	          p_sum_other = SUM(pcp.sum_planned_other),
        	  p_sum_teo = SUM(pcp.sum_planned_teo),
	          p_sum_fares = SUM(pcp.sum_planned_fares),
    	          p_sum_total = SUM(pcp.sum_planned_storage)
	  FROM plan_cargo_processing pcp
	  WHERE pcp.cargo_status = p_cargo_status
	  AND pcp.cargo_group_id = p_cargo_group_id
	  AND pcp.cargo_zone_id = p_cargo_zone_id
	  AND pcp.year = p_year
	  AND pcp.month = p_month;
END;