------**********************************************************************************************************
------Produmex WMS Integration with Netronic Manufacturing INSPECT
------**********************************************************************************************************
----Update Produmex Quality Status based on Inspection Result
--Add Inspection Order Result ID IN PMX_NOTQ
IF error = 0 AND transaction_type in ('A', 'U') AND object_type in ('-3	@BOY_CLOUD_INSP_RESO') THEN
	DECLARE itemCode nvarchar(50);
	DECLARE reso_code NVARCHAR (100);
	DECLARE orderCount int;
	DECLARE dateMarker date;
	DECLARE existingCount int;
	DECLARE userid int;
	DECLARE recordCount int;
	DECLARE internalkey int;
	reso_code := list_of_cols_val_tab_del;

	SELECT CURRENT_DATE INTO dateMarker FROM DUMMY;
	SELECT "U_ItemCode" INTO itemCode FROM "@BOY_CLOUD_INSP_RESO" WHERE "Code" = :reso_code;
	SELECT (COALESCE(MAX(CAST("InternalKey" AS INT)),0) + 1) INTO internalkey FROM PMX_NOTQ;			

	INSERT INTO PMX_NOTQ ("InternalKey","Canceled", "UserSign", "CreateDateTime", "UpdateDateTime", "Version", "SenderType", "Action", "ObjectType", "Key", "Column", "Source", "BlockEffects")
	VALUES (
			:internalkey,
			'N',
			'1',
			:dateMarker,
			:dateMarker,
			'1',
			'InspectToPmx',
			'A',
			'BOY_CLOUD_INSP_RESO',
			:reso_code,
			'ResoCode',
			'S',
			'E'
			);

END IF;