APPS.GMD_COMPOSITE_RESULTS_PVT SQL Statements

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

Line: 23

FUNCTION insert_row (
  p_composite_results IN  GMD_COMPOSITE_RESULTS%ROWTYPE
, x_composite_results OUT NOCOPY GMD_COMPOSITE_RESULTS%ROWTYPE
)
  RETURN BOOLEAN IS
BEGIN

    x_composite_results := p_composite_results;

Line: 32

    INSERT INTO GMD_COMPOSITE_RESULTS
     (
      COMPOSITE_RESULT_ID
     ,TEST_ID
     ,MEAN
     ,MODE_NUM
     ,MODE_CHAR
     ,LOW_NUM
     ,HIGH_NUM
     ,RANGE
     ,STANDARD_DEVIATION
     ,SAMPLE_TOTAL
     ,SAMPLE_CNT_USED
     ,NON_VALIDATED_RESULT
     ,DELETE_MARK
     ,TEXT_CODE
     ,ATTRIBUTE_CATEGORY
     ,ATTRIBUTE1
     ,ATTRIBUTE2
     ,ATTRIBUTE3
     ,ATTRIBUTE4
     ,ATTRIBUTE5
     ,ATTRIBUTE6
     ,ATTRIBUTE7
     ,ATTRIBUTE8
     ,ATTRIBUTE9
     ,ATTRIBUTE10
     ,ATTRIBUTE11
     ,ATTRIBUTE12
     ,ATTRIBUTE13
     ,ATTRIBUTE14
     ,ATTRIBUTE15
     ,ATTRIBUTE16
     ,ATTRIBUTE17
     ,ATTRIBUTE18
     ,ATTRIBUTE19
     ,ATTRIBUTE20
     ,ATTRIBUTE21
     ,ATTRIBUTE22
     ,ATTRIBUTE23
     ,ATTRIBUTE24
     ,ATTRIBUTE25
     ,ATTRIBUTE26
     ,ATTRIBUTE27
     ,ATTRIBUTE28
     ,ATTRIBUTE29
     ,ATTRIBUTE30
     ,CREATION_DATE
     ,CREATED_BY
     ,LAST_UPDATE_DATE
     ,LAST_UPDATED_BY
     ,LAST_UPDATE_LOGIN
     ,MEDIAN_NUM
     ,MEDIAN_CHAR
     ,LOW_CHAR
     ,HIGH_CHAR
     ,COMPOSITE_SPEC_DISP_ID
     ,IN_SPEC_IND
     ,VALUE_IN_REPORT_PRECISION
     ,WF_RESPONSE
     )
     VALUES
     (
      gmd_qc_comp_result_id_s.NEXTVAL
     ,x_composite_results.TEST_ID
     ,x_composite_results.MEAN
     ,x_composite_results.MODE_NUM
     ,x_composite_results.MODE_CHAR
     ,x_composite_results.LOW_NUM
     ,x_composite_results.HIGH_NUM
     ,x_composite_results.RANGE
     ,x_composite_results.STANDARD_DEVIATION
     ,x_composite_results.SAMPLE_TOTAL
     ,x_composite_results.SAMPLE_CNT_USED
     ,x_composite_results.NON_VALIDATED_RESULT
     ,x_composite_results.DELETE_MARK
     ,x_composite_results.TEXT_CODE
     ,x_composite_results.ATTRIBUTE_CATEGORY
     ,x_composite_results.ATTRIBUTE1
     ,x_composite_results.ATTRIBUTE2
     ,x_composite_results.ATTRIBUTE3
     ,x_composite_results.ATTRIBUTE4
     ,x_composite_results.ATTRIBUTE5
     ,x_composite_results.ATTRIBUTE6
     ,x_composite_results.ATTRIBUTE7
     ,x_composite_results.ATTRIBUTE8
     ,x_composite_results.ATTRIBUTE9
     ,x_composite_results.ATTRIBUTE10
     ,x_composite_results.ATTRIBUTE11
     ,x_composite_results.ATTRIBUTE12
     ,x_composite_results.ATTRIBUTE13
     ,x_composite_results.ATTRIBUTE14
     ,x_composite_results.ATTRIBUTE15
     ,x_composite_results.ATTRIBUTE16
     ,x_composite_results.ATTRIBUTE17
     ,x_composite_results.ATTRIBUTE18
     ,x_composite_results.ATTRIBUTE19
     ,x_composite_results.ATTRIBUTE20
     ,x_composite_results.ATTRIBUTE21
     ,x_composite_results.ATTRIBUTE22
     ,x_composite_results.ATTRIBUTE23
     ,x_composite_results.ATTRIBUTE24
     ,x_composite_results.ATTRIBUTE25
     ,x_composite_results.ATTRIBUTE26
     ,x_composite_results.ATTRIBUTE27
     ,x_composite_results.ATTRIBUTE28
     ,x_composite_results.ATTRIBUTE29
     ,x_composite_results.ATTRIBUTE30
     ,x_composite_results.CREATION_DATE
     ,x_composite_results.CREATED_BY
     ,x_composite_results.LAST_UPDATE_DATE
     ,x_composite_results.LAST_UPDATED_BY
     ,x_composite_results.LAST_UPDATE_LOGIN
     ,x_composite_results.MEDIAN_NUM
     ,x_composite_results.MEDIAN_CHAR
     ,x_composite_results.LOW_CHAR
     ,x_composite_results.HIGH_CHAR
     ,x_composite_results.COMPOSITE_SPEC_DISP_ID
     ,x_composite_results.IN_SPEC_IND
     ,x_composite_results.VALUE_IN_REPORT_PRECISION
     ,x_composite_results.WF_RESPONSE
     )
      RETURNING composite_result_id INTO x_composite_results.composite_result_id
   ;

Line: 165

      fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULTS_PVT', 'INSERT_ROW');

Line: 168

END insert_row;

Line: 172

FUNCTION delete_row (p_composite_result_id   IN  NUMBER,
                     p_last_update_date 	IN  DATE,
                     p_last_updated_by 	        IN  NUMBER,
                     p_last_update_login 	IN  NUMBER)
RETURN BOOLEAN IS

  dummy       PLS_INTEGER;

Line: 187

    SELECT 1
    INTO   dummy
    FROM   gmd_composite_results
    WHERE  composite_result_id = p_composite_result_id
    FOR UPDATE NOWAIT;

Line: 193

    UPDATE gmd_composite_results
    SET    delete_mark = 1,
           last_update_date  = NVL(p_last_update_date,SYSDATE),
           last_updated_by   = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
           last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
    WHERE  composite_result_id = p_composite_result_id
    ;

Line: 221

     fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULTS_PVT', 'DELETE_ROW');

Line: 224

END delete_row;

Line: 238

    SELECT 1
    INTO   dummy
    FROM   gmd_composite_results
    WHERE  composite_result_id = p_composite_result_id
    FOR UPDATE NOWAIT;

Line: 259

     fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULTS_PVT', 'DELETE_ROW');

Line: 275

    SELECT *
    INTO   x_composite_results
    FROM   gmd_composite_results
    WHERE  composite_result_id = p_composite_results.composite_result_id
    ;