The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION insert_row (
p_composite_spec_disp IN GMD_COMPOSITE_SPEC_DISP%ROWTYPE
, x_composite_spec_disp OUT NOCOPY GMD_COMPOSITE_SPEC_DISP%ROWTYPE
)
RETURN BOOLEAN IS
BEGIN
x_composite_spec_disp := p_composite_spec_disp;
INSERT INTO GMD_COMPOSITE_SPEC_DISP
(
COMPOSITE_SPEC_DISP_ID
,EVENT_SPEC_DISP_ID
,DISPOSITION
,LATEST_IND
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,DELETE_MARK
)
VALUES
(
gmd_qc_comp_spec_disp_id_s.NEXTVAL
,x_composite_spec_disp.EVENT_SPEC_DISP_ID
,x_composite_spec_disp.DISPOSITION
,x_composite_spec_disp.LATEST_IND
,x_composite_spec_disp.CREATION_DATE
,x_composite_spec_disp.CREATED_BY
,x_composite_spec_disp.LAST_UPDATE_DATE
,x_composite_spec_disp.LAST_UPDATED_BY
,x_composite_spec_disp.LAST_UPDATE_LOGIN
,x_composite_spec_disp.DELETE_MARK
)
RETURNING composite_spec_disp_id INTO x_composite_spec_disp.composite_spec_disp_id
;
fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_SPEC_DISP_PVT', 'INSERT_ROW');
END insert_row;
FUNCTION delete_row (p_composite_spec_disp_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;
SELECT 1
INTO dummy
FROM gmd_composite_spec_disp
WHERE composite_spec_disp_id = p_composite_spec_disp_id
FOR UPDATE NOWAIT;
UPDATE gmd_composite_spec_disp
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_spec_disp_id = p_composite_spec_disp_id
;
fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_SPEC_DISP_PVT', 'DELETE_ROW');
END delete_row;
SELECT 1
INTO dummy
FROM gmd_composite_spec_disp
WHERE composite_spec_disp_id = p_composite_spec_disp_id
FOR UPDATE NOWAIT;
fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_SPEC_DISP_PVT', 'DELETE_ROW');
SELECT *
INTO x_composite_spec_disp
FROM gmd_composite_spec_disp
WHERE composite_spec_disp_id = p_composite_spec_disp.composite_spec_disp_id
;