Running Apex_approval.create_task through procedure
Hello,
I am using Apex to design an application where I need to create Human approval task through a stored procedure.
I noticed, I am able to use the apex_approval.create_task directly through Apex forms but when I try to run this via stored procedure it gives me error:
Error at line 5/38: ORA-20987: APEX - Task definition not found ORA-06512: at "APEX_240200.WWV_FLOW_ERROR", line 1150 ORA-06512: at "APEX_240200.WWV_FLOW_ERROR", line 1608 ORA-06512: at "APEX_240200.WWV_FLOW_APPROVAL", line 3957 ORA-06512: at "APEX_240200.WWV_FLOW_APPROVAL_API", line 66 ORA-06512: at line 8 3. p_company_id varchar2(100); 4. p_user_id varchar2(100); 5. l_task_id number; 6. begin 7. --EXECUTE_SCHEDULE_PROCESS(10301);