APPS.GMD_SPEC_RESULTS_PVT SQL Statements

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

Line: 24

FUNCTION insert_row (p_spec_results IN  GMD_SPEC_RESULTS%ROWTYPE)
RETURN BOOLEAN IS
BEGIN

  INSERT INTO GMD_SPEC_RESULTS
   (
    EVENT_SPEC_DISP_ID
   ,RESULT_ID
   ,IN_SPEC_IND
   ,EVALUATION_IND
   ,ACTION_CODE
   ,UPDATE_INSTANCE_ID
   ,VALUE_IN_REPORT_PRECISION
   ,ADDITIONAL_TEST_IND
   ,WF_RESPONSE
   ,DELETE_MARK
   ,CREATION_DATE
   ,CREATED_BY
   ,LAST_UPDATE_DATE
   ,LAST_UPDATED_BY
   ,LAST_UPDATE_LOGIN
   )
   VALUES
   (
    p_spec_results.EVENT_SPEC_DISP_ID
   ,p_spec_results.RESULT_ID
   ,p_spec_results.IN_SPEC_IND
   ,p_spec_results.EVALUATION_IND
   ,p_spec_results.ACTION_CODE
   ,p_spec_results.UPDATE_INSTANCE_ID
   ,p_spec_results.VALUE_IN_REPORT_PRECISION
   ,p_spec_results.ADDITIONAL_TEST_IND
   ,p_spec_results.WF_RESPONSE
   ,p_spec_results.DELETE_MARK
   ,p_spec_results.CREATION_DATE
   ,p_spec_results.CREATED_BY
   ,p_spec_results.LAST_UPDATE_DATE
   ,p_spec_results.LAST_UPDATED_BY
   ,p_spec_results.LAST_UPDATE_LOGIN
   )
   ;

Line: 74

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

Line: 77

END insert_row;

Line: 83

FUNCTION delete_row
(
  p_event_spec_disp_id IN NUMBER
, p_result_id          IN NUMBER
)
RETURN BOOLEAN IS

  dummy       PLS_INTEGER;

Line: 98

    SELECT 1
    INTO   dummy
    FROM   gmd_spec_results
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    AND    result_id          = p_result_id
    FOR UPDATE NOWAIT;

Line: 105

    UPDATE gmd_spec_results
    SET    delete_mark = 1
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    AND    result_id          = p_result_id
    ;

Line: 131

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

Line: 134

END delete_row;

Line: 154

    SELECT 1
    INTO   dummy
    FROM   gmd_spec_results
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    AND    result_id          = p_result_id
    FOR UPDATE NOWAIT;

Line: 176

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

Line: 193

    SELECT *
    INTO   x_spec_results
    FROM   gmd_spec_results
    WHERE  event_spec_disp_id = p_spec_results.event_spec_disp_id
    AND    result_id          = p_spec_results.result_id
    ;