Hi,
I am new to IFS and I need to automate a process in IFS:
What PL/SQL procedure to call if I want to copy and paste a raw when a status is changed for Safety_Inspection ?
I have made a call that works when called directly in DB
DECLARE
info_ VARCHAR2(2000);
objkey_ VARCHAR2(2000);
objversion_ VARCHAR2(2000);
attr_ VARCHAR2(2000);
calculated_plan_date_ DATE;
BEGIN
calculated_plan_date_ := ADD_MONTHS(SYSDATE,3);
Client_SYS.Add_To_Attr('SAFETY_INSPECTION_NO','33' , attr_);
Client_SYS.Add_To_Attr('PLAN_DATE', calculated_plan_date_ , attr_);
Client_SYS.Add_To_Attr('SAFETY_INSPECTION_TEMP_NO', '3', attr_);
Client_SYS.Add_To_Attr('SAFETY_INSPECTION_TYPE_NO', '24', attr_);
Client_SYS.Add_To_Attr('COMPANY_ID', '01', attr_);
Client_SYS.Add_To_Attr('LOCATION_ID', 'GRE', attr_);
Safety_Inspection_API.New__(info_,objkey_, objversion_, attr_,'DO');
--Transaction_SYS.Deferred_Call('Safety_Inspection_API.New__', attr_,'AUTOMATIC COPY SAFETY INSPECTION', sysdate, 'FALSE');
END;
How do I make it work in IFS event action?
Right now my challange is that i put some dummy values in this query is it possible to reuse as many values of the row as possible when creating a new raw. So what i really need is a COPY and PASTE function/API call
Any hints ?
