APPS.RG_REPORT_AXIS_CONTENTS_PKG SQL Statements

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

Line: 27

      select 1 into dummy
      from rg_report_axis_contents
      where axis_set_id = X_axis_set_id
      and axis_seq = X_axis_seq
      and rownum < 2;

Line: 34

      select 1 into dummy
      from rg_report_axis_contents
      where axis_set_id = X_axis_set_id
      and rownum < 2;

Line: 45

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

Line: 52

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

Line: 56

  END delete_rows;