Pasted as Plain Text
Description: No description
URL: https://lumen.esilibrary.com/p/Qoz3xd59.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql
index e70d5777df..a00c6e41b9 100644
--- a/Open-ILS/src/sql/Pg/040.schema.asset.sql
+++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql
@@ -755,6 +755,8 @@ $f$ LANGUAGE PLPGSQL;
 
 
 CREATE OR REPLACE FUNCTION asset.record_has_holdable_copy ( rid BIGINT, ou INT DEFAULT NULL) RETURNS BOOL AS $f$
+DECLARE
+    v_ou INT := COALESCE(ou,(evergreen.org_top()).id);
 BEGIN
     PERFORM 1
         FROM
@@ -769,7 +771,7 @@ BEGIN
             AND ccs.holdable = true
             AND acp.deleted = false
             AND acpl.deleted = false
-            AND acp.circ_lib IN (SELECT id FROM actor.org_unit_descendants(COALESCE($2,(SELECT id FROM evergreen.org_top()))))
+            AND acp.circ_lib IN (SELECT id FROM actor.org_unit_descendants(v_ou))
         LIMIT 1;
     IF FOUND THEN
         RETURN true;