SQL & PL/SQL

Hello..

Hopefully a quick one for somebody..

Getting following error message..

[052710_034807986][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06550: line 4, column 20:
PLS-00306: wrong number or types of arguments in call to 'BEFOREREPORTTRIGGER'
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored

....when I'm trying to call a trigger in a XSL script that is used to create a XML PUblisher report to run in ORACLE Financials..

Anyway, Procedure header & Spec at fault is..

CREATE OR REPLACE PACKAGE Subixclt IS
FUNCTION BeforeReportTrigger(p_order_by IN VARCHAR2) RETURN VARCHAR2;
ordered  VARCHAR2(50);
raisedby VARCHAR2(50);
status VARCHAR2(50);
claimant VARCHAR2(50);
expense_date_from DATE;
expense_date_to DATE;
END;

CREATE OR REPLACE PACKAGE BODY Subixclt IS
FUNCTION BeforeReportTrigger(p_order_by IN VARCHAR2)RETURN VARCHAR2 IS

BEGIN
DECLARE

ordered  VARCHAR2(50);
raisedby VARCHAR2(50);
status VARCHAR2(50);
claimant VARCHAR2(100);
expense_date_from DATE;
expense_date_to DATE;

BEGIN
 IF (p_order_by='Expense Report Number') THEN
	ordered :='order by 1 asc;';
  ELSIF (p_order_by='Person Claiming') THEN
	ordered :='order by 2 asc;';
  ELSIF (p_order_by='Submit Date') THEN
  ordered :='order by 4 asc;';
  END IF;
 
RETURN(p_order_by);
END;
END;
END;

PLease ask if yous need any further info..

muchos gracias..

Steven