Forget to mention the database , both target and source is Oracle.
In the odi log you can find error message. Looks like there is syntax error with the query you mentioned.
FROM keyword is missing here:
DELETE FROM TRG.PGMSTAT_STAFF_STG;
As per saranpatangi, yoou forgetten From key work from delete statement and hope you checked the ignore error option on ODI procedure so you got warning message for procedure step and session got green color (indicate it is successfully executed), please un-check the ignore error option on ODi procedure and run the procedure and you will get exact error message on operator