declare
	blk_name varchar2(60);
	form_name varchar2(60);
	str_base_table varchar2(60);
	bt number;
	alert number;
begin
	
	
	
	insert into AUTH_SLIP_RET(ALT_ID,AU_SLIP,EDT,DOR_SLIP,USERNAME,REASON,DEBAR,RECONSIDER,REG_WAIT,VR_CF,OCC_STATUS)
	 	values(:AUTH_SLIP_RET.ALT_ID,:AUTH_SLIP_RET.AU_SLIP,:AUTH_SLIP_RET.EDT,:AUTH_SLIP_RET.DOR_SLIP,
	 				:AUTH_SLIP_RET.USERNAME,:AUTH_SLIP_RET.REASON,:AUTH_SLIP_RET.DEBAR,:AUTH_SLIP_RET.RECONSIDER,
	 				:AUTH_SLIP_RET.REG_WAIT,:AUTH_SLIP_RET.VR_CF,:AUTH_SLIP_RET.OCC_STATUS);
	 			

			VACATION_PKG.RET_AUTH_SLIP(:alt_trans.alt_id);
			
		
  
  	IF SQL%FOUND THEN
  			standard.commit;
  
		
						set_alert_property('alert57',title,'success');
						set_alert_property('alert57',alert_message_text,'Authority slip return successfully');
						alert:= show_alert('alert57');
						
						clear_form(NO_VALIDATE);
			ELSE
		
						set_alert_property('alert57',title,'success');
						set_alert_property('alert57',alert_message_text,'Authority slip return un-successfull');
						alert:= show_alert('alert57');
						clear_form(NO_VALIDATE);
					--	EXIT_FORM(no_commit);
			END IF;
	
end;