The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE DELETE_SUMMARY_DETAILS(
i_org_id IN NUMBER,
i_del_period_id IN NUMBER,
err_num OUT NOCOPY NUMBER,
err_code OUT NOCOPY VARCHAR2,
err_msg OUT NOCOPY VARCHAR2)
IS
l_stmt_num NUMBER;
DELETE FROM MTL_PER_CLOSE_DTLS
WHERE
ORGANIZATION_ID = I_ORG_ID AND
ACCT_PERIOD_ID = I_DEL_PERIOD_ID;
DELETE FROM MTL_PERIOD_SUMMARY
WHERE
ORGANIZATION_ID = I_ORG_ID AND
ACCT_PERIOD_ID = I_DEL_PERIOD_ID;
END DELETE_SUMMARY_DETAILS;