<cfabort>
<cfif isdefined('url.invoice_id') AND url.invoice_id NEQ 0>

	<cfquery name='getschedules' datasource='#Application.DataSrc#'>
        SELECT * FROM  #Request.prefix_db_agency#.pSchedules 
    	WHERE Invoice_ID = '#url.invoice_id#'
        AND Status = 0
    </cfquery>
    <cfloop query="getschedules">
		<cfscript>
	   		 pgcfc = CreateObject("Component", "components.general.progressnotes");
	   		 retiredschedules = pgcfc.retire_schedules(#getschedules.Schedule_ID#); 
	    </cfscript>
	</cfloop>
	<cfset schedule_ids = ValueList(getschedules.Schedule_ID) />
	<cfquery name='delete_schedules' datasource='#Application.DataSrc#'>
        UPDATE #Request.prefix_db_agency#.pSchedules 
    	SET  
    		EClaimed = 0,
       		Invoice_ID = 0,
       	 	Date_Change = <cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp">,
        	Change_by    = <cfqueryparam value = "#session.employeeid#" CFSQLType ="CF_SQL_INTEGER"> 
    	    WHERE Schedule_ID  IN (#schedule_ids#)
    		AND Invoice_ID = '#url.invoice_id#'
        	AND Status = 0
    </cfquery>

    <cfquery name='delete_invoices' datasource='#Application.DataSrc#'>
        UPDATE #Request.prefix_db_agency#.Invoices 
    	SET  
    		voided_claim = 1, 
        	Record_Modified_Date = <cfqueryparam value="#now()#" cfsqltype="cf_sql_timestamp">,
        	Record_Modified_By    = <cfqueryparam value = "#session.employeeid#" CFSQLType ="CF_SQL_INTEGER"> 
    	WHERE  Invoice_ID = '#url.invoice_id#'
    </cfquery>







<cfelse>
	<h2>We cannot process your request. So please contact your administrator.</h2>
</cfif>