APEXtras

PROCEDURE ScheduleResendEmail(p_email_id   IN NUMBER, p_recipients IN VARCHAR2) IS
    l_arglist arglist_t;
BEGIN
    l_arglist(1).argument_name := 'p_email_id';
    l_arglist(1).argument_type := 'NUMBER';
    l_arglist(1).default_value := '';
    l_arglist(1).current_value := TO_CHAR(p_email_id);
    l_arglist(2).argument_name := 'p_recipients';
    l_arglist(2).argument_type := 'VARCHAR2';
    l_arglist(2).default_value := '';
    l_arglist(2).current_value := p_recipients;
    ScheduleSPJob(p_program_name       => 'APEXTRAS_SCHEDULER.ResendEmail',
                  p_argument_list      => l_arglist,
                  p_schedule_date_time => NULL, -- Execute immediately
                  p_force_recreate     => FALSE);
  END;

Using the Oracle Scheduler in APEX