APPS.RG_REPORT_SUBMISSION_PKG SQL Statements

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

Line: 42

                SELECT REPORT_ID,REPORT_REQUEST_ID
                FROM RG_REPORT_REQUESTS
                WHERE REPORT_SET_ID = set_id
                ORDER BY sequence ASC;

Line: 173

        SELECT  row_set_id,
                column_set_id,
                unit_of_measure_id,
                content_set_id,
                row_order_id,
                rounding_option,
                parameter_set_id,
                minimum_display_level,
                report_display_set_id,
                output_option,
                name,
                segment_override,
                override_alc_ledger_currency
        INTO    report_rec
        FROM    RG_REPORTS
        WHERE   REPORT_ID = rep_id;

Line: 215

           SELECT report_run_type
           INTO   rep_run_type
           FROM   rg_report_content_sets
           WHERE  content_set_id = report_rec.content_set_id;

Line: 260

               UPDATE   FND_CONCURRENT_REQUESTS
               SET
                 OUTPUT_FILE_TYPE = 'XML'
               WHERE
                 REQUEST_ID = conc_req_id;

Line: 307

               UPDATE   FND_CONCURRENT_REQUESTS
               SET
                 OUTPUT_FILE_TYPE = 'XML'
               WHERE
                 REQUEST_ID = conc_req_id;

Line: 355

               UPDATE   FND_CONCURRENT_REQUESTS
               SET
                 OUTPUT_FILE_TYPE = 'XML'
               WHERE
                 REQUEST_ID = conc_req_id;

Line: 381

        UPDATE  RG_REPORT_REQUESTS
        SET
                CONCURRENT_REQUEST_ID   = conc_req_id,
                PERIOD_NAME             = set_period_name,
                ACCOUNTING_DATE         = accounting_date,
                LEDGER_ID               = ledger_id,
                ALC_LEDGER_CURRENCY     = alc_ledger_currency,
                UNIT_OF_MEASURE_ID      = unit_of_m_id,
                ROUNDING_OPTION         = report_rec.rounding_option,
                SEGMENT_OVERRIDE        = report_rec.segment_override,
                OVERRIDE_ALC_LEDGER_CURRENCY
                                    = report_rec.override_alc_ledger_currency,
                CONTENT_SET_ID          = report_rec.content_set_id,
                ROW_ORDER_ID            = report_rec.row_order_id,
                EXCEPTIONS_FLAG         = 'N',
                REPORT_DISPLAY_SET_ID   = report_rec.report_display_set_id,
                OUTPUT_OPTION           = report_rec.output_option
        WHERE   REPORT_REQUEST_ID       = rep_request_id;

Line: 404

          SELECT SEQUENCE
          INTO   report_sequence
          FROM   RG_REPORT_REQUESTS
          WHERE  REPORT_REQUEST_ID = rep_request_id;

Line: 409

          RG_REPORT_SET_REQUESTS_PKG.insert_report_set_req_detail(
                 report_set_request_id,
                 report_sequence,
                 rep_id,
                 conc_req_id);

Line: 484

      SELECT    row_set_id,
                column_set_id,
                unit_of_measure_id,
                content_set_id,
                row_order_id,
                rounding_option,
                parameter_set_id,
                minimum_display_level,
                report_display_set_id,
                output_option,
                name,
                segment_override
      INTO    report_rec
      FROM    RG_REPORTS
      WHERE   REPORT_ID = X_REPORT_ID;

Line: 505

         SELECT report_run_type
         INTO   rep_run_type
         FROM   rg_report_content_sets
         WHERE  content_set_id = X_content_set_id;

Line: 554

            UPDATE      FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 602

            UPDATE      FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 687

        SELECT  row_set_id,
                column_set_id,
                unit_of_measure_id,
                content_set_id,
                row_order_id,
                rounding_option,
                parameter_set_id,
                minimum_display_level,
                report_display_set_id,
                output_option,
                name,
                segment_override
        INTO    report_rec
        FROM    RG_REPORTS
        WHERE   REPORT_ID = X_REPORT_ID;

Line: 708

         SELECT report_run_type
         INTO   rep_run_type
         FROM   rg_report_content_sets
         WHERE  content_set_id = X_content_set_id;

Line: 775

            UPDATE      FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 841

            UPDATE      FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = req_id;

Line: 873

      SELECT    template_code
      INTO    l_template_code
      FROM    XDO_TEMPLATES_VL
      WHERE   description = X_TEMPLATE_CODE;