Calling Multiple stored procedures sequentially in a single Data model

Hi Team,

We have a requirement to create a script to call multiple stored procedures in Oracle DB sequentially with some declarations.

Its the current functionality being used in Hyperion. Could you please confirm if we can use BI Publisher data model (Procedure Call) to call sequence of procedures.

Example of data model definition :

declare

sp_process_name varchar2(10);

sp_process_status number(1);

begin

flag := 1;

cnt := 0;

out_msg := 'Start';

if sp_process_name = 'AUTO' then

if sp_process_status = 0 then

out_msg := 'Error : Q_update1';

IR_SWIFT_OWNER.UPDATETO1(); --------------------------stored procedure 1

out_msg := 'Error : Q_Create';

IR_SWIFT_OWNER.AUTORECONCILE(); --------------------------stored procedure 2