APPS.GMD_SAMPLE_SPEC_DISP_PVT SQL Statements

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

Line: 24

FUNCTION insert_row (p_sample_spec_disp IN  GMD_SAMPLE_SPEC_DISP%ROWTYPE)
RETURN BOOLEAN IS
BEGIN

    INSERT INTO GMD_SAMPLE_SPEC_DISP
     (
      EVENT_SPEC_DISP_ID
     ,SAMPLE_ID
     ,DISPOSITION
     ,DELETE_MARK
     ,CREATION_DATE
     ,CREATED_BY
     ,LAST_UPDATE_DATE
     ,LAST_UPDATED_BY
     ,LAST_UPDATE_LOGIN
     )
     VALUES
     (
      p_sample_spec_disp.EVENT_SPEC_DISP_ID
     ,p_sample_spec_disp.SAMPLE_ID
     ,p_sample_spec_disp.DISPOSITION
     ,p_sample_spec_disp.DELETE_MARK
     ,p_sample_spec_disp.CREATION_DATE
     ,p_sample_spec_disp.CREATED_BY
     ,p_sample_spec_disp.LAST_UPDATE_DATE
     ,p_sample_spec_disp.LAST_UPDATED_BY
     ,p_sample_spec_disp.LAST_UPDATE_LOGIN
     )
     ;

Line: 62

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

Line: 65

END insert_row;

Line: 71

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

  dummy       PLS_INTEGER;

Line: 86

    SELECT 1
    INTO   dummy
    FROM   gmd_sample_spec_disp
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    AND    sample_id          = p_sample_id
    FOR UPDATE NOWAIT;

Line: 93

    UPDATE gmd_sample_spec_disp
    SET    delete_mark = 1
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    AND    sample_id          = p_sample_id
    ;

Line: 119

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

Line: 122

END delete_row;

Line: 142

    SELECT 1
    INTO   dummy
    FROM   gmd_sample_spec_disp
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    AND    sample_id          = p_sample_id
    FOR UPDATE NOWAIT;

Line: 164

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

Line: 181

    SELECT *
    INTO   x_sample_spec_disp
    FROM   gmd_sample_spec_disp
    WHERE  event_spec_disp_id = p_sample_spec_disp.event_spec_disp_id
    AND    sample_id          = p_sample_spec_disp.sample_id
    ;