 			  PART_NAME
 				,DERIVED_FROM_cat_item)
 			VALUES (
-				sq_collection_object_id.currval,
+				#pid.pid#,
 			  '#PART_NAME#'
 				,#collection_object_id#)
 	</cfquery>
-	<cfif len(#coll_object_remarks#) gt 0>
+	<cfif len(coll_object_remarks) gt 0>
 		<!---- new remark --->
 		<cfquery name="newCollRem" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
 			INSERT INTO coll_object_remark (collection_object_id, coll_object_remarks)
-			VALUES (sq_collection_object_id.currval, '#escapeQuotes(coll_object_remarks)#')
-		</cfquery>
+			VALUES (#pid.pid#, '#escapeQuotes(coll_object_remarks)#')
+		</cfquery>
+	</cfif>
+	<cfif len(newPartContainerBarcode) gt 0>
+		<cfstoredproc procedure="movePartToContainer" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
+			<cfprocparam cfsqltype="CF_SQL_FLOAT" value="#pid.pid#"><!---- v_collection_object_id ---->
+			<cfprocparam cfsqltype="cf_sql_varchar" value="#newPartContainerBarcode#"><!---- v_barcode ---->
+			<cfprocparam cfsqltype="cf_sql_varchar" value=""><!---- v_container_id ---->
+			<cfprocparam cfsqltype="cf_sql_varchar" value=""><!---- v_parent_container_type ---->
+		</cfstoredproc>
 	</cfif>
 	</cftransaction>
 	<cflocation url="editParts.cfm?collection_object_id=#collection_object_id#" addtoken="false">

	<cfquery name= "getEntBy" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		SELECT agent_id FROM agent_name WHERE agent_name = '#session.username#'  group by agent_id
	</cfquery>
	<cftransaction>
	<cfquery name="updateColl" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		INSERT INTO coll_object (
			COLLECTION_OBJECT_ID,

			CONDITION,
			FLAGS )
		VALUES (
			#pid.pid#,
			'SP',
			#session.myAgentID#,
			sysdate,
