PROCEDURE TOGGLE_MONITOR_JOB(
                    P_REPORT_NAME     OB_MONITOR_RCPTS.REPORT_NAME%TYPE,
                    P_ACTION   NUMBER,
                    p_update_by ob_monitor_rcpts.update_by%type
                  )AS

JOB_ID NUMBER;
p_what varchar2(100);


BEGIN

		select what into p_what from ob_monitor_rcpts where trim(lower(report_name)) = trim(lower(p_report_name));
       SELECT JOB INTO JOB_ID FROM user_jobs WHERE trim(LOWER(WHAT)) = trim(lower(P_WHAT));

       IF(P_ACTION = 1) THEN
       		UPDATE OB_MONITOR_RCPTS SET
                                REPORT_STATUS = 'A',
                                UPDATE_DETAILS = 'Job Started',
                                UPDATE_DATE = SYSDATE,
                                UPDATE_BY = p_update_by
            WHERE lower(trim(REPORT_NAME)) = lower(trim(P_REPORT_NAME));
        DBMS_JOB.BROKEN(JOB_ID,false);
        dbms_output.put_line( 'Job Started');
       ELSIF(P_ACTION = 0) THEN
       	  UPDATE OB_MONITOR_RCPTS SET
                                REPORT_STATUS = 'D',
                                UPDATE_DETAILS = 'Job Suspended',
                                UPDATE_DATE = SYSDATE,
                                UPDATE_BY = p_update_by
        WHERE lower(trim(REPORT_NAME)) = lower(trim(P_REPORT_NAME));
        DBMS_JOB.BROKEN(JOB_ID,true);
               dbms_output.put_line( 'Job Suspended');

        end if;

       commit;

       exception when others then
       dbms_output.put_line('Error : '||sqlerrm);

END;