The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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
;
fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'INSERT_ROW');
END insert_row;
FUNCTION delete_row (p_event_spec_disp_id IN NUMBER)
RETURN BOOLEAN IS
dummy PLS_INTEGER;
SELECT 1
INTO dummy
FROM gmd_event_spec_disp
WHERE event_spec_disp_id = p_event_spec_disp_id
FOR UPDATE NOWAIT;
DELETE gmd_event_spec_disp
WHERE event_spec_disp_id = p_event_spec_disp_id
;
fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'DELETE_ROW');
END delete_row;
SELECT 1
INTO dummy
FROM gmd_event_spec_disp
WHERE event_spec_disp_id = p_event_spec_disp_id
FOR UPDATE NOWAIT;
fnd_msg_pub.add_exc_msg ('GMD_EVENT_SPEC_DISP_PVT', 'DELETE_ROW');
SELECT *
INTO x_event_spec_disp
FROM gmd_event_spec_disp
WHERE event_spec_disp_id = p_event_spec_disp.event_spec_disp_id
;