Issue #24592 - add bomhead record in bomitem trigger if one does not exist

diff --git a/foundation-database/public/trigger_functions/bomitem.sql b/foundation-database/public/trigger_functions/bomitem.sql
index bd4baf9..3ee829c 100644 (file)
--- a/foundation-database/public/trigger_functions/bomitem.sql
+++ b/foundation-database/public/trigger_functions/bomitem.sql
@@ -9,6 +9,7 @@ DECLARE
   _bomworkid INTEGER;
   _seqNumber INTEGER;
   _parentItem RECORD;
+  _bomheadid INTEGER;
 BEGIN
 
   -- Privilege Checks