Calling custom event from a command in Aurena

Hi @harshamc00,

You cannot directly execute a custom event from a command in Aurena or in IEE.

A custom event is triggered when there is an INSERT/UPDATE/DELETE operation on the relevant table.

I would recommend you to write a custom action in the projection with a similar logic as the custom event action logic and then use the Execute Action option.

Cheers !
Dhananjaya.

Thank you for the answer @dhlelk  

I need to create a function to generate project from a business opportunity and in IEE I could do this using a custom menu with following code

declare
  info_ varchar2(32000);
  objid_ varchar2(32000);
  objversion_ varchar2(32000);
  attr_ varchar2(32000);
  attr_cf_ varchar2(32000);
  project_id_ varchar2(100);
  
  
begin
  
        Client_SYS.Clear_Attr(attr_);
        --Client_SYS.Add_To_Attr('PROJECT_ID', '', attr_);
        Client_SYS.Add_To_Attr('NAME','PR-' || &OPPORTUNITY_NO, attr_);
        Client_SYS.Add_To_Attr('MANAGER', '*', attr_);
        Client_SYS.Add_To_Attr('COMPANY', &COMPANY, attr_);
        Client_SYS.Add_To_Attr('CALENDAR_ID', '*', attr_);
        Client_SYS.Add_To_Attr('ACCESS_ON_OFF', '0', attr_);
        Client_SYS.Add_To_Attr('BASELINE_REVISION_NUMBER', '0', attr_);
        Client_SYS.Add_To_Attr('EARNED_VALUE_METHOD_DB', 'PLANNED', attr_);
         

  -- Call the procedure
  Project_API.New(info_,
                  objid_,
                  objversion_,
                  attr_,
                  'DO');
  

                  
  Client_SYS.Clear_Attr(attr_cf_); 
  Client_SYS.Add_To_Attr('CF$_SOURCE_BO', &OPPORTUNITY_NO, attr_cf_); 
  Client_SYS.Add_To_Attr('CF$_TITLE', &CF$_TITLE, attr_cf_);   
  
    Project_CFP.Cf_New__(info_,
                  objid_,
                  attr_cf_,
                  attr_,
                  'DO');
               
                  
end;

------------------------------------------------------------------------------------------------------------------------------------

But when it comes to Aurena I could only use standard methods in the database and I’m stuck on how to pass the attribute string to these methods since in Aurena actions (ExecuteActions) there is no place to define attribute string based on what I see.

Can this be done in Aurena currently? If So, how could I do this?

Hi @harshamc00,

Please refer the below post, could be what you are looking for.

- Nalaka - 

Thank you @Nalaka Samarasinghe 

This was helpful. Do you know if there any functionality in Aurena where we can define custom PLSQL methods (connected to commands in Aurena)? Similar to what we can do in IEE Custom Menus

Hi @harshamc00 ,

I think these wil be useful

Is there a possibility to create custom commands (buttons) in Aurena that run a method, passing parameters from a page ? | IFS Community

Aurena - Custom Commands based on a Custom package - Parameters refresh | IFS Community

@Chamaka Wimalarathne 

It seems like partner accounts do not have access to the links

Hi @harshamc00,

This is the information that @Chamaka Wimalarathne was referring to:

To create custom commands (buttons) in Aurena that run a method, passing parameters from the page:

1. Go to Projection Configuration and define the Custom Action, referencing a PLSQL package and method. 
2. Define an instance of the custom command using the Page Designer.

• If the method exists within a custom/utility package (can be found within the Projection Configuration area) and you are able to find the custom package/method. 
• However you may not find the parameters even after a dictionary cache refresh.
• You will need to run the script mentioned in Scripts/Logs section after deploying the custom package, to get IFS to recognize the parameters in the method.

Script:

DEFINE GRANTEE = IFSSYS
PROMPT Granting to &GRANTEE 
BEGIN

   Installation_SYS.Grant_Ifssys(TRUE);
END;
/

PROMPT Refreshing Dictionary_SYS
EXEC Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'COMPUTE');

PROMPT Refreshing Reference_SYS
EXEC Reference_SYS.Refresh_Active_List__(2);

PROMPT Reinitialize packages

-- This command disables Installation_Mode in Dictionary_SYS
EXEC Dbms_Session.Modify_Package_State(Dbms_Session.Reinitialize);
/
PROMPT Refreshing Security_SYS
EXEC Security_SYS.Refresh_Active_List__(3);
/

- Nalaka -