 <cfif action is "validate">
 <cfoutput>
 <cfquery name="gaid" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
-	update CF_TEMP_ACCN set 
+	update CF_TEMP_ACCN set
 		i$agent_id_1=getAgentID(TRANS_AGENT_1),
 		i$agent_id_2=getAgentID(TRANS_AGENT_2),
 		i$agent_id_3=getAgentID(TRANS_AGENT_3),

<cfsetting requesttimeout="600">
<cfset title="bulkload accession">
<!---

drop table cf_temp_accn;

create table cf_temp_accn (
	i$key number not null,
	guid_prefix varchar2(255) not null,

<cfif action is "loadData">

<cfoutput>



	<cfquery name="getTempData" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		select * from CF_TEMP_ACCN
	</cfquery>
	<cftransaction>
	<cfloop query="getTempData">
		<br>#accn_number#
		<cfquery name="newTrans" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
			INSERT INTO trans (
				TRANSACTION_ID,
