APPS.QPR_REPORT_ENTITIES_PVT SQL Statements

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

Line: 17

  PROCEDURE DELETE_REPORT_HEADER(
        p_report_id        IN            NUMBER,
        x_return_status    OUT NOCOPY    VARCHAR2)
  IS
  BEGIN

     DELETE FROM QPR_REPORT_HDRS_B
     WHERE REPORT_HEADER_ID = p_report_id;

Line: 26

     DELETE FROM QPR_REPORT_HDRS_TL
     WHERE REPORT_HEADER_ID = p_report_id;

Line: 34

  END DELETE_REPORT_HEADER;

Line: 50

  PROCEDURE DELETE_REPORT(
                p_report_id    IN     NUMBER,
                x_return_status OUT NOCOPY VARCHAR2)
  IS
      l_report_line_id  NUMBER;

Line: 59

          SELECT REPORT_LINE_ID
          FROM QPR_REPORT_LINES
          WHERE REPORT_HEADER_ID = p_report_id;

Line: 65

     DELETE_RELATED_REPORTS(p_report_id,x_return_status);

Line: 74

       DELETE FROM BISM_OBJECTS
        WHERE OBJECT_NAME LIKE 'qpr'||l_report_line_id||'q%';

Line: 79

     DELETE FROM QPR_REPORT_LINES
     WHERE REPORT_HEADER_ID = p_report_id;

Line: 82

     DELETE FROM QPR_REPORT_RELNS
     WHERE PARENT_REPORT_ID = p_report_id;

Line: 85

     DELETE FROM QPR_REPORT_HDRS_TL
     WHERE REPORT_HEADER_ID = p_report_id;

Line: 88

    DELETE FROM QPR_REPORT_HDRS_B
    WHERE REPORT_HEADER_ID = p_report_id;

Line: 97

   END DELETE_REPORT;

Line: 111

   PROCEDURE DELETE_RELATED_REPORTS(
              p_parent_report_id       IN NUMBER,
              x_return_status   OUT NOCOPY VARCHAR2)

   IS

        l_related_report_id        NUMBER;

Line: 122

          SELECT REPORT_LINE_ID
          FROM QPR_REPORT_LINES
          WHERE REPORT_HEADER_ID = p_parent_report_id;

Line: 128

          SELECT TARGET_REPORT_ID
          FROM QPR_REPORT_RELNS
          WHERE PARENT_REPORT_ID = p_parent_report_id;

Line: 148

              DELETE FROM BISM_OBJECTS
                 WHERE OBJECT_NAME LIKE 'qpr'||l_report_line_id||'q%';

Line: 155

         DELETE FROM QPR_REPORT_HDRS_B WHERE REPORT_HEADER_ID IN
             (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

Line: 158

         DELETE FROM QPR_REPORT_HDRS_TL WHERE REPORT_HEADER_ID IN
             (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

Line: 161

         DELETE FROM QPR_REPORT_LINES WHERE REPORT_HEADER_ID IN
             (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

Line: 171

     END DELETE_RELATED_REPORTS;

Line: 186

  PROCEDURE DELETE_REPORTS(
        p_price_plan_id        IN            NUMBER,
        x_return_status    OUT NOCOPY    VARCHAR2)
  IS

     l_report_line_id       NUMBER;

Line: 195

        SELECT QRL.REPORT_LINE_ID
        FROM QPR_REPORT_HDRS_B QRH,
	     QPR_REPORT_LINES QRL
        WHERE QRH.REPORT_HEADER_ID = QRL.REPORT_HEADER_ID
	AND QRH.PLAN_ID = c_price_plan_id;

Line: 211

	DELETE FROM BISM_OBJECTS
	WHERE OBJECT_NAME LIKE 'qpr'||l_report_line_id||'q%';

Line: 217

     DELETE FROM QPR_REPORT_LINES
     WHERE REPORT_HEADER_ID IN (
		SELECT REPORT_HEADER_ID
		FROM QPR_REPORT_HDRS_B
		WHERE PLAN_ID = p_price_plan_id
				);

Line: 224

     DELETE FROM QPR_REPORT_RELNS
     WHERE PARENT_REPORT_ID IN (
		SELECT REPORT_HEADER_ID
		FROM QPR_REPORT_HDRS_B
		WHERE PLAN_ID = p_price_plan_id
				);

Line: 231

     DELETE FROM QPR_REPORT_HDRS_TL
     WHERE REPORT_HEADER_ID IN (
		SELECT REPORT_HEADER_ID
		FROM QPR_REPORT_HDRS_B
		WHERE PLAN_ID = p_price_plan_id
				);

Line: 237

     DELETE FROM QPR_REPORT_HDRS_B
     WHERE PLAN_ID = p_price_plan_id;

Line: 245

  END DELETE_REPORTS;