Hi everybody!

I have a event action that automatic approved purchase requisition line . My problem is when I execute SQL statement in PLSQL it works perfectly but when I tried to execute it on IFS it doesnt work.

The problem is here;

ifsapp.PURCH_REQ_APPROVAL_API.Get_Pos_Code( '&OLD:REQUISITION_NO','1')=ifsapp.COMPANY_PERS_ASSIGN_API.Get_Pos_Code_Employee('#DEFAULT_COMPANY#',employee_code_)

ifsapp.COMPANY_PERS_ASSIGN_API.Get_Pos_Code_Employee('#DEFAULT_COMPANY#',employee_code_) this statement returns null on IFS. But it is not null. I get a result from plsql. What can be the problem? Does anyone have a idea?

ifsapp.PURCH_REQ_APPROVAL_API.Get_Pos_Code( '&OLD:REQUISITION_NO','1') and this statement returns position code with a period ‘.’ but it does not have period.

I find Employee_code_  like that

cursor get_emp is
select a.emp_no from COMPANY_PERSON_ALL a where a.employee_status='*' and a.person_id='&OLD:REQUISITIONER_CODE';
    
BEGIN

open get_emp;
fetch get_emp into employee_code_;
close get_emp;