pgsql/investigations/ar-arapply.sql

diff --git a/pgsql/investigations/ar-arapply.sql b/pgsql/investigations/ar-arapply.sql
index a0249bd..2e6ca39 100644 (file)
--- a/pgsql/investigations/ar-arapply.sql
+++ b/pgsql/investigations/ar-arapply.sql
@@ -4,7 +4,7 @@
 
 
 
-CREATE OR REPLACE FUNCTION x_ar_verify_arapply(i_aropen_id integer)
+CREATE OR REPLACE FUNCTION x_ar_verify_arapply(i_arapply_id integer)
     RETURNS  TEXT
 AS $BODY$
 DECLARE    
@@ -41,15 +41,15 @@ DECLARE
     
 BEGIN
    
-    SELECT * INTO _ar FROM aropen where aropen_id = i_aropen_id;
+    SELECT * INTO _ar FROM arapply where arapply_id = i_arapply_id;
     
     
     IF NOT FOUND THEN
-        RAISE EXCEPTION 'not a valid open id..';
+        RAISE EXCEPTION 'not a valid apply id..';
     END IF;
     
     IF _ar.aropen_journalnumber IS NULL THEN
-        RAISE EXCEPTION 'not a valid open id..';
+        RAISE EXCEPTION 'not a valid apply id..';
     END IF;
 
     SELECT