PROCEDURE school_det_sp 
( BEHAVIOUR_ID IN behaviour.behaviour_id%TYPE,
  BEH_TYPE IN behaviour.beh_type%TYPE,
  BE_STU_ID IN behaviour.be_stu_id%TYPE,
  BE_CLASS_ID IN behaviour.be_class_id%TYPE,
  DATE_RECIEVED IN behaviour.date_recieved%TYPE
--b_id IN behaviour.behaviour_id%TYPE,
--   b_type IN behaviour.beh_type%TYPE,
--   s_id IN behaviour.be_stu_id%TYPE,
--   c_id IN behaviour.be_class_id%TYPE,
--   d_id IN behaviour.date_recieved%TYPE
	) 
IS
	lv_beh_total NUMBER (8);
  lv_punish VARCHAR2(40);
BEGIN
  INSERT INTO behaviour (BEHAVIOUR_ID, BEH_TYPE, BE_STU_ID , BE_CLASS_ID, DATE_RECIEVED) 
		VALUES(:BEHAVIOUR_ID,:BEH_TYPE, :BE_STU_ID, :BE_CLASS_ID, :DATE_RECIEVED);
SELECT COUNT(behaviour_id)
   INTO lv_beh_total
   FROM behaviour 
   WHERE be_stu_id =:BE_STU_ID
   AND  be_class_id = :BE_CLASS_ID
   AND  date_recieved =:DATE_RECIEVED;
IF lv_beh_total = 2 THEN
	lv_punish:='Lunch Time Detention';
	DBMS_OUTPUT.PUT_LINE(lv_punish);
INSERT INTO DETENTION_BEHAVIOUR(BEH_BEHAVIOUR_ID, DET_DETENTION_ID, DB_STU_ID, DB_CLASS_ID,DATE_RECIEVED)
		VALUES(:BEHAVIOUR_ID,1,:BE_STU_ID,:BE_CLASS_ID, :DATE_RECIEVED);
ELSIF lv_beh_total = 3 THEN
 	lv_punish:='After School Detention';
	DBMS_OUTPUT.PUT_LINE(lv_punish);
INSERT INTO DETENTION_BEHAVIOUR(BEH_BEHAVIOUR_ID, DET_DETENTION_ID, DB_STU_ID, DB_CLASS_ID,DATE_RECIEVED)
		VALUES(:BEHAVIOUR_ID,2,:BE_STU_ID,:BE_CLASS_ID, :DATE_RECIEVED);
ELSIF lv_beh_total = 5 THEN
 	lv_punish:='Lunch Time Detention';
	DBMS_OUTPUT.PUT_LINE(lv_punish);
INSERT INTO DETENTION_BEHAVIOUR(BEH_BEHAVIOUR_ID, DET_DETENTION_ID, DB_STU_ID, DB_CLASS_ID,DATE_RECIEVED)
		VALUES(:BEHAVIOUR_ID,1,:BE_STU_ID,:BE_CLASS_ID, :DATE_RECIEVED);
ELSIF lv_beh_total = 6 THEN
 	lv_punish:='After School Detention';
	DBMS_OUTPUT.PUT_LINE(lv_punish);
INSERT INTO DETENTION_BEHAVIOUR(BEH_BEHAVIOUR_ID, DET_DETENTION_ID, DB_STU_ID, DB_CLASS_ID,DATE_RECIEVED)
		VALUES(:BEHAVIOUR_ID,2,:BE_STU_ID,:BE_CLASS_ID, :DATE_RECIEVED);
ELSIF lv_beh_total = 8 THEN
 	lv_punish:='Lunch Time Detention';
	DBMS_OUTPUT.PUT_LINE(lv_punish);
INSERT INTO DETENTION_BEHAVIOUR(BEH_BEHAVIOUR_ID, DET_DETENTION_ID, DB_STU_ID, DB_CLASS_ID,DATE_RECIEVED)
		VALUES(:BEHAVIOUR_ID,1,:BE_STU_ID,:BE_CLASS_ID, :DATE_RECIEVED);
ELSIF lv_beh_total = 9 THEN
 	lv_punish:='After School Detention';
	DBMS_OUTPUT.PUT_LINE(lv_punish);
INSERT INTO DETENTION_BEHAVIOUR(BEH_BEHAVIOUR_ID, DET_DETENTION_ID, DB_STU_ID, DB_CLASS_ID,DATE_RECIEVED)
		VALUES(:BEHAVIOUR_ID,2,:BE_STU_ID,:BE_CLASS_ID, :DATE_RECIEVED);
END IF;
END;