-- B1 DEPENDS: BEFORE:PT:PROCESS_START

CREATE procedure _TmSp_AfterUpdateAppObjLineOINM
LANGUAGE SQLSCRIPT 
SQL SECURITY INVOKER

AS
obj int;
BEGIN

	SELECT count(*) into obj FROM "PUBLIC".objects 
	WHERE object_name = 'TMPIGNOREDUPITEMCODEIGN1'  and schema_name = CURRENT_SCHEMA;

	if :obj <> 0 then
		DROP TABLE tmpIgnoreDupItemCodeIGN1;
	end if;

	SELECT count(*) into obj FROM "PUBLIC".objects 
	WHERE object_name = 'TMPIGNOREDUPITEMCODEIGE1'  and schema_name = CURRENT_SCHEMA;

	if :obj <> 0 then
		DROP TABLE tmpIgnoreDupItemCodeIGE1;
	end if;

	SELECT count(*) into obj
	FROM "PUBLIC".objects 
	WHERE object_name = 'TMPIGNOREDUPFIFOBACKFLUSHITEMCODE'  and schema_name = CURRENT_SCHEMA;

	if :obj <> 0 then
		DROP TABLE tmpIgnoreDupFIFOBackFlushItemCode;
	end if;

END;
