APPS.RG_REPORT_EXCEPTION_FLAGS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    select RG_REPORT_EXCEPTION_FLAGS_s.nextval
    into   next_group_id
    from   dual;

Line: 31

  PROCEDURE delete_rows(X_axis_set_id NUMBER,
                        X_axis_seq NUMBER) IS
  BEGIN
    IF (X_axis_seq = -1) THEN
      delete from rg_report_exceptions
      where axis_set_id = X_axis_set_id;

Line: 38

      delete from rg_report_exception_flags
       where axis_set_id = X_axis_set_id;

Line: 41

      delete from rg_report_exceptions
       where axis_set_id = X_axis_set_id
        and axis_seq = X_axis_seq;

Line: 45

      delete from rg_report_exception_flags
       where axis_set_id = X_axis_set_id
         and axis_seq = X_axis_seq;

Line: 50

  END delete_rows;