APPS.GMD_EVENT_SPEC_DISP_PVT SQL Statements

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

Line: 24

FUNCTION insert_row (
  p_event_spec_disp IN  GMD_EVENT_SPEC_DISP%ROWTYPE
, x_event_spec_disp OUT NOCOPY GMD_EVENT_SPEC_DISP%ROWTYPE
)
RETURN BOOLEAN IS
BEGIN

  x_event_spec_disp := p_event_spec_disp;

Line: 33

  INSERT INTO GMD_EVENT_SPEC_DISP
   (
    EVENT_SPEC_DISP_ID
   ,SAMPLING_EVENT_ID
   ,SPEC_ID
   ,SPEC_VR_ID
   ,DISPOSITION
   ,SPEC_USED_FOR_LOT_ATTRIB_IND
   ,DELETE_MARK
   ,CREATION_DATE
   ,CREATED_BY
   ,LAST_UPDATE_DATE
   ,LAST_UPDATED_BY
   ,LAST_UPDATE_LOGIN
   )
   VALUES
   (
    gmd_qc_event_spec_disp_id_s.NEXTVAL
   ,x_event_spec_disp.SAMPLING_EVENT_ID
   ,x_event_spec_disp.SPEC_ID
   ,x_event_spec_disp.SPEC_VR_ID
   ,x_event_spec_disp.DISPOSITION
   ,x_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND
   ,x_event_spec_disp.DELETE_MARK
   ,x_event_spec_disp.CREATION_DATE
   ,x_event_spec_disp.CREATED_BY
   ,x_event_spec_disp.LAST_UPDATE_DATE
   ,x_event_spec_disp.LAST_UPDATED_BY
   ,x_event_spec_disp.LAST_UPDATE_LOGIN
   )
      RETURNING event_spec_disp_id INTO x_event_spec_disp.event_spec_disp_id
   ;

Line: 74

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

Line: 77

END insert_row;

Line: 83

FUNCTION delete_row (p_event_spec_disp_id IN NUMBER)
RETURN BOOLEAN IS

  dummy       PLS_INTEGER;

Line: 93

    SELECT 1
    INTO   dummy
    FROM   gmd_event_spec_disp
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    FOR UPDATE NOWAIT;

Line: 99

    DELETE gmd_event_spec_disp
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    ;

Line: 123

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

Line: 126

END delete_row;

Line: 141

    SELECT 1
    INTO   dummy
    FROM   gmd_event_spec_disp
    WHERE  event_spec_disp_id = p_event_spec_disp_id
    FOR UPDATE NOWAIT;

Line: 162

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

Line: 178

    SELECT *
    INTO   x_event_spec_disp
    FROM   gmd_event_spec_disp
    WHERE  event_spec_disp_id = p_event_spec_disp.event_spec_disp_id
    ;