Oracle Forms

hi

i have made a client side procedure with one IN PARAMETER having datatype number. i call this procedure through a button in which i declare a CURSOR
(all_emp)...so in the BEGIN SECTION i make a loop as (FOR e IN all_emp LOOP) and then call the client side procedure as CALC_EMP_PR_ALW_DED(e.emp_id); but here the error show that is statment ignored....

so plz help me that where i am wrong.... here is the trigger code


working in forms 6i...
IF SHOW_LOV('LOV_EMP') THEN
NULL;
END IF;

DECLARE

CURSOR all_emp IS
SELECT DISTINCT e.emp_id
FROM alw_ded ad,emp_alw_ded ead,emp e
WHERE NVL(ead.status,'A') = 'A'
AND NVL(e.stat,'A') = 'A'
AND ead.ad_id = ad.ad_id
AND e.emp_id = ead.emp_id
AND ead.emp_id = :CON_BLK.emp_id;

BEGIN



FOR e IN all_emp LOOP



CALC_EMP_PR_ALW_DED(e.emp_id);




END LOOP;



END;





thankx in advance